src/main/java/com/ruoyi/sales/service/impl/SalesLedgerServiceImpl.java

@@ -829,7 +829,17 @@
            salesLedger.setSalesContractNo(contractNo);
            salesLedgerMapper.insert(salesLedger);
        } else {
            salesLedger.setSalesContractNo(null);
            if (StrUtil.isNotBlank(salesLedgerDto.getSalesContractNo())) {
                SalesLedger existLedger = salesLedgerMapper.selectById(salesLedger.getId());
                // 如果合同号发生了变化，需要校验唯一性
                if (!salesLedgerDto.getSalesContractNo().equals(existLedger.getSalesContractNo())) {
                    Assert.isTrue(salesLedgerMapper.selectOne(new LambdaQueryWrapper<SalesLedger>()
                                    .eq(SalesLedger::getSalesContractNo, salesLedgerDto.getSalesContractNo())
                                    .last("limit 1")) == null,
                            salesLedgerDto.getSalesContractNo() + "合同号已存在");
                }
                salesLedger.setSalesContractNo(salesLedgerDto.getSalesContractNo());
            }
            salesLedgerMapper.updateById(salesLedger);
        }


 src/main/resources/mapper/production/ProductWorkOrderMapper.xml

@@ -47,7 +47,7 @@
                LEFT JOIN product_process pp ON pp.id = ppri.process_id
                LEFT JOIN product_model pm ON pm.id = ppri.product_model_id
                LEFT JOIN product p ON p.id = pm.product_id
                left join product_model t7 on t7.product_id = po.product_model_id
                left join product_model t7 on t7.id = po.product_model_id
        <where>
            <if test="c.workOrderNo != null and c.workOrderNo != ''">
                pwo.work_order_no like concat('%', #{c.workOrderNo}, '%')