啊鑫
18 小时以前 ed05efdc17aab076146b134ebe105b6382f221d7
MES.Service/Modes/MesInvItemInCDetails2.cs
@@ -1,304 +1,358 @@
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_ITEM_IN_C_DETAILS2")]
public class MesInvItemInCDetails2
{
    /// <summary>
    /// 物料成品入库申请条码明细
    ///</summary>
    [SugarTable("MES_INV_ITEM_IN_C_DETAILS2")]
    public class MesInvItemInCDetails2
    {
        /// <summary>
        /// SEQ_OUT
        ///</summary>
         [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true   )]
         public decimal Id { get; set; }
        /// <summary>
        /// 入库单id
        ///</summary>
         [SugarColumn(ColumnName="ITEM_IN_ID" ,IsPrimaryKey = true   )]
         public decimal ItemInId { get; set; }
        /// <summary>
        /// 物料条码PSN
        ///</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="C_ITEM_BARCODE"    )]
         public string? CItemBarcode { 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>
        /// 环保标志(0-非环保,1-环保.无条码手工录入,有条码为冗余字段)
        ///</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>
        /// 作业方式0-有线条码枪1-无线条码枪
        ///</summary>
         [SugarColumn(ColumnName="WORK_TYPE"    )]
         public decimal? WorkType { 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>
        /// 是否共管物料(0:否,1:是)
        ///</summary>
         [SugarColumn(ColumnName="COMANAGEMENT_FLAG"    )]
         public short? ComanagementFlag { get; set; }
        /// <summary>
        /// 客户编码
        ///</summary>
         [SugarColumn(ColumnName="CUST_NO"    )]
         public string? CustNo { get; set; }
        /// <summary>
        /// 检验结果
        ///</summary>
         [SugarColumn(ColumnName="CHECK_RES"    )]
         public string? CheckRes { get; set; }
        /// <summary>
        /// 进货数量
        ///</summary>
         [SugarColumn(ColumnName="CHECK_QTY"    )]
         public decimal? CheckQty { get; set; }
        /// <summary>
        /// 检验状态
        ///</summary>
         [SugarColumn(ColumnName="CHECK_STATES"    )]
         public string? CheckStates { get; set; }
        /// <summary>
        /// 强制入库标记0无,1-强制入库  退料单使用
        ///</summary>
         [SugarColumn(ColumnName="FORCE_IN_FLAG"    )]
         public short? ForceInFlag { get; set; }
        /// <summary>
        /// 仓库编码
        ///</summary>
         [SugarColumn(ColumnName="DEPOT_CODE"    )]
         public string? DepotCode { get; set; }
        /// <summary>
        /// 货位编码
        ///</summary>
         [SugarColumn(ColumnName="DEPOT_SECTION_CODE"    )]
         public string? DepotSectionCode { get; set; }
        /// <summary>
        /// 特记事项
        ///</summary>
         [SugarColumn(ColumnName="REMARK"    )]
         public string? Remark { 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="USE_QTY"    )]
         public decimal? UseQty { get; set; }
        /// <summary>
        /// 领料数量
        ///</summary>
         [SugarColumn(ColumnName="OUT_QTY"    )]
         public decimal? OutQty { get; set; }
        /// <summary>
        /// 物料简称
        ///</summary>
         [SugarColumn(ColumnName="ITEM_SNAME"    )]
         public string? ItemSname { get; set; }
        /// <summary>
        /// 档位低值
        ///</summary>
         [SugarColumn(ColumnName="SPOSTION"    )]
         public decimal? Spostion { get; set; }
        /// <summary>
        /// 档位高值
        ///</summary>
         [SugarColumn(ColumnName="EPOSTION"    )]
         public decimal? Epostion { get; set; }
        /// <summary>
        /// 检验日期
        ///</summary>
         [SugarColumn(ColumnName="CHECK_DATE"    )]
         public DateTime? CheckDate { get; set; }
        /// <summary>
        /// 单位
        ///</summary>
         [SugarColumn(ColumnName="UNIT"    )]
         public string? Unit { get; set; }
        /// <summary>
        /// 是否检验
        ///</summary>
         [SugarColumn(ColumnName="ISCHECK"    )]
         public decimal? Ischeck { get; set; }
        /// <summary>
        /// 采购订单
        ///</summary>
         [SugarColumn(ColumnName="EBELN"    )]
         public string? Ebeln { get; set; }
        /// <summary>
        /// 生产日期
        ///</summary>
         [SugarColumn(ColumnName="LOT_DATE"    )]
         public string? LotDate { get; set; }
        /// <summary>
        /// 入库单号
        ///</summary>
         [SugarColumn(ColumnName="BILL_NO"    )]
         public string? BillNo { get; set; }
        /// <summary>
        /// 入库审核标志
        ///</summary>
         [SugarColumn(ColumnName="STOCK_OK"    )]
         public short? StockOk { 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="CB_NO"    )]
         public string? CbNo { get; set; }
        /// <summary>
        /// 箱号
        ///</summary>
         [SugarColumn(ColumnName="BOX_NO"    )]
         public string? BoxNo { get; set; }
        /// <summary>
        /// 仓库ID
        ///</summary>
         [SugarColumn(ColumnName="DEPOT_ID"    )]
         public decimal? DepotId { get; set; }
        /// <summary>
        /// 货位ID
        ///</summary>
         [SugarColumn(ColumnName="DEPOT_SECTION_ID"    )]
         public decimal? DepotSectionId { get; set; }
        /// <summary>
        /// 行号
        ///</summary>
         [SugarColumn(ColumnName="LINE_NUM"    )]
         public string? LineNum { get; set; }
        /// <summary>
        /// 扫码数量
        ///</summary>
         [SugarColumn(ColumnName="SM_QTY"    )]
         public decimal? SmQty { get; set; }
        /// <summary>
        /// 销售订单
        ///</summary>
         [SugarColumn(ColumnName="VGBEL"    )]
         public string? Vgbel { get; set; }
        /// <summary>
        /// 销售订单行号
        ///</summary>
         [SugarColumn(ColumnName="KDPOS"    )]
         public decimal? Kdpos { get; set; }
        /// <summary>
        /// 任务单号
        ///</summary>
         [SugarColumn(ColumnName="WORK_NO"    )]
         public string? WorkNo { get; set; }
        /// <summary>
        /// 行号
        ///</summary>
         [SugarColumn(ColumnName="EBELN_LINE_NO"    )]
         public decimal? EbelnLineNo { get; set; }
        /// <summary>
        /// 到货单号
        ///</summary>
         [SugarColumn(ColumnName="CBILL_NO"    )]
         public string? CbillNo { get; set; }
        /// <summary>
        /// 急料标识
        ///</summary>
         [SugarColumn(ColumnName="URGENT_FLAG"    )]
         public decimal? UrgentFlag { get; set; }
        /// <summary>
        /// 产品型号
        ///</summary>
         [SugarColumn(ColumnName="BOARD_STYLE"    )]
         public string? BoardStyle { get; set; }
        /// <summary>
        /// 任务单行号
        ///</summary>
         [SugarColumn(ColumnName="WORK_LINE"    )]
         public decimal? WorkLine { get; set; }
        /// <summary>
        /// 生产工单
        ///</summary>
         [SugarColumn(ColumnName="TASK_NO"    )]
         public string? TaskNo { get; set; }
        /// <summary>
        /// 供应商
        ///</summary>
         [SugarColumn(ColumnName="SUPP_NO"    )]
         public string? SuppNo { get; set; }
        /// <summary>
        /// 任务汇报单
        ///</summary>
         [SugarColumn(ColumnName="RBILL_NO"    )]
         public string? RbillNo { get; set; }
        /// <summary>
        /// 物料ID
        ///</summary>
         [SugarColumn(ColumnName="ITEM_ID"    )]
         public decimal? ItemId { get; set; }
    }
}
 /// <summary>
 ///     SEQ_OUT
 /// </summary>
 [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
    public decimal Id { get; set; }
 /// <summary>
 ///     入库单id
 /// </summary>
 [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)]
    public decimal ItemInId { get; set; }
 /// <summary>
 ///     物料条码PSN
 /// </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 = "C_ITEM_BARCODE")]
    public string? CItemBarcode { 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>
 ///     环保标志(0-非环保,1-环保.无条码手工录入,有条码为冗余字段)
 /// </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>
 ///     作业方式0-有线条码枪1-无线条码枪
 /// </summary>
 [SugarColumn(ColumnName = "WORK_TYPE")]
    public decimal? WorkType { 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>
 ///     是否共管物料(0:否,1:是)
 /// </summary>
 [SugarColumn(ColumnName = "COMANAGEMENT_FLAG")]
    public short? ComanagementFlag { get; set; }
 /// <summary>
 ///     客户编码
 /// </summary>
 [SugarColumn(ColumnName = "CUST_NO")]
    public string? CustNo { get; set; }
 /// <summary>
 ///     检验结果
 /// </summary>
 [SugarColumn(ColumnName = "CHECK_RES")]
    public string? CheckRes { get; set; }
 /// <summary>
 ///     进货数量
 /// </summary>
 [SugarColumn(ColumnName = "CHECK_QTY")]
    public decimal? CheckQty { get; set; }
 /// <summary>
 ///     检验状态
 /// </summary>
 [SugarColumn(ColumnName = "CHECK_STATES")]
    public string? CheckStates { get; set; }
 /// <summary>
 ///     强制入库标记0无,1-强制入库  退料单使用
 /// </summary>
 [SugarColumn(ColumnName = "FORCE_IN_FLAG")]
    public short? ForceInFlag { get; set; }
 /// <summary>
 ///     仓库编码
 /// </summary>
 [SugarColumn(ColumnName = "DEPOT_CODE")]
    public string? DepotCode { get; set; }
 /// <summary>
 ///     货位编码
 /// </summary>
 [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
    public string? DepotSectionCode { get; set; }
 /// <summary>
 ///     特记事项
 /// </summary>
 [SugarColumn(ColumnName = "REMARK")]
    public string? Remark { 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 = "USE_QTY")]
    public decimal? UseQty { get; set; }
 /// <summary>
 ///     领料数量
 /// </summary>
 [SugarColumn(ColumnName = "OUT_QTY")]
    public decimal? OutQty { get; set; }
 /// <summary>
 ///     物料简称
 /// </summary>
 [SugarColumn(ColumnName = "ITEM_SNAME")]
    public string? ItemSname { get; set; }
 /// <summary>
 ///     档位低值
 /// </summary>
 [SugarColumn(ColumnName = "SPOSTION")]
    public decimal? Spostion { get; set; }
 /// <summary>
 ///     档位高值
 /// </summary>
 [SugarColumn(ColumnName = "EPOSTION")]
    public decimal? Epostion { get; set; }
 /// <summary>
 ///     检验日期
 /// </summary>
 [SugarColumn(ColumnName = "CHECK_DATE")]
    public DateTime? CheckDate { get; set; }
 /// <summary>
 ///     单位
 /// </summary>
 [SugarColumn(ColumnName = "UNIT")]
    public string? Unit { get; set; }
 /// <summary>
 ///     是否检验
 /// </summary>
 [SugarColumn(ColumnName = "ISCHECK")]
    public decimal? Ischeck { get; set; }
 /// <summary>
 ///     采购订单
 /// </summary>
 [SugarColumn(ColumnName = "EBELN")]
    public string? Ebeln { get; set; }
 /// <summary>
 ///     生产日期
 /// </summary>
 [SugarColumn(ColumnName = "LOT_DATE")]
    public string? LotDate { get; set; }
 /// <summary>
 ///     入库单号
 /// </summary>
 [SugarColumn(ColumnName = "BILL_NO")]
    public string? BillNo { get; set; }
 /// <summary>
 ///     入库审核标志
 /// </summary>
 [SugarColumn(ColumnName = "STOCK_OK")]
    public short? StockOk { 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 = "CB_NO")]
    public string? CbNo { get; set; }
 /// <summary>
 ///     箱号
 /// </summary>
 [SugarColumn(ColumnName = "BOX_NO")]
    public string? BoxNo { get; set; }
 /// <summary>
 ///     仓库ID
 /// </summary>
 [SugarColumn(ColumnName = "DEPOT_ID")]
    public decimal? DepotId { get; set; }
 /// <summary>
 ///     货位ID
 /// </summary>
 [SugarColumn(ColumnName = "DEPOT_SECTION_ID")]
    public decimal? DepotSectionId { get; set; }
 /// <summary>
 ///     行号
 /// </summary>
 [SugarColumn(ColumnName = "LINE_NUM")]
    public string? LineNum { get; set; }
 /// <summary>
 ///     扫码数量
 /// </summary>
 [SugarColumn(ColumnName = "SM_QTY")]
    public decimal? SmQty { get; set; }
 /// <summary>
 ///     销售订单
 /// </summary>
 [SugarColumn(ColumnName = "VGBEL")]
    public string? Vgbel { get; set; }
 /// <summary>
 ///     销售订单行号
 /// </summary>
 [SugarColumn(ColumnName = "KDPOS")]
    public decimal? Kdpos { get; set; }
 /// <summary>
 ///     任务单号
 /// </summary>
 [SugarColumn(ColumnName = "WORK_NO")]
    public string? WorkNo { get; set; }
 /// <summary>
 ///     行号
 /// </summary>
 [SugarColumn(ColumnName = "EBELN_LINE_NO")]
    public decimal? EbelnLineNo { get; set; }
 /// <summary>
 ///     到货单号
 /// </summary>
 [SugarColumn(ColumnName = "CBILL_NO")]
    public string? CbillNo { get; set; }
 /// <summary>
 ///     急料标识
 /// </summary>
 [SugarColumn(ColumnName = "URGENT_FLAG")]
    public decimal? UrgentFlag { get; set; }
 /// <summary>
 ///     产品型号
 /// </summary>
 [SugarColumn(ColumnName = "BOARD_STYLE")]
    public string? BoardStyle { get; set; }
 /// <summary>
 ///     任务单行号
 /// </summary>
 [SugarColumn(ColumnName = "WORK_LINE")]
    public decimal? WorkLine { get; set; }
 /// <summary>
 ///     生产工单
 /// </summary>
 [SugarColumn(ColumnName = "TASK_NO")]
    public string? TaskNo { get; set; }
 /// <summary>
 ///     供应商
 /// </summary>
 [SugarColumn(ColumnName = "SUPP_NO")]
    public string? SuppNo { get; set; }
 /// <summary>
 ///     任务汇报单
 /// </summary>
 [SugarColumn(ColumnName = "RBILL_NO")]
    public string? RbillNo { get; set; }
 /// <summary>
 ///     物料ID
 /// </summary>
 [SugarColumn(ColumnName = "ITEM_ID")]
    public decimal? ItemId { get; set; }
}