合并上格最新代码

展杰

2024-08-16 3dfa3d93337cca6363b0e138c74f80af96431b83

 MES.Service/Modes/MesInvBusiness2.cs

@@ -1,194 +1,227 @@
using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace MES.Service.Modes
using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     库存交易记录表
/// </summary>
[SugarTable("MES_INV_BUSINESS2")]
public class MesInvBusiness2
{
    /// <summary>
    /// 库存交易记录表
    ///</summary>
    [SugarTable("MES_INV_BUSINESS2")]
    public class MesInvBusiness2
    {
        /// <summary>
        /// ID(seq_inv_id) 
        ///</summary>
         [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; }
    }
}
   /// <summary>
   ///     ID(seq_inv_id)
   /// </summary>
   [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; }
}