考试成绩导入接口修改，查询接口修改

Administrator

2021-07-29 92b71ac07ad4e0b7282135cad0919a4be4ec1efb

 src/main/java/org/springblade/modules/exam/service/impl/ExamScoreServiceImpl.java

@@ -7,19 +7,19 @@
import org.springblade.modules.exam.entity.ExamExaminationSubject;
import org.springblade.modules.exam.entity.ExamPaper;
import org.springblade.modules.exam.entity.ExamScore;
import org.springblade.modules.exam.excel.ExamScoreExcel;
import org.springblade.modules.exam.mapper.ExamScoreMapper;
import org.springblade.modules.exam.service.ExamPaperService;
import org.springblade.modules.exam.service.ExamScoreService;
import org.springblade.modules.exam.vo.ExamPaperSubjectVO;
import org.springblade.modules.exam.vo.ExamResultVO;
import org.springblade.modules.exam.vo.ExamScoreVO;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

import static com.bstek.ureport.expression.model.condition.Join.and;

/**
 * 考试成绩服务实现类
@@ -76,7 +76,7 @@
               if (examResultVO.getSubjectChoicesId().equals(examExaminationSubject.getExamSubjectChoices().getId())) {
                  //对比答案

                  if (examExaminationSubject.getExamSubjectChoices().getChoicesType() == 2){
                  if (examExaminationSubject.getExamSubjectChoices().getChoicesType() == 2 || examExaminationSubject.getExamSubjectChoices().getChoicesType() == 3){
                     //判断题逻辑
                     if (examResultVO.getValue().equals(examExaminationSubject.getExamSubjectChoices().getAnswer())) {
                        theoryGrade += examResultVO.getGrade();
@@ -123,4 +123,32 @@
      //返回结果
      return false;
   }

   /**
    * 导入实操成绩
    * @param examScoreExcelList
    * @param isCovered 是否覆盖
    */
   @Override
   public void importExamScore(List<ExamScoreExcel> examScoreExcelList, Boolean isCovered) {
      if (examScoreExcelList.size()>0){
         examScoreExcelList.forEach(examScoreExcel -> {
            if (null!=examScoreExcel.getLearnGrade() && null!=examScoreExcel.getIdCardNo() && examScoreExcel.getIdCardNo()!=""){
               ExamScore examScore = baseMapper.getExamScoreInfoByIdCardNo(examScoreExcel.getIdCardNo());
               if (null!=examScore) {
                  examScore.setLearnGrade(examScoreExcel.getLearnGrade());
                  if (examScore.getTheoryGrade() >= 60 && examScore.getLearnGrade() >= 60) {
                     //合格
                     examScore.setQualified(0);
                  } else {
                     //不合格
                     examScore.setQualified(1);
                  }
                  //更新成绩数据
                  baseMapper.updateById(examScore);
               }
            }
         });
      }
   }
}