From a7dd93b840bdce4bd0011bc948157f440514a207 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期二, 28 四月 2026 16:36:04 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev_New_pro' into dev_New_pro

---
 src/main/java/com/ruoyi/basic/service/impl/StorageAttachmentServiceImpl.java  |   10 -
 src/main/resources/mapper/device/DeviceMaintenanceMapper.xml                  |    2 
 src/main/java/com/ruoyi/device/dto/DeviceMaintenanceDto.java                  |    6 +
 src/main/java/com/ruoyi/device/dto/DeviceRepairDto.java                       |    5 
 src/main/resources/mapper/sales/SalesQuotationMapper.xml                      |    1 
 src/main/java/com/ruoyi/basic/dto/StorageBlobVO.java                          |    2 
 src/main/java/com/ruoyi/device/execl/DeviceMaintenanceExeclDto.java           |    4 
 src/main/java/com/ruoyi/device/vo/DeviceRepairVo.java                         |   20 +++
 src/main/java/com/ruoyi/device/service/impl/DeviceRepairServiceImpl.java      |   64 ++++++----
 src/main/java/com/ruoyi/device/service/IDeviceRepairService.java              |    9 
 src/main/java/com/ruoyi/device/service/impl/DeviceMaintenanceServiceImpl.java |   21 ++
 .DS_Store                                                                     |    0 
 src/main/java/com/ruoyi/device/controller/DeviceMaintenanceController.java    |    6 
 src/main/java/com/ruoyi/device/mapper/DeviceMaintenanceMapper.java            |    3 
 src/main/java/com/ruoyi/approve/service/impl/ApproveProcessServiceImpl.java   |   33 +++--
 src/main/java/com/ruoyi/device/controller/DeviceRepairController.java         |   15 +-
 src/main/java/com/ruoyi/device/service/IDeviceMaintenanceService.java         |    7 
 src/main/java/com/ruoyi/device/vo/DeviceMaintenanceVo.java                    |   51 ++++++++
 src/main/java/com/ruoyi/basic/controller/StorageAttachmentController.java     |    9 
 src/main/java/com/ruoyi/device/pojo/DeviceRepair.java                         |    4 
 src/main/java/com/ruoyi/device/mapper/DeviceRepairMapper.java                 |    5 
 src/main/java/com/ruoyi/basic/service/StorageAttachmentService.java           |    4 
 src/main/resources/mapper/device/DeviceRepairMapper.xml                       |    4 
 src/main/java/com/ruoyi/basic/utils/FileUtil.java                             |   45 +++----
 src/main/java/com/ruoyi/device/execl/DeviceRepairExeclDto.java                |    4 
 src/main/java/com/ruoyi/device/pojo/DeviceMaintenance.java                    |    2 
 26 files changed, 227 insertions(+), 109 deletions(-)

diff --git a/.DS_Store b/.DS_Store
new file mode 100644
index 0000000..166b92d
--- /dev/null
+++ b/.DS_Store
Binary files differ
diff --git a/src/main/java/com/ruoyi/approve/service/impl/ApproveProcessServiceImpl.java b/src/main/java/com/ruoyi/approve/service/impl/ApproveProcessServiceImpl.java
index 3143391..b75fedf 100644
--- a/src/main/java/com/ruoyi/approve/service/impl/ApproveProcessServiceImpl.java
+++ b/src/main/java/com/ruoyi/approve/service/impl/ApproveProcessServiceImpl.java
@@ -11,9 +11,11 @@
 import com.ruoyi.approve.bean.vo.ApproveProcessConfigNodeVo;
 import com.ruoyi.approve.bean.vo.ApproveProcessVO;
 import com.ruoyi.approve.mapper.ApproveNodeMapper;
+import com.ruoyi.approve.mapper.ApproveProcessConfigNodeMapper;
 import com.ruoyi.approve.mapper.ApproveProcessMapper;
 import com.ruoyi.approve.pojo.ApproveNode;
 import com.ruoyi.approve.pojo.ApproveProcess;
+import com.ruoyi.approve.pojo.ApproveProcessConfigNode;
 import com.ruoyi.approve.service.ApproveProcessConfigNodeService;
 import com.ruoyi.approve.service.IApproveNodeService;
 import com.ruoyi.approve.service.IApproveProcessService;
@@ -68,6 +70,7 @@
     private final ApproveNodeMapper approveNodeMapper;
     private final ApproveProcessConfigNodeService approveProcessConfigNodeService;
     private final FileUtil fileUtil;
