private void clientesToolStripMenuItem1_Click(object sender, EventArgs e)
{
SaveFileDialog svDialog = new SaveFileDialog();
svDialog.FileName = "Relatorio de Clientes";
svDialog.Title = "Salvar relatório";
svDialog.Filter = "xlsx File(*.xlsx)|*.xlsx";
svDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
DialogResult resultado = svDialog.ShowDialog();
if (resultado == DialogResult.OK)
{
Spartacus.Database.Command cmd = new Spartacus.Database.Command();
cmd.v_text = @"select Id, Nome, Tipo, Email, SiglaEstado, Endereco, Cidade,Bairro
from pessoa where status <> #status#";
cmd.AddParameter("status", Spartacus.Database.Type.BOOLEAN);
cmd.SetValue("status", "0");//0(Flase)
Controller.ControllerRelatoriosXLSX.ExportarTabelaParaXLSX(svDialog.FileName, cmd);
}
}