erp/BizCom/Dao/CeErpTrade.cs

using Castle.ActiveRecord;
using NHibernate.Criterion;
using System;
using System.Text;

namespace BizCom
{
    [ActiveRecord("CE_ErpTrade")]
    public class CeErpTrade : ComBase<CeErpTrade>, ICloneable
    {


        /// <summary>
        ///交易编号
        /// </summary>
        [PrimaryKey(PrimaryKeyType.Assigned)]
        public string tid { get; set; }

        private double _num = 0;
        /// <summary>
        ///商品购买数量
        /// </summary>
        [Property]
        public double num
        {
            get { return _num; }
            set { _num = value; }
        }

        private string _status = "";
        /// <summary>
        ///交易状态
        /// </summary>
        [Property]
        public string status
        {
            get { return _status; }
            set { _status = value; }
        }

        private string _type = "";
        /// <summary>
        ///交易类型列表
        /// </summary>
        [Property]
        public string type
        {
            get { return _type; }
            set { _type = value; }
        }

        private double _price = 0;
        /// <summary>
        ///
        /// </summary>
        [Property]
        public double price
        {
            get { return _price; }
            set { _price = value; }
        }

        private double _discount_fee = 0;
        /// <summary>
        ///优惠金额
        /// </summary>
        [Property]
        public double discount_fee
        {
            get { return _discount_fee; }
            set { _discount_fee = value; }
        }

        private double _total_fee = 0;
        /// <summary>
        ///商品金额
        /// </summary>
        [Property]
        public double total_fee
        {
            get { return _total_fee; }
            set { _total_fee = value; }
        }
        [Property]
        public DateTime? create_time { get; set; }
        /// <summary>
        ///交易创建时间
        /// </summary>
        [Property]
        public DateTime? created { get; set; }

        /// <summary>
        ///付款时间
        /// </summary>
        [Property]
        public DateTime? pay_time { get; set; }

        /// <summary>
        ///交易修改时间
        /// </summary>
        [Property]
        public DateTime? modified { get; set; }

        /// <summary>
        ///交易结束时间
        /// </summary>
        [Property]
        public DateTime? end_time { get; set; }

        private string _buyer_nick = "";
        /// <summary>
        ///买家昵称
        /// </summary>
        [Property]
        public string buyer_nick
        {
            get { return _buyer_nick; }
            set { _buyer_nick = value; }
        }

        private string _step_trade_status = "";
        /// <summary>
        ///分阶段付款的订单状态
        /// </summary>
        [Property]
        public string step_trade_status
        {
            get { return _step_trade_status; }
            set { _step_trade_status = value; }
        }

        private double _step_paid_fee = 0;
        /// <summary>
        ///分阶段付款的已付金额
        /// </summary>
        [Property]
        public double step_paid_fee
        {
            get { return _step_paid_fee; }
            set { _step_paid_fee = value; }
        }

        private string _shipping_type = "";
        /// <summary>
        ///创建交易时的物流方式
        /// </summary>
        [Property]
        public string shipping_type
        {
            get { return _shipping_type; }
            set { _shipping_type = value; }
        }

        private double _adjust_fee = 0;
        /// <summary>
        ///卖家手工调整金额
        /// </summary>
        [Property]
        public double adjust_fee
        {
            get { return _adjust_fee; }
            set { _adjust_fee = value; }
        }

        private string _trade_from = "";
        /// <summary>
        ///交易内部来源
        /// </summary>
        [Property]
        public string trade_from
        {
            get { return _trade_from; }
            set { _trade_from = value; }
        }

        private string _seller_flag = "";
        /// <summary>
        ///卖家备注旗帜
        /// </summary>
        [Property]
        public string seller_flag
        {
            get { return _seller_flag; }
            set { _seller_flag = value; }
        }

        private string _seller_nick = "";
        /// <summary>
        ///卖家昵称
        /// </summary>
        [Property]
        public string seller_nick
        {
            get { return _seller_nick; }
            set { _seller_nick = value; }
        }

        private double _payment = 0;
        /// <summary>
        ///实付金额
        /// </summary>
        [Property]
        public double payment
        {
            get { return _payment; }
            set { _payment = value; }
        }

        private bool _seller_rate = false;
        /// <summary>
        ///卖家是否已评价
        /// </summary>
        [Property]
        public bool seller_rate
        {
            get { return _seller_rate; }
            set { _seller_rate = value; }
        }

        private double _post_fee = 0;
        /// <summary>
        ///邮费
        /// </summary>
        [Property]
        public double post_fee
        {
            get { return _post_fee; }
            set { _post_fee = value; }
        }

        private string _receiver_name = "";
        /// <summary>
        ///收货人的姓名
        /// </summary>
        [Property]
        public string receiver_name
        {
            get { return _receiver_name; }
            set { _receiver_name = value; }
        }

        private string _receiver_country = "";
        /// <summary>
        ///收货人国籍
        /// </summary>
        [Property]
        public string receiver_country
        {
            get { return _receiver_country; }
            set { _receiver_country = value; }
        }

