protected DocumentModel CreateDocument()
{
DocumentModel document = WordExtensions.Load($@"{AppSettings.UploadFolder}\MauVanBan\MauDanhSachYKCDGiaoViec.docx");
document.Content.Find("(NgayBaoCao)")?.First()?.LoadText($"{AppSettings.DateRegion}, ngày {DateTime.Now.Date.Day} tháng {DateTime.Now.Date.Month} năm {DateTime.Now.Date.Year}");
var dataTable = document.GetChildElements(true, ElementType.Table).Cast <GemBox.Document.Tables.Table>().ToArray()[1];
int stt = 1;
int currentIndex = 1;
foreach (var item in RequestServices.GetList(YkcdCuaUbndTinh: true, tuNgay: TuNgay.Text.ToDateTimeNullable(), denNgay: DenNgay.Text.ToDateTimeNullable()).Where(item => TrangThai.GetSelectedValues().Contains(item.Status)).OrderBy(item => item.RequiredDate).ToList())
{
dataTable.Rows.Insert(
currentIndex, new TableRow(document,
new TableCell(document, new Paragraph(document, stt.ToString()).Center()),
new TableCell(document, new Paragraph(document, item?.Document?.DocumentCode?.RemoveBreakLineCharacters()).Center()),
new TableCell(document, new Paragraph(document, item?.Document?.ReleaseDate?.ToDateString())?.Center()),
new TableCell(document, new Paragraph(document, item?.RequestContent?.RemoveBreakLineCharacters())),
new TableCell(document, new Paragraph(document, item?.RequiredDate.ToDateString())?.Center()),
new TableCell(document, item?.Performs.Select(i => i.DepartmentName).ToList().DisplayList(document)),
new TableCell(document, item?.Reports?.Select(i => i.ReportContent).ToList().DisplayList(document))
));
stt++;
currentIndex++;
}
return(document);
}
protected override void GetDataList()
{
BaseCollection = RequestServices.GetList(YkcdCuaUbndTinh: true, tuNgay: TuNgay.Text.ToDateTimeNullable(), denNgay: DenNgay.Text.ToDateTimeNullable()).Where(item => TrangThai.GetSelectedValues().Contains(item.Status)).OrderBy(item => item.RequiredDate).ToList();
}