/// <summary>
/// 查询模具列表
/// </summary>
/// <param name="sql"></param>
/// <param name="parameters"></param>
/// <returns></returns>
private RoleMenus GetModel(string sql, IList <DbParameter> parameters)
{
SqlDataReader reader = (SqlDataReader)_commonDbConneciton.ExecuteReader(sql, parameters);
RoleMenus model = new RoleMenus();
while (reader.Read())
{
GetRolePermissions(reader, ref model);
}
reader.Close();
return(model);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddModel(RoleMenus model)
{
string sql = string.Empty;
sql = "INSERT INTO [QX_G_RoleMenus] ([RoleID],[MenuList],[Description]) "
+ "VALUES (@RoleID, @MenuList, @Description)";
IList <DbParameter> parameters = new List <DbParameter>();
parameters.Add(_commonDbConneciton.CreateSqlParameter("@RoleID", SqlDbType.Int, model.RoleID));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@MenuList", SqlDbType.NVarChar, model.MenuList));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@Description", SqlDbType.NVarChar, 200, model.Description));
return(ExecuteNonQuery(sql, parameters));
}
/// <summary>已重载。删除关联数据</summary>
/// <returns></returns>
protected override int OnDelete()
{
if (MenuButtons != null)
{
MenuButtons.Delete();
}
if (RoleMenus != null)
{
RoleMenus.Delete();
}
if (RoleMenuButtons != null)
{
RoleMenuButtons.Delete();
}
return(base.OnDelete());
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void treeView_Roles_AfterSelect(object sender, TreeViewEventArgs e)
{
//获取根节点MenuType实体
TreeNode parentNode = GetMenuTypeNode(e.Node);
_curMenuType = ((MenuType)parentNode.Tag);
//判断是否为角色节点
if (e.Node.Parent != null)
{
_curRole = (Roles)e.Node.Tag;
//查询角色权限
_curRoleMenus = _roleMenusBll.GetModel(_curRole.RoleID);
Init_TreeViewMenus(_curMenuType.MenuTypeID);
Set_TreeViewMenus();
}
}
/// <summary>
/// 修改模具
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int EditModel(RoleMenus model)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat("UPDATE [QX_RolePermissions] SET ");
sql.AppendFormat("[RoleID] = @RoleID, ");
sql.AppendFormat("[PermissionList] = @PermissionList, ");
sql.AppendFormat("[Description] = @Description ");
sql.AppendFormat("WHERE [RolePermissionID] = @RolePermissionID ");
IList <DbParameter> parameters = new List <DbParameter>();
parameters.Add(_commonDbConneciton.CreateSqlParameter("@RoleID", SqlDbType.Int, model.RoleID));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@PermissionList", SqlDbType.NText, model.MenuList));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@Description", SqlDbType.Text, 200, model.Description));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@RolePermissionID", SqlDbType.Int, model.RoleMenuID));
return(ExecuteNonQuery(sql.ToString(), parameters));
}
/// <summary>
/// 查询模具列表
/// </summary>
/// <param name="sql"></param>
/// <param name="parameters"></param>
/// <returns></returns>
private List <RoleMenus> GetList(string sql, IList <DbParameter> parameters)
{
List <RoleMenus> ls = new List <RoleMenus>();
SqlDataReader reader = (SqlDataReader)_commonDbConneciton.ExecuteReader(sql, parameters);
RoleMenus model;
while (reader.Read())
{
model = new RoleMenus();
GetRolePermissions(reader, ref model);
ls.Add(model);
}
reader.Close();
return(ls);
}
public ResponseDto <Roles> SaveGrant([FromBody] List <RoleMenus> request)
{
ResponseDto <Roles> response = new ResponseDto <Roles>();
var _entity = _appSystemServices.GetEntitys <RoleMenus>();
_entity.Where(x => x.RoleId == request.FirstOrDefault().RoleId).ToDelete().ExecuteAffrows();
if (request.Count > 0)
{
request.ForEach(x => {
var menus = new RoleMenus()
{
RoleId = x.RoleId, MenuId = x.MenuId, CompanyId = CurrentUser.CompanyId
};
menus.SetCreateDefault(this.CurrentUser);
_appSystemServices.Create <RoleMenus>(menus);
});
}
return(response);
}
/// <summary>已重载。删除关联数据</summary>
/// <returns></returns>
protected override int OnDelete()
{
if (AdminRoles != null)
{
AdminRoles.Delete();
}
if (RoleDataPermissions != null)
{
RoleDataPermissions.Delete();
}
if (RoleMenus != null)
{
RoleMenus.Delete();
}
if (RoleMenuButtons != null)
{
RoleMenuButtons.Delete();
}
return(base.OnDelete());
}
/// <summary>
/// Assign All Menus to SuperAdmin
/// </summary>
/// <param name="roleId"></param>
private void AssignMenus(string roleId)
{
List <BDMMenus> menuList = new List <BDMMenus>();
List <string> menuIds = new List <string>();
menuList = bal.GetMenuByRole("");
foreach (var item in menuList)
{
menuIds.Add(Convert.ToString(item.MenuId));
}
ApplicationDbContext context = new ApplicationDbContext();
RoleMenus model = new RoleMenus();
model.MenuIds = string.Join(",", menuIds.ToArray());
model.RoleId = roleId;
if (model.Id == 0)
{
context.RoleMenus.Add(model);
context.SaveChanges();
}
}
public IList <CheckBoxItem> GetCheckBoxItem(IList <Menu> menuList)
{
var list = new List <CheckBoxItem>();
foreach (var menu in menuList)
{
bool checkStatus = false;
if (IsEdit)
{
checkStatus = RoleMenus.Contains(menu);
}
CheckBoxItem item = new CheckBoxItem
{
Text = menu.MenuName,
Value = menu.MenuId.ToString(),
Checked = checkStatus
};
list.Add(item);
}
return(list);
}
private void LoopMenu(List <Menus> listAll, List <Menus> listChild, StringBuilder sb, List <RoleMenus> listRoleRights)
{
for (int i = 0, len = listChild.Count; i < len; i++)
{
Menus m = listChild[i];
RoleMenus rr = listRoleRights.Find(p => p.MenuId == m.Id);
string closed = "";
//if (m.Type == 1)
//{
// closed = "\"state\":\"closed\",";
//}
if (rr != null)
{
sb.Append(string.Format("{{\"id\":\"{0}\",\"text\":\"{1}\",\"checked\":{2},\"iconCls\":\"{3}\",{4}\"attributes\":{{\"url\":\"{5}\",\"action\":\"{6}\"}}", m.Id, m.Name, "true", m.Ico, closed, m.Url, m.Action));
}
else
{
sb.Append(string.Format("{{\"id\":\"{0}\",\"text\":\"{1}\",\"checked\":{2},\"iconCls\":\"{3}\",{4}\"attributes\":{{\"url\":\"{5}\",\"action\":\"{6}\"}}", m.Id, m.Name, "false", m.Ico, closed, m.Url, m.Action));
}
var listTemp = listAll.FindAll(p => p.ParentId == m.Id);
if (listTemp.Count > 0)
{
sb.Append(",\"children\": [");
LoopMenu(listAll, listTemp, sb, listRoleRights);
sb.Append("]");
}
if (i < len - 1)
{
sb.Append("},");
}
else
{
sb.Append("}");
}
}
}
/// <summary>
/// 获取用户权限
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
private bool GetUserRoleMenus(int userID)
{
_dicRoleMenus = new Dictionary <int, UserPermissions>();
UserRoles userRoles = null;
RoleMenus roleMenus = null;
string[] ayyRoles = new string[0] {
};
//获取用户角色
userRoles = _userRolesBll.GetModel(userID);
if (userRoles == null || string.IsNullOrEmpty(userRoles.RoleID))
{
return(false);
}
ayyRoles = userRoles.RoleID.Split(',');
for (int i = 0; i < ayyRoles.Length; i++)
{
//获取角色权限
roleMenus = _roleMenusBll.GetModel(Convert.ToInt32(ayyRoles[i]));
foreach (int key in roleMenus.DicPermissions.Keys)
{
if (!_dicRoleMenus.ContainsKey(key))
{
//添加到权限字典
_dicRoleMenus.Add(key, roleMenus.DicPermissions[key]);
}
}
}
return(true);
}
