Merge branch 'master' of http://43.142.96.171:8080/r/~tjx/StandardPda

lg

2024-08-15 105639743f1b2f8c47a5bc9659532f231935206b

Merge branch 'master' of http://43.142.96.171:8080/r/~tjx/StandardPda

 MES.Service/Dto/service/InventoryItem.cs

@@ -16,4 +16,12 @@

    [SugarColumn(ColumnName = "QTY")]
    public decimal Qty { get; set; } // ä½¿ç”¨ decimal æ¥è¡¨ç¤ºæ•°é‡

    [SugarColumn(ColumnName = "sections_code")]
    public string SectionsCode { get; set; }

    [SugarColumn(ColumnName = "erp_item_no")]
    public string ErpItemNo { get; set; }

    [SugarColumn(ColumnName = "flist")] public string Flist { get; set; }
}

 MES.Service/Dto/service/WarehouseQuery.cs

@@ -19,4 +19,8 @@
    public string? Type { get; set; }
    public string? DepotCode { get; set; }
    public string? SuppNo { get; set; }
    
    public string Factory { get; set; }
    
    public string Company { get; set; }
}

 MES.Service/Modes/MesInvBusiness2.cs

@@ -1,9 +1,7 @@
using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace MES.Service.Modes
{
using SqlSugar;

namespace MES.Service.Modes;

    /// <summary>
    /// åº“存交易记录表
    ///</summary>
@@ -13,182 +11,217 @@
        /// <summary>
        /// ID(seq_inv_id) 
        ///</summary>
         [SugarColumn(ColumnName="ID",OracleSequenceName = "SEQ_ID",IsPrimaryKey = true   )]
 [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ID",
        IsPrimaryKey = true)]
         public decimal Id { get; set; }

        /// <summary>
        /// çŠ¶æ€|0-未交易1-已交易 
        ///</summary>
         [SugarColumn(ColumnName="STATUS"    )]
         public decimal? Status { get; set; }

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

        /// <summary>
        /// äº‹åŠ¡ç±»åž‹ç¼–码 
        ///</summary>
         [SugarColumn(ColumnName="TRANSACTION_CODE"    )]
         public string TransactionCode { get; set; }

        /// <summary>
        /// äº¤æ˜“类型|1-入库0-转库-1出库 
        ///</summary>
         [SugarColumn(ColumnName="BUSINESS_TYPE"    )]
         public decimal? BusinessType { get; set; }

        /// <summary>
        /// å•æ®ID 
        ///</summary>
         [SugarColumn(ColumnName="BILL_ID"    )]
         public decimal? BillId { get; set; }

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

        /// <summary>
        /// ç”Ÿäº§è®¢å•å· 
        ///</summary>
         [SugarColumn(ColumnName="TASK_NO"    )]
         public string TaskNo { get; set; }

        /// <summary>
        /// å®¢æˆ·ç¼–号 
        ///</summary>
         [SugarColumn(ColumnName="CUSTOMER_NO"    )]
         public string CustomerNo { get; set; }

        /// <summary>
        /// å•æ®è¡ŒID 
        ///</summary>
         [SugarColumn(ColumnName="BILL_LINE_ID"    )]
         public decimal? BillLineId { get; set; }

        /// <summary>
        /// ç‰©æ–™æ¡ç  
        ///</summary>
         [SugarColumn(ColumnName="ITEM_BARCODE"    )]
         public string ItemBarcode { get; set; }

        /// <summary>
        /// æœ¬å¸ç‰©æ–™ç¼–码 
        ///</summary>
         [SugarColumn(ColumnName="ITEM_NO"    )]
         public string ItemNo { get; set; }

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

        /// <summary>
        /// åŽ‚家批次 
        ///</summary>
         [SugarColumn(ColumnName="LOT_NO"    )]
         public string LotNo { get; set; }

        /// <summary>
        /// æ˜¯å¦çŽ¯ä¿(0:否,1:是) 
        ///</summary>
         [SugarColumn(ColumnName="EP_FLAG"    )]
         public short? EpFlag { get; set; }

        /// <summary>
        /// æ•°é‡ 
        ///</summary>
         [SugarColumn(ColumnName="QUANTITY"    )]
         public decimal? Quantity { get; set; }

        /// <summary>
        /// æºå­åº“CODE 
        ///</summary>
         [SugarColumn(ColumnName="FROM_INV_DEPOTS_CODE"    )]
         public string FromInvDepotsCode { get; set; }

        /// <summary>
        /// æºè´§ä½CODE 
        ///</summary>
         [SugarColumn(ColumnName="FROM_INV_DEPOT_SECTIONS_CODE"    )]
         public string FromInvDepotSectionsCode { get; set; }

        /// <summary>
        /// ç›®çš„子库CODE 
        ///</summary>
         [SugarColumn(ColumnName="TO_INV_DEPOTS_CODE"    )]
         public string ToInvDepotsCode { get; set; }

        /// <summary>
        /// ç›®çš„货位CODE 
        ///</summary>
         [SugarColumn(ColumnName="TO_INV_DEPOT_SECTIONS_CODE"    )]
         public string ToInvDepotSectionsCode { get; set; }

        /// <summary>
        /// äº¤æ˜“异常信息 
        ///</summary>
         [SugarColumn(ColumnName="DESCRIPTION"    )]
         public string Description { get; set; }

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

        /// <summary>
        /// åˆ›å»ºæ—¶é—´ 
        ///</summary>
         [SugarColumn(ColumnName="CREATE_DATE"    )]
         public DateTime? CreateDate { 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="ULLAGE_STAT_FLAG"    )]
         public short? UllageStatFlag { get; set; }

        /// <summary>
        /// åˆ†åŽ‚编码 
        ///</summary>
         [SugarColumn(ColumnName="FACTORY"    )]
         public string Factory { get; set; }

        /// <summary>
        /// å…¬å¸ä»£ç  
        ///</summary>
         [SugarColumn(ColumnName="COMPANY"    )]
         public string Company { get; set; }

        /// <summary>
        /// ç®±å·æ¡ç  
        ///</summary>
         [SugarColumn(ColumnName="ITEM_BARCODE2"    )]
         public string ItemBarcode2 { get; set; }

        /// <summary>
        /// å¡æ¿æ¡ç  
        ///</summary>
         [SugarColumn(ColumnName="ITEM_BARCODE3"    )]
         public string ItemBarcode3 { get; set; }

        /// <summary>
        /// ä»»åŠ¡å•å· 
        ///</summary>
         [SugarColumn(ColumnName="WORK_NO"    )]
         public string WorkNo { get; set; }

        /// <summary>
        /// ä»»åŠ¡å•è¡Œå· 
        ///</summary>
         [SugarColumn(ColumnName="WORK_LINE"    )]
         public decimal? WorkLine { get; set; }

        /// <summary>
        /// ä¾›åº”商 
        ///</summary>
         [SugarColumn(ColumnName="SUPP_NO"    )]
         public string SuppNo { get; set; }

        /// <summary>
        /// ç”Ÿäº§çº¿ 
        ///</summary>
         [SugarColumn(ColumnName="LINE_NO"    )]
         public string LineNo { get; set; }

        /// <summary>
        /// é‡‡è´­è®¢å•id 
        ///</summary>
         [SugarColumn(ColumnName="EBELN_K3ID"    )]
         public decimal? EbelnK3id { get; set; }

        /// <summary>
        /// é‡‡è´­è®¢å•è¡Œid 
        ///</summary>
         [SugarColumn(ColumnName="LINE_K3ID"    )]
         public decimal? LineK3id { get; set; }
    }
}

 MES.Service/Modes/MesInvItemArn.cs

 MES.Service/Modes/MesInvItemBarcodes.cs

 MES.Service/Modes/MesInvItemInCDetails.cs

