private List <byte> CreateRequest(List <byte> buffer)
{
List <byte> bytes = new List <byte>();
BussinesTripInfo info = BussinesTripInfo.deserialise(buffer);
int documentID = db.getDocumentID();
string filename = DocumetGeneration.GenerateDocument(info, documentID);
db.AddDocument(info, filename, documentID);
bytes = File.ReadAllBytes(filename).ToList();
return(bytes);
}
public void AddDocument(BussinesTripInfo info, string fileName, int documentID)
{
string query = "insert into changes (name, surname, patronymic," +
"startdate, enddate, destinationPlace, reason, sender, fileName, documentID) values (\'" + info.name + "\', \'" + info.surname + "\', \'" + info.patronymic +
"\',\'" + info.from.ToString("yyyy-MM-dd") + "\',\'" + info.to.ToString("yyyy-MM-dd") + "\',\'" +
info.destinationPlace + "\', \'" + info.reason + "\',\'" + info.fullNameOfSender + "\',\'" + fileName + "\', " +
documentID.ToString() + ");";
SqlCommand command = new SqlCommand(query, conn);
command.ExecuteNonQuery();
}
public static string GenerateDocument(BussinesTripInfo info, int documentID)
{
string filename = (new Random()).NextDouble().GetHashCode().ToString() + ".docx";
DocX doc = DocX.Create(filename);
doc.InsertParagraph("Транспортное республиканское унитарное предприятие").
Font("Times New Roman").
FontSize(11).
Alignment = Xceed.Document.NET.Alignment.left;
doc.Paragraphs[0].SetLineSpacing(Xceed.Document.NET.LineSpacingType.After, 2);
doc.InsertParagraph("\t\"БАРАНОВИЧСКОЕ ОТДЕЛЕНИЕ").
Font("Times New Roman").
FontSize(10).
Alignment = Xceed.Document.NET.Alignment.left;
doc.InsertParagraph(" БЕЛОРУССКОЙ ЖЕЛЕНЗНОЙ ДОРОГИ\"").
Font("Times New Roman").
FontSize(10).
Alignment = Xceed.Document.NET.Alignment.left;
doc.InsertParagraph(" ВОЛКОВЫССКАЯ ДИСТАНЦИЯ ПУТИ").
Font("Times New Roman").
FontSize(10).
Bold().
Alignment = Xceed.Document.NET.Alignment.left;
doc.InsertParagraph(" ___________________№______________").
Font("Times New Roman").
FontSize(11).
Bold().
//UnderlineStyle(Xceed.Document.NET.UnderlineStyle.singleLine).
Alignment = Xceed.Document.NET.Alignment.left;
doc.Paragraphs[4].SetLineSpacing(Xceed.Document.NET.LineSpacingType.After, 20);
doc.InsertParagraph("КОМАНДИРОВОЧНОЕ УДОСТОВЕРЕНИЕ №" + documentID.ToString()).
Font("Times New Roman").
FontSize(13).
Bold().
Alignment = Xceed.Document.NET.Alignment.center;
doc.Paragraphs[5].SetLineSpacing(Xceed.Document.NET.LineSpacingType.After, 25);
//НУЖЕН КУРСИВ
doc.InsertParagraph("Выдано ______" + info.surname + " " + info.name + " " + info.patronymic + "________________").
Font("Times New Roman").
FontSize(11).
Bold().
//UnderlineStyle(Xceed.Document.NET.UnderlineStyle.singleLine).
Alignment = Xceed.Document.NET.Alignment.left;
doc.Paragraphs[6].SetLineSpacing(Xceed.Document.NET.LineSpacingType.After, 0);
doc.InsertParagraph(" (фамилия, имя, отчество)").
Font("Times New Roman").
FontSize(10).
//AppendLine(text.Trim()).
Alignment = Xceed.Document.NET.Alignment.left;
doc.InsertParagraph(info.job + "_________________________________________________").
Font("Times New Roman").
FontSize(11).
Bold().
UnderlineStyle(Xceed.Document.NET.UnderlineStyle.singleLine).
Alignment = Xceed.Document.NET.Alignment.left;
doc.Paragraphs[8].SetLineSpacing(Xceed.Document.NET.LineSpacingType.After, 0);
doc.InsertParagraph(" (наименование организации, выдавшей удостоверение)").
Font("Times New Roman").
FontSize(10).
//UnderlineStyle(Xceed.Document.NET.UnderlineStyle.singleLine).
Alignment = Xceed.Document.NET.Alignment.left;
doc.Paragraphs[9].SetLineSpacing(Xceed.Document.NET.LineSpacingType.After, 3);
doc.InsertParagraph("командированному в " + info.destinationPlace).
Font("Times New Roman").
FontSize(11).
//UnderlineStyle(Xceed.Document.NET.UnderlineStyle.singleLine).
Alignment = Xceed.Document.NET.Alignment.left;
doc.Paragraphs[10].SetLineSpacing(Xceed.Document.NET.LineSpacingType.After, 0);
doc.InsertParagraph("Срок командировки: сроком на " + (info.to - info.from).Days + " дней с " +
info.from.Date.ToString("dd.MM.yyyy") + " по " + info.to.Date.ToString("dd.MM.yyyy")).
Font("Times New Roman").
FontSize(11).
//UnderlineStyle(Xceed.Document.NET.UnderlineStyle.singleLine).
Alignment = Xceed.Document.NET.Alignment.left;
doc.Paragraphs[11].SetLineSpacing(Xceed.Document.NET.LineSpacingType.After, 5);
doc.InsertParagraph(info.reason).
Font("Times New Roman").
FontSize(11).
//UnderlineStyle(Xceed.Document.NET.UnderlineStyle.singleLine).
Alignment = Xceed.Document.NET.Alignment.left;
doc.Paragraphs[11].SetLineSpacing(Xceed.Document.NET.LineSpacingType.After, 10);
doc.InsertParagraph("_____________________________________________________________________").
Font("Times New Roman").
FontSize(11).
//UnderlineStyle(Xceed.Document.NET.UnderlineStyle.singleLine).
Alignment = Xceed.Document.NET.Alignment.left;
doc.Paragraphs[12].SetLineSpacing(Xceed.Document.NET.LineSpacingType.After, 10);
doc.InsertParagraph("Основание: приказ №322 ЛС от 19.07.2019г").
Font("Times New Roman").
FontSize(11).
//UnderlineStyle(Xceed.Document.NET.UnderlineStyle.singleLine).
Alignment = Xceed.Document.NET.Alignment.left;
doc.Paragraphs[13].SetLineSpacing(Xceed.Document.NET.LineSpacingType.After, 10);
doc.InsertParagraph(" Действительно по предъявлении паспорта, удострверения личности.").
Font("Times New Roman").
FontSize(11).
//UnderlineStyle(Xceed.Document.NET.UnderlineStyle.singleLine).
Alignment = Xceed.Document.NET.Alignment.left;
doc.Paragraphs[14].SetLineSpacing(Xceed.Document.NET.LineSpacingType.After, 15);
doc.InsertParagraph(info.fullNameOfSender).
Font("Times New Roman").
FontSize(12).
UnderlineStyle(Xceed.Document.NET.UnderlineStyle.singleLine).
Alignment = Xceed.Document.NET.Alignment.left;
doc.Paragraphs[15].SetLineSpacing(Xceed.Document.NET.LineSpacingType.After, 10);
doc.InsertParagraph(" М.П.").
Font("Times New Roman").
FontSize(8).
//UnderlineStyle(Xceed.Document.NET.UnderlineStyle.singleLine).
Alignment = Xceed.Document.NET.Alignment.left;
doc.Save();
return(filename);
}
