/// <summary> /// 将IDataReader的当前记录读取到AllSitemapEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public AllSitemapEntity LoadSingleRow(IDataReader reader) { var obj = new AllSitemapEntity(); obj.Id = (System.Int32)reader["Id"]; obj.PlatCode = (System.String)reader["PlatCode"]; obj.PlatSiteId = (System.String)reader["PlatSiteId"]; obj.SiteId = (System.String)reader["SiteId"]; obj.SiteName = (System.String)reader["SiteName"]; obj.PendStartTime = (System.DateTime)reader["PendStartTime"]; obj.PendEndTime = (System.DateTime)reader["PendEndTime"]; obj.SiteState = (System.String)reader["SiteState"]; 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.SiteMainUrl = (System.String)reader["SiteMainUrl"]; obj.SiteLoginUrl = (System.String)reader["SiteLoginUrl"]; obj.SiteApiUrl = (System.String)reader["SiteApiUrl"]; obj.SiteSvcUrl = (System.String)reader["SiteSvcUrl"]; obj.RowTime = (System.DateTime)reader["RowTime"]; return(obj); }
protected void Page_Load(object sender, EventArgs e) { bool navFlag = string.IsNullOrEmpty(ConfigurationManager.AppSettings["AutoNav"]); var platSession = GovApi.GetPlatSession(); var zoneName = UAFactory.Instance.ZoneName; var zoneCache = FunctionAppCache.Instance.GetZone(zoneName); if (null == zoneCache) { redirectBack(platSession); return; } //if (string.IsNullOrEmpty(platSession.Uid) || null == zoneCache) //{ // redirectBack(platSession); // return; //} this.NavSiteId = GovApi.GetNavSiteId(); platSession.LastSiteId = this.NavSiteId; this.NavArgs = platSession.AuthArgs; this.NavApiUrl = GetNavApiUrl(platSession, navFlag); this.Cdn = zoneCache.Cdn; this.Version = zoneCache.ClientVersion; var req = HttpContext.Current.Request; string server = (req.QueryString[COLServerV2] ?? req.QueryString[COLServer]) ?? string.Empty; if (server == "-1") { return; } AllSitemapEntity site = null; if (!string.IsNullOrEmpty(server)) { site = SiteMapCache.Instance().GetPlatSiteConfig(server); } if (null != site) { redirect(site, platSession); return; } if (!string.IsNullOrEmpty(platSession.LastSiteId)) { site = SiteMapCache.Instance().GetSiteConfig(platSession.LastSiteId); } if (null != site) { redirect(site, platSession); return; } if (string.IsNullOrEmpty(server) && navFlag) { return; } site = SiteMapCache.Instance().GetSiteConfig(); redirect(site, platSession); }
void redirect(AllSitemapEntity site, IPlatSessionData platSession) { string url = string.Format(site.SiteLoginUrl, platSession.AuthArgs); if (!string.IsNullOrEmpty(ConfigurationManager.AppSettings["TraceNav"])) { LogHelper.Insert(string.Format("Redirect rawUrl:{0},newUrl:{1}", Request.Url.PathAndQuery, url), LogType.Error); } HttpContext.Current.Response.RedirectPermanent(url, false); HttpContext.Current.ApplicationInstance.CompleteRequest(); }
/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2015/10/18 18:56:48</remarks> public bool Update(AllSitemapEntity entity, DbTransaction trans) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_AllSitemap_Update"); database.AddInParameter(commandWrapper, "@Id", DbType.Int32, entity.Id); database.AddInParameter(commandWrapper, "@PlatCode", DbType.AnsiString, entity.PlatCode); database.AddInParameter(commandWrapper, "@PlatSiteId", DbType.AnsiString, entity.PlatSiteId); database.AddInParameter(commandWrapper, "@SiteId", DbType.AnsiString, entity.SiteId); database.AddInParameter(commandWrapper, "@SiteName", DbType.AnsiString, entity.SiteName); database.AddInParameter(commandWrapper, "@PendStartTime", DbType.DateTime, entity.PendStartTime); database.AddInParameter(commandWrapper, "@PendEndTime", DbType.DateTime, entity.PendEndTime); database.AddInParameter(commandWrapper, "@SiteState", DbType.AnsiString, entity.SiteState); 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, "@SiteMainUrl", DbType.AnsiString, entity.SiteMainUrl); database.AddInParameter(commandWrapper, "@SiteLoginUrl", DbType.AnsiString, entity.SiteLoginUrl); database.AddInParameter(commandWrapper, "@SiteApiUrl", DbType.AnsiString, entity.SiteApiUrl); database.AddInParameter(commandWrapper, "@SiteSvcUrl", DbType.AnsiString, entity.SiteSvcUrl); database.AddInParameter(commandWrapper, "@RowTime", DbType.DateTime, entity.RowTime); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } entity.Id = (System.Int32)database.GetParameterValue(commandWrapper, "@Id"); return(Convert.ToBoolean(results)); }
/// <summary> /// GetById /// </summary> /// <param name="id">id</param> /// <returns>AllSitemapEntity</returns> /// <remarks>2015/10/18 18:56:48</remarks> public AllSitemapEntity GetById(System.Int32 id) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_AllSitemap_GetById"); database.AddInParameter(commandWrapper, "@Id", DbType.Int32, id); AllSitemapEntity 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>2015/10/18 18:56:48</remarks> public bool Update(AllSitemapEntity 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:48</remarks> public bool Insert(AllSitemapEntity entity) { return(Insert(entity, null)); }
public static bool Update(AllSitemapEntity allSitemapEntity, DbTransaction trans = null, string zoneId = "") { var provider = new AllSitemapProvider(zoneId); return(provider.Update(allSitemapEntity, trans)); }