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