+    private final ApproveProcessConfigNodeMapper approveProcessConfigNodeMapper;
 
     @Override
     public void addApprove(ApproveProcessVO approveProcessVO) throws Exception {
@@ -300,17 +303,20 @@
                 .eq(ApproveProcess::getApproveReason, approveGetAndUpdateVo.getApproveReason())
                 .last("limit 1");
         ApproveProcess approveProcess = approveProcessMapper.selectOne(approveProcessLambdaQueryWrapper);
-        if (approveProcess == null) throw new RuntimeException("鈥�");
-        String[] split = approveGetAndUpdateVo.getApproveUserIds().split(",");
-        if (split.length == 0) {
-            throw new RuntimeException("璇烽�夋嫨瀹℃壒浜�");
-        }
-        List<SysUser> sysUsers = sysUserMapper.selectUserByIds(Arrays.asList(split).stream().map(Long::parseLong).collect(Collectors.toList()));
+
+        if (approveProcess == null) throw new RuntimeException("璇烽�夋嫨瀹℃壒浜�");
+        //鏌ヨ瀹℃壒閰嶇疆
+        List<ApproveProcessConfigNode> approveProcessConfig = approveProcessConfigNodeMapper.selectList(new LambdaQueryWrapper<ApproveProcessConfigNode>().eq(ApproveProcessConfigNode::getApproveType, approveGetAndUpdateVo.getApproveType()));
+        List<Long> configNodeIds = approveProcessConfig.stream()
+                .sorted(Comparator.comparing(ApproveProcessConfigNode::getNodeOrder))
+                .map(ApproveProcessConfigNode::getApproverId)
+                .collect(Collectors.toList());
+        List<SysUser> sysUsers = sysUserMapper.selectUserByIds(configNodeIds);
         if (CollectionUtils.isEmpty(sysUsers)) throw new RuntimeException("璇烽�夋嫨瀹℃壒浜�");
         //瀹℃牳涓笉鍙互缂栬緫瀹℃牳浜�
         if (approveProcess.getApproveStatus() != 1) {
-            approveProcess.setApproveUserCurrentId(Long.parseLong(split[0]));
-            approveProcess.setApproveUserCurrentName(sysUsers.stream().filter(user -> user.getUserId().equals(Long.parseLong(split[0]))).collect(Collectors.toList()).get(0).getNickName());
+            approveProcess.setApproveUserCurrentId(configNodeIds.get(0));
+            approveProcess.setApproveUserCurrentName(sysUsers.stream().filter(user -> user.getUserId().equals(configNodeIds.get(0))).collect(Collectors.toList()).get(0).getNickName());
         }
         if (approveGetAndUpdateVo.getApproveStatus() != null) {
             approveProcess.setApproveStatus(approveGetAndUpdateVo.getApproveStatus());
@@ -322,21 +328,24 @@
         LambdaQueryWrapper<ApproveNode> approveNodeLambdaQueryWrapper = new LambdaQueryWrapper<>();
         approveNodeLambdaQueryWrapper.eq(ApproveNode::getApproveProcessId, approveProcess.getApproveId())
                 .eq(ApproveNode::getDeleteFlag, 0)
-//                .eq(ApproveNode::getTenantId, SecurityUtils.getLoginUser().getTenantId())
                 .orderByAsc(ApproveNode::getApproveNodeOrder);
         approveNodeMapper.delete(approveNodeLambdaQueryWrapper);
+        //鏌ヨ瀹℃壒閰嶇疆
+        approveGetAndUpdateVo.setApproveUserIds(configNodeIds.stream()
+                .map(String::valueOf)
+                .collect(Collectors.joining(",")));
         approveNodeService.initApproveNodes(approveGetAndUpdateVo.getApproveUserIds(), approveProcess.getApproveId(), approveProcess.getTenantId());
         /*娑堟伅閫氱煡*/
-        String id = approveProcess.getApproveUserIds().split(",")[0];
+        Long id = configNodeIds.get(0);
         if (approveProcess.getApproveType()==8){
             sysNoticeService.simpleNoticeByUser(approveProcessType(approveProcess.getApproveType()),
                     approveProcess.getApproveId() + "娴佺▼缂栧彿鐨勫鎵归渶瑕佹偍瀹℃牳!!!!!",
-                    Arrays.asList(Long.valueOf(id)),
+                    Collections.singletonList(id),
                     "/safeProduction/safeWorkApproval?approveType=" + approveProcess.getApproveType() + "&approveId=" + approveProcess.getApproveId());
         }else {
             sysNoticeService.simpleNoticeByUser(approveProcessType(approveProcess.getApproveType()),
                     approveProcess.getApproveId() + "娴佺▼缂栧彿鐨勫鎵归渶瑕佹偍瀹℃牳!!!!!",
-                    Arrays.asList(Long.valueOf(id)),
+                    Collections.singletonList(id),
                     "/collaborativeApproval/approvalProcess?approveType=" + approveProcess.getApproveType() + "&approveId=" + approveProcess.getApproveId());
         }
     }
diff --git a/src/main/java/com/ruoyi/basic/controller/StorageAttachmentController.java b/src/main/java/com/ruoyi/basic/controller/StorageAttachmentController.java
index 17cbb47..d79f911 100644
--- a/src/main/java/com/ruoyi/basic/controller/StorageAttachmentController.java
+++ b/src/main/java/com/ruoyi/basic/controller/StorageAttachmentController.java
@@ -18,19 +18,18 @@
 
 @RestController
 @AllArgsConstructor
-@RequestMapping("/basic/storage_attachment")
+    @RequestMapping("/basic/storage_attachment")
 public class StorageAttachmentController {
     private StorageAttachmentService storageAttachmentService;
 
     /**
      * 鍒嗛〉鏌ヨ閫氱敤鏂囦欢涓婁紶鐨勯檮浠朵俊鎭�
-     * @param page 鍒嗛〉鍙傛暟
      * @param storageAttachmentDTO 鍏宠仈璁板綍淇℃伅
      * @return 鍒嗛〉缁撴灉
      */
-    @GetMapping("/listPage")
-    public R listPage(Page page, StorageAttachmentDTO storageAttachmentDTO) {
-        return R.ok(storageAttachmentService.listPage(page, storageAttachmentDTO));
+    @GetMapping("/list")
+    public R list(StorageAttachmentDTO storageAttachmentDTO) {
+        return R.ok(storageAttachmentService.list(storageAttachmentDTO));
     }
 
     /**
diff --git a/src/main/java/com/ruoyi/basic/dto/StorageBlobVO.java b/src/main/java/com/ruoyi/basic/dto/StorageBlobVO.java
index 88fa3a2..75eed4f 100644
--- a/src/main/java/com/ruoyi/basic/dto/StorageBlobVO.java
+++ b/src/main/java/com/ruoyi/basic/dto/StorageBlobVO.java
@@ -14,4 +14,6 @@
      * 涓嬭浇鍦板潃
      */
     private String downloadURL;
+
+    private Long storageAttachmentId;
 }
diff --git a/src/main/java/com/ruoyi/basic/service/StorageAttachmentService.java b/src/main/java/com/ruoyi/basic/service/StorageAttachmentService.java
index b8a3f8a..be7e0cb 100644
--- a/src/main/java/com/ruoyi/basic/service/StorageAttachmentService.java
+++ b/src/main/java/com/ruoyi/basic/service/StorageAttachmentService.java
@@ -6,6 +6,7 @@
 import com.ruoyi.basic.dto.StorageAttachmentDTO;
 import com.ruoyi.basic.dto.StorageAttachmentVO;
 import com.ruoyi.basic.dto.StorageBlobDTO;
+import com.ruoyi.basic.dto.StorageBlobVO;
 import com.ruoyi.basic.enums.ApplicationTypeEnum;
 import com.ruoyi.basic.enums.RecordTypeEnum;
 import com.ruoyi.basic.pojo.StorageAttachment;
@@ -31,11 +32,10 @@
 
     /**
      * 鍒嗛〉鏌ヨ閫氱敤鏂囦欢涓婁紶鐨勯檮浠朵俊鎭�
-     * @param page 鍒嗛〉鍙傛暟
      * @param storageAttachmentDTO 鍏宠仈璁板綍淇℃伅
      * @return 鍒嗛〉缁撴灉
      */
-    public IPage<StorageAttachmentVO> listPage(Page page, StorageAttachmentDTO storageAttachmentDTO);
+    public List<StorageBlobVO> list(StorageAttachmentDTO storageAttachmentDTO);
 
     /**
      * 鍒犻櫎閫氱敤鏂囦欢涓婁紶鐨勯檮浠朵俊鎭�
diff --git a/src/main/java/com/ruoyi/basic/service/impl/StorageAttachmentServiceImpl.java b/src/main/java/com/ruoyi/basic/service/impl/StorageAttachmentServiceImpl.java
index e645380..fda9f26 100644
--- a/src/main/java/com/ruoyi/basic/service/impl/StorageAttachmentServiceImpl.java
+++ b/src/main/java/com/ruoyi/basic/service/impl/StorageAttachmentServiceImpl.java
@@ -1,12 +1,8 @@
 package com.ruoyi.basic.service.impl;
 
-import com.baomidou.mybatisplus.core.metadata.IPage;
-import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.ruoyi.basic.dto.StorageAttachmentDTO;
-import com.ruoyi.basic.dto.StorageAttachmentVO;
-import com.ruoyi.basic.dto.StorageBlobDTO;
-import com.ruoyi.basic.enums.ApplicationTypeEnum;
+import com.ruoyi.basic.dto.StorageBlobVO;
 import com.ruoyi.basic.enums.RecordTypeEnum;
 import com.ruoyi.basic.mapper.StorageAttachmentMapper;
 import com.ruoyi.basic.mapper.StorageBlobMapper;
@@ -45,8 +41,8 @@
     }
 
     @Override
-    public IPage<StorageAttachmentVO> listPage(Page page, StorageAttachmentDTO storageAttachmentDTO) {
-        return fileUtil.getStorageAttachmentVosPageListByApplicationAndRecordTypeAndRecordId(page, storageAttachmentDTO);
+    public List<StorageBlobVO> list(StorageAttachmentDTO storageAttachmentDTO) {
+        return fileUtil.getStorageBlobVOsByApplicationAndRecordTypeAndRecordId(storageAttachmentDTO);
     }
 
     @Override
diff --git a/src/main/java/com/ruoyi/basic/utils/FileUtil.java b/src/main/java/com/ruoyi/basic/utils/FileUtil.java
index 0e3d10d..c57468a 100644
--- a/src/main/java/com/ruoyi/basic/utils/FileUtil.java
+++ b/src/main/java/com/ruoyi/basic/utils/FileUtil.java
@@ -286,41 +286,20 @@
     /**
      * 閫氳繃璁板綍绫诲瀷鑾峰彇鏂囦欢淇℃伅 attachment锛堝垎椤碉級
      *
-     * @param page       鍒嗛〉鍙傛暟
      * @param storageAttachmentDTO 鍏宠仈璁板綍淇℃伅
      */
-    public IPage<StorageAttachmentVO> getStorageAttachmentVosPageListByApplicationAndRecordTypeAndRecordId(Page page, StorageAttachmentDTO storageAttachmentDTO) {
-        // 鍒嗛〉鏌ヨ绗﹀悎鏉′欢鐨� StorageAttachment 璁板綍
+    public List<StorageBlobVO> getStorageBlobVOsByApplicationAndRecordTypeAndRecordId(StorageAttachmentDTO storageAttachmentDTO) {
         LambdaQueryWrapper<StorageAttachment> queryWrapper = new LambdaQueryWrapper<StorageAttachment>()
                 .eq(StorageAttachment::getRecordType, storageAttachmentDTO.getRecordType())
                 .eq(StorageAttachment::getRecordId, storageAttachmentDTO.getRecordId());
         if (storageAttachmentDTO.getApplication() != null) {
             queryWrapper.eq(StorageAttachment::getApplication, storageAttachmentDTO.getApplication());
         }
-        IPage<StorageAttachmentVO> storageAttachmentIPage = storageAttachmentMapper.selectPage(page, queryWrapper);
-
-        // 杞崲涓� StorageAttachmentVO 骞惰幏鍙栧搴旂殑 StorageBlobVO
-        List<StorageAttachmentVO> storageAttachmentVOS = new ArrayList<>();
-        if (CollectionUtils.isNotEmpty(storageAttachmentIPage.getRecords())) {
-            for (StorageAttachment storageAttachment : storageAttachmentIPage.getRecords()) {
-                StorageAttachmentVO storageAttachmentVO = new StorageAttachmentVO();
-                BeanUtils.copyProperties(storageAttachment, storageAttachmentVO);
-                List<StorageBlobVO> storageBlobVOS = getStorageBlobVOsByStorageAttachmentIds(Collections.singletonList(storageAttachment.getId()));
-                if (CollectionUtils.isEmpty(storageBlobVOS)) {
-                    storageAttachmentVO.setStorageBlobVOS(new ArrayList<>());
-                } else {
-                    storageAttachmentVO.setStorageBlobVOS(storageBlobVOS);
-                }
-                storageAttachmentVOS.add(storageAttachmentVO);
-            }
+        List<StorageAttachment> storageAttachments = storageAttachmentMapper.selectList(queryWrapper);
+        if (CollectionUtils.isEmpty(storageAttachments)) {
+            return null;
         }
-
-        // 鏋勫缓鍒嗛〉缁撴灉
-        IPage<StorageAttachmentVO> resultPage = new Page<>();
-        BeanUtils.copyProperties(storageAttachmentIPage, resultPage);
-        resultPage.setRecords(storageAttachmentVOS);
-
-        return resultPage;
+        return getStorageBlobVOsByStorageAttachmentIds(storageAttachments.stream().map(StorageAttachment::getId).collect(Collectors.toList()));
     }
 
     /**
@@ -355,6 +334,9 @@
         if (CollectionUtils.isEmpty(storageAttachments)) {
             return null;
         }
+        Map<Long, Long> blobIdToAttachmentIdMap = storageAttachments.stream()
+                .collect(Collectors.toMap(StorageAttachment::getStorageBlobId, StorageAttachment::getId));
+
         List<Long> storageBlobIds = storageAttachments.stream().map(StorageAttachment::getStorageBlobId).collect(Collectors.toList());
         List<StorageBlob> storageBlobs = storageBlobMapper.selectByIds(storageBlobIds);
         List<StorageBlobVO> storageBlobDTOS = new ArrayList<>();
@@ -363,6 +345,7 @@
             BeanUtils.copyProperties(storageBlob, storageBlobVO);
             storageBlobVO.setPreviewURL(buildSignedPreviewUrl(storageBlobVO));
             storageBlobVO.setDownloadURL(buildSignedDownloadUrl(storageBlobVO));
+            storageBlobVO.setStorageAttachmentId(blobIdToAttachmentIdMap.get(storageBlob.getId()));
             storageBlobDTOS.add(storageBlobVO);
         }
         return storageBlobDTOS;
@@ -398,6 +381,10 @@
         if (CollectionUtils.isEmpty(storageAttachments)) {
             return null;
         }
+        // 鏋勫缓 storageBlobId -> storageAttachmentId 鐨勬槧灏�
+        Map<Long, Long> blobIdToAttachmentIdMap = storageAttachments.stream()
+                .collect(Collectors.toMap(StorageAttachment::getStorageBlobId, StorageAttachment::getId));
+
         List<Long> storageBlobIds = storageAttachments.stream().map(StorageAttachment::getStorageBlobId).collect(Collectors.toList());
         List<StorageBlob> storageBlobs = storageBlobMapper.selectByIds(storageBlobIds);
         List<StorageBlobVO> storageBlobDTOS = new ArrayList<>();
@@ -406,6 +393,7 @@
             BeanUtils.copyProperties(storageBlob, storageBlobVO);
             storageBlobVO.setPreviewURL(buildSignedPreviewUrl(storageBlobVO));
             storageBlobVO.setDownloadURL(buildSignedDownloadUrl(storageBlobVO));
+            storageBlobVO.setStorageAttachmentId(blobIdToAttachmentIdMap.get(storageBlob.getId()));
             storageBlobDTOS.add(storageBlobVO);
         }
         return storageBlobDTOS;
@@ -448,6 +436,10 @@
         if (CollectionUtils.isEmpty(storageAttachments)) {
             return null;
         }
+        // 鏋勫缓 storageBlobId -> storageAttachmentId 鐨勬槧灏�
+        Map<Long, Long> blobIdToAttachmentIdMap = storageAttachments.stream()
+                .collect(Collectors.toMap(StorageAttachment::getStorageBlobId, StorageAttachment::getId));
+
         List<Long> storageBlobIds = storageAttachments.stream().map(StorageAttachment::getStorageBlobId).collect(Collectors.toList());
         List<StorageBlob> storageBlobs = storageBlobMapper.selectByIds(storageBlobIds);
         List<StorageBlobVO> storageBlobDTOS = new ArrayList<>();
@@ -456,6 +448,7 @@
             BeanUtils.copyProperties(storageBlob, storageBlobVO);
             storageBlobVO.setPreviewURL(buildSignedUrl(storageBlobVO, "/preview/", expired));
             storageBlobVO.setDownloadURL(buildSignedUrl(storageBlobVO, "/download/", expired));
+            storageBlobVO.setStorageAttachmentId(blobIdToAttachmentIdMap.get(storageBlob.getId()));
             storageBlobDTOS.add(storageBlobVO);
         }
         return storageBlobDTOS;
diff --git a/src/main/java/com/ruoyi/device/controller/DeviceMaintenanceController.java b/src/main/java/com/ruoyi/device/controller/DeviceMaintenanceController.java
index e53953d..e34fc37 100644
--- a/src/main/java/com/ruoyi/device/controller/DeviceMaintenanceController.java
+++ b/src/main/java/com/ruoyi/device/controller/DeviceMaintenanceController.java
@@ -34,7 +34,7 @@
 
     @PostMapping()
     @Operation(summary = "娣诲姞璁惧淇濆吇")
-    public AjaxResult add(@RequestBody DeviceMaintenance deviceMaintenance) {
+    public AjaxResult add(@RequestBody DeviceMaintenanceDto deviceMaintenance) {
         DeviceLedger byId = deviceLedgerService.getById(deviceMaintenance.getDeviceLedgerId());
         deviceMaintenance.setDeviceName(byId.getDeviceName());
         deviceMaintenance.setDeviceModel(byId.getDeviceModel());
@@ -49,7 +49,7 @@
 
     @PutMapping ()
     @Operation(summary = "淇敼璁惧淇濆吇")
-    public AjaxResult update(@RequestBody DeviceMaintenance deviceMaintenance) {
+    public AjaxResult update(@RequestBody DeviceMaintenanceDto deviceMaintenance) {
         DeviceLedger byId = deviceLedgerService.getById(deviceMaintenance.getDeviceLedgerId());
         deviceMaintenance.setDeviceName(byId.getDeviceName());
         deviceMaintenance.setDeviceModel(byId.getDeviceModel());
@@ -58,7 +58,7 @@
 
     @PostMapping ("maintenance")
     @Operation(summary = "淇敼璁惧淇濆吇")
-    public AjaxResult maintenance(@RequestBody DeviceMaintenance deviceMaintenance) {
+    public AjaxResult maintenance(@RequestBody DeviceMaintenanceDto deviceMaintenance) {
         return deviceMaintenanceService.updateDeviceDeviceMaintenance(deviceMaintenance);
     }
 
diff --git a/src/main/java/com/ruoyi/device/controller/DeviceRepairController.java b/src/main/java/com/ruoyi/device/controller/DeviceRepairController.java
index 8e969ad..d3c19bb 100644
--- a/src/main/java/com/ruoyi/device/controller/DeviceRepairController.java
+++ b/src/main/java/com/ruoyi/device/controller/DeviceRepairController.java
@@ -30,27 +30,26 @@
 
     @PostMapping()
     @Operation(summary = "娣诲姞璁惧鎶ヤ慨")
-    public AjaxResult add( @RequestBody DeviceRepair deviceRepair) {
-        return deviceRepairService.saveDeviceRepair(deviceRepair);
+    public AjaxResult add( @RequestBody DeviceRepairDto deviceRepairDto) {
+        return deviceRepairService.saveDeviceRepair(deviceRepairDto);
     }
 
     @Operation(summary = "鏍规嵁id鏌ヨ璁惧鎶ヤ慨")
     @GetMapping("/{id}")
     public AjaxResult detail(@PathVariable Long id) {
-        DeviceRepairDto byId = deviceRepairService.detailById(id);
-        return AjaxResult.success(byId);
+        return AjaxResult.success(deviceRepairService.detailById(id));
     }
 
     @PutMapping ()
     @Operation(summary = "淇敼璁惧鎶ヤ慨")
-    public AjaxResult update( @RequestBody DeviceRepair deviceRepair) {
-        return deviceRepairService.updateDeviceRepair(deviceRepair);
+    public AjaxResult update( @RequestBody DeviceRepairDto deviceRepairDto) {
+        return deviceRepairService.updateDeviceRepair(deviceRepairDto);
     }
 
     @PostMapping ("repair")
     @Operation(summary = "璁惧缁翠慨")
-    public AjaxResult repair( @RequestBody DeviceRepair deviceRepair) {
-        return deviceRepairService.updateDeviceRepair(deviceRepair);
+    public AjaxResult repair( @RequestBody DeviceRepairDto deviceRepairDto) {
+        return deviceRepairService.updateDeviceRepair(deviceRepairDto);
     }
 
     @DeleteMapping("/{ids}")
diff --git a/src/main/java/com/ruoyi/device/dto/DeviceMaintenanceDto.java b/src/main/java/com/ruoyi/device/dto/DeviceMaintenanceDto.java
index 75b870c..127d82b 100644
--- a/src/main/java/com/ruoyi/device/dto/DeviceMaintenanceDto.java
+++ b/src/main/java/com/ruoyi/device/dto/DeviceMaintenanceDto.java
@@ -2,11 +2,13 @@
 
 import com.baomidou.mybatisplus.annotation.FieldFill;
 import com.baomidou.mybatisplus.annotation.TableField;
+import com.ruoyi.basic.dto.StorageBlobDTO;
 import com.ruoyi.device.pojo.DeviceMaintenance;
 import io.swagger.v3.oas.annotations.media.Schema;
 import lombok.Data;
 
 import java.time.LocalDateTime;
+import java.util.List;
 
 @Data
 public class DeviceMaintenanceDto extends DeviceMaintenance {
@@ -47,5 +49,9 @@
 
     @Schema(description = "鍒涘缓浜哄悕绉�")
     private String createUserName;
+
+    @Schema(description = "淇濆吇鍥剧墖")
+    private List<StorageBlobDTO> storageBlobDTOs;
+
 }
 
diff --git a/src/main/java/com/ruoyi/device/dto/DeviceRepairDto.java b/src/main/java/com/ruoyi/device/dto/DeviceRepairDto.java
index 34b3086..12def24 100644
--- a/src/main/java/com/ruoyi/device/dto/DeviceRepairDto.java
+++ b/src/main/java/com/ruoyi/device/dto/DeviceRepairDto.java
@@ -1,8 +1,11 @@
 package com.ruoyi.device.dto;
 
+import com.ruoyi.basic.dto.StorageBlobDTO;
 import com.ruoyi.device.pojo.DeviceRepair;
 import io.swagger.v3.oas.annotations.media.Schema;
 import lombok.Data;
+
+import java.util.List;
 
 @Data
 public class DeviceRepairDto extends DeviceRepair {
@@ -12,4 +15,6 @@
 
     @Schema(description = "缁翠慨鏃堕棿瀛楃涓�")
     private String maintenanceTimeStr;
+
+    private List<StorageBlobDTO> storageBlobDTOs;
 }
diff --git a/src/main/java/com/ruoyi/device/execl/DeviceMaintenanceExeclDto.java b/src/main/java/com/ruoyi/device/execl/DeviceMaintenanceExeclDto.java
index 0614da2..809e4e6 100644
--- a/src/main/java/com/ruoyi/device/execl/DeviceMaintenanceExeclDto.java
+++ b/src/main/java/com/ruoyi/device/execl/DeviceMaintenanceExeclDto.java
@@ -21,6 +21,10 @@
     @Schema(description = "瑙勬牸鍨嬪彿")
     private String deviceModel;
 
+    @Schema(description = "椤圭洰")
+    @Excel(name = "椤圭洰")
+    private String machineryCategory;
+
     @Excel(name = "璁″垝淇濆吇鏃ユ湡", dateFormat = "yyyy-MM-dd HH:mm:ss", width = 30)
     @Schema(description = "璁″垝淇濆吇鏃ユ湡")
     private Date maintenancePlanTime;
diff --git a/src/main/java/com/ruoyi/device/execl/DeviceRepairExeclDto.java b/src/main/java/com/ruoyi/device/execl/DeviceRepairExeclDto.java
index 7e0a580..c782da2 100644
--- a/src/main/java/com/ruoyi/device/execl/DeviceRepairExeclDto.java
+++ b/src/main/java/com/ruoyi/device/execl/DeviceRepairExeclDto.java
@@ -19,6 +19,10 @@
     @Excel(name = "璁惧鍨嬪彿")
     private String deviceModel;
 
+    @Schema(description = "椤圭洰")
+    @Excel(name = "椤圭洰")
+    private String machineryCategory;
+
     @Schema(description = "鎶ヤ慨鏃堕棿")
     @Excel(name = "鎶ヤ慨鏃堕棿", width = 30, dateFormat = "yyyy-MM-dd")
     private Date repairTime;
diff --git a/src/main/java/com/ruoyi/device/mapper/DeviceMaintenanceMapper.java b/src/main/java/com/ruoyi/device/mapper/DeviceMaintenanceMapper.java
index 1e2c049..0fd6c72 100644
--- a/src/main/java/com/ruoyi/device/mapper/DeviceMaintenanceMapper.java
+++ b/src/main/java/com/ruoyi/device/mapper/DeviceMaintenanceMapper.java
@@ -7,6 +7,7 @@
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.ruoyi.device.dto.DeviceMaintenanceDto;
 import com.ruoyi.device.pojo.DeviceMaintenance;
+import com.ruoyi.device.vo.DeviceMaintenanceVo;
 import org.apache.ibatis.annotations.Mapper;
 
 import java.util.List;
@@ -16,7 +17,7 @@
 
     IPage<DeviceMaintenanceDto> queryPage(Page page, DeviceMaintenanceDto deviceMaintenanceDto);
 
-    DeviceMaintenanceDto detailById(Long id);
+    DeviceMaintenanceVo detailById(Long id);
 
     @InterceptorIgnore(tenantLine = "true")
     List<DeviceMaintenance> list1(Long id);
diff --git a/src/main/java/com/ruoyi/device/mapper/DeviceRepairMapper.java b/src/main/java/com/ruoyi/device/mapper/DeviceRepairMapper.java
index cbfcbcd..52af77a 100644
--- a/src/main/java/com/ruoyi/device/mapper/DeviceRepairMapper.java
+++ b/src/main/java/com/ruoyi/device/mapper/DeviceRepairMapper.java
@@ -5,12 +5,13 @@
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.ruoyi.device.dto.DeviceRepairDto;
 import com.ruoyi.device.pojo.DeviceRepair;
+import com.ruoyi.device.vo.DeviceRepairVo;
 import org.apache.ibatis.annotations.Mapper;
 import org.apache.ibatis.annotations.Param;
 
 @Mapper
 public interface DeviceRepairMapper extends BaseMapper<DeviceRepair> {
-    IPage<DeviceRepairDto> queryPage(Page page, @Param("deviceRepairDto") DeviceRepairDto deviceRepairDto);
+    IPage<DeviceRepairVo> queryPage(Page page, @Param("deviceRepairDto") DeviceRepairDto deviceRepairDto);
 
-    DeviceRepairDto detailById(Long id);
+    DeviceRepairVo detailById(Long id);
 }
diff --git a/src/main/java/com/ruoyi/device/pojo/DeviceMaintenance.java b/src/main/java/com/ruoyi/device/pojo/DeviceMaintenance.java
index 2294338..b635e5f 100644
--- a/src/main/java/com/ruoyi/device/pojo/DeviceMaintenance.java
+++ b/src/main/java/com/ruoyi/device/pojo/DeviceMaintenance.java
@@ -37,7 +37,7 @@
     @Schema(description = "鏈�鍚庢墽琛屾椂闂�")
     private LocalDateTime lastExecutionTime;
 
-    @Schema(description = "璁惧绫荤洰")
+    @Schema(description = "璁惧椤圭洰")
     private String machineryCategory;
 
 
diff --git a/src/main/java/com/ruoyi/device/pojo/DeviceRepair.java b/src/main/java/com/ruoyi/device/pojo/DeviceRepair.java
index a469ee1..9db134e 100644
--- a/src/main/java/com/ruoyi/device/pojo/DeviceRepair.java
+++ b/src/main/java/com/ruoyi/device/pojo/DeviceRepair.java
@@ -34,8 +34,8 @@
 
     @Schema(description = "鎶ヤ慨鍐呭")
     private String remark;
-    
-    @Schema(description = "璁惧绫荤洰")
+
+    @Schema(description = "璁惧椤圭洰")
     private String machineryCategory;
 
 
diff --git a/src/main/java/com/ruoyi/device/service/IDeviceMaintenanceService.java b/src/main/java/com/ruoyi/device/service/IDeviceMaintenanceService.java
index 294ffd2..e5a4080 100644
--- a/src/main/java/com/ruoyi/device/service/IDeviceMaintenanceService.java
+++ b/src/main/java/com/ruoyi/device/service/IDeviceMaintenanceService.java
@@ -5,6 +5,7 @@
 import com.baomidou.mybatisplus.extension.service.IService;
 import com.ruoyi.device.dto.DeviceMaintenanceDto;
 import com.ruoyi.device.pojo.DeviceMaintenance;
+import com.ruoyi.device.vo.DeviceMaintenanceVo;
 import com.ruoyi.framework.web.domain.AjaxResult;
 
 import jakarta.servlet.http.HttpServletResponse;
@@ -13,11 +14,11 @@
 
     IPage<DeviceMaintenanceDto> queryPage(Page page, DeviceMaintenanceDto deviceMaintenanceDto);
 
-    AjaxResult saveDeviceRepair(DeviceMaintenance deviceMaintenance);
+    AjaxResult saveDeviceRepair(DeviceMaintenanceDto deviceMaintenance);
 
-    AjaxResult updateDeviceDeviceMaintenance(DeviceMaintenance deviceMaintenance);
+    AjaxResult updateDeviceDeviceMaintenance(DeviceMaintenanceDto deviceMaintenance);
 
     void export(HttpServletResponse response, Long[] ids);
 
-    DeviceMaintenanceDto detailById(Long id);
+    DeviceMaintenanceVo detailById(Long id);
 }
diff --git a/src/main/java/com/ruoyi/device/service/IDeviceRepairService.java b/src/main/java/com/ruoyi/device/service/IDeviceRepairService.java
index c785435..8d20acd 100644
--- a/src/main/java/com/ruoyi/device/service/IDeviceRepairService.java
+++ b/src/main/java/com/ruoyi/device/service/IDeviceRepairService.java
@@ -5,6 +5,7 @@
 import com.baomidou.mybatisplus.extension.service.IService;
 import com.ruoyi.device.dto.DeviceRepairDto;
 import com.ruoyi.device.pojo.DeviceRepair;
+import com.ruoyi.device.vo.DeviceRepairVo;
 import com.ruoyi.framework.web.domain.AjaxResult;
 
 import jakarta.servlet.http.HttpServletResponse;
@@ -12,13 +13,13 @@
 
 public interface IDeviceRepairService extends IService<DeviceRepair> {
 
-    IPage<DeviceRepairDto> queryPage(Page page, DeviceRepairDto deviceRepairDto);
+    IPage<DeviceRepairVo> queryPage(Page page, DeviceRepairDto deviceRepairDto);
 
-    AjaxResult saveDeviceRepair(DeviceRepair deviceRepair);
+    AjaxResult saveDeviceRepair(DeviceRepairDto deviceRepairDto);
 
-    AjaxResult updateDeviceRepair(DeviceRepair deviceRepair);
+    AjaxResult updateDeviceRepair(DeviceRepairDto deviceRepairDto);
 
     void export(HttpServletResponse response, Long[] ids);
 
-    DeviceRepairDto detailById(Long id);
+    DeviceRepairVo detailById(Long id);
 }
diff --git a/src/main/java/com/ruoyi/device/service/impl/DeviceMaintenanceServiceImpl.java b/src/main/java/com/ruoyi/device/service/impl/DeviceMaintenanceServiceImpl.java
index b5bb664..fbf03ad 100644
--- a/src/main/java/com/ruoyi/device/service/impl/DeviceMaintenanceServiceImpl.java
+++ b/src/main/java/com/ruoyi/device/service/impl/DeviceMaintenanceServiceImpl.java
@@ -4,6 +4,8 @@
 import com.baomidou.mybatisplus.core.metadata.IPage;
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.ruoyi.basic.enums.RecordTypeEnum;
+import com.ruoyi.basic.utils.FileUtil;
 import com.ruoyi.common.utils.bean.BeanUtils;
 import com.ruoyi.common.utils.poi.ExcelUtil;
 import com.ruoyi.device.dto.DeviceMaintenanceDto;
@@ -11,6 +13,8 @@
 import com.ruoyi.device.mapper.DeviceMaintenanceMapper;
 import com.ruoyi.device.pojo.DeviceMaintenance;
 import com.ruoyi.device.service.IDeviceMaintenanceService;
+import com.ruoyi.device.vo.DeviceMaintenanceVo;
+import com.ruoyi.device.vo.DeviceRepairVo;
 import com.ruoyi.framework.web.domain.AjaxResult;
 import com.ruoyi.measuringinstrumentledger.mapper.SparePartsMapper;
 import com.ruoyi.measuringinstrumentledger.pojo.SpareParts;
@@ -34,6 +38,7 @@
     private final DeviceMaintenanceMapper deviceMaintenanceMapper;
     private final SparePartsMapper sparePartsMapper;
     private final SparePartsRequisitionRecordService sparePartsRequisitionRecordService;
+    private final FileUtil fileUtil;
 
     @Override
     public IPage<DeviceMaintenanceDto> queryPage(Page page, DeviceMaintenanceDto deviceMaintenanceDto) {
@@ -42,9 +47,12 @@
     }
 
     @Override
-    public AjaxResult saveDeviceRepair(DeviceMaintenance deviceMaintenance) {
+    @Transactional(rollbackFor = Exception.class)
+    public AjaxResult saveDeviceRepair(DeviceMaintenanceDto deviceMaintenance) {
         boolean save = this.save(deviceMaintenance);
         if (save){
+            // 澶勭悊鍥剧墖涓婁紶
+            fileUtil.saveStorageAttachmentByRecordTypeAndRecordId("file", RecordTypeEnum.DEVICE_MAINTENANCE, deviceMaintenance.getId(), deviceMaintenance.getStorageBlobDTOs());
             return AjaxResult.success();
         }
         return AjaxResult.error();
@@ -52,7 +60,7 @@
 
     @Override
     @Transactional(rollbackFor = Exception.class)
-    public AjaxResult updateDeviceDeviceMaintenance(DeviceMaintenance deviceMaintenance) {
+    public AjaxResult updateDeviceDeviceMaintenance(DeviceMaintenanceDto deviceMaintenance) {
         DeviceMaintenance oldDeviceMaintenance = this.getById(deviceMaintenance.getId());
         // 澶勭悊澶囦欢浣跨敤鎯呭喌
         if (com.github.xiaoymin.knife4j.core.util.CollectionUtils.isNotEmpty(deviceMaintenance.getSparePartsUseList())) {
@@ -88,6 +96,8 @@
         }
 
         if (this.updateById(deviceMaintenance)) {
+            // 澶勭悊鍥剧墖涓婁紶
+            fileUtil.saveStorageAttachmentByRecordTypeAndRecordId("file", RecordTypeEnum.DEVICE_MAINTENANCE, deviceMaintenance.getId(), deviceMaintenance.getStorageBlobDTOs());
             return AjaxResult.success();
         }
         return AjaxResult.error();
@@ -109,8 +119,9 @@
     }
 
     @Override
-    public DeviceMaintenanceDto detailById(Long id) {
-
-        return deviceMaintenanceMapper.detailById(id);
+    public DeviceMaintenanceVo detailById(Long id) {
+        DeviceMaintenanceVo vo = deviceMaintenanceMapper.detailById(id);
+        vo.setStorageBlobVOs(fileUtil.getStorageBlobVOsByRecordTypeAndRecordId(RecordTypeEnum.DEVICE_MAINTENANCE, id));
+        return vo;
     }
 }
diff --git a/src/main/java/com/ruoyi/device/service/impl/DeviceRepairServiceImpl.java b/src/main/java/com/ruoyi/device/service/impl/DeviceRepairServiceImpl.java
index 8a0aa53..897e569 100644
--- a/src/main/java/com/ruoyi/device/service/impl/DeviceRepairServiceImpl.java
+++ b/src/main/java/com/ruoyi/device/service/impl/DeviceRepairServiceImpl.java
@@ -4,6 +4,9 @@
 import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.github.xiaoymin.knife4j.core.util.CollectionUtils;
+import com.ruoyi.basic.enums.ApplicationTypeEnum;
+import com.ruoyi.basic.enums.RecordTypeEnum;
+import com.ruoyi.basic.utils.FileUtil;
 import com.ruoyi.common.utils.bean.BeanUtils;
 import com.ruoyi.common.utils.poi.ExcelUtil;
 import com.ruoyi.device.dto.DeviceDefectRecordDto;
@@ -15,6 +18,7 @@
 import com.ruoyi.device.service.DeviceDefectRecordService;
 import com.ruoyi.device.service.IDeviceLedgerService;
 import com.ruoyi.device.service.IDeviceRepairService;
+import com.ruoyi.device.vo.DeviceRepairVo;
 import com.ruoyi.framework.web.domain.AjaxResult;
 import com.ruoyi.measuringinstrumentledger.mapper.SparePartsMapper;
 import com.ruoyi.measuringinstrumentledger.pojo.SpareParts;
@@ -42,33 +46,40 @@
     private final IDeviceLedgerService deviceLedgerService;
     private final SparePartsMapper sparePartsMapper;
     private final SparePartsRequisitionRecordService sparePartsRequisitionRecordService;
+    private final FileUtil fileUtil;
 
     @Override
-    public IPage<DeviceRepairDto> queryPage(Page page, DeviceRepairDto deviceRepairDto) {
-
-        return deviceRepairMapper.queryPage(page, deviceRepairDto);
-    }
-
-    @Override
-    public AjaxResult saveDeviceRepair(DeviceRepair deviceRepair) {
-        DeviceLedger byId = deviceLedgerService.getById(deviceRepair.getDeviceLedgerId());
-        deviceRepair.setDeviceName(byId.getDeviceName());
-        deviceRepair.setDeviceModel(byId.getDeviceModel());
-        boolean save = this.save(deviceRepair);
-        if (save){
-            return AjaxResult.success();
+    public IPage<DeviceRepairVo> queryPage(Page page, DeviceRepairDto deviceRepairDto) {
+        IPage<DeviceRepairVo> pageDto = deviceRepairMapper.queryPage(page, deviceRepairDto);
+        for (DeviceRepairVo vo : pageDto.getRecords()) {
+           vo.setStorageBlobVOs(fileUtil.getStorageBlobVOsByRecordTypeAndRecordId(RecordTypeEnum.DEVICE_REPAIR, vo.getId()));
         }
-        return AjaxResult.error();
+        return pageDto;
     }
 
     @Override
     @Transactional(rollbackFor = Exception.class)
-    public AjaxResult updateDeviceRepair(DeviceRepair deviceRepair) {
-        DeviceRepair oldDeviceRepair = this.getById(deviceRepair.getId());
+    public AjaxResult saveDeviceRepair(DeviceRepairDto deviceRepairDto) {
+        DeviceLedger byId = deviceLedgerService.getById(deviceRepairDto.getDeviceLedgerId());
+        deviceRepairDto.setDeviceName(byId.getDeviceName());
+        deviceRepairDto.setDeviceModel(byId.getDeviceModel());
+        boolean save = this.save(deviceRepairDto);
+        if (save) {
+            // 澶勭悊鍥剧墖涓婁紶
+            fileUtil.saveStorageAttachmentByRecordTypeAndRecordId("file", RecordTypeEnum.DEVICE_REPAIR, deviceRepairDto.getId(), deviceRepairDto.getStorageBlobDTOs());
+            return AjaxResult.success();
+        }
+        return AjaxResult.error("淇濆瓨澶辫触");
+    }
+
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public AjaxResult updateDeviceRepair(DeviceRepairDto deviceRepairDto) {
+        DeviceRepair oldDeviceRepair = this.getById(deviceRepairDto.getId());
         // 澶勭悊澶囦欢浣跨敤鎯呭喌
-        if (CollectionUtils.isNotEmpty(deviceRepair.getSparePartsUseList())) {
+        if (CollectionUtils.isNotEmpty(deviceRepairDto.getSparePartsUseList())) {
             List<Long> sparePartIds = new ArrayList<>();
-            for (DeviceRepair.SparePartUse sparePartUse : deviceRepair.getSparePartsUseList()) {
+            for (DeviceRepairDto.SparePartUse sparePartUse : deviceRepairDto.getSparePartsUseList()) {
                 // 鑾峰彇澶囦欢淇℃伅
                 SpareParts spareParts = sparePartsMapper.selectById(sparePartUse.getId());
                 if (spareParts != null) {
@@ -82,7 +93,7 @@
                         // 鍒涘缓澶囦欢棰嗙敤璁板綍
                         SparePartsRequisitionRecord record = new SparePartsRequisitionRecord();
                         record.setSourceType(0); // 0 缁翠慨
-                        record.setSourceId(deviceRepair.getId());
+                        record.setSourceId(deviceRepairDto.getId());
                         record.setDeviceLedgerId(oldDeviceRepair.getDeviceLedgerId());
                         record.setSparePartsId(sparePartUse.getId());
                         record.setQuantity(sparePartUse.getQuantity());
@@ -94,12 +105,12 @@
             }
             // 鏇存柊澶囦欢IDs瀛楁
             if (!sparePartIds.isEmpty()) {
-                deviceRepair.setSparePartsIds(StringUtils.join(sparePartIds, ","));
+                deviceRepairDto.setSparePartsIds(StringUtils.join(sparePartIds, ","));
             }
         }
 
-        if (this.updateById(deviceRepair)) {
-            Long id = deviceRepair.getId();
+        if (this.updateById(deviceRepairDto)) {
+            Long id = deviceRepairDto.getId();
             //
             DeviceDefectRecordDto deviceDefectRecordDto = new DeviceDefectRecordDto();
             deviceDefectRecordDto.setDeviceLedgerId(id);
@@ -111,6 +122,8 @@
                     deviceDefectRecordService.updateByDDR(deviceDefectRecord);
                 });
             }
+            // 澶勭悊鍥剧墖涓婁紶
+            fileUtil.saveStorageAttachmentByRecordTypeAndRecordId("file", RecordTypeEnum.DEVICE_REPAIR, id, deviceRepairDto.getStorageBlobDTOs());
             return AjaxResult.success();
         }
         return AjaxResult.error();
@@ -151,9 +164,10 @@
     }
 
     @Override
-    public DeviceRepairDto detailById(Long id) {
-
-        return deviceRepairMapper.detailById(id);
+    public DeviceRepairVo detailById(Long id) {
+        DeviceRepairVo vo = deviceRepairMapper.detailById(id);
+        vo.setStorageBlobVOs(fileUtil.getStorageBlobVOsByRecordTypeAndRecordId(RecordTypeEnum.DEVICE_REPAIR, id));
+        return vo;
     }
 
 }
diff --git a/src/main/java/com/ruoyi/device/vo/DeviceMaintenanceVo.java b/src/main/java/com/ruoyi/device/vo/DeviceMaintenanceVo.java
new file mode 100644
index 0000000..f71c5cb
--- /dev/null
+++ b/src/main/java/com/ruoyi/device/vo/DeviceMaintenanceVo.java
@@ -0,0 +1,51 @@
+package com.ruoyi.device.vo;
+
+import com.ruoyi.basic.dto.StorageBlobVO;
+import com.ruoyi.device.pojo.DeviceMaintenance;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.time.LocalDateTime;
+import java.util.List;
+
+@Data
+public class DeviceMaintenanceVo extends DeviceMaintenance {
+    @Schema(description = "璁惧淇濆吇id")
+    private Long id;
+
+    @Schema(description = "璁惧鍙拌处id")
+    private Long deviceLedgerId;
+
+    @Schema(description = "璁惧鍚嶇О")
+    private String deviceName;
+
+    @Schema(description = "瑙勬牸鍨嬪彿")
+    private String deviceModel;
+
+    @Schema(description = "瀹為檯淇濆吇浜�")
+    private String maintenanceActuallyName;
+
+    @Schema(description = "淇濆吇缁撴灉 0 缁翠慨 1 瀹屽ソ")
+    private String maintenanceResult;
+
+    @Schema(description = "鐘舵�� 0 寰呬繚鍏� 1 瀹岀粨 2 澶辫触")
+    private Integer status;
+
+    @Schema(description = "鍒涘缓鏃堕棿")
+    private LocalDateTime createTime;
+
+    @Schema(description = "鏇存柊鏃堕棿")
+    private LocalDateTime updateTime;
+
+    @Schema(description = "鏇存柊浜�")
+    private String updateUserName;
+
+    @Schema(description = "绉熸埛id")
+    private Long tenantId;
+
+    @Schema(description = "鍒涘缓浜哄悕绉�")
+    private String createUserName;
+
+    @Schema(description = "淇濆吇鍥剧墖鍒楄〃")
+    private List<StorageBlobVO> storageBlobVOs;
+}
diff --git a/src/main/java/com/ruoyi/device/vo/DeviceRepairVo.java b/src/main/java/com/ruoyi/device/vo/DeviceRepairVo.java
new file mode 100644
index 0000000..e90c501
--- /dev/null
+++ b/src/main/java/com/ruoyi/device/vo/DeviceRepairVo.java
@@ -0,0 +1,20 @@
+package com.ruoyi.device.vo;
+
+import com.ruoyi.basic.dto.StorageBlobVO;
+import com.ruoyi.device.pojo.DeviceRepair;
+import io.swagger.v3.oas.annotations.media.Schema;
+import lombok.Data;
+
+import java.util.List;
+
+@Data
+public class DeviceRepairVo extends DeviceRepair {
+
+    @Schema(description = "鎶ヤ慨鏃堕棿瀛楃涓�")
+    private String repairTimeStr;
+
+    @Schema(description = "缁翠慨鏃堕棿瀛楃涓�")
+    private String maintenanceTimeStr;
+
+    private List<StorageBlobVO> storageBlobVOs;
+}
diff --git a/src/main/resources/mapper/device/DeviceMaintenanceMapper.xml b/src/main/resources/mapper/device/DeviceMaintenanceMapper.xml
index e166457..e21669f 100644
--- a/src/main/resources/mapper/device/DeviceMaintenanceMapper.xml
+++ b/src/main/resources/mapper/device/DeviceMaintenanceMapper.xml
@@ -51,7 +51,7 @@
             </if>
         </where>
     </select>
-    <select id="detailById" resultType="com.ruoyi.device.dto.DeviceMaintenanceDto">
+    <select id="detailById" resultType="com.ruoyi.device.vo.DeviceMaintenanceVo">
         select dm.id,
                dm.device_ledger_id,
                dm.maintenance_plan_time,
diff --git a/src/main/resources/mapper/device/DeviceRepairMapper.xml b/src/main/resources/mapper/device/DeviceRepairMapper.xml
index aeb87a8..2eb1d29 100644
--- a/src/main/resources/mapper/device/DeviceRepairMapper.xml
+++ b/src/main/resources/mapper/device/DeviceRepairMapper.xml
@@ -5,7 +5,7 @@
 
 <mapper namespace="com.ruoyi.device.mapper.DeviceRepairMapper">
 
-    <select id="queryPage" resultType="com.ruoyi.device.dto.DeviceRepairDto">
+    <select id="queryPage" resultType="com.ruoyi.device.vo.DeviceRepairVo">
         select dr.id,
                dr.device_ledger_id,
                 dr.repair_time,
@@ -51,7 +51,7 @@
             </if>
         </where>
     </select>
-    <select id="detailById" resultType="com.ruoyi.device.dto.DeviceRepairDto">
+    <select id="detailById" resultType="com.ruoyi.device.vo.DeviceRepairVo">
         select dr.id,
                dr.device_ledger_id,
                dr.repair_time,
diff --git a/src/main/resources/mapper/sales/SalesQuotationMapper.xml b/src/main/resources/mapper/sales/SalesQuotationMapper.xml
index 1e358ca..cf15b63 100644
--- a/src/main/resources/mapper/sales/SalesQuotationMapper.xml
+++ b/src/main/resources/mapper/sales/SalesQuotationMapper.xml
@@ -9,6 +9,7 @@
         FROM sales_quotation t1
         LEFT JOIN approve_process t2 ON t1.quotation_no = t2.approve_reason and t2.approve_type = 6
         WHERE 1=1
+          and t2.approve_deleted = 0
         <if test="salesQuotationDto.quotationNo != null and salesQuotationDto.quotationNo != '' ">
             AND t1.quotation_no LIKE CONCAT('%',#{salesQuotationDto.quotationNo},'%')
         </if>

--
Gitblit v1.9.3