public void TestMethod1() { ExcelTool.ExcelCreator Excel = new ExcelCreator(); Excel.CreateExcelFile(); }
public ActionResult View(string dateBegin, string dateEnd, string employeeFilter, string command) { if (!ModelState.IsValid) { return(RedirectToAction("View")); } if (!string.IsNullOrEmpty(dateBegin) && !string.IsNullOrEmpty(dateEnd)) { _erService.DateBegin = Convert.ToDateTime(dateBegin); _erService.DateEnd = Convert.ToDateTime(dateEnd).AddDays(1); } _erService.EmployeeFilter = employeeFilter; EmployeeReportViewModel model; if (command == "Загрузить Excel") { var excelCreator = new ExcelCreator(); model = _erService.GetData(); var fullPath = excelCreator.CreateFile(model); return(File(new FileStream(fullPath, FileMode.Open), "application/vnd.ms-excel", "Отчёт по сотрудникам.xlsx")); } model = _erService.GetData(); return(View(model)); }
static void Main(string[] args) { log4net.Config.XmlConfigurator.Configure(); intra.gradual.financial.ValidateLogin validateLogin = new intra.gradual.financial.ValidateLogin(); validateLogin.Username = "******"; validateLogin.Password = "******"; intra.gradual.financial.PosicaoCotistaWS ws = new intra.gradual.financial.PosicaoCotistaWS(); ws.ValidateLoginValue = validateLogin; intra.gradual.financial.PosicaoCotistaViewModel[] vm = ws.Exporta(null, null, null); //MessageBox.Show("Recebeu " + vm.Length + " registros"); int len = vm.Length; DataSet dataSet = new DataSet(); //DataTableReader xreader = dataSet.CreateDataReader(); DataTable tabela = parseToDataTable <intra.gradual.financial.PosicaoCotistaViewModel>(vm); dataSet.Tables.Add(tabela); if (ExcelCreator.CreateExcel(dataSet, @"c:\temp\fundos.xlsx", "Fundos")) { } }
public ActionResult Excel(string json) { List <ExcelTemplate> data = JsonConvert.DeserializeObject <List <ExcelTemplate> >(json); DataSet dataSet = Util.ToDataSet(data); ExcelCreator excelCreator = new ExcelCreator(); return(File(excelCreator.Create(dataSet), "application/vnd.ms-excel", "kartexport.xls")); }
private void button1_Click(object sender, EventArgs e) { PlateCalculator calc = new PlateCalculator(order); calc.CalculateBoards(); ExcelCreator excel = new ExcelCreator(calc.Plates, @"C:\Users\casp4\Documents"); excel.CreateExcel(); }
public string Excel([System.Web.Http.FromBody] UploadData uploadData) { List <ExcelTemplate> data = JsonConvert.DeserializeObject <List <ExcelTemplate> >(uploadData.data); DataSet dataSet = Util.ToDataSet(data); ExcelCreator excelCreator = new ExcelCreator(); byte[] bytes = excelCreator.Create(dataSet); string[] fileInfo = byteArrayToFileInfo(bytes, "xls"); return(Request.Url.GetLeftPart(UriPartial.Authority) + "/Temp/" + fileInfo[1]); }
public void EsportaExcel(string filepath, string nomeRuolo, List <ConfrontoConoscenzaCompetenza> confronti) { ExcelCreator excel = new ExcelCreator(); excel.NomeRuolo = nomeRuolo; excel.Dati = confronti; excel.PunteggiMassimi = new ParametriConfronto(); excel.CreaExcel(filepath); }
public async Task <byte[]> AddToExcelVacancy(int skip, int amount, VacancySearchModel searchModel, VacancySortModel sortModel) { var vacancies = await vacancyService.Search(skip, amount, searchModel, sortModel); var excelVacancyList = vacancies.Select(ConvertToExcelModel).ToList(); var result = ExcelCreator.GenerateExcel(excelVacancyList); return(result); }
public async Task <byte[]> AddToExcelCandidate(int skip, int amount, CandidateSearchModel searchOptions, CandidateSortModel sortModel) { var candidates = await candidateService.Find(skip, amount, searchOptions, sortModel); var excelCandidateList = candidates.Select(ConvertToExcelModel).ToList(); var result = ExcelCreator.GenerateExcel(excelCandidateList); return(result); }
public void ExcelThing() { order.AddBoard(new Board(1000, br)); order.AddBoard(new Board(1100, br)); order.AddBoard(new Board(1200, br)); order.AddBoard(new Board(1300, br)); order.AddBoard(new Board(1400, br)); pc.CalculateBoards(); ExcelCreator ec = new ExcelCreator(pc.Plates, @"C:\Users\Mathias\Documents\PathToExcel"); //ec.CreateExcel(); }
public ActionResult ExportToExcel() { // Read session for filterstring .To get same table result on index when export is clicked. var filterStr = HttpContext.Session.GetString("FilterStr"); var stream = ExcelCreator.CreateExcelFileStream(_service.GetProductsByFilter(filterStr).Result.Select(p => new { p.Code, p.Name, p.Price })); var responseStream = new FileStreamResult(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") { FileDownloadName = $"Export.xlsx" }; return(responseStream); }
private string GenExcel(string name, List <ExcelTemplate> xls) { try { System.Data.DataSet dataSet = Util.ToDataSet(xls); ExcelCreator excelCreator = new ExcelCreator(); byte[] bytes = excelCreator.Create(dataSet); string[] fileInfo = byteArrayToFileInfo(name, bytes, "xls"); return(Request.Url.GetLeftPart(UriPartial.Authority) + "/Temp/" + fileInfo[1]); } catch (Exception e) { _log.FatalFormat("Can't generate excel file: {0}", e); throw e; } }
private void toolStripButton2_Click(object sender, EventArgs e) { if (dataGridView1.DataSource != null) { ExcelCreator excel = new ExcelCreator((DataTable)dataGridView1.DataSource); saveFileDialog1.Filter = "xls files (*.xls)|*.xls"; if (saveFileDialog1.ShowDialog() == DialogResult.OK) { excel.Save(saveFileDialog1.FileName); } } else { MessageBox.Show("List is empty!"); } }
static void Main(string[] args) { var ps = new ParserService(db); //string dir = string.Format(@"C:\temp\images"); //DirectoryInfo di = new DirectoryInfo(dir); //di.GetFiles().ToList().ForEach(file => //{ // var image = ps.resizeImage(40, 40, file.FullName); // image.Save(file.FullName); //}); //return; int orderId = 1;// ps.ParseCategories(); ExcelCreator excelCreator = new ExcelCreator(db, orderId); excelCreator.Generate(); }
public string Excel(string json) { _log.DebugFormat("Received json: {0}", json); // try to decode input string to see if it is base64 encoded try { byte[] decoded = Convert.FromBase64String(json); json = System.Text.Encoding.UTF8.GetString(decoded); _log.DebugFormat("json after decode: {0}", json); } catch (Exception e) { _log.DebugFormat("Could not decode base64. Will treat as non-base64 encoded: {0}", e.Message); } List <ExcelTemplate> data = JsonConvert.DeserializeObject <List <ExcelTemplate> >(json); DataSet dataSet = Util.ToDataSet(data); ExcelCreator excelCreator = new ExcelCreator(); byte[] bytes = excelCreator.Create(dataSet); string[] fileInfo = byteArrayToFileInfo(bytes, "xls"); return(Request.Url.GetLeftPart(UriPartial.Authority) + "/Temp/" + fileInfo[1]); }
/// <summary> /// Gera o relatorio de usuarios logados no HB e saldo /// quebrou o esquema, pq tem que buscar a relacao de contas x assessor do oracle pra cruzar com /// a consulta do MSSQL /// </summary> /// <param name="functionName"></param> public void GenerateLogadosHBSaldo(string functionName) { try { logger.Info("GenerateLogadosHBSaldo(" + functionName + ")"); if (!dctParametros.ContainsKey(functionName)) { logger.Error("GenerateLogadosHBSaldo(" + functionName + ") nao ha parametros definidos"); return; } BaseParam parametros = dctParametros[functionName]; string scriptPath = ConfigurationManager.AppSettings["DiretorioScripts"].ToString(); string sheetPath = ConfigurationManager.AppSettings["DiretorioPlanilhas"].ToString(); string rede = ""; if (ConfigurationManager.AppSettings["DiretorioRede"] != null) { rede = ConfigurationManager.AppSettings["DiretorioRede"].ToString(); } string scriptFilename = scriptPath + Path.DirectorySeparatorChar + parametros.ScriptFile; string scriptAssessores = scriptPath + Path.DirectorySeparatorChar + "getassess.sql"; string excelFile = sheetPath + Path.DirectorySeparatorChar + parametros.ExcelFilePrefix + "-" + DateTime.Now.ToString("yyyMMdd-HHmmss") + ".xlsx"; logger.Info("GenerateLogadosHBSaldo(" + functionName + ") Carregando script: " + scriptFilename); PersistenciaDB db = new PersistenciaDB(); string idlogins = "select distinct(IdLogin) from tb_logacesso where Sistema='Portal' and DataLogIn > DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE()))"; DataSet dsLogins = db.ExecutarScriptSqlServer("ControleAcesso", idlogins); string idClientes = "select C.cd_codigo,L.id_login from tb_cliente_conta C, tb_cliente L where C.cd_sistema = 'BOL' and L.id_cliente = C.id_cliente"; DataSet dsClientes = db.ExecutarScriptSqlServer("Cadastro", idClientes); string scriptAssessor = File.ReadAllText(scriptAssessores); logger.Info("GenerateLogadosHBSaldo(" + functionName + ") obtendo tabela assessores"); DataSet dsAss = db.ExecutarScriptRetDS(scriptAssessor); logger.Info("GenerateLogadosHBSaldo(" + functionName + ") executando script"); string scriptSQL = File.ReadAllText(scriptFilename); DataSet ds = db.ExecutarScriptSqlServer(parametros.ConnStringName, scriptSQL); if (ds.Tables.Count == 0 || (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count == 0)) { logger.Error("GenerateLogadosHBSaldo(" + functionName + ") Nao ha registros para se gerar uma planilha"); return; } var query = from record in ds.Tables[0].AsEnumerable() join assessor in dsAss.Tables[0].AsEnumerable() on record.Field <string>("Cliente") equals assessor.Field <string>("Cliente") select new { Cliente = record.Field <string>("Cliente").Trim(), Nome = assessor.Field <string>("Nome").Trim(), CpfCnpj = assessor.Field <string>("CPF/CNPJ").Trim(), Assessor = assessor.Field <string>("Assessor").Trim(), NomeAssessor = assessor.Field <string>("Nome Assessor").Trim(), Titulo = record.Field <string>("Titulo").Trim(), Aplicacao = record.Field <string>("Aplicacao").Trim(), Vencimento = record.Field <string>("Vencimento").Trim(), Taxa = record.Field <string>("Taxa").Trim(), Quantidade = record.Field <string>("Quantidade").Trim(), Indice = record.Field <string>("Indice").Trim(), ValorOriginal = record.Field <string>("ValorOriginal").Trim(), IRRF = record.Field <string>("IRRF").Trim(), IOF = record.Field <string>("IOF").Trim(), SaldoLiquido = record.Field <string>("SaldoLiquido").Trim(), DataAtualizacao = record.Field <string>("DataAtualizacao").Trim(), }; DataSet ds1 = new DataSet(); ds1.Tables.Add(query.ToDataTable()); logger.Info("GenerateVctosRendaFixa(" + functionName + ") dataset carregado, gerando planilha"); if (ExcelCreator.CreateExcel(ds1, excelFile, parametros.WorksheetName)) { logger.Info("GenerateVctosRendaFixa(" + functionName + ") planilha gerada com sucesso"); string subject = parametros.Subject + " - " + DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss"); string message = "Planilha " + functionName + " gerada as " + DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss"); message += "\n\n"; message += "Gravado em [" + excelFile + "]"; if (!String.IsNullOrEmpty(rede)) { message += "\n\n"; message += "Disponivel na pasta de rede: [" + rede + "]"; } if (!String.IsNullOrEmpty(parametros.Message)) { message += "\n\n" + parametros.Message; } message += "\n\n"; string[] anexos = new string[1]; anexos[0] = excelFile; MailUtil.EnviarPlanilhaPorEmail(parametros.MailFrom, parametros.MailTo, null, null, subject, message, anexos); } try { if (!String.IsNullOrEmpty(rede)) { FileInfo excelInfo = new FileInfo(excelFile); rede += Path.DirectorySeparatorChar; rede += excelInfo.Name; logger.Info("GenerateVctosRendaFixa(" + functionName + ") Copiando arquivo [" + excelFile + "] para [" + rede + "]"); File.Copy(excelFile, rede); } else { logger.Info("GenerateVctosRendaFixa(" + functionName + ") Chave appsettings 'DiretorioRede' nao existe para copia do arquivo!"); } } catch (Exception ex) { logger.Error("GenerateVctosRendaFixa(" + functionName + "): Erro ao copiar para pasta de rede"); logger.Error("GenerateVctosRendaFixa(" + functionName + "): " + ex.Message, ex); } } catch (Exception ex) { logger.Error("GenerateVctosRendaFixa(" + functionName + "): " + ex.Message, ex); } }
public void SetUp() { _excelCreator = new ExcelCreator(); }
/// <summary> /// /// </summary> /// <param name="functionName"></param> public void GerarBase(string functionName) { try { logger.Info("GerarBase(" + functionName + ")"); if (!dctParametros.ContainsKey(functionName)) { logger.Error("GerarBase(" + functionName + ") nao ha parametros definidos"); return; } BaseParam parametros = dctParametros[functionName]; string scriptPath = ConfigurationManager.AppSettings["DiretorioScripts"].ToString(); string sheetPath = ConfigurationManager.AppSettings["DiretorioPlanilhas"].ToString(); string rede = ""; if (ConfigurationManager.AppSettings["DiretorioRede"] != null) { rede = ConfigurationManager.AppSettings["DiretorioRede"].ToString(); } string scriptFilename = scriptPath + Path.DirectorySeparatorChar + parametros.ScriptFile; string excelFile = sheetPath + Path.DirectorySeparatorChar + parametros.ExcelFilePrefix + "-" + DateTime.Now.ToString("yyyMMdd-HHmmss") + ".xlsx"; logger.Info("GerarBase(" + functionName + ") Carregando script: " + scriptFilename); string scriptSQL = File.ReadAllText(scriptFilename); PersistenciaDB db = new PersistenciaDB(); logger.Info("GerarBase(" + functionName + ") executando script"); DataSet ds = db.ExecutarScriptRetDS(scriptSQL); if (ds.Tables.Count == 0 || (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count == 0)) { logger.Error("GerarBase(" + functionName + ") Nao ha registros para se gerar uma planilha"); return; } logger.Info("GerarBase(" + functionName + ") dataset carregado, gerando planilha"); if (ExcelCreator.CreateExcel(ds, excelFile, parametros.WorksheetName)) { logger.Info("GerarBase(" + functionName + ") planilha gerada com sucesso"); string subject = parametros.Subject + " - " + DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss"); string message = "Planilha " + functionName + " gerada as " + DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss"); message += "\n\n"; message += "Gravado em [" + excelFile + "]"; if (!String.IsNullOrEmpty(rede)) { message += "\n\n"; message += "Disponivel na pasta de rede: [" + rede + "]"; } if (!String.IsNullOrEmpty(parametros.Message)) { message += "\n\n" + parametros.Message; } message += "\n\n"; string [] anexos = new string[1]; anexos[0] = excelFile; MailUtil.EnviarPlanilhaPorEmail(parametros.MailFrom, parametros.MailTo, null, null, subject, message, anexos); } try { if (!String.IsNullOrEmpty(rede)) { FileInfo excelInfo = new FileInfo(excelFile); rede += Path.DirectorySeparatorChar; rede += excelInfo.Name; logger.Info("GerarBase(" + functionName + ") Copiando arquivo [" + excelFile + "] para [" + rede + "]"); File.Copy(excelFile, rede); } else { logger.Info("GerarBase(" + functionName + ") Chave appsettings 'DiretorioRede' nao existe para copia do arquivo!"); } } catch (Exception ex) { logger.Error("GerarBase(" + functionName + "): Erro ao copiar para pasta de rede"); logger.Error("GerarBase(" + functionName + "): " + ex.Message, ex); } } catch (Exception ex) { logger.Error("GerarBase(" + functionName + "): " + ex.Message, ex); } }
private void btGerarPlanilha_Click(object sender, EventArgs e) { btGerarPlanilha.Enabled = false; DataTable deta = new DataTable("MDTD"); deta.Columns.Add("CodigoAgenteCustodia", typeof(System.String)); deta.Columns.Add("CodigoCliente", typeof(System.String)); deta.Columns.Add("DigitoCodigoCliente", typeof(System.String)); deta.Columns.Add("CpfCpnjCliente", typeof(System.String)); deta.Columns.Add("TipoTitulo", typeof(System.String)); deta.Columns.Add("DataVctoTitulo", typeof(System.String)); deta.Columns.Add("CodigoSelic", typeof(System.String)); deta.Columns.Add("CodigoISIN", typeof(System.String)); deta.Columns.Add("TipoTransacao", typeof(System.String)); deta.Columns.Add("IDContabilTransacao", typeof(System.String)); deta.Columns.Add("QuantitadeTitulosTransacao", typeof(System.String)); deta.Columns.Add("NumeroProtocolo", typeof(System.String)); deta.Columns.Add("Usuario", typeof(System.String)); deta.Columns.Add("AgenteCustodiaContraparte", typeof(System.String)); deta.Columns.Add("PrecoUnitarioTransacao", typeof(System.String)); deta.Columns.Add("ValorTransacao", typeof(System.String)); deta.Columns.Add("ValorTaxaAgente", typeof(System.String)); deta.Columns.Add("ValorTotal", typeof(System.String)); deta.Columns.Add("PrecoUnitarioOriginal", typeof(System.String)); deta.Columns.Add("ValorOriginal", typeof(System.String)); deta.Columns.Add("DataPrecoOriginal", typeof(System.String)); deta.Columns.Add("OrigemSaldo", typeof(System.String)); deta.Columns.Add("DataOperacao", typeof(System.String)); deta.Columns.Add("DataMovimento", typeof(System.String)); deta.Columns.Add("DataFinalDoacaoCupom", typeof(System.String)); deta.Columns.Add("ValorTxSemBMFBovespa", typeof(System.String)); deta.Columns.Add("ValorTxSemAgenteCustodia", typeof(System.String)); deta.Columns.Add("PercentualReinvestimento", typeof(System.String)); deta.Columns.Add("ProtocoloAgendamento", typeof(System.String)); deta.Columns.Add("DataEmissaoTitulo", typeof(System.String)); deta.Columns.Add("DataPagtoCupomAnterior", typeof(System.String)); deta.Columns.Add("DataPagtoPrimeiroCupom", typeof(System.String)); deta.Columns.Add("PUPrimeiroCupomJurosPago", typeof(System.String)); deta.Columns.Add("DataPgtoCupomAnteriorCompra", typeof(System.String)); deta.Columns.Add("DataLiquidacaoCompra", typeof(System.String)); deta.Columns.Add("Filler", typeof(System.String)); deta.AcceptChanges(); //try //{ logger.Info("Inicio processamento arquivo MDTD_01_IDENTIFICACAO_X"); string[] lines = File.ReadAllLines(arquivo); long tamstrut = Marshal.SizeOf(typeof(MDTD_01_IDENTIFICACAO_X)); foreach (string line in lines) { string tipo = line.Substring(0, 2); string registro = line.Substring(2); if (tipo.Equals("01")) { DataRow row = deta.NewRow(); MDTD_01_IDENTIFICACAO_X strut = Utilities.MarshalFromStringBlock <MDTD_01_IDENTIFICACAO_X>(line); row["CodigoAgenteCustodia"] = Convert.ToInt32(strut.CodigoAgenteCustodia.ByteArrayToString()).ToString(); row["CodigoCliente"] = Convert.ToInt32(strut.CodigoCliente.ByteArrayToString()).ToString(); row["DigitoCodigoCliente"] = Convert.ToInt32(strut.DigitoCodigoCliente.ByteArrayToString()).ToString(); row["CpfCpnjCliente"] = strut.CpfCpnjCliente.ByteArrayToString(); row["TipoTitulo"] = strut.TipoTitulo.ByteArrayToString(); row["DataVctoTitulo"] = strut.DataVctoTitulo.ByteArrayToString(); row["CodigoSelic"] = strut.CodigoSelic.ByteArrayToString(); row["CodigoISIN"] = strut.CodigoISIN.ByteArrayToString(); row["TipoTransacao"] = strut.TipoTransacao.ByteArrayToString(); row["IDContabilTransacao"] = strut.IDContabilTransacao.ByteArrayToString(); row["QuantitadeTitulosTransacao"] = strut.QuantitadeTitulosTransacao.ByteArrayToDecimal(2).ToString(); row["NumeroProtocolo"] = strut.NumeroProtocolo.ByteArrayToString(); row["Usuario"] = strut.Usuario.ByteArrayToString(); row["AgenteCustodiaContraparte"] = strut.CodigoAgenteCustodia.ByteArrayToString().ToString(); row["PrecoUnitarioTransacao"] = strut.PrecoUnitarioTransacao.ByteArrayToDecimal(2).ToString(); row["ValorTransacao"] = strut.ValorTransacao.ByteArrayToDecimal(2).ToString(); row["ValorTaxaAgente"] = strut.ValorTaxaAgente.ByteArrayToDecimal(2).ToString(); row["ValorTotal"] = strut.ValorTotal.ByteArrayToDecimal(2).ToString(); row["PrecoUnitarioOriginal"] = Convert.ToInt32(strut.PrecoUnitarioOriginal.ByteArrayToDecimal(2)).ToString(); row["ValorOriginal"] = strut.ValorOriginal.ByteArrayToDecimal(2).ToString(); row["DataPrecoOriginal"] = strut.DataPrecoOriginal.ByteArrayToString(); row["OrigemSaldo"] = strut.OrigemSaldo.ByteArrayToString(); row["DataOperacao"] = strut.DataOperacao.ByteArrayToString(); row["DataMovimento"] = strut.DataMovimento.ByteArrayToString(); row["DataFinalDoacaoCupom"] = strut.DataFinalDoacaoCupom.ByteArrayToString(); row["ValorTxSemBMFBovespa"] = strut.ValorTxSemBMFBovespa.ByteArrayToDecimal(2).ToString(); row["ValorTxSemAgenteCustodia"] = strut.ValorTxSemAgenteCustodia.ByteArrayToDecimal(2).ToString(); row["PercentualReinvestimento"] = strut.PercentualReinvestimento.ByteArrayToString(); row["ProtocoloAgendamento"] = strut.ProtocoloAgendamento.ByteArrayToString(); row["DataEmissaoTitulo"] = strut.DataEmissaoTitulo.ByteArrayToString(); row["DataPagtoCupomAnterior"] = strut.DataPagtoCupomAnterior.ByteArrayToString(); row["DataPagtoPrimeiroCupom"] = strut.DataPagtoPrimeiroCupom.ByteArrayToString(); row["PUPrimeiroCupomJurosPago"] = strut.PUPrimeiroCupomJurosPago.ByteArrayToDecimal(2).ToString(); row["DataPgtoCupomAnteriorCompra"] = strut.DataPgtoCupomAnteriorCompra.ByteArrayToString(); row["DataLiquidacaoCompra"] = strut.DataLiquidacaoCompra.ByteArrayToString(); row["Filler"] = strut.Filler.ByteArrayToString(); deta.Rows.Add(row); } } DataSet ds1 = new DataSet("DS1"); ds1.Tables.Add(deta); ds1.AcceptChanges(); if (ExcelCreator.CreateExcel(ds1, excelFile, "Sheet1")) { logger.Info("Movimento Diario Tesouro Direto planilha gerada com sucesso"); string subject = " Movimento Diario Tesouro Direto - " + DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss"); string message = "Planilha Movimento Diario Tesouro Direto gerada as " + DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss"); message += "\n\n"; message += "Gravado em [" + excelFile + "]"; if (!String.IsNullOrEmpty(rede)) { message += "\n\n"; message += "Disponivel na pasta de rede: [" + rede + "]"; } //if (!String.IsNullOrEmpty(parametros.Message)) //{ // message += "\n\n" + parametros.Message; //} message += "\n\n"; string[] anexos = new string[1]; anexos[0] = excelFile; MailUtil.EnviarPlanilhaPorEmail("*****@*****.**", "*****@*****.**", null, null, subject, message, anexos); } //try //{ // if (!String.IsNullOrEmpty(rede)) // { // FileInfo excelInfo = new FileInfo(excelFile); // rede += Path.DirectorySeparatorChar; // rede += excelInfo.Name; // logger.Info("GenerateVctosRendaFixa(" + functionName + ") Copiando arquivo [" + excelFile + "] para [" + rede + "]"); // File.Copy(excelFile, rede); // } // else // logger.Info("GenerateVctosRendaFixa(" + functionName + ") Chave appsettings 'DiretorioRede' nao existe para copia do arquivo!"); //} //catch (Exception ex) //{ // logger.Error("GenerateVctosRendaFixa(" + functionName + "): Erro ao copiar para pasta de rede"); // logger.Error("GenerateVctosRendaFixa(" + functionName + "): " + ex.Message, ex); //} //} //catch (Exception ex) //{ // logger.Error("_processa_ItauFJ_03_Cotacoes(): " + ex.Message, ex); //} btGerarPlanilha.Enabled = true; }