/// <summary> /// 将IDataReader的当前记录读取到AllZoneinfoEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public AllZoneinfoEntity LoadSingleRow(IDataReader reader) { var obj = new AllZoneinfoEntity(); obj.Idx = (System.Int32)reader["Idx"]; obj.PlatformCode = (System.String)reader["PlatformCode"]; obj.ZoneName = (System.String)reader["ZoneName"]; obj.PlatformZoneName = (System.String)reader["PlatformZoneName"]; obj.Name = (System.String)reader["Name"]; obj.ApiUrl = (System.String)reader["ApiUrl"]; obj.ChargeUrl = (System.String)reader["ChargeUrl"]; obj.WebServerUrl = (System.String)reader["WebServerUrl"]; obj.IsDebug = (System.Int32)reader["IsDebug"]; obj.IsOpenCharge = (System.Int32)reader["IsOpenCharge"]; obj.ChatIp = (System.String)reader["ChatIp"]; obj.ChatPort = (System.Int32)reader["ChatPort"]; obj.ClientVersion = (System.String)reader["ClientVersion"]; obj.Cdn = (System.String)reader["Cdn"]; obj.CrossName = (System.String)reader["CrossName"]; obj.OpenIndulge = (System.Boolean)reader["OpenIndulge"]; obj.TxFooter = (System.String)reader["TxFooter"]; obj.GameName = (System.String)reader["GameName"]; obj.States = (System.Int32)reader["States"]; obj.Maintain = (System.String)reader["Maintain"]; return(obj); }
/// <summary> /// 白鹭选区 /// </summary> private void SelectZoneEget(AllZoneinfoEntity zoneCache) { pf = GetParam("pf"); pfUrl = zoneCache.ChargeUrl.Replace("pf", pf == "" ? "h5_egret" : pf); GetHost = Request.Url.AbsoluteUri.Split('?')[0].Replace("/Index.aspx", ""); //前端需要的域名 string appId = GetParam("appId"); string platInfo = GetParam("platInfo"); string spid = GetParam("egret.runtime.spid"); string channelId = GetParam("channelId"); string isNewApi = GetParam("isNewApi"); string egretSdkDomain = GetParam("egretSdkDomain"); string egretServerDomain = GetParam("egretServerDomain"); string egretRv = GetParam("egretRv"); string token = GetParam("token"); var egretId = GetParam("egretId"); var userId = GetParam("userId"); var userName = GetParam("userName"); var userImg = GetParam("userImg"); var userSex = GetParam("userSex"); var egretOauthUser = GetParam("egretOauthUser"); var egretChannelId = GetParam("egretChannelId"); pf = GetParam("pf"); skipUrl = string.Format("appId={0}&egret.runtime.spid={1}&isSelectZone=1&channelId={2}&platInfo={3}&isNewApi={4}&egretSdkDomain={5}&egretServerDomain={6}&egretRv={7}&httpRoot={8}&pf={9}&isStatistics=1&pfUrl={10}&token={11}&egretId={12}&userId={13}&userName={14}&userImg={15}&userSex={16}&egretOauthUser={17}&egretChannelId={18}", appId, spid, channelId, platInfo, isNewApi, egretSdkDomain, egretServerDomain, egretRv, GetHost, pf, pfUrl, token, egretId, userId, userName, userImg, userSex, egretOauthUser, egretChannelId); }
/// <summary> /// A8选区 /// </summary> /// <param name="zoneCache"></param> private void SelectZoneA8(AllZoneinfoEntity zoneCache) { pf = GetParam("pf"); pfUrl = zoneCache.ChargeUrl.Replace("pf", pf == "" ? "h5_a8" : pf); //pfurl 是js文件 暂时占用chargeurl字段 GetHost = Request.Url.AbsoluteUri.Split('?')[0].Replace("/Index.aspx", ""); //前端需要的域名 openid = GetParamNOUrlDecode("openid"); state = GetParam("state"); nowTimestamp = GetParam("nowTimestamp"); sessionId = GetParam("sessionId"); sign = GetParam("sign"); jsNeed = GetParam("jsNeed"); nickName = GetParam("nickName"); string qqOpenid = GetParam("qqopenid"); string qqOpenkey = GetParam("qqopenkey"); string qqPf = GetParam("qqpf"); string platform = GetParam("platform"); string share = GetParam("share"); string shareType = GetParam("shareType"); string isSubscribe = GetParam("isSubscribe"); string isShare = GetParam("isShare"); openid = UAHelper.StrToUtf8(openid); skipUrl = string.Format( "pfurl={0}&pf={1}&isSelectZone=1&nickName={2}&sessionId={3}&jsNeed={4}&state={5}&openid={6}&nowTimestamp={7}&httpRoot={8}&sign={9}&qqopenid={10}&qqopenkey={11}&qqpf={12}&platform={13}&share={14}&shareType={15}&isSubscribe={16}&isShare={17}", pfUrl, pf, nickName, sessionId, jsNeed, state, openid, nowTimestamp, GetHost, sign, qqOpenid, qqOpenkey, qqPf, platform, share, shareType, isSubscribe, isShare); }
/// <summary> /// 玩吧选区 /// </summary> private void SelectZoneWb(AllZoneinfoEntity zoneCache) { pfUrl = zoneCache.Cdn; GetHost = Request.Url.AbsoluteUri.Split('?')[0].Replace("/Index.aspx", ""); //前端需要的域名 string pf = GetParam("pf"); string openid = GetParam("openid"); string openkey = GetParam("openkey"); string pfkey = GetParam("pfkey"); string serverId = GetParam("serverId"); string platform = GetParam("platform"); skipUrl = string.Format("{7}?isSelectZone=1&openid={0}&openkey={1}&pfkey={2}&serverId={3}&platform={4}&pf={5}&httpRoot={6}", openid, openkey, pfkey, serverId, platform, pf, GetHost, pfUrl); }
ConfigCrosssiteEntity GetSiteItem(AllZoneinfoEntity src) { if (null == src) { return(null); } var obj = new ConfigCrosssiteEntity(); obj.DomainId = ROOTDomainId; obj.DomainName = "Root"; obj.SiteId = src.ZoneName; obj.SiteName = src.CrossName; obj.ShowSiteId = src.CrossName; obj.ShowSiteName = src.CrossName; return(obj); }
/// <summary> /// 群黑选区 /// </summary> private void SelectZoneQunHei(AllZoneinfoEntity zoneCache) { pfUrl = zoneCache.Cdn; GetHost = Request.Url.AbsoluteUri.Split('?')[0].Replace("/Index.aspx", ""); //前端需要的域名 string username = GetParamNOUrlDecode("username"); string serverid = GetParam("serverid"); string time = GetParam("time"); string isadult = GetParam("isadult"); //防沉迷标识(1是成年,0是未成年) string uimg = GetParam("uimg"); //玩家头像 string nname = GetParam("nname"); //玩家昵称 string unid = GetParam("unid"); //玩家来源 string flag = GetParam("flag"); //验证签名,md5(username+serverid+isadult+time+key) skipUrl = string.Format("pfurl={9}?isSelectZone=1&username={0}&serverid={1}&time={2}&isadult={3}&uimg={4}&nname={5}&unid={6}&httpRoot={7}&flag={8}&platform=h5_qunhei&pf=h5_qunhei", username, serverid, time, isadult, uimg, nname, unid, GetHost, flag, pfUrl); }
/// <summary> /// 小熊选区 /// </summary> /// <param name="zoneCache"></param> private void SelectZoneBear(AllZoneinfoEntity zoneCache) { pf = GetParam("pf"); pfUrl = zoneCache.ChargeUrl.Replace("pf", pf == "" ? "h5_bear" : pf); GetHost = Request.Url.AbsoluteUri.Split('?')[0].Replace("/Index.aspx", ""); //前端需要的域名 openid = GetParam("openid"); string name = GetParam("name"); string sex = GetParam("sex"); string face = GetParam("face"); string city = GetParam("city"); string appId = GetParam("appId"); skipUrl = string.Format( "pfurl={0}&pf={1}&isSelectZone=1&openid={2}&name={3}&sex={4}&face={5}&city={6}&appId={7}&httpRoot={8}", pfUrl, pf, openid, name, sex, face, city, appId, GetHost); }
/// <summary> /// GetById /// </summary> /// <param name="idx">idx</param> /// <returns>AllZoneinfoEntity</returns> /// <remarks>2016/6/1 19:20:29</remarks> public AllZoneinfoEntity GetById(System.Int32 idx) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_AllZoneinfo_GetById"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, idx); AllZoneinfoEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/6/1 19:20:29</remarks> public bool Update(AllZoneinfoEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_AllZoneinfo_Update"); database.AddInParameter(commandWrapper, "@Idx", DbType.Int32, entity.Idx); database.AddInParameter(commandWrapper, "@PlatformCode", DbType.AnsiString, entity.PlatformCode); database.AddInParameter(commandWrapper, "@ZoneName", DbType.AnsiString, entity.ZoneName); database.AddInParameter(commandWrapper, "@PlatformZoneName", DbType.AnsiString, entity.PlatformZoneName); database.AddInParameter(commandWrapper, "@Name", DbType.String, entity.Name); database.AddInParameter(commandWrapper, "@ApiUrl", DbType.AnsiString, entity.ApiUrl); database.AddInParameter(commandWrapper, "@ChargeUrl", DbType.AnsiString, entity.ChargeUrl); database.AddInParameter(commandWrapper, "@WebServerUrl", DbType.AnsiString, entity.WebServerUrl); database.AddInParameter(commandWrapper, "@IsDebug", DbType.Int32, entity.IsDebug); database.AddInParameter(commandWrapper, "@IsOpenCharge", DbType.Int32, entity.IsOpenCharge); database.AddInParameter(commandWrapper, "@ChatIp", DbType.AnsiString, entity.ChatIp); database.AddInParameter(commandWrapper, "@ChatPort", DbType.Int32, entity.ChatPort); database.AddInParameter(commandWrapper, "@ClientVersion", DbType.AnsiString, entity.ClientVersion); database.AddInParameter(commandWrapper, "@Cdn", DbType.AnsiString, entity.Cdn); database.AddInParameter(commandWrapper, "@CrossName", DbType.String, entity.CrossName); database.AddInParameter(commandWrapper, "@OpenIndulge", DbType.Boolean, entity.OpenIndulge); database.AddInParameter(commandWrapper, "@TxFooter", DbType.String, entity.TxFooter); database.AddInParameter(commandWrapper, "@GameName", DbType.String, entity.GameName); database.AddInParameter(commandWrapper, "@States", DbType.Int32, entity.States); database.AddInParameter(commandWrapper, "@Maintain", DbType.AnsiString, entity.Maintain); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } return(Convert.ToBoolean(results)); }
/// <summary> /// Update /// </summary> /// <param name="entity"></param> /// <returns></returns> /// <remarks>2016/6/1 19:20:29</remarks> public bool Update(AllZoneinfoEntity entity) { return(Update(entity, null)); }
/// <summary> /// Insert /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/6/1 19:20:29</remarks> public bool Insert(AllZoneinfoEntity entity) { return(Insert(entity, null)); }
private SiteMapCache() { try { s_dicPlats.Clear(); s_dicSites.Clear(); s_dicPlatSites.Clear(); s_dicUaPlats.Clear(); var plats = AllPlatmapMgr.GetAll(); var sites = AllSitemapMgr.GetAll(); var uaPlats = AllUaplatformMgr.GetAll(); var zones = AllZoneinfoMgr.GetAll(); string factCode = FactoryCode; AllPlatmapEntity root = null; foreach (var item in plats) { item.PlatCode = item.PlatCode.ToLower(); s_dicPlats[item.PlatCode] = item; if (null == root && string.Compare(factCode, item.PlatCode, true) == 0) { root = item; } } foreach (var item in zones) { if (string.Compare(item.ZoneName, SiteId, true) == 0) { PlatCode = item.PlatformCode; ZoneIno = item; break; } if (!s_zoneDic.ContainsKey(item.PlatformCode + item.ZoneName)) { s_zoneDic.Add(item.PlatformCode + item.ZoneName, item); } s_zoneDic[item.PlatformCode + item.ZoneName] = item; } foreach (var item in sites) { if (string.Compare(factCode, item.PlatCode, true) != 0) { continue; } s_dicSites[item.SiteId] = item; s_dicPlatSites[item.PlatSiteId] = item; if (null == root) { continue; } if (string.IsNullOrEmpty(item.PlatMainUrl)) { item.PlatMainUrl = root.PlatMainUrl; } if (string.IsNullOrEmpty(item.PlatApiUrl)) { item.PlatApiUrl = root.PlatApiUrl; } if (string.IsNullOrEmpty(item.PayUrl)) { item.PayUrl = root.PayUrl; } if (string.IsNullOrEmpty(item.BbsUrl)) { item.BbsUrl = root.BbsUrl; } if (string.IsNullOrEmpty(item.NavUrl)) { item.NavUrl = root.NavUrl; } if (string.IsNullOrEmpty(item.CdnUrl)) { item.CdnUrl = root.CdnUrl; } if (string.IsNullOrEmpty(item.ChatUrl)) { item.ChatUrl = root.ChatUrl; } } foreach (var item in uaPlats) { s_dicUaPlats[item.PlatformCode.ToLower()] = item; } this.InitFlag = true; } catch (Exception ex) { SystemlogMgr.Error("SiteMapCache:Init", ex); this.InitFlag = false; } }
public CrossSiteTipsEntity(AllZoneinfoEntity src) { this.SiteId = src.ZoneName; this.SiteName = src.Name; }
public static bool Update(AllZoneinfoEntity allZoneinfoEntity, DbTransaction trans = null, string zoneId = "") { var provider = new AllZoneinfoProvider(zoneId); return(provider.Update(allZoneinfoEntity, trans)); }