Index: ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/RecyclingApplicationManagerImpl.java =================================================================== diff -u -r13497 -r13515 --- ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/RecyclingApplicationManagerImpl.java (.../RecyclingApplicationManagerImpl.java) (revision 13497) +++ ssts-recyclingapplication/src/main/java/com/forgon/disinfectsystem/recyclingapplication/service/RecyclingApplicationManagerImpl.java (.../RecyclingApplicationManagerImpl.java) (revision 13515) @@ -3655,7 +3655,7 @@ //一次性物品 if(diposableGoodMap != null && diposableGoodMap.size() > 0){ //一次性物品处理 - String disposableHandleSql = "select cd.cssdOrgUnitCode,cd.cssdOrgUnitName,ct.tousseName from CssdServiceDepts cd join CssdHandleTousses ct on cd.cssdOrgUnitCode=ct.orgUnitCode " + String disposableHandleSql = "select cd.cssdOrgUnitCode,cd.cssdOrgUnitName from CssdServiceDepts cd " +" where cd.tousseType='" + CssdServiceDepts.TOUSSETYPE_DIPOSABLEGOODS + "' and cd.clinicOrgUnitCode='" + departCoding + "' "; ResultSet rs = null; List disposableGoodsHandlelist = new ArrayList();