backend/ExamKing.Application/Services/StuscoreService.cs

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

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

#nullable enable
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using ExamKing.Application.ErrorCodes;
using ExamKing.Application.Mappers;
using ExamKing.Core.Entites;
using Furion.DatabaseAccessor;
using Furion.DependencyInjection;
using Furion.FriendlyException;
using Mapster;
using Microsoft.EntityFrameworkCore;

namespace ExamKing.Application.Services
{
    /// <summary>
    /// 考试成绩服务
    /// </summary>
    public class StuscoreService : IStuscoreService, ITransient
    {
        private readonly IRepository<TbStuscore> _stuscoreRepository;

        /// <summary>
        /// 依赖注入
        /// </summary>
        /// <param name="stuscoreRepository"></param>
        public StuscoreService(IRepository<TbStuscore> stuscoreRepository)
        {
            _stuscoreRepository = stuscoreRepository;
        }

        /// <summary>
        /// 查询学生全部考试成绩分页
        /// </summary>
        /// <param name="studentId"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <returns></returns>
        public async Task<PagedList<StuscoreDto>> FindScoreAllByStudentAndPage(int studentId, int pageIndex = 1,
            int pageSize = 10)
        {
            var pageResult = await _stuscoreRepository
                .Entities.AsNoTracking()
                .Where(u=>u.StuId==studentId)
                .Select(u => new TbStuscore
                {
                    Id = u.Id,
                    StuId = u.StuId,
                    CourseId = u.CourseId,
                    ExamId = u.ExamId,
                    Score = u.Score,
                    CreateTime = u.CreateTime,
                    Exam = new TbExam
                    {
                        Id = u.Exam.Id,
                        ExamName = u.Exam.ExamName,
                        StartTime = u.Exam.StartTime,
                        Duration = u.Exam.Duration,
                    }