From db9aadf9df7d875aec7da5ab957fbd2e87557fcc Mon Sep 17 00:00:00 2001 From: Administrator <zhubaomin> Date: 星期三, 20 十二月 2023 18:17:42 +0800 Subject: [PATCH] 2023-12-20 朱宝民 dao优化 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java | 34 ++++++++++++++++++++++++++++++---- 1 files changed, 30 insertions(+), 4 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java index 0e75827..aaa7433 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java @@ -1,15 +1,21 @@ package com.dy.pipIrrGlobal.daoSe; +import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.dy.pipIrrGlobal.pojoSe.SeClientCard; +import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; + +import java.util.Map; /** * @author ZhuBaoMin - * @date 2023/12/7 9:06 - * @LastEditTime 2023/12/7 9:06 + * @date 2023/12/18 16:26 + * @LastEditTime 2023/12/18 16:26 * @Description */ -public interface SeClientCardMapper { + +@Mapper +public interface SeClientCardMapper extends BaseMapper<SeClientCard> { int deleteByPrimaryKey(Long id); int insert(SeClientCard record); @@ -23,10 +29,30 @@ int updateByPrimaryKey(SeClientCard record); /** - * 渚濇嵁姘村崱鍦板潃鑾峰彇姘村崱缂栧彿锛堜富閿級 + * 渚濇嵁姘村崱鍦板潃鑾峰彇姘村崱缂栧彿锛�12鏈�19鏃ュ簾寮冿級 * @param cardAddr * @return */ Long getCardIdByAddr(@Param("cardAddr") String cardAddr); + /** + * 鏍规嵁姘村崱缂栧彿鑾峰彇姘村崱琛ㄤ富閿紙12鏈�19鏃ユ坊鍔犲悗搴熷純锛� + * @param cardNum 16浣嶆按鍗$紪鍙� + * @return 姘村崱琛ㄤ富閿� + */ + Long getCardIdByNum(@Param("cardNum") String cardNum); + + /** + * 鏍规嵁琛屾斂鍖哄垝涓叉ā鍧楁煡璇㈡按鍗$紪鍙� + * @param areaCode + * @return + */ + String getCardNumOfMax(@Param("areaCode") String areaCode); + + /** + * 鏍规嵁姘村崱缂栧彿鑾峰彇姘村崱琛ㄤ富閿強鍐滄埛缂栧彿 + * @param cardNum + * @return + */ + Map getCardIdAndClientNum(@Param("cardNum") String cardNum); } \ No newline at end of file -- Gitblit v1.8.0