1.生产补料初步完成（拆分补料还未完成） 2.出库物料明细实体类调整

南骏 池

2025-02-10 62750a4a726896b803fa0f7b1862c19f7bd04f4c

1.生产补料初步完成（拆分补料还未完成）
2.出库物料明细实体类调整

 entity/MesInvItemOutItems.cs

@@ -203,13 +203,13 @@
    ///     已入库数
    /// </summary>
    [SugarColumn(ColumnName = "rk_qty")]
    public int? RkQty { get; set; }
    public decimal? RkQty { get; set; }

    /// <summary>
    ///     已扫数量
    /// </summary>
    [SugarColumn(ColumnName = "tl_qty")]
    public int? TlQty { get; set; }
    public decimal? TlQty { get; set; }

    /// <summary>
    ///     物料ID

 entity/MesItemBlDetail.cs

@@ -53,20 +53,20 @@
    ///     计划数量
    /// </summary>
    [SugarColumn(ColumnName = "bld006")]
    public int? Bld006 { get; set; }
    public decimal? Bld006 { get; set; }

    /// <summary>
    ///     申请数量
    /// </summary>
    [SugarColumn(ColumnName = "bld007")]
    public int? Bld007 { get; set; }
    public decimal? Bld007 { get; set; }

    /// <summary>
    ///     已领数量
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "bld008")]
    public int? Bld008 { get; set; }
    public decimal? Bld008 { get; set; }

    /// <summary>
    ///     单位

 service/Warehouse/MesItemBlManager.cs

@@ -221,6 +221,7 @@
                    Remark = mesItemBl.Bl007,
                    DepotCode = womdab.Dab017,
                    OutPart = womdaa.Daa013,
                    OutType = "生产补料",
                    FType = 0,
                    Factory = stockBarcode.Factory,
                    Company = stockBarcode.Company,
@@ -229,23 +230,23 @@
                    PbillNo = womdaa.Daa001,
                    OutDate = DateTime.Now,
                    Status = 0,
                    BbillNo = query.blNo
                    BbillNo = query.billNo
                }).IgnoreColumns(true).ExecuteCommand();
            }

            // 检查并更新出库单物料明细
            var itemCount = db.Queryable<MesInvItemOutItems>()
                .Where(i =>
                    i.ItemOutId == outId && i.ItemId == stockBarcode.ItemId)
                    i.ItemOutId == outId && i.ItemId == stockBarcode.ItemId && i.ItemOutId == outId)
                .Count();

            if (itemCount > 0)
                // 更新已存在的物料明细数量
                db.Updateable<MesInvItemOutItems>()
                    .SetColumns(i =>
                        i.Quantity == i.Quantity + stockBarcode.Quantity)
                        i.TlQty == i.TlQty + stockBarcode.Quantity)
                    .Where(i =>
                        i.ItemOutId == outId && i.ItemId == stockBarcode.ItemId)
                        i.ItemOutId == outId && i.ItemId == stockBarcode.ItemId && i.ItemOutId == outId)
                    .ExecuteCommand();
            else
                // 插入新的物料明细记录
@@ -255,6 +256,7 @@
                    ItemOutId = outId,
                    ItemNo = blDetail.Bld002,
                    Quantity = stockBarcode.Quantity,
                    TlQty = stockBarcode.Quantity,
                    CreateBy = query.userName,
                    CreateDate = DateTime.Now,
                    LastupdateBy = query.userName,