addcarform.aspx.cs

这个是用C#做底层开发车辆管理系统

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace CarControl
{
	/// <summary>
	/// addcarForm 的摘要说明。
	/// </summary>
	public class addcarForm : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.TextBox TextBox2;
		protected System.Web.UI.WebControls.TextBox TextBox5;
		protected System.Web.UI.WebControls.TextBox TextBox6;
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.DropDownList DropDownList2;
		protected System.Web.UI.WebControls.Button Button1;
		
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.TextBox TextBox3;
		protected System.Web.UI.WebControls.Label Label1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(Session["S_username"].ToString()=="")
			{
				Response.Redirect("index.aspx");
			}
			
			if(Session["S_userrule"].ToString()=="")
			{
				Response.Redirect("main1.aspx");
			}// 在此处放置用户代码以初始化页面
			if(!IsPostBack)
			{   
				//初始化单位名单
				string SqlConn=System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
				SqlConnection Conn=new SqlConnection(SqlConn);
				Conn.Open();
				string sqlstring="select * from bumen";
				SqlDataAdapter myadapter =new SqlDataAdapter(sqlstring,Conn);
				DataSet ds=new DataSet();
				myadapter.Fill(ds,"bumen");
				DropDownList1.DataSource=ds;
				DropDownList1.DataTextField="type";
				DropDownList1.DataValueField="type";
				DropDownList1.DataBind();
				DropDownList1.Items.Add("暂无");
                DropDownList1.Items[DropDownList1.Items.Count-1].Value="";
                DropDownList1.SelectedIndex=this.DropDownList1.Items.Count - 1;
　　　　　　　　//初始化司机名单
                string sqlstring1="select * from [user] where part='院办(车队)'";
				SqlCommand cmd=new SqlCommand();
				cmd.Connection=Conn;
				cmd.CommandText=sqlstring1;
				SqlDataReader dsread=cmd.ExecuteReader();
				if(!dsread.Read())
				{
					DropDownList2.Items.Add("任意人");
					DropDownList2.Items[DropDownList2.Items.Count-1].Value="";
					DropDownList2.SelectedIndex=this.DropDownList2.Items.Count - 1;
				}
				else
				{   
					dsread.Close();
					SqlDataAdapter myadapter1 =new SqlDataAdapter(sqlstring1,Conn);
					DataSet ds1=new DataSet();
					myadapter1.Fill(ds1,"user");
					DropDownList2.DataSource=ds1;
					DropDownList2.DataTextField="name";
					DropDownList2.DataValueField="name";
					DropDownList2.DataBind();
					DropDownList2.Items.Add("任意人");
					DropDownList2.Items[DropDownList2.Items.Count-1].Value="";
					DropDownList2.SelectedIndex=this.DropDownList2.Items.Count - 1;
				}
				Conn.Close();
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		

		private void Button1_Click(object sender, System.EventArgs e)
		{
			string carnum=TextBox1.Text;
            string cartype=TextBox2.Text;
			string carzuowei=TextBox3.Text;
		    string dtel=TextBox5.Text;
		    string dphone=TextBox6.Text;
			string depart=DropDownList1.SelectedItem.Text.ToString();
            string driver=DropDownList2.SelectedItem.Text.ToString();
			string regtime=DateTime.Now.ToString();
			string carstate="空闲";
			string car_xc="－－－－";
			string car_gl="－－－－";
			string car_qssj="－－－－";
			string car_jssj="－－－－";
			string SqlConn=System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
			SqlConnection conn=new SqlConnection(SqlConn);
			conn.Open();
			SqlCommand cmd=new SqlCommand();
			cmd.Connection=conn;
			cmd.CommandText="insert into [car]([car_code],[car_type],[car_zuowei],[car_company],[car_user],[car_usermobile],[car_usertel],[car_regtime],[car_state],[car_xingcheng],[car_gongli],[car_statestart],[car_stateend]) values('"+carnum+"','"+cartype+"','"+carzuowei+"','"+depart+"','"+driver+"','"+dtel+"','"+dphone+"','"+regtime+"','"+carstate+"','"+car_xc+"','"+car_gl+"','"+car_qssj+"','"+car_jssj+"')";
			cmd.ExecuteNonQuery();
			cmd.Dispose();
			conn.Close();
			TextBox1.Text="";
			TextBox2.Text="";
			TextBox3.Text="";
			TextBox5.Text="";
			TextBox6.Text="";
			DropDownList1.SelectedIndex=this.DropDownList1.Items.Count - 1;
			DropDownList2.SelectedIndex=this.DropDownList2.Items.Count - 1;
			this.Label1.Text="车辆添加成功！请关闭窗口。";
		}

		
	}
}