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