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

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

        private int _pCategory = 0;
        /// <summary>
        ///类别
        /// </summary>
        [Property]
        public int PCategory
        {
            get { return _pCategory; }
            set { _pCategory = value; }
        }

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

        private string _pSupTypeId = "";
        /// <summary>
        ///一级分类ID
        /// </summary>
        [Property]
        public string PSupTypeId
        {
            get { return _pSupTypeId; }
            set { _pSupTypeId = value; }
        }

        private string _pSupType = "";
        /// <summary>
        ///一级分类
        /// </summary>
        [Property]
        public string PSupType
        {
            get { return _pSupType; }
            set { _pSupType = value; }
        }

        private string _pTypeId = "";
        /// <summary>
        ///类型ID
        /// </summary>
        [Property]
        public string PTypeId
        {
            get { return _pTypeId; }
            set { _pTypeId = value; }
        }

        private string _pType = "";
        /// <summary>
        ///类型名称
        /// </summary>
        [Property]
        public string PType
        {
            get { return _pType; }
            set { _pType = value; }
        }

        private string _spu = "";
        /// <summary>
        ///款式编码
        /// </summary>
        [Property]
        public string Spu
        {
            get { return _spu; }
            set { _spu = value; }
        }

        private string _pNo = "";
        /// <summary>
        ///编号
        /// </summary>
        [Property]
        public string PNo
        {
            get { return _pNo; }
            set { _pNo = value; }
        }

        private string _pName = "";
        /// <summary>
        ///商品名称
        /// </summary>
        [Property]
        public string PName
        {
            get { return _pName; }
            set { _pName = value; }
        }

        private string _shortName = "";
        /// <summary>
        ///短名称
        /// </summary>
        [Property]
        public string ShortName
        {
            get { return _shortName; }
            set { _shortName = value; }
        }

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

        private string _pMaterial = "";
        /// <summary>
        ///材质
        /// </summary>
        [Property]
        public string PMaterial
        {
            get { return _pMaterial; }
            set { _pMaterial = value; }
        }

        private string _pCraft = "";
        /// <summary>
        ///工艺
        /// </summary>
        [Property]
        public string PCraft
        {
            get { return _pCraft; }
            set { _pCraft = value; }
        }

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

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

        private double _chang = 0;
        /// <summary>
        ///长
        /// </summary>
        [Property]
        public double Chang
        {
            get { return _chang; }
            set { _chang = value; }
        }

        private double _kuang = 0;
        /// <summary>
        ///宽
        /// </summary>
        [Property]
        public double Kuang
        {
            get { return _kuang; }
            set { _kuang = value; }
        }

        private double _gao = 0;
        /// <summary>
        ///高
        /// </summary>
        [Property]
        public double Gao
        {
            get { return _gao; }
            set { _gao = value; }
        }

        private string _chiCunUnit = "";
        /// <summary>
        ///尺寸单位
        /// </summary>
        [Property]
        public string ChiCunUnit
        {
            get { return _chiCunUnit; }
            set { _chiCunUnit = value; }
        }

        private double _mianJi = 0;
        /// <summary>
        ///面积
        /// </summary>
        [Property]
        public double MianJi
        {
            get { return _mianJi; }
            set { _mianJi = value; }
        }

        private string _mianJiUnit = "";
        /// <summary>
        ///面积单位
        /// </summary>
        [Property]
        public string MianJiUnit
        {
            get { return _mianJiUnit; }
            set { _mianJiUnit = value; }
        }

        private double _tiJi = 0;
        /// <summary>
        ///体积
        /// </summary>
        [Property]
        public double TiJi
        {
            get { return _tiJi; }
            set { _tiJi = value; }
        }

        private string _tiJiUnit = "";
        /// <summary>
        ///体积单位
        /// </summary>
        [Property]
        public string TiJiUnit
        {
            get { return _tiJiUnit; }
            set { _tiJiUnit = value; }
        }

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

        private string _weightUnit = "";
        /// <summary>
        ///重量单位
        /// </summary>
        [Property]
        public string WeightUnit
        {
            get { return _weightUnit; }
            set { _weightUnit = value; }
        }

        private string _color = "";
        /// <summary>
        ///颜色
        /// </summary>
        [Property]
        public string Color
        {
            get { return _color; }
            set { _color = value; }
        }

        private string _spec = "";
        /// <summary>
        ///规格
        /// </summary>
        [Property]
        public string Spec
        {
            get { return _spec; }
            set { _spec = value; }
        }

        private string _stockUnit = "";
        /// <summary>
        ///库存数量基准单位
        /// </summary>
        [Property]
        public string StockUnit
        {
            get { return _stockUnit; }
            set { _stockUnit = value; }
        }

        private string _logoPicPath = "";
        /// <summary>
        ///Logo路径
        /// </summary>
        [Property]
        public string LogoPicPath
        {
            get { return _logoPicPath; }
            set { _logoPicPath = value; }
        }

        private string _picPath = "";
        /// <summary>
        ///大图路径
        /// </summary>
        [Property]
        public string PicPath
        {
            get { return _picPath; }
            set { _picPath = value; }
        }

        private double _jiZunPrice = 0;
        /// <summary>
        ///
        /// </summary>
        [Property]
        public double JiZunPrice
        {
            get { return _jiZunPrice; }
            set { _jiZunPrice = value; }
        }

        private double _chengBenPrice = 0;
        /// <summary>
        ///
        /// </summary>
        [Property]
        public double ChengBenPrice
        {
            get { return _chengBenPrice; }
            set { _chengBenPrice = value; }
        }

        private double _diaoPaiPrice = 0;
        /// <summary>
        ///
        /// </summary>
        [Property]
        public double DiaoPaiPrice
        {
            get { return _diaoPaiPrice; }
            set { _diaoPaiPrice = value; }
        }

        private int _isLock = 0;
        /// <summary>
        ///是否删除
        /// </summary>
        [Property]
        public int IsLock
        {
            get { return _isLock; }
            set { _isLock = value; }
        }

        private int _isDel = 0;
        /// <summary>
        ///是否停用
        /// </summary>
        [Property]
        public int IsDel
        {
            get { return _isDel; }
            set { _isDel = value; }
        }

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

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

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

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

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

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

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


        private int _isAllDesignerSelect = 0;
        /// <summary>
        ///
        /// </summary>
        [Property]
        public int IsAllDesignerSelect
        {
            get { return _isAllDesignerSelect; }
            set { _isAllDesignerSelect = value; }
        }
        //表单json
        private string _formJson = "";
        [Property]
        public string FormJson
        {
            get { return _formJson; }
            set { _formJson = value; }
        }

        private string _uuid = "";
        /// <summary>
        /// uuid
        /// </summary>
        [Property]
        public string uuid
        {
            get { return _uuid; }
            set { _uuid = value; }
        }
        public static void Del(object id)
        {
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat("delete from CE_ErpProduct where id=" + id);
            ExecuteNonQuery(sql.ToString());
        }

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

        public static DataTable Get()
        {
            string sql = "select * from CE_ErpProduct order by PTypeId,ID asc";
            return DbConn.ExecuteDataset(sql).Tables[0];
        }

        public static CeErpProduct GetByName(string name)
        {
            return FindFirst(Expression.Eq("uuid", name));
        }
    }
}