//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); } } }