Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java =================================================================== diff -u -r40834 -r40869 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 40834) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 40869) @@ -4367,9 +4367,9 @@ private boolean updateTousseInstanceSignInfo(Collection ids, String signer, Date signDate, Long signRecordId, boolean firstInvoice) { //签收完发货单,需要同步TousseInstance String update = "update TousseInstance po set po.signedUser=?,po.signedDate=?,signRecordId=?,po.status=?"; - String invoiceIdSql = SqlBuilder.build_number_IN_Statement("invoice_id",SqlBuilder.IN, ids); + String invoiceIdSql = SqlUtils.getNonStringFieldInLargeCollectionsPredicate("invoice_id", ids); if(!firstInvoice){ - invoiceIdSql = SqlBuilder.build_number_IN_Statement("invoice2_id",SqlBuilder.IN, ids); + invoiceIdSql = SqlUtils.getNonStringFieldInLargeCollectionsPredicate("invoice2_id", ids); } String statusSql = " po.status = '" + TousseInstance.STATUS_SHIPPED + "'"; String hql = String.format("%s where %s and %s", update,invoiceIdSql,statusSql);