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);
|
}
|
}
|
|
}
|
}
|
