public ServiceVoCollection listService(Integer[] nServiceIds)
{
DomainFactory factory = getDomainFactory();
StringBuffer hqlStart = new StringBuffer();
String hql;
hqlStart.append("from Service s where s.id in ( ");
for (int i = 0; i < nServiceIds.length; i++)
hqlStart.append(nServiceIds[i] + ",");
if (hqlStart.toString().endsWith(","))
hql = hqlStart.toString().substring(0, hqlStart.length() - 1);
else
hql = hqlStart.toString();
hql += " )";
return ServiceVoAssembler.createServiceVoCollectionFromService(factory.find(hql));
}
java类ims.core.vo.domain.ServiceVoAssembler的实例源码
ServiceImpl.java 文件源码
项目:AvoinApotti
阅读 28
收藏 0
点赞 0
评论 0
ReferralDetailsComponentImpl.java 文件源码
项目:AvoinApotti
阅读 21
收藏 0
点赞 0
评论 0
private EpisodeofCareShortVo updateEpisodeOfCareSpecialty(CatsReferralWizardVo catsReferralVo, ReferralLetterDetailsVo referralDetailsVo, DomainFactory factory) throws StaleObjectException
{
CareContextVo voCC = CareContextVoAssembler.create((CareContext) getDomainFactory().getDomainObject(CareContext.class, catsReferralVo.getCareContext().getID_CareContext()));
ServiceVo voServ = ServiceVoAssembler.create((ims.core.clinical.domain.objects.Service) getDomainFactory().getDomainObject(ims.core.clinical.domain.objects.Service.class, referralDetailsVo.getService().getID_Service()));
EpisodeOfCare doEOC = (EpisodeOfCare) factory.getDomainObject(EpisodeOfCare.class, voCC.getEpisodeOfCare().getID_EpisodeOfCare());
if (doEOC != null)
{
//WDEV-11535 - if referral service.specialty is null set it back to DAD
Specialty spec = null;
if(voServ.getSpecialty() == null)
spec = Specialty.DAD;
else
spec = voServ.getSpecialty();
doEOC.setSpecialty(getDomLookup(spec));
factory.save(doEOC);
return EpisodeofCareShortVoAssembler.create(doEOC);
}
return null;
}
PresentationComponentImpl.java 文件源码
项目:AvoinApotti
阅读 76
收藏 0
点赞 0
评论 0
@SuppressWarnings("unchecked")
public ServiceVo getService(Integer id)
{
DomainFactory factory = getDomainFactory();
StringBuffer hql = new StringBuffer("select service from CatsReferral as catsRef join catsRef.referralDetails" +
" as referal join referal.service as service where catsRef.id = "+id);
List domService = factory.find(hql.toString());
ServiceVoCollection serviceColl = ServiceVoAssembler.createServiceVoCollectionFromService(domService);
if(serviceColl.size() > 0)
return serviceColl.get(0);
else
return null;
}
ServiceConfigurationImpl.java 文件源码
项目:openMAXIMS
阅读 25
收藏 0
点赞 0
评论 0
public ServiceVo getService(ServiceRefVo service)
{
if(service == null || service.getID_Service() == null)
return null;
DomainFactory factory = getDomainFactory();
ServiceVo serviceVo = ServiceVoAssembler.create((Service) factory.getDomainObject(Service.class, service.getID_Service()));
String hql = "select count(s.id) from ReferralService as rs left join rs.referralServices as s where s.id = :ServiceId";
Object[] count = factory.find(hql, new String[] {"ServiceId"}, new Object[] {serviceVo.getID_Service()}).toArray();
if(count != null && count.length > 0 && ((Long) count[0]).intValue() > 0)
serviceVo.setCanReferIntoTheService(true);
else
serviceVo.setCanReferIntoTheService(false);
return serviceVo;
}
ServiceImpl.java 文件源码
项目:openMAXIMS
阅读 25
收藏 0
点赞 0
评论 0
public ServiceVoCollection listService(Integer[] nServiceIds)
{
DomainFactory factory = getDomainFactory();
StringBuffer hqlStart = new StringBuffer();
String hql;
hqlStart.append("from Service s where s.id in ( ");
for (int i = 0; i < nServiceIds.length; i++)
hqlStart.append(nServiceIds[i] + ",");
if (hqlStart.toString().endsWith(","))
hql = hqlStart.toString().substring(0, hqlStart.length() - 1);
else
hql = hqlStart.toString();
hql += " )";
return ServiceVoAssembler.createServiceVoCollectionFromService(factory.find(hql));
}
ReferralDetailsComponentImpl.java 文件源码
项目:openMAXIMS
阅读 32
收藏 0
点赞 0
评论 0
private EpisodeofCareShortVo updateEpisodeOfCareSpecialty(CatsReferralWizardVo catsReferralVo, ReferralLetterDetailsVo referralDetailsVo, DomainFactory factory) throws StaleObjectException
{
CareContextVo voCC = CareContextVoAssembler.create((CareContext) getDomainFactory().getDomainObject(CareContext.class, catsReferralVo.getCareContext().getID_CareContext()));
ServiceVo voServ = ServiceVoAssembler.create((ims.core.clinical.domain.objects.Service) getDomainFactory().getDomainObject(ims.core.clinical.domain.objects.Service.class, referralDetailsVo.getService().getID_Service()));
EpisodeOfCare doEOC = (EpisodeOfCare) factory.getDomainObject(EpisodeOfCare.class, voCC.getEpisodeOfCare().getID_EpisodeOfCare());
if (doEOC != null)
{
//WDEV-11535 - if referral service.specialty is null set it back to DAD
Specialty spec = null;
if(voServ.getSpecialty() == null)
spec = Specialty.DAD;
else
spec = voServ.getSpecialty();
doEOC.setSpecialty(getDomLookup(spec));
factory.save(doEOC);
return EpisodeofCareShortVoAssembler.create(doEOC);
}
return null;
}
PresentationComponentImpl.java 文件源码
项目:openMAXIMS
阅读 26
收藏 0
点赞 0
评论 0
@SuppressWarnings("unchecked")
public ServiceVo getService(Integer id)
{
DomainFactory factory = getDomainFactory();
StringBuffer hql = new StringBuffer("select service from CatsReferral as catsRef join catsRef.referralDetails" +
" as referal join referal.service as service where catsRef.id = "+id);
List domService = factory.find(hql.toString());
ServiceVoCollection serviceColl = ServiceVoAssembler.createServiceVoCollectionFromService(domService);
if(serviceColl.size() > 0)
return serviceColl.get(0);
else
return null;
}
ServiceImpl.java 文件源码
项目:openMAXIMS
阅读 30
收藏 0
点赞 0
评论 0
public ServiceVoCollection listService(Integer[] nServiceIds)
{
DomainFactory factory = getDomainFactory();
StringBuffer hqlStart = new StringBuffer();
String hql;
hqlStart.append("from Service s where s.id in ( ");
for (int i = 0; i < nServiceIds.length; i++)
hqlStart.append(nServiceIds[i] + ",");
if (hqlStart.toString().endsWith(","))
hql = hqlStart.toString().substring(0, hqlStart.length() - 1);
else
hql = hqlStart.toString();
hql += " )";
return ServiceVoAssembler.createServiceVoCollectionFromService(factory.find(hql));
}
ReferralDetailsComponentImpl.java 文件源码
项目:openMAXIMS
阅读 23
收藏 0
点赞 0
评论 0
private EpisodeofCareShortVo updateEpisodeOfCareSpecialty(CatsReferralWizardVo catsReferralVo, ReferralLetterDetailsVo referralDetailsVo, DomainFactory factory) throws StaleObjectException
{
CareContextVo voCC = CareContextVoAssembler.create((CareContext) getDomainFactory().getDomainObject(CareContext.class, catsReferralVo.getCareContext().getID_CareContext()));
ServiceVo voServ = ServiceVoAssembler.create((ims.core.clinical.domain.objects.Service) getDomainFactory().getDomainObject(ims.core.clinical.domain.objects.Service.class, referralDetailsVo.getService().getID_Service()));
EpisodeOfCare doEOC = (EpisodeOfCare) factory.getDomainObject(EpisodeOfCare.class, voCC.getEpisodeOfCare().getID_EpisodeOfCare());
if (doEOC != null)
{
//WDEV-11535 - if referral service.specialty is null set it back to DAD
Specialty spec = null;
if(voServ.getSpecialty() == null)
spec = Specialty.DAD;
else
spec = voServ.getSpecialty();
doEOC.setSpecialty(getDomLookup(spec));
factory.save(doEOC);
return EpisodeofCareShortVoAssembler.create(doEOC);
}
return null;
}
PresentationComponentImpl.java 文件源码
项目:openMAXIMS
阅读 27
收藏 0
点赞 0
评论 0
@SuppressWarnings("unchecked")
public ServiceVo getService(Integer id)
{
DomainFactory factory = getDomainFactory();
StringBuffer hql = new StringBuffer("select service from CatsReferral as catsRef join catsRef.referralDetails" +
" as referal join referal.service as service where catsRef.id = "+id);
List domService = factory.find(hql.toString());
ServiceVoCollection serviceColl = ServiceVoAssembler.createServiceVoCollectionFromService(domService);
if(serviceColl.size() > 0)
return serviceColl.get(0);
else
return null;
}
LocationServiceImpl.java 文件源码
项目:openmaxims-linux
阅读 26
收藏 0
点赞 0
评论 0
public ServiceVoCollection listService(Boolean activeOnly)
{
DomainFactory factory = getDomainFactory();
if (activeOnly.booleanValue())
return ServiceVoAssembler.createServiceVoCollectionFromService(factory.find("from Service service where service.isActive = :active", new String[]{"active"}, new Object[]{activeOnly}));
return ServiceVoAssembler.createServiceVoCollectionFromService(factory.listDomainObjects(Service.class)).sort();
}
ServiceImpl.java 文件源码
项目:openmaxims-linux
阅读 32
收藏 0
点赞 0
评论 0
public ServiceVoCollection listService(Integer[] nServiceIds)
{
DomainFactory factory = getDomainFactory();
StringBuffer hqlStart = new StringBuffer();
String hql;
hqlStart.append("from Service s where s.id in ( ");
for (int i = 0; i < nServiceIds.length; i++)
hqlStart.append(nServiceIds[i] + ",");
if (hqlStart.toString().endsWith(","))
hql = hqlStart.toString().substring(0, hqlStart.length() - 1);
else
hql = hqlStart.toString();
hql += " )";
return ServiceVoAssembler.createServiceVoCollectionFromService(factory.find(hql));
}
SupportNetworkProfessionalServicesImpl.java 文件源码
项目:AvoinApotti
阅读 27
收藏 0
点赞 0
评论 0
public ServiceVoCollection listService(ServiceCategory serviceType)
{
// will be called from servicefunction when implemented in Spinal
DomainFactory factory = getDomainFactory();
if (serviceType == null)
return ServiceVoAssembler.createServiceVoCollectionFromService(factory.listDomainObjects(Service.class));
String hql = "from Service s where s.serviceCategory = :serviceType and s.isActive = :active";
java.util.List services = factory.find(hql, new String[]{"serviceType", "active"}, new Object[]{getDomLookup(serviceType), Boolean.TRUE});
return ServiceVoAssembler.createServiceVoCollectionFromService(services);
}
SupportNetworkProfessionalServicesImpl.java 文件源码
项目:AvoinApotti
阅读 31
收藏 0
点赞 0
评论 0
public ServiceVoCollection listService(ServiceCategoryCollection excludedServices)
{
DomainFactory factory = getDomainFactory();
StringBuffer hql = new StringBuffer("from Service s where s.isActive = :active");
ArrayList paramNames = new ArrayList();
ArrayList paramValues = new ArrayList();
paramNames.add("active");
paramValues.add(Boolean.TRUE);
if (excludedServices != null)
{
int servicesSize = excludedServices.size();
for (int i = 0; i < servicesSize; i++)
{
if (i == 0)
hql.append(" and (");
ServiceCategory serviceCategory = excludedServices.get(i);
String serviceType = "serviceType" + Integer.toString(i);
paramNames.add(serviceType);
paramValues.add(new Integer(serviceCategory.getID()));
hql.append("s.serviceCategory.id <> :" + serviceType);
if (i == (servicesSize - 1))
hql.append(")");
else
hql.append(" and ");
}
}
hql.append(" order by UPPER(s.serviceName) asc ");
java.util.List services = factory.find(hql.toString(), paramNames, paramValues);
return ServiceVoAssembler.createServiceVoCollectionFromService(services);
}
SupportServicesImpl.java 文件源码
项目:AvoinApotti
阅读 27
收藏 0
点赞 0
评论 0
public ServiceVoCollection listService( ServiceCategoryCollection excludedServices)
{
DomainFactory factory = getDomainFactory();
StringBuffer hql = new StringBuffer("from Service s where s.isActive = :active");
ArrayList paramNames = new ArrayList();
ArrayList paramValues = new ArrayList();
paramNames.add("active");
paramValues.add(Boolean.TRUE);
if (excludedServices != null)
{
int servicesSize = excludedServices.size();
for (int i = 0; i < servicesSize; i++)
{
if (i == 0)
hql.append(" and (");
ServiceCategory serviceCategory = excludedServices.get(i);
String serviceType = "serviceType" + Integer.toString(i);
paramNames.add(serviceType);
paramValues.add(new Integer(serviceCategory.getID()));
hql.append("s.serviceCategory.id <> :" + serviceType);
if (i == (servicesSize - 1))
hql.append(")");
else
hql.append(" and ");
}
}
//WDEV-18210
hql.append(" order by UPPER(s.serviceName) asc");
java.util.List services = factory.find(hql.toString(), paramNames, paramValues);
return ServiceVoAssembler.createServiceVoCollectionFromService(services);
}
LocationServiceImpl.java 文件源码
项目:AvoinApotti
阅读 22
收藏 0
点赞 0
评论 0
public ServiceVo getService(Integer serviceId)
{
DomainFactory factory = getDomainFactory();
if (serviceId != null)
{
Service domSserv = (Service) factory.getDomainObject(Service.class, serviceId);
return ServiceVoAssembler.create(domSserv);
}
return null;
}
LocationServiceImpl.java 文件源码
项目:AvoinApotti
阅读 22
收藏 0
点赞 0
评论 0
public ServiceVoCollection listService(Boolean activeOnly)
{
DomainFactory factory = getDomainFactory();
if (activeOnly.booleanValue())
return ServiceVoAssembler.createServiceVoCollectionFromService(factory.find("from Service service where service.isActive = :active", new String[]{"active"}, new Object[]{activeOnly}));
return ServiceVoAssembler.createServiceVoCollectionFromService(factory.listDomainObjects(Service.class)).sort();
}
PrescriptionComponentImpl.java 文件源码
项目:AvoinApotti
阅读 28
收藏 0
点赞 0
评论 0
/**
* getCatsReferralService
*/
public ims.core.vo.ServiceShortVo getCatsReferralService(ims.RefMan.vo.CatsReferralRefVo catsRefVo)
{
if(catsRefVo == null || catsRefVo.getID_CatsReferral() == null) {
throw new CodingRuntimeException("CatsReferralVo is null or id not provided");
}
CatsReferralListVo voCatsReferral = CatsReferralListVoAssembler.create((CatsReferral)getDomainFactory().getDomainObject(CatsReferral.class, catsRefVo.getID_CatsReferral()));
if (voCatsReferral != null && voCatsReferral.getReferralDetailsIsNotNull()&& voCatsReferral.getReferralDetails().getServiceIsNotNull()) {
return ServiceVoAssembler.create((Service)getDomainFactory().getDomainObject(Service.class, voCatsReferral.getReferralDetails().getService().getID_Service()));
}
return null;
}
AtConsultationComponentImpl.java 文件源码
项目:AvoinApotti
阅读 26
收藏 0
点赞 0
评论 0
public ServiceShortVo getCatsReferralService(CatsReferralRefVo voCatsReferralRef)
{
CatsReferralListVo voCatsReferral = CatsReferralListVoAssembler.create((CatsReferral)getDomainFactory().getDomainObject(CatsReferral.class, voCatsReferralRef.getID_CatsReferral()));
if (voCatsReferral != null)
return ServiceVoAssembler.create((Service)getDomainFactory().getDomainObject(Service.class, voCatsReferral.getReferralDetails().getService().getID_Service()));
return null;
}
ReferralOutcomeComponentImpl.java 文件源码
项目:AvoinApotti
阅读 23
收藏 0
点赞 0
评论 0
public ServiceVo getCatsReferralService(CatsReferralRefVo voCatsReferralRef)
{
CatsReferralListVo voCatsReferral = CatsReferralListVoAssembler.create((CatsReferral)getDomainFactory().getDomainObject(CatsReferral.class, voCatsReferralRef.getID_CatsReferral()));
if (voCatsReferral != null
&& voCatsReferral.getReferralDetailsIsNotNull()
&& voCatsReferral.getReferralDetails().getServiceIsNotNull())
return ServiceVoAssembler.create((Service)getDomainFactory().getDomainObject(Service.class, voCatsReferral.getReferralDetails().getService().getID_Service()));
return null;
}
SupportNetworkProfessionalServicesImpl.java 文件源码
项目:openMAXIMS
阅读 29
收藏 0
点赞 0
评论 0
public ServiceVoCollection listService(ServiceCategory serviceType)
{
// will be called from servicefunction when implemented in Spinal
DomainFactory factory = getDomainFactory();
if (serviceType == null)
return ServiceVoAssembler.createServiceVoCollectionFromService(factory.listDomainObjects(Service.class));
String hql = "from Service s where s.serviceCategory = :serviceType and s.isActive = :active";
java.util.List services = factory.find(hql, new String[]{"serviceType", "active"}, new Object[]{getDomLookup(serviceType), Boolean.TRUE});
return ServiceVoAssembler.createServiceVoCollectionFromService(services);
}
SupportNetworkProfessionalServicesImpl.java 文件源码
项目:openMAXIMS
阅读 28
收藏 0
点赞 0
评论 0
public ServiceVoCollection listService(ServiceCategoryCollection excludedServices)
{
DomainFactory factory = getDomainFactory();
StringBuffer hql = new StringBuffer("from Service s where s.isActive = :active");
ArrayList paramNames = new ArrayList();
ArrayList paramValues = new ArrayList();
paramNames.add("active");
paramValues.add(Boolean.TRUE);
if (excludedServices != null)
{
int servicesSize = excludedServices.size();
for (int i = 0; i < servicesSize; i++)
{
if (i == 0)
hql.append(" and (");
ServiceCategory serviceCategory = excludedServices.get(i);
String serviceType = "serviceType" + Integer.toString(i);
paramNames.add(serviceType);
paramValues.add(new Integer(serviceCategory.getID()));
hql.append("s.serviceCategory.id <> :" + serviceType);
if (i == (servicesSize - 1))
hql.append(")");
else
hql.append(" and ");
}
}
hql.append(" order by s.upperName asc "); //WDEV-20219 UPPER(s.serviceName)
java.util.List services = factory.find(hql.toString(), paramNames, paramValues);
return ServiceVoAssembler.createServiceVoCollectionFromService(services);
}
SupportServicesImpl.java 文件源码
项目:openMAXIMS
阅读 33
收藏 0
点赞 0
评论 0
public ServiceVoCollection listService( ServiceCategoryCollection excludedServices)
{
DomainFactory factory = getDomainFactory();
StringBuffer hql = new StringBuffer("from Service s where s.isActive = :active");
ArrayList paramNames = new ArrayList();
ArrayList paramValues = new ArrayList();
paramNames.add("active");
paramValues.add(Boolean.TRUE);
if (excludedServices != null)
{
int servicesSize = excludedServices.size();
for (int i = 0; i < servicesSize; i++)
{
if (i == 0)
hql.append(" and (");
ServiceCategory serviceCategory = excludedServices.get(i);
String serviceType = "serviceType" + Integer.toString(i);
paramNames.add(serviceType);
paramValues.add(new Integer(serviceCategory.getID()));
hql.append("s.serviceCategory.id <> :" + serviceType);
if (i == (servicesSize - 1))
hql.append(")");
else
hql.append(" and ");
}
}
//WDEV-18210
hql.append(" order by s.upperName asc"); //WDEV-20219 UPPER(s.serviceName)
java.util.List services = factory.find(hql.toString(), paramNames, paramValues);
return ServiceVoAssembler.createServiceVoCollectionFromService(services);
}
LocationServiceImpl.java 文件源码
项目:openMAXIMS
阅读 25
收藏 0
点赞 0
评论 0
public ServiceVo getService(Integer serviceId)
{
DomainFactory factory = getDomainFactory();
if (serviceId != null)
{
Service domSserv = (Service) factory.getDomainObject(Service.class, serviceId);
return ServiceVoAssembler.create(domSserv);
}
return null;
}
LocationServiceImpl.java 文件源码
项目:openMAXIMS
阅读 22
收藏 0
点赞 0
评论 0
public ServiceVoCollection listService(Boolean activeOnly)
{
DomainFactory factory = getDomainFactory();
if (activeOnly.booleanValue())
return ServiceVoAssembler.createServiceVoCollectionFromService(factory.find("from Service service where service.isActive = :active order by service.serviceName asc ", new String[]{"active"}, new Object[]{activeOnly})); //WDEV-22950
return ServiceVoAssembler.createServiceVoCollectionFromService(factory.listDomainObjects(Service.class)).sort();
}
PrescriptionComponentImpl.java 文件源码
项目:openMAXIMS
阅读 31
收藏 0
点赞 0
评论 0
/**
* getCatsReferralService
*/
public ims.core.vo.ServiceShortVo getCatsReferralService(ims.RefMan.vo.CatsReferralRefVo catsRefVo)
{
if(catsRefVo == null || catsRefVo.getID_CatsReferral() == null) {
throw new CodingRuntimeException("CatsReferralVo is null or id not provided");
}
CatsReferralListVo voCatsReferral = CatsReferralListVoAssembler.create((CatsReferral)getDomainFactory().getDomainObject(CatsReferral.class, catsRefVo.getID_CatsReferral()));
if (voCatsReferral != null && voCatsReferral.getReferralDetailsIsNotNull()&& voCatsReferral.getReferralDetails().getServiceIsNotNull()) {
return ServiceVoAssembler.create((Service)getDomainFactory().getDomainObject(Service.class, voCatsReferral.getReferralDetails().getService().getID_Service()));
}
return null;
}
AtConsultationComponentImpl.java 文件源码
项目:openMAXIMS
阅读 35
收藏 0
点赞 0
评论 0
public ServiceShortVo getCatsReferralService(CatsReferralRefVo voCatsReferralRef)
{
CatsReferralListVo voCatsReferral = CatsReferralListVoAssembler.create((CatsReferral)getDomainFactory().getDomainObject(CatsReferral.class, voCatsReferralRef.getID_CatsReferral()));
if (voCatsReferral != null)
return ServiceVoAssembler.create((Service)getDomainFactory().getDomainObject(Service.class, voCatsReferral.getReferralDetails().getService().getID_Service()));
return null;
}
ReferralOutcomeComponentImpl.java 文件源码
项目:openMAXIMS
阅读 20
收藏 0
点赞 0
评论 0
public ServiceVo getCatsReferralService(CatsReferralRefVo voCatsReferralRef)
{
CatsReferralListVo voCatsReferral = CatsReferralListVoAssembler.create((CatsReferral)getDomainFactory().getDomainObject(CatsReferral.class, voCatsReferralRef.getID_CatsReferral()));
if (voCatsReferral != null
&& voCatsReferral.getReferralDetailsIsNotNull()
&& voCatsReferral.getReferralDetails().getServiceIsNotNull())
return ServiceVoAssembler.create((Service)getDomainFactory().getDomainObject(Service.class, voCatsReferral.getReferralDetails().getService().getID_Service()));
return null;
}
SupportNetworkProfessionalServicesImpl.java 文件源码
项目:openMAXIMS
阅读 28
收藏 0
点赞 0
评论 0
public ServiceVoCollection listService(ServiceCategory serviceType)
{
// will be called from servicefunction when implemented in Spinal
DomainFactory factory = getDomainFactory();
if (serviceType == null)
return ServiceVoAssembler.createServiceVoCollectionFromService(factory.listDomainObjects(Service.class));
String hql = "from Service s where s.serviceCategory = :serviceType and s.isActive = :active";
java.util.List services = factory.find(hql, new String[]{"serviceType", "active"}, new Object[]{getDomLookup(serviceType), Boolean.TRUE});
return ServiceVoAssembler.createServiceVoCollectionFromService(services);
}
SupportNetworkProfessionalServicesImpl.java 文件源码
项目:openMAXIMS
阅读 27
收藏 0
点赞 0
评论 0
public ServiceVoCollection listService(ServiceCategoryCollection excludedServices)
{
DomainFactory factory = getDomainFactory();
StringBuffer hql = new StringBuffer("from Service s where s.isActive = :active");
ArrayList paramNames = new ArrayList();
ArrayList paramValues = new ArrayList();
paramNames.add("active");
paramValues.add(Boolean.TRUE);
if (excludedServices != null)
{
int servicesSize = excludedServices.size();
for (int i = 0; i < servicesSize; i++)
{
if (i == 0)
hql.append(" and (");
ServiceCategory serviceCategory = excludedServices.get(i);
String serviceType = "serviceType" + Integer.toString(i);
paramNames.add(serviceType);
paramValues.add(new Integer(serviceCategory.getID()));
hql.append("s.serviceCategory.id <> :" + serviceType);
if (i == (servicesSize - 1))
hql.append(")");
else
hql.append(" and ");
}
}
hql.append(" order by UPPER(s.serviceName) asc ");
java.util.List services = factory.find(hql.toString(), paramNames, paramValues);
return ServiceVoAssembler.createServiceVoCollectionFromService(services);
}