everlight.eap/backend/DllEapEntity/RA/MachineBase.cs

using Cksoft.Unity;
using System;

namespace DllEapEntity.RA
{
    [Table("machine")]
    public class MachineBase:BaseEntity
    {
        ////自动产生代码开始&&此行不能删除
        #region 自动产生代码
        public MachineBase()
        {
            base.EntityStatusID = 1;
        }
        [ColDetail(20,"设备ID",1,1,100,1,"a.FCode","",1,1)]
        public string FCode { get; set; }
        [ColDetail(30,"机台名称",1,1,100,1,"e.FName","",1,1)]
        public string FName { get; set; }
        [ColDetail(40,"机型",1,1,100,1,"e.Model","",1,1)]
        public string Model { get; set; }
        [ColDetail(50,"目前执行的循环数",1,1,100,1,"b.Cycle","",1,1)]
        public string Cycle { get; set; }
        [ColDetail(60,"当段剩余小时",1,1,100,1,"b.Hour","",1,1)]
        public string Hour { get; set; }
        [ColDetail(70,"当段剩余分钟",1,1,100,1,"b.Minutes","",1,1)]
        public string Minutes { get; set; }
        [ColDetail(80,"当前程序名",1,1,100,1,"b.ProgramName","",1,1)]
        public string ProgramName { get; set; }
        [ColDetail(90,"当前执行的段数",1,1,100,1,"b.Step","",1,1)]
        public string Step { get; set; }
        [ColDetail(100,"ID",1,1,100,1,"a.ID","",1,1)]
        public int ID { get; set; }
        [ColDetail(110,"状态 0=停机，1=运转，2=预约",1,1,100,1,"c.Status","",1,1)]
        public string Status { get; set; }
        [ColDetail(120,"机台编号",1,1,100,1,"a.MacNum","",1,1)]
        public string MacNum { get; set; }
        [ColDetail(130,"IP地址",1,1,100,1,"a.IPAdress","",1,1)]
        public string IPAdress { get; set; }
        
        public string Time { get; set; }
        public string StatusName { get; set; }
        public string StatusTime { get; set; }
        public string AlarmNum { get; set; }
        public string Rate { get; set; }
        public override string GetSelectSql()
        {
            return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}");
        }
        public override string GetQueryColSql()
        {
             string sqlstr = "a.FCode FCode,e.FName FName,e.Model Model,b.Cycle Cycle,b.Hour Hour,b.Minutes Minutes,b.ProgramName ProgramName,b.Step Step,a.ID ID";
             sqlstr += ",c.Status Status,a.MacNum MacNum,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 alarminfo d on a.id =d.macid";
            sqlstr+=" left outer join supplier e on a.SupplierID =e.id";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return "";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除
    }
}