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