public static void PrihZaDen()
{
DataBaseTables data = new DataBaseTables();
data.dtDepFill();
table = data.dtDepartments;
PrihOtch();
}
public static void PrihOtch()
{
word.Application application = new word.Application();
word.Document document = application.Documents.Add(Visible: true);
word.Range range = document.Range(0, 0);
file_name = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory) + "\\СпДолж_" + "Список должностей"
+ DateTime.Now.ToString("_hh_mm_ss_dd_MM_yyyy") + ".docx";
try
{
document.Sections.PageSetup.LeftMargin
= application.CentimetersToPoints(Convert.ToSingle(2.5));
document.Sections.PageSetup.RightMargin
= application.CentimetersToPoints(Convert.ToSingle(1));
document.Sections.PageSetup.TopMargin
= application.CentimetersToPoints(Convert.ToSingle(2));
document.Sections.PageSetup.BottomMargin
= application.CentimetersToPoints(Convert.ToSingle(1.5));
range.Text = "Служба технической поддержки IT Liga";
range.ParagraphFormat.Alignment
= word.WdParagraphAlignment.wdAlignParagraphCenter;
range.ParagraphFormat.SpaceAfter = 1;
range.ParagraphFormat.SpaceBefore = 1;
range.ParagraphFormat.LineSpacingRule = word.WdLineSpacing.wdLineSpaceSingle;
range.Font.Name = "Times New Roman";
range.Font.Size = 16;
document.Paragraphs.Add();
document.Paragraphs.Add();
word.Paragraph Name_Doc = document.Paragraphs.Add();
Name_Doc.Format.Alignment = word.WdParagraphAlignment.wdAlignParagraphLeft;
Name_Doc.Range.Font.Name = "Times New Roman";
Name_Doc.Range.Font.Size = 14;
Name_Doc.Range.Text = "Список должностей";
document.Paragraphs.Add();
document.Paragraphs.Add();
foreach (DataRow row in table.Rows)
{
DataBaseTables data = new DataBaseTables();
data.qrPositions += " where Naim_Depart = '" + row["Naim_Depart"].ToString() + "'";
data.dtPositFill();
table2 = data.dtPositions;
Name_Doc.Range.Font.Name = "Times New Roman";
Name_Doc.Range.Text = "Отдел: " + row["Naim_Depart"].ToString();
document.Paragraphs.Add();
word.Paragraph pTable = document.Paragraphs.Add();
word.Table tbDanTab = document.Tables.Add(pTable.Range, table2.Rows.Count + 1,
table2.Columns.Count);
tbDanTab.Borders.InsideLineStyle = word.WdLineStyle.wdLineStyleSingle;
tbDanTab.Borders.OutsideLineStyle = word.WdLineStyle.wdLineStyleSingle;
tbDanTab.Cell(1, 1).Range.Text = "Наименование должности";
tbDanTab.Cell(1, 2).Range.Text = "Оклад";
tbDanTab.Range.Font.Size = 12;
tbDanTab.Range.Font.Name = "Times New Roman";
tbDanTab.Rows.Alignment = WdRowAlignment.wdAlignRowCenter;
tbDanTab.Columns[1].Width = 250;
tbDanTab.Columns[2].Width = 150;
for (int i = 2; i <= tbDanTab.Rows.Count; i++)
{
for (int j = 1; j <= tbDanTab.Columns.Count; j++)
{
tbDanTab.Cell(i, j).Range.Text
= table2.Rows[i - 2][j - 1].ToString();
}
}
document.Paragraphs.Add();
}
document.Paragraphs.Add();
Name_Doc.Range.Font.Name = "Times New Roman";
Name_Doc.Range.Font.Size = 14;
Name_Doc.Format.Alignment = word.WdParagraphAlignment.wdAlignParagraphRight;
Name_Doc.Range.Text = "Руководитель отдела кадров ____________ (_________________)";
document.Paragraphs.Add();
Name_Doc.Range.Text = "Менеджер по персоналу ____________ (_________________)";
document.Paragraphs.Add();
Name_Doc.Range.Text = "Генеральный директор ____________ (_________________)";
document.Paragraphs.Add();
Name_Doc.Range.Text = DateTime.Now.ToLongDateString();
}
catch
{
}
finally
{
document.SaveAs2(file_name, word.WdSaveFormat.wdFormatDocumentDefault);
document.Close();
application.Quit();
}
}
