FindingQuestionsImpl.java 文件源码

/**
* 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);
}