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

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

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

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

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

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

        private double _total = 0;
        /// <summary>
        ///总价
        /// </summary>
        [Property]
        public double total
        {
            get { return _total; }
            set { _total = value; }
        }

        private string _batchNo = "";
        /// <summary>
        ///批次号
        /// </summary>
        [Property]
        public string batchNo
        {
            get { return _batchNo; }
            set { _batchNo = value; }
        }

        private string _logistics = "";
        /// <summary>
        ///物流
        /// </summary>
        [Property]
        public string logistics
        {
            get { return _logistics; }
            set { _logistics = value; }
        }

        private string _logisticsNo = "";
        /// <summary>
        ///运单号
        /// </summary>
        [Property]
        public string logisticsNo
        {
            get { return _logisticsNo; }
            set { _logisticsNo = value; }
        }

        private double _logisticsAmount = 0;
        /// <summary>
        ///快递金额
        /// </summary>
        [Property]
        public double logisticsAmount
        {
            get { return _logisticsAmount; }
            set { _logisticsAmount = value; }
        }

        private double _weight = 0;
        /// <summary>
        ///重量
        /// </summary>
        [Property]
        public double weight
        {
            get { return _weight; }
            set { _weight = value; }
        }

        private string _fileName = "";
        /// <summary>
        ///文件名
        /// </summary>
        [Property]
        public string fileName
        {
            get { return _fileName; }
            set { _fileName = value; }
        }

        private string _province = "";
        /// <summary>
        ///计费省份
        /// </summary>
        [Property]
        public string province
        {
            get { return _province; }
            set { _province = value; }
        }

        private string _supplierName = "";
        /// <summary>
        ///供应商名称
        /// </summary>
        [Property]
        public string supplierName
        {
            get { return _supplierName; }
            set { _supplierName = value; }
        }

        private string _unusual = "";
        /// <summary>
        ///异常
        /// </summary>
        [Property]
        public string unusual
        {
            get { return _unusual; }
            set { _unusual = value; }
        }

        private string _explain = "";
        /// <summary>
        ///说明
        /// </summary>
        [Property]
        public string explain
        {
            get { return _explain; }
            set { _explain = value; }
        }

        /// <summary>
        ///导入日期
        /// </summary>
        [Property]
        public DateTime? importDate { get; set; }

        /// <summary>
        ///入账日期
        /// </summary>
        [Property]
        public DateTime? accountedDate { get; set; }

        private int _importUserId = 0;
        /// <summary>
        ///导入人员ID
        /// </summary>
        [Property]
        public int importUserId { get; set; }

        private int _shopId = 0;
        /// <summary>
        ///店铺ID
        /// </summary>
        [Property]
        public int shopId
        {
            get { return _shopId; }
            set { _shopId = value; }
        }

        private int _state = 0;
        /// <summary>
        ///状态
        /// </summary>
        [Property]
        public int state
        {
            get { return _state; }
            set { _state = value; }
        }

        /// <summary>
        ///完成日期
        /// </summary>
        [Property]
        public DateTime? finishDate { get; set; }

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

        public static CeErpZhangDan GetById(int id)
        {
            return FindFirst(Expression.Eq("ID", id));
        }

        public static CeErpZhangDan GetBytid(string tid)
        {
            return FindFirst(Expression.Eq("tid", tid));
        }

        public object Clone()
        {
            return this.MemberwiseClone();
        }
    }
}