private void AppendData(List <KnifeCaptureTracking> knife_captures)
{
int Total = 0;
try
{
DataTable DetailTable = new DataTable();
DetailTable.Columns.Add("Total captured");
DetailTable.Columns.Add("Time");
DetailTable.Columns.Add("Knife Type");
DetailTable.Columns.Add("Position");
DetailTable.Columns.Add("Knife Name");
DetailTable.Columns.Add("Current");
foreach (var item in knife_captures)
{
Total++;
var knife = ComponentBase.Get_Knife(item.LocalKnifeId);
string knife_name = knife != null ? knife.ComponentCode : string.Empty;
DetailTable.Rows.Add(new object[] { Total, item.UpdateTime.ToString("ddd, dd/MM/yy, hh:ss tt"), item.KType, item.KPosition, knife_name, item.LocalValue });
}
txtOldLeft.Text = KC_DisMachine.OldLeft.ToString();
txtOldRight.Text = KC_DisMachine.OldRight.ToString();
txtNewLeft.Text = KC_DisMachine.NewLeft.ToString();
txtNewRight.Text = KC_DisMachine.NewRight.ToString();
lbTotalOld.Text = (KC_DisMachine.OldLeft + KC_DisMachine.OldRight).ToString();
lbTotalNew.Text = (KC_DisMachine.NewLeft + KC_DisMachine.NewRight).ToString();
DetailData.DataSource = DetailTable;
DetailData.Columns[0].Width = 50;
DetailData.Columns[1].Width = 130;
DetailData.Columns[2].Width = 70;
DetailData.Columns[3].Width = 70;
DetailData.Columns[4].Width = 50;
DetailData.Columns[5].Width = 50;
}
catch { }
}
public static void ExportToExcel_KC_Machine(AutoCutMachine Machine, ExcelWorksheet CurrentSheet, DateTime ExportDateOfWeek)
{
var knife_captures = KC_ImplementBase.Get_KnifeCaptureTrackingsOnWeek(Machine, ExportDateOfWeek);
if (knife_captures == null)
{
return;
}
string[] Header = new string[] { "Tổng/STT", "Thời gian", "Loại dao", "Đầu dao", "Tên dao", "Hiện tại" };
int beginColumn = 1;
int beginRow = 1;
//create excel header
for (int i = beginColumn; i <= Header.Length; i++)
{
CurrentSheet.Cells[beginRow, i].Value = Header[i - 1];
CurrentSheet.Cells[beginRow, i].Style.Font.Bold = true;
CurrentSheet.Cells[beginRow, i].Style.Border.BorderAround(ExcelBorderStyle.Medium);
}
ExcelRange HeaderRow = CurrentSheet.Cells[beginRow, beginColumn, beginRow, beginColumn + 4];
HeaderRow.Style.Fill.PatternType = ExcelFillStyle.Solid;
HeaderRow.Style.Fill.BackgroundColor.SetColor(Color.Yellow);
HeaderRow.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
HeaderRow.Style.VerticalAlignment = ExcelVerticalAlignment.Center;
HeaderRow.Style.Border.BorderAround(ExcelBorderStyle.Medium);
int Total = 0;
foreach (var item in knife_captures)
{
Total++;
ExcelRange CurrentRow = CurrentSheet.Cells[beginRow + Total, beginColumn, beginRow + Total, beginColumn + 4];
CurrentRow.Style.Fill.PatternType = ExcelFillStyle.Solid;
if (item.KnifeType == 0)
{
CurrentRow.Style.Fill.BackgroundColor.SetColor(Color.Silver);
}
if (item.KnifeType == 1)
{
CurrentRow.Style.Fill.BackgroundColor.SetColor(Color.LightBlue);
}
int CurrentRowIndex = beginRow + Total;
ExcelRange TotalCell = CurrentSheet.Cells[CurrentRowIndex, beginColumn + 0];
ExcelRange TimeCell = CurrentSheet.Cells[CurrentRowIndex, beginColumn + 1];
ExcelRange TypeCell = CurrentSheet.Cells[CurrentRowIndex, beginColumn + 2];
ExcelRange PosCell = CurrentSheet.Cells[CurrentRowIndex, beginColumn + 3];
ExcelRange KnifeNameCell = CurrentSheet.Cells[CurrentRowIndex, beginColumn + 4];
ExcelRange LocalCell = CurrentSheet.Cells[CurrentRowIndex, beginColumn + 5];
TotalCell.Style.Border.BorderAround(ExcelBorderStyle.Dashed);
TimeCell.Style.Border.BorderAround(ExcelBorderStyle.Dashed);
TypeCell.Style.Border.BorderAround(ExcelBorderStyle.Dashed);
PosCell.Style.Border.BorderAround(ExcelBorderStyle.Dashed);
KnifeNameCell.Style.Border.BorderAround(ExcelBorderStyle.Dashed);
LocalCell.Style.Border.BorderAround(ExcelBorderStyle.Dashed);
if (item.KnifeHeadPos == 0)
{
PosCell.Style.Fill.PatternType = ExcelFillStyle.Solid;
PosCell.Style.Fill.BackgroundColor.SetColor(Color.LightGreen);
}
if (item.KnifeHeadPos == 1)
{
PosCell.Style.Fill.PatternType = ExcelFillStyle.Solid;
PosCell.Style.Fill.BackgroundColor.SetColor(Color.LightYellow);
}
var knife = ComponentBase.Get_Knife(item.LocalKnifeId);
string knife_name = knife != null ? knife.ComponentCode : string.Empty;
TotalCell.Value = Total;
TimeCell.Value = item.UpdateTime.ToString("ddd, dd/MM/yy, hh:ss tt");
TypeCell.Value = item.KType;
PosCell.Value = item.KPosition;
KnifeNameCell.Value = knife_name;
LocalCell.Value = item.LocalValue;
}
ExcelRange CurrentTable = CurrentSheet.Cells[beginRow, beginColumn, beginRow + Total, beginColumn + 5];
CurrentTable.Style.Border.BorderAround(ExcelBorderStyle.Medium);
CurrentSheet.Cells.Style.WrapText = true;
CurrentSheet.Column(beginColumn).Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
CurrentSheet.Column(beginColumn + 5).Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;
CurrentSheet.Column(beginColumn + 1).Width = 30;
CurrentSheet.Column(beginColumn + 2).Width = 20;
CurrentSheet.Column(beginColumn + 3).Width = 20;
CurrentSheet.Column(beginColumn + 4).Width = 20;
}
