user_edit.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;

namespace B2Bsite
{
	/// <summary>
	/// 用户信息修改
	/// </summary>
	public class User_Edit : 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.Button Button1;

        public DBConnection conn=new DBConnection();
    
		private void Page_Load(object sender, System.EventArgs e)
		{
            if( !IsPostBack )
            {  
                if(Session["username"]==null)
                {
                    Response.Write ("<script language='JavaScript'>");
                    Response.Write ("alert('请先登录！')");
                    Response.Write ("</script>");
                    Response.End();
                    return;
                }
                string username=Session["username"].ToString ();
                string sql="SELECT * FROM Users where UserName='"+username+"'";
                SqlDataReader dr=conn.ExecuteReader(sql);

                if(dr.Read ())
                {
                    TextBox1.Text=dr["UserName"].ToString ();
                    TextBox7.Text=dr["TrueName"].ToString ();
                    TextBox2.Text=dr["PassWord"].ToString ();
                    TextBox3.Text=dr["PassWord"].ToString ();
                    Radio.SelectedValue =dr["Sex"].ToString ();
                    TextBox8.Text=dr["QQ"].ToString ();
                    TextBox9.Text=dr["IDCard"].ToString ();
                    TextBox10.Text=dr["HomePage"].ToString ();
                    TextBox11.Text=dr["Phone"].ToString ();
                    TextBox12.Text=dr["Address"].ToString ();
                    TextBox15.Text=dr["PostalCode"].ToString ();
                    TextBox4.Text=dr["Email"].ToString ();
                    TextBox5.Text=dr["Email"].ToString ();
                    TextBox13.Text=dr["Question"].ToString ();
                    TextBox14.Text=dr["Answer"].ToString ();
                    dr.Close ();
                }
                else
                {
                    Response.Write ("<script language='JavaScript'>");
                    Response.Write ("alert('没有该用户！')");
                    Response.Write ("</script>");
                    return;
                }
            }
		}

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

        }
		#endregion

        private void Button1_Click(object sender, System.EventArgs e)
        {
            string username,TrueName,password,sex,qq,idcard,homepage,phone,address,postalcode,email,question,answer;
            username=TextBox1.Text ;
            TrueName=TextBox7.Text ;
            password= System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile( TextBox2.Text,"MD5" );
            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;
            //执行sql更新命令
            string sql2="update Users set TrueName='"+TrueName+"',PassWord='"+password+"',Sex='"+sex+"',QQ='"+qq+"',IDCard='"+idcard+"',HomePage='"+homepage+"',Phone='"+phone+"',Address='"+address+"',PostalCode='"+postalcode+"',Email='"+email+"',Question='"+question+"',Answer='"+answer+"' where UserName='"+username+"'";
            conn.Updata(sql2);

            Response.Write ("<script language='JavaScript'>");
            Response.Write ("alert('修改成功！')");
            Response.Write ("</script>");
        }
	}
}