/// <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> /// 根据品种ID获取现货交易费用交易手续费_范围_值 /// </summary> /// <param name="BreedClassID">品种ID</param> /// <returns></returns> public DataSet GetXHSpotRangeCostByBreedClassID(int BreedClassID) { try { XH_SpotRangeCostDAL xHSpotRangeCostDAL = new XH_SpotRangeCostDAL(); return(xHSpotRangeCostDAL.GetXHSpotRangeCostByBreedClassID(BreedClassID)); } catch (Exception ex) { GTA.VTS.Common.CommonUtility.LogHelper.WriteError(ex.Message, ex); return(null); } }
/// <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(); } } }