namespace wcftest.orm
|
{
|
using System;
|
using System.Collections.Generic;
|
using System.ComponentModel.DataAnnotations;
|
using System.ComponentModel.DataAnnotations.Schema;
|
using System.Data.Entity.Spatial;
|
|
public partial class Sale_Order
|
{
|
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
|
public Sale_Order()
|
{
|
Sale_Order_StatusHistory = new HashSet<Sale_Order_StatusHistory>();
|
Sale_OrderList = new HashSet<Sale_OrderList>();
|
}
|
|
[Key]
|
public long Order_Id { get; set; }
|
|
[Required]
|
[StringLength(50)]
|
public string OrderCode { get; set; }
|
|
[StringLength(50)]
|
public string StoreOrderCode { get; set; }
|
|
public byte? OrderChannel { get; set; }
|
|
public int? StoreInfo_Id { get; set; }
|
|
public int? Store_Id { get; set; }
|
|
[StringLength(250)]
|
public string StoreName { get; set; }
|
|
public int? Storage_Id { get; set; }
|
|
[StringLength(50)]
|
public string StorageName { get; set; }
|
|
public int? User_Id { get; set; }
|
|
[StringLength(50)]
|
public string UserTrueName { get; set; }
|
|
public int? Dept_Id { get; set; }
|
|
[StringLength(50)]
|
public string DeptName { get; set; }
|
|
public DateTime? ApplyDate { get; set; }
|
|
|
|
[StringLength(50)]
|
public string ClientCode { get; set; }
|
|
[StringLength(500)]
|
public string ClientShortName { get; set; }
|
|
[StringLength(500)]
|
public string Email { get; set; }
|
|
[StringLength(350)]
|
public string Telephone { get; set; }
|
|
[StringLength(350)]
|
public string Fax { get; set; }
|
|
public DateTime? DeliveryDate { get; set; }
|
|
public decimal? TotalQuantityOrder { get; set; }
|
|
public decimal? TotalQuantityCanceled { get; set; }
|
|
public decimal? TotalQuantityInvoiced { get; set; }
|
|
public decimal? TotalQuantityRefunded { get; set; }
|
|
public decimal? TotalQuantityOuted { get; set; }
|
|
public decimal? TotalQuantityShipped { get; set; }
|
|
public decimal? Weight { get; set; }
|
|
/// <summary>
|
/// ×ÜÌ×Êý (ÕýÕûÊý)
|
/// </summary>
|
public decimal? MaterialCount { get; set; }
|
|
/// <summary>
|
/// Òѳö¿âÌ×Êý (ÕýÕûÊý) [EditBy shaocx,2022-09-30]
|
/// </summary>
|
public int? HasOutNumber { get; set; }
|
|
/// <summary>
|
/// ¾ÝÎÒ·ÖÎö£¬Õâ¸öÖµÊÇ Òѳö¿âÌ×Êý£¬¸úÉÏÃæµÄHasOutNumberÖµÊÇÒ»ÑùµÄ ¡£ [Editby shaocx,2022-10-16]
|
/// </summary>
|
public int? Client_Id { get; set; }
|
|
/// <summary>
|
/// ±¾´Î³ö¿âÌ×Êý (ÕýÕûÊý)
|
/// </summary>
|
public decimal? OutNumber { get; set; }
|
|
[StringLength(50)]
|
public string Package { get; set; }
|
|
public byte? StatusID { get; set; }
|
|
/// <summary>
|
/// ״̬£¬Ê¹ÓÃö¾ÙSale_Order_StatusEnum
|
/// </summary>
|
[StringLength(50)]
|
public string StatusText { get; set; }
|
|
public byte? FinStatusID { get; set; }
|
|
[StringLength(50)]
|
public string FinStatusText { get; set; }
|
|
public byte? PayMode { get; set; }
|
|
[StringLength(150)]
|
public string Payment { get; set; }
|
|
public byte? SortingStatus { get; set; }
|
|
public DateTime? SortingDate { get; set; }
|
|
[StringLength(50)]
|
public string Auditor { get; set; }
|
|
public byte? Auditing { get; set; }
|
|
public DateTime? AuditDate { get; set; }
|
|
/// <summary>
|
/// ÔÝʱ ÒÔÕâ¸ö×ֶαê־Ϊ °´ÕÕ¿âλºÅ³ö¿â
|
/// </summary>
|
public string AuditRemark { get; set; }
|
|
public int? OrderPrint_Id { get; set; }
|
|
[StringLength(50)]
|
public string OrderPrintCode { get; set; }
|
|
public int? SortStorage_Id { get; set; }
|
|
[StringLength(50)]
|
public string SortStorageName { get; set; }
|
|
[StringLength(500)]
|
public string Company { get; set; }
|
|
[StringLength(50)]
|
public string PostCode { get; set; }
|
|
public int? Country_Id { get; set; }
|
|
[StringLength(50)]
|
public string CountryName { get; set; }
|
|
[StringLength(150)]
|
public string CountryFullName { get; set; }
|
|
public int? Province_Id { get; set; }
|
|
[StringLength(50)]
|
public string ProvinceName { get; set; }
|
|
public int? City_Id { get; set; }
|
|
[StringLength(800)]
|
public string CityName { get; set; }
|
|
public int? Region_Id { get; set; }
|
|
[StringLength(800)]
|
public string RegionName { get; set; }
|
|
[StringLength(1000)]
|
public string Street { get; set; }
|
|
public byte? ExpressCorpType { get; set; }
|
|
public int? ExpressCorp_Id { get; set; }
|
|
[StringLength(500)]
|
public string ExpressCorpName { get; set; }
|
|
[StringLength(150)]
|
public string ExpressCode { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? BaseTaxAmount { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? BaseShippingAmount { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? BaseDiscountAmount { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? BaseSubTotal { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? BaseGrandTotal { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? BaseTotalPaid { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? BaseTotalUnPaid { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? BaseTotalRefunded { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? BaseTotalCanceled { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? BaseTotalInvoiced { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? BaseTotalOnlineRefunded { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? BaseTotalOffRefunded { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? TaxAmount { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? ShippingAmount { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? FactFreightRMB { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? DiscountAmount { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? SubTotal { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? GrandTotal { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? TotalPaid { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? Unpaid { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? TotalRefunded { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? TotalCanceled { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? TotalInvoiced { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? TotalOnlineRefunded { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? TotalOffRefunded { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? StoreBaseRate { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? StoreOrderRate { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? BaseGlobalRate { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? BaseOrderRate { get; set; }
|
|
[StringLength(50)]
|
public string GlobalCurrencyCode { get; set; }
|
|
[StringLength(50)]
|
public string BaseCurrencyCode { get; set; }
|
|
[StringLength(50)]
|
public string StoreCurrencyCode { get; set; }
|
|
[StringLength(50)]
|
public string OrderCurrencyCode { get; set; }
|
|
public string ShippingMethod { get; set; }
|
|
public string ShippingDescription { get; set; }
|
|
public byte? IsSendEmail { get; set; }
|
|
public string GiftMessage { get; set; }
|
|
[StringLength(800)]
|
public string ShippingName { get; set; }
|
|
[StringLength(800)]
|
public string BillingName { get; set; }
|
|
public string ShippingAddress { get; set; }
|
|
public string BillingAddress { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? FavourAmount { get; set; }
|
|
[Column(TypeName = "numeric")]
|
public decimal? Rate { get; set; }
|
|
[Column(TypeName = "money")]
|
public decimal? TotalRateMoney { get; set; }
|
|
public byte? CustomProduct { get; set; }
|
|
[StringLength(50)]
|
public string StoreOrderId { get; set; }
|
|
public string Tag { get; set; }
|
|
public byte? Flag { get; set; }
|
|
[StringLength(50)]
|
public string OrderType { get; set; }
|
|
public int? TuotouDays { get; set; }
|
|
public int Consignor_Id { get; set; }
|
|
[Required]
|
[StringLength(50)]
|
public string ConsignorCode { get; set; }
|
|
[Required]
|
[StringLength(150)]
|
public string ConsignorName { get; set; }
|
|
[StringLength(50)]
|
public string Mobile { get; set; }
|
|
[StringLength(150)]
|
public string ExternalNo { get; set; }
|
|
[StringLength(150)]
|
public string ExternalNo2 { get; set; }
|
|
[StringLength(150)]
|
public string SourceId { get; set; }
|
|
[StringLength(50)]
|
public string CiqStatus { get; set; }
|
|
[StringLength(50)]
|
public string CiqCheckType { get; set; }
|
|
[StringLength(50)]
|
public string BigPen { get; set; }
|
|
[StringLength(50)]
|
public string ReturnOrderCode { get; set; }
|
|
[StringLength(150)]
|
public string BillingTel { get; set; }
|
|
[StringLength(50)]
|
public string BillingCountry { get; set; }
|
|
[StringLength(50)]
|
public string BillingZip { get; set; }
|
|
[StringLength(50)]
|
public string PaymentWay { get; set; }
|
|
[StringLength(50)]
|
public string Driver { get; set; }
|
|
public decimal? TotalWeight { get; set; }
|
|
[StringLength(50)]
|
public string sortingCode { get; set; }
|
|
[StringLength(50)]
|
public string ContainerNo { get; set; }
|
|
[StringLength(50)]
|
public string feeItem_Ids { get; set; }
|
|
public byte? Enable { get; set; }
|
|
public string Remark { get; set; }
|
|
public int? CreateID { get; set; }
|
|
[StringLength(50)]
|
public string Creator { get; set; }
|
|
public DateTime? CreateDate { get; set; }
|
|
public int? ModifyID { get; set; }
|
|
[StringLength(50)]
|
public string Modifier { get; set; }
|
|
public DateTime? ModifyDate { get; set; }
|
|
public int? PlatUser_Id { get; set; }
|
|
[StringLength(50)]
|
public string PlatUserCode { get; set; }
|
|
[StringLength(50)]
|
public string PlatUserName { get; set; }
|
|
[StringLength(50)]
|
public string PlatCorpName { get; set; }
|
|
public int UserProduct_Id { get; set; }
|
|
[StringLength(50)]
|
public string UserProductCode { get; set; }
|
|
[StringLength(100)]
|
public string UserProductAlias { get; set; }
|
|
public string ExpandFields { get; set; }
|
|
[StringLength(100)]
|
public string PickUpPort { get; set; }
|
|
public int? Destination_Id { get; set; }
|
|
[StringLength(50)]
|
public string DestinationName { get; set; }
|
|
[StringLength(50)]
|
public string RelationDrivers { get; set; }
|
|
public int? Plate_Id { get; set; }
|
|
[StringLength(50)]
|
public string PlateName { get; set; }
|
|
[StringLength(50)]
|
public string PlateCode { get; set; }
|
|
public int? OrderExit { get; set; }
|
|
public long? Product_Id { get; set; }
|
|
[StringLength(50)]
|
public string ProductCode { get; set; }
|
|
[StringLength(500)]
|
public string ProductName { get; set; }
|
|
public decimal? ValidQuantity { get; set; }
|
|
[StringLength(50)]
|
public string BatchNumber { get; set; }
|
|
[StringLength(50)]
|
public string AllocatedForklift { get; set; }
|
|
public int? forklift_Id { get; set; }
|
|
[StringLength(50)]
|
public string ForkliftCode { get; set; }
|
|
[StringLength(50)]
|
public string ForkliftName { get; set; }
|
|
public DateTime? PickupBeginDate { get; set; }
|
|
public DateTime? PickupEndDate { get; set; }
|
|
[StringLength(50)]
|
public string PickUpPortState { get; set; }
|
|
[StringLength(50)]
|
public string RelationState { get; set; }
|
|
[StringLength(50)]
|
public string OutTransId { get; set; }
|
|
[StringLength(50)]
|
public string PlateType { get; set; }
|
|
[StringLength(250)]
|
public string TrackingNumber { get; set; }
|
|
|
|
[StringLength(50)]
|
public string SaleCode { get; set; }
|
|
public int? PriorityNo { get; set; }
|
|
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
|
public virtual ICollection<Sale_Order_StatusHistory> Sale_Order_StatusHistory { get; set; }
|
|
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
|
public virtual ICollection<Sale_OrderList> Sale_OrderList { get; set; }
|
}
|
}
|
