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