From 48ee7c963f29f5614a8f86c08608620cc6310793 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期一, 26 十月 2026 17:11:33 +0800
Subject: [PATCH] feat: 完善产品编码与技术文件管理

---
 yudao-module-mdm-api/src/main/java/cn/iocoder/yudao/module/mdm/enums/MdmItemTypeEnum.java                                |    8 
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/item/MdmItemServiceImpl.java                          |   55 +++++++
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemSaveReqVO.java                |    9 
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/MdmItemSyncApiImpl.java                              |    6 
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/dataobject/item/MdmItemTechnicalFileDO.java               |   22 +++
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemMapper.java                             |    5 
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/enums/ErrorCodeConstants.java                                 |    4 
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemRespDTO.java                              |    5 
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemSyncReqDTO.java                           |    5 
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemRespVO.java                   |    5 
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemTechnicalFileMapper.java                |   26 +++
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/item/MdmItemTechnicalFileServiceImpl.java             |   69 +++++++++
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/dataobject/item/MdmItemCodeSequenceDO.java                |   16 ++
 yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/enums/storage/StorageRecordTypeEnum.java                |    2 
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemCreateReqDTO.java                         |    5 
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemImportExcelVO.java            |    8 +
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemTechnicalFileRespVO.java      |   18 ++
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/enums/MdmItemTypeEnum.java                                    |   10 
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/dataobject/item/MdmItemDO.java                            |    5 
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/item/MdmItemTechnicalFileService.java                 |   11 +
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemExcelVO.java                  |    7 
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemCodeSequenceMapper.java                 |   25 +++
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemUpdateReqDTO.java                         |    3 
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemTechnicalFileCreateReqVO.java |   17 ++
 yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/MdmItemController.java                  |   22 +++
 25 files changed, 340 insertions(+), 28 deletions(-)

