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 |   23 +++++++++++++++++++++++
 1 files changed, 23 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 2ed2858..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;
@@ -65,4 +66,26 @@
 	 * @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