From f6aa75199f79c3fbe74de4c72c3271234e781341 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期二, 28 五月 2024 18:03:22 +0800
Subject: [PATCH] 将单独查询的sql 统一
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java | 4 ++++
1 files changed, 4 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 f02edaf..e05e048 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
@@ -113,4 +113,8 @@
@Select("call pro_lis_sqdbgd(0,#{tjnumber,mode=IN})")
// @Select("select * from test_remark")
List<TjOrderRemark> addHuaYanTable(@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);
}
--
Gitblit v1.8.0