Index: ssts-userecord/src/main/java/com/forgon/disinfectsystem/useRecord/service/UseRecordManagerImpl.java =================================================================== diff -u -r17544 -r17563 --- ssts-userecord/src/main/java/com/forgon/disinfectsystem/useRecord/service/UseRecordManagerImpl.java (.../UseRecordManagerImpl.java) (revision 17544) +++ ssts-userecord/src/main/java/com/forgon/disinfectsystem/useRecord/service/UseRecordManagerImpl.java (.../UseRecordManagerImpl.java) (revision 17563) @@ -175,8 +175,8 @@ start.setTime(now.getTime() - 24 * 60*60*1000); String sql = String - .format("where po.departCoding = '%s' and %s",departCoding,dateQueryAdapter.dateAreaSql("po.enteringDate", - Constants.SIMPLEDATEFORMAT_YYYYMMDDHHMMSS.format(start), Constants.SIMPLEDATEFORMAT_YYYYMMDDHHMMSS.format(now), false)); + .format("where po.departCoding = '%s' and %s",departCoding,dateQueryAdapter.dateAreaSql("po.enteringDate", + Constants.SIMPLEDATEFORMAT_YYYYMMDDHHMMSS.format(start), null, false,true));//没有结束时间,则只要大于开始时间就行,不限制结束时间为当前时间。因为精度只到秒,当前时间与使用记录的时间是同一秒,会导致刚添加的使用记录未被查出 return objectDao.findBySql(UseRecord.class.getSimpleName(), sql, "enteringDate desc,operationRoom asc"); }