111

啊鑫

2025-08-29 d1dc6aaa453c38c6282930d85c58388b89aac065

 MES.Service/service/Warehouse/MesInvItemMovesManager.cs

@@ -14,7 +14,8 @@

    public MovesDto ScanInBarcode(WarehouseQuery query)
    {
        if (string.IsNullOrEmpty(query.sectionCode)) throw new Exception("请扫库位条码！");
        if (string.IsNullOrEmpty(query.sectionCode))
            throw new Exception("请扫库位条码！");

        var pBillTypeId = 300;
        var pTransctionNo = 301;
@@ -26,7 +27,8 @@
            .Select((a, b) => new { b.DepotCode })
            .First();

        if (depotQuery == null) throw new Exception($"002[库位编码 {query.sectionCode} 不存在，请确认！");
        if (depotQuery == null)
            throw new Exception($"002[库位编码 {query.sectionCode} 不存在，请确认！");

        var cDepotCode = depotQuery.DepotCode;

@@ -48,17 +50,20 @@
        var iDepotCode = itemMoveQuery.InvDepotsCode;

        // 验证库区与仓库
        var depotValidationQuery = Db.Queryable<MesDepotSections, MesDepots>(
                (a, b) => new JoinQueryInfos(
        var depotValidationQuery = Db
            .Queryable<MesDepotSections, MesDepots>((a, b) =>
                new JoinQueryInfos(
                    JoinType.Inner, a.Zuid.ToString() == b.Zuid))
            .Where((a, b) => a.DepotSectionCode == query.sectionCode &&
                             b.DepotCode == iDepotCode)
            .Select((a, b) => new { b.DepotCode })
            .First();

        if (depotValidationQuery == null) throw new Exception($"002[库位编码 {query.sectionCode} 不存在，请确认！");
        if (depotValidationQuery == null)
            throw new Exception($"002[库位编码 {query.sectionCode} 不存在，请确认！");

        if (iDepotCode != depotValidationQuery.DepotCode) throw new Exception("实际仓库与申请调入仓库不符，请核对！");
        if (iDepotCode != depotValidationQuery.DepotCode)
            throw new Exception("实际仓库与申请调入仓库不符，请核对！");

        var barcodeCount = Db.Queryable<MesInvItemMovesCDetails>()
            .Where(b =>
@@ -176,13 +181,14 @@
    private List<MesInvItemMovesCDetails> GetItemMovesCDetails(
        WarehouseQuery query)
    {
        return Db.Queryable<MesInvItemMovesCDetails, MesItems, MesSupplier>(
                (b, c, f) => new JoinQueryInfos(
                    JoinType.Left,
                    b.ItemNo == c.ItemNo && b.Company == c.Company &&
                    b.Factory == c.Factory,
                    JoinType.Left, b.SuppNo == f.SuppNo
                ))
        return Db
            .Queryable<MesInvItemMovesCDetails, MesItems,
                MesSupplier>((b, c, f) => new JoinQueryInfos(
                JoinType.Left,
                b.ItemNo == c.ItemNo && b.Company == c.Company &&
                b.Factory == c.Factory,
                JoinType.Left, b.SuppNo == f.SuppNo
            ))
            .Where((b, c, f) => b.ItemMoveId == query.id)
            .Select((b, c, f) => new MesInvItemMovesCDetails
            {
@@ -226,9 +232,9 @@
        if (mesInvItemMoves == null)
            throw new Exception("出库单 " + query.billNo + "不存在，请确认！");

        var count = Db.Queryable<MesInvItemMoves, MesInvItemMovesCDetails>(
                (a, b) =>
                    new JoinQueryInfos(JoinType.Inner, a.Id == b.ItemMoveId))
        var count = Db
            .Queryable<MesInvItemMoves, MesInvItemMovesCDetails>((a, b) =>
                new JoinQueryInfos(JoinType.Inner, a.Id == b.ItemMoveId))
            .Where((a, b) => b.ItemBarcode == query.barcode
                             && a.TransactionNo == TransctionNo &&
                             SqlFunc.IsNull(a.Status, 0) == 0).Count();