/** * 详情页面的查询 */ @Override public Map<String, Object> pointsStardList(PointsCpt pointsCpt, int pageNo, int pageSize) { pointsCpt.setStartRow((pageNo-1)*pageSize+1); pointsCpt.setEndRow(pageSize*pageNo+50); JspPage page = (JspPage)commonDao.pageQuery("MemberPointsSetting.getMemberPointsSettingStardCount","MemberPointsSetting.getMemberPointsSettingStardPage", pointsCpt, pageNo, pageSize,false); Map<String,Object> resMap = new HashMap<String, Object>(); resMap.put("total", page.getTotalCount()); resMap.put("rows", page.getResult()); /** * 计算合计 */ NumberFormat nf = new DecimalFormat(",##0.00"); // 获取合计数 Map<String, Object> footerMap1 = new HashMap<String, Object>(); Double totalFee = (Double) commonDao.queryForObject( "MemberPointsSetting.getMemberPointsSettingTotalByPage", pointsCpt); String memberPointsSettingToata = nf.format(totalFee); //合计显示的位置 footerMap1.put("pointsDesc", "合计:"); footerMap1.put("points", memberPointsSettingToata); // 将合计总计Footer回传 List<Map<String, Object>> footerList = new ArrayList<Map<String, Object>>(); footerList.add(footerMap1); resMap.put("footer", footerList); return resMap; }
如图所示: