/// <summary>
/// 保存权限
/// </summary>
/// <param name="roleFid"></param>
/// <param name="roleauthlist"></param>
/// <returns></returns>
public bool SetRoleAuth(Guid roleFid, List <RoleAuthInfo> roleauthlist)
{
///授权项
List <RoleAuthInfo> roleauths = roleauthlist.Where(d => d.IsAuth.GetValueOrDefault()).ToList();
///清除授权项
List <RoleAuthInfo> roleunauths = roleauthlist.Where(d => !d.IsAuth.GetValueOrDefault()).ToList();
///当前角色对应的授权项信息
List <RoleAuthInfo> roleauthnows = new RoleAuthDAL().GetList("and [VALID_FLAG] <> 0 "
+ "and [ROLE_FID] = '" + roleFid + "'", string.Empty);
///INSERT LIST
List <RoleAuthInfo> insertlist = new List <RoleAuthInfo>();
List <RoleAuthInfo> updatelist = new List <RoleAuthInfo>();
List <RoleAuthInfo> updateReverselist = new List <RoleAuthInfo>();
///比对现有库中该角色的权限，提取需要插入和反转的权限
foreach (var roleauth in roleauths)
{
var roleauthnow = roleauthnows.FirstOrDefault(d => d.AuthType == roleauth.AuthType &&
d.AuthSourceFid == roleauth.AuthSourceFid);
if (roleauthnow == null)
{
insertlist.Add(roleauth);
}
else
{
if (!roleauthnow.IsAuth.GetValueOrDefault())
{
updatelist.Add(roleauthnow);
}
}
}
///比对现有库中该角色的权限，提取需要反转的权限
foreach (var roleunauth in roleunauths)
{
var roleauthnow = roleauthnows.FirstOrDefault(d => d.AuthType == roleunauth.AuthType &&
d.AuthSourceFid == roleunauth.AuthSourceFid &&
d.IsAuth.GetValueOrDefault());
if (roleauthnow != null)
{
updateReverselist.Add(roleauthnow);
}
}
using (var trans = new TransactionScope())
{
if (!new RoleAuthDAL().InsertList(insertlist, roleFid, ""))
{
throw new Exception("Role Auth Error");
}
if (!new RoleAuthDAL().ReverseAuthList(updatelist))
{
throw new Exception("Role Auth Error");
}
if (!new RoleAuthDAL().ReverseIsAuthList(updateReverselist))
{
throw new Exception("Role Auth Error");
}
trans.Complete();
}
return(true);
}
/// <summary>
/// 获取客户端按钮根据菜单动作按钮
/// </summary>
/// <param name="userFid"></param>
/// <returns></returns>
public DataTable GetClientMenusActionByUser(Guid userFid)
{
///授权
List <Guid> sourceFids = new RoleAuthDAL().GetSourceFidsByUserFid(userFid, (int)AuthTypeConstants.MENU);
if (sourceFids.Count == 0)
{
return(dal.GetMenuActionByUser("XC.[MENU_TYPE] = " + (int)MenuTypeConstants.ClientMenu + " and XC.[NEED_AUTH] = 0"));
}
return(dal.GetMenuActionByUser("XC.[MENU_TYPE] = " + (int)MenuTypeConstants.ClientMenu + " and (XC.[FID] in ('" + string.Join("','", sourceFids.ToArray()) + "') or XC.[NEED_AUTH] = 0)"));
}
/// <summary>
/// 根据角色获取菜单项
/// </summary>
/// <param name="roleFid"></param>
/// <returns></returns>
public List <MenuInfo> GetMenusByRoleFid(Guid roleFid)
{
///权限
List <Guid> sourceFids = new RoleAuthDAL().GetSourceFidsByRoleFid(roleFid, (int)AuthTypeConstants.MENU);
if (sourceFids.Count == 0)
{
return(dal.GetList("[MENU_TYPE] in (" + (int)MenuTypeConstants.WebModule + "," + (int)MenuTypeConstants.WebMenu + ") and [NEED_AUTH] = 0", "[DISPLAY_ORDER]"));
}
return(dal.GetList("[MENU_TYPE] in (" + (int)MenuTypeConstants.WebModule + "," + (int)MenuTypeConstants.WebMenu + ") and ([FID] in ('" + string.Join("','", sourceFids.ToArray()) + "') or [NEED_AUTH] = 0)", "[DISPLAY_ORDER]"));
}
/// <summary>
/// 获取客户端菜单
/// </summary>
/// <param name="userFid"></param>
/// <returns></returns>
public List <MenuInfo> GetClientMenus(Guid userFid)
{
///授权
List <Guid> sourceFids = new RoleAuthDAL().GetSourceFidsByUserFid(userFid, (int)AuthTypeConstants.MENU);
if (sourceFids.Count == 0)
{
return(dal.GetList("[MENU_TYPE] = " + (int)MenuTypeConstants.ClientMenu + " and [NEED_AUTH] = 0", "[DISPLAY_ORDER]"));
}
return(dal.GetList("[MENU_TYPE] = " + (int)MenuTypeConstants.ClientMenu + " and ([FID] in ('" + string.Join("','", sourceFids.ToArray()) + "') or [NEED_AUTH] = 0)", "[DISPLAY_ORDER]"));
}
public List <MenuInfo> GetClientMenusByRoleFid(Guid roleFid)
{
///权限
List <Guid> sourceFids = new RoleAuthDAL().GetSourceFidsByRoleFid(roleFid, 1);
if (sourceFids.Count == 0)
{
return(new List <MenuInfo>());
}
///仅获取WEB菜单
return(dal.GetList("and [VALID_FLAG] <> 0 and [MENU_TYPE] in (30) "
+ "and [FID] in ('" + string.Join("','", sourceFids.ToArray()) + "')", "[DISPLAY_ORDER]"));
}
public List <ActionInfo> GetActionsByMenuRoleFid(Guid menuFid, Guid roleFid)
{
List <MenuActionInfo> list = dal.GetList("and [MENU_FID] = '" + menuFid + "'", string.Empty);
if (list.Count == 0)
{
return(new List <ActionInfo>());
}
List <Guid> notNeedAuthFids = list.Where(d => !d.NeedAuth.GetValueOrDefault()).Select(d => d.ActionFid.GetValueOrDefault()).ToList();
///权限
List <Guid> sourceFids
= new RoleAuthDAL().GetAuthSourceFidsByRoleFidAuthTypeInSourceFids(roleFid
, 2
, "'" + string.Join("','", list.Select(d => d.Fid.GetValueOrDefault()).ToArray()) + "'");
string actionFidCondition = string.Empty;
if (sourceFids.Count > 0)
{
List <Guid> actionFids = list.Where(d => sourceFids.Contains(d.Fid.GetValueOrDefault())).Select(d => d.ActionFid.GetValueOrDefault()).ToList();
if (actionFids.Count > 0)
{
actionFidCondition += ",'" + string.Join("','", actionFids.ToArray()) + "'";
}
}
if (notNeedAuthFids.Count > 0)
{
actionFidCondition += ",'" + string.Join("','", notNeedAuthFids.ToArray()) + "'";
}
if (string.IsNullOrEmpty(actionFidCondition))
{
return(new List <ActionInfo>());
}
List <ActionInfo> actionList = new ActionDAL().GetList("and [FID] in (" + actionFidCondition.Substring(1) + ")"
, string.Empty);
foreach (var actionInfo in actionList)
{
var info = list.SingleOrDefault(d => d.ActionFid == actionInfo.Fid);
if (info == null)
{
continue;
}
actionInfo.DisplayOrder = info.ActionOrder.GetValueOrDefault();
actionInfo.ClientJs = info.ClientJs;
actionInfo.Fid = info.Fid;
}
return(actionList.OrderBy(d => d.DisplayOrder).ToList());
}
public bool SetRoleAuth(Guid roleFid, List <Guid> authSourceFids, bool setFlag, string modifyUser)
{
List <RoleAuthInfo> list = new RoleAuthDAL().GetList("and [VALID_FLAG] <> 0 "
+ "and [ROLE_FID] = '" + roleFid + "' "
+ "and [AUTH_SOURCE_FID] in ('" + string.Join("','", authSourceFids.ToArray()) + "')", string.Empty);
string sql = string.Empty;
foreach (var authSourceFid in authSourceFids)
{
var info = list.FirstOrDefault(d => d.AuthSourceFid == authSourceFid);
if (info == null)
{
if (!setFlag)
{
continue;
}
int authType = GetAuthType(authSourceFid);
if (authType == 0)
{
continue;
}
sql += "insert into dbo.[TS_SYS_ROLE_AUTH] "
+ "([FID],[ROLE_FID],[AUTH_TYPE],[IS_AUTH],[AUTH_SOURCE_FID],[VALID_FLAG],[CREATE_USER],[CREATE_DATE]) "
+ "values (NEWID(),'" + roleFid + "'," + authType + ",1,'" + authSourceFid + "',1,'" + modifyUser + "',GETDATE());";
continue;
}
if (info.IsAuth.GetValueOrDefault() == setFlag)
{
continue;
}
sql += "update dbo.[TS_SYS_ROLE_AUTH] "
+ "set [IS_AUTH] = " + (setFlag ? 1 : 0) + ",[MODIFY_USER] = '" + modifyUser + "',[MODIFY_DATE] = GETDATE() "
+ "where [ID] = " + info.Id + ";";
}
if (string.IsNullOrEmpty(sql))
{
return(true);
}
return(CommonDAL.ExecuteNonQueryBySql(sql));
}
/// <summary>
/// 只获取弹出窗体的授权动作
/// </summary>
/// <param name="menuFid"></param>
/// <param name="roleFid"></param>
/// <param name="entityName"></param>
/// <param name="formEditWidth"></param>
/// <param name="formEditHeight"></param>
/// <param name="formUrl"></param>
/// <returns></returns>
public List <ActionInfo> GetFormActions(Guid menuFid, Guid roleFid, string entityName, out int formEditWidth, out int formEditHeight, out string formUrl)
{
///out默认值
formEditWidth = 800;
formEditHeight = 480;
formUrl = string.Empty;
///弹出窗体，在菜单管理中限制同级菜单名称不能重复
MenuInfo formMenuInfo = new MenuDAL().GetInfo(entityName, menuFid);
if (formMenuInfo == null)
{
throw new Exception("MC:0x00000028");///菜单数据错误
}
///窗体属性
formEditWidth = formMenuInfo.EditFormWidth.GetValueOrDefault();
formEditHeight = formMenuInfo.EditFormHeight.GetValueOrDefault();
formUrl = formMenuInfo.LinkUrl;
///所有按钮，后期按MENU_FID区分
List <MenuActionInfo> menuAtions = dal.GetList("[MENU_FID] = N'" + formMenuInfo.Fid.GetValueOrDefault() + "'", string.Empty);
///无按钮
if (menuAtions.Count == 0)
{
return(new List <ActionInfo>());
}
///不需要授权页面按钮的FID
List <Guid> menuActionFids = menuAtions.Where(d => !d.NeedAuth.GetValueOrDefault()).Select(d => d.Fid.GetValueOrDefault()).ToList();
///获取已授权的按钮GUID
List <Guid> sourceFids = new RoleAuthDAL().GetAuthSourceFidsByRoleFidAuthTypeInSourceFids(roleFid
, (int)AuthTypeConstants.ACTION///授权类型为按钮
, menuAtions.Count(d => d.NeedAuth.GetValueOrDefault()) == 0 ? string.Empty : "'" + string.Join("','", menuAtions.Where(d => d.NeedAuth.GetValueOrDefault()).Select(d => d.Fid.GetValueOrDefault()).ToArray()) + "'");
///可以显示的页面按钮
menuActionFids.AddRange(sourceFids);
if (menuActionFids.Count == 0)
{
return(new List <ActionInfo>());
}
///获取所有的动作按钮
List <ActionInfo> actionList = new ActionDAL().GetList("[FID] in ('" + string.Join("','", menuAtions.Where(d => menuActionFids.Contains(d.Fid.GetValueOrDefault())).Select(d => d.ActionFid.GetValueOrDefault()).ToArray()) + "')", string.Empty);
List <ActionInfo> actionInfos = new List <ActionInfo>();
foreach (var menuActionFid in menuActionFids)
{
MenuActionInfo menuActionInfo = menuAtions.FirstOrDefault(d => d.Fid.GetValueOrDefault() == menuActionFid);
if (menuActionInfo == null)
{
continue;
}
ActionInfo actionInfo = actionList.FirstOrDefault(d => d.Fid.GetValueOrDefault() == menuActionInfo.ActionFid.GetValueOrDefault()).Clone();
if (actionInfo == null)
{
continue;
}
actionInfo.IsListAction = false;
actionInfo.DisplayOrder = menuActionInfo.ActionOrder.GetValueOrDefault();
actionInfo.ClientJs = menuActionInfo.ClientJs;
actionInfo.Fid = menuActionInfo.Fid;
actionInfo.DetailFlag = menuActionInfo.DetailFlag.GetValueOrDefault();
actionInfos.Add(actionInfo);
}
return(actionInfos.OrderBy(d => d.DisplayOrder).ToList());
}
/// <summary>
/// 获取所有需要授权的项目，其中IS_AUTH=TRUE表示已经授权
/// </summary>
/// <param name="roleFid"></param>
/// <returns></returns>
public List <RoleAuthInfo> GetRoleAuthList(Guid roleFid)
{
///需要授权的菜单
List <MenuInfo> menus = new MenuDAL().GetList("and [VALID_FLAG] <> 0", string.Empty);
///需要授权的功能项
List <MenuActionInfo> menuactions = new MenuActionDAL().GetList("and [VALID_FLAG] <> 0", string.Empty);
///功能项
List <ActionInfo> actions = new ActionDAL().GetList("and [VALID_FLAG] <> 0", string.Empty);
///需要授权的报表
List <ReportInfo> reports = new ReportDAL().GetList("and [VALID_FLAG] <> 0", string.Empty);
///需要授权的图表
List <ChartInfo> charts = new ChartDAL().GetList("and [VALID_FLAG] <> 0", string.Empty);
///角色对应已授权的项目
List <RoleAuthInfo> roleauths = new RoleAuthDAL().GetList("and [ROLE_FID] = '" + roleFid + "' and [IS_AUTH] <> 0 and [VALID_FLAG] <> 0", string.Empty);
List <RoleAuthInfo> list = new List <RoleAuthInfo>();
///菜单
foreach (var item in menus)
{
RoleAuthInfo info = new RoleAuthInfo();
info.AuthSourceFid = item.Fid;
info.AuthSourceName = item.MenuName + "|" + item.MenuNameCn;
info.AuthType = 1;
info.AuthTypeName = "菜单";
info.DisplayOrder = item.DisplayOrder.GetValueOrDefault();
if (item.NeedAuth.GetValueOrDefault())
{
var roleauth = roleauths.FirstOrDefault(d => d.AuthSourceFid == item.Fid && d.AuthType == 1);
info.IsAuth = roleauth == null ? false : true;
}
else
{
info.IsAuth = true;
}
info.ParentSourceFid = item.ParentMenuFid.GetValueOrDefault();
list.Add(info);
}
///功能
foreach (var item in menuactions)
{
RoleAuthInfo info = new RoleAuthInfo();
info.AuthSourceFid = item.Fid;
var action = actions.FirstOrDefault(d => d.Fid == item.ActionFid);
if (action == null)
{
continue;
}
info.AuthSourceName = action.ActionName + "|" + action.ActionNameCn;
info.AuthType = 2;
info.AuthTypeName = "功能";
info.DisplayOrder = item.ActionOrder.GetValueOrDefault();
if (item.NeedAuth.GetValueOrDefault())
{
var roleauth = roleauths.FirstOrDefault(d => d.AuthSourceFid == item.Fid && d.AuthType == 2);
info.IsAuth = roleauth == null ? false : true;
}
else
{
info.IsAuth = true;
}
info.ParentSourceFid = item.MenuFid.GetValueOrDefault();
var menuinfo = list.FirstOrDefault(d => d.AuthType == 1 && d.AuthSourceFid == item.MenuFid);
if (menuinfo == null)
{
continue;
}
list.Add(info);
}
RoleAuthInfo reportauth = new RoleAuthInfo();
reportauth.AuthSourceFid = Guid.Parse("2238F7AD-9196-4B53-A0D0-81460FDA1F4C");
reportauth.AuthSourceName = "REPORT|报表";
reportauth.AuthType = 1;
reportauth.AuthTypeName = "菜单";
reportauth.IsAuth = true;
reportauth.DisplayOrder = int.MaxValue - 1;
reportauth.ParentSourceFid = Guid.Empty;
list.Add(reportauth);
///报表
foreach (var item in reports)
{
RoleAuthInfo info = new RoleAuthInfo();
info.AuthSourceFid = item.Fid;
info.AuthSourceName = item.NameEn + "|" + item.Name;
info.AuthType = 3;
info.AuthTypeName = "报表";
if (item.IsAuth.GetValueOrDefault())
{
var roleauth = roleauths.FirstOrDefault(d => d.AuthSourceFid == item.Fid && d.AuthType == 3);
info.IsAuth = roleauth == null ? false : true;
}
else
{
info.IsAuth = true;
}
info.ParentSourceFid = reportauth.AuthSourceFid.GetValueOrDefault();
list.Add(info);
}
RoleAuthInfo chartauth = new RoleAuthInfo();
chartauth.AuthSourceFid = Guid.Parse("6E714DD6-2D41-45AE-88C2-433EEF1973E9");
chartauth.AuthSourceName = "CHART|图表";
chartauth.AuthType = 1;
chartauth.AuthTypeName = "菜单";
chartauth.IsAuth = true;
chartauth.DisplayOrder = int.MaxValue;
chartauth.ParentSourceFid = Guid.Empty;
list.Add(chartauth);
///图表
foreach (var item in charts)
{
RoleAuthInfo info = new RoleAuthInfo();
info.AuthSourceFid = item.Fid;
info.AuthSourceName = item.NameEn + "|" + item.Name;
info.AuthType = 4;
info.AuthTypeName = "图表";
if (item.IsAuth.GetValueOrDefault())
{
var roleauth = roleauths.FirstOrDefault(d => d.AuthSourceFid == item.Fid && d.AuthType == 4);
info.IsAuth = roleauth == null ? false : true;
}
else
{
info.IsAuth = true;
}
info.ParentSourceFid = chartauth.AuthSourceFid.GetValueOrDefault();
list.Add(info);
}
return(list.OrderBy(d => d.DisplayOrder).ToList());
}
