erp/BizCom/Dao/CeErpProductHour.cs

using Castle.ActiveRecord;
using System.Text;

namespace BizCom
{
    [ActiveRecord("CE_ErpProductHour")]
    public class CeErpProductHour : ComBase<CeErpProductHour>
    {

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

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

        private int _kfTime = 0;
        /// <summary>
        ///客服阶段
        /// </summary>
        [Property]
        public int kfTime
        {
            get { return _kfTime; }
            set { _kfTime = value; }
        }

        private int _dsjTime = 0;
        /// <summary>
        ///待设计阶段 
        /// </summary>
        [Property]
        public int dsjTime
        {
            get { return _dsjTime; }
            set { _dsjTime = value; }
        }

        private int _sjzTime = 0;
        /// <summary>
        ///设计中阶段 
        /// </summary>
        [Property]
        public int sjzTime
        {
            get { return _sjzTime; }
            set { _sjzTime = value; }
        }

        private int _xdTime = 0;
        /// <summary>
        ///下单阶段
        /// </summary>
        [Property]
        public int xdTime
        {
            get { return _xdTime; }
            set { _xdTime = value; }
        }

        private int _fhTime = 0;
        /// <summary>
        ///发货阶段
        /// </summary>
        [Property]
        public int fhTime
        {
            get { return _fhTime; }
            set { _fhTime = value; }
        }

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

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

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