1.条码表实体类型调整 2.条码库存表实体新增基础字段 3.期初入库新增入库人

南骏 池

2025-02-13 eda0c8f74ce453b6e43f88fc92b1e651ce5b6095

 entity/MesInvBusiness2.cs

@@ -1,238 +1,257 @@
using SqlSugar;

namespace NewPdaSqlServer.entity
namespace NewPdaSqlServer.entity;

/// <summary>
///     库存交易记录表
/// </summary>
[SugarTable("MES_INV_BUSINESS2")]
public class MesInvBusiness2
{
    /// <summary>
    /// 库存交易记录表
    ///</summary>
    [SugarTable("MES_INV_BUSINESS2")]
    public class MesInvBusiness2
    {
        /// <summary>
        /// ID(seq_inv_id) 
        /// 默认值: (newid())
        ///</summary>
        [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
        public Guid Guid { get; set; }
    ///     ID(seq_inv_id)
    ///     默认值: (newid())
    /// </summary>
    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
    public Guid Guid { get; set; }

        /// <summary>
        /// 状态|0-未交易1-已交易 
        ///</summary>
        [SugarColumn(ColumnName = "STATUS")]
        public long? Status { get; set; }
    /// <summary>
    ///     状态|0-未交易1-已交易
    /// </summary>
    [SugarColumn(ColumnName = "STATUS")]
    public long? Status { get; set; }

        /// <summary>
        /// 单据类型ID 
        ///</summary>
        [SugarColumn(ColumnName = "BILL_TYPE_ID")]
        public long? BillTypeId { get; set; }
    /// <summary>
    ///     单据类型ID
    /// </summary>
    [SugarColumn(ColumnName = "BILL_TYPE_ID")]
    public long? BillTypeId { get; set; }

        /// <summary>
        /// 事务类型编码 
        ///</summary>
        [SugarColumn(ColumnName = "TRANSACTION_CODE")]
        public string? TransactionCode { get; set; }
    /// <summary>
    ///     事务类型编码
    /// </summary>
    [SugarColumn(ColumnName = "TRANSACTION_CODE")]
    public string? TransactionCode { get; set; }

        /// <summary>
        /// 交易类型|1-入库0-转库-1出库 
        ///</summary>
        [SugarColumn(ColumnName = "BUSINESS_TYPE")]
        public long? BusinessType { get; set; }
    /// <summary>
    ///     交易类型|1-入库0-转库-1出库
    /// </summary>
    [SugarColumn(ColumnName = "BUSINESS_TYPE")]
    public long? BusinessType { get; set; }

        /// <summary>
        /// 单据ID 
        ///</summary>
        [SugarColumn(ColumnName = "BILL_ID")]
        public long? BillId { get; set; }
    /// <summary>
    ///     单据ID
    /// </summary>
    [SugarColumn(ColumnName = "BILL_ID")]
    public long? BillId { get; set; }

        /// <summary>
        /// 单据编码 
        ///</summary>
        [SugarColumn(ColumnName = "BILL_NO")]
        public string? BillNo { 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 = "TASK_NO")]
    public string? TaskNo { get; set; }

        /// <summary>
        /// 客户编号 
        ///</summary>
        [SugarColumn(ColumnName = "CUSTOMER_NO")]
        public string? CustomerNo { get; set; }
    /// <summary>
    ///     客户编号
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_NO")]
    public string? CustomerNo { get; set; }

        /// <summary>
        /// 单据行ID 
        ///</summary>
        [SugarColumn(ColumnName = "BILL_LINE_ID")]
        public long? BillLineId { get; set; }
    /// <summary>
    ///     单据行ID
    /// </summary>
    [SugarColumn(ColumnName = "BILL_LINE_ID")]
    public long? BillLineId { get; set; }

        /// <summary>
        /// 物料条码 
        ///</summary>
        [SugarColumn(ColumnName = "ITEM_BARCODE")]
        public string? ItemBarcode { 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 = "ITEM_NO")]
    public string? ItemNo { get; set; }

