期初入库

啊鑫

2025-01-08 ff6a0b066a84dee4ba1b11512f6f34896a3c7dc7

期初入库

 Controllers/Warehouse/InventoryController.cs

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

namespace NewPdaSqlServer.Controllers.Warehouse;

[ApiController]
[Route("api/[controller]")]
public class InventoryController : ControllerBase
{
    private readonly InventoryManager m = new();

    /// <summary>
    /// æ‰«æåº“位条码的控制器方法
    /// </summary>
    /// <param name="query">包含库位代码的查询对象</param>
    /// <returns>扫描结果信息</returns>
    /// <remarks>
    /// è¯·æ±‚示例:
    /// POST /api/Inventory/ScanDepotNo
    /// {
    ///     "DepotCode": "库位代码"
    /// }
    /// </remarks>
    [HttpPost("ScanDepotNo")]
    public ResponseResult ScanDepotNo([FromBody] WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.ScanDepotNo(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/Inventory/ScanBarcode
    /// {
    ///     "barcode": "条码",
    ///     "DepotCode": "库位代码",
    ///     "userName": "用户名"
    /// }
    /// </remarks>
    [HttpPost("ScanBarcode")]
    public ResponseResult ScanBarcode([FromBody] WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.ScanBarcode(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }
}

 Controllers/Warehouse/MesDbckController.cs

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

namespace NewPdaSqlServer.Controllers.Warehouse;

[ApiController]
[Route("api/[controller]")]
public class MesDbckController : ControllerBase
{
    private readonly MesDbckManager m = new();


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

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

 Dto/service/WarehouseQuery.cs

@@ -29,4 +29,5 @@
    public decimal? Fum { get; set; }

    public string? itemNo { get; set; }
    public string? message { get; set; }
}

 entity/MesDbck.cs

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

namespace NewPdaSqlServer.entity;

/// <summary>
/// </summary>
[SugarTable("MES_DBCK")]
public class MesDbck
{
    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "id", IsPrimaryKey = true)]
    public Guid Id { get; set; }

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

    /// <summary>
    ///     è°ƒæ‹¨æ–¹å‘
    /// </summary>
    [SugarColumn(ColumnName = "ftransferdirect")]
    public string? Ftransferdirect { get; set; }

    /// <summary>
    ///     è°ƒæ‹¨ç±»åž‹
    /// </summary>
    [SugarColumn(ColumnName = "ftransferbiztype")]
    public string? Ftransferbiztype { get; set; }

    /// <summary>
    ///     è°ƒå‡ºåº“存组织
    /// </summary>
    [SugarColumn(ColumnName = "fstockoutorgid")]
    public string? Fstockoutorgid { get; set; }

    /// <summary>
    ///     è°ƒå…¥åº“存组织
    /// </summary>
    [SugarColumn(ColumnName = "fstockorgid")]
    public string? Fstockorgid { get; set; }

    /// <summary>
    ///     è°ƒå‡ºè´§ä¸»ç±»åž‹
    /// </summary>
    [SugarColumn(ColumnName = "fownertypeoutidhead")]
    public string? Fownertypeoutidhead { get; set; }

    /// <summary>
    ///     è°ƒå‡ºè´§ä¸»
    /// </summary>
    [SugarColumn(ColumnName = "fowneroutidhead")]
    public string? Fowneroutidhead { get; set; }

    /// <summary>
    ///     è°ƒå…¥è´§ä¸»ç±»åž‹
    /// </summary>
    [SugarColumn(ColumnName = "fownertypeidhead")]
    public string? Fownertypeidhead { get; set; }

    /// <summary>
    ///     è°ƒå…¥è´§ä¸»
    /// </summary>
    [SugarColumn(ColumnName = "fowneridhead")]
    public string? Fowneridhead { get; set; }

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

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

    /// <summary>
    ///     åˆ›å»ºæ—¶é—´
    /// </summary>
    [SugarColumn(ColumnName = "cteate_data")]
    public DateTime? CteateData { get; set; }

    /// <summary>
    ///     æœ€åŽè·Ÿæ–°äºº
    /// </summary>
    [SugarColumn(ColumnName = "lastupdate_by")]
    public string? LastupdateBy { get; set; }

    /// <summary>
    ///     æœ€åŽè·Ÿæ–°æ—¶é—´
    /// </summary>
    [SugarColumn(ColumnName = "lastupdate_date")]
    public DateTime? LastupdateDate { get; set; }

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

    /// <summary>
    ///     å®¡æ ¸æ—¶é—´
    /// </summary>
    [SugarColumn(ColumnName = "sh_date")]
    public DateTime? ShDate { get; set; }

    /// <summary>
    ///     å®¡æ ¸çŠ¶æ€
    ///     é»˜è®¤å€¼: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "sh_state")]
    public bool? ShState { get; set; }

    /// <summary>
    ///     è°ƒæ‹¨ç±»åž‹ç¼–码
    /// </summary>
    [SugarColumn(ColumnName = "ftransferbiztype_no")]
    public string? FtransferbiztypeNo { get; set; }

    /// <summary>
    ///     è°ƒæ‹¨æ–¹å‘编码
    /// </summary>
    [SugarColumn(ColumnName = "ftransferdirect_no")]
    public string? FtransferdirectNo { get; set; }

    /// <summary>
    ///     è°ƒå‡ºä»“库
    /// </summary>
    [SugarColumn(ColumnName = "inv_fcode")]
    public string? InvFcode { get; set; }

    /// <summary>
    ///     è°ƒå‡ºä»“库名称
    /// </summary>
    [SugarColumn(ColumnName = "inv_fname")]
    public string? InvFname { get; set; }

    /// <summary>
    ///     è°ƒå…¥ä»“库
    /// </summary>
    [SugarColumn(ColumnName = "from_fcode")]
    public string? FromFcode { get; set; }

    /// <summary>
    ///     è°ƒå…¥ä»“库名称
    /// </summary>
    [SugarColumn(ColumnName = "from_fname")]
    public string? FromFname { get; set; }

    /// <summary>
    ///     è°ƒå‡ºåº“存组织ID
    /// </summary>
    [SugarColumn(ColumnName = "fstockoutorgid_no")]
    public int? FstockoutorgidNo { get; set; }

    /// <summary>
    ///     è°ƒå…¥åº“存组织ID
    /// </summary>
    [SugarColumn(ColumnName = "fstockorgid_no")]
    public int? FstockorgidNo { get; set; }

    /// <summary>
    ///     è°ƒæ‹¨ç”³è¯·å•
    /// </summary>
    [SugarColumn(ColumnName = "billno")]
    public string? Billno { get; set; }

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

    /// <summary>
    ///     å‡ºåº“仓库
    /// </summary>
    [SugarColumn(ColumnName = "ck_depot")]
    public int? CkDepot { get; set; }

    /// <summary>
    ///     å…¥åº“仓库
    /// </summary>
    [SugarColumn(ColumnName = "rk_depot")]
    public int? RkDepot { get; set; }

    /// <summary>
    ///     å®Œç»“标识
    ///     é»˜è®¤å€¼: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "is_wc")]
    public bool? IsWc { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "remark")]
    public string? Remark { get; set; }
}

 entity/MesDbckEtail.cs

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

