/// <summary> /// 根据品种获取最后交易日实体 /// </summary> /// <param name="breedclass"></param> /// <returns></returns> public QH_LastTradingDay GetLastTradingDayEntity(int breedclass) { QH_FuturesTradeRulesDAL FuturesTradeRulesDAL = new QH_FuturesTradeRulesDAL(); QH_LastTradingDayDAL LastTradingDayDAL = new QH_LastTradingDayDAL(); QH_FuturesTradeRules FuturesTradeRules = FuturesTradeRulesDAL.GetModel(breedclass); QH_LastTradingDay LastTradingDay = LastTradingDayDAL.GetModel((int)FuturesTradeRules.LastTradingDayID); return(LastTradingDay); }
/// <summary> /// 删除最后交易日 /// </summary> /// <param name="LastTradingDayID">最后交易日ID</param> /// <returns></returns> public bool DeleteQHLastTradingDay(int LastTradingDayID) { try { QH_LastTradingDayDAL qHLastTradingDayDAL = new QH_LastTradingDayDAL(); return(qHLastTradingDayDAL.Delete(LastTradingDayID)); } catch (Exception ex) { string errCode = "GL-6052"; string errMsg = "删除最后交易日失败!"; VTException exception = new VTException(errCode, errMsg, ex); LogHelper.WriteError(exception.ToString(), exception.InnerException); return(false); } }
/// <summary> /// 更新最后交易日 /// </summary> /// <param name="model">最后交易日实体</param> /// <returns></returns> public bool UpdateQHLastTradingDay(ManagementCenter.Model.QH_LastTradingDay model) { try { QH_LastTradingDayDAL qHLastTradingDayDAL = new QH_LastTradingDayDAL(); return(qHLastTradingDayDAL.Update(model)); } catch (Exception ex) { string errCode = "GL-6051"; string errMsg = "更新最后交易日失败!"; VTException exception = new VTException(errCode, errMsg, ex); LogHelper.WriteError(exception.ToString(), exception.InnerException); return(false); } }
/// <summary> /// 添加最后交易日 /// </summary> /// <param name="model">最后交易日实体</param> /// <returns></returns> public int AddQHLastTradingDay(ManagementCenter.Model.QH_LastTradingDay model) { try { QH_LastTradingDayDAL qHLastTradingDayDAL = new QH_LastTradingDayDAL(); return(qHLastTradingDayDAL.Add(model)); } catch (Exception ex) { string errCode = "GL-6050"; string errMsg = "添加最后交易日失败!"; VTException exception = new VTException(errCode, errMsg, ex); LogHelper.WriteError(exception.ToString(), exception.InnerException); return(AppGlobalVariable.INIT_INT); } }
/// <summary> /// 根据最后交易日ID,获取最后交易日实体 /// </summary> /// <param name="LastTradingDayID">最后交易日ID</param> /// <returns></returns> public ManagementCenter.Model.QH_LastTradingDay GetQHLastTradingDayModel(int LastTradingDayID) { try { QH_LastTradingDayDAL qHLastTradingDayDAL = new QH_LastTradingDayDAL(); return(qHLastTradingDayDAL.GetModel(LastTradingDayID)); } catch (Exception ex) { string errCode = "GL-6053"; string errMsg = "根据最后交易日ID,获取最后交易日实体失败!"; VTException exception = new VTException(errCode, errMsg, ex); LogHelper.WriteError(exception.ToString(), exception.InnerException); return(null); } }
/// <summary> ///根据品种标识,删除期货品种交易规则(规则相关表全部删除) /// </summary> /// <param name="BreedClassID">品种标识</param> /// <returns></returns> public bool DeleteFuturesTradeRulesAboutAll(int BreedClassID) { QH_FuturesTradeRulesDAL qHFuturesTradeRulesDAL = new QH_FuturesTradeRulesDAL(); QH_AgreementDeliveryMonthDAL qH_AgreementDeliveryMonthDAL = new QH_AgreementDeliveryMonthDAL(); QH_ConsignQuantumDAL qH_ConsignQuantumDAL = new QH_ConsignQuantumDAL(); QH_SingleRequestQuantityDAL qH_SingleRequestQuantityDAL = new QH_SingleRequestQuantityDAL(); QH_LastTradingDayDAL qH_LastTradingDayDAL = new QH_LastTradingDayDAL(); DbConnection Conn = null; Database db = DatabaseFactory.CreateDatabase(); Conn = db.CreateConnection(); if (Conn.State != ConnectionState.Open) { Conn.Open(); } DbTransaction Tran = Conn.BeginTransaction(); try { int ConsignQuantumID = AppGlobalVariable.INIT_INT; int LastTradingDayID = AppGlobalVariable.INIT_INT; QH_FuturesTradeRules qHFuturesTradeRules = new QH_FuturesTradeRules(); qHFuturesTradeRules = qHFuturesTradeRulesDAL.GetModel(BreedClassID); if (qHFuturesTradeRules != null) { if (!string.IsNullOrEmpty(qHFuturesTradeRules.ConsignQuantumID.ToString())) { ConsignQuantumID = Convert.ToInt32(qHFuturesTradeRules.ConsignQuantumID); } if (!string.IsNullOrEmpty(qHFuturesTradeRules.LastTradingDayID.ToString())) { LastTradingDayID = Convert.ToInt32(qHFuturesTradeRules.LastTradingDayID); } if (ConsignQuantumID != AppGlobalVariable.INIT_INT) { if (!qH_SingleRequestQuantityDAL.DeleteSingleRQByConsignQuantumID(ConsignQuantumID, Tran, db)) { Tran.Rollback(); return(false); } } List <Model.QH_AgreementDeliveryMonth> qHAgreementDeliveryM = qH_AgreementDeliveryMonthDAL.GetListArray(string.Format("BreedClassID={0}", BreedClassID), Tran, db); foreach (Model.QH_AgreementDeliveryMonth MonthID in qHAgreementDeliveryM) { if (!qH_AgreementDeliveryMonthDAL.Delete((Int32)MonthID.MonthID, BreedClassID)) //?处理 { Tran.Rollback(); return(false); } } if (!qHFuturesTradeRulesDAL.Delete(BreedClassID, Tran, db)) { Tran.Rollback(); return(false); } if (ConsignQuantumID != AppGlobalVariable.INIT_INT) { if (!qH_ConsignQuantumDAL.Delete(ConsignQuantumID, Tran, db)) { Tran.Rollback(); return(false); } } if (LastTradingDayID != AppGlobalVariable.INIT_INT) { if (!qH_LastTradingDayDAL.Delete(LastTradingDayID, Tran, db)) { Tran.Rollback(); return(false); } } } Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); string errCode = "GL-6004"; string errMsg = " 根据品种标识,删除期货品种交易规则(规则相关表全部删除)失败!"; VTException exception = new VTException(errCode, errMsg, ex); LogHelper.WriteError(exception.ToString(), exception.InnerException); return(false); } finally { if (Conn.State == ConnectionState.Open) { Conn.Close(); } } }