📄 confirmres.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.Diagnostics;
namespace SkyShark.LOB
{
/// <summary>
/// Summary description for _default.
/// </summary>
public class ConfirmRes : System.Web.UI.Page
{
protected System.Web.UI.WebControls.HyperLink HyperLink1;
protected System.Web.UI.WebControls.HyperLink HyperLink4;
protected System.Web.UI.WebControls.HyperLink HyperLink5;
protected System.Web.UI.WebControls.HyperLink HyperLink2;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.TextBox txtTNo;
protected System.Web.UI.WebControls.Button btnConfirm;
protected System.Web.UI.WebControls.Label txtUser;
protected System.Web.UI.WebControls.Label lblDetails;
protected System.Web.UI.WebControls.Label lblMessage;
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.RequiredFieldValidator RequiredFieldValidator1;
protected SkyShark.LOB.DataSet2 dataSet21;
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()=="LOB"))
{
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.dataSet21 = new SkyShark.LOB.DataSet2();
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).BeginInit();
this.btnConfirm.Click += new System.EventHandler(this.btnConfirm_Click);
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT TicketNo, FltNo, DateOfJourney, ClassOfRes, Name, EMail, Fare, Status, Res" +
"ervedBy, DateOfRes, TicketConfirmed FROM dtReservations WHERE (TicketNo = @ticke" +
"tno)";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ticketno", System.Data.SqlDbType.VarChar, 10, "TicketNo"));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO dtReservations(TicketNo, FltNo, DateOfJourney, ClassOfRes, Name, EMail, Fare, Status, ReservedBy, DateOfRes, TicketConfirmed) VALUES (@TicketNo, @FltNo, @DateOfJourney, @ClassOfRes, @Name, @EMail, @Fare, @Status, @ReservedBy, @DateOfRes, @TicketConfirmed); SELECT TicketNo, FltNo, DateOfJourney, ClassOfRes, Name, EMail, Fare, Status, ReservedBy, DateOfRes, TicketConfirmed FROM dtReservations WHERE (TicketNo = @TicketNo)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@TicketNo", System.Data.SqlDbType.VarChar, 10, "TicketNo"));
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("@DateOfJourney", System.Data.SqlDbType.DateTime, 8, "DateOfJourney"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClassOfRes", System.Data.SqlDbType.VarChar, 10, "ClassOfRes"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Name", System.Data.SqlDbType.VarChar, 20, "Name"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EMail", System.Data.SqlDbType.VarChar, 50, "EMail"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Fare", System.Data.SqlDbType.Int, 4, "Fare"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Status", System.Data.SqlDbType.Int, 4, "Status"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReservedBy", System.Data.SqlDbType.VarChar, 15, "ReservedBy"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@DateOfRes", System.Data.SqlDbType.DateTime, 8, "DateOfRes"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@TicketConfirmed", System.Data.SqlDbType.Bit, 1, "TicketConfirmed"));
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = "UPDATE dtReservations SET TicketConfirmed = \'1\' WHERE (TicketNo = @Original_Ticke" +
"tNo)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
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));
//
// 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;
//
// dataSet21
//
this.dataSet21.DataSetName = "DataSet2";
this.dataSet21.Locale = new System.Globalization.CultureInfo("en-US");
this.dataSet21.Namespace = "http://www.tempuri.org/DataSet2.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).EndInit();
}
#endregion
private void btnConfirm_Click(object sender, System.EventArgs e)
{
lblMessage.Text="";
lblDetails.Visible=false;
sqlConnection1.Open();
dataSet21.Clear();
sqlDataAdapter1.SelectCommand.Parameters[0].Value=txtTNo.Text.Trim();
sqlDataAdapter1.Fill(dataSet21, "TicketDetails");
sqlConnection1.Close();
if (dataSet21.Tables["TicketDetails"].Rows.Count==0)
{
lblMessage.Text="Invalid ticket number.";
return;
}
else
{
string DateOfFlight;
DateOfFlight=dataSet21.Tables["TicketDetails"].Rows[0][2].ToString();
if (Convert.ToDateTime(DateOfFlight) < Convert.ToDateTime(DateTime.Today.ToShortDateString()))
{
lblMessage.Text="The flight has already departed";
return;
}
else
{
sqlConnection1.Open();
sqlDataAdapter1.UpdateCommand.Parameters[0].Value=txtTNo.Text.Trim();
sqlDataAdapter1.UpdateCommand.ExecuteNonQuery();
sqlConnection1.Close();
lblDetails.Text="Ticket confirmed\n(" +
dataSet21.Tables["TicketDetails"].Rows[0][4].ToString() +
"\n" + dataSet21.Tables["TicketDetails"].Rows[0][2].ToString() + ")";
lblDetails.Visible=true;
}
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -