Index: ssts-userecord/src/main/java/com/forgon/disinfectsystem/useRecord/dwr/table/UseRecordTableManager.java =================================================================== diff -u -r35854 -r35913 --- ssts-userecord/src/main/java/com/forgon/disinfectsystem/useRecord/dwr/table/UseRecordTableManager.java (.../UseRecordTableManager.java) (revision 35854) +++ ssts-userecord/src/main/java/com/forgon/disinfectsystem/useRecord/dwr/table/UseRecordTableManager.java (.../UseRecordTableManager.java) (revision 35913) @@ -157,7 +157,7 @@ if(seeCssdServiceDepart && supplyRoomConfigManager.isSecondSupplyRoomOrgUnit(loginUser.getCurrentOrgUnitCode())){ //查询供应室服务临床科室及供应室的使用记录 - sql += " and exists (select 1 from " + CssdServiceDepts.class.getSimpleName() + sql += " and (exists (select 1 from " + CssdServiceDepts.class.getSimpleName() + " where cssdOrgUnitCode = '" + loginUser.getCurrentOrgUnitCode() + "' " + " and (clinicOrgUnitCode = po.departCoding or cssdOrgUnitCode = po.departCoding)) "; }else{