From 690a1b6765451b65002544cffab232fd0748912a Mon Sep 17 00:00:00 2001 From: lige <bestlige@outlook.com> Date: 星期二, 24 十月 2023 17:19:40 +0800 Subject: [PATCH] 登记时回显 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java | 9 +++++++++ 1 files changed, 9 insertions(+), 0 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 30a3f17..5d55e82 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 @@ -133,4 +133,13 @@ "a.update_id=#{userId}\n" + "WHERE a.order_id=#{orderId}") boolean updateTjOrderDetailsByOrderId(@Param("orderId")String orderId,@Param("userName")String userName,@Param("userId") String userId,@Param("ls")String ls); + + + @Select("SELECT *\n" + + "FROM `tj_order_detail` \n" + + "where order_id=#{orderId}\n" + + "and pro_id IN\n" + + "(select pro_id from tj_project where pro_parent_id=#{proParentId})") + public List<TjOrderDetail> getDetailByOrderIdAndParId(@Param("orderId")Long orderId,@Param("proParentId")Long proParentId); + } -- Gitblit v1.8.0