/*
* 查找将要核保订正的投保单记录
* @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;
}
