User/personal.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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 LYF.SqlHelper;
using System.Data.SqlClient;

public partial class User_personal : System.Web.UI.Page
{
    private SqlHelper shp = new SqlHelper("XS");
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["username"] == null || Session["username"].ToString() == "")
        {
            Response.Write("<script>alert('您还未登录，登录后可以进行个人管理！');parent.location.href='index.aspx'</script>");
        }
        else
        {
            if (!IsPostBack)
            {
                LoadBind();
            }
        }
    }
    private void LoadBind() 
    {
        string sql = "select username,name,card,tel,address,money from XS_User where username='" + Session["username"].ToString() + "'";
        using (SqlDataReader dr = shp.ExecuteReader(sql)) 
        {
            if (dr.Read()) 
            {
                this.username.InnerText = dr["username"].ToString();
                this.money.InnerText = Double.Parse(dr["money"].ToString()).ToString("0.00");
                this.sfz.Value = dr["card"].ToString();
                this.name.Value = dr["name"].ToString();
                this.tel.Value = dr["tel"].ToString();
                this.address.Value = dr["address"].ToString();
            }
        }
        shp.CloseDB();
    }
    protected void editBT_Click(object sender, EventArgs e)
    {
        string sql="update XS_User set card='"+this.sfz.Value+"',";
        sql += "name='" + this.name.Value + "',";
        sql += "tel='" + this.tel.Value + "',";
        sql += "address='" + this.address.Value + "' where username='" + this.username.InnerText + "'";
        shp.ExecuteNonQuery(sql);
        ShowJsMsg("温馨提示：修改成功！");
        LoadBind();
    }
    public void ShowJsMsg(string msg)
    {
        this.ClientScript.RegisterStartupScript(this.GetType(), "message",