Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java
===================================================================
diff -u -r29380 -r29392
--- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java	(.../TousseInstanceManagerImpl.java)	(revision 29380)
+++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java	(.../TousseInstanceManagerImpl.java)	(revision 29392)
@@ -6604,18 +6604,17 @@
 
                 + " union "
 
-                + "(select tdancestor.id ,null depart,tdancestor.name tousseName,null,s.sterilizationMode sterilingMode,null,ti.taskGroup taskGroup,"
+                + "(select tdancestor.id ,null depart,tdancestor.name tousseName,null,ti.sterilingMode sterilingMode,null,ti.taskGroup taskGroup,"
                 + firstBarcodeSql
                 + "barcode,null reviewTime,count(0) amount, max(tdancestor.includeImplant) " 
                 + nullSql
                 + " from "+ TousseInstance.class.getSimpleName() +" ti "
                 + " join "+ BarcodeDevice.class.getSimpleName() +" b on b.id=ti.id "
                 + "join "+ TousseDefinition.class.getSimpleName() +" td on ti.tousseDefinition_id=td.id join "+ TousseDefinition.class.getSimpleName() +" tdancestor "
                 + "on td.ancestorID=tdancestor.id left join "+ InvoicePlan.class.getSimpleName() +" pd on pd.id=ti.proxyDisinfection_id "
-                + " join " + Sterilisation.class.getSimpleName() + " s on s.sterilisation = td.sterilingMethod"
                 + " where 1=1 and tdancestor.isTraceable='"+ Constants.STR_NO +"' and ti.status='"+ TousseInstance.STATUS_REVIEWED +"' and ti.comboTousseInstanceId is null "
                 + dateSql
-                + " and ti.reviewBasket_id is null and (pd.id is null and ti.orgunitcoding='"+orgUnitCode+"' or pd.id is not null and pd.handleDepartCoding='"+orgUnitCode+"') group by tdancestor.id,tdancestor.name,ti.taskGroup,s.sterilizationMode"
+                + " and ti.reviewBasket_id is null and (pd.id is null and ti.orgunitcoding='"+orgUnitCode+"' or pd.id is not null and pd.handleDepartCoding='"+orgUnitCode+"') group by tdancestor.id,tdancestor.name,ti.taskGroup,ti.sterilingMode"
                 + "))t";
         if(StringUtils.isNotBlank(extraOrder)){
         	sql += " order by " + extraOrder;  	
Index: ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/action/SterilizationRecordAction.java
===================================================================
diff -u -r29365 -r29392
--- ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/action/SterilizationRecordAction.java	(.../SterilizationRecordAction.java)	(revision 29365)
+++ ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/action/SterilizationRecordAction.java	(.../SterilizationRecordAction.java)	(revision 29392)
@@ -1039,6 +1039,7 @@
                                     returnDataJsonObject.put("fixedBarcode", fixedBarcode);
                                     TousseDefinition td = tousseDefinitionManager.getTousseDefinitionByFixedBarcode(fixedBarcode);
                                     returnDataJsonObject.put("stockAmount",  tousseInstanceManager.getTousseInstanceStockAmount(td));
+                                    returnDataJsonObject.put("sterilingMode", tousseInstance.getSterilingMode());
                                 }else{
 									returnDataJsonObject.put("sterilingType", tousseInstance.getSterilingType());
 									returnDataJsonObject.put("depart", StringUtils.defaultString(tousseInstance.getDepart()," "));