Index: ssts-operationmonitor/src/main/java/com/forgon/disinfectsystem/supplyroomcontrol/service/RaRoomControlHelper.java =================================================================== diff -u -r18584 -r18757 --- ssts-operationmonitor/src/main/java/com/forgon/disinfectsystem/supplyroomcontrol/service/RaRoomControlHelper.java (.../RaRoomControlHelper.java) (revision 18584) +++ ssts-operationmonitor/src/main/java/com/forgon/disinfectsystem/supplyroomcontrol/service/RaRoomControlHelper.java (.../RaRoomControlHelper.java) (revision 18757) @@ -96,7 +96,7 @@ String unionWhere = this.buildUnionSql(supplyRoomVo); whereSql += " union " + unionWhere + ") po where 1=1 "; if (StringUtils.isNotBlank(departCoding)) { - whereSql += " and po.depart = '" + departCoding + "'"; + whereSql += " and po.\"depart\" = '" + departCoding + "'"; } if (StringUtils.isNotBlank(taskGroup) && !"全部".equals(taskGroup)) { whereSql += String.format(" and po.tousseDefinitionId in (select cht.tousseDefinitionId from CssdHandleTousses cht where cht.taskGroup = '%s' and cht.orgUnitCode = '%s')", taskGroup, AcegiHelper.getLoginUser().getCurrentOrgUnitCode());