From bc9d77f6061a5c7f7deceaabc7c5ed6c17ad8c2f Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期一, 12 十月 2026 14:19:37 +0800
Subject: [PATCH] fix(wm/productissue): 修复物料匹配校验逻辑并迁移至 MDM 物料服务

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/qc/ipqc/MesQcIpqcServiceImpl.java |  252 ++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 231 insertions(+), 21 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/qc/ipqc/MesQcIpqcServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/qc/ipqc/MesQcIpqcServiceImpl.java
index eb962d7..748207d 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/qc/ipqc/MesQcIpqcServiceImpl.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/qc/ipqc/MesQcIpqcServiceImpl.java
@@ -1,13 +1,21 @@
 package cn.iocoder.yudao.module.mes.service.qc.ipqc;
 
+import cn.hutool.core.collection.CollUtil;
 import cn.hutool.core.util.ObjUtil;
 import cn.hutool.core.util.ObjectUtil;
+import cn.hutool.core.util.StrUtil;
+import cn.iocoder.yudao.framework.common.exception.ServiceException;
 import cn.iocoder.yudao.framework.common.pojo.PageResult;
 import cn.iocoder.yudao.module.mes.dal.dataobject.wm.productproduce.MesWmProductProduceLineDO;
 import cn.iocoder.yudao.module.mes.enums.wm.MesWmQualityStatusEnum;
 import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
+import cn.iocoder.yudao.module.mes.controller.admin.qc.ipqc.vo.MesQcIpqcImportExcelVO;
 import cn.iocoder.yudao.module.mes.controller.admin.qc.ipqc.vo.MesQcIpqcPageReqVO;
 import cn.iocoder.yudao.module.mes.controller.admin.qc.ipqc.vo.MesQcIpqcSaveReqVO;
+import cn.iocoder.yudao.module.mes.controller.admin.qc.vo.MesQcImportRespVO;
+import cn.iocoder.yudao.module.mes.enums.DictTypeConstants;
+import cn.iocoder.yudao.module.mes.enums.md.autocode.MesMdAutoCodeRuleCodeEnum;
+import cn.iocoder.yudao.module.mes.service.qc.imports.MesQcImportHelper;
 import cn.iocoder.yudao.module.mes.dal.dataobject.md.workstation.MesMdWorkstationDO;
 import cn.iocoder.yudao.module.mes.dal.dataobject.pro.route.MesProRouteProductDO;
 import cn.iocoder.yudao.module.mes.dal.dataobject.pro.task.MesProTaskDO;
@@ -20,6 +28,7 @@
 import cn.iocoder.yudao.module.mes.enums.qc.MesQcDefectLevelEnum;
 import cn.iocoder.yudao.module.mes.enums.qc.MesQcStatusEnum;
 import cn.iocoder.yudao.module.mes.enums.qc.MesQcTypeEnum;
+import cn.iocoder.yudao.module.mes.enums.pro.MesProFeedbackStatusEnum;
 import cn.iocoder.yudao.module.mes.enums.MesBizTypeConstants;
 import cn.iocoder.yudao.module.mes.service.md.item.MesMdItemService;
 import cn.iocoder.yudao.module.mes.service.md.workstation.MesMdWorkstationService;
@@ -31,9 +40,12 @@
 import cn.iocoder.yudao.module.mes.service.qc.defectrecord.MesQcDefectRecordService;
 import cn.iocoder.yudao.module.mes.service.qc.indicatorresult.MesQcIndicatorResultService;
 import cn.iocoder.yudao.module.mes.service.qc.template.MesQcTemplateItemService;
+import cn.iocoder.yudao.module.mes.controller.admin.qc.ncr.vo.MesQcNcrSaveReqVO;
+import cn.iocoder.yudao.module.mes.service.qc.ncr.MesQcNcrService;
 import cn.iocoder.yudao.module.mes.service.wm.productproduce.MesWmProductProduceLineService;
 import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
 import jakarta.annotation.Resource;
+import lombok.extern.slf4j.Slf4j;
 import org.springframework.context.annotation.Lazy;
 import org.springframework.stereotype.Service;
 import org.springframework.transaction.annotation.Transactional;
@@ -41,7 +53,11 @@
 
 import java.math.BigDecimal;
 import java.math.RoundingMode;
