/// <summary>
/// 根据角色Id,岗位Id,组Id,人员Id获取具有的菜单信息
/// </summary>
/// <param name="input">输入参数</param>
/// <returns>树形菜单信息</returns>
public async Task <IEnumerable <TreeEntity> > GetMenuHavePermissionByPrivilegeMasterValue(GetMenuHavePermissionByPrivilegeMasterValueInput input)
{
return((await _permissionRepository.GetMenuHavePermissionByPrivilegeMasterValue(input)).ToList());
}
public async Task <JsonResult> GetMenuHavePermissionByPrivilegeMasterValue(GetMenuHavePermissionByPrivilegeMasterValueInput input)
{
return(JsonForZtree((await _permissionLogic.GetMenuHavePermissionByPrivilegeMasterValue(input)).ToList()));
}
/// <summary>
/// 根据角色Id,岗位Id,组Id,人员Id获取具有的菜单信息
/// </summary>
/// <param name="input">输入参数</param>
/// <returns>树形菜单信息</returns>
/// GetMenuPermissionByPrivilegeMasterValue
public Task <IEnumerable <TreeEntity> > GetMenuHavePermissionByPrivilegeMasterValue(GetMenuHavePermissionByPrivilegeMasterValueInput input)
{
var sql =
new StringBuilder("SELECT MenuId id,ParentId pId,name,icon FROM System_Menu menu WHERE MenuId IN( SELECT PrivilegeAccessValue FROM System_Permission WHERE PrivilegeAccess=@privilegeAccess AND ");
sql.Append(
input.PrivilegeMaster == EnumPrivilegeMaster.人员
? " PrivilegeMasterValue IN (SELECT PrivilegeMasterValue FROM System_PermissionUser WHERE PrivilegeMasterUserId=@privilegeMasterValue) "
: " PrivilegeMasterValue=@privilegeMasterValue ");
sql.Append(" GROUP BY PrivilegeAccessValue) AND menu.IsFreeze=@isFreeze");
if (input.PrivilegeAccess != null)
{
switch (input.PrivilegeAccess)
{
case EnumPrivilegeAccess.菜单按钮:
sql.Append(" AND menu.HaveFunctionPermission='true'");
break;
case EnumPrivilegeAccess.数据权限:
sql.Append(" AND menu.HaveDataPermission='true'");
break;
case EnumPrivilegeAccess.字段:
sql.Append(" AND menu.HaveFieldPermission='true'");
break;
case EnumPrivilegeAccess.菜单:
sql.Append(" AND menu.HaveMenuPermission='true'");
break;
}
}
sql.Append(" ORDER BY OrderNo");
return(SqlMapperUtil.SqlWithParams <TreeEntity>(sql.ToString(),
new
{
privilegeAccess = EnumPrivilegeAccess.菜单,
privilegeMasterValue = input.PrivilegeMasterValue,
isFreeze = false
}));
}
/// <summary>
/// 根据角色ID获取具有的菜单信息
/// </summary>
/// <param name="input"></param>
/// <returns>树形菜单信息</returns>
public Task <IEnumerable <TreeEntity> > GetMenuHavePermissionByPrivilegeMasterValue(GetMenuHavePermissionByPrivilegeMasterValueInput input)
{
var sql = new StringBuilder(
@"SELECT MenuId id,ParentId pId,name,icon FROM Sys_Menu menu WHERE MenuId IN( SELECT PrivilegeAccessValue FROM Sys_Permission WHERE PrivilegeAccess=@privilegeAccess AND PrivilegeMasterValue=@privilegeMasterValue GROUP BY PrivilegeAccessValue)
order by OrderNo");
return(SqlMapperUtil.SqlWithParams <TreeEntity>(sql.ToString(),
new
{
privilegeAccess = EnumPrivilegeAccess.菜单,
privilegeMasterValue = input.PrivilegeMasterValue,
isFreeze = false
}));
}
/// <summary>
/// 根据特权ID获取当前拥有的权限
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <IEnumerable <TreeEntity> > GetMenuHavePermissionByPrivilegeMasterValue(GetMenuHavePermissionByPrivilegeMasterValueInput input)
{
var treeList = await _systemPermissionDapperRepository.GetMenuHavePermissionByPrivilegeMasterValue(input);
return(treeList);
}
