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<EamEquipment> {
|
/**
|
* 查询产线下的设备
|
* @param productionId 产线id
|
* @return
|
*/
|
@Select("select * from eam_equipment where del_flag = 0 and org_id = #{productionId}")
|
List<EamEquipment> queryByProductionId(String productionId);
|
|
/**
|
* 查询EAM建模下的设备
|
* @param eamCenterId
|
* @return
|
*/
|
List<EamEquipment> queryByEamCenterId(String eamCenterId);
|
|
/**
|
* 分页查询
|
* @param page
|
* @param queryWrapper
|
* @return
|
*/
|
IPage<EamEquipment> queryPageList(IPage<EamEquipment> page, @Param(Constants.WRAPPER) Wrapper<EamEquipment> queryWrapper);
|
|
/**
|
* 列表查询
|
* @param queryWrapper
|
* @return
|
*/
|
List<EamEquipment> queryList(@Param(Constants.WRAPPER) Wrapper<EamEquipment> queryWrapper);
|
|
/**
|
* 获取可生成技术鉴定工单的设备列表
|
* @return
|
*/
|
List<EamEquipment> selectTechnicalEquipmentList(@Param(Constants.WRAPPER) Wrapper<EamEquipment> queryWrapper);
|
|
}
|
