using iWare.Wms.Core.Enum;
|
using iWare.Wms.Core;
|
using iWare.Wms.Core.Util.LowCode.Dto;
|
using Microsoft.EntityFrameworkCore;
|
using System;
|
using System.ComponentModel;
|
using System.ComponentModel.DataAnnotations;
|
using OfficeOpenXml.FormulaParsing.Excel.Functions.DateTime;
|
|
namespace iWare.Wms.Application
|
{
|
/// <summary>
|
/// 设备运行历史输出参数
|
/// </summary>
|
[Description("设备运行历史")]
|
public class EquipmentWorkingLogOutput
|
{
|
/// <summary>
|
/// 字典类型Id
|
/// </summary>
|
[Description("设备ID")]
|
public long EquipId { get; set; }
|
|
/// <summary>
|
/// 设备编号
|
/// </summary>
|
[Description("设备编号")]
|
public string EquipmentID { get; set; }
|
|
/// <summary>
|
/// 开机时间
|
/// </summary>
|
[Description("开机时间")]
|
public DateTime? StartUpTime { get; set; }
|
|
/// <summary>
|
/// 关机时间
|
/// </summary>
|
[Description("关机时间")]
|
public DateTime? ShutDownTime { get; set; }
|
|
/// <summary>
|
/// 故障开始时间
|
/// </summary>
|
[Description("故障开始时间")]
|
public DateTime? FailureStartTime { get; set; }
|
|
/// <summary>
|
/// 故障结束时间
|
/// </summary>
|
[Description("故障结束时间")]
|
public DateTime? FailureEndTime { get; set; }
|
|
/// <summary>
|
/// 故障代码
|
/// </summary>
|
[Description("故障代码")]
|
public string FailureType { get; set; }
|
|
/// <summary>
|
/// 故障文本
|
/// </summary>
|
[Description("故障文本")]
|
public string FailureMsg { get; set; }
|
|
/// <summary>
|
/// 开始换刀时间
|
/// </summary>
|
[Description("开始换刀时间")]
|
public DateTime? KnifeToolChangeStartTime { get; set; }
|
|
/// <summary>
|
/// 结束换刀时间
|
/// </summary>
|
[Description("结束换刀时间")]
|
public DateTime? KnifeToolChangeEndTime { get; set; }
|
|
/// <summary>
|
/// 切换手动时间
|
/// </summary>
|
[Description("切换手动时间")]
|
public DateTime? ToggleManualTime { get; set; }
|
|
/// <summary>
|
/// 切换自动时间
|
/// </summary>
|
[Description("切换自动时间")]
|
public DateTime? ToggleAutoTime { get; set; }
|
|
/// <summary>
|
/// 工件履历ID
|
/// </summary>
|
[Description("工件履历ID")]
|
public long WorkPieceLogID { get; set; }
|
|
/// <summary>
|
/// 设备所属工序
|
/// </summary>
|
[Description("设备所属工序")]
|
public string WorkingProcedure { get; set; }
|
|
/// <summary>
|
/// 设备信息变更点
|
/// </summary>
|
[Description("设备信息变更点")]
|
public string MonitoringPoint { get; set; }
|
|
/// <summary>
|
/// 设备信息变更时生产工件号
|
/// </summary>
|
[Description("生产工件号")]
|
public string WorkPieceID { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[Description("备注")]
|
public string Remarks { get; set; }
|
|
/// <summary>
|
/// 履历信息新增时间
|
/// </summary>
|
[Description("履历信息新增时间")]
|
public DateTime? LogAddTime { get; set; }
|
|
/// <summary>
|
/// Id主键
|
/// </summary>
|
[Description("ID")]
|
public long Id { get; set; }
|
|
/// <summary>
|
/// 设备名称
|
/// </summary>
|
[Description("设备名称")]
|
public string EquipmentName { get; set; }
|
|
|
/// <summary>
|
/// 工件状态
|
/// </summary>
|
public string EquipmentStateName
|
{
|
get
|
{
|
try
|
{
|
return EquipmentState == null ? "" : EnumUtil.GetDescription((EnumEquipmentCurrentState)(int.Parse(EquipmentState)));
|
}
|
catch
|
{
|
return "";
|
}
|
|
}
|
}
|
public string EquipmentState { get; set; }
|
public DateTime? EquipmentStateStartTime { get; set; }
|
public DateTime? EquipmentStateEndTime { get; set; }
|
public string WarnType { get; set; }
|
public DateTime? WarnStartTime { get; set; }
|
public DateTime? WarnEndTime { get; set; }
|
public string Warnmsg { get; set; }
|
public string UpdateDesc { get; set; }
|
|
public string WarnTimeHand { get {
|
string str = "";
|
if (WarnStartTime.HasValue)
|
{
|
str += (WarnStartTime.ToString() + "-");
|
}
|
else
|
{
|
str += "-";
|
}
|
if (WarnEndTime.HasValue)
|
{
|
str += WarnEndTime.ToString();
|
}
|
return str;
|
}
|
}
|
public string EquipmentStateTimeHand
|
{
|
get
|
{
|
string str = "";
|
if (EquipmentStateStartTime.HasValue)
|
{
|
str += (EquipmentStateStartTime.ToString() + "-");
|
}
|
else
|
{
|
str += "-";
|
}
|
if (EquipmentStateEndTime.HasValue)
|
{
|
str += EquipmentStateEndTime.ToString();
|
}
|
return str;
|
}
|
}
|
public double EquipmentStateTimeCount
|
{
|
get
|
{
|
double str = 0;
|
if (EquipmentStateStartTime.HasValue)
|
{
|
if (EquipmentStateEndTime.HasValue)
|
{
|
str = (EquipmentStateEndTime.Value- EquipmentStateStartTime.Value).TotalHours;
|
}
|
else
|
{
|
//str=(DateTime.Now - EquipmentStateStartTime.Value).TotalHours;
|
str = 0;
|
}
|
}
|
else
|
{
|
str = 0;
|
}
|
return str;
|
}
|
}
|
public string FailureTimeHand
|
{
|
get
|
{
|
string str = "";
|
if (FailureStartTime.HasValue)
|
{
|
str += (FailureStartTime.ToString() + "-");
|
}
|
else
|
{
|
str += "-";
|
}
|
if (FailureEndTime.HasValue)
|
{
|
str += FailureEndTime.ToString();
|
}
|
return str;
|
}
|
}
|
}
|
|
/// <summary>
|
/// 导出Excel文件中字段
|
/// </summary>
|
[Description("设备运行历史")]
|
public class EquipmentExcelOutput
|
{
|
/// <summary>
|
/// 设备编号
|
/// </summary>
|
[Description("设备编号")]
|
public string EquipmentId { get; set; }
|
/// <summary>
|
/// 设备名称
|
/// </summary>
|
[Description("设备名称")]
|
public string EquipmentName { get; set; }
|
/// <summary>
|
/// 变更描述
|
/// </summary>
|
[Description("变更描述")]
|
public string UpdateDesc { get; set; }
|
|
///// <summary>
|
///// 故障代码
|
///// </summary>
|
//[Description("故障代码")]
|
//public string FailureType { get; set; }
|
|
/// <summary>
|
/// 故障文本
|
/// </summary>
|
[Description("故障文本")]
|
public string FailureMsg { get; set; }
|
/// <summary>
|
/// 故障开始时间
|
/// </summary>
|
[Description("故障开始时间")]
|
public DateTime? FailureStartTime { get; set; }
|
/// <summary>
|
/// 故障结束时间
|
/// </summary>
|
[Description("故障结束时间")]
|
public DateTime? FailureEndTime { get; set; }
|
/// <summary>
|
/// 告警文本
|
/// </summary>
|
[Description("告警文本")]
|
public string Warnmsg { get; set; }
|
/// <summary>
|
/// 告警开始时间
|
/// </summary>
|
[Description("告警开始时间")]
|
public DateTime? WarnStartTime { get; set; }
|
/// <summary>
|
/// 告警结束时间
|
/// </summary>
|
[Description("告警结束时间")]
|
public DateTime? WarnEndTime { get; set; }
|
|
/// <summary>
|
/// 工件状态
|
/// </summary>
|
[Description("设备状态")]
|
public string EquipmentStateName { get; set; }
|
//public string EquipmentState { get; set; }
|
[Description("状态开始")]
|
public DateTime? EquipmentStateStartTime { get; set; }
|
[Description("状态结束")]
|
public DateTime? EquipmentStateEndTime { get; set; }
|
|
|
/// <summary>
|
/// 履历信息新增时间
|
/// </summary>
|
[Description("履历信息新增时间")]
|
public DateTime? LogAddTime { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[Description("备注")]
|
public string Remarks { get; set; }
|
}
|
}
|