namespace NewPdaSqlServer.entity;

/// <summary>
/// </summary>
[SugarTable("MES_DBCK_ETAIL")]
public class MesDbckEtail
{
    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "id", IsPrimaryKey = true)]
    public Guid Id { get; set; }

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

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "item_id")]
    public int? ItemId { get; set; }

    /// <summary>
    ///     ç”³è¯·æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "sh_num")]
    public decimal? ShNum { get; set; }

    /// <summary>
    ///     å·²æ‰«æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "ys_num")]
    public decimal? YsNum { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "item_unit")]
    public string? ItemUnit { get; set; }

    /// <summary>
    ///     ç‰©æ–™åç§°
    /// </summary>
    [SugarColumn(ColumnName = "item_name")]
    public string? ItemName { get; set; }

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

    /// <summary>
    ///     è§„格型号
    /// </summary>
    [SugarColumn(ColumnName = "item_mpdel")]
    public string? ItemMpdel { get; set; }

    /// <summary>
    ///     å½“前库存数
    /// </summary>
    [SugarColumn(ColumnName = "kc")]
    public decimal? Kc { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "remark")]
    public string? Remark { get; set; }

    /// <summary>
    ///     å•ä½
    /// </summary>
    [SugarColumn(ColumnName = "unit_Id")]
    public int? UnitId { get; set; }

    /// <summary>
    ///     é¡ºåº
    /// </summary>
    [SugarColumn(ColumnName = "forder")]
    public int? Forder { get; set; }

    /// <summary>
    ///     è°ƒå‡ºæ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "DC_NUM")]
    public decimal? DcNum { get; set; }

    /// <summary>
    ///     è°ƒå…¥æ•°é‡
    /// </summary>
    [SugarColumn(ColumnName = "DR_NUM")]
    public decimal? DrNum { get; set; }
}

 entity/MesInvItemIns.cs

