login.aspx.cs

课程设计了

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;


public partial class Login : System.Web.UI.Page
{
    protected string sqlconn = System.Configuration.ConfigurationManager.AppSettings["sqconnectionstring"];
    protected void Page_Load(object sender, EventArgs e)
    {

 
			if(!IsPostBack)
			{
			   rnd();
			}

		}


		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    

		}
		#endregion

		public void rnd()//生成随机码
		{
			Random rnd=new Random();
			int rndi=1000+rnd.Next(8999);
			Label1.Text=rndi.ToString();
			Session["rnd"]=rndi;//用Session保寸随机码
		}

		protected void Button1_Click(object sender, System.EventArgs e)
		{
			//判断用户输入随机码和用Session保存的随机码是否一致
			if(Crnd.Text!=Session["rnd"].ToString())//如果不一致，则转向到独立登录页面进行重新登录
			{
				
				Response.Write("验证码不正确！");
				Response.Redirect("Login.aspx");
			}
			else
			{
                string AdminLei = this.DropDownList1.SelectedValue.ToString();
				string AdminName=this.AdminName.Text.ToString();
				string Adminpass=this.Adminpass.Text.ToString();
		
				string Sql=" Select * from WorkersList where WorkerName='" +AdminName+ "' and WorkerPwd='" +Adminpass+ "' and WorkKindListId='"+AdminLei+"'";
               
				SqlConnection Conn;
				Conn=new SqlConnection(sqlconn);
				Conn.Open();
                SqlCommand Comm = new SqlCommand(Sql, Conn);
                SqlDataReader dr = Comm.ExecuteReader();
			
		 
				if(AdminName!=""&& Adminpass!="")
				{
					if(dr.Read())
					{
						
			
						Session["lei"]=AdminLei;										  
						Session["flag"]=1;
						Response.Redirect("Default.aspx");
					}						
					else
					{
						this.Response.Write("<script>alert('对不起,最高管理员还没有分配给您权限 ！')</script>");			
					}	
				}
		
				Conn.Close();
			
			}

		}
	
}