优化提示

kyy

2025-10-11 87bf0fe8996e0d2c9078e52d367a348bb6bf6a4a

优化提示

 service/Warehouse/MesInvItemInCDetailsManager.cs

@@ -1,4 +1,5 @@
using Masuit.Tools.Models;
using Microsoft.AspNetCore.SignalR.Protocol;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
@@ -56,8 +57,17 @@
                    string? outMessage = parameters[4].Value?.ToString();
                    string? outSum = parameters[5].Value?.ToString();


                    // 检查参数是否为空，并在异常中显示实际值
                    if (string.IsNullOrEmpty(outMessage) || string.IsNullOrEmpty(outSum))
                        throw new InvalidOperationException("存储过程返回参数异常");
                    {
                        // 拼接参数实际值（处理 null 的情况）
                        string messageValue = outMessage ?? "null";
                        string sumValue = outSum ?? "null";
                        throw new InvalidOperationException(
                            $"存储过程返回参数异常：输出消息为【{messageValue}】，输出数量为【{sumValue}】"
                        );
                    }

                    // 验证结果
                    if (!int.TryParse(outSum, out int result) || result <= 0)
@@ -113,10 +123,16 @@
                    WHERE  a.Item_In_Id = '{0}' AND a.Item_Id = '{1}'", cId, itemBarcodeDetails.ItemId);

                    res.ItemBarCDetails = Db.Ado.SqlQuery<dynamic>(sql2);
                    //查询已入库总数
                    var totalCDetailsQuantity = Db.Queryable<MesInvItemInCDetails>()
                    .Where(it => it.ItemInId == cId)
                    .Sum(it => it.Quantity);
                  
                    res.SumQuantity = Convert.ToDecimal(totalCDetailsQuantity);

                    // 设置返回信息
                    res.Message = outMessage;
                    res.SumQuantity = result;
                    

                    return res;
                }
@@ -1493,9 +1509,18 @@

            res.ItemBarCDetails = Db.Ado.SqlQuery<dynamic>(sql2, new { cId, itemId = itemBarcode.ItemId });

            res.Message = $"验退操作成功，拆分后条码：{cfBar}，验退单号：{ytdh}";
            res.SumQuantity = res.ItemBarCDetails?.Count ?? 0;

            //查询已入库总数
            var totalCDetailsQuantity = Db.Queryable<MesInvItemInCDetails>()
            .Where(it => it.ItemInId == cId)
            .Sum(it => it.Quantity);

            res.SumQuantity = Convert.ToDecimal(totalCDetailsQuantity);


            res.Message = $"验退操作成功，拆分后条码：{cfBar}，验退单号：{ytdh}";
            // res.SumQuantity = res.ItemBarCDetails?.Count ?? 0;
            res.SumQuantity = Convert.ToDecimal(totalCDetailsQuantity);
            return res;
        }
        catch (Exception ex)