protected void btnDel_Click(object sender, EventArgs e) { int result = 0; if (Utils.ToInt(nodeValue) > 0) { HoneyWell.Model.Sys_Menu info = new HoneyWell.BLL.Sys_Menu().GetModel(Convert.ToInt32(nodeValue)); HoneyWell.Model.Sys_Logs logs = new HoneyWell.Model.Sys_Logs(); logs.ID = 0; logs.DutyId = Utils.ToInt(GetDutyId()); logs.LoginName = GetUserName(); logs.TitleName = "模块管理"; logs.Depicts = "删除模块信息,名称为:" + info.MenuNameC + ""; logs.CreateTime = DateTime.Now; logs.IpAddress = Request.UserHostAddress; logs.MoreCol1 = ""; logs.MoreCol2 = ""; new HoneyWell.BLL.Sys_Logs().Add(logs); result = new HoneyWell.BLL.Sys_Public().Delete("Sys_Menu", " ID=" + Utils.ToInt(nodeValue) + ""); } if (result > 0) { ScriptManager.RegisterClientScriptBlock(btnSave, GetType(), "", "alert('操作成功!');parent.location='sys_Module_Tree.aspx'", true); } }
protected void btnSave_Click(object sender, EventArgs e) { int result = 0; HoneyWell.Model.Sys_Menu menu = SetObjectValue(); result = new HoneyWell.BLL.Sys_Menu().Add(menu); if (result > 0) { ScriptManager.RegisterClientScriptBlock(btnSave, GetType(), "", "alert('操作成功!');parent.location='sys_Module_Tree.aspx'", true); } }
public void BindData() { if (nodeText != "") { HoneyWell.Model.Sys_Menu sys_Model = new HoneyWell.BLL.Sys_Menu().GetModel(Utils.ToInt(nodeValue)); txt_MenuCode.Value = sys_Model.MenuCode; txt_MenuNameC.Value = sys_Model.MenuNameC; txt_MenuOrder.Value = sys_Model.MenuOrder.ToString(); txt_MenuUrl.Value = sys_Model.MenuUrl; h_ParentID.Value = sys_Model.ParentID.ToString(); h_MenuLevel.Value = sys_Model.MenuLevel.ToString(); } }
public void BindData() { if (Utils.ToInt(nodeValue) > 0) { HoneyWell.Model.Sys_Menu menu = new HoneyWell.BLL.Sys_Menu().GetModel(Utils.ToInt(nodeValue)); h_MenuLevel.Value = menu.MenuLevel.ToString(); lab_ParentName.InnerHtml = menu.MenuNameC; } else { h_MenuLevel.Value = "0"; lab_ParentName.InnerHtml = nodeText; } }
protected void btnSave_Click(object sender, EventArgs e) { bool result = false; HoneyWell.Model.Sys_Menu menu = SetObjectValue(); if (Utils.ToInt(nodeValue) > 0) { result = new HoneyWell.BLL.Sys_Menu().Update(menu); } if (result == true) { ScriptManager.RegisterClientScriptBlock(btnSave, GetType(), "", "alert('操作成功!');location.href='sys_Module_Manage.aspx?nodeText=" + nodeText + "&nodeValue=" + nodeValue + "'", true); } }
/// <summary> /// 绑定模块权限 /// </summary> void BindMenu() { string txt_str = "<table width='90%' border='0' cellspacing='0' cellpadding='0'>"; DataTable dt = new HoneyWell.BLL.Sys_Menu().GetMenuTree("", " and MenuLevel=1 order by MenuOrder").Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { txt_str = txt_str + "<tr>"; txt_str = txt_str + "<td width='10%' align='left' height='25' valign='middle'>" + dt.Rows[i]["MenuNameC"].ToString() + ":</td>"; DataTable dt1 = new HoneyWell.BLL.Sys_Menu().GetMenuTree("", " and ParentID=" + dt.Rows[i]["ID"].ToString() + " and MenuLevel=2 order by MenuOrder").Tables[0]; txt_str = txt_str + "<td width='90%' align='left' height='25' valign='middle'>"; for (int k = 0; k < dt1.Rows.Count; k++) { txt_str = txt_str + " <input type=\"checkbox\" style=\"margin-bottom:7px;\" onclick=\"checkJX(" + dt1.Rows[k]["Id"].ToString() + ");\" name='cb' id=\"cb_" + dt1.Rows[k]["Id"].ToString() + "\" value='" + dt1.Rows[k]["Id"].ToString() + "' ></input>"; txt_str = txt_str + " " + dt1.Rows[k]["MenuNameC"].ToString() + ""; } txt_str = txt_str + "</td>"; txt_str = txt_str + "</tr>"; } txt_str = txt_str + "</table>"; sp_MenuSetting.InnerHtml = txt_str; }
public void BindMenu() { string MenuSetting = ""; string TableName = "Sys_Duty"; string ShowField = " top 1 MenuSetting"; string OrderField = " and ID='" + Request.Cookies["Fadmin"]["DutyID"].ToString() + "'"; DataTable dt_user = new HoneyWell.BLL.Sys_Public().SelectData(ShowField, TableName, OrderField).Tables[0]; if (dt_user != null && dt_user.Rows.Count > 0) { MenuSetting = dt_user.Rows[0]["MenuSetting"].ToString(); } else { Response.Write("<script language='javascript'>alert('非法登陆系统后台@!');selfIn.location.href='Friend.aspx';</script>"); Response.End(); } DataTable dt1 = new HoneyWell.BLL.Sys_Menu().GroupMenuTree("", " and ID in (select ParentID from Sys_Menu where ID in(" + MenuSetting + ") group by ParentID) and MenuLevel='1' order by MenuOrder").Tables[0]; for (int k = 0; k < dt1.Rows.Count; k++) { str_menu += "<div class=\"overall\">"; str_menu += " <div class=\"mainmenu\"><i></i><span>" + dt1.Rows[k]["MenuNameC"].ToString() + "</span> <b></b></div>"; str_menu += " <div class=\"submenu\">"; str_menu += " <ul>"; DataTable dt2 = new HoneyWell.BLL.Sys_Menu().GetMenuTree("", " and ID in (" + MenuSetting + ") and ParentID=" + dt1.Rows[k]["ID"].ToString() + " and MenuLevel='2' order by MenuOrder").Tables[0]; for (int j = 0; j < dt2.Rows.Count; j++) { DataTable dt3 = new HoneyWell.BLL.Sys_Menu().GetMenuTree("", " and ID in (" + MenuSetting + ") and ParentID=" + dt2.Rows[j]["ID"].ToString() + " and MenuLevel='3' order by MenuOrder").Tables[0]; if (dt3 != null && dt3.Rows.Count > 0) { str_menu += "<li>"; str_menu += " <div class=\"second\"><img src=\"images/line1.png\" class=\"dashe\" /><span>" + dt2.Rows[j]["MenuNameC"].ToString() + "</span><i ></i></div>"; str_menu += " <div class=\"three\">"; str_menu += " <ul>"; for (int m = 0; m < dt3.Rows.Count; m++) { string str_style1 = ""; if (dt3.Rows.Count - 1 == m && dt2.Rows.Count - 1 == j) { str_style1 = "style=\"border-bottom:none;\""; } else { str_style1 = ""; } str_menu += "<li " + str_style1 + "><img src=\"images/line1.png\" class=\"threeimg\" /><a href=\"" + dt3.Rows[m]["MenuUrl"].ToString() + "\" target=\"main\"><span>" + dt3.Rows[m]["MenuNameC"].ToString() + "</span></a> <i></i></li>"; } str_menu += " </ul>"; str_menu += " </div>"; } else { string str_style2 = ""; if (dt2.Rows.Count - 1 == j) { str_style2 = "style=\"border-bottom:none;\""; } else { str_style2 = ""; } str_menu += "<li>"; str_menu += " <div class=\"second\" " + str_style2 + "><img src=\"images/line1.png\" class=\"dashe\" /><a href=\"" + dt2.Rows[j]["MenuUrl"].ToString() + "\" target=\"main\"><span>" + dt2.Rows[j]["MenuNameC"].ToString() + "</span></a><i ></i></div>"; } str_menu += "</li>"; } str_menu += " </ul>"; str_menu += " </div>"; str_menu += " </div>"; } }
private DataTable Tree_Table() { DataTable dt = new DataTable(); DataRow dr; dt.Columns.Add(new DataColumn("id", typeof(string))); //id列 类型int dt.Columns.Add(new DataColumn("parent_id", typeof(string))); //父id列 类型int dt.Columns.Add(new DataColumn("name", typeof(string))); //名称列 类型string //构造根节点 dr = dt.NewRow(); var node0 = dr[0] = "0"; dr[1] = DBNull.Value; dr[2] = "根目录"; dt.Rows.Add(dr); //构造一级菜单 string TableName = "Sys_Menu"; string SqlWhere = " and MenuLevel=1 order by MenuOrder asc"; DataSet ds = new HoneyWell.BLL.Sys_Menu().GetMenuTree(TableName, SqlWhere); if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { dr = dt.NewRow(); var node1 = dr[0] = ds.Tables[0].Rows[i]["ID"].ToString(); dr[1] = node0;//(子节点)属于根节点 dr[2] = ds.Tables[0].Rows[i]["MenuNameC"].ToString(); dt.Rows.Add(dr); //构造二级菜单 string SqlWhere1 = " and MenuLevel=2 and ParentID=" + Utils.ToInt(node1) + " order by MenuOrder asc"; DataSet ds1 = new HoneyWell.BLL.Sys_Menu().GetMenuTree("Sys_Menu", SqlWhere1); if (ds1 != null && ds1.Tables[0].Rows.Count > 0) { for (int j = 0; j < ds1.Tables[0].Rows.Count; j++) { dr = dt.NewRow(); var node2 = dr[0] = ds1.Tables[0].Rows[j]["ID"].ToString(); dr[1] = node1; dr[2] = ds1.Tables[0].Rows[j]["MenuNameC"].ToString(); dt.Rows.Add(dr); //构造三级菜单 string SqlWhere2 = " and MenuLevel=3 and ParentID=" + Utils.ToInt(node2) + " order by MenuOrder asc"; DataSet ds2 = new HoneyWell.BLL.Sys_Menu().GetMenuTree("Sys_Menu", SqlWhere2); if (ds2 != null && ds2.Tables[0].Rows.Count > 0) { for (int k = 0; k < ds2.Tables[0].Rows.Count; k++) { dr = dt.NewRow(); var node3 = dr[0] = ds2.Tables[0].Rows[k]["ID"].ToString(); dr[1] = node2; dr[2] = ds2.Tables[0].Rows[k]["MenuNameC"].ToString(); dt.Rows.Add(dr); } } } } } } return(dt); }
/// <summary> /// 绑定单体对象 /// </summary> void BindModel() { BLL.Sys_Duty sys_BLL = new BLL.Sys_Duty(); Model.Sys_Duty sys_Model = sys_BLL.GetModel(PKID); DutyName = sys_Model.DutyName; DutyDesc = sys_Model.DutyDesc; MenuSetting = sys_Model.MenuSetting; string txt_str = "<table width='100%' border='0' cellspacing='0' cellpadding='0'>"; DataTable dt = new HoneyWell.BLL.Sys_Menu().GetMenuTree("", " and MenuLevel=1 order by MenuOrder").Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { txt_str = txt_str + "<tr>"; txt_str = txt_str + "<td width='10%' align='left' valign='top'>" + dt.Rows[i]["MenuNameC"].ToString() + ":</td>"; DataTable dt1 = new HoneyWell.BLL.Sys_Menu().GetMenuTree("", " and ParentID=" + dt.Rows[i]["ID"].ToString() + " and MenuLevel=2 order by MenuOrder").Tables[0]; txt_str = txt_str + "<td width='90%' align='left'>"; txt_str = txt_str + "<table border='0' cellspacing='0' cellpadding='0'>"; txt_str = txt_str + "<tr>"; for (int k = 0; k < dt1.Rows.Count; k++) { string str_checked = ""; if (sys_Model.MenuSetting.ToString().Length > 0) { string[] S_MenuSetting = sys_Model.MenuSetting.ToString().Split(','); for (int j = 0; j < S_MenuSetting.Length; j++) { if (S_MenuSetting[j] == dt1.Rows[k]["ID"].ToString()) { str_checked = "checked='true'"; } } } txt_str = txt_str + "<td align='left'>"; txt_str = txt_str + " <input type=\"checkbox\" " + str_checked + " style=\"margin-bottom:7px;\" onclick=\"checkJX(" + dt1.Rows[k]["Id"].ToString() + ");\" name='cb' id=\"cb_" + dt1.Rows[k]["Id"].ToString() + "\" value='" + dt1.Rows[k]["Id"].ToString() + "' ></input>"; txt_str = txt_str + " " + dt1.Rows[k]["MenuNameC"].ToString() + ""; DataTable dt2 = new HoneyWell.BLL.Sys_Menu().GetMenuTree("", " and ParentID=" + dt1.Rows[k]["ID"].ToString() + " and MenuLevel=3 order by MenuOrder").Tables[0]; if (dt2 != null && dt2.Rows.Count > 0) { txt_str = txt_str + ":<br>"; for (int g = 0; g < dt2.Rows.Count; g++) { string str_checked1 = ""; if (sys_Model.MenuSetting.ToString().Length > 0) { string[] S_MenuSetting1 = sys_Model.MenuSetting.ToString().Split(','); for (int m = 0; m < S_MenuSetting1.Length; m++) { if (S_MenuSetting1[m] == dt2.Rows[g]["ID"].ToString()) { str_checked1 = "checked='true'"; } } } txt_str = txt_str + " <input type=\"checkbox\" " + str_checked1 + " style=\"margin-bottom:7px;\" onclick=\"checkJX(" + dt2.Rows[g]["Id"].ToString() + ");\" name='cb' id=\"cb_" + dt2.Rows[g]["Id"].ToString() + "\" value='" + dt2.Rows[g]["Id"].ToString() + "' ></input>"; txt_str = txt_str + " " + dt2.Rows[g]["MenuNameC"].ToString() + ""; } } txt_str = txt_str + "</td>"; if (k == 5 || k == 11 || k == 17) { txt_str = txt_str + "</tr><tr>"; } } txt_str = txt_str + "</table>"; txt_str = txt_str + "</td>"; txt_str = txt_str + "</tr>"; } txt_str = txt_str + "</table>"; sp_MenuSetting.InnerHtml = txt_str; }