KJD_WebService/Store.Contracts/Order/Entitys/WeiOrderEntity.cs

using FreeSql.DataAnnotations;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

namespace Store.Contracts.Order.Entitys;

/// <summary>
/// 微信订单表
/// </summary>
[Table(Name = "erp.oms_wei_order")]
public class WeiOrderEntity
{
	/// <summary>
	/// id
	/// </summary>
	[Column(Name = "id", IsPrimary = true, IsIdentity = true)]
	public long Id { get; set; }

	/// <summary>
	/// 店铺id
	/// </summary>
	[Column(Name = "shop_id")]
	public long ShopId { get; set; }

	/// <summary>
	/// 店铺名称
	/// </summary>
	[Column(Name = "shop_name")]
	public string ShopName { get; set; }

	/// <summary>
	/// 商户id
	/// </summary>
	[Column(Name = "merchant_id")]
	public long MerchantId { get; set; }

	/// <summary>
	/// 订单号
	/// </summary>
	[Column(Name = "order_id")]
	public string OrderId { get; set; }

	/// <summary>
	/// 买家身份标识
	/// </summary>
	[Column(Name = "openid")]
	public string Openid { get; set; }

	/// <summary>
	/// 秒级时间戳
	/// </summary>
	[Column(Name = "create_time")]
	public int? CreateTime { get; set; }

	/// <summary>
	/// 秒级时间戳
	/// </summary>
	[Column(Name = "update_time")]
	public int? UpdateTime { get; set; }

	/// <summary>
	/// unionid
	/// </summary>
	[Column(Name = "unionid")]
	public string Unionid { get; set; }

	/// <summary>
	/// 状态10 待付款；20 待发货；21 部分发货；30 待收货；100 完成；200 全部商品售后之后，订单取消；250 未付款用户主动取消或超时未付款订单自动取消；
	/// </summary>
	[Column(Name = "status")]
	public int? Status { get; set; }

	/// <summary>
	/// 售后信息json
	/// </summary>
	[Column(Name = "aftersale_detail")]
	public string AftersaleDetail { get; set; }

	/// <summary>
	/// 支付信息json
	/// </summary>
	[Column(Name = "pay_info")]
	public string PayInfo { get; set; }

	/// <summary>
	/// 额外信息
	/// </summary>
	[Column(Name = "ext_info")]
	public string ExtInfo { get; set; }

	/// <summary>
	/// 商品总价，单位为分
	/// </summary>
	[Column(Name = "product_price")]
	public int? ProductPrice { get; set; }

	/// <summary>
	/// 订单金额，单位为分，order_price=original_order_price-discounted_price-deduction_price-change_down_price
	/// </summary>
	[Column(Name = "order_price")]
	public int? OrderPrice { get; set; }

	/// <summary>
	/// 采购价，单位为分
	/// </summary>
	[Column(Name = "purchase_price")]
	public int? PurchasePrice { get; set; }

	/// <summary>
	/// 采购时间
	/// </summary>
	[Column(Name = "purchase_time")]
	public int? PurchaseTime { get; set; }

	/// <summary>
	/// 运费，单位为分
	/// </summary>
	[Column(Name = "freight")]
	public int? Freight { get; set; }

	/// <summary>
	/// 平台服务费（微信小店：预计技术服务费），单位为分
	/// </summary>
	[Column(Name = "predict_commission_fee")]
	public int? PredictCommissionFee { get; set; }

	/// <summary>
	/// 达人佣金（微信小店：分账金额），单位为分
	/// </summary>
	[Column(Name = "commission_amount")]
	public int CommissionAmount { get; set; }

	/// <summary>
	/// 优惠券优惠金额，单位为分
	/// </summary>
	[Column(Name = "discounted_price")]
	public int? DiscountedPrice { get; set; }

	/// <summary>
	/// 利润（实付金额-采购价-平台服务费-达人佣金，达人佣金、采购价为空值则为0）
	/// </summary>
	[Column(Name = "profit")]
	public int? Profit { get; set; }

