/// <summary> /// Шаблон писем по миграции НП /// </summary> /// <param name="connectionstringtemplate">Строка соединения</param> /// <param name="path">Путь к папке сохранения</param> /// <param name="model">Модель миграции</param> public void MigrationDoc(string connectionstringtemplate, string path, MigrationParse model) { SqlLibaryIfns.SqlModelReport.SqlTemplate.ModelTemplate template = new SqlLibaryIfns.SqlModelReport.SqlTemplate.ModelTemplate(); var setting = new FullSetting { UseTemplate = new UseTemplate() { IdTemplate = 3 } }; var documenttemplate = template.Template(connectionstringtemplate, setting); model.N280 = template.Inspection(connectionstringtemplate, "7746").Inspection.N280; var ul46 = model.ReportMigration.Where(code => (code.Kpp ?? string.Empty) != "" && code.Problem.Contains("Запись о налогоплательщике в ЦУН не содержит ОКТМО")).ToArray(); var fullpath = path + "7746" + "_ЮЛ_" + Constant.WordConstant.Formatword; GenerateDoc(fullpath, documenttemplate, ul46, model, 1, "7746"); setting.UseTemplate.IdTemplate = 2; documenttemplate = template.Template(connectionstringtemplate, setting); model.ReportMigration.GroupBy(x => x.CodeIfns).ToList().ForEach(key => { model.N280 = template.Inspection(connectionstringtemplate, key.Key).Inspection.N280; List <ReportMigration[]> report = new List <ReportMigration[]>(); var fl = model.ReportMigration.Where(code => code.CodeIfns == key.Key && string.IsNullOrWhiteSpace(code.Kpp)).ToArray(); var ul = model.ReportMigration.Where(code => code.CodeIfns == key.Key && (code.Kpp ?? string.Empty) != "" && !code.Problem.Contains("Запись о налогоплательщике в ЦУН не содержит ОКТМО")).ToArray(); if (fl.Length >= 1) { report.Add(fl); } if (ul.Length >= 1) { report.Add(ul); } foreach (var param in report) { int isshablon; if (!string.IsNullOrWhiteSpace(param[0].Kpp)) { isshablon = 1; fullpath = path + key.Key + "_ЮЛ_" + Constant.WordConstant.Formatword; } else { isshablon = 2; fullpath = path + key.Key + "_ФЛ_ИП_" + Constant.WordConstant.Formatword; } GenerateDoc(fullpath, documenttemplate, param, model, isshablon, key.Key); } report.Clear(); }); }
public OutBdkModel(string connectionstringtemplate, string connectionstringtaxes, string path, FullSetting setting) { ModelFull modelFull = new ModelFull(); FileLogica.FileLogica logica = new FileLogica.FileLogica(); SqlLibaryIfns.SqlModelReport.SqlTemplate.ModelTemplate template = new SqlLibaryIfns.SqlModelReport.SqlTemplate.ModelTemplate(); logica.FileDelete(path); ConectionStringTemplate = connectionstringtemplate; PathSave = path; Report = modelFull.ReportBdk(connectionstringtaxes, connectionstringtemplate, setting); DocumentTemplate = template.Template(connectionstringtemplate, setting); }
/// <summary> /// Шаблон писем по миграции НП /// </summary> /// <param name="connectionStringTemplate">Строка соединения</param> /// <param name="path">Путь к папке сохранения</param> /// <param name="model">Модель миграции</param>\ /// <param name="postAddress">Модель адреса</param> public void MigrationDocument(string connectionStringTemplate, string path, MigrationParse model, string postAddress = null) { ServiceRestLotus lotus = new ServiceRestLotus(); SqlLibaryIfns.SqlModelReport.SqlTemplate.ModelTemplate template = new SqlLibaryIfns.SqlModelReport.SqlTemplate.ModelTemplate(); var setting = new FullSetting { UseTemplate = new UseTemplate() { IdTemplate = 3 } }; var documentTemplate = template.Template(connectionStringTemplate, setting); model.N280 = template.Inspection(connectionStringTemplate, "7746").Inspection.N280; var ul46 = model.ReportMigration.Where(code => (code.Kpp ?? string.Empty) != "" && code.Problem.Contains("Запись о налогоплательщике в ЦУН не содержит ОКТМО")).ToArray(); var fullPath = path + "7746" + "_ЮЛ_" + Constant.WordConstant.FormatWord; GenerateDoc(fullPath, documentTemplate, ul46, model, 1, "7746"); setting.UseTemplate.IdTemplate = 2; documentTemplate = template.Template(connectionStringTemplate, setting); model.ReportMigration.GroupBy(x => x.CodeIfns).ToList().ForEach(key => { model.N280 = template.Inspection(connectionStringTemplate, key.Key).Inspection.N280; List <ReportMigration[]> report = new List <ReportMigration[]>(); var fl = model.ReportMigration.Where(code => code.CodeIfns == key.Key && string.IsNullOrWhiteSpace(code.Kpp)).ToArray(); var ul = model.ReportMigration.Where(code => code.CodeIfns == key.Key && (code.Kpp ?? string.Empty) != "" && !code.Problem.Contains("Запись о налогоплательщике в ЦУН не содержит ОКТМО")).ToArray(); if (fl.Length >= 1) { report.Add(fl); } if (ul.Length >= 1) { report.Add(ul); } foreach (var param in report) { int isTemplate; string fileName; if (!string.IsNullOrWhiteSpace(param[0].Kpp)) { isTemplate = 1; fileName = key.Key + "_ЮЛ_" + Constant.WordConstant.FormatWord; fullPath = path + fileName; } else { isTemplate = 2; fileName = key.Key + "_ФЛ_ИП_" + Constant.WordConstant.FormatWord; fullPath = path + fileName; } GenerateDoc(fullPath, documentTemplate, param, model, isTemplate, key.Key); //Отправка на сервис в Lotus if (postAddress != null) { Letter modeLetter = new Letter() { Attachments = new Attachment[1], DestinationCodes = new string[1] }; modeLetter.Attachments[0] = new Attachment { FileName = fileName, Extension = Constant.WordConstant.FormatWord, Data = File.ReadAllBytes(fullPath) }; modeLetter.Id = Guid.NewGuid().ToString(); modeLetter.Subscriber = documentTemplate.Templates.Stone.Stone3; modeLetter.DestinationCodes[0] = key.Key; modeLetter.File = "07-10"; modeLetter.Author = null; lotus.ServicePostLotus(postAddress, modeLetter); } } report.Clear(); }); }