public static string[] GetPageAuthorityFromDB(string ModuleID, UserInfoUtil UserInfo)
{
//获得用户权限
DataTable data = CommonUtilDBHelper.GetPageAuthority(UserInfo.UserID, UserInfo.CompanyCD, ModuleID);
if (data.Rows.Count > 0)
{
//获得该页面的可操作业务
DataRow[] rows = data.Select("ModuleID = '" + ModuleID + "'");
int iCount = rows.Length;
if (iCount > 0)
{
//实例化
string[] authority = new String[iCount];
//将权限添加到返回集中
for (int i = 0; i < rows.Length; i++)
{
string FunctionCD = (string)rows[i]["FunctionCD"];
authority[i] = FunctionCD;
}
return(authority);
}
}
//返回可操作的业务集
return(null);
}
public static DataTable InitMenuData(string userID, string companyCD, string filterID)
{
//获取系统默认设置的菜单项
DataTable dtMenu = CommonUtilDBHelper.GetMenuData(userID, companyCD, filterID);
//添加企业文化菜单
// InitCompCulture(dtMenu, companyCD);
return(dtMenu);
}
/// <summary>
/// 企业文化菜单设置
/// </summary>
/// <param name="dtMenu">菜单信息</param>
/// <param name="companyCD">公司代码</param>
private static void InitCompCulture(DataTable dtMenu, string companyCD)
{
//获取客户自己设置的企业文化菜单项
DataTable dtCulture = CommonUtilDBHelper.GetCultureInfo(companyCD);
//添加一列用于判断是否包含子分类
dtCulture.Columns.Add(new DataColumn("HasSubMenu"));
DataTable dtOrderCulture = new DataTable();
dtOrderCulture = dtCulture.Clone();
//客户自定义企业文化菜单存在的时候
if (dtCulture != null && dtCulture.Rows.Count > 0)
{
//获取第一级分类信息
DataRow[] drSuperType = dtCulture.Select("SupperTypeID =0");
//遍历第一级部门
for (int i = 0; i < drSuperType.Length; i++)
{
DataRow drFirstType = (DataRow)drSuperType[i];
//获取部门ID
string typeID = drFirstType["ID"].ToString().Trim();
//重新设置子分类ID，以便实现和菜单生成的接口一致
drFirstType["ID"] = ConstUtil.MENU_PERSONAL_COMPANY_CULTURE + typeID;
//重新设置父分类ID，以便实现和菜单生成的接口一致
drFirstType["SupperTypeID"] = ConstUtil.MENU_PERSONAL_COMPANY_CULTURE;
//设定子分类
bool hasSubMenu = ReorderRow(dtOrderCulture, typeID, dtCulture, drFirstType["ID"].ToString().Trim());
//有子分类时
if (hasSubMenu)
{
drFirstType["HasSubMenu"] = "1";
}
else
{
drFirstType["HasSubMenu"] = "0";
}
//导入第一级分类
dtOrderCulture.ImportRow(drFirstType);
}
}
else
{
return;
}
#region 将企业文化分类插入菜单项
//客户自定义企业文化菜单存在的时候
if (dtOrderCulture != null && dtOrderCulture.Rows.Count > 0)
{
//
dtMenu.DefaultView.Sort = "ModuleID";
//
int compCulture = dtMenu.DefaultView.Find(ConstUtil.MENU_PERSONAL_COMPANY_CULTURE);
//遍历所有的自定义企业文化
for (int i = 0; i < dtOrderCulture.Rows.Count; i++)
{
//新建一个菜单项
DataRow drCulture = dtMenu.NewRow();
//模块ID
drCulture["ModuleID"] = dtCulture.Rows[i]["ID"].ToString();
//分类名称设置为菜单名
drCulture["ModuleName"] = dtCulture.Rows[i]["TypeName"].ToString();
//模块类型 A-表示应用系统 S-表示子系统（六大模块） M-表示菜单 P-页面
//如果还有子分类时，则不表示菜单
if ("1".Equals(dtCulture.Rows[i]["HasSubMenu"].ToString()))
{
drCulture["ModuleType"] = "S";
}
else
{
drCulture["ModuleType"] = "M";
}
//上级模块ID
drCulture["ParentID"] = dtCulture.Rows[i]["SupperTypeID"].ToString();
//属性类型，主要用于对象更灵活的控制，目前值有：link和空值
drCulture["PropertyType"] = "link";
//属性值，当属性类型为“link”时，则属性值表示link 内容
drCulture["PropertyValue"] = "Pages/Office/AdminManager/Equipment_Add.aspx";
//添加企业文化到菜单数据集中
dtMenu.Rows.InsertAt(drCulture, compCulture + i + 1);
}
}
#endregion
}
public static ArrayList InitMenuDataSimple(string userID, string companyCD)
{
return(CommonUtilDBHelper.InitMenuDataSimple(userID, companyCD));
}
public static DataTable GetCompanyModule(string CompanyCD)
{
return(CommonUtilDBHelper.GetCompanyModule(CompanyCD));
}
/// <summary>
/// 获得页面上的操作按钮
/// </summary>
/// <param name="UserID">用户ID</param>
/// <param name="CompanyCD">公司代码</param>
/// <returns>返回用户可操作的页面业务集。</returns>
public static DataTable InitPageAuthority(string UserID, string CompanyCD)
{
return(CommonUtilDBHelper.GetPageAuthority(UserID, CompanyCD));
}