public static CPageDataCache FindPageData(HttpContext context, String PageDataKey) { if (context.Cache.Get(PageDataKey) != null) { CPageDataCache c = (CPageDataCache)context.Cache[PageDataKey]; return(c); } else { return(null); } }
public static CPageDataCache CreatePageDataCache(string sKey, string SqlString, int Spacing) { CPageDataCache cpdc = new CPageDataCache(); cpdc.UpdateSpacing = Spacing; cpdc.SqlString = SqlString; //执行查询 string Connstr = System.Configuration.ConfigurationManager.AppSettings["DBConnStr"]; using (CDBAccess cn = new CDBAccess(Connstr)) { cpdc.dt = cn.ExecQuery(cpdc.SqlString); } cpdc.dt.TableName = "TBN_" + DateTime.Now.ToString("HH:mm:ss fffff"); cpdc.UpdateTime = DateTime.Now; return(cpdc); }
public CPageDataCache getPageDataCache() { if (context.Cache.Get(PageDataKey) != null) { CPageDataCache c = (CPageDataCache)context.Cache[PageDataKey]; c.UpdateSpacing = Spacing; return(c); } else { CPageDataCache c = CPageDataCache.CreatePageDataCache(PageDataKey, Sqlstr, Spacing); lock (context.Cache) { if (context.Cache[PageDataKey] == null) { context.Cache[PageDataKey] = c; } return(c); } } }