using MySql.Data.MySqlClient;
|
using System;
|
using System.Collections.ObjectModel;
|
using System.Data;
|
using XCommon.Log;
|
using XCommon.MySql;
|
using DataRWDAL.Base;
|
using System.Collections.Generic;
|
using DataEntity.User;
|
using System.Web.UI.WebControls;
|
using SqlSugar;
|
using XHandler.Class;
|
using System.Linq;
|
using DataRWDAL;
|
using DataEntity.UserManager;
|
namespace XImagingXhandler.XDAL
|
{
|
/// <summary>
|
/// 用户表读写操作
|
/// </summary>
|
public class UserDB:BaseDB
|
{
|
#region 检查用户、密码是否存在
|
/// <summary>
|
/// 检查用户、密码是否存在
|
/// </summary>
|
/// <param name="username"></param>
|
/// <param name="password"></param>
|
/// <returns></returns>
|
public static bool isExistUserByUserInfo(string username, string password = "")
|
{
|
bool isExistUser = false;
|
|
using (var db = GetInstance())
|
{
|
if (password != "")
|
{
|
var query = db.Queryable<UserInfo>().Where(it => it.status.Equals(1) && it.username.Equals(username) && it.userpwd.Equals(password)).ToList();
|
if (query != null && query.Count > 0)
|
{
|
isExistUser = true;
|
}
|
else
|
{
|
isExistUser = false;
|
}
|
}
|
else
|
{
|
var query = db.Queryable<UserInfo>().Where(it => it.status.Equals(1) && it.username.Equals(username)).ToList();
|
if (query != null && query.Count > 0)
|
{
|
isExistUser = true;
|
}
|
else
|
{
|
isExistUser = false;
|
}
|
}
|
}
|
return isExistUser;
|
}
|
#endregion
|
|
#region 根据用户名返回用户信息
|
/// <summary>
|
/// 根据用户名返回用户信息
|
/// </summary>
|
/// <param name="username">用户名</param>
|
/// <returns>用户信息</returns>
|
public static UserInfo GetUserInfByUserName(string username)
|
{
|
UserInfo user = null;
|
string sqlstr = string.Empty;
|
using (var db = GetInstance())
|
{
|
var query = db.Queryable<UserInfo>().Where(it => it.status.Equals(1) && it.username.Equals(username)).Single();
|
return query;
|
}
|
}
|
#endregion
|
|
#region 根据用户Id返回用户信息
|
/// <summary>
|
/// 根据用户Id返回用户信息
|
/// </summary>
|
/// <param name="userId">用户Id</param>
|
/// <returns>用户信息</returns>
|
public static UserInfo GetUserInfByUserId(string userId)
|
{
|
UserInfo user = null;
|
string sqlstr = string.Empty;
|
using (var db = GetInstance())
|
{
|
var query = db.Queryable<UserInfo>().Where(it => it.status.Equals(1) && it.id.Equals(userId)).Single();
|
return query;
|
}
|
}
|
#endregion
|
|
|
#region 根据返回用户信息列表
|
/// <summary>
|
/// 根据用户Id返回用户信息
|
/// </summary>
|
/// <returns>用户信息集合</returns>
|
public static List<UserInfo> GetAllUserInfo()
|
{
|
List<UserInfo> userList = null;
|
string sqlstr = string.Empty;
|
using (var db = GetInstance())
|
{
|
//var query = db.Queryable<UserInfo,RoleTab>().Where((it,im) =>it.authority==im.role_id && it.status.Equals(1)).ToList();
|
var query = db.Queryable("t_userinfo", "t").AddJoinInfo("t_roles", "l", "t.authority=l.Id", JoinType.Inner)
|
.Select("t.*,l.name");
|
if(query!=null)
|
{
|
userList = new List<UserInfo>();
|
foreach (var item in query.ToList())
|
{
|
UserInfo userInfo = new UserInfo();
|
foreach (var property in (IDictionary<string, object>)item)
|
{
|
//Console.WriteLine($"{property.Key}: {property.Value}");
|
|
//foreach (var property in item.GetType().GetProperties())
|
//{
|
var propertyName = property.Key.ToString();//property.Name.ToString();
|
var propertyValue = property.Value==null?"": property.Value.ToString();
|
if (propertyName == "Id")
|
{
|
userInfo.id = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "authority")
|
{
|
userInfo.authority = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "status")
|
{
|
userInfo.status = Convert.ToInt32(propertyValue.Trim() != "" ? propertyValue : "0");
|
continue;
|
}
|
if (propertyName == "username")
|
{
|
userInfo.username = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "userpwd")
|
{
|
userInfo.userpwd = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "truename")
|
{
|
userInfo.truename = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "loginstate")
|
{
|
userInfo.loginstate = Convert.ToInt32(propertyValue.Trim()!=""? propertyValue:"0");
|
continue;
|
}
|
if (propertyName == "logintime")
|
{
|
userInfo.logintime = Convert.ToDateTime(propertyValue.Trim() != "" ? propertyValue : "2022-10-09");
|
continue;
|
}
|
if (propertyName == "name")
|
{
|
userInfo.authorityname = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "department")
|
{
|
userInfo.department = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "phone")
|
{
|
userInfo.phone = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "email")
|
{
|
userInfo.email = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "EffectiveDate")
|
{
|
userInfo.EffectiveDate = Convert.ToDateTime(propertyValue.Trim() != "" ? propertyValue: "2022-10-09");
|
continue;
|
}
|
if (propertyName == "pcmac")
|
{
|
userInfo.pcmac = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "pcip")
|
{
|
userInfo.pcip = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "authorize")
|
{
|
userInfo.authorize = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "Remark")
|
{
|
userInfo.Remark = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "loginerrornum")
|
{
|
userInfo.loginerrornum = Convert.ToInt32(propertyValue.Trim() != "" ? propertyValue : "0");
|
continue;
|
}
|
if (propertyName == "LockTime")
|
{
|
userInfo.LockTime = Convert.ToDateTime(propertyValue.Trim() != "" ? propertyValue : "2022-10-09");
|
continue;
|
}
|
if (propertyName == "createname")
|
{
|
userInfo.createname = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "createtime")
|
{
|
userInfo.createtime = Convert.ToDateTime(propertyValue.Trim() != "" ? propertyValue: "2022-10-09");
|
continue;
|
}
|
if (propertyName == "modifyname")
|
{
|
userInfo.modifyname = propertyValue.ToString();
|
continue;
|
}
|
if (propertyName == "modifytime")
|
{
|
userInfo.modifytime = Convert.ToDateTime(propertyValue.Trim() != "" ? propertyValue : "2022-10-09");
|
continue;
|
}
|
|
}
|
userList.Add(userInfo);
|
}
|
}
|
}
|
return userList;
|
}
|
#endregion
|
|
#region 根据返回角色信息列表
|
/// <summary>
|
/// 根据返回角色信息列表
|
/// </summary>
|
/// <returns>角色信息集合</returns>
|
public static List<RoleTab> GetRoles()
|
{
|
List<RoleTab> userList = null;
|
string sqlstr = string.Empty;
|
using (var db = GetInstance())
|
{
|
var query = db.Queryable<RoleTab>().ToList();
|
userList = query;
|
}
|
return userList;
|
}
|
#endregion
|
|
/// <summary>
|
/// 获取所有权限列表
|
/// </summary>
|
/// <returns></returns>
|
public static List<RolesModel> GetAllRoles()
|
{
|
using (var db = GetInstance())
|
{
|
List<RolesModel> list = db.Queryable<RolesModel>().ToList();
|
foreach (var role in list)
|
{
|
if (role.Type == "0")
|
role.TypeName = "锁定";
|
else
|
role.TypeName = "正常";
|
}
|
|
return list;
|
}
|
}
|
|
#region 修改一条新的角色数据 by 角色数据
|
/// <summary>
|
/// 修改一条新的角色数据 by 角色数据
|
/// </summary>
|
/// <param name="liquid">角色数据</param>
|
/// <returns>1:成功；0：失败</returns>
|
public static int UpdateRoleIntodb(RoleTab roleTab)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Updateable<RoleTab>(roleTab).ExecuteCommand();
|
}
|
}
|
#endregion
|
|
#region 添加一条新的用户数据 by 用户数据
|
/// <summary>
|
/// 添加一条新的用户数据 by 用户数据
|
/// </summary>
|
/// <param name="userInfo">用户数据</param>
|
/// <returns>1:成功；0：失败</returns>
|
public static int AddUserIntodb(UserInfo userInfo)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Insertable<UserInfo>(userInfo).ExecuteCommand();
|
}
|
}
|
#endregion
|
|
#region 修改一条新的用户数据 by 用户数据
|
/// <summary>
|
/// 修改一条新的用户数据 by 用户数据
|
/// </summary>
|
/// <param name="userInfo">用户数据</param>
|
/// <returns>1:成功；0：失败</returns>
|
public static int UpdateUserIntodb(UserInfo userInfo)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Updateable<UserInfo>(userInfo).ExecuteCommand();
|
}
|
}
|
#endregion
|
|
#region 删除
|
/// <summary>
|
/// 删除
|
/// </summary>
|
/// <param name="id"></param>
|
/// <returns></returns>
|
public static bool DelUserById(string id)
|
{
|
#region AddLog
|
|
#endregion
|
using (var db = GetInstance())
|
{
|
var query = GetUserInfByUserId(id);
|
query.status = 0;
|
var result = db.Updateable<UserInfo>(query).ExecuteCommand();
|
if(result>0)
|
{
|
return true;
|
}
|
}
|
return false;
|
}
|
#endregion
|
|
public static List<UserInfo> Search(string name, string phone, string state, string authority)
|
{
|
var result = GetAllUserInfo();
|
if (string.IsNullOrEmpty(name) && string.IsNullOrEmpty(phone) && string.IsNullOrEmpty(state) && string.IsNullOrEmpty(authority))
|
{
|
if (result != null)
|
{
|
return result.ToList();
|
}
|
}
|
|
if (!string.IsNullOrEmpty(authority))
|
result = result.Where(s => s.authority == authority).ToList();
|
if (result == null)
|
return null;
|
|
if (!string.IsNullOrEmpty(state))
|
result = result.Where(s => s.status == Convert.ToInt32(state)).ToList();
|
if (result == null)
|
return null;
|
|
if (!string.IsNullOrEmpty(phone))
|
result = result.Where(s => s.phone != null && s.phone.Contains(phone)).ToList();
|
if (result == null)
|
return null;
|
|
if (!string.IsNullOrEmpty(name))
|
result = result.Where(s => s.username.Contains(name)).ToList();
|
if (result == null)
|
return null;
|
|
return result.ToList();
|
}
|
|
#region 获取用户所在的角色权限菜单
|
/// <summary>
|
/// 获取用户所在的角色权限菜单
|
/// </summary>
|
/// <param name="userId">用户Id</param>
|
/// <returns></returns>
|
public static List<RoleMenu> GetRoleMenuByUserId(string userId)
|
{
|
roleAllMenus = new List<RoleMenu>();
|
string sqlText = "select r.Name,r.MenuId from t_userinfo t, t_roles r where t.authority=r.Id and t.Id='" + userId + "' and t.status=1";
|
try
|
{
|
using (var db = GetInstance())
|
{
|
// 多表查询
|
var query = db.Queryable<RoleTab, UserInfo>
|
(
|
(sc, st) =>
|
new JoinQueryInfos(JoinType.Inner, st.authority == sc.role_id)
|
)
|
.Where((sc, st) => st.id == userId && st.status == 1).Single();
|
if (query != null)
|
{
|
|
//string menuIdTxts = query.GetType().GetProperties()[].ToString();
|
string menuIdTxts = string.Empty;
|
menuIdTxts = query.menu_id.ToString();
|
if (menuIdTxts != "")
|
{
|
string[] menuIdArray = menuIdTxts.Split(',');
|
for (int i = 0; i < menuIdArray.Length; i++)
|
{
|
if (!menuIdArray[i].Equals(""))
|
{
|
RoleMenu roleMenu = new RoleMenu();
|
roleMenu = GetARoleRealMenu(menuIdArray[i], menuIdTxts);
|
roleAllMenus.Add(roleMenu);
|
}
|
}
|
|
//所有权限菜单序列化成Json文件
|
//string j = JsonConvert.SerializeObject(roleAllMenus);
|
//resultRoleMenu = JObject.Parse(j);
|
}
|
}
|
}
|
|
//MySqlCommand sqlcom = new MySqlCommand();
|
//MySqlParameter[] commandParameters;
|
//sqlcom.CommandText = sqlText;
|
//commandParameters = new MySqlParameter[0];
|
//MySqlConnection mysqlcon = MySqlHelper.GetConnection();
|
//DataTable dt = MySqlHelper.GetDataTable(mysqlcon.ConnectionString, CommandType.Text, sqlcom.CommandText, commandParameters);
|
|
//if (dt != null && dt.Rows.Count > 0)
|
//{
|
// if (dt.Rows[0]["MenuId"] != null)
|
// {
|
// string menuIdTxts = dt.Rows[0]["MenuId"].ToString();
|
// if (menuIdTxts != "")
|
// {
|
// string[] menuIdArray = menuIdTxts.Split(',');
|
// for (int i = 0; i < menuIdArray.Length; i++)
|
// {
|
// if (!menuIdArray[i].Equals(""))
|
// {
|
// RoleMenu roleMenu = new RoleMenu();
|
// roleMenu = GetARoleMenu(menuIdArray[i]);
|
// roleAllMenus.Add(roleMenu);
|
// }
|
// }
|
|
// //所有权限菜单序列化成Json文件
|
// //string j = JsonConvert.SerializeObject(roleAllMenus);
|
// //resultRoleMenu = JObject.Parse(j);
|
// }
|
// }
|
//}
|
//else
|
//{
|
// //isExistUser = false;
|
//}
|
}
|
catch (MySqlException me)
|
{
|
LoggerHelper.ErrorLog("执行：" + sqlText, me);
|
}
|
|
return roleAllMenus;
|
}
|
#endregion
|
|
#region 获取用户所在的角色权限的菜单加工完整
|
static List<RoleMenu> roleAllMenuLists = null;
|
/// <summary>
|
/// 获取用户所在的角色权限的菜单加工完整
|
/// </summary>
|
/// <param name="userId">用户Id</param>
|
/// <returns></returns>
|
public static List<RoleMenu> GetWholeRoleMenuByUserId(string userId)
|
{
|
List<RoleMenu> roleMenuList = GetRoleMenuByUserId(userId);//当前角色的菜单
|
|
roleAllMenuLists = new List<RoleMenu>();
|
string sqlText = "select t.Id,t.Name,t.ChildrenId from t_menu t where t.Level=0 and t.state=1";
|
try
|
{
|
using (var db = GetInstance())
|
{
|
var query = db.Queryable<MenuTab>().Where(it => it.level.Equals(0)&&it.state.Equals(1));
|
|
if(query.Count() > 0)
|
{
|
for (int i = 0; i < query.Count(); i++)
|
{
|
RoleMenu roleMenu = new RoleMenu();
|
roleMenu = GetARoleMenu(query.ToList()[i].menu_id.ToString());
|
roleAllMenuLists.Add(roleMenu);
|
}
|
}
|
|
}
|
|
//清除不是该用户拥有的权限
|
if (roleAllMenuLists.Count > 0)
|
{
|
List<RoleMenu> mainMenu = new List<RoleMenu>();//未包含权限的主菜单
|
for (int i = 0; i < roleAllMenuLists.Count; i++)
|
{
|
int countSubMenu = 0;
|
if (roleAllMenuLists[i].rolemenuchildren != null && roleAllMenuLists[i].rolemenuchildren.Count > 0)
|
{
|
int subMenusNum = roleAllMenuLists[i].rolemenuchildren.Count;//子菜单的总数
|
List<RoleMenu> subMenu = new List<RoleMenu>();//未包含权限的子菜单
|
for (int j = 0; j < subMenusNum; j++)
|
{
|
if (roleMenuList.Exists(x => x.rolemenuid.Equals(roleAllMenuLists[i].rolemenuchildren[j].rolemenuid)))
|
{
|
countSubMenu++;
|
}
|
else
|
{
|
var mainAMenu = roleMenuList.FirstOrDefault(x => x.rolemenuid.Equals(roleAllMenuLists[i].rolemenuid));
|
if(mainAMenu !=null&& mainAMenu.rolemenuchildren.Exists(x=>x.rolemenuid.Equals(roleAllMenuLists[i].rolemenuchildren[j].rolemenuid)))
|
{
|
if (roleAllMenuLists[i].rolemenuchildren[j].rolemenuChildIds != "")
|
{
|
for (int k = 0; k < mainAMenu.rolemenuchildren.Count; k++)
|
{
|
var subAMenu = mainAMenu.rolemenuchildren.FirstOrDefault(x => x.rolemenuid.Equals(roleAllMenuLists[i].rolemenuchildren[j].rolemenuid));
|
if (subAMenu != null)
|
{
|
if (subAMenu.rolemenuChildIds == "")
|
{
|
roleAllMenuLists[i].rolemenuchildren[j].rolemenuchildren.Clear();
|
}
|
else
|
{
|
foreach (var m in roleAllMenuLists[i].rolemenuchildren[j].rolemenuchildren)
|
{
|
var q = subAMenu.rolemenuchildren.FirstOrDefault(x => x.rolemenuid.Equals(m.rolemenuid));
|
if (q != null)
|
{
|
|
}
|
else
|
{
|
roleAllMenuLists[i].rolemenuchildren[j].rolemenuchildren.Remove(m);
|
}
|
}
|
}
|
}
|
}
|
}
|
}
|
else
|
{
|
int countofSub = 0;
|
//查看看看是否包含子菜单
|
if(roleAllMenuLists[i].rolemenuchildren[j].rolemenuchildren!=null)
|
{
|
foreach(var m in roleAllMenuLists[i].rolemenuchildren[j].rolemenuchildren)
|
{
|
var n = roleMenuList.FirstOrDefault(x => x.rolemenuid.Equals(m.rolemenuid));
|
if(n!=null)
|
{
|
countofSub++;
|
countSubMenu++;
|
}
|
}
|
}
|
if (countofSub > 0)
|
{
|
|
}
|
else
|
{
|
subMenu.Add(roleAllMenuLists[i].rolemenuchildren[j]);
|
}
|
}
|
}
|
}
|
|
for (int k = 0; k < subMenu.Count; k++)
|
{
|
roleAllMenuLists[i].rolemenuchildren.Remove(subMenu[k]);
|
}
|
}
|
|
if (countSubMenu > 0)
|
{
|
continue;
|
}
|
else
|
{
|
if (roleMenuList.Exists(x => x.rolemenuid.Equals(roleAllMenuLists[i].rolemenuid)))
|
{
|
|
}
|
else
|
{
|
mainMenu.Add(roleAllMenuLists[i]);
|
}
|
}
|
}
|
|
for (int k = 0; k < mainMenu.Count; k++)
|
{
|
roleAllMenuLists.Remove(mainMenu[k]);
|
}
|
|
}
|
}
|
catch (MySqlException me)
|
{
|
LoggerHelper.ErrorLog("执行：" + sqlText, me);
|
}
|
|
return roleAllMenuLists;
|
}
|
#endregion
|
|
#region 根据菜单Id获取该菜单的实例对象
|
public static RoleMenu GetARoleMenu(string menuId)
|
{
|
RoleMenu roleMenu = new RoleMenu();
|
|
//string sqlText = "select t.Id,t.ChildrenId,t.Name,t.State=1 from t_menu t where t.Id='" + menuId + "'";
|
try
|
{
|
using (var db = GetInstance())
|
{
|
var query = db.Queryable<MenuTab>().Where(it => it.menu_id.Equals(menuId) ).Single();
|
|
if(query != null)
|
{
|
roleMenu.rolemenuid = query.menu_id.ToString();
|
roleMenu.rolemenuname = query.name.ToString();
|
roleMenu.rolemenuChildIds = query.children_id == null ? "" : query.children_id.ToString();
|
|
if (roleMenu.rolemenuChildIds.Length > 0)
|
{
|
roleMenu.rolemenuchildren = new List<RoleMenu>();
|
|
string[] childIds = roleMenu.rolemenuChildIds.Split(',');
|
for (int i = 0; i < childIds.Length; i++)
|
{
|
RoleMenu childMenu = new RoleMenu();
|
childMenu = GetARoleMenu(childIds[i]);
|
|
roleMenu.rolemenuchildren.Add(childMenu);
|
}
|
}
|
else
|
{
|
roleMenu.rolemenuChildIds = "";
|
}
|
}
|
else
|
{
|
roleMenu = null;
|
}
|
}
|
//MySqlCommand sqlcom = new MySqlCommand();
|
//MySqlParameter[] commandParameters;
|
//sqlcom.CommandText = sqlText;
|
//commandParameters = new MySqlParameter[0];
|
//MySqlConnection mysqlcon = MySqlHelper.GetConnection();
|
//DataTable dt = MySqlHelper.GetDataTable(mysqlcon.ConnectionString, CommandType.Text, sqlcom.CommandText, commandParameters);
|
|
//if (dt != null && dt.Rows.Count > 0)
|
//{
|
// if (dt.Rows[0]["Name"] != null)
|
// {
|
// roleMenu.rolemenuid = dt.Rows[0]["Id"].ToString();
|
// roleMenu.rolemenuname = dt.Rows[0]["Name"].ToString();
|
// roleMenu.rolemenuChildIds = dt.Rows[0]["ChildrenId"] == null ? "" : dt.Rows[0]["ChildrenId"].ToString();
|
|
// if (roleMenu.rolemenuChildIds.Length > 0)
|
// {
|
// roleMenu.rolemenuchildren = new List<RoleMenu>();
|
|
// string[] childIds = roleMenu.rolemenuChildIds.Split(',');
|
// for (int i = 0; i < childIds.Length; i++)
|
// {
|
// RoleMenu childMenu = new RoleMenu();
|
// childMenu = GetARoleMenu(childIds[i]);
|
|
// roleMenu.rolemenuchildren.Add(childMenu);
|
// }
|
// }
|
// else
|
// {
|
// roleMenu.rolemenuChildIds = "";
|
// }
|
// }
|
// else
|
// {
|
// roleMenu = null;
|
// }
|
//}
|
//else
|
//{
|
// roleMenu = null;
|
//}
|
}
|
catch (MySqlException me)
|
{
|
LoggerHelper.ErrorLog("执行：" , me);
|
}
|
return roleMenu;
|
}
|
#endregion
|
|
#region 根据菜单Id获取该菜单的实际权限实例对象
|
public static RoleMenu GetARoleRealMenu(string menuId,string menuIdsWith)
|
{
|
RoleMenu roleMenu = new RoleMenu();
|
|
//string sqlText = "select t.Id,t.ChildrenId,t.Name,t.State=1 from t_menu t where t.Id='" + menuId + "'";
|
try
|
{
|
using (var db = GetInstance())
|
{
|
var query = db.Queryable<MenuTab>().Where(it => it.menu_id.Equals(menuId)).Single();
|
|
if (query != null)
|
{
|
roleMenu.rolemenuid = query.menu_id.ToString();
|
roleMenu.rolemenuname = query.name.ToString();
|
roleMenu.rolemenuChildIds = query.children_id == null ? "" : query.children_id.ToString();
|
|
if (roleMenu.rolemenuChildIds.Length > 0)
|
{
|
roleMenu.rolemenuchildren = new List<RoleMenu>();
|
|
string[] childIds = roleMenu.rolemenuChildIds.Split(',');
|
for (int i = 0; i < childIds.Length; i++)
|
{
|
RoleMenu childMenu = new RoleMenu();
|
childMenu = GetARoleRealMenu(childIds[i],menuIdsWith);
|
if(menuIdsWith.Contains(childMenu.rolemenuid))
|
{
|
roleMenu.rolemenuchildren.Add(childMenu);
|
}
|
else
|
{
|
if(childMenu.rolemenuchildren!=null&&childMenu.rolemenuchildren.Count>0)
|
{
|
roleMenu.rolemenuchildren.Add(childMenu);
|
}
|
}
|
}
|
}
|
else
|
{
|
roleMenu.rolemenuChildIds = "";
|
}
|
}
|
else
|
{
|
roleMenu = null;
|
}
|
}
|
}
|
catch (MySqlException me)
|
{
|
LoggerHelper.ErrorLog("执行：", me);
|
}
|
return roleMenu;
|
}
|
#endregion
|
|
#region 根据角色Id获取该角色的实例对象
|
public static RoleTab GetARoleTab(string roleId)
|
{
|
RoleTab roleTab = null;
|
try
|
{
|
using (var db = GetInstance())
|
{
|
var query = db.Queryable<RoleTab>().Where(it => it.role_id.Equals(roleId)).Single();
|
roleTab = query;
|
}
|
}
|
catch (MySqlException me)
|
{
|
LoggerHelper.ErrorLog("执行：", me);
|
}
|
return roleTab;
|
}
|
#endregion
|
|
#region 获取系统内所有菜单对象
|
public static List<MenuTab> GetAllMenuTab()
|
{
|
List<MenuTab> menuTabs = null;
|
try
|
{
|
using (var db = GetInstance())
|
{
|
var query = db.Queryable<MenuTab>().ToList();
|
menuTabs = query;
|
}
|
}
|
catch (MySqlException me)
|
{
|
LoggerHelper.ErrorLog("执行：", me);
|
}
|
return menuTabs;
|
}
|
#endregion
|
|
#region 获取某个菜单下的子菜单数据
|
static List<RoleMenu> roleAllMenus = new List<RoleMenu>();//保存某个用户的所有菜单
|
public static List<RoleMenu> GetSubRolwMenus(string menuId)
|
{
|
List<RoleMenu> subRoleMenus = new List<RoleMenu>();
|
RoleMenu roleMenu = GetARoleMenu(menuId);
|
if (roleMenu.rolemenuChildIds != "")
|
{
|
|
}
|
return subRoleMenus;
|
}
|
#endregion
|
}
|
}
|
