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;
}
