private void SaveDownload(string fileName, WarrantyList list)
{
var workbook = new HSSFWorkbook();
var worksheet = workbook.CreateSheet("Report");
ExcelWorker.CellStyles = new List <ICellStyle>();
ExcelWorker.CreateRow(worksheet, 0, new ExcelCell[] {
ExcelWorker.CreateCell(workbook, "Kho", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index),
ExcelWorker.CreateCell(workbook, "Mã", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index),
ExcelWorker.CreateCell(workbook, "Nhân viên", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index),
ExcelWorker.CreateCell(workbook, "Mã hóa đơn", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index),
ExcelWorker.CreateCell(workbook, "Khách hàng", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index),
ExcelWorker.CreateCell(workbook, "Ngày tạo", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index),
ExcelWorker.CreateCell(workbook, "Ngày chuyển đi TTBH", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index),
ExcelWorker.CreateCell(workbook, "Ngày TTBH nhận", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index),
ExcelWorker.CreateCell(workbook, "Ngày chuyển đến CH", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index),
ExcelWorker.CreateCell(workbook, "Ngày CH nhận", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index),
ExcelWorker.CreateCell(workbook, "Ngày giao hàng", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index),
ExcelWorker.CreateCell(workbook, "Phí", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index),
ExcelWorker.CreateCell(workbook, "Khuyến mãi", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index),
ExcelWorker.CreateCell(workbook, "Ghi chú", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index),
ExcelWorker.CreateCell(workbook, "Khác", HSSFColor.RoyalBlue.Index, HSSFColor.White.Index)
});
for (var i = 0; i < list.Data.Count; i++)
{
var record = list.Data[i];
ExcelWorker.CreateRow(worksheet, i + 1, new ExcelCell[] {
ExcelWorker.CreateCell(workbook, record.WarehouseName),
ExcelWorker.CreateCell(workbook, record.Code),
ExcelWorker.CreateCell(workbook, record.EmployeeName),
ExcelWorker.CreateCell(workbook, record.OrderCode),
ExcelWorker.CreateCell(workbook, record.ClientName),
ExcelWorker.CreateCell(workbook, record.SubmitDate.ToString(Constants.DateTimeString)),
ExcelWorker.CreateCell(workbook, record.TransferDate.HasValue ? record.TransferDate.Value.ToString(Constants.DateString) : ""),
ExcelWorker.CreateCell(workbook, record.ReceivedDate.HasValue ? record.ReceivedDate.Value.ToString(Constants.DateString) : ""),
ExcelWorker.CreateCell(workbook, record.ProcessedDate.HasValue ? record.ProcessedDate.Value.ToString(Constants.DateString) : ""),
ExcelWorker.CreateCell(workbook, record.ReturnedDate.HasValue ? record.ReturnedDate.Value.ToString(Constants.DateString) : ""),
ExcelWorker.CreateCell(workbook, record.FinishDate.ToString(Constants.DateString)),
ExcelWorker.CreateCell(workbook, record.FeeString),
ExcelWorker.CreateCell(workbook, record.DiscountString),
ExcelWorker.CreateCell(workbook, record.Note),
ExcelWorker.CreateCell(workbook, record.Other)
});
}
ExcelWorker.CreateRow(worksheet, list.Data.Count + 1, new ExcelCell[] {
ExcelWorker.CreateCell(workbook, ""),
ExcelWorker.CreateCell(workbook, ""),
ExcelWorker.CreateCell(workbook, ""),
ExcelWorker.CreateCell(workbook, ""),
ExcelWorker.CreateCell(workbook, ""),
ExcelWorker.CreateCell(workbook, ""),
ExcelWorker.CreateCell(workbook, ""),
ExcelWorker.CreateCell(workbook, ""),
ExcelWorker.CreateCell(workbook, ""),
ExcelWorker.CreateCell(workbook, ""),
ExcelWorker.CreateCell(workbook, "Tổng cộng"),
ExcelWorker.CreateCell(workbook, list.Data.Sum(i => i.Fee).GetCurrencyString()),
ExcelWorker.CreateCell(workbook, list.Data.Sum(i => i.Discount).GetCurrencyString()),
ExcelWorker.CreateCell(workbook, ""),
ExcelWorker.CreateCell(workbook, "")
});
using (var fs = new FileStream(fileName, FileMode.OpenOrCreate, FileAccess.Write))
{
workbook.Write(fs);
}
}
