/// <summary> /// 根据品种ID,字段范围ID,删除交易手续费_范围_值 /// </summary> /// <param name="BreedClassID">品种ID</param> /// <param name="FieldRangeID">字段范围ID</param> /// <returns></returns> public bool DeleteSpotRangeCost(int BreedClassID, int FieldRangeID) { CM_FieldRangeDAL cMFieldRangeDAL = new CM_FieldRangeDAL(); XH_SpotRangeCostDAL xHSpotRangeCostDAL = new XH_SpotRangeCostDAL(); DbConnection Conn = null; Database db = DatabaseFactory.CreateDatabase(); Conn = db.CreateConnection(); if (Conn.State != ConnectionState.Open) { Conn.Open(); } DbTransaction Tran = Conn.BeginTransaction(); try { xHSpotRangeCostDAL.Delete(BreedClassID, FieldRangeID, Tran, db); cMFieldRangeDAL.Delete(FieldRangeID, Tran, db); Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); GTA.VTS.Common.CommonUtility.LogHelper.WriteError(ex.Message, ex); return(false); } finally { if (Conn != null && Conn.State == ConnectionState.Open) { Conn.Close(); } } }
/// <summary> /// 添加现货最小变动价位范围值 /// </summary> /// <param name="xH_MinChangePriceValue">最小变动价位实体</param> /// <param name="cM_FieldRange">字段范围实体</param> /// <returns></returns> public bool AddXHMinChangePriceValue(XH_MinChangePriceValue xH_MinChangePriceValue, CM_FieldRange cM_FieldRange) { CM_FieldRangeDAL cMFieldRangeDAL = new CM_FieldRangeDAL(); XH_MinChangePriceValueDAL xHMinChangePriceValueDAL = new XH_MinChangePriceValueDAL(); DbConnection Conn = null; Database db = DatabaseFactory.CreateDatabase(); Conn = db.CreateConnection(); if (Conn.State != ConnectionState.Open) { Conn.Open(); } DbTransaction Tran = Conn.BeginTransaction(); int fieldRangeID = AppGlobalVariable.INIT_INT; try { fieldRangeID = cMFieldRangeDAL.Add(cM_FieldRange, Tran, db); if (fieldRangeID != AppGlobalVariable.INIT_INT) { xH_MinChangePriceValue.FieldRangeID = fieldRangeID; xHMinChangePriceValueDAL.Add(xH_MinChangePriceValue, Tran, db); Tran.Commit(); } return(true); } catch (Exception ex) { Tran.Rollback(); string errCode = "GL-5320"; 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(); } } }
/// <summary> /// 添加现货交易费用交易手续费 /// </summary> /// <param name="xH_SpotRangeCost">现货交易手续费实体</param> /// <param name="cM_FieldRange">字段范围实体</param> /// <returns></returns> public bool AddXHSpotRangeCost(XH_SpotRangeCost xH_SpotRangeCost, CM_FieldRange cM_FieldRange) { CM_FieldRangeDAL cMFieldRangeDAL = new CM_FieldRangeDAL(); XH_SpotRangeCostDAL xHSpotRangeCostDAL = new XH_SpotRangeCostDAL(); DbConnection Conn = null; Database db = DatabaseFactory.CreateDatabase(); Conn = db.CreateConnection(); if (Conn.State != ConnectionState.Open) { Conn.Open(); } DbTransaction Tran = Conn.BeginTransaction(); int fieldRangeID = AppGlobalVariable.INIT_INT; try { fieldRangeID = cMFieldRangeDAL.Add(cM_FieldRange, Tran, db); if (fieldRangeID != AppGlobalVariable.INIT_INT) { //xH_SpotRangeCost.FieldRangeID = fieldRangeID; xHSpotRangeCostDAL.Add(xH_SpotRangeCost, Tran, db); Tran.Commit(); } return(true); } catch (Exception ex) { Tran.Rollback(); LogHelper.WriteError(ex.Message, ex); return(false); } finally { if (Conn != null && Conn.State == ConnectionState.Open) { Conn.Close(); } } }
/// <summary> /// 根据品种ID,字段范围ID,删除最小变动价位_范围_值 /// </summary> /// <param name="BreedClassID">品种ID</param> /// <param name="FieldRangeID">字段范围ID</param> /// <returns></returns> public bool DeleteMinChangePriceValue(int BreedClassID, int FieldRangeID) { CM_FieldRangeDAL cMFieldRangeDAL = new CM_FieldRangeDAL(); XH_MinChangePriceValueDAL xHMinChangePriceValueDAL = new XH_MinChangePriceValueDAL(); DbConnection Conn = null; Database db = DatabaseFactory.CreateDatabase(); Conn = db.CreateConnection(); if (Conn.State != ConnectionState.Open) { Conn.Open(); } DbTransaction Tran = Conn.BeginTransaction(); try { xHMinChangePriceValueDAL.Delete(BreedClassID, FieldRangeID, Tran, db); cMFieldRangeDAL.Delete(FieldRangeID, Tran, db); Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); string errCode = "GL-5321"; string errMsg = "根据品种ID,字段范围ID,删除最小变动价位_范围_值失败!"; VTException exception = new VTException(errCode, errMsg, ex); LogHelper.WriteError(exception.ToString(), exception.InnerException); return(false); } finally { if (Conn.State == ConnectionState.Open) { Conn.Close(); } } }
/// <summary> /// 更新交易规则_最小变动价位_范围_值 /// </summary> /// <param name="xHMinChangePriceValue">交易规则_最小变动价位_范围_值实体</param> /// <param name="cMFieldRange">字段范围值实体</param> /// <returns></returns> public bool UpdateMinChangePriceValue(CM_FieldRange cMFieldRange, XH_MinChangePriceValue xHMinChangePriceValue) { CM_FieldRangeDAL cMFieldRangeDAL = new CM_FieldRangeDAL(); XH_MinChangePriceValueDAL xHMinChangePriceValueDAL = new XH_MinChangePriceValueDAL(); DbConnection Conn = null; Database db = DatabaseFactory.CreateDatabase(); Conn = db.CreateConnection(); if (Conn.State != ConnectionState.Open) { Conn.Open(); } DbTransaction Tran = Conn.BeginTransaction(); try { cMFieldRangeDAL.Update(cMFieldRange, Tran, db); xHMinChangePriceValueDAL.Update(xHMinChangePriceValue, Tran, db); Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); string errCode = "GL-5322"; 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(); } } }
/// <summary> ///根据品种标识,品种涨跌幅标识,品种有效申报标识,删除现货品种交易规则(规则相关表全部删除) /// </summary> /// <param name="BreedClassID">品种标识</param> ///// <param name="BreedClassHighLowID">品种涨跌幅标识</param> ///// <param name="BreedClassValidID">品种有效申报标识</param> /// <returns></returns> public bool DeleteSpotTradeRulesAboutAll(int BreedClassID) { XH_SpotTradeRulesDAL xHSpotTradeRulesDAL = new XH_SpotTradeRulesDAL(); XH_SpotPositionDAL xHSpotPositionDAL = new XH_SpotPositionDAL(); XH_SpotHighLowValueDAL xHSpotHighLowValueDAL = new XH_SpotHighLowValueDAL(); XH_ValidDeclareValueDAL xHValidDeclareValueDAL = new XH_ValidDeclareValueDAL(); //XH_MinChangePriceValueDAL xHMinChangePriceValueDAL = new XH_MinChangePriceValueDAL(); CM_FieldRangeDAL cMFieldRangeDAL = new CM_FieldRangeDAL(); XH_ValidDeclareTypeDAL xHValidDeclareTypeDAL = new XH_ValidDeclareTypeDAL(); XH_MinVolumeOfBusinessDAL xHMinVolumeOfBusinessDAL = new XH_MinVolumeOfBusinessDAL(); XH_SpotHighLowControlTypeDAL xHSpotHighLowControlTypeDAL = new XH_SpotHighLowControlTypeDAL(); CM_UnitConversionDAL cM_UnitConversionDAL = new CM_UnitConversionDAL(); DbConnection Conn = null; Database db = DatabaseFactory.CreateDatabase(); Conn = db.CreateConnection(); if (Conn.State != ConnectionState.Open) { Conn.Open(); } DbTransaction Tran = Conn.BeginTransaction(); try { int BreedClassHighLowID = AppGlobalVariable.INIT_INT; int BreedClassValidID = AppGlobalVariable.INIT_INT; XH_SpotTradeRules xHSpotTradeRules = new XH_SpotTradeRules(); xHSpotTradeRules = xHSpotTradeRulesDAL.GetModel(BreedClassID); if (xHSpotTradeRules != null) { if (!string.IsNullOrEmpty(xHSpotTradeRules.BreedClassHighLowID.ToString())) { BreedClassHighLowID = Convert.ToInt32(xHSpotTradeRules.BreedClassHighLowID); } if (!string.IsNullOrEmpty(xHSpotTradeRules.BreedClassValidID.ToString())) { BreedClassValidID = Convert.ToInt32(xHSpotTradeRules.BreedClassValidID); } if (BreedClassHighLowID != AppGlobalVariable.INIT_INT) { if (!xHSpotHighLowValueDAL.DeleteSpotHighLowValue(BreedClassHighLowID, Tran, db)) { Tran.Rollback(); return(false); } } if (BreedClassValidID != AppGlobalVariable.INIT_INT) { if (!xHValidDeclareValueDAL.DeleteVDeclareValue(BreedClassValidID, Tran, db)) { Tran.Rollback(); return(false); } } //if (!xHMinChangePriceValueDAL.Delete(BreedClassID, Tran, db)) //{ // Tran.Rollback(); // return false; //} //List<Model.XH_MinChangePriceValue> xhMinCHangePriceV = // xHMinChangePriceValueDAL.GetListArray(string.Format("BreedClassID={0}", BreedClassID), Tran, db); //foreach (Model.XH_MinChangePriceValue FieldRangeID in xhMinCHangePriceV) //{ // if (!cMFieldRangeDAL.Delete(FieldRangeID.FieldRangeID)) // { // Tran.Rollback(); // return false; // } //} if (!xHMinVolumeOfBusinessDAL.DeleteXHMinVolumeOfBusByBreedClassID(BreedClassID, Tran, db)) { Tran.Rollback(); return(false); } //添加删除现货单位换算 List <Model.CM_UnitConversion> cMUnitC = cM_UnitConversionDAL.GetListArray(string.Format("BreedClassID={0}", BreedClassID)); foreach (Model.CM_UnitConversion unitConversion in cMUnitC) { if (!cM_UnitConversionDAL.DeleteUnitConversionByBreedClassID(Convert.ToInt32(unitConversion.BreedClassID), Tran, db)) { Tran.Rollback(); return(false); } } if (!xHSpotTradeRulesDAL.Delete(BreedClassID, Tran, db)) { Tran.Rollback(); return(false); } if (!xHValidDeclareTypeDAL.DeleteValidDeclareType(BreedClassValidID, Tran, db)) { Tran.Rollback(); return(false); } if (!xHSpotHighLowControlTypeDAL.Delete(BreedClassHighLowID, Tran, db)) { Tran.Rollback(); return(false); } } Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); string errCode = "GL-5202"; 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(); } } }