@@ -11,7 +11,8 @@
    /// <summary>
    ///     SEQ_OUT
    /// </summary>
    [SugarColumn(ColumnName = "ID",OracleSequenceName = "SEQ_INV_ID", IsPrimaryKey = true)]
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }

    /// <summary>

 MES.Service/Modes/MesInvItemInCItems.cs

 MES.Service/Modes/MesInvItemMoves.cs

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

namespace MES.Service.Modes;

/// <summary>
///     ç‰©æ–™ç§»åº“主表
/// </summary>
[SugarTable("MES_INV_ITEM_MOVES")]
public class MesInvItemMoves
{
 /// <summary>
 ///     SEQ_INV_ID
 /// </summary>
 [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
    public decimal Id { get; set; }

 /// <summary>
 ///     ç§»åº“单号
 /// </summary>
 [SugarColumn(ColumnName = "BILL_NO")]
    public string BillNo { get; set; }

 /// <summary>
 ///     ç§»å…¥å­åº“id
 /// </summary>
 [SugarColumn(ColumnName = "INV_DEPOTS_ID")]
    public decimal? InvDepotsId { get; set; }

 /// <summary>
 ///     ç§»å…¥è´§ä½id
 /// </summary>
 [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
    public decimal? InvDepotSectionsId { get; set; }

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

 /// <summary>
 ///     åˆ›å»ºæ—¶é—´
 /// </summary>
 [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { 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>
 ///     çŠ¶æ€|0-制单1-过账
 /// </summary>
 [SugarColumn(ColumnName = "STATUS")]
    public decimal? Status { get; set; }

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

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

 /// <summary>
 ///     äº‹åŠ¡ç±»åž‹ID
 /// </summary>
 [SugarColumn(ColumnName = "TRANSACTION_ID")]
    public decimal? TransactionId { get; set; }

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

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

 /// <summary>
 ///     ç§»å…¥å­åº“code
 /// </summary>
 [SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
    public string InvDepotsCode { get; set; }

 /// <summary>
 ///     ç§»å…¥è´§ä½code
 /// </summary>
 [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
    public string InvDepotSectionsCode { get; set; }

 /// <summary>
 ///     äº‹åŠ¡ç±»åž‹ç¼–码
 /// </summary>
 [SugarColumn(ColumnName = "TRANSACTION_NO")]
    public decimal? TransactionNo { get; set; }

 /// <summary>
 ///     ç§»å‡ºå­åº“code
 /// </summary>
 [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
    public string FromDepotsCode { get; set; }

 /// <summary>
 ///     å·¥åŽ‚编码
 /// </summary>
 [SugarColumn(ColumnName = "FACTORY_CODE")]
    public string FactoryCode { get; set; }

 /// <summary>
 ///     SAP返回单据
 /// </summary>
 [SugarColumn(ColumnName = "SAPNO")]
    public string Sapno { get; set; }

 /// <summary>
 ///     å·²å›žå†™SAP
 /// </summary>
 [SugarColumn(ColumnName = "SAPSTATUS")]
    public short? Sapstatus { get; set; }

 /// <summary>
 ///     SAP返回年份
 /// </summary>
 [SugarColumn(ColumnName = "SAPYEAR")]
    public short? Sapyear { get; set; }

 /// <summary>
 ///     SAP返回信息
 /// </summary>
 [SugarColumn(ColumnName = "SAPTEXT")]
    public string Saptext { get; set; }

 /// <summary>
 ///     åˆ†åŽ‚编码
 /// </summary>
 [SugarColumn(ColumnName = "FACTORY")]
    public string Factory { get; set; }

 /// <summary>
 ///     å…¬å¸ä»£ç 
 /// </summary>
 [SugarColumn(ColumnName = "COMPANY")]
    public string Company { get; set; }

 /// <summary>
 ///     åå®¡æ ¸äº‹åŠ¡ç±»åž‹ç¼–码
 /// </summary>
 [SugarColumn(ColumnName = "MTRANSACTION_NO")]
    public decimal? MtransactionNo { get; set; }

 /// <summary>
 ///     è‡ªåŠ¨ä¿å­˜å­—段
 /// </summary>
 [SugarColumn(ColumnName = "ZD_NUM")]
    public decimal? ZdNum { get; set; }

 /// <summary>
 ///     æ˜¯å¦æŽ¨é€ERP1-是，2-否
 /// </summary>
 [SugarColumn(ColumnName = "TS")]
    public decimal? Ts { get; set; }
}

 MES.Service/Modes/MesInvItemMovesCDetails.cs

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

namespace MES.Service.Modes;

/// <summary>
///     ç‰©æ–™ç§»åº“条码明细从表
/// </summary>
[SugarTable("MES_INV_ITEM_MOVES_C_DETAILS")]
public class MesInvItemMovesCDetails
{
 /// <summary>
 ///     seq_inv_id
 /// </summary>
 [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
    public decimal Id { get; set; }

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

 /// <summary>
 ///     ç‰©æ–™æ¡ç 
 /// </summary>
 [SugarColumn(ColumnName = "ITEM_BARCODE")]
    public string ItemBarcode { get; set; }

 /// <summary>
 ///     å®¢æˆ·ç‰©æ–™ç¼–码（无条码手工录入，有条码为冗余字段）
 /// </summary>
 [SugarColumn(ColumnName = "C_ITEM_CODE")]
    public string CItemCode { get; set; }

 /// <summary>
 ///     ä¿¡åŽç‰©æ–™ç¼–码（无条码手工录入，有条码为冗余字段）
 /// </summary>
 [SugarColumn(ColumnName = "ITEM_NO")]
    public string ItemNo { get; set; }

 /// <summary>
 ///     åŽ‚家批次
 /// </summary>
 [SugarColumn(ColumnName = "LOT_NO")]
    public string LotNo { get; set; }

 /// <summary>
 ///     æ•°é‡ï¼ˆæ— æ¡ç æ‰‹å·¥å½•å…¥ï¼Œæœ‰æ¡ç ä¸ºå†—余字段）
 /// </summary>
 [SugarColumn(ColumnName = "QUANTITY")]
    public decimal? Quantity { get; set; }

 /// <summary>
 ///     å‡ºåº“方式(1:有条码,0:无条码)
 /// </summary>
 [SugarColumn(ColumnName = "BARCODE_FLAG")]
    public short? BarcodeFlag { get; set; }

 /// <summary>
 ///     çŽ¯ä¿æ ‡å¿—（无条码手工录入，有条码为冗余字段）
 /// </summary>
 [SugarColumn(ColumnName = "EP_FLAG")]
    public short? EpFlag { get; set; }

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

 /// <summary>
 ///     åˆ›å»ºæ—¶é—´
 /// </summary>
 [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { 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>
 ///     å­åº“id
 /// </summary>
 [SugarColumn(ColumnName = "INV_DEPOTS_ID")]
    public decimal? InvDepotsId { get; set; }

 /// <summary>
 ///     è´§ä½id
 /// </summary>
 [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
    public decimal? InvDepotSectionsId { get; set; }

 /// <summary>
 ///     å®¢æˆ·ç¼–码
 /// </summary>
 [SugarColumn(ColumnName = "CUST_NO")]
    public string CustNo { get; set; }

 /// <summary>
 ///     ä»»åŠ¡ä»¤å·
 /// </summary>
 [SugarColumn(ColumnName = "TASK_NO")]
    public string TaskNo { get; set; }

 /// <summary>
 ///     ç§»å‡ºä»“库编号
 /// </summary>
 [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
    public string FromDepotsCode { get; set; }

 /// <summary>
 ///     ç§»å‡ºåº“位编号
 /// </summary>
 [SugarColumn(ColumnName = "FROM_DEPOT_SECTIONS_CODE")]
    public string FromDepotSectionsCode { get; set; }

 /// <summary>
 ///     æ¡ç å¤‡æ³¨
 /// </summary>
 [SugarColumn(ColumnName = "REMARK")]
    public string Remark { get; set; }

 /// <summary>
 ///     åˆ†åŽ‚编码
 /// </summary>
 [SugarColumn(ColumnName = "FACTORY")]
    public string Factory { get; set; }

 /// <summary>
 ///     å…¬å¸ä»£ç 
 /// </summary>
 [SugarColumn(ColumnName = "COMPANY")]
    public string Company { get; set; }

 /// <summary>
 ///     ç®±å·
 /// </summary>
 [SugarColumn(ColumnName = "BOX_NO")]
    public string BoxNo { get; set; }

 /// <summary>
 ///     å¡æ¿å·
 /// </summary>
 [SugarColumn(ColumnName = "KO_NO")]
    public string KoNo { get; set; }

 /// <summary>
 ///     ç§»å…¥ä»“库编号
 /// </summary>
 [SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
    public string InvDepotsCode { get; set; }

 /// <summary>
 ///     ç§»å…¥åº“位编号
 /// </summary>
 [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
    public string InvDepotSectionsCode { get; set; }

 /// <summary>
 ///     è´¨æ£€ç»“æžœ
 /// </summary>
 [SugarColumn(ColumnName = "IQC_STATUS")]
    public string IqcStatus { get; set; }

 /// <summary>
 ///     å°è½¦ç¼–号
 /// </summary>
 [SugarColumn(ColumnName = "FCAR")]
    public string Fcar { get; set; }

 /// <summary>
 ///     å…¥åº“日期
 /// </summary>
 [SugarColumn(ColumnName = "INDEP_DATE")]
    public DateTime? IndepDate { get; set; }

 /// <summary>
 ///     å†»ç»“提交重检，0：冻结未提交重检，1：冻结并提交重检
 /// </summary>
 [SugarColumn(ColumnName = "VISABLE_SUBMIT")]
    public short? VisableSubmit { get; set; }

 /// <summary>
 ///     æäº¤é‡æ£€äºº
 /// </summary>
 [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")]
    public string VisableSubmitBy { get; set; }

 /// <summary>
 ///     æäº¤é‡æ£€æ—¶é—´
 /// </summary>
 [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")]
    public DateTime? VisableSubmitDate { get; set; }

 /// <summary>
 ///     äº§å“åž‹å·
 /// </summary>
 [SugarColumn(ColumnName = "BOARD_STYLE")]
    public string BoardStyle { get; set; }

 /// <summary>
 ///     ä»»åŠ¡å•å·
 /// </summary>
 [SugarColumn(ColumnName = "WORK_NO")]
    public string WorkNo { get; set; }

 /// <summary>
 ///     ä»»åŠ¡å•è¡Œå·
 /// </summary>
 [SugarColumn(ColumnName = "WORK_LINE")]
    public decimal? WorkLine { get; set; }

 /// <summary>
 ///     ä¾›åº”商编号
 /// </summary>
 [SugarColumn(ColumnName = "SUPP_NO")]
    public string SuppNo { get; set; }

 /// <summary>
 ///     è°ƒå…¥
 /// </summary>
 [SugarColumn(ColumnName = "MOVE_OK")]
    public decimal? MoveOk { get; set; }
}

 MES.Service/Modes/MesInvItemStocks.cs

 MES.Service/Modes/MesQaItemsDetect01.cs

 MES.Service/Modes/MesQaItemsDetectDetail5.cs

@@ -1,9 +1,7 @@
using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace MES.Service.Modes
{
using SqlSugar;

namespace MES.Service.Modes;

    /// <summary>
    /// æ¥æ–™æ£€éªŒä»Žè¡¨
    ///</summary>
@@ -11,144 +9,166 @@
    public class MesQaItemsDetectDetail5
    {
        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true   )]
         public decimal Id { get; set; }

        /// <summary>
        /// æ ‡å‡†å€¼ç±»åž‹ 
        ///</summary>
         [SugarColumn(ColumnName="FTEXT_TYPE"    )]
         public string FtextType { get; set; }

        /// <summary>
        /// æ ‡å‡†å€¼ 
        ///</summary>
         [SugarColumn(ColumnName="FSTAND"    )]
         public decimal? Fstand { get; set; }

        /// <summary>
        /// ä¸Šå…¬å·® 
        ///</summary>
         [SugarColumn(ColumnName="FUP_ALLOW"    )]
         public string FupAllow { get; set; }

        /// <summary>
        /// ä¸‹å…¬å·® 
        ///</summary>
         [SugarColumn(ColumnName="FDOWN_ALLOW"    )]
         public string FdownAllow { get; set; }

        /// <summary>
        /// æ£€éªŒæ°´å‡† 
        ///</summary>
         [SugarColumn(ColumnName="SAMPLE_SIZE_NO"    )]
         public string SampleSizeNo { get; set; }

        /// <summary>
        /// æ£€éªŒæ°´å¹³ 
        ///</summary>
         [SugarColumn(ColumnName="FCHECK_LEVEL"    )]
         public string FcheckLevel { get; set; }

        /// <summary>
        /// æ‹’收水平 
        ///</summary>
         [SugarColumn(ColumnName="FAC_LEVEL"    )]
         public string FacLevel { get; set; }

        /// <summary>
        /// æ£€éªŒé¡¹ç›® 
        ///</summary>
         [SugarColumn(ColumnName="FCHECK_ITEM"    )]
         public string FcheckItem { get; set; }

        /// <summary>
        /// è§„格要求 
        ///</summary>
         [SugarColumn(ColumnName="FSPEC_REQU"    )]
         public string FspecRequ { get; set; }

        /// <summary>
        /// æŠ½æ£€æ•°é‡ 
        ///</summary>
         [SugarColumn(ColumnName="CHECK_QYT"    )]
         public decimal? CheckQyt { get; set; }

        /// <summary>
        /// æ£€éªŒç»“æžœ 
        ///</summary>
         [SugarColumn(ColumnName="FCHECK_RESU"    )]
         public string FcheckResu { get; set; }

        /// <summary>
        /// AC数量 
        ///</summary>
         [SugarColumn(ColumnName="FAC_QTY"    )]
         public decimal? FacQty { get; set; }

        /// <summary>
        /// RE数量 
        ///</summary>
         [SugarColumn(ColumnName="FRE_QTY"    )]
         public decimal? FreQty { get; set; }

        /// <summary>
        /// ä¸åˆæ ¼æ•° 
        ///</summary>
         [SugarColumn(ColumnName="FNG_QTY"    )]
         public decimal? FngQty { get; set; }

        /// <summary>
        /// ä¸è‰¯çŽ‡ 
        ///</summary>
         [SugarColumn(ColumnName="FNG_RATE"    )]
         public decimal? FngRate { get; set; }

        /// <summary>
        /// å·²å½•å…¥æ•°é‡ 
        ///</summary>
         [SugarColumn(ColumnName="FENTER_QTY"    )]
         public decimal? FenterQty { get; set; }

        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="RELEASE_NO"    )]
         public string ReleaseNo { get; set; }

        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="COMPANY"    )]
         public string Company { get; set; }

        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="FACTORY"    )]
         public string Factory { get; set; }

        /// <summary>
        /// æ£€éªŒé¡¹ç›®æè¿° 
        ///</summary>
         [SugarColumn(ColumnName="FCHECK_ITEM_DESC"    )]
         public string FcheckItemDesc { get; set; }

        /// <summary>
        /// å·¥åºå· 
        ///</summary>
         [SugarColumn(ColumnName="PROC_NO"    )]
         public string ProcNo { get; set; }

        /// <summary>
        /// å·¥ä½œä¸­å¿ƒç¼–码 
        ///</summary>
         [SugarColumn(ColumnName="WORKSHOP_CENTER_CODE"    )]
         public string WorkshopCenterCode { get; set; }

        /// <summary>
        /// å•ä½ 
        ///</summary>
         [SugarColumn(ColumnName="FUNIT"    )]
         public string Funit { get; set; }

        /// <summary>
        /// ç‰¹å®šä¿®æ”¹ 
        ///</summary>
         [SugarColumn(ColumnName="GIVEN_MODIFY"    )]
         public short? GivenModify { get; set; }

        /// <summary>
        /// æ£€éªŒå·¥å…· 
        ///</summary>
         [SugarColumn(ColumnName="FCHECK_TOOL"    )]
         public string FcheckTool { get; set; }

        /// <summary>
        /// æ›´æ–°äºº 
        ///</summary>
         [SugarColumn(ColumnName="LASTUPDATE_BY"    )]
         public string LastupdateBy { get; set; }

        /// <summary>
        /// æ›´æ–°æ—¶é—´ 
        ///</summary>
         [SugarColumn(ColumnName="LASTUPDATE_DATE"    )]
         public DateTime? LastupdateDate { get; set; }
    }
}

 MES.Service/Modes/Purdhb.cs

 MES.Service/Modes/Purdka.cs

 MES.Service/service/BasicData/MesStaffManager.cs

@@ -149,7 +149,7 @@
            Status = 0,
            Isdeparture = 0,
            CheckFlag = 0,
            ExpFiel12 = 0,
            ExpFiel12 = 0
        };
    }


 MES.Service/service/QC/MesQaItemsDetectDetail5Manager.cs

@@ -1,26 +1,24 @@
using SqlSugar;
using System;
using System.Collections.Generic;
using MES.Service.DB;
using MES.Service.DB;
using MES.Service.Modes;
using SqlSugar;

namespace MES.Service.service.QC
{
public class MesQaItemsDetectDetail5Manager : Repository<MesQaItemsDetectDetail5>
{
namespace MES.Service.service.QC;
 
public class
    MesQaItemsDetectDetail5Manager : Repository<MesQaItemsDetectDetail5>
{
    //当前类已经继承了 Repository å¢žã€åˆ ã€æŸ¥ã€æ”¹çš„方法

    //这里面写的代码不会给覆盖,如果要重新生成请删除 MesQaItemsDetectDetail5Manager.cs


    #region æ•™å­¦æ–¹æ³•

    /// <summary>
    /// ä»“储方法满足不了复杂业务需求，业务代码请在这里面定义方法
    /// </summary>
    public void Study()
    {
	     
       /*********查询*********/

        var data1 = base.GetById(1);//根据ID查询
@@ -28,51 +26,54 @@
        var data3 = base.GetList(it => 1 == 1);  //根据条件查询  
        //var data4 = base.GetSingle(it => 1 == 1);//根据条件查询一条,如果超过一条会报错

        var p = new PageModel() { PageIndex = 1, PageSize = 2 };// åˆ†é¡µæŸ¥è¯¢
        var p = new PageModel { PageIndex = 1, PageSize = 2 }; // åˆ†é¡µæŸ¥è¯¢
        var data5 = base.GetPageList(it => 1 == 1, p);
        Console.Write(p.TotalCount);//返回总数

        var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom(), OrderByType.Asc);// åˆ†é¡µæŸ¥è¯¢åŠ æŽ’序
        var data6 =
            base.GetPageList(it => 1 == 1, p,
                it => SqlFunc.GetRandom()); // åˆ†é¡µæŸ¥è¯¢åŠ æŽ’序
        Console.Write(p.TotalCount);//返回总数
     
        List<IConditionalModel> conModels = new List<IConditionalModel>(); //组装条件查询作为条件实现 åˆ†é¡µæŸ¥è¯¢åŠ æŽ’序
        conModels.Add(new ConditionalModel() { FieldName= typeof(MesQaItemsDetectDetail5).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" });//id=1
        var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc);
        var conModels = new List<IConditionalModel>(); //组装条件查询作为条件实现 åˆ†é¡µæŸ¥è¯¢åŠ æŽ’序
        conModels.Add(new ConditionalModel
        {
            FieldName = typeof(MesQaItemsDetectDetail5).GetProperties()[0].Name,
            ConditionalType = ConditionalType.Equal, FieldValue = "1"
        }); //id=1
        var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom());

        base.AsQueryable().Where(x => 1 == 1).ToList();//支持了转换成queryable,我们可以用queryable实现复杂功能

        AsQueryable().Where(x => 1 == 1)
            .ToList(); //支持了转换成queryable,我们可以用queryable实现复杂功能
 

        /*********插入*********/
        var insertData = new MesQaItemsDetectDetail5() { };//测试参数
        var insertArray = new MesQaItemsDetectDetail5[] { insertData };
        var insertData = new MesQaItemsDetectDetail5(); //测试参数
        var insertArray = new[] { insertData };
        base.Insert(insertData);//插入
        base.InsertRange(insertArray);//批量插入
        var id = base.InsertReturnIdentity(insertData);//插入返回自增列
        base.AsInsertable(insertData).ExecuteCommand();//我们可以转成 Insertable实现复杂插入

        AsInsertable(insertData).ExecuteCommand(); //我们可以转成 Insertable实现复杂插入


        /*********更新*********/
        var updateData = new MesQaItemsDetectDetail5() {  };//测试参数
        var updateArray = new MesQaItemsDetectDetail5[] { updateData };//测试参数
        var updateData = new MesQaItemsDetectDetail5(); //测试参数
        var updateArray = new[] { updateData }; //测试参数
        base.Update(updateData);//根据实体更新
        base.UpdateRange(updateArray);//批量更新
        //base.Update(it => new MesQaItemsDetectDetail5() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ›´æ–°ClassName列和CreateTime列，其它列不更新，条件id=1
        base.AsUpdateable(updateData).ExecuteCommand();  //转成Updateable可以实现复杂的插入

        AsUpdateable(updateData).ExecuteCommand(); //转成Updateable可以实现复杂的插入


        /*********删除*********/
        var deldata = new MesQaItemsDetectDetail5() {  };//测试参数
        var deldata = new MesQaItemsDetectDetail5(); //测试参数
        base.Delete(deldata);//根据实体删除
        base.DeleteById(1);//根据主键删除
        base.DeleteById(new int[] { 1,2});//根据主键数组删除
        base.DeleteById(new[] { 1, 2 }); //根据主键数组删除
        base.Delete(it=>1==2);//根据条件删除
        base.AsDeleteable().Where(it=>1==2).ExecuteCommand();//转成Deleteable实现复杂的操作
        AsDeleteable().Where(it => 1 == 2)
            .ExecuteCommand(); //转成Deleteable实现复杂的操作
    } 

    #endregion

 
 }
}

 MES.Service/service/Warehouse/MesDepotSectionsManager.cs

@@ -17,20 +17,16 @@
            .Select((a, b) => a.DepotSectionName).Single();

        if (sectionName == null)
        {
            throw new Exception("库位编码 " + query.sectionCode + " ä¸å­˜åœ¨ï¼Œè¯·ç¡®è®¤ï¼");
        }

        return sectionName;
    }

    //库位变更
    public MesDepotSections ScanInDepotSectionsName(WarehouseQuery query)
    {
        
        if (string.IsNullOrEmpty(query.sectionCode))
        {
            throw new Exception("请扫库位条码!");
        }
        
        var mesDepotSections = Db.Queryable<MesDepotSections, MesDepots>(
                (a, b) =>
@@ -44,20 +40,47 @@
            }).First();

        if (mesDepotSections == null)
        {
            throw new Exception("库位编码" + query.sectionCode + " ä¸å­˜åœ¨ï¼Œè¯·ç¡®è®¤!");
        }

        return mesDepotSections;
    }

    //库位变更
    public MesInvItemStocks ScanEditBarcode(WarehouseQuery entity)
    {
        if (string.IsNullOrEmpty(entity.sectionCode))
        {
            throw new Exception("请扫库位条码!");

        var mesDepotSections = Db.Queryable<MesDepotSections, MesDepots>(
                (a, b) =>
                    new JoinQueryInfos(JoinType.Inner,
                        a.Zuid.ToString() == b.Zuid))
            .Where((a, b) => a.DepotSectionCode == entity.sectionCode)
            .First();
        if (mesDepotSections == null)
            throw new Exception("库位编码" + entity.sectionCode + " ä¸å­˜åœ¨ï¼Œè¯·ç¡®è®¤ï¼");

        var mesInvItemStocks = Db.Queryable<MesInvItemStocks>()
            .Where(s => s.ItemBarcode == entity.barcode).First();

        if (mesInvItemStocks == null) throw new Exception("条码在仓库中不存在，请核对！");

        if (mesInvItemStocks.DepotsCode != mesDepotSections.DepotCode)
            throw new Exception(
                "条码原仓库：" + mesInvItemStocks.DepotsCode + " ä¸Žç›®æ ‡ä»“库：" +
                mesDepotSections.DepotCode + " ä¸ä¸€è‡´ï¼Œåº“位变更失败！");

        UseTransaction(db =>
        {
            return db.Updateable<MesInvItemStocks>()
                .SetColumns(s => s.DepotsCode == mesDepotSections.DepotCode)
                .SetColumns(s => s.DepotSectionsCode == entity.sectionCode)
                .Where(s => s.ItemBarcode == entity.barcode)
                .ExecuteCommand();
        });

        return mesInvItemStocks;
        }

        return null;
    }
    //调拨入库
}

 MES.Service/service/Warehouse/MesInvBusiness2Manager.cs

@@ -1,26 +1,23 @@
using SqlSugar;
using System;
using System.Collections.Generic;
using MES.Service.DB;
using MES.Service.DB;
using MES.Service.Modes;
using SqlSugar;

namespace MES.Service.service.Warehouse
{
namespace MES.Service.service.Warehouse;

public class MesInvBusiness2Manager : Repository<MesInvBusiness2>
{
 
    //当前类已经继承了 Repository å¢žã€åˆ ã€æŸ¥ã€æ”¹çš„方法

    //这里面写的代码不会给覆盖,如果要重新生成请删除 MesInvBusiness2Manager.cs


    #region æ•™å­¦æ–¹æ³•

    /// <summary>
    /// ä»“储方法满足不了复杂业务需求，业务代码请在这里面定义方法
    /// </summary>
    public void Study()
    {
	     
       /*********查询*********/

        var data1 = base.GetById(1);//根据ID查询
@@ -28,51 +25,54 @@
        var data3 = base.GetList(it => 1 == 1);  //根据条件查询  
        //var data4 = base.GetSingle(it => 1 == 1);//根据条件查询一条,如果超过一条会报错

        var p = new PageModel() { PageIndex = 1, PageSize = 2 };// åˆ†é¡µæŸ¥è¯¢
        var p = new PageModel { PageIndex = 1, PageSize = 2 }; // åˆ†é¡µæŸ¥è¯¢
        var data5 = base.GetPageList(it => 1 == 1, p);
        Console.Write(p.TotalCount);//返回总数

        var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom(), OrderByType.Asc);// åˆ†é¡µæŸ¥è¯¢åŠ æŽ’序
        var data6 =
            base.GetPageList(it => 1 == 1, p,
                it => SqlFunc.GetRandom()); // åˆ†é¡µæŸ¥è¯¢åŠ æŽ’序
        Console.Write(p.TotalCount);//返回总数
     
        List<IConditionalModel> conModels = new List<IConditionalModel>(); //组装条件查询作为条件实现 åˆ†é¡µæŸ¥è¯¢åŠ æŽ’序
        conModels.Add(new ConditionalModel() { FieldName= typeof(MesInvBusiness2).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" });//id=1
        var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc);
        var conModels = new List<IConditionalModel>(); //组装条件查询作为条件实现 åˆ†é¡µæŸ¥è¯¢åŠ æŽ’序
        conModels.Add(new ConditionalModel
        {
            FieldName = typeof(MesInvBusiness2).GetProperties()[0].Name,
            ConditionalType = ConditionalType.Equal, FieldValue = "1"
        }); //id=1
        var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom());

        base.AsQueryable().Where(x => 1 == 1).ToList();//支持了转换成queryable,我们可以用queryable实现复杂功能

        AsQueryable().Where(x => 1 == 1)
            .ToList(); //支持了转换成queryable,我们可以用queryable实现复杂功能
 

        /*********插入*********/
        var insertData = new MesInvBusiness2() { };//测试参数
        var insertArray = new MesInvBusiness2[] { insertData };
        var insertData = new MesInvBusiness2(); //测试参数
        var insertArray = new[] { insertData };
        base.Insert(insertData);//插入
        base.InsertRange(insertArray);//批量插入
        var id = base.InsertReturnIdentity(insertData);//插入返回自增列
        base.AsInsertable(insertData).ExecuteCommand();//我们可以转成 Insertable实现复杂插入

        AsInsertable(insertData).ExecuteCommand(); //我们可以转成 Insertable实现复杂插入


        /*********更新*********/
        var updateData = new MesInvBusiness2() {  };//测试参数
        var updateArray = new MesInvBusiness2[] { updateData };//测试参数
        var updateData = new MesInvBusiness2(); //测试参数
        var updateArray = new[] { updateData }; //测试参数
        base.Update(updateData);//根据实体更新
        base.UpdateRange(updateArray);//批量更新
        //base.Update(it => new MesInvBusiness2() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ›´æ–°ClassName列和CreateTime列，其它列不更新，条件id=1
        base.AsUpdateable(updateData).ExecuteCommand();  //转成Updateable可以实现复杂的插入

        AsUpdateable(updateData).ExecuteCommand(); //转成Updateable可以实现复杂的插入


        /*********删除*********/
        var deldata = new MesInvBusiness2() {  };//测试参数
        var deldata = new MesInvBusiness2(); //测试参数
        base.Delete(deldata);//根据实体删除
        base.DeleteById(1);//根据主键删除
        base.DeleteById(new int[] { 1,2});//根据主键数组删除
        base.DeleteById(new[] { 1, 2 }); //根据主键数组删除
        base.Delete(it=>1==2);//根据条件删除
        base.AsDeleteable().Where(it=>1==2).ExecuteCommand();//转成Deleteable实现复杂的操作
        AsDeleteable().Where(it => 1 == 2)
            .ExecuteCommand(); //转成Deleteable实现复杂的操作
    } 

    #endregion

 
 }
}

 MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs

 MES.Service/service/Warehouse/MesInvItemMovesCDetailsManager.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,79 @@
using MES.Service.DB;
using MES.Service.Modes;
using SqlSugar;

namespace MES.Service.service.Warehouse;

public class
    MesInvItemMovesCDetailsManager : Repository<MesInvItemMovesCDetails>
{
    //当前类已经继承了 Repository å¢žã€åˆ ã€æŸ¥ã€æ”¹çš„方法

    //这里面写的代码不会给覆盖,如果要重新生成请删除 MesInvItemMovesCDetailsManager.cs


    #region æ•™å­¦æ–¹æ³•

    /// <summary>
    ///     ä»“储方法满足不了复杂业务需求，业务代码请在这里面定义方法
    /// </summary>
    public void Study()
    {
        /*********查询*********/

        var data1 = base.GetById(1); //根据ID查询
        var data2 = base.GetList(); //查询所有
        var data3 = base.GetList(it => 1 == 1); //根据条件查询  
        //var data4 = base.GetSingle(it => 1 == 1);//根据条件查询一条,如果超过一条会报错

        var p = new PageModel { PageIndex = 1, PageSize = 2 }; // åˆ†é¡µæŸ¥è¯¢
        var data5 = base.GetPageList(it => 1 == 1, p);
        Console.Write(p.TotalCount); //返回总数

        var data6 =
            base.GetPageList(it => 1 == 1, p,
                it => SqlFunc.GetRandom()); // åˆ†é¡µæŸ¥è¯¢åŠ æŽ’序
        Console.Write(p.TotalCount); //返回总数

        var conModels = new List<IConditionalModel>(); //组装条件查询作为条件实现 åˆ†é¡µæŸ¥è¯¢åŠ æŽ’序
        conModels.Add(new ConditionalModel
        {
            FieldName = typeof(MesInvItemMovesCDetails).GetProperties()[0].Name,
            ConditionalType = ConditionalType.Equal, FieldValue = "1"
        }); //id=1
        var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom());

        AsQueryable().Where(x => 1 == 1)
            .ToList(); //支持了转换成queryable,我们可以用queryable实现复杂功能


        /*********插入*********/
        var insertData = new MesInvItemMovesCDetails(); //测试参数
        var insertArray = new[] { insertData };
        base.Insert(insertData); //插入
        base.InsertRange(insertArray); //批量插入
        var id = base.InsertReturnIdentity(insertData); //插入返回自增列
        AsInsertable(insertData).ExecuteCommand(); //我们可以转成 Insertable实现复杂插入


        /*********更新*********/
        var updateData = new MesInvItemMovesCDetails(); //测试参数
        var updateArray = new[] { updateData }; //测试参数
        base.Update(updateData); //根据实体更新
        base.UpdateRange(updateArray); //批量更新
        //base.Update(it => new MesInvItemMovesCDetails() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ›´æ–°ClassName列和CreateTime列，其它列不更新，条件id=1
        AsUpdateable(updateData).ExecuteCommand(); //转成Updateable可以实现复杂的插入


        /*********删除*********/
        var deldata = new MesInvItemMovesCDetails(); //测试参数
        base.Delete(deldata); //根据实体删除
        base.DeleteById(1); //根据主键删除
        base.DeleteById(new[] { 1, 2 }); //根据主键数组删除
        base.Delete(it => 1 == 2); //根据条件删除
        AsDeleteable().Where(it => 1 == 2)
            .ExecuteCommand(); //转成Deleteable实现复杂的操作
    }

    #endregion
}