        private string _receiver_state = "";
        /// <summary>
        ///收货人的所在省份
        /// </summary>
        [Property]
        public string receiver_state
        {
            get { return _receiver_state; }
            set { _receiver_state = value; }
        }

        private string _receiver_city = "";
        /// <summary>
        ///收货人的所在城市
        /// </summary>
        [Property]
        public string receiver_city
        {
            get { return _receiver_city; }
            set { _receiver_city = value; }
        }

        private string _receiver_town = "";
        /// <summary>
        ///收货人街道地址
        /// </summary>
        [Property]
        public string receiver_town
        {
            get { return _receiver_town; }
            set { _receiver_town = value; }
        }

        private string _receiver_district = "";
        /// <summary>
        ///收货人的所在地区
        /// </summary>
        [Property]
        public string receiver_district
        {
            get { return _receiver_district; }
            set { _receiver_district = value; }
        }

        private string _receiver_address = "";
        /// <summary>
        ///收货人的详细地址
        /// </summary>
        [Property]
        public string receiver_address
        {
            get { return _receiver_address; }
            set { _receiver_address = value; }
        }

        private string _receiver_zip = "";
        /// <summary>
        ///收货人的邮编
        /// </summary>
        [Property]
        public string receiver_zip
        {
            get { return _receiver_zip; }
            set { _receiver_zip = value; }
        }

        private string _receiver_mobile = "";
        /// <summary>
        ///收货人的手机号码
        /// </summary>
        [Property]
        public string receiver_mobile
        {
            get { return _receiver_mobile; }
            set { _receiver_mobile = value; }
        }

        private string _receiver_phone = "";
        /// <summary>
        ///收货人的电话号码
        /// </summary>
        [Property]
        public string receiver_phone
        {
            get { return _receiver_phone; }
            set { _receiver_phone = value; }
        }

        /// <summary>
        ///卖家发货时间
        /// </summary>
        [Property]
        public DateTime? consign_time { get; set; }

        private double _received_payment = 0;
        /// <summary>
        ///卖家实际收到的支付宝打款金额
        /// </summary>
        [Property]
        public double received_payment
        {
            get { return _received_payment; }
            set { _received_payment = value; }
        }

        /// <summary>
        ///发货时间
        /// </summary>
        [Property]
        public DateTime? delivery_time { get; set; }

        /// <summary>
        ///揽收时间
        /// </summary>
        [Property]
        public DateTime? collect_time { get; set; }

        /// <summary>
        ///签收时间
        /// </summary>
        [Property]
        public DateTime? sign_time { get; set; }

        private string _buyer_message = "";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string buyer_message
        {
            get { return _buyer_message; }
            set { _buyer_message = value; }
        }

        private string _buyer_memo = "";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string buyer_memo
        {
            get { return _buyer_memo; }
            set { _buyer_memo = value; }
        }

        private string _seller_memo = "";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string seller_memo
        {
            get { return _seller_memo; }
            set { _seller_memo = value; }
        }

        private string _posCode = "";
        /// <summary>
        ///店铺编码
        /// </summary>
        [Property]
        public string posCode
        {
            get { return _posCode; }
            set { _posCode = value; }
        }

        private string _buyer_id = "";
        /// <summary>
        ///客户id
        /// </summary>
        [Property]
        public string buyer_id
        {
            get { return _buyer_id; }
            set { _buyer_id = value; }
        }
        private bool _isNew = false;
        [Property]
        public bool IsNew
        {
            get { return _isNew; }
            set { _isNew = value; }
        }

        private double _unrefundedAmount = 0;
        /// <summary>
        /// 未退款金额
        /// </summary>
        [Property]
        public double unrefundedAmount
        {
            get { return _unrefundedAmount; }
            set { _unrefundedAmount = value; }
        }

        private int _orderFrom = 10;
        /// <summary>
        /// 【订单来源】"10"：第三方平台"15"：私域电商"20"：ERP "30"：售前系统
        /// </summary>

        [Property]
        public int orderFrom
        {
            get { return _orderFrom; }
            set { _orderFrom = value; }
        }

        private int _orderType = 10;
        /// <summary>
        /// 【订单类型】"10"：线上单"15"：线下单"20"：补差单"30"：售后单
        /// </summary>
        [Property]
        public int orderType
        {
            get { return _orderType; }
            set { _orderType = value; }
        }
        /// <summary>
        ///确认时间
        /// </summary>
        [Property]
        public DateTime? confirmTime { get; set; }
        public object Clone()
        {
            return this.MemberwiseClone();
        }

        public static void Del(object id)
        {
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat("delete from CE_ErpTrade where tid='" + id + "'");
            ExecuteNonQuery(sql.ToString());
        }

        public static CeErpTrade Get(string tid)
        {
            return FindFirst(Expression.Eq("tid", tid));
        }
        public static CeErpTrade GetByName(string name)
        {
            return FindFirst(Expression.Eq("buyer_nick", name));
        }
    }
}