using System; namespace MainForm { /// /// 整线设备状态信息-本次开机 /// public class LineWorkingData_ThisTime { #region 数据 /// /// 主键 /// public string GUID { get; set; } /// /// 线体名称 /// public string LineName { get; set; } /// /// 本次开机时间 /// public float BootTimeLong { get; set; } = 0; /// /// 本次开机运行时间 /// public float NormalTimeLong { get; set; } = 0; /// /// 本次开机待机时间 /// public float StandbyTimeLong { get; set; } = 0; /// /// 本次开机故障时间 /// public float FaultTimeLong { get; set; } = 0; /// /// 本次开机缺料时间 /// public float MaterialShortageTimeLong { get; set; } = 0; /// /// 本次开机维修时间 /// public float MaintenanceTimeLong { get; set; } = 0; /// /// 本次开机故障停机次数 /// public int FaultNumber { get; set; } = 0; /// /// 本次开机产量 /// public int OutputNumber { get; set; } = 0; /// /// 本次开机合格数量 /// public int QualifiedNumber { get; set; } = 0; /// /// 本次开机合格率 /// public float QualifiedRate { get; set; } = 0; /// /// 设计节拍 /// public float DesignRhythm { get; set; } = 0; /// /// 本次开机实际节拍 /// public float RealityRhythm { get; set; } = 0; /// /// 创建时间 /// public DateTime CreateTime { get; set; } #endregion 数据 /// /// 新增数据 /// /// 数据 /// 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); } /// /// 修改数据 /// /// 数据 /// 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); } /// /// 查询数据 By Data、设备代号 /// /// 数据 /// public string ToStringQuery() { return string.Format("select * from LineWorkingData " + " where LineName = '{0}' " + LineName); } /// /// 查询数据 By 开始时间~结束时间、设备代号 /// /// 开始时间 /// 结束时间 /// 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); } } } /// /// 整线设备状态信息-本日 /// 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; } }