/// <summary> /// 删除一级信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDelOne_Click(object sender, EventArgs e) { string hidValue = this.hidOne.Value.TrimEnd(','); if (hidValue.Length == 0) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('请选择要删除的信息!');", true); return; } string[] arr = hidValue.Split(','); if (arr.Length > 1) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('只能选择一项信息进行删除!');", true); return; } int num = OALevelService.Delete(Convert.ToInt32(arr[0])); if (num > 0) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('删除成功!');location.href='levelMenu.aspx'", true); } else { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('删除失败!');location.href='levelMenu.aspx'", true); } }
/// <summary> /// 添加一级信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAddOne_Click(object sender, EventArgs e) { string pName = this.txtOne.Text.Trim(); if (pName.Length == 0) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('名称不能为空!');", true); return; } OALevel item = new OALevel(); item.levelName = pName; item.levelNO = OALevelService.GetMaxLevelNo(0); item.isParent = 0; item.url = ""; item.parentLevelNo = 0; item.status = 0; item.remark = ""; int num = OALevelService.Add(item); if (num > 0) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('添加成功!');", true); } LoadOneInfo(); }
/// <summary> /// 修改一级信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnModOne_Click(object sender, EventArgs e) { string name = this.txtOne.Text.Trim(); if (name.Length == 0) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('名称不能为空!');", true); return; } string hidValue = this.hidOne.Value.TrimEnd(','); if (hidValue.Length == 0) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('请选择要修改的信息!');", true); return; } string[] arr = hidValue.Split(','); if (arr.Length > 1) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('只能选择一项信息进行修改!');", true); return; } OALevelService.Update(Convert.ToInt32(arr[0]), name, ""); ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('修改成功!');location.href='levelMenu.aspx'", true); }
/// <summary> /// 修改二级信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnModTwo_Click(object sender, EventArgs e) { string name = this.txtTwo.Text.Trim(); if (name.Length == 0) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('二级分类名称不能为空!');", true); return; } string hidValue = this.hidTwo.Value.TrimEnd(','); if (hidValue.Length == 0) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('请选择要修改的信息!');", true); return; } string[] arr = hidValue.Split(','); if (arr.Length > 1) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('只能选择一项信息进行修改!');", true); return; } string url = txtURL.Text.Trim(); OALevelService.Update(Convert.ToInt32(arr[0]), name, url); ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('修改成功!');", true); GetTwo(this.ddlOne.SelectedValue); }
/// <summary> /// 权限更新 /// </summary> private void UpdatePrivilege() { //先Delete已有的重新添加 string sql = "delete from SysPrivileges where roleId = " + roleId; int rows = DBHelperSQL.ExecuteSql(sql); if (strLevelNo.Length == 0 && rows > 0) { Response.Write("success"); } else { string[] arr = strLevelNo.TrimEnd(',').Split(','); int num = 5; SysPrivileges item = null; StringBuilder sb = new StringBuilder(); if (arr.Length > 0) { for (int i = 0; i < arr.Length; i++) { item = new SysPrivileges(); item.roleId = roleId; item.departmentId = departId; if (arr[i] != "on") { item.levelNo = Convert.ToInt32(arr[i]); } item.parentLevelNo = OALevelService.GetparentLevelNoByLevelNo(item.levelNo); if (!SysPrivilegesService.Exists(item.roleId, item.departmentId, item.levelNo)) { num = SysPrivilegesService.Add(item); if (num == 0) { sb.Append("权限编号:" + item.levelNo + "添加失败,"); } } } } if (num == 0) { Response.Write(sb.ToString()); } else { Response.Write("success"); } } }
/// <summary> /// 一级信息加载 /// </summary> /// <returns></returns> protected string GetOneInfo() { StringBuilder sb = new StringBuilder(); DataSet ds = OALevelService.GetList("parentLevelNo = 0"); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { sb.Append("<label class=\"preview\"><input type=\"radio\" id='one" + dr["id"] + "' name='one' onclick=\"getOneMenuInfo(" + dr["id"] + ",'" + dr["levelName"] + "',this);\" />" + dr["levelName"] + "</label>"); } } return(sb.ToString()); }
/// <summary> /// 加载一级信息 /// </summary> private void LoadOneInfo() { DataSet ds = OALevelService.GetList("parentLevelNo = 0"); if (ds.Tables[0].Rows.Count > 0) { ddlOne.Items.Clear(); ddlOne.DataSource = ds; ddlOne.DataTextField = "levelName"; ddlOne.DataValueField = "id"; ddlOne.DataBind(); //this.ddlProvince.SelectedValue = "1"; } ddlOne.Items.Insert(0, new ListItem("请选择一级分类", "0")); }
/// <summary> /// 添加二级信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAddTwo_Click(object sender, EventArgs e) { string pid = this.ddlOne.SelectedValue; if (pid == "0") { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('请选择一级分类!');", true); return; } string twoName = this.txtTwo.Text.Trim(); if (twoName.Length == 0) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('二级分类名称不能为空!');", true); return; } OALevel item = new OALevel(); item.levelName = twoName; item.isParent = 0; item.url = txtURL.Text.Trim(); OALevel parentItem = OALevelService.GetModel(Convert.ToInt32(pid)); if (parentItem != null) { item.parentLevelNo = parentItem.levelNO; } else { item.parentLevelNo = 0; } item.levelNO = OALevelService.GetMaxLevelNo(item.parentLevelNo); item.status = 0; item.remark = ""; int num = OALevelService.Add(item); if (num > 0) { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('添加成功!');", true); } else { ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "alert('添加失败!');", true); } GetTwo(pid); }
/// <summary> /// 一级权限菜单信息加载 /// </summary> /// <returns></returns> private void GetTwo(string pid) { StringBuilder sb = new StringBuilder(); if (pid != "0") { OALevel item = OALevelService.GetModel(Convert.ToInt32(pid)); if (item != null) { DataSet ds = OALevelService.GetList("parentLevelNo = " + item.levelNO); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { sb.Append("<label class=\"preview\"><input type=\"radio\" id='city" + dr["id"] + "' name='city' onclick=\"getTwoInfo(" + dr["id"] + ",'" + dr["levelName"] + "',this,'" + dr["url"] + "');\" />" + dr["levelName"] + "</label>"); } } } } ViewState["twoInfo"] = sb.ToString(); }
/// <summary> /// 返回菜单信息 /// </summary> /// <returns></returns> protected string GetMenu() { StringBuilder sb = new StringBuilder(); AdminUser item = Session["loginUser"] as AdminUser; DataSet ds = SysPrivilegesService.GetLevelInfo(item.roleId, 3); int menuCount = SysPrivilegesService.GetSonCount(item.roleId, 3); //总数 int nowNode = 1; if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { OALevel levelItem = OALevelService.GetModelByLevelNo(Convert.ToInt32(ds.Tables[0].Rows[i]["levelNo"])); if (levelItem != null) { sb.Append("<div class=\"left_tab\" style=\"padding-left:30px;\">" + levelItem.levelName + "</div>"); sb.Append("<ul>"); DataSet ds2 = SysPrivilegesService.GetSonInfo(Convert.ToInt32(ViewState["role"]), 3, Convert.ToInt32(ds.Tables[0].Rows[i]["levelNo"])); if (ds2.Tables[0].Rows.Count > 0) { for (int j = 0; j < ds2.Tables[0].Rows.Count; j++) { levelItem = OALevelService.GetModelByLevelNo(Convert.ToInt32(ds2.Tables[0].Rows[j]["levelNo"])); if (levelItem != null) { sb.Append("<li id=\"m_" + nowNode + "\" onClick=\"dis_cont('" + levelItem.url + "'," + nowNode + "," + ViewState["role"] + "," + menuCount + ")\">" + levelItem.levelName + "</li>"); nowNode++; } } } sb.Append("</ul>"); } } } return(sb.ToString()); }
private void LoadLevelTree(int roleId, int departId) { DataSet ds = OALevelService.GetList("parentLevelNo = 0"); //顶级信息 DataSet ds1 = new DataSet(); //存放一级菜单信息 DataSet ds2 = new DataSet(); //存放二级菜单信息 // StringBuilder sb = new StringBuilder(); //存储第三级复选框的id信息 if (ds.Tables[0].Rows.Count > 0) { StringBuilder sb = new StringBuilder(); TreeNode tn = null; TreeNode tn1 = null; TreeNode tn2 = null; string levelNo0 = ""; string levelNo1 = ""; string levelNo2 = ""; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { tn = new TreeNode(); levelNo0 = ds.Tables[0].Rows[i]["levelNo"].ToString(); ds1 = OALevelService.GetList("parentLevelNo = '" + levelNo0 + "'"); if (SysPrivilegesService.Exists(roleId, departId, Convert.ToInt32(levelNo0))) { tn.Text = "<input type='checkbox' id='" + i + "' onclick='check(this," + ds1.Tables[0].Rows.Count + ")' value='" + ds.Tables[0].Rows[i]["levelNo"].ToString() + "' checked='checked' />" + ds.Tables[0].Rows[i]["levelName"].ToString(); } else { tn.Text = "<input type='checkbox' id='" + i + "' onclick='check(this," + ds1.Tables[0].Rows.Count + ")' value='" + ds.Tables[0].Rows[i]["levelNo"].ToString() + "' />" + ds.Tables[0].Rows[i]["levelName"].ToString(); } #region 一级菜单信息的加载 if (ds1.Tables[0].Rows.Count > 0) { for (int j = 0; j < ds1.Tables[0].Rows.Count; j++) { tn1 = new TreeNode(); levelNo1 = ds1.Tables[0].Rows[j]["levelNo"].ToString(); ds2 = OALevelService.GetList("parentLevelNo = '" + levelNo1 + "'"); if (SysPrivilegesService.Exists(roleId, departId, Convert.ToInt32(levelNo1))) { tn1.Text = "<input type='checkbox' id='" + i + "_" + j + "' onclick='check2(this," + ds2.Tables[0].Rows.Count + ")' value='" + ds1.Tables[0].Rows[j]["levelNo"].ToString() + "' checked='checked' />" + ds1.Tables[0].Rows[j]["levelName"].ToString(); } else { tn1.Text = "<input type='checkbox' id='" + i + "_" + j + "' onclick='check2(this," + ds2.Tables[0].Rows.Count + ")' value='" + ds1.Tables[0].Rows[j]["levelNo"].ToString() + "' />" + ds1.Tables[0].Rows[j]["levelName"].ToString(); } #region 二级菜单信息的加载 //this.level2Count.Value = ds2.Tables[0].Rows.Count.ToString(); //二级菜单的子类数量 if (ds2.Tables[0].Rows.Count > 0) { for (int k = 0; k < ds2.Tables[0].Rows.Count; k++) { tn2 = new TreeNode(); levelNo2 = ds2.Tables[0].Rows[k]["levelNo"].ToString(); sb.Append((i + "_" + j + "_" + k).ToString() + ","); if (SysPrivilegesService.Exists(roleId, departId, Convert.ToInt32(levelNo2))) { tn2.Text = "<input type='checkbox' id='" + i + "_" + j + "_" + k + "' onclick='check3(this)' value='" + ds2.Tables[0].Rows[k]["levelNo"].ToString() + "' checked='checked' />" + ds2.Tables[0].Rows[k]["levelName"].ToString(); } else { tn2.Text = "<input type='checkbox' id='" + i + "_" + j + "_" + k + "' onclick='check3(this)' value='" + ds2.Tables[0].Rows[k]["levelNo"].ToString() + "' />" + ds2.Tables[0].Rows[k]["levelName"].ToString(); } tn1.ChildNodes.Add(tn2); } } #endregion tn.ChildNodes.Add(tn1); //一级菜单追加到顶级菜单节点下。 } } #endregion this.tvModel.Nodes.Add(tn); //顶级菜单追加到权限树上 } tvModel.CollapseAll(); this.hidRowsCount.Value = sb.ToString().TrimEnd(','); } }