1

啊鑫

2024-11-29 48675bbf98749545c2b5b45e4a13f74993626a95

 service/QC/LljService.cs

@@ -1,12 +1,9 @@
using System.Data;
using Microsoft.IdentityModel.Tokens;
using Microsoft.IdentityModel.Tokens;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
using NewPdaSqlServer.util;
using SqlSugar;
using DbType = System.Data.DbType;


namespace NewPdaSqlServer.service.QC;

@@ -17,7 +14,7 @@
        var parsedGuid = Guid.Empty;
        if (!queryObj.id.IsNullOrEmpty())
        {
            bool isValid = Guid.TryParse(queryObj.id, out parsedGuid);
            var isValid = Guid.TryParse(queryObj.id, out parsedGuid);
            if (!isValid)
                throw new ApplicationException("GUID转换错误");
        }
@@ -74,7 +71,7 @@

        mesQaIqcItem.ForEach(item =>
        {
            string LEV = item.FcheckLevel switch
            var LEV = item.FcheckLevel switch
            {
                null => "" // 默认值
                ,
@@ -402,12 +399,9 @@
    {
        var rkjDto = new LLJDto();

        bool isValid = Guid.TryParse(id, out var parsedGuid);
        var isValid = Guid.TryParse(id, out var parsedGuid);

        if (!isValid)
        {
            throw new Exception("GUID转换错误");
        }
        if (!isValid) throw new Exception("GUID转换错误");

        var qsItemOqcItem =
            Db.Queryable<MesQaItemsDetectDetail5>()
@@ -502,10 +496,9 @@
    //子表修改备注字段
    public int saveRemarksPid(LLJDto dto)
    {
        bool isValid = Guid.TryParse(dto.pid, out var parsedGuid);
        var isValid = Guid.TryParse(dto.pid, out var parsedGuid);

        if (isValid)
        {
            return UseTransaction(db =>
            {
                return db.Updateable<MesQaItemsDetectDetail5>()
@@ -514,7 +507,6 @@
                    .Where(it => it.Guid == parsedGuid)
                    .ExecuteCommand();
            });
        }

        throw new Exception("GUID转换错误");
    }
@@ -577,11 +569,9 @@
        {
            mesQaItemsDetectDetail5.FenterQty ??= 0;
            if (mesQaItemsDetectDetail5.FenterQty == 0)
            {
                throw new Exception("检验项目:" +
                                    mesQaItemsDetectDetail5.FcheckItem +
                                    " 已录入数量为0，请确认。");
            }
        }

        var com = UseTransaction(db =>
@@ -643,7 +633,7 @@
                        TotalOkRkQty = SqlFunc.AggregateSum(b.OkRkqty)
                    })
                    .First();
                

                var totalQuantity = first.TotalQuantity ?? 0;
                var totalOkRkQty = first.TotalOkRkQty ?? 0;

@@ -658,12 +648,13 @@
                executeCommand += db.Updateable<MesInvItemArnDetail>()
                    .SetColumns(s => s.CheckStates == "不合格待审批")
                    .SetColumns(s => s.Ischeck == 1)
                    .SetColumns(s => s.CheckRes == mesQaItemsDetect01.FcheckResu)
                    .SetColumns(
                        s => s.CheckRes == mesQaItemsDetect01.FcheckResu)
                    .SetColumns(s => s.CheckDate == DateTime.Now)
                    .Where(s => s.ParentGuid == mesInvItemArn.Guid
                                && s.ItemId == mesQaItemsDetect01.ItemId)
                    .ExecuteCommand();
                

                executeCommand += db.Updateable<MesQaItemsDetect01>()
                    .SetColumns(s => s.IqcDate == DateTime.Now)
                    .SetColumns(s => s.FcheckDate == DateTime.Now)
@@ -672,7 +663,7 @@
                    .ExecuteCommand();
            }

            if (executeCommand >=3)
            if (executeCommand >= 3)
                return executeCommand;

            throw new Exception("更新失败");