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; } }
public LifeTimeReportData(DataTable dtInput, LifetimeLimitEntity LimitData) { this.LimitData = LimitData; RawData = dtInput; AllSerialNumbers = new List <string>(); AllTestHours = new List <int>(); AllTestPins = new List <byte>(); ParsedData = new Dictionary <string, Dictionary <int, LifeTimeReportHourData> >(); GetUniqueSerialNumbers(); GetUniqueTestHours(); PopulateData(); }
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; }
public static LifetimeLimitEntity GetLifetimeLimits(string PartName) { LifetimeLimitEntity Results = new LifetimeLimitEntity(); int PartID = GetPartID(PartName); if (PartID != 0) { int LifetimeLimitID = GetLifetimeLimitID(PartName); if (LifetimeLimitID != 0) { string query = @"SELECT LowerRange, UpperRange FROM GCI.LifetimeLimit WHERE LifetimeLimitID = " + LifetimeLimitID.ToString(); if (OpenConnection() == true) { //Create Command MySqlCommand cmd = new MySqlCommand(query, connection); //Create a data reader and Execute the command MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list while (dataReader.Read()) { double LowerRange = Convert.ToDouble(dataReader["LowerRange"]); double UpperRange = Convert.ToDouble(dataReader["UpperRange"]); Results = new LifetimeLimitEntity(LifetimeLimitID, UpperRange, LowerRange); } dataReader.Close(); //close Connection CloseConnection(); } } } return(Results); }