using Cksoft.Unity;
using System;

namespace DllEapEntity
{
    [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(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(10050,"实体分类",1,0,100,1,"d.FName","",1,1)]
        public string TEntityFTypeFName { get; set; }
        [ColDetail(10060,"厂商代码",1,0,100,1,"f.FCode","",1,1)]
        public string SupplierFCode { get; set; }
        [ColDetail(10070,"实体分类ID",1,1,100,1,"a.EntityTypeID","",1,1)]
        public int EntityTypeID { get; set; }
        [ColDetail(10090,"实体代码",1,1,100,0,"","editTEntityFCode",1,1)]
        public string FCode { get; set; }
        [ColDetail(10100,"实体名称",1,1,100,0,"","editTEntityFName",1,1)]
        public string FName { get; set; }
        [ColDetail(10110,"IP地址",1,0,100,1,"e.IPAddress","editIPAddress",1,1)]
        public string IPAddress { 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,a.ID ID,a.PreID PreID,a.EntityID EntityID,d.FName TEntityFTypeFName,f.FCode SupplierFCode,a.EntityTypeID EntityTypeID";
             sqlstr += ",case  when a.EntityTypeID=1 then e.FCode else a.FCode end FCode,case  when a.EntityTypeID=1 then e.FName else a.FName end FName,e.IPAddress IPAddress";
             sqlstr += ",0 EntityStatusID";
             return sqlstr;
        }
        public override string GetQueryTabSql()
        {
            string sqlstr=" LayoutDetail a ";
            sqlstr+=" left outer join layoutmst c on a.PreID =c.id";
            sqlstr+=" left outer join constitem d on a.EntityTypeID =d.subid and d.preid=1";
            sqlstr+=" left outer join machine e on a.EntityTypeID=1 and a.EntityID =e.id";
            sqlstr+=" left outer join supplier f on e.SupplierID =f.id";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return "";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除
    }
}