From bd1618cb6bdae1da53fd21df7afbd4962278f9c8 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期二, 13 五月 2025 14:12:38 +0800
Subject: [PATCH] zjh20250513

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerMapper.java |    9 ++++++++-
 1 files changed, 8 insertions(+), 1 deletions(-)

diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerMapper.java
index 9907aa3..217f5a4 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerMapper.java
@@ -107,5 +107,12 @@
 
     TjCustomer getCusInfo(@Param("card") String card);
 
-    List<TjCustomer> getCusInfoList(String card);
+    List<Map<String ,Object >> getCusInfoList(String card);
+
+    List<Map<String ,Object >> getCusInfoListByCardAndName(@Param("card") String card,@Param("name") String name);
+
+
+    @Select("SELECT IF(b.cus_sex=0,'鐢�','濂�') xb FROM tj_order a JOIN tj_customer b ON b.cus_id=a.user_id \n" +
+            "WHERE a.tj_number=#{tjNumber}")
+    String getSexByTjh(String tjNumber);
 }

--
Gitblit v1.8.0