public ims.admin.vo.ServiceForElectiveListConfigVoCollection listServices(String name) { StringBuilder hqlBuilder = new StringBuilder("select s1_1 from Service as s1_1 where s1_1.upperName like :servName and s1_1.isActive = 1 and s1_1.serviceCategory.id <> :patCategoryID "); List <?> dos = getDomainFactory().find(hqlBuilder.toString(),new String[] {"servName","patCategoryID"},new Object[] {name.toUpperCase()+"%",ServiceCategory.PATHOLOGY_DISCIPLINE.getID()}); if (dos == null || dos.size() == 0) return null; return ServiceForElectiveListConfigVoAssembler.createServiceForElectiveListConfigVoCollectionFromService(dos); }
public ims.admin.vo.ServiceForElectiveListConfigVoCollection listServices(String name) { StringBuilder hqlBuilder = new StringBuilder("select s1_1 from Service as s1_1 where s1_1.upperName like :servName and s1_1.isActive = 1 "); List <?> dos = getDomainFactory().find(hqlBuilder.toString(),"servName",name.toUpperCase()+"%"); if (dos == null || dos.size() == 0) return null; return ServiceForElectiveListConfigVoAssembler.createServiceForElectiveListConfigVoCollectionFromService(dos); }
public ims.admin.vo.ServiceForElectiveListConfigVoCollection listServices(String name) { //WDEV-20064 StringBuilder hqlBuilder = new StringBuilder("select s1_1 from Service as s1_1 where s1_1.upperName like :servName and s1_1.isActive = 1 and s1_1.serviceCategory.id =:clinicalCategoryID order by s1_1.upperName asc"); List <?> dos = getDomainFactory().find(hqlBuilder.toString(),new String[] {"servName","clinicalCategoryID"},new Object[] {name.toUpperCase()+"%",ServiceCategory.CLINICAL.getID()}); if (dos == null || dos.size() == 0) return null; return ServiceForElectiveListConfigVoAssembler.createServiceForElectiveListConfigVoCollectionFromService(dos); }
public ServiceForElectiveListConfigVoCollection listServices(String name) { if (name == null) return null; StringBuilder query = new StringBuilder("SELECT service FROM Service AS service "); ArrayList<String> paramNames = new ArrayList<String>(); ArrayList<Object> paramValues = new ArrayList<Object>(); query.append(" WHERE service.upperName LIKE :NAME AND service.isActive = 1 "); paramNames.add("NAME"); paramValues.add(name.toUpperCase() + "%"); query.append(" ORDER BY service.upperName"); return ServiceForElectiveListConfigVoAssembler.createServiceForElectiveListConfigVoCollectionFromService(getDomainFactory().find(query.toString(), paramNames, paramValues)); }