Index: ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java =================================================================== diff -u -r37556 -r37666 --- ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java (.../RecyclingRecordManagerImpl.java) (revision 37556) +++ ssts-recyclingrecord/src/main/java/com/forgon/disinfectsystem/recyclingrecord/service/RecyclingRecordManagerImpl.java (.../RecyclingRecordManagerImpl.java) (revision 37666) @@ -516,17 +516,6 @@ Set thisBarcodes = SqlUtils.splitStringToSet(entry.getValue(), Constants.IDS_SEPARATOR); totalBarcodes.addAll(thisBarcodes); String barcodeSql = SqlUtils.getStringFieldInLargeCollectionsPredicate("bd.barcode", thisBarcodes); -/* sbf.append("update "); - sbf.append(TousseInstance.class.getSimpleName()); - sbf.append(" set recyclingItemId="); - sbf.append(entry.getKey()); - sbf.append(" ,recyclingStatus='"); - sbf.append(TousseInstance.STATUS_RECYCLED); - sbf.append("' where id in (select bd.id from "); - sbf.append(BarcodeDevice.class.getSimpleName()); - sbf.append(" bd where "); - sbf.append(barcodeSql); - sbf.append(")");*/ sbf.append("update "); sbf.append(TousseInstance.class.getSimpleName()); sbf.append(" set recyclingItemId="); @@ -542,9 +531,9 @@ sbf.append(") and tousseDefinition_id in(select id from "); sbf.append(TousseDefinition.class.getSimpleName()); sbf.append(" where isRecycling='是')"); + jdbcTemplate.execute(sbf.toString()); + sbf.setLength(0); } - jdbcTemplate.execute(sbf.toString()); - sbf.setLength(0); /*sbf.append("select ti.useRecord_id from "); sbf.append(TousseInstance.class.getSimpleName()); sbf.append(" ti join ");