/// <summary> /// 获取所有股指期货持仓限制和品种_股指期货_保证金数据 /// </summary> /// <param name="BreedClassName">品种名称</param> /// <param name="pageNo">当前页</param> /// <param name="pageSize">显示记录数</param> /// <param name="rowCount">总行数</param> /// <returns></returns> public DataSet GetAllQHSIFPositionAndQHSIFBail(string BreedClassName, int pageNo, int pageSize, out int rowCount) { try { QH_SIFPositionDAL qHSIFPositionDAL = new QH_SIFPositionDAL(); return(qHSIFPositionDAL.GetAllQHSIFPositionAndQHSIFBail(BreedClassName, pageNo, pageSize, out rowCount)); } catch (Exception ex) { rowCount = AppGlobalVariable.INIT_INT; string errCode = "GL-6663"; string errMsg = "获取所有股指期货持仓限制和品种_股指期货_保证金数据失败!"; VTException exception = new VTException(errCode, errMsg, ex); LogHelper.WriteError(exception.ToString(), exception.InnerException); return(null); } }
/// <summary> /// 增加一条数据 /// </summary> //public void Add(ManagementCenter.Model.QH_SIFPosition model) //{ // qH_SIFPositionDAL.Add(model); //} #region 添加股指期货持仓限制和品种_股指期货_保证金数据 /// <summary> /// 添加股指期货持仓限制和品种_股指期货_保证金数据 /// </summary> /// <param name="qHSIFPosition">股指期货持仓限制实体</param> /// <param name="qHSIFBail">品种_股指期货_保证金实体</param> /// <returns></returns> public bool AddQHSIFPositionAndQHSIFBail(ManagementCenter.Model.QH_SIFPosition qHSIFPosition, ManagementCenter.Model.QH_SIFBail qHSIFBail) { QH_SIFBailDAL qHSIFBailDAL = new QH_SIFBailDAL(); QH_SIFPositionDAL qHSIFPositionDAL = new QH_SIFPositionDAL(); DbConnection Conn = null; Database db = DatabaseFactory.CreateDatabase(); Conn = db.CreateConnection(); if (Conn.State != ConnectionState.Open) { Conn.Open(); } DbTransaction Tran = Conn.BeginTransaction(); try { qHSIFPositionDAL.Add(qHSIFPosition, Tran, db); qHSIFBailDAL.Add(qHSIFBail, Tran, db); Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); string errCode = "GL-6660"; 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(); } } }