From 51dab03d03a4f3f671a64c3660c42e5241357c9b Mon Sep 17 00:00:00 2001 From: Administrator <zhubaomin> Date: 星期四, 28 十二月 2023 15:30:57 +0800 Subject: [PATCH] 2023-12-28 朱宝民 根据水卡编号获取操作记录,重构农户查询,返回23个字段 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientCardMapper.java | 33 ++++++++++++++++++++++++++++++--- 1 files changed, 30 insertions(+), 3 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 6f16c9a..97dfd57 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,17 +1,23 @@ package com.dy.pipIrrGlobal.daoSe; +import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.dy.pipIrrGlobal.pojoSe.SeClientCard; +import com.dy.pipIrrGlobal.voSe.VoCardInfo; +import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; +import java.util.List; import java.util.Map; /** * @author ZhuBaoMin - * @date 2023/12/18 16:26 - * @LastEditTime 2023/12/18 16:26 + * @date 2023/12/22 16:04 + * @LastEditTime 2023/12/22 16:04 * @Description */ -public interface SeClientCardMapper { + +@Mapper +public interface SeClientCardMapper extends BaseMapper<SeClientCard> { int deleteByPrimaryKey(Long id); int insert(SeClientCard record); @@ -51,4 +57,25 @@ * @return */ Map getCardIdAndClientNum(@Param("cardNum") String cardNum); + + /** + * 鏍规嵁鍐滄埛涓婚敭鑾峰彇姘村崱鍒楄〃 + * @param clientId + * @return + */ + List<VoCardInfo> getCardInfoByClientId(@Param("clientId") Long clientId); + + /** + * 鏍规嵁姘村崱缂栧彿鑾峰彇鎿嶄綔璁板綍鍒楄〃 + * @param cardNum 姘村崱缂栧彿 + * @return 姘村崱鎿嶄綔璁板綍鍒楄〃 + */ + List<Map<String, Object>> getOperateRecordsByCardNum(@Param("cardNum") Long cardNum); + + /** + * 鏍规嵁姘村崱缂栧彿鑾峰彇浣欓 + * @param cardNum 姘村崱缂栧彿 + * @return 浣欓 + */ + Float getMoneyByCardNum(@Param("cardNum") Long cardNum); } \ No newline at end of file -- Gitblit v1.8.0