From c5a0c0b290cba50f76d17843ac062ffa935b15d6 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期三, 30 十月 2024 18:03:18 +0800
Subject: [PATCH] zjh20241030
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java | 10 ++++++++--
1 files changed, 8 insertions(+), 2 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..0ef8cbd 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
@@ -125,8 +125,8 @@
"\tLEFT JOIN tj_project pro ON re.pro_id = pro.pro_id\n" +
"\tLEFT JOIN sys_user us ON us.user_id = re.doctor_name \n" +
"WHERE\n" +
- "\tre.type != 2 \n" +//and pro.need_report='Y'
- "\tAND re.tj_number =#{tjNumber}")
+ "re.type != 2 \n" +//and pro.need_report='Y'
+ "AND re.tj_number =#{tjNumber} and re.dept_id !=532 and pro.pro_name not like '%璐�%'")
List<CsProVo> cSWebGetProByTjNumAndOrderId(String tjNumber);
@@ -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