计算表格的总计

最新推荐文章于 2021-07-28 20:10:38 发布

原创最新推荐文章于 2021-07-28 20:10:38 发布 · 584 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#总计

JavaEE 专栏收录该内容

10 篇文章

订阅专栏

计算总和

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()));