Criteria cri=this.getSession().createCriteria(Fruit.class);
int offline=bean.getStartNum();
int limitNum=bean.getLimitNum();
String name=bean.getName();
String fruitType=bean.getFruitType();
if(name!=null && !name.equals("")){
cri.add(Restrictions.like("fruitName", "%"+name+"%"));
}
.....
Criteria repA=cri.createCriteria("repAward", CriteriaSpecification.LEFT_JOIN);
Criteria works=cri.createCriteria("works", CriteriaSpecification.LEFT_JOIN);
Criteria copyRight=cri.createCriteria("copyRight", CriteriaSpecification.LEFT_JOIN);
Criteria standard=cri.createCriteria("standard", CriteriaSpecification.LEFT_JOIN);
Criteria patent=cri.createCriteria("patent", CriteriaSpecification.LEFT_JOIN);
Criteria protion=cri.createCriteria("protion", CriteriaSpecification.LEFT_JOIN);
Criteria newProducts=cri.createCriteria("newProducts", CriteriaSpecification.LEFT_JOIN);
if (fruitType != null && fruitType.length() > 0 ){//信息表
if ("G".equals(fruitType)) {
if(bean.getRewName()!=null && !"".equals(bean.getRewName())){
repA.add(Restrictions.like("rewName", "%"+bean.getRewName()+"%"));
}
.........
}.........
}
if (fruitType != null && fruitType.length() > 0 && !fruitType.equals("0")) {
cri.add(Restrictions.eq("fruitType",fruitType));
}
int startNum = offline==0?0:PageBean.countOffset(limitNum, offline);//当前页开始记录
long count=(Long) cri.setProjection(Projections.rowCount()).uniqueResult();
cri.setProjection(null);
cri.setResultTransformer(CriteriaSpecification.ROOT_ENTITY);//避免返回多个对象数组
cri.setFirstResult(startNum);
cri.setMaxResults(limitNum);
List<Fruit> listtemp=cri.list();
int offline=bean.getStartNum();
int limitNum=bean.getLimitNum();
String name=bean.getName();
String fruitType=bean.getFruitType();
if(name!=null && !name.equals("")){
cri.add(Restrictions.like("fruitName", "%"+name+"%"));
}
.....
Criteria repA=cri.createCriteria("repAward", CriteriaSpecification.LEFT_JOIN);
Criteria works=cri.createCriteria("works", CriteriaSpecification.LEFT_JOIN);
Criteria copyRight=cri.createCriteria("copyRight", CriteriaSpecification.LEFT_JOIN);
Criteria standard=cri.createCriteria("standard", CriteriaSpecification.LEFT_JOIN);
Criteria patent=cri.createCriteria("patent", CriteriaSpecification.LEFT_JOIN);
Criteria protion=cri.createCriteria("protion", CriteriaSpecification.LEFT_JOIN);
Criteria newProducts=cri.createCriteria("newProducts", CriteriaSpecification.LEFT_JOIN);
if (fruitType != null && fruitType.length() > 0 ){//信息表
if ("G".equals(fruitType)) {
if(bean.getRewName()!=null && !"".equals(bean.getRewName())){
repA.add(Restrictions.like("rewName", "%"+bean.getRewName()+"%"));
}
.........
}.........
}
if (fruitType != null && fruitType.length() > 0 && !fruitType.equals("0")) {
cri.add(Restrictions.eq("fruitType",fruitType));
}
int startNum = offline==0?0:PageBean.countOffset(limitNum, offline);//当前页开始记录
long count=(Long) cri.setProjection(Projections.rowCount()).uniqueResult();
cri.setProjection(null);
cri.setResultTransformer(CriteriaSpecification.ROOT_ENTITY);//避免返回多个对象数组
cri.setFirstResult(startNum);
cri.setMaxResults(limitNum);
List<Fruit> listtemp=cri.list();