xiaomiMes/MainForm/ClassFile/ProjectClass/LineWorkingData.cs

using System;

namespace MainForm
{
    /// <summary>
    /// 整线设备状态信息-本次开机
    /// </summary>
    public class LineWorkingData_ThisTime
    {
        #region 数据
        /// <summary>
        /// 主键
        /// </summary>
        public string GUID { get; set; }
        /// <summary>
        /// 线体名称
        /// </summary>
        public string LineName { get; set; }
        /// <summary>
        /// 本次开机时间
        /// </summary>
        public float BootTimeLong { get; set; } = 0;
        /// <summary>
        /// 本次开机运行时间
        /// </summary>
        public float NormalTimeLong { get; set; } = 0;
        /// <summary>
        /// 本次开机待机时间
        /// </summary>
        public float StandbyTimeLong { get; set; } = 0;
        /// <summary>
        /// 本次开机故障时间
        /// </summary>
        public float FaultTimeLong { get; set; } = 0;
        /// <summary>
        /// 本次开机缺料时间
        /// </summary>
        public float MaterialShortageTimeLong { get; set; } = 0;
        /// <summary>
        /// 本次开机维修时间
        /// </summary>
        public float MaintenanceTimeLong { get; set; } = 0;
        /// <summary>
        /// 本次开机故障停机次数
        /// </summary>
        public int FaultNumber { get; set; } = 0;
        /// <summary>
        /// 本次开机产量
        /// </summary>
        public int OutputNumber { get; set; } = 0;
        /// <summary>
        /// 本次开机合格数量
        /// </summary>
        public int QualifiedNumber { get; set; } = 0;
        /// <summary>
        /// 本次开机合格率
        /// </summary>
        public float QualifiedRate { get; set; } = 0;
        /// <summary>
        /// 设计节拍
        /// </summary>
        public float DesignRhythm { get; set; } = 0;
        /// <summary>
        /// 本次开机实际节拍
        /// </summary>
        public float RealityRhythm { get; set; } = 0;
        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime CreateTime { get; set; }
        #endregion 数据

        /// <summary>
        /// 新增数据
        /// </summary>
        /// <param name="date">数据</param>
        /// <returns></returns>
        public string ToStringInsert()
        {
            return string.Format("insert into LineWorkingData(" +
                "GUID," +
                "LineName," +
                "BootTimeLong," +
                "NormalTimeLong," +
                "StandbyTimeLong," +
                "FaultTimeLong," +
                "MaterialShortageTimeLong," +
                "MaintenanceTimeLong," +
                "FaultNumber," +
                "OutputNumber," +
                "QualifiedNumber," +
                "QualifiedRate," +
                "DesignRhythm," +
                "RealityRhythm," +
                "CreateTime" +
                ") values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}')",
                GUID,
                LineName,
                BootTimeLong,
                NormalTimeLong,
                StandbyTimeLong,
                FaultTimeLong,
                MaterialShortageTimeLong,
                MaintenanceTimeLong,
                FaultNumber,
                OutputNumber,
                QualifiedNumber,
                QualifiedRate,
                DesignRhythm,
                RealityRhythm,
                CreateTime);
        }

        /// <summary>
        /// 修改数据
        /// </summary>
        /// <param name="date">数据</param>
        /// <returns></returns>
        public string ToStringUpdate()
        {
            return string.Format("update LineWorkingData set " +
                "BootTimeLong ='{0}'," +
                "NormalTimeLong ='{1}'," +
                "StandbyTimeLong ='{2}'," +
                "FaultTimeLong ='{3}'," +
                "MaterialShortageTimeLong ='{4}'," +
                "MaintenanceTimeLong ='{5}'," +
                "FaultNumber ='{6}'," +
                "OutputNumber ='{7}'," +
                "QualifiedNumber ='{8}'," +
                "QualifiedRate ='{9}'," +
                "DesignRhythm ='{10}'," +
                "RealityRhythm ='{11}'" +
                " Where GUID = '{12}' ",
                BootTimeLong,
                NormalTimeLong,
                StandbyTimeLong,
                FaultTimeLong,
                MaterialShortageTimeLong,
                MaintenanceTimeLong,
                FaultNumber,
                OutputNumber,
                QualifiedNumber,
                QualifiedRate,
                DesignRhythm,
                RealityRhythm,
                GUID);
        }

        /// <summary>
        /// 查询数据 By Data、设备代号
        /// </summary>
        /// <param name="date">数据</param>
        /// <returns></returns>
        public string ToStringQuery()
        {
            return string.Format("select * from LineWorkingData " +
                " where LineName = '{0}' " +
                LineName);
        }

        /// <summary>
        /// 查询数据 By 开始时间~结束时间、设备代号
        /// </summary>
        /// <param name="startDate">开始时间</param>
        /// <param name="endDate">结束时间</param>
        /// <returns></returns>
        public string ToStringQuery(string startDate, string endDate)
        {
            if (LineName != "All")
            {
                return string.Format("select " +
                "GUID as 主键," +
                "LineName as 线体名称," +
                "BootTimeLong as 本次开机时间," +
                "NormalTimeLong as 本次开机运行时间," +
                "StandbyTimeLong as 本次开机待机时间," +
                "FaultTimeLong as 本次开机故障时间," +
                "MaterialShortageTimeLong as 本次开机缺料时间," +
                "MaintenanceTimeLong as 本次开机维修时间," +
                "FaultNumber as 本次开机故障停机次数," +
                "OutputNumber as 本次开机产量," +
                "QualifiedNumber as 本次开机合格数量," +
                "QualifiedRate as 本次开机合格率," +
                "DesignRhythm as 设计节拍," +
                "RealityRhythm as 本次开机实际节拍," +
                "CreateTime as 创建时间" +
                " from LineWorkingData " +
                " where CreateTime" +
                " between convert(datetime, '{0}', 120)" +
                " and     convert(datetime, '{1}', 120)" +
                " and LineName ='{2}'",
                startDate,
                endDate,
                LineName
                );
            }
            else
            {
                return string.Format("select " +
               "GUID," +
               "LineName as 线体名称," +
               "BootTimeLong as 本次开机时间," +
               "NormalTimeLong as 本次开机运行时间," +
               "StandbyTimeLong as 本次开机待机时间," +
               "FaultTimeLong as 本次开机故障时间," +
               "MaterialShortageTimeLong as 本次开机缺料时间," +
               "MaintenanceTimeLong as 本次开机维修时间," +
               "FaultNumber as 本次开机故障停机次数," +
               "OutputNumber as 本次开机产量," +
               "QualifiedNumber as 本次开机合格数量," +
               "QualifiedRate as 本次开机合格率," +
               "DesignRhythm as 设计节拍," +
               "RealityRhythm as 本次开机实际节拍," +
               "CreateTime as 创建时间" +
               "from LineWorkingData " +
               "where CreateTime " +
               "between convert(datetime, '{0}', 120) " +
               "and     convert(datetime, '{1}', 120) ",
               startDate,
               endDate);
            }
        }
    }

    /// <summary>
    /// 整线设备状态信息-本日
    /// </summary>
    public class LineWorkingData_Today
    {
        public string 线体名称 { get; set; } = string.Empty;

        public float 本日开机时间 { get; set; } = 0;
        public float 本日开机运行时间 { get; set; } = 0;
        public float 本日开机待机时间 { get; set; } = 0;
        public float 本日开机故障时间 { get; set; } = 0;
        public float 本日开机缺料时间 { get; set; } = 0;
        public float 本日开机维修时间 { get; set; } = 0;
        public int 本日故障停机次数 { get; set; } = 0;
    }
}