~tjx/NewPdaSqlServer.git

			@@ -1,258 +1,300 @@
			using SqlSugar;

			namespace NewPdaSqlServer.entity
			namespace NewPdaSqlServer.entity;

			/// <summary>
			/// 采购订单表
			/// </summary>
			[SugarTable("MES_ROH_IN")]
			public class MesRohIn
			{
			/// <summary>
			/// 采购订单表
			///</summary>
			[SugarTable("MES_ROH_IN")]
			public class MesRohIn
			{
			/// <summary>
			/// 主键
			/// 默认值: (newid())
			///</summary>
			[SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
			public Guid Guid { get; set; }
			/// <summary>
			/// 采购单号
			///</summary>
			[SugarColumn(ColumnName="BILL_NO" )]
			public string BillNo { get; set; }
			/// <summary>
			/// 单据状态
			///</summary>
			[SugarColumn(ColumnName="DOCUMENT_STATUS" )]
			public string DocumentStatus { get; set; }
			/// <summary>
			/// 单据类型
			///</summary>
			[SugarColumn(ColumnName="DOCUMENT_TYPE" )]
			public string DocumentType { get; set; }
			/// <summary>
			/// 业务类型
			///</summary>
			[SugarColumn(ColumnName="BUSINESS_TYPE" )]
			public string BusinessType { get; set; }
			/// <summary>
			/// 采购日期
			///</summary>
			[SugarColumn(ColumnName="PURCHASE_DATE" )]
			public DateTime? PurchaseDate { get; set; }
			/// <summary>
			/// 供应商
			///</summary>
			[SugarColumn(ColumnName="SUPPLIER" )]
			public string Supplier { get; set; }
			/// <summary>
			/// 关闭状态
			///</summary>
			[SugarColumn(ColumnName="CLOSE_STATUS" )]
			public string CloseStatus { get; set; }
			/// <summary>
			/// 采购组织
			///</summary>
			[SugarColumn(ColumnName="PURCHASE_ORG" )]
			public string PurchaseOrg { get; set; }
			/// <summary>
			/// 采购部门
			///</summary>
			[SugarColumn(ColumnName="PURCHASE_DEPT" )]
			public string PurchaseDept { get; set; }
			/// <summary>
			/// 采购组
			///</summary>
			[SugarColumn(ColumnName="PURCHASE_GROUP" )]
			public string PurchaseGroup { get; set; }
			/// <summary>
			/// 数量验收
			///</summary>
			[SugarColumn(ColumnName="QTY_ACCEPTANCE" )]
			public string QtyAcceptance { get; set; }
			/// <summary>
			/// 采购员
			///</summary>
			[SugarColumn(ColumnName="PURCHASER" )]
			public string Purchaser { get; set; }
			/// <summary>
			/// 质量要求
			///</summary>
			[SugarColumn(ColumnName="QUALITY_REQ" )]
			public string QualityReq { get; set; }
			/// <summary>
			/// 结算方
			///</summary>
			[SugarColumn(ColumnName="SETTLEMENT_PARTY" )]
			public string SettlementParty { get; set; }
			/// <summary>
			/// 收款方
			///</summary>
			[SugarColumn(ColumnName="PAYMENT_PARTY" )]
			public string PaymentParty { get; set; }
			/// <summary>
			/// 邮箱
			///</summary>
			[SugarColumn(ColumnName="EMAIL" )]
			public string Email { get; set; }
			/// <summary>
			/// 运输方式
			///</summary>
			[SugarColumn(ColumnName="TRANSPORT_METHOD" )]
			public string TransportMethod { get; set; }
			/// <summary>
			/// 备注
			///</summary>
			[SugarColumn(ColumnName="REMARKS" )]
			public string Remarks { get; set; }
			/// <summary>
			/// 治具丶模具加工及采购
			///</summary>
			[SugarColumn(ColumnName="FIXTURE_MOLD_PROCUREMENT" )]
			public string FixtureMoldProcurement { get; set; }
			/// <summary>
			/// 作废状态
			///</summary>
			[SugarColumn(ColumnName="CANCELLATION_STATUS" )]
			public string CancellationStatus { get; set; }
			/// <summary>
			/// 作废人
			///</summary>
			[SugarColumn(ColumnName="CANCELLATION_PERSON" )]
			public string CancellationPerson { get; set; }
			/// <summary>
			/// 作废日期
			///</summary>
			[SugarColumn(ColumnName="CANCELLATION_DATE" )]
			public DateTime? CancellationDate { 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_DATE" )]
			public DateTime? LastupdateDate { get; set; }
			/// <summary>
			/// 最后修改人
			///</summary>
			[SugarColumn(ColumnName="LASTUPDATE_BY" )]
			public string LastupdateBy { get; set; }
			/// <summary>
			/// 审核人
			///</summary>
			[SugarColumn(ColumnName="ERP_CHECK_BY" )]
			public string ErpCheckBy { get; set; }
			/// <summary>
			/// 审核时间
			///</summary>
			[SugarColumn(ColumnName="ERP_CHECK_DATE" )]
			public string ErpCheckDate { get; set; }
			/// <summary>
			/// ERP的ID号
			///</summary>
			[SugarColumn(ColumnName="EBELN_K3ID" )]
			public long? EbelnK3id { get; set; }
			/// <summary>
			/// 审核日期
			///</summary>
			[SugarColumn(ColumnName="CHECK_DATE" )]
			public DateTime? CheckDate { get; set; }
			/// <summary>
			/// 审核人
			///</summary>
			[SugarColumn(ColumnName="CHECK_BY" )]
			public string CheckBy { get; set; }
			/// <summary>
			/// 审核标识
			///</summary>
			[SugarColumn(ColumnName="CHECK_FALG" )]
			public int? CheckFalg { get; set; }
			/// <summary>
			/// 打印次数
			///</summary>
			[SugarColumn(ColumnName="REMARK1" )]
			public string Remark1 { get; set; }
			/// <summary>
			/// 自定义字段2
			///</summary>
			[SugarColumn(ColumnName="REMARK2" )]
			public string Remark2 { get; set; }
			/// <summary>
			/// 自定义字段3
			///</summary>
			[SugarColumn(ColumnName="REMARK3" )]
			public string Remark3 { get; set; }
			/// <summary>
			/// 自定义字段4
			///</summary>
			[SugarColumn(ColumnName="REMARK4" )]
			public string Remark4 { get; set; }
			/// <summary>
			/// 自定义字段5
			///</summary>
			[SugarColumn(ColumnName="REMARK5" )]
			public string Remark5 { get; set; }
			/// <summary>
			///
			///</summary>
			[SugarColumn(ColumnName="CHANGEREASON" )]
			public string Changereason { 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="Prearrivaldate" )]
			public DateTime? Prearrivaldate { get; set; }
			/// <summary>
			///
			///</summary>
			[SugarColumn(ColumnName="ReceiveOrgId" )]
			public string ReceiveOrgId { get; set; }
			/// <summary>
			///
			///</summary>
			[SugarColumn(ColumnName="Provider_Id" )]
			public string ProviderId { get; set; }
			/// <summary>
			/// 联系人
			///</summary>
			[SugarColumn(ColumnName="anred" )]
			public string Anred { get; set; }
			/// <summary>
			/// 电话
			///</summary>
			[SugarColumn(ColumnName="telf1" )]
			public string Telf1 { get; set; }
			/// <summary>
			/// 固定电话
			///</summary>
			[SugarColumn(ColumnName="Fixed_Telephone" )]
			public string FixedTelephone { get; set; }
			/// <summary>
			/// 通讯地址
			///</summary>
			[SugarColumn(ColumnName="Address" )]
			public string Address { get; set; }
			/// <summary>
			/// 验收方式
			///</summary>
			[SugarColumn(ColumnName="Acctype" )]
			public string Acctype { get; set; }
			}
			}
			/// 主键
			/// 默认值: (newid())
			/// </summary>
			[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
			public Guid Guid { get; set; }

			/// <summary>
			/// 采购单号
			/// </summary>
			[SugarColumn(ColumnName = "BILL_NO")]
			public string? BillNo { get; set; }

			/// <summary>
			/// 单据状态
			/// </summary>
			[SugarColumn(ColumnName = "DOCUMENT_STATUS")]
			public string? DocumentStatus { get; set; }

			/// <summary>
			/// 单据类型
			/// </summary>
			[SugarColumn(ColumnName = "DOCUMENT_TYPE")]
			public string? DocumentType { get; set; }

			/// <summary>
			/// 业务类型
			/// </summary>
			[SugarColumn(ColumnName = "BUSINESS_TYPE")]
			public string? BusinessType { get; set; }

			/// <summary>
			/// 采购日期
			/// </summary>
			[SugarColumn(ColumnName = "PURCHASE_DATE")]
			public DateTime? PurchaseDate { get; set; }

			/// <summary>
			/// 供应商
			/// </summary>
			[SugarColumn(ColumnName = "SUPPLIER")]
			public string? Supplier { get; set; }

			/// <summary>
			/// 关闭状态
			/// </summary>
			[SugarColumn(ColumnName = "CLOSE_STATUS")]
			public string? CloseStatus { get; set; }

			/// <summary>
			/// 采购组织
			/// </summary>
			[SugarColumn(ColumnName = "PURCHASE_ORG")]
			public string? PurchaseOrg { get; set; }

			/// <summary>
			/// 采购部门
			/// </summary>
			[SugarColumn(ColumnName = "PURCHASE_DEPT")]
			public string? PurchaseDept { get; set; }

			/// <summary>
			/// 采购组
			/// </summary>
			[SugarColumn(ColumnName = "PURCHASE_GROUP")]
			public string? PurchaseGroup { get; set; }

			/// <summary>
			/// 数量验收
			/// </summary>
			[SugarColumn(ColumnName = "QTY_ACCEPTANCE")]
			public string? QtyAcceptance { get; set; }

			/// <summary>
			/// 采购员
			/// </summary>
			[SugarColumn(ColumnName = "PURCHASER")]
			public string? Purchaser { get; set; }

			/// <summary>
			/// 质量要求
			/// </summary>
			[SugarColumn(ColumnName = "QUALITY_REQ")]
			public string? QualityReq { get; set; }

			/// <summary>
			/// 结算方
			/// </summary>
			[SugarColumn(ColumnName = "SETTLEMENT_PARTY")]
			public string? SettlementParty { get; set; }

			/// <summary>
			/// 收款方
			/// </summary>
			[SugarColumn(ColumnName = "PAYMENT_PARTY")]
			public string? PaymentParty { get; set; }

			/// <summary>
			/// 邮箱
			/// </summary>
			[SugarColumn(ColumnName = "EMAIL")]
			public string? Email { get; set; }

			/// <summary>
			/// 运输方式
			/// </summary>
			[SugarColumn(ColumnName = "TRANSPORT_METHOD")]
			public string? TransportMethod { get; set; }

			/// <summary>
			/// 备注
			/// </summary>
			[SugarColumn(ColumnName = "REMARKS")]
			public string? Remarks { get; set; }

			/// <summary>
			/// 治具丶模具加工及采购
			/// </summary>
			[SugarColumn(ColumnName = "FIXTURE_MOLD_PROCUREMENT")]
			public string? FixtureMoldProcurement { get; set; }

			/// <summary>
			/// 作废状态
			/// </summary>
			[SugarColumn(ColumnName = "CANCELLATION_STATUS")]
			public string? CancellationStatus { get; set; }

			/// <summary>
			/// 作废人
			/// </summary>
			[SugarColumn(ColumnName = "CANCELLATION_PERSON")]
			public string? CancellationPerson { get; set; }

			/// <summary>
			/// 作废日期
			/// </summary>
			[SugarColumn(ColumnName = "CANCELLATION_DATE")]
			public DateTime? CancellationDate { 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_DATE")]
			public DateTime? LastupdateDate { get; set; }

			/// <summary>
			/// 最后修改人
			/// </summary>
			[SugarColumn(ColumnName = "LASTUPDATE_BY")]
			public string? LastupdateBy { get; set; }

			/// <summary>
			/// 审核人
			/// </summary>
			[SugarColumn(ColumnName = "ERP_CHECK_BY")]
			public string? ErpCheckBy { get; set; }

			/// <summary>
			/// 审核时间
			/// </summary>
			[SugarColumn(ColumnName = "ERP_CHECK_DATE")]
			public string? ErpCheckDate { get; set; }

			/// <summary>
			/// ERP的ID号
			/// </summary>
			[SugarColumn(ColumnName = "EBELN_K3ID")]
			public long? EbelnK3id { get; set; }

			/// <summary>
			/// 审核日期
			/// </summary>
			[SugarColumn(ColumnName = "CHECK_DATE")]
			public DateTime? CheckDate { get; set; }

			/// <summary>
			/// 审核人
			/// </summary>
			[SugarColumn(ColumnName = "CHECK_BY")]
			public string? CheckBy { get; set; }

			/// <summary>
			/// 审核标识
			/// </summary>
			[SugarColumn(ColumnName = "CHECK_FALG")]
			public int? CheckFalg { get; set; }

			/// <summary>
			/// 打印次数
			/// </summary>
			[SugarColumn(ColumnName = "REMARK1")]
			public string? Remark1 { get; set; }

			/// <summary>
			/// 自定义字段2
			/// </summary>
			[SugarColumn(ColumnName = "REMARK2")]
			public string? Remark2 { get; set; }

			/// <summary>
			/// 自定义字段3
			/// </summary>
			[SugarColumn(ColumnName = "REMARK3")]
			public string? Remark3 { get; set; }

			/// <summary>
			/// 自定义字段4
			/// </summary>
			[SugarColumn(ColumnName = "REMARK4")]
			public string? Remark4 { get; set; }

			/// <summary>
			/// 自定义字段5
			/// </summary>
			[SugarColumn(ColumnName = "REMARK5")]
			public string? Remark5 { get; set; }

			/// <summary>
			/// </summary>
			[SugarColumn(ColumnName = "CHANGEREASON")]
			public string? Changereason { 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 = "Prearrivaldate")]
			public DateTime? Prearrivaldate { get; set; }

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

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

			/// <summary>
			/// 联系人
			/// </summary>
			[SugarColumn(ColumnName = "anred")]
			public string? Anred { get; set; }

			/// <summary>
			/// 电话
			/// </summary>
			[SugarColumn(ColumnName = "telf1")]
			public string? Telf1 { get; set; }

			/// <summary>
			/// 固定电话
			/// </summary>
			[SugarColumn(ColumnName = "Fixed_Telephone")]
			public string? FixedTelephone { get; set; }

			/// <summary>
			/// 通讯地址
			/// </summary>
			[SugarColumn(ColumnName = "Address")]
			public string? Address { get; set; }

			/// <summary>
			/// 验收方式
			/// </summary>
			[SugarColumn(ColumnName = "Acctype")]
			public string? Acctype { get; set; }
			}