private void comboPartName_SelectedIndexChanged(object sender, EventArgs e) { try { if (comboPartName.Items.Count > 0) { if (comboPartName.SelectedItem == null) { return; } SelectedPartName = comboPartName.SelectedItem.ToString(); PopulateBoardList(); listLifetimeInfo1.Clear(); LifetimePartLimits = GCIDB.GetLifetimeLimits(SelectedPartName); LoadedLifetimeLimitID = LifetimePartLimits.LifetimeLimitID; if (LifetimePartLimits.LifetimeLimitID > 0) { LoadedPartID = GCIDB.GetPartID(SelectedPartName); ExistingSerialNumbers = GCIDB.GetSerialNumberList(SelectedPartName); } } } catch (Exception ex) { MessageBox.Show("comboPartName_SelectedIndexChanged(): " + ex.ToString()); } }
private void listParts_SelectedIndexChanged(object sender, EventArgs e) { if (PinsEdited == true || limitList1.HasEdits() == true || lifetimeLimits1.Edited == true) { // if (MessageBox.Show("There were changes made to the part.\nWould you like to save these changes to the database?", "Edits detected", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) // { SaveChanges(); //} } PinsEdited = false; limitList1.ClearAllEdits(); lifetimeLimits1.Edited = false; buttonSaveChanges.IsEnabled = false; if (listParts.Items.Count > 0) { if (listParts.SelectedItem == null) { return; } SelectedPartName = listParts.SelectedItem.ToString(); SelectedLifetimeLimitID = GCIDB.GetLifetimeLimitID(SelectedPartName); LoadedLimitData = GCIDB.GetProductionLimits(SelectedPartName); lifetimeLimits1.SetEnabled(true); if (SelectedLifetimeLimitID > 0) { LoadedLifetimeLimitData = GCIDB.GetLifetimeLimits(SelectedPartName); lifetimeLimits1.LCL = LoadedLifetimeLimitData.LowerRange; lifetimeLimits1.UCL = LoadedLifetimeLimitData.UpperRange; } else { lifetimeLimits1.LCL = Properties.Settings.Default.LifetimeLimit_DefaultLowerRange; lifetimeLimits1.UCL = Properties.Settings.Default.LifetimeLimit_DefaultUpperRange; } if (LoadedLimitData.Count > 0) { SelectedPartID = LoadedLimitData[0].PartID; SelectedProductionLimitID = LoadedLimitData[0].ProductionLimitID; } else { SelectedPartID = GCIDB.GetPartID(SelectedPartName); SelectedProductionLimitID = 0; } limitList1.ClearLimits(); foreach (LimitEntity Limit in LoadedLimitData) { limitList1.AddLimit(Limit); } buttonEditTestPins.IsEnabled = true; //buttonSaveChanges.IsEnabled = true; } }
private void generateReort_button_Click(object sender, RoutedEventArgs e) { List <String> SerialNumbers = GetSelectedSerialNumbers(); if (SerialNumbers.Count == 0) { MessageBox.Show("Please select serial numbers."); return; } DataTable dtResult = GCIDB.GetLifetimeData(SelectedPartName, SelectedBatchName, SerialNumbers); LifetimeLimitEntity Limits = GCIDB.GetLifetimeLimits(SelectedPartName); LifeTimeReportData LifetimeReport = new LifeTimeReportData(dtResult, Limits); LifetimeReport.GenerateExcelOutput(customerName_textBox.Text, PO_textBox.Text, prodDesc_textBox.Text, SelectedPartName, SelectedBatchName); //ExportToExcel.FastExportToExcel(dtResult); }
private void serialNumbers_listBox_SelectionChanged(object sender, SelectionChangedEventArgs e) { // List<string> SerialNumbers = GetSelectedSerialNumbers(); //Show that the Button is functioning //MessageBox.Show(string.Format("Pulling Legacy Report for Part ID: {0} Batch ID: {1} and Serial Number: {2}", SelectedPartName, SelectedBatchName, SelectedSerialNumbers)); GCIDB.Initialize(); GCIDB.OpenConnection(); List <String> SerialNumbers = GetSelectedSerialNumbers(); if (SerialNumbers.Count == 0) { MessageBox.Show("Please select serial numbers."); return; } DataTable dtResult = GCIDB.GetLifetimeData(SelectedPartName, SelectedBatchName, SerialNumbers); LifetimeLimitEntity Limits = GCIDB.GetLifetimeLimits(SelectedPartName); LifeTimeReportData LifetimeReport = new LifeTimeReportData(dtResult, Limits); //dt = GCIDB.GetLifetimeData(SelectedPartName, SelectedBatchName, SelectedSerialNumbers); dataGrid.DataContext = dtResult; }