default.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;
using System.Configuration;

namespace ExamineSystem
{
	/// <summary>
	/// Summary description for Default.
	/// </summary>
	public class Default : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.RequiredFieldValidator RFVUserName;
		protected System.Web.UI.WebControls.RequiredFieldValidator RFVPassword;
		protected System.Web.UI.WebControls.Button SureBtn;
		protected System.Web.UI.WebControls.Button CancelBtn;
		protected System.Web.UI.WebControls.DropDownList RoleList;
		protected System.Web.UI.WebControls.TextBox UserName;
		protected System.Web.UI.WebControls.TextBox Password;
		protected System.Web.UI.WebControls.Button RegisterBtn;
		protected System.Web.UI.HtmlControls.HtmlGenericControl title;
		protected System.Web.UI.WebControls.DataGrid NewsList;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!Page.IsPostBack)
			{
				BindRoleData();
				BindNewsData();
			}
		}

		private void BindRoleData()
		{
			RoleDB role = new RoleDB();
			SqlDataReader recr = role.GetRoles();

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

			recr.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.SureBtn.Click += new System.EventHandler(this.SureBtn_Click);
			this.RegisterBtn.Click += new System.EventHandler(this.RegisterBtn_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void SureBtn_Click(object sender, System.EventArgs e)
		{
			UserDB user = new UserDB();
			String userId = "";

			SqlDataReader recu = user.GetUserLogin(UserName.Text.Trim(),UserDB.Encrypt(Password.Text.Trim()));

			if(recu.Read())
			{
				userId = recu["UserID"].ToString();
			}
			recu.Close();			

			if((userId != null)&&(userId != ""))
			{
				SqlDataReader recur = user.GetSingleUser(Int32.Parse(userId));
				if(recur.Read())
				{
					if(RoleList.SelectedValue == recur["RoleID"].ToString())
					{
						Session["UserID"] = userId;
						Session["UserName"] = UserName.Text.Trim();		
						Session["RoleID"] = recur["RoleID"].ToString();
		
						if(RoleList.SelectedValue== "1")
						{
							//返回到初始页面
							Response.Redirect("~/User.aspx");
						}
						if(RoleList.SelectedValue== "2")
						{
							Response.Redirect("~/Admins/AddPaper.aspx");
						}
						if(RoleList.SelectedValue== "3"|| RoleList.SelectedValue== "0")
						{
							Response.Redirect("~/Admins/AuthorityManage.aspx");
						}
					}
					else
					{
						Response.Write("<script>alert(\"你的用户所属角色有误，请重新选择！\")</script>");
					}
				}
				recur.Close();
			}
			else
			{
				Password.Text = "";
				RoleList.SelectedIndex = -1;

				Response.Write("<script>alert(\"你的用户名\\密码有误，请重新输入！\")</script>");
			}
		}

		private void RegisterBtn_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("~/UserRegister.aspx");
		}
		private void BindNewsData()
		{
			NewsList.DataSource = null;
			NewsList.DataBind();

			SqlConnection myConnection = new SqlConnection(DataBaseDB.ConnectionString);
			String cmdText = "SELECT * FROM News";
			SqlCommand myCommand = new SqlCommand(cmdText,myConnection);
			myConnection.Open();
			SqlDataReader recn = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
			//设置控件的数据源，并绑定DataGrid控件数据
			NewsList.DataSource = recn;
			NewsList.DataBind();
			recn.Close();
		}
		private void NewsList_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}
	}
}