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);
|
|
//根据标准id查询物料
|
Material selFath(Integer id);
|
}
|
