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);
}
