'lxw'

he wei

2022-09-03 a6d9890f25fa81ec3163155e33203ffeb84169c3

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

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

import com.whyc.pojo.ComponentApproving;
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;
@@ -10,11 +11,12 @@
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.Date;
import java.util.LinkedList;
import java.util.List;

@@ -26,9 +28,16 @@
    @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")
    @ApiOperation("导入数据")
    public void  importData() throws IOException, InvalidFormatException {
        List<MaterialCodeDictionary> list = new LinkedList<>();
        File fileTemp = new File("C:\\Users\\29550\\Desktop\\当前项目\\202207图纸管理\\物料类别(1).xlsx");