/// <summary>
/// 按条件检索博客
/// </summary>
/// <param name="selectArticleRequest"></param>
/// <returns></returns>
public static List <Article> SelectArticleList(SelectArticleRequest selectArticleRequest)
{
List <Article> list = null;
using (BlogEntities blogEntities = new BlogEntities())
{
if (String.IsNullOrEmpty(selectArticleRequest.Title))
{
selectArticleRequest.Title = "";
}
if (selectArticleRequest.BeginPublicationTime == null)
{
selectArticleRequest.BeginPublicationTime = DateTime.MinValue;
}
if (selectArticleRequest.EndPublicationTime == null)
{
selectArticleRequest.EndPublicationTime = DateTime.MaxValue;
}
if (selectArticleRequest.Page == 0)
{
selectArticleRequest.Page = 1;
}
if (selectArticleRequest.CountPerPage == 0)
{
selectArticleRequest.CountPerPage = int.MaxValue;
}
var articles = (from article in blogEntities.Article.Include("ArticleLabel")
where article.Title.Contains(selectArticleRequest.Title) &&
article.PublicationTime >= selectArticleRequest.BeginPublicationTime &&
article.PublicationTime <= selectArticleRequest.EndPublicationTime
orderby article.PublicationTime descending
select article)
.Skip((selectArticleRequest.Page - 1) * selectArticleRequest.CountPerPage)
.Take(selectArticleRequest.CountPerPage);
list = new List <Article>(articles.ToArray());
}
return(list);
}
/// <summary>
/// 按条件检索博客
/// </summary>
/// <param name="selectArticleRequest"></param>
/// <returns></returns>
public static List<Article> SelectArticleList(SelectArticleRequest selectArticleRequest)
{
List<Article> list = null;
using (BlogEntities blogEntities = new BlogEntities())
{
if (String.IsNullOrEmpty(selectArticleRequest.Title))
{
selectArticleRequest.Title = "";
}
if (selectArticleRequest.BeginPublicationTime == null)
{
selectArticleRequest.BeginPublicationTime = DateTime.MinValue;
}
if (selectArticleRequest.EndPublicationTime == null)
{
selectArticleRequest.EndPublicationTime = DateTime.MaxValue;
}
if (selectArticleRequest.Page == 0)
{
selectArticleRequest.Page = 1;
}
if (selectArticleRequest.CountPerPage == 0)
{
selectArticleRequest.CountPerPage = int.MaxValue;
}
var articles = (from article in blogEntities.Article.Include("ArticleLabel")
where article.Title.Contains(selectArticleRequest.Title)
&& article.PublicationTime >= selectArticleRequest.BeginPublicationTime
&& article.PublicationTime <= selectArticleRequest.EndPublicationTime
orderby article.PublicationTime descending
select article)
.Skip((selectArticleRequest.Page - 1) * selectArticleRequest.CountPerPage)
.Take(selectArticleRequest.CountPerPage);
list = new List<Article>(articles.ToArray());
}
return list;
}
