// POST api/demo01
public String Post([FromBody]string value)
{
var httpContext = (HttpContextWrapper)Request.Properties["MS_HttpContext"];
var foo = httpContext.Request.Form["Foo"];
var st = ReadStream(httpContext.Request.InputStream);
//return this.Request.RequestUri.AbsoluteUri;
var result = Request.Content.ReadAsStringAsync().Result;
var dbconnection = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection();
//var dbconnection = "";
SAPINTDB.netlib7 net = new SAPINTDB.netlib7(dbconnection);
var forms = httpContext.Request.Form;
for (int i = 0; i < forms.Count; i++)
{
var formvalue = forms.GetValues(i);
var str = string.Empty;
foreach (var item in formvalue)
{
str = str + item;
}
var formkey = forms.GetKey(i);
var sql = string.Format("insert into sapdb.dbo.webapi([key],[value]) values('{0}','{1}');", formkey, str);
net.ExecNonQuery(sql);
}
return result;
}
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;
}
// POST api/demo01
public String Post([FromBody] string value)
{
var httpContext = (HttpContextWrapper)Request.Properties["MS_HttpContext"];
var foo = httpContext.Request.Form["Foo"];
var st = ReadStream(httpContext.Request.InputStream);
//return this.Request.RequestUri.AbsoluteUri;
var result = Request.Content.ReadAsStringAsync().Result;
var dbconnection = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection();
//var dbconnection = "";
SAPINTDB.netlib7 net = new SAPINTDB.netlib7(dbconnection);
var forms = httpContext.Request.Form;
for (int i = 0; i < forms.Count; i++)
{
var formvalue = forms.GetValues(i);
var str = string.Empty;
foreach (var item in formvalue)
{
str = str + item;
}
var formkey = forms.GetKey(i);
var sql = string.Format("insert into sapdb.dbo.webapi([key],[value]) values('{0}','{1}');", formkey, str);
net.ExecNonQuery(sql);
}
return(result);
}
private void btnUpdateTemplate_Click(object sender, EventArgs e)
{
String dbName = ConfigFileTool.SAPGlobalSettings.GetTemplateDb();
SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName);
dbhelper.LogEvents = true;
dbhelper.DataTableUpdate(dt, "Select * from codeTemplate");
dt.AcceptChanges();
this.userDataGridView.DataSource = dt;
}
private void btnUpdateDb_Click(object sender, EventArgs e)
{
try
{
String dbName = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection();
SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName);
dbhelper.DataTableUpdate(dt, this.syntaxBoxControl1.Document.Text);
dt.AcceptChanges();
this.dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnUpdateDb_Click(object sender, EventArgs e)
{
try
{
String dbName = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection();
SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName);
dbhelper.DataTableUpdate(dt, this.syntaxBoxControl1.Document.Text);
dt.AcceptChanges();
this.dataGridView1.DataSource = dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
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 InitDb(String dbName = "")
{
try
{
if (!String.IsNullOrEmpty(dbName))
{
m_dbname = dbName;
}
else
{
m_dbname = ConfigFileTool.SAPGlobalSettings.GetDefaultCodeManagerDb();
}
if (string.IsNullOrWhiteSpace(m_dbname))
{
throw new Exception("Can't get the dbName");
}
m_vdb = new SAPINTDB.netlib7(m_dbname);
connection = m_vdb.CreateConnection();
switch (m_vdb.ProviderType)
{
case netlib7.ProviderTypes.Oracle:
break;
case netlib7.ProviderTypes.SqlServer:
dialect = new SqlServerDialect();
break;
case netlib7.ProviderTypes.MsAccess:
dialect = new SqlCeDialect();
break;
case netlib7.ProviderTypes.MySql:
dialect = new MySqlDialect();
break;
case netlib7.ProviderTypes.PostgreSQL:
break;
case netlib7.ProviderTypes.OleDB:
dialect = new SqlCeDialect();
break;
case netlib7.ProviderTypes.SQLite:
dialect = new SqliteDialect();
break;
case netlib7.ProviderTypes.Unknown:
break;
default:
break;
}
var config = new DapperExtensionsConfiguration(typeof(AutoClassMapper <>), new List <Assembly>(), dialect);
var sqlGenerator = new SqlGeneratorImpl(config);
Db = new Database(connection, sqlGenerator);
}
catch (Exception)
{
throw;
}
}
private void InitDb(String dbName = "")
{
try
{
if (!String.IsNullOrEmpty(dbName))
{
m_dbname = dbName;
}
else
{
m_dbname = ConfigFileTool.SAPGlobalSettings.GetDefaultCodeManagerDb();
}
if (string.IsNullOrWhiteSpace(m_dbname))
{
throw new Exception("Can't get the dbName");
}
m_vdb = new SAPINTDB.netlib7(m_dbname);
connection = m_vdb.CreateConnection();
switch (m_vdb.ProviderType)
{
case netlib7.ProviderTypes.Oracle:
break;
case netlib7.ProviderTypes.SqlServer:
dialect = new SqlServerDialect();
break;
case netlib7.ProviderTypes.MsAccess:
dialect = new SqlCeDialect();
break;
case netlib7.ProviderTypes.MySql:
dialect = new MySqlDialect();
break;
case netlib7.ProviderTypes.PostgreSQL:
break;
case netlib7.ProviderTypes.OleDB:
dialect = new SqlCeDialect();
break;
case netlib7.ProviderTypes.SQLite:
dialect = new SqliteDialect();
break;
case netlib7.ProviderTypes.Unknown:
break;
default:
break;
}
var config = new DapperExtensionsConfiguration(typeof(AutoClassMapper<>), new List<Assembly>(), dialect);
var sqlGenerator = new SqlGeneratorImpl(config);
Db = new Database(connection, sqlGenerator);
}
catch (Exception)
{
throw;
}
}
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;
}