@@ -208,7 +208,7 @@
    ///     é»˜è®¤å€¼: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "URGENT_FLAG")]
    public byte? UrgentFlag { get; set; }
    public string? UrgentFlag { get; set; }

    /// <summary>
    /// </summary>

 service/Warehouse/InventoryManager.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,259 @@
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
using NewPdaSqlServer.util;
using SqlSugar;

namespace NewPdaSqlServer.service.Warehouse;

// æœŸåˆæ¡ç å…¥åº“
public class InventoryManager : RepositoryNoEntity
{
    // è¿™ä¸ªæ–¹æ³•ç”¨äºŽæ‰«æåº“位条码
    public string ScanDepotNo(WarehouseQuery query)
    {
        var p_section_code = query.DepotCode;

        // æ£€æŸ¥åº“位代码是否为空
        if (string.IsNullOrEmpty(p_section_code))
        {
            throw new Exception("002[请扫库位条码！");
        }

        // æŸ¥è¯¢åº“区库位信息
        var depotSection = Db.Queryable<MesDepotSections, MesDepots>((a, b) =>
                new JoinQueryInfos(
                    JoinType.Inner, a.DepotGuid == b.Guid
                ))
            .Where((a, b) => a.DepotSectionCode == p_section_code)
            .Select((a, b) => new
                { a.DepotSectionName, b.DepotCode, b.DepotName })
            .Single();

        // å¦‚果库位代码不存在，则返回错误信息
        if (depotSection == null)
        {
            throw new Exception("库位编码 " + p_section_code + " ä¸å­˜åœ¨ï¼Œè¯·ç¡®è®¤ï¼");
        }

        // è¿”回成功信息
        return "仓库：" + depotSection.DepotName + "  åº“位：" +
               depotSection.DepotSectionName;
    }

