From e8937f27fce194d015ce6c27d286e7fc89f5e580 Mon Sep 17 00:00:00 2001 From: liurunyu <lry9898@163.com> Date: 星期三, 23 四月 2025 17:29:47 +0800 Subject: [PATCH] 查询开关阀记录相关修改 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountYearMapper.java | 53 +++++++++++++++++++++++++++++++++++++++++------------ 1 files changed, 41 insertions(+), 12 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountYearMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountYearMapper.java index e75f9a5..1af5eda 100644 --- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountYearMapper.java +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountYearMapper.java @@ -1,22 +1,23 @@ package com.dy.pipIrrGlobal.daoSt; -import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.dy.pipIrrGlobal.pojoSt.StClientAmountYear; -import com.dy.pipIrrGlobal.pojoSt.StIntakeAmountYear; +import com.dy.pipIrrGlobal.voSt.VoStClientAmountYearRecord; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import java.util.List; +import java.util.Map; /** * @Author: liurunyu - * @Date: 2024/7/24 17:03 + * @Date: 2024/12/30 9:21 * @Description */ @Mapper -public interface StClientAmountYearMapper extends BaseMapper<StClientAmountYear> { +public interface StClientAmountYearMapper { /** * delete by primary key + * * @param id primaryKey * @return deleteCount */ @@ -24,6 +25,7 @@ /** * insert record to table + * * @param record the record * @return insert count */ @@ -31,6 +33,7 @@ /** * insert record to table selective + * * @param record the record * @return insert count */ @@ -38,21 +41,15 @@ /** * select by primary key + * * @param id primary key * @return object by primary key */ StClientAmountYear selectByPrimaryKey(Long id); /** - * 鏌ヨ鏌愬勾鏌愬彇姘村彛鐨勫勾鏌愰噺鍊� - * @param clientId 鍐滄埛ID - * @param year 鏌愬勾 - * @return - */ - List<StClientAmountYear> selectByClientIdAndYear(@Param("clientId")Long clientId, @Param("year")Integer year) ; - - /** * update record selective + * * @param record the updated record * @return update count */ @@ -60,8 +57,40 @@ /** * update record + * * @param record the updated record * @return update count */ int updateByPrimaryKey(StClientAmountYear record); + + + + ////////////////////////////////////// + //鏌ヨ缁熻缁撴灉 + /** + * 鏌ヨ鎬绘暟閲� + * @param params + * @return + */ + Long selectCountYearStatistics(Map<?, ?> params) ; + /** + * 鏌ヨ鍒嗛〉鏁版嵁 + * @param params + * @return + */ + List<VoStClientAmountYearRecord> selectYearStatistics(Map<?, ?> params) ; + + ////////////////////////////////////// + //缁熻鐩稿叧 + /** + * 鏌ヨ鏌愬勾 鏌愰噺鍊� + * + * @param year 鏌愬勾 + * @return + */ + List<StClientAmountYear> selectByYear(@Param("year") Integer year); + + ///////////////////////////////////// + //涓存椂浠诲姟 + int deleteAll() ; } \ No newline at end of file -- Gitblit v1.8.0