using Castle.ActiveRecord;
using System.Text;

namespace BizCom
{
    [ActiveRecord("CE_ErpSupplierProduct")]
    public class CeErpSupplierProduct : ComBase<CeErpSupplierProduct>
    {

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

        private int _supplierID = 0;
        /// <summary>
        ///供应商
        /// </summary>
        [Property]
        public int SupplierID
        {
            get { return _supplierID; }
            set { _supplierID = value; }
        }

        private int _productID = 0;
        /// <summary>
        ///产品类型
        /// </summary>
        [Property]
        public int ProductID
        {
            get { return _productID; }
            set { _productID = value; }
        }

        private string _productCrafts = "";
        /// <summary>
        ///产品工艺
        /// </summary>
        [Property]
        public string ProductCrafts
        {
            get { return _productCrafts; }
            set { _productCrafts = value; }
        }

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

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

        private string _area = "";
        /// <summary>
        ///地区
        /// </summary>
        [Property]
        public string Area
        {
            get { return _area; }
            set { _area = value; }
        }


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

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

        private int _bsort = 0;
        /// <summary>
        ///排序
        /// </summary>
        [Property]
        public int Bsort
        {
            get { return _bsort; }
            set { _bsort = value; }
        }

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


        private string _productText = "";
        /// <summary>
        ///产品名字
        /// </summary>
        [Property]
        public string ProductText
        {
            get { return _productText; }
            set { _productText = value; }
        }

        private string _productIds = "";
        /// <summary>
        ///产品ID
        /// </summary>
        [Property]
        public string ProductIds
        {
            get { return _productIds; }
            set { _productIds = value; }
        }


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