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