From f2162e182405184e14bfa8d628150ccc49318fc3 Mon Sep 17 00:00:00 2001 From: zhaowenxuan <chacca165@163.com> Date: 星期一, 19 五月 2025 17:11:54 +0800 Subject: [PATCH] 总检页面增加体检类型搜索调整了存储过程 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerBlackMapper.java | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerBlackMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerBlackMapper.java index 4d4c08e..290e89b 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerBlackMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjCustomerBlackMapper.java @@ -3,7 +3,11 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.ltkj.hosp.domain.TjCustomerBlack; import org.apache.ibatis.annotations.Mapper; +import org.apache.ibatis.annotations.Select; @Mapper public interface TjCustomerBlackMapper extends BaseMapper<TjCustomerBlack> { + + @Select("SELECT * FROM tj_customer_black a WHERE a.cus_id=#{cusId} AND a.is_expiration='N'") + TjCustomerBlack isTjCustomerBlack(String cusId); } -- Gitblit v1.8.0