pipIrr-SV.git - Gitblit

			@@ -1,18 +1,23 @@
			package com.dy.pipIrrGlobal.daoSt;

			import com.baomidou.mybatisplus.core.mapper.BaseMapper;
			import com.dy.pipIrrGlobal.pojoSt.StClientAmountYear;
			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
			*/
			@@ -20,6 +25,7 @@

			/**
			* insert record to table
			*
			* @param record the record
			* @return insert count
			*/
			@@ -27,6 +33,7 @@

			/**
			* insert record to table selective
			*
			* @param record the record
			* @return insert count
			*/
			@@ -34,6 +41,7 @@

			/**
			* select by primary key
			*
			* @param id primary key
			* @return object by primary key
			*/
			@@ -41,6 +49,7 @@

			/**
			* update record selective
			*
			* @param record the updated record
			* @return update count
			*/
			@@ -48,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() ;
			}