package com.yuanchu.mom.mapper;

import com.yuanchu.mom.pojo.Material;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.List;
import java.util.Map;

/**
* @author Administrator
* @description 针对表【material】的数据库操作Mapper
* @createDate 2023-07-26 15:52:50
* @Entity com.yuanchu.mom.pojo.Material
*/

public interface MaterialMapper extends BaseMapper<Material> {


    //标准MOM-->左侧五级树展示
    List<Map<String,Object>> selectTreeByMaterial();

    //根据物料名称查询物料id和物料编码
    List<Material> selectMcodeId(String name);

    //根据物料名称和物料编码查询物料id,规格信息和型号信息
    List<Map> selectIdByCoNa(String name, String code);
}