1.销售出库功能开发，拆分未实现。

南骏 池

2025-02-28 b3bd860758d33a47964087f3ee7333b646fe443d

1.销售出库功能开发，拆分未实现。

 Controllers/Warehouse/MesXsckController.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,461 @@
using System.Dynamic;
using Microsoft.AspNetCore.Mvc;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
using NewPdaSqlServer.service.Warehouse;
using NewPdaSqlServer.util;

namespace NewPdaSqlServer.Controllers.Warehouse;

/// <summary>
///     ç”Ÿäº§è¡¥æ–™ç›¸å…³æŽ¥å£
/// </summary>
[Route("api/[controller]")]
[ApiController]
public class MesXsckController : ControllerBase
{
    private readonly MesXsckManager _manager = new();

    /***进入模版管理可以修改模版***/

    /// <summary>
    ///     èŽ·å–所有
    /// </summary>
    /// <returns></returns>
    [HttpPost("GetList")]
    public ResponseResult GetList()
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = _manager.GetList();
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     æ ¹æ®ä¸»é”®èŽ·å–
    /// </summary>
    /// <returns></returns>
    [HttpPost("GetById")]
    public ResponseResult GetById(int id)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = _manager.GetById(id);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     æ ¹æ®ä¸»é”®åˆ é™¤
    /// </summary>
    /// <returns></returns>
    [HttpPost("DeleteByIds")]
    public ResponseResult DeleteByIds([FromBody] object[] ids)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = _manager.DeleteByIds(ids);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     æ·»åŠ 
    /// </summary>
    /// <returns></returns>
    [HttpPost("Insert")]
    public ResponseResult Add([FromBody] MesItemBl data)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = _manager.Insert(data);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     æ·»åŠ è¿”回自增
    /// </summary>
    /// <returns></returns>
    [HttpPost("InsertReturnIdentity")]
    public ResponseResult InsertReturnIdentity([FromBody] MesItemBl data)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = _manager.InsertReturnIdentity(data);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     ä¿®æ”¹
    /// </summary>
    /// <returns></returns>
    [HttpPost("Update")]
    public ResponseResult Update([FromBody] MesItemBl data)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = _manager.Update(data);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     ç”Ÿäº§è¡¥æ–™å•æ¡ç æ‹†åˆ†
    /// </summary>
    /// <param name="query">查询参数</param>
    /// <returns>拆分结果和待处理列表</returns>
    /// <remarks>
    ///     è¯·æ±‚示例:
    ///     POST /api/MesItemBl/SplitBarcode
    ///     {
    ///     "billNo": "WO202401010001",  // å·¥å•å·(必填)
    ///     "barcode": "BC001",          // æ¡ç å·(必填)
    ///     "userName": "admin",          // ç”¨æˆ·å(必填)
    ///     "blNo": "BL202401010001",    // è¡¥æ–™å•å·(必填)
    ///     "Num": 10                    // æ‹†åˆ†æ•°é‡(必填,必须大于0)
    ///     }
    ///     ä¸šåŠ¡å¤„理：
    ///     - éªŒè¯è¡¥æ–™å•çŠ¶æ€
    ///     - éªŒè¯æ¡ç åº“存信息
    ///     - éªŒè¯æ‹†åˆ†æ•°é‡æ˜¯å¦åˆç†
    ///     - æ‰§è¡Œæ¡ç æ‹†åˆ†äº‹åŠ¡å¤„理
    ///     - æ›´æ–°å·¥å•å’Œè¡¥æ–™å•ç›¸å…³æ•°é‡
    ///     è¿”回数据包含：
    ///     - success: æ‹†åˆ†æ˜¯å¦æˆåŠŸ
    ///     - pendingList: å¾…处理明细列表，包含：
    ///     * Bld012: ç‰©æ–™ID
    ///     * Bld002: ç‰©æ–™ç¼–号
    ///     * Bld003: ç‰©æ–™åç§°
    ///     * Bld004: ç‰©æ–™è§„æ ¼
    ///     * Bld007: è®¡åˆ’数量
    ///     * Bld008: å·²è¡¥æ•°é‡
    /// </remarks>
    /// <response code="200">拆分成功</response>
    /// <response code="400">拆分失败，返回具体错误信息</response>
    [HttpPost("SplitBarcode")]
    public ResponseResult SplitBarcode([FromBody] WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var (success, pendingList) = _manager.SplitBarcode(query);
            resultInfos.success = success;
            resultInfos.pendingList = pendingList;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    #region ç”Ÿäº§è¡¥æ–™

    /// <summary>
    ///     èŽ·å–生产补料单号列表
    /// </summary>
    /// <returns>补料单号列表</returns>
    /// <response code="200">成功获取补料单号列表</response>
    /// <response code="400">获取失败</response>
    [HttpPost("GetFHTZBillNo")]
    public ResponseResult GetFHTZBillNo(WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = _manager.GetFHTZBillNo(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     æ ¹æ®å•å·èŽ·å–生产补料单明细
    /// </summary>
    /// <param name="query">查询参数，必须包含billNo</param>
    /// <returns>补料单明细列表</returns>
    /// <remarks>
    ///     è¯·æ±‚示例:
    ///     POST /api/MesItemBl/GetMesItemBlDetailByBillNo
    ///     {
    ///     "billNo": "BL202401010001"
    ///     }
    /// </remarks>
    /// <response code="200">成功获取补料单明细</response>
    /// <response code="400">获取失败，可能是单据号不存在或已完成</response>
    [HttpPost("GetMesItemFHTZetailByBillNo")]
    public ResponseResult GetMesItemFHTZetailByBillNo(
        [FromBody] WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = _manager.GetMesItemFHTZetailByBillNo(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     æ‰«ææ¡ç 
    /// </summary>
    /// <param name="query">查询参数</param>
    /// <returns>扫描结果和待处理列表</returns>
    /// <remarks>
    ///     è¯·æ±‚示例:
    ///     POST /api/MesItemBl/SctlScanBarcode
    ///     {
    ///     "billNo": "WO202401010001",
    ///     "barcode": "1234567890",
    ///     "userName": "admin",
    ///     "blNo": "BL202401010001"
    ///     }
    /// </remarks>
    /// <response code="200">扫描成功</response>
    /// <response code="400">扫描失败，返回具体错误信息</response>
    [HttpPost("XSCKScanBarcode")]
    public ResponseResult XSCKScanBarcode([FromBody] WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = _manager.XSCKScanBarcode(query);
            if (resultInfos.tbBillList.result == "2")
            {
                return new ResponseResult
                {
                    status = Convert.ToInt32(resultInfos.tbBillList.result),
                    message = resultInfos.tbBillList.strMsg,
                    data = resultInfos
                };
            }
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    #endregion

    #region ç”Ÿäº§è¶…领

    /// <summary>
    ///     èŽ·å–生产超领单号列表
    /// </summary>
    /// <returns>超领单号列表</returns>
    /// <response code="200">成功获取超领单号列表</response>
    /// <response code="400">获取失败</response>
    [HttpPost("GetSccList")]
    public ResponseResult GetSccList(WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = _manager.GetSccList(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     èŽ·å–生产超领单明细
    /// </summary>
    /// <param name="query">查询参数，必须包含billNo</param>
    /// <returns>超领单明细列表</returns>
    /// <remarks>
    ///     è¯·æ±‚示例:
    ///     POST /api/MesItemBl/GetMesItemBlDetailBySccBillNo
    ///     {
    ///     "billNo": "SC202401010001"
    ///     }
    /// </remarks>
    /// <response code="200">成功获取超领单明细</response>
    /// <response code="400">获取失败，返回具体错误信息</response>
    [HttpPost("GetMesItemBlDetailBySccBillNo")]
    public ResponseResult GetMesItemBlDetailBySccBillNo(
        [FromBody] WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList =
                _manager.GetMesItemBlDetailBySccBillNo(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    /// <summary>
    ///     ç”Ÿäº§è¶…领扫描条码1
    /// </summary>
    /// <param name="query">查询参数</param>
    /// <returns>扫描结果和待处理列表</returns>
    /// <remarks>
    ///     è¯·æ±‚示例:
    ///     POST /api/MesItemBl/ScanBarcodeForOverPicking
    ///     {
    ///     "billNo": "WO202401010001",
    ///     "barcode": "1234567890",
    ///     "userName": "admin",
    ///     "blNo": "SC202401010001"
    ///     }
    /// </remarks>
    /// <response code="200">扫描成功</response>
    /// <response code="400">扫描失败，返回具体错误信息</response>
    [HttpPost("ScanBarcodeForOverPicking")]
    public ResponseResult ScanBarcodeForOverPicking(
        [FromBody] WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var (success, pendingList) =
                _manager.ScanBarcodeForOverPicking(query);
            resultInfos.success = success;
            resultInfos.pendingList = pendingList;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }


    [HttpPost("PrintBarcodeForOverPicking")]
    public ResponseResult PrintForOverPicking(WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            var (success, pendingList) =
                _manager.PrintBarcodeForOverPicking(query);
            resultInfos.success = success;
            resultInfos.pendingList = pendingList;
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    #endregion
}

 entity/MesDbModel.cs

@@ -3,7 +3,7 @@
namespace MES.Service.Modes;

//调拨出入库单通用类
public class TransferOutDetailModel
public class ItemDetailModel
{
    public string ItemNo { get; set; } // ç‰©å“ç¼–号
    public string ItemName { get; set; } // ç‰©å“åç§°

 entity/SalesDeliver.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,106 @@
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     å‘货通知申请单
/// </summary>
[SugarTable("SALES_DELIVER")]
public class SalesDeliver
{
    /// <summary>
    ///     ä¸»é”®
    /// </summary>
    [SugarColumn(ColumnName = "id", IsPrimaryKey = true)]
    public Guid? Id { get; set; }

    /// <summary>
    ///     å•æ®ç¼–号
    /// </summary>
    [SugarColumn(ColumnName = "bill_no")]
    public string? BillNo { get; set; }

    /// <summary>
    ///     å•æ®ç±»åž‹
    /// </summary>
    [SugarColumn(ColumnName = "FBillTypeID")]
    public string? FBillTypeId { get; set; }

    /// <summary>
    ///     é”€å”®ç»„织
    /// </summary>
    [SugarColumn(ColumnName = "FSaleOrgId")]
    public string? FSaleOrgId { get; set; }

    /// <summary>
    ///     å‘货组织
    /// </summary>
    [SugarColumn(ColumnName = "FStockOrgId")]
    public string? FStockOrgId { get; set; }

    /// <summary>
    ///     åˆ›å»ºäºº
    /// </summary>
    [SugarColumn(ColumnName = "FCreatorId")]
    public string? FCreatorId { get; set; }

    /// <summary>
    ///     å®¡æ ¸äºº
    /// </summary>
    [SugarColumn(ColumnName = "FApproverID")]
    public string? FApproverId { get; set; }

    /// <summary>
    ///     åˆ›å»ºæ—¥æœŸ
    /// </summary>
    [SugarColumn(ColumnName = "FCreateDate")]
    public DateTime? FCreateDate { get; set; }

    /// <summary>
    ///     å®¡æ ¸æ—¥æœŸ
    /// </summary>
    [SugarColumn(ColumnName = "FApproveDate")]
    public DateTime? FApproveDate { get; set; }

    /// <summary>
    ///     é”€å”®å‘˜
    /// </summary>
    [SugarColumn(ColumnName = "FSalesManID")]
    public string? FSalesManId { get; set; }

    /// <summary>
    ///     å®¢æˆ·
    /// </summary>
    [SugarColumn(ColumnName = "FCustomerID")]
    public string? FCustomerId { get; set; }

    /// <summary>
    ///     æ—¥æœŸ
    /// </summary>
    [SugarColumn(ColumnName = "FDate")]
    public DateTime? FDate { get; set; }

    /// <summary>
    ///     å¤‡æ³¨
    /// </summary>
    [SugarColumn(ColumnName = "FNote")]
    public string? FNote { get; set; }

    /// <summary>
    ///     å®¡æ ¸çŠ¶æ€
    /// </summary>
    [SugarColumn(ColumnName = "FApproverStaus")]
    public bool? FApproverStatus { get; set; }

    /// <summary>
    ///     æ˜¯å¦å®Œç»“
    /// </summary>
    [SugarColumn(ColumnName = "FINISHSTATUS")]
    public bool? FinishStatus { get; set; }

    /// <summary>
    ///     é”€å”®è®¢å•å·
    /// </summary>
    [SugarColumn(ColumnName = "SalesId")]
    public Guid? SalesId { get; set; }
}

 entity/SalesDeliverDetail.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,52 @@
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     å‘货通知单明细
/// </summary>
[SugarTable("SALES_DELIVER_DETAIL")]
public class SalesDeliverDetail
{
    /// <summary>
    ///     ä¸»é”®
    /// </summary>
    [SugarColumn(ColumnName = "id", IsPrimaryKey = true)]
    public Guid? Id { get; set; }

    /// <summary>
    ///     ä¸»è¡¨GUID
    /// </summary>
    [SugarColumn(ColumnName = "pid")]
    public Guid? Pid { get; set; }

    /// <summary>
    ///     é”€å”®è®¢å•æ˜Žç»†GUID
    /// </summary>
    [SugarColumn(ColumnName = "SalesDetailId")]
    public Guid? SalesDetailId { get; set; }

    /// <summary>
    ///     åº”发数量
    /// </summary>
    [SugarColumn(ColumnName = "FMustQty")]
    public decimal? FMustQty { get; set; }

    /// <summary>
    ///     å®žå‘数量
    /// </summary>
    [SugarColumn(ColumnName = "FRealQty")]
    public decimal? FRealQty { get; set; }

    /// <summary>
    ///     å¤‡æ³¨
    /// </summary>
    [SugarColumn(ColumnName = "FEntrynote")]
    public string? FEntryNote { get; set; }

    /// <summary>
    ///     æŽ’序
    /// </summary>
    [SugarColumn(ColumnName = "FSEQ")]
    public int? FSeq { get; set; }
}

 entity/SalesOrder.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,137 @@
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     é”€å”®è®¢å•è¡¨
/// </summary>
[SugarTable("SALES_ORDER")]
public class SalesOrder
{
    /// <summary>
    ///     SEQ_sales序列
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
    public Guid? Id { get; set; }

    [SugarColumn(ColumnName = "ERP_ID")]
    public decimal? ErpID { get; set; } // ERPID

    [SugarColumn(ColumnName = "BILL_NO")]
    public string? BillNo { get; set; } // å•æ®ç¼–号

    [SugarColumn(ColumnName = "BILL_TYPE_ID")]
    public string? BillTypeId { get; set; } // å•æ®ç±»åž‹

    [SugarColumn(ColumnName = "DOCUMENT_STATUS")]
    public string? DocumentStatus { get; set; } // å•æ®çŠ¶æ€

    [SugarColumn(ColumnName = "F_DATE")]
    public DateTime? FDate { get; set; } // æ—¥æœŸ

    [SugarColumn(ColumnName = "BUSINESS_TYPE")]
    public string? BusinessType { get; set; } // ä¸šåŠ¡ç±»åž‹

    [SugarColumn(ColumnName = "HEAD_DELIVERY_WAY")]
    public string? HeadDeliveryWay { get; set; } // äº¤è´§æ–¹å¼

    [SugarColumn(ColumnName = "HEAD_LOC_ID")]
    public string? HeadLocId { get; set; } // äº¤è´§åœ°ç‚¹

    [SugarColumn(ColumnName = "SALE_ORG_ID")]
    public string? SaleOrgId { get; set; } // é”€å”®ç»„织

    //[SugarColumn(ColumnName = "UNW_TEXT_KHDD")]
    //public string? UnWTextKhdd { get; set; } // å®¢æˆ·è®¢å•

    //[SugarColumn(ColumnName = "UNW_DATE_KHXQ")]
    //public DateTime? UnWDateKhxq { get; set; } // å®¢æˆ·éœ€æ±‚交期

    //[SugarColumn(ColumnName = "UNW_BASE_PROPERTY_KHDJ")]
    //public string? UnWBasePropertyKhdj { get; set; } // å®¢æˆ·ç­‰çº§

    [SugarColumn(ColumnName = "CUST_ID")]
    public string? CustId { get; set; } // å®¢æˆ·

    //[SugarColumn(ColumnName = "UNW_LARGE_TEXT_TBKHBZ")]
    //public string? UnWLargetextTbkhbz { get; set; } // æ·˜å®å®¢æˆ·å¤‡æ³¨

    [SugarColumn(ColumnName = "CLOSE_STATUS")]
    public string? CloseStatus { get; set; } // å…³é—­çŠ¶æ€

    [SugarColumn(ColumnName = "SALE_DEPT_ID")]
    public string? SaleDeptId { get; set; } // é”€å”®éƒ¨é—¨

    [SugarColumn(ColumnName = "SALER_ID")]
    public string? SalerId { get; set; } // é”€å”®å‘˜

    [SugarColumn(ColumnName = "NOTE")]
    public string? Note { get; set; } // å¤‡æ³¨

    //[SugarColumn(ColumnName = "UNW_REMARKS_KHJHDD")]
    //public string? UnWRemarksKhjHdd { get; set; } // å®¢æˆ·äº¤è´§åœ°ç‚¹
    [SugarColumn(ColumnName = "RECEIVE_ID")]
    public string? ReceiveId { get; set; } // æ”¶è´§æ–¹

    [SugarColumn(ColumnName = "RECEIVE_CONTACT")]
    public string? ReceiveContact { get; set; } // æ”¶è´§æ–¹è”系人

    [SugarColumn(ColumnName = "SETTLE_ID")]
    public string? SettleId { get; set; } // ç»“ç®—æ–¹

    [SugarColumn(ColumnName = "APPROVER_ID")]
    public string? ApproverId { get; set; } // å®¡æ ¸äºº

    [SugarColumn(ColumnName = "LINK_MAN")]
    public string? LinkMan { get; set; } // æ”¶è´§äººå§“名

    [SugarColumn(ColumnName = "CHARGE_ID")]
    public string? ChargeId { get; set; } // ä»˜æ¬¾æ–¹

    [SugarColumn(ColumnName = "LINK_PHONE")]
    public string? LinkPhone { get; set; } // è”系电话

    [SugarColumn(ColumnName = "CREATOR_ID")]
    public string? CreatorId { get; set; } // åˆ›å»ºäºº

    [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; } // åˆ›å»ºæ—¥æœŸ

    [SugarColumn(ColumnName = "MODIFIER_ID")]
    public string? ModifierId { get; set; } // æœ€åŽä¿®æ”¹äºº

    [SugarColumn(ColumnName = "MODIFY_DATE")]
    public DateTime? ModifyDate { get; set; } // æœ€åŽä¿®æ”¹æ—¥æœŸ

    [SugarColumn(ColumnName = "APPROVE_DATE")]
    public DateTime? ApproveDate { get; set; } // å®¡æ ¸æ—¥æœŸ

    [SugarColumn(ColumnName = "CLOSER_ID")]
    public string? CloserId { get; set; } // å…³é—­äºº

    [SugarColumn(ColumnName = "CLOSE_DATE")]
    public DateTime? CloseDate { get; set; } // å…³é—­æ—¥æœŸ

    [SugarColumn(ColumnName = "CHANGE_DATE")]
    public DateTime? ChangeDate { get; set; } // å˜æ›´æ—¥æœŸ

    [SugarColumn(ColumnName = "CANCEL_STATUS")]
    public string? CancelStatus { get; set; } // ä½œåºŸçŠ¶æ€

    [SugarColumn(ColumnName = "CANCELLER_ID")]
    public string? CancellerId { get; set; } // ä½œåºŸäºº

    [SugarColumn(ColumnName = "VERSION_NO")]
    public double? VersionNo { get; set; } // ç‰ˆæœ¬å·

    [SugarColumn(ColumnName = "CHANGE_REASON")]
    public string? ChangeReason { get; set; } // å˜æ›´åŽŸå› 

    [SugarColumn(ColumnName = "CHANGER_ID")]
    public string? ChangerId { get; set; } // å˜æ›´äºº

    [SugarColumn(ColumnName = "ENTRY_NOTE")]
    public string? EntryNote { get; set; } // å¤‡æ³¨


}

 entity/SalesOrderDetail.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,251 @@
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     é”€å”®è®¢å•æ˜Žç»†è¡¨
/// </summary>
[SugarTable("SALES_ORDER_DETAIL")]
public class SalesOrderDetail
{
    /// <summary>
    ///     SEQ_sales序列
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
    public Guid Id { get; set; }

    /// <summary>
    ///     SEQ_sales序列
    /// </summary>
    [SugarColumn(ColumnName = "pid")]
    public Guid? Pid { get; set; }

    /// <summary>
    ///     ERPID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_ID")]
    public decimal? ErpID { get; set; }

    /// <summary>
    ///     ERP头ID
    /// </summary>
    [SugarColumn(ColumnName = "E_HID")]
    public decimal? EHID { get; set; }

    /// <summary>
    ///     ç‰©æ–™ç¼–码
    /// </summary>
    [SugarColumn(ColumnName = "MATERIAL_ID")]
    public string? MaterialId { get; set; }

    /// <summary>
    ///     å®¢æˆ·ç‰©æ–™ç¼–码
    /// </summary>
    [SugarColumn(ColumnName = "MAP_ID")]
    public string? MapId { get; set; }

    /// <summary>
    ///     å®¢æˆ·ç‰©æ–™åç§°
    /// </summary>
    [SugarColumn(ColumnName = "MAP_NAME")]
    public string? MapName { get; set; }

    /// <summary>
    ///     å®¢æˆ·ç‰©æ–™è§„æ ¼
    /// </summary>
    [SugarColumn(ColumnName = "MAP_SPEC")]
    public string? MapSpec { get; set; }

    /// <summary>
    ///     åºå·
    /// </summary>
    [SugarColumn(ColumnName = "Seq")]
    public int? Seq { get; set; }

    /// <summary>
    ///     é”€å”®å•ä½
    /// </summary>
    [SugarColumn(ColumnName = "UNIT_ID")]
    public string? UnitId { get; set; }

    /// <summary>
    ///     é”€å”®æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "QTY")]
    public decimal? Qty { get; set; }

    /// <summary>
    ///     è®¡ä»·å•ä½
    /// </summary>
    [SugarColumn(ColumnName = "PRICE_UNIT_ID")]
    public string? PriceUnitId { get; set; }

    /// <summary>
    ///     è®¡ä»·æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "PRICE_UNIT_QTY")]
    public decimal? PriceUnitQty { get; set; }

    /// <summary>
    ///     è¦è´§æ—¥æœŸ
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_DATE")]
    public DateTime? DeliveryDate { get; set; }

    /// <summary>
    ///     æ˜¯å¦èµ å“
    /// </summary>
    [SugarColumn(ColumnName = "IS_FREE")]
    public string? IsFree { get; set; }

    ///// <summary>
    /////     é”€å”®è®¢å•å·
    ///// </summary>
    //[SugarColumn(ColumnName = "UNW_TEXT_XSDDH")]
    //public string? SalesOrderNo { get; set; }

    /// <summary>
    ///     ä¾›åº”组织
    /// </summary>
    [SugarColumn(ColumnName = "SUPPLY_ORG_ID")]
    public string? SupplyOrgId { get; set; }

    /// <summary>
    ///     åº“存组织
    /// </summary>
    [SugarColumn(ColumnName = "STOCK_ORG_ID")]
    public string? StockOrgId { get; set; }

    /// <summary>
    ///     ç»“算组织
    /// </summary>
    [SugarColumn(ColumnName = "SETTLE_ORG_IDS")]
    public string? SettleOrgIds { get; set; }


    ///// <summary>
    /////     è·Ÿå•å‘˜
    ///// </summary>
    //[SugarColumn(ColumnName = "UNW_BASE_GDY")]
    //public string? SalesFollowUp { get; set; }

    /// <summary>
    ///     è´§ä¸»ç±»åž‹
    /// </summary>
    [SugarColumn(ColumnName = "OWNER_TYPE_ID")]
    public string? OwnerTypeId { get; set; }

    /// <summary>
    ///     è´§ä¸»
    /// </summary>
    [SugarColumn(ColumnName = "OWNER_ID")]
    public string? OwnerId { get; set; }

    /// <summary>
    ///     å¤‡æ³¨
    /// </summary>
    [SugarColumn(ColumnName = "ENTRY_NOTE")]
    public string? EntryNote { get; set; }

    /// <summary>
    ///     è®¡åˆ’跟踪号
    /// </summary>
    [SugarColumn(ColumnName = "MTO_NO")]
    public string? MtoNo { get; set; }

    /// <summary>
    ///     æ‰¹å·
    /// </summary>
    [SugarColumn(ColumnName = "LOT")]
    public string? Lot { get; set; }

    /// <summary>
    ///     å‘货上限
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_MAX_QTY")]
    public decimal? DeliveryMaxQty { get; set; }

    /// <summary>
    ///     å‘货下限
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_MIN_QTY")]
    public decimal? DeliveryMinQty { get; set; }

    /// <summary>
    ///     è¶…发控制单位
    /// </summary>
    [SugarColumn(ColumnName = "OUT_LMT_UNIT_ID")]
    public string? OutLmtUnitId { get; set; }

    /// <summary>
    ///     ä¸šåŠ¡å…³é—­
    /// </summary>
    [SugarColumn(ColumnName = "MRP_CLOSE_STATUS")]
    public string? MrpCloseStatus { get; set; }

    /// <summary>
    ///     ä¸šåŠ¡ç»ˆæ­¢
    /// </summary>
    [SugarColumn(ColumnName = "MRP_TERMINATE_STATUS")]
    public string? MrpTerminateStatus { get; set; }

    /// <summary>
    ///     ç»ˆæ­¢æ—¥æœŸ
    /// </summary>
    [SugarColumn(ColumnName = "TERMINATE_DATE")]
    public DateTime? TerminateDate { get; set; }

    /// <summary>
    ///     ç»ˆæ­¢äºº
    /// </summary>
    [SugarColumn(ColumnName = "TERMINATER_ID")]
    public string? TerminaterId { get; set; }

    /// <summary>
    ///     æºå•ç±»åž‹
    /// </summary>
    [SugarColumn(ColumnName = "SRC_TYPE")]
    public string? SrcType { get; set; }

    /// <summary>
    ///     æºå•å•å·
    /// </summary>
    [SugarColumn(ColumnName = "SRC_BILL_NO")]
    public string? SrcBillNo { get; set; }

    /// <summary>
    ///     ç´¯è®¡å‘货通知数量
    /// </summary>
    [SugarColumn(ColumnName = "DELI_QTY")]
    public decimal? DeliQty { get; set; }

    /// <summary>
    ///     ç´¯è®¡å‡ºåº“数量
    /// </summary>
    [SugarColumn(ColumnName = "STOCK_OUT_QTY")]
    public decimal? StockOutQty { get; set; }

    /// <summary>
    ///     ç´¯è®¡é€€è´§é€šçŸ¥æ•°é‡ï¼ˆé”€å”®åŸºæœ¬ï¼‰
    [SugarColumn(ColumnName = "BASE_RET_NOTICE_QTY")]
    public decimal? BaseRetNoticeQty { get; set; } /// </summary>

    /// <summary>
    ///     ç´¯è®¡é€€è´§æ•°é‡ï¼ˆé”€å”®åŸºæœ¬ï¼‰
    /// </summary>
    [SugarColumn(ColumnName = "BASE_RETURN_QTY")]
    public decimal? BaseReturnQty { get; set; }

    /// <summary>
    ///     å‰©ä½™æœªå‡ºæ•°é‡ï¼ˆé”€å”®åŸºæœ¬ï¼‰
    /// </summary>
    [SugarColumn(ColumnName = "BASE_REMAIN_OUT_QTY")]
    public decimal? BaseRemainOutQty { get; set; }

    /// <summary>
    ///     ç´¯è®¡åº”收数量（销售基本）
    /// </summary>
    [SugarColumn(ColumnName = "BASEARQTY")]
    public decimal? BASEARQTY { get; set; }

}

 service/Warehouse/MesXsckManager.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,1489 @@
using Masuit.Tools;
using MES.Service.Modes;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
using NewPdaSqlServer.util;
using SqlSugar;
using SqlSugar.Extensions;
using System.Data;
using System.Data.SqlClient;

namespace NewPdaSqlServer.service.Warehouse;

public class MesXsckManager : Repository<MesItemBl>
{
    #region ç”Ÿäº§è¡¥æ–™

    /// <summary>
    ///     èŽ·å–生产发货通知单号列表
    /// </summary>
    /// <returns>发货通知单号列表</returns>
    public List<string> GetFHTZBillNo(WarehouseQuery query)
    {
        var list = Db.Queryable<SalesDeliver>()
            .Where(s => (s.FApproverStatus ?? false) == true)
            .Select(s => s.BillNo)
            .ToList();
        return list;
    }

    /// <summary>
    ///     æ ¹æ®å‘货通知单获取对应代发货明细  prc_rf_pda_scan_zout_showbl
    /// </summary>
    /// <returns>发货通知单明细列表</returns>
    public List<ItemDetailModel> GetMesItemFHTZetailByBillNo(
            WarehouseQuery query)
    {
        if (string.IsNullOrEmpty(query.billNo))
            throw new Exception("请选单据号！");

        // æ£€æŸ¥å‘货通知单是否存在且审核
        var mesItem = Db.Queryable<SalesDeliver>()
            .Where(a => a.BillNo == query.billNo && a.FApproverStatus == true)
            .First();

        if (mesItem == null)
            throw new Exception("单据号不存在或未审核！");

        if (mesItem.FinishStatus == true)
            throw new Exception("单据号已完结！");

        // èŽ·å–未完成的发货通知单明细
        var blDetails = Db.Queryable<SalesDeliver, SalesDeliverDetail, SalesOrderDetail,MesItems>((a, b, c, d) =>
                new JoinQueryInfos(JoinType.Left, a.Id == b.Pid,
                JoinType.Left, b.SalesDetailId == c.Id,
                JoinType.Left, c.MaterialId == d.ItemId.ToString()))
            .Where((a, b) => a.BillNo == query.billNo
                             && (b.FMustQty ?? 0) - (b.FRealQty ?? 0) > 0)
            .Select((a, b, c, d) => new ItemDetailModel
            {
                ItemNo = d.ItemNo,
                ItemName = d.ItemName,
                ItemModel = d.ItemModel,
                FQty = b.FMustQty,
                SQty = b.FRealQty,
                FMaterialId = d.ItemId.ToString(),
                Id = b.Id.ToString()

            })
            .ToList();

        return  blDetails;
    }

    /// <summary>
    /// ç”Ÿäº§å·¥å•è¡¥æ–™æ‰«ç 
    ///     æ‰«ææ¡ç   prc_rf_pda_scan_zout_barcode3
    /// </summary>
    /// <param name="query">查询参数</param>
    /// <returns>扫描结果</returns>
    /// <remarks>
    ///     å‚数说明:
    ///     - billNo: å•æ®å·(必填)
    ///     - barcode: æ¡ç (必填)
    ///     - userName: ç”¨æˆ·å
    ///     - blNo: å‘货通知单号(必填)
    /// </remarks>
    public ProductionPickDto XSCKScanBarcode( WarehouseQuery query)
    {
        var _strMsg = "";
        var _intSum = "";
        using (var conn = new SqlConnection(DbHelperSQL.strConn))
        {
            if (query.userName.IsNullOrEmpty()) throw new Exception("用户名不允许为空");
            if (query.daa001.IsNullOrEmpty()) throw new Exception("发货通知单号不允许为空");
            if (query.barcode.IsNullOrEmpty()) throw new Exception("条码不允许为空");

            using (var cmd = new SqlCommand("[prc_pda_XSCK]", conn))
            {
                try
                {
                    conn.Open();
                    cmd.CommandType = CommandType.StoredProcedure;
                    SqlParameter[] parameters =
                    {
                        new("@outMsg", SqlDbType.NVarChar, 300),
                        new("@outSum", SqlDbType.NVarChar, 300),
                        new("@barcode_num", SqlDbType.NVarChar, 300),
                        new("@split_num", SqlDbType.NVarChar, 300),
                        new("@c_User", query.userName),
                        new("@p_biLL_no", query.daa001),
                        new("@p_item_barcode", query.barcode)
                    };
                    parameters[0].Direction = ParameterDirection.Output;
                    parameters[1].Direction = ParameterDirection.Output;
                    parameters[2].Direction = ParameterDirection.Output;
                    parameters[3].Direction = ParameterDirection.Output;
                    foreach (var parameter in parameters)
                        cmd.Parameters.Add(parameter);
                    cmd.ExecuteNonQuery();
                    _strMsg = parameters[0].Value.ToString();
                    _intSum = parameters[1].Value.ToString();

                    var barcodeNum = parameters[2].Value.ToString();
                    var splitNum = parameters[3].Value.ToString();

                    var result = Convert.ToInt32(_intSum);
                    if (result <= 0) throw new Exception(_strMsg);

                    var dto = new ProductionPickDto
                    {
                        daa001 = query.daa001,
                        barcodeNum = barcodeNum,
                        splitNum = splitNum,
                        barcode = query.barcode,
                        strMsg = _strMsg,
                        result = _intSum
                    };

                    return dto;
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }
                finally
                {
                    conn.Close();
                }
            }
        }
    }

    /// <summary>
    ///     ç”Ÿäº§å‘货通知单条码拆分 prc_rf_pda_prnt_zout_barcode2
    /// </summary>
    /// <param name="query">查询参数</param>
    /// <returns>(成功标志, å¾…处理列表)</returns>
    /// <remarks>
    ///     å‰å°éœ€è¦ä¼ å…¥çš„参数:
    ///     - userName: ç”¨æˆ·å(必填)
    ///     - billNo: å·¥å•å·(必填)
    ///     - barcode: ç‰©æ–™æ¡ç (必填)
    ///     - Num: å‘料数量(必填,必须大于0)
    ///     - blNo: å‘货通知单号(必填)
    /// </remarks>
    public (bool success, List<MesItemBlDetail> pendingList) SplitBarcode(
        WarehouseQuery query)
    {
        if (string.IsNullOrEmpty(query.userName))
            throw new Exception("用户名不能为空！");

        if (string.IsNullOrEmpty(query.billNo))
            throw new Exception("请选取单据号！");

        if (string.IsNullOrEmpty(query.barcode))
            throw new Exception("请扫描条码！");

        if ((query.Num ?? 0) <= 0)
            throw new Exception("请输入正确的发料数量！");

        if (string.IsNullOrEmpty(query.blNo))
            throw new Exception("发货通知单号不能为空！");


        // æ£€éªŒæ˜¯å¦é‡å¤æ‰«æ
        var exists = Db.Queryable<MesInvItemOutCDetails>()
            .Where(b => b.ItemBarcode == query.barcode)
            .Any();

        if (exists)
            throw new Exception("此条码已扫描,勿重复扫码！");

        // æŸ¥è¯¢æ¡ç åº“存信息
        var stockBarcode = Db.Queryable<MesInvItemStocks>()
            .Where(t => t.ItemBarcode == query.barcode && t.Quantity > 0)
            .First();

        if (stockBarcode == null)
            throw new Exception($"库存中无此条码,请核对！{query.barcode}");

        var totalQty = stockBarcode.Quantity;
        string newBarcode = null;

        var outNoType = "";
        if (query.Type == "生产补料")
        {
            outNoType = "SCBL(生产补料)";
        }
        else
        {
            outNoType = "SCCL(生产超领)";
        }

        // å¼€å¯äº‹åŠ¡å¤„理
        var success = UseTransaction(db =>
        {
            var executeCommand = 0;

            // æ‹†åˆ†æ¡ç 
            if (totalQty > query.Num)
            {
                var mesItems = db.Queryable<MesItems>()
                    .Where(s => s.Id == stockBarcode.ItemId).First();

                // ç”Ÿæˆæ–°æ¡ç å·
                newBarcode = BillNo.GetBillNo("TM(条码)", mesItems.ItemNo);

                // å†™å…¥æ–°æ¡ç 
                executeCommand += db.Insertable(new MesInvItemBarcodes
                {
                    Guid = Guid.NewGuid(),
                    ItemBarcode = newBarcode,
                    CustNo = stockBarcode.CustomerNo,
                    // ProductCode = stockBarcode.ProductCode, 
                    // ItemBarcode2 = stockBarcode.ItemBarcode2,
                    // ItemCode = stockBarcode.ItemCode,
                    ItemNo = stockBarcode.ItemNo,
                    LotNo = stockBarcode.LotNo,
                    Quantity = query.Num,
                    EpFlag = true,
                    TaskNo = stockBarcode.TaskNo,
                    CreateBy = query.userName,
                    CreateDate = DateTime.Now,
                    LastupdateBy = query.userName,
                    LastupdateDate = DateTime.Now,
                    OldItemBarcode = query.barcode,
                    // Mblnr = stockBarcode.Mblnr,
                    // Zeile = stockBarcode.Zeile,
                    // RohInId = stockBarcode.RohInId,
                    Barcodestatus = false,
                    Oldqty = query.Num as long?,
                    // Unit = stockBarcode.Unit,
                    // WeightUnit = stockBarcode.WeightUnit,
                    Factory = stockBarcode.Factory,
                    Company = stockBarcode.Company,
                    BillNo = stockBarcode.BillNo,
                    BoardStyle = stockBarcode.BoardStyle,
                    // ColorName = stockBarcode.ColorName,
                    WorkNo = stockBarcode.WorkNo,
                    WorkLine = stockBarcode.WorkLine,
                    // MemoBad = stockBarcode.MemoBad,
                    ComeFlg = 5,
                    // Memo = stockBarcode.Memo,
                    SuppId = stockBarcode.SuppId,
                    SuppNo = stockBarcode.SuppNo,
                    InsDate = stockBarcode.IndepDate, // Added InsDate
                    ItemId = stockBarcode.ItemId
                    // ItemUnit = stockBarcode.ItemUnit // Added ItemUnit
                }).IgnoreColumns(true).ExecuteCommand();

                // æ›´æ–°åŽŸæ¡ç æ•°é‡
                executeCommand += db.Updateable<MesInvItemBarcodes>()
                    .SetColumns(it => it.Quantity == it.Quantity - query.Num)
                    .Where(it => it.ItemBarcode == query.barcode)
                    .ExecuteCommand();

                // æ›´æ–°åŽŸæ¡ç æ•°é‡
                executeCommand += db.Updateable<MesInvItemStocks>()
                    .SetColumns(it => it.Quantity == it.Quantity - query.Num)
                    .Where(it => it.ItemBarcode == query.barcode)
                    .ExecuteCommand();

                //// åˆ é™¤åŽŸæ¡ç åº“存记录
                //executeCommand += db.Deleteable<MesInvItemStocks>()
                //    .Where(it => it.ItemBarcode == query.barcode)
                //    .ExecuteCommand();

                // æ’入剩余条码数量的新库存记录
                executeCommand += db.Insertable(new MesInvItemStocks
                {
                    Guid = Guid.NewGuid(),
                    TaskNo = stockBarcode.TaskNo,
                    ItemBarcode = newBarcode,
                    ItemNo = stockBarcode.ItemNo,
                    LotNo = stockBarcode.LotNo,
                    Quantity = query.Num,
                    EpFlag = stockBarcode.EpFlag,
                    CustomerNo = stockBarcode.CustomerNo,
                    ItemWt = stockBarcode.ItemWt,
                    DepotsCode = stockBarcode.DepotsCode,
                    DepotsId = stockBarcode.DepotsId,
                    DepotSectionsCode = stockBarcode.DepotSectionsCode,
                    CheckDate = stockBarcode.CheckDate,
                    ItemType = stockBarcode.ItemType,
                    IndepDate = stockBarcode.IndepDate,
                    Factory = stockBarcode.Factory,
                    Company = stockBarcode.Company,
                    IqcStatus = stockBarcode.IqcStatus,
                    BoardStyle = stockBarcode.BoardStyle,
                    WorkNo = stockBarcode.WorkNo,
                    WorkLine = stockBarcode.WorkLine,
                    SuppNo = stockBarcode.SuppNo,
                    ItemId = stockBarcode.ItemId
                    // UnitId = stockBarcode.ItemUnit
                }).IgnoreColumns(true).ExecuteCommand();

                // å†™å…¥æ–°æ¡ç çš„交易记录
                executeCommand += db.Insertable(new MesInvBusiness2
                {
                    Guid = Guid.NewGuid(),
                    Status = 1,
                    BillTypeId = 200, // p_bill_type_id
                    TransactionCode = "209", // p_transaction_no
                    BusinessType = 0,
                    ItemBarcode = newBarcode,
                    ItemNo = stockBarcode.ItemNo,
                    LotNo = stockBarcode.LotNo,
                    EpFlag = true,
                    Quantity = query.Num,
                    FromInvDepotsCode = null,
                    FromInvDepotSectionsCode = null,
                    ToInvDepotsCode = stockBarcode.DepotsCode,
                    ToInvDepotSectionsCode = stockBarcode.DepotSectionsCode,
                    Description = query.Type + "拆分生成",
                    CreateBy = query.userName,
                    CreateDate = DateTime.Now,
                    LastupdateBy = query.userName,
                    LastupdateDate = DateTime.Now,
                    Factory = stockBarcode.Factory,
                    Company = stockBarcode.Company,
                    TaskNo = stockBarcode.TaskNo,
                    BillNo = stockBarcode.BillNo,
                    WorkNo = stockBarcode.WorkNo,
                    WorkLine = stockBarcode.WorkLine,
                    SuppNo = stockBarcode.SuppNo,
                    SuppId = stockBarcode.SuppId,
                    ItemId = stockBarcode.ItemId
                    // CkDepot = stockBarcode.DepotsId
                }).IgnoreColumns(true).ExecuteCommand();
            }
            else if (totalQty < query.Num)
            {
                throw new Exception("发料数量大于条码数,请核对！");
            }

            //if (string.IsNullOrEmpty(newBarcode)) newBarcode = query.barcode;

            // æ£€æŸ¥å‘货通知单状态
            var mesItemBl = Db.Queryable<MesItemBl>()
                .Where(a => a.BlNo == query.blNo && (a.Bl018 ?? false) == true)
                .First();

            if (mesItemBl == null)
                throw new Exception($"申请单 {query.blNo} å·²æ’¤å›žï¼");

            if (mesItemBl.Bl018 != true)
                throw new Exception($"申请单 {query.blNo} æœªå®¡æ ¸ï¼");

            if (mesItemBl.Bl019 == true)
                throw new Exception($"申请单 {query.blNo} å·²å®Œç»“！");

            // èŽ·å–发货通知单明细并校验
            var blDetail = Db.Queryable<MesItemBlDetail>()
                .Where(b =>
                    b.Mid == mesItemBl.Id && b.Bld012 == stockBarcode.ItemId)
                .First();

            if (blDetail == null)
                throw new Exception($"申请单不存在此物料 {stockBarcode.ItemNo} è¯·ç¡®è®¤ï¼");

            var remainingQty = (blDetail.Bld007 ?? 0) - (blDetail.Bld008 ?? 0);
            if (remainingQty == 0)
                throw new Exception("物料已扫码完成，请核对！");

            if (query.Num > remainingQty)
                throw new Exception(
                    $"拆分数量：{query.Num} å¤§äºŽå¾…发料数量：{remainingQty}，请核对！");

            // æ£€æŸ¥å·¥å•ä¿¡æ¯
            var womdaa = Db.Queryable<Womdaa>()
                .Where(a => a.Daa001 == query.billNo)
                .First();

            if (womdaa == null)
                throw new Exception($"工单 {query.billNo} ä¸å­˜åœ¨ï¼Œè¯·ç¡®è®¤ï¼");

            var womdab = Db.Queryable<Womdab>()
                .Where(b =>
                    b.Dab001 == query.billNo && b.Erpid == blDetail.Bld014)
                .First();

            if (womdab == null)
                throw new Exception($"备料明细不存在此物料 {stockBarcode.ItemNo} è¯·ç¡®è®¤ï¼");

            // æ£€æŸ¥å·²å‘料数量是否超过待发料数量
            var sumQty = db.Queryable<MesInvItemOutCDetails>()
                .Where(it =>
                    it.TaskNo == query.blNo && it.ItemId == stockBarcode.ItemId)
                .Sum(it => it.Quantity);

            //if (sumQty > remainingQty)
            //    throw new Exception(
            //        $"拆分数量：{sumQty} å¤§äºŽå¾…发料数量：{remainingQty}，请核对！");


            var depots = Db.Queryable<MesDepots>()
                .Where(t => t.DepotId == stockBarcode.DepotId)
                .First();

            // èŽ·å–或创建出库单
            var itemOut = db.Queryable<MesInvItemOuts>()
                .Where(a => a.TaskNo == query.blNo
                            && a.DepotId == stockBarcode.DepotId
                            && a.OutDate.Value.Date.ToString("yyyy-MM-dd") ==
                            DateTime.Now.Date.ToString("yyyy-MM-dd")
                            && a.BillTypeId == 200
                            && a.TransactionNo == 209
                            && a.Status == 0)
                .First();

            var outId = new Guid();
            var outNo = "";
            if (itemOut == null)
            {
                // åˆ›å»ºæ–°çš„出库单
                outId = Guid.NewGuid();
                outNo = BillNo.GetBillNo(outNoType);

                // æ’入出库单主表
                executeCommand += db.Insertable(new MesInvItemOuts
                {
                    Guid = outId,
                    ItemOutNo = outNo,
                    TaskNo = query.blNo,
                    CreateBy = query.userName,
                    CreateDate = DateTime.Now,
                    LastupdateBy = query.userName,
                    LastupdateDate = DateTime.Now,
                    BillTypeId = 200,
                    TransactionNo = 209,
                    Remark = mesItemBl.Bl007,
                    DepotCode = depots.DepotCode,
                    OutPart = womdaa.Daa013,
                    FType = 0,
                    Factory = stockBarcode.Factory,
                    Company = stockBarcode.Company,
                    WorkNo = womdaa.Daa021,
                    BoardItem = womdaa.Daa002,
                    PbillNo = womdaa.Daa001,
                    OutDate = DateTime.Now,
                    Status = 0,
                    DepotId = stockBarcode.DepotId,
                    THORGID = stockBarcode.StockOrgId,
                    OutType = query.Type,
                    //BbillNo = query.blNo
                }).IgnoreColumns(true).ExecuteCommand();
            }
            else
            {
                outId = itemOut.Guid;
                outNo = itemOut.ItemOutNo;
            }

            // æ£€æŸ¥æ˜¯å¦å·²å­˜åœ¨å‡ºåº“单明细
            var itemOutItemCount = db.Queryable<MesInvItemOutItems>()
                .Where(it =>
                    it.ItemOutId == outId &&
                    it.ItemId == stockBarcode.ItemId &&
                    it.DepotId == stockBarcode.DepotId.ToString())
                .Count();

            if (itemOutItemCount == 0)
                // æ’入新的出库单明细
                executeCommand += db.Insertable(new MesInvItemOutItems
                {
                    Guid = Guid.NewGuid(),
                    ItemOutId = outId,
                    ItemNo = blDetail.Bld002,
                    Quantity = query.Num,
                    TlQty = query.Num,
                    CreateBy = query.userName,
                    CreateDate = DateTime.Now,
                    LastupdateBy = query.userName,
                    LastupdateDate = DateTime.Now,
                    Factory = stockBarcode.Factory,
                    Company = stockBarcode.Company,
                    DepotCode = depots.DepotCode,
                    TaskNo = query.blNo,
                    WorkNo = womdaa.Daa021,
                    WorkLine = blDetail.Bld013,
                    ErpItemNo = womdab.Dab003,
                    ErpId = womdab.Eid,
                    ErpAutoid = womdab.Erpid,
                    PbillNo = query.billNo,
                    ItemId = blDetail.Bld012,
                    DepotId = stockBarcode.DepotId.ToString(),
                    ItemDabid = womdab.Guid,
                    // Unit = blDetail.Bld009,
                    // DepotId = (int)stockBarcode.DepotsId
                }).IgnoreColumns(true).ExecuteCommand();
            else
                // æ›´æ–°å·²æœ‰å‡ºåº“单明细数量
                executeCommand += db.Updateable<MesInvItemOutItems>()
                    .SetColumns(it => it.TlQty == (it.TlQty ?? 0) + query.Num)
                    .Where(it =>
                    it.ItemOutId == outId &&
                    it.ItemId == stockBarcode.ItemId &&
                    it.DepotId == stockBarcode.DepotId.ToString())
                    .ExecuteCommand();

            // æ’入出库条码明细
            executeCommand += db.Insertable(new MesInvItemOutCDetails
            {
                Guid = Guid.NewGuid(),
                ItemOutId = outId,
                ItemBarcode = newBarcode ?? query.barcode,
                ItemNo = stockBarcode.ItemNo,
                LotNo = stockBarcode.LotNo,
                Quantity = query.Num,
                ForceOutFlag = 0,
                CreateBy = query.userName,
                CreateDate = DateTime.Now,
                LastupdateBy = query.userName,
                LastupdateDate = DateTime.Now,
                DepotCode = depots.DepotCode,
                DepotSectionCode = stockBarcode.DepotSectionsCode,
                Remark = blDetail.Bld010,
                Factory = stockBarcode.Factory,
                Company = stockBarcode.Company,
                TaskNoy = mesItemBl.Bl013,
                BoardStyle = mesItemBl.Bl002,
                TaskNo = query.blNo,
                WorkNo = blDetail.Bld001,
                WorkLine = blDetail.Bld013,
                SuppNo = stockBarcode.SuppNo,
                PbillNo = query.billNo,
                ItemId = blDetail.Bld012,
                Unit = blDetail.Bld009,
                DepotId = (int)stockBarcode.DepotsId,
                Dabid = womdab.Guid,
            }).IgnoreColumns(true).ExecuteCommand();

            // æ’入业务流水
            executeCommand += db.Insertable(new MesInvBusiness2
            {
                Guid = Guid.NewGuid(),
                Status = 1,
                BillTypeId = 200, // p_bill_type_id
                TransactionCode = "209", // p_transaction_no 
                BusinessType = 1,
                ItemBarcode = newBarcode ?? query.barcode,
                ItemNo = stockBarcode.ItemNo,
                LotNo = stockBarcode.LotNo,
                EpFlag = true,
                Quantity = query.Num,
                FromInvDepotsCode = stockBarcode.DepotsCode,
                FromInvDepotSectionsCode = stockBarcode.DepotSectionsCode,
                Description = query.Type,
                CreateBy = query.userName,
                CreateDate = DateTime.Now,
                LastupdateBy = query.userName,
                LastupdateDate = DateTime.Now,
                Factory = stockBarcode.Factory,
                Company = stockBarcode.Company,
                TaskNo = mesItemBl.Bl012,
                BillNo = query.blNo,
                WorkNo = blDetail.Bld001,
                WorkLine = blDetail.Bld013,
                SuppNo = stockBarcode.SuppNo,
                ItemId = stockBarcode.ItemId
                // CkDepot = stockBarcode.DepotsId
            }).IgnoreColumns(true).ExecuteCommand();

            // æ›´æ–°å·¥å•è¡¨æ•°é‡
            executeCommand += db.Updateable<Womdab>()
                .SetColumns(it => new Womdab
                {
                    Dab007 = (it.Dab007 ?? 0) + query.Num, // å·¥å•æ•°é‡
                    Dab020 = (it.Dab020 ?? 0) + query.Num, // å·²å‘料数量
                    Dab021 = (it.Dab021 ?? 0) + query.Num // å·²å‘料数量
                })
                .Where(it => it.Id == womdab.Id && it.Dab003 == womdab.Dab003)
                .ExecuteCommand();

            // æ›´æ–°å‘货通知单明细已补数量
            executeCommand += db.Updateable<MesItemBlDetail>()
                .SetColumns(it => new MesItemBlDetail
                {
                    Bld008 = (it.Bld008 ?? 0) + (int)query.Num
                })
                .Where(it => it.Id == blDetail.Id)
                .ExecuteCommand();

            // èŽ·å–更新后的发货通知单明细数量
            var updatedDetail = db.Queryable<MesItemBlDetail>()
                .Where(it => it.Id == blDetail.Id)
                .Select(it => new { it.Bld007, it.Bld008 })
                .First();

            if ((updatedDetail.Bld007 ?? 0) <= (updatedDetail.Bld008 ?? 0))
                // æ›´æ–°æ˜Žç»†å®ŒæˆçŠ¶æ€
                executeCommand += db.Updateable<MesItemBlDetail>()
                    .SetColumns(it => new MesItemBlDetail { Bld011 = 1 })
                    .Where(it => it.Id == blDetail.Id)
                    .ExecuteCommand();

            // æ£€æŸ¥æ˜¯å¦è¿˜æœ‰æœªå®Œæˆçš„明细

            var unfinishedDetail = db.Queryable<MesItemBlDetail>()
                .Where(it => it.Mid == mesItemBl.Id && (it.Bld011 ?? 0) == 0)
                .First();

            if (unfinishedDetail == null)
                // å¦‚果没有找到未完成明细，则更新发货通知单状态为已完成
                executeCommand += db.Updateable<MesItemBl>()
                    .SetColumns(it => new MesItemBl
                    {
                        Bl019 = true,
                        WcUser = query.userName,
                        WcTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
                    })
                    .Where(it => it.Id == mesItemBl.Id)
                    .ExecuteCommand();

            if (executeCommand <= 1) throw new Exception("更新失败");

            return executeCommand;
        }) > 0;

        // èŽ·å–最终的待发料明细列表
        var pendingList = Db.Queryable<MesItemBl, MesItemBlDetail>((a, b) =>
                new JoinQueryInfos(JoinType.Left, a.Id == b.Mid))
            .Where((a, b) => a.BlNo == query.blNo
                             && (b.Bld007 ?? 0) - (b.Bld008 ?? 0) > 0)
            .Select((a, b) => new MesItemBlDetail
            {
                Bld012 = b.Bld012,
                Bld002 = b.Bld002,
                Bld003 = b.Bld003,
                Bld004 = b.Bld004,
                Bld007 = b.Bld007,
                Bld008 = b.Bld008
            })
            .ToList();

        return (success, pendingList);
    }

    #endregion

    #region ç”Ÿäº§è¶…领

    public List<string> GetSccList(WarehouseQuery query)
    {
        var list = Db.Queryable<MesItemBl>()
            .Where(s => (s.Bl018 ?? false) == true
                        && (s.Bl019 ?? false) == false
                        && s.Bl008 == query.Type)
            .Select(s => s.BlNo)
            .ToList();
        return list;
    }

    /// <summary>
    ///     èŽ·å–生产超领单明细
    /// </summary>
    /// <param name="query">查询参数</param>
    /// <returns>生产超领单明细列表</returns>
    public (string bl001, List<MesItemBlDetail> item)
        GetMesItemBlDetailBySccBillNo(
            WarehouseQuery query)
    {
        if (string.IsNullOrEmpty(query.billNo))
            throw new Exception("请选单据号！");

        // æ£€æŸ¥è¶…领单是否存在且为生产超领/委外超领类型
        var mesItemBl = Db.Queryable<MesItemBl>()
            .Where(a => a.BlNo == query.billNo && a.Bl008 == query.Type)
            .First();

        if (mesItemBl == null)
            throw new Exception("单据号不正确！");

        // æ£€æŸ¥å·¥å•æ˜Žç»†çŠ¶æ€
        var blDetails = Db.Queryable<MesItemBlDetail>()
            .Where(it => it.Mid == mesItemBl.Id)
            .ToList();

        foreach (var womdab in blDetails.Select(detail => Db.Queryable<Womdab>()
                     .Where(it => it.Erpid == detail.Bld014)
                     .First()))
        {
            if (womdab == null)
                throw new Exception("未找到工单明细！");

            if ((womdab.Dab006 ?? 0) != (womdab.Dab007 ?? 0) ||
                (womdab.Dab021 ?? 0) != (womdab.Dab022 ?? 0))
                throw new Exception("物料未领完料或存在待补物料！");
        }

        // èŽ·å–未完成的超领单明细
        var pendingDetails = Db.Queryable<MesItemBl, MesItemBlDetail>((a, b) =>
                new JoinQueryInfos(JoinType.Left, a.Id == b.Mid))
            .Where((a, b) => a.BlNo == query.billNo
                             && (b.Bld007 ?? 0) - (b.Bld008 ?? 0) > 0)
            .OrderBy((a, b) => b.Bld002)
            .Select((a, b) => new MesItemBlDetail
            {
                Bld012 = b.Bld012,
                Bld002 = b.Bld002,
                Bld003 = b.Bld003,
                Bld004 = b.Bld004,
                Bld007 = b.Bld007,
                Bld008 = b.Bld008
            })
            .ToList();

        return (mesItemBl.Bl001, pendingDetails);
    }

    /// <summary>
    ///     ç”Ÿäº§è¶…领扫描条码 prc_rf_pda_scan_zout_barcodeCL
    /// </summary>
    /// <param name="query">查询参数</param>
    /// <returns>扫描结果</returns>
    /// <remarks>
    ///     å‚数说明:
    ///     - billNo: å·¥å•å·(必填)
    ///     - barcode: æ¡ç (必填)
    ///     - userName: ç”¨æˆ·å(必填)
    ///     - blNo: è¶…领单号(必填)
    /// </remarks>
    public (WarehouseQuery item, List<MesItemBlDetail> pendingList)
        ScanBarcodeForOverPicking(
            WarehouseQuery query)
    {
        #region å‚数校验

        if (string.IsNullOrEmpty(query.billNo))
            throw new Exception("请选取单据号！");

        if (string.IsNullOrEmpty(query.barcode))
            throw new Exception("请扫描条码！");

        if (string.IsNullOrEmpty(query.userName))
            throw new Exception("用户名不能为空！");

        if (string.IsNullOrEmpty(query.blNo))
            throw new Exception("超领单号不能为空！");

        #endregion

        // æ£€éªŒæ˜¯å¦é‡å¤æ‰«æ
        var exists = Db.Queryable<MesInvItemOutCDetails>()
            .Where(b => b.ItemBarcode == query.barcode)
            .Any();

        if (exists)
            throw new Exception("此条码已扫描,勿重复扫码！");

        // æŸ¥è¯¢æ¡ç åº“存信息
        var stockBarcode = Db.Queryable<MesInvItemStocks>()
            .Where(t => t.ItemBarcode == query.barcode && t.Quantity > 0)
            .First();

        if (stockBarcode == null)
            throw new Exception($"库存中无此条码,请核对！{query.barcode}");

        // æ£€æŸ¥è¶…领单状态
        var mesItemBl = Db.Queryable<MesItemBl>()
            .Where(a => a.BlNo == query.blNo && (a.Bl018 ?? false) == false)
            .First();

        if (mesItemBl == null)
            throw new Exception($"申请单 {query.blNo} å·²æ’¤å›žï¼");

        if (mesItemBl.Bl018 != true)
            throw new Exception($"申请单 {query.blNo} æœªå®¡æ ¸ï¼");

        if (mesItemBl.Bl019 == true)
            throw new Exception($"申请单 {query.blNo} å·²å®Œç»“！");

        // æ£€æŸ¥å·¥å•æ˜Žç»†çŠ¶æ€
        var blDetails = Db.Queryable<MesItemBlDetail>()
            .Where(it => it.Mid == mesItemBl.Id)
            .ToList();

        foreach (var womdab1 in blDetails.Select(detail => Db
                     .Queryable<Womdab>()
                     .Where(it => it.Erpid == detail.Bld014)
                     .First()))
        {
            if (womdab1 == null)
                throw new Exception("未找到工单明细！");

            if ((womdab1.Dab006 ?? 0) != (womdab1.Dab007 ?? 0) ||
                (womdab1.Dab021 ?? 0) != (womdab1.Dab022 ?? 0))
                throw new Exception("物料未领完料或存在待补物料！");
        }

        // èŽ·å–超领单明细并校验
        var blDetail = Db.Queryable<MesItemBlDetail>()
            .Where(b =>
                b.Mid == mesItemBl.Id && b.Bld012 == stockBarcode.ItemId)
            .First();

        if (blDetail == null)
            throw new Exception($"申请单不存在此物料 {stockBarcode.ItemNo} è¯·ç¡®è®¤ï¼");

        // æ£€æŸ¥å¾…超领数量
        var quantity = (blDetail.Bld007 ?? 0) - (blDetail.Bld008 ?? 0);
        if (quantity == 0)
            throw new Exception("物料已扫码完成，请核对！");

        // æ£€æŸ¥å·¥å•ä¿¡æ¯
        var womdaa = Db.Queryable<Womdaa>()
            .Where(a => a.Daa001 == query.billNo)
            .First();

        if (womdaa == null)
            throw new Exception($"工单 {query.billNo} ä¸å­˜åœ¨ï¼Œè¯·ç¡®è®¤ï¼");

        var womdab = Db.Queryable<Womdab>()
            .Where(b => b.Dab001 == query.billNo && b.Erpid == blDetail.Bld014)
            .First();

        if (womdab == null)
            throw new Exception($"备料明细不存在此物料 {stockBarcode.ItemNo} è¯·ç¡®è®¤ï¼");

        // å¦‚果条码数量大于待超领数量,返回待处理列表供确认
        if (stockBarcode.Quantity > quantity)
        {
            var pendingList = Db.Queryable<MesItemBl, MesItemBlDetail>((a, b) =>
                    new JoinQueryInfos(JoinType.Left, a.Id == b.Mid))
                .Where((a, b) => a.BlNo == query.blNo
                                 && (b.Bld007 ?? 0) - (b.Bld008 ?? 0) > 0)
                .Select((a, b) => new MesItemBlDetail
                {
                    Bld012 = b.Bld012,
                    Bld002 = b.Bld002,
                    Bld003 = b.Bld003,
                    Bld004 = b.Bld004,
                    Bld007 = b.Bld007,
                    Bld008 = b.Bld008
                })
                .ToList();

            query.Num = stockBarcode.Quantity;
            query.Fum = quantity;

            return (query, pendingList);
        }

        // æ‰§è¡Œæ•°æ®åº“事务
        UseTransaction(db =>
        {
            // ç”Ÿæˆæˆ–获取出库单
            var outId = Guid.Empty;
            var outNo = "";
            var outRecord = db.Queryable<MesInvItemOuts>()
                .Where(a => a.TaskNo == query.blNo
                            && a.DepotId == stockBarcode.DepotId
                            && a.OutDate.Value.Date == DateTime.Now.Date
                            && a.BillTypeId == 200
                            && a.TransactionNo == 210
                            && a.Status == 0)
                .First();

            if (outRecord == null)
            {
                outId = Guid.NewGuid();
                outNo = BillNo.GetBillNo("BL(工单补料)"); // éœ€è¦å®žçŽ°ç”Ÿæˆå•å·çš„方法

                // æ’入出库单主表
                db.Insertable(new MesInvItemOuts
                {
                    Guid = outId,
                    ItemOutNo = outNo,
                    TaskNo = query.blNo,
                    CreateBy = query.userName,
                    CreateDate = DateTime.Now,
                    LastupdateBy = query.userName,
                    LastupdateDate = DateTime.Now,
                    BillTypeId = 200,
                    TransactionNo = 210,
                    Remark = mesItemBl.Bl007,
                    DepotCode = womdab.Dab017,
                    OutPart = womdaa.Daa013,
                    FType = 0,
                    WorkNo = womdaa.Daa021,
                    OutType = query.Type,
                    BoardItem = womdaa.Daa002,
                    PbillNo = womdaa.Daa001,
                    OutDate = DateTime.Now,
                    Status = 0,
                    BbillNo = query.blNo
                }).IgnoreColumns(true).ExecuteCommand();
            }
            else
            {
                outId = outRecord.Guid;
                outNo = outRecord.ItemOutNo;
            }

            // æ›´æ–°æˆ–插入出库单明细
            var outItem = db.Queryable<MesInvItemOutItems>()
                .Where(it =>
                    it.ItemOutId == outId && it.ItemId == stockBarcode.ItemId)
                .First();

            if (outItem == null)
                // æ’入出库单明细
                db.Insertable(new MesInvItemOutItems
                {
                    Guid = Guid.NewGuid(),
                    ItemOutId = outId,
                    ItemNo = blDetail.Bld002,
                    Quantity = stockBarcode.Quantity,
                    CreateBy = query.userName,
                    CreateDate = DateTime.Now,
                    LastupdateBy = query.userName,
                    LastupdateDate = DateTime.Now,
                    DepotCode = womdab.Dab017,
                    TaskNo = query.blNo,
                    WorkNo = womdaa.Daa021,
                    WorkLine = blDetail.Bld013,
                    ErpItemNo = womdab.Dab003,
                    ErpId = womdab.Eid,
                    ErpAutoid = womdab.Erpid,
                    PbillNo = query.billNo,
                    ItemId = blDetail.Bld012,
                    DepotId = stockBarcode.DepotId.ToString(),
                    // Unit = blDetail.Bld009,
                    // DepotId = stockBarcode.DepotsId
                }).IgnoreColumns(true).ExecuteCommand();
            else
                // æ›´æ–°å‡ºåº“单明细数量
                db.Updateable<MesInvItemOutItems>()
                    .SetColumns(it => new MesInvItemOutItems
                    {
                        Quantity = it.Quantity + stockBarcode.Quantity
                    })
                    .Where(it =>
                        it.ItemOutId == outId &&
                        it.ItemId == stockBarcode.ItemId)
                    .ExecuteCommand();

            // æ’入出库条码明细
            db.Insertable(new MesInvItemOutCDetails
            {
                Guid = Guid.NewGuid(),
                ItemOutId = outId,
                ItemBarcode = stockBarcode.ItemBarcode,
                ItemNo = stockBarcode.ItemNo,
                LotNo = stockBarcode.LotNo,
                Quantity = stockBarcode.Quantity,
                CreateBy = query.userName,
                CreateDate = DateTime.Now,
                LastupdateBy = query.userName,
                LastupdateDate = DateTime.Now,
                DepotCode = stockBarcode.DepotsCode,
                DepotSectionCode = stockBarcode.DepotSectionsCode,
                Remark = blDetail.Bld010,
                TaskNo = query.blNo,
                WorkNo = blDetail.Bld001,
                WorkLine = blDetail.Bld013,
                SuppNo = stockBarcode.SuppNo,
                PbillNo = query.billNo,
                ItemId = blDetail.Bld012,
                Unit = blDetail.Bld009,
                DepotId = (int)stockBarcode.DepotsId,
                Dabid = womdab.Guid,
            }).IgnoreColumns(true).ExecuteCommand();

            // æ’入业务流水
            db.Insertable(new MesInvBusiness2
            {
                Guid = Guid.NewGuid(),
                Status = 1,
                BillTypeId = 200,
                TransactionCode = "210",
                BusinessType = -1,
                ItemBarcode = query.barcode,
                ItemNo = stockBarcode.ItemNo,
                LotNo = stockBarcode.LotNo,
                EpFlag = true,
                Quantity = stockBarcode.Quantity,
                FromInvDepotsCode = stockBarcode.DepotsCode,
                FromInvDepotSectionsCode = stockBarcode.DepotSectionsCode,
                CreateBy = query.userName,
                CreateDate = DateTime.Now,
                LastupdateBy = query.userName,
                LastupdateDate = DateTime.Now,
                TaskNo = mesItemBl.Bl012,
                BillNo = query.blNo,
                WorkNo = blDetail.Bld001,
                WorkLine = blDetail.Bld013,
                SuppNo = stockBarcode.SuppNo,
                SuppId = stockBarcode.SuppId,
                ItemId = stockBarcode.ItemId
                // CkDepot = stockBarcode.DepotsId
            }).IgnoreColumns(true).ExecuteCommand();

            // æ›´æ–°å·¥å•å¤‡æ–™æ˜Žç»†
            db.Updateable<Womdab>()
                .SetColumns(it => new Womdab
                {
                    Dab020 = (it.Dab020 ?? 0) + stockBarcode.Quantity,
                    Dab023 = (it.Dab023 ?? 0) + stockBarcode.Quantity
                })
                .Where(it => it.Id == womdab.Id)
                .ExecuteCommand();

            // æ›´æ–°è¶…领单明细
            db.Updateable<MesItemBlDetail>()
                .SetColumns(it => new MesItemBlDetail
                {
                    Bld008 = (it.Bld008 ?? 0) + (int)stockBarcode.Quantity,
                    Bld011 = (it.Bld007 ?? 0) <=
                             (it.Bld008 ?? 0) + stockBarcode.Quantity
                        ? 1
                        : 0
                })
                .Where(it => it.Id == blDetail.Id)
                .ExecuteCommand();

            // æ›´æ–°åº“存数量为0
            db.Updateable<MesInvItemStocks>()
                .SetColumns(it => it.Quantity == 0)
                .Where(it => it.Guid == stockBarcode.Guid)
                .ExecuteCommand();

            // æ£€æŸ¥æ˜¯å¦æ‰€æœ‰æ˜Žç»†éƒ½å·²å®Œæˆ
            var hasUnfinished = db.Queryable<MesItemBlDetail>()
                .Where(it => it.Mid == mesItemBl.Id && (it.Bld011 ?? 0) == 0)
                .Any();

            // å¦‚果所有明细完成,更新超领单状态为已完成
            if (!hasUnfinished)
                db.Updateable<MesItemBl>()
                    .SetColumns(it => it.Bl019 == true)
                    .Where(it => it.Id == mesItemBl.Id)
                    .ExecuteCommand();

            return 1;
        });

        // èŽ·å–最终的待处理列表
        var finalPendingList = Db.Queryable<MesItemBl, MesItemBlDetail>(
                (a, b) =>
                    new JoinQueryInfos(JoinType.Left, a.Id == b.Mid))
            .Where((a, b) => a.BlNo == query.blNo
                             && (b.Bld007 ?? 0) - (b.Bld008 ?? 0) > 0)
            .Select((a, b) => new MesItemBlDetail
            {
                Bld012 = b.Bld012,
                Bld002 = b.Bld002,
                Bld003 = b.Bld003,
                Bld004 = b.Bld004,
                Bld007 = b.Bld007,
                Bld008 = b.Bld008
            })
            .ToList();

        return (query, finalPendingList);
    }

    /// <summary>
    ///     ç”Ÿäº§è¶…领打印条码
    /// </summary>
    /// <param name="query">查询参数</param>
    /// <returns>处理结果</returns>
    public (bool success, List<MesItemBlDetail> pendingList)
        PrintBarcodeForOverPicking(WarehouseQuery query)
    {
        UseTransaction(db =>
        {
            #region å‚数校验

            if (string.IsNullOrEmpty(query.billNo))
                throw new Exception("请选取单据号！");

            if (string.IsNullOrEmpty(query.barcode))
                throw new Exception("请扫描条码！");

            if (string.IsNullOrEmpty(query.userName))
                throw new Exception("用户名不能为空！");

            if (string.IsNullOrEmpty(query.blNo))
                throw new Exception("超领单号不能为空！");

            if (query.Num <= 0)
                throw new Exception("请输入正确的发料数量！");

            #endregion

            // æŸ¥è¯¢åº“存条码信息
            var stockBarcode = db.Queryable<MesInvItemStocks>()
                .Where(t => t.ItemBarcode == query.barcode && t.Quantity > 0)
                .First();

            if (stockBarcode == null)
                throw new Exception($"库存中无此条码，请核对！{query.barcode}");

            var totalQty = stockBarcode.Quantity;
            string newBarcode = null;

            // æ‹†åˆ†æ¡ç 
            if (totalQty > query.Num)
            {
                var mesItems = db.Queryable<MesItems>()
                    .Where(s => s.Id == stockBarcode.ItemId).First();
                // ç”Ÿæˆæ–°æ¡ç å·
                newBarcode = BillNo.GetBillNo("TMBH(条码编号)", mesItems.ItemNo);

                // å†™å…¥æ–°æ¡ç è®°å½•
                db.Insertable(new MesInvItemBarcodes
                {
                    Guid = Guid.NewGuid(),
                    ItemBarcode = newBarcode,
                    ItemNo = stockBarcode.ItemNo,
                    LotNo = stockBarcode.LotNo,
                    Quantity = query.Num,
                    EpFlag = true,
                    CreateBy = query.userName,
                    CreateDate = DateTime.Now,
                    LastupdateBy = query.userName,
                    LastupdateDate = DateTime.Now,
                    OldItemBarcode = query.barcode,
                    Factory = stockBarcode.Factory,
                    Company = stockBarcode.Company,
                    WorkNo = stockBarcode.WorkNo,
                    WorkLine = stockBarcode.WorkLine,
                    SuppId = stockBarcode.SuppId,
                    SuppNo = stockBarcode.SuppNo,
                    ItemId = stockBarcode.ItemId
                }).IgnoreColumns(true).ExecuteCommand();

                // æ›´æ–°åŽŸæ¡ç æ•°é‡
                db.Updateable<MesInvItemBarcodes>()
                    .SetColumns(it => new MesInvItemBarcodes
                    { Quantity = totalQty - query.Num })
                    .Where(it => it.ItemBarcode == query.barcode)
                    .ExecuteCommand();

                // åˆ é™¤åŽŸæ¡ç åº“存记录
                db.Deleteable<MesInvItemStocks>()
                    .Where(it => it.ItemBarcode == query.barcode)
                    .ExecuteCommand();

                // æ’入剩余条码数量的新库存记录
                db.Insertable(new MesInvItemStocks
                {
                    Guid = Guid.NewGuid(),
                    ItemBarcode = stockBarcode.ItemBarcode,
                    ItemNo = stockBarcode.ItemNo,
                    LotNo = stockBarcode.LotNo,
                    Quantity = totalQty - query.Num,
                    EpFlag = stockBarcode.EpFlag,
                    CustomerNo = stockBarcode.CustomerNo,
                    DepotsCode = stockBarcode.DepotsCode,
                    DepotsId = stockBarcode.DepotsId,
                    DepotSectionsCode = stockBarcode.DepotSectionsCode,
                    CheckDate = stockBarcode.CheckDate,
                    ItemType = stockBarcode.ItemType,
                    IndepDate = stockBarcode.IndepDate,
                    Factory = stockBarcode.Factory,
                    Company = stockBarcode.Company,
                    IqcStatus = stockBarcode.IqcStatus,
                    BoardStyle = stockBarcode.BoardStyle,
                    WorkNo = stockBarcode.WorkNo,
                    WorkLine = stockBarcode.WorkLine,
                    SuppNo = stockBarcode.SuppNo,
                    SuppId = stockBarcode.SuppId,
                    ItemId = stockBarcode.ItemId
                }).IgnoreColumns(true).ExecuteCommand();

                // å†™æ–°æ¡ç çš„交易表，新条码不入库直接出
                db.Insertable(new MesInvBusiness2
                {
                    Guid = Guid.NewGuid(),
                    Status = 1,
                    BillTypeId = 200,
                    TransactionCode = "210",
                    BusinessType = -1,
                    ItemBarcode = newBarcode,
                    ItemNo = stockBarcode.ItemNo,
                    LotNo = stockBarcode.LotNo,
                    EpFlag = true,
                    Quantity = query.Num,
                    ToInvDepotsCode = stockBarcode.DepotsCode,
                    ToInvDepotSectionsCode = stockBarcode.DepotSectionsCode,
                    Description = "生产超领",
                    CreateBy = query.userName,
                    CreateDate = DateTime.Now,
                    LastupdateBy = query.userName,
                    LastupdateDate = DateTime.Now,
                    TaskNo = stockBarcode.TaskNo,
                    WorkNo = stockBarcode.WorkNo,
                    WorkLine = stockBarcode.WorkLine,
                    SuppNo = stockBarcode.SuppNo,
                    SuppId = stockBarcode.SuppId,
                    ItemId = stockBarcode.ItemId
                }).IgnoreColumns(true).ExecuteCommand();
            }
            else if (totalQty < query.Num)
            {
                throw new Exception("发料数量大于条码数,请核对！");
            }

            if (string.IsNullOrEmpty(newBarcode))
                newBarcode = query.barcode;

            // æ£€æŸ¥è¶…领单状态
            var mesItemBl = db.Queryable<MesItemBl>()
                .Where(a => a.BlNo == query.blNo && a.Bl008 == "生产超领")
                .First();

            if (mesItemBl == null)
                throw new Exception("申请单不存在！");

            if (!(mesItemBl.Bl018 ?? false))
                throw new Exception($"申请单 {query.blNo} æœªå®¡æ ¸ï¼");

            if (mesItemBl.Bl019 ?? false)
                throw new Exception($"申请单 {query.blNo} å·²å®Œç»“！");

            // æ£€æŸ¥è¶…领单明细
            var blDetail = db.Queryable<MesItemBlDetail>()
                .Where(b =>
                    b.Mid == mesItemBl.Id && b.Bld012 == stockBarcode.ItemId)
                .First();

            if (blDetail == null)
                throw new Exception($"申请单不存在此物料 {stockBarcode.ItemNo} è¯·ç¡®è®¤ï¼");

            var pendingQty = (blDetail.Bld007 ?? 0) - (blDetail.Bld008 ?? 0);
            if (pendingQty == 0)
                throw new Exception("物料已扫码完成，请核对！");

            // æ£€æŸ¥å·¥å•
            var workOrder = db.Queryable<Womdaa>()
                .Where(a => a.Daa001 == query.billNo)
                .First();

            if (workOrder == null)
                throw new Exception($"工单 {query.billNo} ä¸å­˜åœ¨ï¼Œè¯·ç¡®è®¤ï¼");

            var workOrderDetail = db.Queryable<Womdab>()
                .Where(b =>
                    b.Dab001 == query.billNo && b.Erpid == blDetail.Bld014)
                .First();

            if (workOrderDetail == null)
                throw new Exception($"备料明细不存在此物料 {stockBarcode.ItemNo} è¯·ç¡®è®¤ï¼");

            if (query.Num > pendingQty)
                throw new Exception(
                    $"拆分数量：{query.Num} å¤§äºŽå¾…发料数量：{pendingQty}，请核对！");

            // èŽ·å–或创建出库单
            var itemOut = db.Queryable<MesInvItemOuts>()
                .Where(a => a.BbillNo == query.blNo
                            && a.DepotCode == workOrderDetail.Dab017
                            && a.OutDate.Value.Date.ToString("yyyy-MM-dd") ==
                            DateTime.Now.Date.ToString("yyyy-MM-dd")
                            && a.BillTypeId == 200
                            && a.TransactionNo == 210
                            && a.Status == 0)
                .First();

            if (itemOut == null)
            {
                // åˆ›å»ºæ–°çš„出库单
                itemOut = new MesInvItemOuts
                {
                    Guid = Guid.NewGuid(),
                    ItemOutNo = BillNo.GetBillNo("BL(工单补料)"), // éœ€è¦å®žçŽ°ç”Ÿæˆå•å·çš„方法
                    TaskNo = query.blNo,
                    CreateBy = query.userName,
                    CreateDate = DateTime.Now,
                    LastupdateBy = query.userName,
                    LastupdateDate = DateTime.Now,
                    BillTypeId = 200,
                    TransactionNo = 210,
                    Remark = mesItemBl.Bl007,
                    DepotCode = workOrderDetail.Dab017,
                    OutPart = workOrder.Daa013,
                    FType = 0,
                    Factory = stockBarcode.Factory,
                    Company = stockBarcode.Company,
                    WorkNo = workOrder.Daa021,
                    OutType = "生产超领单",
                    BoardItem = workOrder.Daa002,
                    PbillNo = workOrder.Daa001,
                    OutDate = DateTime.Now,
                    Status = 0,
                    BbillNo = query.blNo
                };

                db.Insertable(itemOut).IgnoreColumns(true).ExecuteCommand();
            }

            // æ£€æŸ¥æ˜¯å¦å·²å­˜åœ¨å‡ºåº“单明细
            var itemOutItemCount = db.Queryable<MesInvItemOutItems>()
                .Where(it =>
                    it.ItemOutId == itemOut.Guid &&
                    it.ItemId == stockBarcode.ItemId)
                .Count();

            if (itemOutItemCount == 0)
                // æ’入新的出库单明细
                db.Insertable(new MesInvItemOutItems
                {
                    Guid = Guid.NewGuid(),
                    ItemOutId = itemOut.Guid,
                    ItemNo = blDetail.Bld002,
                    Quantity = query.Num,
                    CreateBy = query.userName,
                    CreateDate = DateTime.Now,
                    LastupdateBy = query.userName,
                    LastupdateDate = DateTime.Now,
                    Factory = stockBarcode.Factory,
                    Company = stockBarcode.Company,
                    DepotCode = workOrderDetail.Dab017,
                    TaskNo = query.blNo,
                    WorkNo = workOrder.Daa021,
                    WorkLine = blDetail.Bld013,
                    ErpItemNo = workOrderDetail.Dab003,
                    ErpId = workOrderDetail.Eid,
                    ErpAutoid = workOrderDetail.Erpid,
                    PbillNo = query.billNo,
                    ItemId = blDetail.Bld012
                    // Unit = blDetail.Bld009,
                    // DepotId = stockBarcode.DepotsId
                }).IgnoreColumns(true).ExecuteCommand();
            else
                // æ›´æ–°å·²æœ‰å‡ºåº“单明细数量
                db.Updateable<MesInvItemOutItems>()
                    .SetColumns(it => it.Quantity == it.Quantity + query.Num)
                    .Where(it =>
                        it.ItemOutId == itemOut.Guid &&
                        it.ItemId == stockBarcode.ItemId)
                    .ExecuteCommand();

            // æ’入出库明细记录
            db.Insertable(new MesInvItemOutCDetails
            {
                Guid = Guid.NewGuid(),
                ItemOutId = itemOut.Guid,
                ItemBarcode = newBarcode,
                ItemNo = stockBarcode.ItemNo,
                LotNo = stockBarcode.LotNo,
                Quantity = query.Num,
                ForceOutFlag = 0,
                CreateBy = query.userName,
                CreateDate = DateTime.Now,
                LastupdateBy = query.userName,
                LastupdateDate = DateTime.Now,
                DepotCode = stockBarcode.DepotsCode,
                DepotSectionCode = stockBarcode.DepotSectionsCode,
                Remark = blDetail.Bld010,
                Factory = stockBarcode.Factory,
                Company = stockBarcode.Company,
                TaskNoy = mesItemBl.Bl013,
                BoardStyle = mesItemBl.Bl002,
                TaskNo = query.blNo,
                WorkNo = blDetail.Bld001,
                WorkLine = blDetail.Bld013,
                SuppNo = stockBarcode.SuppNo,
                PbillNo = query.billNo,
                ItemId = blDetail.Bld012,
                Unit = blDetail.Bld009,
                DepotId = (int)stockBarcode.DepotsId,
                LineK3id = workOrderDetail.Erpid,
                EbelnK3id = workOrderDetail.Eid
            }).IgnoreColumns(true).ExecuteCommand();

            // æ’入业务交易记录
            db.Insertable(new MesInvBusiness2
            {
                Guid = Guid.NewGuid(),
                Status = 1,
                BillTypeId = 200, // p_bill_type_id
                TransactionCode = "210", // p_transaction_no 
                BusinessType = 1,
                ItemBarcode = newBarcode,
                ItemNo = stockBarcode.ItemNo,
                LotNo = stockBarcode.LotNo,
                EpFlag = true,
                Quantity = query.Num,
                FromInvDepotsCode = stockBarcode.DepotsCode,
                FromInvDepotSectionsCode = stockBarcode.DepotSectionsCode,
                CreateBy = query.userName,
                CreateDate = DateTime.Now,
                LastupdateBy = query.userName,
                LastupdateDate = DateTime.Now,
                Factory = stockBarcode.Factory,
                Company = stockBarcode.Company,
                TaskNo = mesItemBl.Bl012, // Matches C_QTCK.Bl012
                BillNo = query.blNo,
                WorkNo = blDetail.Bld001, // Matches C_QTCK_D.Bld001
                WorkLine = blDetail.Bld013, // Matches C_QTCK_D.Bld013
                SuppNo = stockBarcode.SuppNo,
                ItemId = stockBarcode.ItemId
            }).IgnoreColumns(true).ExecuteCommand();

            // æ›´æ–°å·¥å•è¡¨æ•°é‡
            db.Updateable<Womdab>()
                .SetColumns(it => new Womdab
                {
                    Dab020 = (it.Dab020 ?? 0) + stockBarcode.Quantity,
                    Dab023 = (it.Dab023 ?? 0) + stockBarcode.Quantity
                })
                .Where(it => it.Id == workOrderDetail.Id)
                .ExecuteCommand();

            // æ›´æ–°å‘货通知单明细已补数量
            db.Updateable<MesItemBlDetail>()
                .SetColumns(it => new MesItemBlDetail
                {
                    Bld008 = (it.Bld008 ?? 0) + (int)stockBarcode.Quantity
                })
                .Where(it => it.Id == blDetail.Id)
                .ExecuteCommand();

            // æ£€æŸ¥å‘货通知单明细是否完成
            var blDetail1 = db.Queryable<MesItemBlDetail>()
                .Where(it => it.Id == blDetail.Id)
                .First();

            if ((blDetail1.Bld007 ?? 0) <= (blDetail1.Bld008 ?? 0))
                // æ›´æ–°æ˜Žç»†å®ŒæˆçŠ¶æ€
                db.Updateable<MesItemBlDetail>()
                    .SetColumns(it => it.Bld011 == 1)
                    .Where(it => it.Id == blDetail1.Id)
                    .ExecuteCommand();

            // æ£€æŸ¥æ˜¯å¦æ‰€æœ‰æ˜Žç»†éƒ½å·²å®Œæˆ
            var hasUnfinished = db.Queryable<MesItemBlDetail>()
                .Where(it => it.Mid == mesItemBl.Id && (it.Bld011 ?? 0) == 0)
                .Any();

            // å¦‚果所有明细完成,更新发货通知单状态为已完成
            if (!hasUnfinished)
                db.Updateable<MesItemBl>()
                    .SetColumns(it => it.Bl019 == true)
                    .Where(it => it.Id == mesItemBl.Id)
                    .ExecuteCommand();

            return 1;
        });


        // èŽ·å–最终的待处理列表
        // èŽ·å–发货通知单明细中未完成的记录
        // é€šè¿‡å·¦è¿žæŽ¥æŸ¥è¯¢å‘货通知单(MesItemBl)和发货通知单明细(MesItemBlDetail)表
        // æ¡ä»¶: 1.发货通知单号匹配 2.计划数量(Bld007)减去已补数量(Bld008)大于0(即未完成的)
        var pendingList = Db.Queryable<MesItemBl, MesItemBlDetail>((a, b) =>
                new JoinQueryInfos(JoinType.Left, a.Id == b.Mid))
            .Where((a, b) => a.BlNo == query.blNo
                             && (b.Bld007 ?? 0) - (b.Bld008 ?? 0) > 0)
            .Select((a, b) => new MesItemBlDetail
            {
                Bld012 = b.Bld012, // ç‰©æ–™ID
                Bld002 = b.Bld002, // ç‰©æ–™ç¼–号
                Bld003 = b.Bld003, // ç‰©æ–™åç§°
                Bld004 = b.Bld004, // ç‰©æ–™è§„æ ¼
                Bld007 = b.Bld007, // è®¡åˆ’数量
                Bld008 = b.Bld008 // å·²è¡¥æ•°é‡
            })
            .ToList();

        return (true, pendingList);
    }

    #endregion
}

 service/Warehouse/TransferOutManager.cs

@@ -52,7 +52,7 @@
    /// </summary>
    /// <param name="query">查询参数,包含单据号</param>
    /// <returns>待处理的调拨出库明细列表</returns>
    public List<TransferOutDetailModel> GetTransferOutDetailListByBillNo(
    public List<ItemDetailModel> GetTransferOutDetailListByBillNo(
        WarehouseQuery query)
    {
        var p_bill_no = query.billNo;
@@ -69,7 +69,7 @@
                && a.FBillNo == p_bill_no // åŒ¹é…å•æ®å·
                && a.FApproveStatus == 1) // å•æ®å·²å®¡æ ¸
            .OrderBy((b, a, s) => s.ItemNo)
            .Select((b, a, s) => new TransferOutDetailModel
            .Select((b, a, s) => new ItemDetailModel
            {
                ItemNo = s.ItemNo,
                ItemName = s.ItemName,
@@ -89,7 +89,7 @@
        return result;
    }

    public List<TransferOutDetailModel> GetDBCKDetal(
    public List<ItemDetailModel> GetDBCKDetal(
        WarehouseQuery query)
    {
        var p_bill_no = query.billNo;
@@ -106,7 +106,7 @@
                && a.FBillNo == p_bill_no // åŒ¹é…å•æ®å·
                && a.FApproveStatus == 1) // å•æ®å·²å®¡æ ¸
            .OrderBy((b, a, s) => s.ItemNo)
            .Select((b, a, s) => new TransferOutDetailModel
            .Select((b, a, s) => new ItemDetailModel
            {
                ItemNo = s.ItemNo,
                ItemName = s.ItemName,
@@ -128,7 +128,7 @@
    /// </summary>
    /// <param name="query">包含单据号、用户名和条码信息的查询参数</param>
    /// <returns>处理后的表单和待处理明细列表</returns>
    public (WarehouseQuery form, List<TransferOutDetailModel> items)
    public (WarehouseQuery form, List<ItemDetailModel> items)
        ScanMoveBarcode(WarehouseQuery query)
    {
        var p_bill_no = query.billNo;
@@ -217,7 +217,7 @@
    /// </summary>
    /// <param name="query">包含单据号、用户名和条码信息的查询参数</param>
    /// <returns>处理后的表单和待处理明细列表</returns>
    public (WarehouseQuery form, List<TransferOutDetailModel> items)
    public (WarehouseQuery form, List<ItemDetailModel> items)
        ScanReceiveBarcode(WarehouseQuery query)
    {
        var p_bill_no = query.billNo;