user_register.aspx.cs

b to b 模式 电子商务系统

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 ;//包含 web.config配置文件
//using System.Drawing.Imaging;

namespace B2Bsite
{
	/// <summary>
	/// 用户注册
	/// </summary>
	public class User_Register : System.Web.UI.Page
	{
        protected System.Web.UI.WebControls.Label Label1;
        protected System.Web.UI.WebControls.Label Label2;
        protected System.Web.UI.WebControls.TextBox TextBox1;
        protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator4;
        protected System.Web.UI.WebControls.Label Label9;
        protected System.Web.UI.WebControls.Label Label15;
        protected System.Web.UI.WebControls.TextBox TextBox7;
        protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator6;
        protected System.Web.UI.WebControls.Label Label3;
        protected System.Web.UI.WebControls.TextBox TextBox2;
        protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator3;
        protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
        protected System.Web.UI.WebControls.Label Label10;
        protected System.Web.UI.WebControls.Label Label4;
        protected System.Web.UI.WebControls.TextBox TextBox3;
        protected System.Web.UI.WebControls.CompareValidator CompareValidator1;
        protected System.Web.UI.WebControls.Label Label27;
        protected System.Web.UI.WebControls.Label Label16;
        protected System.Web.UI.WebControls.RadioButtonList Radio;
        protected System.Web.UI.WebControls.Label Label17;
        protected System.Web.UI.WebControls.TextBox TextBox8;
        protected System.Web.UI.WebControls.Label Label18;
        protected System.Web.UI.WebControls.TextBox TextBox9;
        protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
        protected System.Web.UI.WebControls.Label Label26;
        protected System.Web.UI.WebControls.Label Label19;
        protected System.Web.UI.WebControls.TextBox TextBox10;
        protected System.Web.UI.WebControls.Label Label20;
        protected System.Web.UI.WebControls.TextBox TextBox11;
        protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator6;
        protected System.Web.UI.WebControls.Label Label28;
        protected System.Web.UI.WebControls.Label Label21;
        protected System.Web.UI.WebControls.TextBox TextBox12;
        protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
        protected System.Web.UI.WebControls.Label Label11;
        protected System.Web.UI.WebControls.TextBox TextBox15;
        protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator5;
        protected System.Web.UI.WebControls.Label Label29;
        protected System.Web.UI.WebControls.Label Label5;
        protected System.Web.UI.WebControls.TextBox TextBox4;
        protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
        protected System.Web.UI.WebControls.Label Label12;
        protected System.Web.UI.WebControls.Label Label6;
        protected System.Web.UI.WebControls.TextBox TextBox5;
        protected System.Web.UI.WebControls.CompareValidator CompareValidator2;
        protected System.Web.UI.WebControls.Label Label13;
        protected System.Web.UI.WebControls.Label Label22;
        protected System.Web.UI.WebControls.TextBox TextBox13;
        protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
        protected System.Web.UI.WebControls.Label Label24;
        protected System.Web.UI.WebControls.Label Label23;
        protected System.Web.UI.WebControls.TextBox TextBox14;
        protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
        protected System.Web.UI.WebControls.Label Label25;
        protected System.Web.UI.WebControls.Label Label7;
        protected System.Web.UI.WebControls.TextBox TextBox6;
        protected System.Web.UI.WebControls.Label Label14;
        protected System.Web.UI.WebControls.Button Button2;
        protected System.Web.UI.WebControls.Label Label8;

        public DBConnection conn=new DBConnection();
    
		private void Page_Load(object sender, System.EventArgs e)
		{
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </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)
        {
            //普通加密
            //获得要加密的字段，并转化为Byte[]数组
            /*byte[] data=System.Text .Encoding .Unicode .GetBytes (TextBox2.Text .ToCharArray ());
            //建立加密服务
            System.Security .Cryptography .MD5 md5=new System.Security .Cryptography.MD5CryptoServiceProvider ();
            //加密Byte[]数组
            byte[] result=md5.ComputeHash (data);
            //将加密后的数组转化为字段
            string sResult=System.Text.Encoding .Unicode .GetString (result);*/
            //显示普通加密
            //Label31.Text ="MD5普通加密："+sResult.ToString ()+"<br>";

            //作为密码方式加密
            string EnPswdStr=System.Web .Security .FormsAuthentication .HashPasswordForStoringInConfigFile (TextBox2.Text .ToString (),"MD5");


            String username,truename,password,sex,qq,idcard,homepage,phone,address,postalcode,email,question,answer,checkcode,sql;
            SqlConnection connection=new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);//数据库连接的类
            username=TextBox1.Text ;
            truename=TextBox7.Text ;
            password=EnPswdStr;
            sex=Radio.SelectedItem.Value ;
            qq=TextBox8.Text;
            idcard=TextBox9.Text;
            homepage=TextBox10.Text ;
            phone=TextBox11.Text;
            address=TextBox12.Text;
            postalcode=TextBox15.Text ;
            email=TextBox4.Text ;
            question=TextBox13.Text;
            answer=TextBox14.Text;
            checkcode=TextBox6.Text;

            sql="select * from Users where UserName='"+username+"'";
            SqlDataReader dr=conn.ExecuteReader(sql);//返回结果集
            while(dr.Read ())
            {
                Response.Write ("<script language='JavaScript'>");
                Response.Write ("alert('此会员名已存在！请重新输入一个！')");
                Response.Write ("</script>");
                TextBox1.Text ="";
                TextBox6.Text ="";
                return;
            }
            dr.Close ();


            if (Session["CheckCode"].ToString()!=checkcode)
            {
                Response.Write ("<script language='JavaScript'>");
                Response.Write ("alert('输入的验证码有误！请重新输入！')");
                Response.Write ("</script>");
                return;
            }

            sql="Insert into Users(UserName,TrueName,PassWord,Sex,QQ,IDCard,HomePage,Phone,Address,Email,Question,Answer) values('"+username+"','"+truename+"','"+password+"','"+sex+"','"+qq+"','"+idcard+"','"+homepage+"','"+phone+"','"+address+"','"+email+"','"+question+"','"+answer+"')";
            /*SqlCommand command=new SqlCommand (sql,connection);//构造执行数据库命令 
            connection.Open();//打开数据库
            command.ExecuteNonQuery();//执行语句
            connection.Close();*/
            conn.Updata(sql);

            Response.Write ("<script language='JavaScript'>");
            Response.Write ("alert('注册成功，欢迎加入我们！');");
            Response.Write ("window.open('User_Login.aspx');</script>");
        }
	}
}