 MES.Service/service/Warehouse/MesInvItemMovesManager.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,45 @@
using MES.Service.DB;
using MES.Service.Dto.service;
using MES.Service.Modes;
using SqlSugar;

namespace MES.Service.service.Warehouse;

public class MesInvItemMovesManager : Repository<MesInvItemMoves>
{
    //当前类已经继承了 Repository å¢žã€åˆ ã€æŸ¥ã€æ”¹çš„方法

    //这里面写的代码不会给覆盖,如果要重新生成请删除 MesInvItemMovesManager.cs

    public List<MesInvItemMoves> GetBillNo(WarehouseQuery query)
    {
        query.Factory = "1000";
        query.Company = "1000";

        return Db.Queryable<MesInvItemMoves>()
            .Where(it =>
                SqlFunc.IsNull(it.Status, 0) == 1 &&
                SqlFunc.IsNull(it.Ts, 0) != 1)
            .Where(it =>
                it.Factory == query.Factory && it.Company == query.Company)
            .OrderBy(it => it.Id, OrderByType.Desc).ToList();
    }

    //scan_out_show_DB
    public List<InventoryItem> ScanOutShowDb(WarehouseQuery query)
    {
        var BillTypeId = 300;
        var TransctionNo = 301;
        query.Factory = "1000";
        query.Company = "1000";

        var sql = string.Format(
            "select f_get_sections_code({0}, {1}, b.item_no)                       sections_code , s.erp_item_no , S.ITEM_MODEL , to_char(nvl(b.quantity, 0) - nvl(quantity_ok, 0), 'FM9999999990.00') flist from mes_inv_item_moves a join mes_inv_item_out_items b on b.item_out_id = a.id join mes_items s on b.item_no = s.item_no left join (select ITEM_MOVE_ID, item_no, sum(quantity) quantity_ok             from MES_INV_ITEM_MOVES_C_DETAILS group by ITEM_MOVE_ID, item_no) c                    on c.ITEM_MOVE_ID = a.id and b.item_no = c.item_no where 1 = 1 and a.bill_type_id = {2} and a.transaction_no = {3} and a.bill_no = {4} and nvl(b.quantity, 0) - nvl(quantity_ok, 0) > 0   and rownum < 500   AND A.STATUS = 1 order by f_get_sections_code({0}, {1}, b.item_no), s.erp_item_no ",
            query.Factory, query.Company, BillTypeId, TransctionNo,
            query.billNo);

        var results = Db.Ado.SqlQuery<InventoryItem>(sql);

        return results;
    }
}

