/** 提现金额统计 */ public BigDecimal getSumMoneyByApplyTime(Calendar f_stime, Calendar f_etime) { // TODO Auto-generated method stub Criteria criteria = backMoneyRequestDao.createCriteria(); criteria.setProjection(Projections.projectionList().add(Projections.sum("money"))); if (null != f_stime) { criteria.add(Restrictions.ge("applyTime", f_stime)); } if (null != f_etime) { criteria.add(Restrictions.le("applyTime", f_etime)); } List list = criteria.add(Restrictions.eq("status", BackMoneyStatus.已成功)).list(); BigDecimal money = new BigDecimal(0.00); Object obj = list.get(0); if (obj != null) { money = (BigDecimal) obj; } return money; }