using Cksoft.Unity;
using System;

namespace DllStatusShowEntity
{
    [Table("LayoutDetail")]
    public class LayoutDetail:BaseEntity
    {
        ////自动产生代码开始&&此行不能删除
        #region 自动产生代码
        public LayoutDetail()
        {
            base.EntityStatusID = 1;
        }
        [ColDetail(40,"位置X",1,1,100,1,"a.LocX","editLocX",1,1)]
        public double LocX { get; set; }
        [ColDetail(50,"位置Y",1,1,100,1,"a.LocY","editLocY",1,1)]
        public double LocY { get; set; }
        [ColDetail(60,"大小W",1,1,100,1,"a.SizeW","editSizeW",1,1)]
        public double SizeW { get; set; }
        [ColDetail(70,"大小H",1,1,100,1,"a.SizeH","editSizeH",1,1)]
        public double SizeH { get; set; }
        [ColDetail(80,"字体大小",1,1,100,1,"a.FontSize","editFontSize",1,1)]
        public int FontSize { get; set; }
        [ColDetail(90,"颜色",1,1,100,1,"a.FColor","editFColor",1,1)]
        public string FColor { get; set; }
        [ColDetail(100,"备注",1,1,100,1,"a.Remark","editRemark",1,1)]
        public string Remark { get; set; }
        [ColDetail(110,"录入人代码",1,1,100,1,"a.reccode","editRecCode",1,1)]
        public string RecCode { get; set; }
        [ColDetail(120,"录入日期",1,1,100,1,"a.rectime","editRecTime",1,1)]
        public DateTime RecTime { get; set; }
        [ColDetail(130,"修改人代码",1,1,100,1,"a.modcode","editModCode",1,1)]
        public string ModCode { get; set; }
        [ColDetail(140,"修改时间",1,1,100,1,"a.modtime","editModTime",1,1)]
        public DateTime ModTime { get; set; }
        [ColDetail(150,"实体代码",1,0,100,1,"b.FCode","editTEntityFCode",1,1)]
        public string TEntityFCode { get; set; }
        [ColDetail(160,"实体名称",1,0,100,1,"b.FName","editTEntityFName",1,1)]
        public string TEntityFName { 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.PreID","",1,1)]
        public int PreID { get; set; }
        [ColDetail(10020,"实体ID",0,1,100,1,"a.EntityID","editTEntityFCode",1,2)]
        public int EntityID { get; set; }
        [ColDetail(10030,"IP地址",1,0,100,1,"b.FIP","editTEntityFIP",1,1)]
        public string TEntityFIP { get; set; }
        [ColDetail(10040,"实体分类ID",0,0,100,1,"b.FType","",1,1)]
        public int TEntityFType { get; set; }
        [ColDetail(10050,"实体分类",1,0,100,1,"d.FName","",1,1)]
        public string TEntityFTypeFName { get; set; }
        public override string GetSelectSql()
        {
            return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}");
        }
        public override string GetQueryColSql()
        {
             string sqlstr = "a.LocX LocX,a.LocY LocY,a.SizeW SizeW,a.SizeH SizeH,a.FontSize FontSize,a.FColor FColor,a.Remark Remark,a.reccode RecCode,a.rectime RecTime";
             sqlstr += ",a.modcode ModCode,a.modtime ModTime,b.FCode TEntityFCode,b.FName TEntityFName,a.ID ID,a.PreID PreID,a.EntityID EntityID,b.FIP TEntityFIP";
             sqlstr += ",b.FType TEntityFType,d.FName TEntityFTypeFName,0 EntityStatusID";
             return sqlstr;
        }
        public override string GetQueryTabSql()
        {
            string sqlstr=" LayoutDetail a ";
            sqlstr+=" left outer join tentity b on a.EntityID =b.id";
            sqlstr+=" left outer join layoutmst c on a.PreID =c.id";
            sqlstr+=" left outer join constitem d on b.FType =d.subid and d.preid=1";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return "";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除
    }
}