?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 Chauffeur : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (Page.IsValid == true)
        {
            SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
            strcon.Open();
            string ChauffeurName=this.ChauffeurName.Text.ToString();
            string Type=this.Type.Text.ToString();
            string Health=this.Health.Text.ToString();
            string DriveAge=this.DriveAge.Text.ToString();
            string TruckType=this.TruckType.Text.ToString();
            string Area=this.Area.Text.ToString();
            string Tel=this.Tel.Text.ToString();
            string EffectDate=this.EffectDate.Text.ToString();
            string Bewrite=this.Bewrite.Text.ToString();
            string Username = Session["username"].ToString();
            string ChauffeurNow = Convert.ToString(DateTime.Now); 
            SqlCommand cmd = new SqlCommand("insert into tb_Chauffeur (ChauffeurName,Type,Health,DriveAge,TruckType,Area,Tel,EffectDate,Bewrite,ChauffeurNow,username)values('" + ChauffeurName + "','" + Type + "','" + Health + "','" + DriveAge + "','" + TruckType + "','" + Area + "','" + Tel + "','" + EffectDate + "','" + Bewrite + "','" + ChauffeurNow + "','"+Username+"')", strcon);
            cmd.ExecuteNonQuery();
            strcon.Close();
            Response.Write("<script language=javascript>alert('恭喜您，添加成功！等待審核！');location='Chauffeur_send.aspx'</script>");
        }
    }
}