Exemple #1
0
        /// <summary>
        /// 带事务的Update
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="trans">The trans.</param>
        /// <returns></returns>
        /// <remarks>2016/5/30 13:18:06</remarks>
        public bool Update(AllUaplatformEntity entity, DbTransaction trans)
        {
            var       database       = new SqlDatabase(this.ConnectionString);
            DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_AllUaplatform_Update");

            database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, entity.Idx);
            database.AddInParameter(commandWrapper, "@FactoryCode", DbType.AnsiString, entity.FactoryCode);
            database.AddInParameter(commandWrapper, "@PlatformCode", DbType.AnsiString, entity.PlatformCode);
            database.AddInParameter(commandWrapper, "@ExchangeRate", DbType.Int32, entity.ExchangeRate);
            database.AddInParameter(commandWrapper, "@CashRate", DbType.Int32, entity.CashRate);
            database.AddInParameter(commandWrapper, "@ChargeUrl", DbType.AnsiString, entity.ChargeUrl);
            database.AddInParameter(commandWrapper, "@PlatformUrl", DbType.AnsiString, entity.PlatformUrl);
            database.AddInParameter(commandWrapper, "@LoginKey", DbType.AnsiString, entity.LoginKey);
            database.AddInParameter(commandWrapper, "@ChargeKey", DbType.AnsiString, entity.ChargeKey);
            database.AddInParameter(commandWrapper, "@ClientVersion", DbType.AnsiString, entity.ClientVersion);
            database.AddInParameter(commandWrapper, "@UserActionUrl", DbType.AnsiString, entity.UserActionUrl);


            int results = 0;

            if (trans != null)
            {
                results = database.ExecuteNonQuery(commandWrapper, trans);
            }
            else
            {
                results = database.ExecuteNonQuery(commandWrapper);
            }


            return(Convert.ToBoolean(results));
        }
Exemple #2
0
        /// <summary>
        /// 将IDataReader的当前记录读取到AllUaplatformEntity 对象
        /// </summary>
        /// <param name="reader"></param>
        /// <returns></returns>
        public AllUaplatformEntity LoadSingleRow(IDataReader reader)
        {
            var obj = new AllUaplatformEntity();

            obj.Idx           = (System.Int32)reader["Idx"];
            obj.FactoryCode   = (System.String)reader["FactoryCode"];
            obj.PlatformCode  = (System.String)reader["PlatformCode"];
            obj.ExchangeRate  = (System.Int32)reader["ExchangeRate"];
            obj.CashRate      = (System.Int32)reader["CashRate"];
            obj.ChargeUrl     = (System.String)reader["ChargeUrl"];
            obj.PlatformUrl   = (System.String)reader["PlatformUrl"];
            obj.LoginKey      = (System.String)reader["LoginKey"];
            obj.ChargeKey     = (System.String)reader["ChargeKey"];
            obj.ClientVersion = (System.String)reader["ClientVersion"];
            obj.UserActionUrl = (System.String)reader["UserActionUrl"];

            return(obj);
        }
Exemple #3
0
        /// <summary>
        /// GetById
        /// </summary>
        /// <param name="idx">idx</param>
        /// <returns>AllUaplatformEntity</returns>
        /// <remarks>2016/5/30 13:18:06</remarks>
        public AllUaplatformEntity GetById(System.Int32 idx)
        {
            var database = new SqlDatabase(this.ConnectionString);

            DbCommand commandWrapper = database.GetStoredProcCommand("P_AllUaplatform_GetById");

            database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, idx);


            AllUaplatformEntity obj = null;

            using (IDataReader reader = database.ExecuteReader(commandWrapper))
            {
                if (reader.Read())
                {
                    obj = LoadSingleRow(reader);
                }
            }
            return(obj);
        }
Exemple #4
0
        /// <summary>
        /// GetById
        /// </summary>
        /// <param name="idx">idx</param>
        /// <returns>AllUaplatformEntity</returns>
        /// <remarks>2014/7/9 21:22:33</remarks>
        public AllUaplatformEntity GetByCode(string platformCode)
        {
            var database = new SqlDatabase(Properties.Settings.Default.NB_ConfigConnectionString);

            DbCommand commandWrapper = database.GetStoredProcCommand("C_AllPlatform_GetByCode");

            database.AddInParameter(commandWrapper, "@PlatformCode", DbType.AnsiString, platformCode);


            AllUaplatformEntity obj = null;

            using (IDataReader reader = database.ExecuteReader(commandWrapper))
            {
                if (reader.Read())
                {
                    obj = LoadSingleRow(reader);
                }
            }
            return(obj);
        }
Exemple #5
0
 /// <summary>
 /// Update
 /// </summary>
 /// <param name="entity"></param>
 /// <returns></returns>
 /// <remarks>2016/5/30 13:18:06</remarks>
 public bool Update(AllUaplatformEntity entity)
 {
     return(Update(entity, null));
 }
