add_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;

public partial class Add_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();
    }
    #region 页面初始化必需的内容
    public void HeardConfig()
    {
        Header.Title = "销售订单管理系统-商品添加";
        HeaderTextInfo.GetHeader(this, null);
    }
    #endregion
    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 = "insert into Commodity (CommodityName,ShortName,ProducePlace,Unit,Specs,PassNumber,PassList,CompanyId,Remark,Username,AddTime)values('" + CommodityName + "','" + ShortName + "','" + ProducePlace + "','" + Unit + "','" + Specs + "','" + PassNumber + "','" + PassList + "','" + CompanyId + "','" + Remark + "','" + Username + "','" + AddTime + "')";
        bool YesNo = new SqlDataBase().RunSql_Return_Bool(CmdTxt);//判断添加后返回结果，如果正确则返回的是1
        if (YesNo)
        { JScript.AlertAndRedirect("添加成功！", "Add_Product.aspx"); }
        else
        { JScript.GoHistory("添加失败", -1); }
    }
}