private void bitButton1_Click(object sender, EventArgs e)
{
DialogResult msg = MessageBox.Show("Wollen Sie wirklich alle Excel-Instanzen beenden.", "Excel", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
if (msg == System.Windows.Forms.DialogResult.Yes)
{
FuncGeneral.KillProgram("EXCEL");
}
}
private void rotaBitButton1_Click(object sender, EventArgs e)
{
FuncGeneral.KillProgram("EXCEL");
ExcelHelper xls = new ExcelHelper();
xls.Workbook_Hinzufuegen();
this.m_SqlHelper.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace);
int i = 0;
bool add_select = true;
foreach (string ert in this.m_Tablelist)
{
string table = m_Tablelist[i];
string[] cols = m_ColumnlistOutput[i];
foreach (string col in cols)
{
if (add_select == true)
{
add_select = false;
this.m_SqlHelper.SQLBuilderHinzufuegen("SELECT TOP 100", SQLHelper.SQLBuilder.DeleteSQL);
}
string suchen = table + "." + col + ",";
this.m_SqlHelper.SQLBuilderHinzufuegen(suchen, SQLHelper.SQLBuilder.NoSpace);
}
i++;
}
string sql = "";
string sql_where = "";
string sql_inner_join = "";
sql = this.m_SqlHelper.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace);
sql = FuncGeneral.DeleteRight(sql, 1);
this.m_SqlHelper.SQLBuilderHinzufuegen(sql, SQLHelper.SQLBuilder.DeleteSQL);
sql = this.m_SqlHelper.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace);
sql_inner_join = this.m_SqlHelperInnerJoin.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace);
sql_where = this.m_SqlHelperWhere.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace);
this.textBox2.Text = sql + sql_inner_join + sql_where;
xls.SQL2Excel(this.textBox2.Text, m_ConnectionString);
string file_name = "Messwerte" + FuncString.GetOnlyNumeric(FuncString.GetTimestamp());
xls.DateiSpeichern(file_name);
xls.ExcelHelperClose();
xls = null;
}
