/// <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 LoadTitle(SelectionWell selectionWell)
{
Substitute = new CellExchange_Class(sheet);
Accredit accredit = AdditionnTable.GetAccredit();
Substitute.AddExchange(mark.acred, $"{accredit.Text}\nВыдан {accredit.YMDFrom}", 0);
Worker work = AdditionnTable.GetSigner(data.ETypeTemplate.Protocol, "Протокол");
Substitute.AddExchange(mark.fio_nac, work.FIO, 0);
Substitute.AddExchange(mark.number_prot, selectionWell.FormatNumber, 0);
Substitute.AddExchange(mark.abon, selectionWell.Objecte.Client.Detail.FullName, 0);
Substitute.AddExchange(mark.yr_adr, Helpers.LogicHelper.AdresLogic.FirstModel(selectionWell.Objecte.Client.Detail.AdresLegalID).Adr.CutAdres(false), 0);
Substitute.AddExchange(mark.type_well, G.TypeWell.Rows.Get <string>(selectionWell.Well.TypeWellID, C.TypeWell.FullName), 0);
Substitute.AddExchange(mark.select_adr, selectionWell.Objecte.Adres.CutAdres(false), 0);
Substitute.AddExchange(mark.date_select, MyTools.StringDate_From_YMDHMS(selectionWell.YMDHM, MyTools.EInputDate.YMDHM, MyTools.EInputDate.YMD), 0);
Substitute.AddExchange(mark.time_select, MyTools.StringDate_From_YMDHMS(selectionWell.YMDHM, MyTools.EInputDate.YMDHM, MyTools.EInputDate.YMDHM), 0);
Substitute.AddExchange(mark.repres, new Representative(selectionWell.Sample.RepresentativeID).Post_FIO, 0);
Substitute.AddExchange(mark.year, DateControl_Class.SelectYear, 0);
MonthYear();
NumberFolder(_selectionWells.Select(x => x.Objecte.NumberFolder).ToArray());
work = AdditionnTable.GetSigner(data.ETypeTemplate.Protocol, "Протокол");
Substitute.AddExchange(mark.fio, work.FIO, 0);
Substitute.AddExchange(mark.job, work.Post, 0);
int day, month;
MyTools.Y_M_D_From_YMD(StaticDate.SelectDate, out month, out month, out day);
Substitute.AddExchange(mark.day, day, 0);
Substitute.AddExchange(mark.month, MyTools.Month_From_M_C_R(month, Reg: MyTools.ERegistor.ToLower), 0);
Substitute.AddExchange(mark._month, month.ToString("00"), 0);
Substitute.Exchange();
}
private void LoadTitle()
{
sheet = book.GetSheet("Титульник");
Substitute = new CellExchange_Class(sheet);
Worker worker = AdditionnTable.GetSigner(data.ETypeTemplate.Journal, "Титульник");
Substitute.AddExchange(mark.fio, worker.FIO, 1);
Substitute.AddExchange(mark.job, worker.Post, 1);
Substitute.Exchange();
}
/// <summary>Обработка письма</summary>
private void Letter()
{
Substitute = new CellExchange_Class(book.GetSheet("Письмо"));
ClientName(client);
ObjectAdres(obj, true);
MonthYearSelect();
NumberFolder(obj.NumberFolder);
Substitute.AddExchange("{год месячного объёма}", DateControl_Class.SelectYear - 1, 0);
Substitute.AddExchange("{листов}", selections.Length, 0);
NumberFolder(obj.NumberFolder);
var works = AdditionnTable.GetSigner(data.ETypeTemplate.Extract, "Письмо");
Substitute.AddExchange("{должность}", works.Post, 0);
Substitute.AddExchange("{фио}", works.FIO, 0);
Substitute.Exchange();
}
private void Letter()
{
sheet = book.GetSheet("Письмо");
if (!R621 && !R644)
{
book.RemoveSheetAt(book.GetSheetIndex("Письмо"));
return;
}
Substitute = new CellExchange_Class(sheet);
ClientName(obj.Client);
ObjectAdres(obj, true);
MonthYearSelect();
NumberFolder(obj.NumberFolder);
var worker = AdditionnTable.GetSigner(data.ETypeTemplate.CalculationFees, "Письмо");
Substitute.AddExchange(mark.job, worker.Post, 1);
Substitute.AddExchange(mark.fio, worker.FIO, 1);
int Radder621 = SearchRowFromMark(sheet, mark.adder621).RowNum;
Resolution resolution = PollutionBase_Class.AllResolution.First(x => x.CurtName.Contains("621"));
ResolutionClarify(resolution, R621);
if (R621)
{
Substitute.AddExchange(mark.adder621, GetNormDoc(resolution), 1);
}
else
{
Substitute.AddExchange(mark.adder621, e => { e.Row.ZeroHeight = true; }, 1);
}
resolution = PollutionBase_Class.AllResolution.First(x => x.CurtName.Contains("644"));
ResolutionClarify(resolution, R644);
if (R644)
{
Substitute.AddExchange(mark.adder644, GetNormDoc(resolution), 1);
}
else
{
Substitute.AddExchange(mark.adder644, e => { e.Row.ZeroHeight = true; }, 1);
}
Substitute.Exchange();
ResizeHeight(sheet, Radder621, Radder621 + 3);
}
private void LoadCap(string name)
{
Substitute = new CellExchange_Class(sheet);
Substitute.AddExchange("{месяц}", MyTools.Month_From_M_C_R(MyTools.M_From_YM(DateControl_Class.SelectMonth), Reg: MyTools.ERegistor.ToLower), 0);
Substitute.AddExchange("{год}", DateControl_Class.SelectYear, 0);
MonthYear();
Worker workers = AdditionnTable.GetSigner(data.ETypeTemplate.Registry, "директор");
Substitute.AddExchange("{должность директора}", workers.Post, 0);
Substitute.AddExchange("{фио директора}", workers.rFIO, 0);
workers = AdditionnTable.GetSigner(data.ETypeTemplate.Registry, "подписывающий");
Substitute.AddExchange("{должность}", workers.Post, 0);
Substitute.AddExchange("{фио}", workers.FIO, 0);
LoadTextTemplate(sheet, name, 1);
Substitute.AddExchange("{итоговая сумма}", summa.ToMoney(), 0);
Substitute.Exchange();
}
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();
}
protected override void internalStart()
{
Objecte obj = _negotiationAssistant.Objecte;
book = TemplateStorage.WorkBook;
Substitute = new CellExchange_Class(book.GetSheetAt(0));
ClientName(_negotiationAssistant.Objecte.Client);
NumberFolder(obj.NumberFolder);
#region Подписывающий
var works = AdditionnTable.GetSigner(data.ETypeTemplate.LetterNotification, "Письмо");
Substitute.AddExchange("{должность}", works.Post, 0);
Substitute.AddExchange("{ФИО}", works.FIO, 0);
#endregion
#region адрес/дата
ObjectAdres(obj, true);
CP = new Control_Print();
CP.Elems.SetRowFromGrid(MyTools.GL_Auto);
var DateSelect = new DateSelector(_negotiationAssistant.YMD);
CP.Elems.SetFromGrid(DateSelect.View);
CP.ShowDialog();
if (DateSelect.dateTime == null)
{
return;
}
_negotiationAssistant.YMD = MyTools.YMD_From_DateTime(DateSelect.dateTime);
Substitute.AddExchange("{дата отбора}", MyTools.YearMonthDay_From_YMD(DateSelect.dateTime), 0);
#endregion
Substitute.AddExchange("{адрес отбора}", obj.Adres, 0);
Substitute.Exchange();
Print("Письма", "Письмо", EPathPrint.Documents);
}
private void LoadTitle()
{
Substitute = new CellExchange_Class(sheet);
ClientName(this._selectionWell.Objecte.Client, false);
ClientAdres(this._selectionWell.Objecte.Client, false);
ObjectAdres(this._selectionWell.Objecte, false);
Substitute.AddExchange(mark.period,
$"{MyTools.YearMonth_From_YM(StartYM, MyTools.EDateTimeTypes.BeautifulWords)} - {MyTools.YearMonth_From_YM(StartYM + MonthCount - 1, MyTools.EDateTimeTypes.BeautifulWords)}",
0);
Worker worker = AdditionnTable.GetSigner(data.ETypeTemplate.InspectionResult, "Результат");
Substitute.AddExchange(mark.fio, worker.FIO, 0);
Substitute.AddExchange(mark.job, worker.Post, 0);
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(8, 8, 6, 8 + (MonthCount > 6 ? MonthCount / 2 : 0) + (ShowNorms ? 2 : 0)));
Substitute.Exchange();
int span = 2 + MonthCount + (ShowNorms ? 2 : 0);
for (int i = 0; i < 5; i++)
{
sheet.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(i, i, 0, span));
}
}