Exemplo n.º 1
0
        private void ExportWindow_Load(object sender, EventArgs e)
        {
            IQueryBatchProvider batchProvider = _services.HostWindow.ActiveChildForm as IQueryBatchProvider;

            if (batchProvider != null && batchProvider.Batch != null)
            {
                if (batchProvider.Batch.Queries.Count > 1)
                {
                    BatchQuerySelectForm querySelectForm = new BatchQuerySelectForm();
                    querySelectForm.Fill(batchProvider.Batch);
                    querySelectForm.ShowDialog();
                    if (querySelectForm.DialogResult == DialogResult.OK)
                    {
                        _dsExecutedData = querySelectForm.SelectedQuery.Result;
                    }
                    else
                    {
                        Close(); // user calncelled
                    }
                    return;
                }

                if (batchProvider.Batch.Queries.Count == 1)
                {
                    _dsExecutedData = batchProvider.Batch.Queries[0].Result;
                    return;
                }
            }

            MessageBox.Show("Couldn't find a result window, run a query or view a table to export the data.");
            Close();
        }
        /// <summary>Execute the command.</summary>
        public override void Execute()
        {
            IQueryBatchProvider batchProvider = HostWindow.ActiveChildForm as IQueryBatchProvider;

            if (batchProvider == null)
            {
                HostWindow.DisplaySimpleMessageBox(null, "No results to save as a 'DataSet'.", "Save Results as DataSet XML Error");
            }
            else
            {
                DataSet ds = null;

                if (batchProvider.Batch != null)
                {
                    if (batchProvider.Batch.Queries.Count > 1)
                    {
                        BatchQuerySelectForm querySelectForm = Services.Resolve <BatchQuerySelectForm>();
                        querySelectForm.Fill(batchProvider.Batch);
                        querySelectForm.ShowDialog();
                        if (querySelectForm.DialogResult == DialogResult.OK)
                        {
                            ds = querySelectForm.SelectedQuery.Result;
                        }
                    }
                    else if (batchProvider.Batch.Queries.Count == 1)
                    {
                        ds = batchProvider.Batch.Queries[0].Result;
                    }
                }

                if (ds == null)
                {
                    return;
                }

                using (SaveFileDialog saveFileDialog = new SaveFileDialog())
                {
                    saveFileDialog.Title            = "Save Results as DataSet XML";
                    saveFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.MyComputer);
                    saveFileDialog.Filter           = Properties.Settings.Default.XmlFileDialogFilter;

                    if (saveFileDialog.ShowDialog(HostWindow.Instance) == DialogResult.OK)
                    {
                        ds.WriteXml(saveFileDialog.FileName, XmlWriteMode.WriteSchema);
                        string msg = string.Format("Saved results to file: '{0}'", saveFileDialog.FileName);
                        HostWindow.SetStatus(HostWindow.ActiveChildForm, msg);
                    }
                }
            }
        }