Index: ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodsManagerImpl.java =================================================================== diff -u -r15308 -r15376 --- ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodsManagerImpl.java (.../DiposableGoodsManagerImpl.java) (revision 15308) +++ ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodsManagerImpl.java (.../DiposableGoodsManagerImpl.java) (revision 15376) @@ -945,11 +945,11 @@ String sql = ""; if (dbConnection.isSqlServer()) { - sql = "select * from (select top 1 d.cost from DisposableGoodsBatchStock d where d.diposableGoods_id = " + sql = "select * from (select top 1 d.cost from DisposableGoodsBatchStock d where d.disposableGoodsId = " + disposableGoods.getId() + " and storage > 0 order by d.id asc) as temp"; } else if (dbConnection.isOracle()) { - sql = "select * from (select d.cost from DisposableGoodsBatchStock d where d.diposableGoods_id = " + sql = "select * from (select d.cost from DisposableGoodsBatchStock d where d.disposableGoodsId = " + disposableGoods.getId() + " and storage > 0 order by d.id asc) where rownum =1"; }