modifyuser.aspx.cs

购物车主要是为广大网上顾客购物的资源平台。购物车主要目标是建设在网上对用户进行信息服务互动平台。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class modifyuser : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Uid"] == null)
        {
            Response.Redirect("Default.aspx");
        }
        if (!IsPostBack)
        {
            if (Request.QueryString["name"] ==null)
            {
                Response.Redirect("login.aspx");
            }
            else
            {
                //    if (Page.PreviousPage != null)
                //    {
                //        TextBox tbx = (TextBox)Page.PreviousPage.FindControl("TextBox1");
                //        this.Label5.Text = tbx.Text.ToString();
                //    }
                this.Label5.Text = Request.QueryString["name"].ToString();
            }
            this.Panel1.Visible = false;
            if (Session["Uid"] != null)
            {
                string sql = "select Uname,Upwd,Uphone,Umomey from Userlist where Uid='" + Session["Uid"].ToString() + "'";
                DBClass db = new DBClass();
                DataTable dt = db.GetDataTable(sql);
              
                if (dt.Rows.Count > 0)
                {
                    this.GridView1.DataSource = dt;
                    this.GridView1.DataBind();


                }
            }
        }
    }

    protected void Button3_Click(object sender, EventArgs e)
    {
        this.TextBox1.Text = "";
        this.TextBox2.Text = "";
        this.TextBox3.Text = "";
        this.TextBox4.Text = "";
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        this.Panel1.Visible = true;
        if (Session["Uid"] != null)
        {
            string sql = "select * from Userlist where Uid='" + Session["Uid"].ToString() + "'";
            DBClass db = new DBClass();
            DataTable dt = db.GetDataTable(sql);
            this.TextBox1.Text = dt.Rows[0]["Uname"].ToString();
            this.TextBox2.Text = dt.Rows[0]["Upwd"].ToString();
            this.TextBox3.Text = dt.Rows[0]["Upwd"].ToString();
            this.TextBox4.Text = dt.Rows[0]["Uphone"].ToString();


        }

    }
    protected void Button2_Click(object sender, EventArgs e)
    {

        if (this.TextBox1.Text.Trim() == string.Empty)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请输入用户名')</script>");
            return;
        }

        if (this.TextBox2.Text.Trim() == string.Empty)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请输入新密码')</script>");
            return;
        }
        if (this.TextBox3.Text.Trim() == string.Empty)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请再次新密码')</script>");
            return;
        }

        if (this.TextBox4.Text.Trim() == string.Empty)
        {
            ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请输入电话号码')</script>");
            return;
        }


            if (this.TextBox3.Text.Trim() != this.TextBox2.Text.Trim())
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('两次新密码不相同')</script>");
                return;
            }



            string sql = string.Format("SELECT Uname,Upwd,Uphone,Umomey FROM Userlist WHERE Uid='" + Session["Uid"] + "'");  
                DBClass db = new DBClass();
                DataTable dt = db.GetDataTable(sql);
               
          
            if (dt.Rows.Count> 0)
            {
                string Uname = this.TextBox1.Text.Trim();
                string Upwd = this.TextBox2.Text.Trim();
                string Uphone = this.TextBox4.Text.Trim();
               
                string connsql = "update Userlist set Uname='" + Uname + "',Upwd='" + Upwd + "',Uphone='" + Uphone + "'where Uid='" + Session["Uid"] + "'";
               
                //string connsql = string.Format("update Userlist set Upwd='{0}',Uname='{2}',Uphone='{3}'where Uid='{1}'", this.TextBox2.Text.Trim(), this.TextBox1.Text.Trim(), this.TextBox4.Text.Trim(), Session["Uid"].ToString());
                using (SqlConnection conn = DBClass.GetConnection())
                {

                    SqlCommand cmd = new SqlCommand(connsql, conn);
                   conn.Open();
                    cmd.ExecuteNonQuery();
                  conn.Close();
                    ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('您的资料修改成功！')</script>");
     　　　　　　　
                }
            }
            else
            {
                ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('原资料不存在！')</script>");
                return;
            }
            string csql = string.Format("SELECT Uname,Upwd,Uphone,Umomey FROM Userlist WHERE Uid='" + Session["Uid"] + "'");
            DBClass cdb = new DBClass();
            DataTable cdt = cdb.GetDataTable(csql);
　　　　　　this.GridView1.DataSource =cdt;
           　this.GridView1.DataBind();
            this.Label5.Text = cdt.Rows[0]["Uname"].ToString();
          
        
        }
    protected void Button4_Click(object sender, EventArgs e)
    {
        this.Panel1.Visible = false;
    }

    protected void Button5_Click(object sender, EventArgs e)
    {
        Response.Redirect("Buy.aspx");
    }
    protected void Button6_Click(object sender, EventArgs e)
    {
        Session.Abandon();
        Response.Redirect("Default.aspx");
    }
}