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