diff --git a/yudao-module-mdm-api/src/main/java/cn/iocoder/yudao/module/mdm/enums/MdmItemTypeEnum.java b/yudao-module-mdm-api/src/main/java/cn/iocoder/yudao/module/mdm/enums/MdmItemTypeEnum.java
index 9c98fd1..f9363bd 100644
--- a/yudao-module-mdm-api/src/main/java/cn/iocoder/yudao/module/mdm/enums/MdmItemTypeEnum.java
+++ b/yudao-module-mdm-api/src/main/java/cn/iocoder/yudao/module/mdm/enums/MdmItemTypeEnum.java
@@ -12,9 +12,11 @@
 @AllArgsConstructor
 public enum MdmItemTypeEnum {
 
-    MATERIAL(1, "鐗╂枡"),
-    PRODUCT(2, "浜у搧"),
-    SEMI_FINISHED(3, "鍗婃垚鍝�");
+    RAW_MATERIAL(1, "鍘熸潗鏂�"),
+    SEMI_FINISHED(2, "鍗婃垚鍝�"),
+    FINISHED_PRODUCT(3, "鎴愬搧"),
+    AUXILIARY(4, "杈呮潗"),
+    OTHER(5, "鍏朵粬");
 
     /**
      * 绫诲瀷缂栫爜
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/MdmItemSyncApiImpl.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/MdmItemSyncApiImpl.java
index eadd522..6a2b189 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/MdmItemSyncApiImpl.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/MdmItemSyncApiImpl.java
@@ -41,6 +41,10 @@
         if (existingItem != null) {
             // 鏇存柊
             item.setId(existingItem.getId());
+            // MES 鍚屾璇锋眰鏆備笉缁存姢鎶�鏈弬鏁帮紝閬垮厤鍚屾鏃舵妸 MDM 宸茬淮鎶ょ殑鍙傛暟娓呯┖銆�
+            if (syncReqDTO.getTechnicalParameters() == null) {
+                item.setTechnicalParameters(existingItem.getTechnicalParameters());
+            }
             itemMapper.updateById(item);
             itemId = existingItem.getId();
         } else {
@@ -99,4 +103,4 @@
         }
     }
 
-}
\ No newline at end of file
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemCreateReqDTO.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemCreateReqDTO.java
index 995cfe8..26daf46 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemCreateReqDTO.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemCreateReqDTO.java
@@ -21,6 +21,9 @@
     @Schema(description = "瑙勬牸鍨嬪彿", example = "M8*20")
     private String specification;
 
+    @Schema(description = "鎶�鏈弬鏁�")
+    private String technicalParameters;
+
     @Schema(description = "鐗╂枡鍒嗙被缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
     private Long categoryId;
 
@@ -60,4 +63,4 @@
     @Schema(description = "澶囨敞", example = "澶囨敞淇℃伅")
     private String remark;
 
-}
\ No newline at end of file
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemRespDTO.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemRespDTO.java
index b3c1993..a783abc 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemRespDTO.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemRespDTO.java
@@ -24,6 +24,9 @@
     @Schema(description = "瑙勬牸鍨嬪彿", example = "M8*20")
     private String specification;
 
+    @Schema(description = "鎶�鏈弬鏁�")
+    private String technicalParameters;
+
     @Schema(description = "鐗╂枡鍒嗙被缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
     private Long categoryId;
 
@@ -72,4 +75,4 @@
     @Schema(description = "澶囨敞", example = "澶囨敞淇℃伅")
     private String remark;
 
-}
\ No newline at end of file
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemSyncReqDTO.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemSyncReqDTO.java
index a6d88cb..00430e2 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemSyncReqDTO.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemSyncReqDTO.java
@@ -23,6 +23,9 @@
     @Schema(description = "瑙勬牸鍨嬪彿", example = "M6*20")
     private String specification;
 
+    @Schema(description = "鎶�鏈弬鏁�")
+    private String technicalParameters;
+
     @Schema(description = "鐗╂枡绫诲瀷锛�1鍘熸枡, 2鍗婃垚鍝�, 3鎴愬搧, 4杈呮枡", example = "1")
     private Long itemType;
 
@@ -106,4 +109,4 @@
     @Schema(description = "璐ㄩ噺鐘舵�佸繀濉�", example = "false")
     private Boolean qualityStatusFlag;
 
-}
\ No newline at end of file
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemUpdateReqDTO.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemUpdateReqDTO.java
index 1f1fdf1..07de29d 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemUpdateReqDTO.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/api/item/dto/MdmItemUpdateReqDTO.java
@@ -24,6 +24,9 @@
     @Schema(description = "瑙勬牸鍨嬪彿", example = "M8*20")
     private String specification;
 
+    @Schema(description = "鎶�鏈弬鏁�")
+    private String technicalParameters;
+
     @Schema(description = "鐗╂枡鍒嗙被缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
     private Long categoryId;
 
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/MdmItemController.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/MdmItemController.java
index b570ded..a560e07 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/MdmItemController.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/MdmItemController.java
@@ -14,6 +14,8 @@
 import cn.iocoder.yudao.module.mdm.controller.admin.item.vo.MdmItemSaveReqVO;
 import cn.iocoder.yudao.module.mdm.controller.admin.item.vo.MdmItemStatusUpdateReqVO;
 import cn.iocoder.yudao.module.mdm.controller.admin.item.vo.MdmItemSyncUpdateReqVO;
+import cn.iocoder.yudao.module.mdm.controller.admin.item.vo.MdmItemTechnicalFileCreateReqVO;
+import cn.iocoder.yudao.module.mdm.controller.admin.item.vo.MdmItemTechnicalFileRespVO;
 import cn.iocoder.yudao.module.mdm.dal.dataobject.category.MdmItemCategoryDO;
 import cn.iocoder.yudao.module.mdm.dal.dataobject.item.MdmItemBatchConfigDO;
 import cn.iocoder.yudao.module.mdm.dal.dataobject.item.MdmItemDO;
@@ -23,6 +25,7 @@
 import cn.iocoder.yudao.module.mdm.service.category.MdmItemCategoryService;
 import cn.iocoder.yudao.module.mdm.service.item.MdmItemBatchConfigService;
 import cn.iocoder.yudao.module.mdm.service.item.MdmItemService;
+import cn.iocoder.yudao.module.mdm.service.item.MdmItemTechnicalFileService;
 import cn.iocoder.yudao.module.mdm.service.unit.MdmUnitMeasureService;
 import cn.iocoder.yudao.module.mes.api.item.MesMdItemApi;
 import cn.iocoder.yudao.module.mes.api.wm.warehouse.MesWmWarehouseApi;
@@ -70,6 +73,9 @@
     @Resource
     private MdmItemBatchConfigService itemBatchConfigService;
 
+    @Resource
+    private MdmItemTechnicalFileService technicalFileService;
+
     @PostMapping("/create")
     @Operation(summary = "鍒涘缓鐗╂枡")
     @PreAuthorize("@ss.hasPermission('mdm:item:create')")
@@ -99,6 +105,20 @@
     public CommonResult<Boolean> updateItemSync(@Valid @RequestBody MdmItemSyncUpdateReqVO reqVO) {
         itemService.updateItemSync(reqVO.getId(), reqVO.getSync());
         return success(true);
+    }
+
+    @PostMapping("/technical-file/create")
+    @Operation(summary = "涓婁紶浜у搧鎶�鏈枃浠剁増鏈�")
+    @PreAuthorize("@ss.hasPermission('mdm:item:update')")
+    public CommonResult<Long> createTechnicalFile(@Valid @RequestBody MdmItemTechnicalFileCreateReqVO reqVO) {
+        return success(technicalFileService.createTechnicalFile(reqVO));
+    }
+
+    @GetMapping("/technical-file/list")
+    @Operation(summary = "鑾峰緱浜у搧鎶�鏈枃浠跺巻鍙�")
+    @PreAuthorize("@ss.hasPermission('mdm:item:query')")
+    public CommonResult<List<MdmItemTechnicalFileRespVO>> getTechnicalFileList(@RequestParam("itemId") Long itemId) {
+        return success(technicalFileService.getTechnicalFileList(itemId));
     }
 
     @DeleteMapping("/delete")
@@ -349,4 +369,4 @@
         return success(itemService.importItemList(list, updateSupport));
     }
 
-}
\ No newline at end of file
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemExcelVO.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemExcelVO.java
index 6273789..9974a8d 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemExcelVO.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemExcelVO.java
@@ -14,7 +14,7 @@
 @Data
 public class MdmItemExcelVO {
 
-    @ExcelProperty("鐗╂枡缂栫爜")
+    @ExcelProperty("浜у搧缂栧彿")
     private String code;
 
     @ExcelProperty("鐗╂枡鍚嶇О")
@@ -26,7 +26,10 @@
     @ExcelProperty("瑙勬牸鍨嬪彿")
     private String specification;
 
-    @ExcelProperty("鐗╂枡绫诲瀷")
+    @ExcelProperty("鎶�鏈弬鏁�")
+    private String technicalParameters;
+
+    @ExcelProperty("浜у搧绫诲瀷")
     private String itemTypeName;
 
     @ExcelProperty("鐗╂枡鍒嗙被")
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemImportExcelVO.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemImportExcelVO.java
index a490136..32c0543 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemImportExcelVO.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemImportExcelVO.java
@@ -17,7 +17,7 @@
 @NoArgsConstructor
 public class MdmItemImportExcelVO {
 
-    @ExcelProperty("鐗╂枡缂栫爜")
+    @ExcelProperty("浜у搧缂栧彿锛堜慨鏀规椂鐢ㄤ簬鍖归厤锛屾柊澧炴椂鑷姩鐢熸垚锛�")
     private String code;
 
     @ExcelProperty("鐗╂枡鍚嶇О")
@@ -29,6 +29,12 @@
     @ExcelProperty("瑙勬牸鍨嬪彿")
     private String specification;
 
+    @ExcelProperty("鎶�鏈弬鏁�")
+    private String technicalParameters;
+
+    @ExcelProperty("浜у搧绫诲瀷锛�1鍘熸潗鏂� 2鍗婃垚鍝� 3鎴愬搧 4杈呮潗 5鍏朵粬锛�")
+    private Integer itemType;
+
     @ExcelProperty("鐗╂枡鍒嗙被缂栫爜")
     private String categoryCode;
 
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemRespVO.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemRespVO.java
index b9709d3..99311a8 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemRespVO.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemRespVO.java
@@ -25,6 +25,9 @@
     @Schema(description = "瑙勬牸鍨嬪彿", example = "M8*20")
     private String specification;
 
+    @Schema(description = "鎶�鏈弬鏁�")
+    private String technicalParameters;
+
     @Schema(description = "鐗╂枡鍒嗙被缂栧彿", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
     private Long categoryId;
 
@@ -138,4 +141,4 @@
     @Schema(description = "鍒涘缓鏃堕棿", requiredMode = Schema.RequiredMode.REQUIRED)
     private LocalDateTime createTime;
 
-}
\ No newline at end of file
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemSaveReqVO.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemSaveReqVO.java
index de0c38d..8210630 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemSaveReqVO.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemSaveReqVO.java
@@ -12,7 +12,7 @@
     @Schema(description = "鐗╂枡缂栧彿", example = "1")
     private Long id;
 
-    @Schema(description = "鐗╂枡缂栫爜", requiredMode = Schema.RequiredMode.REQUIRED, example = "ITEM001")
+    @Schema(description = "鐗╂枡缂栫爜锛堢敱绯荤粺鑷姩鐢熸垚锛屼慨鏀规椂蹇界暐鍓嶇浼犲叆鍊硷級", example = "100100001")
     private String code;
 
     @Schema(description = "鐗╂枡鍚嶇О", requiredMode = Schema.RequiredMode.REQUIRED, example = "铻轰笣")
@@ -23,6 +23,9 @@
 
     @Schema(description = "瑙勬牸鍨嬪彿", example = "M8*20")
     private String specification;
+
+    @Schema(description = "鎶�鏈弬鏁�")
+    private String technicalParameters;
 
     @Schema(description = "鐗╂枡鍒嗙被缂栧彿锛堝叧鑱� MES 鐗╂枡鍒嗙被 mes_md_item_type锛�", example = "1")
     private Long categoryId;
@@ -48,7 +51,7 @@
     @Schema(description = "榛樿浠撳簱缂栫爜", example = "WH001")
     private String warehouseCode;
 
-    @Schema(description = "鐗╂枡绫诲瀷", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
+    @Schema(description = "浜у搧绫诲瀷锛�1鍘熸潗鏂� 2鍗婃垚鍝� 3鎴愬搧 4杈呮潗 5鍏朵粬", requiredMode = Schema.RequiredMode.REQUIRED, example = "1")
     private Integer itemType;
 
     @Schema(description = "鐘舵��", requiredMode = Schema.RequiredMode.REQUIRED, example = "0")
@@ -115,4 +118,4 @@
 
     private Long mdmItemId;
 
-}
\ No newline at end of file
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemTechnicalFileCreateReqVO.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemTechnicalFileCreateReqVO.java
new file mode 100644
index 0000000..508c20b
--- /dev/null
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemTechnicalFileCreateReqVO.java
@@ -0,0 +1,17 @@
+package cn.iocoder.yudao.module.mdm.controller.admin.item.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import jakarta.validation.constraints.NotNull;
+import lombok.Data;
+
+@Data
+public class MdmItemTechnicalFileCreateReqVO {
+
+    @NotNull
+    @Schema(description = "浜у搧ID", requiredMode = Schema.RequiredMode.REQUIRED)
+    private Long itemId;
+
+    @NotNull
+    @Schema(description = "宸蹭笂浼犵殑 storage blob ID", requiredMode = Schema.RequiredMode.REQUIRED)
+    private Long blobId;
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemTechnicalFileRespVO.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemTechnicalFileRespVO.java
new file mode 100644
index 0000000..298baa1
--- /dev/null
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/controller/admin/item/vo/MdmItemTechnicalFileRespVO.java
@@ -0,0 +1,18 @@
+package cn.iocoder.yudao.module.mdm.controller.admin.item.vo;
+
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.time.LocalDateTime;
+
+@Data
+public class MdmItemTechnicalFileRespVO {
+    private Long id;
+    private Long itemId;
+    private Long blobId;
+    private Integer versionNo;
+    private String fileName;
+    private String previewURL;
+    private String downloadURL;
+    private LocalDateTime createTime;
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/dataobject/item/MdmItemCodeSequenceDO.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/dataobject/item/MdmItemCodeSequenceDO.java
new file mode 100644
index 0000000..ae3f924
--- /dev/null
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/dataobject/item/MdmItemCodeSequenceDO.java
@@ -0,0 +1,16 @@
+package cn.iocoder.yudao.module.mdm.dal.dataobject.item;
+
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.Data;
+
+/** 鐗╂枡缂栫爜鍒嗘娴佹按銆傛瘡涓洓浣嶅墠缂�鐙珛閫掑銆� */
+@Data
+@TableName("mdm_item_code_sequence")
+public class MdmItemCodeSequenceDO {
+
+    @TableId
+    private String prefix;
+
+    private Integer currentValue;
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/dataobject/item/MdmItemDO.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/dataobject/item/MdmItemDO.java
index 1b7f5c0..3a3213f 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/dataobject/item/MdmItemDO.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/dataobject/item/MdmItemDO.java
@@ -55,6 +55,9 @@
      */
     private String specification;
 
+    /** 鎶�鏈弬鏁� */
+    private String technicalParameters;
+
     /**
      * 鐗╂枡鍒嗙被缂栧彿
      *
@@ -213,4 +216,4 @@
      */
     private String remark;
 
-}
\ No newline at end of file
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/dataobject/item/MdmItemTechnicalFileDO.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/dataobject/item/MdmItemTechnicalFileDO.java
new file mode 100644
index 0000000..c71de14
--- /dev/null
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/dataobject/item/MdmItemTechnicalFileDO.java
@@ -0,0 +1,22 @@
+package cn.iocoder.yudao.module.mdm.dal.dataobject.item;
+
+import cn.iocoder.yudao.framework.mybatis.core.dataobject.BaseDO;
+import com.baomidou.mybatisplus.annotation.KeySequence;
+import com.baomidou.mybatisplus.annotation.TableId;
+import com.baomidou.mybatisplus.annotation.TableName;
+import lombok.Data;
+import lombok.EqualsAndHashCode;
+
+@Data
+@EqualsAndHashCode(callSuper = true)
+@TableName("mdm_item_technical_file")
+@KeySequence("mdm_item_technical_file_seq")
+public class MdmItemTechnicalFileDO extends BaseDO {
+
+    @TableId
+    private Long id;
+    private Long itemId;
+    private Long storageBlobId;
+    private Integer versionNo;
+    private String fileName;
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemCodeSequenceMapper.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemCodeSequenceMapper.java
new file mode 100644
index 0000000..6a45f53
--- /dev/null
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemCodeSequenceMapper.java
@@ -0,0 +1,25 @@
+package cn.iocoder.yudao.module.mdm.dal.mysql.item;
+
+import cn.iocoder.yudao.module.mdm.dal.dataobject.item.MdmItemCodeSequenceDO;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import org.apache.ibatis.annotations.Insert;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Select;
+import org.apache.ibatis.annotations.Update;
+
+@Mapper
+public interface MdmItemCodeSequenceMapper extends BaseMapper<MdmItemCodeSequenceDO> {
+
+    @Insert("INSERT IGNORE INTO mdm_item_code_sequence(prefix, current_value) VALUES (#{prefix}, 0)")
+    void insertIfAbsent(String prefix);
+
+    @Select("SELECT current_value FROM mdm_item_code_sequence WHERE prefix = #{prefix} FOR UPDATE")
+    Integer selectCurrentValueForUpdate(String prefix);
+
+    @Update("UPDATE mdm_item_code_sequence SET current_value = current_value + 1 WHERE prefix = #{prefix}")
+    int increment(String prefix);
+
+    @Update("UPDATE mdm_item_code_sequence SET current_value = #{value} WHERE prefix = #{prefix}")
+    int updateCurrentValue(@org.apache.ibatis.annotations.Param("prefix") String prefix,
+                           @org.apache.ibatis.annotations.Param("value") Integer value);
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemMapper.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemMapper.java
index eec20ce..c7c203a 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemMapper.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemMapper.java
@@ -20,6 +20,9 @@
 @Mapper
 public interface MdmItemMapper extends BaseMapperX<MdmItemDO> {
 
+    @org.apache.ibatis.annotations.Select("SELECT COALESCE(MAX(CAST(SUBSTRING(code, 5) AS UNSIGNED)), 0) FROM mdm_item WHERE deleted = 0 AND code LIKE CONCAT(#{prefix}, '%')")
+    Integer selectMaxSequenceByPrefix(@Param("prefix") String prefix);
+
     default PageResult<MdmItemDO> selectPage(MdmItemPageReqVO reqVO, Collection<Long> categoryIds) {
         return selectPage(reqVO, new LambdaQueryWrapperX<MdmItemDO>()
                 .likeIfPresent(MdmItemDO::getCode, reqVO.getCode())
@@ -92,4 +95,4 @@
      */
     List<Map<String, Object>> selectItemReferenceCount(@Param("itemId") Long itemId);
 
-}
\ No newline at end of file
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemTechnicalFileMapper.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemTechnicalFileMapper.java
new file mode 100644
index 0000000..0cd95bc
--- /dev/null
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/dal/mysql/item/MdmItemTechnicalFileMapper.java
@@ -0,0 +1,26 @@
+package cn.iocoder.yudao.module.mdm.dal.mysql.item;
+
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.module.mdm.dal.dataobject.item.MdmItemTechnicalFileDO;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.util.List;
+
+@Mapper
+public interface MdmItemTechnicalFileMapper extends BaseMapperX<MdmItemTechnicalFileDO> {
+
+    default List<MdmItemTechnicalFileDO> selectListByItemId(Long itemId) {
+        return selectList(new LambdaQueryWrapper<MdmItemTechnicalFileDO>()
+                .eq(MdmItemTechnicalFileDO::getItemId, itemId)
+                .orderByDesc(MdmItemTechnicalFileDO::getVersionNo));
+    }
+
+    default Integer selectMaxVersionNo(Long itemId) {
+        MdmItemTechnicalFileDO row = selectOne(new LambdaQueryWrapper<MdmItemTechnicalFileDO>()
+                .eq(MdmItemTechnicalFileDO::getItemId, itemId)
+                .orderByDesc(MdmItemTechnicalFileDO::getVersionNo)
+                .last("LIMIT 1"));
+        return row == null || row.getVersionNo() == null ? 0 : row.getVersionNo();
+    }
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/enums/ErrorCodeConstants.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/enums/ErrorCodeConstants.java
index a3df052..4616bbf 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/enums/ErrorCodeConstants.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/enums/ErrorCodeConstants.java
@@ -18,6 +18,8 @@
     ErrorCode MDM_ITEM_SKU_CODE_DUPLICATE = new ErrorCode(1_050_006, "SKU缂栫爜宸插瓨鍦�");
     ErrorCode MDM_ITEM_EXISTS_REFERENCE = new ErrorCode(1_050_007, "鐗╂枡宸茶涓氬姟寮曠敤锛屾棤娉曞垹闄�");
     ErrorCode MDM_ITEM_IMPORT_LIST_IS_EMPTY = new ErrorCode(1_050_008, "瀵煎叆鐨勭墿鏂欐暟鎹笉鑳戒负绌�");
+    ErrorCode MDM_ITEM_TYPE_INVALID = new ErrorCode(1_050_009, "浜у搧绫诲瀷鏃犳晥");
+    ErrorCode MDM_ITEM_CODE_SEQUENCE_EXHAUSTED = new ErrorCode(1_050_010, "浜у搧缂栧彿娴佹按鍙峰凡瓒呰繃浜斾綅");
 
     // ========== 鐗╂枡鍒嗙被鐩稿叧 1-050-051 ~ 1-050-100 ==========
     ErrorCode MDM_ITEM_CATEGORY_NOT_EXISTS = new ErrorCode(1_050_051, "鐗╂枡鍒嗙被涓嶅瓨鍦�");
@@ -46,4 +48,4 @@
     ErrorCode MDM_WAREHOUSE_NAME_DUPLICATE = new ErrorCode(1_050_203, "浠撳簱鍚嶇О宸插瓨鍦�");
     ErrorCode MDM_WAREHOUSE_IS_DISABLE = new ErrorCode(1_050_204, "浠撳簱宸茬鐢�");
 
-}
\ No newline at end of file
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/enums/MdmItemTypeEnum.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/enums/MdmItemTypeEnum.java
index 594ea64..f9363bd 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/enums/MdmItemTypeEnum.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/enums/MdmItemTypeEnum.java
@@ -12,9 +12,11 @@
 @AllArgsConstructor
 public enum MdmItemTypeEnum {
 
-    MATERIAL(1, "鐗╂枡"),
-    PRODUCT(2, "浜у搧"),
-    SEMI_FINISHED(3, "鍗婃垚鍝�");
+    RAW_MATERIAL(1, "鍘熸潗鏂�"),
+    SEMI_FINISHED(2, "鍗婃垚鍝�"),
+    FINISHED_PRODUCT(3, "鎴愬搧"),
+    AUXILIARY(4, "杈呮潗"),
+    OTHER(5, "鍏朵粬");
 
     /**
      * 绫诲瀷缂栫爜
@@ -38,4 +40,4 @@
         return null;
     }
 
-}
\ No newline at end of file
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/item/MdmItemServiceImpl.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/item/MdmItemServiceImpl.java
index cfbc790..1780521 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/item/MdmItemServiceImpl.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/item/MdmItemServiceImpl.java
@@ -19,6 +19,7 @@
 import cn.iocoder.yudao.module.mdm.dal.dataobject.unit.MdmUnitMeasureDO;
 import cn.iocoder.yudao.module.mdm.dal.mysql.item.MdmItemBatchConfigMapper;
 import cn.iocoder.yudao.module.mdm.dal.mysql.item.MdmItemMapper;
+import cn.iocoder.yudao.module.mdm.dal.mysql.item.MdmItemCodeSequenceMapper;
 import cn.iocoder.yudao.module.mdm.dal.mysql.unit.MdmUnitMeasureMapper;
 import cn.iocoder.yudao.module.mdm.service.brand.MdmBrandService;
 import cn.iocoder.yudao.module.mdm.service.category.MdmItemCategoryService;
@@ -60,6 +61,9 @@
     private MdmItemMapper itemMapper;
 
     @Resource
+    private MdmItemCodeSequenceMapper itemCodeSequenceMapper;
+
+    @Resource
     private MdmItemCategoryService itemCategoryService;
     @Resource
     private MdmUnitMeasureService unitMeasureService;
@@ -85,6 +89,7 @@
     @Override
     @Transactional(rollbackFor = Exception.class)
     public Long createItem(MdmItemSaveReqVO createReqVO) {
+        createReqVO.setCode(generateItemCode(createReqVO.getItemType()));
         // 鏍¢獙鏁版嵁
         validateItemSaveData(createReqVO);
 
@@ -107,7 +112,10 @@
     @Transactional(rollbackFor = Exception.class)
     public void updateItem(MdmItemSaveReqVO updateReqVO) {
         // 鏍¢獙瀛樺湪
-        validateItemExists(updateReqVO.getId());
+        MdmItemDO existingItem = validateItemExists(updateReqVO.getId());
+        // 缂栧彿鐢辩郴缁熺敓鎴愶紝淇敼浜у搧鏃朵繚鎸佸師缂栧彿涓嶅彉銆�
+        updateReqVO.setCode(existingItem.getCode());
+        updateReqVO.setItemType(existingItem.getItemType());
         // 鏍¢獙鏁版嵁
         validateItemSaveData(updateReqVO);
 
@@ -127,8 +135,41 @@
     }
 
     private void validateItemSaveData(MdmItemSaveReqVO reqVO) {
+        if (reqVO.getItemType() == null || reqVO.getItemType() < 1 || reqVO.getItemType() > 5) {
+            throw exception(MDM_ITEM_TYPE_INVALID);
+        }
         // 鏍¢獙鐗╂枡缂栫爜鐨勫敮涓�鎬�
         validateItemCodeUnique(reqVO.getId(), reqVO.getCode());
+    }
+
+    /** 鐢熸垚鍥涗綅绫诲瀷鍓嶇紑 + 浜斾綅娴佹按鍙凤紝鍏变節浣嶃�傛祦姘磋鍦ㄤ簨鍔″唴鍔犻攣锛岄伩鍏嶅苟鍙戦噸澶嶃�� */
+    private String generateItemCode(Integer itemType) {
+        String prefix = switch (itemType == null ? 0 : itemType) {
+            case 1 -> "1001";
+            case 2 -> "1002";
+            case 3 -> "1003";
+            case 4 -> "1004";
+            case 5 -> "1005";
+            default -> throw exception(MDM_ITEM_TYPE_INVALID);
+        };
+        itemCodeSequenceMapper.insertIfAbsent(prefix);
+        Integer current = itemCodeSequenceMapper.selectCurrentValueForUpdate(prefix);
+        if (current == null) {
+            current = itemMapper.selectMaxSequenceByPrefix(prefix);
+            itemCodeSequenceMapper.insertIfAbsent(prefix);
+            itemCodeSequenceMapper.updateCurrentValue(prefix, current);
+        }
+        int maxExisting = itemMapper.selectMaxSequenceByPrefix(prefix);
+        if (current < maxExisting) {
+            current = maxExisting;
+            itemCodeSequenceMapper.updateCurrentValue(prefix, current);
+        }
+        if (current >= 99_999) {
+            throw exception(MDM_ITEM_CODE_SEQUENCE_EXHAUSTED);
+        }
+        itemCodeSequenceMapper.increment(prefix);
+        int next = current + 1;
+        return prefix + String.format("%05d", next);
     }
 
     /**
@@ -468,8 +509,8 @@
         TransactionTemplate importTxTemplate = new TransactionTemplate(transactionManager);
         for (MdmItemImportExcelVO importVO : importList) {
             // 2.1 鍩虹鏍¢獙
-            if (StrUtil.isBlank(importVO.getCode()) || StrUtil.isBlank(importVO.getName())) {
-                respVO.getFailureList().put(buildFailKey(importVO), "鐗╂枡缂栫爜鍜岀墿鏂欏悕绉颁笉鑳戒负绌�");
+            if (StrUtil.isBlank(importVO.getName())) {
+                respVO.getFailureList().put(buildFailKey(importVO), "鐗╂枡鍚嶇О涓嶈兘涓虹┖");
                 continue;
             }
             // 2.2 瑙f瀽鍒嗙被
@@ -511,10 +552,12 @@
 
             // 2.6 缁勮 SaveReqVO锛堝鐢� create/update 閫昏緫锛�
             MdmItemSaveReqVO saveReqVO = new MdmItemSaveReqVO();
+            // 鏂板鏃跺拷鐣� Excel 涓殑鐗╂枡缂栫爜锛岀敱 MDM 鎸変骇鍝佺被鍨嬭嚜鍔ㄧ敓鎴愩��
             saveReqVO.setCode(importVO.getCode());
             saveReqVO.setName(importVO.getName());
             saveReqVO.setBarCode(importVO.getBarCode());
             saveReqVO.setSpecification(importVO.getSpecification());
+            saveReqVO.setTechnicalParameters(importVO.getTechnicalParameters());
             saveReqVO.setCategoryId(categoryId);
             saveReqVO.setUnitMeasureId(unitMeasureId);
             saveReqVO.setUnitMeasureId2(unitMeasureId2);
@@ -532,10 +575,10 @@
             saveReqVO.setStatus(importVO.getStatus() != null ? importVO.getStatus() : cn.iocoder.yudao.framework.common.enums.CommonStatusEnum.ENABLE.getStatus());
             saveReqVO.setSyncMes(importVO.getSyncMes() != null ? importVO.getSyncMes() : false);
             saveReqVO.setRemark(importVO.getRemark());
-            saveReqVO.setItemType(1); // 榛樿鐗╂枡绫诲瀷锛氱墿鏂�
+            saveReqVO.setItemType(importVO.getItemType() != null ? importVO.getItemType() : 1); // 鏈彁渚涚被鍨嬫椂榛樿涓哄師鏉愭枡
 
             // 2.7 宸插瓨鍦紙鎸夌紪鐮佸垽鏂級
-            MdmItemDO existByCode = itemMapper.selectByCode(importVO.getCode());
+            MdmItemDO existByCode = StrUtil.isBlank(importVO.getCode()) ? null : itemMapper.selectByCode(importVO.getCode());
             if (existByCode != null && !Boolean.TRUE.equals(isUpdateSupport)) {
                 respVO.getFailureList().put(buildFailKey(importVO), "鐗╂枡缂栫爜宸插瓨鍦�");
                 continue;
@@ -587,4 +630,4 @@
                 StrUtil.blankToDefault(importVO.getName(), "锛堝悕绉板拰缂栫爜涓虹┖鐨勮锛�"));
     }
 
-}
\ No newline at end of file
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/item/MdmItemTechnicalFileService.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/item/MdmItemTechnicalFileService.java
new file mode 100644
index 0000000..9ec54f9
--- /dev/null
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/item/MdmItemTechnicalFileService.java
@@ -0,0 +1,11 @@
+package cn.iocoder.yudao.module.mdm.service.item;
+
+import cn.iocoder.yudao.module.mdm.controller.admin.item.vo.MdmItemTechnicalFileCreateReqVO;
+import cn.iocoder.yudao.module.mdm.controller.admin.item.vo.MdmItemTechnicalFileRespVO;
+
+import java.util.List;
+
+public interface MdmItemTechnicalFileService {
+    Long createTechnicalFile(MdmItemTechnicalFileCreateReqVO reqVO);
+    List<MdmItemTechnicalFileRespVO> getTechnicalFileList(Long itemId);
+}
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/item/MdmItemTechnicalFileServiceImpl.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/item/MdmItemTechnicalFileServiceImpl.java
new file mode 100644
index 0000000..b798384
--- /dev/null
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/item/MdmItemTechnicalFileServiceImpl.java
@@ -0,0 +1,69 @@
+package cn.iocoder.yudao.module.mdm.service.item;
+
+import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
+import cn.iocoder.yudao.module.mdm.controller.admin.item.vo.MdmItemTechnicalFileCreateReqVO;
+import cn.iocoder.yudao.module.mdm.controller.admin.item.vo.MdmItemTechnicalFileRespVO;
+import cn.iocoder.yudao.module.mdm.dal.dataobject.item.MdmItemTechnicalFileDO;
+import cn.iocoder.yudao.module.mdm.dal.mysql.item.MdmItemTechnicalFileMapper;
+import cn.iocoder.yudao.module.system.api.storage.StorageAttachmentApi;
+import cn.iocoder.yudao.module.system.api.storage.dto.StorageBlobRespDTO;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.Collections;
+import java.util.List;
+
+import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
+import static cn.iocoder.yudao.module.mdm.enums.ErrorCodeConstants.MDM_ITEM_NOT_EXISTS;
+
+@Service
+public class MdmItemTechnicalFileServiceImpl implements MdmItemTechnicalFileService {
+
+    private static final String RECORD_TYPE = "mdm_item_technical_file";
+
+    private final MdmItemTechnicalFileMapper mapper;
+    private final MdmItemService itemService;
+    private final StorageAttachmentApi storageAttachmentApi;
+
+    public MdmItemTechnicalFileServiceImpl(MdmItemTechnicalFileMapper mapper,
+                                           MdmItemService itemService,
+                                           StorageAttachmentApi storageAttachmentApi) {
+        this.mapper = mapper;
+        this.itemService = itemService;
+        this.storageAttachmentApi = storageAttachmentApi;
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public Long createTechnicalFile(MdmItemTechnicalFileCreateReqVO reqVO) {
+        if (itemService.getItem(reqVO.getItemId()) == null) {
+            throw exception(MDM_ITEM_NOT_EXISTS);
+        }
+        int version = mapper.selectMaxVersionNo(reqVO.getItemId()) + 1;
+        // 璁板綍 ID 蹇呴』涓庨檮浠跺叧绯昏褰� ID 涓�鑷达紝鍥犳鍏堟彃鍏ョ増鏈褰曪紝鍐嶇粦瀹氶檮浠躲��
+        MdmItemTechnicalFileDO file = new MdmItemTechnicalFileDO();
+        file.setItemId(reqVO.getItemId());
+        file.setStorageBlobId(reqVO.getBlobId());
+        file.setVersionNo(version);
+        mapper.insert(file);
+        storageAttachmentApi.bindAttachments("file", RECORD_TYPE, file.getId(),
+                Collections.singletonList(reqVO.getBlobId()));
+        return file.getId();
+    }
+
+    @Override
+    public List<MdmItemTechnicalFileRespVO> getTechnicalFileList(Long itemId) {
+        return mapper.selectListByItemId(itemId).stream().map(file -> {
+            MdmItemTechnicalFileRespVO resp = BeanUtils.toBean(file, MdmItemTechnicalFileRespVO.class);
+            resp.setBlobId(file.getStorageBlobId());
+            List<StorageBlobRespDTO> blobs = storageAttachmentApi.listAttachments(RECORD_TYPE, file.getId());
+            if (blobs != null && !blobs.isEmpty()) {
+                StorageBlobRespDTO blob = blobs.get(0);
+                resp.setFileName(blob.getName());
+                resp.setPreviewURL(blob.getPreviewURL());
+                resp.setDownloadURL(blob.getDownloadURL());
+            }
+            return resp;
+        }).toList();
+    }
+}
diff --git a/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/enums/storage/StorageRecordTypeEnum.java b/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/enums/storage/StorageRecordTypeEnum.java
index fe7437d..b4ca400 100644
--- a/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/enums/storage/StorageRecordTypeEnum.java
+++ b/yudao-module-system/src/main/java/cn/iocoder/yudao/module/system/enums/storage/StorageRecordTypeEnum.java
@@ -65,6 +65,8 @@
     // ===== MES =====
     MES_PD_DOCUMENT("mes_pd_document", "MES 璁捐璧勬枡"),
 
+    MDM_ITEM_TECHNICAL_FILE("mdm_item_technical_file", "MDM 鐗╂枡鎶�鏈枃浠�"),
+
     // ===== SRM =====
     SRM_SUPPLIER_CERTIFICATE("srm_supplier_certificate", "SRM 渚涘簲鍟嗚祫璐ㄨ瘉涔�"),
     SRM_TENDER_PROJECT("srm_tender_project", "SRM 鎷涙爣椤圭洰"),

--
Gitblit v1.9.3