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