/// <summary> /// 根据权限归属Id查询菜单权限信息 /// </summary> /// <param name="input">权限类型:菜单、功能项、数据、字段、文件</param> /// <returns></returns> public Task <IEnumerable <SystemPermission> > GetPermissionByPrivilegeMasterValue( SystemPermissionByPrivilegeMasterValueInput input) { var sql = new StringBuilder( "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 })); }
public async Task <JsonResult> GetPermissionByPrivilegeMasterValue(SystemPermissionByPrivilegeMasterValueInput input) { return(Json(await _permissionLogic.GetPermissionByPrivilegeMasterValue(input))); }
/// <summary> /// 根据状态为True的菜单信息 /// </summary> /// <returns></returns> public async Task <IEnumerable <SystemPermission> > GetPermissionByPrivilegeMasterValue(SystemPermissionByPrivilegeMasterValueInput input) { return((await _permissionRepository.GetPermissionByPrivilegeMasterValue(input)).ToList()); }