Index: ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/service/SterilizationRecordManagerImpl.java
===================================================================
diff -u -r35207 -r35266
--- ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/service/SterilizationRecordManagerImpl.java	(.../SterilizationRecordManagerImpl.java)	(revision 35207)
+++ ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/service/SterilizationRecordManagerImpl.java	(.../SterilizationRecordManagerImpl.java)	(revision 35266)
@@ -2534,13 +2534,13 @@
         	return;
         }
 		String sql = "select dg.name,dg.specification from SteriliPurposeDisposableGoods s "
-				+ " join DisposableGoods dg on dg.id=s.disposableGoodsId where disposableGoodsId not in (select d.disposableGoodsId from SteriConsumeMaterialUseRecord r "
+				+ " join DisposableGoods dg on dg.id=s.disposableGoodsId where sterilizationPurposeId="+ httpOption.getId() +" and disposableGoodsId not in (select d.disposableGoodsId from SteriConsumeMaterialUseRecord r "
 				+ "join SteriConsumeMaterialUseDetail d on d.useRecord_id=r.id "
 				+ "where r.sterilizationRecordId="+sterilizationRecordId;
 		if(CollectionUtils.isNotEmpty(deleteDetailIds)){
 			sql += " and " + SqlUtils.getNonStringFieldNotInCollectionsPredicate("d.id", deleteDetailIds);
 		}
-		sql += " and sterilizationPurposeId=" +httpOption.getId() + ") ";
+		sql += " and r.sterilizationPurpose='" +httpOption.getOptionText() + "' ) ";
 		if(CollectionUtils.isNotEmpty(addDisposableGoodsIds)){
 			sql += " and " + SqlUtils.getNonStringFieldNotInCollectionsPredicate("s.disposableGoodsId", addDisposableGoodsIds);
 		}