    // è¿™ä¸ªæ–¹æ³•ç”¨äºŽæ‰«ææ¡ç 
    public WarehouseQuery ScanBarcode(WarehouseQuery query)
    {
        var p_item_barcode = query.barcode;
        var p_section_code = query.DepotCode;
        var c_user = query.userName;
        var p_bill_type_id = 100;
        var p_transction_no = 601;

        // æ£€æŸ¥åº“位代码是否为空
        if (string.IsNullOrEmpty(p_section_code))
        {
            throw new Exception("002[请扫库位条码！");
        }

        // æŸ¥è¯¢åº“区库位信息
        var depotSection = Db.Queryable<MesDepotSections, MesDepots>((a, b) =>
                new JoinQueryInfos(
                    JoinType.Inner, a.DepotGuid == b.Guid
                ))
            .Where((a, b) => a.DepotSectionCode == p_section_code)
            .Select((a, b) => new
                { a.DepotSectionName, b.DepotCode, b.DepotName, b.DepotId })
            .Single();

        // å¦‚果库位代码不存在，则返回错误信息
        if (depotSection == null)
        {
            throw new Exception("库位编码 " + p_section_code + " ä¸å­˜åœ¨ï¼Œè¯·ç¡®è®¤ï¼");
        }

        // æ£€æŸ¥æ˜¯å¦å·²ç»æ”¶è´§
        var c_num = Db.Queryable<MesInvItemIns, MesInvItemInCDetails>((a, b) =>
                new JoinQueryInfos(
                    JoinType.Inner, a.Guid == b.ItemInId
                ))
            .Where((a, b) => b.ItemBarcode == p_item_barcode)
            .Count();

        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[条码已在库存中，请核对！");
        }

        // æŸ¥è¯¢æ¡ç è¯¦ç»†ä¿¡æ¯
        var c_mes_inv_item_barcodes = Db.Queryable<MesInvItemBarcodes>()
            .Where(t => t.ItemBarcode == p_item_barcode)
            .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 =>
        {
            // è‡ªåŠ¨ç”Ÿæˆå…¥åº“单
            var c_id = db.Queryable<MesInvItemIns>()
                .Where(d =>
                    d.Sapstatus == 0 &&
                    d.InsDate.Value.ToString("yyyy-MM-dd") ==
                    DateTime.Now.ToString("yyyy-MM-dd") &&
                    d.Status == 0 &&
                    d.TransctionNo == p_transction_no.ToString() &&
                    d.CbillNo == c_mes_inv_item_barcodes.BillNo &&
                    (d.SuppId ?? "0") ==
                    (c_mes_inv_item_barcodes.SuppId ?? "0") &&
                    d.DepotsCode == depotSection.DepotCode)
                .Single();

            if (c_id == null)
            {
                var billNo = BillNo.GetBillNo("IN(入库单)");
                // ç”Ÿæˆå…¥åº“单号
                var newMesInvItemIns = new MesInvItemIns
                {
                    Guid = Guid.NewGuid(),
                    TransctionNo = p_transction_no.ToString(),
                    DepotsCode = depotSection.DepotCode,
                    DepotsId = depotSection.DepotId,
                    BillTypeId = p_bill_type_id,
                    CreateBy = c_user,
                    CreateDate = DateTime.Now,
                    LastupdateBy = c_user,
                    LastupdateDate = DateTime.Now,
                    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",
                    CbillNo = c_mes_inv_item_barcodes.BillNo,
                    Fstatus = 0
                };
                db.Insertable(newMesInvItemIns)
                    .IgnoreColumns(true)
                    .ExecuteCommand();
                c_id = newMesInvItemIns;
            }

            // æ’入入库单明细
            db.Insertable(new MesInvItemInCDetails
            {
                Guid = Guid.NewGuid(),
                ItemInId = c_id.Guid,
                BillNo = c_id.BillNo,
                ItemBarcode = p_item_barcode,
                Quantity = c_mes_inv_item_barcodes.Quantity,
                BarcodeFlag = true,
                EpFlag = true,
                WorkType = 1,
                ItemNo = c_mes_inv_item_barcodes.ItemNo,
                LotNo = c_mes_inv_item_barcodes.LotNo,
                SuppNo = c_mes_inv_item_barcodes.SuppNo,
                DepotId = depotSection.DepotId,
                DepotCode = depotSection.DepotCode,
                DepotSectionCode = p_section_code,
                ItemSname = c_mes_inv_item_barcodes.ItemSname,
                Unit = c_mes_inv_item_barcodes.Unit,
                CreateBy = c_user,
                CreateDate = DateTime.Now,
                LastupdateBy = c_user,
                LastupdateDate = DateTime.Now,
                Remark = c_mes_inv_item_barcodes.Memo,
                Ebeln = c_mes_inv_item_barcodes.Mblnr,
                EbelnLineNo = c_mes_inv_item_barcodes.Zeile,
                WorkNo = c_mes_inv_item_barcodes.WorkNo,
                WorkLine = c_mes_inv_item_barcodes.WorkLine,
                CbillNo = c_mes_inv_item_barcodes.BillNo,
                UrgentFlag = c_mes_inv_item_barcodes.UrgentFlag,
                BoardStyle = c_mes_inv_item_barcodes.BoardStyle,
                TaskNo = c_mes_inv_item_barcodes.TaskNo,
                ItemId = c_mes_inv_item_barcodes.ItemId
            }).IgnoreColumns(true).ExecuteCommand();


            db.Insertable(new MesInvBusiness2
            {
                Guid = Guid.NewGuid(),
                Status = 1,
                BillTypeId = p_bill_type_id,
                TransactionCode = p_transction_no.ToString(),
                BusinessType = 1,
                ItemBarcode = p_item_barcode,
                ItemNo = c_mes_inv_item_barcodes.ItemNo,
                LotNo = c_mes_inv_item_barcodes.LotNo,
                EpFlag = true,
                Quantity = c_mes_inv_item_barcodes.Quantity,
                InvDepotId = depotSection.DepotId,
                ToInvDepotsCode = depotSection.DepotCode,
                ToInvDepotSectionsCode = p_section_code,
                CreateBy = c_user,
                CreateDate = DateTime.Now,
                LastupdateBy = c_user,
                LastupdateDate = DateTime.Now,
                TaskNo = c_mes_inv_item_barcodes.TaskNo,
                BillNo = c_id.BillNo,
                WorkNo = c_mes_inv_item_barcodes.WorkNo,
                WorkLine = c_mes_inv_item_barcodes.WorkLine,
                SuppNo = c_mes_inv_item_barcodes.SuppNo,
                ItemId = c_mes_inv_item_barcodes.ItemId
            }).IgnoreColumns(true).ExecuteCommand();

            // æ’入库存信息
            db.Insertable(new MesInvItemStocks
            {
                Guid = Guid.NewGuid(),
                TaskNo = c_mes_inv_item_barcodes.TaskNo,
                ItemBarcode = p_item_barcode,
                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),
                DepotsCode = depotSection.DepotCode,
                DepotsId = depotSection.DepotId,
                DepotSectionsCode = p_section_code,
                CheckDate = c_mes_inv_item_barcodes.CreateDate,
                IndepDate = c_mes_inv_item_barcodes.CreateDate,
                BoardStyle = c_mes_inv_item_barcodes.BoardStyle,
                WorkNo = c_mes_inv_item_barcodes.WorkNo,
                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
                // Fsubsidiary = c_organize
            }).IgnoreColumns(true).ExecuteCommand();

            return 1;
        });

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

        query.itemNo = mesItems.ItemNo;
        query.Num = c_mes_inv_item_barcodes.Quantity;
        query.message = "物料 " +
                        c_mes_inv_item_barcodes.ItemNo + " æœ¬æ¬¡æ”¶è´§æ€»æ•°ï¼š " +
                        c_mes_inv_item_barcodes.Quantity;
        // è¿”回成功信息
        return query;
    }
}

 service/Warehouse/MesCgthSqManager.cs

