private void btnUndo_Click(object sender, EventArgs e)
{
Word.Document document = Globals.ThisAddIn.Application.ActiveDocument;
object numTimes3 = Convert.ToInt32(txtUndoNumber.Text);
document.Undo(ref numTimes3);
}
//</Snippet56>
//---------------------------------------------------------------------
//<Snippet62>
private void RangeFormat()
{
// Set the Range to the first paragraph.
Word.Document document = this.Application.ActiveDocument;
Word.Range rng = document.Paragraphs[1].Range;
// Change the formatting. To change the font size for a right-to-left language,
// such as Arabic or Hebrew, use the Font.SizeBi property instead of Font.Size.
rng.Font.Size = 14;
rng.Font.Name = "Arial";
rng.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
rng.Select();
MessageBox.Show("Formatted Range");
// Undo the three previous actions.
object numTimes3 = 3;
document.Undo(ref numTimes3);
rng.Select();
MessageBox.Show("Undo 3 actions");
// Apply the Normal Indent style.
object indentStyle = "Normal Indent";
rng.set_Style(ref indentStyle);
rng.Select();
MessageBox.Show("Normal Indent style applied");
// Undo a single action.
object numTimes1 = 1;
document.Undo(ref numTimes1);
rng.Select();
MessageBox.Show("Undo 1 action");
}
private void GenAppForLeave(object parametrs)
{
Random gen = new Random();
string[] paramsData = (string[])parametrs;
string filename = paramsData[0];
string templateFileName = paramsData[1];
string newPdfFilePath = paramsData[2];
string tempDirectory = "temp";
ObjExcel = new Excel.Application();
//Открываем книгу.
try
{
xlWorkbook = ObjExcel.Workbooks.Open(filename, 0, true, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
}
catch (Exception ex)
{
OnWriteLog?.Invoke(ex.Message + "\r\n");
}
if (xlWorkbook == null)
{
OnWriteLog?.Invoke("Не удалось открыть файл " + filename + "\r\n");
OnGenerateAppForLeaveEnd?.Invoke();
return;
}
//Выбираем таблицу(лист).
ObjExcel.Visible = false;
xlWorksheet = (Excel.Worksheet)xlWorkbook.Sheets[1];
xlRange = xlWorksheet.UsedRange;
//Создаём новый Word.Application
app = new Word.Application();
//Загружаем документ
object wordFileName = templateFileName;
object falseValue = false;
object trueValue = true;
object missing = Type.Missing;
try
{
doc = app.Documents.Open(ref wordFileName, ref missing, ref trueValue,
ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing);
}
catch (Exception ex)
{
OnWriteLog?.Invoke(ex.Message + "\r\n");
}
if (doc == null)
{
OnWriteLog?.Invoke("Не удалось открыть файл " + wordFileName + "\r\n");
app.Quit();
OnGenerateAppForLeaveEnd?.Invoke();
return;
}
int rowCount = xlRange.Rows.Count;
//int colCount = 4;
Directory.CreateDirectory(newPdfFilePath + "\\" + tempDirectory);
for (int i = 2; i <= rowCount; i++)
{
if (isClose)
{
break;
}
object times = 1;
while (doc.Undo(ref times))
{
}
string chiefNumber = xlRange.Cells[i, "C"].Value2.ToString();
string chiefFIO = xlRange.Cells[i, "D"].Value2.ToString();
string employeeFIO = xlRange.Cells[i, "B"].Value2.ToString();
string employeeNumber = xlRange.Cells[i, "A"].Value2.ToString();
string pdfFileName = newPdfFilePath + "\\" + tempDirectory + "\\" + employeeNumber + "_" + chiefNumber + ".pdf";
OnWriteLog?.Invoke("Save file " + pdfFileName);
//Console.Write("Save file " + pdfFileName);
//Очищаем параметры поиска
app.Selection.Find.ClearFormatting();
app.Selection.Find.Replacement.ClearFormatting();
//Задаём параметры замены и выполняем замену.
object findText = "<ФИО Руководителя>";
object replaceWith = chiefFIO;
object replace = Word.WdReplace.wdReplaceAll;
app.Selection.Find.Execute(ref findText, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing, ref replaceWith,
ref replace, ref missing, ref missing, ref missing, ref missing);
findText = "<ФИО Сотрудника>";
replaceWith = employeeFIO;
app.Selection.Find.Execute(ref findText, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing, ref replaceWith,
ref replace, ref missing, ref missing, ref missing, ref missing);
//Генерация даты отпуска
DateTime DateStart = new DateTime(2018, 1, 1);
DateTime DateEnd = new DateTime(2019, 1, 1);
int range = (DateEnd - DateStart).Days;
DateTime LeaveDate = DateStart.AddDays(gen.Next(range));
findText = "<Дата начала отпуска>";
replaceWith = LeaveDate.ToShortDateString();
app.Selection.Find.Execute(ref findText, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing, ref replaceWith,
ref replace, ref missing, ref missing, ref missing, ref missing);
//Количество дней отпуска
int DaysCount = gen.Next(40);
findText = "<N>";
replaceWith = DaysCount.ToString();
app.Selection.Find.Execute(ref findText, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing, ref replaceWith,
ref replace, ref missing, ref missing, ref missing, ref missing);
//Генерация даты написания заявления
if (LeaveDate.AddDays(-14) <= DateStart)
{
DateStart = DateStart.AddDays(-14);
}
range = (LeaveDate.AddDays(-14) - DateStart).Days;
DateTime SignDate = DateStart.AddDays(gen.Next(range));
findText = "<Дата написания заявления>";
replaceWith = SignDate.ToShortDateString();
app.Selection.Find.Execute(ref findText, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing, ref replaceWith,
ref replace, ref missing, ref missing, ref missing, ref missing);
findText = "<Таб.№ работника>";
replaceWith = employeeNumber;
app.Selection.Find.Execute(ref findText, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing, ref replaceWith,
ref replace, ref missing, ref missing, ref missing, ref missing);
app.Visible = false;
//Сохраняем pdf
object fileName2 = pdfFileName;
object saveFormat = Word.WdSaveFormat.wdFormatPDF;
try
{
app.ActiveDocument.SaveAs2(ref fileName2,
ref saveFormat, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref missing, ref missing);
//Создаём архив и добавляем в него файл
string zipPath = newPdfFilePath + "\\" + chiefNumber + ".zip";
if (!File.Exists(zipPath))
{
string directoryPath = newPdfFilePath + "\\" + chiefNumber;
Directory.CreateDirectory(directoryPath);
ZipFile.CreateFromDirectory(directoryPath, zipPath);
Directory.Delete(directoryPath);
}
using (ZipArchive modFile = ZipFile.Open(zipPath, ZipArchiveMode.Update))
{
modFile.CreateEntryFromFile((string)fileName2, employeeNumber + "_" + chiefNumber + ".pdf");
}
}
catch (Exception ex)
{
OnWriteLog?.Invoke("\r\n" + ex.Message + "\r\n");
break;
}
File.Delete((string)fileName2);
OnWriteLog?.Invoke(" OK\r\n");
OnRecordProcessed?.Invoke();
}
Directory.Delete(newPdfFilePath + "\\" + tempDirectory);
object saveChanges = Word.WdSaveOptions.wdDoNotSaveChanges;
doc.Close(ref saveChanges, ref missing, ref missing);
doc = null;
app.Quit();
OnGenerateAppForLeaveEnd?.Invoke();
}
public CreaterCertificates(string templatePath, string savePath, List <Student> students)
{
if (students.Count > 0)
{
Word.Application app = new Word.Application();
var newDocument = app.Documents.Open(templatePath, ReadOnly: false);
var r = new Random();
string path = $"{savePath}\\Сертификаты_{DateTime.Now.ToString("dd-MMM-yyyy")}_{DateTimeOffset.UtcNow.ToUnixTimeSeconds()}";
newDocument.SaveAs2(path);
foreach (var s in students)
{
Student student;
//using (var _context = new ApplicationContext())
//{
// student = _context.Students.Include(x => x.Person).Include(x => x.Module.Group.Course).First(x => x.ID == s.ID);
//}
Word.Document doc = app.Documents.Open(templatePath, ReadOnly: false);
doc.Activate();
var range = doc.Range();
range.Find.Execute(FindText: "#УЧЕНИК", Replace: WdReplace.wdReplaceAll, ReplaceWith: s.Person.FullName);
range.Find.Execute(FindText: "#КУРС", Replace: WdReplace.wdReplaceAll, ReplaceWith: s.Module.Group.Course.Name);
range.Find.Execute(FindText: "#ГРУППА", Replace: WdReplace.wdReplaceAll, ReplaceWith: s.Module.Group.Title);
var shapes = doc.Shapes;
foreach (Microsoft.Office.Interop.Word.Shape shape in shapes)
{
try
{
var initialText = shape.TextFrame.TextRange.Text;
var resultingText = initialText
.Replace("#УЧЕНИК", s.Person.FullName)
.Replace("#КУРС", s.Module.Group.Course.Name)
.Replace("#ГРУППА", s.Module.Group.Title);
if (initialText != resultingText)
{
shape.TextFrame.TextRange.Text = resultingText;
}
}
catch
{
continue;
}
}
doc.ActiveWindow.Selection.WholeStory();
doc.ActiveWindow.Selection.Copy();
newDocument.ActiveWindow.Selection.Paste();
object times = 1;
while (doc.Undo(ref times))
{
}
doc.Close();
Marshal.ReleaseComObject(doc);
}
WordHelpers.PrintDocument(newDocument);
newDocument.Paragraphs.Last.Range.Delete();
newDocument.SaveAs2(path);
app.Quit();
Marshal.ReleaseComObject(app);
Marshal.ReleaseComObject(newDocument);
GC.Collect();
}
}
