/** * 根据日期统计一天的会议 * @param siteId * @param startTime * @return */public int countMeetingInSiteByDate(String siteId, Date startTime){ long endTimeMillis = startTime.getTime() + 1000 * 60 * 60 * 24; Date endTime = new Date(endTimeMillis); Map paramMap = new HashMap(4); paramMap.put("siteId", siteId); paramMap.put("startTime", startTime); paramMap.put("endTime", endTime); StringBuffer sql = new StringBuffer( "where qmIsDelete=0 and qmSiteId=:siteId and qmMeetingTime>=:startTime and qmMeetingTime<:endTime"); return countBySql(sql.toString(), paramMap);}
转载于:https://www.cnblogs.com/zzl0916/p/10969415.html
