From ea91e62004a5a86be6c7a5fda852995e1bf3e3a0 Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期五, 23 五月 2025 18:55:36 +0800 Subject: [PATCH] zjh20250523 --- 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..920fa05 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,'0','1') 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