From b35eae37bf2ab5cd1861bd774e56ec780ad8b116 Mon Sep 17 00:00:00 2001
From: zjh <zjh@888>
Date: 星期三, 06 三月 2024 15:09:43 +0800
Subject: [PATCH] zjh 本地 2024/03/6 --3
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 8 ++++++++
1 files changed, 8 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 1e1d449..0cdbafc 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
@@ -194,4 +194,12 @@
//瀛樺偍杩囩▼涓撶敤鎺ュ彛(鍒濆)
List<List<?>> getCsCunChuGuoChengCustomerList(Map<String,Object> map);
+
+
+ @Select("SELECT count(*) FROM tj_order a WHERE a.deleted=0 and a.card_id=#{cardId}")
+ int selectTjOrderByCardId(String cardId);
+
+
+ @Select("SELECT a.card_id FROM tj_order a WHERE a.deleted=0")
+ List<String> selectTjOrderByCardId1();
}
--
Gitblit v1.8.0