 MES.Service/service/Warehouse/OpeningReceiptServer.cs

@@ -18,37 +18,26 @@
    public MesInvItemBarcodes ScanInBarcodeQC(WarehouseQuery query)
    {
        if (string.IsNullOrWhiteSpace(query.sectionCode))
        {
            throw new Exception("请扫库位条码！");
        }

        var depotCode = GetDepotCode(query.sectionCode);
        if (depotCode == null)
        {
            throw new Exception($"002[库位编码 {query.sectionCode} ä¸å­˜åœ¨ï¼Œè¯·ç¡®è®¤ï¼");
        }

        var checkBarcodeAlreadyReceived =
            CheckBarcodeAlreadyReceived(query.barcode);

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

        if (CheckBarcodeInStock(query.barcode) > 0)
        {
            throw new Exception("条码已在库存中，请核对！");
        }

        var barcodeInfo = GetBarcodeInfo(query.barcode);
        if (barcodeInfo == null || barcodeInfo.ComeFlg != 0)
        {
            throw new Exception("条码不是期初条码，无法用期初入库！");
        }

        var inventoryItemInId = GetOrCreateInventoryItemInId(barcodeInfo,
            depotCode, query.userName, out string billNo);
            depotCode, query.userName, out var billNo);

        UseTransaction(db =>
        {
@@ -71,15 +60,12 @@
        var mesInvItemBarcodes = Db.Queryable<MesInvItemBarcodes>()
            .Where(s => s.ItemBarcode == query.barcode).Count();

        if (mesInvItemBarcodes <= 0)
        {
            throw new Exception("条码不存在");
        }
        if (mesInvItemBarcodes <= 0) throw new Exception("条码不存在");

        var mesInvItemInCDetails = Db.Queryable<MesInvItemInCDetails>()
            .Where(s => s.ItemBarcode == query.barcode).Single();

        PurchaseInventory entity = new PurchaseInventory
        var entity = new PurchaseInventory
        {
            ItemIns = GetMesInvItemIns(mesInvItemInCDetails.ItemInId),
            InvItemInCDetails =
@@ -153,10 +139,7 @@
            TaskNo = barcodeInfo.TaskNo
        }).ExecuteCommand();

        if (executeCommand <= 0)
        {
            throw new Exception("写入失败");
        }
        if (executeCommand <= 0) throw new Exception("写入失败");
    }

