From 22915f206dae518b291762d7b5ef3c4143cd79b8 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期四, 25 七月 2024 15:36:18 +0800
Subject: [PATCH] 检查申请单插入前查询判断

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcsqdService.java          |    2 ++
 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java |    6 ++++++
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java            |    4 ++++
 3 files changed, 12 insertions(+), 0 deletions(-)

diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java
index 50424ae..09d8492 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/LtkjExamJcsqdMapper.java
@@ -38,6 +38,10 @@
             "FROM ltkj_exam_jcbgd a WHERE a.tjh=#{tjh} GROUP BY a.xmmc")
     void saveLtkjExamJcsqd(String tjh);
 
+    @Select("SELECT a.tjh,a.tmh,NULL jclx,NULL jczlx,a.shysxm bgys,a.shysdm bgysid,a.sqsj,a.zdsj jgsj, a.xmmc jcxmmc,a.xmdm jcxmid,a.jcbw bw," +
+            "a.yxzd jgzt,a.yxbx jgbx FROM ltkj_exam_jcbgd a WHERE a.tjh=#{tjh} GROUP BY a.xmmc")
+    List<LtkjExamJcbgd> queryLtkjExamJcsqdByTjh(String tjh);
+
 
     @DataSource(value = DataSourceType.SLAVE_HIS)
     @Qualifier (value = "slaveHisDataSource")
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcsqdService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcsqdService.java
index 291f651..5c566d4 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcsqdService.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/LtkjExamJcsqdService.java
@@ -26,4 +26,6 @@
     void saveLtkjExamJcsqd(String tjh);
 
     AjaxResult getTjJcProByHisCall(String ksmc,String strIn,String brid,int pagecount,int page,String status);
+
+    List<LtkjExamJcbgd> queryLtkjExamJcsqdByTjh(String tjh);
 }
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java
index 5598e72..6182d21 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java
@@ -4,6 +4,7 @@
 import com.ltkj.common.core.domain.AjaxResult;
 import com.ltkj.hosp.mapper.LtkjExamJcsqdMapper;
 import com.ltkj.hosp.service.LtkjExamJcsqdService;
+import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
 import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
 import lombok.extern.slf4j.Slf4j;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -56,6 +57,11 @@
     }
 
     @Override
+    public List<LtkjExamJcbgd> queryLtkjExamJcsqdByTjh(String tjh) {
+        return mapper.queryLtkjExamJcsqdByTjh(tjh);
+    }
+
+    @Override
     public void saveLtkjExamJcsqd(String tjh) {
         mapper.saveLtkjExamJcsqd(tjh);
     }

--
Gitblit v1.8.0