addfl.aspx.cs

民航订票系统,实现自助订票,方便快捷!请大家放心下载!

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
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 SkyShark.BM
{
	/// <summary>
	/// Summary description for _default.
	/// </summary>
	public class WebAddFl : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.HyperLink HyperLink2;
		protected System.Web.UI.WebControls.HyperLink HyperLink4;
		protected System.Web.UI.WebControls.HyperLink HyperLink5;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.Label Label8;
		protected System.Web.UI.WebControls.Label Label9;
		protected System.Web.UI.WebControls.Label Label10;
		protected System.Web.UI.WebControls.Label Label11;
		protected System.Web.UI.WebControls.Label Label12;
		protected System.Data.SqlClient.SqlCommand sqlSelectCommand1;
		protected System.Data.SqlClient.SqlCommand sqlInsertCommand1;
		protected System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
		protected System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
		protected System.Data.SqlClient.SqlConnection sqlConnection1;
		protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
		protected System.Web.UI.WebControls.Label txtUser;
		protected System.Web.UI.WebControls.TextBox txtFareBn;
		protected System.Web.UI.WebControls.TextBox txtFareExec;
		protected System.Web.UI.WebControls.TextBox txtSeatsBus;
		protected System.Web.UI.WebControls.TextBox txtSeatsExec;
		protected System.Web.UI.WebControls.TextBox txtArrTime;
		protected System.Web.UI.WebControls.TextBox txtDepTime;
		protected System.Web.UI.WebControls.TextBox txtDestination;
		protected System.Web.UI.WebControls.TextBox txtOrigin;
		protected System.Web.UI.WebControls.Button btnAdd;
		protected System.Web.UI.WebControls.Button btnCancel;
		protected System.Web.UI.WebControls.TextBox txtFltNo;
		protected System.Web.UI.WebControls.Label Label13;
		protected System.Web.UI.WebControls.TextBox txtAircraft;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator6;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator7;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator8;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator9;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator10;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator1;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator2;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator3;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator4;
		protected SkyShark.BM.DataSet1 dataSet11;
		protected System.Web.UI.WebControls.Label lblMessage;
		protected System.Web.UI.WebControls.HyperLink HyperLink3;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if (Session["usrRole"]==null)
			{
				Response.Redirect("..\\default.aspx");
			}
										  
			if (!(Session["usrRole"].ToString()=="BM"))
			{
				Response.Redirect("..\\default.aspx");
			}
			else
			{
				txtUser.Text="User: "+ Session["usrName"].ToString();
			}
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
			this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
			this.dataSet11 = new SkyShark.BM.DataSet1();
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
			this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);
			this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT FltNo FROM dtFltDetails";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = @"INSERT INTO dtFltDetails (FltNo, Origin, Destination, Deptime, Arrtime, AircraftType, SeatsExec, SeatsBn, FareExec, FareBn, LaunchDate) VALUES (@FltNo, @Origin, @Destination, @Deptime, @Arrtime, @AircraftType, @SeatsExec, @SeatsBn, @FareExec, @FareBn, @LaunchDate)";
			this.sqlInsertCommand1.Connection = this.sqlConnection1;
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@FltNo", System.Data.SqlDbType.VarChar, 10, "FltNo"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Origin", System.Data.SqlDbType.VarChar, 16, "Origin"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Destination", System.Data.SqlDbType.VarChar, 16, "Destination"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Deptime", System.Data.SqlDbType.DateTime, 8, "Deptime"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Arrtime", System.Data.SqlDbType.DateTime, 8, "Arrtime"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@AircraftType", System.Data.SqlDbType.VarChar, 10, "AircraftType"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SeatsExec", System.Data.SqlDbType.Int, 4, "SeatsExec"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SeatsBn", System.Data.SqlDbType.Int, 4, "SeatsBn"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@FareExec", System.Data.SqlDbType.Int, 4, "FareExec"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@FareBn", System.Data.SqlDbType.Int, 4, "FareBn"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@LaunchDate", System.Data.SqlDbType.DateTime, 8, "LaunchDate"));
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = @"UPDATE dtFltDetails SET FltNo = @FltNo, Origin = @Origin, Destination = @Destination, Deptime = @Deptime, Arrtime = @Arrtime, AircraftType = @AircraftType, SeatsExec = @SeatsExec, SeatsBn = @SeatsBn, FareExec = @FareExec, FareBn = @FareBn, LaunchDate = @LaunchDate WHERE (FltNo = @Original_FltNo) AND (AircraftType = @Original_AircraftType) AND (Arrtime = @Original_Arrtime) AND (Deptime = @Original_Deptime) AND (FareBn = @Original_FareBn) AND (FareExec = @Original_FareExec) AND (LaunchDate = @Original_LaunchDate) AND (SeatsBn = @Original_SeatsBn) AND (SeatsExec = @Original_SeatsExec); SELECT FltNo, Origin, Destination, Deptime, Arrtime, AircraftType, SeatsExec, SeatsBn, FareExec, FareBn, LaunchDate FROM dtFltDetails WHERE (FltNo = @FltNo)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@FltNo", System.Data.SqlDbType.VarChar, 10, "FltNo"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Origin", System.Data.SqlDbType.VarChar, 16, "Origin"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Destination", System.Data.SqlDbType.VarChar, 16, "Destination"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Deptime", System.Data.SqlDbType.DateTime, 8, "Deptime"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Arrtime", System.Data.SqlDbType.DateTime, 8, "Arrtime"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@AircraftType", System.Data.SqlDbType.VarChar, 10, "AircraftType"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SeatsExec", System.Data.SqlDbType.Int, 4, "SeatsExec"));