1、首检生成检验项目时报请重试优化（字段长度限制所导致）

kyy

2025-08-05 6581234907def80093c3e9b4cdbc864714ed3f59

 MES.Service/service/SpotCheck/SpotCheckService.cs

@@ -1,25 +1,21 @@
using MES.Service.DB;
using MES.Service.Dto.service;
using MES.Service.Modes;
using Newtonsoft.Json;
using SqlSugar;

namespace MES.Service.service.SpotCheck;

public class SpotCheckService
{
  
    public async Task<DjDetailResult> GetDjDetail(DJPageResultDto queryObj)
    {
        // 处理传入的 releaseNo 为 null 的情况
        if (string.IsNullOrEmpty(queryObj.eqNo))
        {
            return new DjDetailResult
            {
                MesEqKeepsType02List = new List<MesEqKeepsType02>(),
                EqInfoList = new List<MesEqMaintain>()
            };
        }

        using (var db = SqlSugarHelper.GetInstance())
        {
@@ -30,20 +26,20 @@
                var todayEnd = todayStart.AddDays(1);

                var results = await db.Queryable<MesEqMaintain>()
                    .Where(x => x.EqNo == queryObj.eqNo && x.CreateDate >= todayStart && x.CreateDate < todayEnd &&
                    .Where(x => x.EqNo == queryObj.eqNo &&
                                x.CreateDate >= todayStart &&
                                x.CreateDate < todayEnd &&
                                x.Flag == 0)
                    .Select(x => new
                    {
                        Id = x.Id,
                        x.Id,
                        x.EqName,
                        x.PlanNo,
                        x.EqNo
                    })
                    .ToListAsync();
                if (results == null || results.Count == 0)
                {
                    throw new Exception("单据不存在");
                }

                var ids = results.Select(r => (decimal)r.Id).ToList();

@@ -55,13 +51,11 @@
                }).ToList();

                if (ids.Count == 0)
                {
                    return new DjDetailResult
                    {
                        MesEqKeepsType02List = new List<MesEqKeepsType02>(),
                        EqInfoList = new List<MesEqMaintain>()
                    };
                }

                // 根据获取的 id 列表查询 MesEqKeepsType02 表
                var keepsType02List = await db.Queryable<MesEqKeepsType02>()
@@ -98,13 +92,12 @@
        }
    }

    public async Task<List<MesEqMaintain>> UpdateDjDetail(DJPageResultDto updateObj)
    public async Task<List<MesEqMaintain>> UpdateDjDetail(
        DJPageResultDto updateObj)
    {
        // 处理传入的 releaseNo 为 null 或空字符串的情况
        if (string.IsNullOrEmpty(updateObj.releaseNo))
        {
            return new List<MesEqMaintain>();
        }

        using (var db = SqlSugarHelper.GetInstance())
        {
@@ -120,17 +113,14 @@
                        CheckBy = updateObj.userNo,
                        Flag = 1,
                        CheckDate = DateTime.Now
                    }) 
                    })
                    .Where(x => x.PlanNo == updateObj.releaseNo && x.Flag == 0)
                    .ExecuteCommandAsync();

                // 根据 inspectionItems 列表的 id 更新 MesEqKeepsType02 表
                if (updateObj.inspectionItems != null)
                {
                    foreach (var item in updateObj.inspectionItems)
                    {
                        if (item.id.HasValue)
                        {
                            await db.Updateable<MesEqKeepsType02>()
                                .SetColumns(x => new MesEqKeepsType02
                                {
@@ -138,9 +128,6 @@
                                })
                                .Where(x => x.Id == item.id.Value)
                                .ExecuteCommandAsync();
                        }
                    }
                }

                // 提交事务
                db.Ado.CommitTran();