50,526
社区成员
发帖
与我相关
我的任务
分享
StringBuilder sb = new StringBuilder("SELECT c FROM CarInfo c,TransportTask t,ConsignmentBill b WHERE t.carNo=c.carCode");
sb.append("AND b.recordId=t.consignmentBill.recordId"+
" AND c.load*1000<b.goodsWeight"+
" AND t.consignmentBill.recordId =b.recordId"+
" AND c.sysInfo.state = 3 AND t.scanFlag IN (1,2)"+
" AND c.experimentCode = '"+new MyVisit().getExperimentCode()+
"' GROUP BY c.carCode");
String hql = sb.toString();
System.out.println(hql);
this.setPage(carInfoService.findCarInfoByHql(page, hql));
return SUCCESS;