public PagedResultDto <PCPTBVT_DTO> FilterPCPTBVT(
[FromBody] PCPTBVT_DTO inputFilter,
string orderBy, bool desc = false,
int?skip = null, int?take = null)
{
return(_service.PCPTBVT_Filter(inputFilter, orderBy, desc, skip, take));
}
public FileDto PCPTBVT_ExportToExcel(PCPTBVT_DTO input)
{
var workbook = new Workbook();
var sheet0 = workbook.Worksheets[0];
var data = procedureHelper.GetData <PCPTBVT_EXPORT_DTO>("PhieuCapPhatTBVTYT_Filter", input);
sheet0.Cells.ImportCustomObjects(
data, 0, 0,
new ImportTableOptions()
{
DateFormat = "dd/MM/yyyy",
IsFieldNameShown = true,
});
sheet0.Cells.ImportArray(
new string[]
{
"Mã PCP",
"Phòng ban",
"Ngày tạo",
"Ghi chú"
},
0, 0, false);
var range = sheet0.Cells.MaxDisplayRange;
var cellStyle = workbook.CreateStyle();
cellStyle.SetBorder(BorderType.BottomBorder, CellBorderType.Thin, Color.Black);
cellStyle.SetBorder(BorderType.LeftBorder, CellBorderType.Thin, Color.Black);
cellStyle.SetBorder(BorderType.RightBorder, CellBorderType.Thin, Color.Black);
cellStyle.SetBorder(BorderType.TopBorder, CellBorderType.Thin, Color.Black);
for (int r = range.FirstRow; r < range.RowCount; r++)
{
for (int c = range.FirstColumn; c < range.ColumnCount; c++)
{
Cell cell = sheet0.Cells[r, c];
cell.SetStyle(cellStyle, new StyleFlag()
{
TopBorder = true, BottomBorder = true, LeftBorder = true, RightBorder = true
});
}
}
sheet0.AutoFitColumns();
var fileName = $"PCPTBVT_{DateTime.Now.ToString("MMddyyyyHHmmss")}.xlsx";
var file = new FileDto(fileName, MimeTypeNames.ApplicationVndOpenxmlformatsOfficedocumentSpreadsheetmlSheet);
var filePath = Path.Combine(_appFolders.TempFileDownloadFolder, file.FileToken);
workbook.Save(Path.Combine(filePath), SaveFormat.Xlsx);
return(file);
}
public PagedResultDto <PCPTBVT_DTO> PCPTBVT_Filter(
PCPTBVT_DTO inputFilter,
string orderBy = null,
bool desc = false,
int?skip = null,
int?take = null)
{
IEnumerable <PCPTBVT_DTO> list = procedureHelper.GetData <PCPTBVT_DTO>("PhieuCapPhatTBVTYT_Filter", inputFilter);
var totalCount = list.Count();
list = SortAndLimit(list.AsQueryable(), orderBy, desc, skip, take);
// result
return(new PagedResultDto <PCPTBVT_DTO>(
totalCount,
list.ToList()));
}
public FileDto ExportPCPTBVT([FromBody] PCPTBVT_DTO input)
{
return(_service.PCPTBVT_ExportToExcel(input));
}
