public static string GerarRelatorio() { ApagarRelatorio(); Spartacus.Database.Generic database; Spartacus.Reporting.Report relatorio; System.Data.DataTable tabela = new System.Data.DataTable("relatorio"); Spartacus.Database.Command cmd = new Spartacus.Database.Command(); cmd.v_text = "select 'Relatório de Cotações do Dia Curso de Programação CSharp' as titulo, * from cotacoes where dia = #dia#"; cmd.AddParameter("dia", Spartacus.Database.Type.STRING); cmd.SetValue("dia", DateTime.Now.ToString("dd/MM/yyyy")); try { database = new Spartacus.Database.Sqlite("cotacoes.db"); tabela = database.Query(cmd.GetUpdatedText(), "relatorio"); if (tabela.Rows.Count != 0) { System.Collections.Generic.List<Spartacus.Reporting.Field> v_fields; v_fields = new System.Collections.Generic.List<Spartacus.Reporting.Field>(); v_fields.Add(new Spartacus.Reporting.Field("dia", "Data", Spartacus.Reporting.FieldAlignment.CENTER, 10, Spartacus.Database.Type.STRING)); v_fields.Add(new Spartacus.Reporting.Field("codmoeda", "Cód. Moeda", Spartacus.Reporting.FieldAlignment.CENTER, 10, Spartacus.Database.Type.STRING)); v_fields.Add(new Spartacus.Reporting.Field("tipomoeda", "Tipo Moeda", Spartacus.Reporting.FieldAlignment.CENTER, 10, Spartacus.Database.Type.STRING)); v_fields.Add(new Spartacus.Reporting.Field("siglamoeda", "Sigla Moeda", Spartacus.Reporting.FieldAlignment.CENTER, 10, Spartacus.Database.Type.STRING)); v_fields.Add(new Spartacus.Reporting.Field("taxacompra", "Taxa Compra", Spartacus.Reporting.FieldAlignment.RIGHT, 15, Spartacus.Database.Type.REAL)); v_fields.Add(new Spartacus.Reporting.Field("taxavenda", "Taxa Venda", Spartacus.Reporting.FieldAlignment.RIGHT, 15, Spartacus.Database.Type.REAL)); v_fields.Add(new Spartacus.Reporting.Field("parcompra", "Par. Compra", Spartacus.Reporting.FieldAlignment.RIGHT, 15, Spartacus.Database.Type.REAL)); v_fields.Add(new Spartacus.Reporting.Field("parvenda", "Par. Venda", Spartacus.Reporting.FieldAlignment.RIGHT, 15, Spartacus.Database.Type.REAL)); relatorio = new Spartacus.Reporting.Report(tabela, "titulo", v_fields); relatorio.Execute(); relatorio.Save("relatorio.pdf"); return "Relatório gerado com sucesso!"; } else { return "não foi encontrada informações sobre o dia atual!"; } } catch (Spartacus.Database.Exception ex) { return String.Format("Ocorreu um erro ao gerar o relatório: {0}", ex.v_message); } }
private void OnParamExecuteClick(object sender, System.EventArgs e) { try { this.v_report = new Spartacus.Reporting.Report(this.v_currentcode, this.v_currentfile); for (int k = 0; k < this.v_report.v_cmd.v_parameters.Count; k++) { this.v_report.v_cmd.SetValue(k, this.v_paramwindow.v_containers[k].GetValue()); } this.v_report.v_progress.ProgressEvent += new Spartacus.Utils.ProgressEventClass.ProgressEventHandler(this.OnProgress); this.v_report.Execute(); if (this.v_report.v_table.Rows.Count == 0) { Spartacus.Forms.Messagebox.Show("O relatorio nao foi salvo em PDF porque nao tem dados.", "Sem dados!", Spartacus.Forms.Messagebox.Icon.HAND); } else { this.v_report.Save(this.v_reportpdffile.GetValue()); } this.v_progressbar.SetValue("Pronto!", 100); } catch (Spartacus.Database.Exception exc) { Spartacus.Forms.Messagebox.Show(exc.v_message, "Spartacus.Database.Exception", Spartacus.Forms.Messagebox.Icon.ERROR); System.Environment.Exit(-1); } catch (Spartacus.Reporting.Exception exc) { Spartacus.Forms.Messagebox.Show(exc.v_message, "Spartacus.Reporting.Exception", Spartacus.Forms.Messagebox.Icon.ERROR); System.Environment.Exit(-1); } catch (Spartacus.Forms.Exception exc) { Spartacus.Forms.Messagebox.Show(exc.v_message, "Spartacus.Forms.Exception", Spartacus.Forms.Messagebox.Icon.ERROR); System.Environment.Exit(-1); } catch (System.Exception exc) { Spartacus.Forms.Messagebox.Show(exc.Message, exc.GetType().ToString(), Spartacus.Forms.Messagebox.Icon.ERROR); System.Environment.Exit(-1); } }
/// <summary> /// Adiciona um relatório. /// </summary> /// <param name="p_report">Relatório.</param> public void Add(Spartacus.Reporting.Report p_report) { this.v_reports.Add(p_report); }
/// <summary> /// Adiciona um relatório associado a um nome de arquivo PDF de saída. /// </summary> /// <param name="p_report">Relatório.</param> /// <param name="p_filename">Nome do arquivo PDF de saída.</param> public void Add(Spartacus.Reporting.Report p_report, string p_filename) { this.v_reports.Add(p_report); this.v_filenames.Add(p_filename); }
private void OnMainExecuteClick(object sender, System.EventArgs e) { System.Data.DataRow v_row = this.v_maingrid.CurrentRow(); try { this.v_currentcode = int.Parse(v_row["code"].ToString()); this.v_currentfile = v_row["xmlfile"].ToString(); this.v_report = new Spartacus.Reporting.Report(this.v_currentcode, this.v_currentfile); this.v_paramwindow = new Spartacus.Forms.Window( System.Configuration.ConfigurationManager.AppSettings["param.title"].ToString(), 500, 500, this.v_mainwindow ); for (int k = 0; k < this.v_report.v_cmd.v_parameters.Count; k++) { if (this.v_report.v_cmd.v_parameters[k].v_type == Spartacus.Database.Type.DATE) { Spartacus.Forms.Datetimepicker v_param = new Spartacus.Forms.Datetimepicker( this.v_paramwindow, this.v_report.v_cmd.v_parameters[k].v_description, "dd/MM/yyyy" ); this.v_paramwindow.Add(v_param); } else { if (this.v_report.v_cmd.v_parameters[k].v_lookup != null && this.v_report.v_cmd.v_parameters[k].v_lookup != "") { Spartacus.Forms.Lookup v_param = new Spartacus.Forms.Lookup( this.v_paramwindow, this.v_report.v_cmd.v_parameters[k].v_description ); v_param.Populate(this.v_report.v_database, this.v_report.v_cmd.v_parameters[k].v_lookup, "80;150"); this.v_paramwindow.Add(v_param); } else { Spartacus.Forms.Textbox v_param = new Spartacus.Forms.Textbox( this.v_paramwindow, this.v_report.v_cmd.v_parameters[k].v_description ); this.v_paramwindow.Add(v_param); } } } this.v_reportpdffile = new Spartacus.Forms.Filepicker( this.v_paramwindow, Spartacus.Forms.Filepicker.Type.SAVE, System.Configuration.ConfigurationManager.AppSettings["param.pdffile"].ToString(), System.Configuration.ConfigurationManager.AppSettings["param.filter"].ToString() ); this.v_paramwindow.Add(this.v_reportpdffile); this.v_parambuttons = new Spartacus.Forms.Buttons(this.v_paramwindow); this.v_parambuttons.AddButton(System.Configuration.ConfigurationManager.AppSettings["param.execute"].ToString(), this.OnParamExecuteClick); this.v_parambuttons.AddButton(System.Configuration.ConfigurationManager.AppSettings["param.cancel"].ToString(), this.OnParamCancelClick); this.v_paramwindow.Add(this.v_parambuttons); this.v_progressbar = new Spartacus.Forms.Progressbar(this.v_paramwindow); this.v_progressbar.SetValue("Aguardando início", 0); this.v_paramwindow.Add(this.v_progressbar); this.v_paramwindow.Show(); } catch (Spartacus.Database.Exception exc) { Spartacus.Forms.Messagebox.Show(exc.v_message, "Spartacus.Database.Exception", Spartacus.Forms.Messagebox.Icon.ERROR); System.Environment.Exit(-1); } catch (Spartacus.Reporting.Exception exc) { Spartacus.Forms.Messagebox.Show(exc.v_message, "Spartacus.Reporting.Exception", Spartacus.Forms.Messagebox.Icon.ERROR); System.Environment.Exit(-1); } catch (Spartacus.Forms.Exception exc) { Spartacus.Forms.Messagebox.Show(exc.v_message, "Spartacus.Forms.Exception", Spartacus.Forms.Messagebox.Icon.ERROR); System.Environment.Exit(-1); } catch (System.Exception exc) { Spartacus.Forms.Messagebox.Show(exc.Message, exc.GetType().ToString(), Spartacus.Forms.Messagebox.Icon.ERROR); System.Environment.Exit(-1); } }
public void MenuMovimentacaoPDF(object sender, EventArgs e) { Spartacus.Reporting.Report v_report; System.Data.DataTable v_table; v_table = this.v_database.Query( "select m.id, " + " m.data, " + " a.nome, " + " m.descricao, " + " m.debito, " + " m.credito, " + " m.saldo " + "from movimentos m " + "inner join agentes a " + "on a.id = m.idagente " + "order by m.id desc ", "MOVIMENTACAO" ); v_report = new Spartacus.Reporting.Report(v_table); v_report.Execute(); v_report.Save("movimentacao.pdf"); Spartacus.Forms.Messagebox.Show("Relatório salvo com sucesso.", "OK", Spartacus.Forms.Messagebox.Icon.INFORMATION); }
public void MenuAgentesPDF(object sender, EventArgs e) { Spartacus.Reporting.Report v_report; System.Data.DataTable v_table; v_table = this.v_database.Query( "select a.id, " + " a.nome, " + " a.telefone " + "from agentes a " + "order by a.id ", "AGENTES" ); v_report = new Spartacus.Reporting.Report(v_table); v_report.Execute(); v_report.Save("agentes.pdf"); Spartacus.Forms.Messagebox.Show("Relatório salvo com sucesso.", "OK", Spartacus.Forms.Messagebox.Icon.INFORMATION); }