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