using Cksoft.Unity;
using System;
using System.Collections.Generic;

namespace DllEapEntity.RA
{
    [Table("machine")]
    public class MachineShort:BaseEntity
    {
        ////自动产生代码开始&&此行不能删除
        #region 自动产生代码
        public MachineShort()
        {
            base.EntityStatusID = 1;
        }
        [ColDetail(10,"园区",1,1,100,1,"a.Factory","",1,1)]
        public string Factory { get; set; }
        [ColDetail(20,"设备ID",1,1,100,1,"a.FCode","",1,1)]
        public string FCode { get; set; }
        [ColDetail(30,"湿度实际值",1,1,100,1,"b.HumidPV","",1,1)]
        public string HumidPV { get; set; }
        [ColDetail(40,"温度实际值",1,1,100,1,"b.TemperaturePV","",1,1)]
        public string TemperaturePV { get; set; }
        [ColDetail(50,"状态持续时间（小时）",1,1,100,1,"c.Duration","",1,1)]
        public string Duration { get; set; }
        [ColDetail(60,"状态 0=停机，1=运转，2=预约",1,1,100,1,"c.Status","",1,1)]
        public string Status { get; set; }
        [ColDetail(70,"湿度标准值",1,1,100,1,"b.HumidSv","",1,1)]
        public string HumidSv { get; set; }
        [ColDetail(80,"温度标准值",1,1,100,1,"b.TemperatureSV","",1,1)]
        public string TemperatureSV { get; set; }
        [ColDetail(90,"当前执行的段数",1,1,100,1,"b.Step","",1,1)]
        public string Step { get; set; }
        [ColDetail(100,"当前程序名",1,1,100,1,"b.ProgramName","",1,1)]
        public string ProgramName { get; set; }
        [ColDetail(110,"当段剩余分钟",1,1,100,1,"b.Minutes","",1,1)]
        public string Minutes { get; set; }
        [ColDetail(120,"当段剩余小时",1,1,100,1,"b.Hour","",1,1)]
        public string Hour { get; set; }
        [ColDetail(130,"目前执行的循环数",1,1,100,1,"b.Cycle","",1,1)]
        public string Cycle { get; set; }
        [ColDetail(140,"机型",1,1,100,1,"d.Model","",1,1)]
        public string Model { get; set; }
        [ColDetail(150,"机台名称",1,1,100,1,"d.FName","",1,1)]
        public string FName { get; set; }
        [ColDetail(160,"厂商",1,1,100,1,"d.SName","",1,1)]
        public string SName { get; set; }
        [ColDetail(170,"机台编号",1,1,100,1,"a.MacNum","",1,1)]
        public string MacNum { get; set; }
        [ColDetail(180,"修改时间",1,1,100,1,"b.ModeTime","",1,1)]
        public DateTime ModeTime { get; set; }
        [ColDetail(190,"开始时间",1,1,100,1,"c.StartTime","",1,1)]
        public DateTime StartTime { get; set; }
        [ColDetail(200,"IP地址",1,1,100,1,"a.IPAdress","",1,1)]
        public string IPAdress { get; set; }
        public override string GetSelectSql()
        {
            return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}");
        }
        public override string GetQueryColSql()
        {
             string sqlstr = "a.Factory Factory,a.FCode FCode,b.HumidPV HumidPV,b.TemperaturePV TemperaturePV,c.Duration Duration,c.Status Status,b.HumidSv HumidSv";
             sqlstr += ",b.TemperatureSV TemperatureSV,b.Step Step,b.ProgramName ProgramName,b.Minutes Minutes,b.Hour Hour,b.Cycle Cycle,d.Model Model,d.FName FName";
             sqlstr += ",d.SName SName,a.MacNum MacNum,b.ModeTime ModeTime,c.StartTime StartTime,a.IPAdress IPAdress,0 EntityStatusID";
             return sqlstr;
        }
        public override string GetQueryTabSql()
        {
            string sqlstr=" machine a ";
            sqlstr+=" left outer join baseinfo b on a.id =b.macid";
            sqlstr+=" left outer join statusinfo c on a.id =c.macid";
            sqlstr+=" left outer join supplier d on a.SupplierID =d.id";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return "";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除
    }
}