[原创]使用Microsoft.Web.UI.WebControls的iewc轻松解决权限树问题（无限级权限管理）4

Purview_User_Manage_Top.aspx.cs：用户权限管理之 选择用户


using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace YljWeb._Admin.Purview_Manage
{
 /// <summary>
 /// Purview_User_Manage_Top 的摘要说明。
 /// </summary>
 public class Purview_User_Manage_Top : System.Web.UI.Page
 {
  protected System.Web.UI.WebControls.Label lbl_Select_Username;
  protected System.Web.UI.WebControls.DropDownList ddl_username;
 
  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   this.ddl_username.Attributes.Add("onchange","javascript:self.location=\"?username=\"+this.options[this.selectedIndex].value");
   if(!Page.IsPostBack)//该页是否是为响应客户端而产生的或者是否是首次访问，系统自动生成
   {
    DropBind();
   }
   if( Request["username"] != null)
   {
    Session["Purview_User_Username"] = Request["username"];
    this.lbl_Select_Username.Text = Session["Purview_User_Username"].ToString();
    this.ddl_username.SelectedValue = Session["Purview_User_Username"].ToString();
    this.Response.Write("<script language=\"javascript\">parent.location.reload();</"+"script>");
   }
   if( Session["Purview_User_Username"] != null)
   {
    this.lbl_Select_Username.Text = Session["Purview_User_Username"].ToString();
    this.ddl_username.SelectedValue = Session["Purview_User_Username"].ToString();
   }
  }

  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {   
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion
  private void DropBind()
  {
   string strSql = "Select * from AdminUser";
   DataSet myds1= new DataSet();
   myds1 = YljWeb.Classes.SqlConn.ExecuteSqlForDataSet(strSql);
   ///////////////  填充 搜索 中下拉列表  ///////////
   this.ddl_username.DataSource = myds1.Tables[0].DefaultView;   
   this.ddl_username.DataTextField = "username"; 
   this.ddl_username.DataValueField = "username"; 
   this.ddl_username.DataBind();
   ////////////////  以下两条代码为什么会无效？ 而在 News_Add.aspx 中却有效   ///////////////////////////////////////////
   this.ddl_username.Items.Add(new ListItem(" 请选择用户 ","0"));
   this.ddl_username.SelectedValue="0";
  }

 }
}

Purview_User_Manage_Left.aspx：系统所有的权限（功能）树

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace YljWeb._Admin.Purview_Manage
{
 /// <summary>
 /// Purview_User_Manage_Left 的摘要说明。
 /// </summary>
 public class Purview_User_Manage_Left : System.Web.UI.Page
 {
  protected Microsoft.Web.UI.WebControls.TreeView TreeViewAll;
  protected System.Web.UI.WebControls.Label lbl_Curnodeid;
  
  protected YljWeb.Classes.TreeControl tree=new YljWeb.Classes.TreeControl();
 
  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   if(!Page.IsPostBack)//该页是否是为响应客户端而产生的或者是否是首次访问，系统自动生成
   {
    BindTreeViewAll();
   }
  }

  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {   
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion
  private void BindTreeViewAll()
  {
   string str_Sql="select * from Purview_All order by order_id";
   if (YljWeb.Classes.SqlConn.IsExist(str_Sql)) // 遍历树
   {
    tree.BindTreeView1("nodeid","parentid","location","mytext",str_Sql,"middFrame","Purview_User_Manage_Midd.aspx",lbl_Curnodeid,TreeViewAll); 
   }

  }
 }
}

