userright.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;
using System.Configuration;
using  gyit.Data;

namespace itcrm.admin
{
	/// <summary>
	/// UserRight 的摘要说明。
	/// </summary>
	public class UserRight : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.ListBox lstHaveMenu;
		protected System.Web.UI.WebControls.Button btnDelOne;
		protected System.Web.UI.WebControls.Button btnAddOne;
		protected System.Web.UI.WebControls.ListBox lstMenu;
		protected System.Web.UI.WebControls.ListBox lstRole;
	    DBOperator db;
		private void Page_Load(object sender, System.EventArgs e)
		{
			db =DBOperator.CreateObject((string)ConfigurationSettings.AppSettings["DSN"]);
			if(!Page.IsPostBack)
				BindUser();
			    BindRole();
		}

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

		}
		#endregion


//*** 绑定用户
		private void BindUser()
		{
			string strSql="select UserID,UserName from Admin";
			DataSet ds=null;
			db.Open();
			ds=db.exeSqlForDataSet(strSql);
			db.Close();
			lstRole.DataSource=ds;
			lstRole.DataValueField="UserID";
			lstRole.DataTextField="UserName";
			lstRole.DataBind();
			lstRole.Dispose();
			ds.Dispose();
		}
//*** 绑定权限
		private void BindRole()
		{
			string strSql="select RoleID,RoleName from Role";
			DataSet ds=null;
			db.Open();
			ds=db.exeSqlForDataSet(strSql);
			db.Close();
			lstMenu.DataSource=ds;
			lstMenu.DataValueField="RoleID";
			lstMenu.DataTextField="RoleName";
			lstMenu.DataBind();
			lstMenu.Dispose();
			ds.Dispose();
		}
//已有角色
		private void BindHaveMenu(string who)
		{
			
			string strSql="select R.RoleID,R.RoleName,U.UserID,U.RoleID from Role R,UserRight U where R.RoleID in(select RoleID from UserRight where UserID='"+who+"')and U.RoleID=R.RoleID and U.UserID='"+who+"'";
			DataSet ds=new DataSet();
			db.Open();
			ds=db.exeSqlForDataSet(strSql);
			db.Close();
			try
			{
				lstHaveMenu.DataSource=ds;
				lstHaveMenu.DataTextField="RoleName";
				lstHaveMenu.DataValueField="RoleID";
				lstHaveMenu.DataBind();
				lstHaveMenu.Dispose();
				
				
			}
			catch(System.Exception ee)
			{
				Page.Response.Write("<br>"+ee.Message);
			}
			if(ds!=null)
				lstHaveMenu.Dispose();
			    ds.Dispose();
					
		}
//*** 下拉列表触发
		private void lstRole_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if(lstRole.SelectedIndex>-1)
			{
				BindHaveMenu(lstRole.SelectedItem.Value);
				
			}
		}
//*** 单项增加
		private void btnAddOne_Click(object sender, System.EventArgs e)
		{
			 if(lstMenu.SelectedIndex>-1)
			 AddOne();
		
		}
//*** 单项增加
		private void AddOne()
		{
			string[] strPara =new string[2];
			object[] strValues=new object[2];

			strPara[0]="@UserID";
			strPara[1]="@RoleID";
        
			if(lstRole.SelectedIndex>-1)
				strValues[0]=lstRole.SelectedItem.Value;
			if(lstMenu.SelectedIndex>-1)
				strValues[1]=lstMenu.SelectedItem.Value;
			try
			{
				db.Open();
				db.exeProc("Add_UserRight",strPara,strValues);
				db.Close();
				BindHaveMenu(lstRole.SelectedItem.Value);
			}
			catch(System.Exception ee)
			{
				Page.Response.Write("<br>"+ee.Message);
			}

		}
//******删除
		private void btnDelOne_Click(object sender, System.EventArgs e)
		{
			if(lstHaveMenu.SelectedIndex>-1)
			DelOne(lstHaveMenu.SelectedItem.Value);
		}
//*** 单项删除
		private void DelOne(string who)
		{
			string strSql="delete from UserRight where RoleID='"+who+"'";
			db.Open();
			db.exeSql(strSql);
			db.Close();
			BindHaveMenu(lstRole.SelectedItem.Value);
		}
	}
}