	/// <summary>
	/// 采购状态，默认值为：0未采购，推送仓库时修改为1采购
	/// </summary>
	[Column(Name = "purchase_status")]
	public int PurchaseStatus { get; set; }

	/// <summary>
	/// 延迟发货时间(微信小店：商品发货时效，超时此时间未发货即为发货超时)
	/// </summary>
	[Column(Name = "delivery_deadline")]
	public int? DeliveryDeadline { get; set; }

	/// <summary>
	/// 发货时间
	/// </summary>
	[Column(Name = "delivery_time")]
	public int? DeliveryTime { get; set; }

	/// <summary>
	/// 收货人姓名
	/// </summary>
	[Column(Name = "user_name")]
	public string UserName { get; set; }

	/// <summary>
	/// 邮编
	/// </summary>
	[Column(Name = "postal_code")]
	public string PostalCode { get; set; }

	/// <summary>
	/// 省份
	/// </summary>
	[Column(Name = "province_name")]
	public string ProvinceName { get; set; }

	/// <summary>
	/// 城市
	/// </summary>
	[Column(Name = "city_name")]
	public string CityName { get; set; }

	/// <summary>
	/// 区
	/// </summary>
	[Column(Name = "county_name")]
	public string CountyName { get; set; }

	/// <summary>
	/// 详细地址
	/// </summary>
	[Column(Name = "detail_info")]
	public string DetailInfo { get; set; }

	/// <summary>
	/// 联系方式
	/// </summary>
	[Column(Name = "tel_number")]
	public string TelNumber { get; set; }

	/// <summary>
	/// 门牌号码
	/// </summary>
	[Column(Name = "house_number")]
	public string HouseNumber { get; set; }

	/// <summary>
	/// 虚拟发货订单联系方式(deliver_method=1时返回)
	/// </summary>
	[Column(Name = "virtual_order_tel_number")]
	public string VirtualOrderTelNumber { get; set; }

	/// <summary>
	/// 额外的联系方式信息（虚拟号码相关）
	/// </summary>
	[Column(Name = "tel_number_ext_info")]
	public string TelNumberExtInfo { get; set; }

	/// <summary>
	/// 0：不使用虚拟号码，1：使用虚拟号码
	/// </summary>
	[Column(Name = "use_tel_number")]
	public int? UseTelNumber { get; set; }

	/// <summary>
	/// 标识当前店铺下一个唯一的用户收货地址
	/// </summary>
	[Column(Name = "hash_code")]
	public string HashCode { get; set; }

	/// <summary>
	/// 发货物流信息JSON
	/// </summary>
	[Column(Name = "delivery_product_info")]
	public string DeliveryProductInfo { get; set; }

	/// <summary>
	/// 发货完成时间，秒级时间戳
	/// </summary>
	[Column(Name = "ship_done_time")]
	public int? ShipDoneTime { get; set; }

	/// <summary>
	/// 电子面单代发时的订单密文
	/// </summary>
	[Column(Name = "ewaybill_order_code")]
	public string EwaybillOrderCode { get; set; }

	/// <summary>
	/// 结算信息json
	/// </summary>
	[Column(Name = "settle_info")]
	public string SettleInfo { get; set; }

	/// <summary>
	/// 订单审核状态（0待审核1已审核）
	/// </summary>
	[Column(Name = "audit_status")]
	public int? AuditStatus { get; set; }

	/// <summary>
	/// 订单审核时间
	/// </summary>
	[Column(Name = "audit_time")]
	public DateTime? AuditTime { get; set; }

	/// <summary>
	/// erp发货快递公司
	/// </summary>
	[Column(Name = "erp_send_company")]
	public string ErpSendCompany { get; set; }

	/// <summary>
	/// erp发货快递单号
	/// </summary>
	[Column(Name = "erp_send_code")]
	public string ErpSendCode { get; set; }

	/// <summary>
	/// erp发货状态
	/// </summary>
	[Column(Name = "erp_send_status")]
	public int? ErpSendStatus { get; set; }

