266 lines
11 KiB
C#
266 lines
11 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Collections;
|
|
using System.Web.UI.WebControls;
|
|
|
|
namespace BLL
|
|
{
|
|
public class CommonService
|
|
{
|
|
/// <summary>
|
|
/// 判断菜单是否存在
|
|
/// </summary>
|
|
/// <param name="postId"></param>
|
|
/// <returns></returns>
|
|
public static bool IsExistMenu(string menuId)
|
|
{
|
|
Model.Sys_Menu m = Funs.DB.Sys_Menu.FirstOrDefault(e => e.MenuId == menuId);
|
|
if (m != null)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据上级菜单获取菜单ID信息
|
|
/// </summary>
|
|
/// <param name="superMenuId">上级菜单ID</param>
|
|
/// <returns></returns>
|
|
public static Model.Sys_Menu GetMenuBySuperMenuId(string superMenuId)
|
|
{
|
|
return Funs.DB.Sys_Menu.FirstOrDefault(e => e.SuperMenu == superMenuId);
|
|
}
|
|
|
|
///// <summary>
|
|
///// 判断按键对应菜单是否存在
|
|
///// </summary>
|
|
///// <param name="postId"></param>
|
|
///// <returns></returns>
|
|
//public static bool isExistButtonToMenu(string buttonToMenuId)
|
|
//{
|
|
// Model.ButtonToMenu b = Funs.DB.ButtonToMenu.FirstOrDefault(e => e.ButtonToMenuId == buttonToMenuId);
|
|
// if (b != null)
|
|
// {
|
|
// return true;
|
|
// }
|
|
// else
|
|
// {
|
|
// return false;
|
|
// }
|
|
//}
|
|
|
|
#region 获取当前人是否具有按钮操作权限
|
|
/// <summary>
|
|
/// 获取当前人是否具有按钮操作权限
|
|
/// </summary>
|
|
/// <param name="projectId">项目id</param>
|
|
/// <param name="userId">用户id</param>
|
|
/// <param name="menuId">菜单id</param>
|
|
/// <param name="buttonName">按钮名称</param>
|
|
/// <returns>是否具有权限</returns>
|
|
public static bool GetAllButtonPowerList(string projectId, string userId, string menuId, string buttonName)
|
|
{
|
|
Model.HJGLDB db = Funs.DB;
|
|
bool isPower = false; // 定义是否具备按钮权限
|
|
|
|
var pro = BLL.Base_ProjectService.GetProjectByProjectId(projectId);
|
|
Model.Sys_Menu menu = Funs.DB.Sys_Menu.FirstOrDefault(e => e.MenuId == menuId);
|
|
|
|
// 如项目关闭，则现场管道安装菜单不可用
|
|
if (pro != null && pro.IsClosed == true && menu.MenuModule == Const.System_3)
|
|
{
|
|
isPower = false;
|
|
}
|
|
|
|
var user = BLL.Sys_UserService.GetUsersByUserId(userId); ////用户
|
|
if (user != null)
|
|
{
|
|
if (user.Account == Const.Gly)
|
|
{
|
|
isPower = true;
|
|
}
|
|
|
|
// 项目不为空的时候
|
|
if (isPower==false)
|
|
{
|
|
string userRoles = user.RoleIds;
|
|
if (!string.IsNullOrEmpty(userRoles))
|
|
{
|
|
// 用户可能多个角色
|
|
string[] rolse = userRoles.Split('|');
|
|
foreach (string r in rolse)
|
|
{
|
|
var rolePower = from x in db.Sys_RolePower
|
|
where x.MenuId == menuId && x.RoleId == r
|
|
select x;
|
|
|
|
if (rolePower.Count() > 0 && !string.IsNullOrEmpty(rolePower.FirstOrDefault().ButtonToMenus))
|
|
{
|
|
string buttonPowers = rolePower.FirstOrDefault().ButtonToMenus;
|
|
|
|
// 按钮权限
|
|
string[] buttons= buttonPowers.Split(',');
|
|
foreach(string btn in buttons)
|
|
{
|
|
var button = from x in db.Sys_ButtonToMenu where x.ButtonToMenuId == btn && x.ButtonName== buttonName select x;
|
|
if (button.Count() > 0)
|
|
{
|
|
isPower = true;
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
if (isPower == true)
|
|
{
|
|
break;
|
|
}
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
}
|
|
|
|
return isPower;
|
|
}
|
|
#endregion
|
|
|
|
#region 根据登陆id和系统id得到菜单列表
|
|
/// <summary>
|
|
/// 根据登陆id和系统id得到菜单列表
|
|
/// </summary>
|
|
/// <param name="userId"></param>
|
|
/// <param name="menuModule"></param>
|
|
/// <returns></returns>
|
|
public static List<Model.Sys_Menu> GetMenu(string userId, string menuModule)
|
|
{
|
|
List<Model.Sys_Menu> reMenuList = new List<Model.Sys_Menu>(); ////要返回的菜单列表
|
|
var user = BLL.Sys_UserService.GetUsersByUserId(userId); ////用户
|
|
if (user.UserId == Const.GlyId)
|
|
{
|
|
var sysMenu = from x in Funs.DB.Sys_Menu where x.MenuModule == menuModule && x.IsUse==true orderby x.SortIndex select x;
|
|
reMenuList = sysMenu.ToList();
|
|
}
|
|
else
|
|
{
|
|
if (!string.IsNullOrEmpty(user.RoleIds))
|
|
{
|
|
string[] userRoles = user.RoleIds.Split('|');
|
|
var sysMenuRole = from x in Funs.DB.Sys_Menu
|
|
join y in Funs.DB.Sys_RolePower on x.MenuId equals y.MenuId
|
|
where x.MenuModule == menuModule && x.IsUse==true && userRoles.Contains(y.RoleId)
|
|
orderby x.SortIndex
|
|
select x;
|
|
reMenuList = sysMenuRole.ToList();
|
|
}
|
|
}
|
|
|
|
reMenuList = reMenuList.Distinct().OrderBy(x => x.SortIndex).ToList();
|
|
////对于菜单集合 去重复返回
|
|
return reMenuList;
|
|
}
|
|
#endregion
|
|
|
|
#region 得到首页导航菜单列表 用于空权限登陆加载
|
|
/// <summary>
|
|
/// 得到首页导航菜单列表 用于空权限登陆加载
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static string[] GetDeskDesktopMenuId(string menuModule)
|
|
{
|
|
//string[] menuList;
|
|
//switch (menuModule)
|
|
//{
|
|
// case Const.System_1:
|
|
|
|
// menuList = new string[] { Const.DeskTopSGGLSuperMenuId, Const.DeskTopSGGLMenuId };
|
|
// var menuSystem = from x in Funs.DB.Sys_Menu
|
|
// where (x.MenuId == Const.ProjectSiteMenuId || x.MenuId == Const.ProjectColligateMenuId || x.SuperMenu == Const.ProjectSiteMenuId || x.SuperMenu == Const.ProjectColligateMenuId)
|
|
// select x.MenuId;
|
|
// foreach (var item in menuSystem)
|
|
// {
|
|
// menuList=menuList.Concat(new string[]{item}).ToArray();
|
|
// }
|
|
|
|
// break;
|
|
// case Const.System_2:
|
|
// menuList = new string[] { Const.DesktopHSSEServerSuperMenuId, Const.DesktopHSSEServerMenuId };
|
|
// break;
|
|
// case Const.System_3:
|
|
// menuList = new string[] { Const.DesktopHSSESuperMenuId, Const.DesktopHSSEMenuId };
|
|
// break;
|
|
// case Const.System_4:
|
|
// menuList = new string[] { Const.DesktopCQMSServerSuperMenuId, Const.DesktopCQMSServerMenuId };
|
|
// break;
|
|
|
|
// default:
|
|
// menuList = null;
|
|
// break;
|
|
//}
|
|
|
|
return null; //menuList;
|
|
}
|
|
#endregion
|
|
|
|
/// <summary>
|
|
/// 抽取权限到项目
|
|
/// </summary>
|
|
/// <param name="projectId"></param>
|
|
public static void ExtractionPower(string projectId)
|
|
{
|
|
/////增加项目上这个角色的菜单权限
|
|
//var rolePower = from x in Funs.DB.Sys_RolePower
|
|
// join y in Funs.DB.Sys_Menu on x.MenuId equals y.MenuId
|
|
// where (y.MenuModule == Const.System_3 || y.MenuModule == Const.System_5 || y.MenuModule == Const.System_7
|
|
// || y.MenuModule == Const.System_9 || y.MenuModule == Const.System_11)
|
|
// select x;
|
|
|
|
//if (rolePower.Count() > 0)
|
|
//{
|
|
// foreach (var roleItem in rolePower)
|
|
// {
|
|
// var proRolePower = Funs.DB.Project_RolePower.FirstOrDefault(x => x.ProjectId == projectId && x.RoleId == roleItem.RoleId && x.MenuId == roleItem.MenuId);
|
|
// if (proRolePower == null)
|
|
// {
|
|
// Model.Project_RolePower newPower = new Model.Project_RolePower();
|
|
// newPower.RoleId = roleItem.RoleId;
|
|
// newPower.ProjectId =projectId;
|
|
// newPower.MenuId = roleItem.MenuId;
|
|
// BLL.Project_RolePowerService.SaveProject_RolePower(newPower);
|
|
// }
|
|
// }
|
|
//}
|
|
|
|
///////增加项目上这个角色的按钮权限
|
|
//var buttonPower = from x in Funs.DB.Sys_ButtonPower
|
|
// join y in Funs.DB.Sys_Menu on x.MenuId equals y.MenuId
|
|
// where (y.MenuModule == Const.System_3 || y.MenuModule == Const.System_5 || y.MenuModule == Const.System_7
|
|
// || y.MenuModule == Const.System_9 || y.MenuModule == Const.System_11)
|
|
// select x;
|
|
|
|
//if (buttonPower.Count() > 0)
|
|
//{
|
|
// foreach (var buttonItem in buttonPower)
|
|
// {
|
|
// var proButtonPower = Funs.DB.Project_RoleButtonPower.FirstOrDefault(x => x.ProjectId == projectId && x.RoleId == buttonItem.RoleId
|
|
// && x.MenuId == buttonItem.MenuId && x.ButtonToMenuId == buttonItem.ButtonToMenuId);
|
|
// if (proButtonPower == null)
|
|
// {
|
|
// Model.Project_RoleButtonPower newRoleButtonPower = new Model.Project_RoleButtonPower();
|
|
// newRoleButtonPower.RoleId = buttonItem.RoleId;
|
|
// newRoleButtonPower.ProjectId = projectId;
|
|
// newRoleButtonPower.MenuId = buttonItem.MenuId;
|
|
// newRoleButtonPower.ButtonToMenuId = buttonItem.ButtonToMenuId;
|
|
// BLL.Project_RoleButtonPowerService.SaveProject_RoleButtonPower(newRoleButtonPower);
|
|
// }
|
|
// }
|
|
//}
|
|
}
|
|
}
|
|
} |