package com.dy.pipIrrGlobal.daoSt;
|
|
import com.dy.pipIrrGlobal.pojoSt.StClientAmountMonth;
|
import com.dy.pipIrrGlobal.voSt.VoClientAmountStatistics;
|
import com.dy.pipIrrGlobal.voSt.VoStClientAmountMonth;
|
import com.dy.pipIrrGlobal.voSt.VoStClientIdAmountYearRecord;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @Author: liurunyu
|
* @Date: 2024/12/30 8:54
|
* @Description
|
*/
|
@Mapper
|
public interface StClientAmountMonthMapper {
|
/**
|
* 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(StClientAmountMonth record);
|
|
/**
|
* insert record to table selective
|
*
|
* @param record the record
|
* @return insert count
|
*/
|
int insertSelective(StClientAmountMonth record);
|
|
/**
|
* select by primary key
|
*
|
* @param id primary key
|
* @return object by primary key
|
*/
|
StClientAmountMonth selectByPrimaryKey(Long id);
|
|
/**
|
* update record selective
|
*
|
* @param record the updated record
|
* @return update count
|
*/
|
int updateByPrimaryKeySelective(StClientAmountMonth record);
|
|
/**
|
* update record
|
*
|
* @param record the updated record
|
* @return update count
|
*/
|
int updateByPrimaryKey(StClientAmountMonth record);
|
|
|
|
//////////////////////////////////////
|
//查询统计结果
|
/**
|
* 查询总数量
|
* @param params
|
* @return
|
*/
|
Long selectCountMonthStatistics(Map<?, ?> params) ;
|
|
List<VoStClientIdAmountYearRecord> selectClientIds4MonthStatistics(Map<?, ?> params) ;
|
|
/**
|
* 查询分页数据
|
* @param params
|
* @return
|
*/
|
List<VoStClientAmountMonth> selectMonthStatistics(Map<?, ?> params) ;
|
|
//////////////////////////////////////
|
//统计相关
|
/**
|
* 查询某年某月 量值
|
*
|
* @param year 某年
|
* @return
|
*/
|
List<StClientAmountMonth> selectByYear(@Param("year") Integer year);
|
|
/**
|
* 以农户维度统计用水量及费用
|
*
|
* @param year 统计年度
|
* @return
|
*/
|
List<VoClientAmountStatistics> statisticsByClient(Integer year);
|
|
|
//////////////////////////////////////
|
//临时任务相关
|
/**
|
* 删除全部
|
* @return
|
*/
|
int deleteAll() ;
|
|
}
|
