Index: ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/consumptivematerial/controller/SteriConsumeMaterialUseRecordController.java
===================================================================
diff -u -r34648 -r34665
--- ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/consumptivematerial/controller/SteriConsumeMaterialUseRecordController.java	(.../SteriConsumeMaterialUseRecordController.java)	(revision 34648)
+++ ssts-maintain/src/main/java/com/forgon/disinfectsystem/maintain/device/consumptivematerial/controller/SteriConsumeMaterialUseRecordController.java	(.../SteriConsumeMaterialUseRecordController.java)	(revision 34665)
@@ -122,7 +122,7 @@
 			
 			if(rowCount > 0){
 				String pageColumnName = "id";
-				String orderSql = " order by createDateTime desc ";
+				String orderSql = " order by id desc ";
 				int start = (pageNow-1) * pageSize;
 				int limit = pageSize;
 				
@@ -150,7 +150,7 @@
 						+ "left join %s dgb on dgb.id = urd.disposableGoodsBatchId "
 						+ "left join %s sr on sr.id = ur.sterilizationRecordId "
 						+ "left join %s st on st.id = sr.sterilizer_id "
-						+ "where ur.id in (%s) %s",
+						+ "where ur.id in (%s) order by ur.id desc",
 						SteriConsumeMaterialUseRecord.class.getSimpleName(),
 						SteriConsumeMaterialUseDetail.class.getSimpleName(),
 						DisposableGoods.class.getSimpleName(),
@@ -216,6 +216,7 @@
 					}
 				} catch (Exception e) {
 					e.printStackTrace();
+					result = "加载失败：" + e.getMessage();
 				} finally {
 					DatabaseUtil.closeResultSetAndStatement(rs);
 				}
@@ -240,7 +241,7 @@
 		if(start == 0){
 			querySqlByPage.append("select top "+ limit +" * from ("+ querySql +") t");
 		}else{
-			querySqlByPage.append("select top "+ (start + limit) +" * from ("+ querySql +") t ");
+			querySqlByPage.append("select top "+ limit +" * from ("+ querySql +") t ");
 			querySqlByPage.append("where "+ pageColumnName +" not in (select top "+ (start) +" "+ pageColumnName +" from ("+ querySql +") t0 " + orderSql + " )");
 		}
 		querySqlByPage.append(orderSql);