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);
|
|
/**
|
* 分页查询
|
* @param page
|
* @param queryWrapper
|
* @return
|
*/
|
IPage<EamEquipment> queryPageList(IPage<EamEquipment> page, @Param(Constants.WRAPPER) Wrapper<EamEquipment> queryWrapper);
|
|
|
/**
|
* 查询产线下得设备
|
* 没有数据权限控制
|
* @param queryWrapper
|
* @return
|
*/
|
List<EamEquipment> queryByProductionIds(@Param(Constants.WRAPPER) Wrapper<EamEquipment> queryWrapper);
|
}
|