/// <summary>
/// 设置菜单权限
/// </summary>
/// <param name="value"></param>
private void SetMenuRoles(sys_menu value)
{
_sysRoleMenuRpt.DeleteWhere(f => f.MenuId == value.Id);
if (!string.IsNullOrEmpty(value.RoleIds) && value.RoleIds.Length > 1)
{
//新增用户角色关系表
string[] roles = value.RoleIds.Split(",".ToArray());
foreach (var item in roles)
{
if (!string.IsNullOrEmpty(item))
{
var userrole = new sys_role_menu {
RoleId = int.Parse(item), MenuId = value.Id
};
_sysRoleMenuRpt.Add(userrole);
}
}
_sysRoleMenuRpt.Commit();
}
}
public int InsertRoleMenuIds(int roleId, List <int> checkedIds)
{
var sysRoleMenus = new List <sys_role_menu>();
foreach (var item in checkedIds)
{
var sysRoleMenu = new sys_role_menu
{
role_id = roleId,
menu_id = item
};
sysRoleMenus.Add(sysRoleMenu);
}
_context.Set <sys_role_menu>().AddRange(sysRoleMenus);
return(checkedIds.Count);
//string sql = string.Empty;
//foreach (var checkedId in checkedIds)
//{
// sql += $"INSERT INTO sys_role_menu (role_id, menu_id) VALUES({roleId}, {checkedId});";
//}
//return _context.Database.ExecuteSqlRaw(sql);
}
