package com.javaweb.platform.mapper;

import com.javaweb.platform.domain.ProjectApplyHole;
import java.util.List;

/**
 * 钻孔申请记录表Mapper接口
 * 
 * @author zmk
 * @date 2022-03-25
 */
public interface ProjectApplyHoleMapper 
{
    /**
     * 查询钻孔申请记录表
     * 
     * @param id 钻孔申请记录表ID
     * @return 钻孔申请记录表
     */
    public ProjectApplyHole selectProjectApplyHoleById(String id);

    /**
     * 查询钻孔申请记录表列表
     * 
     * @param projectApplyHole 钻孔申请记录表
     * @return 钻孔申请记录表集合
     */
    public List<ProjectApplyHole> selectProjectApplyHoleList(ProjectApplyHole projectApplyHole);
    
    
    
    /**
     * 查找记录 join  hole_info
     * @param projectApplyHole
     * @return
     */
    public List<ProjectApplyHole> selectProjectApplyHoleListJoinHoleInfo(ProjectApplyHole projectApplyHole);

    /**
     * 新增钻孔申请记录表
     * 
     * @param projectApplyHole 钻孔申请记录表
     * @return 结果
     */
    public int insertProjectApplyHole(ProjectApplyHole projectApplyHole);

    /**
     * 修改钻孔申请记录表
     * 
     * @param projectApplyHole 钻孔申请记录表
     * @return 结果
     */
    public int updateProjectApplyHole(ProjectApplyHole projectApplyHole);

    /**
     * 删除钻孔申请记录表
     * 
     * @param id 钻孔申请记录表ID
     * @return 结果
     */
    public int deleteProjectApplyHoleById(String id);

    /**
     * 批量删除钻孔申请记录表
     * 
     * @param ids 需要删除的数据ID
     * @return 结果
     */
    public int deleteProjectApplyHoleByIds(String[] ids);
    
    /**
     * 更新状态
     * @param projectApplyHole
     * @return
     */
    public int updateProjectApplyStatus(ProjectApplyHole projectApplyHole);
}