From c1eb35b338c6796d493d60ec12e499802b0a8072 Mon Sep 17 00:00:00 2001
From: value <z1292839451@163.com>
Date: 星期五, 14 六月 2024 08:13:22 +0800
Subject: [PATCH] 标准库导入
---
inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java | 20 ++++++++++++++++++++
inspect-server/src/main/java/com/yuanchu/mom/service/StandardTreeService.java | 3 +++
inspect-server/src/main/java/com/yuanchu/mom/controller/StandardTreeController.java | 11 ++++++++++-
3 files changed, 33 insertions(+), 1 deletions(-)
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/controller/StandardTreeController.java b/inspect-server/src/main/java/com/yuanchu/mom/controller/StandardTreeController.java
index 9952349..50f5331 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/controller/StandardTreeController.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/controller/StandardTreeController.java
@@ -14,6 +14,7 @@
import io.swagger.annotations.*;
import lombok.AllArgsConstructor;
import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
import java.util.Map;
@@ -148,8 +149,16 @@
@ValueAuth
@PostMapping("/getStandTreeBySampleType")
- @ApiModelProperty("浠呰幏鍙栧厜绾ょ殑鍨嬪彿")
+ @ApiOperation("浠呰幏鍙栧厜绾ょ殑鍨嬪彿")
public Result<?> getStandTreeBySampleType(String laboratory, String sampleType){
return Result.success(standardTreeService.getStandTreeBySampleType(laboratory, sampleType));
}
+
+ @ValueClassify("鏍囧噯搴�")
+ @ApiOperation("瀵煎叆鏍囧噯搴�")
+ @PostMapping("/inExcelOfTree")
+ public Result inExcelOfTree(@RequestParam("file") MultipartFile file){
+ standardTreeService.inExcelOfTree(file);
+ return Result.success();
+ }
}
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/StandardTreeService.java b/inspect-server/src/main/java/com/yuanchu/mom/service/StandardTreeService.java
index d82be97..f38e4bc 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/StandardTreeService.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/StandardTreeService.java
@@ -4,6 +4,7 @@
import com.yuanchu.mom.dto.FactoryDto;
import com.yuanchu.mom.dto.SampleTypeDto;
import com.yuanchu.mom.pojo.StandardTree;
+import org.springframework.web.multipart.MultipartFile;
import java.util.List;
import java.util.Map;
@@ -29,4 +30,6 @@
List<StandardTree> getStandTreeBySampleType(String laboratory, String sampleType);
+ void inExcelOfTree(MultipartFile file);
+
}
diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java
index 2db4f2a..3977838 100644
--- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java
+++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java
@@ -1,5 +1,6 @@
package com.yuanchu.mom.service.impl;
+import cn.hutool.poi.excel.ExcelUtil;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
@@ -17,7 +18,10 @@
import lombok.AllArgsConstructor;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+import org.springframework.web.multipart.MultipartFile;
+import java.io.IOException;
+import java.io.InputStream;
import java.util.List;
import java.util.Map;
@@ -126,6 +130,22 @@
.eq(StandardTree::getSampleType, sampleType)
.select(StandardTree::getModel, StandardTree::getSample));
}
+
+ @Override
+ public void inExcelOfTree(MultipartFile file) {
+ InputStream inputStream;
+ try {
+ inputStream = file.getInputStream();
+ } catch (IOException e) {
+ throw new RuntimeException(e);
+ }
+ ExcelUtil.readBySax(inputStream, 0, (i, l, list) -> {
+ System.out.println(list);
+ if (i == 0 && l >= 1) {
+
+ }
+ });
+ }
}
--
Gitblit v1.9.3