From dedcf4174c8540ee3a912daad2ff13e014e495b1 Mon Sep 17 00:00:00 2001
From: alielie <alielie@git.com>
Date: 星期五, 28 三月 2025 16:28:30 +0800
Subject: [PATCH] 优化UI组件;

---
 HMI.MenuManage/Model/MenuManageModel.cs |    9 ++++++---
 1 files changed, 6 insertions(+), 3 deletions(-)

diff --git a/HMI.MenuManage/Model/MenuManageModel.cs b/HMI.MenuManage/Model/MenuManageModel.cs
index e12f5a6..95b9212 100644
--- a/HMI.MenuManage/Model/MenuManageModel.cs
+++ b/HMI.MenuManage/Model/MenuManageModel.cs
@@ -48,12 +48,14 @@
                     id INTEGER PRIMARY KEY AUTOINCREMENT,
                     code TEXT NOT NULL,
                     name TEXT NOT NULL,
+                    icon TEXT,
                     iconPath TEXT,
                     level TEXT,
                     type TEXT,
                     parentCode TEXT,
                     dllPath TEXT,
                     className TEXT,
+                    sort REAL,
                     UNIQUE(code)
                     );");
         }
@@ -62,7 +64,7 @@
         {
             ObservableCollection<MenuData> data = new ObservableCollection<MenuData>();
             ObservableCollection<MenuData> treeData = new ObservableCollection<MenuData>();
-            DataTable dt = sqliteHelper.GetDataTable("SELECT m1.*,m2.name AS parentName FROM menu AS m1 LEFT JOIN menu AS m2 ON m1.parentCode = m2.code Order By m1.id;");
+            DataTable dt = sqliteHelper.GetDataTable("SELECT m1.*,m2.name AS parentName FROM menu AS m1 LEFT JOIN menu AS m2 ON m1.parentCode = m2.code Order By m1.sort,m1.id;");
             Dictionary<string, MenuData> cache = new Dictionary<string, MenuData>();
             if (dt != null)
             {
@@ -73,13 +75,14 @@
                         Id = dr["id"].ToString(),
                         Code = dr["code"].ToString(),
                         Name = dr["name"].ToString(),
-                        IconPath = dr["iconPath"].ToString(),
+                        Icon = dr["icon"].ToString(),
                         Level = dr["level"].ToString(),
                         Type = dr["type"].ToString(),
                         ParentCode = dr["parentCode"].ToString(),
                         ParentName = dr["parentName"].ToString(),
                         DllPath = dr["dllPath"].ToString(),
-                        ClassName = dr["className"].ToString()
+                        ClassName = dr["className"].ToString(),
+                        Sort = dr["sort"] == DBNull.Value ? 0 : double.Parse(dr["sort"].ToString()),
                     };
                     data.Add(menu);
                     if (menu.Level == "1")

--
Gitblit v1.9.1