/// <summary>Приложение</summary>
private void Applications()
{
foreach (var one in selections)
{
Well well = one.Well;
ISheet sheet = book.GetSheet("Приложение").CopySheet(well.PresentNumber != string.Empty ? well.PresentNumber : "без_номера");
Substitute = new CellExchange_Class(sheet);
//Substitute.AddExchange("{объект}", obj.Adres + ' ' + well.PresentNumber, 0);
Substitute.AddExchange("{абонент}", client.Detail.FullName, 0);
Substitute.AddExchange("{колодец}", $"{well.FullName} - {well.PresentNumber}", 0);
Substitute.AddExchange("{адрес}", (client.Objects.Any() ? obj.Adres.CutAdres(false) : string.Empty), 0);
Substitute.AddExchange("{номер отбора}", one.FormatNumber, 0);
{
var works = AdditionnTable.GetSigner(data.ETypeTemplate.Extract, "Приложение");
Substitute.AddExchange("{должность}", works.Post, 0);
Substitute.AddExchange("{фио}", works.FIO, 0);
}
tableSelection = new TableSelection(obj, sample);
tableSelection.CreateTable(SearchCellFromMark(sheet, "{таблица}", false), one);
tableSelection.Signature(SearchCellFromMark(sheet, "{пример}", false), Substitute);
Substitute.AddExchange("{полное наименование колодца}", well.FullName + ' ' + well.PresentNumber, 0);
Substitute.Exchange();
}
book.RemoveSheetAt(book.GetSheetIndex("Приложение"));
}
private void LoadTable()
{
sheet = book.GetSheet("Таблица");
Substitute = new CellExchange_Class(sheet);
IRow row = SearchRowFromMark(sheet, StaticMark.abonent, false);
var selectionWells = Helpers.LogicHelper.SelectionWellLogic.Find(DateControl_Class.SelectMonth, 1);
foreach (var selectionWell in selectionWells)
{
sheet.ShiftRows(row.RowNum + 3, sheet.LastRowNum, 0);
row.CopyRowTo(row.RowNum + 3);
sheet.GetRow(row.RowNum + 1).CopyRowTo(row.RowNum + 4);
sheet.GetRow(row.RowNum + 2).CopyRowTo(row.RowNum + 5);
}
foreach (var selectionWell in selectionWells.OrderBy(x => x.Number))
{
Client client = selectionWell.Objecte.Client;
ClientName(client, false);
WellNumber(selectionWell);
Substitute.AddExchange(mark.number_sample,
$"{selectionWell.Number}-С-{MyTools.YearMonth_From_YM(MyTools.YM_From_YMDHM(selectionWell.YMDHM), MyTools.EDateTimeTypes.DivisionSymbol, DivisionSymbol: "/")}",
1);
row = SearchRowFromMark(sheet, "{таблица}");
tableSelection = new TableSelection(selectionWell.Objecte, selectionWell.Sample);
tableSelection.CreateTable(SearchCellFromMark(sheet, "{таблица}", false), selectionWell);
}
tableSelection.Signature(SearchCellFromMark(sheet, "{пример}", false), Substitute);
ResizeWidth(sheet, MyTools.ETypeFormatBook.Horizontal, tableSelection.table);
MonthYearSelect();
Worker worker = AdditionnTable.GetSigner(data.ETypeTemplate.Journal, "Таблица");
Substitute.AddExchange(mark.fio, worker.FIO, 1);
Substitute.AddExchange(mark.job, worker.Post, 1);
Substitute.Exchange();
}
