|  |  | 
 |  |  | 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 | 
 |  |  |      */ | 
 |  |  | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * insert record to table | 
 |  |  |      * | 
 |  |  |      * @param record the record | 
 |  |  |      * @return insert count | 
 |  |  |      */ | 
 |  |  | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * insert record to table selective | 
 |  |  |      * | 
 |  |  |      * @param record the record | 
 |  |  |      * @return insert count | 
 |  |  |      */ | 
 |  |  | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * select by primary key | 
 |  |  |      * | 
 |  |  |      * @param id primary key | 
 |  |  |      * @return object by primary key | 
 |  |  |      */ | 
 |  |  |     StClientAmountYear selectByPrimaryKey(Long id); | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 查询某年某取水口的年某量值 | 
 |  |  |      * @param clientId 农户ID | 
 |  |  |      * @param year 某年 | 
 |  |  |      * @return | 
 |  |  |      */ | 
 |  |  |     StClientAmountYear selectByClientIdAndYear(@Param("clientId")Long clientId, @Param("year")Integer year) ; | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * update record selective | 
 |  |  |      * | 
 |  |  |      * @param record the updated record | 
 |  |  |      * @return update count | 
 |  |  |      */ | 
 |  |  | 
 |  |  |  | 
 |  |  |     /** | 
 |  |  |      * 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() ; | 
 |  |  | } |