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