Exemple #6
0
 /// <summary>
 /// Insert
 /// </summary>
 /// <param name="entity"></param>
 /// <param name="trans">The trans.</param>
 /// <returns></returns>
 /// <remarks>2016/5/30 13:18:06</remarks>
 public bool Insert(AllUaplatformEntity entity)
 {
     return(Insert(entity, null));
 }
        public static bool Update(AllUaplatformEntity allUaplatformEntity, DbTransaction trans = null, string zoneId = "")
        {
            var provider = new AllUaplatformProvider(zoneId);

            return(provider.Update(allUaplatformEntity, trans));
        }
Exemple #8
0
        void Init()
        {
            try
            {
                _errorPage = "/Error.aspx";
                _factory   = ConfigurationManager.AppSettings["FactoryName"].ToLower();
                JumpScript = ConfigurationManager.AppSettings["JumpScript"];
                ZoneName   = ConfigurationManager.AppSettings["ZoneName"].ToLower();
                var ualog = ConfigurationManager.AppSettings["OpenUALog"];
                _zoneDic     = new Dictionary <string, AllZoneinfoEntity>();
                _zoneNameDic = new Dictionary <string, AllZoneinfoEntity>();
                if (!string.IsNullOrEmpty(ualog) && ualog == "1")
                {
                    OpenUALog = true;
                }
                var timeout         = ConfigurationManager.AppSettings["UATimeOut"];
                var uARequestRecord = ConfigurationManager.AppSettings["UARequestRecord"];
                if (!string.IsNullOrEmpty(uARequestRecord) && uARequestRecord == "1")
                {
                    _uARequestRecord = true;
                }

                var zoneInfoList = AllZoneinfoMgr.GetByPlatform(FactoryName);
                foreach (var item in zoneInfoList)
                {
                    if (!_zoneDic.ContainsKey(item.ZoneName))
                    {
                        _zoneDic.Add(item.ZoneName, null);
                    }
                    _zoneDic[item.ZoneName] = item;
                    if (!_zoneNameDic.ContainsKey(item.PlatformCode + item.PlatformZoneName))
                    {
                        _zoneNameDic.Add(item.PlatformCode + item.PlatformZoneName, null);
                    }
                    _zoneNameDic[item.PlatformCode + item.PlatformZoneName] = item;
                }

                string className = _factory.ToLower();
                if (!string.IsNullOrEmpty(_factory))
                {
                    if (_factory.Contains("gov_"))
                    {
                        className = "gov";
                    }
                }
                if (!string.IsNullOrEmpty(_factory))
                {
                    if (_factory.Contains("h5_a8"))
                    {
                        className = "A8";
                    }
                }
                if (!string.IsNullOrEmpty(_factory))
                {
                    if (_factory.Contains("txh5_a8"))
                    {
                        className = "wbTx";
                    }
                }
                if (!string.IsNullOrEmpty(_factory))
                {
                    if (_factory.Contains("h5_wb"))
                    {
                        className = "wbTx";
                    }
                }
                if (!string.IsNullOrEmpty(_factory))
                {
                    if (_factory.Contains("h5_egret"))
                    {
                        className = "egret";
                    }
                }
                if (!string.IsNullOrEmpty(_factory))
                {
                    if (_factory.Contains("h5_bear"))
                    {
                        className = "bear";
                    }
                }
                if (!string.IsNullOrEmpty(_factory))
                {
                    if (_factory.Contains("h5_qunhei"))
                    {
                        className = "qunhei";
                    }
                }
                if (!string.IsNullOrEmpty(timeout))
                {
                    var t = ConvertHelper.ConvertToInt(timeout);
                    if (t > 0)
                    {
                        _timeout = t;
                    }
                }
                _adapter = UAAdapter.GetInstance(className);

                var platforms = GetPlatformList(_factory);
                if (platforms == null || platforms.Count <= 0)
                {
                    SystemlogMgr.Error("UaFactory create", "UaFactory config is null,factory:" + _factory);
                }
                else
                {
                    _platformDic     = platforms.ToDictionary(d => d.PlatformCode, d => d);
                    _platformUrl     = platforms[0].PlatformUrl;
                    _defaultPlatform = platforms[0];
                }
                if (IsTx)
                {
                    var appId = ConfigAppsettingMgr.GetById(20004);
                    if (appId != null)
                    {
                        _txAppId = ConvertHelper.ConvertToInt(appId.Value);
                    }
                    var appKey = ConfigAppsettingMgr.GetById(20005);
                    if (appKey != null)
                    {
                        _txAppKey = appKey.Value;
                    }
                }
            }
            catch (Exception ex)
            {
                SystemlogMgr.Error("UaFactory create", ex);
                throw ex;
            }
        }