测评登录.aspx.cs

本系统以ASP.NET为开发平台

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 Web
{
	/// <summary>
	/// WebForm2 的摘要说明。
	/// </summary>
	public class WebForm2 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Image Image1;
		protected System.Web.UI.WebControls.Image Image2;
		protected System.Web.UI.HtmlControls.HtmlGenericControl SPAN3;
		protected System.Web.UI.HtmlControls.HtmlGenericControl FONT1;
		protected System.Web.UI.HtmlControls.HtmlGenericControl Span4;
		protected System.Web.UI.HtmlControls.HtmlGenericControl Font2;
		protected System.Web.UI.HtmlControls.HtmlGenericControl Span5;
		protected System.Web.UI.HtmlControls.HtmlGenericControl Font3;
		protected System.Web.UI.HtmlControls.HtmlGenericControl Span6;
		protected System.Web.UI.HtmlControls.HtmlGenericControl Font4;
		protected System.Web.UI.HtmlControls.HtmlGenericControl Span1;
		protected System.Web.UI.HtmlControls.HtmlGenericControl Font5;
		protected System.Web.UI.HtmlControls.HtmlGenericControl Span2;
		protected System.Web.UI.HtmlControls.HtmlGenericControl Font9;
		protected System.Web.UI.HtmlControls.HtmlGenericControl Span12;
		protected System.Web.UI.HtmlControls.HtmlGenericControl Font12;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.HyperLink HyperLink19;
		protected System.Web.UI.WebControls.HyperLink HyperLink23;
		protected System.Web.UI.WebControls.HyperLink HyperLink24;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.TextBox TextBox2;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.TextBox TextBox3;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.TextBox TextBox4;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.TextBox TextBox5;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.Button Button3;
		protected System.Web.UI.WebControls.Button Button4;
		protected System.Web.UI.WebControls.Label Label8;
		protected System.Web.UI.WebControls.TextBox TextBox6;
		protected System.Web.UI.WebControls.Label Label9;
		protected System.Web.UI.WebControls.TextBox TextBox7;
		protected System.Web.UI.WebControls.Label Label10;
		protected System.Web.UI.WebControls.Button Button5;
		protected System.Web.UI.WebControls.Button Button6;
		protected System.Web.UI.WebControls.Label Label4;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
		}

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

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{
			if(TextBox2.Text!=""&&TextBox3.Text!="")
			{										 
				SqlConnection conn=new SqlConnection("Server=.;database=学生综合素质测评系统;uid=sa;password=");
				conn.Open();
				string sql="select * from 学生 where (学号='"+TextBox2.Text+"') and (密码='"+TextBox3.Text+"')";
				SqlCommand mycom=new SqlCommand(sql,conn);
				SqlDataReader mydr=mycom.ExecuteReader();
				if (mydr.Read()==true)
				{
					
					Response.Redirect("学生登录成功.aspx");
				}
				else
					Label4.Text="输入了错误的帐号/密码，请重新输入！";
				  
			}
		}
		private void Button2_Click(object sender, System.EventArgs e)
		{
			TextBox2.Text="";
			TextBox3.Text="";
		}

		private void Button3_Click(object sender, System.EventArgs e)
		{
			if(TextBox4.Text!=""&&TextBox5.Text!="")
			{										 
				SqlConnection conn=new SqlConnection("Server=.;database=学生综合素质测评系统;uid=sa;password=");
				conn.Open();
				string sql="select * from 班委 where (帐号='"+TextBox4.Text+"') and (密码='"+TextBox5.Text+"')";
				SqlCommand mycom=new SqlCommand(sql,conn);
				SqlDataReader mydr=mycom.ExecuteReader();
				if (mydr.Read()==true)
				{
					
					Response.Redirect("班委登录成功.aspx");
				}
				else
					Label7.Text="输入了错误的帐号/密码，请重新输入！";
			}
		}
			private void Button4_Click(object sender, System.EventArgs e)
			{
				TextBox4.Text="";
				TextBox5.Text="";
			}

		private void Button5_Click(object sender, System.EventArgs e)
		{
			if(TextBox6.Text!=""&&TextBox7.Text!="")
			{										 
				SqlConnection conn=new SqlConnection("Server=.;database=学生综合素质测评系统;uid=sa;password=");
				conn.Open();
				string sql="select * from 辅导员 where (帐号='"+TextBox6.Text+"') and (密码='"+TextBox7.Text+"')";
				SqlCommand mycom=new SqlCommand(sql,conn);
				SqlDataReader mydr=mycom.ExecuteReader();
				if (mydr.Read()==true)
				{
					
					Response.Redirect("辅导员登录成功.aspx");
				}
				else
					Label10.Text="输入了错误的帐号/密码，请重新输入！";
			}
		}
		private void Button6_Click(object sender, System.EventArgs e)
		{
			TextBox6.Text="";
			TextBox7.Text="";
		}
	}
}