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