login.ascx.cs

采用C＃.NET2008与SQL SERVER的社区网站

namespace Aspnet.control
{
	using System;
	using System.Data;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;
	using System.Configuration;
	using System.Data.SqlClient;


	/// <summary>
	///		login 的摘要说明。
	/// </summary>
	public class login : System.Web.UI.UserControl
	{
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.HyperLink HyperLink2;
		protected System.Web.UI.WebControls.TextBox TB_name;
		protected System.Web.UI.WebControls.TextBox TB_pwd;
		protected System.Web.UI.WebControls.RequiredFieldValidator RFV_pwd;
		protected System.Web.UI.WebControls.Button BT_Submit;
		protected System.Web.UI.WebControls.Button BT_cancel;
		protected System.Web.UI.WebControls.RadioButtonList RBL_type;
		protected System.Web.UI.WebControls.RequiredFieldValidator RFV_name;

		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.BT_Submit.Click += new System.EventHandler(this.BT_Submit_Click);
			this.BT_cancel.Click += new System.EventHandler(this.BT_cancel_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void BT_Submit_Click(object sender, System.EventArgs e)
		{
			string strconn="server=.;database=Aspnet;uid=sa;pwd=sa";//连接字符串
			string selectstr;
			SqlConnection Conn=new SqlConnection(strconn);
			if(RBL_type.SelectedItem.Value.ToString()=="个人")
			{
				selectstr="select count(*) from UserInfo where UserName like '"+TB_name.Text+"' and Pwd like '"+TB_pwd.Text+"'";
			}
			else
			{
				selectstr="select count(*) from AdminInfo where AdminID like '"+TB_name.Text+"' and AdminPwd like '"+TB_pwd.Text+"'";
			}
			Session["type"]=RBL_type.SelectedItem.Value.ToString();
			SqlCommand mycommand=new SqlCommand(selectstr,Conn);
			Conn.Open();//打开数据库连接
			int flag=(int)mycommand.ExecuteScalar();
			Conn.Close();
			if(flag>0)//用户存在
			{
				Session["UserName"]=TB_name.Text;
				Response.Redirect("Review.aspx");//("../sysconfig/Viewmessage.aspx");
			}
			else
			{
				Response.Write("<script>alert('用户名或密码错误,请重新登录！')</script>");
				TB_name.Text="";
				TB_pwd.Text="";
			}
		}

		private void BT_cancel_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("Review.aspx");
		}
	}
}