DetachedCriteria 实现多表关联，检索条件

[java] view plain copy print ?

1. DetachedCriteria queryCriteria = DetachedCriteria.forClass(Rsvmain.class);  
2. if (ObjectUtils.isNotEmpty(query.getUnitinfoName())) {  
3.                 DetachedCriteria unitinfo = DetachedCriteria.forClass(Unitinfo.class);  
4.                 unitinfo.add(Restrictions.like("unitnm", "%" + query.getUnitinfoName() + "%"));  
5.                 unitinfo.setProjection(Property.forName("id"));  
6.                 queryCriteria.add(Property.forName("unitinfoId").in(unitinfo));  
7.             }  
8.             if (ObjectUtils.isNotEmpty(query.getMemberName())) {  
9.                 DetachedCriteria member = DetachedCriteria.forClass(Member.class);  
10.                 member.add(Restrictions.disjunction()  
11.                         .add(Restrictions.like("lastnm", "%" + query.getMemberName() + "%"))  
12.                         .add(Restrictions.like("firstnm", "%" + query.getMemberName() + "%"))  
13.                         .add(Restrictions.like("altnm", "%" + query.getMemberName() + "%")));  
14.                 member.setProjection(Property.forName("id"));  
15.                 queryCriteria.add(Property.forName("memberId").in(member));  
16.             }  
17.             if (ObjectUtils.isNotEmpty(query.getStartdt()) || ObjectUtils.isNotEmpty(query.getEnddt())) {  
18.                 DetachedCriteria rsvdtl = DetachedCriteria.forClass(Rsvdtl.class);  
19.                 if (ObjectUtils.isNotEmpty(query.getStartdt())) {  
20.                     rsvdtl.add(Restrictions.ge("cidt", query.getStartdt()));  
21.                 }  
22.                 if (ObjectUtils.isNotEmpty(query.getEnddt())) {  
23.                     rsvdtl.add(Restrictions.le("codt", query.getEnddt()));  
24.                 }  
25.                 rsvdtl.setProjection(Property.forName("rsvmainId"));  
26.                 queryCriteria.add(Property.forName("id").in(rsvdtl));  
27.             }