	/// <summary>
	/// erp发货时间
	/// </summary>
	[Column(Name = "erp_send_time")]
	public DateTime? ErpSendTime { get; set; }

	/// <summary>
	/// 旗帜颜色备注，1：灰旗，2：红旗，3：橙旗，4：绿旗，5：天蓝旗，6：紫旗
	/// </summary>
	[Column(Name = "colour_flag")]
	public int? ColourFlag { get; set; }

	/// <summary>
	/// 旗帜备注时间
	/// </summary>
	[Column(Name = "colour_flag_update_time")]
	public DateTime? ColourFlagUpdateTime { get; set; }

	/// <summary>
	/// 供应商备注异常单
	/// </summary>
	[Column(Name = "supplier_remark_exception")]
	public string SupplierRemarkException { get; set; }

	/// <summary>
	/// 礼物单状态，默认值0：不存在礼物单，1：礼物单已发货，2：礼物单信息已更正，3：礼物单发货失败
	/// </summary>
	[Column(Name = "gift_order_status")]
	public byte GiftOrderStatus { get; set; }

	/// <summary>
	/// 店铺备注：取微信ext_info.merchant_notes
	/// </summary>
	[Column(Name = "shop_remark")]
	public string ShopRemark { get; set; }

	/// <summary>
	/// 商家的系统备注
	/// </summary>
	[Column(Name = "soft_remark")]
	public string SoftRemark { get; set; }

	/// <summary>
	/// 外采金额（单位：分，整数存储）
	/// </summary>
	[Column(Name = "out_amount")]
	public int OutAmount { get; set; }

	/// <summary>
	/// 外采账户
	/// </summary>
	[Column(Name = "out_account")]
	public string OutAccount { get; set; }

	/// <summary>
	/// 外采订单号
	/// </summary>
	[Column(Name = "out_order_no")]
	public string OutOrderNo { get; set; }

	/// <summary>
	/// 外采快递公司
	/// </summary>
	[Column(Name = "out_express_company")]
	public string OutExpressCompany { get; set; }

	/// <summary>
	/// 外采快递单号
	/// </summary>
	[Column(Name = "out_express_no")]
	public string OutExpressNo { get; set; }

	/// <summary>
	/// 外采是否发货（0 未发货，1 已发货）
	/// </summary>
	[Column(Name = "out_shipped")]
	public byte OutShipped { get; set; }

	/// <summary>
	/// 判断是否优化过发货0 未优化， 1已优化
	/// </summary>
	[Column(Name = "is_shipment_optimized")]
	public int IsShipmentOptimized { get; set; }

	/// <summary>
	/// 判断是否优随机使用快递单号0 未使用， 1已使用
	/// </summary>
	[Column(Name = "is_express_no_used")]
	public int IsExpressNoUsed { get; set; }

	/// <summary>
	/// 外采订单售后状态
	/// </summary>
	[Column(Name = "out_after_sale_status")]
	public string OutAfterSaleStatus { get; set; }

	/// <summary>
	/// 是否支持运费险：0-不支持，1-支持
	/// </summary>
	[Column(Name = "has_freight_insurance")]
	public byte HasFreightInsurance { get; set; }

	/// <summary>
	/// 运费险金额（单位：元）
	/// </summary>
	[Column(Name = "freight_insurance_amount")]
	public decimal FreightInsuranceAmount { get; set; }

	/// <summary>
	/// 是否外采礼物单：0-否，1-是（外采订单）
	/// </summary>
	[Column(Name = "external_gift")]
	public byte ExternalGift { get; set; }

	/// <summary>
	/// 中转仓的状态 0未使用，1已创建，2创建失败(购买失败)，3已创建未有上游快递单号，4已创建有上游快递单号
	/// </summary>
	[Column(Name = "transfer_warehouse_status")]
	public byte? TransferWarehouseStatus { get; set; }

	/// <summary>
	/// 商品运费（由店铺买家支付的）
	/// </summary>
	[Column(Name = "postage_price")]
	public int? PostagePrice { get; set; }
}