From b3df3d5ca95d12742888727e022343e65e39cefa Mon Sep 17 00:00:00 2001 From: zjh <zjh@888> Date: 星期二, 27 二月 2024 20:03:53 +0800 Subject: [PATCH] zjh 本地 2024/02/27 -3 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java | 10 +++++----- 1 files changed, 5 insertions(+), 5 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java index acae5da..76bb663 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java @@ -71,10 +71,6 @@ " SELECT a.pro_id FROM tj_order_detail a WHERE !ISNULL(flowing_water_id) AND order_id=#{orderId})") public List<TjProject> selectTjOrderDetailListByFlowingWaterIdIsNotNull(String orderId); - - - - /** * 鏌ヨ鏈即璐归」鐩� */ @@ -139,7 +135,7 @@ "SELECT #{tjNum},b.cus_id,b.cus_name,'1633660948860522619','绾煶鍚槇'," + "#{userName},SYSDATE(),#{userId} FROM tb_transition a LEFT JOIN tj_customer b " + "ON a.cus_id=b.cus_idcard WHERE a.cus_id=#{cusId} AND a.parent_pro_id IN('1633660948860522619') GROUP BY a.cus_id") - boolean saveTjPureToneTesByCusId(String cusId,String tjNum,String userName, String userId); + boolean saveTjPureToneTesByCusId(@Param("cusId")String cusId,@Param("tjNum")String tjNum,@Param("userName")String userName,@Param("userId") String userId); @Update("UPDATE tj_order_detail a SET\n" + @@ -158,4 +154,8 @@ "(select pro_id from tj_project where pro_parent_id=#{proParentId})") public List<TjOrderDetail> getDetailByOrderIdAndParId(@Param("orderId")Long orderId,@Param("proParentId")Long proParentId); + + + @Select("call pro_lis_sqdbgd(1,#{tjnumber,mode=IN})") + List<TjOrderDetail> addHuaYanTable(@Param("tjnumber") String tjnumber); } -- Gitblit v1.8.0