/* * 查找将要核保订正的投保单记录 * @title findUWResultModify * @author 薛玉强 * @see ins.prpall.proposal.service.facade.UWModifyService#findUWResultModify(ins.prpall.proposal.model.LCGrpCont) */ @Override public Page findUWResultModify(LCGrpCont lcGrpCont, int pageNo, int pageSize) { // 根据查询条件查询投保单记录 StringBuffer findUWModifyHql = new StringBuffer(); findUWModifyHql.append( "from LCGrpCont t1 where t1.state = '" + FinalCollection.CONT_STATE8 + "'"); if (null != lcGrpCont && !"".equals(lcGrpCont.getGrpContNo())) { findUWModifyHql.append(" and t1.grpContNo like '" + lcGrpCont.getGrpContNo().trim() + "%'"); } if (null != lcGrpCont && !"".equals(lcGrpCont.getManageCom())) { findUWModifyHql.append(" and t1.manageCom like '" + lcGrpCont.getManageCom().trim() + "%'"); } if (null != lcGrpCont && !"".equals(lcGrpCont.getAppntNo())) { findUWModifyHql.append(" and t1.appntNo like '" + lcGrpCont.getAppntNo().trim() + "%'"); } if (null != lcGrpCont && !"".equals(lcGrpCont.getGrpName())) { findUWModifyHql.append(" and t1.grpName like '%" + lcGrpCont.getGrpName().trim() + "%'"); } if (null != lcGrpCont && !"".equals(lcGrpCont.getAgentCode())) { findUWModifyHql.append(" and t1.agentCode like '" + lcGrpCont.getAgentCode().trim() + "%'"); } Page lcGrpContPage = this.findByHql(findUWModifyHql.toString(), pageNo, pageSize, null); return lcGrpContPage; }