public IResponseMessage GetByPublishDate(string content)
{
var wxArticles = new List<ResponseMessageNews.Article>();
using (var db = new WeChatDbContext())
{
var items = from item in db.Articles
where item.Published == content
orderby item.Published descending
select item;
if (items.Count() == 0)
return new ResponseMessageText("无此日期的文章，请尝试其他");
foreach (var item in items)
{
var wxArticle = new ResponseMessageNews.Article
{
Description = item.Description,
Title = item.Title,
PicUrl = new Uri(item.PicUrl),
Url = new Uri(item.Url)
};
wxArticles.Add(wxArticle);
}
}
return new ResponseMessageNews(wxArticles.ToArray());
}
public IResponseMessage GetAllTags()
{
var tags = new HashSet<string>();
using (var db = new WeChatDbContext())
{
var query = from item in db.Articles
select item.Tags;
foreach (var item in query)
{
var split = item.Split(' ');
foreach (var tag in split)
{
tags.Add(tag);
}
}
}
return new ResponseMessageText(string.Join(" ", tags.ToArray()));
}
public IResponseMessage GetTop()
{
var wxArticles = new List<ResponseMessageNews.Article>();
using (var db = new WeChatDbContext())
{
var items = from item in db.Articles
orderby item.Published descending
select item;
foreach (var item in items.Take(5))
{
var wxArticle = new ResponseMessageNews.Article
{
Description = item.Description,
Title = item.Title,
PicUrl = new Uri(item.PicUrl),
Url = new Uri(item.Url)
};
wxArticles.Add(wxArticle);
}
}
return new ResponseMessageNews(wxArticles.ToArray());
}
public ArticleManager()
{
_db = new WeChatDbContext();
}
internal IResponseMessage GetByTag(string content)
{
var wxArticles = new List<ResponseMessageNews.Article>();
using (var db = new WeChatDbContext())
{
var items = from item in db.Articles
where item.Tags.Contains(content)
orderby item.Published descending
select item;
if (items.Count() == 0)
return null;
foreach (var item in items.Take(10))
{
var wxArticle = new ResponseMessageNews.Article
{
Description = item.Description,
Title = item.Title,
PicUrl = new Uri(item.PicUrl),
Url = new Uri(item.Url)
};
wxArticles.Add(wxArticle);
}
}
return new ResponseMessageNews(wxArticles.ToArray());
}