Purview_User_Manage_Midd.aspx：用户权限管理的操作部分

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace YljWeb._Admin.Purview_Manage
{
 /// <summary>
 /// Purview_User_Manage_Midd 的摘要说明。
 /// </summary>
 public class Purview_User_Manage_Midd : System.Web.UI.Page
 {
  protected System.Web.UI.WebControls.Label lbl_select_node;
  protected System.Web.UI.WebControls.Button btn_purview_add;
  protected System.Web.UI.WebControls.Label lbl_purview_retract;
  protected System.Web.UI.WebControls.Button btn_purview_retract;
  protected string selusername;
  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   if(Request["location"]!=null )
   {
    if( Session["Purview_User_Username"]!=null)
    {
     selusername = Session["Purview_User_Username"].ToString();
     this.lbl_select_node.Text = Request["location"].ToString();
     this.lbl_select_node.Visible = false;
     this.btn_purview_add.Enabled = true;
     if(Request["location"].ToString() != "0_1_")
     {
      Check_ParentNode_State();
     }
    }
    else
    {
     this.ShowErrMsg("请先选择用户！");
    }
   }
   if(Request["location2"]!=null && Session["Purview_User_Username"]!=null)
   {
    
    if( Session["Purview_User_Username"]!=null)
    {
     this.lbl_purview_retract.Text = Request["location2"].ToString();
     this.lbl_purview_retract.Visible = false;
     this.btn_purview_retract.Enabled = true;
     selusername = Session["Purview_User_Username"].ToString();
    }   
    else
    {
     this.ShowErrMsg("请先选择用户！");
    }
   }
  }

  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {   
   this.btn_purview_add.Click += new System.EventHandler(this.btn_purview_add_Click);
   this.btn_purview_retract.Click += new System.EventHandler(this.btn_purview_retract_Click);
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion

  private void btn_purview_retract_Click(object sender, System.EventArgs e)
  {
   string strSqlUpdate="Update Purview_User_Have set state = 0  where username='"+ selusername +"' and location like '"+ this.lbl_purview_retract.Text +"%'";
   YljWeb.Classes.SqlConn.ExecuteSql(strSqlUpdate);
   this.lbl_purview_retract.Text = "成功收回";
   this.Response.Write("<script language=\"javascript\">parent.frames(\"rightFrame\").document.location.reload();</"+"script>");
   Response.Write("<meta http-equiv=refresh content=0;url=Purview_User_Manage_Midd.aspx>");
  }

  private void btn_purview_add_Click(object sender, System.EventArgs e)
  {
   string strSqlUpdate="Update Purview_User_Have set state = 1  where username='"+ selusername +"' and location = '"+ this.lbl_select_node.Text +"'";
   YljWeb.Classes.SqlConn.ExecuteSql(strSqlUpdate);
   this.lbl_select_node.Text = "成功填加";
   this.Response.Write("<script language=\"javascript\">parent.frames(\"rightFrame\").document.location.reload();</"+"script>");
   Response.Write("<meta http-equiv=refresh content=0;url=Purview_User_Manage_Midd.aspx>");
  }
  private void Check_ParentNode_State()
  {
   string str_Sql="select parentid from Purview_User_Have where username='"+ selusername +"' and  location = '"+ Request["location"].ToString() +"'";
   DataSet ds = YljWeb.Classes.SqlConn.ExecuteSqlForDataSet(str_Sql);
   DataRow dr =  ds.Tables[0].Rows[0];
   string str_parentid = dr[0].ToString();
   string str_Sql2="select * from Purview_User_Have where username='"+ selusername +"' and location = '"+ str_parentid +"' and state = 1 ";
   if( !YljWeb.Classes.SqlConn.IsExist(str_Sql2) )
   {
    this.ShowErrMsg("请先填加其上一级权限！");
    this.lbl_select_node.Text = "";
    this.btn_purview_add.Enabled = false;
   }
  }
  /// <summary>
  /// //////////////////////////////  弹出消息框  ////////////////////////////////////////
  /// </summary>
  /// <param name="MsgStr"></param>
  private void ShowErrMsg(string MsgStr)
  {
   this.Response.Write("<script language='javascript'>");
   this.Response.Write("alert('" +MsgStr + "');");
   this.Response.Write("</script>");
  }
 }
}

Purview_User_Manage_Right.aspx：用户已经有的权限树

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace YljWeb._Admin.Purview_Manage
{
 /// <summary>
 /// Purview_User_Manage_Right 的摘要说明。
 /// </summary>
 public class Purview_User_Manage_Right : System.Web.UI.Page
 {
  protected Microsoft.Web.UI.WebControls.TreeView TreeViewHave;
  protected System.Web.UI.WebControls.Label lbl_Curnodeid;
 
  protected YljWeb.Classes.TreeControl tree=new YljWeb.Classes.TreeControl();
 
  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   if(!Page.IsPostBack)//该页是否是为响应客户端而产生的或者是否是首次访问，系统自动生成
   {
    if( Session["Purview_User_Username"] != null)
    {
     BindTreeViewHave();
    }
    else
    {
     this.lbl_Curnodeid.Visible = true;
     this.lbl_Curnodeid.Text = "请选择用户！";
    }
   }
  }

  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {   
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion
  private void BindTreeViewHave()
  {
   string username = Session["Purview_User_Username"].ToString();
   string str_Sql="select * from Purview_User_Have where username ='"+ username +"'and state = 1 order by order_id";
   if (YljWeb.Classes.SqlConn.IsExist(str_Sql)) // 遍历树
   {
    tree.BindTreeView2("nodeid","parentid","location","mytext",str_Sql,"middFrame","Purview_User_Manage_Midd.aspx",lbl_Curnodeid,TreeViewHave);
   }

  }
 }
}

本文地址：http://com.8s8s.com/it/it41241.htm