public static void CreateRecordInJournal(FormC01 formc01Item) { formc01 = formc01Item; fileName = ArchiveTransport.PutETSJournalC01(formc01Item.bin, formc01Item.code); FillDocument(); }
public void CreateTemplate(FormC01 form, string saveTo) { var FILE_NAME = "formC01.docx"; System.IO.File.Copy(FileArchiveTransport.GetFormC01TemplateFileName(), saveTo + "\\" + FILE_NAME, true); var word = new WordService(saveTo + "\\" + FILE_NAME, false); word.SetCell(1, 1, 2, form.broker.name); word.SetCell(1, 2, 2, form.broker.code); word.SetCell(2, 2, 1, form.code); word.SetCell(2, 2, 2, form.bin); word.SetCell(2, 2, 3, form.name); word.SetCell(2, 2, 5, form.codeG + " " + form.codeS); word.SetCell(2, 2, 6, form.codeP); word.CloseDocument(true); word.CloseWord(true); }
private void OnWriteInJournal() { var formC01Service = new FormC01Service(FileArchiveTransport.GetJournalC01FileName()); var formC01 = new FormC01(); formC01.code = OurCompany.code; formC01.bin = BIN; formC01.date = Convert.ToDateTime(DateTxt); formC01.name = OurCompany.name; formC01.broker = OurCompany; var wherePath = Service.GetDirectory(); if (wherePath != null) { formC01 = formC01Service.InsertCompany(formC01); formC01Service.CreateTemplate(formC01, wherePath.FullName); } }
public static FormC01 FillC01(string brokerBin, string code, string companyBin, string companyName, string serial) { FormC01 formc01 = new FormC01(); OurCompany ourCompany = new OurCompany(); OurCompaniesConsts ourCompanies = new OurCompaniesConsts(); ourCompanies.GetListOurCompanies(); ourCompany = ourCompanies.GetListOurCompanies().Where(x => x.bin == brokerBin).First(); formc01.code = code; formc01.bin = companyBin; formc01.date = DateTime.Now; formc01.name = companyName; formc01.broker = ourCompany; formc01.number = serial.Length == 3 ? serial : "0" + serial; formc01.codeG = formc01.broker.code.ToLower() + "g" + formc01.number; formc01.codeP = formc01.broker.code.ToLower() + "p" + formc01.number; formc01.codeS = formc01.broker.code.ToLower() + "s" + formc01.number; return(formc01); }
public FormC01 InsertCompany(FormC01 form) { var excel = new ExcelService(path); excel.SetActiveSheetByName(form.code.ToUpper()); var rowsCount = excel.GetRowsCount(); string number = null; for (var iRow = rowsCount; iRow > 0; iRow--) { if (excel.GetCell(iRow, "B") != "") { number = excel.GetCell(iRow, "B"); } } if (string.IsNullOrEmpty(number)) { return(null); } var iNumber = 0; iNumber = int.Parse(number); number = (iNumber + 1).ToString(); if (number.Length == 1) { number = number.Insert(0, "00"); } else if (number.Length == 2) { number = number.Insert(0, "0"); } else if (number.Length > 3) { number = "1"; } form.number = number; form.codeG = form.broker.code.ToLower() + "g" + form.number; form.codeP = form.broker.code.ToLower() + "p" + form.number; form.codeS = form.broker.code.ToLower() + "s" + form.number; for (var iRow = rowsCount; iRow > 0; iRow--) { if (!string.IsNullOrEmpty(excel.GetCell(iRow, "B"))) { excel.SetCells(iRow + 1, "A", form.date); excel.SetCells(iRow + 1, "B", form.number); excel.SetCells(iRow + 1, "C", form.name); excel.SetCells(iRow + 1, "D", form.bin); excel.SetCells(iRow + 1, "E", form.code); excel.SetCells(iRow + 1, "F", form.codeG + " " + form.codeS); excel.SetCells(iRow + 1, "G", form.codeP); break; } } excel.CloseWorkbook(true); excel.CloseExcel(); return(form); }