Index: ssts-returngoods/src/main/java/com/forgon/disinfectsystem/returngoodsrecord/service/ReturnGoodsRecordManagerImpl.java =================================================================== diff -u -r28067 -r28070 --- ssts-returngoods/src/main/java/com/forgon/disinfectsystem/returngoodsrecord/service/ReturnGoodsRecordManagerImpl.java (.../ReturnGoodsRecordManagerImpl.java) (revision 28067) +++ ssts-returngoods/src/main/java/com/forgon/disinfectsystem/returngoodsrecord/service/ReturnGoodsRecordManagerImpl.java (.../ReturnGoodsRecordManagerImpl.java) (revision 28070) @@ -1254,8 +1254,10 @@ */ private void setTousseDefinitionInvoicePlanId(List disinfectTdList,Long invoicePlanId){ if(CollectionUtils.isNotEmpty(disinfectTdList)){ - objectDao.excuteSQL(String.format("update %s set invoicePlanID=% where %s", TousseDefinition.class.getSimpleName(),invoicePlanId, - disinfectTdList.stream().map(TousseDefinition::getId).collect(Collectors.toList()))); + List tdIdList = disinfectTdList.stream().map(TousseDefinition::getId).collect(Collectors.toList()); + objectDao.excuteSQL(String.format("update %s set invoicePlanID=% where %s", + TousseDefinition.class.getSimpleName(),invoicePlanId, + SqlUtils.getNonStringFieldInLargeCollectionsPredicate("id", tdIdList))); } }