/// <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); }