using FreeSql.DataAnnotations; using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace Store.Contracts.Order.Entitys; /// /// 微信订单商品明细表 /// [Table(Name = "erp.oms_wei_order_item")] public class WeiOrderItemEntity { /// /// id /// [Column(Name = "id", IsPrimary = true, IsIdentity = true)] public long Id { get; set; } /// /// 店铺id /// [Column(Name = "shop_id")] public long ShopId { get; set; } /// /// 商户id /// [Column(Name = "merchant_id")] public long MerchantId { get; set; } /// /// 订单id(平台订单id) /// [Column(Name = "order_id")] public string OrderId { get; set; } /// /// 商品spuid /// [Column(Name = "product_id")] public string ProductId { get; set; } /// /// 商品skuid /// [Column(Name = "sku_id")] public string SkuId { get; set; } /// /// sku小图 /// [Column(Name = "thumb_img")] public string ThumbImg { get; set; } /// /// sku数量 /// [Column(Name = "sku_cnt")] public int SkuCnt { get; set; } /// /// 售卖单价(单位:分) /// [Column(Name = "sale_price")] public int? SalePrice { get; set; } /// /// 商品标题 /// [Column(Name = "title")] public string Title { get; set; } /// /// 正在售后/退款流程中的 sku 数量 /// [Column(Name = "on_aftersale_sku_cnt")] public int? OnAftersaleSkuCnt { get; set; } /// /// 完成售后/退款的 sku 数量 /// [Column(Name = "finish_aftersale_sku_cnt")] public int? FinishAftersaleSkuCnt { get; set; } /// /// 商品编码 /// [Column(Name = "sku_code")] public string SkuCode { get; set; } /// /// 市场单价(单位:分) /// [Column(Name = "market_price")] public int? MarketPrice { get; set; } /// /// sku属性JSON /// [Column(Name = "sku_attrs")] public string SkuAttrs { get; set; } /// /// sku实付总价,取estimate_price和change_price中较小值 /// [Column(Name = "real_price")] public int? RealPrice { get; set; } /// /// 商品外部spuid /// [Column(Name = "out_product_id")] public string OutProductId { get; set; } /// /// 采购价 /// [Column(Name = "purchase_price")] public int? PurchasePrice { get; set; } /// /// 运费 /// [Column(Name = "freight")] public int? Freight { get; set; } /// /// 商品外部skuid /// [Column(Name = "out_sku_id")] public string OutSkuId { get; set; } /// /// 是否有优惠金额,非必填,默认为false /// [Column(Name = "is_discounted")] public string IsDiscounted { get; set; } /// /// 优惠后sku总价,非必填,is_discounted为true时有值 /// [Column(Name = "estimate_price")] public int? EstimatePrice { get; set; } /// /// 是否修改过价格,非必填,默认为false /// [Column(Name = "is_change_price")] public string IsChangePrice { get; set; } /// /// 改价后sku总价,非必填,is_change_price为true时有值 /// [Column(Name = "change_price")] public int? ChangePrice { get; set; } /// /// 订单内商品维度平台券优惠金额 (利润需要计算这个金额在内) /// [Column(Name = "cash_coupon_discounted_price")] public int? CashCouponDiscountedPrice { get; set; } /// /// 区域库存id /// [Column(Name = "out_warehouse_id")] public string OutWarehouseId { get; set; } /// /// 退货地址 /// [Column(Name = "return_address")] public string ReturnAddress { get; set; } /// /// 商品发货信息JSON /// [Column(Name = "sku_deliver_info")] public string SkuDeliverInfo { get; set; } /// /// 商品额外服务信息JSON /// [Column(Name = "extra_service")] public string ExtraService { get; set; } /// /// 是否使用了会员积分抵扣 /// [Column(Name = "use_deduction")] public string UseDeduction { get; set; } /// /// 会员积分抵扣金额,单位为分 /// [Column(Name = "deduction_price")] public int? DeductionPrice { get; set; } /// /// 平台服务费(微信小店:预计技术服务费),单位为分 /// [Column(Name = "predict_commission_fee")] public int? PredictCommissionFee { get; set; } /// /// 达人佣金(微信小店:分账金额),单位为分 /// [Column(Name = "commission_amount")] public int? CommissionAmount { get; set; } /// /// 商品优惠券信息,逐步替换 order.order_detail.coupon_info /// [Column(Name = "order_product_coupon_info_list")] public string OrderProductCouponInfoList { get; set; } /// /// 商品id(o_goods外键) /// [Column(Name = "erp_goods_id")] public long ErpGoodsId { get; set; } /// /// 商品skuid(o_goods_sku外键) /// [Column(Name = "erp_goods_sku_id")] public long ErpGoodsSkuId { get; set; } /// /// 售后状态 1:无售后或售后关闭,2:售后处理中,3:退款中,4: 退款成功 11 已取消 /// [Column(Name = "refund_status")] public int RefundStatus { get; set; } }