销售订单插入bug修复

zyf

2025-05-07 2f48267f8b9b7ffa912933f651add73da35fe15f

 MES.Service/service/Warehouse/MesInvItemOutsManager.cs

@@ -14,13 +14,16 @@
    //当前类已经继承了 Repository 增、删、查、改的方法
    //这里面写的代码不会给覆盖,如果要重新生成请删除 MesInvItemOutsManager.cs

    public List<MesInvItemOuts> GetProductionPickPage(WarehouseQuery query)
    public (List<MesInvItemOuts> Items, int TotalCount) GetProductionPickPage(
        WarehouseQuery query)
    {
        return Db.Queryable<MesInvItemOuts, MesDepots>((a, o) =>
        var totalCount = 0; // 初始化 totalCount
        // 确保这里使用 'out' 来获取总行数
        var result = Db.Queryable<MesInvItemOuts, MesDepots>((a, o) =>
                new JoinQueryInfos(
                    JoinType.Left,
                    o.DepotCode == a.DepotCode && a.Company == o.Company &&
                    a.Factory == o.Factory
                    a.Factory == a.Factory
                ))
            .Where((a, o) => a.BillTypeId == 200 &&
                             a.TransactionNo == 201 &&
@@ -46,7 +49,10 @@
                ItemOutNo = a.ItemOutNo,
                DepotName = o.DepotName // 需要动态添加的字段
            })
            .ToPageList(query.PageIndex, query.Limit);
            .ToPageList(query.PageIndex, query.Limit,
                ref totalCount); // 确保这里使用 'out'

        return (result, totalCount);
    }

    public MaterialReceipt GetProductionPick(WarehouseQuery query)
@@ -55,9 +61,9 @@
        if (query.id != null)
        {
            var mesInvItemOutsList = GetProductionPickPage(query);
            if (mesInvItemOutsList.Count <= 0) return form;
            if (mesInvItemOutsList.TotalCount <= 0) return form;

            form.ItemOuts = mesInvItemOutsList[0];
            form.ItemOuts = mesInvItemOutsList.Items[0];
            form.ItemsList = getProductionItemsList(query);
            form.InvItemoutCDetails = GetProductionDetails(query);
        }
@@ -831,7 +837,7 @@
        throw new Exception("获取数据失败");
    }

    private MessageCenter ProductionMesToErpParam(WarehouseQuery query)
    public MessageCenter ProductionMesToErpParam(WarehouseQuery query)
    {
        var erpParameters = "";
        var title = "";
@@ -927,28 +933,33 @@
                item.ItemId + "')";
            var C_ITEM_UNIT = Db.Ado.SqlQuerySingle<string>(sql);

            var xsddh = item.Caa015 ?? "";
            var wzh = item.PositionNo ?? "";
            var qty = ((int)item.Quantity).ToString();
            var erpid = ((int)item.erpId).ToString();
            var id = ((int)item.Id).ToString();
            scllentryList.Add(new
            {
                FMaterialId = item.ItemNo,
                FUnitID = C_ITEM_UNIT,
                FAppQty = item.Quantity,
                FActualQty = item.Quantity,
                FAppQty = qty,
                FActualQty = qty,
                FStockId = item.DepotCode,
                FPPBomEntryId = item.erpId,
                F_UNW_Text_xsddh = item.Caa015,
                F_UNW_TEXT_WZH = item.PositionNo,
                F_MES_ENTRYID = item.Id
                FPPBomEntryId = erpid,
                F_UNW_Text_xsddh = xsddh,
                F_UNW_TEXT_WZH = wzh,
                F_MES_ENTRYID = id
            });
        }

        var dataJson = new
        {
            F_MES_ID = mesInvItemOuts.Id,
            FDate = mesInvItemOuts.CreateBy,
            F_MES_ID = mesInvItemOuts.Id.ToString(),
            FDate = DateTime.Now.ToString("yyyy-MM-dd"),
            FPickerId = userName,
            F_UNW_LargeText_BZ = " ",
            F_UNW_KH = " ",
            F_UNW_DDSL = womcaa.Caa012,
            F_UNW_DDSL = womcaa.Caa012.ToString(),
            F_UNW_Text_CZG = userName,
            scllentry = scllentryList
        };