From ab550ebbfa4b579b373fdd7589e799bbb44362e7 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 05 七月 2024 18:37:03 +0800
Subject: [PATCH] zjh 2024/07/5-1
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java
index 2b9153b..7632d10 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java
@@ -134,7 +134,13 @@
// @Select("select * from test_remark")
List<TjOrderRemark> addHuaYanTable(@Param("tjnumber") String tjnumber);
+ @Select("call pro_checkhyAndcg(0,#{tjnumber,mode=IN})")
+ List<TjOrderRemark> addHuaYanAndCgTable(@Param("tjnumber")String tjnumber);
+
@Update("UPDATE tj_order_remark a SET a.type=2 WHERE a.tj_number=#{tjnumber} AND a.pro_id=#{proId}")
void updateTjOrderRemark(@Param("tjnumber")String tjnumber,@Param("proId")String proId);
+
+ @Delete("DELETE FROM tj_order_remark WHERE jxbz=#{bldh}")
+ void deleteTjOrderDetailByjxbz(String bldh);
}
--
Gitblit v1.8.0