erp/BizCom/Dao/CeErpTradeOrder.cs

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

namespace BizCom
{
    [ActiveRecord("CE_ErpTradeOrder")]
    public class CeErpTradeOrder : ComBase<CeErpTradeOrder>
    {

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

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

        private string _refund_status = "";
        /// <summary>
        ///退款状态
        /// </summary>
        [Property]
        public string refund_status
        {
            get { return _refund_status; }
            set { _refund_status = value; }
        }

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

        private bool _seller_rate = false;
        /// <summary>
        ///seller_rate
        /// </summary>
        [Property]
        public bool seller_rate
        {
            get { return _seller_rate; }
            set { _seller_rate = value; }
        }

        private string _seller_type = "";
        /// <summary>
        ///卖家类型
        /// </summary>
        [Property]
        public string seller_type
        {
            get { return _seller_type; }
            set { _seller_type = value; }
        }

        [PrimaryKey(PrimaryKeyType.Assigned)]
        public string oid { get; set; }

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

        private string _title = "";
        /// <summary>
        ///商品标题
        /// </summary>
        [Property]
        public string title
        {
            get { return _title; }
            set { _title = value; }
        }

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

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

        private double _total_fee = 0;
        /// <summary>
        ///应付金额
        /// </summary>
        [Property]
        public double total_fee
        {
            get { return _total_fee; }
            set { _total_fee = value; }
        }

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

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

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

        private bool _is_oversold = false;
        /// <summary>
        ///是否超卖
        /// </summary>
        [Property]
        public bool is_oversold
        {
            get { return _is_oversold; }
            set { _is_oversold = value; }
        }

        private string _store_code = "";
        /// <summary>
        ///发货的仓库编码
        /// </summary>
        [Property]
        public string store_code
        {
            get { return _store_code; }
            set { _store_code = value; }
        }


        private string _sku_id = "";
        /// <summary>
        ///客户选项 sku
        /// </summary>
        [Property]
        public string sku_id
        {
            get { return _sku_id; }
            set { _sku_id = value; }
        }
        private string _sku_properties_name = "";
        /// <summary>
        ///客户选项 sku
        /// </summary>
        [Property]
        public string sku_properties_name
        {
            get { return _sku_properties_name; }
            set { _sku_properties_name = value; }
        }

        private bool _is_sh_ship = false;
        /// <summary>
        ///是否发货
        /// </summary>
        [Property]
        public bool is_sh_ship
        {
            get { return _is_sh_ship; }
            set { _is_sh_ship = value; }
        }

        private double _divide_order_fee = 0;
        /// <summary>
        ///分摊之后的实付金额
        /// </summary>
        [Property]
        public double divide_order_fee
        {
            get { return _divide_order_fee; }
            set { _divide_order_fee = value; }
        }

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

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

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

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

        private int _bagRealCount = 0;
        /// <summary>
        ///
        /// </summary>
        [Property]
        public int bagRealCount
        {
            get { return _bagRealCount; }
            set { _bagRealCount = value; }
        }
        private int _isBagOrder = 0;
        /// <summary>
        ///是否sku手提袋
        /// </summary>
        [Property]
        public int isBagOrder
        {
            get { return _isBagOrder; }
            set { _isBagOrder = value; }
        }

        private string _spu_id = "";
        /// <summary>
        ///商品ID
        /// </summary>
        [Property]
        public string spu_id
        {
            get { return _spu_id; }
            set { _spu_id = value; }
        }


        public static CeErpTradeOrder GetByOid(string oid)
        {
            return FindFirst(Expression.Eq("oid", oid));
        }


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