hyingbo
3 天以前 6da57b610d97be3f79084d43440e7823d707b249
lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/mapper/EamEquipmentMapper.java
@@ -1,7 +1,16 @@
package org.jeecg.modules.eam.mapper;
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
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 org.jeecg.modules.system.entity.SysCategory;
import java.util.List;
/**
 * @Description: 设备台账
@@ -10,5 +19,26 @@
 * @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);
    @InterceptorIgnore(
            tenantLine = "true",   // 忽略多租户条件
            blockAttack = "true", // 绕过全表操作检查
            illegalSql = "true"   // 禁用 SQL 注入检查
    )
    List<SysCategory> getCategoryTypeMap();
}