public int?InsertKnotData(DataKnot currentKnotData) { using (var _connection = new SqlConnection(connectionString)) { var insertCmd = @"INSERT INTO DataKnot (CycleID ,DataStepUID ,Barcode ,Model ,AmbientSensor ,Upperfoam ,LHFoam ,RHFoam ,AdaptorCord ,Torque1 ,Angle1 ,Code1 ,Torque2 ,Angle2 ,Code2 ,Torque3 ,Angle3 ,Code3 ,Torque4 ,Angle4 ,Code4 ,Torque5 ,Angle5 ,Code5 ,Torque6 ,Angle6 ,Code6 ,TransDateTime) VALUES (@CycleID ,@DataStepUID ,@Barcode ,@Model ,@AmbientSensor ,@Upperfoam ,@LHFoam ,@RHFoam ,@AdaptorCord ,@Torque1 ,@Angle1 ,@Code1 ,@Torque2 ,@Angle2 ,@Code2 ,@Torque3 ,@Angle3 ,@Code3 ,@Torque4 ,@Angle4 ,@Code4 ,@Torque5 ,@Angle5 ,@Code5 ,@Torque6 ,@Angle6 ,@Code6 ,@TransDateTime)"; return(_connection.Execute(insertCmd, currentKnotData)); } }
private void _dependency_OnChanged(object sender, RecordChangedEventArgs <DataStep> e) { if (e.ChangeType != ChangeType.None) { switch (e.ChangeType) { case ChangeType.Insert: switch (e.Entity.StepName) { case "READY ON": Logger.Info($"Step ==> {e.Entity.StepName} # {e.Entity.CycleID}"); if (currentKnotData == null) { currentKnotData = new DataKnot { CycleID = e.Entity.CycleID, DataStepUID = e.Entity.DataStepUID, TransDateTime = DateTime.Now }; } break; case "BARCODE MODEL": Logger.Info($"Step ==> {e.Entity.StepName} # {JsonConvert.SerializeObject(e.Entity)}"); currentBarcodeModelStepUID = e.Entity.DataStepUID; if (currentKnotData == null) { currentKnotData = new DataKnot { CycleID = e.Entity.CycleID, DataStepUID = e.Entity.DataStepUID, TransDateTime = DateTime.Now }; } else { currentKnotData.CycleID = e.Entity.CycleID; currentKnotData.DataStepUID = e.Entity.DataStepUID; } currentSequence = 1; break; case "JUMP MODEL GC7": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {JsonConvert.SerializeObject(e.Entity)}"); if (currentKnotData == null) { currentKnotData = new DataKnot { CycleID = e.Entity.CycleID, TransDateTime = DateTime.Now }; } currentKnotData.Model = "MODEL GC7"; } break; case "JUMP MODEL HM7": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {JsonConvert.SerializeObject(e.Entity)}"); if (currentKnotData == null) { currentKnotData = new DataKnot { CycleID = e.Entity.CycleID, TransDateTime = DateTime.Now }; } currentKnotData.Model = "MODEL HM7"; } break; case "JUMP MODEL HN6": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {JsonConvert.SerializeObject(e.Entity)}"); if (currentKnotData == null) { currentKnotData = new DataKnot { CycleID = e.Entity.CycleID, TransDateTime = DateTime.Now }; } currentKnotData.Model = "MODEL HN6"; } break; case "IAI START PB": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {JsonConvert.SerializeObject(e.Entity)}"); isFocusKnotData = true; } break; case "AMBIENT SENSOR CONFIRMED": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {e.Entity.OutcomeType}"); if (currentKnotData == null) { currentKnotData = new DataKnot { TransDateTime = DateTime.Now }; } currentKnotData.AmbientSensor = e.Entity.OutcomeType; } break; case "ADAPATER CORD CONFIRMED": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {e.Entity.OutcomeType}"); if (currentKnotData == null) { currentKnotData = new DataKnot { TransDateTime = DateTime.Now }; } currentKnotData.AdaptorCord = e.Entity.OutcomeType; } break; case "LH FOAM JIG PUSH FWD CONFIRMED": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {e.Entity.OutcomeType}"); if (currentKnotData == null) { currentKnotData = new DataKnot { TransDateTime = DateTime.Now }; } currentKnotData.LHFoam = e.Entity.OutcomeType; } break; case "RH FOAM JIG FWD": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {e.Entity.OutcomeType}"); if (currentKnotData == null) { currentKnotData = new DataKnot { TransDateTime = DateTime.Now }; } currentKnotData.RHFoam = e.Entity.OutcomeType; } break; case "UPPER FOAM JIG FWD": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {e.Entity.OutcomeType}"); if (currentKnotData == null) { currentKnotData = new DataKnot { TransDateTime = DateTime.Now }; } currentKnotData.Upperfoam = e.Entity.OutcomeType; } break; case "END": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {JsonConvert.SerializeObject(e.Entity)}"); isFocusKnotData = false; GetStepData(); if (string.IsNullOrEmpty(currentKnotData.Barcode)) { Logger.Info($"**BARCODE NOT FOUND**"); } else { Logger.Info($"**BARCODE** {currentKnotData.Barcode}"); Logger.Info($"TOTAL TORQUE COUNT: {currentSequence - 1}"); if ((currentSequence - 1) != KNOT_COUNT) { Logger.Error($"BARCODE: {currentKnotData.Barcode} | Knot data not complete"); } //Insert data to Knot table Logger.Info($"INSERT BARCODE {currentKnotData.Barcode} # {JsonConvert.SerializeObject(currentKnotData)}"); KnotDataService.InsertKnotData(currentKnotData); } //reset seq currentKnotData = null; currentSequence = 0; currentBarcodeModelStepUID = ""; } break; default: Logger.Debug($"GotStepChange (NotFocus) : {e.Entity.StepName}"); break; } break; case ChangeType.Update: switch (e.Entity.StepName) { case "AMBIENT SENSOR CONFIRMED": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {e.Entity.OutcomeType}"); if (currentKnotData == null) { currentKnotData = new DataKnot { TransDateTime = DateTime.Now }; } currentKnotData.AmbientSensor = e.Entity.OutcomeType; } break; case "ADAPATER CORD CONFIRMED": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {e.Entity.OutcomeType}"); if (currentKnotData == null) { currentKnotData = new DataKnot { TransDateTime = DateTime.Now }; } currentKnotData.AdaptorCord = e.Entity.OutcomeType; } break; case "LH FOAM JIG PUSH FWD CONFIRMED": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {e.Entity.OutcomeType}"); if (currentKnotData == null) { currentKnotData = new DataKnot { TransDateTime = DateTime.Now }; } currentKnotData.LHFoam = e.Entity.OutcomeType; } break; case "RH FOAM JIG FWD": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {e.Entity.OutcomeType}"); if (currentKnotData == null) { currentKnotData = new DataKnot { TransDateTime = DateTime.Now }; } currentKnotData.RHFoam = e.Entity.OutcomeType; } break; case "UPPER FOAM JIG FWD": if (e.Entity.CycleID == currentKnotData.CycleID) { Logger.Info($"Step ==> {e.Entity.StepName} # {e.Entity.OutcomeType}"); if (currentKnotData == null) { currentKnotData = new DataKnot { TransDateTime = DateTime.Now }; } currentKnotData.Upperfoam = e.Entity.OutcomeType; } break; default: break; } break; } } }