Index: ssts-qualitymon/src/main/java/com/forgon/disinfectsystem/qualitymonitoring/definition/service/QualityMonitoringDefinitionManagerImpl.java =================================================================== diff -u -r27374 -r29601 --- ssts-qualitymon/src/main/java/com/forgon/disinfectsystem/qualitymonitoring/definition/service/QualityMonitoringDefinitionManagerImpl.java (.../QualityMonitoringDefinitionManagerImpl.java) (revision 27374) +++ ssts-qualitymon/src/main/java/com/forgon/disinfectsystem/qualitymonitoring/definition/service/QualityMonitoringDefinitionManagerImpl.java (.../QualityMonitoringDefinitionManagerImpl.java) (revision 29601) @@ -91,6 +91,8 @@ sql += " and po.responsibilityPart = '" + responsiblePerson + "'"; } sql += " and (po.isDisabled is null or po.isDisabled = '' or po.isDisabled = '" + Constants.STR_NO + "')"; + // KPSZXYY-44(查询最新版本的监测项) + sql += " and po.version = (select max(version) from QualityMonitoringDefinition where formName = po.formName)"; sql += " order by sortNumber asc "; return objectDao.findBySql(QualityMonitoringDefinition.class.getSimpleName(),sql); }