register.aspx.cs

酒店管理,主要从事酒店管理都可以.这可是北大青鸟的程序

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.Odbc;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace HotelHome
{
	/// <summary>
	/// FirstRegister 的摘要说明。
	/// </summary>
	public class Register : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label title;
		protected System.Web.UI.WebControls.TextBox txtSecondPwd;
		protected System.Web.UI.WebControls.TextBox txtFirstPwd;
		protected System.Web.UI.WebControls.TextBox txtMemID;
		protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
		protected System.Web.UI.WebControls.TextBox txtEmail;
		protected System.Web.UI.WebControls.TextBox txtTelNumber;
		protected System.Web.UI.WebControls.TextBox txtMemAddr;
		protected System.Web.UI.WebControls.TextBox txtQuestion;
		protected System.Web.UI.WebControls.TextBox txtAnswer;
		protected System.Web.UI.WebControls.TextBox txtName;
		protected System.Web.UI.WebControls.Button btnRestet;
		protected System.Web.UI.WebControls.Button btnSubmit;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			this.btnSubmit.Attributes.Add("onclick","return doValidate();");
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.txtMemID.TextChanged += new System.EventHandler(this.txtMemID_TextChanged);
			this.txtQuestion.TextChanged += new System.EventHandler(this.txtQuestion_TextChanged);
			this.btnSubmit.Click += new System.EventHandler(this.btnSubmit_Click);
			this.btnRestet.Click += new System.EventHandler(this.btnRestet_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion


		private void txtMemID_TextChanged(object sender, System.EventArgs e)
		{
		
		}

		private void btnSubmit_Click(object sender, System.EventArgs e)
		{
			
          
			DBService mycon=new DBService();			
			DataSet myds=new DataSet();
			string comstring;
			if(!this.txtMemID.Text.Equals(""))
			{
				comstring="select * from member where memID='"+ this.txtMemID.Text.Trim() +" '";
				myds=mycon.executeBySQL(comstring);
			
				if(myds.Tables[0].Rows.Count>0)  //用户名已经存在
				{
					Response.Write("<script>alert('对不起，该用户名已存在！请改用其他用户名！');</script>");				
				}			
				else  //
				{
					comstring=	"insert into member(MemID,memPwd,name,memAddr,TelNumber,email,Question,Answer) values(?,?,?,?,?,?,?,?)";
					mycon.setCommandText(comstring);
			
					mycon.comm.Parameters.Add("1",this.txtMemID.Text.Trim());
				
					mycon.comm.Parameters.Add("2",this.txtFirstPwd.Text.Trim());		
				
					mycon.comm.Parameters.Add("3",this.txtName.Text.Trim());		
			
					mycon.comm.Parameters.Add("4",this.txtMemAddr.Text.Trim());
		
					mycon.comm.Parameters.Add("5",this.txtTelNumber.Text.Trim());
				
					mycon.comm.Parameters.Add("6",this.txtEmail.Text.Trim());
		            
					mycon.comm.Parameters.Add("7",this.txtQuestion.Text.Trim());

					mycon.comm.Parameters.Add("8",this.txtAnswer.Text.Trim());
				
					
						
						
					int i=mycon.ExecuteNonQuery();
					if(i>0) //插入成功，给注册用户分配信用卡号码；
					{   
						int r=123*(int)new System.Random().Next(100);
						string cardID=this.txtMemID.Text+this.txtFirstPwd.Text+r.ToString();
						
                        comstring=	"insert into member(cardID) values(?) where memID=?";
                        mycon.setCommandText(comstring);
                        mycon.comm.Parameters.Add("1",cardID);
						mycon.comm.Parameters.Add("2",this.txtMemID.Text.Trim());

						Response.Write("<script>alert('恭喜您注册成功！);window.navigate('../index.aspx');</script>");
						//this.Response.Redirect("Login.aspx");

					}
				}
			}
		
		}

		private void btnRestet_Click(object sender, System.EventArgs e)
		{
			this.txtMemID.Text="";
			this.txtFirstPwd.Text="";
			this.txtSecondPwd.Text="";
			this.txtTelNumber.Text="";
			this.txtName.Text="";
			this.txtMemAddr.Text="";
			this.txtEmail.Text="";	
			this.txtQuestion.Text="";
			this.txtAnswer.Text="";
		}

		private void txtQuestion_TextChanged(object sender, System.EventArgs e)
		{
		
		}

		
	}
}