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