/// <summary>
/// GetById
/// </summary>
/// <param name="platCode">platCode</param>
/// <returns>AllPlatmapEntity</returns>
/// <remarks>2015/10/18 18:56:38</remarks>
public AllPlatmapEntity GetById(System.String platCode)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("P_AllPlatmap_GetById");
database.AddInParameter(commandWrapper, "@PlatCode", DbType.AnsiString, platCode);
AllPlatmapEntity 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>2015/10/18 18:56:38</remarks>
public bool Update(AllPlatmapEntity entity, DbTransaction trans)
{
var database = new SqlDatabase(this.ConnectionString);
DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_AllPlatmap_Update");
database.AddInParameter(commandWrapper, "@PlatCode", DbType.AnsiString, entity.PlatCode);
database.AddInParameter(commandWrapper, "@PlatName", DbType.AnsiString, entity.PlatName);
database.AddInParameter(commandWrapper, "@ShareDomain", DbType.AnsiString, entity.ShareDomain);
database.AddInParameter(commandWrapper, "@SessionMode", DbType.Int32, entity.SessionMode);
database.AddInParameter(commandWrapper, "@AppKey", DbType.AnsiString, entity.AppKey);
database.AddInParameter(commandWrapper, "@AppSecret", DbType.AnsiString, entity.AppSecret);
database.AddInParameter(commandWrapper, "@LoginKey", DbType.AnsiString, entity.LoginKey);
database.AddInParameter(commandWrapper, "@PayKey", DbType.AnsiString, entity.PayKey);
database.AddInParameter(commandWrapper, "@PayPointRate", DbType.Int32, entity.PayPointRate);
database.AddInParameter(commandWrapper, "@PlatMainUrl", DbType.AnsiString, entity.PlatMainUrl);
database.AddInParameter(commandWrapper, "@PlatApiUrl", DbType.AnsiString, entity.PlatApiUrl);
database.AddInParameter(commandWrapper, "@PayUrl", DbType.AnsiString, entity.PayUrl);
database.AddInParameter(commandWrapper, "@BbsUrl", DbType.AnsiString, entity.BbsUrl);
database.AddInParameter(commandWrapper, "@NavUrl", DbType.AnsiString, entity.NavUrl);
database.AddInParameter(commandWrapper, "@CdnUrl", DbType.AnsiString, entity.CdnUrl);
database.AddInParameter(commandWrapper, "@ChatUrl", DbType.AnsiString, entity.ChatUrl);
database.AddInParameter(commandWrapper, "@RowTime", DbType.DateTime, entity.RowTime);
int results = 0;
if (trans != null)
{
results = database.ExecuteNonQuery(commandWrapper, trans);
}
else
{
results = database.ExecuteNonQuery(commandWrapper);
}
return(Convert.ToBoolean(results));
}
/// <summary>
/// 将IDataReader的当前记录读取到AllPlatmapEntity 对象
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public AllPlatmapEntity LoadSingleRow(IDataReader reader)
{
var obj = new AllPlatmapEntity();
obj.PlatCode = (System.String)reader["PlatCode"];
obj.PlatName = (System.String)reader["PlatName"];
obj.ShareDomain = (System.String)reader["ShareDomain"];
obj.SessionMode = (System.Int32)reader["SessionMode"];
obj.AppKey = (System.String)reader["AppKey"];
obj.AppSecret = (System.String)reader["AppSecret"];
obj.LoginKey = (System.String)reader["LoginKey"];
obj.PayKey = (System.String)reader["PayKey"];
obj.PayPointRate = (System.Int32)reader["PayPointRate"];
obj.PlatMainUrl = (System.String)reader["PlatMainUrl"];
obj.PlatApiUrl = (System.String)reader["PlatApiUrl"];
obj.PayUrl = (System.String)reader["PayUrl"];
obj.BbsUrl = (System.String)reader["BbsUrl"];
obj.NavUrl = (System.String)reader["NavUrl"];
obj.CdnUrl = (System.String)reader["CdnUrl"];
obj.ChatUrl = (System.String)reader["ChatUrl"];
obj.RowTime = (System.DateTime)reader["RowTime"];
return(obj);
}
public static bool Update(AllPlatmapEntity allPlatmapEntity, DbTransaction trans = null, string zoneId = "")
{
var provider = new AllPlatmapProvider(zoneId);
return(provider.Update(allPlatmapEntity, trans));
}
/// <summary>
/// Update
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
/// <remarks>2015/10/18 18:56:38</remarks>
public bool Update(AllPlatmapEntity entity)
{
return(Update(entity, null));
}
/// <summary>
/// Insert
/// </summary>
/// <param name="entity"></param>
/// <param name="trans">The trans.</param>
/// <returns></returns>
/// <remarks>2015/10/18 18:56:38</remarks>
public bool Insert(AllPlatmapEntity 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;
}
}
