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

namespace BizCom
{
    [ActiveRecord("CE_ErpStayGoods")]
    public class CeErpStayGoods : ComBase<CeErpStayGoods>
    {

        /// <summary>
        /// 推多单号
        /// </summary>
        [PrimaryKey(PrimaryKeyType.Native)]
        public int stay_id { get; set; }

        private string _t_id = "";
        /// <summary>
        ///订单号
        /// </summary>
        [Property]
        public string t_id
        {
            get { return _t_id; }
            set { _t_id = value; }
        }
        private string _ctid = "";
        /// <summary>
        ///拆单号
        /// </summary>
        [Property]
        public string ctid
        {
            get { return _ctid; }
            set { _ctid = value; }
        }

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

        private string _stay_type = "";
        /// <summary>
        ///推多/推购
        /// </summary>
        [Property]
        public string stay_type
        {
            get { return _stay_type; }
            set { _stay_type = value; }
        }

        private string _shop_name = "";
        /// <summary>
        ///店铺名称
        /// </summary>
        [Property]
        public string shop_name
        {
            get { return _shop_name; }
            set { _shop_name = value; }
        }

        private string _wangwang = "";
        /// <summary>
        ///旺旺号
        /// </summary>
        [Property]
        public string wangwang
        {
            get { return _wangwang; }
            set { _wangwang = value; }
        }

        /// <summary>
        ///申请时间
        /// </summary>
        [Property]
        public DateTime? creata_time { get; set; }

        private string _create_u_name = "";
        /// <summary>
        ///申请人名称
        /// </summary>
        [Property]
        public string create_u_name
        {
            get { return _create_u_name; }
            set { _create_u_name = value; }
        }

        private int _audit_type = 0;
        /// <summary>
        ///审核状态 1审核中 2通过 3已退回 
        /// </summary>
        [Property]
        public int audit_type
        {
            get { return _audit_type; }
            set { _audit_type = value; }
        }

        private int _create_u_id = 0;
        /// <summary>
        ///申请人用户id
        /// </summary>
        [Property]
        public int create_u_id
        {
            get { return _create_u_id; }
            set { _create_u_id = value; }
        }

        private int _audit_u_id = 0;
        /// <summary>
        ///审核人
        /// </summary>
        [Property]
        public int audit_u_id
        {
            get { return _audit_u_id; }
            set { _audit_u_id = value; }
        }

        private string _audit_u_name = "";
        /// <summary>
        ///审核人名称
        /// </summary>
        [Property]
        public string audit_u_name
        {
            get { return _audit_u_name; }
            set { _audit_u_name = value; }
        }

        /// <summary>
        ///
        /// </summary>
        [Property]
        public DateTime? audit_time { get; set; }

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

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

        public static CeErpStayGoods GetByCtid(string ctid)
        {
            return FindFirst(Expression.Eq("ctid", ctid));
        }
        public static CeErpStayGoods GetByTid(string t_id)
        {
            return FindFirst(Expression.Eq("t_id", t_id));
        }

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

        public static CeErpStayGoods GetStayId(int eid)
        {
            return FindFirst(Expression.Eq("stay_id", eid));
        }
    }
}