📄 createres.aspx.cs
字号:
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Destination", System.Data.SqlDbType.VarChar, 16, "Destination"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Deptime", System.Data.SqlDbType.DateTime, 8, "Deptime"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Arrtime", System.Data.SqlDbType.DateTime, 8, "Arrtime"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@AircraftType", System.Data.SqlDbType.VarChar, 10, "AircraftType"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SeatsExec", System.Data.SqlDbType.Int, 4, "SeatsExec"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SeatsBn", System.Data.SqlDbType.Int, 4, "SeatsBn"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@FareExec", System.Data.SqlDbType.Int, 4, "FareExec"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@FareBn", System.Data.SqlDbType.Int, 4, "FareBn"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@LaunchDate", System.Data.SqlDbType.DateTime, 8, "LaunchDate"));
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE dtFltDetails SET FltNo = @FltNo, Origin = @Origin, Destination = @Destination, Deptime = @Deptime, Arrtime = @Arrtime, AircraftType = @AircraftType, SeatsExec = @SeatsExec, SeatsBn = @SeatsBn, FareExec = @FareExec, FareBn = @FareBn, LaunchDate = @LaunchDate 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); SELECT FltNo, Origin, Destination, Deptime, Arrtime, AircraftType, SeatsExec, SeatsBn, FareExec, FareBn, LaunchDate FROM dtFltDetails WHERE (FltNo = @FltNo)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
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("@Origin", System.Data.SqlDbType.VarChar, 16, "Origin"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Destination", System.Data.SqlDbType.VarChar, 16, "Destination"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Deptime", System.Data.SqlDbType.DateTime, 8, "Deptime"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Arrtime", System.Data.SqlDbType.DateTime, 8, "Arrtime"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@AircraftType", System.Data.SqlDbType.VarChar, 10, "AircraftType"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@SeatsExec", System.Data.SqlDbType.Int, 4, "SeatsExec"));
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));
//
// 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;
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT FltNo, StatusDate, StatusClass, Status FROM dtFltStatus WHERE (FltNo = @fl" +
"tno) AND (StatusDate = @statusdate) AND (StatusClass = @statusclass)";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@fltno", System.Data.SqlDbType.VarChar, 10, "FltNo"));
this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@statusdate", System.Data.SqlDbType.DateTime, 8, "StatusDate"));
this.sqlSelectCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@statusclass", System.Data.SqlDbType.VarChar, 10, "StatusClass"));
//
// sqlInsertCommand2
//
this.sqlInsertCommand2.CommandText = "INSERT INTO dtFltStatus(FltNo, StatusDate, StatusClass, Status) VALUES (@FltNo, @" +
"StatusDate, @StatusClass, @Status); SELECT FltNo, StatusDate, StatusClass, Statu" +
"s FROM dtFltStatus";
this.sqlInsertCommand2.Connection = this.sqlConnection1;
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@FltNo", System.Data.SqlDbType.VarChar, 10, "FltNo"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@StatusDate", System.Data.SqlDbType.DateTime, 8, "StatusDate"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@StatusClass", System.Data.SqlDbType.VarChar, 10, "StatusClass"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Status", System.Data.SqlDbType.Int, 4, "Status"));
//
// sqlDataAdapter2
//
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", "dtFltStatus", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("FltNo", "FltNo"),
new System.Data.Common.DataColumnMapping("StatusDate", "StatusDate"),
new System.Data.Common.DataColumnMapping("StatusClass", "StatusClass"),
new System.Data.Common.DataColumnMapping("Status", "Status")})});
this.sqlDataAdapter2.UpdateCommand = this.sqlCommand1;
//
// sqlCommand1
//
this.sqlCommand1.CommandText = "UPDATE dtFltStatus SET Status = Status - 1 WHERE (FltNo = @fltno) AND (StatusDate" +
" = @statusdate) AND (StatusClass = @statusclass)";
this.sqlCommand1.Connection = this.sqlConnection1;
this.sqlCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@fltno", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "FltNo", System.Data.DataRowVersion.Original, null));
this.sqlCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@statusdate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StatusDate", System.Data.DataRowVersion.Original, null));
this.sqlCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@statusclass", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "StatusClass", System.Data.DataRowVersion.Original, null));
//
// sqlSelectCommand3
//
this.sqlSelectCommand3.CommandText = "SELECT TicketNo FROM dtReservations";
this.sqlSelectCommand3.Connection = this.sqlConnection1;
//
// sqlInsertCommand3
//
this.sqlInsertCommand3.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.sqlInsertCommand3.Connection = this.sqlConnection1;
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@TicketNo", System.Data.SqlDbType.VarChar, 10, "TicketNo"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@FltNo", System.Data.SqlDbType.VarChar, 10, "FltNo"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@DateOfJourney", System.Data.SqlDbType.DateTime, 8, "DateOfJourney"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClassOfRes", System.Data.SqlDbType.VarChar, 4, "ClassOfRes"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Name", System.Data.SqlDbType.VarChar, 20, "Name"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EMail", System.Data.SqlDbType.VarChar, 50, "EMail"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Fare", System.Data.SqlDbType.Int, 4, "Fare"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Status", System.Data.SqlDbType.Int, 4, "Status"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReservedBy", System.Data.SqlDbType.VarChar, 15, "ReservedBy"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@DateOfRes", System.Data.SqlDbType.DateTime, 8, "DateOfRes"));
this.sqlInsertCommand3.Parameters.Add(new System.Data.SqlClient.SqlParameter("@TicketConfirmed", System.Data.SqlDbType.Bit, 1, "TicketConfirmed"));
//
// sqlUpdateCommand2
//
this.sqlUpdateCommand2.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.sqlUpdateCommand2.Connection = this.sqlConnection1;
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@TicketNo", System.Data.SqlDbType.VarChar, 10, "TicketNo"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@FltNo", System.Data.SqlDbType.VarChar, 10, "FltNo"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@DateOfJourney", System.Data.SqlDbType.DateTime, 8, "DateOfJourney"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClassOfRes", System.Data.SqlDbType.VarChar, 4, "ClassOfRes"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Name", System.Data.SqlDbType.VarChar, 20, "Name"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@EMail", System.Data.SqlDbType.VarChar, 50, "EMail"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Fare", System.Data.SqlDbType.Int, 4, "Fare"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Status", System.Data.SqlDbType.Int, 4, "Status"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ReservedBy", System.Data.SqlDbType.VarChar, 15, "ReservedBy"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@DateOfRes", System.Data.SqlDbType.DateTime, 8, "DateOfRes"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@TicketConfirmed", System.Data.SqlDbType.Bit, 1, "TicketConfirmed"));
this.sqlUpdateCommand2.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.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClassOfRes", System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClassOfRes", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.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.sqlUpdateCommand2.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.sqlUpdateCommand2.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.sqlUpdateCommand2.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.sqlUpdateCommand2.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.sqlUpdateCommand2.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.sqlUpdateCommand2.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.sqlUpdateCommand2.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.sqlUpdateCommand2.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));
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -