public static void CreateTestReport(Patient patient, MedicalTest test, string file_path)
{
if (file_path == null)
{
return;
}
Type test_type = test.GetType();
using (DocX document = DocX.Create(file_path))
{
Novacode.Paragraph header = document.InsertParagraph(
//selected_procedure.ProcedureType.First().ToString().ToUpper() + String.Join("", selected_procedure.ProcedureType.Skip(1)).ToLower(),
test_type.GetCustomAttribute <DisplayNameAttribute>().DisplayName,
false,
new Formatting()
{
FontFamily = new System.Drawing.FontFamily("Times New Roman"),
Size = 16D
}
);
header.Alignment = Alignment.center;
header.Bold();
document.InsertParagraph(" ");
Novacode.Table patient_info = document.AddTable(5, 2);
patient_info.Rows[0].Cells[0].Paragraphs.First().Append("ФИО пациента").Bold();
patient_info.Rows[0].Cells[1].Paragraphs.First().Append(patient.LastName + " " + patient.FirstName + " " + patient.Patronym);
patient_info.Rows[1].Cells[0].Paragraphs.First().Append("Пол").Bold();
patient_info.Rows[1].Cells[1].Paragraphs.First().Append(patient.Sex == Sex.мужской ? "мужской" : "женский");
patient_info.Rows[2].Cells[0].Paragraphs.First().Append("Дата рождения").Bold();
patient_info.Rows[2].Cells[1].Paragraphs.First().Append(patient.Birthdate.ToShortDateString());
patient_info.Rows[3].Cells[0].Paragraphs.First().Append("Адрес проживания").Bold();
patient_info.Rows[3].Cells[1].Paragraphs.First().Append(
patient.PostIndex + ", " + patient.Country + ", " + patient.Region +
", " + patient.City + ", " + patient.Address
);
patient_info.Rows[4].Cells[0].Paragraphs.First().Append("Номер карты").Bold();
patient_info.Rows[4].Cells[1].Paragraphs.First().Append(patient.CardNumber.ToString());
patient_info.Alignment = Alignment.left;
patient_info.AutoFit = AutoFit.Window;
PropertyInfo[] indicators = test_type.GetProperties().Where(x => x.IsDefined(typeof(TestInfo))).ToArray();
Novacode.Table test_info = document.AddTable(indicators.Count(), 2);
int k = 0;
foreach (var indicator in indicators)
{
test_info.Rows[k].Cells[0].Paragraphs.First().Append(indicator.GetCustomAttribute <TestInfo>().DisplayName);
object property_value = indicator.GetValue(test);
test_info.Rows[k].Cells[1].Paragraphs.First().Append(property_value != null ? property_value.ToString() : "");
k++;
}
test_info.Alignment = Alignment.left;
test_info.AutoFit = AutoFit.Window;
document.InsertTable(patient_info);
document.InsertParagraph(" ");
document.InsertTable(test_info);
document.Save();
}
}
/// <summary>
/// Initialize Word Report --> Support Method
/// </summary>
public static void InsertSummaryResults()
{
try
{
Table table = resultSummarydocument.AddTable(1, 4);
// Specify some properties for this Table.
table.Alignment = Alignment.left;
table.AutoFit = AutoFit.Contents;
table.Design = TableDesign.TableGrid;
table.SetColumnWidth(0, 667.87);
table.SetColumnWidth(1, 5347.87);
table.SetColumnWidth(2, 1255.87);
table.SetColumnWidth(3, 1825.82);
table.Rows[0].Cells[0].Paragraphs.First().Append(smrw.ToString() + ".");
smrw += 1;
table.Rows[0].Cells[1].Paragraphs.First().Append(BaseUtilities.scenarioName);
switch (BaseUtilities.scenarioStatus.ToLower())
{
case "pass":
table.Rows[0].Cells[2].Paragraphs.First().Append("Pass").Color(System.Drawing.Color.FromArgb(52, 168, 83));
break;
case "fail":
table.Rows[0].Cells[2].Paragraphs.First().Append("Fail").Color(System.Drawing.Color.FromArgb(234, 67, 53));
break;
case "skip":
table.Rows[0].Cells[2].Paragraphs.First().Append("Skip").Color(System.Drawing.Color.FromArgb(234, 67, 53));
break;
}
Hyperlink link = resultSummarydocument.AddHyperlink("Click here", new Uri(reportpath));
table.Rows[0].Cells[3].Paragraphs.First().AppendHyperlink(link).Color(System.Drawing.Color.FromArgb(1, 91, 168));
resultSummarydocument.InsertTable(table);
resultSummarydocument.Save();
}
catch (Exception e)
{
Reports.SetupErrorLog(e);
}
}
private void ExportarDgvAWord(DataGridView dgv, string filename)
{
//Creamos el Word
DocX miWord = DocX.Create(filename);
//Creamos la tabla
//Le sumo + 1 para adicionarle el encabezado
Table miTabla = miWord.AddTable(dgv.RowCount + 1, dgv.ColumnCount);
miWord.InsertParagraph("Hello Word");
for (int fila = -1; fila < dgv.RowCount; fila++)
{
for (int col = 0; col < dgv.ColumnCount; col++)
{
if (fila == -1) //Es encabezado
{
//Mediante Bold() cambio a negrita toda la fila
miTabla.Rows[0].Cells[col].Paragraphs.First().Append(dgv.Columns[col].HeaderText).Bold();
}
else //Es otra fila
{
miTabla.Rows[fila + 1].Cells[col].Paragraphs.First().Append(dgv.Rows[fila].Cells[col].Value.ToString());
}
}
}
miWord.InsertTable(miTabla);
miWord.Save();
}
private static void ExportObjectInDoc(FHXObject obj, DocX doc, int level = 0)
{
doc.InsertSection();
Paragraph p = doc.InsertParagraph(obj.Name).Heading((HeadingType)level).Bold().UnderlineStyle(UnderlineStyle.singleLine);
p.Alignment = Alignment.left;
if (obj.Parameters.Count > 0)
{
Table t = doc.InsertTable(obj.Parameters.Count, 2);
int i = 0;
foreach (FHXParameter par in obj.Parameters)
{
ExportParameterInDoc(par, t, i);
i++;
}
}
foreach (FHXObject child in obj.Children)
{
ExportObjectInDoc(child, doc, level + 1);
}
}
///// <summary>
///// 添加概述模块（用于县公司）
///// </summary>
///// <param name="document"></param>
///// <param name="ischild"></param>
//public virtual void Addintro(DocX document,bool ischild) { }
/// <summary>
/// 添加组织机构模块（省公司和市公司）
/// </summary>
/// <param name="document"></param>
public virtual void Addorganization(DocX document, NumoftitleHelper title)
{
try
{
Paragraph pagebreak = document.InsertParagraph();
pagebreak.InsertPageBreakAfterSelf();//分页符
title.Less2Zero();
var h1_2 = document.InsertParagraph(title.num2title() + "组织机构");
h1_2.StyleName = "Heading2";
using (FontFamily fontfamily = new FontFamily("宋体"))
{
h1_2.Color(Color.Black).FontSize(16).Font(fontfamily);
}
Table t = table.tableHelper.organizationTable(document, Childcompany, PathManager.getSingleton().GetOrganizationpicPath(CompanyID, false));
t.Alignment = Alignment.center;
t.AutoFit = AutoFit.Contents;
if (t != null)
{
document.InsertTable(t);
}
}
catch (System.Exception ex)
{
LogHelper.WriteLog(typeof(CreateCompany), ex);
}
}
private void AddTable(CalculationResult calculationResult)
{
PageBreak();
var value = $@"Расчетный состав для {MainWindowViewModel.Instance.Calculation.CountConcrete} м³";
AddTitle(value);
var table = _document.AddTable(5, 2);
table.Design = TableDesign.TableGrid;
table.Alignment = Alignment.center;
table.SetColumnWidth(0, 5024);
table.SetColumnWidth(1, 5024);
table.Rows[0].Cells[0].Paragraphs[0].Append("Цемент").Font(_fontFamily.Source).FontSize(_fontSizeText);
table.Rows[0].Cells[1].Paragraphs[0].Append($@"{calculationResult.CorrectedCementConsumption * MainWindowViewModel.Instance.Calculation.CountConcrete: .##} кг.").Font(_fontFamily.Source).FontSize(_fontSizeText);
table.Rows[1].Cells[0].Paragraphs[0].Append("Вода").Font(_fontFamily.Source).FontSize(_fontSizeText);
table.Rows[1].Cells[1].Paragraphs[0].Append($@"{calculationResult.WaterFlowWithRegardToAirContent * MainWindowViewModel.Instance.Calculation.CountConcrete: .##} л.").Font(_fontFamily.Source).FontSize(_fontSizeText);
table.Rows[2].Cells[0].Paragraphs[0].Append("Песок").Font(_fontFamily.Source).FontSize(_fontSizeText);
table.Rows[2].Cells[1].Paragraphs[0].Append($@"{calculationResult.TheAmountOfSandDry * MainWindowViewModel.Instance.Calculation.CountConcrete: .##} кг.").Font(_fontFamily.Source).FontSize(_fontSizeText);
table.Rows[3].Cells[0].Paragraphs[0].Append("Крупный заполнитель").Font(_fontFamily.Source).FontSize(_fontSizeText);
table.Rows[3].Cells[1].Paragraphs[0].Append($@"{calculationResult.NumberOfCoarseAggregate * MainWindowViewModel.Instance.Calculation.CountConcrete: .##} кг.").Font(_fontFamily.Source).FontSize(_fontSizeText);
table.Rows[4].Cells[0].Paragraphs[0].Append($@"Химическая добавка { MainWindowViewModel.Instance.Calculation.Admixtures.Name}").Font(_fontFamily.Source).FontSize(_fontSizeText);
table.Rows[4].Cells[1].Paragraphs[0].Append($@"{calculationResult.ChemicalAdditive * MainWindowViewModel.Instance.Calculation.CountConcrete: .##} кг.").Font(_fontFamily.Source).FontSize(_fontSizeText);
_document.InsertTable(table);
}
/*使用起来就比较麻烦如果这样弄出来
* DocXClass.addTable(file,3,3,new string[] { "1","2","3"});
* DocX document = DocXClass.getDocx(file);
* Table t= DocXClass.getTables( document)[0];
*
* DocXClass.setCellvalue( t, 1, 0, "a");
* DocXClass.setCellvalue( t, 1, 1, "b");
* DocXClass.setCellvalue( t, 1, 2, "c");
* DocXClass.mergeCells( t, true, 2, 0, 2);
* DocXClass.setCellvalue( t,2,0,"merge
* DocXClass.saveTable(ref document);
*/
//添加表格，其实可以只需要行列数就行，列标题都可以之后再设置
public static void addTable(string docx, int row, int col, string[] colHeader)
{
if (!File.Exists(docx))
{
MessageBox.Show(docx + "文件不存在");
return;
}
if (col > colHeader.Length)
{
MessageBox.Show("列标题少于给定的列数目");
return;
}
using (DocX document = DocX.Load(docx))
{
// Create a new Table with 2 coloumns and 3 rows.
Table newTable = document.InsertTable(row, col);
// Set the design of this Table.
//newTable.Design = TableDesign.Custom;//传统样式，但是没有表格线
//newTable.Design = TableDesign.TableNormal;//传统样式，但是没有表格线
newTable.Design = TableDesign.TableGrid;//传统样式，有了表格线
// Set the coloumn names.
for (int i = 0; i < col; i++)
{
newTable.Rows[0].Cells[i].Paragraphs.First().InsertText(colHeader[i], false);
}
document.Save();
}// Release this document from memory.
}
private static Table InsertFixedTable(DocX doc, XElement tableEl)
{
XElement colParameters = tableEl.Element("ColumnsParameters");
int colCount;
if (colParameters.Element("ColumnCount") != null)
{
colCount = int.Parse(colParameters.Element("ColumnCount").Value);
}
else
{
colCount = colParameters.Element("Columns").Elements().Count();
}
Table table = doc.InsertTable(tableEl.Element("Rows").Elements().Count(), colCount);
table.Design = TableDesign.TableGrid;
if (colParameters.Element("Columns") != null)
{
byte wIndex = 0;
foreach (XElement width in colParameters.Element("Columns").Elements())
{
table.SetColumnWidth(wIndex, double.Parse(width.Value));
wIndex++;
}
}
return(table);
}
/// <summary>
/// 添加房地信息总汇模块（作为省公司下级的市公司）
/// </summary>
/// <param name="document"></param>
/// <param name="childcityName"></param>
public void Addfdxx(DocX document, string childcityName, NumoftitleHelper title)
{
try
{
Table t = tableHelper.Template_city(document);
t = tableHelper.inserttable_city(t, lstFM);
if (t == null)
{
return;
}
title.Less2Zero();
var h1_3 = document.InsertParagraph(title.num2title() + "房地信息总汇");
h1_3.StyleName = "Heading2";
using (FontFamily fontfamily = new FontFamily("宋体"))
{
h1_3.Color(Color.Black).FontSize(16).Font(fontfamily);
}
//表格描述
var tbltitle = document.InsertParagraph(childcityName + "房地信息汇总表");
tbltitle.FontSize(14).Alignment = Alignment.center;
t.Alignment = Alignment.center;
t.AutoFit = AutoFit.Contents;
document.InsertTable(t);
}
catch (Exception ex)
{
LogHelper.WriteLog(typeof(CreateCityCompany), ex);
}
}
///// <summary>
///// 添加市公司的组织机构模块
///// </summary>
///// <param name="document"></param>
//public override void Addorganization(DocX document)
//{
// var h1_2 = document.InsertParagraph("组织机构");
// h1_2.StyleName = "Heading2";
// Table t = table.tableHelper.organizationTable(document, Childcompany, path.pathHelper.GetOrganizationpicPath(CompanyID));
// document.InsertTable(t);
//}
/// <summary>
/// 添加组织机构模块（作为省公司下级的市公司）
/// </summary>
/// <param name="document"></param>
/// <param name="childcityID"></param>
public void Addorganization(DocX document, int childcityID, NumoftitleHelper title)
{
List <Companymodel> cchildcityID = DBhelper.GetChildcompany(childcityID);
Table t = table.tableHelper.organizationTable(document, cchildcityID, PathManager.getSingleton().GetOrganizationpicPath(childcityID, false));//childcountryID
t.Alignment = Alignment.center;
t.AutoFit = AutoFit.Contents;
if (t == null)
{
return;
}
title.Less2Zero();
var h1_2 = document.InsertParagraph(title.num2title() + "组织机构");
h1_2.InsertPageBreakBeforeSelf();
h1_2.StyleName = "Heading2";
using (FontFamily fontfamily = new FontFamily("宋体"))
{
h1_2.Color(Color.Black).FontSize(16).Font(fontfamily);
}
document.InsertTable(t);
}
private void BuildRow(XlsItem item, DocX document)
{
var row = (XlsRow)item;
var oldStyle = MergeStyle(item.Style);
try
{
var formatting = GetFormatting();
if (/*row.Items.Count < 2 &&*/ !row.Items.Exists(i => (i is XlsGroup)))
{
var para = AppendParagraph(document);
foreach (var child in row.Items)
{
AppendParaText(child, para);
}
}
else
{
var table = document.InsertTable(row.GetRows(), row.GetCols());
}
}
finally
{
SetStyle(oldStyle);
}
}
private void FillPurchases(DocX doc)
{
IEnumerable <LBCFUBL_WCF.DBO.Purchase> purchases = Helper
.GetPurchaseClient()
.GetPurchases()
.OrderBy(x => x.date)
.OrderBy(x => x.login)
.ThenBy(x => x.Product.name)
.Where(x => x.date >= from && x.date <= to);
Novacode.Table table = doc.AddTable(purchases.Count() + 1, 4);
setTableStyle(table);
table.Rows[0].Cells[0].InsertParagraph().Append("Login").Bold();
table.Rows[0].Cells[1].InsertParagraph().Append("Date").Bold();
table.Rows[0].Cells[2].InsertParagraph().Append("Produit").Bold();
table.Rows[0].Cells[3].InsertParagraph().Append("Prix").Bold();
int i = 1;
foreach (LBCFUBL_WCF.DBO.Purchase purchase in purchases)
{
table.Rows[i].Cells[0].InsertParagraph().Append(purchase.login);
table.Rows[i].Cells[1].InsertParagraph().Append(purchase.date.ToString("dd-MM-yyyy hh:mm"));
table.Rows[i].Cells[2].InsertParagraph().Append(purchase.Product.name);
table.Rows[i].Cells[3].InsertParagraph().Append(currency(purchase.Product.cost_with_margin));
i++;
}
doc.InsertTable(table);
}
private static void WriteUnitTestStepObjectModification(UnitTestStepObjectModificationViewModel step, DocX doc)
{
Paragraph p;
p = doc.InsertParagraph();
p.StyleName = "Heading2";
p.InsertText(string.Format("Step {0}: {1}", step.ParentIndex + 1, step.DisplayName));
p = doc.InsertParagraph();
p.StyleName = "Heading3";
p.InsertText(string.Format("Attribute modifications"));
Table t = doc.InsertTable(step.AttributeChanges.Count + 1, 3);
t.Alignment = Alignment.left;
t.Design = TableDesign.LightListAccent1;
t.Rows[0].Cells[0].Paragraphs.First().Append("Attribute");
t.Rows[0].Cells[1].Paragraphs.First().Append("Modification type");
t.Rows[0].Cells[2].Paragraphs.First().Append("Value");
for (int i = 0; i < step.AttributeChanges.Count; i++)
{
t.Rows[i + 1].Cells[0].Paragraphs.First().Append(step.AttributeChanges[i].Name);
t.Rows[i + 1].Cells[1].Paragraphs.First().Append(step.AttributeChanges[i].ModificationType.ToString());
t.Rows[i + 1].Cells[2].Paragraphs.First().Append(step.AttributeChanges[i].ValueChangesString);
}
}
static void Main(string[] args)
{
//EPPlus (excel lib)
DocX report = DocX.Create("Report.docx", DocumentTypes.Document);
var paragraph = report.InsertParagraph("YoY Value Report", false,
new Formatting()
{
Bold = true
});
report.InsertParagraph();
report.InsertParagraph();
var table = report.InsertTable(2, 3);
table.Rows[0].Cells[0].InsertParagraph("Year");
table.Rows[0].Cells[1].InsertParagraph("Value");
table.Rows[0].Cells[2].InsertParagraph("Remarks");
table.Design = TableDesign.ColorfulList;
report.Save();
report.Dispose();
}
public static void GerarTabelaAreaDeEstagio(this DocX document, List <AreaEstagioCurso> areas, int IdArea)
{
int rows = areas.Count();
Table t = document.AddTable(rows, 2);
Formatting format = new Formatting();
format.Bold = true;
t.Paragraphs.ForEach(x => x.FontSize(12));
t.Paragraphs.ForEach(x => x.Font("Arial"));
t.Alignment = Alignment.center;
t.AutoFit = AutoFit.ColumnWidth;
for (int i = 0; i <= (int)TableBorderType.InsideV; i++)
{
t.SetBorder((TableBorderType)i, new Border());
}
for (int i = 1; i <= rows; i++)
{
int pos = i - 1;
if (i % 7 == 0)
{
document.InsertSectionPageBreak();
}
t.Rows[pos].Cells[1].Paragraphs[0].InsertText(areas[pos].Nome);
if (areas[pos].Identificador == IdArea)
{
t.Rows[pos].Cells[0].Paragraphs[0].InsertText("X", false, format);
}
}
document.InsertTable(t);
}
private void FillAccounts(DocX doc)
{
IEnumerable <LBCFUBL_WCF.DBO.Account> accounts = Helper
.GetAccountClient()
.GetAccounts()
.OrderBy(x => x.login)
.Where(x => x.date >= from && x.date <= to);
Novacode.Table table = doc.AddTable(accounts.Count() + 1, 3);
setTableStyle(table);
table.Rows[0].Cells[0].InsertParagraph().Append("Login").Bold();
table.Rows[0].Cells[1].InsertParagraph().Append("Date").Bold();
table.Rows[0].Cells[2].InsertParagraph().Append("Argent").Bold();
int i = 1;
foreach (LBCFUBL_WCF.DBO.Account account in accounts)
{
table.Rows[i].Cells[0].InsertParagraph().Append(account.login);
table.Rows[i].Cells[1].InsertParagraph().Append(account.date.ToString("dd-MM-yyyy hh:mm"));
table.Rows[i].Cells[2].InsertParagraph().Append(currency(account.argent));
i++;
}
doc.InsertTable(table);
}
private void InsertExperiences(Resume resume, DocX doc)
{
// 3 experience
doc.InsertParagraph().AppendLine();
doc.InsertParagraph(_localizationService.GetResource("Resume.Fields.Experiences", _workContext.Current.WorkingLanguage.Id), false, H2);
//.AppendLine(line);
foreach (var exp in resume.Experiences.OrderBy(x => x.DisplayOrder))
{
// doc.InsertParagraph().AppendLine();
var table = doc.AddTable(5, 2);
table.Design = TableDesign.TableNormal;
table.AutoFit = AutoFit.Contents;
InsertExperienceRow(doc, table, 0, "Resume.Fields.Experiences.Name", exp.GetLocalized(x => x.Name), H4);
InsertExperienceRow(doc, table, 1, "Resume.Fields.Experiences.Period", exp.GetLocalized(x => x.Period));
InsertExperienceRow(doc, table, 2, "Resume.Fields.Experiences.Function", exp.GetLocalized(x => x.Function));
InsertExperienceRow(doc, table, 3, "Resume.Fields.Experiences.City", exp.GetLocalized(x => x.City));
InsertExperienceRow(doc, table, 4, "Resume.Fields.Experiences.Tasks", exp.GetLocalized(x => x.Tasks));
doc.InsertTable(table);
//foreach (var p in exp.Projects)
//{
// doc.InsertParagraph().AppendLine();
// doc.InsertParagraph(p.GetLocalized(x => x.Name), false, H4);
// doc.InsertParagraph(p.GetLocalized(x => x.Description), false, Normal);
// doc.InsertParagraph(p.GetLocalized(x => x.Technology), false, Normal);
//}
}
}
private void button13_Click(object sender, EventArgs e)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.AddExtension = true;
sfd.Filter = "Word file (*.docx)|*.docx";
if (sfd.ShowDialog() == DialogResult.OK && sfd.FileName != "")
{
if (Path.GetExtension(sfd.FileName) == ".docx")
{
DocX doc = DocX.Create(sfd.FileName);
Paragraph p1 = doc.InsertParagraph();
p1.AppendLine("Итоговые результаты расчета").FontSize(14);
p1.AppendLine();
Table t = doc.AddTable(P.Z + 2, 5);
t.Alignment = Alignment.center;
t.Rows[0].Cells[0].Paragraphs.First().Append("№ ступени:").FontSize(12);
t.Rows[0].Cells[1].Paragraphs.First().Append("H0, кДж / кг").FontSize(12);
t.Rows[0].Cells[2].Paragraphs.First().Append("G, кг/с").FontSize(12);
t.Rows[0].Cells[3].Paragraphs.First().Append("\u03b7oi").FontSize(12);
t.Rows[0].Cells[4].Paragraphs.First().Append("N, МВт").FontSize(12);
for (int i = 0; i <= P.Z; i++)
{
for (int k = 0; k < 5; k++)
{
t.Rows[i + 1].Cells[k].Paragraphs.First().Append("" + (String)dataGridView1.Rows[i].Cells[k].Value);
}
}
doc.InsertTable(t);
doc.Save();
}
}
}
private void экспортВWordToolStripMenuItem_Click(object sender, EventArgs e)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.AddExtension = true;
sfd.Filter = "Word file (*.docx)|*.docx";
if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK && sfd.FileName != "")
{
if (Path.GetExtension(sfd.FileName) == ".docx")
{
DocX doc = DocX.Create(sfd.FileName);
Paragraph p1 = doc.InsertParagraph();
p1.AppendLine("Подробный тепловой расчет ступеней паровой турбины").FontSize(14);
p1.AppendLine();
Table t = doc.AddTable(j, 3);
t.Alignment = Alignment.center;
t.SetColumnWidth(0, 200);
t.Rows[0].Cells[0].Paragraphs.First().Append("Величина").FontSize(12);
t.Rows[0].Cells[1].Paragraphs.First().Append("Единица измерения").FontSize(12);
t.Rows[0].Cells[2].Paragraphs.First().Append("Значение").FontSize(12);
for (int i = 1; i < j; i++)
{
for (int k = 0; k < 3; k++)
{
t.Rows[i].Cells[k].Paragraphs.First().Append("" + (String)DB.Rows[i].Cells[k].Value);
}
}
doc.InsertTable(t);
doc.Save();
}
}
}
private static Table CreateMainData(DocX doc, string documentType, Vendor vendor, Customer customer, Consumer consumer, DocumentData documentData, PaymentData paymentData)
{
var t = doc.AddTable(1, 2);
t.SetWidthsPercentage(new[] { 50f, 50f }, doc.PageWidth);
var border = new Border();
border.Tcbs = BorderStyle.Tcbs_none;
for (int i = 0; i < 2; i++)
{
t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Left, border);
t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Top, border);
t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Right, border);
t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Bottom, border);
}
GenerateVendorText(t.Rows[0].Cells[0], vendor);
GenerateCustomerText(t.Rows[0].Cells[0], customer);
if (consumer != null)
{
GenerateConsumerText(t.Rows[0].Cells[0], consumer);
}
GenerateDocumentDataText(t.Rows[0].Cells[1], documentData, documentType);
GeneratePaymentDataText(t.Rows[0].Cells[1], paymentData);
doc.InsertTable(t);
return(t);
}
/// <summary>
/// Crea la tabla de recursos valiosos
/// </summary>
/// <param name="doc"></param>
/// <param name="empresa"></param>
private void insertarRecursosValiosos(DocX doc, Empresa empresa)
{
List <RecursoValioso> listadoRecursoValioso = MatrizBO.ConsultarRecursosValiosos(empresa.IdEmpresa);
int cantidadRecursos = listadoRecursoValioso.Count;
var RVParrafo = new Novacode.Formatting();
RVParrafo.FontFamily = new System.Drawing.FontFamily("Calibri");
RVParrafo.Size = 12D;
RVParrafo.Position = 3;
Paragraph pParr = doc.InsertParagraph("En este sentido se identifican " + cantidadRecursos + " recursos por encima del promedio, los cuales se convierten en valiosos y se listan a continuación", false, RVParrafo);
pParr.Alignment = Alignment.left;
Table tab = doc.AddTable(cantidadRecursos + 1, 2);
tab.AutoFit = AutoFit.Contents;
tab.Alignment = Alignment.center;
tab.Design = TableDesign.ColorfulGridAccent1;
tab.Rows[0].Cells[0].Paragraphs.First().Append("Recurso Valioso");
tab.Rows[0].Cells[0].Paragraphs.First().Alignment = Alignment.center;
tab.Rows[0].Cells[0].Paragraphs.First().Bold();
tab.Rows[0].Cells[1].Paragraphs.First().Append("Observaciones");
tab.Rows[0].Cells[1].Paragraphs.First().Alignment = Alignment.center;
tab.Rows[0].Cells[1].Paragraphs.First().Bold();
for (int i = 0; i < cantidadRecursos; i++)
{
RecursoValioso recursoValioso = listadoRecursoValioso[i];
tab.Rows[i + 1].Cells[0].Paragraphs.First().Append(recursoValioso.NombreRecurso);
}
doc.InsertTable(tab);
}
private static Table CreateSignTable(DocX doc)
{
var t = doc.AddTable(1, 2);
t.SetWidthsPercentage(new[] { 50f, 50f }, doc.PageWidth);
var border = new Border();
border.Tcbs = BorderStyle.Tcbs_none;
var formattingBold = new Formatting {
Bold = true, Size = DefaultSize, FontFamily = Font
};
var formattingWithoutBold = new Formatting {
Bold = false, Size = DefaultSize, FontFamily = Font
};
for (int i = 0; i < 2; i++)
{
t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Left, border);
t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Top, border);
t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Right, border);
t.Rows[0].Cells[i].SetBorder(TableCellBorderType.Bottom, border);
}
var p = t.Rows[0].Cells[0].Paragraphs.First().Append($"........................................................................\r\n{Resource.customerSign}", formattingWithoutBold);
p.Alignment = Alignment.center;
p = t.Rows[0].Cells[1].Paragraphs.First().Append($"........................................................................\r\n{Resource.vendorSign}", formattingWithoutBold);
p.Alignment = Alignment.center;
doc.InsertTable(t);
return(t);
}
// Create Issue Description doc for Evidence (SIT)
public void CreateXLSX()
{
string fp = filepath;
fp += release + " – Evidence.docx";
using (DocX document = DocX.Create(@fp)) {
// Add document info
string title = release + " – Evidence";
document.InsertParagraph(title).FontSize(15d).Bold().SpacingAfter(50d).Alignment = Alignment.center;
// Add a Table into the document and sets its values
var t1 = document.AddTable(test_names.Count, 2);
t1.Design = TableDesign.TableGrid;
t1.Alignment = Alignment.center;
t1.Rows[0].Cells[0].FillColor = Color.LightGray;
t1.Rows[0].Cells[1].FillColor = Color.LightGray;
for (int i = 0; i < test_names.Count; i++)
{
if (i == 0)
{
t1.Rows[i].Cells[0].Paragraphs[0].Append(test_names[i]).FontSize(10d).Bold().SpacingBefore(5d).SpacingAfter(5d).Alignment = Alignment.center;
t1.Rows[i].Cells[1].Paragraphs[0].Append(test_descriptions[i]).FontSize(10d).Bold().SpacingBefore(5d).SpacingAfter(5d).Alignment = Alignment.center;
}
else
{
t1.Rows[i].Cells[0].Paragraphs[0].Append(test_names[i]).FontSize(8d).KeepLinesTogether(true);
t1.Rows[i].Cells[1].Paragraphs[0].Append(test_descriptions[i]).FontSize(8d).KeepLinesTogether(true);
}
}
t1.AutoFit = AutoFit.Contents;
document.InsertTable(t1);
Paragraph p = document.InsertParagraph("\n");
// Create new table where .zip is embedded
var t2 = document.AddTable(2, 1);
t2.Design = TableDesign.TableGrid;
t2.Alignment = Alignment.center;
t2.Rows[0].Cells[0].FillColor = Color.LightGray;
t2.Rows[0].Cells[0].Paragraphs[0].Append("Before/After Evidence").FontSize(10d).Bold().SpacingBefore(5d).SpacingAfter(5d).Alignment = Alignment.center;
t2.Rows[1].Cells[0].Paragraphs[0].FontSize(8d).Alignment = Alignment.center;
document.InsertTable(t2);
document.Save();
}
}
private void toolStripMenuItem3_Click(object sender, EventArgs e)
{
saveFileDialog1.FileName = "report";
if (saveFileDialog1.ShowDialog() == DialogResult.Cancel)
{
return;
}
var conn = new MySqlConnection(Data.connString);
conn.Open();
var currentDate = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
var monthAgoDate = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd hh:mm:ss");
DocX document = DocX.Create(saveFileDialog1.FileName);
document.InsertParagraph("Отчет").Font("Times New Roman").FontSize(18)
.Alignment = Alignment.center;
document.InsertParagraph();
var countSuccesses =
conn.QueryFirst <string> (
$"select count(*) from link_archive where created between '{monthAgoDate}' and '{currentDate}'");
document.InsertParagraph($"За последний месяц было создано {countSuccesses} пар");
document.InsertParagraph();
var couplesList = conn.Query <forMeeting> (
$"select concat_ws(' ', A.firstname, A.lastname) as first_person, concat_ws(' ', B.firstname, B.lastname) as second_person from link_archive\njoin archive_person as A on A.id = link_archive.firstP_id\njoin archive_person as B on B.id = link_archive.secondP_id\nwhere created between '{monthAgoDate}' and '{currentDate}'").ToList();
Table couplesTable = document.AddTable(couplesList.Count + 1, 2);
couplesTable.Alignment = Alignment.both;
couplesTable.AutoFit = AutoFit.ColumnWidth;
couplesTable.SetWidthsPercentage(new[] { 50.0f, 50.0f });
couplesTable.Design = TableDesign.TableGrid;
couplesTable.Rows[0].Cells[0].Paragraphs[0].Append("Первый партнер");
couplesTable.Rows[0].Cells[1].Paragraphs[0].Append("Второй партнер");
for (int i = 0; i < couplesList.Count; i++)
{
couplesTable.Rows[i + 1].Cells[0].Paragraphs[0].Append(couplesList[i].first_person);
couplesTable.Rows[i + 1].Cells[1].Paragraphs[0].Append(couplesList[i].second_person);
}
document.InsertTable(couplesTable);
document.InsertParagraph();
var declinedCount = conn.QueryFirst <string> ($"select count(*) from archive_person\nwhere archive_person.id not in (select id from person) and archive_person.id not in (select firstP_id from link_archive where created between '{monthAgoDate}' and '{currentDate}') and archive_person.id not in (select secondP_id from link_archive where created between '{monthAgoDate}' and '{currentDate}')");
document.InsertParagraph($"От услуг отказалось {declinedCount} клиентов");
document.Save();
conn.Close();
Process.Start(saveFileDialog1.FileName);
}
private void BuildDocumentIndexStyle(List <DirectoryInfo> list)
{
var templatetbl = docx.Tables[0];
var c = 0;
var templaterow = templatetbl.Rows[0];
var ncols = templaterow.ColumnCount;
Row row = null;
Table tbl = null;
Paragraph alphaParagraph = null;
foreach (var pg in docx.Paragraphs)
{
if (pg.Text.Contains("{lastnamestartswith}"))
{
alphaParagraph = pg;
break;
}
}
var alphaindex = "@";
foreach (var m in list)
{
if (m.Person.LastName[0] != alphaindex[0])
{
tbl?.RemoveRow(0);
var pg = docx.InsertParagraph(alphaParagraph);
pg.KeepWithNextParagraph();
alphaindex = m.Person.LastName.Substring(0, 1);
pg.ReplaceText("{lastnamestartswith}", alphaindex);
tbl = docx.InsertTable(templatetbl);
c = 0;
}
Debug.Assert(tbl != null, "tbl != null");
if (c == 0) // start a new row
{
row = tbl.InsertRow(templaterow);
row.BreakAcrossPages = false;
tbl.Rows.Add(row);
}
Debug.Assert(row != null, "row != null");
var cell = row.Cells[c];
DoCellReplacements(cell, m);
if (++c == ncols)
{
c = 0; // start a new row
}
}
while (c > 0 && c < ncols && row != null)
{
DoEmptyCell(row.Cells[c++]);
}
tbl?.RemoveRow(0); // remove first row from last table worked on
docx.RemoveParagraph(alphaParagraph); // remove the alphaParagraph template
docx.Tables[0].Remove(); // remove the template table
docx.Paragraphs[0].Remove(trackChanges: false); // remove the empty paragraph after the template table
}
private void button1_Click(object sender, EventArgs e)
{
//创建文档
using (DocX document = DocX.Create(@"HelloWorld.docx"))
{
//插入段落
Paragraph p = document.InsertParagraph();
//段落加入文本，定义格式
p.Append("Hello World!") //内容
.Font(new Xceed.Words.NET.Font("宋体")) //字体格式
.FontSize(20) //字体大小
.Color(Color.Blue) //字体颜色
.Bold()
.Alignment = Alignment.center; //字体对其方式
p = document.InsertParagraph(); //创建段落
p.Append("CHINA")
.Font(new Xceed.Words.NET.Font("微软雅黑"))
.FontSize(18)
.Color(Color.Red);
//插入表格4x4，使用addtable后再inserttable
var table1 = document.AddTable(9, 4);
table1.Design = TableDesign.TableGrid;
for (int i = 0; i < 9; i++)
{
for (int k = 0; k < 4; k++)
{
table1.Rows[i].Cells[k].Paragraphs.First().InsertText(string.Format("第{0}行，第{1}列", i, k));
}
}
//合并单元格
table1.MergeCellsInColumn(0, 0, 1);
//////水平合并（合并第1行的第1、2个单元格）
//table1.ApplyHorizontalMerge(0, 0, 1);
//table1.Rows[0].Cells[0].Paragraphs[0].ChildObjects.Add(table.Rows[0].Cells[1].Paragraphs[0].ChildObjects[0]);
////垂直合并（合并第1列的第3、4个单元格）
//table.ApplyVerticalMerge(0,2, 3);
//table.Rows[2].Cells[0].Paragraphs[0].ChildObjects.Add(table.Rows[3].Cells[0].Paragraphs[0].ChildObjects[0]);
document.InsertTable(table1);
//追加行
document.Tables[0].InsertRow().Cells[1].Paragraphs.First().InsertText("新添11加的行");
//插入图片
p = document.InsertParagraph();
Xceed.Words.NET.Image image = document.AddImage(@"1.jpg");
Picture pic = image.CreatePicture();
p.InsertPicture(pic);
p.Alignment = Alignment.right;
//保存文档
document.Save();
}
MessageBox.Show("Done!");
}
private DocX addHeaderTable(DocX _doc)
{
DocX doc = _doc;
var columnWidths = new float[] { 270, 190 };
Table headerTable = doc.AddTable(15, columnWidths.Length);
Border lastCellBorder = new Border(BorderStyle.Tcbs_single, BorderSize.one, 0, System.Drawing.Color.Black);
ConfigHandler configHandler = new ConfigHandler();
Formatting format = getHeaderFormat();
Font font = null;
string fontName = configHandler.read(mainViewModel, "invoiceStandardFont");
if (!string.IsNullOrEmpty(fontName))
{
font = new Font(fontName);
}
else
{
font = new Font("Times New Roman");
}
headerTable.Alignment = Alignment.center;
headerTable.SetWidths(columnWidths);
headerTable.SetWidths(columnWidths);
headerTable.Design = TableDesign.TableGrid;
headerTable.AutoFit = AutoFit.ColumnWidth;
headerTable = setBorder(headerTable);
headerTable.Rows[0].Cells[1].Paragraphs[0].Append(mainViewModel.profileFirstName + " " + mainViewModel.profileLastName, format);
headerTable.Rows[1].Cells[0].Paragraphs[0].Append(mainViewModel.customerCompanyName, format);
headerTable.Rows[1].Cells[1].Paragraphs[0].Append(mainViewModel.profileAddress + " " + mainViewModel.profileAddressNumber, format);
headerTable.Rows[2].Cells[0].Paragraphs[0].Append(mainViewModel.customerAddress + " " + mainViewModel.customerAddressNumber, format);
headerTable.Rows[2].Cells[1].Paragraphs[0].Append(mainViewModel.profilePostalCode + " " + mainViewModel.profileCityName, format);
headerTable.Rows[3].Cells[0].Paragraphs[0].Append(mainViewModel.customerPostalCode + " " + mainViewModel.customerCityName, format);
headerTable.Rows[3].Cells[1].Paragraphs[0].Append("Tel: " + mainViewModel.profileTelephoneNumber, format);
headerTable.Rows[4].Cells[1].Paragraphs[0].Append("Mobil: " + mainViewModel.profileMobileNumber, format);
headerTable.Rows[5].Cells[1].Paragraphs[0].Append("Fax: " + mainViewModel.profileFaxNumber, format);
headerTable.Rows[6].Cells[1].Paragraphs[0].Append("E-Mail: " + mainViewModel.profileEMailAddress, format);
headerTable.Rows[7].Cells[1].Paragraphs[0].Append("", format); //empty
headerTable.Rows[8].Cells[1].Paragraphs[0].Append(mainViewModel.profileBankName, format);
headerTable.Rows[9].Cells[1].Paragraphs[0].Append("Konto Nr.: " + mainViewModel.profileBankAccountNumber, format);
headerTable.Rows[10].Cells[1].Paragraphs[0].Append("BLZ: " + mainViewModel.profileBankCodeNumber, format);
headerTable.Rows[11].Cells[1].Paragraphs[0].Append("IBAN: " + mainViewModel.profileIBAN, format);
headerTable.Rows[12].Cells[1].Paragraphs[0].Append("BIC: " + mainViewModel.profileBankCodeNumber, format);
headerTable.Rows[13].Cells[1].Paragraphs[0].Append("", format); //empty
headerTable.Rows[14].Cells[0].SetBorder(TableCellBorderType.Bottom, lastCellBorder);
headerTable.Rows[14].Cells[1].Paragraphs[0].Append(mainViewModel.profileCityName + ", den " + mainViewModel.invoiceDate, format);
headerTable.Rows[14].Cells[1].SetBorder(TableCellBorderType.Bottom, lastCellBorder);
doc.InsertTable(headerTable);
return(doc);
}
private void toolStripMenuItem2_Click(object sender, EventArgs e)
{
var companybik = Interaction.InputBox("Введите БИК компании: ");
if (companybik == "")
{
return;
}
saveFileDialog1.FileName = "list";
saveFileDialog1.ShowDialog();
var path = saveFileDialog1.FileName;
var conn = new MySqlConnection(Information.connString);
conn.Open();
DocX document = DocX.Create(path);
document.InsertParagraph("Список должностей").Font("Times New Roman").FontSize(18).Alignment = Alignment.left;
document.InsertParagraph();
var count = conn.QueryFirst <string> ($"select count(*) from position where company_id = {companybik}");
var positionList = conn.Query <Position> ($"select name, payment, conditions, requirements from position where company_id = {companybik}").ToList();
Table mainTable = document.AddTable(Convert.ToInt32(count) + 1, 4);
mainTable.Alignment = Alignment.both;
mainTable.AutoFit = AutoFit.ColumnWidth;
mainTable.SetWidthsPercentage(new[] { 25.0f, 25.0f, 25.0f, 25.0f });
mainTable.Design = TableDesign.None;
mainTable.Rows[0].Cells[0].Paragraphs[0].Append("Название должнолсти");
mainTable.Rows[0].Cells[1].Paragraphs[0].Append("Оплата");
mainTable.Rows[0].Cells[2].Paragraphs[0].Append("Условия");
mainTable.Rows[0].Cells[3].Paragraphs[0].Append("Требования");
for (int i = 0; i < Convert.ToInt32(count); i++)
{
mainTable.Rows[i + 1].Cells[0].Paragraphs[0].Append(positionList[i].name);
mainTable.Rows[i + 1].Cells[1].Paragraphs[0].Append(positionList[i].payment);
mainTable.Rows[i + 1].Cells[2].Paragraphs[0].Append(positionList[i].conditions);
mainTable.Rows[i + 1].Cells[3].Paragraphs[0].Append(positionList[i].requirements);
}
document.InsertTable(mainTable);
document.InsertParagraph();
var phone = conn.QueryFirstOrDefault <string> ($"select phone from company where bik = {companybik}");
document.InsertParagraph($"Звонить по телефону {phone}");
document.Save();
conn.Close();
Process.Start(path);
}
private static void InsertWaresTable(DocX doc, out Table waresTable, out Row r)
{
waresTable = doc.InsertTable(1, 6);
waresTable.TableCaption = "WARES_TABLE";
r = waresTable.Rows.First();
FillWaresTableInformationRow(waresTable, r);
}
/// <summary>
/// Add a Table in a document where its columns will have a specific width. In addition,
/// the left margin of the row cells will be removed for all rows except the first.
/// Finally, a blank border will be set for the table's top and bottom borders.
/// </summary>
public static void ColumnsWidth()
{
Console.WriteLine("\tColumnsWidth()");
// Create a document
using (DocX document = DocX.Create(TableSample.TableSampleOutputDirectory + @"ColumnsWidth.docx"))
{
// Add a title
document.InsertParagraph("Columns width").FontSize(15d).SpacingAfter(50d).Alignment = Alignment.center;
// Insert a title paragraph.
var p = document.InsertParagraph("In the following table, the cell's left margin has been removed for rows 2-6 as well as the top/bottom table's borders.").Bold();
p.Alignment = Alignment.center;
p.SpacingAfter(40d);
// Add a table in a document of 1 row and 3 columns.
var columnWidths = new float[] { 100f, 300f, 200f };
var t = document.InsertTable(1, columnWidths.Length);
// Set the table's column width and background
t.SetWidths(columnWidths);
t.Design = TableDesign.TableGrid;
t.AutoFit = AutoFit.Contents;
var row = t.Rows.First();
// Fill in the columns of the first row in the table.
for (int i = 0; i < row.Cells.Count; ++i)
{
row.Cells[i].Paragraphs.First().Append("Data " + i);
}
// Add rows in the table.
for (int i = 0; i < 5; i++)
{
var newRow = t.InsertRow();
// Fill in the columns of the new rows.
for (int j = 0; j < newRow.Cells.Count; ++j)
{
var newCell = newRow.Cells[j];
newCell.Paragraphs.First().Append("Data " + i);
// Remove the left margin of the new cells.
newCell.MarginLeft = 0;
}
}
// Set a blank border for the table's top/bottom borders.
var blankBorder = new Border(BorderStyle.Tcbs_none, 0, 0, Color.White);
t.SetBorder(TableBorderType.Bottom, blankBorder);
t.SetBorder(TableBorderType.Top, blankBorder);
document.Save();
Console.WriteLine("\tCreated: ColumnsWidth.docx\n");
}
}