コード例 #1
0
        // 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;
        }
コード例 #2
0
        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;
        }
コード例 #3
0
        // 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);
        }
コード例 #4
0
        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;
        }
コード例 #5
0
 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);
     }
 }
コード例 #6
0
        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);
            }
        }
コード例 #7
0
        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;
        }
コード例 #8
0
        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;
            }
        }
コード例 #9
0
        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;
            }
        }
コード例 #10
0
        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;
        }