pipIrr-SV.git - Gitblit

New file
			@@ -0,0 +1,87 @@
			package com.dy.pipIrrGlobal.daoSt;

			import com.baomidou.mybatisplus.core.mapper.BaseMapper;
			import com.dy.pipIrrGlobal.pojoSt.StClientAmountDay;
			import org.apache.ibatis.annotations.Mapper;
			import org.apache.ibatis.annotations.Param;

			import java.util.List;

			/**
			* @Author: liurunyu
			* @Date: 2024/12/28 11:58
			* @Description
			*/
			@Mapper
			public interface StClientAmountDayMapper extends BaseMapper<StClientAmountDay> {
			/**
			* delete by primary key
			*
			* @param id primaryKey
			* @return deleteCount
			*/
			int deleteByPrimaryKey(Long id);

			/**
			* insert record to table
			*
			* @param record the record
			* @return insert count
			*/
			int insert(StClientAmountDay record);

			/**
			* insert record to table selective
			*
			* @param record the record
			* @return insert count
			*/
			int insertSelective(StClientAmountDay record);

			/**
			* select by primary key
			*
			* @param id primary key
			* @return object by primary key
			*/
			StClientAmountDay selectByPrimaryKey(Long id);

			/**
			* update record selective
			*
			* @param record the updated record
			* @return update count
			*/
			int updateByPrimaryKeySelective(StClientAmountDay record);

			/**
			* update record
			*
			* @param record the updated record
			* @return update count
			*/
			int updateByPrimaryKey(StClientAmountDay record);


			//////////////////////////////////////
			//统计相关
			/**
			* 查询用水户一个月所有日的用水量
			* @param clientId
			* @param year
			* @param month
			* @return
			*/
			List<StClientAmountDay> selectByClientIdAndYearAndMonthAndDay(@Param("clientId")Long clientId,
			@Param("year")Integer year,
			@Param("month")Integer month) ;

			//////////////////////////////////////
			//临时任务相关

			/**
			* 删除全部
			* @return
			*/
			int deleteAll() ;
			}