From e763f8274af31b5240776d699d7d6077bf9a320e Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期五, 24 五月 2024 18:11:39 +0800
Subject: [PATCH] 导检单生产工具类
---
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..f323916 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) GROUP BY a.order_id ")
+ String isPayByTjNum(String orderId);
}
--
Gitblit v1.8.0