From f0cb85eddfb1e36afd3af04ee379cf5040a49b8a Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期六, 14 六月 2025 18:09:44 +0800
Subject: [PATCH] 编辑多个和单个图片上传，删除图片
---
src/main/java/com/whyc/service/BomAcceptanceService.java | 71 +++++++++++++++++++++++++++++++++++
src/main/java/com/whyc/controller/BomAcceptanceController.java | 8 ++++
2 files changed, 78 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/whyc/controller/BomAcceptanceController.java b/src/main/java/com/whyc/controller/BomAcceptanceController.java
index a882803..74603ab 100644
--- a/src/main/java/com/whyc/controller/BomAcceptanceController.java
+++ b/src/main/java/com/whyc/controller/BomAcceptanceController.java
@@ -13,6 +13,8 @@
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;
@@ -70,4 +72,10 @@
service.delPic(num,picNum,picUrl,"");
return new Response().set(1,true,"鍒犻櫎鍥炬垚鍔�");
}
+
+ @ApiOperation(value = "瀵煎嚭浜у搧楠屾敹淇℃伅")
+ @GetMapping("downloadBomAcceptance")
+ public void downloadBomAcceptance(HttpServletRequest req, HttpServletResponse resp, @RequestParam int num){
+ service.downloadBomAcceptance(req,resp,num);
+ }
}
\ No newline at end of file
diff --git a/src/main/java/com/whyc/service/BomAcceptanceService.java b/src/main/java/com/whyc/service/BomAcceptanceService.java
index 159f737..dd12aff 100644
--- a/src/main/java/com/whyc/service/BomAcceptanceService.java
+++ b/src/main/java/com/whyc/service/BomAcceptanceService.java
@@ -9,13 +9,18 @@
import com.whyc.pojo.BOMFeedback;
import com.whyc.pojo.BomAcceptance;
import com.whyc.pojo.DefectiveProducts;
+import com.whyc.pojo.ProductHistory;
import com.whyc.util.ActionUtil;
import com.whyc.util.CommonUtil;
import com.whyc.util.FileUtil;
+import org.apache.poi.hssf.usermodel.*;
+import org.apache.poi.ss.usermodel.IndexedColors;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.web.multipart.MultipartFile;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.IOException;
import java.util.Date;
@@ -163,7 +168,38 @@
public Response updateBomAcceptance(BomAcceptance bomAcceptance) {
UpdateWrapper wrapper=new UpdateWrapper();
wrapper.eq("num",bomAcceptance.getNum());
- mapper.update(bomAcceptance,wrapper);
+ if(bomAcceptance.getDirectName()!=null){
+ wrapper.set("direct_name",bomAcceptance.getDirectName());
+ }
+ if(bomAcceptance.getBomSeries()!=null){
+ wrapper.set("bom_series",bomAcceptance.getBomSeries());
+ }
+ if(bomAcceptance.getBomModel()!=null){
+ wrapper.set("bom_model",bomAcceptance.getBomModel());
+ }
+ if(bomAcceptance.getDevParam()!=null){
+ wrapper.set("dev_param",bomAcceptance.getDevParam());
+ }
+ if(bomAcceptance.getStandParam()!=null){
+ wrapper.set("stand_param",bomAcceptance.getStandParam());
+ }
+ if(bomAcceptance.getBomSize()!=null){
+ wrapper.set("bom_size",bomAcceptance.getBomSize());
+ }
+ if(bomAcceptance.getDevWeight()!=null){
+ wrapper.set("dev_weight",bomAcceptance.getDevWeight());
+ }
+ if(bomAcceptance.getDevWeightAll()!=null){
+ wrapper.set("dev_weight_all",bomAcceptance.getDevWeightAll());
+ }
+ if(bomAcceptance.getSparePartmodel()!=null){
+ wrapper.set("spare_partmodel",bomAcceptance.getSparePartmodel());
+ }
+ if(bomAcceptance.getBomVersion()!=null){
+ wrapper.set("bom_version",bomAcceptance.getBomVersion());
+ }
+
+ mapper.update(null,wrapper);
return new Response().set(1,true,"缂栬緫鎴愬姛");
}
//鍒犻櫎鍥�
@@ -241,4 +277,37 @@
return new Response().set(1,false,"鍥剧墖涓嶅瓨鍦�");
}
}
+ //瀵煎嚭浜у搧楠屾敹淇℃伅
+ public void downloadBomAcceptance(HttpServletRequest req, HttpServletResponse resp, int num) {
+ //璇诲彇浜у搧淇℃伅
+ QueryWrapper wrapper=new QueryWrapper();
+ wrapper.eq("num",num);
+ wrapper.last("limit 1");
+ BomAcceptance bomAcceptance=mapper.selectOne(wrapper);
+ //鐢熸垚excel
+ creatBomAcceptanceExcel(req,resp,bomAcceptance);
+ }
+ //鐢熸垚excel
+ private void creatBomAcceptanceExcel(HttpServletRequest req, HttpServletResponse resp, BomAcceptance bomAcceptance) {
+ //鍒涘缓鍗曚釜sheet
+ HSSFWorkbook wb = new HSSFWorkbook();
+ //瀛椾綋鏍煎紡-鍔犵矖
+ HSSFCellStyle cellStyle = wb.createCellStyle();
+ cellStyle.setFillForegroundColor(IndexedColors.GOLD.getIndex());//娣诲姞鍓嶆櫙鑹�,鍐呭鐪嬬殑娓呮
+ cellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
+ HSSFFont font = wb.createFont();
+ font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
+ cellStyle.setFont(font);
+ HSSFSheet sheet = wb.createSheet("浜у搧楠屾敹淇℃伅璁板綍");
+ sheet.setColumnWidth(1,10000);
+ sheet.setDefaultRowHeight((short)(1000));
+ //鍥剧墖鍏冪礌
+ HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
+ HSSFRow row=sheet.createRow(1);
+ HSSFCell cell=row.createCell(0);
+ cell=row.createCell(0);
+ cell.setCellValue("浜у搧楠屾敹淇℃伅璁板綍");
+ cell.setCellStyle(cellStyle);
+ }
+
}
\ No newline at end of file
--
Gitblit v1.9.1