?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 Bedrock_Commodity_add : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Convert.ToString(Session["username"]) == "")
        {
            Response.Write("<script language=javascript>alert('請(qǐng)登錄');location='../login.aspx'</script>");
            return;
        }
        if (!IsPostBack)
        {
            SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
            strcon.Open();
            SqlDataAdapter sda = new SqlDataAdapter("select * from tb_Company where CompanyType='供應(yīng)商' order by id desc",strcon);
            DataSet ds = new DataSet();
            sda.Fill(ds, "tb_Company");
            this.CompanyId.DataSource = ds;
            this.CompanyId.DataValueField = "id";
            this.CompanyId.DataTextField = "CompanyName";
            this.CompanyId.DataBind();
        }
    }
    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 = Convert.ToString(Session["username"]);
        string AddTime = Convert.ToString(DateTime.Now);
        SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
        strcon.Open();
        SqlCommand scd = new SqlCommand("insert into tb_Commodity (CommodityName,ShortName,ProducePlace,Unit,Specs,PassNumber,PassList,CompanyId,Remark,Username,AddTime)values('" + CommodityName + "','" + ShortName + "','" + ProducePlace + "','" + Unit + "','" + Specs + "','" + PassNumber + "','" + PassList + "','" + CompanyId + "','" + Remark + "','" + Username + "','" + AddTime + "')", strcon);
        scd.ExecuteNonQuery();
        strcon.Close();
        Response.Write("<script language=javascript>alert('您已經(jīng)添加成功');location='Commodity_add.aspx'</script>");
    }
}