String hql = "select publicPolicyId from TMuster where musterDate >= ? and publicPolicyId between ? and ? ";
Query query = session.createQuery(hql);
query.setParameter(0, DateUtil.toDate("2010-01-01"));
query.setParameter(1, policyIdStart);
query.setParameter(2, policyIdEnd);
List tmpList = query.list();
if(tmpList == null){return null;}
// 过滤查询 TPolicyInsurantTemporary 非空条件
hql = "select id.publicPolicyId from TPolicyInsurantTemporary where id.publicPolicyId in(:plist) and name <> '' and cert <> '' and cerc <> '' ";
query = session.createQuery(hql);
query.setParameterList("plist", tmpList);
tmpList = query.list();
if(tmpList == null){return null;}
// 过滤查询 PublicPolicyTemporary 非空条件
hql = "from TPublicPolicyTemporary where publicPolicyId in(:plist) and applyName <> '' and applyCert <> '' and applyCerc <> '' and billNo <> '' ";
query = session.createQuery(hql);
query.setParameterList("plist", tmpList);
tmpList = query.list();
if(tmpList == null){return null;}
rstList = this.TPublicPolicyTrVO(tmpList);
08-25
1024
09-08
1305