From f3ac4e7983dd475d800acc31cbbb8bbaf2e6c638 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周四, 29 8月 2024 15:08:18 +0800 Subject: [PATCH] 修复 OP05工位 获取打标二维码,会漏获取数据 --- DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/BLL/WorkPieceInfoManager.cs | 278 ++++++++++++++++++++++++++++++++++++++++--------------- 1 files changed, 202 insertions(+), 76 deletions(-) diff --git a/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/BLL/WorkPieceInfoManager.cs b/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/BLL/WorkPieceInfoManager.cs index 5dd9efd..6722b9c 100644 --- a/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/BLL/WorkPieceInfoManager.cs +++ b/DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_BusinessLogical/BLL/WorkPieceInfoManager.cs @@ -1,4 +1,5 @@ -锘縰sing iWare_SCADA_BusinessLogical.Utils; +锘縰sing HslCommunication.BasicFramework; +using iWare_SCADA_BusinessLogical.Utils; using iWare_SCADA_Model; using iWare_SCADA_Model.MiddleModel; using iWare_SCADA_Model.TableModel; @@ -7,6 +8,7 @@ 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; @@ -214,40 +216,54 @@ info.WorkingProcedureCurrent = loginfo.WorkingProcedure; info.Remarks = info.Remarks ?? "" + $"{info.WorkingProcedureCurrent}宸ヤ欢涓婄嚎"; + //淇涓� op35 鍚屼竴涓欢 涓嬬嚎鏃堕棿璺熶笅涓�涓笂绾挎椂闂翠竴妯′竴鏍风殑闂 銆怑ditby shaocx,2024-08-27銆� + var isNeedAddNewProcess = true; 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 ?? "") + "鍙堜竴娆′笂绾匡紝鏇存柊缁撴潫鏃堕棿"; + if (pro.WorkingProcedureCurrent == loginfo.WorkingProcedure) + {//琛ㄧず宸ュ簭鐩稿悓 + isNeedAddNewProcess = false; + pro.Remarks = (pro.Remarks ?? "") + "鍙堜竴娆′笂绾匡紝鏇存柊缁撴潫鏃堕棿"; + } + else + { + 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(); - - //涓嶅啀榛樿璧嬪�间负鍚堟牸 銆怑ditby shaocx,2024-08-16銆� - //process.QualityState = info.QualityState.HasValue ? info.QualityState.Value : (int)QualityState.OK;//榛樿鍚堟牸锛屽凡澶勭悊 - process.QualityState = GetQualityStateValue(info.QualityState); - - if (process.WorkingProcedureCurrent == WorkingProcedureForHMI.OP70.ToString()) - { //鐗规畩澶勭悊OP70锛屽洜涓篛P70娌℃湁娴嬮噺锛岄粯璁ゅ悎鏍� [Editby shaocx,2024-07-03] - process.QualityState = (int)QualityState.OK;//榛樿鍚堟牸锛孫P70榛樿鏄悎鏍� - } - - 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")) + if (isNeedAddNewProcess) { - process.EndTime = process.StartTime; + //姣忔鎵弿涓婄嚎閮芥彃鍏ヨ拷婧〃 + WorkPieceProcess new_process = new WorkPieceProcess(); + new_process = EntityPropHelper.Mapper<WorkPieceProcess, WorkPieceInfo>(info); + QualityStateHelper.ResetQualityNoOkForNewProcess(ref new_process); + new_process.StartTime = DateTimeHelper.GetDateTime(); + + //涓嶅啀榛樿璧嬪�间负鍚堟牸 銆怑ditby shaocx,2024-08-16銆� + //process.QualityState = info.QualityState.HasValue ? info.QualityState.Value : (int)QualityState.OK;//榛樿鍚堟牸锛屽凡澶勭悊 + new_process.QualityState = GetQualityStateValue(info.QualityState); + + if (new_process.WorkingProcedureCurrent == WorkingProcedureForHMI.OP70.ToString()) + { //鐗规畩澶勭悊OP70锛屽洜涓篛P70娌℃湁娴嬮噺锛岄粯璁ゅ悎鏍� [Editby shaocx,2024-07-03] + new_process.QualityState = (int)QualityState.OK;//榛樿鍚堟牸锛孫P70榛樿鏄悎鏍� + } + + new_process.Id = Yitter.IdGenerator.YitIdHelper.NextId(); + new_process.CreatedUserName = loginfo.MonitoringPoint; + new_process.CreatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); + new_process.UpdatedUserName = loginfo.MonitoringPoint; + new_process.UpdatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local); + new_process.OperationType = OperationType.鐢熶骇.ToString(); + new_process.Remarks = ""; + if (loginfo.WorkingProcedure.Equals("OP05")) + { + new_process.EndTime = new_process.StartTime; + } + db.WorkPieceProcess.Add(new_process); } - db.WorkPieceProcess.Add(process); //db.Database.AutoTransactionsEnabled = false;// 鍚屼竴涓猄aveChanges榛樿浜嬪姟锛� 鍏抽棴榛樿浜嬪姟锛�... 濂藉儚涓嶈兘鐢ㄥ晩锛屽悗闈㈠啀鐮旂┒鍚� if (isAddWorkPieceInfo) @@ -358,12 +374,38 @@ catch (Exception e) { loginfo.Remarks = (loginfo.Remarks ?? "") + $"璇诲彇浜岀淮鐮亄loginfo.WorkPieceID ?? "绌�"}鏇存柊鏁版嵁寮傚父{e.Message}"; + Log4NetHelper.WriteErrorLog(type, $" {loginfo.WorkingProcedure}涓婄嚎鐩戞帶璇荤爜鏍囪 璇诲彇宸ヤ欢鐮佹暟鎹甗{loginfo.WorkPieceID ?? "绌�"}]鏃跺紓甯革細", e); } finally { loginfo.Id = Yitter.IdGenerator.YitIdHelper.NextId(); db.WorkPieceLog.Add(loginfo); - db.SaveChanges(); + + //淇濆瓨鏁版嵁搴撶殑寮傚父鎹曟崏 [Editby shaocx,2024-08-29] + try + { + db.SaveChanges(); + } + catch (DbEntityValidationException exception) + { + var errorMessages = + exception.EntityValidationErrors + .SelectMany(validationResult => validationResult.ValidationErrors) + .Select(m => m.ErrorMessage); + var fullErrorMessage = string.Join(", ", errorMessages); + var exceptionMessage = string.Concat(exception.Message, " 楠岃瘉寮傚父娑堟伅鏄細", fullErrorMessage); + + Log4NetHelper.WriteErrorLog(type, $" {loginfo.WorkingProcedure}涓婄嚎鐩戞帶璇荤爜鏍囪 璇诲彇宸ヤ欢鐮佹暟鎹甗{loginfo.WorkPieceID ?? "绌�"}],淇濆瓨鏁版嵁搴撴椂寮傚父锛�" + exceptionMessage, exception); + + throw new DbEntityValidationException(exceptionMessage, exception.EntityValidationErrors); + } + catch (Exception) + { + + throw; + } + + } @@ -469,6 +511,9 @@ /// <param name="type"></param> public static void QualityInfoComplete(WorkPieceLogMiddle logMiddle, LogType type) { + //鏍规嵁璐ㄩ噺鏁版嵁鍒ゆ柇鏄惁鍚堟牸/涓嶅悎鏍� 銆怑ditby shaocx,2024-06-25銆� + WorkPieceInfoManager.SetLogMiddleForQuality(ref logMiddle); + //姝ゅ鍚屾椂鎻掑叆浜哤orkPieceLog锛學orkPieceInfoLog琛紝骞舵柊澧炴垨淇敼WorkPieceInfo琛� //鎻掑叆璐ㄩ噺鐩稿叧琛≦ualityDataInfo @@ -718,10 +763,17 @@ 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_05 = WorkPieceProcessHelper.CreateWorkPieceProcessForOP05(logMiddle, db, pieceInfo); + if (process_05 != null) + {//鍒涘缓OP05宸ュ簭锛屽綋娌℃湁05宸ュ簭鏃�,鎵嶅垱寤� 銆怑ditby shaocx,2024-08-29銆� + db.WorkPieceProcess.Add(process_05); + } WorkPieceProcess process = new WorkPieceProcess(); process = EntityPropHelper.Mapper<WorkPieceProcess, WorkPieceInfo>(pieceInfo); + QualityStateHelper.ResetQualityNoOkForNewProcess(ref process); process.StartTime = DateTimeHelper.GetDateTime(); //涓嶅啀榛樿璧嬪�间负鍚堟牸 銆怑ditby shaocx,2024-08-16銆� @@ -900,9 +952,9 @@ { 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) + WorkPieceInfo cur_db_info = new WorkPieceInfo(); + cur_db_info = db.WorkPieceInfo.Where(o => o.WorkPieceID == loginfo.WorkPieceID).FirstOrDefault(); + if (cur_db_info == null || cur_db_info.WorkPieceID.Length < 1) {//娌℃湁宸ヤ欢淇℃伅锛屼笉鍋氭洿鏂� Log4NetHelper.WriteErrorLog(type, $"宸ヤ欢{loginfo.WorkPieceID} 宸ヤ欢鎺ㄥ嚭宸ュ簭{loginfo.WorkingProcedure} 娌℃湁鑾峰彇鍒板伐浠朵俊鎭笉鍋氭洿鏂�"); return; @@ -911,43 +963,58 @@ {//鏇存柊琛╓orkPieceInfo if (loginfo.WorkingProcedure.Equals("OP10")) { + /* info.WorkPieceCurrentPosition = info.WorkingProcedureCurrent + "NOOK"; - //var WorkingProcedure = (loginfo.MonitoringPoint.Equals("OP1002") ? "OP10" : "OP40"); loginfo2.WorkingProcedure = info.WorkingProcedureCurrent;//瑙e喅OP10锛孫P40鍚屼竴涓殑闂 loginfo.WorkingProcedure = info.WorkingProcedureCurrent; //瑙e喅OP10锛孫P40鍚屼竴涓殑闂 + //*/ + //淇 閿欒璁板綍鎴怬P05鐨勯棶棰� 銆怑ditby shaocx,2024-08-26銆� + var set_WorkingProcedureCurrent = ""; + if (cur_db_info.WorkingProcedureCurrent != "OP10" && cur_db_info.WorkingProcedureCurrent != "OP40") + { + SetWorkingProcedureCurrentForOP10(cur_db_info, ref set_WorkingProcedureCurrent); + } + else + { + set_WorkingProcedureCurrent = cur_db_info.WorkingProcedureCurrent; + } + cur_db_info.WorkingProcedureCurrent = set_WorkingProcedureCurrent; + cur_db_info.WorkPieceCurrentPosition = set_WorkingProcedureCurrent + "NOOK"; + loginfo2.WorkingProcedure = set_WorkingProcedureCurrent;//瑙e喅OP10锛孫P40鍚屼竴涓殑闂 + loginfo.WorkingProcedure = set_WorkingProcedureCurrent; //瑙e喅OP10锛孫P40鍚屼竴涓殑闂 } else { - info.WorkingProcedureCurrent = loginfo.WorkingProcedure; - info.WorkPieceCurrentPosition = loginfo.WorkingProcedure + "NOOK"; + cur_db_info.WorkingProcedureCurrent = loginfo.WorkingProcedure; + cur_db_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"))) + cur_db_info.WorkPieceState = (int)WorkPieceState.NOOKPush; + cur_db_info.UpdatedUserName = loginfo.MonitoringPoint; + cur_db_info.UpdatedTime = DateTime.Now; + cur_db_info.Remarks = "宸ヤ欢NOOK鎺ㄥ嚭"; + if (!(cur_db_info.WorkingProcedureStartTime.HasValue && cur_db_info.WorkingProcedureStartTime > DateTime.Parse("1900/01/01"))) { - info.WorkingProcedureStartTime = DateTimeHelper.GetDateTime(); + cur_db_info.WorkingProcedureStartTime = DateTimeHelper.GetDateTime(); } - info.WorkingProcedureEndTime = DateTimeHelper.GetDateTime(); - info.WorkingProcedureCompleted = info.WorkingProcedureCompleted + loginfo.WorkingProcedure;//宸插畬鎴愬伐搴� - info.WorkPieceCurrentPositionOrder = info.WorkingProcedurePlan.IndexOf(loginfo.WorkingProcedure) / 2; + cur_db_info.WorkingProcedureEndTime = DateTimeHelper.GetDateTime(); + cur_db_info.WorkingProcedureCompleted = cur_db_info.WorkingProcedureCompleted + loginfo.WorkingProcedure;//宸插畬鎴愬伐搴� + cur_db_info.WorkPieceCurrentPositionOrder = cur_db_info.WorkingProcedurePlan.IndexOf(loginfo.WorkingProcedure) / 2; } QualityDataInfo qualityData = null; qualityData = db.QualityDataInfo.Where(o => o.WorkPieceID == loginfo.WorkPieceID).FirstOrDefault(); if (loginfo.WorkingProcedure.Equals("OP35")) {//涓轰簡瑙e喅OP35鐨勯噰闆嗗埌鐨勮川閲忎俊鎭槸OK杩楴OOK鐨勬儏鍐碉紝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())) + loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"OP35NOOK鍘熻川閲忎俊鎭瘂(cur_db_info.QualityState.HasValue ? cur_db_info.QualityState.Value.ToString() : "绌�")}"; + cur_db_info.QualityState = (int)QualityState.NG; + if (!cur_db_info.QualityState.Equals(((int)QualityState.OK).ToString())) { - info.QualityErrorInfo = $"{loginfo.WorkingProcedure}宸ュ簭璐ㄩ噺NOOK閲囬泦鏁版嵁涓嶅悎鏍納info.QualityState}"; + cur_db_info.QualityErrorInfo = $"{loginfo.WorkingProcedure}宸ュ簭璐ㄩ噺NOOK閲囬泦鏁版嵁涓嶅悎鏍納cur_db_info.QualityState}"; } else { - info.QualityErrorInfo = ""; + cur_db_info.QualityErrorInfo = ""; } - loginfo.QualityState = info.QualityState; + loginfo.QualityState = cur_db_info.QualityState; if (qualityData != null) @@ -967,9 +1034,9 @@ pro.UpdatedTime = DateTimeHelper.GetDateTime(); } - QualityStateHelper.SetQualityStateForNoOk(ref info, ref pro, ref qualityData); + QualityStateHelper.SetQualityStateForNoOk(ref cur_db_info, ref pro, ref qualityData); - db.WorkPieceInfoLog.Add(GetAddWorkPieceInfoLog(info)); + db.WorkPieceInfoLog.Add(GetAddWorkPieceInfoLog(cur_db_info)); } else @@ -1007,9 +1074,9 @@ //|| !((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) + WorkPieceInfo cur_db_info = new WorkPieceInfo(); + cur_db_info = db.WorkPieceInfo.Where(o => o.WorkPieceID == loginfo.WorkPieceID).FirstOrDefault(); + if (cur_db_info == null || cur_db_info.WorkPieceID.Length < 1) {//娌℃湁宸ヤ欢淇℃伅锛屼笉鍋氭洿鏂� loginfo2.Remarks = $"宸ヤ欢{loginfo.WorkPieceID} 宸ヤ欢SPC鎺ㄥ嚭宸ュ簭{loginfo.WorkingProcedure} 娌℃湁鑾峰彇鍒板伐浠朵俊鎭笉鍋氭洿鏂�"; Log4NetHelper.WriteErrorLog(type, $"宸ヤ欢{loginfo.WorkPieceID} 宸ヤ欢SPC鎺ㄥ嚭宸ュ簭{loginfo.WorkingProcedure} 娌℃湁鑾峰彇鍒板伐浠朵俊鎭笉鍋氭洿鏂�"); @@ -1019,33 +1086,44 @@ {//鏇存柊琛╓orkPieceInfo if (loginfo.WorkingProcedure.Equals("OP10")) { - info.WorkPieceCurrentPosition = info.WorkingProcedureCurrent + "SPC"; - //var WorkingProcedure = (loginfo.MonitoringPoint.Equals("OP1002") ? "OP10" : "OP40"); - loginfo2.WorkingProcedure = info.WorkingProcedureCurrent;//瑙e喅OP10锛孫P40鍚屼竴涓殑闂 - loginfo.WorkingProcedure = info.WorkingProcedureCurrent; //瑙e喅OP10锛孫P40鍚屼竴涓殑闂 + //淇 閿欒璁板綍鎴怬P05鐨勯棶棰� 銆怑ditby shaocx,2024-08-26銆� + var set_WorkingProcedureCurrent = ""; + if (cur_db_info.WorkingProcedureCurrent != "OP10" && cur_db_info.WorkingProcedureCurrent != "OP40") + { + SetWorkingProcedureCurrentForOP10(cur_db_info, ref set_WorkingProcedureCurrent); + } + else + { + set_WorkingProcedureCurrent = cur_db_info.WorkingProcedureCurrent; + } + cur_db_info.WorkingProcedureCurrent = set_WorkingProcedureCurrent; + cur_db_info.WorkPieceCurrentPosition = set_WorkingProcedureCurrent + "SPC"; + loginfo2.WorkingProcedure = set_WorkingProcedureCurrent;//瑙e喅OP10锛孫P40鍚屼竴涓殑闂 + loginfo.WorkingProcedure = set_WorkingProcedureCurrent; //瑙e喅OP10锛孫P40鍚屼竴涓殑闂 } else { - info.WorkingProcedureCurrent = loginfo.WorkingProcedure; - info.WorkPieceCurrentPosition = loginfo.WorkingProcedure + "SPC"; + cur_db_info.WorkingProcedureCurrent = loginfo.WorkingProcedure; + cur_db_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"))) + cur_db_info.WorkPieceState = (int)WorkPieceState.SPCPush; + cur_db_info.UpdatedUserName = loginfo.MonitoringPoint; + cur_db_info.UpdatedTime = DateTime.Now; + cur_db_info.WorkingProcedureEndTime = DateTimeHelper.GetDateTime(); + if (!(cur_db_info.WorkingProcedureStartTime.HasValue && cur_db_info.WorkingProcedureStartTime > DateTime.Parse("1900/01/01"))) { - info.WorkingProcedureStartTime = DateTimeHelper.GetDateTime(); + cur_db_info.WorkingProcedureStartTime = DateTimeHelper.GetDateTime(); } - info.WorkingProcedureCompleted = info.WorkingProcedureCompleted + loginfo.WorkingProcedure;//宸插畬鎴愬伐搴� - info.WorkPieceCurrentPositionOrder = info.WorkingProcedurePlan.IndexOf(loginfo.WorkingProcedure) / 2; + cur_db_info.WorkingProcedureCompleted = cur_db_info.WorkingProcedureCompleted + loginfo.WorkingProcedure;//宸插畬鎴愬伐搴� + cur_db_info.WorkPieceCurrentPositionOrder = cur_db_info.WorkingProcedurePlan.IndexOf(loginfo.WorkingProcedure) / 2; } - info.Remarks = "宸ヤ欢SPC鎶芥鎺ㄥ嚭"; + cur_db_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(); + 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(); @@ -1055,7 +1133,8 @@ } //姣忔SPC 閮芥彃鍏ヨ拷婧〃 WorkPieceProcess process = new WorkPieceProcess(); - process = EntityPropHelper.Mapper<WorkPieceProcess, WorkPieceInfo>(info); + process = EntityPropHelper.Mapper<WorkPieceProcess, WorkPieceInfo>(cur_db_info); + QualityStateHelper.ResetQualityNoOkForNewProcess(ref process); process.StartTime = DateTimeHelper.GetDateTime(); process.OperationType = OperationType.SPC.ToString(); process.QualityState = (int)QualityState.Suspected; @@ -1068,7 +1147,7 @@ db.WorkPieceProcess.Add(process); - db.WorkPieceInfoLog.Add(GetAddWorkPieceInfoLog(info)); + db.WorkPieceInfoLog.Add(GetAddWorkPieceInfoLog(cur_db_info)); } else { @@ -1088,6 +1167,37 @@ } } + + + public static void SetWorkingProcedureCurrentForOP10(WorkPieceInfo cur_db_info, ref string set_WorkingProcedureCurrent) + { + //鎴柇瀛楃涓� + if (cur_db_info.WorkingProcedureCurrent.Length == 4) + { + try + { + var bb = cur_db_info.WorkingProcedureCurrent.Substring(2, 2); + int ii = Convert.ToInt32(bb); + if (ii <= 10) + { + set_WorkingProcedureCurrent = "OP10"; + } + else + { + set_WorkingProcedureCurrent = "OP40"; + } + } + catch (Exception) + { + set_WorkingProcedureCurrent = cur_db_info.WorkingProcedureCurrent; + } + } + else + { + set_WorkingProcedureCurrent = cur_db_info.WorkingProcedureCurrent; + } + } + /// <summary> /// 宸ュ簭瀹屾垚 /// </summary> @@ -1177,6 +1287,7 @@ 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琛� @@ -1238,7 +1349,14 @@ } else { - info.WorkPieceState = (int)WorkPieceState.WIP; + //杩欓噷淇OP10銆丱P40 鍥犱负PLC鍏堟帹 SPC鎺ㄥ嚭銆佸啀鎺� 浜у搧涓嬬嚎闂锛屽鑷� 浜у搧涓嬬嚎鏇存柊鏁版嵁鏃讹紝鎶奡PC鏁版嵁瑕嗙洊鐨勯棶棰� 銆怑ditby shaocx,2024-08-27銆� + var isAlow = SystemBussinessHelper.IsAllowUpdateWorkPieceStateToWip(info, db, logMiddle); + if (isAlow) + { + 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); @@ -1250,11 +1368,14 @@ { WorkPieceProcess process = new WorkPieceProcess(); process = EntityPropHelper.Mapper<WorkPieceProcess, WorkPieceInfo>(info); + QualityStateHelper.ResetQualityNoOkForNewProcess(ref process); process.Id = Yitter.IdGenerator.YitIdHelper.NextId(); process.StartTime = DateTimeHelper.GetDateTime(); process.EndTime = DateTimeHelper.GetDateTime(); if (logMiddle.WorkingProcedure.Equals("OP80")) {//OP80鐨勮川閲忔暟鎹槸鍚庢潵鑾峰彇鏂囦欢鎼炵殑 + //璐ㄦ鏁版嵁锛屽啀鑰冭檻 鍙﹀涓ょ鐘舵�� 銆怑ditby shaocx,2024-08-27銆� + QualityStateHelper.SetQualityStateForOP80(logMiddle, ref info, ref process); } else { @@ -1280,6 +1401,11 @@ } else { + if (logMiddle.WorkingProcedure.Equals("OP80")) + {//OP80鐨勮川閲忔暟鎹槸鍚庢潵鑾峰彇鏂囦欢鎼炵殑 + //璐ㄦ鏁版嵁锛屽啀鑰冭檻 鍙﹀涓ょ鐘舵�� 銆怑ditby shaocx,2024-08-27銆� + QualityStateHelper.SetQualityStateForOP80(logMiddle, ref info, ref pro); + } if (op80id > 0) { pro.QualityDataInfoID = op80id; -- Gitblit v1.9.3