/// <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; }