everlight.eap/backend/DllEapEntity/OutPutTimeInfo.cs

using Cksoft.Unity;
using System;

namespace DllEapEntity
{
    [Table("outputtime")]
    public class OutPutTimeInfo:BaseEntity
    {
        ////自动产生代码开始&&此行不能删除
        #region 自动产生代码
        public OutPutTimeInfo()
        {
            base.EntityStatusID = 1;
        }
        [ColDetail(10,"名称",1,1,100,1,"e.FName","",1,1)]
        public string Factory { get; set; }
        [ColDetail(20,"名称",1,1,100,1,"k.FName","",1,1)]
        public string Floor { get; set; }
        [ColDetail(30,"FCode",1,1,100,1,"g.FCode","",1,1)]
        public string PCode { get; set; }
        [ColDetail(40,"代码",1,1,100,1,"d.FCode","",1,1)]
        public string MModelCode { get; set; }
        [ColDetail(50,"代码",1,1,100,1,"c.FCode","",1,1)]
        public string MacCode { get; set; }
        [ColDetail(60,"主键id",1,1,100,1,"a.ID","",1,1)]
        [Key]
        public int ID { get; set; }
        [ColDetail(70,"设备主键id",1,1,100,1,"a.MacID","",1,1)]
        public int MacID { get; set; }
        [ColDetail(80,"日期",1,1,100,1,"a.Day","",1,1)]
        public DateTime Day { get; set; }
        [ColDetail(90,"小时",1,1,100,1,"a.Hour","",1,1)]
        public double Hour { get; set; }
        [ColDetail(100,"稼动率",1,1,100,1,"a.RunRate","",1,1)]
        public double RunRate { get; set; }
        [ColDetail(110,"稼动时长",1,1,100,1,"a.RunTime","",1,1)]
        public double RunTime { get; set; }
        [ColDetail(120,"待机率",1,1,100,1,"a.StandbyRate","",1,1)]
        public double StandbyRate { get; set; }
        [ColDetail(130,"待机时长",1,1,100,1,"a.StandbyTime","",1,1)]
        public double StandbyTime { get; set; }
        [ColDetail(140,"故障率",1,1,100,1,"a.AlarmRate","",1,1)]
        public double AlarmRate { get; set; }
        [ColDetail(150,"故障时长",1,1,100,1,"a.AlarmTime","",1,1)]
        public double AlarmTime { get; set; }
        [ColDetail(160,"故障次数",1,1,100,1,"a.AlarmCount","",1,1)]
        public int AlarmCount { get; set; }
        [ColDetail(170,"产量",1,1,100,1,"a.Count","",1,1)]
        public int Count { get; set; }
        public override string GetSelectSql()
        {
            return string.Format($"select { GetQueryColSql()} from { GetQueryTabSql()}");
        }
        public override string GetQueryColSql()
        {
             string sqlstr = "e.FName Factory,k.FName Floor,g.FCode PCode,d.FCode MModelCode,c.FCode MacCode,a.ID ID,a.MacID MacID,a.Day Day,a.Hour Hour,a.RunRate RunRate";
             sqlstr += ",a.RunTime RunTime,a.StandbyRate StandbyRate,a.StandbyTime StandbyTime,a.AlarmRate AlarmRate,a.AlarmTime AlarmTime,a.AlarmCount AlarmCount";
             sqlstr += ",a.Count Count,0 EntityStatusID";
             return sqlstr;
        }
        public override string GetQueryTabSql()
        {
            string sqlstr=" outputtime a ";
            sqlstr+=" left outer join machine c on a.macid =c.id";
            sqlstr+=" left outer join macmodel d on c.MModeID =d.id";
            sqlstr+=" left outer join factoryregion e on c.FactoryId =e.id";
            sqlstr+=" left outer join mactprocess f on c.id =f.macid";
            sqlstr+=" left outer join tprocess g on f.PCode =g.FCode";
            sqlstr+=" left outer join factoryregion j on c.RegionId =j.id";
            sqlstr+=" left outer join factoryregion k on j.ParentId =k.id";
            sqlstr+=" left outer join factoryregion l on k.ParentId =l.id";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return "";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除
    }
}