From 2d45468ce5f1dcdc27141a61bcbdf41ca98b7e42 Mon Sep 17 00:00:00 2001
From: zengh <123456>
Date: Sun, 18 Jul 2021 14:35:48 +0800
Subject: [PATCH] 解除绑定相关

---
 src/main/java/org/springblade/modules/exam/service/impl/ExamPaperServiceImpl.java |    6 ++++++
 src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.java            |    2 ++
 src/main/java/org/springblade/modules/exam/service/ExamPaperService.java          |    5 +++++
 src/main/java/org/springblade/modules/exam/controller/ExamPaperController.java    |    8 ++++++++
 src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.xml             |    4 ++++
 5 files changed, 25 insertions(+), 0 deletions(-)

diff --git a/src/main/java/org/springblade/modules/exam/controller/ExamPaperController.java b/src/main/java/org/springblade/modules/exam/controller/ExamPaperController.java
index d5ebd3f..01adfae 100644
--- a/src/main/java/org/springblade/modules/exam/controller/ExamPaperController.java
+++ b/src/main/java/org/springblade/modules/exam/controller/ExamPaperController.java
@@ -163,4 +163,12 @@
 		return R.data(pages);
 	}
 
+	/**
+	 * 解除绑定
+	 */
+	@GetMapping("/UnbindSubject")
+	public R UnbindSubject(String paperid,String subjectid){
+
+		return R.status(examPaperService.UnbindSubject(paperid,subjectid));
+	}
 }
diff --git a/src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.java b/src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.java
index 73febb4..e84a2d3 100644
--- a/src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.java
+++ b/src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.java
@@ -44,4 +44,6 @@
 	 * @return
 	 */
     List<ExamPaper> selectExamPaperPageTree(@Param("paper") ExamPaper examPaper);
+
+    boolean UnbindSubject(String paperid,String subjectid);
 }
diff --git a/src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.xml b/src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.xml
index eb2e01c..392f98d 100644
--- a/src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.xml
+++ b/src/main/java/org/springblade/modules/exam/mapper/ExamPaperMapper.xml
@@ -82,4 +82,8 @@
         </if>
     </select>
 
+    <delete id="UnbindSubject">
+       delete from exam_examination_subject where examination_id = #{paperid} and subject_id = #{subjectid}
+    </delete>
+
 </mapper>
diff --git a/src/main/java/org/springblade/modules/exam/service/ExamPaperService.java b/src/main/java/org/springblade/modules/exam/service/ExamPaperService.java
index 61bfa1c..00d25ee 100644
--- a/src/main/java/org/springblade/modules/exam/service/ExamPaperService.java
+++ b/src/main/java/org/springblade/modules/exam/service/ExamPaperService.java
@@ -45,4 +45,9 @@
 	 * @return
 	 */
     List<ExamPaper> selectExamPaperPageTree(ExamPaper examPaper);
+
+	/**
+	 * 解除试卷和题目的绑定
+	 */
+	boolean UnbindSubject(String paperid,String subjectid);
 }
diff --git a/src/main/java/org/springblade/modules/exam/service/impl/ExamPaperServiceImpl.java b/src/main/java/org/springblade/modules/exam/service/impl/ExamPaperServiceImpl.java
index dc4908d..3755952 100644
--- a/src/main/java/org/springblade/modules/exam/service/impl/ExamPaperServiceImpl.java
+++ b/src/main/java/org/springblade/modules/exam/service/impl/ExamPaperServiceImpl.java
@@ -56,4 +56,10 @@
 	public List<ExamPaper> selectExamPaperPageTree(ExamPaper examPaper) {
 		return baseMapper.selectExamPaperPageTree(examPaper);
 	}
+
+	@Override
+	public boolean UnbindSubject(String paperid, String subjectid) {
+		return baseMapper.UnbindSubject(paperid,subjectid);
+	}
+
 }

--
Gitblit v1.9.3