    private decimal GetOrCreateInventoryItemInId(MesInvItemBarcodes barcodeInfo,
@@ -264,10 +247,7 @@
            SuppNo = barcodeInfo.SuppNo
        }).ExecuteCommand();

        if (executeCommand <= 0)
        {
            throw new Exception("写入失败");
        }
        if (executeCommand <= 0) throw new Exception("写入失败");
    }

    private void InsertBusinessRecord(MesInvItemBarcodes barcodeInfo,
@@ -300,9 +280,6 @@
            SuppNo = barcodeInfo.SuppNo
        }).ExecuteCommand();

        if (executeCommand <= 0)
        {
            throw new Exception("写入失败");
        }
        if (executeCommand <= 0) throw new Exception("写入失败");
    }
}

 MESApplication/Controllers/Warehouse/MesDepotSectionsController.cs

@@ -16,6 +16,48 @@

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

    //ScanInDepotSectionsName
    [HttpPost("ScanInDepotSectionsName")]
    public ResponseResult ScanInDepotSectionsName(WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.ScanInDepotSectionsName(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    //ScanEditBarcode
    [HttpPost("ScanEditBarcode")]
    public ResponseResult ScanEditBarcode(WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.ScanEditBarcode(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }

    //GetSectionName
    [HttpPost("GetSectionName")]
    public ResponseResult GetSectionName(WarehouseQuery query)

 MESApplication/Controllers/Warehouse/MesInvBusiness2Controller.cs

@@ -1,24 +1,16 @@
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Logging;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using System.Dynamic;
using System.Dynamic;
using MES.Service.Modes;
using MES.Service.service;
using MES.Service.service.Warehouse;
using MES.Service.util;
using Microsoft.AspNetCore.Mvc;

namespace MESApplication.Controllers.Warehouse
{
namespace MESApplication.Controllers.Warehouse;

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


        /***进入模版管理可以修改模版***/
@@ -119,6 +111,7 @@
                return ResponseResult.ResponseError(ex);
            }
        }

        /// <summary>
        /// æ·»åŠ è¿”回自增
        /// </summary>
@@ -164,7 +157,6 @@
            catch (Exception ex)
            {
                return ResponseResult.ResponseError(ex);
            }
        }
    }
}

 MESApplication/Controllers/Warehouse/MesInvItemMovesCDetailsController.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,163 @@