@@ -73,7 +73,7 @@
                    ItemNo = s.ItemNo, // ä»ŽMesItems表中获取ItemNo
                    ItemName = s.ItemName, // ä»ŽMesItems表中获取ItemName
                    ItemModel = s.ItemModel, // ä»ŽMesItems表中获取ItemModel
                    ItemId = c.ItemId,
                    ItemId = c.ItemId
                }).ToList(); // å°†æŸ¥è¯¢ç»“果转换为列表 

        return mesInvItemOutItemsList; // è¿”回处理后的列表

 service/Warehouse/MesDbckManager.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,7 @@
using NewPdaSqlServer.DB;
using NewPdaSqlServer.entity;

namespace NewPdaSqlServer.service.Warehouse;

public class MesDbckManager : Repository<MesDbck>
{}

 service/Warehouse/MesInvItemInCDetailsManager.cs

@@ -171,8 +171,8 @@
                    LastupdateBy = user,
                    LastupdateDate = DateTime.Now,
                    UrgentFlag = itemBarcodeDetails.UrgentFlag.Value
                        ? (byte)1
                        : (byte)0,
                        ? "1"
                        : "0",
                    CbillNo = itemBarcodeDetails.BillNo,
                    Fstatus = 0,
                    Status = 0,

 service/Warehouse/MesItemQtrkManager.cs

@@ -200,7 +200,7 @@
                    CreateDate = DateTime.Now,
                    LastupdateBy = c_user,
                    LastupdateDate = DateTime.Now,
                    UrgentFlag = barcode.UrgentFlag.Value ? (byte)1 : (byte)0,
                    UrgentFlag = barcode.UrgentFlag.Value ? "1" : "0",
                    CbillNo = p_bill_no,
                    Fstatus = 0,
                    Status = 0,