using System;
using Castle.ActiveRecord;
using System.Text;

namespace BizCom
{
    [ActiveRecord("CE_ErpBagOrder")]
    public class CeErpBagOrder : ComBase<CeErpBagOrder>
    {

        /// <summary>
        /// 
        /// </summary>
        [PrimaryKey(PrimaryKeyType.Native)]
        public int ID { get; set; }

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

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

        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 string _price="";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string 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 string _total_fee="";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string total_fee
        {
             get{ return _total_fee; }
             set{ _total_fee=value; }
        }

        /// <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 string _step_paid_fee="";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string 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 string _adjust_fee="";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string 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 string _payment="";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string 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 string _post_fee="";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string 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 string _received_payment="";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string 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 _productType="";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string ProductType
        {
             get{ return _productType; }
             set{ _productType=value; }
        }

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

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

        private int _productCount=0;
        /// <summary>
        ///
        /// </summary>
        [Property]
        public int ProductCount
        {
             get{ return _productCount; }
             set{ _productCount=value; }
        }

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


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