Index: ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java =================================================================== diff -u -r17555 -r17556 --- ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java (.../RecyclingRecordManagerImpl.java) (revision 17555) +++ ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java (.../RecyclingRecordManagerImpl.java) (revision 17556) @@ -1349,8 +1349,10 @@ List taskList = packingManager.getPackingTask(records.getId(),item.getTousseDefinitionId(),PackingTask.TASK_RECYCLINGRECORD); if (CollectionUtils.isNotEmpty(taskList)) { List taskIdList = new ArrayList(); - String sql = String.format("select min(p.id),min(p.amount),count(i.packingTaskID) from %s p left join %s i on p.id = i.packingTaskID group by p.id", - PackingTask.class.getSimpleName(),IDCardInfoForPackingTask.class.getSimpleName()); + String sql = String.format("select min(p.id),min(p.amount),count(i.packingTaskID) from %s p left join %s i on p.id = i.packingTaskID" + + " where p.tousseDefinition_id = %s and p.sourceId = %s and p.taskType = %s group by p.id", + PackingTask.class.getSimpleName(),IDCardInfoForPackingTask.class.getSimpleName(),item.getTousseDefinitionId(), + records.getId(),PackingTask.TASK_RECYCLINGRECORD); ResultSet rs = objectDao.executeSql(sql); try { while(rs.next()){