static public int ExecuteSql(string sql, string company) { Firebird.Firebird edi = new Firebird.Firebird(); edi.Url = System.Configuration.ConfigurationManager.AppSettings["EdiServer"]; string[] par = { sql, "DBAP", "SCCEDI", "SCCEDI0805" }; int flag = edi.Update("cargoconnect", par); return(flag); }
static public DataTable GetTab(string sql, string company) { Firebird.Firebird edi = new Firebird.Firebird(); edi.Url = System.Configuration.ConfigurationManager.AppSettings["EdiServer"]; string[] par = { sql, "DBAP", "SCCEDI", "SCCEDI0805" }; DataTable master = edi.List("cargoconnect", par); return(master); }
static public object ExecuteScalar(string sql) { Firebird.Firebird edi = new Firebird.Firebird(); edi.Url = System.Configuration.ConfigurationManager.AppSettings["EdiServer"]; string[] par = { sql, "DBAP", "SCCEDI", "SCCEDI0805" }; DataTable master = edi.List("cargoconnect", par); if (master.Rows.Count > 0) { return(master.Rows[0][0]); } //else // return -1; return(null); }
static public DataSet GetDataSet(string[] sqls, string company) { Firebird.Firebird edi = new Firebird.Firebird(); edi.Url = System.Configuration.ConfigurationManager.AppSettings["EdiServer"]; DataSet set = new DataSet("set"); for (int i = 0; i < sqls.Length; i++) { string sql = sqls[i]; string[] par = { sql, "DBAP", "SCCEDI", "SCCEDI0805" }; DataTable tab = edi.List("cargoconnect", par); tab.TableName = "Name" + i.ToString(); set.Tables.Add(tab); } return(set); }