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