private void SearchColumnData()
{
for (int j = 1; j < 10; j++)
{
ValueMax = Convert.ToDouble(BG_测厚数据表.Rows[5].Cells[j].Value);
ValueMin = Convert.ToDouble(BG_测厚数据表.Rows[5].Cells[j].Value);
ValueAVG = 0;
for (int i = 5; i < BG_测厚数据表.Rows.Count - 1; i++)
{
if (ValueMax < Convert.ToDouble(BG_测厚数据表.Rows[i].Cells[j].Value))
{
ValueMax = Convert.ToDouble(BG_测厚数据表.Rows[i].Cells[j].Value);
}
if (ValueMin > Convert.ToDouble(BG_测厚数据表.Rows[i].Cells[j].Value))
{
ValueMin = Convert.ToDouble(BG_测厚数据表.Rows[i].Cells[j].Value);
}
ValueAVG += Convert.ToDouble(BG_测厚数据表.Rows[i].Cells[j].Value);
}
BG_测厚数据表.Rows[0].Cells[j].Value = ValueMax;
BG_测厚数据表.Rows[1].Cells[j].Value = ValueMin;
BG_测厚数据表.Rows[2].Cells[j].Value = (ValueAVG / (BG_测厚数据表.Rows.Count - 6)).ToString("F3");
}
}
private void SearchRowData()
{
for (int i = 0; i < BG_测厚数据表.Rows.Count - 1; i++)
{
if (i != 3 && i != 4)
{
ValueAVG = 0;
for (int j = 1; j < BG_测厚数据表.ColumnCount - 1; j++)
{
ValueAVG += Convert.ToDouble(BG_测厚数据表.Rows[i].Cells[j].Value);
BG_测厚数据表.Rows[i].Cells[10].Value = (ValueAVG / 9).ToString("F3");
}
}
else
{
i++;
}
}
}