company_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_Company_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 where id="+Request["id"],strcon);
            DataSet ds = new DataSet();
            sda.Fill(ds, "tb_Company");
            DataRowView rowview = ds.Tables["tb_Company"].DefaultView[0];
            CompanyName.Text = rowview["CompanyName"].ToString();
            CompanyType.Text= rowview["CompanyType"].ToString();
            CompanyShort.Text= rowview["CompanyShort"].ToString();
            CompanyAddress.Text= rowview["CompanyAddress"].ToString();
            Postalcode.Text= rowview["Postalcode"].ToString();
            Tel.Text= rowview["Tel"].ToString();
            Fax.Text= rowview["Fax"].ToString();
            Linkman.Text= rowview["Linkman"].ToString();
            Email.Text= rowview["Email"].ToString();
            Bank.Text= rowview["Bank"].ToString();
            BandAccounts.Text= rowview["BandAccounts"].ToString();
        }
        this.Button2.Attributes.Add("onclick", "window.close();");
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string CompanyName=this.CompanyName.Text.ToString();
        string CompanyType=this.CompanyType.Text.ToString();
        string CompanyShort=this.CompanyShort.Text.ToString();
        string CompanyAddress=this.CompanyAddress.Text.ToString();
        string Postalcode=this.Postalcode.Text.ToString();
        string Tel=this.Tel.Text.ToString();
        string Fax=this.Fax.Text.ToString();
        string Linkman=this.Linkman.Text.ToString();
        string Email=this.Email.Text.ToString();
        string Bank=this.Bank.Text.ToString();
        string BandAccounts=this.BandAccounts.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_Company (CompanyName,CompanyType,CompanyShort,CompanyAddress,Postalcode,Tel,Fax,Linkman,Email,Bank,BandAccounts,Username,AddTime)values('" + CompanyName + "','" + CompanyType + "','" + CompanyShort + "','" + CompanyAddress + "','" + Postalcode + "','" + Tel + "','" + Fax + "','" + Linkman + "','" + Email + "','" + Bank + "','" + BandAccounts + "','" + Username + "','" + AddTime + "') where id='"+Request["id"].ToString()+"'", strcon);

        SqlCommand scd = new SqlCommand("update tb_Company set CompanyName='" + CompanyName + "',CompanyType='" + CompanyType + "',CompanyShort='" + CompanyShort + "',CompanyAddress='" + CompanyAddress + "',Postalcode='" + Postalcode + "',Tel='" + Tel + "',Fax='" + Fax + "',Linkman='" + Linkman + "',Email='" + Email + "',Bank='" + Bank + "',BandAccounts='" + BandAccounts + "',Username='" + Username + "',AddTime='" + AddTime + "' where id='" + Request["id"].ToString() + "'", strcon);
        scd.ExecuteNonQuery();
        Response.Write("<script language=javascript>alert('您已经修改成功');opener.location.reload();window.close()</script>");
        strcon.Close();
    }
}