querystat.aspx.cs

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

			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = @"UPDATE dtReservations SET TicketNo = @TicketNo, FltNo = @FltNo, DateOfJourney = @DateOfJourney, ClassOfRes = @ClassOfRes, Name = @Name, EMail = @EMail, Fare = @Fare, Status = @Status, ReservedBy = @ReservedBy, DateOfRes = @DateOfRes, TicketConfirmed = @TicketConfirmed WHERE (TicketNo = @Original_TicketNo) AND (ClassOfRes = @Original_ClassOfRes) AND (DateOfJourney = @Original_DateOfJourney) AND (DateOfRes = @Original_DateOfRes) AND (EMail = @Original_EMail OR @Original_EMail IS NULL AND EMail IS NULL) AND (Fare = @Original_Fare) AND (FltNo = @Original_FltNo) AND (Name = @Original_Name) AND (ReservedBy = @Original_ReservedBy) AND (Status = @Original_Status) AND (TicketConfirmed = @Original_TicketConfirmed OR @Original_TicketConfirmed IS NULL AND TicketConfirmed IS NULL); SELECT TicketNo, FltNo, DateOfJourney, ClassOfRes, Name, EMail, Fare, Status, ReservedBy, DateOfRes, TicketConfirmed FROM dtReservations WHERE (TicketNo = @TicketNo)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@TicketNo", System.Data.SqlDbType.VarChar, 10, "TicketNo"));
			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("@DateOfJourney", System.Data.SqlDbType.DateTime, 8, "DateOfJourney"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClassOfRes", System.Data.SqlDbType.VarChar, 10, "ClassOfRes"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Name", System.Data.SqlDbType.VarChar, 20, "Name"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EMail", System.Data.SqlDbType.VarChar, 50, "EMail"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Fare", System.Data.SqlDbType.Int, 4, "Fare"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Status", System.Data.SqlDbType.Int, 4, "Status"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReservedBy", System.Data.SqlDbType.VarChar, 15, "ReservedBy"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@DateOfRes", System.Data.SqlDbType.DateTime, 8, "DateOfRes"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@TicketConfirmed", System.Data.SqlDbType.Bit, 1, "TicketConfirmed"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_TicketNo", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TicketNo", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClassOfRes", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClassOfRes", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_DateOfJourney", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateOfJourney", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_DateOfRes", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateOfRes", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_EMail", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EMail", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Fare", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Fare", System.Data.DataRowVersion.Original, null));
			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_Name", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Name", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ReservedBy", System.Data.SqlDbType.VarChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReservedBy", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Status", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Status", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_TicketConfirmed", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TicketConfirmed", System.Data.DataRowVersion.Original, null));
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = @"DELETE FROM dtReservations WHERE (TicketNo = @Original_TicketNo) AND (ClassOfRes = @Original_ClassOfRes) AND (DateOfJourney = @Original_DateOfJourney) AND (DateOfRes = @Original_DateOfRes) AND (EMail = @Original_EMail OR @Original_EMail IS NULL AND EMail IS NULL) AND (Fare = @Original_Fare) AND (FltNo = @Original_FltNo) AND (Name = @Original_Name) AND (ReservedBy = @Original_ReservedBy) AND (Status = @Original_Status) AND (TicketConfirmed = @Original_TicketConfirmed OR @Original_TicketConfirmed IS NULL AND TicketConfirmed IS NULL)";
			this.sqlDeleteCommand1.Connection = this.sqlConnection1;
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_TicketNo", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TicketNo", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClassOfRes", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClassOfRes", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_DateOfJourney", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateOfJourney", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_DateOfRes", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "DateOfRes", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_EMail", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "EMail", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Fare", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Fare", System.Data.DataRowVersion.Original, null));
			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_Name", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Name", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ReservedBy", System.Data.SqlDbType.VarChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ReservedBy", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Status", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Status", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_TicketConfirmed", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "TicketConfirmed", System.Data.DataRowVersion.Original, null));
			// 
			// sqlDataAdapter2
			// 
			this.sqlDataAdapter2.DeleteCommand = this.sqlDeleteCommand1;
			this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand2;
			this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand2;
			this.sqlDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "dtReservations", new System.Data.Common.DataColumnMapping[] {
																																																						new System.Data.Common.DataColumnMapping("TicketNo", "TicketNo"),
																																																						new System.Data.Common.DataColumnMapping("FltNo", "FltNo"),
																																																						new System.Data.Common.DataColumnMapping("DateOfJourney", "DateOfJourney"),
																																																						new System.Data.Common.DataColumnMapping("ClassOfRes", "ClassOfRes"),
																																																						new System.Data.Common.DataColumnMapping("Name", "Name"),
																																																						new System.Data.Common.DataColumnMapping("EMail", "EMail"),
																																																						new System.Data.Common.DataColumnMapping("Fare", "Fare"),
																																																						new System.Data.Common.DataColumnMapping("Status", "Status"),
																																																						new System.Data.Common.DataColumnMapping("ReservedBy", "ReservedBy"),
																																																						new System.Data.Common.DataColumnMapping("DateOfRes", "DateOfRes"),
																																																						new System.Data.Common.DataColumnMapping("TicketConfirmed", "TicketConfirmed")})});
			this.sqlDataAdapter2.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// dataSet41
			// 
			this.dataSet41.DataSetName = "DataSet4";
			this.dataSet41.Locale = new System.Globalization.CultureInfo("en-US");
			this.dataSet41.Namespace = "http://www.tempuri.org/DataSet4.xsd";
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataSet41)).EndInit();

		}
		#endregion

		private void Button2_Click(object sender, System.EventArgs e)
		{
			dataSet41.Clear();
			lblMessage.Text="";
			lblStatus.Text="";
			if (txtFltNo.Text=="" || txtFltNo.Text==null)
			{
				lblMessage.Text="Invalid flight number";
				return;
			}
			else
			{
				sqlConnection1.Open();
				sqlDataAdapter1.SelectCommand.Parameters[0].Value=txtFltNo.Text.Trim();
				sqlDataAdapter1.SelectCommand.Parameters[1].Value=Cal1.SelectedDate.ToShortDateString();
				sqlDataAdapter1.SelectCommand.Parameters[2].Value=lstClass.SelectedItem.Text;
				sqlDataAdapter1.Fill(dataSet41, "FltStatus");
				sqlConnection1.Close();
				if (dataSet41.Tables["FltStatus"].Rows.Count==0)
				{
					lblStatus.Text="Status: Available";
				}
				else
				{
					string strStatus;
					int status;
					strStatus=dataSet41.Tables["FltStatus"].Rows[0][0].ToString();
					status=Convert.ToInt32(strStatus);
					if (status >= 0)
					{
						lblStatus.Text="Status: Available";
					}
					else
					{
						lblStatus.Text="Status: Overbooked (" + strStatus + ")";
					}
				}
			}
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			dataSet41.Clear();
			lblMessage.Text="";
			lblStatus.Text="";
			if (txtTNo.Text=="" || txtTNo.Text==null)
			{
				lblMessage.Text="Invalid flight number";
				return;
			}
			else
			{
				sqlConnection1.Open();
				sqlDataAdapter2.SelectCommand.Parameters[0].Value=txtTNo.Text.Trim();
				sqlDataAdapter2.Fill(dataSet41, "TicketStatus");
				sqlConnection1.Close();
				if (dataSet41.Tables["TicketStatus"].Rows.Count==0)
				{
					lblMessage.Text="Invalid ticket number.";
				}
				else
				{
					string strStatus;
					int status;
					strStatus=dataSet41.Tables["TicketStatus"].Rows[0][0].ToString();
					status=Convert.ToInt32(strStatus);
					if (status >= 0)
					{
						lblStatus.Text="Status: Confirmed";
					}
					else
					{
						lblStatus.Text="Status: Overbooked (" + strStatus + ")";
					}
				}
			}
		}
	}
}