📄 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.SqlClient;
using System.Configuration;
namespace ClassOnline
{
/// <summary>
/// Reg 的摘要说明。
/// </summary>
public class Reg : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Button btnAgree;
protected System.Web.UI.WebControls.Panel step1;
protected System.Web.UI.WebControls.TextBox txtAccount;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
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 lblStep2;
protected System.Web.UI.WebControls.Label lblPwd;
protected System.Web.UI.WebControls.Panel step2;
protected System.Web.UI.WebControls.TextBox txtUname;
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
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 txtUzip;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
protected System.Web.UI.WebControls.TextBox txtUemail;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator3;
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.WebControls.Panel step3;
protected System.Web.UI.WebControls.Button btnSave;
protected System.Web.UI.WebControls.Button btnReturn;
protected System.Web.UI.WebControls.Label lblOK;
protected System.Web.UI.WebControls.Panel step4;
protected System.Web.UI.HtmlControls.HtmlGenericControl span1;
private ArrayList alYear;
private ArrayList alMonth;
private ArrayList alDay;
int i;
string strSQL;
SqlConnection objconn;
SqlCommand objcmd;
SqlDataReader 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=1950;i<2002;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 窗体设计器生成的代码
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.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)
{
//创建数据库连接并打开
objconn =new SqlConnection(ConfigurationSettings.AppSettings["connstr"]);
objconn.Open();
strSQL="select UserID from UserInfo where UserAccount='"+txtAccount.Text.ToString()+"'";
//strSQL="select u_id from userinfo where u_account='juw'";
objcmd=new SqlCommand(strSQL,objconn);
dr=objcmd.ExecuteReader();
if(dr.Read())
{
lblStep2.Text="您输入的用户名已经存在，请您选择一个其他的名字！";
objconn.Close();
//txtAccount.Text="";
}
else
{
objconn.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>";
}
}
private void btnSave_Click(object sender, System.EventArgs e)
{
if(Page.IsValid)
{
strSQL="INSERT INTO UserInfo(UserName,UserAccount,UserPwd,UserSex,UserBth,UserRegDate,UMobile,UTel,UTel2,UAddress,UZip,UEMail,UserJob,UserIcq,Userqq,UserGrp) 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)";
//创建数据库连接并打开
objconn =new SqlConnection(ConfigurationSettings.AppSettings["connstr"]);
objconn.Open();
objcmd=new SqlCommand(strSQL,objconn);
objcmd.ExecuteNonQuery();
strSQL="select UserID from UserInfo where UserAccount='"+txtAccount.Text.ToString()+"'";
objcmd=new SqlCommand(strSQL,objconn);
SqlDataReader dr=objcmd.ExecuteReader();
while(dr.Read())
Session["UserID"]=dr["UserID"];
dr.Close();
objconn.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 + -