1.条码表实体类型调整 2.条码库存表实体新增基础字段 3.期初入库新增入库人

南骏 池

2025-02-13 eda0c8f74ce453b6e43f88fc92b1e651ce5b6095

 service/Warehouse/InventoryManager.cs

@@ -16,9 +16,7 @@

        // 检查库位代码是否为空
        if (string.IsNullOrEmpty(p_section_code))
        {
            throw new Exception("002[请扫库位条码！");
        }

        // 查询库区库位信息
        var depotSection = Db.Queryable<MesDepotSections, MesDepots>((a, b) =>
@@ -32,9 +30,7 @@

        // 如果库位代码不存在，则返回错误信息
        if (depotSection == null)
        {
            throw new Exception("库位编码 " + p_section_code + " 不存在，请确认！");
        }

        // 返回成功信息
        return "仓库：" + depotSection.DepotName + "  库位：" +
@@ -52,9 +48,7 @@

        // 检查库位代码是否为空
        if (string.IsNullOrEmpty(p_section_code))
        {
            throw new Exception("002[请扫库位条码！");
        }

        // 查询库区库位信息
        var depotSection = Db.Queryable<MesDepotSections, MesDepots>((a, b) =>
@@ -68,9 +62,7 @@

        // 如果库位代码不存在，则返回错误信息
        if (depotSection == null)
        {
            throw new Exception("库位编码 " + p_section_code + " 不存在，请确认！");
        }

        // 检查是否已经收货
        var c_num = Db.Queryable<MesInvItemIns, MesInvItemInCDetails>((a, b) =>
@@ -80,20 +72,14 @@
            .Where((a, b) => b.ItemBarcode == p_item_barcode)
            .Count();

        if (c_num > 0)
        {
            throw new Exception("002[条码重复扫描，请核对！");
        }
        if (c_num > 0) throw new Exception("002[条码重复扫描，请核对！");

        // 查询条码信息
        c_num = Db.Queryable<MesInvItemStocks>()
            .Where(t => t.ItemBarcode == p_item_barcode)
            .Count();

        if (c_num > 0)
        {
            throw new Exception("002[条码已在库存中，请核对！");
        }
        if (c_num > 0) throw new Exception("002[条码已在库存中，请核对！");

        // 查询条码详细信息
        var c_mes_inv_item_barcodes = Db.Queryable<MesInvItemBarcodes>()
@@ -101,14 +87,10 @@
            .Single();

        if (c_mes_inv_item_barcodes == null)
        {
            throw new Exception("002[条码不存在，请核对！");
        }

        if (c_mes_inv_item_barcodes.ComeFlg != 0)
        {
            throw new Exception("002[条码不是期初条码，无法用期初入库！");
        }

        UseTransaction(db =>
        {
@@ -144,7 +126,12 @@
                    BillNo = billNo,
                    SuppId = c_mes_inv_item_barcodes.SuppId,
                    SuppNo = c_mes_inv_item_barcodes.SuppNo,
                    UrgentFlag = c_mes_inv_item_barcodes.UrgentFlag == null ? null : c_mes_inv_item_barcodes.UrgentFlag.Value ? "1" : "0",
                    UrgentFlag = c_mes_inv_item_barcodes.UrgentFlag == null
                        ?
                        null
                        : c_mes_inv_item_barcodes.UrgentFlag.Value
                            ? "1"
                            : "0",
                    CbillNo = c_mes_inv_item_barcodes.BillNo,
                    Fstatus = 0
                };
@@ -226,8 +213,11 @@
                ItemNo = c_mes_inv_item_barcodes.ItemNo,
                LotNo = c_mes_inv_item_barcodes.LotNo,
                Quantity = c_mes_inv_item_barcodes.Quantity,
                EpFlag = c_mes_inv_item_barcodes.EpFlag == null ? null : (byte)(c_mes_inv_item_barcodes.EpFlag.Value ? 1 : 0),
                EpFlag = c_mes_inv_item_barcodes.EpFlag == null
                    ? null
                    : (byte)(c_mes_inv_item_barcodes.EpFlag.Value ? 1 : 0),
                DepotsCode = depotSection.DepotCode,
                DepotId = depotSection.DepotId,
                DepotsId = depotSection.DepotId,
                DepotSectionsCode = p_section_code,
                CheckDate = c_mes_inv_item_barcodes.CreateDate,
@@ -237,7 +227,8 @@
                WorkLine = c_mes_inv_item_barcodes.WorkLine,
                // ItemUnit = c_mes_inv_item_barcodes.Unit,
                SuppNo = c_mes_inv_item_barcodes.SuppNo,
                ItemId = c_mes_inv_item_barcodes.ItemId
                ItemId = c_mes_inv_item_barcodes.ItemId,
                IndepUserCode = c_user
                // Fsubsidiary = c_organize
            }).IgnoreColumns(true).ExecuteCommand();

@@ -245,7 +236,7 @@
        });

        var mesItems = Db.Queryable<MesItems>()
            .Where(s=>s.Id == c_mes_inv_item_barcodes.ItemId)
            .Where(s => s.Id == c_mes_inv_item_barcodes.ItemId)
            .First();

        query.itemNo = mesItems.ItemNo;