private void btnReadIdocFromDb_Click(object sender, EventArgs e)
{
String dbName = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection();
dt = new DataTable();
SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName);
String sqlstr = String.Format("select * from EDIDC where docnum like '{0}'", this.txtIdocNumber.Text.Trim());
dbhelper.DataTableFill(dt, sqlstr);
this.dataGridView1.DataSource = null;
this.dataGridView1.DataSource = dt;
var dt2 = new DataTable();
sqlstr = String.Format("select * from EDID4 where docnum like '{0}'", this.txtIdocNumber.Text.Trim());
dbhelper.DataTableFill(dt2, sqlstr);
this.dataGridView2.DataSource = null;
this.dataGridView2.DataSource = dt2;
var dt3 = new DataTable();
sqlstr = String.Format("select * from EDIDS where docnum like '{0}'", this.txtIdocNumber.Text.Trim());
dbhelper.DataTableFill(dt3, sqlstr);
this.dataGridView3.DataSource = null;
this.dataGridView3.DataSource = dt3;
}
private void btnOpenTemplateTable_Click(object sender, EventArgs e)
{
String dbName = ConfigFileTool.SAPGlobalSettings.GetTemplateDb();
dt = new DataTable();
SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName);
dbhelper.LogEvents = true;
dbhelper.DataTableFill(dt, "Select * from codeTemplate");
this.userDataGridView.DataSource = null;
this.userDataGridView.DataSource = dt;
}
private void btnReadIdocFromDb_Click(object sender, EventArgs e)
{
String dbName = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection();
dt = new DataTable();
SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName);
String sqlstr = String.Format("select * from EDIDC where docnum like '{0}'", this.txtIdocNumber.Text.Trim());
dbhelper.DataTableFill(dt, sqlstr);
this.dataGridView1.DataSource = null;
this.dataGridView1.DataSource = dt;
var dt2 = new DataTable();
sqlstr = String.Format("select * from EDID4 where docnum like '{0}'", this.txtIdocNumber.Text.Trim());
dbhelper.DataTableFill(dt2, sqlstr);
this.dataGridView2.DataSource = null;
this.dataGridView2.DataSource = dt2;
var dt3 = new DataTable();
sqlstr = String.Format("select * from EDIDS where docnum like '{0}'", this.txtIdocNumber.Text.Trim());
dbhelper.DataTableFill(dt3, sqlstr);
this.dataGridView3.DataSource = null;
this.dataGridView3.DataSource = dt3;
}
private void btnExcute_Click(object sender, EventArgs e)
{
try
{
String dbName = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection();
dt = new DataTable();
SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName);
dbhelper.DataTableFill(dt, this.syntaxBoxControl1.Document.Text);
this.dataGridView1.DataSource = null;
this.dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnExcute_Click(object sender, EventArgs e)
{
try
{
String dbName = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection();
dt = new DataTable();
SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName);
dbhelper.DataTableFill(dt, this.syntaxBoxControl1.Document.Text);
this.dataGridView1.DataSource = null;
this.dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnOpenTemplateTable_Click(object sender, EventArgs e)
{
String dbName = ConfigFileTool.SAPGlobalSettings.GetTemplateDb();
dt = new DataTable();
SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName);
dbhelper.LogEvents = true;
dbhelper.DataTableFill(dt, "Select * from codeTemplate");
this.userDataGridView.DataSource = null;
this.userDataGridView.DataSource = dt;
}
