package com.aps.core.mapper;

import com.aps.core.domain.ApsPlate.ApsPlatePlan;
import com.aps.core.domain.ApsPlate.ApsPlateStandardRequireBomOrderDetail;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * ApsPlateStandardRequireBomOrderDetailMapper接口
 * 
 * @author zhl
 * @date 2025-05-06
 */
@Mapper
public interface ApsPlateStandardRequireBomOrderDetailMapper 
{
    /**
     * 查询ApsPlateStandardRequireBomOrderDetail
     * 
     * @param id ApsPlateStandardRequireBomOrderDetail主键
     * @return ApsPlateStandardRequireBomOrderDetail
     */
    public ApsPlateStandardRequireBomOrderDetail selectApsPlateStandardRequireBomOrderDetailById(Long id);

    /**
     * 查询ApsPlateStandardRequireBomOrderDetail列表
     * 
     * @param apsPlateStandardRequireBomOrderDetail ApsPlateStandardRequireBomOrderDetail
     * @return ApsPlateStandardRequireBomOrderDetail集合
     */
    public List<ApsPlateStandardRequireBomOrderDetail> selectApsPlateStandardRequireBomOrderDetailList(ApsPlateStandardRequireBomOrderDetail apsPlateStandardRequireBomOrderDetail);

    /**
     * 新增ApsPlateStandardRequireBomOrderDetail
     * 
     * @param apsPlateStandardRequireBomOrderDetail ApsPlateStandardRequireBomOrderDetail
     * @return 结果
     */
    public int insertApsPlateStandardRequireBomOrderDetail(ApsPlateStandardRequireBomOrderDetail apsPlateStandardRequireBomOrderDetail);

    /**
     * 修改ApsPlateStandardRequireBomOrderDetail
     * 
     * @param apsPlateStandardRequireBomOrderDetail ApsPlateStandardRequireBomOrderDetail
     * @return 结果
     */
    public int updateApsPlateStandardRequireBomOrderDetail(ApsPlateStandardRequireBomOrderDetail apsPlateStandardRequireBomOrderDetail);

    /**
     * 删除ApsPlateStandardRequireBomOrderDetail
     * 
     * @param id ApsPlateStandardRequireBomOrderDetail主键
     * @return 结果
     */
    public int deleteApsPlateStandardRequireBomOrderDetailById(Long id);

    /**
     * 批量删除ApsPlateStandardRequireBomOrderDetail
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteApsPlateStandardRequireBomOrderDetailByIds(Long[] ids);

    int deleteLastPatch(String batchNumber);

    int batchInsert(List<ApsPlateStandardRequireBomOrderDetail> list);

    /**
     * 根据需求ID查询其上阶及下阶数据
     * */
    List<ApsPlatePlan> selectRequireUpAndDownLevel(Long requireId);
}