using iWare.Wms.Core.Util.LowCode.Dto; using Microsoft.EntityFrameworkCore; using System; using System.ComponentModel; namespace iWare.Wms.Application { public class UpdateQualityStateInput { /// /// 工件号 /// public List WorkPieceIDList { get; set; } /// /// 质量状态 /// public string QualityState { get; set; } /// /// 质量不合格原因 /// public string QualityErrorInfo { get; set; } /// /// 工件状态 /// public string WorkPieceState { get; set; } /// /// 工序 /// public string WorkingProcedure { get; set; } /// /// 密码 /// public string Password { get; set; } } /// /// 质量数据查询输出参数 /// public class QualityDataInfoOutput { /// /// 工件号 /// public string WorkPieceID { get; set; } /// /// 设备 /// public string EquipmentID { get; set; } /// /// 设备名称 /// public string EquipmentName { get; set; } /// /// 工序 /// public string WorkingProcedure { get; set; } /// /// 质量状态 /// public int QualityState { get; set; } /// /// 质量状态名称 /// public string QualityStateName { get { if (1 == QualityState) { return "合格"; } else if (2 == QualityState) { return "不合格"; } else if (3 == QualityState) { return "疑似"; } else { return ""; } } } public string GetQualityStateName(string State) { int qs = QualityState; int.TryParse(State, out qs); if (1 == qs) { return "合格"; } else if (2 == qs) { return "不合格"; } else if (3 == qs) { return "疑似"; } else { return ""; } } /// /// 质量状态名称 /// public string QualityStateNameHand { get { if(string.IsNullOrEmpty(EquipmentID)) { return string.Empty; } string qs = ""; if(EquipmentID.Equals("EOP10")) { if (string.IsNullOrEmpty(WorkingProcedure)) { return (string.IsNullOrEmpty(OP10QualityState)|| string.IsNullOrEmpty(OP40QualityState))?(GetQualityStateName(OP10QualityState)+ GetQualityStateName(OP40QualityState)): ((GetQualityStateName(OP10QualityState) +"|"+ GetQualityStateName(OP40QualityState))); } if (WorkingProcedure.Equals("OP10")) { qs=OP10QualityState; } else { qs = OP40QualityState; } } else if(EquipmentID.Equals("EOP20")) { qs = OP20QualityState; } else if (EquipmentID.Equals("EOP30")) { qs = OP30QualityState; } else if (EquipmentID.Equals("EOP35")) { qs = OP35QualityState; } else if (EquipmentID.Equals("EOP60")) { qs = OP60QualityState; } else if (EquipmentID.Equals("EOP80")) { qs = OP80QualityState; } return GetQualityStateName(qs.ToString()); } } /// /// 操作方式 /// public string QualityStateUpdateMode { get; set; } /// /// 操作人 /// public string QualityStateUpdateUser { get; set; } /// /// 质量接收时间 /// public DateTime QualityReceiveTime { get; set; } /// /// 质量接收时间 /// public string QualityReceiveTimeHand { get { if (string.IsNullOrEmpty(EquipmentID)) { return QualityReceiveTime.ToString(); } if (EquipmentID.Equals("EOP10")) { if (string.IsNullOrEmpty(WorkingProcedure)) { return OP10QualityReceiveTime.ToString()+ ((OP10QualityReceiveTime.HasValue&& OP40QualityReceiveTime.HasValue)?"|":"")+ OP40QualityReceiveTime.ToString(); } if (WorkingProcedure.Equals("OP10")) { return OP10QualityReceiveTime.ToString(); } else { return OP40QualityReceiveTime.ToString(); } } else if (EquipmentID.Equals("EOP20")) { return OP20QualityReceiveTime.ToString(); } else if (EquipmentID.Equals("EOP30")) { return OP30QualityReceiveTime.ToString(); } else if (EquipmentID.Equals("EOP35")) { return OP35QualityReceiveTime.ToString(); } else if (EquipmentID.Equals("EOP60")) { return OP60QualityReceiveTime.ToString(); } else if (EquipmentID.Equals("EOP80")) { return OP80QualityReceiveTime.ToString(); } return QualityReceiveTime.ToString(); } } private DateTime? m_EndTime=null; /// /// 下线时间 /// public DateTime? OfflineTime { get { if (m_EndTime.HasValue&& m_EndTime.Value.Date==DateTime.Parse("0001-01-01")) { return null; } else { return m_EndTime; } } set { m_EndTime = value; } } /// /// 连杆厚度;OP10/OP40 /// public string QualityOP10To1 { get; set; } public string QualityOP40To1 { get; set; } /// /// 小头孔直径;OP20/OP60/OP80 /// public string QualityOP20To1 { get; set; } /// /// 涨断力矩;OP30 /// public string QualityOP30To1 { get; set; } /// /// 预拧紧力矩(CH1);OP30 /// public string QualityOP30To2 { get; set; } /// /// 预拧紧力矩(CH2);OP30 /// public string QualityOP30To8 { get; set; } /// /// 最终力矩(CH3);OP30 /// public string QualityOP30To3 { get; set; } /// /// 终拧紧力矩(CH3);OP30 /// public string QualityOP30To4 { get; set; } /// /// 终拧紧角度(CH3);OP30 /// public string QualityOP30To5 { get; set; } /// /// 最终力矩(CH4);OP30 /// public string QualityOP30To9 { get; set; } /// /// 终拧紧力矩(CH4);OP30 /// public string QualityOP30To10 { get; set; } /// /// 终拧紧角度(CH4);OP30 /// public string QualityOP30To11 { get; set; } /// /// 衬套压装力矩;OP30 /// public string QualityOP30To6 { get; set; } /// /// 衬套压装位移;OP30 /// public string QualityOP30To7 { get; set; } /// /// 压装力矩;OP35 /// public string QualityOP35To1 { get; set; } /// /// Y轴位移;OP35 /// public string QualityOP35To2 { get; set; } /// /// 大头孔直径;OP60/OP80 /// public string QualityOP60To1 { get; set; } /// /// 校验码结果;OP60 /// public string QualityOP60To2 { get; set; } /// /// 清洗温度;OP70 /// public string QualityOP70To1 { get; set; } /// /// 清洗压力;OP70 /// public string QualityOP70To2 { get; set; } /// /// 出口处工件温度;OP70 /// public string QualityOP70To3 { get; set; } /// /// 大头重量;OP80 /// public string QualityOP80To1 { get; set; } /// /// 小头重量;OP80 /// public string QualityOP80To2 { get; set; } /// /// 总重;OP80 /// public string QualityOP80To3 { get; set; } /// /// 弯曲;OP80 /// public string QualityOP80To4 { get; set; } /// /// 扭度;OP80 /// public string QualityOP80To5 { get; set; } /// /// 大头垂直度;OP80 /// public string QualityOP80To6 { get; set; } /// /// 大头孔分组级别;OP80 /// public string QualityOP80To7 { get; set; } /// /// 小头孔分组级别;OP80 /// public string QualityOP80To8 { get; set; } /// /// 重量组别;OP80 /// public string QualityOP80To9 { get; set; } /// /// 小头垂直度;OP80 /// public virtual string QualityOP80To10 { get; set; } public DateTime? OP10QualityReceiveTime { get; set; } public DateTime? OP20QualityReceiveTime { get; set; } public DateTime? OP30QualityReceiveTimeCH3 { get; set; } public DateTime? OP30QualityReceiveTimeCH4 { get; set; } public DateTime? OP30QualityReceiveTimeCH5 { get; set; } public DateTime? OP30QualityReceiveTimeCH6 { get; set; } public DateTime? OP30QualityReceiveTime { get; set; } public DateTime? OP35QualityReceiveTime { get; set; } public DateTime? OP40QualityReceiveTime { get; set; } public DateTime? OP60QualityReceiveTime { get; set; } public DateTime? OP80QualityReceiveTime { get; set; } public string OP10QualityState { get; set; } public string OP20QualityState { get; set; } public string OP30QualityStateCH3 { get; set; } public string OP30QualityStateCH4 { get; set; } public string OP30QualityStateCH5 { get; set; } public string OP30QualityStateCH6 { get; set; } public string OP30QualityState { get; set; } public string OP35QualityState { get; set; } public string OP40QualityState { get; set; } public string OP60QualityState { get; set; } public string OP80QualityState { get; set; } /// /// 备注 /// public string Remarks { get; set; } /// /// Id主键 /// public long Id { get; set; } /// /// 创建时间 /// public DateTimeOffset ?CreatedTime { get; set; } /// /// 创建时间 /// public DateTimeOffset? UpdateTime { get; set; } } /// /// 导出Excel文件中字段 /// [Description("设备质量数据")] public class QualityDataExcelOutput { /// /// 工件号 /// [Description("工件号")] public string WorkPieceID { get; set; } /// /// 设备 /// public string EquipmentID { get; set; } /// /// 设备名称 /// [Description("设备名称")] public string EquipmentName { get; set; } /// /// 工序 /// [Description("工序")] public string WorkingProcedure { get; set; } /// /// 质量状态 /// public int QualityState { get; set; } /// /// 质量状态名称 /// [Description("质量状态")] public string QualityStateName{ get; set; } /// /// 操作方式 /// [Description("操作方式")] public string QualityStateUpdateMode { get; set; } /// /// 操作人 /// [Description("操作人")] public string QualityStateUpdateUser { get; set; } /// /// 质量接收时间 /// [Description("质量接收时间")] public DateTime QualityReceiveTime { get; set; } /// /// 下线时间 /// [Description("下线时间")] public DateTime OfflineTime { get; set; } /// /// 连杆厚度 /// [Description("连杆厚度")] public string QualityOP10To1 { get; set; } public string QualityOP40To1 { get; set; } /// /// 小头孔直径 /// [Description("小头孔直径")] public string QualityOP20To1 { get; set; } /// /// 涨断力矩 /// [Description("涨断力矩")] public string QualityOP30To1 { get; set; } /// /// 预拧紧力矩(CH1);OP30 /// [Description("预拧紧力矩(CH1)")] public string QualityOP30To2 { get; set; } /// /// 预拧紧力矩(CH2);OP30 /// [Description("预拧紧力矩(CH2)")] public string QualityOP30To8 { get; set; } /// /// 最终力矩(CH3);OP30 /// [Description("最终力矩(CH3)")] public string QualityOP30To3 { get; set; } /// /// 终拧紧力矩(CH3);OP30 /// [Description("终拧紧力矩(CH3)")] public string QualityOP30To4 { get; set; } /// /// 终拧紧角度(CH3);OP30 /// [Description("终拧紧角度(CH3)")] public string QualityOP30To5 { get; set; } /// /// 最终力矩(CH4);OP30 /// [Description("最终力矩(CH4)")] public string QualityOP30To9 { get; set; } /// /// 终拧紧力矩(CH4);OP30 /// [Description("终拧紧力矩(CH4)")] public string QualityOP30To10 { get; set; } /// /// 终拧紧角度(CH4);OP30 /// [Description("终拧紧角度(CH4)")] public string QualityOP30To11 { get; set; } /// /// 衬套压装力矩 /// [Description("衬套压装力矩")] public string QualityOP30To6 { get; set; } /// /// 衬套压装位移 /// [Description("衬套压装位移")] public string QualityOP30To7 { get; set; } /// /// 压装力矩 /// [Description("压装力矩")] public string QualityOP35To1 { get; set; } /// /// Y轴位移 /// [Description("Y轴位移")] public string QualityOP35To2 { get; set; } /// /// 大头孔直径 /// [Description("大头孔直径")] public string QualityOP60To1 { get; set; } /// /// 校验码结果 /// [Description("校验码结果")] public string QualityOP60To2 { get; set; } /// /// 清洗温度 /// [Description("清洗温度")] public string QualityOP70To1 { get; set; } /// /// 清洗压力 /// [Description("清洗压力")] public string QualityOP70To2 { get; set; } /// /// 出口处工件温度 /// [Description("出口处工件温度")] public string QualityOP70To3 { get; set; } /// /// 大头重量 /// [Description("大头重量")] public string QualityOP80To1 { get; set; } /// /// 小头重量 /// [Description("小头重量")] public string QualityOP80To2 { get; set; } /// /// 总重 /// [Description("总重")] public string QualityOP80To3 { get; set; } /// /// 弯曲 /// [Description("弯曲")] public string QualityOP80To4 { get; set; } /// /// 扭度 /// [Description("扭度")] public string QualityOP80To5 { get; set; } /// /// 大头垂直度 /// [Description("大头垂直度")] public string QualityOP80To6 { get; set; } /// /// 小头垂直度;OP80 /// [Description("小头垂直度")] public virtual string QualityOP80To10 { get; set; } /// /// 大头孔分组级别 /// [Description("大头孔分组级别")] public string QualityOP80To7 { get; set; } /// /// 小头孔分组级别 /// [Description("小头孔分组级别")] public string QualityOP80To8 { get; set; } /// /// 重量组别 /// [Description("重量组别")] public string QualityOP80To9 { get; set; } /// /// 备注 /// [Description("备注")] public string Remarks { get; set; } /// /// Id主键 /// public long Id { get; set; } /// /// 创建时间 /// [Description("时间")] public DateTimeOffset? CreatedTime { get; set; } } /// /// 数控双端面磨床(OP10/40)设备实体输出 /// [Description("数控双端面磨床设备")] public class QualityDataOP1040Output { /// /// 工件号 /// [Description("工件号")] public string WorkPieceID { get; set; } /// /// 设备 /// [Description("设备编号")] public string EquipmentID { get; set; } /// /// 质量状态 /// [Description("质量状态")] public string QualityStateNameHand { get; set; } /// /// 测量时间 /// [Description("测量时间")] public string QualityReceiveTimeHand { get; set; } /// /// 连杆厚度 /// [Description("OP10连杆厚度")] public string QualityOP10To1 { get; set; } [Description("OP40连杆厚度")] public string QualityOP40To1 { get; set; } } /// /// 数控四工位组合机床(OP20)设备实体输出 /// [Description("数控四工位组合机床设备")] public class QualityDataOP20Output { /// /// 工件号 /// [Description("工件号")] public string WorkPieceID { get; set; } /// /// 设备 /// [Description("设备编号")] public string EquipmentID { get; set; } /// /// 质量状态 /// [Description("质量状态")] public string QualityStateNameHand { get; set; } /// /// 测量时间 /// [Description("测量时间")] public string QualityReceiveTimeHand { get; set; } /// /// 小头孔直径;OP20/OP60/OP80 /// [Description("小头孔直径")] public string QualityOP20To1 { get; set; } } /// /// 激光涨断装配机床(OP30)设备实体输出 /// [Description("激光涨断装配机床设备")] public class QualityDataOP30Output { /// /// 工件号 /// [Description("工件号")] public string WorkPieceID { get; set; } /// /// 设备 /// [Description("设备编号")] public string EquipmentID { get; set; } /// /// 质量状态 /// [Description("质量状态")] public string QualityStateNameHand { get; set; } /// /// 测量时间 /// [Description("测量时间")] public string QualityReceiveTimeHand { get; set; } /// /// 涨断力矩;OP30 /// [Description("涨断力矩")] public string QualityOP30To1 { get; set; } /// /// 预拧紧力矩(CH1);OP30 /// [Description("预拧紧力矩(CH1)")] public string QualityOP30To2 { get; set; } /// /// 预拧紧力矩(CH2);OP30 /// [Description("预拧紧力矩(CH2)")] public string QualityOP30To8 { get; set; } /// /// 最终力矩(CH3);OP30 /// [Description("最终力矩(CH3)")] public string QualityOP30To3 { get; set; } /// /// 终拧紧力矩(CH3);OP30 /// [Description("终拧紧力矩(CH3)")] public string QualityOP30To4 { get; set; } /// /// 终拧紧角度(CH3);OP30 /// [Description("终拧紧角度(CH3)")] public string QualityOP30To5 { get; set; } /// /// 最终力矩(CH4);OP30 /// [Description("最终力矩(CH4)")] public string QualityOP30To9 { get; set; } /// /// 终拧紧力矩(CH4);OP30 /// [Description("终拧紧力矩(CH4)")] public string QualityOP30To10 { get; set; } /// /// 终拧紧角度(CH4);OP30 /// [Description("终拧紧角度(CH4)")] public string QualityOP30To11 { get; set; } /// /// 衬套压装力矩;OP30 /// [Description("衬套压装力矩")] public string QualityOP30To6 { get; set; } /// /// 衬套压装位移;OP30 /// [Description("衬套压装位移")] public string QualityOP30To7 { get; set; } } /// /// 连杆衬套精整专机(OP35)设备实体输出 /// [Description("连杆衬套精整专机设备")] public class QualityDataOP35Output { /// /// 工件号 /// [Description("工件号")] public string WorkPieceID { get; set; } /// /// 设备 /// [Description("设备编号")] public string EquipmentID { get; set; } /// /// 质量状态 /// [Description("质量状态")] public string QualityStateNameHand { get; set; } /// /// 测量时间 /// [Description("测量时间")] public string QualityReceiveTimeHand { get; set; } /// /// 压装力矩;OP35 /// [Description("压装力矩")] public string QualityOP35To1 { get; set; } /// /// Y轴位移;OP35 /// [Description("Y轴位移")] public string QualityOP35To2 { get; set; } } /// /// 数控四工位组合机(OP50)设备实体输出 /// [Description("数控四工位组合机设备")] public class QualityDataOP50Output { /// /// 工件号 /// [Description("工件号")] public string WorkPieceID { get; set; } /// /// 工序 /// [Description("工序")] public string WorkingProcedure { get; set; } /// /// 质量状态 /// [Description("质量状态")] public string QualityStateName { get; set; } /// /// 操作方式 /// [Description("操作方式")] public string QualityStateUpdateMode { get; set; } /// /// 操作人 /// [Description("操作人")] public string QualityStateUpdateUser { get; set; } /// /// 质量接收时间 /// [Description("质量接收时间")] public DateTime QualityReceiveTime { get; set; } } /// /// 反向加工中心(OP60)设备实体输出 /// [Description("反向加工中心设备")] public class QualityDataOP60Output { /// /// 工件号 /// [Description("工件号")] public string WorkPieceID { get; set; } /// /// 设备 /// [Description("设备编号")] public string EquipmentID { get; set; } /// /// 质量状态 /// [Description("质量状态")] public string QualityStateNameHand { get; set; } /// /// 测量时间 /// [Description("测量时间")] public string QualityReceiveTimeHand { get; set; } /// /// 大头孔直径;OP60/OP80 /// [Description("大头孔直径")] public string QualityOP60To1 { get; set; } /// /// 校验码结果;OP60 /// [Description("校验码结果")] public string QualityOP60To2 { get; set; } } /// /// 清洗机(OP70)设备实体输出 /// [Description("清洗机设备")] public class QualityDataOP70Output { /// /// 工件号 /// [Description("工件号")] public string WorkPieceID { get; set; } /// /// 工序 /// [Description("工序")] public string WorkingProcedure { get; set; } /// /// 质量状态 /// [Description("质量状态")] public string QualityStateName { get; set; } /// /// 清洗温度;OP70 /// [Description("清洗温度")] public string QualityOP70To1 { get; set; } /// /// 清洗压力;OP70 /// [Description("清洗压力")] public string QualityOP70To2 { get; set; } /// /// 出口处工件温度;OP70 /// [Description("出口处工件温度")] public string QualityOP70To3 { get; set; } } /// /// 测量机(OP80)设备实体输出 /// [Description("测量机设备")] public class QualityDataOP80Output { /// /// 工件号 /// [Description("工件号")] public string WorkPieceID { get; set; } /// /// 设备 /// [Description("设备编号")] public string EquipmentID { get; set; } /// /// 质量状态 /// [Description("质量状态")] public string QualityStateNameHand { get; set; } /// /// 测量时间 /// [Description("测量时间")] public string QualityReceiveTimeHand { get; set; } /// /// 大头重量;OP80 /// [Description("大头重量")] public string QualityOP80To1 { get; set; } /// /// 小头重量;OP80 /// [Description("小头重量")] public string QualityOP80To2 { get; set; } /// /// 总重;OP80 /// [Description("总重")] public string QualityOP80To3 { get; set; } /// /// 弯曲;OP80 /// [Description("弯曲")] public string QualityOP80To4 { get; set; } /// /// 扭度;OP80 /// [Description("扭度")] public string QualityOP80To5 { get; set; } /// /// 大头垂直度;OP80 /// [Description("大头垂直度")] public string QualityOP80To6 { get; set; } /// /// 小头垂直度;OP80 /// [Description("小头垂直度")] public string QualityOP80To10 { get; set; } /// /// 大头孔分组级别;OP80 /// [Description("大头孔分组级别")] public string QualityOP80To7 { get; set; } /// /// 小头孔分组级别;OP80 /// [Description("小头孔分组级别")] public string QualityOP80To8 { get; set; } /// /// 重量组别;OP80 /// [Description("重量组别")] public string QualityOP80To9 { get; set; } } }