package org.jeecg.modules.eam.mapper; import com.baomidou.mybatisplus.core.conditions.Wrapper; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.Constants; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; import org.jeecg.modules.eam.entity.EamEquipment; import java.util.List; /** * @Description: 设备台账 * @Author: jeecg-boot * @Date: 2025-03-19 * @Version: V1.0 */ public interface EamEquipmentMapper extends BaseMapper { /** * 查询产线下的设备 * @param productionId 产线id * @return */ @Select("select * from eam_equipment where del_flag = 0 and org_id = #{productionId}") List queryByProductionId(String productionId); /** * 查询EAM建模下的设备 * @param eamCenterId * @return */ List queryByEamCenterId(String eamCenterId); /** * 分页查询 * @param page * @param queryWrapper * @return */ IPage queryPageList(IPage page, @Param(Constants.WRAPPER) Wrapper queryWrapper); /** * 列表查询 * @param queryWrapper * @return */ List queryList(@Param(Constants.WRAPPER) Wrapper queryWrapper); /** * 获取可生成技术鉴定工单的设备列表 * @return */ List selectTechnicalEquipmentList(@Param(Constants.WRAPPER) Wrapper queryWrapper); }