public IList <IndexModulesEntity> GetIndexModules(IndexModuleType type, int top)
{
string sql = @"SELECT TOP ({0}) [Id]
,[Key]
,[Title]
,[SubTitle1]
,[SubTitle2]
,[ImagePath]
,[LinkUrl]
,[CreateTime]
,[Description]
,[RefId]
,[Sort]
,[Status]
FROM [IndexModules]
WHERE [Key]=@key and status=1
ORDER BY [Sort]";
var db = DbSFO2OMain;
var parameters = db.CreateParameterCollection();
parameters.Append("key", type.As(0));
sql = string.Format(sql, top);
return(db.ExecuteSqlList <IndexModulesEntity>(sql, parameters));
}
private IList <IndexModulesEntity> GetIndexModules(IndexModuleType type, int top, IList <IndexModulesEntity> modules)
{
if (modules == null || modules.Count == 0)
{
return(new List <IndexModulesEntity>());
}
return(modules.Where(n => n.Key == type.As(0)).Take(top).ToList());
}
/// <summary>
/// 从缓存中获取数据
/// </summary>
/// <param name="type"></param>
/// <param name="top"></param>
/// <returns></returns>
public IList <IndexModulesEntity> GetIndexModulesFromCache(IndexModuleType type, int top)
{
try
{
var modules = RedisCacheHelper.AutoCache(ConstClass.RedisKey4MPrefix, ConstClass.RedisKeyIndexModules, () =>
{
var data = GetAllIndexModules();
return(data);
}, 60);
return(GetIndexModules(type, top, modules));
}
catch (Exception ex)
{
LogHelper.Error(ex);
var modules = GetAllIndexModules();
return(GetIndexModules(type, top, modules));
}
}
/// <summary>
/// 根据类型获取模块数据信息
/// </summary>
/// <param name="type"></param>
/// <param name="top"></param>
/// <returns></returns>
public IList <IndexModulesEntity> GetIndexModules(IndexModuleType type, int top)
{
return(IndexDal.GetIndexModules(type, top));
}
