public PatientProcedureForSurgicalAuditPreOpChecksVoCollection listProcedures(SurgicalAuditPreOpChecksRefVo surgicalAuditPreOpChecksRef) { if (surgicalAuditPreOpChecksRef == null || surgicalAuditPreOpChecksRef.getID_SurgicalAuditPreOpChecks() == null) { throw new CodingRuntimeException("Cannot get PatientProcedureForSurgicalAuditPreOpChecksVoCollection on null Id for surgicalAuditPreOpChecksRef "); } DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer(); hql.append("select procedures from SurgicalAuditPreOpChecks as surgAuditPreOP left join surgAuditPreOP.plannedProcedures as procedures where surgAuditPreOP.id = :surgPreOpId order by procedures.procedureDescription asc "); List<?> list = factory.find(hql.toString(), new String[] { "surgPreOpId" }, new Object[] { surgicalAuditPreOpChecksRef.getID_SurgicalAuditPreOpChecks()}); return PatientProcedureForSurgicalAuditPreOpChecksVoAssembler.createPatientProcedureForSurgicalAuditPreOpChecksVoCollectionFromPatientProcedure(list); }
public PatientProcedureForSurgicalAuditPreOpChecksVoCollection listProcedures( SurgicalAuditPreOpChecksRefVo surgicalAuditPreOpChecksRef) { if (surgicalAuditPreOpChecksRef == null || surgicalAuditPreOpChecksRef.getID_SurgicalAuditPreOpChecks() == null) { throw new CodingRuntimeException("Cannot get PatientProcedureForSurgicalAuditPreOpChecksVoCollection on null Id for surgicalAuditPreOpChecksRef "); } DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer(); hql.append("select procedures from SurgicalAuditPreOpChecks as surgAuditPreOP left join surgAuditPreOP.plannedProcedures as procedures where surgAuditPreOP.id = :surgPreOpId order by procedures.procedureDescription asc "); List<?> list = factory.find(hql.toString(), new String[] { "surgPreOpId" }, new Object[] { surgicalAuditPreOpChecksRef.getID_SurgicalAuditPreOpChecks()}); return PatientProcedureForSurgicalAuditPreOpChecksVoAssembler.createPatientProcedureForSurgicalAuditPreOpChecksVoCollectionFromPatientProcedure(list); }