private IEnumerable <SearchSum> DoSelect()
{
DataTable dt = SqlHelper.ExecuteDataTable(@"
select top 5 Keyword,count(*) as searchcount from keywords
where datediff(day,searchdatetime,getdate())<7
group by Keyword
order by count(*) desc ");
List <SearchSum> list = new List <SearchSum>();
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
SearchSum oneModel = new SearchSum();
oneModel.Keyword = Convert.ToString(row["keyword"]);
oneModel.SearchCount = Convert.ToInt32(row["SearchCount"]);
list.Add(oneModel);
}
}
return(list);
}
public IEnumerable <SearchSum> GetSuggestion(string kw)
{
DataTable dt = SqlHelper.ExecuteDataTable(@"select top 5 Keyword,count(*) as searchcount from keywords
where datediff(day,searchdatetime,getdate())<7
and keyword like @keyword
group by Keyword
order by count(*) desc", new SqlParameter("@keyword", "%" + kw + "%"));
List <SearchSum> list = new List <SearchSum>();
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
SearchSum oneModel = new SearchSum();
oneModel.Keyword = Convert.ToString(row["keyword"]);
oneModel.SearchCount = Convert.ToInt32(row["SearchCount"]);
list.Add(oneModel);
}
}
return(list);
}
