From 88ee7561ab60710099182514bf639e37fd6114a9 Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期五, 17 五月 2024 18:03:21 +0800 Subject: [PATCH] zjh 2024/05/17-1 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java index 0cdbafc..e274de6 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java @@ -202,4 +202,8 @@ @Select("SELECT a.card_id FROM tj_order a WHERE a.deleted=0") List<String> selectTjOrderByCardId1(); + + + @Select("SELECT a.order_id FROM tj_order_detail a WHERE a.order_id=#{orderId} AND !ISNULL(a.flowing_water_id)") + String isPayByTjNum(String orderId); } -- Gitblit v1.8.0