using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using Model.ModelDto.SysDto;
|
using Model.ModelVm.SysVm;
|
using SqlSugar;
|
using WMS.Entity.Context;
|
using WMS.Entity.SysEntity;
|
using WMS.IDAL.ISysInterface;
|
|
namespace WMS.DAL.SysInfrastructure
|
{
|
/// <summary>
|
/// 角色权限仓储实践
|
/// </summary>
|
public class RoleRightRepository : BaseRepository<SysRoleRight>, IRoleRightRepository
|
{
|
private static readonly SqlSugarScope Db = DataContext.Db;
|
public RoleRightRepository() : base(Db)
|
{
|
}
|
|
|
public List<RoleRightDto> GetRoleMenuList(int userId)
|
{
|
try
|
{
|
var user = Db.Queryable<SysUserInfor>().First(m => m.Id == userId && m.IsDel == "0");
|
if (user == null)
|
{
|
throw new Exception("未查询到登录人信息");
|
}
|
if (string.IsNullOrWhiteSpace(user.RoleNo))
|
{
|
throw new Exception("未查询到登录人的所属角色信息");
|
}
|
|
string str = $@"select role.Id RoleId, menu.Id MenuId,roleright.RoleNo,roleright.MenuNo,role.RoleName,
|
menu.MenuName,menu.ParentNo,menu.Ord,menu.Url,menu.level,menu.IsEnable,role.Demo RoleDemo,menu.Demo MenuDemo
|
from SysRoleRight roleright
|
join SysFunctionMenu menu on roleright.MenuNo = menu.MenuNo
|
join SysRoles role on roleright.RoleNo = role.RoleNo
|
where role.IsDel = '0' and menu.IsDel = '0'
|
and roleright.IsDel = '0' and roleright.RoleNo = '{user.RoleNo}' ";
|
|
var roleRightDtos = Db.Ado.SqlQuery<RoleRightDto>(str);
|
return roleRightDtos.OrderBy(m => m.Ord).ToList();
|
|
|
}
|
catch (Exception e)
|
{
|
throw new Exception(e.Message);
|
}
|
}
|
|
/// <summary>
|
/// 获取角色权限信息列表
|
/// 多表：角色权限、角色、菜单
|
/// </summary>
|
/// <returns></returns>
|
public List<RoleRightDto> GetRoleRightList()
|
{
|
string str = "select role.Id RoleId,menu.Id MenuId,roleright.RoleNo,roleright.MenuNo,role.RoleName,menu.MenuName,menu.ParentNo,menu.Ord,menu.Url,menu.level,menu.IsEnable,role.Demo RoleDemo,menu.Demo MenuDemo from SysRoleRight roleright join SysFunctionMenu menu on roleright.MenuNo = menu.MenuNo join SysRoles role on roleright.RoleNo = role.RoleNo where role.IsDel = @isdel";
|
|
List<RoleRightDto> roleRightDtos = Db.Ado.SqlQuery<RoleRightDto>(str, new
|
{
|
isdel = "0", //角色是否删除
|
});
|
return roleRightDtos;
|
}
|
|
/// <summary>
|
/// 根据角色id获取当前角色所拥有权限
|
/// </summary>
|
/// <param name="id">角色id</param>
|
/// <returns></returns>
|
public List<RoleRightDto> GetRoleRightListById(int id)
|
{
|
string str = "select * from SysRoleRight roleright left join SysRoles role on roleright.RoleNo = role.RoleNo left join SysFunctionMenu menu1 on menu1.MenuNo = roleright.MenuNo where role.Id = @id and roleright.IsDel = @isdel";
|
List<RoleRightDto> rolerightlist = Db.Ado.SqlQuery<RoleRightDto>(str, new
|
{
|
isdel = "0", //角色权限是否删除
|
id //id
|
});
|
return rolerightlist;
|
}
|
|
/// <summary>
|
/// 获取角色权限信息列表(单表)
|
/// </summary>
|
/// <returns></returns>
|
public List<SysRoleRight> GetRoleRightOneListById(int id)
|
{
|
string str = "select RoleNo,MenuNo from SysRoleRight where Isdel = @isdel and RoleNo = (select RoleNo from SysRoles where IsDel = @roleisdel and Id = @id)";
|
List<SysRoleRight> roleRights = Db.Ado.SqlQuery<SysRoleRight>(str, new
|
{
|
roleisdel = "0", //角色是否删除
|
isdel = "0", //角色权限是否删除
|
id //id
|
});
|
return roleRights;
|
}
|
|
/// <summary>
|
/// 根据角色号获取角色权限信息列表(单表)
|
/// </summary>
|
/// <param name="RoleNo">角色号</param>
|
/// <returns></returns>
|
public List<SysRoleRight> GetRoleRightOneListByNo(string RoleNo)
|
{
|
string str = "select * from SysRoleRight where RoleNo = @roleno";
|
List<SysRoleRight> roleRights = Db.Ado.SqlQuery<SysRoleRight>(str, new
|
{
|
roleno = RoleNo //角色号
|
});
|
return roleRights;
|
}
|
|
/// <summary>
|
/// 新增角色权限信息
|
/// </summary>
|
/// <param name="roleright">角色权限实体模型</param>
|
/// <returns></returns>
|
public async Task<int> InsertRoleRight(SysRoleRight roleright)
|
{
|
string str = "insert into SysRoleRight values(@roleno, @menuno, @isdel, @createtime, @createuser, null, null)";
|
int i = await Db.Ado.ExecuteCommandAsync(str, new
|
{
|
roleno = roleright.RoleNo, //角色号
|
menuno = roleright.MenuNo, //菜单号
|
isdel = "0", //是否删除
|
createtime = Db.GetDate(), //创建时间
|
createuser = roleright.CreateUser //创建人
|
});
|
return i;
|
}
|
|
/// <summary>
|
/// 删除角色权限信息
|
/// </summary>
|
/// <param name="RoleNo">角色号</param>
|
/// <returns></returns>
|
public async Task<int> DeleteRoleRight(string RoleNo)
|
{
|
string str = "delete from SysRoleRight where RoleNo = @roleno";
|
//删除
|
int i = await Db.Ado.ExecuteCommandAsync(str, new
|
{
|
roleno = RoleNo //角色号
|
});
|
return i;
|
}
|
|
/// <summary>
|
/// 删除子级角色权限信息
|
/// </summary>
|
/// <param name="RoleNo">角色号</param>
|
/// <returns></returns>
|
public async Task<int> DeleteChildRoleRight(string RoleNo, string MenuNo)
|
{
|
try
|
{
|
//将菜单号进行分割 存储数组中
|
var arr = MenuNo.Split(',');
|
|
List<SysRoles> roleList = Db.Ado.SqlQuery<SysRoles>($"select * from SysRoles where CreateUser in (select Id from SysUserInfor where RoleNo='{RoleNo}') ");
|
foreach (var item in roleList)
|
{
|
List<SysRoleRight> roleRightList = Db.Ado.SqlQuery<SysRoleRight>($"select * from SysRoleRight where RoleNo='{item.RoleNo}'");
|
foreach (var right in roleRightList)
|
{
|
int first1 = Array.IndexOf(arr, right.MenuNo);
|
if (first1 <= -1)
|
{
|
await Db.Ado.ExecuteCommandAsync($"delete from SysRoleRight where RoleNo = '{item.RoleNo}' and MenuNo='{right.MenuNo}' ");
|
}
|
}
|
}
|
return 1;
|
}
|
catch(Exception ex)
|
{
|
throw new Exception("编辑角色权限信息异常", ex);
|
}
|
}
|
|
/// <summary>
|
/// 分配权限显示
|
/// </summary>
|
/// <param name="str"></param>
|
/// <returns></returns>
|
public List<RoleRightDto> GetRoleRightRBAC(string str)
|
{
|
List<RoleRightDto> rolerightdto = Db.Ado.SqlQuery<RoleRightDto>(str);
|
return rolerightdto;
|
}
|
}
|
}
|
