using Cksoft.Unity;
using System;

namespace DllEapEntity
{
    [Table("TEntity")]
    public class TEntity:BaseEntity
    {
        ////自动产生代码开始&&此行不能删除
        #region 自动产生代码
        public TEntity()
        {
            base.EntityStatusID = 1;
        }
        [ColDetail(30,"代码",1,1,100,1,"a.FCode","editFCode",1,1)]
        public string FCode { get; set; }
        [ColDetail(40,"名称",1,1,100,1,"a.FName","editFName",1,1)]
        public string FName { get; set; }
        [ColDetail(50,"IP地址",1,1,100,1,"a.FIP","editFIP",1,1)]
        public string FIP { get; set; }
        [ColDetail(60,"端口",1,1,100,1,"a.FPort","editFPort",1,1)]
        public int FPort { get; set; }
        [ColDetail(80,"备注",1,1,100,1,"a.remark","editremark",1,1)]
        public string remark { get; set; }
        [ColDetail(90,"录入人代码",1,1,100,1,"a.reccode","editreccode",1,1)]
        public string RecCode { get; set; }
        [ColDetail(100,"录入日期",1,1,100,1,"a.rectime","editrectime",1,1)]
        public DateTime RecTime { get; set; }
        [ColDetail(110,"修改人代码",1,1,100,1,"a.modcode","editmodcode",1,1)]
        public string ModCode { get; set; }
        [ColDetail(120,"修改时间",1,1,100,1,"a.modtime","editmodtime",1,1)]
        public DateTime ModTime { get; set; }
        [ColDetail(140,"分类名称",1,0,100,1,"b.FName","editFTypeFName",2,5)]
        public string FTypeFName { get; set; }
        [ColDetail(150,"是否启动",1,0,100,1,"c.FName","editIfStart",2,5)]
        public string IfStartFName { get; set; }
        [ColDetail(10000,"ID",0,1,100,1,"a.ID","",1,1)]
        [Key]
        [Identity]
        public int ID { get; set; }
        [ColDetail(10010,"分类ID",0,1,100,1,"a.FType","editFTypeFName",2,4)]
        public int FType { get; set; }
        [ColDetail(10020,"显示屏ID",0,1,100,1,"a.LcdID","editTLcdFCode",1,2)]
        public int LcdID { get; set; }
        [ColDetail(10030,"显示屏代码",0,0,100,1,"d.FCode","editTLcdFCode",1,1)]
        public string TLcdFCode { get; set; }
        [ColDetail(10040,"显示屏名称",0,0,100,1,"d.FName","editTLcdFName",1,1)]
        public string TLcdFName { get; set; }
        [ColDetail(10050,"是否启动ID",1,1,100,1,"a.IfStart","editIfStart",2,4)]
        public int IfStart { get; set; }
        [ColDetail(10060,"来源ID",0,1,100,1,"a.OrgID","",1,1)]
        public int OrgID { get; set; }
        public override string GetSelectSql()
        {
            return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}");
        }
        public override string GetQueryColSql()
        {
             string sqlstr = "a.FCode FCode,a.FName FName,a.FIP FIP,a.FPort FPort,a.remark remark,a.reccode RecCode,a.rectime RecTime,a.modcode ModCode,a.modtime ModTime";
             sqlstr += ",b.FName FTypeFName,c.FName IfStartFName,a.ID ID,a.FType FType,a.LcdID LcdID,d.FCode TLcdFCode,d.FName TLcdFName,a.IfStart IfStart,a.OrgID OrgID";
             sqlstr += ",0 EntityStatusID";
             return sqlstr;
        }
        public override string GetQueryTabSql()
        {
            string sqlstr=" TEntity a ";
            sqlstr+=" left outer join constitem b on a.FType =b.subid and b.preid=8";
            sqlstr+=" left outer join constitem c on a.IfStart =c.subid and c.preid=9";
            sqlstr+=" left outer join tlcd d on a.LcdID =d.id";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return "";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除
    }
}