From 894f398c74611d6cb42fd0d4e17a41f9b5ab9db4 Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期一, 07 四月 2025 10:24:00 +0800
Subject: [PATCH] 检验项目参数和查询优化

---
 basic-server/src/main/java/com/ruoyi/basic/excel/MultiSheetImportListener.java |    6 +-----
 1 files changed, 1 insertions(+), 5 deletions(-)

diff --git a/basic-server/src/main/java/com/ruoyi/basic/excel/MultiSheetImportListener.java b/basic-server/src/main/java/com/ruoyi/basic/excel/MultiSheetImportListener.java
index 281061c..298b820 100644
--- a/basic-server/src/main/java/com/ruoyi/basic/excel/MultiSheetImportListener.java
+++ b/basic-server/src/main/java/com/ruoyi/basic/excel/MultiSheetImportListener.java
@@ -78,8 +78,7 @@
         // 鏌ヨ鏁版嵁搴撲腑鏄惁瀛樺湪鐩稿悓璁板綍
         LambdaQueryWrapper<StructureItemParameter> wrapper = Wrappers.lambdaQuery(StructureItemParameter.class)
                 .eq(StructureItemParameter::getInspectionItem, data.getInspectionItem())
-                .eq(StructureItemParameter::getSample, data.getSample())
-                .last("limit 1");
+                .eq(StructureItemParameter::getSample, data.getSample());
 
         // 鍒ゆ柇鏄惁鏈夋楠岄」绫诲瀷
         if (ObjectUtils.isNotEmpty(data.getInspectionItemClass())) {
@@ -169,9 +168,6 @@
         if (data.getManDay() == null) {
             data.setManDay(null);
         }
-
-        // 璁剧疆褰撳墠Sheet鍚嶄负鍒嗙被鏍囪瘑
-        data.setInspectionItemClass(currentSheetName);
 
         // 娣诲姞鍒扮紦瀛樺垪琛�
         cachedList.add(data);

--
Gitblit v1.9.3