authoritymanage.aspx.cs

用ASP.NET（C#）、SQL Server2000数据库开发在线考试系统源代码

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.Data.SqlClient;

namespace ExamineSystem
{
	/// <summary>
	/// Summary description for AuthorityManage.
	/// </summary>
	public class AuthorityManage : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Button ApplyOwner;
		protected System.Web.UI.WebControls.DropDownList UserList;
		protected System.Web.UI.WebControls.ListBox RoleList;
		protected System.Web.UI.WebControls.Label RoleName;
		protected System.Web.UI.HtmlControls.HtmlGenericControl title;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			////验证用户的权限
			if(Session["UserID"] == null)
			{
				Response.Redirect("~/Default.aspx");
			}
			

			if(!Page.IsPostBack)
			{
				BindUserData();

				BindRoleData();

				if(UserList.SelectedIndex > -1)
				{
					///当存在用户时，绑定该用户的的权限列表
					BindUserRoleData(Int32.Parse(UserList.SelectedValue));
				}
			}
		}

		private void BindUserData()
		{
			UserList.Items.Clear();

			UserDB user = new UserDB();
			SqlDataReader recu = user.GetUsers();

			UserList.DataSource = recu;
			UserList.DataTextField = "UserName";
			UserList.DataValueField = "UserID";
			UserList.DataBind();

			recu.Close();
		}

		private void BindRoleData()
		{
			RoleList.Items.Clear();

			RoleDB role = new RoleDB();
			SqlDataReader recr = role.GetRoles();

			RoleList.DataSource = recr;
			RoleList.DataTextField = "RoleName";
			RoleList.DataValueField = "RoleID";
			RoleList.DataBind();

			recr.Close();
			if(RoleList.Items.Count > 0)
			{
				ApplyOwner.Enabled = true;
			}
			else
			{
				ApplyOwner.Enabled = false;
			}
		}

		private void BindUserRoleData(int nUserID)
		{
			if(UserList.Items.Count > 0)
			{
				UserDB user = new UserDB();
				SqlDataReader recu = user.GetSingleUser(nUserID);
				while(recu.Read())
				{
					RoleName.Text = recu["RoleName"].ToString();
				}
				recu.Close();
			}
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.UserList.SelectedIndexChanged += new System.EventHandler(this.UserList_SelectedIndexChanged);
			this.ApplyOwner.Click += new System.EventHandler(this.ApplyOwner_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void UserList_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if(UserList.SelectedIndex > -1)
			{
				BindUserRoleData(Int32.Parse(UserList.SelectedValue));
			}
		}

		private void ApplyOwner_Click(object sender, System.EventArgs e)
		{
			if(UserList.SelectedIndex > -1 && RoleList.SelectedIndex > -1)
			{
				UserDB user = new UserDB();
				user.UpdateUserRole(Int32.Parse(UserList.SelectedValue),Int32.Parse(RoleList.SelectedValue));
				BindUserRoleData(Int32.Parse(UserList.SelectedValue));
				RoleList.SelectedIndex = -1;
			}
			else
			{
				Response.Write("<script>alert(\"请选择你的数据项！\")</script>");
			}
		}
	}
}