public void MenuButtonSearch_OnClick(object sender, RoutedEventArgs e)
{
IList selected;
var formSearch = new FSearch(SForm.Name, TypeSearch.Consult, sender);
if (formSearch.TreeView.Nodes[0].Nodes.Count > 0)
{
formSearch.ShowDialog();
SForm.ResultSearch = formSearch.DataSource;
selected = formSearch.GetSelected as IList;
}
else
{
var fResult = new FResult()
{
GridResult =
{
ObjetoApp = SForm.InvokeMethod,
ValueControl = SForm.ObjectControl,
FormType = SForm.GetType(),
IsSearch = true
}
};
fResult.GridResult.Refresh();
fResult.ShowDialog();
SForm.ResultSearch = fResult.GridResult.SComponent.DataSource;
selected = fResult.GridResult.GetListSelected();
}
if (!SForm.Visible && !(sender is SGrid))
{
return;
}
if ((sender is RibbonButton) || ((sender is SGrid) && (sender as SGrid).ScreenSecondary))
{
SForm.ObjectControl = selected;
SForm.RefreshControls();
if (selected?.Count > 0)
{
SForm.StateForm = StateForm.Viewing;
}
}
}
private void MenuButtonSearch_OnClick(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(SForm.CurrentQuery))
{
MessageBox.Show((SForm.TypeSearch == TypeSearch.Consult ? "Nenhuma consulta selecionada" : "Nenhum relatório selecionado"), "ESR SOFTWARES");
return;
}
;
var query = SForm.CurrentQuery;
using (var conn = new SqlConnection())
{
conn.ConnectionString = _connection.Database.Connection.ConnectionString;
var command = new SqlCommand(query, conn);
SForm.RunSearch();
try
{
conn.Open();
command.CommandText = SForm.CurrentQuery;
using (var reader = command.ExecuteReader())
{
var dt = new DataTable();
dt.Load(reader);
if (dt.Rows.Count == 0)
{
MessageBox.Show("Nenhum resultado encontrado");
}
else
{
if (SForm.TypeSearch == TypeSearch.Consult)
{
if ((SForm.Tag as SGrid)?.Name == "GridMain")
{
SForm.DataSource = dt;
SForm.Hide();
}
else
{
var fResult = new FResult();
fResult.GridResult.FormType = (SForm.Tag as SGrid)?.FormType;
fResult.GridResult.ObjetoApp = (SForm.Tag as SGrid)?.ObjetoApp;
fResult.SetDataSource(dt);
fResult.GridResult.SComponent.Refresh();
fResult.ShowDialog();
SForm.DataSource = fResult.GridResult.SComponent.DataSource;
SForm.GetSelected = fResult.GridResult.GetListSelected();
SForm.Hide();
}
}
else
{
var fReport = new FormVisualisador(SForm.Report.ReportName, new Dictionary <string, object>()
{
{ SForm.Report.Code, dt }
}).ShowDialog();
}
}
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
finally
{
conn.Close();
}
}
}
