From 0891b6708cc09c2672a19661a8555aae0e742df1 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期四, 24 九月 2026 16:54:27 +0800
Subject: [PATCH] feat: 新增多模块导入导出功能
---
src/main/java/com/ruoyi/basic/mapper/ProductModelMapper.java | 14 ++++++++++++++
1 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/ruoyi/basic/mapper/ProductModelMapper.java b/src/main/java/com/ruoyi/basic/mapper/ProductModelMapper.java
index b245741..0d521c9 100644
--- a/src/main/java/com/ruoyi/basic/mapper/ProductModelMapper.java
+++ b/src/main/java/com/ruoyi/basic/mapper/ProductModelMapper.java
@@ -7,6 +7,7 @@
import com.ruoyi.basic.vo.ProductModelVo;
import com.ruoyi.procurementrecord.bean.dto.ProcurementPageDto;
import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
import java.util.List;
import java.util.Map;
@@ -27,4 +28,17 @@
ProductModel selectLatestRecord();
List<Map<String, Object>> getProductAndModelList();
+
+ /**
+ * 鎸変骇鍝佸悕绉� + 瑙勬牸鍨嬪彿鏌ヨ浜у搧鍨嬪彿
+ *
+ * @param productName 浜у搧鍚嶇О
+ * @param model 瑙勬牸鍨嬪彿
+ * @return 浜у搧鍨嬪彿锛堝彇绗竴鏉★級
+ */
+ @Select("select pm.id, pm.product_id, pm.model, pm.unit from product_model pm " +
+ "left join product p on pm.product_id = p.id " +
+ "where p.product_name = #{productName} and pm.model = #{model} " +
+ "order by pm.id limit 1")
+ ProductModel selectByProductNameAndModel(@Param("productName") String productName, @Param("model") String model);
}
--
Gitblit v1.9.3