?? reg.aspx.cs
字號:
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>
/// reg 的摘要說明。
/// </summary>
public class reg : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox txtAccount;
protected System.Web.UI.WebControls.Panel step2;
protected System.Web.UI.WebControls.TextBox txtUname;
protected System.Web.UI.WebControls.Panel step3;
protected System.Web.UI.WebControls.RadioButtonList rltSex;
protected System.Web.UI.WebControls.DropDownList ddlYear;
protected System.Web.UI.WebControls.DropDownList ddlMonth;
protected System.Web.UI.WebControls.DropDownList ddlDay;
protected System.Web.UI.WebControls.TextBox txtUjob;
protected System.Web.UI.WebControls.TextBox txtUtel1;
protected System.Web.UI.WebControls.TextBox txtUtel2;
protected System.Web.UI.WebControls.TextBox txtUtel3;
protected System.Web.UI.WebControls.TextBox txtUpager;
protected System.Web.UI.WebControls.TextBox txtUaddr;
protected System.Web.UI.WebControls.TextBox txtUemail;
protected System.Web.UI.WebControls.TextBox txtUicq;
protected System.Web.UI.WebControls.TextBox txtUqq;
protected System.Web.UI.WebControls.Button btnOK;
protected System.Web.UI.HtmlControls.HtmlGenericControl span1;
protected System.Web.UI.WebControls.Button btnSave;
protected System.Web.UI.WebControls.Button btnReturn;
protected System.Web.UI.WebControls.Panel step4;
protected System.Web.UI.WebControls.Panel step1;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator3;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
private ArrayList alYear;
private ArrayList alMonth;
private ArrayList alDay;
int i;
//數據庫操作相關變量
string strConn;
string strSQL;
OleDbConnection cn;
OleDbCommand cmd;
protected System.Web.UI.WebControls.TextBox txtUzip;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
protected System.Web.UI.WebControls.Label lblOK;
protected System.Web.UI.WebControls.Label lblStep2;
protected System.Web.UI.WebControls.Calendar Cal1;
protected System.Web.UI.WebControls.Button btnAgree;
protected System.Web.UI.WebControls.TextBox txtUpwd;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
protected System.Web.UI.WebControls.TextBox txtUpwd2;
protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
protected System.Web.UI.WebControls.Button btnNext;
protected System.Web.UI.WebControls.Label lblPwd;
OleDbDataReader dr;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此處放置用戶代碼以初始化頁面
if(!Page.IsPostBack)
{
step1.Visible=true;
step2.Visible=false;
step3.Visible=false;
step4.Visible=false;
alYear=new ArrayList();
alMonth=new ArrayList();
alDay=new ArrayList();
for(i=1972;i<1989;i++)
alYear.Add(i.ToString());
for(i=1;i<=12;i++)
alMonth.Add(i.ToString());
for(i=1;i<32;i++)
alDay.Add(i.ToString());
ddlYear.DataSource=alYear;
ddlYear.DataBind();
ddlMonth.DataSource=alMonth;
ddlMonth.DataBind();
ddlDay.DataSource=alDay;
ddlDay.DataBind();
}
}
#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.btnAgree.Click += new System.EventHandler(this.btnAgree_Click);
this.btnNext.Click += new System.EventHandler(this.btnNext_Click);
this.ddlYear.SelectedIndexChanged += new System.EventHandler(this.Date_SelectIndexChanged);
this.ddlMonth.SelectedIndexChanged += new System.EventHandler(this.Date_SelectIndexChanged);
this.btnOK.Click += new System.EventHandler(this.btnOK_Click);
this.btnSave.Click += new System.EventHandler(this.btnSave_Click);
this.btnReturn.Click += new System.EventHandler(this.btnReturn_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void btnAgree_Click(object sender, System.EventArgs e)
{
step1.Visible=false;
step2.Visible=true;
step3.Visible=false;
step4.Visible=false;
}
private void btnNext_Click(object sender, System.EventArgs e)
{
if(Page.IsValid)
{
strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("txl.aspx");
cn=new OleDbConnection(strConn);
strSQL="select u_id from userinfo where u_account='"+txtAccount.Text.ToString()+"'";
//strSQL="select u_id from userinfo where u_account='juw'";
cn.Open();
cmd=new OleDbCommand(strSQL,cn);
dr=cmd.ExecuteReader();
if(dr.Read())
{
lblStep2.Text="您輸入的用戶名已經存在，請您選擇一個其他的名字！";
cn.Close();
//txtAccount.Text="";
}
else
{
cn.Close();
lblPwd.Text=txtUpwd.Text.ToString();
step1.Visible=false;
step2.Visible=false;
step3.Visible=true;
step4.Visible=false;
}
}
}
private void btnOK_Click(object sender, System.EventArgs e)
{
if(Page.IsValid)
{
step1.Visible=false;
step2.Visible=false;
step3.Visible=false;
step4.Visible=true;
span1.InnerHtml="您輸入的信息是："+"<br>";
span1.InnerHtml+="登錄名："+txtAccount.Text.ToString()+"<br>";
span1.InnerHtml+="姓名："+txtUname.Text.ToString()+"<br>";
span1.InnerHtml+="性別："+rltSex.SelectedItem.Text.ToString()+"<br>";
span1.InnerHtml+="生日："+ddlYear.SelectedItem.Text.ToString()+"年"+ddlMonth.SelectedItem.Text.ToString()+"月"+ddlDay.SelectedItem.Text.ToString()+"日"+"<br>";
span1.InnerHtml+="工作單位："+txtUjob.Text.ToString()+"<br>";
span1.InnerHtml+="商務電話："+txtUtel1.Text.ToString()+"<br>";
span1.InnerHtml+="宅電："+txtUtel2.Text.ToString()+"<br>";
span1.InnerHtml+="移動電話："+txtUtel3.Text.ToString()+"<br>";
span1.InnerHtml+="尋呼機："+txtUpager.Text.ToString()+"<br>";
span1.InnerHtml+="通訊地址："+txtUaddr.Text.ToString()+"<br>";
span1.InnerHtml+="郵政編碼："+txtUzip.Text.ToString()+"<br>";
span1.InnerHtml+="E_mail："+txtUemail.Text.ToString()+"<br>";
span1.InnerHtml+="ICQ："+txtUicq.Text.ToString()+"<br>";
span1.InnerHtml+="Oicq："+txtUqq.Text.ToString()+"<br>";
}
}
public void btnSave_Click(object sender, System.EventArgs e)
{
if(Page.IsValid)
{
strSQL="INSERT INTO userinfo(u_name,u_account,u_pwd,u_sex,u_bth,u_regdate,u_tel1,u_tel2,u_tel3,u_addr,u_zip,u_email,u_job,u_icq,u_qq,u_grp) VALUES('";
strSQL+=txtUname.Text.ToString()+"','";
strSQL+=txtAccount.Text.ToString()+"','";
strSQL+=lblPwd.Text.ToString()+"','";
strSQL+=rltSex.SelectedItem.Text.ToString()+"','";
strSQL+=ddlYear.SelectedItem.Text.ToString()+"-"+ddlMonth.SelectedItem.Text.ToString()+"-"+ddlDay.SelectedItem.Text.ToString()+"','";
strSQL+=DateTime.Today.ToString()+"','";
strSQL+=txtUtel1.Text.ToString()+"','";
strSQL+=txtUtel2.Text.ToString()+"','";
strSQL+=txtUtel3.Text.ToString()+"','";
strSQL+=txtUaddr.Text.ToString()+"','";
strSQL+=txtUzip.Text.ToString()+"','";
strSQL+=txtUemail.Text.ToString()+"','";
strSQL+=txtUjob.Text.ToString()+"','";
strSQL+=txtUicq.Text.ToString()+"','";
strSQL+=txtUqq.Text.ToString()+"',1)";
strConn="provider=Microsoft.Jet.OLEDB.4.0;data source="+Server.MapPath("txl.aspx");
cn=new OleDbConnection(strConn);
cmd=new OleDbCommand(strSQL,cn);
cn.Open();
cmd.ExecuteNonQuery();
strSQL="select u_id from userinfo where u_account='"+txtAccount.Text.ToString()+"'";
cmd=new OleDbCommand(strSQL,cn);
dr=cmd.ExecuteReader();
while(dr.Read())
Session["uid"]=dr["u_id"];
dr.Close();
cn.Close();
//cn.Close();
Page.Response.Redirect("welcome.aspx");
}
}
private void btnReturn_Click(object sender, System.EventArgs e)
{
step1.Visible=false;
step2.Visible=false;
step3.Visible=true;
step4.Visible=false;
}
private void Date_SelectIndexChanged(object sender,System.EventArgs e)
{
int[] numbers = {31,28, 31, 30, 31,30,31,31,30,31,30,31};
if((Convert.ToInt32(ddlYear.SelectedItem.Text.ToString())%4)==0)
numbers[1]=29;
alDay=new ArrayList();
for(i=1;i<=numbers[Convert.ToInt32(ddlMonth.SelectedItem.Text.ToString())-1];i++)
alDay.Add(i.ToString());
ddlDay.DataSource=alDay;
ddlDay.DataBind();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -