南骏 池
2025-05-12 c418ccde908642c73f86ff43cc999be835a1e77d
service/QC/IpqcService.cs
@@ -6,6 +6,7 @@
using NewPdaSqlServer.util;
using SqlSugar;
using static Azure.Core.HttpHeader;
using static Microsoft.EntityFrameworkCore.DbLoggerCategory;
namespace NewPdaSqlServer.service.QC;
@@ -83,7 +84,8 @@
                a.FcheckResu,
                a.Order,
                a.Ybsl,
                a.YbslIn
                a.ISRZXX,
                a.IPQCRZXX
            }).Select((a, b) => new MesQaItemsDetectDetail5
            {
                Guid = a.Guid,
@@ -107,6 +109,8 @@
                Order = a.Order,
                Ybsl = a.Ybsl,
                YbslIn = Ybsl_In,
                ISRZXX = a.ISRZXX,
                IPQCRZXX = a.IPQCRZXX
            }).OrderBy(a => a.Order)
            .ToList();
    }
@@ -142,4 +146,22 @@
        return (pageList, totalCount);
    }
    //更新不合格描述
    public int updateIpqcRzxx(LLJDto dto)
    {
        if (dto == null) throw new ArgumentNullException(nameof(dto), "参数对象不能为 null");
        // 参数校验(根据存储过程新增参数)
        if (string.IsNullOrEmpty(dto.pid?.ToString()))
            throw new ArgumentException("项目明细id存在问题,请联系管理员!", nameof(dto.pid));
        var withOracle = Db.Updateable<MesQaItemsDetectDetail5>()
                .SetColumns(s => s.IPQCRZXX == dto.inRzxxValue)
                .Where(s => s.Guid.ToString() == dto.pid)
                .ExecuteCommand();
        return withOracle;
    }
}