From 1ea4e6b1fce036ba234c9f21c69e9fd68649abb2 Mon Sep 17 00:00:00 2001
From: zjh <zjh@888>
Date: 星期三, 05 六月 2024 18:45:22 +0800
Subject: [PATCH] zjh 本地 2024/06/05 --2

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java |   14 ++++++++++++++
 1 files changed, 14 insertions(+), 0 deletions(-)

diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
index 6f92c49..6ed856c 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
@@ -8,6 +8,7 @@
 import com.ltkj.hosp.domain.TjCustomer;
 import com.ltkj.hosp.domain.TjOrder;
 import com.ltkj.hosp.vodomain.LineChartsVo;
+import org.apache.ibatis.annotations.Delete;
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
 import org.apache.ibatis.annotations.Select;
@@ -227,4 +228,17 @@
             " left join dict_comp d on d.drug_manufacturer_id = c.firm_id\n" +
             "where c.tj_number=#{tjNumber}")
     Map<String ,Object > selectDjdUserInfo(@Param("tjNumber")String tjNumber);
+
+
+    @Select("SELECT a.jcsqdh FROM ltkj_outpinexamapply a WHERE a.cardId=#{cardId}")
+    String getHuoQuJcsqdh(String cardId);
+    @Delete("DELETE FROM ltkj_outpinexamapply WHERE cardId=#{cardId}")
+    String delHuoQuJcsqdh(String cardId);
+
+
+
+    @Select("SELECT a.jysqdh FROM ltkj_outpintestapply a WHERE a.cardId='20240604000001'")
+    String getHuoQuJysqdh(String cardId);
+    @Delete("DELETE FROM ltkj_outpintestapply WHERE cardId=#{cardId}")
+    String delHuoQuJysqdh(String cardId);
 }

--
Gitblit v1.8.0