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