From cb50f227bb5276600a8011caf13f2784d94af6ab Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期三, 16 十月 2024 15:04:08 +0800
Subject: [PATCH] 检验标本字典
---
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..3c8526c 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}")
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