From 930d29f39d115fe76c305af4320c2acbcb30c445 Mon Sep 17 00:00:00 2001
From: czt <czt18638530771@163.com>
Date: 星期四, 12 六月 2025 10:37:37 +0800
Subject: [PATCH] 优化SQL
---
igds-core/src/main/java/com/ld/igds/view/service/DeviceSerService.java | 2 +-
1 files changed, 1 insertions(+), 1 deletions(-)
diff --git a/igds-core/src/main/java/com/ld/igds/view/service/DeviceSerService.java b/igds-core/src/main/java/com/ld/igds/view/service/DeviceSerService.java
index 2442e8f..07caffb 100644
--- a/igds-core/src/main/java/com/ld/igds/view/service/DeviceSerService.java
+++ b/igds-core/src/main/java/com/ld/igds/view/service/DeviceSerService.java
@@ -68,7 +68,7 @@
companyId = ContextUtil.getCompanyId();
String hql = " from " + DeviceSer.class.getName()
- + " where companyId=:companyId order by id + 0";
+ + " where companyId=:companyId order by type,id + 0";
Map<String, Object> param = new HashMap<String, Object>();
param.put("companyId", companyId);
--
Gitblit v1.9.3