cancelres.aspx.cs

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

			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));
			// 
			// 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", "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.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// sqlCommand1
			// 
			this.sqlCommand1.CommandText = "dbo.[DeleteReservations]";
			this.sqlCommand1.CommandType = System.Data.CommandType.StoredProcedure;
			this.sqlCommand1.Connection = this.sqlConnection1;
			this.sqlCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
			this.sqlCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ticketno", System.Data.SqlDbType.VarChar, 10));
			this.sqlCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@user", System.Data.SqlDbType.VarChar, 15));
			this.sqlCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@cancdate", System.Data.SqlDbType.DateTime, 8));
			this.sqlCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@refund", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
			// 
			// dataSet51
			// 
			this.dataSet51.DataSetName = "DataSet5";
			this.dataSet51.Locale = new System.Globalization.CultureInfo("en-US");
			this.dataSet51.Namespace = "http://www.tempuri.org/DataSet5.xsd";
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataSet51)).EndInit();

		}
		#endregion

		private void Button2_Click(object sender, System.EventArgs e)
		{
			lblMessage.Text="";
			dataSet51.Clear();
			sqlConnection1.Open();
			sqlDataAdapter1.SelectCommand.Parameters[0].Value=txtTNo.Text.Trim();
			sqlDataAdapter1.Fill(dataSet51, "TicketDetails");
			sqlConnection1.Close();
			if (dataSet51.Tables["TicketDetails"].Rows.Count==0)
			{
				lblMessage.Text="Invalid ticket number";
				return;
			}
			else
			{
				string ticketno, user, cancdate, journeydate;
				int refund, fare;
				ticketno=txtTNo.Text.Trim();
				journeydate=dataSet51.Tables["TicketDetails"].Rows[0][2].ToString();
				fare=Convert.ToInt32(dataSet51.Tables["TicketDetails"].Rows[0][6].ToString());
				if (Convert.ToDateTime(journeydate)<=DateTime.Today)
				{
					refund=fare-10;
				}
				else
				{
					refund=Convert.ToInt32(fare*0.8);
				}
				cancdate=DateTime.Today.ToShortDateString();
				user=Session["usrName"].ToString();
				sqlCommand1.Parameters[1].Value=ticketno;
				sqlCommand1.Parameters[2].Value=user;
				sqlCommand1.Parameters[3].Value=cancdate;
				sqlCommand1.Parameters[4].Value=refund;
				sqlConnection1.Open();
				sqlCommand1.ExecuteReader();
				sqlConnection1.Close();
				lblMessage.Text="Please refund US $ " + refund.ToString();
				txtTNo.Text="";
			}
		}
	}
}