/// <summary>
/// 根据权限归属Id查询菜单权限信息
/// </summary>
/// <param name="input">权限类型:菜单、功能项、数据、字段、文件</param>
/// <returns></returns>
public Task <IEnumerable <SystemPermission> > GetPermissionByPrivilegeMasterValue(
GetPermissionByPrivilegeMasterValueInput input)
{
var sql =
new StringBuilder(
String.Format(
"SELECT PrivilegeAccessValue FROM System_Permission WHERE PrivilegeAccess=@privilegeAccess"));
sql.Append(
input.PrivilegeMaster == EnumPrivilegeMaster.人员
? " AND PrivilegeMasterValue IN (SELECT PrivilegeMasterValue FROM System_PermissionUser WHERE PrivilegeMasterUserId=@privilegeMasterValue)"
: " AND PrivilegeMasterValue=@privilegeMasterValue");
if (!input.PrivilegeMenuId.IsNullOrEmptyGuid())
{
sql.Append(" AND PrivilegeMenuId=@privilegeMenuId");
}
sql.Append(" GROUP BY PrivilegeAccessValue");
return(SqlMapperUtil.SqlWithParams <SystemPermission>(sql.ToString(),
new
{
privilegeAccess = (byte)input.PrivilegeAccess,
privilegeMasterValue = input.PrivilegeMasterValue,
privilegeMenuId = input.PrivilegeMenuId
}));
}
/// <summary>
/// 根据状态为True的菜单信息
/// </summary>
/// <returns></returns>
public async Task <IEnumerable <SystemPermission> > GetPermissionByPrivilegeMasterValue(GetPermissionByPrivilegeMasterValueInput input)
{
return((await _permissionRepository.GetPermissionByPrivilegeMasterValue(input)).ToList());
}
public async Task <JsonResult> GetPermissionByPrivilegeMasterValue(GetPermissionByPrivilegeMasterValueInput input)
{
return(Json(await _permissionLogic.GetPermissionByPrivilegeMasterValue(input)));
}
/// <summary>
/// 根据角色id获取具有的菜单信息
/// </summary>
/// <param name="input"></param>
/// <returns>树形菜单信息</returns>
public Task <IEnumerable <SystemPermission> > GetPermissionByPrivilegeMasterValue(GetPermissionByPrivilegeMasterValueInput input)
{
var sql = new StringBuilder($"select * from Sys_Permission where PrivilegeAccess=@privilegeAccess");
sql.Append(" AND PrivilegeMasterValue=@privilegeMasterValue ");
if (!string.IsNullOrWhiteSpace(input.PrivilegeMenuId))
{
sql.Append(@" AND PrivilegeAccessValue in(select MenuButtonId from
sys_menubutton where MenuId=@privilegeMenuId)");
}
return(SqlMapperUtil.Query <SystemPermission>(sql.ToString(), new
{
privilegeAccess = (byte)input.PrivilegeAccess,
privilegeMasterValue = input.PrivilegeMasterValue
, privilegeMenuId = input.PrivilegeMenuId
}));
}
/// <summary>
/// 根据权限id获取权限信息
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <IEnumerable <TreeEntity> > GetPermissionByCheckedPrivilegeMasterValue(GetPermissionByPrivilegeMasterValueInput input)
{
try
{
//获取所有菜单
var getMenuAll = (await _menuRepository.GetAllMenu()).ToList();
IEnumerable <SystemPermission> getPermissionByMaster = (await _systemPermissionDapperRepository.GetPermissionByPrivilegeMasterValue(input)).ToList();
List <TreeEntity> treeList = new List <TreeEntity>();
foreach (TreeEntity tree in getMenuAll)
{
tree.Checked = getPermissionByMaster.Count(m => m.PrivilegeAccessValue.ToString() == tree.id.ToString()) != 0;
tree.isParent = getMenuAll.Select(m1 => m1.pId).Contains(tree.id);
treeList.Add(tree);
}
return(treeList);
}
catch
{
return(null);
}
}
/// <summary>
/// 根据权限ID查询权限信息
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public Task <IEnumerable <SystemPermission> > GetPermissionByPrivilegeMasterValue(GetPermissionByPrivilegeMasterValueInput input)
{
return(_systemPermissionDapperRepository.GetPermissionByPrivilegeMasterValue(input));
}
