Index: ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java =================================================================== diff -u -r29529 -r30229 --- ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java (.../TousseInstanceTableManager.java) (revision 29529) +++ ssts-packing/src/main/java/com/forgon/disinfectsystem/packing/dwr/table/TousseInstanceTableManager.java (.../TousseInstanceTableManager.java) (revision 30229) @@ -749,7 +749,7 @@ } List sortOrder = new ArrayList(); sortOrder.add("desc"); - parameterMap.put("grid_sort_urgentLevel.grade desc,po.id", sortOrder); + parameterMap.put("grid_sort_case when urgentLevel.grade is null then 0 else urgentLevel.grade end desc,po.id", sortOrder); } } //hql语句:where