sb

alielie

2025-03-03 f90615921589586c1f9efde22620b45243d94657

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
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 RoleHelper
    {
        /// <summary>
        /// 根据roleCode获取rel数据
        /// </summary>
        /// <param name="sqliteHelper"></param>
        /// <param name="roleCode"></param>
        /// <returns></returns>
        public static ObservableCollection<RoleData> SelectUserRoleData(SqliteHelper sqliteHelper,
            string roleCode)
        {
            ObservableCollection<RoleData> datas = new ObservableCollection<RoleData>();
            DataTable dt = sqliteHelper.GetDataTable($@"SELECT * FROM role AS r ;");
            if (dt != null)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    var role = new RoleData
                    {
                        Id = dr["id"].ToString(),
                        Code = dr["code"].ToString(),
                        Name = dr["name"].ToString()
                    };
                    datas.Add(role);
                }
            }
            return datas;
        }
 
        public static void SaveRelData(SqliteHelper sqliteHelper, ObservableCollection<RoleMenuRel> rels, string roleCode)
        {
            List<RoleMenuRel> datas = new List<RoleMenuRel>();
            GetSelectedMenu(rels, datas);
            List<string> sqls = new List<string>() {
                $"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}');");
            }
            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);
            }
        }
 
    }
}