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