package com.ruoyi.web.modules.industryservice.mapper;

import java.util.List;
import org.apache.ibatis.annotations.Param;
import com.ruoyi.web.modules.industryservice.domain.BizFarmerHousehold;

/**
 * 农牧户数据填报 Mapper
 */
public interface BizFarmerHouseholdMapper
{
    BizFarmerHousehold selectBizFarmerHouseholdById(Long id);

    int countByYearMonthAndVillageExcludeId(@Param("statYear") Integer statYear,
            @Param("statMonth") Integer statMonth, @Param("villageDeptId") Long villageDeptId,
            @Param("excludeId") Long excludeId);

    BizFarmerHousehold selectByYearMonthAndVillage(@Param("statYear") Integer statYear,
            @Param("statMonth") Integer statMonth, @Param("villageDeptId") Long villageDeptId);

    List<BizFarmerHousehold> selectBizFarmerHouseholdList(BizFarmerHousehold query);

    int insertBizFarmerHousehold(BizFarmerHousehold row);

    int updateBizFarmerHousehold(BizFarmerHousehold row);

    int deleteBizFarmerHouseholdByIds(@Param("ids") Long[] ids);
}
