?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_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>");
        }
    }
    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 + "')", strcon);
        scd.ExecuteNonQuery();
        Response.Write("<script language=javascript>alert('您已經(jīng)添加成功');location='Company_add.aspx'</script>");
        strcon.Close();
    }
}