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