using Cksoft.Unity;
using System;

namespace DllEapEntity
{
    [Table("outputtime")]
    public class OutPutTime:BaseEntity
    {
        ////自动产生代码开始&&此行不能删除
        #region 自动产生代码
        public OutPutTime()
        {
            base.EntityStatusID = 1;
        }
        [ColDetail(10,"主键id",1,1,100,1,"a.ID","",1,1)]
        [Key]
        [Identity]
        public int ID { get; set; }
        [ColDetail(20,"设备主键id",1,1,100,1,"a.MacID","",1,1)]
        public int MacID { get; set; }
        [ColDetail(30,"日期",1,1,100,1,"a.Day","",1,1)]
        public string Day { get; set; }
        [ColDetail(40,"小时",1,1,100,1,"a.Hour","",1,1)]
        public string Hour { get; set; }
        [ColDetail(50,"稼动率",1,1,100,1,"a.RunRate","",1,1)]
        public string RunRate { get; set; }
        [ColDetail(60,"稼动时长",1,1,100,1,"a.RunTime","",1,1)]
        public string RunTime { get; set; }
        [ColDetail(70,"待机率",1,1,100,1,"a.StandbyRate","",1,1)]
        public string StandbyRate { get; set; }
        [ColDetail(80,"待机时长",1,1,100,1,"a.StandbyTime","",1,1)]
        public string StandbyTime { get; set; }
        [ColDetail(90,"故障率",1,1,100,1,"a.AlarmRate","",1,1)]
        public string AlarmRate { get; set; }
        [ColDetail(100,"故障时长",1,1,100,1,"a.AlarmTime","",1,1)]
        public string AlarmTime { get; set; }
        [ColDetail(110,"故障次数",1,1,100,1,"a.AlarmCount","",1,1)]
        public int AlarmCount { get; set; }
        [ColDetail(120,"产量",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 = "a.ID ID,a.MacID MacID,a.Day Day,a.Hour Hour,a.RunRate RunRate,a.RunTime RunTime,a.StandbyRate StandbyRate,a.StandbyTime StandbyTime";
             sqlstr += ",a.AlarmRate AlarmRate,a.AlarmTime AlarmTime,a.AlarmCount AlarmCount,a.Count Count,0 EntityStatusID";
             return sqlstr;
        }
        public override string GetQueryTabSql()
        {
            string sqlstr=" outputtime a ";
            return sqlstr;
        }
        public override string GetQuerySortSql()
        {
            return "";
        }
        #endregion
        ////自动产生代码结束&&此行不能删除
    }
}