using Cksoft.Unity;
using System;

namespace DllEapEntity
{
    [Table("Machine")]
    public class Machine02:BaseEntity
    {
        ////自动产生代码开始&&此行不能删除
        #region 自动产生代码
        public Machine02()
        {
            base.EntityStatusID = 1;
        }
        [ColDetail(10,"厂商代码",1,0,60,1,"e.FCode","editSupplierFCode",1,1)]
        public string SupplierFCode { get; set; }
        [ColDetail(30,"代码",1,1,60,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.IPAddress","editIPAddress",1,1)]
        public string IPAddress { get; set; }
        [ColDetail(60,"端口",1,1,60,1,"a.FPort","editFPort",1,1)]
        public int FPort { get; set; }
        [ColDetail(130,"备注",1,1,200,1,"a.Remark","editRemark",1,1)]
        public string Remark { get; set; }
        [ColDetail(10000,"主键ID",0,1,100,1,"a.ID","",1,1)]
        [Key]
        [Identity]
        public int ID { get; set; }
        [ColDetail(10010,"机型代码",0,0,100,1,"d.FCode","editMModeCode",1,1)]
        public string MModeCode { get; set; }
        [ColDetail(10020,"机型名称",0,0,100,1,"d.FName","editMModeName",1,1)]
        public string MModeName { get; set; }
        [ColDetail(10040,"是否连接",1,0,100,1,"a.IsConn","",1,1)]
        public int IsConn { get; set; }
        [ColDetail(10070,"制程代码",1,0,100,1,"g.FCode","",1,1)]
        public string PCode { get; set; }
        [ColDetail(10080,"制程名称",1,0,100,1,"g.FName","",1,1)]
        public string PName { get; set; }
        [ColDetail(10150,"物理地址",1,1,100,1,"a.MacAddress","",1,1)]
        public string MacAddress { get; set; }
        [ColDetail(10160,"RegionId",0,1,100,1,"a.RegionId","",1,1)]
        public int RegionId { get; set; }
        [ColDetail(10170,"厂区ID",0,1,100,1,"a.FactoryId","",1,1)]
        public int FactoryId { get; set; }
        [ColDetail(10180,"厂区名称",1,0,100,1,"i.FName","",1,1)]
        public string FactoryName { get; set; }
        [ColDetail(10190,"来源",0,1,100,1,"a.Source","",1,1)]
        public string Source { get; set; }
        [ColDetail(10200,"状态ID",1,1,100,1,"j.StatusID","",1,1)]
        public int StatusID { get; set; }
        [ColDetail(10210,"线体名称",1,1,100,1,"k.FName","",1,1)]
        public string RegionNmae { get; set; }
        public override string GetSelectSql()
        {
            return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}");
        }
        public override string GetQueryColSql()
        {
             string sqlstr = "e.FCode SupplierFCode,a.FCode FCode,a.FName FName,a.IPAddress IPAddress,a.FPort FPort,a.Remark Remark,a.ID ID,d.FCode MModeCode,d.FName MModeName";
             sqlstr += ",a.IsConn IsConn,g.FCode PCode,g.FName PName,a.MacAddress MacAddress,a.RegionId RegionId,a.FactoryId FactoryId,i.FName FactoryName,a.Source Source";
             sqlstr += ",j.StatusID StatusID,k.FName RegionNmae,0 EntityStatusID";
             return sqlstr;
        }
        public override string GetQueryTabSql()
        {
            string sqlstr=" Machine a ";
            sqlstr+=" left outer join staff b on a.RecCode =b.FCode";
            sqlstr+=" left outer join staff c on a.ModCode =c.FCode";
            sqlstr+=" left outer join macmodel d on a.MModeID =d.id";
            sqlstr+=" left outer join supplier e on d.SupplierID =e.id";
            sqlstr+=" left outer join mactprocess f on a.id =f.macid";
            sqlstr+=" left outer join tprocess g on f.PCode =g.FCode";
            sqlstr+=" left outer join constitem h on a.CallPMode =h.subid and h.preid=14";
            sqlstr+=" left outer join factoryregion i on a.factoryid =i.id";
            sqlstr+=" left outer join macstatus01 j on a.FCode =j.MacCode";
            sqlstr+=" left outer join factoryregion k on a.regionid =k.id";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return " a.FCode asc";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除
    }
}