Index: ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/service/SterilizationRecordManagerImpl.java =================================================================== diff -u -r36368 -r36376 --- ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/service/SterilizationRecordManagerImpl.java (.../SterilizationRecordManagerImpl.java) (revision 36368) +++ ssts-sterile/src/main/java/com/forgon/disinfectsystem/sterilizationmanager/sterilizationrecord/service/SterilizationRecordManagerImpl.java (.../SterilizationRecordManagerImpl.java) (revision 36376) @@ -2077,6 +2077,10 @@ ResultSet rs = null; try { rs = objectDao.executeSql(sql); + boolean queryUrgentLevel_id = false; + if(enableUrgentFunction){ + queryUrgentLevel_id = SqlUtils.isExistColumn(rs, "urgentLevel_id"); + } while(rs.next()){ Long id = rs.getLong("id"); String tiStatus = rs.getString("status"); @@ -2088,7 +2092,7 @@ String tousseName = rs.getString("tousseName"); tdIdSet.add(tousseDefinition_id); TousseInstance ti = new TousseInstance(); - if(enableUrgentFunction && SqlUtils.isExistColumn(rs, "urgentLevel_id")){ + if(enableUrgentFunction && queryUrgentLevel_id){ Long urgentLevel_id = rs.getLong("urgentLevel_id"); if(DatabaseUtil.isPoIdValid(urgentLevel_id)){ UrgentLevel urgentLevel = new UrgentLevel();