/// <summary> /// 获取解决的数据源,只能看到自己与下级所有角色 /// </summary> /// <param name="context"></param> /// <param name="originalSql"></param> /// <returns></returns> public static string GetRolesSql(string originalSql) { if (UserContext.Current.IsSuperAdmin) { return(originalSql); } int currnetRoleId = UserContext.Current.RoleId; List <int> roleIds = RoleContext.GetAllChildrenIds(currnetRoleId); roleIds.Add(currnetRoleId); string sql = $@"SELECT Role_Id as 'key',RoleName as 'value' FROM Sys_Role WHERE Enable=1 and Role_Id in ({string.Join(',', roleIds)})"; return(sql); }