+import java.util.ArrayList;
+import java.util.HashMap;
+import java.util.LinkedHashMap;
 import java.util.List;
+import java.util.Map;
 import java.util.Objects;
 
 import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
@@ -50,10 +66,11 @@
 /**
  * MES 杩囩▼妫�楠屽崟锛圛PQC锛� Service 瀹炵幇绫�
  *
- * @author 鑺嬮亾婧愮爜
+ * @author 瓒呯骇绠$悊鍛�
  */
 @Service
 @Validated
+@Slf4j
 public class MesQcIpqcServiceImpl implements MesQcIpqcService {
 
     /**
@@ -103,7 +120,14 @@
     private MesWmProductProduceLineService productProduceLineService;
 
     @Resource
+    @Lazy
+    private MesQcNcrService ncrService;
+
+    @Resource
     private AdminUserApi adminUserApi;
+
+    @Resource
+    private MesQcImportHelper qcImportHelper;
 
     @Override
     @Transactional(rollbackFor = Exception.class)
@@ -114,9 +138,21 @@
         MesProWorkOrderDO workOrder = workOrderService.validateWorkOrderExists(createReqVO.getWorkOrderId());
         // 1.3 纭畾妫�楠岀墿鏂欙細鏈変换鍔℃椂鍙栦换鍔$殑鐗╂枡锛屾棤浠诲姟鏃跺彇宸ュ崟鐨勪骇鍝�
         Long itemId = (ctx.task() != null) ? ctx.task().getItemId() : workOrder.getProductId();
-        // 1.4 鏍规嵁鐗╂枡 + 妫�楠岀被鍨嬭嚜鍔ㄥ尮閰嶆ā鏉�
-        MesQcTemplateItemDO templateItem = templateItemService.getRequiredTemplateByItemIdAndType(
-                itemId, MesQcTypeEnum.IPQC.getType());
+        // 1.4 鏍规嵁鐗╂枡 + IPQC 绫诲瀷鏌ユ壘鍙敤璐ㄦ鏂规锛堟敮鎸佸墠绔樉寮忔寚瀹氾級
+        List<MesQcTemplateItemDO> templateItems = templateItemService.getTemplateItemList(
+                itemId, MesQcTypeEnum.IPQC.getType(), null, null);
+        if (CollUtil.isEmpty(templateItems)) {
+            throw exception(QC_NO_TEMPLATE);
+        }
+        MesQcTemplateItemDO templateItem = templateItems.get(0);
+        if (createReqVO.getTemplateId() != null) {
+            templateItem = templateItems.stream()
+                    .filter(available -> Objects.equals(available.getTemplateId(), createReqVO.getTemplateId()))
+                    .findFirst().orElse(null);
+            if (templateItem == null) {
+                throw exception(QC_NO_TEMPLATE); // 鎸囧畾浜嗘柟妗堜絾涓嶅湪鍖归厤鍒楄〃涓紝鎷掔粷
+            }
+        }
         Long templateId = templateItem.getTemplateId();
         // 1.5 鑾峰彇鏉ユ簮鍗曟嵁缂栧彿
         String sourceDocCode = validateAndGetSourceDocCode(
@@ -213,8 +249,35 @@
         ipqcMapper.updateById(new MesQcIpqcDO()
                 .setId(id).setStatus(MesQcStatusEnum.FINISHED.getStatus()));
 
-        // 3. 鍥炲啓鏉ユ簮鍗曟嵁
+        // 3. 涓嶅悎鏍兼椂鑷姩鍒涘缓 NCR
+        generateNcrIfNeeded(ipqc);
+
+        // 4. 鍥炲啓鏉ユ簮鍗曟嵁
         writeBackSourceDoc(ipqc);
+    }
+
+    /**
+     * 涓嶅悎鏍兼椂鑷姩鍒涘缓 NCR锛堜笉鍚堟牸鍝佸鐞嗗崟锛�
+     *
+     * @param ipqc 杩囩▼妫�楠屽崟
+     */
+    private void generateNcrIfNeeded(MesQcIpqcDO ipqc) {
+        BigDecimal unqualifiedQty = ipqc.getUnqualifiedQuantity();
+        if (unqualifiedQty == null || unqualifiedQty.compareTo(BigDecimal.ZERO) <= 0) {
+            return;
+        }
+        String ncrCode = "NCR" + java.time.LocalDateTime.now()
+                .format(java.time.format.DateTimeFormatter.ofPattern("yyyyMMddHHmmssSSS"));
+        MesQcNcrSaveReqVO saveReqVO = new MesQcNcrSaveReqVO();
+        saveReqVO.setCode(ncrCode);
+        saveReqVO.setName("涓嶅悎鏍煎搧澶勭悊鍗�");
+        saveReqVO.setQcType(MesQcTypeEnum.IPQC.getType());
+        saveReqVO.setQcId(ipqc.getId());
+        saveReqVO.setItemId(ipqc.getItemId());
+        saveReqVO.setUnqualifiedQuantity(unqualifiedQty);
+        saveReqVO.setDefectDescription("鐢辫繃绋嬫楠�(" + ipqc.getCode() + ")鑷姩鐢熸垚");
+        ncrService.createNcr(saveReqVO);
+        log.info("[generateNcrIfNeeded] IPQC({}) 涓嶅悎鏍硷紝鑷姩鍒涘缓 NCR", ipqc.getId());
     }
 
     /**
@@ -225,25 +288,34 @@
      * @param ipqc 杩囩▼妫�楠屽崟
      */
     private void writeBackSourceDoc(MesQcIpqcDO ipqc) {
-        if (ipqc.getSourceDocType() == null) {
-            return;
-        }
-        if (ipqc.getSourceDocId() == null) {
-            throw new IllegalArgumentException(
-                    "IPQC 鍗昜" + ipqc.getId() + "] sourceDocType 闈炵┖浣� sourceDocId 涓虹┖");
+        // 1. 纭畾 sourceDocType/sourceDocId
+        Long sourceDocId = ipqc.getSourceDocId();
+        Long sourceLineId = ipqc.getSourceLineId();
+
+        // 濡傛灉 IPQC 鍗曟病鏈夎缃潵婧愶紝灏濊瘯閫氳繃 taskId 鏌ユ壘鍏宠仈鐨勫緟妫�楠屾姤宸�
+        if (sourceDocId == null && ipqc.getTaskId() != null) {
+            MesProFeedbackDO feedback = feedbackService.getFeedbackListByTaskId(ipqc.getTaskId()).stream()
+                    .filter(f -> MesProFeedbackStatusEnum.UNCHECK.getStatus().equals(f.getStatus()))
+                    .findFirst().orElse(null);
+            if (feedback != null) {
+                sourceDocId = feedback.getId();
+                log.info("[writeBackSourceDoc] IPQC({}) 鏈缃潵婧愬崟鎹紝閫氳繃 taskId({}) 鎵惧埌寰呮楠屾姤宸�({})",
+                        ipqc.getId(), ipqc.getTaskId(), feedback.getId());
+            }
         }
 
-        if (Objects.equals(ipqc.getSourceDocType(), MesBizTypeConstants.PRO_FEEDBACK)) {
-            feedbackService.updateProFeedbackWhenIpqcFinish(ipqc.getSourceDocId(), ipqc.getSourceLineId(),
-                    ObjectUtil.defaultIfNull(ipqc.getQualifiedQuantity(), BigDecimal.ZERO),
-                    ObjectUtil.defaultIfNull(ipqc.getUnqualifiedQuantity(), BigDecimal.ZERO),
-                    ObjectUtil.defaultIfNull(ipqc.getLaborScrapQuantity(), BigDecimal.ZERO),
-                    ObjectUtil.defaultIfNull(ipqc.getMaterialScrapQuantity(), BigDecimal.ZERO),
-                    ObjectUtil.defaultIfNull(ipqc.getOtherScrapQuantity(), BigDecimal.ZERO));
-        } else {
-            throw new IllegalArgumentException(
-                    "IPQC 鍗昜" + ipqc.getId() + "] sourceDocType=" + ipqc.getSourceDocType() + " 鏃犳硶璇嗗埆锛屾棤娉曞洖鍐欐潵婧愬崟鎹�");
+        if (sourceDocId == null) {
+            log.warn("[writeBackSourceDoc] IPQC({}) 鏃犳硶纭畾鏉ユ簮鎶ュ伐锛岃烦杩囧洖鍐�", ipqc.getId());
+            return;
         }
+
+        // 2. 鍥炲啓鎶ュ伐
+        feedbackService.updateProFeedbackWhenIpqcFinish(sourceDocId, sourceLineId,
+                ObjectUtil.defaultIfNull(ipqc.getQualifiedQuantity(), BigDecimal.ZERO),
+                ObjectUtil.defaultIfNull(ipqc.getUnqualifiedQuantity(), BigDecimal.ZERO),
+                ObjectUtil.defaultIfNull(ipqc.getLaborScrapQuantity(), BigDecimal.ZERO),
+                ObjectUtil.defaultIfNull(ipqc.getMaterialScrapQuantity(), BigDecimal.ZERO),
+                ObjectUtil.defaultIfNull(ipqc.getOtherScrapQuantity(), BigDecimal.ZERO));
     }
 
     @Override
@@ -398,4 +470,142 @@
         ipqcMapper.updateById(updateIpqc);
     }
 
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public MesQcImportRespVO importIpqcList(List<MesQcIpqcImportExcelVO> importList) {
+        MesQcImportRespVO respVO = MesQcImportRespVO.builder()
+                .createList(new ArrayList<>()).failureList(new LinkedHashMap<>()).build();
+        if (CollUtil.isEmpty(importList)) {
+            return respVO;
+        }
+        qcImportHelper.startImport();
+        Map<String, Integer> firstRowNoByKey = new HashMap<>();
+        for (int i = 0; i < importList.size(); i++) {
+            MesQcIpqcImportExcelVO row = importList.get(i);
+            if (isImportRowEmpty(row)) {
+                continue; // 璺宠繃绌鸿
+            }
+            String label = StrUtil.isNotBlank(row.getCode()) ? "妫�楠屽崟缂栧彿 " + row.getCode().trim()
+                    : "绗� " + (i + 2) + " 琛�";
+            String importKey = buildImportKey(row);
+            try {
+                Integer firstRowNo = firstRowNoByKey.get(importKey);
+                if (firstRowNo != null) {
+                    throw MesQcImportHelper.duplicateRowException(firstRowNo, buildImportKeyDesc(row));
+                }
+                respVO.getCreateList().add(createIpqcByImport(row));
+                firstRowNoByKey.putIfAbsent(importKey, i + 2);
+            } catch (Exception ex) {
+                respVO.getFailureList().put(label, MesQcImportHelper.resolveImportErrorMessage(ex));
+            }
+        }
+        return respVO;
+    }
+
+    private boolean isImportRowEmpty(MesQcIpqcImportExcelVO row) {
+        return row == null || (StrUtil.isBlank(row.getCode()) && StrUtil.isBlank(row.getName())
+                && StrUtil.isBlank(row.getType()) && StrUtil.isBlank(row.getWorkOrderCode())
+                && StrUtil.isBlank(row.getWorkstationName()) && StrUtil.isBlank(row.getTemplateName())
+                && row.getCheckQuantity() == null && row.getQualifiedQuantity() == null
+                && row.getUnqualifiedQuantity() == null && row.getLaborScrapQuantity() == null
+                && row.getMaterialScrapQuantity() == null && row.getOtherScrapQuantity() == null
+                && StrUtil.isBlank(row.getCheckResult()) && StrUtil.isBlank(row.getInspectorName())
+                && StrUtil.isBlank(row.getInspectDate()) && StrUtil.isBlank(row.getRemark()));
+    }
+
+    /**
+     * 渚濇嵁瀵煎叆琛屽垱寤轰竴寮犺繃绋嬫楠屽崟锛氱墿鏂欑敱宸ュ崟鎺ㄥ锛岀姸鎬佷负銆屽緟妫�楠屻�嶏紝妫�楠岃鐢辫川妫�鏂规鑷姩鐢熸垚
+     *
+     * @return 妫�楠屽崟缂栧彿
+     */
+    private String createIpqcByImport(MesQcIpqcImportExcelVO row) {
+        MesQcIpqcSaveReqVO reqVO = new MesQcIpqcSaveReqVO();
+        // 1. 妫�楠屽崟缂栧彿锛氬~鍐欏垯浣跨敤锛岀暀绌鸿嚜鍔ㄧ敓鎴�
+        String code = StrUtil.isNotBlank(row.getCode()) ? row.getCode().trim()
+                : qcImportHelper.generateCode(MesMdAutoCodeRuleCodeEnum.QC_IPQC_CODE.getCode());
+        if (ipqcMapper.selectByCode(code) != null) {
+            throw new IllegalArgumentException("妫�楠屽崟缂栧彿宸插瓨鍦細" + code
+                    + "銆傝淇敼妯℃澘涓殑銆屾楠屽崟缂栧彿銆嶏紝鎴栧厛鍦ㄧ郴缁熶腑鍒犻櫎璇ョ紪鍙风殑妫�楠屽崟鍚庨噸鏂板鍏�");
+        }
+        reqVO.setCode(code);
+        // 2. 鍚嶇О銆佹楠岀被鍨嬨�佸伐鍗曘�佸伐浣嶃�佽川妫�鏂规
+        if (StrUtil.isBlank(row.getName())) {
+            throw new IllegalArgumentException("妫�楠屽崟鍚嶇О涓嶈兘涓虹┖锛氳濉啓妯℃澘涓琛岀殑銆屾楠屽崟鍚嶇О銆嶅垪");
+        }
+        reqVO.setName(row.getName().trim());
+        reqVO.setType(qcImportHelper.resolveDictValue(row.getType(),
+                DictTypeConstants.MES_IPQC_TYPE, "妫�楠岀被鍨�", true));
+        reqVO.setWorkOrderId(qcImportHelper.resolveWorkOrderId(row.getWorkOrderCode()));
+        reqVO.setWorkstationId(qcImportHelper.resolveWorkstationId(row.getWorkstationName()));
+        reqVO.setTemplateId(qcImportHelper.resolveTemplateId(row.getTemplateName()));
+        // 3. 鏁伴噺锛氬悎鏍煎搧 + 涓嶅悎鏍煎搧 蹇呴』绛変簬妫�娴嬫暟閲忥紙妫�娴嬫暟閲忕暀绌哄垯鑷姩鍚堣锛夛紱宸ュ簾/鏂欏簾/鍏朵粬搴熺暀绌烘寜 0
+        BigDecimal qualified = qcImportHelper.resolveQuantity(row.getQualifiedQuantity(), "鍚堟牸鍝佹暟閲�", true);
+        BigDecimal unqualified = qcImportHelper.resolveQuantity(row.getUnqualifiedQuantity(), "涓嶅悎鏍煎搧鏁伴噺", true);
+        reqVO.setQualifiedQuantity(qualified);
+        reqVO.setUnqualifiedQuantity(unqualified);
+        reqVO.setCheckQuantity(qcImportHelper.resolveCheckQuantity(
+                row.getCheckQuantity(), qualified, unqualified, "妫�娴嬫暟閲�"));
+        BigDecimal laborScrap = qcImportHelper.resolveQuantity(row.getLaborScrapQuantity(), "宸ュ簾鏁伴噺", false);
+        BigDecimal materialScrap = qcImportHelper.resolveQuantity(row.getMaterialScrapQuantity(), "鏂欏簾鏁伴噺", false);
+        BigDecimal otherScrap = qcImportHelper.resolveQuantity(row.getOtherScrapQuantity(), "鍏朵粬搴熷搧鏁伴噺", false);
+        laborScrap = laborScrap != null ? laborScrap : BigDecimal.ZERO;
+        materialScrap = materialScrap != null ? materialScrap : BigDecimal.ZERO;
+        otherScrap = otherScrap != null ? otherScrap : BigDecimal.ZERO;
+        validateScrapQuantity(unqualified, laborScrap, materialScrap, otherScrap);
+        reqVO.setLaborScrapQuantity(laborScrap);
+        reqVO.setMaterialScrapQuantity(materialScrap);
+        reqVO.setOtherScrapQuantity(otherScrap);
+        // 4. 妫�楠屼俊鎭�
+        reqVO.setCheckResult(qcImportHelper.resolveDictValue(row.getCheckResult(),
+                DictTypeConstants.MES_QC_CHECK_RESULT, "妫�娴嬬粨鏋�", false));
+        reqVO.setInspectorUserId(qcImportHelper.resolveInspectorUserId(row.getInspectorName()));
+        reqVO.setInspectDate(qcImportHelper.parseDateTime(row.getInspectDate(), "妫�娴嬫棩鏈�"));
+        reqVO.setRemark(StrUtil.trimToNull(row.getRemark()));
+        // 5. 鍘婚噸锛氬悓涓� 鐢熶骇宸ュ崟 + 妫�楠岀被鍨� + 宸ヤ綅 + 妫�娴嬫棩鏈� 鐨勮繃绋嬫楠屽崟涓嶅彲閲嶅瀵煎叆
+        MesQcIpqcDO duplicate = CollUtil.getFirst(ipqcMapper.selectListByImportKey(reqVO.getWorkOrderId(),
+                reqVO.getType(), reqVO.getWorkstationId(), reqVO.getInspectDate()));
+        if (duplicate != null) {
+            throw MesQcImportHelper.duplicateExistingException(buildImportKeyDesc(row), "杩囩▼妫�楠屽崟",
+                    duplicate.getCode(), "璐ㄩ噺绠$悊-杩囩▼妫�楠�");
+        }
+        // 6. 澶嶇敤鍒涘缓閫昏緫锛氭牎楠屽伐鍗�/宸ヤ綅/浜哄憳銆佹寜鐗╂枡鍖归厤璐ㄦ鏂规銆佺敓鎴愭楠岃
+        try {
+            createIpqc(reqVO);
+        } catch (ServiceException ex) {
+            MesQcImportHelper.rethrowTemplateError(ex, row.getWorkOrderCode(), "杩囩▼妫�楠�(IPQC)");
+        }
+        return code;
+    }
+
+    /**
+     * 鏍¢獙 宸ュ簾 + 鏂欏簾 + 鍏朵粬搴熷搧 涓嶈秴杩囦笉鍚堟牸鍝佹暟閲�
+     */
+    private void validateScrapQuantity(BigDecimal unqualified, BigDecimal laborScrap,
+                                       BigDecimal materialScrap, BigDecimal otherScrap) {
+        BigDecimal scrapSum = laborScrap.add(materialScrap).add(otherScrap);
+        if (scrapSum.compareTo(unqualified) <= 0) {
+            return;
+        }
+        throw new IllegalArgumentException("宸ュ簾銆佹枡搴熴�佸叾浠栧簾鍝佹暟閲忎箣鍜屼笉鑳借秴杩囦笉鍚堟牸鍝佹暟閲忥細涓嶅悎鏍煎搧鏁伴噺涓� "
+                + unqualified.stripTrailingZeros().toPlainString() + "锛岃�� 宸ュ簾 " + laborScrap.stripTrailingZeros().toPlainString()
+                + " + 鏂欏簾 " + materialScrap.stripTrailingZeros().toPlainString() + " + 鍏朵粬搴熷搧 "
+                + otherScrap.stripTrailingZeros().toPlainString() + " = " + scrapSum.stripTrailingZeros().toPlainString()
+                + "銆傝淇敼妯℃澘涓殑搴熷搧鏁伴噺鎴栦笉鍚堟牸鍝佹暟閲忓悗閲嶆柊瀵煎叆");
+    }
+
+    /**
+     * 瀵煎叆鍘婚噸閿細鍚屼竴 鐢熶骇宸ュ崟 + 妫�楠岀被鍨� + 宸ヤ綅 + 妫�娴嬫棩鏈� 瑙嗕负鍚屼竴鎵硅繃绋嬫楠屾暟鎹�
+     */
+    private String buildImportKey(MesQcIpqcImportExcelVO row) {
+        return String.join("|", StrUtil.trimToEmpty(row.getWorkOrderCode()), StrUtil.trimToEmpty(row.getType()),
+                StrUtil.trimToEmpty(row.getWorkstationName()), StrUtil.trimToEmpty(row.getInspectDate()));
+    }
+
+    private String buildImportKeyDesc(MesQcIpqcImportExcelVO row) {
+        return "鐢熶骇宸ュ崟[" + MesQcImportHelper.describeImportValue(row.getWorkOrderCode())
+                + "]銆佹楠岀被鍨媅" + MesQcImportHelper.describeImportValue(row.getType())
+                + "]銆佸伐浣峓" + MesQcImportHelper.describeImportValue(row.getWorkstationName())
+                + "]銆佹娴嬫棩鏈焄" + MesQcImportHelper.describeImportValue(row.getInspectDate()) + "]";
+    }
+
 }

--
Gitblit v1.9.3