using System.Dynamic;
using MES.Service.Modes;
using MES.Service.service.Warehouse;
using MES.Service.util;
using Microsoft.AspNetCore.Mvc;

namespace MESApplication.Controllers.Warehouse;

[ApiController]
[Route("api/[controller]")]
public class MesInvItemMovesCDetailsController : ControllerBase
{
    private readonly MesInvItemMovesCDetailsManager 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] MesInvItemMovesCDetails 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] MesInvItemMovesCDetails 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] MesInvItemMovesCDetails 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);
        }
    }
}

 MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs

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

namespace MESApplication.Controllers.Warehouse;

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

    // GetBillNo
    [HttpPost("GetBillNo")]
    public ResponseResult GetBillNo(WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.GetBillNo(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }
    
    //ScanOutShowDb
    [HttpPost("ScanOutShowDb")]
    public ResponseResult ScanOutShowDb(WarehouseQuery query)
    {
        try
        {
            dynamic resultInfos = new ExpandoObject();
            resultInfos.tbBillList = m.GetBillNo(query);
            return new ResponseResult
            {
                status = 0,
                message = "OK",
                data = resultInfos
            };
        }
        catch (Exception ex)
        {
            return ResponseResult.ResponseError(ex);
        }
    }


    /// <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] MesInvItemMoves 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] MesInvItemMoves 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] MesInvItemMoves 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);
        }
    }
}

 MESApplication/Controllers/Warehouse/OpeningReceiptController.cs