public void displayLimits(DataGridViewCellMouseEventArgs e) //wyswietla limity po rightclicku na header kolumny { if (e.Button == MouseButtons.Right) { if (dataTable.Columns[e.ColumnIndex] is ExtendedColumn) { ExtendedColumn extCol = (ExtendedColumn)dataTable.Columns[e.ColumnIndex]; MessageBox.Show(extCol.giveLimits()); } } }
public ChartForm(List <Report> reportes, DataGridView datagrid, DataGridViewCellMouseEventArgs de, DataTable datatable) { this.reports = reportes; this.dataGridView = datagrid; this.dataTable = datatable; this.measurements = new List <double>(); this.dates = new List <DateTime>(); this.datesMeasures = new List <DateMeasurement>(); this.columnIndex = de.ColumnIndex; columnName = dataGridView.Columns[columnIndex].HeaderText.ToString(); columnIndex = de.ColumnIndex; InitializeComponent(); for (int i = 0; i < (dataGridView.Rows.Count - 1); i++) { if (dataGridView.Rows[i].Cells[columnIndex] != null) { double g = 0; DateTime dt = DateTime.Now; try { g = Double.Parse(datagrid.Rows[i].Cells[columnIndex].Value.ToString()); dt = reports[i].DateTime; datesMeasures.Add(new DateMeasurement(dt, g)); // dt = reports[i].DateTime; // dates.Add(dt); } catch (Exception e) { // MessageBox.Show("1: " + i + " " + e.ToString()); } } } foreach (DateMeasurement dm in datesMeasures) //tworzy posortowane listy pomiarów i dat { measurements.Add(dm.measurement); dates.Add(dm.date); } if (dataTable.Columns[columnIndex] is ExtendedColumn) //pobiera limity dolny i górny { ExtendedColumn eC = (ExtendedColumn)dataTable.Columns[columnIndex]; upperLimit = eC.Highlimit; lowerLimit = eC.Lowlimit; } CreateChart(); }
public void createGrid(string TextFromReport) { dataTable.Columns.Add("Serial number"); dataTable.Columns.Add("UUTResult"); dataTable.Columns.Add("Date"); dataTable.Columns.Add("Time"); foreach (string measure in handleInputs.FieldsToRead) { try { int index = TextFromReport.IndexOf(measure); int indexend = TextFromReport.IndexOf("Module Time:", index); string substr = TextFromReport.Substring(index, (indexend - index)); if (substr.Contains("Measurement[0]")) { for (int x = 0; ; x++) { if (TextFromReport.Substring(index, (indexend - index)).Contains("Measurement[" + x.ToString() + "]")) { ExtendedColumn extendedColumn = new ExtendedColumn(measure + " Measurement[" + x.ToString() + "]"); extendedColumn.findLimitsMulti(index, x, TextFromReport); dataTable.Columns.Add(extendedColumn); } else { break; } } } else { ExtendedColumn extendedColumn = new ExtendedColumn(measure); extendedColumn.findLimits(index, TextFromReport); dataTable.Columns.Add(extendedColumn); } } catch { //tutaj dasz w komórce tabeli wartość null } } }
public void checkIfCellsPassed() { for (int j = 0; j < dataTable.Rows.Count; j++) { for (int i = 0; i < dataTable.Columns.Count; i++) { if (dataTable.Columns[i] is ExtendedColumn) { ExtendedColumn extCol = (ExtendedColumn)dataTable.Columns[i]; if (extCol.checkLimits((mainForm.dataGridView1.Rows[j].Cells[i]))) { mainForm.dataGridView1.Rows[j].Cells[i].Style.BackColor = Color.Green; } else { mainForm.dataGridView1.Rows[j].Cells[i].Style.BackColor = Color.Red; } } } } }