~tjx/NewPdaSqlServer.git

			@@ -1,319 +1,397 @@
			using SqlSugar;

			namespace NewPdaSqlServer.entity
			namespace NewPdaSqlServer.entity;

			/// <summary>
			/// 物料入库条码明细
			/// </summary>
			[SugarTable("MES_INV_ITEM_IN_C_DETAILS")]
			public class MesInvItemInCDetails
			{
			/// <summary>
			/// 物料入库条码明细
			///</summary>
			[SugarTable("MES_INV_ITEM_IN_C_DETAILS")]
			public class MesInvItemInCDetails
			{
			/// <summary>
			///
			/// 默认值: (newid())
			///</summary>
			[SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
			public Guid Guid { get; set; }
			/// <summary>
			/// 入库单id
			///</summary>
			[SugarColumn(ColumnName="ITEM_IN_ID" )]
			public long? 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:无条码)
			/// 默认值: ((1))
			///</summary>
			[SugarColumn(ColumnName="BARCODE_FLAG" )]
			public bool? BarcodeFlag { get; set; }
			/// <summary>
			/// 环保标志（0-非环保,1-环保.无条码手工录入，有条码为冗余字段）
			/// 默认值: ((1))
			///</summary>
			[SugarColumn(ColumnName="EP_FLAG" )]
			public bool? 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 long? 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:是)
			/// 默认值: ((0))
			///</summary>
			[SugarColumn(ColumnName="COMANAGEMENT_FLAG" )]
			public bool? 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-强制入库退料单使用
			/// 默认值: ((0))
			///</summary>
			[SugarColumn(ColumnName="FORCE_IN_FLAG" )]
			public bool? 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 int? Spostion { get; set; }
			/// <summary>
			/// 结束位置
			///</summary>
			[SugarColumn(ColumnName="EPOSTION" )]
			public int? 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>
			/// 是否检验
			/// 默认值: ((0))
			///</summary>
			[SugarColumn(ColumnName="ISCHECK" )]
			public bool? 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>
			/// 是否入库成功
			/// 默认值: ((0))
			///</summary>
			[SugarColumn(ColumnName="STOCK_OK" )]
			public bool? StockOk { get; set; }
			/// <summary>
			/// 工厂
			///</summary>
			[SugarColumn(ColumnName="FACTORY" )]
			public string Factory { get; set; }
			/// <summary>
			/// 公司
			///</summary>
			[SugarColumn(ColumnName="COMPANY" )]
			public string Company { get; set; }
			/// <summary>
			/// CB单号
			///</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 long? DepotId { get; set; }
			/// <summary>
			/// 货位ID
			///</summary>
			[SugarColumn(ColumnName="DEPOT_SECTION_ID" )]
			public long? 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 long? Kdpos { get; set; }
			/// <summary>
			/// 作业单号
			///</summary>
			[SugarColumn(ColumnName="WORK_NO" )]
			public string WorkNo { get; set; }
			/// <summary>
			/// 行号
			///</summary>
			[SugarColumn(ColumnName="EBELN_LINE_NO" )]
			public long? EbelnLineNo { get; set; }
			/// <summary>
			/// CB单号
			///</summary>
			[SugarColumn(ColumnName="CBILL_NO" )]
			public string CbillNo { get; set; }
			/// <summary>
			/// 紧急标记
			///</summary>
			[SugarColumn(ColumnName="URGENT_FLAG" )]
			public bool? UrgentFlag { get; set; }
			/// <summary>
			/// 板型
			///</summary>
			[SugarColumn(ColumnName="BOARD_STYLE" )]
			public string BoardStyle { get; set; }
			/// <summary>
			/// 工作行号
			///</summary>
			[SugarColumn(ColumnName="WORK_LINE" )]
			public int? 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>
			/// K3 采购单号
			///</summary>
			[SugarColumn(ColumnName="EBELN_K3ID" )]
			public long? EbelnK3id { get; set; }
			/// <summary>
			/// K3 行号
			///</summary>
			[SugarColumn(ColumnName="LINE_K3ID" )]
			public long? LineK3id { get; set; }
			/// <summary>
			/// 物料ID
			///</summary>
			[SugarColumn(ColumnName="ITEM_ID" )]
			public long? ItemId { get; set; }
			}
			}
			/// 默认值: (newid())
			/// </summary>
			[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
			public Guid Guid { get; set; }

			/// <summary>
			/// 入库单id
			/// </summary>
			[SugarColumn(ColumnName = "ITEM_IN_ID")]
			public Guid? 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:无条码)
			/// 默认值: ((1))
			/// </summary>
			[SugarColumn(ColumnName = "BARCODE_FLAG")]
			public bool? BarcodeFlag { get; set; }

			/// <summary>
			/// 环保标志（0-非环保,1-环保.无条码手工录入，有条码为冗余字段）
			/// 默认值: ((1))
			/// </summary>
			[SugarColumn(ColumnName = "EP_FLAG")]
			public bool? 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 long? 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:是)
			/// 默认值: ((0))
			/// </summary>
			[SugarColumn(ColumnName = "COMANAGEMENT_FLAG")]
			public bool? 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-强制入库退料单使用
			/// 默认值: ((0))
			/// </summary>
			[SugarColumn(ColumnName = "FORCE_IN_FLAG")]
			public bool? 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 int? Spostion { get; set; }

			/// <summary>
			/// 结束位置
			/// </summary>
			[SugarColumn(ColumnName = "EPOSTION")]
			public int? 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>
			/// 是否检验
			/// 默认值: ((0))
			/// </summary>
			[SugarColumn(ColumnName = "ISCHECK")]
			public bool? 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>
			/// 是否入库成功
			/// 默认值: ((0))
			/// </summary>
			[SugarColumn(ColumnName = "STOCK_OK")]
			public bool? StockOk { get; set; }

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

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

			/// <summary>
			/// CB单号
			/// </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 long? DepotId { get; set; }

			/// <summary>
			/// 货位ID
			/// </summary>
			[SugarColumn(ColumnName = "DEPOT_SECTION_ID")]
			public long? 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 long? Kdpos { get; set; }

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

			/// <summary>
			/// 行号
			/// </summary>
			[SugarColumn(ColumnName = "EBELN_LINE_NO")]
			public long? EbelnLineNo { get; set; }

			/// <summary>
			/// CB单号
			/// </summary>
			[SugarColumn(ColumnName = "CBILL_NO")]
			public string? CbillNo { get; set; }

			/// <summary>
			/// 紧急标记
			/// </summary>
			[SugarColumn(ColumnName = "URGENT_FLAG")]
			public bool? UrgentFlag { get; set; }

			/// <summary>
			/// 板型
			/// </summary>
			[SugarColumn(ColumnName = "BOARD_STYLE")]
			public string? BoardStyle { get; set; }

			/// <summary>
			/// 工作行号
			/// </summary>
			[SugarColumn(ColumnName = "WORK_LINE")]
			public int? 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>
			/// K3 采购单号
			/// </summary>
			[SugarColumn(ColumnName = "EBELN_K3ID")]
			public long? EbelnK3id { get; set; }

			/// <summary>
			/// K3 行号
			/// </summary>
			[SugarColumn(ColumnName = "LINE_K3ID")]
			public long? LineK3id { get; set; }

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

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

			/// <summary>
			/// 收料组织
			/// </summary>
			[SugarColumn(ColumnName = "ReceiveOrgId")]
			public string? ReceiveOrgId { get; set; }


			// 添加的字段，并且它们不属于数据库表
			[SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }

			[SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }

			[SugarColumn(IsIgnore = true)] public string? ItemUnit { get; set; }

			[SugarColumn(IsIgnore = true)] public decimal? SumQuantity { get; set; }
			}