protected void btnDeleteSelect_Click(object sender, EventArgs e) { if (Session["ZT_ADMIN"] == null) { Response.Redirect("Login.aspx"); } else { if (!Communal.CheckQx("MenuDelete.aspx")) { Response.Redirect("RightsWarn.aspx"); } else { string DeleteTitle = ""; foreach (GridViewRow gr in this.GridView1.Rows) { CheckBox cb = (CheckBox)gr.Cells[1].FindControl("Select"); if (cb.Checked) { //删除数据库信息 Label ll = (Label)gr.Cells[1].FindControl("lblElementID"); int ElementID = Convert.ToInt32(ll.Text); WebProject.BLL.SysManage.ZT_SYS_ElementInfo bll_ElementInfo = new WebProject.BLL.SysManage.ZT_SYS_ElementInfo(); DeleteTitle += bll_ElementInfo.GetModel(ElementID).ElementName + ","; bll_ElementInfo.Delete(ElementID); } } LogManage.WriteLog(Request.UserHostAddress, "菜单管理", "删除菜单", "成功", "菜单名称:" + DeleteTitle.TrimEnd(',') + ", 删除人:" + SessionUtil.GetAdminSession().AdminNo); ShowData(); } } }
public void BindMenu() { try { TreeNode node = null; WebProject.BLL.SysManage.ZT_SYS_ElementInfo bll_ElementInfo = new WebProject.BLL.SysManage.ZT_SYS_ElementInfo(); DataSet ds = bll_ElementInfo.GetMenuList(SessionUtil.GetAdminSession().RoleNo); DataSet nodeview = ds; for (int i = 0; i < nodeview.Tables[0].Rows.Count; i++) { node = new TreeNode(); node.Text = GetName(nodeview.Tables[0].Rows[i]["ParentCode"].ToString()); node.Value = nodeview.Tables[0].Rows[i]["ParentCode"].ToString(); node.Target = "main-frame"; TreeView1.Nodes.Add(node); BindMenuChild(nodeview.Tables[0].Rows[i]["ParentCode"].ToString(), node); } } catch { TreeNode node = null; node = new TreeNode(); node.Text = "无法显示菜单"; node.Value = "无法显示菜单"; TreeView1.Nodes.Add(node); } }
public void ShowData() { if (Request["ElementID"] + "" == "") { Response.Redirect("RightsWarn.aspx"); } else { try { WebProject.BLL.SysManage.ZT_SYS_ElementInfo bll_ElementInfo = new WebProject.BLL.SysManage.ZT_SYS_ElementInfo(); WebProject.Model.SysManage.ZT_SYS_ElementInfo model_ElementInfo = bll_ElementInfo.GetModel(Int32.Parse(Request["ElementID"].ToString())); this.txtElementName.Text = model_ElementInfo.ElementName.ToString(); this.txtElementCode.Text = model_ElementInfo.ElementCode.ToString(); this.txtParentCode.Text = model_ElementInfo.ParentCode.ToString(); this.txtElementLink.Text = model_ElementInfo.ElementLink.ToString(); this.txtElementShow.Text = model_ElementInfo.ElementShow.ToString(); } catch { Response.Redirect("RightsWarn.aspx"); } } }
public void ShowData() { WebProject.BLL.SysManage.ZT_SYS_ElementInfo bll_ElementInfo = new WebProject.BLL.SysManage.ZT_SYS_ElementInfo(); DataSet ds = bll_ElementInfo.GetList(" 1=1 "); if (ds.Tables[0].Rows.Count > 0) { this.lblMessage.Visible = false; this.btnDeleteSelect.Visible = true; this.GridView1.Visible = true; this.GridView1.DataSource = ds; this.GridView1.DataBind(); } else { this.lblMessage.Visible = true; this.btnDeleteSelect.Visible = false; this.GridView1.Visible = false; } }
protected void btnSubmit_Click(object sender, EventArgs e) { if (Session["ZT_ADMIN"] == null) { Response.Redirect("Login.aspx"); } else { if (this.txtElementCode.Text.Trim() == "") { MessageBox.Show(this, "请输入菜单编号!"); return; } if (this.txtElementName.Text.Trim() == "") { MessageBox.Show(this, "请输入菜单名称!"); return; } if (this.txtElementShow.Text.Trim() == "") { MessageBox.Show(this, "请输入菜单是否显示!"); return; } if (this.txtParentCode.Text.Trim() == "") { MessageBox.Show(this, "请输入父级菜单编号!"); return; } WebProject.Model.SysManage.ZT_SYS_ElementInfo model_ElementInfo = new WebProject.Model.SysManage.ZT_SYS_ElementInfo(); model_ElementInfo.ElementName = this.txtElementName.Text.Trim(); model_ElementInfo.ElementCode = this.txtElementCode.Text.Trim(); model_ElementInfo.ParentCode = this.txtParentCode.Text.Trim(); model_ElementInfo.ElementLink = this.txtElementLink.Text.Trim(); model_ElementInfo.ElementShow = this.txtElementShow.Text.Trim(); model_ElementInfo.CreateBy = SessionUtil.GetAdminSession().AdminNo; model_ElementInfo.CreateDate = DateTime.Now; WebProject.BLL.SysManage.ZT_SYS_ElementInfo bll_ElementInfo = new WebProject.BLL.SysManage.ZT_SYS_ElementInfo(); bll_ElementInfo.Add(model_ElementInfo); LogManage.WriteLog(Request.UserHostAddress, "菜单管理", "添加菜单", "成功", "菜单名:" + model_ElementInfo.ElementName + ", 创建人:" + SessionUtil.GetAdminSession().AdminNo); MessageBox.ShowAndRedirect(this, "添加菜单成功!", "MenuList.aspx"); } }
public string GetElementGun(WebProject.Model.SysManage.ZT_SYS_RoleInfo model_RoleInfo) { string Gun = ""; WebProject.BLL.SysManage.ZT_SYS_ElementInfo bll_ElementInfo = new WebProject.BLL.SysManage.ZT_SYS_ElementInfo(); string[] ElementsList = model_RoleInfo.RoleElements.Split(','); string Elements = ""; for (int i = 0; i < ElementsList.Length; i++) { Elements = Elements + "'" + ElementsList[i] + "',"; } Elements = Elements.Substring(0, Elements.Length - 1); DataSet dsGun = bll_ElementInfo.GetList(" (ParentCode <> '0E00' and ParentCode <> '0I00') and ElementShow=0 and ElementCode in (" + Elements + ")"); for (int i = 0; i < dsGun.Tables[0].Rows.Count; i++) { Gun = Gun + "|" + dsGun.Tables[0].Rows[i]["ElementName"]; } return Gun; }
public void BindMenuChild(string ParentCode, TreeNode rootNode) { try { //显示菜单 TreeNode node = null; WebProject.BLL.SysManage.ZT_SYS_ElementInfo bll_ElementInfo = new WebProject.BLL.SysManage.ZT_SYS_ElementInfo(); DataSet ds = bll_ElementInfo.GetMenuItemList(ParentCode, SessionUtil.GetAdminSession().RoleNo); DataSet nodeview = ds; for (int i = 0; i < nodeview.Tables[0].Rows.Count; i++) { node = new TreeNode(); node.Text = nodeview.Tables[0].Rows[i]["ElementName"].ToString(); node.Value = nodeview.Tables[0].Rows[i]["ElementCode"].ToString(); node.NavigateUrl = "javascript:parent.frames['header-frame'].document.getElementById('load-div').style.display='';parent.frames['main-frame'].document.location.href='" + Request.Path.Replace("Left.aspx", nodeview.Tables[0].Rows[i]["ElementLink"].ToString()) + "';"; node.Target = "main-frame"; rootNode.ChildNodes.Add(node); } } catch { } }
public string GetElementSystem(WebProject.Model.SysManage.ZT_SYS_RoleInfo model_RoleInfo) { string System = ""; WebProject.BLL.SysManage.ZT_SYS_ElementInfo bll_ElementInfo = new WebProject.BLL.SysManage.ZT_SYS_ElementInfo(); string[] ElementsList = model_RoleInfo.RoleElements.Split(','); string Elements = ""; for (int i = 0; i < ElementsList.Length; i++) { Elements = Elements + "'" + ElementsList[i] + "',"; } Elements = Elements.Substring(0, Elements.Length - 1); DataSet dsSystem = bll_ElementInfo.GetList(" (ElementShow=1 or ElementShow=2) and ElementCode in (" + Elements + ")"); for (int i = 0; i < dsSystem.Tables[0].Rows.Count; i++) { System = System + "|" + dsSystem.Tables[0].Rows[i]["ElementName"]; } return System; }
private void LoadTree() { this.TreeView1.Nodes.Clear(); TreeNode item = new TreeNode(); item.Text = "系统功能权限"; item.Value = "root"; item.Target = "1"; item.Expanded = true; item.ImageUrl = "Images/tree_to.ico"; TreeView1.Nodes.Add(item); bool blnModule = false; string whereSql = ""; WebProject.BLL.SysManage.ZT_SYS_ElementInfo bll_ElementInfo = new WebProject.BLL.SysManage.ZT_SYS_ElementInfo(); System.Data.DataTable dt1, dt2; DataRow dr; whereSql = " ParentCode='00' and ElementShow = '1'";// order by SequenceNo"; //排序 dt1 = bll_ElementInfo.GetList(whereSql).Tables[0]; if (dt1.Rows.Count == 0) return; for (int i = 0; i < dt1.Rows.Count; i++) //模块 { //T_xt_functionInfo modelInfo = (T_xt_functionInfo)modelList[i]; dr = dt1.Rows[i]; TreeNode module = new TreeNode(); module.Target = "2"; module.ShowCheckBox = true; //module.Checked = true; module.Text = dr["ElementName"].ToString(); module.Value = dr["ElementCode"].ToString(); module.Expanded = false; item.ChildNodes.Add(module); blnModule = false; //获取功能列表 whereSql = " ParentCode='" + dr["ElementCode"].ToString() + "'";// order by SequenceNo"; dt2 = bll_ElementInfo.GetList(whereSql).Tables[0]; if (dt2.Rows.Count == 0) continue; for (int j = 0; j < dt2.Rows.Count; j++) //功能 { dr = dt2.Rows[j]; TreeNode func = new TreeNode(); func.Target = "3"; func.Value = dr["ElementCode"].ToString(); func.Text = dr["ElementName"].ToString(); func.ShowCheckBox = true; //func.Checked = true; func.Checked = this.checkRight(func.Value); module.ChildNodes.Add(func); if (func.Checked) blnModule = true; }//功能 module.Checked = blnModule; }//模块 }
private DataTable BindDataDT() { WebProject.BLL.SysManage.ZT_SYS_ElementInfo bll_ElementInfo = new WebProject.BLL.SysManage.ZT_SYS_ElementInfo(); string whereSql = " ElementShow = '0'";// order by SequenceNo"; //排序 DataTable dtTree = bll_ElementInfo.GetList(whereSql).Tables[0]; return dtTree; }
public static bool CheckQx(string ElementLink) { if (SessionUtil.GetAdminSession().RoleNo + "" == "") { return false; } else { WebProject.BLL.SysManage.ZT_SYS_RoleInfo bll_RoleInfo = new WebProject.BLL.SysManage.ZT_SYS_RoleInfo(); WebProject.Model.SysManage.ZT_SYS_RoleInfo model_RoleInfo = bll_RoleInfo.GetModel(SessionUtil.GetAdminSession().RoleNo); string RoleElements = model_RoleInfo.RoleElements; WebProject.BLL.SysManage.ZT_SYS_ElementInfo bll_ElementInfo = new WebProject.BLL.SysManage.ZT_SYS_ElementInfo(); DataSet ds = bll_ElementInfo.GetList("ElementLink='" + ElementLink + "'"); if (ds.Tables[0].Rows.Count > 0) { string ElementCode = ds.Tables[0].Rows[0]["ElementCode"].ToString(); if (RoleElements.IndexOf(ElementCode) < 0) { return false; } else { return true; } } else { return false; } } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { if (!Communal.CheckQx("MenuDelete.aspx")) { Response.Redirect("RightsWarn.aspx"); } else { //删除数据库的信息 Label ll = (Label)this.GridView1.Rows[e.RowIndex].Cells[1].FindControl("lblElementID"); int ElementID = Convert.ToInt32(ll.Text); WebProject.BLL.SysManage.ZT_SYS_ElementInfo bll_ElementInfo = new WebProject.BLL.SysManage.ZT_SYS_ElementInfo(); LogManage.WriteLog(Request.UserHostAddress, "菜单管理", "删除菜单", "成功", "菜单名称:" + bll_ElementInfo.GetModel(ElementID).ElementName + ", 删除人:" + SessionUtil.GetAdminSession().AdminNo); bll_ElementInfo.Delete(ElementID); //重新加载信息 ShowData(); } }
public string GetName(string str) { WebProject.BLL.SysManage.ZT_SYS_ElementInfo bll_ElementInfo = new WebProject.BLL.SysManage.ZT_SYS_ElementInfo(); return bll_ElementInfo.GetModelList(" ElementCode = '" + str + "'")[0].ElementName; }
protected void btnSubmit_Click(object sender, EventArgs e) { if (Session["ZT_ADMIN"] == null) { Response.Redirect("Login.aspx"); } else { if (this.txtElementCode.Text.Trim() == "") { MessageBox.Show(this, "请输入菜单编号!"); return; } if (this.txtElementName.Text.Trim() == "") { MessageBox.Show(this, "请输入菜单名称!"); return; } if (this.txtElementShow.Text.Trim() == "") { MessageBox.Show(this, "请输入菜单是否显示!"); return; } if (this.txtParentCode.Text.Trim() == "") { MessageBox.Show(this, "请输入父级菜单编号!"); return; } if (Request["ElementID"] + "" == "") { Response.Redirect("RightsWarn.aspx"); } else { try { WebProject.BLL.SysManage.ZT_SYS_ElementInfo bll_ElementInfo = new WebProject.BLL.SysManage.ZT_SYS_ElementInfo(); WebProject.Model.SysManage.ZT_SYS_ElementInfo model_ElementInfo = bll_ElementInfo.GetModel(Int32.Parse(Request["ElementID"].ToString())); model_ElementInfo.ElementName = this.txtElementName.Text.Trim(); model_ElementInfo.ElementCode = this.txtElementCode.Text.Trim(); model_ElementInfo.ParentCode = this.txtParentCode.Text.Trim(); model_ElementInfo.ElementLink = this.txtElementLink.Text.Trim(); model_ElementInfo.ElementShow = this.txtElementShow.Text.Trim(); model_ElementInfo.LastUpdateBy = SessionUtil.GetAdminSession().AdminNo; model_ElementInfo.LastUpdateDate = DateTime.Now; bll_ElementInfo.Update(model_ElementInfo); LogManage.WriteLog(Request.UserHostAddress, "菜单管理", "修改菜单", "成功", "菜单名:" + model_ElementInfo.ElementName + ", 修改人:" + SessionUtil.GetAdminSession().AdminNo); MessageBox.ShowAndRedirect(this, "修改菜单信息成功!", "MenuList.aspx"); } catch { Response.Redirect("RightsWarn.aspx"); } } } }