| package com.dy.pipIrrGlobal.daoSt; | 
|   | 
| import com.baomidou.mybatisplus.core.mapper.BaseMapper; | 
| import com.dy.pipIrrGlobal.pojoSt.StIntakeAmountYear; | 
| import com.dy.pipIrrGlobal.pojoSt.StLossYear; | 
| import org.apache.ibatis.annotations.Mapper; | 
| import org.apache.ibatis.annotations.Param; | 
|   | 
| import java.util.List; | 
|   | 
| /** | 
|  * @Author: liurunyu | 
|  * @Date: 2024/7/24 16:38 | 
|  * @Description | 
|  */ | 
| @Mapper | 
| public interface StIntakeAmountYearMapper extends BaseMapper<StIntakeAmountYear> { | 
|     /** | 
|      * 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(StIntakeAmountYear record); | 
|   | 
|     /** | 
|      * insert record to table selective | 
|      * @param record the record | 
|      * @return insert count | 
|      */ | 
|     int insertSelective(StIntakeAmountYear record); | 
|   | 
|     /** | 
|      * select by primary key | 
|      * @param id primary key | 
|      * @return object by primary key | 
|      */ | 
|     StIntakeAmountYear selectByPrimaryKey(Long id); | 
|   | 
|     /** | 
|      * 查询某年某取水口的年某量值 | 
|      * @param intakeId 取水ID | 
|      * @param year 某年 | 
|      * @return | 
|      */ | 
|     List<StIntakeAmountYear> selectByIntakeIdAndYear(@Param("intakeId")Long intakeId, @Param("year")Integer year) ; | 
|   | 
|     /** | 
|      * update record selective | 
|      * @param record the updated record | 
|      * @return update count | 
|      */ | 
|     int updateByPrimaryKeySelective(StIntakeAmountYear record); | 
|   | 
|     /** | 
|      * update record | 
|      * @param record the updated record | 
|      * @return update count | 
|      */ | 
|     int updateByPrimaryKey(StIntakeAmountYear record); | 
| } |