commodity_open.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 Bedrock_Commodity_open : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
            strcon.Open();
            SqlDataAdapter sda = new SqlDataAdapter("select * from tb_Company 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();

            SqlDataAdapter sda1 = new SqlDataAdapter("select * from tb_Commodity where id=" + Request["id"], strcon);
            sda1.Fill(ds, "tb_Commodity");
            DataRowView rowview = ds.Tables["tb_Commodity"].DefaultView[0];
            CommodityName.Text = rowview["CommodityName"].ToString();
            ShortName.Text = rowview["ShortName"].ToString();
            ProducePlace.Text = rowview["ProducePlace"].ToString();
            Unit.Text = rowview["Unit"].ToString();
            Specs.Text = rowview["Specs"].ToString();
            PassNumber.Text = rowview["PassNumber"].ToString();
            PassList.Text = rowview["PassList"].ToString();
            CompanyId.Text = rowview["CompanyId"].ToString();
            Remark.Text = rowview["Remark"].ToString();
        }
        this.Button2.Attributes.Add("onclick", "window.close();");
    }
    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("update tb_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=" + Request["id"], strcon);
        scd.ExecuteNonQuery();
        strcon.Close();
        Response.Write("<script language=javascript>alert('您已经修改成功');opener.location.reload();window.close()</script>");
    }
}