| | |
| | | using iWare_SCADA_BusinessLogical.Utils; |
| | | using HslCommunication.BasicFramework; |
| | | using iWare.Wms.Core; |
| | | using iWare_SCADA_BusinessLogical.Utils; |
| | | using iWare_SCADA_Model; |
| | | using iWare_SCADA_Model.MiddleModel; |
| | | using iWare_SCADA_Model.TableModel; |
| | |
| | | using System.Collections.Concurrent; |
| | | using System.Collections.Generic; |
| | | using System.ComponentModel.DataAnnotations; |
| | | using System.Data.Entity.Validation; |
| | | using System.Diagnostics; |
| | | //using System.Data.Entity.Infrastructure; |
| | | using System.Linq; |
| | |
| | | { |
| | | public class WorkPieceInfoManager |
| | | { |
| | | public static WorkPieceInfo GetWorkPieceInfo(string WorkPieceID) |
| | | { |
| | | using (DbModel db = new DbModel()) |
| | | { |
| | | //查询所有 |
| | | var query = db.WorkPieceInfo.Where(o => o.WorkPieceID == WorkPieceID).FirstOrDefault(); |
| | | return query; |
| | | } |
| | | } |
| | | //public static WorkPieceInfo GetWorkPieceInfo(string WorkPieceID) |
| | | //{ |
| | | // using (DbModel db = new DbModel()) |
| | | // { |
| | | // //查询所有 |
| | | // var query = db.WorkPieceInfo.Where(o => o.WorkPieceID == WorkPieceID).FirstOrDefault(); |
| | | // return query; |
| | | // } |
| | | //} |
| | | |
| | | |
| | | public static long InsertWorkPieceInfo(WorkPieceInfo workPiece) |
| | | { |
| | | using (DbModel db = new DbModel()) |
| | | { |
| | | db.WorkPieceInfo.Add(workPiece); |
| | | db.SaveChanges(); |
| | | return workPiece.Id; |
| | | } |
| | | } |
| | | //public static long InsertWorkPieceInfo(WorkPieceInfo workPiece) |
| | | //{ |
| | | // using (DbModel db = new DbModel()) |
| | | // { |
| | | // db.WorkPieceInfo.Add(workPiece); |
| | | // db.SaveChanges(); |
| | | // return workPiece.Id; |
| | | // } |
| | | //} |
| | | |
| | | public static WorkPieceLogMiddle GetAddWorkPieceLog(WorkPieceLogMiddle loginfo) |
| | | { |
| | | loginfo.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | return loginfo; |
| | | } |
| | | //public static WorkPieceLogMiddle GetAddWorkPieceLog(WorkPieceLogMiddle loginfo) |
| | | //{ |
| | | // loginfo.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | // return loginfo; |
| | | //} |
| | | |
| | | /// <summary> |
| | | /// 给WorkPieceLog主键等公共的的属性赋值 |
| | |
| | | public static WorkPieceLog GetAddWorkPieceLog(WorkPieceLog loginfo) |
| | | { |
| | | loginfo.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | PieceLogTypeEnum pieceLogTypeEnum = PieceLogTypeEnum.正常; |
| | | loginfo.PieceLogType = (int)pieceLogTypeEnum; |
| | | loginfo.PieceLogTypeName = pieceLogTypeEnum.ToString(); |
| | | return loginfo; |
| | | } |
| | | public static WorkPieceLog GetAddWorkPieceLog1(WorkPieceLogMiddle loginfo) |
| | | { |
| | | loginfo.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | return loginfo; |
| | | } |
| | | //public static WorkPieceLog GetAddWorkPieceLog1(WorkPieceLogMiddle loginfo) |
| | | //{ |
| | | // loginfo.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | // return loginfo; |
| | | //} |
| | | /// <summary> |
| | | /// 通过WorkPieceInfo 给WorkPieceInfoLog 属性赋值 |
| | | /// </summary> |
| | |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | loginfo.Remarks = (loginfo.Remarks ?? "") + $"{loginfo.WorkPieceID ?? "空"}刀具寿命更新数据异常{ex.Message}"; |
| | | loginfo.Remarks = $"{loginfo.WorkPieceID ?? "空"}刀具寿命更新数据异常{ex.Message}"; |
| | | |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 读取二维码时逻辑 |
| | | /// 校验工件是否跳序,质量是否合格 |
| | | /// </summary> |
| | | public static void ReadQRcode(WorkPieceLog loginfo, LogType type, PLCService plcService, int? IsFeedback) |
| | | {//此处同时插入了WorkPieceLog,WorkPieceInfoLog表,并新增或修改WorkPieceInfo表 |
| | | using (DbModel db = new DbModel()) |
| | | { |
| | | try |
| | | { |
| | | bool isAddWorkPieceInfo = false; |
| | | if (loginfo.WorkPieceID.Length == 22) |
| | | { |
| | | WorkPieceInfo info = new WorkPieceInfo(); |
| | | info = db.WorkPieceInfo.Where(o => o.WorkPieceID == loginfo.WorkPieceID).FirstOrDefault(); |
| | | if (info == null || info.WorkPieceID.Length < 1) |
| | | {//插入WorkPieceInfo表 |
| | | loginfo = CommonManager.Instance.GetWorkPieceID(loginfo, type); |
| | | info = EntityPropHelper.Mapper<WorkPieceInfo, WorkPieceLog>(loginfo); |
| | | //EntityPropHelper<WorkPieceLog, WorkPieceInfo>.CopyProp(loginfo, info, loginfo.GetWorkPieceInfoDict()); |
| | | if (!loginfo.WorkingProcedure.Equals("OP05")) |
| | | {//当工件二维码第一次出现的工序不是OP05,则设置为可疑状态 |
| | | info.QualityState = (int)QualityState.Suspected; |
| | | info.QualityErrorInfo = $"工件二维码第一次出现的工序{loginfo.MonitoringPoint}不是OP05,数据缺失,请确认情况并做相应处理!"; |
| | | info.Remarks = $"工件二维码第一次出现的工序{loginfo.WorkingProcedure}不是OP05,数据缺失,请确认情况并做相应处理!"; |
| | | } |
| | | else |
| | | { |
| | | info.QualityState = (int)QualityState.OK;//此处需要注意,判断所有工序质量,然后再赋值 |
| | | info.Remarks = "OP05新增工件信息"; |
| | | } |
| | | info.WorkPieceinitOnlineTime = DateTimeHelper.GetDateTime(); |
| | | info.WorkingProcedurePlan = ConfigHelper.GetConfigString("WorkingProcedureAllStr") ?? "OP05OP10OP20OP30OP35OP40OP50OP60OP70OP80"; |
| | | info.CreatedUserName = loginfo.MonitoringPoint; |
| | | info.CreatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | info = ParseQRCode(info); |
| | | isAddWorkPieceInfo = true; |
| | | } |
| | | else |
| | | { |
| | | if (info.WorkingProcedureCurrent.Equals("OP05")) |
| | | { |
| | | loginfo.Remarks = (loginfo.Remarks ?? "") + $"读取二维码{loginfo.WorkPieceID ?? "空"} OP05工序重复读取了"; |
| | | return; |
| | | } |
| | | } |
| | | info.WorkingProcedureStartTime = DateTimeHelper.GetDateTime();// |
| | | info.WorkingProcedureEndTime = null; |
| | | info.WorkPieceState = (int)WorkPieceState.WIP; |
| | | info.EquipmentID = loginfo.EquipmentID; |
| | | info.QualityStateUpdateUser = loginfo.UpdatedUserName; |
| | | info.QualityStateUpdateTime = loginfo.UpdatedTime.Value.LocalDateTime; |
| | | info.QualityStateUpdateMode = QualityStateUpdateMode.Auto.ToString(); |
| | | info.UpdatedUserName = loginfo.MonitoringPoint; |
| | | info.UpdatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | info.WorkPieceCurrentPosition = loginfo.WorkingProcedure; |
| | | info.WorkPieceCurrentPositionOrder = info.WorkingProcedurePlan.IndexOf(loginfo.WorkingProcedure) / 2; |
| | | info.WorkingProcedureCurrent = loginfo.WorkingProcedure; |
| | | info.Remarks = info.Remarks ?? "" + $"{info.WorkingProcedureCurrent}工件上线"; |
| | | |
| | | var pro = db.WorkPieceProcess.Where(o => o.WorkPieceID == loginfo.WorkPieceID && !o.OperationType.Equals("SPC") && (o.EndTime == null || o.EndTime <= DateTime.MinValue)).OrderByDescending(o => o.StartTime).FirstOrDefault(); |
| | | if (pro != null && pro.WorkPieceID.Length > 1) |
| | | { |
| | | pro.EndTime = DateTimeHelper.GetDateTime(); |
| | | pro.UpdatedUserName = loginfo.MonitoringPoint; |
| | | pro.UpdatedTime = DateTimeHelper.GetDateTime(); |
| | | pro.Remarks = (pro.Remarks ?? "") + "又一次上线,更新结束时间"; |
| | | } |
| | | //每次扫描上线都插入追溯表 |
| | | WorkPieceProcess process = new WorkPieceProcess(); |
| | | process = EntityPropHelper.Mapper<WorkPieceProcess, WorkPieceInfo>(info); |
| | | process.StartTime = DateTimeHelper.GetDateTime(); |
| | | process.QualityState = info.QualityState.HasValue ? info.QualityState.Value : (int)QualityState.OK; |
| | | process.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | process.CreatedUserName = loginfo.MonitoringPoint; |
| | | process.CreatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | process.UpdatedUserName = loginfo.MonitoringPoint; |
| | | process.UpdatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | process.OperationType = OperationType.生产.ToString(); |
| | | process.Remarks = ""; |
| | | if (loginfo.WorkingProcedure.Equals("OP05")) |
| | | { |
| | | process.EndTime = process.StartTime; |
| | | } |
| | | db.WorkPieceProcess.Add(process); |
| | | |
| | | //db.Database.AutoTransactionsEnabled = false;// 同一个SaveChanges默认事务, 关闭默认事务:... 好像不能用啊,后面再研究吧 |
| | | if (isAddWorkPieceInfo) |
| | | { |
| | | db.WorkPieceInfo.Add(info); |
| | | } |
| | | else |
| | | {//不确定info是直接会修改还是需要再次查询,待测试 |
| | | //info.Remarks = "修改,具体修改逻辑待定"; |
| | | } |
| | | |
| | | #region 判断是否跳序,或质量不符合 然后反馈PLC |
| | | if (IsFeedback.HasValue && IsFeedback.Value == (int)FeedbackMode.FeedbackPLC) |
| | | { |
| | | bool checkQualityInfoCompleteFlag = false; |
| | | bool plcFlag = true;//反馈给PLC的标记 |
| | | string message = ""; |
| | | checkQualityInfoCompleteFlag = WorkPieceInfoManager.CheckQualityInfoComplete(info, loginfo, type); |
| | | |
| | | if (!checkQualityInfoCompleteFlag || info.QualityState != (int)QualityState.OK) |
| | | { |
| | | plcFlag = false; |
| | | message = !checkQualityInfoCompleteFlag ? "跳序," : ""; |
| | | message += info.QualityState != (int)QualityState.OK ? "质量不符合" : ""; |
| | | } |
| | | ////反馈给PLC,(写入点待定) |
| | | //MessageModel fr = null; |
| | | //fr = plcService.WriteValuePoint("", "", plcFlag, PLCManger.GetTypeForString("bool")); |
| | | //if (fr.result) |
| | | //{ |
| | | // Log4NetHelper.WriteInfoLog(type, $" 工件{info.WorkPieceID} {loginfo.WorkingProcedure}工序反馈给PLC 成功, 出现 {message}"); |
| | | //} |
| | | //else |
| | | //{ |
| | | // Log4NetHelper.WriteErrorLog(type, $" 工件{info.WorkPieceID} {loginfo.WorkingProcedure}工序反馈给PLC 失败, 出现 {message} ,失败原因:{fr.resMsg}"); |
| | | //} |
| | | |
| | | //#region 反馈PLC |
| | | |
| | | //bool checkQualityInfoCompleteFlag = false; |
| | | //bool plcFlag = true;//反馈给PLC的标记 |
| | | //string message = ""; |
| | | //checkQualityInfoCompleteFlag = WorkPieceInfoManager.CheckQualityInfoComplete(info, wplog, PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure)); |
| | | |
| | | //if (!checkQualityInfoCompleteFlag || info.QualityState != (int)QualityState.OK) |
| | | //{ |
| | | // plcFlag = false; |
| | | // message = !checkQualityInfoCompleteFlag ? "跳序," : ""; |
| | | //message += info.QualityState != (int)QualityState.OK ? "质量不符合" : ""; |
| | | //} |
| | | ////反馈给PLC,(写入点待定) |
| | | //MessageModel fr = null; |
| | | //fr = plcService.WriteValuePoint("", "", plcFlag, PLCManger.GetTypeForString("bool")); |
| | | //if (fr.result) |
| | | //{ |
| | | // Log4NetHelper.WriteInfoLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure), $" 工件{wplog.WorkPieceID} {WorkingProcedure}工序反馈给PLC 成功, 出现 {message}"); |
| | | //} |
| | | //else |
| | | //{ |
| | | // Log4NetHelper.WriteErrorLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure), $" 工件{wplog.WorkPieceID} {WorkingProcedure}工序反馈给PLC 失败, 出现 {message} ,失败原因:{fr.resMsg}"); |
| | | //} |
| | | //#endregion |
| | | } |
| | | else |
| | | {//读码完成若工件质量不符合或发生跳序,不用管设备是否把工件放过去,数采系统都不变更当前工序,反馈设备PLC工件不符合, |
| | | //若工序后续收集点收到相关工件信息再变更当前工序, 但质量信息不变 |
| | | |
| | | info.WorkingProcedureCurrent = loginfo.WorkingProcedure; |
| | | } |
| | | #endregion |
| | | |
| | | #region 更新设备实时表 |
| | | |
| | | bool isAddEquipmentCurrentMonitor = false; |
| | | EquipmentCurrentMonitor equinfo = new EquipmentCurrentMonitor(); |
| | | equinfo = db.EquipmentCurrentMonitor.Where(o => o.EquipmentID == loginfo.EquipmentID).FirstOrDefault(); |
| | | if (equinfo == null || equinfo.Id < 1) |
| | | {//没有工件信息,不做更新 |
| | | Log4NetHelper.WriteErrorLog(type, $"设备{loginfo.EquipmentID} 告警监控{loginfo.WorkingProcedure} 没有获取到设备监控信息,现新增"); |
| | | equinfo = EntityPropHelper.Mapper<EquipmentCurrentMonitor, WorkPieceLog>(loginfo); |
| | | equinfo.OnlineTime = DateTime.Now; |
| | | isAddEquipmentCurrentMonitor = true; |
| | | } |
| | | else |
| | | {//更新工件 |
| | | equinfo.WorkPieceID = loginfo.WorkPieceID; |
| | | equinfo.UpdatedUserName = loginfo.MonitoringPoint; |
| | | equinfo.UpdatedTime = DateTime.Now; |
| | | equinfo.OnlineTime = DateTime.Now; |
| | | } |
| | | if (isAddEquipmentCurrentMonitor) |
| | | { |
| | | equinfo.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | db.EquipmentCurrentMonitor.Add(equinfo); |
| | | } |
| | | #endregion |
| | | //db.WorkPieceLog.Add(GetAddWorkPieceLog(loginfo)); |
| | | db.WorkPieceInfoLog.Add(GetAddWorkPieceInfoLog(info)); |
| | | //UpdateKnifeToolLift(db, loginfo);//更新刀具寿命信息 |
| | | } |
| | | else |
| | | { |
| | | loginfo.Remarks = (loginfo.Remarks ?? "") + $"上线完成读取二维码{loginfo.WorkPieceID ?? "空"}异常"; |
| | | Log4NetHelper.WriteErrorLog(type, $" {loginfo.WorkingProcedure}上线监控读码标记 读取工件码数据[{loginfo.WorkPieceID ?? "空"}]时异常:"); |
| | | |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | loginfo.Remarks = (loginfo.Remarks ?? "") + $"读取二维码{loginfo.WorkPieceID ?? "空"}更新数据异常{e.Message}"; |
| | | } |
| | | finally |
| | | { |
| | | loginfo.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | db.WorkPieceLog.Add(loginfo); |
| | | db.SaveChanges(); |
| | | |
| | | } |
| | | |
| | | } |
| | | } |
| | | public static WorkPieceLogMiddle QualityDataHand(WorkPieceLogMiddle loginfo, List<EquipmentQualityConfig> qcofig) |
| | | { |
| | | try |
| | |
| | | return loginfo; |
| | | } |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 质量检测完成 |
| | | /// 赋值 修改人 【Editby shaocx,2024-07-05】 |
| | | /// </summary> |
| | | /// <param name="logMiddle"></param> |
| | | /// <param name="type"></param> |
| | | public static void QualityInfoComplete(WorkPieceLogMiddle logMiddle, LogType type) |
| | | /// <returns></returns> |
| | | public static string ResetUpdatedUserName(WorkPieceLogMiddle logMiddle) |
| | | { |
| | | //此处同时插入了WorkPieceLog,WorkPieceInfoLog表,并新增或修改WorkPieceInfo表 |
| | | //插入质量相关表QualityDataInfo |
| | | if (logMiddle.MonitoringPoint.Equals("OP1003")) |
| | | {//因为OP10和OP40是一台机器,OP1003专门是OP40测量的。 |
| | | return "OP4003"; |
| | | } |
| | | return logMiddle.MonitoringPoint; |
| | | } |
| | | |
| | | using (DbModel db = new DbModel()) |
| | | |
| | | |
| | | |
| | | |
| | | public static void SetWorkingProcedureCurrentForOP10(WorkPieceInfo cur_db_info, ref string set_WorkingProcedureCurrent) |
| | | { |
| | | //截断字符串 |
| | | if (cur_db_info.WorkingProcedureCurrent.Length == 4) |
| | | { |
| | | |
| | | bool isAddWorkPieceInfo = false; |
| | | WorkPieceLog loginfo2 = new WorkPieceLog(); |
| | | loginfo2 = EntityPropHelper.Mapper<WorkPieceLog, WorkPieceLogMiddle>(logMiddle); |
| | | try |
| | | { |
| | | |
| | | if (logMiddle.WorkPieceID.Length == 22) |
| | | {//获取到的工件号异常 |
| | | WorkPieceInfo pieceInfo = new WorkPieceInfo(); |
| | | pieceInfo = db.WorkPieceInfo.Where(o => o.WorkPieceID == logMiddle.WorkPieceID).FirstOrDefault(); |
| | | if (pieceInfo == null || pieceInfo.WorkPieceID.Length < 1) |
| | | {//没有工件信息,不做更新 |
| | | if (logMiddle.MonitoringPoint.Equals("OP1002") || logMiddle.MonitoringPoint.Equals("OP1003") || logMiddle.MonitoringPoint.Contains("OP2002")) |
| | | {//OP10 没有上线扫码枪,约定用测量完成信号当上线标记 |
| | | pieceInfo = EntityPropHelper.Mapper<WorkPieceInfo, WorkPieceLogMiddle>(logMiddle); |
| | | //EntityPropHelper<WorkPieceLog, WorkPieceInfo>.CopyProp(loginfo, info, loginfo.GetWorkPieceInfoDict()); |
| | | if (!logMiddle.WorkingProcedure.Equals("OP05")) |
| | | {//当工件二维码第一次出现的工序不是OP05,则设置为可疑状态 |
| | | pieceInfo.QualityState = (int)QualityState.Suspected; |
| | | pieceInfo.QualityErrorInfo = $"工件二维码第一次出现的工序{logMiddle.MonitoringPoint}不是OP05,数据缺失,请确认情况并做相应处理!"; |
| | | pieceInfo.Remarks = $"工件二维码第一次出现的工序{logMiddle.WorkingProcedure}不是OP05,数据缺失,请确认情况并做相应处理!"; |
| | | } |
| | | else |
| | | { |
| | | pieceInfo.QualityState = (int)QualityState.OK;//此处需要注意,判断所有工序质量,然后再赋值 |
| | | pieceInfo.Remarks = "OP05新增工件信息"; |
| | | } |
| | | pieceInfo.WorkPieceinitOnlineTime = DateTimeHelper.GetDateTime(); |
| | | pieceInfo.WorkingProcedurePlan = ConfigHelper.GetConfigString("WorkingProcedureAllStr") ?? "OP05OP10OP20OP30OP35OP40OP50OP60OP70OP80"; |
| | | pieceInfo.CreatedUserName = logMiddle.MonitoringPoint; |
| | | pieceInfo.CreatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | pieceInfo.WorkingProcedureStartTime = DateTimeHelper.GetDateTime();// |
| | | pieceInfo.WorkingProcedureEndTime = null; |
| | | pieceInfo = ParseQRCode(pieceInfo); |
| | | isAddWorkPieceInfo = true; |
| | | |
| | | |
| | | } |
| | | else |
| | | { |
| | | loginfo2.Remarks = loginfo2.Remarks ?? "" + $"|工件{logMiddle.WorkPieceID} 质量检测完成工序{logMiddle.MonitoringPoint} 没有获取到工件信息不做更新"; |
| | | Log4NetHelper.WriteErrorLog(type, $"工件{logMiddle.WorkPieceID} 质量检测完成工序{logMiddle.MonitoringPoint} 没有获取到工件信息不做更新"); |
| | | return; |
| | | } |
| | | } |
| | | if (logMiddle.MonitoringPoint.Equals("OP1002") || logMiddle.MonitoringPoint.Equals("OP1003") || logMiddle.MonitoringPoint.Contains("OP2002")) |
| | | {// OP10 没有上线扫码枪,约定用测量完成信号当上线标记,所以上线需要修改的字段放这里 |
| | | |
| | | if (logMiddle.WorkingProcedure.Equals("OP10")) |
| | | { |
| | | var WorkingProcedure = (logMiddle.MonitoringPoint.Equals("OP1002") ? "OP10" : "OP40"); |
| | | loginfo2.WorkingProcedure = WorkingProcedure;//解决OP10,OP40同一个的问题 |
| | | logMiddle.WorkingProcedure = WorkingProcedure;//解决OP10,OP40同一个的问题 |
| | | } |
| | | pieceInfo.WorkPieceCurrentPosition = logMiddle.WorkingProcedure; |
| | | pieceInfo.WorkPieceCurrentPositionOrder = pieceInfo.WorkingProcedurePlan.IndexOf(logMiddle.WorkingProcedure) / 2; |
| | | pieceInfo.WorkingProcedureCurrent = logMiddle.WorkingProcedure; |
| | | pieceInfo.WorkingProcedureStartTime = DateTimeHelper.GetDateTime(); |
| | | |
| | | #region 更新设备实时表 |
| | | |
| | | bool isAddEquipmentCurrentMonitor = false; |
| | | EquipmentCurrentMonitor equinfo = new EquipmentCurrentMonitor(); |
| | | equinfo = db.EquipmentCurrentMonitor.Where(o => o.EquipmentID == logMiddle.EquipmentID).FirstOrDefault(); |
| | | if (equinfo == null || equinfo.Id < 1) |
| | | {//没有工件信息,不做更新 |
| | | Log4NetHelper.WriteErrorLog(type, $"设备{logMiddle.EquipmentID} 告警监控{logMiddle.WorkingProcedure} 没有获取到设备监控信息,现新增"); |
| | | equinfo = EntityPropHelper.Mapper<EquipmentCurrentMonitor, WorkPieceLog>(logMiddle); |
| | | equinfo.OnlineTime = DateTime.Now; |
| | | isAddEquipmentCurrentMonitor = true; |
| | | } |
| | | else |
| | | {//更新工件 |
| | | equinfo.WorkPieceID = logMiddle.WorkPieceID; |
| | | equinfo.UpdatedUserName = logMiddle.MonitoringPoint; |
| | | equinfo.UpdatedTime = DateTime.Now; |
| | | equinfo.OnlineTime = DateTime.Now; |
| | | } |
| | | if (isAddEquipmentCurrentMonitor) |
| | | { |
| | | equinfo.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | db.EquipmentCurrentMonitor.Add(equinfo); |
| | | } |
| | | #endregion |
| | | //UpdateKnifeToolLift(db, loginfo);//更新刀具寿命信息 |
| | | } |
| | | pieceInfo.WorkPieceState = (int)WorkPieceState.WIP;//推出后和SPC抽检后 质量录入时状态修改回在制品 |
| | | pieceInfo.EquipmentID = logMiddle.EquipmentID; |
| | | pieceInfo.QualityStateUpdateUser = logMiddle.UpdatedUserName; |
| | | pieceInfo.QualityStateUpdateTime = logMiddle.UpdatedTime.Value.LocalDateTime; |
| | | pieceInfo.QualityStateUpdateMode = QualityStateUpdateMode.Auto.ToString(); |
| | | pieceInfo.Remarks = pieceInfo.Remarks ?? "" + $"{logMiddle.WorkingProcedure}质量检测完成修改"; |
| | | pieceInfo.UpdatedUserName = logMiddle.MonitoringPoint; |
| | | pieceInfo.UpdatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | if (!(pieceInfo.WorkingProcedureStartTime.HasValue && pieceInfo.WorkingProcedureStartTime > DateTime.Parse("1900/01/01"))) |
| | | {//工序开始时间没有则赋值 |
| | | pieceInfo.WorkingProcedureStartTime = DateTimeHelper.GetDateTime(); |
| | | } |
| | | pieceInfo.QualityState = (int)((logMiddle.QualityStateStr.Equals("OK") || logMiddle.QualityStateStr.Equals("0K")) ? QualityState.OK : QualityState.NG); |
| | | //赋值不合格原因 |
| | | SetQualityNoOk_WorkPieceInfo(logMiddle, ref pieceInfo); |
| | | |
| | | |
| | | if (!pieceInfo.QualityState.Equals(((int)QualityState.OK).ToString())) |
| | | { |
| | | pieceInfo.QualityErrorInfo = $"{logMiddle.WorkingProcedure}工序质量采集数据不合格{pieceInfo.QualityState}"; |
| | | } |
| | | else |
| | | { |
| | | pieceInfo.QualityErrorInfo = ""; |
| | | } |
| | | logMiddle.QualityState = pieceInfo.QualityState; |
| | | if (isAddWorkPieceInfo) |
| | | { |
| | | db.WorkPieceInfo.Add(pieceInfo); |
| | | } |
| | | |
| | | #region 根据标准值更新最新质量数据(OP10/OP40/OP20/OP60) |
| | | var qcofig = db.EquipmentQualityConfig.Where(o => o.WorkingProcedure.Equals(logMiddle.WorkingProcedure) && o.ParamType != 1 && o.IsDeleted == false).ToList(); |
| | | if (qcofig.Count > 0) |
| | | { |
| | | QualityDataHand(logMiddle, qcofig); |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | var qualityData = db.QualityDataInfo.Where(o => o.WorkPieceID == logMiddle.WorkPieceID).FirstOrDefault(); |
| | | if (qualityData == null || qualityData.WorkPieceID.Length < 1 || qualityData.WorkingProcedure.Length < 1) |
| | | {//插入QualityDataInfo表 |
| | | qualityData = EntityPropHelper.Mapper<QualityDataInfo, WorkPieceLog>(logMiddle); |
| | | db.QualityDataInfo.Add(GetAddQualityDataInfo(qualityData)); |
| | | } |
| | | //修改QualityDataInfo表 //重复收到质量信息,会覆盖之前的 |
| | | EntityPropHelper<WorkPieceLogMiddle, QualityDataInfo>.CopyProp(logMiddle, qualityData, GetQualityDataInfoUpdate(logMiddle, logMiddle.WorkingProcedure, logMiddle.MonitoringPoint));//指定修改字段 |
| | | |
| | | qualityData.QualityStateUpdateUser = pieceInfo.UpdatedUserName; |
| | | qualityData.QualityReceiveTime = pieceInfo.UpdatedTime.Value.LocalDateTime; |
| | | qualityData.QualityStateUpdateMode = pieceInfo.QualityStateUpdateMode; |
| | | if (logMiddle.WorkingProcedure.Equals("OP10")) |
| | | { |
| | | qualityData.OP10QualityState = logMiddle.QualityState.HasValue ? logMiddle.QualityState.Value.ToString() : "3"; |
| | | qualityData.OP10QualityReceiveTime = DateTimeHelper.GetDateTime(); |
| | | } |
| | | else if (logMiddle.WorkingProcedure.Equals("OP20")) |
| | | { |
| | | //Log4NetHelper.WriteErrorLog(type, $" {loginfo.WorkingProcedure}质量信息【{loginfo.QualityStateStr ?? "空"}】" + |
| | | // $"【{(loginfo.QualityState.HasValue? loginfo.QualityState.Value:999)}】【{(info.QualityState.HasValue ? info.QualityState.Value : 888)}】 读取工件码数据[{loginfo.WorkPieceID ?? "空"}]"); |
| | | qualityData.OP20QualityState = logMiddle.QualityState.HasValue ? logMiddle.QualityState.Value.ToString() : "3"; |
| | | qualityData.OP20QualityReceiveTime = DateTimeHelper.GetDateTime(); |
| | | qualityData.OP20QualityFilePath = logMiddle.OP20QualityFilePath; |
| | | } |
| | | else if (logMiddle.WorkingProcedure.Equals("OP30")) |
| | | { |
| | | switch (logMiddle.MonitoringPoint) |
| | | { |
| | | case "OP3002CH3": |
| | | qualityData.OP30QualityFilePathCH3 = logMiddle.OP30QualityFilePathCH3; |
| | | qualityData.OP30QualityStateCH3 = logMiddle.QualityState.HasValue ? logMiddle.QualityState.Value.ToString() : "3"; |
| | | qualityData.OP30QualityReceiveTimeCH3 = DateTimeHelper.GetDateTime(); |
| | | |
| | | if (qualityData.OP30QualityStateCH3 == ((int)QualityState.NG).ToString()) |
| | | { |
| | | logMiddle.QualityNoOk = (int)QualityNoOkEnum.OP30涨断工位力矩大; |
| | | logMiddle.QualityNoOkReason = QualityNoOkEnum.OP30涨断工位力矩大.ToString(); |
| | | //赋值不合格原因 |
| | | SetQualityNoOk_WorkPieceInfo(logMiddle, ref pieceInfo); |
| | | } |
| | | |
| | | break; |
| | | case "OP3002CH4": |
| | | qualityData.OP30QualityFilePathCH4 = logMiddle.OP30QualityFilePathCH4; |
| | | qualityData.OP30QualityStateCH4 = logMiddle.QualityState.HasValue ? logMiddle.QualityState.Value.ToString() : "3"; |
| | | qualityData.OP30QualityReceiveTimeCH4 = DateTimeHelper.GetDateTime(); |
| | | |
| | | if (qualityData.OP30QualityStateCH4 == ((int)QualityState.NG).ToString()) |
| | | { |
| | | logMiddle.QualityNoOk = (int)QualityNoOkEnum.OP30预拧紧工位力矩大; |
| | | logMiddle.QualityNoOkReason = QualityNoOkEnum.OP30预拧紧工位力矩大.ToString(); |
| | | //赋值不合格原因 |
| | | SetQualityNoOk_WorkPieceInfo(logMiddle, ref pieceInfo); |
| | | } |
| | | |
| | | break; |
| | | case "OP3002CH5": |
| | | qualityData.OP30QualityFilePathCH5 = logMiddle.OP30QualityFilePathCH5; |
| | | qualityData.OP30QualityStateCH5 = logMiddle.QualityState.HasValue ? logMiddle.QualityState.Value.ToString() : "3"; |
| | | qualityData.OP30QualityReceiveTimeCH5 = DateTimeHelper.GetDateTime(); |
| | | |
| | | if (qualityData.OP30QualityStateCH5 == ((int)QualityState.NG).ToString()) |
| | | { |
| | | logMiddle.QualityNoOk = (int)QualityNoOkEnum.OP30终拧紧工位力矩大; |
| | | logMiddle.QualityNoOkReason = QualityNoOkEnum.OP30终拧紧工位力矩大.ToString(); |
| | | //赋值不合格原因 |
| | | SetQualityNoOk_WorkPieceInfo(logMiddle, ref pieceInfo); |
| | | } |
| | | |
| | | break; |
| | | case "OP3002CH6": |
| | | qualityData.OP30QualityFilePathCH6 = logMiddle.OP30QualityFilePathCH6; |
| | | qualityData.OP30QualityStateCH6 = logMiddle.QualityState.HasValue ? logMiddle.QualityState.Value.ToString() : "3"; |
| | | qualityData.OP30QualityReceiveTimeCH6 = DateTimeHelper.GetDateTime(); |
| | | |
| | | if (qualityData.OP30QualityStateCH6 == ((int)QualityState.NG).ToString()) |
| | | { |
| | | logMiddle.QualityNoOk = (int)QualityNoOkEnum.OP30压衬套工位力矩大; |
| | | logMiddle.QualityNoOkReason = QualityNoOkEnum.OP30压衬套工位力矩大.ToString(); |
| | | //赋值不合格原因 |
| | | SetQualityNoOk_WorkPieceInfo(logMiddle, ref pieceInfo); |
| | | } |
| | | |
| | | break; |
| | | default: |
| | | break; |
| | | } |
| | | //qualityData.OP30QualityState = loginfo.QualityState.HasValue ? loginfo.QualityState.Value.ToString() : "3"; |
| | | //qualityData.OP30QualityReceiveTime = DateTimeHelper.GetDateTime(); |
| | | } |
| | | else if (logMiddle.WorkingProcedure.Equals("OP35")) |
| | | { |
| | | qualityData.OP35QualityState = logMiddle.QualityState.HasValue ? logMiddle.QualityState.Value.ToString() : "3"; |
| | | qualityData.OP35QualityReceiveTime = DateTimeHelper.GetDateTime(); |
| | | } |
| | | else if (logMiddle.WorkingProcedure.Equals("OP40")) |
| | | { |
| | | qualityData.OP40QualityState = logMiddle.QualityState.HasValue ? logMiddle.QualityState.Value.ToString() : "3"; |
| | | qualityData.OP40QualityReceiveTime = DateTimeHelper.GetDateTime(); |
| | | } |
| | | else if (logMiddle.WorkingProcedure.Equals("OP60")) |
| | | { |
| | | qualityData.OP60QualityFilePath = logMiddle.OP60QualityFilePath; |
| | | qualityData.OP60QualityState = logMiddle.QualityState.HasValue ? logMiddle.QualityState.Value.ToString() : "3"; |
| | | qualityData.OP60QualityReceiveTime = DateTimeHelper.GetDateTime(); |
| | | } |
| | | else if (logMiddle.WorkingProcedure.Equals("OP80")) |
| | | { |
| | | qualityData.OP80QualityFilePath = logMiddle.OP80QualityFilePath; |
| | | qualityData.OP80QualityState = logMiddle.QualityState.HasValue ? logMiddle.QualityState.Value.ToString() : "3"; |
| | | qualityData.OP80QualityReceiveTime = DateTimeHelper.GetDateTime(); |
| | | } |
| | | |
| | | var pro = db.WorkPieceProcess.Where(o => o.WorkPieceID == logMiddle.WorkPieceID && o.WorkingProcedureCurrent == pieceInfo.WorkingProcedureCurrent && o.OperationType == OperationType.生产.ToString()).OrderByDescending(o => o.StartTime).FirstOrDefault(); |
| | | if (pro == null || pro.WorkPieceID.Length < 1 || logMiddle.MonitoringPoint.Equals("OP1002") || logMiddle.MonitoringPoint.Equals("OP1003") || logMiddle.MonitoringPoint.Contains("OP2002")) |
| | | {// OP10 没有上线扫码枪,约定用测量完成信号当上线标记,所以上线需要修改的字段放这里 |
| | | //上线是每次都插入 |
| | | |
| | | WorkPieceProcess process = new WorkPieceProcess(); |
| | | process = EntityPropHelper.Mapper<WorkPieceProcess, WorkPieceInfo>(pieceInfo); |
| | | process.StartTime = DateTimeHelper.GetDateTime(); |
| | | process.QualityState = pieceInfo.QualityState.HasValue ? pieceInfo.QualityState.Value : (int)QualityState.OK; |
| | | //记录质量不合格原因 【Editby shaocx,2024-06-26】 |
| | | //赋值不合格原因 |
| | | SetQualityNoOk_WorkPieceProcess(logMiddle, ref process); |
| | | |
| | | process.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | process.CreatedUserName = logMiddle.MonitoringPoint; |
| | | process.CreatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | process.UpdatedUserName = logMiddle.MonitoringPoint; |
| | | process.UpdatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | process.OperationType = OperationType.生产.ToString(); |
| | | process.QualityDataInfoID = qualityData.Id; |
| | | process.Remarks = ""; |
| | | db.WorkPieceProcess.Add(process); |
| | | } |
| | | else |
| | | {//其他的都只是修改 |
| | | pro.QualityDataInfoID = qualityData.Id; |
| | | pro.UpdatedUserName = logMiddle.MonitoringPoint; |
| | | pro.UpdatedTime = DateTimeHelper.GetDateTime(); |
| | | pro.QualityState = pieceInfo.QualityState.HasValue ? pieceInfo.QualityState.Value : 9; |
| | | //赋值不合格原因 |
| | | SetQualityNoOk_WorkPieceProcess(logMiddle, ref pro); |
| | | |
| | | //TODO:判断如果是60工序,那么就要更新pro表的创建人为loginfo.MonitoringPoint 【Editby shaocx,2024-06-05】 |
| | | if (logMiddle.WorkingProcedure == "OP60") |
| | | { |
| | | pro.CreatedUserName = logMiddle.MonitoringPoint; |
| | | |
| | | } |
| | | } |
| | | |
| | | if (logMiddle.QualityType != null && logMiddle.QualityType.Equals(QualityType.SPC.ToString())) |
| | | {//SPC反馈, |
| | | if (logMiddle.QualityState != (int)QualityState.OK) |
| | | { |
| | | //当某到工序检测到不合格工件时,从该工件加工完成时刻前指定时间起至报检不合格时间止,系统将该工件的最后加工工序在该时间段内加工的所有工件、正在加工的工件、该工序入口处的第一个工件全部标记为疑似状态,由人工复检工件并修改状态,并支持批量变更。 |
| | | //答复:在线测量不需要走这个流程,只有SPC抽检才需要,需要把这时间段的工件全部置为疑似,哪怕是已完成工件 |
| | | //时间段起始时间:抽检工件生产时间前一SPC抽检时间 |
| | | //时间段结束时间:抽检工件质量结果出现后的时间 |
| | | //抽检工件工序扫描枪外入口处的第一个工件 也把质量状态置为疑似 |
| | | //(每一工序SPC抽检是设置的固定的,比如200抽4,状态置为疑似时若工件还在设备内,会继续生产完毕后排出) |
| | | //目前这块逻辑放到了 WebAPI中了 |
| | | |
| | | } |
| | | |
| | | } |
| | | db.WorkPieceInfoLog.Add(GetAddWorkPieceInfoLog(pieceInfo)); |
| | | db.QualityDataInfoLog.Add(GetAddQualityDataInfoLog(qualityData));//插入日志 |
| | | var bb = cur_db_info.WorkingProcedureCurrent.Substring(2, 2); |
| | | int ii = Convert.ToInt32(bb); |
| | | if (ii <= 10) |
| | | { |
| | | set_WorkingProcedureCurrent = "OP10"; |
| | | } |
| | | else |
| | | { |
| | | loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"质量检测完成读取二维码{logMiddle.WorkPieceID ?? "空"}异常"; |
| | | Log4NetHelper.WriteErrorLog(type, $" {logMiddle.WorkingProcedure}工序监控读码标记 读取工件码数据[{logMiddle.WorkPieceID ?? "空"}]时异常:"); |
| | | |
| | | set_WorkingProcedureCurrent = "OP40"; |
| | | } |
| | | } |
| | | catch (Exception ex) |
| | | catch (Exception) |
| | | { |
| | | loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"质量检测完成{logMiddle.WorkPieceID ?? "空"}更新数据异常{ex.Message}++{ex.StackTrace}"; |
| | | Log4NetHelper.WriteErrorLog(type, $" {logMiddle.WorkingProcedure}工序监控读码标记 读取工件码数据[{logMiddle.WorkPieceID ?? "空"}]时异常:"); |
| | | } |
| | | finally |
| | | { |
| | | loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"质量:{logMiddle.QualityStateStr ?? "空"}"; |
| | | db.WorkPieceLog.Add(GetAddWorkPieceLog(loginfo2));//插入工件采集日志表 |
| | | db.SaveChanges(); |
| | | set_WorkingProcedureCurrent = cur_db_info.WorkingProcedureCurrent; |
| | | } |
| | | } |
| | | } |
| | | /// <summary> |
| | | /// 工件推出NOOK |
| | | /// </summary> |
| | | /// <param name="loginfo"></param> |
| | | /// <param name="type"></param> |
| | | public static void WorkPiecePushOff(WorkPieceLogMiddle loginfo, LogType type) |
| | | { |
| | | using (DbModel db = new DbModel()) |
| | | else |
| | | { |
| | | WorkPieceLog loginfo2 = new WorkPieceLog(); |
| | | loginfo2 = EntityPropHelper.Mapper<WorkPieceLog, WorkPieceLogMiddle>(loginfo); |
| | | try |
| | | { |
| | | if (loginfo.WorkPieceID != null && loginfo.WorkPieceID.Trim('\0').Length == 22) |
| | | { |
| | | WorkPieceInfo info = new WorkPieceInfo(); |
| | | info = db.WorkPieceInfo.Where(o => o.WorkPieceID == loginfo.WorkPieceID).FirstOrDefault(); |
| | | if (info == null || info.WorkPieceID.Length < 1) |
| | | {//没有工件信息,不做更新 |
| | | Log4NetHelper.WriteErrorLog(type, $"工件{loginfo.WorkPieceID} 工件推出工序{loginfo.WorkingProcedure} 没有获取到工件信息不做更新"); |
| | | return; |
| | | } |
| | | else |
| | | {//更新表WorkPieceInfo |
| | | if (loginfo.WorkingProcedure.Equals("OP10")) |
| | | { |
| | | info.WorkPieceCurrentPosition = info.WorkingProcedureCurrent + "NOOK"; |
| | | //var WorkingProcedure = (loginfo.MonitoringPoint.Equals("OP1002") ? "OP10" : "OP40"); |
| | | loginfo2.WorkingProcedure = info.WorkingProcedureCurrent;//解决OP10,OP40同一个的问题 |
| | | loginfo.WorkingProcedure = info.WorkingProcedureCurrent; //解决OP10,OP40同一个的问题 |
| | | } |
| | | else |
| | | { |
| | | info.WorkingProcedureCurrent = loginfo.WorkingProcedure; |
| | | info.WorkPieceCurrentPosition = loginfo.WorkingProcedure + "NOOK"; |
| | | } |
| | | info.WorkPieceState = (int)WorkPieceState.NOOKPush; |
| | | info.UpdatedUserName = loginfo.MonitoringPoint; |
| | | info.UpdatedTime = DateTime.Now; |
| | | info.Remarks = "工件NOOK推出"; |
| | | if (!(info.WorkingProcedureStartTime.HasValue && info.WorkingProcedureStartTime > DateTime.Parse("1900/01/01"))) |
| | | { |
| | | info.WorkingProcedureStartTime = DateTimeHelper.GetDateTime(); |
| | | } |
| | | info.WorkingProcedureEndTime = DateTimeHelper.GetDateTime(); |
| | | info.WorkingProcedureCompleted = info.WorkingProcedureCompleted + loginfo.WorkingProcedure;//已完成工序 |
| | | info.WorkPieceCurrentPositionOrder = info.WorkingProcedurePlan.IndexOf(loginfo.WorkingProcedure) / 2; |
| | | } |
| | | if (loginfo.WorkingProcedure.Equals("OP35")) |
| | | {//为了解决OP35的采集到的质量信息是OK还NOOK的情况,OP35 NOOK时更新质量信息 |
| | | loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"OP35NOOK原质量信息{(info.QualityState.HasValue ? info.QualityState.Value.ToString() : "空")}"; |
| | | info.QualityState = (int)QualityState.NG; |
| | | if (!info.QualityState.Equals(((int)QualityState.OK).ToString())) |
| | | { |
| | | info.QualityErrorInfo = $"{loginfo.WorkingProcedure}工序质量NOOK采集数据不合格{info.QualityState}"; |
| | | } |
| | | else |
| | | { |
| | | info.QualityErrorInfo = ""; |
| | | } |
| | | loginfo.QualityState = info.QualityState; |
| | | |
| | | var qualityData = db.QualityDataInfo.Where(o => o.WorkPieceID == loginfo.WorkPieceID).FirstOrDefault(); |
| | | if (qualityData != null) |
| | | { |
| | | qualityData.OP35QualityState = loginfo.QualityState.HasValue ? loginfo.QualityState.Value.ToString() : "3"; |
| | | qualityData.OP35QualityReceiveTime = DateTimeHelper.GetDateTime(); |
| | | db.QualityDataInfoLog.Add(GetAddQualityDataInfoLog(qualityData)); |
| | | } |
| | | } |
| | | //更新上一工序的结束时间 |
| | | var pro = db.WorkPieceProcess.Where(o => o.WorkPieceID == loginfo.WorkPieceID && o.WorkingProcedureCurrent == loginfo.WorkingProcedure && o.OperationType == OperationType.生产.ToString()).OrderByDescending(o => o.StartTime).FirstOrDefault(); |
| | | if (pro != null && pro.WorkPieceID.Length > 0) |
| | | { |
| | | pro.EndTime = DateTimeHelper.GetDateTime(); |
| | | pro.Remarks = (pro.Remarks ?? "") + "NOOK结束"; |
| | | pro.UpdatedUserName = loginfo.MonitoringPoint; |
| | | pro.UpdatedTime = DateTimeHelper.GetDateTime(); |
| | | } |
| | | |
| | | db.WorkPieceInfoLog.Add(GetAddWorkPieceInfoLog(info)); |
| | | |
| | | } |
| | | else |
| | | { |
| | | loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"工件NOOK推出读取二维码{loginfo.WorkPieceID ?? "空"}异常"; |
| | | Log4NetHelper.WriteErrorLog(type, $" {loginfo.WorkingProcedure}工件NOOK推出读码标记 读取工件码数据[{loginfo.WorkPieceID ?? "空"}]时异常:"); |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"读取二维码{loginfo.WorkPieceID ?? "空"}更新数据异常{e.Message}"; |
| | | } |
| | | |
| | | |
| | | db.WorkPieceLog.Add(GetAddWorkPieceLog(loginfo2));//插入工件采集日志表 |
| | | db.SaveChanges(); |
| | | } |
| | | |
| | | } |
| | | /// <summary> |
| | | /// 工件SPC抽检推出 |
| | | /// </summary> |
| | | /// <param name="loginfo"></param> |
| | | /// <param name="type"></param> |
| | | public static void WorkPieceSPCPushOff(WorkPieceLogMiddle loginfo, LogType type) |
| | | { |
| | | |
| | | using (DbModel db = new DbModel()) |
| | | { |
| | | WorkPieceLog loginfo2 = new WorkPieceLog(); |
| | | loginfo2 = EntityPropHelper.Mapper<WorkPieceLog, WorkPieceLogMiddle>(loginfo); |
| | | try |
| | | { |
| | | if ((loginfo.WorkPieceID != null && loginfo.WorkPieceID.Trim('\0').Length == 22) |
| | | //|| !((loginfo.WorkingProcedure.Equals("OP10") || loginfo.WorkingProcedure.Equals("OP40")) && loginfo.Remarks.Length > 0) |
| | | ) |
| | | { |
| | | WorkPieceInfo info = new WorkPieceInfo(); |
| | | info = db.WorkPieceInfo.Where(o => o.WorkPieceID == loginfo.WorkPieceID).FirstOrDefault(); |
| | | if (info == null || info.WorkPieceID.Length < 1) |
| | | {//没有工件信息,不做更新 |
| | | loginfo2.Remarks = $"工件{loginfo.WorkPieceID} 工件SPC推出工序{loginfo.WorkingProcedure} 没有获取到工件信息不做更新"; |
| | | Log4NetHelper.WriteErrorLog(type, $"工件{loginfo.WorkPieceID} 工件SPC推出工序{loginfo.WorkingProcedure} 没有获取到工件信息不做更新"); |
| | | return; |
| | | } |
| | | else |
| | | {//更新表WorkPieceInfo |
| | | if (loginfo.WorkingProcedure.Equals("OP10")) |
| | | { |
| | | info.WorkPieceCurrentPosition = info.WorkingProcedureCurrent + "SPC"; |
| | | //var WorkingProcedure = (loginfo.MonitoringPoint.Equals("OP1002") ? "OP10" : "OP40"); |
| | | loginfo2.WorkingProcedure = info.WorkingProcedureCurrent;//解决OP10,OP40同一个的问题 |
| | | loginfo.WorkingProcedure = info.WorkingProcedureCurrent; //解决OP10,OP40同一个的问题 |
| | | } |
| | | else |
| | | { |
| | | info.WorkingProcedureCurrent = loginfo.WorkingProcedure; |
| | | info.WorkPieceCurrentPosition = loginfo.WorkingProcedure + "SPC"; |
| | | } |
| | | info.WorkPieceState = (int)WorkPieceState.SPCPush; |
| | | info.UpdatedUserName = loginfo.MonitoringPoint; |
| | | info.UpdatedTime = DateTime.Now; |
| | | info.WorkingProcedureEndTime = DateTimeHelper.GetDateTime(); |
| | | if (!(info.WorkingProcedureStartTime.HasValue && info.WorkingProcedureStartTime > DateTime.Parse("1900/01/01"))) |
| | | { |
| | | info.WorkingProcedureStartTime = DateTimeHelper.GetDateTime(); |
| | | } |
| | | |
| | | |
| | | info.WorkingProcedureCompleted = info.WorkingProcedureCompleted + loginfo.WorkingProcedure;//已完成工序 |
| | | info.WorkPieceCurrentPositionOrder = info.WorkingProcedurePlan.IndexOf(loginfo.WorkingProcedure) / 2; |
| | | } |
| | | info.Remarks = "工件SPC抽检推出"; |
| | | |
| | | //更新上一工序的结束时间 |
| | | var pro = db.WorkPieceProcess.Where(o => o.WorkPieceID == loginfo.WorkPieceID && o.WorkingProcedureCurrent == loginfo.WorkingProcedure && o.OperationType == OperationType.生产.ToString()).OrderByDescending(o => o.StartTime).FirstOrDefault(); |
| | | if (pro != null && pro.WorkPieceID.Length > 0) |
| | | { |
| | | pro.EndTime = DateTimeHelper.GetDateTime(); |
| | | pro.Remarks = (pro.Remarks ?? "") + "SPC抽检结束"; |
| | | pro.UpdatedUserName = loginfo.MonitoringPoint; |
| | | pro.UpdatedTime = DateTimeHelper.GetDateTime(); |
| | | } |
| | | //每次SPC 都插入追溯表 |
| | | WorkPieceProcess process = new WorkPieceProcess(); |
| | | process = EntityPropHelper.Mapper<WorkPieceProcess, WorkPieceInfo>(info); |
| | | process.StartTime = DateTimeHelper.GetDateTime(); |
| | | process.OperationType = OperationType.SPC.ToString(); |
| | | process.QualityState = (int)QualityState.Suspected; |
| | | process.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | process.CreatedUserName = loginfo.MonitoringPoint; |
| | | process.CreatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | process.UpdatedUserName = loginfo.MonitoringPoint; |
| | | process.UpdatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | process.Remarks = "工件SPC抽检推出"; |
| | | db.WorkPieceProcess.Add(process); |
| | | |
| | | |
| | | db.WorkPieceInfoLog.Add(GetAddWorkPieceInfoLog(info)); |
| | | } |
| | | else |
| | | { |
| | | loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"工件SPC抽检推出读取二维码{loginfo.WorkPieceID ?? "空"}异常"; |
| | | Log4NetHelper.WriteErrorLog(type, $" {loginfo.WorkingProcedure}工件SPC抽检推出读码标记 读取工件码数据[{loginfo.WorkPieceID ?? "空"}]时异常:"); |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"读取二维码{loginfo.WorkPieceID ?? "空"}更新数据异常{e.Message}"; |
| | | } |
| | | finally |
| | | { |
| | | db.WorkPieceLog.Add(GetAddWorkPieceLog(loginfo2));//插入工件采集日志表 |
| | | db.SaveChanges(); |
| | | } |
| | | |
| | | set_WorkingProcedureCurrent = cur_db_info.WorkingProcedureCurrent; |
| | | } |
| | | } |
| | | /// <summary> |
| | | /// 工序完成 |
| | | /// </summary> |
| | | /// <param name="logMiddle"></param> |
| | | /// <param name="type"></param> |
| | | public static void WorkingProcedureComplete(WorkPieceLogMiddle logMiddle, LogType type) |
| | | { |
| | | |
| | | using (DbModel db = new DbModel()) |
| | | { |
| | | if (logMiddle.WorkingProcedure.Equals("OP70")) |
| | | { |
| | | logMiddle.QualityState = (int)QualityState.OK; //如果是OP70,则默认是合格 【Editby shaocx,2024-06-25】 |
| | | } |
| | | |
| | | WorkPieceLog loginfo2 = new WorkPieceLog(); |
| | | loginfo2 = EntityPropHelper.Mapper<WorkPieceLog, WorkPieceLogMiddle>(logMiddle); |
| | | |
| | | try |
| | | { |
| | | if (logMiddle.WorkPieceID != null && logMiddle.WorkPieceID.Trim('\0').Length == 22) |
| | | { |
| | | |
| | | bool isAddWorkPieceInfo = false; |
| | | WorkPieceInfo info = new WorkPieceInfo(); |
| | | info = db.WorkPieceInfo.Where(o => o.WorkPieceID == logMiddle.WorkPieceID).FirstOrDefault(); |
| | | if (info == null || info.WorkPieceID.Length < 1) |
| | | {//没有工件信息,不做更新 (为了测试先先新增) |
| | | Log4NetHelper.WriteErrorLog(type, $"工件{logMiddle.WorkPieceID} 工件推出工序{logMiddle.WorkingProcedure} 没有获取到工件信息不做更新"); |
| | | //db.WorkPieceLog.Add(GetAddWorkPieceLog(loginfo));//插入工件采集日志表 |
| | | //db.SaveChanges(); |
| | | |
| | | loginfo2 = CommonManager.Instance.GetWorkPieceID(logMiddle, type); |
| | | info = EntityPropHelper.Mapper<WorkPieceInfo, WorkPieceLog>(logMiddle); |
| | | //EntityPropHelper<WorkPieceLog, WorkPieceInfo>.CopyProp(loginfo, info, loginfo.GetWorkPieceInfoDict()); |
| | | if (!logMiddle.WorkingProcedure.Equals("OP05")) |
| | | {//当工件二维码第一次出现的工序不是OP05,则设置为可疑状态 |
| | | info.QualityState = (int)QualityState.Suspected; |
| | | info.QualityErrorInfo = $"工件二维码第一次出现的工序{logMiddle.MonitoringPoint}不是OP05,数据缺失,请确认情况并做相应处理!"; |
| | | info.Remarks = $"工件二维码第一次出现的工序{logMiddle.MonitoringPoint}不是OP05,数据缺失,请确认情况并做相应处理!"; |
| | | } |
| | | else |
| | | { |
| | | info.QualityState = (int)QualityState.OK;//此处需要注意,判断所有工序质量,然后再赋值 |
| | | info.Remarks = "OP05新增工件信息"; |
| | | } |
| | | info.WorkPieceinitOnlineTime = DateTimeHelper.GetDateTime();//WorkPieceInitOnlineTime |
| | | info.WorkingProcedurePlan = ConfigHelper.GetConfigString("WorkingProcedureAllStr") ?? "OP05OP10OP20OP30OP35OP40OP50OP60OP70OP80"; |
| | | info.CreatedUserName = logMiddle.MonitoringPoint; |
| | | info.CreatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | info.WorkingProcedureCurrent = logMiddle.WorkingProcedure; |
| | | info.WorkingProcedureEndTime = null; |
| | | info = ParseQRCode(info); |
| | | isAddWorkPieceInfo = true; |
| | | } |
| | | if (logMiddle.WorkingProcedure.Equals("OP10")) |
| | | { |
| | | //var WorkingProcedure = (loginfo.MonitoringPoint.Equals("OP1002") ? "OP10" : "OP40"); |
| | | loginfo2.WorkingProcedure = info.WorkingProcedureCurrent;//解决OP10,OP40同一个的问题 |
| | | logMiddle.WorkingProcedure = info.WorkingProcedureCurrent; //解决OP10,OP40同一个的问题 |
| | | } |
| | | info.UpdatedUserName = logMiddle.MonitoringPoint; |
| | | info.UpdatedTime = DateTimeHelper.GetDateTime(); |
| | | info.WorkingProcedureCompleted = info.WorkingProcedureCompleted + logMiddle.WorkingProcedure;//已完成工序 |
| | | if (!(info.WorkingProcedureStartTime.HasValue && info.WorkingProcedureStartTime > DateTime.Parse("1900/01/01"))) |
| | | {//若一直没有工序开始时间,则赋值当前时间 |
| | | info.WorkingProcedureStartTime = DateTimeHelper.GetDateTime(); |
| | | } |
| | | info.WorkingProcedureEndTime = DateTimeHelper.GetDateTime(); |
| | | info.WorkPieceCurrentPositionOrder = info.WorkingProcedurePlan.IndexOf(logMiddle.WorkingProcedure) / 2; |
| | | info.Remarks = $"{logMiddle.WorkingProcedure}工序完成"; |
| | | long op80id = 0; |
| | | if (logMiddle.WorkingProcedure.Equals("OP80")) |
| | | { |
| | | info.WorkPieceState = (int)WorkPieceState.FinishedProducts; |
| | | info.WorkPieceLastOfflineTime = DateTimeHelper.GetDateTime(); |
| | | info.WorkPieceCurrentPosition = "OP80"; |
| | | info.CompleteTime = DateTimeHelper.GetDateTime(); |
| | | info.OP80NewCode = logMiddle.OP80NewCode; |
| | | |
| | | //质检数据改为 获取文件后修改 【Editby shaocx,2024-06-15】 |
| | | /* |
| | | info.QualityState = (int)((loginfo.QualityStateStr.Equals("OK") || loginfo.QualityStateStr.Equals("0K")) ? QualityState.OK : QualityState.NG); |
| | | loginfo.QualityState = info.QualityState; |
| | | info.QualityStateUpdateUser = loginfo.UpdatedUserName; |
| | | info.QualityStateUpdateTime = loginfo.UpdatedTime.Value.LocalDateTime; |
| | | info.QualityStateUpdateMode = QualityStateUpdateMode.Auto.ToString(); |
| | | //*/ |
| | | |
| | | var qualityData = db.QualityDataInfo.Where(o => o.WorkPieceID == logMiddle.WorkPieceID).FirstOrDefault(); |
| | | if (qualityData == null || qualityData.WorkPieceID.Length < 1 || qualityData.WorkingProcedure.Length < 1) |
| | | {//插入QualityDataInfo表 |
| | | qualityData = EntityPropHelper.Mapper<QualityDataInfo, WorkPieceLog>(logMiddle); |
| | | db.QualityDataInfo.Add(GetAddQualityDataInfo(qualityData)); |
| | | } |
| | | //修改QualityDataInfo表 //重复收到质量信息,会覆盖之前的 |
| | | EntityPropHelper<WorkPieceLogMiddle, QualityDataInfo>.CopyProp(logMiddle, qualityData, GetQualityDataInfoUpdate(logMiddle, logMiddle.WorkingProcedure, logMiddle.MonitoringPoint));//指定修改字段 |
| | | |
| | | //质检数据改为 获取文件后修改 【Editby shaocx,2024-06-15】 |
| | | /* |
| | | qualityData.QualityStateUpdateUser = info.UpdatedUserName; |
| | | qualityData.QualityReceiveTime = info.UpdatedTime.Value.LocalDateTime; |
| | | qualityData.QualityStateUpdateMode = info.QualityStateUpdateMode; |
| | | qualityData.OP80QualityState = loginfo.QualityState.HasValue ? loginfo.QualityState.Value.ToString() : "3"; |
| | | qualityData.OP80QualityReceiveTime = DateTimeHelper.GetDateTime(); |
| | | qualityData.OP80QualityFilePath = loginfo.OP80QualityFilePath; |
| | | op80id = qualityData.Id; |
| | | loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"质量:{loginfo.QualityStateStr ?? "空"}"; |
| | | if (!info.QualityState.Equals(((int)QualityState.OK).ToString())) |
| | | { |
| | | info.QualityErrorInfo = $"{loginfo.WorkingProcedure}工序质量采集数据不合格"; |
| | | } |
| | | else |
| | | { |
| | | info.QualityErrorInfo = ""; |
| | | } |
| | | //*/ |
| | | } |
| | | else if (logMiddle.WorkingProcedure.Equals("OP30")) |
| | | { |
| | | |
| | | info.QualityState = (int)((logMiddle.QualityStateStr.Equals("OK") || logMiddle.QualityStateStr.Equals("0K")) ? QualityState.OK : QualityState.NG); |
| | | logMiddle.QualityState = info.QualityState; |
| | | info.QualityStateUpdateUser = logMiddle.UpdatedUserName; |
| | | info.QualityStateUpdateTime = logMiddle.UpdatedTime.Value.LocalDateTime; |
| | | info.QualityStateUpdateMode = QualityStateUpdateMode.Auto.ToString(); |
| | | |
| | | var qualityData = db.QualityDataInfo.Where(o => o.WorkPieceID == logMiddle.WorkPieceID).FirstOrDefault(); |
| | | if (qualityData == null || qualityData.WorkPieceID.Length < 1 || qualityData.WorkingProcedure.Length < 1) |
| | | {//插入QualityDataInfo表 |
| | | qualityData = EntityPropHelper.Mapper<QualityDataInfo, WorkPieceLog>(logMiddle); |
| | | db.QualityDataInfo.Add(GetAddQualityDataInfo(qualityData)); |
| | | } |
| | | qualityData.QualityStateUpdateUser = info.UpdatedUserName; |
| | | qualityData.QualityReceiveTime = info.UpdatedTime.Value.LocalDateTime; |
| | | qualityData.QualityStateUpdateMode = info.QualityStateUpdateMode; |
| | | qualityData.OP30QualityState = logMiddle.QualityState.HasValue ? logMiddle.QualityState.Value.ToString() : "3"; |
| | | qualityData.OP30QualityReceiveTime = DateTimeHelper.GetDateTime(); |
| | | loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"质量:{logMiddle.QualityStateStr ?? "空"}"; |
| | | if (!info.QualityState.Equals(((int)QualityState.OK).ToString())) |
| | | { |
| | | info.QualityErrorInfo = $"{logMiddle.WorkingProcedure}工序质量采集数据不合格"; |
| | | } |
| | | else |
| | | { |
| | | info.QualityErrorInfo = ""; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | info.WorkPieceState = (int)WorkPieceState.WIP; |
| | | if (info.WorkingProcedurePlan.IndexOf(logMiddle.WorkingProcedure) + 4 <= info.WorkingProcedurePlan.Length) |
| | | { |
| | | info.WorkPieceCurrentPosition = info.WorkingProcedurePlan.Substring(info.WorkingProcedurePlan.IndexOf(logMiddle.WorkingProcedure), 8); |
| | | } |
| | | } |
| | | |
| | | var pro = db.WorkPieceProcess.Where(o => o.WorkPieceID == logMiddle.WorkPieceID && o.WorkingProcedureCurrent == info.WorkingProcedureCurrent && o.OperationType == OperationType.生产.ToString()).OrderByDescending(o => o.StartTime).FirstOrDefault(); |
| | | if (pro == null || pro.WorkPieceID.Length < 1) |
| | | { |
| | | WorkPieceProcess process = new WorkPieceProcess(); |
| | | process = EntityPropHelper.Mapper<WorkPieceProcess, WorkPieceInfo>(info); |
| | | process.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | process.StartTime = DateTimeHelper.GetDateTime(); |
| | | process.EndTime = DateTimeHelper.GetDateTime(); |
| | | if (logMiddle.WorkingProcedure.Equals("OP80")) |
| | | {//OP80的质量数据是后来获取文件搞的 |
| | | } |
| | | else |
| | | { |
| | | process.QualityState = logMiddle.QualityState.HasValue ? logMiddle.QualityState.Value : (int)QualityState.OK; |
| | | } |
| | | process.CreatedUserName = logMiddle.MonitoringPoint; |
| | | process.CreatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | process.UpdatedUserName = logMiddle.MonitoringPoint; |
| | | process.UpdatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | process.OperationType = OperationType.生产.ToString(); |
| | | process.Remarks = ""; |
| | | if (logMiddle.WorkingProcedure.Equals("OP80")) |
| | | { |
| | | process.GetQcDataFlag = logMiddle.GetQcDataFlag;//赋值标记 [Editby shaocx,2024-06-15] |
| | | } |
| | | if (op80id > 0) |
| | | { |
| | | process.QualityDataInfoID = op80id; |
| | | } |
| | | db.WorkPieceProcess.Add(process); |
| | | } |
| | | else |
| | | { |
| | | if (op80id > 0) |
| | | { |
| | | pro.QualityDataInfoID = op80id; |
| | | } |
| | | pro.EndTime = DateTimeHelper.GetDateTime(); |
| | | pro.UpdatedUserName = logMiddle.MonitoringPoint; |
| | | pro.UpdatedTime = DateTimeHelper.GetDateTime(); |
| | | if (logMiddle.WorkingProcedure.Equals("OP80")) |
| | | { |
| | | if (pro.GetQcDataFlag != 0) |
| | | { |
| | | pro.GetQcDataFlag = logMiddle.GetQcDataFlag;//赋值标记 [Editby shaocx,2024-06-15] |
| | | } |
| | | } |
| | | } |
| | | |
| | | |
| | | if (isAddWorkPieceInfo) |
| | | { |
| | | db.WorkPieceInfo.Add(info); |
| | | } |
| | | db.WorkPieceInfoLog.Add(GetAddWorkPieceInfoLog(info)); |
| | | } |
| | | else |
| | | { |
| | | loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"下线完成读取二维码{logMiddle.WorkPieceID ?? "空"}异常"; |
| | | Log4NetHelper.WriteErrorLog(type, $" {logMiddle.WorkingProcedure}工序下线 读取工件码数据[{logMiddle.WorkPieceID ?? "空"}]时异常:"); |
| | | |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"读取二维码{logMiddle.WorkPieceID ?? "空"}更新数据异常{e.Message}"; |
| | | } |
| | | db.WorkPieceLog.Add(GetAddWorkPieceLog(loginfo2));//插入工件采集日志表 |
| | | db.SaveChanges(); |
| | | } |
| | | } |
| | | public static void AlertMonitor(WorkPieceLog loginfo, LogType type) |
| | | { |
| | | |
| | |
| | | {//自动运行状态+下料道满料 = 完成 (就是有生产出来但没有出设备) |
| | | State = ((int)EnumEquipmentCurrentStateDisplay.完成).ToString(); |
| | | } |
| | | //else if (loginfo.IsNormalProduction && loginfo.LackMaterial) |
| | | //{//其他状态全算待机 |
| | | // State = ((int)EnumEquipmentCurrentStateDisplay.待机).ToString(); |
| | | //} |
| | | else |
| | | {//其他状态全算待机 |
| | | State = ((int)EnumEquipmentCurrentStateDisplay.待机).ToString(); |
| | | CommonHandleEnumEquipmentCurrentState(db, info, ref State); //公共处理 设备当前状态 [Editby shaocx,2025-01-07] |
| | | } |
| | | } |
| | | } |
| | |
| | | .OrderByDescending(o => o.WarnStartTime).FirstOrDefault(); |
| | | if (loginfo.IsMessage) |
| | | {//若有告警,如果有设备状态变更,肯定插入,此处只修改即可 |
| | | //若有告警,如果设备状态没有变更,有告警,也不插入新的(问题:当状态没有更改,如一直是故障,但告警信息有变化,怎么办 ps:此处先不管) |
| | | //若有告警,如果设备状态没有变更,有告警,也不插入新的(问题:当状态没有更改,如一直是故障,但告警信息有变化,怎么办 ps:此处先不管) |
| | | infolog.WarnStartTime = DateTimeHelper.GetDateTime(); |
| | | infolog.WarnType = alertall; |
| | | infolog.Warnmsg = warnmsg; |
| | |
| | | equlogalert.WarnEndTime = DateTimeHelper.GetDateTime(); |
| | | } |
| | | } |
| | | #region 原来的代码,以后删掉 |
| | | |
| | | //EquipmentWorkingLog infolog =new EquipmentWorkingLog(); |
| | | //infolog.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | | //infolog.LogAddTime = DateTimeHelper.GetDateTime(); |
| | | //infolog.WorkPieceLogID = loginfo2.Id; |
| | | //infolog.EquipmentID = info.EquipmentID; |
| | | //bool isAddEquipmentWorkingLog = false; |
| | | //if (loginfo.ischeckAlertStatus) |
| | | //{//告警状态发生变更 |
| | | // //说明是一个新告警,需要更新设备监控表 |
| | | // //查找未结束的告警 |
| | | // var equlog = db.EquipmentWorkingLog.Where(o => o.EquipmentID == loginfo.EquipmentID |
| | | // && o.FailureStartTime != null && o.FailureStartTime != DateTime.MinValue) |
| | | // .OrderByDescending(o=>o.FailureStartTime).FirstOrDefault(); |
| | | // if (loginfo.IsCloseAlert) |
| | | // { |
| | | // if (equlog == null|| (equlog.FailureEndTime!=null&& equlog.FailureEndTime > DateTime.MinValue)) |
| | | // { |
| | | // info.AlertTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | // infolog.FailureStartTime = DateTimeHelper.GetDateTime(); |
| | | // infolog.FailureType = faultall; |
| | | // infolog.FailureMsg = faultmsg; |
| | | // infolog.WorkingProcedure = loginfo.WorkingProcedure; |
| | | // infolog.MonitoringPoint = loginfo.MonitoringPoint; |
| | | // infolog.Remarks = "故障信息出现变更1"; |
| | | // infolog.UpdateDesc = (infolog.UpdateDesc??"")+"故障信息变更\r\n"; |
| | | // isAddEquipmentWorkingLog =true; |
| | | // } |
| | | // } |
| | | // else |
| | | // { |
| | | // if (equlog != null && (equlog.FailureEndTime == null || equlog.FailureEndTime <= DateTime.MinValue)) |
| | | // {//告警关闭的,若没有告警信息,不用管 |
| | | // equlog.MonitoringPoint = loginfo.MonitoringPoint; |
| | | // equlog.FailureEndTime = DateTimeHelper.GetDateTime(); |
| | | // } |
| | | |
| | | // } |
| | | //} |
| | | //if (loginfo.ischeckMessageStatus) |
| | | //{//告警状态发生变更 |
| | | // //说明是一个新告警,需要更新设备监控表 |
| | | // //查找未结束的告警 |
| | | // var equlog = db.EquipmentWorkingLog.Where(o => o.EquipmentID == loginfo.EquipmentID |
| | | // && o.WarnStartTime != null && o.WarnStartTime != DateTime.MinValue).OrderByDescending(o => o.WarnStartTime).FirstOrDefault(); |
| | | // if (loginfo.IsMessage) |
| | | // { |
| | | // if (equlog == null || (equlog.WarnEndTime != null && equlog.WarnEndTime > DateTime.MinValue)) |
| | | // { |
| | | // info.WarnTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); |
| | | // infolog.WarnStartTime = DateTimeHelper.GetDateTime(); |
| | | // infolog.WarnType = alertall; |
| | | // infolog.Warnmsg = warnmsg; |
| | | // infolog.WorkingProcedure = loginfo.WorkingProcedure; |
| | | // infolog.MonitoringPoint = loginfo.MonitoringPoint; |
| | | // infolog.Remarks = "告警信息出现变更2"; |
| | | // infolog.UpdateDesc = (infolog.UpdateDesc ?? "") + "告警信息变更\r\n"; |
| | | // isAddEquipmentWorkingLog = true; |
| | | // } |
| | | // } |
| | | // else |
| | | // { |
| | | // if (equlog != null && (equlog.WarnEndTime == null || equlog.WarnEndTime <= DateTime.MinValue)) |
| | | // {//告警关闭的,若没有告警信息,不用管 |
| | | // equlog.MonitoringPoint = loginfo.MonitoringPoint; |
| | | // equlog.WarnEndTime = DateTimeHelper.GetDateTime(); |
| | | // } |
| | | |
| | | // } |
| | | //} |
| | | ////故障》警告》其他 |
| | | //if (loginfo.IsCloseAlert) |
| | | //{//故障 |
| | | // info.AlertTime = info.AlertTime??DateTime.Now; |
| | | // info.FailureType = ""; |
| | | // info.WarnType = ""; |
| | | // info.Alertmsg = faultmsg;//这个需要代码对应字典维护信息才知道 |
| | | // info.FailureType = faultall; |
| | | // State = ((int)EnumEquipmentCurrentStateDisplay.故障).ToString(); |
| | | |
| | | |
| | | // infolog.FailureStartTime = DateTimeHelper.GetDateTime(); |
| | | // infolog.FailureType = faultall; |
| | | // infolog.FailureMsg = faultmsg; |
| | | // if (loginfo.IsMessage) |
| | | // { |
| | | // info.WarnTime = info.WarnTime ?? DateTime.Now; |
| | | // info.Warnmsg = warnmsg;//这个需要代码对应字典维护信息才知道 |
| | | // info.WarnType = alertall; |
| | | // } |
| | | //} |
| | | //else if(loginfo.IsMessage) |
| | | //{//警告 |
| | | // info.AlertTime = null; |
| | | // info.Alertmsg = "";//这个需要代码对应字典维护信息才知道 |
| | | // info.FailureType = ""; |
| | | |
| | | // info.WarnTime = info.WarnTime ?? DateTime.Now; |
| | | // info.Warnmsg = warnmsg;//这个需要代码对应字典维护信息才知道 |
| | | // info.WarnType = alertall; |
| | | |
| | | // infolog.WarnStartTime = DateTimeHelper.GetDateTime(); |
| | | // infolog.WarnType = alertall; |
| | | // infolog.Warnmsg = warnmsg; |
| | | // State = ((int)EnumEquipmentCurrentStateDisplay.警告).ToString(); |
| | | //} |
| | | //else |
| | | //{//告警结束,获取有告警的数据,然后关闭他 |
| | | // info.AlertTime = null; |
| | | // info.Alertmsg = "";//这个需要代码对应字典维护信息才知道 |
| | | // info.FailureType = ""; |
| | | // info.WarnType = ""; |
| | | // info.WarnTime = null; |
| | | // info.Warnmsg = ""; |
| | | // if (loginfo.IsNormalProduction&& loginfo.LackMaterial) |
| | | // { |
| | | // State = ((int)EnumEquipmentCurrentStateDisplay.待机).ToString(); |
| | | // } |
| | | // else if(loginfo.IsNormalProduction && !loginfo.LackMaterial) |
| | | // { |
| | | // State = ((int)EnumEquipmentCurrentStateDisplay.生产).ToString(); |
| | | // } |
| | | // else if(loginfo.IsNormalProduction && loginfo.FullMaterial) |
| | | // {//正常生产+下料道满料 = 完成 (就是有生产出来但没有出设备) |
| | | // State = ((int)EnumEquipmentCurrentStateDisplay.完成).ToString(); |
| | | // } |
| | | // else |
| | | // {//理论上不可能走到这,只是避免空值 |
| | | // State = ((int)EnumEquipmentCurrentStateDisplay.待机).ToString(); |
| | | // } |
| | | //} |
| | | //if (!string.IsNullOrEmpty(State) && State != info.EquipmentCurrentState) |
| | | //{//只有状态出现变化才变更 |
| | | // info.UpdatedUserName = loginfo.MonitoringPoint; |
| | | // info.UpdatedTime = DateTime.Now; |
| | | // info.EquipmentCurrentState = State; |
| | | |
| | | // var equlog = db.EquipmentWorkingLog.Where(o => o.EquipmentID == loginfo.EquipmentID |
| | | // && o.EquipmentStateStartTime != null && o.EquipmentStateStartTime != DateTime.MinValue).OrderByDescending(o => o.EquipmentStateStartTime).FirstOrDefault(); |
| | | |
| | | // if (equlog != null && (equlog.EquipmentStateEndTime == null || equlog.EquipmentStateEndTime <= DateTime.MinValue)) |
| | | // { |
| | | // equlog.MonitoringPoint = loginfo.MonitoringPoint; |
| | | // equlog.EquipmentStateEndTime = DateTimeHelper.GetDateTime(); |
| | | |
| | | // } |
| | | // //状态变更,需要更新原来的,并插入新的 |
| | | // infolog.EquipmentState = State; |
| | | // infolog.EquipmentStateStartTime = DateTimeHelper.GetDateTime(); |
| | | // infolog.WorkingProcedure = loginfo.WorkingProcedure; |
| | | // infolog.MonitoringPoint = loginfo.MonitoringPoint; |
| | | // infolog.Remarks = "告警信息出现变更3"; |
| | | // infolog.UpdateDesc = (infolog.UpdateDesc ?? "") + $"设备状态变更为{((EnumEquipmentCurrentStateDisplay)int.Parse(State)).ToString()}\r\n"; |
| | | // isAddEquipmentWorkingLog = true; |
| | | //} |
| | | ////info.Remarks = $"{loginfo.WorkingProcedure}工序告警"; |
| | | #endregion |
| | | if (isAddEquipmentCurrentMonitor) |
| | | { |
| | | info.Id = Yitter.IdGenerator.YitIdHelper.NextId(); |
| | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"{loginfo2.MonitoringPoint}设备监控更新数据异常{e.Message}.{e.StackTrace}"; |
| | | loginfo2.Remarks = $"{loginfo2.MonitoringPoint}设备监控更新数据异常{e.Message}.{e.StackTrace}"; |
| | | Log4NetHelper.WriteErrorLog(type, $"{loginfo2.MonitoringPoint}设备监控更新数据异常{e.Message}.{e.StackTrace}"); |
| | | } |
| | | |
| | | //db.WorkPieceLog.Add(loginfo2);//插入设备采集日志表 |
| | | db.SaveChanges(); |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 公共处理 设备当前状态 |
| | | /// </summary> |
| | | /// <param name="db"></param> |
| | | /// <param name="info"></param> |
| | | /// <param name="state"></param> |
| | | private static void CommonHandleEnumEquipmentCurrentState(DbModel db, EquipmentCurrentMonitor info, ref string state) |
| | | { |
| | | try |
| | | { |
| | | //如果是OP35,则处理,如果不是,则不处理 |
| | | var query_WorkingProcedure = "OP35"; |
| | | if (info.WorkingProcedure == query_WorkingProcedure) |
| | | { |
| | | var quereyCreateTime = DateTime.Now.AddMinutes(-5); |
| | | //判断10分钟之内 ,只进 不出 |
| | | var num = db.WorkPieceProcess.Where(o => o.WorkingProcedureCurrent == query_WorkingProcedure |
| | | && (o.EndTime == null || o.EndTime <= DateTime.MinValue) |
| | | && o.CreatedTime >= quereyCreateTime |
| | | ).Count(); |
| | | if (num > 0) |
| | | { |
| | | state = ((int)EnumEquipmentCurrentStateDisplay.生产).ToString(); |
| | | return; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | return; |
| | | } |
| | | return; |
| | | } |
| | | catch (Exception) |
| | | { |
| | | return; |
| | | } |
| | | } |
| | | |
| | |
| | | info.UpdatedTime = DateTimeHelper.GetDateTime(); |
| | | info.UpdatedUserName = threadinfo.Threadcode; |
| | | info.Threadlastmodifytime = threadinfo.Threadlastmodifytime > DateTime.MinValue ? threadinfo.Threadlastmodifytime : info.Threadlastmodifytime;//如果有传参则更新 |
| | | //if (info.Threadstatue==1) |
| | | //{ |
| | | // info.Threadlastmodifytime = DateTimeHelper.GetDateTime();//最新跑到数据 |
| | | //} |
| | | //if (info.Threadstatue==1) |
| | | //{ |
| | | // info.Threadlastmodifytime = DateTimeHelper.GetDateTime();//最新跑到数据 |
| | | //} |
| | | } |
| | | db.SaveChanges(); |
| | | } |
| | |
| | | |
| | | public static void SetQualityNoOk_WorkPieceInfo(WorkPieceLogMiddle logMiddle, ref WorkPieceInfo pieceInfo) |
| | | { |
| | | if (!IsWirteQualityNoOk(logMiddle, pieceInfo.QualityNoOk)) return; |
| | | |
| | | pieceInfo.QualityNoOk = logMiddle.QualityNoOk; |
| | | pieceInfo.QualityNoOkReason = logMiddle.QualityNoOkReason; |
| | | } |
| | | public static void SetQualityNoOk_WorkPieceProcess(WorkPieceLogMiddle logMiddle, ref WorkPieceProcess pieceProcess) |
| | | { |
| | | if (!IsWirteQualityNoOk(logMiddle, pieceProcess.QualityNoOk)) return; |
| | | |
| | | pieceProcess.QualityNoOk = logMiddle.QualityNoOk; |
| | | pieceProcess.QualityNoOkReason = logMiddle.QualityNoOkReason; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 是否需要重写 NOOK原因 |
| | | /// </summary> |
| | | /// <param name="logMiddle"></param> |
| | | /// <param name="pieceInfo"></param> |
| | | /// <returns></returns> |
| | | public static bool IsWirteQualityNoOk(WorkPieceLogMiddle logMiddle, int? qualityNoOk) |
| | | { |
| | | if (logMiddle.WorkingProcedure == (WorkingProcedureForHMI.OP30).ToString()) |
| | | { |
| | | //特殊逻辑:按照OP30的顺序判断 |
| | | if (logMiddle.QualityNoOk != null && qualityNoOk != null |
| | | && ( |
| | | qualityNoOk == (int)QualityNoOkEnum.OP30压衬套工位力矩超差 |
| | | || qualityNoOk == (int)QualityNoOkEnum.OP30涨断工位力矩超差 |
| | | || qualityNoOk == (int)QualityNoOkEnum.OP30终拧紧工位力矩超差 |
| | | || qualityNoOk == (int)QualityNoOkEnum.OP30预拧紧工位力矩超差 |
| | | ) |
| | | ) |
| | | { |
| | | if ((int)logMiddle.QualityNoOk > (int)qualityNoOk) |
| | | {//不需要重新赋值 |
| | | return false; |
| | | } |
| | | } |
| | | } |
| | | |
| | | return true; |
| | | } |
| | | |
| | | |
| | |
| | | return loginfo; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 设置中间变量的质量数据 |
| | | /// </summary> |
| | | /// <param name="logMiddle"></param> |
| | | public static void SetLogMiddleForQuality(ref WorkPieceLogMiddle logMiddle) |
| | | { |
| | | |
| | | logMiddle.QualityState = (int)((logMiddle.QualityStateStr.Equals("OK") || logMiddle.QualityStateStr.Equals("0K")) ? QualityStateEnum.OK : QualityStateEnum.NG); |
| | | |
| | | //根据质量数据判断是否合格/不合格 【Editby shaocx,2024-06-25】 |
| | | QualityNoOkEnum? qualityNoOkEnum = null; |
| | | QualityStateEnum qualityState = WorkPieceInfoManager.CalcQualityStateForOP(logMiddle, ref qualityNoOkEnum); |
| | | logMiddle.QualityState = (int)qualityState; |
| | | logMiddle.QualityStateStr = qualityState.ToString(); |
| | | if (qualityNoOkEnum != null) |
| | | { |
| | | logMiddle.QualityNoOk = (int)qualityNoOkEnum; |
| | | logMiddle.QualityNoOkReason = qualityNoOkEnum.ToString(); |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 计算OP 质量数据是否合格 |
| | | /// </summary> |
| | | public static QualityState CalcQualityStateForOP(WorkPieceLogMiddle logMiddle, ref QualityNoOkEnum? qualityNoOkEnum) |
| | | private static QualityStateEnum CalcQualityStateForOP(WorkPieceLogMiddle logMiddle, ref QualityNoOkEnum? qualityNoOkEnum) |
| | | { |
| | | QualityState qualityState = QualityState.Suspected; |
| | | QualityStateEnum qualityState = QualityStateEnum.Suspected; |
| | | if (logMiddle.WorkingProcedure == "OP60") |
| | | { |
| | | {//合格/不合格由 WMS自行判断 |
| | | decimal _QualityOP60To1 = SystemHelper.GetDecimal(logMiddle.QualityOP60To1); |
| | | decimal _QualityOP60To2 = SystemHelper.GetDecimal(logMiddle.QualityOP60To2); |
| | | var isPass_QualityOP60To1 = false; |
| | |
| | | |
| | | if (isPass_QualityOP60To1 && isPass_QualityOP60To2) |
| | | { |
| | | qualityState = QualityState.OK; |
| | | qualityState = QualityStateEnum.OK; |
| | | } |
| | | else |
| | | { |
| | | qualityState = QualityState.NG; |
| | | qualityState = QualityStateEnum.NG; |
| | | } |
| | | if (_QualityOP60To1 == 0 || _QualityOP60To2 == 0) |
| | | { |
| | | qualityState = QualityState.Suspected; |
| | | qualityState = QualityStateEnum.Suspected; |
| | | return qualityState; |
| | | } |
| | | return qualityState; |
| | | } |
| | | else if (logMiddle.WorkingProcedure == "OP80") |
| | | {//合格/不合格由 OP80 判断,QualityState 和 QualityStateStr 都在调用当前方法前 写入值了 |
| | | if (logMiddle.QualityState == (int)QualityStateEnum.OK) |
| | | { |
| | | qualityState = QualityStateEnum.OK; |
| | | return qualityState; |
| | | } |
| | | |
| | | decimal _QualityOP80_D_TKZJ = SystemHelper.GetDecimal(logMiddle.QualityOP80_D_TKZJ); |
| | | if (!(_QualityOP80_D_TKZJ >= (decimal)53.018 && _QualityOP80_D_TKZJ <= (decimal)53.03)) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP80大头孔直径超差; |
| | | } |
| | | |
| | | decimal _QualityOP80_X_TKZJ = SystemHelper.GetDecimal(logMiddle.QualityOP80_X_TKZJ); |
| | | if (!(_QualityOP80_X_TKZJ >= (decimal)22.005 && _QualityOP80_X_TKZJ <= (decimal)22.011)) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP80小头孔直径超差; |
| | | } |
| | | |
| | | decimal _QualityOP80_ZXJ = SystemHelper.GetDecimal(logMiddle.QualityOP80_ZXJ); |
| | | if (!(_QualityOP80_ZXJ >= (decimal)144.475 && _QualityOP80_ZXJ <= (decimal)144.525)) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP80中心距超差; |
| | | } |
| | | |
| | | decimal _QualityOP80_DTKYZD = SystemHelper.GetDecimal(logMiddle.QualityOP80_DTKYZD); |
| | | if (!(_QualityOP80_DTKYZD >= (decimal)0 && _QualityOP80_DTKYZD <= (decimal)0.005)) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP80大头孔圆柱度超差; |
| | | } |
| | | |
| | | decimal _QualityOP80_XTSMYD = SystemHelper.GetDecimal(logMiddle.QualityOP80_XTSMYD); |
| | | if (!(_QualityOP80_XTSMYD >= (decimal)0 && _QualityOP80_XTSMYD <= (decimal)0.003)) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP80小头孔圆度上面超差; |
| | | } |
| | | |
| | | decimal _QualityOP80_XTXMYD = SystemHelper.GetDecimal(logMiddle.QualityOP80_XTXMYD); |
| | | if (!(_QualityOP80_XTXMYD >= (decimal)0 && _QualityOP80_XTXMYD <= (decimal)0.003)) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP80小头孔圆度下面超差; |
| | | } |
| | | |
| | | decimal _QualityOP80To4 = SystemHelper.GetDecimal(logMiddle.QualityOP80To4); |
| | | if (!(_QualityOP80To4 >= (decimal)(-0.075) && _QualityOP80To4 <= (decimal)0.075)) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP80小头孔平行度弯曲超差; |
| | | } |
| | | |
| | | decimal _QualityOP80To5 = SystemHelper.GetDecimal(logMiddle.QualityOP80To5); |
| | | if (!(_QualityOP80To5 >= (decimal)(-0.2) && _QualityOP80To5 <= (decimal)0.2)) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP80小头孔平行度扭曲超差; |
| | | } |
| | | |
| | | decimal _QualityOP80To6 = SystemHelper.GetDecimal(logMiddle.QualityOP80To6); |
| | | if (!(_QualityOP80To6 >= (decimal)0 && _QualityOP80To6 <= (decimal)0.04)) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP80大头孔垂直度超差; |
| | | } |
| | | |
| | | decimal _QualityOP80To10 = SystemHelper.GetDecimal(logMiddle.QualityOP80To10); |
| | | if (!(_QualityOP80To10 >= (decimal)0 && _QualityOP80To10 <= (decimal)0.04)) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP80小头孔垂直度超差; |
| | | } |
| | | |
| | | decimal _QualityOP80_Houdu = SystemHelper.GetDecimal(logMiddle.QualityOP80_Houdu); |
| | | if (!(_QualityOP80_Houdu >= (decimal)21.80 && _QualityOP80_Houdu <= (decimal)21.85)) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP80厚度超差; |
| | | } |
| | | |
| | | decimal _QualityOP80To1 = SystemHelper.GetDecimal(logMiddle.QualityOP80To1); |
| | | if (!(_QualityOP80To1 >= (decimal)364 && _QualityOP80To1 <= (decimal)385)) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP80大头端重量超差; |
| | | } |
| | | |
| | | decimal _QualityOP80To2 = SystemHelper.GetDecimal(logMiddle.QualityOP80To2); |
| | | if (!(_QualityOP80To2 >= (decimal)143 && _QualityOP80To2 <= (decimal)155)) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP80小头端重量超差; |
| | | } |
| | | |
| | | |
| | | return qualityState; |
| | | } |
| | | else if (logMiddle.WorkingProcedure == "OP10") |
| | | { |
| | | if (logMiddle.QualityState != (int)QualityState.OK) |
| | | {//合格/不合格由 QualityStateStr值判断 |
| | | if (logMiddle.QualityState == (int)QualityStateEnum.NG) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP10厚度超差; |
| | | } |
| | | else |
| | | { |
| | | qualityState = QualityStateEnum.OK; |
| | | } |
| | | return qualityState; |
| | | } |
| | | else if (logMiddle.WorkingProcedure == "OP20") |
| | | { |
| | | if (logMiddle.QualityState != (int)QualityState.OK) |
| | | {//合格/不合格由 QualityStateStr值判断 |
| | | if (logMiddle.QualityState == (int)QualityStateEnum.NG) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP20小头孔直径超差; |
| | | } |
| | | else |
| | | { |
| | | qualityState = QualityStateEnum.OK; |
| | | } |
| | | return qualityState; |
| | | } |
| | | else if (logMiddle.WorkingProcedure == "OP30") |
| | | {//合格/不合格由 QualityStateStr值判断 |
| | | if (logMiddle.QualityStateStr.Equals("OK")) |
| | | { |
| | | qualityState = QualityStateEnum.OK; |
| | | } |
| | | else |
| | | { |
| | | qualityState = QualityStateEnum.NG; |
| | | } |
| | | return qualityState; |
| | | } |
| | | else if (logMiddle.WorkingProcedure == "OP35") |
| | | { |
| | | if (logMiddle.QualityState != (int)QualityState.OK) |
| | | {//合格/不合格由 QualityStateStr值判断 |
| | | if (logMiddle.QualityState == (int)QualityStateEnum.NG) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP35滚压力不合格; |
| | | qualityNoOkEnum = QualityNoOkEnum.OP35滚压力超差; |
| | | } |
| | | else |
| | | { |
| | | qualityState = QualityStateEnum.OK; |
| | | } |
| | | return qualityState; |
| | | } |
| | | else if (logMiddle.WorkingProcedure == "OP40") |
| | | { |
| | | if (logMiddle.QualityState != (int)QualityState.OK) |
| | | {//合格/不合格由 QualityStateStr值判断 |
| | | if (logMiddle.QualityState == (int)QualityStateEnum.NG) |
| | | { |
| | | qualityNoOkEnum = QualityNoOkEnum.OP40厚度超差; |
| | | } |
| | | else |
| | | { |
| | | qualityState = QualityStateEnum.OK; |
| | | } |
| | | return qualityState; |
| | | } |
| | |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 获取质量状态值 |
| | | /// </summary> |
| | | /// <param name="qualityState"></param> |
| | | /// <returns></returns> |
| | | public static int GetQualityStateValue(int? qualityState) |
| | | { |
| | | if (qualityState.HasValue == false) |
| | | { |
| | | return (int)QualityStateEnum.Suspected; |
| | | } |
| | | if (qualityState.Value == 1) |
| | | { |
| | | return (int)QualityStateEnum.OK; |
| | | } |
| | | if (qualityState.Value == 2) |
| | | { |
| | | return (int)QualityStateEnum.NG; |
| | | } |
| | | return (int)QualityStateEnum.Suspected; |
| | | } |
| | | |
| | | |
| | | #endregion |
| | | } |
| | | } |