package com.javaweb.geo.mapper;

import com.javaweb.geo.domain.Hole;
import java.util.List;

import org.apache.ibatis.annotations.Param;

/**
 * 钻孔Mapper接口
 * 
 * @author zmk
 * @date 2022-10-20
 */
public interface HoleMapper 
{
    /**
     * 查询钻孔
     * 
     * @param ids 钻孔ID
     * @return 钻孔
     */
    public Hole selectHoleById(String ids);

    /**
     * 查询钻孔数量
     * @param projectId
     * @return
     */
    public int selectHoleNumByProjectId(@Param("projectId") String projectId);
    
    /**
     * 根据序列号查找
     * @return
     */
    public Hole selectHoleBySerNum(@Param("projectId") String projectId,@Param("code") String code);

    /**
     * 查询钻孔列表
     * 
     * @param hole 钻孔
     * @return 钻孔集合
     */
    public List<Hole> selectHoleList(Hole hole);

    /**
     * 新增钻孔
     * 
     * @param hole 钻孔
     * @return 结果
     */
    public int insertHole(Hole hole);

    /**
     * 修改钻孔
     * 
     * @param hole 钻孔
     * @return 结果
     */
    public int updateHole(Hole hole);

    /**
     * 删除钻孔
     * 
     * @param ids 钻孔ID
     * @return 结果
     */
    public int deleteHoleById(String ids);

    /**
     * 批量删除钻孔
     * 
     * @param idss 需要删除的数据ID
     * @return 结果
     */
    public int deleteHoleByIds(String[] idss);

    public  Long selectHoleNum();

    public Long selectAllHoleNum();

    public List<Hole> selectHoleListByFlag0();

    public List<Hole> selectHoleByProjectId(@Param("projectId") String projectId);

    public  Hole selectHoleTotalProcess();

    public Hole selectProjectProcess(@Param("projectId") String projectId);

    public List<Hole> selectHoleProjectProcess();
}