        /// <summary>
        /// 客户物料编码 
        ///</summary>
        [SugarColumn(ColumnName = "C_ITEM_CODE")]
        public string? CItemCode { 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>
    ///     厂家批次
    /// </summary>
    [SugarColumn(ColumnName = "LOT_NO")]
    public string? LotNo { get; set; }

        /// <summary>
        /// 是否环保(0:否,1:是) 
        ///</summary>
        [SugarColumn(ColumnName = "EP_FLAG")]
        public bool? EpFlag { get; set; }
    /// <summary>
    ///     是否环保(0:否,1:是)
    /// </summary>
    [SugarColumn(ColumnName = "EP_FLAG")]
    public bool? EpFlag { get; set; }

        /// <summary>
        /// 数量 
        ///</summary>
        [SugarColumn(ColumnName = "QUANTITY")]
        public decimal? Quantity { 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_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 = "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_DEPOTS_CODE")]
    public string? ToInvDepotsCode { get; set; }

        /// <summary>
        /// 目的货位CODE 
        ///</summary>
        [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")]
        public string? ToInvDepotSectionsCode { 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 = "DESCRIPTION")]
    public string? Description { get; set; }

        /// <summary>
        /// 创建人 
        ///</summary>
        [SugarColumn(ColumnName = "CREATE_BY")]
        public string? CreateBy { 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 = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; }

        /// <summary>
        /// 最后更新人 
        ///</summary>
        [SugarColumn(ColumnName = "LASTUPDATE_BY")]
        public string? LastupdateBy { 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 = "LASTUPDATE_DATE")]
    public DateTime? LastupdateDate { get; set; }

        /// <summary>
        /// 超损统计标识 
        /// 默认值: ((0))
        ///</summary>
        [SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")]
        public bool? UllageStatFlag { get; set; }
    /// <summary>
    ///     超损统计标识
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")]
    public bool? UllageStatFlag { get; set; }

        /// <summary>
        /// 分厂编码 
        ///</summary>
        [SugarColumn(ColumnName = "FACTORY")]
        public string? Factory { 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 = "COMPANY")]
    public string? Company { get; set; }

        /// <summary>
        /// 箱号条码 
        ///</summary>
        [SugarColumn(ColumnName = "ITEM_BARCODE2")]
        public string? ItemBarcode2 { 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 = "ITEM_BARCODE3")]
    public string? ItemBarcode3 { get; set; }

        /// <summary>
        /// 任务单号 
        ///</summary>
        [SugarColumn(ColumnName = "WORK_NO")]
        public string? WorkNo { get; set; }
    /// <summary>
    ///     任务单号
    /// </summary>
    [SugarColumn(ColumnName = "WORK_NO")]
    public string? WorkNo { get; set; }

        /// <summary>
        /// 任务单行号 
        ///</summary>
        [SugarColumn(ColumnName = "WORK_LINE")]
        public int? WorkLine { get; set; }
    /// <summary>
    ///     任务单行号
    /// </summary>
    [SugarColumn(ColumnName = "WORK_LINE")]
    public int? WorkLine { get; set; }

        /// <summary>
        /// 供应商 
        ///</summary>
        [SugarColumn(ColumnName = "SUPP_NO")]
        public string? SuppNo { 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>
    ///     生产线
    /// </summary>
    [SugarColumn(ColumnName = "LINE_NO")]
    public string? LineNo { get; set; }

        /// <summary>
        /// 采购订单id 
        ///</summary>
        [SugarColumn(ColumnName = "EBELN_K3ID")]
        public long? EbelnK3id { get; set; }
    /// <summary>
    ///     采购订单id
    /// </summary>
    [SugarColumn(ColumnName = "EBELN_K3ID")]
    public long? EbelnK3id { get; set; }

        /// <summary>
        /// 采购订单行id 
        ///</summary>
        [SugarColumn(ColumnName = "LINE_K3ID")]
        public long? LineK3id { get; set; }
    /// <summary>
    ///     采购订单行id
    /// </summary>
    [SugarColumn(ColumnName = "LINE_K3ID")]
    public long? LineK3id { get; set; }

        /// <summary>
        /// 物料ID 
        ///</summary>
        [SugarColumn(ColumnName = "ITEM_ID")]
        public long? ItemId { get; set; }
    /// <summary>
    ///     物料ID
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_ID")]
    public long? ItemId { get; set; }

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

    /// <summary>
    ///     源仓库ID
    /// </summary>
    [SugarColumn(ColumnName = "FROM_DEPOT_ID")]
    public int? FromDepotId { get; set; }

    /// <summary>
    ///     目的仓库ID
    /// </summary>
    [SugarColumn(ColumnName = "INV_DEPOT_ID")]
    public int? InvDepotId { get; set; }

    /// <summary>
    ///     mes单据明细行id
    /// </summary>
    [SugarColumn(ColumnName = "MES_LINE")]
    public Guid? MesLine { get; set; }
}