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