From 2d3a029eb2efbedb515e098c97a4d230eacedc26 Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期三, 05 七月 2023 10:25:34 +0800
Subject: [PATCH] 增加版本校验
---
src/main/java/com/whyc/service/SOPService.java | 17 ++++++++++++++---
1 files changed, 14 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/whyc/service/SOPService.java b/src/main/java/com/whyc/service/SOPService.java
index 11c44d8..f31e35c 100644
--- a/src/main/java/com/whyc/service/SOPService.java
+++ b/src/main/java/com/whyc/service/SOPService.java
@@ -57,7 +57,8 @@
Sheet sheet = workbook.getSheetAt(0);
int lastRowNum = sheet.getLastRowNum();
//鏂囦欢鍚�
- sop.setFileName(sheet.getRow(2).getCell(2).getStringCellValue().trim());
+ String fileName = sheet.getRow(2).getCell(2).getStringCellValue().trim();
+ sop.setFileName(fileName);
//涓嬮潰鐨剅ow鏄姩鎬佺殑,鍥犱负鏂囦欢绫诲瀷鐨勮鏁版槸鍔ㄦ�佹嫇灞曠殑
//閿氱偣:鏂囦欢鐗堟湰
int fileVersionIndex = 0;
@@ -234,8 +235,18 @@
sop.setFileTypeList(fileTypeList);
sop.setFileType(fileTypeSb.toString());
-
- sop.setFileVersion(sheet.getRow(fileVersionIndex).getCell(2).getStringCellValue());
+ //鏍￠獙鏂囦欢鐗堟湰鏄惁宸茬粡瀛樺湪
+ String fileVersion = sheet.getRow(fileVersionIndex).getCell(2).getStringCellValue().trim();
+ QueryWrapper<SOP> query = Wrappers.query();
+ query.select("file_version").eq("file_name",fileName);
+ List<SOP> sopListExists = mapper.selectList(query);
+ for (int i = 0; i < sopListExists.size(); i++) {
+ SOP sopExists = sopListExists.get(i);
+ if(sopExists.getFileVersion().equals(fileVersion)){
+ return new Response().set(1,false,"鏂囦欢鐗堟湰宸插瓨鍦�,璇风‘璁OP鐗堟湰鏄惁姝ｇ‘!");
+ }
+ }
+ sop.setFileVersion(fileVersion);
sop.setFileRelatedVersion(sheet.getRow(fileVersionIndex).getCell(7).getStringCellValue());
sop.setEditor(sheet.getRow(fileVersionIndex+1).getCell(2).getStringCellValue());
--
Gitblit v1.9.1