/// <summary>
/// 缓存文件测试
/// </summary>
private void FileTest(string path)
{
DateTimeOffset dtOffset = new DateTimeOffset(DateTime.Now.AddHours(3));
string filePath = path;
string key = "file";
GLCacheExpiration.CreateFileCache(key, filePath, dtOffset);
}
public CacheItem LoadSQLDataList()
{
Console.WriteLine("From SQL");
DateTimeOffset dtOffset = new DateTimeOffset(DateTime.Now.AddHours(3));
string sqlCmd = "SELECT ID,Name,Gender,Phone FROM dbo.Customer";
CacheItem cacheItem = GLCacheExpiration.CreateSQLCache <Customers>("cus", dbConnectionString, sqlCmd, dtOffset, onListSourceChange, SqlCacheOption.List);
return(cacheItem);
}
public CacheItem LoadSQLDataScalar()
{
Console.WriteLine("From SQL");
DateTimeOffset dtOffset = new DateTimeOffset(DateTime.Now.AddHours(3));
string sqlCmd = "SELECT Gender FROM dbo.Customers WHERE ID='00000ddb92044fad8be0913b68697318'";
CacheItem cacheItem = GLCacheExpiration.CreateSQLCache("cus", dbConnectionString, sqlCmd, dtOffset, onScalarSourceChange);
return(cacheItem);
}
public CacheItem LoadSQLDataSingle()
{
Console.WriteLine("From SQL");
DateTimeOffset dtOffset = new DateTimeOffset(DateTime.Now.AddHours(3));
string sqlCmd = "SELECT ID,UserName,Gender,Phone FROM dbo.Customers WHERE ID='00000ddb92044fad8be0913b68697318'";
CacheItem cacheItem = GLCacheExpiration.CreateSQLCache <Customers>("cus", dbConnectionString, sqlCmd, dtOffset, onSingleSourceChange, SqlCacheOption.Single);
return(cacheItem);
}
