1.生产补料优化 2.委外补料优化

南骏 池

2025-04-11 9a722839b8068745b4ca418b01fa942d0b5f308e

1.生产补料优化
2.委外补料优化

 Controllers/Wom/WomdaaController.cs

@@ -265,7 +265,7 @@

    #region 现场管理

    //GetItemsByDaa001

    /// <summary>
    ///     扫描注塑码，获取工单和条码信息
    /// </summary>
@@ -293,9 +293,9 @@
        }
    }

    //GetItemsByDaa001

    /// <summary>
    ///     扫描注塑码，获取工单和条码信息
    ///     产品绑定，追溯码和流水码绑定
    /// </summary>
    /// <returns></returns>
    [HttpPost("ProductBinding")]
@@ -320,5 +320,32 @@
        }
    }

    /// <summary>
    ///     获取卡板信息
    /// </summary>
    /// <returns></returns>
    [HttpPost("getKbBarInfo")]
    public ResponseResult getKbBarInfo([FromBody] dynamic query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            // 先初始化tbBillList属性
            resultInfos.tbBillList = new ExpandoObject();
            resultInfos.tbBillList.KbBarInfo = m.getKbBarInfo(query);
            resultInfos.tbBillList.KbBarMxInfo = m.getKbBarMxInfo(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    #endregion
}

 service/Warehouse/MesItemBlManager.cs

@@ -802,7 +802,7 @@
                    PbillNo = query.billNo,
                    ItemId = blDetail.Bld012,
                    DepotId = stockBarcode.DepotId.ToString(),
                    ItemDabid = womdab.Guid,
                    ItemDabid = blDetail.Id,
                    // Unit = blDetail.Bld009,
                    // DepotId = (int)stockBarcode.DepotsId
                }).IgnoreColumns(true).ExecuteCommand();

 service/Wom/WomdaaManager.cs

@@ -366,4 +366,54 @@
            }
        }
    }


    /// <summary>
    /// 获取卡板信息
    /// </summary>
    /// <param name="query"></param>
    /// <returns></returns>
    public dynamic getKbBarInfo(dynamic query)
    {
        if (string.IsNullOrEmpty(query.Kbbarcode?.ToString()))
            throw new ArgumentException("卡板条码不允许为空", nameof(query.userName));

        var sql = string.Format(@"SELECT OLDQTY,
       ISNULL((SELECT COUNT(1) FROM MES_INV_ITEM_BARCODES_TBMX WHERE ABOUT_TB_BARCODE = '{0}'), 0) AS YSum
FROM MES_INV_ITEM_BARCODES
WHERE ITEM_BARCODE = '{0}' ",  query.Kbbarcode);

        var ZsBarInfo = Db.Ado.SqlQuery<dynamic>(sql);

        if (ZsBarInfo.Count < 1)
        {
            throw new Exception($"该追溯码{query.Zsbarcode}不存在不存在");
        }

        return ZsBarInfo;
    }

    /// <summary>
    /// 获取卡板明细信息
    /// </summary>
    /// <param name="query"></param>
    /// <returns></returns>
    public dynamic getKbBarMxInfo(dynamic query)
    {

        var sql = string.Format(@"SELECT ITEM_BARCODE, QUANTITY,item_no,item_name,item_model
FROM MES_INV_ITEM_BARCODES_TBMX A
         LEFT JOIN WOMDAA B ON B.daa001 = A.DAA_001
        LEFT JOIN MES_ITEMS C ON C.item_id = B.daa002
WHERE ABOUT_TB_BARCODE = '{0}' ", query.Kbbarcode);

        var ZsBarInfo = Db.Ado.SqlQuery<dynamic>(sql);

        if (ZsBarInfo.Count < 1)
        {
            throw new Exception($"该追溯码{query.Zsbarcode}不存在不存在");
        }

        return ZsBarInfo;
    }
}

 service/Wom/WwGdManager.cs

@@ -1,5 +1,6 @@
using System.Data;
using System.Data.SqlClient;
using System.Threading.Tasks.Dataflow;
using Masuit.Tools;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
@@ -773,7 +774,7 @@
        // 获取补料单明细并校验
        var blDetail = Db.Queryable<MesItemBlDetail>()
            .Where(b =>
                b.Mid == mesItemBl.Id && b.Bld012 == stockBarcode.ItemId)
                b.Mid == mesItemBl.Id && b.Bld012 == stockBarcode.ItemId && b.Bld007 > b.Bld008)
            .First();

        if (blDetail == null)
@@ -939,7 +940,8 @@
                    PbillNo = query.billNo,
                    ItemId = blDetail.Bld012,
                    DepotId = stockBarcode.DepotsId.ToString(),
                    ItemDabid = womdab.Id,
                    ItemDabid = blDetail.Id,
                    //AboutGuid = womdab.Id
                    // Unit = blDetail.Bld009,
                    // DepotId = (int)stockBarcode.DepotsId
                }).IgnoreColumns(true).ExecuteCommand();