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

namespace BizCom
{
    [ActiveRecord("CE_ErpDeliverMark")]
    public class CeErpDeliverMark : ComBase<CeErpDeliverMark>
    {
        /// <summary>
        /// ID
        /// </summary>
        [PrimaryKey(PrimaryKeyType.Native)]
        public int ID { get; set; }

        private string _ctid;
        /// <summary>
        /// ctid
        /// </summary>
        [Property]
        public string ctid
        {
            get { return _ctid; }
            set { _ctid = value; }
        }

        private string _nickName;
        /// <summary>
        /// 昵称
        /// </summary>
        [Property]
        public string nickName
        {
            get { return _nickName; }
            set { _nickName = value; }
        }
        /// <summary>
        /// 创建时间
        /// </summary>
        [Property]
        public DateTime? createtime { get; set; }

        private bool _isDel = false;
        /// <summary>
        /// 是否删除
        /// </summary>
        [Property]
        public bool isdel
        {
            get { return _isDel; }
            set { _isDel = value; }
        }

        private int _markNumber = 0;
        /// <summary>
        /// 编码
        /// </summary>
        [Property]
        public int markNumber
        {
            get { return _markNumber; }
            set { _markNumber = value; }
        }

        public static CeErpDeliverMark GetByCtid(string ctid)
        {
            return FindFirst(Expression.Sql(string.Format("ctid='{0}' and isDel = 0", ctid)));
        }

        public static CeErpDeliverMark GetByNumber(int markNumber)
        {
            return FindFirst(Expression.Sql(string.Format("markNumber='{0}' and isDel = 0", markNumber)));
        }
    }
}