private void dataGridView1_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e)
{
if (dataGridView1.Columns.Count < 8)
{
DataGridViewImageButtonSaveColumn columnImage =
new DataGridViewImageButtonSaveColumn();
columnImage.Name = "Zdjecia";
columnImage.HeaderText = "";
dataGridView1.Columns.Add(columnImage);
}
foreach (DataGridViewRow row in dataGridView1.Rows)
{
string lot = row.Cells["LOT"].Value.ToString();
List <FileInfo> imgList = new List <FileInfo>();
if (!imagesPerLot.TryGetValue(lot, out imgList))
{
continue;
}
((DataGridViewImageButtonSaveCell)(row.Cells["Zdjecia"])).Enabled = true;
((DataGridViewImageButtonSaveCell)(row.Cells["Zdjecia"])).ButtonState = PushButtonState.Normal;
row.Cells["Zdjecia"].Tag = imgList;
//DataGridViewButtonCell butCell = new DataGridViewButtonCell();
//butCell.Tag = imgList;
//butCell.Style.BackColor = Color.Lime;
//row.Cells["Zdjecia"] = butCell;
//row.Cells["Zdjecia"].Value = "ZDJĘCIA";
}
}
public static void FillOutGrid(DataGridView grid, DataTable table, bool attachImages)
{
grid.Columns.Clear();
grid.Columns.Add("Nazwa", "Nazwa");
for (int r = 0; r < table.Rows.Count; r++)
{
grid.Columns.Add("Wartosc" + r, "Wartosc" + r);
for (int c = 0; c < table.Columns.Count; c++)
{
grid.Rows.Add(table.Columns[c].ColumnName, table.Rows[r][c]);
}
if (attachImages)
{
DataGridViewImageButtonSaveColumn columnImage = new DataGridViewImageButtonSaveColumn();
columnImage.Name = "Images";
columnImage.HeaderText = "";
grid.Columns.Add(columnImage);
string date = table.Rows[r]["Data_czas"].ToString().Substring(0, 10).Replace(".", "-");
string lot = table.Rows[r]["numerZlecenia"].ToString();
var fileImgList = VIOperations.TryGetFileInfoOfImagesForLot(lot, date);
if (fileImgList.Count > 0)
{
foreach (DataGridViewRow row in grid.Rows)
{
string rowFailureName = row.Cells[0].Value.ToString();
List <System.IO.FileInfo> tagList = new List <System.IO.FileInfo>();
foreach (var img in fileImgList)
{
string failureName = img.Name.Split('_')[1];
if (failureName == rowFailureName)
{
tagList.Add(img);
}
}
if (tagList.Count > 0)
{
((DataGridViewImageButtonSaveCell)(row.Cells[r + 2])).Enabled = true;
((DataGridViewImageButtonSaveCell)(row.Cells[r + 2])).ButtonState = PushButtonState.Normal;
row.Cells[r + 2].Tag = tagList;
}
}
}
}
}
SMTOperations.autoSizeGridColumns(grid);
}
public void init()
{
getData();
DataGridViewImageButtonSaveColumn columnSave = new DataGridViewImageButtonSaveColumn();
dataGridView1.Columns.Add(columnSave);
DataGridViewImageButtonDeleteColumn columnDelete = new DataGridViewImageButtonDeleteColumn();
dataGridView1.Columns.Add(columnDelete);
DataGridViewButtonColumn c = (DataGridViewButtonColumn)dataGridView1.Columns[4];
c.DefaultCellStyle.ForeColor = Color.Navy;
c.DefaultCellStyle.BackColor = Color.Green;
DataGridViewButtonColumn c2 = (DataGridViewButtonColumn)dataGridView1.Columns[5];
c2.DefaultCellStyle.ForeColor = Color.Navy;
c2.DefaultCellStyle.BackColor = Color.Red;
dataGridView1.Columns[4].HeaderText = "Sửa";
dataGridView1.Columns[5].HeaderText = "Xóa";
}
public static void FillOutGridLatestLots(DataGridView grid, List <WasteDataStructure> inspectionData)
{
if (!System.IO.Directory.Exists(@"P:\"))
{
Network.ConnectPDrive();
}
grid.Columns.Clear();
grid.Columns.Add("Data", "Data");
grid.Columns.Add("Model", "Model");
grid.Columns.Add("Lot", "Lot");
grid.Columns.Add("Operator", "Operator");
grid.Columns.Add("Linia", "Linia");
grid.Columns.Add("IloscOK", "IloscOK");
grid.Columns.Add("NG", "NG");
grid.Columns.Add("Scrap", "Scrap");
DataGridViewImageButtonSaveColumn columnImage = new DataGridViewImageButtonSaveColumn();
columnImage.Name = "Images";
columnImage.HeaderText = "";
grid.Columns.Add(columnImage);
//grid.Columns.Add("Zdjecia", "Zdjecia");
foreach (var inspectionRecord in inspectionData.Skip(inspectionData.Count - 40).Reverse())
{
var fileImgList = TryGetFileInfoOfImagesForLot(inspectionRecord.NumerZlecenia, inspectionRecord.RealDateTime.ToString("dd-MM-yyyy"));
grid.Rows.Add(inspectionRecord.RealDateTime, inspectionRecord.Model, inspectionRecord.NumerZlecenia, inspectionRecord.Oper, inspectionRecord.SmtLine, inspectionRecord.GoodQty, inspectionRecord.AllNg, inspectionRecord.AllScrap);
if (fileImgList.Count > 0)
{
((DataGridViewImageButtonSaveCell)(grid.Rows[grid.Rows.GetLastRow(DataGridViewElementStates.None)].Cells["Images"])).Enabled = true;
((DataGridViewImageButtonSaveCell)(grid.Rows[grid.Rows.GetLastRow(DataGridViewElementStates.None)].Cells["Images"])).ButtonState = PushButtonState.Normal;
//grid.Rows[grid.Rows.GetLastRow(DataGridViewElementStates.None)].Cells["Zdjecia"] = new DataGridViewButtonCell();
//grid.Rows[grid.Rows.GetLastRow(DataGridViewElementStates.None)].Cells["Zdjecia"] = new DataGridViewImageButtonCell();
grid.Rows[grid.Rows.GetLastRow(DataGridViewElementStates.None)].Cells["Images"].Tag = fileImgList;
}
}
dgvTools.ColumnsAutoSize(grid, DataGridViewAutoSizeColumnMode.AllCells);
}
