From 90c49a219f9abb8a85be0e07f190c33bac25d1ee Mon Sep 17 00:00:00 2001
From: zengh <123456>
Date: Sun, 18 Jul 2021 11:43:10 +0800
Subject: [PATCH] 修改分值,解除绑定相关

---
 src/main/java/org/springblade/modules/exam/controller/ExamSubjectChoicesController.java    |    8 ++++++++
 src/main/java/org/springblade/modules/exam/service/ExamSubjectChoicesService.java          |    5 +++++
 src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.java            |    2 ++
 src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java |    5 +++++
 src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.xml             |   10 ++++++++++
 5 files changed, 30 insertions(+), 0 deletions(-)

diff --git a/src/main/java/org/springblade/modules/exam/controller/ExamSubjectChoicesController.java b/src/main/java/org/springblade/modules/exam/controller/ExamSubjectChoicesController.java
index 3058883..44a3bf1 100644
--- a/src/main/java/org/springblade/modules/exam/controller/ExamSubjectChoicesController.java
+++ b/src/main/java/org/springblade/modules/exam/controller/ExamSubjectChoicesController.java
@@ -146,4 +146,12 @@
 		return R.data(pages);
 	}
 
+	/**
+	 * 修改单项题目分值
+	 */
+	@PostMapping("/updateChoicesValue")
+	public R updateChoicesValue(String id,String value) {
+		return R.status(examSubjectChoicesService.updateChoicesValue(id,value));
+	}
+
 }
diff --git a/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.java b/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.java
index 74e8536..4d4eb85 100644
--- a/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.java
+++ b/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.java
@@ -39,4 +39,6 @@
 	 */
 	ExamSubjectChoicesVO selectExamSubjectChoicesInfo(@Param("examSubjectChoices") ExamSubjectChoices examSubjectChoices);
 
+	boolean updateChoicesValue(String id,String value);
+
 }
diff --git a/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.xml b/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.xml
index b3c76a0..35b04cb 100644
--- a/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.xml
+++ b/src/main/java/org/springblade/modules/exam/mapper/ExamSubjectChoicesMapper.xml
@@ -30,6 +30,12 @@
         <if test="examSubjectChoices.id!=null and  examSubjectChoices.id!=''">
             and exa.examination_id = #{examSubjectChoices.id}
         </if>
+        <if test="examSubjectChoices.subjectName!=null and  examSubjectChoices.subjectName!=''">
+            and esc.subject_name like concat('%', #{examSubjectChoices.subjectName},'%')
+        </if>
+        <if test="examSubjectChoices.choicesType!=null and  examSubjectChoices.choicesType!=''">
+            and esc.choices_type = #{examSubjectChoices.choices_type}
+        </if>
     </select>
 
 
@@ -74,4 +80,8 @@
             and esc.id = #{examSubjectChoices.id}
         </if>
     </select>
+
+    <update id="updateChoicesValue">
+        update exam_subject_choices set score = #{value} where id = #{id}
+    </update>
 </mapper>
diff --git a/src/main/java/org/springblade/modules/exam/service/ExamSubjectChoicesService.java b/src/main/java/org/springblade/modules/exam/service/ExamSubjectChoicesService.java
index 8cb5107..10c578e 100644
--- a/src/main/java/org/springblade/modules/exam/service/ExamSubjectChoicesService.java
+++ b/src/main/java/org/springblade/modules/exam/service/ExamSubjectChoicesService.java
@@ -32,4 +32,9 @@
 	 * @param examSubjectChoices 选择题信息对象
 	 */
 	ExamSubjectChoicesVO selectExamSubjectChoicesInfo(ExamSubjectChoices examSubjectChoices);
+
+	/**
+	 *	修改分值
+	 */
+	boolean updateChoicesValue(String id , String value);
 }
diff --git a/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java b/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java
index 6f4a78b..4e9634d 100644
--- a/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java
+++ b/src/main/java/org/springblade/modules/exam/service/impl/ExamSubjectChoicesServiceImpl.java
@@ -34,4 +34,9 @@
 	public ExamSubjectChoicesVO selectExamSubjectChoicesInfo(ExamSubjectChoices examSubjectChoices) {
 		return baseMapper.selectExamSubjectChoicesInfo(examSubjectChoices);
 	}
+
+	@Override
+	public boolean updateChoicesValue(String id, String value) {
+		return baseMapper.updateChoicesValue(id,value);
+	}
 }

--
Gitblit v1.9.3