Index: ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodsManagerImpl.java =================================================================== diff -u -r13956 -r13984 --- ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodsManagerImpl.java (.../DiposableGoodsManagerImpl.java) (revision 13956) +++ ssts-diposablegoods/src/main/java/com/forgon/disinfectsystem/diposablegoods/service/DiposableGoodsManagerImpl.java (.../DiposableGoodsManagerImpl.java) (revision 13984) @@ -1128,6 +1128,10 @@ if(objectDao.countObjectBySql(DisposableGoodsIdentification.class.getSimpleName(), sql) > 0){ throw new RuntimeException("物品定义有关联的库存对象,不能被删除!"); } + sql = String.format(" where %s", SqlUtils.getStringFieldInCollectionsPredicate("po.disposableGoodsID", idsSet)); + if(objectDao.countObjectBySql(ExpensiveDisposablegoods.class.getSimpleName(), sql) > 0){ + throw new RuntimeException("物品定义有关联的高值耗材对象,不能被删除!"); + } String deleteSql = String.format("delete from %s where %s",DisposableGoods.class.getSimpleName(), SqlUtils.getStringFieldInCollectionsPredicate("id", idsSet)); objectDao.executeUpdate(deleteSql); // for (String id : ids.split(";")) {