using Castle.ActiveRecord;
using System;
using System.Text;

namespace BizCom
{
    [ActiveRecord("Ce_ErpDesignerFinishRateNew")]
    public class CeErpDesignerFinishRateNew : ComBase<CeErpDesignerFinishRateNew>
    {

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

        private int _did = 0;
        /// <summary>
        ///设计师ID
        /// </summary>
        [Property]
        public int did
        {
            get { return _did; }
            set { _did = value; }
        }

        private string _amount = "";
        /// <summary>
        ///当天总金额
        /// </summary>
        [Property]
        public string Amount
        {
            get { return _amount; }
            set { _amount = value; }
        }

        private int _allOrder = 0;
        /// <summary>
        ///当天总数量
        /// </summary>
        [Property]
        public int AllOrder
        {
            get { return _allOrder; }
            set { _allOrder = value; }
        }

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


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


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

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


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


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

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

        private int _csplitum = 0;
        /// <summary>
        ///
        /// </summary>
        [Property]
        public int refund
        {
            get { return _refund; }
            set { _refund = value; }
        }

        private int _refund = 0;


        private string _onRefund = "";
        /// <summary>
        ///
        /// </summary>
        [Property]
        public string onRefund
        {
            get { return _onRefund; }
            set { _onRefund = value; }
        }
        /// <summary>
        ///
        /// </summary>
        [Property]
        public int csplitum
        {
            get { return _csplitum; }
            set { _csplitum = value; }
        }

        private int _designFinish = 0;
        /// <summary>
        ///
        /// </summary>

        [Property]
        public DateTime? Createtime { get; set; }

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


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

        //根据日期删除
        public static void Del(object id)
        {
            StringBuilder sql = new StringBuilder();
            sql.AppendFormat("delete from Ce_ErpDesignerFinishRateNew where ctime = '" + id + "'");
            ExecuteNonQuery(sql.ToString());
        }
    }
}