public void CopySelectedRows()
{
if (query != null)
{
RenderResults r = new RenderResults();
for (int i = 0; i < query.columns.Count; i++)
{
r.AddColumn(query.columns[i]);
}
r.betweenColumns = ",";
r.betweenRows = "CRLF";
List <string> row = new List <string>();
foreach (int i in SelectedIndices)
{
A.SetProgress(i, SelectedIndices.Count, true);
row.Clear();
for (int j = 0; j < query.columns.Count; j++)
{
row.Add(query.rows[i][j]);
}
r.WriteRow(row);
}
A.SetProgress();
Clipboard.SetText(r.results);
}
}
public void CopyColumnAs(string mode)
{
if (query != null && colUnderMouse >= 0 && colUnderMouse < query.columns.Count)
{
RenderResults r = new RenderResults();
r.AddColumn(query.columns[colUnderMouse]);
r.format = mode;
r.betweenRows = ",";
List <string> row = new List <string>();
foreach (int i in SelectedIndices)
{
row.Clear();
row.Add(query.rows[i][colUnderMouse]);
r.WriteRow(row);
}
Clipboard.SetText(r.results);
}
}
public void SaveData()
{
if (!Directory.Exists(directoryTextbox.Text))
{
return;
}
using (renderer = new RenderResults(T.AddFileToPath(directoryTextbox.Text, fileNameTextbox.Text)))
{
renderer.betweenColumns = colSeparator.Text;
renderer.betweenRows = rowSeparator.Text;
renderer.betweenColumns = colSeparator.Text;
renderer.includeHeaders = columnTitles.GetValue();
renderer.escapeWhenNecessary = escapeWhenNecessary.GetValue();
renderer.padStrings = padStrings.GetValue();
renderer.putStringColumnsInSingleQuotes = singleQuoteStrings.GetValue();
renderer.putStringColumnsInDoubleQuotes = doubleQuoteStrings.GetValue();
renderer.removeNewLines = removeNewlines.GetValue();
renderer.removeNonAscii = stripNonAscii.GetValue();
renderer.includeNulls = printNulls.GetValue();
renderer.removeTime = removeTime.GetValue();
renderer.format = fileType == "Code" ? formatCombo.GetValue() : "";
renderer.rowTemplate = fileType.IsOneOf("Code", "Custom") ? S.Set("rowTemplate", rowTemplate.Text) : "";
renderer.columnTemplate = fileType.IsOneOf("Code", "Custom") ? S.Set("columnTemplate", columnTemplate.Text) : "";
string selectedTable = tableMode ? tableCombo.GetValue() : null;
int rowsExpected = 0;
string sql = null;
if (tableMode)
{
sql = "select " + columnsList.GetSelectedStrings(",") + " from " + selectedTable;
rowsExpected = A.db.GetExpectedRowsInQuery(sql);
}
else
{
rowsExpected = selectedIndices != null && saveSelected.Checked ? selectedIndices.Count : query.rows.Count;
}
selectedColumnsIndexes.Clear();
for (int i = 0; i < columnsList.Items.Count; i++)
{
int pos = 0;
if (columnsList.GetSelected(i))
{
selectedColumnsIndexes.Add(i);
if (tableMode)
{
renderer.AddColumn(new QueryColumnInfo(pos++, A.db.tables[selectedTable].columns[columnsList.Items[i].ToString()]));
}
else
{
renderer.AddColumn(query.columns[i]);
}
}
}
if (columnTitles.Checked)
{
renderer.WriteHeader();
}
using (QSqlBase s = A.db.GetSql())
{
sForWriting = s;
if (tableMode)
{
sForWriting.Open(sql);
}
DlgSaveAsSave dlg = new DlgSaveAsSave(this, rowsExpected);
DialogResult result = dlg.ShowDialog(this);
renderer.Flush();
if (result == DialogResult.Yes)
{
System.Diagnostics.Process.Start(directoryTextbox.Text);
}
else if (result == DialogResult.Cancel)
{
sForWriting.CancelQuery();
}
}
}
Close();
}
