protected void BindRootMenu()
{
AdoHelper adoHelper = AdoHelper.CreateHelper("DB_Instance");
DataSet ds = new StarTech.Adapter.IACenter().GetAllMenusByUserId(int.Parse(this.UserId));
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
DataRow[] rows = ds.Tables[0].Select("parentMenuId=105");
//DataSet ds = adoHelper.ExecuteSqlDataset("select * from IACenter_Menu where parentMenuId=0 order by orderIndex");
string menus = "";
string firstTab = "";
for (int i = 0; i < rows.Length; i++)
{
DataRow row = rows[i];
this.hidRootMenu.Value += "tab_" + row["uniqueId"] + ",";
if (firstTab == "")
{
firstTab = "tab_" + row["uniqueId"] + "|" + row["menuName"];
}
string css = i == 0 ? "Active" : "Normal";
menus += "<a href=\"javascript:selectTab('tab_" + row["uniqueId"] + "','" + row["menuName"] + "');void(0);\" class=\"" + css + "\" id=\"tab_" + row["uniqueId"] + "\">" + row["menuName"] + "</a>";
}
this.ltRootMenu.Text = menus;
if (this.hidRootMenu.Value != "")
{
this.hidRootMenu.Value = this.hidRootMenu.Value.TrimEnd(',');
}
if (firstTab != "")
{
ClientScript.RegisterStartupScript(this.GetType(), "a", "selectTab('" + firstTab.Split('|')[0] + "','" + firstTab.Split('|')[1] + "');", true);
}
}
}
/// <summary>
/// 菜单权限
/// </summary>
public void CheckMenuPermissions(int menuId)
{
bool r = new IACenter().CheckIsMyMenu(menuId, Int32.Parse(this.UserId));
if (r == false)
{
Response.Redirect("/Login.aspx", true);
}
}
/// <summary>
/// 获取当前用户相应的首页
/// </summary>
public string GetMyIndexPage()
{
DataSet ds = new IACenter().ExecuteSqlDataset("select * from t_platform_base_depart where trim(departcode)='" + this.DepartCode.Trim() + "'");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds.Tables[0].Rows[0]["indexpagename"].ToString().Trim() == "" ? "Index_FJ.aspx" : ds.Tables[0].Rows[0]["indexpagename"].ToString());
}
else
{
return("Index_FJ.aspx");
}
}
/// <summary>
/// 验证
/// </summary>
public void SetButtonsPermissions(int menuId, string groupIds)
{
string ids = new StarTech.Adapter.IACenter().GetAllButtons(menuId, groupIds);
ids = "," + ids + ",";
//IACenter_Button
//1 新增 add
//2 删除 delete
//3 修改 edit
//4 查询 search
//5 查看 show
//6 权限设置 pemissionset
//7 审核 approved
//8 取消审核 unapproved
if (ids.IndexOf(",1,") == -1)
{
this.btnAdd.Visible = false;
}
if (ids.IndexOf(",2,") == -1)
{
this.btnDelete.Visible = false;
}
if (ids.IndexOf(",3,") == -1)
{
this.btnEdit.Visible = false;
}
if (ids.IndexOf(",4,") == -1)
{
this.btnSearch.Visible = false;
}
if (ids.IndexOf(",5,") == -1)
{
this.btnShow.Visible = false;
}
//if (ids.IndexOf(",6,") == -1) { this.btnAdd.Visible = false; }
if (ids.IndexOf(",7,") == -1)
{
this.btnSH.Visible = false;
}
if (ids.IndexOf(",8,") == -1)
{
this.btnNSH.Visible = false;
}
}
//绑定数据
private void BindData()
{
//清除所有数据
DeptTree.Nodes.Clear();
//绑定模式
TreeNode node = new TreeNode("用户", "0");
node.SelectAction = TreeNodeSelectAction.Expand;
node.Expand();
//部门数据
DataSet dsDept = new BllTableObject("T_Base_Department").Util_GetList2("*", "1=1", "orderBy");
//所有人员数据
DataSet dsUser = new StarTech.Adapter.IACenter().ExecuteSqlDataset("select * from IACenter_User order by orderBy");
//创建部门节点
CreateDeptNode(node, dsDept.Tables[0], dsUser.Tables[0], "");
DeptTree.Nodes.Add(node);
}
protected void btnSave_Click(object sender, EventArgs e)
{
StarTech.Adapter.IACenter iaCenter = new StarTech.Adapter.IACenter();
//menu
iaCenter.SetGroupMenu(Int32.Parse(this.menuId), Int32.Parse(this.groupId), this.cbxMenu.Checked);
if (this.cbxToSub.Checked)
{
DataSet subMenus = iaCenter.GetSubMenuById(Int32.Parse(this.menuId));
foreach (DataRow row in subMenus.Tables[0].Rows)
{
iaCenter.SetGroupMenu(Int32.Parse(row["uniqueId"].ToString()), Int32.Parse(this.groupId), this.cbxMenu.Checked);
}
}
//button
string buttons = "";
foreach (ListItem item in this.cbxButtons.Items)
{
if (item.Selected == true)
{
buttons += item.Value + ",";
}
}
if (buttons != "")
{
buttons = buttons.TrimEnd(',');
}
bool addButtonsFlag = (buttons == "") ? false : true;
iaCenter.SetGroupButtons(Int32.Parse(this.menuId), Int32.Parse(this.groupId), buttons, addButtonsFlag);
if (this.cbxToSub.Checked)
{
DataSet subMenus = iaCenter.GetSubMenuById(Int32.Parse(this.menuId));
foreach (DataRow row in subMenus.Tables[0].Rows)
{
iaCenter.SetGroupButtons(Int32.Parse(row["uniqueId"].ToString()), Int32.Parse(this.groupId), buttons, addButtonsFlag);
}
}
ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('保存成功!');</script>");
}
protected void btnLogin_Click(object sender, EventArgs e)
{
//验证码
//if (Request["txtYZM"] == null || Session["VerifyChar"] == null) { return; }
//if (Session["VerifyChar"].ToString().ToLower() != Request["txtYZM"].ToString().ToLower())
//{
// ClientScript.RegisterStartupScript(this.GetType(), "alert", "<Script>alert('验证码错误！');</Script>");
// return;
//}
string username = this.txtUsername.Value.Trim().Replace("'", "");
string pwd = this.txtPassword.Value;
pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(pwd, "MD5");
//Response.Write(pwd); Response.End();
DataTable dtUser = new DataTable();
int r = new StarTech.Adapter.IACenter().UserLogin(username, pwd, ref dtUser);
if (r == 1)
{
//日志
//iacenter.AddUserActionLog(dt.Rows[0]["UserName"].ToString(), dt.Rows[0]["TrueName"].ToString(), "", "", "", "登陆", "", "", "", Request.UserHostAddress, Request.Url.ToString());
Session["UserId"] = dtUser.Rows[0]["uniqueId"].ToString();
LogAdd.CreateLog(HttpContext.Current.Session["UserId"].ToString(), "用户‘" + dtUser.Rows[0]["userName"].ToString() + "’登录", "登录", "", "", HttpContext.Current.Request.Url.ToString());
//string ids = GetRootMenus(dt.Rows[0]["uniqueId"].ToString());
string ids = "1";
if (ids != "")
{
Response.Redirect("Main.aspx?rootMenuId=" + ids.Split(',')[0] + "", true);
}
else
{
Response.Redirect("Main.aspx?rootMenuId=-1", true);
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('用户名或密码错误!');</script>");
}
}
protected Hashtable GetUserInfo()
{
Hashtable hTable = new Hashtable();
string memberId = HttpContext.Current.Session["MemberId"] == null ? "" : HttpContext.Current.Session["MemberId"].ToString();
if (memberId == null || memberId.ToString() == "")
{
return(hTable);
}
DataTable dtUser = new IACenter().ExecuteSqlDataset("select * from T_Member_Info where memberId=" + memberId + "").Tables[0];
if (dtUser.Rows.Count > 0)
{
hTable.Add("MemberId", dtUser.Rows[0]["memberId"].ToString()); //
hTable.Add("MemberName", dtUser.Rows[0]["memberName"].ToString()); //
hTable.Add("TrueName", dtUser.Rows[0]["TrueName"].ToString()); //
hTable.Add("MemberLevel", dtUser.Rows[0]["memberLevel"].ToString());
hTable.Add("HeadImg", dtUser.Rows[0]["HeadImg"].ToString());
}
return(hTable);
}
protected void BindData()
{
StarTech.Adapter.IACenter iaCenter = new StarTech.Adapter.IACenter();
this.ltMenuName.Text = iaCenter.GetMenuNameById(Int32.Parse(this.menuId));
this.cbxMenu.Checked = iaCenter.CheckIsGroupMenu(Int32.Parse(this.menuId), Int32.Parse(this.groupId));
DataSet ds = iaCenter.GetSystemButtons();
this.cbxButtons.DataSource = ds;
this.cbxButtons.DataTextField = "buttonName";
this.cbxButtons.DataValueField = "uniqueId";
this.cbxButtons.DataBind();
string buttons = iaCenter.GetAllButtons(Int32.Parse(this.menuId), this.groupId);
buttons = "," + buttons + ",";
foreach (ListItem item in this.cbxButtons.Items)
{
if (buttons.IndexOf("," + item.Value + ",") > -1)
{
item.Selected = true;
}
}
}
protected Hashtable GetUserInfo()
{
Hashtable hTable = new Hashtable();
if (Session["UserInfo"] != null)
{
hTable = (Hashtable)Session["UserInfo"];
}
else
{
DataTable dtUser = new IACenter().GetUserInfoByUserId(int.Parse(Session["UserId"].ToString()));
if (dtUser != null && dtUser.Rows.Count > 0)
{
hTable.Add("UserId", dtUser.Rows[0]["uniqueId"].ToString());
hTable.Add("UserName", dtUser.Rows[0]["userName"].ToString());
hTable.Add("TrueName", dtUser.Rows[0]["trueName"].ToString());
hTable.Add("DepartCode", dtUser.Rows[0]["departId"].ToString());
hTable.Add("DepartName", dtUser.Rows[0]["departId"].ToString());
}
Session["UserInfo"] = hTable;
}
return(hTable);
}
protected string GetRootMenus(string userId)
{
return("1");
string ids = "";
StarTech.Adapter.IACenter iacenter = new StarTech.Adapter.IACenter();
DataSet dsMenus = iacenter.GetAllMenusByUserId(Int32.Parse(userId));
if (dsMenus != null)
{
DataRow[] rowsMenus2 = dsMenus.Tables[0].Select("parentMenuId=0 and isAreaMenu=1");
foreach (DataRow rowMenus2 in rowsMenus2)
{
ids += rowMenus2["uniqueId"].ToString() + ",";
}
return(ids);
}
else
{
return("");
}
}
