static public int Insert(SqlCommand command,
string flightdate,
string flightcode,
string fltsegment,
string ticketName,
string ticketseat,
string ticketcode,
string ticketstat,
string ticbuydate,
string ticsellagt
)
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = SP_mlb_Insert;
command.Parameters.Clear();
SqlHelper.BuildParameter(command, "flightdate", flightdate);
SqlHelper.BuildParameter(command, "flightcode", flightcode);
SqlHelper.BuildParameter(command, "fltsegment", fltsegment);
SqlHelper.BuildParameter(command, "ticketName", ticketName);
SqlHelper.BuildParameter(command, "ticketseat", ticketseat);
SqlHelper.BuildParameter(command, "ticketcode", ticketcode);
SqlHelper.BuildParameter(command, "ticketstat", ticketstat);
SqlHelper.BuildParameter(command, "ticbuydate", ticbuydate);
SqlHelper.BuildParameter(command, "ticsellagt", ticsellagt);
SqlHelper.BuildParameter(command, "_flight_date", DateConverter.FromFlightDate(flightdate));
SqlHelper.BuildParameter(command, "_ticket_buy_date", DateConverter.FromFlightDate(ticbuydate));
return(command.ExecuteNonQuery());
}
static public int Insert(SqlCommand command,
string flightdate,
string flighttime,
string flightcode,
string fltsegment,
string flrtype,
int flrrcnfrm,
int flrnrcfrm,
int flrnohost,
int flrconnect,
int flrcnl,
int flrcap,
int flrlf)
{
DateTime flightDate = DateConverter.FromFlightDate(flightdate);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = SP_flr_Insert;
command.Parameters.Clear();
SqlHelper.BuildParameter(command, "flightdate", flightdate);
SqlHelper.BuildParameter(command, "flighttime", flighttime);
SqlHelper.BuildParameter(command, "flightcode", flightcode);
SqlHelper.BuildParameter(command, "fltsegment", fltsegment);
SqlHelper.BuildParameter(command, "flrtype", flrtype);
SqlHelper.BuildParameter(command, "flrrcnfrm", flrrcnfrm);
SqlHelper.BuildParameter(command, "flrnrcfrm", flrnrcfrm);
SqlHelper.BuildParameter(command, "flrnohost", flrnohost);
SqlHelper.BuildParameter(command, "flrconnect", flrconnect);
SqlHelper.BuildParameter(command, "flrcnl", flrcnl);
SqlHelper.BuildParameter(command, "flrcap", flrcap);
SqlHelper.BuildParameter(command, "flrlf", flrlf);
SqlHelper.BuildParameter(command, "_flight_date", flightdate);
return(command.ExecuteNonQuery());
}