login.aspx.cs

校友管理系统（可以通过excel导入和导出校友信息）

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 UserInfoManage
{
	/// <summary>
	/// Summary description for WebForm1.
	/// </summary>
	public class WebForm1 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label lblWelcome075;
		protected System.Web.UI.WebControls.TextBox txtName075;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredNameValidator075;
		protected System.Web.UI.WebControls.DropDownList drpRole075;
		protected System.Web.UI.WebControls.TextBox txtPwd075;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredPwdValidator075;
		protected System.Web.UI.WebControls.Button btnLogin075;
		protected System.Web.UI.WebControls.CustomValidator PwdCustomValidator075;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.ValidationSummary ValidationSummary075;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// Put user code to initialize the page here
		}

		#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.btnLogin075.Click += new System.EventHandler(this.btnLogin075_Click);
			this.PwdCustomValidator075.ServerValidate += new System.Web.UI.WebControls.ServerValidateEventHandler(this.PwdCustomValidator075_ServerValidate);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void PwdCustomValidator075_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
		{
			string name=this.Request.Form["txtName075"];
			string role=this.Request.Form["drpRole075"];
			string pwd1=this.Request.Form["txtPwd075"];
			System.Data.OleDb.OleDbConnection connection=(System.Data.OleDb.OleDbConnection)this.Session["connection"];
			System.Data.OleDb.OleDbDataAdapter adpt=(System.Data.OleDb.OleDbDataAdapter)this.Session["adpt"];
			if(role.ToLower()=="user")
			{
				adpt.SelectCommand.CommandText="select password from userinfo where name='"+name+"'";
				connection.Open();
				string pwd2=(string)adpt.SelectCommand.ExecuteScalar();
				connection.Close();
				if(pwd2!=null)
				{					
					if(pwd1==pwd2)
					{						
						this.Session["username"]=name;						
					}
					else
					{						
						args.IsValid=false;
					}
				}
				else
				{					
					args.IsValid=false;
				}
			}
			else
			{
				adpt.SelectCommand.CommandText="select password from admininfo where name='"+name+"'";
				connection.Open();
				string pwd2=(string)adpt.SelectCommand.ExecuteScalar();
				connection.Close();				
				if(pwd2!=null)
				{					
					if(pwd1==pwd2)
					{	
						args.IsValid=true;						
					}
					else
					{						
						args.IsValid=false;
					}
				}
				else
				{					
					args.IsValid=false;
				}
			}
		}

		private void btnLogin075_Click(object sender, System.EventArgs e)
		{
			string role=this.Request.Form["drpRole075"];
			if(this.PwdCustomValidator075.IsValid==true)
			{
				if(role.ToLower()=="user")
				{					
					this.Server.Transfer("UserPage.aspx");	
				}
				else
				{
					this.Server.Transfer("AdminPage.aspx");	
				}
			}
		}
	}
}