新增DOControl

alielie

2025-03-23 40014e6e41f1ec017a07b7a620b3c700807d0519

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Markup;
using DatabaseHelper;
using HMI.Core.Util;
using HMI.MenuManage.Entity;
 
namespace HMI.MenuManage.Util
{
    public class RoleMenuHelper
    {
        /// <summary>
        /// 根据roleCode获取rel数据
        /// </summary>
        /// <param name="sqliteHelper"></param>
        /// <param name="roleCode"></param>
        /// <returns></returns>
        public static ObservableCollection<RoleMenuRel> SelectRoleMenuTreeData(SqliteHelper sqliteHelper,
            string roleCode)
        {
            ObservableCollection<RoleMenuRel> treeData = new ObservableCollection<RoleMenuRel>();
            Dictionary<string, RoleMenuRel> cache = new Dictionary<string, RoleMenuRel>();
            DataTable dt = sqliteHelper.GetDataTable($@"SELECT m.*,t.roleCode,t.menuCode FROM menu AS m 
LEFT JOIN (
SELECT rel.roleCode,rel.menuCode FROM role AS r 
INNER JOIN role_menu_rel AS rel 
ON r.code = rel.roleCode AND rel.roleCode='{roleCode}'
) AS t
ON m.code=t.menuCode
Order By m.level,m.id;");
            if (dt != null)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    var menu = new RoleMenuRel
                    {
                        MenuCode = dr["code"].ToString(),
                        RoleCode = roleCode,
                        ParentCode = dr["parentCode"].ToString(),
                        MenuName = dr["name"].ToString(),
                        MenuIcon = dr["iconPath"].ToString(),
                        Selected = !(dr["menuCode"] is System.DBNull),
                    };
                    cache[menu.MenuCode] = menu;
                    if (cache.ContainsKey(menu.ParentCode))
                    {
                        cache[menu.ParentCode].AddChild(menu);
                    }
                    else
                    {
                        treeData.Add(menu);
                    }
                }
            }
            return treeData;
        }
 
        public static void SaveRelData(SqliteHelper sqliteHelper, IEnumerable<RoleMenuRel> rels, string roleCode, string firstSql, string lastSql)
        {
            List<RoleMenuRel> datas = new List<RoleMenuRel>();
            GetSelectedMenu(rels, datas);
            List<string> sqls = new List<string>() {
                firstSql, $"DELETE FROM role_menu_rel WHERE roleCode='{roleCode}'"
            };
            foreach (var data in datas)
            {
                sqls.Add($"INSERT INTO role_menu_rel (roleCode,menuCode) VALUES ('{roleCode}','{data.MenuCode}');");
            }
            sqls.Add(lastSql);
            sqliteHelper.ExecuteBatchSql(sqls);
        }
 
        public static void GetSelectedMenu(IEnumerable<RoleMenuRel> rels, List<RoleMenuRel> datas)
        {
            foreach (var dr in rels)
            {
                if (dr.Selected)
                {
                    datas.Add(dr);
                }
                GetSelectedMenu(dr.Children, datas);
            }
        }
 
    }
}