计算总和
pageAndOrder.addFooterSum(pageAndOrder.ClassName, WarehouseWarrantDetail.class.getName(), null);
pageAndOrder.addFooterSum("ROUND(putNum,0)", null, "putNum");
pageAndOrder.addFooterSum("putNum*price", null, "ztotalAmount");
pageAndOrder.addFooterWhere("warehouseWarrant.id",vo.getWarehouseWarrantId());
PagedQuery result = new PagedQuery();
result.setSession(this.getCurrentSession());
pageAndOrder.setFooter(result.getFooter(pageAndOrder));
query = this.getCurrentSession().createSQLQuery("SELECT COUNT(*) "+sql.toString());
if(StringUtil.isNotEmpty(vo.getProductName())){
query.setParameter("proName", "%"+vo.getProductName()+"%");
}
if(StringUtil.isNotEmpty(vo.getBrandName())){
query.setParameter("brandName", "%"+vo.getBrandName()+"%");
}
if(StringUtil.isNotEmpty(vo.getProductCode())){
query.setParameter("code", "%"+vo.getProductCode()+"%");
}
if(StringUtil.isNotEmpty(vo.getNormModel())){
query.setParameter("nromModel", "%"+vo.getNormModel().toUpperCase().replaceAll(" ", "")+"%");
}
if(StringUtil.isNotEmpty(vo.getCategoryName())){
query.setParameter("categoryName", "%"+vo.getCategoryName()+"%");
}
pageAndOrder.setTotalRows(Integer.parseInt(query.uniqueResult().toString()));