edit_userinfo.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 Edit_UserInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        HeardConfig();//加载页面heard内容
        if (!IsPostBack)
        {
            PersonInfo.Return_SessionPerson();//判断管理员是否登陆
            if (QueryString.Get_Id != null)
            { Ispage_Bind(); }
            else
            { JScript.GoHistory("参数错误", -1); }
        }

    }
    #region 页面初始化必需的内容
    public void HeardConfig()
    {
        Header.Title = "销售订单管理系统-修改信息";
        HeaderTextInfo.GetHeader(this, null);
    }
    #endregion
    public void Ispage_Bind()
    {
        string CmdTxt="Select * From Company Where Id="+QueryString.Get_Id+"";
        SqlDataReader sdr = new SqlDataBase().GetDataReader(CmdTxt);
        if (sdr.Read())
        {
            lbl_Type.Text = sdr["CompanyType"].ToString();
            CompanyName.Text = sdr["CompanyName"].ToString();
            CompanyShort.Text = sdr["CompanyShort"].ToString();
            CompanyAddress.Text = sdr["CompanyAddress"].ToString();
            Postalcode.Text = sdr["Postalcode"].ToString();
            Tel.Text = sdr["Tel"].ToString();
            Fax.Text = sdr["Fax"].ToString();
            Linkman.Text = sdr["Linkman"].ToString();
            Email.Text = sdr["Email"].ToString();
            Bank.Text = sdr["Bank"].ToString();
            BandAccounts.Text = sdr["BandAccounts"].ToString();
        }
        sdr.Close();
        sdr.Dispose();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string CompanyName = this.CompanyName.Text.ToString();
        string CompanyType = this.lbl_Type.Text.ToString();
        string CompanyShort = this.CompanyShort.Text.ToString();
        string CompanyAddress = this.CompanyAddress.Text.ToString();
        string Postalcode = this.Postalcode.Text.ToString();
        string Tel = this.Tel.Text.ToString();
        string Fax = this.Fax.Text.ToString();
        string Linkman = this.Linkman.Text.ToString();
        string Email = this.Email.Text.ToString();
        string Bank = this.Bank.Text.ToString();
        string BandAccounts = this.BandAccounts.Text.ToString();
        string Username = QueryString.Get_SessionPerson;
        string AddTime = Convert.ToString(DateTime.Now);
        //执行修改操作
        string CmdTxt = "update Company set CompanyName='" + CompanyName + "',CompanyType='" + CompanyType + "',CompanyShort='" + CompanyShort + "',CompanyAddress='" + CompanyAddress + "',Postalcode='" + Postalcode + "',Tel='" + Tel + "',Fax='" + Fax + "',Linkman='" + Linkman + "',Email='" + Email + "',Bank='" + Bank + "',BandAccounts='" + BandAccounts + "',Username='" + Username + "',AddTime='" + AddTime + "' where id=" + QueryString.Get_Id + "";
        bool YesNo = new SqlDataBase().RunSql_Return_Bool(CmdTxt);//判断添加后返回结果，如果正确则返回的是1
        if (YesNo)
        { JScript.AlertAndRedirect("修改成功！", ReturnUrl()); }
        else
        { JScript.GoHistory("修改失败", -1); }
    }
    protected void Button2_ServerClick(object sender, EventArgs e)
    {
        Response.Redirect(ReturnUrl());
    }
    public string ReturnUrl()
    {
        string Url = "";
        switch (lbl_Type.Text)
        {
            case "客户":
                Url = "Master_UserInfo.aspx?Flag=1";
                break;
            case "供应商":
                Url = "Master_UserInfo.aspx?Flag=2";
                break;
        }
        return Url;
    }
}