~tjx/NewPdaSqlServer.git

			@@ -1,391 +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; }
			/// 默认值: (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>
			/// 入库单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>
			/// 物料条码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_CODE")]
			public string? CItemCode { get; set; }

			/// <summary>
			/// 客户物料条码
			///</summary>
			[SugarColumn(ColumnName = "C_ITEM_BARCODE")]
			public string? CItemBarcode { 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>
			/// 验收数量
			/// </summary>
			[SugarColumn(ColumnName = "QUANTITY")]
			public decimal? Quantity { get; set; }

			/// <summary>
			/// 入库方式(1:有条码,0:无条码)
			/// 默认值: ((1))
			///</summary>
			[SugarColumn(ColumnName = "BARCODE_FLAG")]
			public bool? BarcodeFlag { 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>
			/// 环保标志（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_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-有线条码枪1-无线条码枪
			///</summary>
			[SugarColumn(ColumnName = "WORK_TYPE")]
			public long? WorkType { 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 = "ITEM_NO")]
			public string? ItemNo { 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:是)
			/// 默认值: ((0))
			///</summary>
			[SugarColumn(ColumnName = "COMANAGEMENT_FLAG")]
			public bool? ComanagementFlag { 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 = "CUST_NO")]
			public string? CustNo { get; set; }

			/// <summary>
			/// 检验结果
			///</summary>
			[SugarColumn(ColumnName = "CHECK_RES")]
			public string? CheckRes { 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_QTY")]
			public decimal? CheckQty { get; set; }

			/// <summary>
			/// 检验状态
			///</summary>
			[SugarColumn(ColumnName = "CHECK_STATES")]
			public string? CheckStates { 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>
			/// 强制入库标记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_CODE")]
			public string? DepotCode { get; set; }

			/// <summary>
			/// 货位编码
			///</summary>
			[SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
			public string? DepotSectionCode { 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 = "REMARK")]
			public string? Remark { 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 = "USE_QTY")]
			public decimal? UseQty { 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 = "OUT_QTY")]
			public decimal? OutQty { get; set; }

			/// <summary>
			/// 物料名称
			///</summary>
			[SugarColumn(ColumnName = "ITEM_SNAME")]
			public string? ItemSname { 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 = "SPOSTION")]
			public int? Spostion { get; set; }

			/// <summary>
			/// 结束位置
			///</summary>
			[SugarColumn(ColumnName = "EPOSTION")]
			public int? Epostion { 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 = "CHECK_DATE")]
			public DateTime? CheckDate { get; set; }
			/// <summary>
			/// 单位
			/// </summary>
			[SugarColumn(ColumnName = "UNIT")]
			public string? Unit { get; set; }

			/// <summary>
			/// 单位
			///</summary>
			[SugarColumn(ColumnName = "UNIT")]
			public string? Unit { get; set; }
			/// <summary>
			/// 是否检验
			/// 默认值: ((0))
			/// </summary>
			[SugarColumn(ColumnName = "ISCHECK")]
			public bool? Ischeck { 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 = "EBELN")]
			public string? Ebeln { get; set; }
			/// <summary>
			/// 批次日期
			/// </summary>
			[SugarColumn(ColumnName = "LOT_DATE")]
			public string? LotDate { 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 = "BILL_NO")]
			public string? BillNo { get; set; }
			/// <summary>
			/// 是否入库成功
			/// 默认值: ((0))
			/// </summary>
			[SugarColumn(ColumnName = "STOCK_OK")]
			public bool? StockOk { 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 = "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>
			/// CB单号
			/// </summary>
			[SugarColumn(ColumnName = "CB_NO")]
			public string? CbNo { 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>
			/// 箱号
			///</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_ID")]
			public long? DepotId { get; set; }
			/// <summary>
			/// 货位ID
			/// </summary>
			[SugarColumn(ColumnName = "DEPOT_SECTION_ID")]
			public long? DepotSectionId { 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 = "LINE_NUM")]
			public string? LineNum { get; set; }
			/// <summary>
			/// 扫描数量
			/// </summary>
			[SugarColumn(ColumnName = "SM_QTY")]
			public decimal? SmQty { 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 = "VGBEL")]
			public string? Vgbel { get; set; }
			/// <summary>
			/// 行号
			/// </summary>
			[SugarColumn(ColumnName = "KDPOS")]
			public long? Kdpos { 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 = "WORK_NO")]
			public string? WorkNo { get; set; }
			/// <summary>
			/// 行号
			/// </summary>
			[SugarColumn(ColumnName = "EBELN_LINE_NO")]
			public long? EbelnLineNo { 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>
			/// 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 = "URGENT_FLAG")]
			public bool? UrgentFlag { get; set; }
			/// <summary>
			/// 板型
			/// </summary>
			[SugarColumn(ColumnName = "BOARD_STYLE")]
			public string? BoardStyle { 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 = "WORK_LINE")]
			public int? WorkLine { 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 = "SUPP_NO")]
			public string? SuppNo { 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>
			/// 收货单号
			///</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 = "EBELN_K3ID")]
			public long? EbelnK3id { get; set; }
			/// <summary>
			/// K3 行号
			/// </summary>
			[SugarColumn(ColumnName = "LINE_K3ID")]
			public long? LineK3id { 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>
			/// 物料ID
			///</summary>
			[SugarColumn(ColumnName = "ITEM_ID")]
			public long? ItemId { get; set; }
			/// <summary>
			/// </summary>
			[SugarColumn(ColumnName = "SUPP_ID")]
			public string? SuppId { get; set; }

			[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? ItemName { get; set; }

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

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

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