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

namespace BizCom
{
    [ActiveRecord("CE_ErpExpressInfo")]
    public class CeErpExpressInfo : ComBase<CeErpExpressInfo>
    {

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

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

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

        private string _company_code = "";
        /// <summary>
        ///快递公司编码
        /// </summary>
        [Property]
        public string company_code
        {
            get { return _company_code; }
            set { _company_code = value; }
        }

        private string _company_name = "";
        /// <summary>
        ///快递公司名字
        /// </summary>
        [Property]
        public string company_name
        {
            get { return _company_name; }
            set { _company_name = value; }
        }

        private string _import_file = "";
        /// <summary>
        ///导入文件名
        /// </summary>
        [Property]
        public string import_file
        {
            get { return _import_file; }
            set { _import_file = value; }
        }

        private string _supplierUserName = "";
        /// <summary>
        ///供应商
        /// </summary>
        [Property]
        public string supplierUserName
        {
            get { return _supplierUserName; }
            set { _supplierUserName = value; }
        }

        private string _state = "";
        /// <summary>
        ///发货状态描述
        /// </summary>
        [Property]
        public string state
        {
            get { return _state; }
            set { _state = value; }
        }

        private string _delivery_memo = "";
        /// <summary>
        ///发货备注
        /// </summary>
        [Property]
        public string delivery_memo
        {
            get { return _delivery_memo; }
            set { _delivery_memo = value; }
        }

        /// <summary>
        ///导入时间
        /// </summary>
        [Property]
        public DateTime? import_time { get; set; }

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

        private int _print_state = 0;
        /// <summary>
        ///打印状态
        /// </summary>
        [Property]
        public int print_state
        {
            get { return _print_state; }
            set { _print_state = value; }
        }

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

        private string _order_memo = "";
        /// <summary>
        ///订单备注
        /// </summary>
        [Property]
        public string order_memo
        {
            get { return _order_memo; }
            set { _order_memo = value; }
        }

        /// <summary>
        ///打印时间
        /// </summary>
        [Property]
        public DateTime? print_time { get; set; }

        private string _printUser = "";
        /// <summary>
        ///打印人
        /// </summary>
        [Property]
        public string printUser
        {
            get { return _printUser; }
            set { _printUser = value; }
        }
        private string _deliveryType = "";
        /// <summary>
        ///发货类型物流、虚拟
        /// </summary>
        [Property]
        public string deliveryType
        {
            get { return _deliveryType; }
            set { _deliveryType = value; }
        }

        private int _isMultiDelivery = 0;
        /// <summary>
        ///导入后是否批量发货了
        /// </summary>
        [Property]
        public int isMultiDelivery
        {
            get { return _isMultiDelivery; }
            set { _isMultiDelivery = value; }
        }


        public static CeErpExpressInfo GetByCtid(string ctid)
        {
            return FindFirst(Expression.Eq("tid", ctid));
        }

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