package com.yuanchu.mom.mapper;
|
|
import com.yuanchu.mom.pojo.Material;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.yuanchu.mom.pojo.dto.MaterialTreeDto;
|
import org.apache.ibatis.annotations.MapKey;
|
|
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> {
|
|
@MapKey("id")
|
List<MaterialTreeDto> selectTreeByMaterial();
|
|
//根据物料名称查询物料id和物料编码
|
List<Material> selectMcodeId(String name);
|
|
//根据物料名称和物料编码查询物料id,规格信息和型号信息
|
List<Map> selectIdByCoNa(String name, String code);
|
}
|
