/// <summary>
/// �����ͼ۸�
/// </summary>
public bool AddLowestPrice(FlightLowestPrice lowestPrice)
{
//�����������
OracleCommand oracleCommand = DSCRM.DBA.GetOraCommand();
//����sql�������
StringBuilder sbInsertSql = new StringBuilder();
sbInsertSql.Append(" insert into T_TP_FLIGHT_LOWEST_PRICE( LOWEST_PRICE_ID,DEPARTURE,ARRIVAL,CREATE_DATE,LOWEST_PRICE,DEPARTURE_TIME,ARRIVAL_TIME,AIRLINER,FLIGHT,CABIN) ");
sbInsertSql.Append(" values (:LOWEST_PRICE_ID,:DEPARTURE,:ARRIVAL,:CREATE_DATE,:LOWEST_PRICE,:DEPARTURE_TIME,:ARRIVAL_TIME,:AIRLINER,:FLIGHT,:CABIN) ");
oracleCommand.CommandText = sbInsertSql.ToString();
// װ�ز���
DBUtil.AddParameter(oracleCommand, "LOWEST_PRICE_ID", (Int32)CommonDBFunction.GenerateIdentity("T_TP_FLIGHT_LOWEST_PRICE"));
DBUtil.AddParameter(oracleCommand, "DEPARTURE", lowestPrice.Departure);
DBUtil.AddParameter(oracleCommand, "ARRIVAL", lowestPrice.Arrival);
DBUtil.AddParameter(oracleCommand, "CREATE_DATE", lowestPrice.CreateDate);
DBUtil.AddParameter(oracleCommand, "LOWEST_PRICE", lowestPrice.LowestPrice);
DBUtil.AddParameter(oracleCommand, "DEPARTURE_TIME", lowestPrice.DepartureTime);
DBUtil.AddParameter(oracleCommand, "ARRIVAL_TIME", lowestPrice.ArrivalTime);
DBUtil.AddParameter(oracleCommand, "AIRLINER", lowestPrice.Airliner);
DBUtil.AddParameter(oracleCommand, "FLIGHT", lowestPrice.Flight);
DBUtil.AddParameter(oracleCommand, "CABIN", lowestPrice.Cabin);
int count = 0;
//�����쳣
try
{
count = DSCRM.DBA.ExecuteNonQuery(oracleCommand);
}
catch
{
}
return count > 0;
}
/// <summary>
/// ��ѯ��ͼ�
/// </summary>
/// <returns></returns>
public FlightLowestPrice QueryLowestPrice()
{
string strSql = "select * from t_TP_Flight_Lowest_Price where rownum < 2 order by lowest_price_id desc ";
FlightLowestPrice lowestPrice = new FlightLowestPrice();
//�����������
OracleCommand oracleCommand = DSCRM.DBA.GetOraCommand();
oracleCommand.CommandText = strSql;
//ִ����ر�����
using (OracleDataReader oracleDataReader = oracleCommand.ExecuteReader(CommandBehavior.CloseConnection))
{
//��ȡ���ݳɹ�����true
if (oracleDataReader.Read())
{
lowestPrice.LowestPriceId = Convert.ToInt32(oracleDataReader["LOWEST_PRICE_ID"]);
if (oracleDataReader["DEPARTURE"] != DBNull.Value)
{
lowestPrice.Departure = Convert.ToString(oracleDataReader["DEPARTURE"]);
}
if (oracleDataReader["ARRIVAL"] != DBNull.Value)
{
lowestPrice.Arrival = Convert.ToString(oracleDataReader["ARRIVAL"]);
}
if (oracleDataReader["CREATE_DATE"] != DBNull.Value)
{
lowestPrice.CreateDate = Convert.ToDateTime(oracleDataReader["CREATE_DATE"]);
}
if (oracleDataReader["LOWEST_PRICE"] != DBNull.Value)
{
lowestPrice.LowestPrice = Convert.ToDouble(oracleDataReader["LOWEST_PRICE"]);
}
if (oracleDataReader["DEPARTURE_TIME"] != DBNull.Value)
{
lowestPrice.DepartureTime = Convert.ToDateTime(oracleDataReader["DEPARTURE_TIME"]);
}
if (oracleDataReader["ARRIVAL_TIME"] != DBNull.Value)
{
lowestPrice.ArrivalTime = Convert.ToDateTime(oracleDataReader["ARRIVAL_TIME"]);
}
if (oracleDataReader["AIRLINER"] != DBNull.Value)
{
lowestPrice.Airliner = Convert.ToString(oracleDataReader["AIRLINER"]);
}
if (oracleDataReader["FLIGHT"] != DBNull.Value)
{
lowestPrice.Flight = Convert.ToString(oracleDataReader["FLIGHT"]);
}
if (oracleDataReader["CABIN"] != DBNull.Value)
{
lowestPrice.Cabin = Convert.ToString(oracleDataReader["CABIN"]);
}
}
}
return lowestPrice;
}
//public RedefineWebBrowserDocumentCompletedEventArgs(FlightLowestPrice lowestPrice)
//{
// this.RedefineWebBrowserDocumentCompletedEventArgs(lowestPrice, base.Url);
//}
//public RedefineWebBrowserDocumentCompletedEventArgs()
//{
//}
public RedefineWebBrowserDocumentCompletedEventArgs(FlightLowestPrice lowestPrice, Uri url)
: base(url)
{
this.lowestPrice = lowestPrice;
}