New file |
| | |
| | | package com.dy.pipIrrGlobal.daoTmp; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.dy.pipIrrGlobal.pojoRm.RmIntakeAmountDay; |
| | | import com.dy.pipIrrGlobal.pojoSt.StIntakeAmountMonth; |
| | | import com.dy.pipIrrGlobal.pojoSt.StIntakeAmountYear; |
| | | import com.dy.pipIrrGlobal.voSt.VoIntake; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | | /** |
| | | * @Author: liurunyu |
| | | * @Date: 2024/12/14 09:27 |
| | | * @Description |
| | | */ |
| | | @Mapper |
| | | public interface ChangeMapper extends BaseMapper<Object> { |
| | | |
| | | /** |
| | | * 查询全部取水口 |
| | | * |
| | | * @return 实体集合 |
| | | */ |
| | | List<VoIntake> selectAllPrIntakes(); |
| | | |
| | | /** |
| | | * 查询一个取水口的日用水量统计记录 |
| | | * |
| | | * @return 实体集合 |
| | | */ |
| | | List<RmIntakeAmountDay> selectOneIntakeAllAmountDay(@Param("intakeId")Long intakeId); |
| | | |
| | | /** |
| | | * 更新一个取水口的日用水量统计 |
| | | * |
| | | * @return 影响实体数 |
| | | */ |
| | | int updateOneIntakeAmountDay(@Param("id")Long id, @Param("amount")Double amount); |
| | | |
| | | |
| | | |
| | | |
| | | /** |
| | | * 删除所有取水口的月用水量统计 |
| | | * @return 影响实体数 |
| | | */ |
| | | int deleteAllIntakeAmountMonth(); |
| | | |
| | | |
| | | /** |
| | | * 统计所有取水口的月用水量 |
| | | * @return 实体集合 |
| | | */ |
| | | List<StIntakeAmountMonth> statisticAllIntakeAmountMonthFromAmountDay(@Param("startDt")Date startDt, |
| | | @Param("endDt")Date endDt); |
| | | /** |
| | | * 保存取水口的月用水量统计 |
| | | * @return 影响实体数 |
| | | */ |
| | | int saveOneIntakeAmountMonth(StIntakeAmountMonth pojo); |
| | | |
| | | |
| | | |
| | | |
| | | /** |
| | | * 删除所有取水口的年用水量统计 |
| | | * @return 影响实体数 |
| | | */ |
| | | int deleteAllIntakeAmountYear(); |
| | | |
| | | |
| | | /** |
| | | * 统计所有取水口的年用水量 |
| | | * @return 实体集合 |
| | | */ |
| | | List<StIntakeAmountYear> statisticAllIntakeAmountYearFromAmountDay(@Param("startDt")Date startDt, |
| | | @Param("endDt")Date endDt); |
| | | /** |
| | | * 保存取水口的月用水量统计 |
| | | * @return 影响实体数 |
| | | */ |
| | | int saveOneIntakeAmountYear(StIntakeAmountYear pojo); |
| | | |
| | | |
| | | } |