C# IDBAccess类代码示例

 internal string GenerateExpression(Type type, out List<DbParameter> parameters, IDBAccess dbAccess)
 {
     this.Init(type, dbAccess);
     parameters = new List<DbParameter>();
     int i = 0;
     return " AND " + this.GenerateSQL(ref parameters, ref i);
 }

        /// <summary>
        /// 初始化ModifyCommandCreator，dbAccess不能为空
        /// </summary>
        /// <exception cref="RException(DatabaseErrorCode.ConnectDbServerError - 0x00010001)">
        /// 传入的dbAccess为空，引发此异常
        /// </exception>
        /// <param name="dbAccess">数据库访问接口</param>
        public SelectCommandCreator(IDBAccess dbAccess)
        {
            this.DbAccess = dbAccess;

            FilterProterties = new string[0];
            OrderBy = new SortInfo[0];
        }

 public VendorDao(string connectionStr)
 {
     _dbAccess = DBFactory.getDBAccess(DBType.MySql, connectionStr);
     connStr = connectionStr;
     mysqlHelp = new Common.MySqlHelper(connectionStr);
     _serialDao = new SerialDao(connectionStr);
 }

 public CallerDao(string connectionString)
 {
     _access = DBFactory.getDBAccess(DBType.MySql, connectionString);
     _intCurrentTime = (int)BLL.gigade.Common.CommonFunction.GetPHPTime();
     //_strIP = BLL.gigade.Common.CommonFunction.GetClientIP();
     _strIP = CommonFunction.GetIP4Address(CommonFunction.GetClientIP());
 }

 public ScheduleItemDao(string connectionString)
 {
     //connectionString = "Server=127.0.0.1;database=test;user=root;pwd=198929;charset='utf8'";
     //connectionString = "Server=192.168.18.166;database=test;user=root;pwd=198929;charset='utf8'";
     _access = DBFactory.getDBAccess(DBType.MySql, connectionString);
     conStr = connectionString;
 }

        public DeliverMasterMgr(string connectionString)
        {
            connection = connectionString;
            _ideliver = new DeliverMasterDao(connectionString);
            _access = DBFactory.getDBAccess(DBType.MySql, connectionString);

        }

        public ProductTempDao(string connectStr)
        {
            _dbAccess = DBFactory.getDBAccess(DBType.MySql, connectStr);

            this.strConn = connectStr;
            reProductDao = new RecommendedProductAttributeDao(connectStr);
        }

 public VipUserMgr(string connStr)
 {
     _vipUserDao = new VipUserDao(connStr);
     _usersDao = new UsersDao(connStr);
     _dbAccess = DBFactory.getDBAccess(DBType.MySql, connStr);
     conn = connStr;
 }

 public PromotionBannerMgr(string connectionStr)
 {
     _promotionBannerDao = new PromotionBannerDao(connectionStr);
     _promotionBannerRelationDao = new PromotionBannerRelationDao(connectionStr);
     _mysqlDao = new MySqlDao(connectionStr);
     _vendorBrandDao = new VendorBrandDao(connectionStr);
     _accessMySql = DBFactory.getDBAccess(DBType.MySql, connectionStr);
 }

        /// <summary>
        /// 方法
        /// </summary>
        /// <param name="connectionString">連接字符串</param>
        /// <param name="particularsSrcType">particularsSrcType = 1 表示使用 db數據庫  particularsSrcType = 2 表示 使用 xml 資料庫</param>
        public ParticularsSrcDao(string connectionString, int particularsSrcType)
        {
            this.connectionString = connectionString;
            this.particularsSrcType = particularsSrcType;

            if (particularsSrcType == 1)
            {
                _dbAccess = DBFactory.getDBAccess(DBType.MySql, connectionString);
            }
        }

 public ProductItemMapExcelMgr(string connectionString)
 {
     _productItemMapMgr = new ProductItemMapMgr(connectionString);
     _productItemMapDao = new ProductItemMapDao(connectionString);
     _productItemMgr = new ProductItemMgr(connectionString);
     _productItemDao = new ProductItemDao(connectionString);
     _callerMgr = new CallerMgr(connectionString);
     _priceMasterMgr = new PriceMasterMgr(connectionString);
     _access = DBAccess.DBFactory.getDBAccess(DBType.MySql, connectionString);
 }

        public PromoPairDao(string connectionstring)
        {
            _access = DBFactory.getDBAccess(DBType.MySql, connectionstring);
            this.connStr = connectionstring;
            _proCateDao = new ProductCategoryDao(connectionstring);
            _prodCategSet = new ProductCategorySetDao(connectionstring);
            _prodPromoDao = new ProdPromoDao(connectionstring);
            _promoAllDao = new PromoAllDao(connectionstring);
            _serialDao = new SerialDao(connectionstring);

        }

 public EdmContentMgr(string connectionString)
 {
     _IEdmContentDao = new EdmContentDao(connectionString);
     _edmContentDao = new EdmContentDao(connectionString);
     _edmEmailDao = new EdmEmailDao(connectionString);
     _vipUserDao = new VipUserDao(connectionString);
     _usersDao = new UsersDao(connectionString);
     _accessMySql = DBFactory.getDBAccess(DBType.MySql, connectionString);
     _edmGroupEmailDao = new EdmGroupEmailDao(connectionString);
     conn = connectionString;
 }

 public ProductSearchDao(string connectionstring, string sphinxHost, string sphinxPort)
 {
     _accessMySql = DBFactory.getDBAccess(DBType.MySql, connectionstring);
     _sphinxHost = GetParameterCode(sphinxHost);
     _sphinxPort = 0;
      if (!string.IsNullOrEmpty(GetParameterCode(sphinxPort)))
      {
          _sphinxPort = Convert.ToInt32(GetParameterCode(sphinxPort));
      }
     
 }

 /// <summary>
 /// 有參構造函數
 /// </summary>
 /// <param name="connectionstring">數據庫連接字符串</param>
 public PromotionsAmountFareDao(string connectionstring)
 {
     _access = DBFactory.getDBAccess(DBType.MySql, connectionstring);
     this.connStr = connectionstring;
     _cateDao = new ProductCategoryDao(connectionstring);
     _prodCateSetDao = new ProductCategorySetDao(connectionstring);
     _prodPromoDao = new ProdPromoDao(connectionstring);
     _promoAllDao = new PromoAllDao(connectionstring);
     _promAmountReduceDao = new PromotionsAmountReduceDao(connectionstring);
     _usconDao = new UserConditionDao(connectionstring);
     _serialDao = new SerialDao(connectionstring);
 }