合并上格最新代码

展杰

2024-08-16 3dfa3d93337cca6363b0e138c74f80af96431b83

 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; }
    }
}