addfl.aspx.cs

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

			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SeatsBn", System.Data.SqlDbType.Int, 4, "SeatsBn"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@FareExec", System.Data.SqlDbType.Int, 4, "FareExec"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@FareBn", System.Data.SqlDbType.Int, 4, "FareBn"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@LaunchDate", System.Data.SqlDbType.DateTime, 8, "LaunchDate"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_FltNo", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FltNo", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_AircraftType", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AircraftType", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Arrtime", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Arrtime", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Deptime", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Deptime", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_FareBn", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FareBn", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_FareExec", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FareExec", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_LaunchDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "LaunchDate", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_SeatsBn", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SeatsBn", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_SeatsExec", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SeatsExec", System.Data.DataRowVersion.Original, null));
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = @"DELETE FROM dtFltDetails 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)";
			this.sqlDeleteCommand1.Connection = this.sqlConnection1;
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_FltNo", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FltNo", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_AircraftType", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "AircraftType", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Arrtime", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Arrtime", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Deptime", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Deptime", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_FareBn", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FareBn", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_FareExec", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FareExec", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_LaunchDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "LaunchDate", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_SeatsBn", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SeatsBn", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_SeatsExec", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "SeatsExec", System.Data.DataRowVersion.Original, null));
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "data source=NPANDEY-D185;initial catalog=Skyshark;integrated security=SSPI;persis" +
				"t security info=True;workstation id=NPANDEY-D185;packet size=4096";
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
			this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "dtFltDetails", new System.Data.Common.DataColumnMapping[] {
																																																					  new System.Data.Common.DataColumnMapping("FltNo", "FltNo"),
																																																					  new System.Data.Common.DataColumnMapping("Origin", "Origin"),
																																																					  new System.Data.Common.DataColumnMapping("Destination", "Destination"),
																																																					  new System.Data.Common.DataColumnMapping("Deptime", "Deptime"),
																																																					  new System.Data.Common.DataColumnMapping("Arrtime", "Arrtime"),
																																																					  new System.Data.Common.DataColumnMapping("AircraftType", "AircraftType"),
																																																					  new System.Data.Common.DataColumnMapping("SeatsExec", "SeatsExec"),
																																																					  new System.Data.Common.DataColumnMapping("SeatsBn", "SeatsBn"),
																																																					  new System.Data.Common.DataColumnMapping("FareExec", "FareExec"),
																																																					  new System.Data.Common.DataColumnMapping("FareBn", "FareBn"),
																																																					  new System.Data.Common.DataColumnMapping("LaunchDate", "LaunchDate")})});
			this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// dataSet11
			// 
			this.dataSet11.DataSetName = "DataSet1";
			this.dataSet11.Locale = new System.Globalization.CultureInfo("en-US");
			this.dataSet11.Namespace = "http://www.tempuri.org/DataSet1.xsd";
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();

		}
		#endregion

		private void btnAdd_Click(object sender, System.EventArgs e)
		{
			dataSet11.Clear();
			sqlConnection1.Open();
			sqlDataAdapter1.Fill(dataSet11,"FltNos");
			sqlConnection1.Close();
			foreach (DataRow myRow in dataSet11.Tables["FltNos"].Rows)
			{
				if (myRow[0].ToString().Trim().ToLower()==txtFltNo.Text.ToLower())
				{
					lblMessage.Text="The flight already exists. Please try another flight number.";
					return;
				}
			}
/*			if (!(dataSet11.Tables[0].Rows.Count==0))
			{
				lblMessage.Text="The flight number already exists. Please try again.";
				return;
			}
*/
			TimeSpan deptime, arrtime;
			try
			{
				deptime=Convert.ToDateTime(txtDepTime.Text).TimeOfDay;
				arrtime=Convert.ToDateTime(txtDepTime.Text).TimeOfDay;
			}
            catch
			{
				lblMessage.Text="Invalid departure or arrival time";
				return;
			}
			try
			{
				sqlDataAdapter1.InsertCommand.Parameters[0].Value=txtFltNo.Text.Trim();
				sqlDataAdapter1.InsertCommand.Parameters[1].Value=txtOrigin.Text.Trim();
				sqlDataAdapter1.InsertCommand.Parameters[2].Value=txtDestination.Text.Trim();
				sqlDataAdapter1.InsertCommand.Parameters[3].Value=deptime.ToString();
				sqlDataAdapter1.InsertCommand.Parameters[4].Value=arrtime.ToString();
				sqlDataAdapter1.InsertCommand.Parameters[5].Value=txtAircraft.Text.Trim();
				sqlDataAdapter1.InsertCommand.Parameters[6].Value=Convert.ToInt32(txtSeatsExec.Text.Trim());
				sqlDataAdapter1.InsertCommand.Parameters[7].Value=Convert.ToInt32(txtSeatsBus.Text.Trim());
				sqlDataAdapter1.InsertCommand.Parameters[8].Value=Convert.ToInt32(txtFareExec.Text.Trim());
				sqlDataAdapter1.InsertCommand.Parameters[9].Value=Convert.ToInt32(txtFareBn.Text.Trim());
				sqlDataAdapter1.InsertCommand.Parameters[10].Value=DateTime.Today.Date.ToShortDateString();
				sqlConnection1.Open();
				sqlDataAdapter1.InsertCommand.ExecuteNonQuery();
			}
			catch
			{
				lblMessage.Text="Unable to add flight details.";
				sqlConnection1.Close();
				return;
			}
			sqlConnection1.Close();
			lblMessage.Text="Flight added successfully.";
			txtFareBn.Text="";
			txtFareExec.Text="";
			txtSeatsBus.Text="";
			txtSeatsExec.Text="";
			txtArrTime.Text="";
			txtDepTime.Text="";
			txtDestination.Text="";
			txtOrigin.Text="";
			txtFltNo.Text="";
			txtAircraft.Text="";
		}

		private void btnCancel_Click(object sender, System.EventArgs e)
		{
			txtFareBn.Text="";
			txtFareExec.Text="";
			txtSeatsBus.Text="";
			txtSeatsExec.Text="";
			txtArrTime.Text="";
			txtDepTime.Text="";
			txtDestination.Text="";
			txtOrigin.Text="";
			txtFltNo.Text="";
			txtAircraft.Text="";
		}
	}
}