private void btnReport_Click(object sender, EventArgs e)
{
if (dtData.DefaultView.Count == 0)
{
return;
}
ExcelUnLoad rep = new ExcelUnLoad();
int crow = 1;
int maxCol = 4;
rep.SetColumnWidth(1, 1, 1, 1, 10);
rep.SetColumnWidth(2, 2, 2, 2, 15);
rep.SetColumnWidth(3, 3, 3, 3, 40);
rep.SetColumnWidth(4, 4, 4, 4, 20);
rep.AddSingleValue("Отчет о загрузке картинок", crow, 1);
rep.Merge(crow, 1, crow, maxCol);
rep.SetCellAlignmentToCenter(crow, 1, crow, maxCol);
rep.SetCellAlignmentToJustify(crow, 1, crow, maxCol);
rep.SetFontBold(crow, 1, crow, 1);
crow += 2;
rep.AddFilter("EAN", tbEan, ref crow);
rep.AddFilter("Наименование", tbName, ref crow);
rep.AddFilter("Артикул", tbIdTovar, ref crow);
rep.AddFilter("Выбран вариант", chbIsNotFount, ref crow);
rep.AddFilter("Выбран вариант", chbIsUpdated, ref crow);
rep.AddFilter("Выбран вариант", chbNoImage, ref crow);
crow++;
int startRow = crow;
int col = 1;
foreach (DataGridViewColumn dc in dgvData.Columns)
{
rep.AddSingleValue(dc.HeaderText, crow, col);
rep.SetFontBold(crow, col, crow, col);
rep.SetCellAlignmentToCenter(crow, col, crow, col);
rep.SetCellAlignmentToJustify(crow, col, crow, col);
rep.SetWrapText(crow, col, crow, col);
col++;
}
foreach (DataRowView row in dtData.DefaultView)
{
crow++;
col = 1;
foreach (DataGridViewColumn dc in dgvData.Columns)
{
rep.AddSingleValue(row[dc.DataPropertyName].ToString(), crow, col);
rep.SetWrapText(crow, col, crow, col);
Color color = Color.White;
if (row["result"].ToString() == "Обновлено")
{
color = panel1.BackColor;
}
else if (row["result"].ToString() == "Картинка не найдена")
{
color = panel2.BackColor;
}
else if (row["result"].ToString() == "Товар не найден")
{
color = panel3.BackColor;
}
rep.SetCellColor(crow, col, crow, col, color);
col++;
}
}
rep.SetBorders(startRow, 1, crow, maxCol);
rep.Show();
}
