ticket.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;

namespace SkyShark.LOB
{
	/// <summary>
	/// Summary description for Ticket.
	/// </summary>
	public class NewTicket : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label lblName;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label lblFltNo;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Label lblTicketNo;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Label lblJourneyDate;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.Label lblBoard;
		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 SkyShark.LOB.DataSet3 dataSet31;
		protected System.Web.UI.WebControls.Label lblFrom;
		protected System.Web.UI.WebControls.Label lblTo;
		protected System.Web.UI.WebControls.Label Label1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if (Session["usrRole"]==null)
			{
				Response.Redirect("..\\default.aspx");
			}
										  
			if (!(Session["usrRole"].ToString()=="LOB"))
			{
				Response.Redirect("..\\default.aspx");
			}
			else
			{
				string ticketno=Request.QueryString.Get(0).ToString();
                sqlDataAdapter1.SelectCommand.Parameters[0].Value=ticketno;
				sqlConnection1.Open();
				sqlDataAdapter1.Fill(dataSet31,"Ticket");
				sqlConnection1.Close();
				lblTicketNo.Text=dataSet31.Tables["Ticket"].Rows[0][0].ToString();
				lblFltNo.Text=dataSet31.Tables["Ticket"].Rows[0][1].ToString();
				string journeydate=dataSet31.Tables["Ticket"].Rows[0][2].ToString();
				lblJourneyDate.Text=Convert.ToDateTime(journeydate).ToShortDateString();
				lblName.Text=dataSet31.Tables["Ticket"].Rows[0][3].ToString();
				lblFrom.Text=dataSet31.Tables["Ticket"].Rows[0][4].ToString();
				lblTo.Text=dataSet31.Tables["Ticket"].Rows[0][5].ToString();
				lblBoard.Text="Boarding " + lblFrom.Text + " at " + 
					dataSet31.Tables["Ticket"].Rows[0][6].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.dataSet31 = new SkyShark.LOB.DataSet3();
			((System.ComponentModel.ISupportInitialize)(this.dataSet31)).BeginInit();
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = @"SELECT dtReservations.TicketNo, dtReservations.FltNo, dtReservations.DateOfJourney, dtReservations.Name, dtFltDetails.Origin, dtFltDetails.Destination, dtFltDetails.Deptime FROM dtReservations INNER JOIN dtFltDetails ON dtReservations.FltNo = dtFltDetails.FltNo WHERE (dtReservations.TicketNo = @ticketno)";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ticketno", System.Data.SqlDbType.VarChar, 10, "TicketNo"));