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