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;
}
}