Index: ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodBatchStockManagerImpl.java =================================================================== diff -u -r13906 -r13989 --- ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodBatchStockManagerImpl.java (.../DiposableGoodBatchStockManagerImpl.java) (revision 13906) +++ ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodBatchStockManagerImpl.java (.../DiposableGoodBatchStockManagerImpl.java) (revision 13989) @@ -137,7 +137,7 @@ "d.specification", specification)); String sql = String.format(" where %s and %s and %s ", SqlUtils .getLongFieldPredicate("po.warehouseID", warehouseId), SqlUtils - .getNonStringFieldPredicate("po.disposableGoodsID", + .getNonStringFieldPredicate("po.disposableGoodsId", disposableGoodsSql), SqlUtils .getStringFieldPredicate("po.batchNumber", batchNumber.trim()));