commodity_add.aspx.cs

基于JSP+SQL Sever2000+Tomcat的网络服务器体系结构开发技术和对数据库技术的进一步了解以及对政府网站的调查研究

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('请登录');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='供应商' 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('您已经添加成功');location='Commodity_add.aspx'</script>");
    }
}