Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/instrumentinstance/service/InstrumentInstanceManagerImpl.java
===================================================================
diff -u -r34700 -r34701
--- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/instrumentinstance/service/InstrumentInstanceManagerImpl.java	(.../InstrumentInstanceManagerImpl.java)	(revision 34700)
+++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/instrumentinstance/service/InstrumentInstanceManagerImpl.java	(.../InstrumentInstanceManagerImpl.java)	(revision 34701)
@@ -1708,7 +1708,7 @@
 			int start = (pageNum - 1) * pageSize;
 			int limit = pageSize;
 			if(dbConnection.isSqlServer()){
-				querySql = getSqlServerQuerySqlByPage(querySql, start, limit, "id", "");
+				querySql = getSqlServerQuerySqlByPage(querySql, start, limit, "id", " order by id ");
 			}else if(dbConnection.isOracle()){
 				querySql = SqlUtils.getOracleQuerySqlByPage(querySql, start, limit);
 			}