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

Administrator

2021-07-29 92b71ac07ad4e0b7282135cad0919a4be4ec1efb

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

@@ -7,6 +7,7 @@
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;
@@ -17,6 +18,8 @@

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

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

/**
 * 考试成绩服务实现类
@@ -120,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);
               }
            }
         });
      }
   }
}