From d47060658f33b38688b41224bb787370547e7c7d Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期一, 20 五月 2024 17:43:12 +0800 Subject: [PATCH] zjh 2024/05/20-1 --- 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