//public
#region 添加价格比较数据
/// <summary>
/// 添加价格比较数据
/// </summary>
/// <param name="priceCompare"></param>
/// <returns></returns>
public bool AddPriceCompare(FlightPriceCompare priceCompare)
{
//创建命令对象
OracleCommand oracleCommand = DSCRM.DBA.GetOraCommand();
//构建sql插入语句
StringBuilder sbInsertSql = new StringBuilder();
sbInsertSql.Append(" insert into T_TP_PRICE_COMPARE( COMPAREID,OTHERPRICEID,LOWEST_PRICE_ID,AUTORESULT,HANDRESULT,MEMO) ");
sbInsertSql.Append(" values (:COMPAREID,:OTHERPRICEID,:LOWEST_PRICE_ID,:AUTORESULT,:HANDRESULT,:MEMO) ");
oracleCommand.CommandText = sbInsertSql.ToString();
// 装载参数
DBUtil.AddParameter(oracleCommand, "COMPAREID", (Int32)CommonDBFunction.GenerateIdentity("T_TP_PRICE_COMPARE"));
DBUtil.AddParameter(oracleCommand, "OTHERPRICEID", priceCompare.Otherpriceid);
DBUtil.AddParameter(oracleCommand, "LOWEST_PRICE_ID", priceCompare.LowestPriceId);
DBUtil.AddParameter(oracleCommand, "AUTORESULT", priceCompare.Autoresult);
DBUtil.AddParameter(oracleCommand, "HANDRESULT", priceCompare.Handresult);
DBUtil.AddParameter(oracleCommand, "MEMO", priceCompare.Memo);
int count = 0;
//捕获异常
try
{
count = DSCRM.DBA.ExecuteNonQuery(oracleCommand);
}
catch
{
}
return(count > 0);
}
/// <summary>
/// 添加其它价格并返回主键ID
/// </summary>
public int AddOtherPrice(FlightOtherPrice otherPrice)
{
//创建命令对象
OracleCommand oracleCommand = DSCRM.DBA.GetOraCommand();
//构建sql插入语句
StringBuilder sbInsertSql = new StringBuilder();
sbInsertSql.Append(" insert into T_TP_OTHER_PRICE( OTHERPRICEID,SOURCETYPE,DEPARTURE,ARRIVAL,CREATE_DATE,LOWEST_PRICE,AIRLINER,FLIGHT,CABIN) ");
sbInsertSql.Append(" values (:OTHERPRICEID,:SOURCETYPE,:DEPARTURE,:ARRIVAL,:CREATE_DATE,:LOWEST_PRICE,:AIRLINER,:FLIGHT,:CABIN) ");
oracleCommand.CommandText = sbInsertSql.ToString();
int recordIndex = (Int32)CommonDBFunction.GenerateIdentity("T_TP_OTHER_PRICE");
// 装载参数
DBUtil.AddParameter(oracleCommand, "OTHERPRICEID", recordIndex);
DBUtil.AddParameter(oracleCommand, "SOURCETYPE", otherPrice.Sourcetype);
DBUtil.AddParameter(oracleCommand, "DEPARTURE", otherPrice.Departure);
DBUtil.AddParameter(oracleCommand, "ARRIVAL", otherPrice.Arrival);
DBUtil.AddParameter(oracleCommand, "CREATE_DATE", otherPrice.CreateDate);
DBUtil.AddParameter(oracleCommand, "LOWEST_PRICE", otherPrice.LowestPrice);
DBUtil.AddParameter(oracleCommand, "AIRLINER", otherPrice.Airliner);
DBUtil.AddParameter(oracleCommand, "FLIGHT", otherPrice.Flight);
DBUtil.AddParameter(oracleCommand, "CABIN", otherPrice.Cabin);
//捕获异常
try
{
DSCRM.DBA.ExecuteNonQuery(oracleCommand);
return(recordIndex);
}
catch
{
return(0);
}
}
/// <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);
}
//更新房态基本信息表
public static void UpdateHotelStatus(EnumDef.EHRoomStatusType tnUpdateStyle, int tnUpdateNum, DateTime tsUpdateDate, String tsHBaseInfoId, int tnEmployeeID)
{
String lsSQL = "SELECT * FROM HOTELSTATUS WHERE HOTELINFOID = " + tsHBaseInfoId.Trim() + " AND USEDATE = to_date('" + tsUpdateDate + "','yyyy-mm-dd hh24:mi:ss')";
int lnRoomBuyNum = 0;
int lnRoomHold = 0;
DataSet ds = new DataSet();
String lsError = "";
if (DBA.SelectSQL("", lsSQL, ref ds, ref lsError) > 0)
{
switch (tnUpdateStyle)
{
case EnumDef.EHRoomStatusType.买房:
if (ds.Tables[0].Rows.Count > 0)
{
lnRoomBuyNum += IntUtil.SafeCInt(ds.Tables[0].Rows[0]["BUYHOUSENUM"]) + tnUpdateNum;
}
break;
case EnumDef.EHRoomStatusType.占房:
break;
case EnumDef.EHRoomStatusType.预留房:
if (ds.Tables[0].Rows.Count > 0)
{
lnRoomHold += IntUtil.SafeCInt(ds.Tables[0].Rows[0]["OBLIGATEHOUSENUM"]) + tnUpdateNum;
}
break;
case EnumDef.EHRoomStatusType.满房:
break;
}
String lsSQLUpdate = @"update HOTELSTATUS set BuyHouseNum = :BuyHouseNum,OBLIGATEHOUSENUM = :OBLIGATEHOUSENUM
where HOUSESTATETYPEID = :HOUSESTATETYPEID ";
OracleConnection loOraConn = DBA.GetOraConnection("CRMDB");
try
{
OracleCommand loOraComm = new OracleCommand(lsSQLUpdate, loOraConn);
DBUtil.AddParameter(loOraComm, "BuyHouseNum", lnRoomBuyNum);
DBUtil.AddParameter(loOraComm, "OBLIGATEHOUSENUM", lnRoomHold);
DBUtil.AddParameter(loOraComm, "HOUSESTATETYPEID", IntUtil.SafeCInt(ds.Tables[0].Rows[0]["HOUSESTATETYPEID"]));
loOraComm.ExecuteNonQuery();
}
finally
{
DBA.CloseOraConnection(loOraConn);
}
}
else
{
switch (tnUpdateStyle)
{
case EnumDef.EHRoomStatusType.买房:
lnRoomBuyNum += tnUpdateNum;
break;
case EnumDef.EHRoomStatusType.占房:
break;
case EnumDef.EHRoomStatusType.预留房:
lnRoomHold += tnUpdateNum;
break;
case EnumDef.EHRoomStatusType.满房:
break;
}
String lsSQLInsert = @"insert into HOTELSTATUS (HOUSESTATETYPEID,HOTELINFOID,USEDATE,BUYHOUSENUM,OBLIGATEHOUSENUM,OPERATETIME,EmployeeInfoID)
Values(:HOUSESTATETYPEID,:HOTELINFOID,:USEDATE,:BUYHOUSENUM,:OBLIGATEHOUSENUM,:OPERATETIME,:EmployeeInfoID)";
OracleConnection loOraConn = DBA.GetOraConnection("CRMDB");
try
{
OracleCommand loOraComm = new OracleCommand(lsSQLInsert, loOraConn);
DBUtil.AddParameter(loOraComm, "HOUSESTATETYPEID", IntUtil.SafeCInt(CommonDBFunction.GenerateIdentity("HOTELSTATUS")));
DBUtil.AddParameter(loOraComm, "HOTELINFOID", IntUtil.SafeCInt(tsHBaseInfoId));
DBUtil.AddParameter(loOraComm, "USEDATE", Convert.ToDateTime(tsUpdateDate));
DBUtil.AddParameter(loOraComm, "BUYHOUSENUM", lnRoomBuyNum);
DBUtil.AddParameter(loOraComm, "OBLIGATEHOUSENUM", lnRoomHold);
DBUtil.AddParameter(loOraComm, "OPERATETIME", DateUitl.GetDateTime());
DBUtil.AddParameter(loOraComm, "EmployeeInfoID", tnEmployeeID);
loOraComm.ExecuteNonQuery();
}
finally
{
DBA.CloseOraConnection(loOraConn);
}
}
}
