public async Task <ActionResult> ExportExcelScoreRecordDetail(string recordId)
{
var data = await _auditRateService.GetScoreRecordDetail(recordId);
var path = Path.Combine(_webHostEnvironment.ContentRootPath, "Resources\\Template\\SME_Score_Record_Detail_Template.xlsx");
WorkbookDesigner designer = new WorkbookDesigner();
designer.Workbook = new Workbook(path);
Worksheet ws = designer.Workbook.Worksheets[0];
// Gán giá trị tĩnh
ws.Cells["B2"].PutValue(data.auditRateM.Record_Date);
ws.Cells["D2"].PutValue(data.auditRateM.PDC);
ws.Cells["F2"].PutValue(data.auditRateM.Building);
ws.Cells["B3"].PutValue(data.auditRateM.Updated_By);
ws.Cells["D3"].PutValue(data.auditRateM.Updated_Time);
ws.Cells["F3"].PutValue(data.auditRateM.Line);
ws.Cells["F4"].PutValue(data.auditRateM.Audit_Type2);
designer.SetDataSource("result", data.listAuditRateD);
designer.Process();
MemoryStream stream = new MemoryStream();
designer.Workbook.Save(stream, SaveFormat.Xlsx);
byte[] result = stream.ToArray();
return(File(result, "application/xlsx", "SME_Score_Record_Detail" + DateTime.Now.ToString("dd_MM_yyyy_HH_mm_ss") + ".xlsx"));
}
public async Task <ActionResult> GetScoreRecordDetail(string recordId)
{
var data = await _auditRateService.GetScoreRecordDetail(recordId);
if (data != null)
{
return(Ok(data));
}
return(NoContent());
}
public async Task <ActionResult> ExportExcelScoreRecordDetail(string recordId)
{
var data = await _auditRateService.GetScoreRecordDetail(recordId);
var Building = await _auditPicDService.GetBuidingByID(data.auditRateM.Building);
var path = Path.Combine(_webHostEnvironment.ContentRootPath, "Resources\\Template\\Sixs_Score_Record_Detail_Template.xlsx");
WorkbookDesigner designer = new WorkbookDesigner();
designer.Workbook = new Workbook(path);
Worksheet ws = designer.Workbook.Worksheets[0];
// Gán giá trị tĩnh
ws.Cells["B2"].PutValue(data.auditRateM.Record_Date);
ws.Cells["D2"].PutValue(data.auditRateM.PDC_Name);
ws.Cells["F2"].PutValue(Building);
ws.Cells["B3"].PutValue(data.auditRateM.Updated_By);
ws.Cells["D3"].PutValue(data.auditRateM.Updated_Time);
ws.Cells["F3"].PutValue(data.auditRateM.Line_ID_2_Name);
ws.Cells["F4"].PutValue(data.auditRateM.Audit_Type2);
designer.SetDataSource("result", data.listAuditRateD);
designer.Process();
for (var i = 6; i <= data.listAuditRateD.Count + 5; i++)
{
var filePathB4 = "wwwroot\\uploaded\\images\\" + data.listAuditRateD[i - 6].UplloadPicture;
if (System.IO.File.Exists(filePathB4))
{
var pictureIndex = ws.Pictures.Add(i, 6, filePathB4);
Aspose.Cells.Drawing.Picture picture = ws.Pictures[pictureIndex];
picture.Width = 100;
picture.Height = 100;
//margin
picture.Top = 3;
picture.Left = 3;
//set lại Height cho dòng có image
ws.Cells.Rows[i].Height = 80;
}
}
MemoryStream stream = new MemoryStream();
designer.Workbook.Save(stream, SaveFormat.Xlsx);
byte[] result = stream.ToArray();
return(File(result, "application/xlsx", "Sixs_Score_Record_Detail" + DateTime.Now.ToString("dd_MM_yyyy_HH_mm_ss") + ".xlsx"));
}