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.OleDb;

namespace txl
{
	/// <summary>
	/// WebForm1 的摘要說明。
	/// </summary>
	public class WebForm1 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox txtAccount;
		protected System.Web.UI.WebControls.Label lblMsg;
		protected System.Web.UI.WebControls.Button btnOK;
		protected System.Web.UI.WebControls.Button btnCancel;
		protected System.Web.UI.WebControls.TextBox txtPwd;
		protected OleDbConnection cn;
		protected OleDbCommand cmd;
		string strSQL,strConn;
		

		private void btnOK_Click(object serder,EventArgs e)
		{
			strSQL="select u_id from userinfo where u_account='"+txtAccount.Text.ToString().Replace("'","")+"' and u_pwd='"+txtPwd.Text.ToString().Replace("'","")+"'";
            //strSQL="select u_id from userinfo where u_account='juw' and u_pwd='123'";
			strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("txl.aspx");
			cn=new OleDbConnection(strConn);
			cn.Open();
			cmd=new OleDbCommand(strSQL,cn);
			OleDbDataReader dr=cmd.ExecuteReader();

			if(dr.Read())
			{
				Session["uid"]=dr["u_id"].ToString();
				Page.Response.Redirect("welcome.aspx");
			}
			else
			{
				lblMsg.Text="用戶名或口令有錯！請重新輸入！";
				//txtAccount.Text="";
				txtPwd.Text="";
				//Page.Response.Write(Session.Count);
			}
			cn.Close();
		}


		private void btnCancel_Click(object sender,System.EventArgs e)
		{
			lblMsg.Text="";
			txtAccount.Text="";
			txtPwd.Text="";
			Page.Response.Redirect("reg.aspx");
		}





	
		private void Page_Load(object sender, System.EventArgs e)
		{
            // 在此處放置用戶代碼以初始化頁面	
			if(!Page.IsPostBack)
			{
				lblMsg.Text="";
				txtAccount.Text="";
				txtPwd.Text="";
			}
			btnOK.Click+=new EventHandler(btnOK_Click);
			btnCancel.Click+=new EventHandler(btnCancel_Click);
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：該調用是 ASP.NET Web 窗體設計器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion


	}
}