using   System;   
using   System.Collections;   
using   System.ComponentModel;   
using   System.Data;   
using   System.Data.SqlClient;   
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.Configuration;   
namespace   aikeding   
{   
	///   <summary>   
	///   reg   的摘要說明。   
	///   </summary>   
	public   class   reg   :   System.Web.UI.Page   
	{   
		protected   System.Web.UI.WebControls.TextBox   webname;   
		protected   System.Web.UI.WebControls.TextBox   realname;   
		protected   System.Web.UI.WebControls.TextBox   birthday;   
		protected   System.Web.UI.WebControls.DropDownList   sex;   
		protected   System.Web.UI.WebControls.DropDownList   animal;   
		protected   System.Web.UI.WebControls.DropDownList   childbearing;   
		protected   System.Web.UI.WebControls.TextBox   avoirdupois;   
		protected   System.Web.UI.WebControls.DropDownList   blood;   
		protected   System.Web.UI.WebControls.TextBox   username;   
		protected   System.Web.UI.WebControls.TextBox   memberid;   
		protected   System.Web.UI.WebControls.TextBox   password;   
		protected   System.Web.UI.WebControls.TextBox   frealname;   
		protected   System.Web.UI.WebControls.TextBox   linkphone;   
		protected   System.Web.UI.WebControls.TextBox   mobile;   
		protected   System.Web.UI.WebControls.TextBox   email;   
		protected   System.Web.UI.WebControls.TextBox   address;   
		protected   System.Web.UI.WebControls.TextBox   post;   
		protected   System.Web.UI.WebControls.TextBox   memo;   
		protected   System.Web.UI.WebControls.Button   Button2;   
		protected   SqlConnection   conn;   
		protected   DateTime   birthday2;   
		private   void   Page_Load(object   sender,   System.EventArgs   e)   
		{   
			//   在此處放置用戶代碼以初始化頁面   
		}   
    
		#region   Web   窗體設(shè)計(jì)器生成的代碼   
		override   protected   void   OnInit(EventArgs   e)   
		{   
			//   
			//   CODEGEN:   該調(diào)用是   ASP.NET   Web   窗體設(shè)計(jì)器所必需的。   
			//   
			InitializeComponent();   
			base.OnInit(e);   
		}   
    
		///   <summary>   
		///   設(shè)計(jì)器支持所需的方法   -   不要使用代碼編輯器修改   
		///   此方法的內(nèi)容。   
		///   </summary>   
		private   void   InitializeComponent()   
		{           
			this.Button2.Click   +=   new   System.EventHandler(this.Button2_Click);   
			this.Load   +=   new   System.EventHandler(this.Page_Load);   
    
		}   
		#endregion   
    
		private   void   Button2_Click(object   sender,   System.EventArgs   e)   
		{   
			conn=new   SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);   
			conn.Open();   
    
			string   webname2=Request["webname"].ToString();   
			string   realname2=Request["realname"].ToString();   
			string   sex2=Request["sex"].ToString();   
			string   animal2=Request["animal"].ToString();   
			string   childbearing2=Request["childbearing"].ToString();   
			string   memo2=Request["memo"].ToString();   
			string   avoirdupois2=Request["avoirdupois"].ToString();   
			string   blood2=Request["blood"].ToString();   
			string   username2=Request["username"].ToString();   
			string   password2=Request["password"].ToString();   
			string   frealname2=Request["frealname"].ToString();   
			string   linkphone2=Request["linkphone"].ToString();   
			string   mobile2=Request["mobile"].ToString();   
			string   email2=Request["email"].ToString();   
			string   address2=Request["address"].ToString();   
			string   post2=Request["post"].ToString();   
			try   
			{   
				birthday2=Convert.ToDateTime(Request["birthday"]);   
    
			}   
			catch   
			{   
				Response.Write("<script>alert('請(qǐng)按正規(guī)格式填寫生日,例如:2004-01-01');history.back();</script>");   
				Response.End();   
			}   
			if(webname2==""   ||   username2=="")   
			{   
    
				Response.Write("<script>alert('寶寶網(wǎng)名或用戶名均不能為空');history.back();</script>");   
				Response.End();   
			}   
			string   Sql="select   *   from   member   where   webname='"+webname2+"'";   
			SqlCommand   cmd=new   SqlCommand(Sql,conn);   
			SqlDataReader   obj=cmd.ExecuteReader();   
			if(obj.Read())   
			{   
				Response.Write("<script>alert('該寶寶網(wǎng)名己存在');history.back();</script>");   
				Response.End();   
			}   
			obj.Close();   
    
			string   Sql2="select   *   from   member   where   username='"+username2+"'";   
			SqlCommand   cmd2=new   SqlCommand(Sql2,conn);   
			SqlDataReader   obj2=cmd2.ExecuteReader();   
			if(obj2.Read())   
			{   
				Response.Write("<script>alert('該用戶名己存在');history.back();</script>");   
				Response.End();   
			}   
			obj2.Close();   
    
			string   Sql5="insert   into   member(webname,realname,birthday,sex,animal,childbearing,memo,avoirdupois,blood,username,password,frealname,linkphone,mobile,email,address,post)values('"+webname2+"','"+realname2+"','"+birthday2+"','"+sex2+"','"+animal2+"','"+childbearing2+"','"+memo2+"','"+avoirdupois2+"','"+blood2+"','"+username2+"','"+password2+"','"+frealname2+"','"+linkphone2+"','"+mobile2+"','"+email2+"','"+address2+"','"+post2+"')";   
			SqlCommand   cmd5=new   SqlCommand(Sql5,conn);   
			cmd5.ExecuteNonQuery();   
			Response.Write("<script>alert('注冊(cè)成功,請(qǐng)登陸!');window.close();</script>");   
			Response.End();   
		}   
	}   
}