物料编码字典查询

whycxzp

2022-08-15 7ae1c7638e3d7707d710dcd1406582891b47853b

物料编码字典查询

 src/main/java/com/whyc/controller/MaterialCodeDictionaryController.java

@@ -1,5 +1,7 @@
package com.whyc.controller;

import com.github.pagehelper.PageInfo;
import com.whyc.dto.Response;
import com.whyc.pojo.MaterialCodeDictionary;
import com.whyc.service.MaterialCodeDictionaryService;
import io.swagger.annotations.Api;
@@ -9,8 +11,10 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import java.io.File;
import java.io.IOException;
import java.util.LinkedList;
@@ -24,6 +28,13 @@
    @Autowired
    private MaterialCodeDictionaryService service;

    @GetMapping("codeList")
    @ApiOperation(value = "查询编码列表分页",notes = "level:0(查询所有),1(一级编码),2(二级编码)")
    public Response<PageInfo<MaterialCodeDictionary>> getCodeList(@RequestParam int pageNum,@RequestParam int pageSize,@RequestParam int level){
        PageInfo<MaterialCodeDictionary> codeList = service.getCodeList(pageNum, pageSize, level);
        return new Response<PageInfo<MaterialCodeDictionary>>().set(1,codeList);
    }

    //解析导入数据,只使用一次
    @Deprecated
    @GetMapping("importData")

 src/main/java/com/whyc/service/MaterialCodeDictionaryService.java

@@ -1,5 +1,9 @@
package com.whyc.service;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.whyc.mapper.MaterialCodeDictionaryMapper;
import com.whyc.pojo.MaterialCodeDictionary;
import org.springframework.stereotype.Service;
@@ -17,4 +21,16 @@
    public void insertBatch(List<MaterialCodeDictionary> list) {
        mapper.insertBatchSomeColumn(list);
    }

    public PageInfo<MaterialCodeDictionary> getCodeList(int pageNum, int pageSize, int level) {
        PageHelper.startPage(pageNum,pageSize);
        QueryWrapper<MaterialCodeDictionary> query = Wrappers.query();
        if(level==1){
            query.eq("parent_code","0");
        }else if(level==2){
            query.ne("parent_code","0");
        }
        List<MaterialCodeDictionary> materialCodeDictionaries = mapper.selectList(query);
        return new PageInfo<MaterialCodeDictionary>(materialCodeDictionaries);
    }
}