From 696d71cdc4eefa49951b7e14556fe56072714edd Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期一, 11 八月 2025 18:10:29 +0800
Subject: [PATCH] 添加字段
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderRemarkMapper.java | 16 ++++++++++++++++
1 files changed, 16 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 c4121cf..ccf3204 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
@@ -317,4 +317,20 @@
@Update("UPDATE tj_order_remark a " +
"SET a.type=1 WHERE a.tj_number=#{tjNumber} and a.pro_id=#{proId}")
int updateTjOrderRemarkByTjzt(@Param("tjNumber") String tjNumber,@Param("proId") String proId);
+
+
+ @Select("call csymxmxzqtyybcjk(#{tjh,mode=IN},#{xmid,mode=IN},#{yy,mode=IN},#{kslx,mode=IN},#{czy,mode=IN}," +
+ "#{czydm,mode=IN}) ")
+ void csymxmxzqtyybcjk(@Param("tjh")String tjNum,@Param("xmid") String proId,@Param("yy") String yy,
+ @Param("kslx") String orgType,@Param("czy") String czy,@Param("czydm") String czydm);
+
+
+ @Select("call newpacsJianChaData(#{tjnumber,mode=IN},0)")
+ List<TjOrderRemark> newpacsJianChaData(String tjnumber);
+
+
+ @Select(" SELECT b.pro_name xmm" +
+ " FROM tj_order_remark a LEFT JOIN tj_project b ON b.pro_id=a.pro_id" +
+ " WHERE a.tj_number=#{tjNumber} AND a.type !=2 AND a.deleted=0")
+ List<String> getTjxm(String tjNumber);
}
--
Gitblit v1.8.0