// 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 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; }