/**
* list Drawing Graphic Findings
*/
public ims.core.vo.DrawingGraphicFindingVoCollection listFindings(String findingName, PreActiveActiveInactiveStatus status)
{
/*
DomainFactory factory = getDomainFactory();
StringBuffer hql = new StringBuffer("from DrawingGraphicFinding dgf ");
ArrayList names = new ArrayList();
ArrayList values = new ArrayList();
if(findingName != null && findingName.equals("") == false)
{
names.add("searchName");
values.add(findingName.toUpperCase());
names.add("STATUS");
values.add(new Integer(PreActiveActiveInactiveStatus.ACTIVE.getId()));
hql.append("where upper(dgf.displayText) like :searchName and dgf.activeStatus.id = :STATUS");
}
else
{
names.add("STATUS");
values.add(new Integer(PreActiveActiveInactiveStatus.ACTIVE.getId()));
hql.append("where dgf.activeStatus.id = :STATUS");
}
*/
DomainFactory factory = getDomainFactory();
StringBuffer hql = new StringBuffer(" ");
String query = "from DrawingGraphicFinding dgf ";
ArrayList markers = new ArrayList();
ArrayList values = new ArrayList();
String andStr = " ";
if(findingName != null && findingName.equals("") == false)
{
hql.append(andStr + " upper(dgf.displayText) like :searchName ");
markers.add("searchName");
values.add(findingName.toUpperCase());
andStr = " and ";
}
if (status != null)
{
hql.append(andStr + " dgf.activeStatus.id = :STATUS ");
markers.add("STATUS");
values.add(new Integer(status.getId()));
andStr = " and ";
}
if (markers.size() > 0)
query += " where ";
query += hql.toString();
List findingsList = factory.find(query, markers, values);
return DrawingGraphicFindingVoAssembler.createDrawingGraphicFindingVoCollectionFromDrawingGraphicFinding(findingsList);
}
FindingQuestionsImpl.java 文件源码
java
阅读 56
收藏 0
点赞 0
评论 0
项目:openMAXIMS
作者:
评论列表
文章目录