Criteriaquery CQ = new Criteriaquery (Tsuser.class, DataGrid);
Query Condition Builder
ORG.JEECGFRAMEWORK.CORE.EXTEND.HQLSEARCH.HQLGENERATEUTIL.INSTALLHQL (CQ, user);
Restrictions.or (Restrictions.ilike ("UserName", Searchvalue, Matchmode.anywhere), Restrictions.ilike ("RealName", Searchvalue, Matchmode.anywhere));
Restrictions.or (Restrictions.ilike ("UserOrgList.tsDepart.departname", Searchvalue, Matchmode.anywhere), Restrictions.ilike ("UserKey", Searchvalue, Matchmode.anywhere));
Restrictions.or (Restrictions.ilike ("Userquarters", Searchvalue, Matchmode.anywhere), Restrictions.ilike ("UserWork ", Searchvalue, Matchmode.anywhere));
Cq.add ();
This.systemService.getDataGridReturn (CQ, True);
Tagutil.datagrid (response, DataGrid);
Unlimited Add or
list<tsuser> list = Criteria.add (Restrictions.or (restrictions.like ("description", Key,matchmode.anywhere),                    restrictions.or (restrictions.like ("name", Key,matchmode.anywhere),               restrictions.or (restricti Ons.like ("direct", Key,matchmode.anywhere),               restrictions.or (Restrictions.like ("Mainplay", Key,matchmode.any where),                        restrictions.like ("Filearea", Key,matchmode.anywhere)))). List ();
Hibernate Criteria Restrictions Tool class usage