Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java =================================================================== diff -u -r16332 -r16335 --- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java (.../InvoicePlanManagerImpl.java) (revision 16332) +++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/InvoicePlanManagerImpl.java (.../InvoicePlanManagerImpl.java) (revision 16335) @@ -951,25 +951,17 @@ break; } } - String amountSql; - SupplyRoomConfig supplyRoomConfig = supplyRoomConfigManager.getSystemParamsObj(); - if(supplyRoomConfig.invoiceOriginRecycling()){ - //发货数量依据回收单 - amountSql = "(recyclingAmount - sendOutAmount) > 0"; - }else{ - amountSql = "(amount - sendOutAmount) > 0"; - } if(!tousseTypeSet.isEmpty()){ // 新的传参方式 - where8 = String.format("po.id in (select invoicePlan.id from TousseItem where (isTerminated is null or isTerminated <> true) and (%s) and %s)",amountSql,SqlUtils.getStringFieldInCollectionsPredicate("tousseType", tousseTypeSet)); + where8 = String.format("po.id in (select invoicePlan.id from TousseItem where (isTerminated is null or isTerminated <> true) and %s)",SqlUtils.getStringFieldInCollectionsPredicate("tousseType", tousseTypeSet)); }else if(TousseItem.DIPOSABLE_YES.equals(tousseType) || TousseItem.TYPE_DIPOSABLE_GOODS.equals(tousseType)){ where8 = String.format("po.id in (select invoicePlan.id from TousseItem where (isTerminated is null or isTerminated <> true) and (amount - sendOutAmount > 0) and tousseType = '%s')",TousseItem.TYPE_DIPOSABLE_GOODS); }else if(TousseItem.DIPOSABLE_NO.equals(tousseType)){ - where8 = String.format("po.id in (select invoicePlan.id from TousseItem where (isTerminated is null or isTerminated <> true) and (%s) and tousseType != '%s')",amountSql,TousseItem.TYPE_DIPOSABLE_GOODS); + where8 = String.format("po.id in (select invoicePlan.id from TousseItem where (isTerminated is null or isTerminated <> true) and tousseType != '%s')",TousseItem.TYPE_DIPOSABLE_GOODS); }else{ //具体的器械包类型 - where8 = String.format("po.id in (select invoicePlan.id from TousseItem where (isTerminated is null or isTerminated <> true) and (%s) and tousseType = '%s')",amountSql,tousseType); + where8 = String.format("po.id in (select invoicePlan.id from TousseItem where (isTerminated is null or isTerminated <> true) and tousseType = '%s')",tousseType); } }