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;
}
}
}
}
}
