Asp.NETPersonnalBlogSystem/BLL/ArticleService.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using Asp.NETPersonnalBlogSystem.DAL;
using Asp.NETPersonnalBlogSystem.Models;

namespace Asp.NETPersonnalBlogSystem.BLL
{
    /// <summary>
    /// 文章业务逻辑类
    /// 处理文章相关的业务操作
    /// </summary>
    public class ArticleService
    {
        /// <summary>
        /// 获取文章列表（分页）
        /// </summary>
        /// <param name="pageIndex">页码（从1开始）</param>
        /// <param name="pageSize">每页数量</param>
        /// <param name="categoryId">分类ID（可选，0表示所有分类）</param>
        /// <param name="keyword">搜索关键词（可选）</param>
        /// <param name="status">文章状态（可选，-1表示所有状态）</param>
        /// <returns>文章列表</returns>
        public List<Article> GetArticleList(int pageIndex, int pageSize, int categoryId = 0, string keyword = "", int status = -1)
        {
            using (var db = new BlogDbContext())
            {
                var query = db.Articles.Include("Category").Include("Author").AsQueryable();

                if (categoryId > 0)
                {
                    query = query.Where(a => a.CategoryId == categoryId);
                }

                if (!string.IsNullOrEmpty(keyword))
                {
                    query = query.Where(a => a.Title.Contains(keyword) || a.Tags.Contains(keyword));
                }

                if (status >= 0)
                {
                    query = query.Where(a => a.Status == status);
                }

                return query.OrderByDescending(a => a.IsTop)
                           .ThenByDescending(a => a.PublishTime)
                           .Skip((pageIndex - 1) * pageSize)
                           .Take(pageSize)
                           .ToList();
            }
        }

        /// <summary>
        /// 获取文章总数
        /// </summary>
        /// <param name="categoryId">分类ID（可选，0表示所有分类）</param>
        /// <param name="keyword">搜索关键词（可选）</param>
        /// <param name="status">文章状态（可选，-1表示所有状态）</param>
        /// <returns>文章总数</returns>
        public int GetArticleCount(int categoryId = 0, string keyword = "", int status = -1)