using Aitex.Core.Common; using Aitex.Core.Common.DeviceData; using Aitex.Core.RT.DataCenter; using Aitex.Core.RT.Event; using Aitex.Core.RT.IOCore; using Aitex.Core.RT.Log; using Aitex.Core.RT.OperationCenter; using Aitex.Core.RT.Routine; using Aitex.Core.RT.SCCore; using Aitex.Core.UI.Control; using Aitex.Core.Util; using DocumentFormat.OpenXml.VariantTypes; using FurnaceRT.Equipments.Systems; using MECF.Framework.Common.CommonData.EnumData; using MECF.Framework.Common.DataCenter; using MECF.Framework.Common.DBCore; using MECF.Framework.Common.Equipment; using MECF.Framework.Common.Event; using MECF.Framework.Common.OperationCenter; using MECF.Framework.Common.Utilities; using MECF.Framework.RT.EquipmentLibrary.HardwareUnits.PMs; using MECF.Framework.RT.EquipmentLibrary.HardwareUnits.Robot; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Diagnostics; using System.Linq; using System.Runtime.Remoting.Metadata.W3cXsd2001; namespace FurnaceRT.Equipments.PMs { public partial class PMModule { private List _dbRecords { get; set; } = new List(); public void GetAllDBRecord() { _dbRecords.Clear(); DataTable dt = DataQuery.Query("select * from \"schedule_maintenance\""); for (int i = 0; i < dt.Rows.Count; i++) { ScheduleMaintenanceDataItem item = new ScheduleMaintenanceDataItem(); item.Item = dt.Rows[i]["maintenance_item"].ToString(); item.Display = dt.Rows[i]["maintenance_display"].ToString(); item.Unit = dt.Rows[i]["unit"].ToString(); item.MaintenanceProcessing = dt.Rows[i]["maintenance_processing"].ToString(); item.Path = dt.Rows[i]["path"].ToString(); item.AdditionInformationName = dt.Rows[i]["addition_information_name"].ToString(); item.AdditionInformationDisplay = dt.Rows[i]["addition_information_display"].ToString(); item.AdditionInformationDisplaySupplement = dt.Rows[i]["addition_information_display_supplement"].ToString(); item.AssociationProcessRecipeName = dt.Rows[i]["association_process_recipeName"].ToString(); if (float.TryParse(dt.Rows[i]["current_value"].ToString(), out float value)) item.CurrentValue = value; if (float.TryParse(dt.Rows[i]["scheduling_start_value"].ToString(), out value)) item.StartValue = value; if (float.TryParse(dt.Rows[i]["maintenance_limit_value"].ToString(), out value)) item.LimitValue = value; _dbRecords.Add(item); } } private void InitScheduleMaintenance() { new ScheduleMaintenanceData(MaintenanceItemEnum.SDCarrierUseFreq.ToString(), "Times", "CarrierWafer.SieDummy", "Carrier Kind", "Side Dummy"); new ScheduleMaintenanceData(MaintenanceItemEnum.SDWaferThickness.ToString(), "Å", "CarrierWafer.SieDummy", "Carrier Kind", "Side Dummy"); new ScheduleMaintenanceData(MaintenanceItemEnum.SDUsableDummyWafer.ToString(), "Sheets", "CarrierWafer.SieDummy", "Carrier Kind", "Side Dummy"); new ScheduleMaintenanceData(MaintenanceItemEnum.SDBufferRackStayTime.ToString(), "h:m:s", "CarrierWafer.SieDummy", "Carrier Kind", "Side Dummy"); new ScheduleMaintenanceData(MaintenanceItemEnum.SDWaferUserTime.ToString(), "h:m:s", "CarrierWafer.SieDummy", "Carrier Kind", "Side Dummy"); new ScheduleMaintenanceData(MaintenanceItemEnum.FDCarrierUseFreq.ToString(), "Times", "CarrierWafer.FillDummy", "Carrier Kind", "Fill Dummy"); new ScheduleMaintenanceData(MaintenanceItemEnum.FDWaferThickness.ToString(), "Å", "CarrierWafer.FillDummy", "Carrier Kind", "Fill Dummy"); new ScheduleMaintenanceData(MaintenanceItemEnum.FDUsableDummyWafer.ToString(), "Sheets", "CarrierWafer.FillDummy", "Carrier Kind", "Fill Dummy"); new ScheduleMaintenanceData(MaintenanceItemEnum.FDBufferRackStayTime.ToString(), "h:m:s", "CarrierWafer.FillDummy", "Carrier Kind", "Fill Dummy"); new ScheduleMaintenanceData(MaintenanceItemEnum.FDWaferUserTime.ToString(), "h:m:s", "CarrierWafer.FillDummy", "Carrier Kind", "Fill Dummy"); new ScheduleMaintenanceData(MaintenanceItemEnum.BoatRecipeThickness1.ToString(), "Å", "Boat"); new ScheduleMaintenanceData(MaintenanceItemEnum.BoatTCUseTime.ToString(), "h:m:s", "Boat"); new ScheduleMaintenanceData(MaintenanceItemEnum.BoatCKDUseTime.ToString(), "h:m:s", "Boat"); new ScheduleMaintenanceData(MaintenanceItemEnum.BoatPUMPUseTime.ToString(), "h:m:s", "Boat"); new ScheduleMaintenanceData(MaintenanceItemEnum.NonOperationTime1.ToString(), "h:m:s", "Conditioning"); new ScheduleMaintenanceData(MaintenanceItemEnum.NonOperationTime2.ToString(), "h:m:s", "Conditioning"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeExecuteFreq.ToString(), "Times", "Reactor.Recipe", "Select Recipe"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeThickness.ToString(), "Å", "Reactor.Recipe", "Select Recipe"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeStepExecuteFreq1.ToString(), "Times", "Reactor.StepRunFreq", "Step ID"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeStepExecuteFreq2.ToString(), "Times", "Reactor.StepRunFreq", "Step ID"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeStepExecuteFreq3.ToString(), "Times", "Reactor.StepRunFreq", "Step ID"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeStepExecuteTime1.ToString(), "h:m:s", "Reactor.StepRunTime", "Step ID"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeStepExecuteTime2.ToString(), "h:m:s", "Reactor.StepRunTime", "Step ID"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeStepExecuteTime3.ToString(), "h:m:s", "Reactor.StepRunTime", "Step ID"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeStepExecuteTime4.ToString(), "h:m:s", "Reactor.StepRunTime", "Step ID"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeStepExecuteTime5.ToString(), "h:m:s", "Reactor.StepRunTime", "Step ID"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeStepExecuteTime6.ToString(), "h:m:s", "Reactor.StepRunTime", "Step ID"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeStepExecuteTime7.ToString(), "h:m:s", "Reactor.StepRunTime", "Step ID"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeStepExecuteTime8.ToString(), "h:m:s", "Reactor.StepRunTime", "Step ID"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeThickness1_Step.ToString(), "Å", "Reactor.StepThickness", "Step Group"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeThickness2_Step.ToString(), "Å", "Reactor.StepThickness", "Step Group"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeThickness3_Step.ToString(), "Å", "Reactor.StepThickness", "Step Group"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeThickness4_Step.ToString(), "Å", "Reactor.StepThickness", "Step Group"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeThickness5_Step.ToString(), "Å", "Reactor.StepThickness", "Step Group"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeThickness6_Step.ToString(), "Å", "Reactor.StepThickness", "Step Group"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeThickness7_Step.ToString(), "Å", "Reactor.StepThickness", "Step Group"); new ScheduleMaintenanceData(MaintenanceItemEnum.RecipeThickness8_Step.ToString(), "Å", "Reactor.StepThickness", "Step Group"); } public void MaintenanceProcessingCommandExec(string maintenanceProcessing, AlarmReportItem alarmReportItem) { if (Enum.TryParse(maintenanceProcessing, out var command)) { switch (command) { case MaintenanceProcessingCommandEnum.None: break; case MaintenanceProcessingCommandEnum.AlarmReport: alarmReportItem?.Exec(); break; case MaintenanceProcessingCommandEnum.JobAutoStart: break; case MaintenanceProcessingCommandEnum.JobProhibition: break; case MaintenanceProcessingCommandEnum.JobManualStart: break; } } } #region Carrier/Wafer public void UpdateSEDWafer() { var ccc = BinarySerializer>>.FromStream("WaferManager"); if (ccc == null) return; List waferInfos = new List(); foreach (var moduleWafers in ccc) { waferInfos.AddRange(moduleWafers.Value.Select(a => a.Value)); } if (waferInfos.Any(a => a.WaferType == WaferType.ED)) { var maxEDUseCount = waferInfos.Where(a => a.WaferType == WaferType.ED).Max(a => a.UseCount); var maxEDUseThick = waferInfos.Where(a => a.WaferType == WaferType.ED).Max(a => a.UseThick); var maxEDUseTime = waferInfos.Where(a => a.WaferType == WaferType.ED).Max(a => a.UseTime); if (Singleton.Instance.Item.TryGetValue(MaintenanceItemEnum.FDCarrierUseFreq.ToString(), out var FDCarrierUseFreq)) Singleton.Instance.SetValue(FDCarrierUseFreq.Item, maxEDUseCount); if (Singleton.Instance.Item.TryGetValue(MaintenanceItemEnum.FDWaferThickness.ToString(), out var FDWaferThickness)) Singleton.Instance.SetValue(FDWaferThickness.Item, maxEDUseThick); if (Singleton.Instance.Item.TryGetValue(MaintenanceItemEnum.FDWaferUserTime.ToString(), out var FDWaferUserTime)) Singleton.Instance.SetValue(FDWaferUserTime.Item, maxEDUseTime); } if (waferInfos.Any(a => a.WaferType == WaferType.SD)) { var maxSDUseCount = waferInfos.Where(a => a.WaferType == WaferType.SD).Max(a => a.UseCount); var maxSDUseThick = waferInfos.Where(a => a.WaferType == WaferType.SD).Max(a => a.UseThick); var maxSDUseTime = waferInfos.Where(a => a.WaferType == WaferType.SD).Max(a => a.UseTime); if (Singleton.Instance.Item.TryGetValue(MaintenanceItemEnum.SDCarrierUseFreq.ToString(), out var SDCarrierUseFreq)) Singleton.Instance.SetValue(SDCarrierUseFreq.Item, maxSDUseCount); if (Singleton.Instance.Item.TryGetValue(MaintenanceItemEnum.SDWaferThickness.ToString(), out var SDWaferThickness)) Singleton.Instance.SetValue(SDWaferThickness.Item, maxSDUseThick); if (Singleton.Instance.Item.TryGetValue(MaintenanceItemEnum.SDWaferUserTime.ToString(), out var SDWaferUserTime)) Singleton.Instance.SetValue(SDWaferUserTime.Item, maxSDUseTime); } } #endregion /// /// 根据RecipeStep +StepGroup统计 累计膜厚 /// /// public void UpdateRecipeStepGroupThickness(string stepName, float thickness) { if (string.IsNullOrEmpty(stepName) || thickness <= 0) return; var stepNo = stepName.Split(':').FirstOrDefault(); var list = _dbRecords .Where(a => !string.IsNullOrEmpty(a.AdditionInformationDisplaySupplement)) .Where(a => a.Path == $"{DataItemEnum.Reactor}.{ReactorsEnum.StepThickness}") .Where(a => a.AdditionInformationDisplaySupplement.Split(',').Contains(stepNo)) .ToList(); if (list == null || list.Count == 0) return; foreach (var item in list) { if (item == null) continue; Singleton.Instance.Increase(item.Item, thickness); } } /// /// 根据RecipeStep统计 Step执行Time 累计时间 /// /// public void UpdateRecipeStepRunTime(string stepName, double stepTime) { if (string.IsNullOrEmpty(stepName) || stepTime <= 0) return; var stepNo = stepName.Split(':').FirstOrDefault(); var list = _dbRecords.Where(a => a.Path == $"{DataItemEnum.Reactor}.{ReactorsEnum.StepRunTime}" && a.AdditionInformationDisplay == stepNo).ToList(); if (list == null || list.Count == 0) return; foreach (var item in list) { if (item == null) continue; var data = Math.Round(stepTime, 1, MidpointRounding.AwayFromZero); Singleton.Instance.Increase(item.Item, (float)data); } } /// /// 根据RecipeStep统计 Step执行 累计次数 /// /// public void UpdateRecipeStepFre(string stepName) { if (string.IsNullOrEmpty(stepName)) return; var stepNo = stepName.Split(':').FirstOrDefault(); var list = _dbRecords.Where(a => a.Path == $"{DataItemEnum.Reactor}.{ReactorsEnum.StepRunFreq}" && a.AdditionInformationDisplay == stepNo).ToList(); if (list == null || list.Count == 0) return; foreach (var item in list) { if (item == null) continue; Singleton.Instance.Increase(item.Item); } } /// /// 根据RecipeName统计 Recipe执行 累计次数 /// /// public void UpdateRecipeFre(string recipeName) { if (string.IsNullOrEmpty(recipeName)) return; var item = _dbRecords .FirstOrDefault(a => a.Item == MaintenanceItemEnum.RecipeExecuteFreq.ToString() && a.Path == $"{DataItemEnum.Reactor}.{ReactorsEnum.Recipe}" && a.AdditionInformationDisplay == recipeName); if (item == null) return; if (item != null && item.Item == MaintenanceItemEnum.RecipeExecuteFreq.ToString()) Singleton.Instance.Increase(item.Item); } /// /// 根据RecipeName统计累计膜厚 /// /// /// public void UpdateRecipeThickness(string recipeName, float thickness) { if (string.IsNullOrEmpty(recipeName) || thickness <= 0) return; var item = _dbRecords .FirstOrDefault(a => a.Item == MaintenanceItemEnum.RecipeThickness.ToString() && a.Path == $"{DataItemEnum.Reactor}.{ReactorsEnum.Recipe}" && a.AdditionInformationDisplay == recipeName); if (item == null) return; if (item != null && item.Item == MaintenanceItemEnum.RecipeThickness.ToString()) Singleton.Instance.Increase(item.Item, thickness); } /// /// 检查 /// /// /// public void CheckRecipeStepGroupThicknessMoreThan(string stepName, out bool isPause) { isPause = false; if (string.IsNullOrEmpty(stepName)) return; var stepNo = stepName.Split(':').FirstOrDefault(); var reactorStepThicknessList = _dbRecords .Where(a => a.Path == $"{DataItemEnum.Reactor}.{ReactorsEnum.StepThickness}") .Where(a => !string.IsNullOrEmpty(a.AdditionInformationDisplay)) .Where(a => !string.IsNullOrEmpty(a.AdditionInformationDisplaySupplement)) .Where(a => a.AdditionInformationDisplaySupplement.Split(',').Contains(stepNo)) .ToList(); foreach (var item in reactorStepThicknessList) { if (!Enum.TryParse(item.MaintenanceProcessing, out var command)) continue; if (item.StartValue < 0 || item.LimitValue <= item.StartValue || command == MaintenanceProcessingCommandEnum.None) continue; string message = $"{item.Item}-{item.Display} {item.AdditionInformationDisplay} {item.CurrentValue} limit is ({item.StartValue}~{item.LimitValue}) times"; string nullMessage = $"{item.Display} No recipe file associated, unable to trigger JobAutoStart"; bool isWarning = item.CurrentValue > item.StartValue && item.CurrentValue < item.LimitValue; bool isAlarm = item.CurrentValue >= item.LimitValue; if (isWarning) { Singleton.Instance.ReatorStepThicknessWarning.Set(message); } if (isAlarm) { Singleton.Instance.ReatorStepThicknessAlarm.Set(message); if (command == MaintenanceProcessingCommandEnum.JobManualStart) { Singleton.Instance.ReatorStepThicknessAlarm.Set(message); if (string.IsNullOrEmpty(item.AssociationProcessRecipeName)) { Singleton.Instance.ReatorStepThicknessAlarm.Set(nullMessage); } else { LOG.Info($"{message} Trigger {item.AssociationProcessRecipeName}"); CheckToPostMessage((int)MSG.RunOtherRecipe, item.AssociationProcessRecipeName, "Process"); } } isPause = true; return; } } } /// /// 检查 RecipeStep 累计时间是否超限 /// /// /// public void CheckRecipeStepTimeMoreThan(string stepName, out bool isPause) { isPause = false; if (string.IsNullOrEmpty(stepName)) return; var stepNo = stepName.Split(':').FirstOrDefault(); var item = _dbRecords.FirstOrDefault(a => a.Path == $"{DataItemEnum.Reactor}.{ReactorsEnum.StepRunTime}" && a.AdditionInformationDisplay == stepNo); if (item == null || !Enum.TryParse(item.MaintenanceProcessing, out var command)) return; if (item.StartValue < 0 || item.LimitValue <= item.StartValue || command == MaintenanceProcessingCommandEnum.None) return; string message = $"{item.Item}-{item.Display} {item.AdditionInformationDisplay} {item.CurrentValue} limit is ({item.StartValue}~{item.LimitValue}) times"; bool isWarning = item.CurrentValue > item.StartValue && item.CurrentValue < item.LimitValue; bool isAlarm = item.CurrentValue >= item.LimitValue; if (isWarning) Singleton.Instance.ReatorStepRunTimeWarning.Set(message); if (isAlarm) { Singleton.Instance.ReatorStepRunTimeAlarm.Set(message); isPause = true; } } /// /// RecipeStep 累计次数是否超限 /// /// /// public void CheckRecipeStepFreqMoreThan(string stepName, out bool isPause) { isPause = false; if (string.IsNullOrEmpty(stepName)) return; var stepNo = stepName.Split(':').FirstOrDefault(); var item = _dbRecords.FirstOrDefault(a => a.Path == $"{DataItemEnum.Reactor}.{ReactorsEnum.StepRunFreq}" && a.AdditionInformationDisplay == stepNo); if (item == null || !Enum.TryParse(item.MaintenanceProcessing, out var command)) return; if (item.StartValue < 0 || item.LimitValue <= item.StartValue || command == MaintenanceProcessingCommandEnum.None) return; string message = $"{item.Item}-{item.Display} {item.AdditionInformationDisplay} {item.CurrentValue} limit is ({item.StartValue}~{item.LimitValue}) times"; bool isWarning = item.CurrentValue > item.StartValue && item.CurrentValue < item.LimitValue; bool isAlarm = item.CurrentValue >= item.LimitValue; if (isWarning) Singleton.Instance.ReatorStepRunFreqWarning.Set(message); if (isAlarm) { Singleton.Instance.ReatorStepRunFreqAlarm.Set(message); isPause = true; } } /// /// 检查Recipe执行 累计次数是否超限 /// /// /// public void CheckRecipeExecuteFreqMoreThan(string recipeName, out bool isPause) { isPause = false; if (string.IsNullOrEmpty(recipeName)) return; var item = _dbRecords .FirstOrDefault(a => a.Item == MaintenanceItemEnum.RecipeExecuteFreq.ToString() && a.Path == $"{DataItemEnum.Reactor}.{ReactorsEnum.Recipe}" && a.AdditionInformationDisplay == recipeName); if (item == null || !Enum.TryParse(item.MaintenanceProcessing, out var command)) return; if (item.StartValue < 0 || item.LimitValue <= item.StartValue || command == MaintenanceProcessingCommandEnum.None) return; string message = $"{item.Item}-{item.Display} {item.AdditionInformationDisplay} {item.CurrentValue} limit is ({item.StartValue}~{item.LimitValue}) times"; bool isWarning = item.CurrentValue > item.StartValue && item.CurrentValue < item.LimitValue; bool isAlarm = item.CurrentValue >= item.LimitValue; if (isWarning) { Singleton.Instance.RecipeExecuteFreqWarning.Set(message); } if (isAlarm) { Singleton.Instance.RecipeExecuteFreqWarning.Set(message); if (command == MaintenanceProcessingCommandEnum.JobAutoStart) { if (string.IsNullOrEmpty(item.AssociationProcessRecipeName)) { Singleton.Instance.RecipeExecuteFreqAlarm.Set(message); } else { LOG.Info($"{message} Trigger {item.AssociationProcessRecipeName}"); CheckToPostMessage((int)MSG.RunOtherRecipe, item.AssociationProcessRecipeName, "Process"); } } isPause = true; return; } } /// /// 检查Recipe执行 累计膜厚是否超限 /// /// /// public void CheckRecipeThicknessMoreThan(string recipeName, out bool isPause) { isPause = false; if (string.IsNullOrEmpty(recipeName)) return; var item = _dbRecords.FirstOrDefault(a => a.Item == MaintenanceItemEnum.RecipeThickness.ToString() && a.Path == $"{DataItemEnum.Reactor}.{ReactorsEnum.Recipe}" && a.AdditionInformationDisplay == recipeName); if (item == null || !Enum.TryParse(item.MaintenanceProcessing, out var command)) return; if (item.StartValue < 0 || item.LimitValue <= item.StartValue || command == MaintenanceProcessingCommandEnum.None) return; string message = $"{item.Item}-{item.Display} {item.AdditionInformationDisplay} {item.CurrentValue} limit is ({item.StartValue}~{item.LimitValue}) Å"; bool isWarning = item.CurrentValue > item.StartValue && item.CurrentValue < item.LimitValue; bool isAlarm = item.CurrentValue >= item.LimitValue; if (isWarning) { Singleton.Instance.RecipeThicknessWarning.Set(message); } if (isAlarm) { Singleton.Instance.RecipeThicknessAlarm.Set(message); if (command == MaintenanceProcessingCommandEnum.JobAutoStart) { if (string.IsNullOrEmpty(item.AssociationProcessRecipeName)) { Singleton.Instance.RecipeThicknessAlarm.Set(message); } else { LOG.Info($"{message} Trigger {item.AssociationProcessRecipeName}"); CheckToPostMessage((int)MSG.RunOtherRecipe, item.AssociationProcessRecipeName, "Process"); } } isPause = true; return; } } } }