Index: ssts-userecord/src/main/java/com/forgon/disinfectsystem/useRecord/service/UseRecordManagerImpl.java =================================================================== diff -u -r22096 -r22104 --- ssts-userecord/src/main/java/com/forgon/disinfectsystem/useRecord/service/UseRecordManagerImpl.java (.../UseRecordManagerImpl.java) (revision 22096) +++ ssts-userecord/src/main/java/com/forgon/disinfectsystem/useRecord/service/UseRecordManagerImpl.java (.../UseRecordManagerImpl.java) (revision 22104) @@ -3955,10 +3955,16 @@ String[] barcodesArr = tousseBarcodes.split(";"); List tousseInstanceList = new ArrayList(); for(int i=0;i auditedUseRecordList = - objectDao.findBySql_ForUpdate(UseRecord.class.getSimpleName(), " where status='"+ UseRecord.STATUS_AUDITED +"' and departCoding='"+ departCode +"'"); + objectDao.findBySql_ForUpdate(UseRecord.class.getSimpleName(), + " where status in ('"+ UseRecord.STATUS_UNAUDITED +"','"+ UseRecord.STATUS_AUDITED +"') and departCoding='"+ departCode +"'"); if(CollectionUtils.isNotEmpty(auditedUseRecordList)){ Collection ids = new ArrayList(); for (UseRecord useRecord : auditedUseRecordList) {