From f8ec379d94c8ccbdadef657240429fe7c7f257ab Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Sat, 09 Oct 2021 17:57:51 +0800
Subject: [PATCH] 题目生成记录优化,单个新增修改为sql批量新增

---
 src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java |   31 +++++++++++++++++++++++++++++++
 1 files changed, 31 insertions(+), 0 deletions(-)

diff --git a/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java b/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java
index e20d61d..0b534a0 100644
--- a/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java
+++ b/src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.java
@@ -5,6 +5,7 @@
 import org.apache.ibatis.annotations.Param;
 import org.springblade.modules.exam.entity.ExamScore;
 import org.springblade.modules.exam.vo.ExamScoreVO;
+import org.springblade.modules.training.entity.TrainingRegistration;
 
 import java.util.List;
 import java.util.Map;
@@ -56,5 +57,35 @@
 	 * @param examScore
 	 * @return
 	 */
+
     int updateByIdAndQualifiee(@Param("examScore") ExamScore examScore);
+	/**
+	 * 自定义分页
+	 *
+	 * @param page  分页
+	 * @return
+	 */
+	List<ExamScoreVO> scorePage(IPage page,String deptid,String jurisdiction);
+
+	/**
+	 * 查询所有考试不合格的数据
+	 * @return
+	 */
+    List<ExamScore> getDisqualificationExamInfo();
+
+	/**
+	 * 根据准考证号查询培训信息
+	 * @param trainingRegistration
+	 * @return
+	 */
+	TrainingRegistration getTrainInfo(@Param("trainingRegistration")TrainingRegistration trainingRegistration);
+
+	/**
+	 * 查询所有无成绩的数据
+	 * @return
+	 */
+	List<ExamScore> getNoScoreInfo();
+
+	List<ExamScore> getLheoryGradeLess60();
+
 }

--
Gitblit v1.9.3