using Cksoft.Unity;
using System;

namespace DllEapEntity
{
    [Table("productionplan")]
    public class Productionplan:BaseEntity
    {
        ////自动产生代码开始&&此行不能删除
        #region 自动产生代码
        public Productionplan()
        {
            base.EntityStatusID = 1;
        }
        [ColDetail(10,"ID",1,1,100,1,"a.ID","",1,1)]
        [Key]
        [Identity]
        public int ID { get; set; }
        [ColDetail(20,"园区",1,1,100,1,"a.park","",1,1)]
        public string Park { get; set; }
        [ColDetail(30,"客户",1,1,100,1,"a.customer","",1,1)]
        public string Customer { get; set; }
        [ColDetail(40,"机种",1,1,100,1,"a.machineType","",1,1)]
        public string MachineType { get; set; }
        [ColDetail(50,"工艺",1,1,100,1,"a.technology","",1,1)]
        public string Technology { get; set; }
        [ColDetail(60,"工艺Code",1,1,100,1,"a.technologyCode","",1,1)]
        public string TechnologyCode { get; set; }
        [ColDetail(70,"月计划",1,1,100,1,"a.monthPlan","",1,1)]
        public string MonthPlan { get; set; }
        [ColDetail(80,"天计划",1,1,100,1,"a.dayPlan","",1,1)]
        public string DayPlan { get; set; }
        [ColDetail(90,"RecCode",1,1,100,1,"a.RecCode","",1,1)]
        public string RecCode { get; set; }
        [ColDetail(100,"RecTime",1,1,100,1,"a.RecTime","",1,1)]
        public DateTime RecTime { get; set; }
        [ColDetail(110,"ModCode",1,1,100,1,"a.ModCode","",1,1)]
        public string ModCode { get; set; }
        [ColDetail(120,"ModTime",1,1,100,1,"a.ModTime","",1,1)]
        public DateTime ModTime { get; set; }
        [ColDetail(140,"planTime",1,1,100,1,"a.planTime","",1,1)]
        public string PlanTime { get; set; }
        [ColDetail(150,"楼层",1,1,100,1,"a.floor","",1,1)]
        public string Floor { get; set; }
        public override string GetSelectSql()
        {
            return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}");
        }
        public override string GetQueryColSql()
        {
             string sqlstr = "a.ID ID,a.park Park,a.customer Customer,a.machineType MachineType,a.technology Technology,a.technologyCode TechnologyCode,a.monthPlan MonthPlan";
             sqlstr += ",a.dayPlan DayPlan,a.RecCode RecCode,a.RecTime RecTime,a.ModCode ModCode,a.ModTime ModTime,a.planTime PlanTime,a.floor Floor,0 EntityStatusID";
             return sqlstr;
        }
        public override string GetQueryTabSql()
        {
            string sqlstr=" productionplan a ";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return "";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除
    }
}