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(); }
protected override void internalStart() { { CP = new Control_Print(); CP.Elems.SetRowFromGrid(MyTools.GL_Auto); var DateSelect = new DateSelector(_negotiationAssistant.YMD); CP.Elems.SetFromGrid(DateSelect.View); CP.ShowDialog(); if (_negotiationAssistant.WorkerID == 0) { MessageBox.Show("Не выбран пробоотборщик!"); return; } _negotiationAssistant.YMD = MyTools.YMD_From_DateTime(DateSelect.dateTime); } Objecte obj = _negotiationAssistant.Objecte; Accredit acc = AdditionnTable.GetAccredit(); string sampler = _negotiationAssistant.Worker.Post_FIO; foreach (var one in obj.Wells) { book = TemplateStorage.WorkBook; Substitute = new CellExchange_Class(book.GetSheetAt(0)); var Details = obj.Client.Detail; Substitute.AddExchange("{абонент}", Details.FullName, 0); if (obj.Separate) { Substitute.AddExchange("{юридический адрес}", obj.Detail.LegalAdres, 0); } else { Substitute.AddExchange("{юридический адрес}", Helpers.LogicHelper.AdresLogic.FirstModel(Details.AdresLegalID).Adr, 0); } Substitute.AddExchange("{тип колодца}", new TypeWell(one.TypeWellID).FullName + " " + new TypeWell(one.TypeWellID).CurtName + '-' + one.Number, 0); Substitute.AddExchange("{место отбора}", obj.Adres.CutAdres(false), 0); Substitute.AddExchange("{аккредитация}", acc.Text, 0); Substitute.AddExchange("{дата аккредитации}", acc.YMDFrom, 0); Substitute.AddExchange("{пробоотборщик}", sampler, 0); //Substitute.AddExchange("{представитель абонента}", sample == null ? string.empty : sample.IDRepresentative > 0 ? new Representative(sample.IDRepresentative).Post_FIO : string.empty, 0); Substitute.Exchange(); Print("Акты", "акт отбора пробы " + new TypeWell(one.TypeWellID).FullName + ' ' + one.Number, EPathPrint.Documents); } }