using Cksoft.Unity;
using System;

namespace DllEapEntity
{
    [Table("equipmentnumber")]
    public class Equipmentnumber:BaseEntity
    {
        ////自动产生代码开始&&此行不能删除
        #region 自动产生代码
        public Equipmentnumber()
        {
            base.EntityStatusID = 1;
        }
        [ColDetail(290,"ID",1,1,100,1,"a.ID","",1,1)]
        [Key]
        [Identity]
        public int ID { get; set; }
        [ColDetail(300,"设备型号",1,1,100,1,"a.equipmentmodel","",1,1)]
        public string Equipmentmodel { get; set; }
        [ColDetail(310,"工段",1,1,100,1,"a.workshopSection","",1,1)]
        public string WorkshopSection { get; set; }
        [ColDetail(320,"三号园区 2#1F",1,1,100,1,"a.threeSecFir","",1,1)]
        public string ThreeSecFir { get; set; }
        [ColDetail(330,"未来城 A1#1F",1,1,100,1,"a.futureCity","",1,1)]
        public string FutureCity { get; set; }
        [ColDetail(340,"未来城 A1#3F",1,1,100,1,"a.futureCityThird","",1,1)]
        public string FutureCityThird { get; set; }
        [ColDetail(350,"二号园区 1#1F",1,1,100,1,"a.secfirstFir","",1,1)]
        public string SecfirstFir { get; set; }
        [ColDetail(360,"二号园区 1#2F",1,1,100,1,"a.secFirstSec","",1,1)]
        public string SecFirstSec { get; set; }
        [ColDetail(370,"二号园区 1#3F",1,1,100,1,"a.secFirstThird","",1,1)]
        public string SecFirstThird { get; set; }
        [ColDetail(380,"二号园区 2#1F",1,1,100,1,"a.secSecFirst","",1,1)]
        public string SecSecFirst { get; set; }
        [ColDetail(390,"二号园区 2#2F",1,1,100,1,"a.secSecSec","",1,1)]
        public string SecSecSec { get; set; }
        [ColDetail(400,"核算逻辑",1,1,100,1,"a.accounting","",1,1)]
        public string Accounting { get; set; }
        [ColDetail(410,"RecCode",1,1,100,1,"a.RecCode","",1,1)]
        public string RecCode { get; set; }
        [ColDetail(420,"RecTime",1,1,100,1,"a.RecTime","",1,1)]
        public DateTime RecTime { get; set; }
        [ColDetail(430,"ModCode",1,1,100,1,"a.ModCode","",1,1)]
        public string ModCode { get; set; }
        [ColDetail(440,"ModTime",1,1,100,1,"a.ModTime","",1,1)]
        public DateTime ModTime { get; set; }
        public override string GetSelectSql()
        {
            return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}");
        }
        public override string GetQueryColSql()
        {
             string sqlstr = "a.ID ID,a.equipmentmodel Equipmentmodel,a.workshopSection WorkshopSection,a.threeSecFir ThreeSecFir,a.futureCity FutureCity,a.futureCityThird FutureCityThird";
             sqlstr += ",a.secfirstFir SecfirstFir,a.secFirstSec SecFirstSec,a.secFirstThird SecFirstThird,a.secSecFirst SecSecFirst,a.secSecSec SecSecSec,a.accounting Accounting";
             sqlstr += ",a.RecCode RecCode,a.RecTime RecTime,a.ModCode ModCode,a.ModTime ModTime,0 EntityStatusID";
             return sqlstr;
        }
        public override string GetQueryTabSql()
        {
            string sqlstr=" equipmentnumber a ";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return "";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除
    }
}