edit_product.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_Product : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        HeardConfig();
        if (!IsPostBack)
        {
            PersonInfo.Return_SessionPerson();//判断管理员是否登陆
            IsPage_Bind();
        }
    }

    public void IsPage_Bind()
    {
        string CmdTxt = "select id,CompanyName from Company where CompanyType='供应商' order by id desc";
        this.CompanyId.DataSource = new SqlDataBase().GetDs(CmdTxt);
        this.CompanyId.DataTextField = "CompanyName";
        this.CompanyId.DataValueField = "Id";
        this.CompanyId.DataBind();

        //读取各项数据并绑定到指定的文本框
        string CmdTxt2 = "select * from Commodity where id=" + QueryString.Get_Id + "";
        SqlDataReader sdr = new SqlDataBase().GetDataReader(CmdTxt2);
        if (sdr.Read())
        {
            this.CommodityName.Text = sdr["CommodityName"].ToString();
            this.ShortName.Text = sdr["ShortName"].ToString();
            this.ProducePlace.Text = sdr["ProducePlace"].ToString();
            this.Unit.Text = sdr["Unit"].ToString();
            this.Specs.Text = sdr["Specs"].ToString();
            this.PassNumber.Text = sdr["PassNumber"].ToString();
            this.PassList.Text = sdr["PassList"].ToString();
            this.CompanyId.SelectedValue = sdr["CompanyId"].ToString();
            this.Remark.Text = sdr["Remark"].ToString();
        }
        sdr.Close();//关闭
        sdr.Dispose();//释放资源
    }
    #region 页面初始化必需的内容
    public void HeardConfig()
    {
        Header.Title = "销售订单管理系统-商品修改";
        HeaderTextInfo.GetHeader(this, null);
    }
    #endregion
    protected void Button2_ServerClick(object sender, EventArgs e)
    {
        JScript.JavaScriptLocationHref("Master_Product.aspx");
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //取出对应的文本诓数据
        string CommodityName = this.CommodityName.Text.ToString();
        string ShortName = this.ShortName.Text.ToString();
        string ProducePlace = this.ProducePlace.Text.ToString();
        string Unit = this.Unit.Text.ToString();
        string Specs = this.Specs.Text.ToString();
        string PassNumber = this.PassNumber.Text.ToString();
        string PassList = this.PassList.Text.ToString();
        string CompanyId = this.CompanyId.Text.ToString();
        string Remark = this.Remark.Text.ToString();
        string Username = QueryString.Get_SessionPerson;
        string AddTime = Convert.ToString(DateTime.Now);
        //修改数据
        string CmdTxt = "update Commodity set CommodityName ='" + CommodityName + "',ShortName ='" + ShortName + "',ProducePlace ='" + ProducePlace + "',Unit='" + Unit + "',Specs='" + Specs + "',PassNumber='" + PassNumber + "',PassList='" + PassList + "',CompanyId='" + CompanyId + "',Remark='" + Remark + "',Username='" + Username + "',AddTime='" + AddTime + "' where id=" + QueryString.Get_Id + "";
        bool YesNo = new SqlDataBase().RunSql_Return_Bool(CmdTxt);//判断添加后返回结果，如果正确则返回的是1
        if (YesNo)
        { JScript.AlertAndRedirect("修改成功！", "Master_Product.aspx"); }
        else
        { JScript.GoHistory("修改失败", -1); }
    }
}