public DataSet Request(DataSet ds, IncludeSchema isEnum, string nombreProcedimiento, IDictionaryEnumerator parametros)
{
DB2Connection lc = OpenConnection();
try
{
DB2Command comm = new DB2Command(nombreProcedimiento, lc);
comm.CommandType = System.Data.CommandType.StoredProcedure;
if (parametros != null)
{
while (parametros.MoveNext())
{
comm.Parameters.Add(parametros.Key.ToString(), parametros.Value);
}
}
DB2DataAdapter adapter = new DB2DataAdapter(comm);
if (isEnum == IncludeSchema.YES)
{
adapter.FillSchema(ds, SchemaType.Mapped);
adapter.Fill(ds);
}
else
{
adapter.Fill(ds, "result_ " + ds.Tables.Count.ToString());
}
}
catch (Exception e)
{
exceptions = "Error ejecutando SQL." + cambioLinea + cambioLinea;
exceptions += e.ToString();
AdministradorCarpetasRegistro.GrabarLogs(TipoRegistro.Error, nombreProcedimiento, e, exceptions);
}
CloseConnection(lc);
return(ds);
}
public DataSet RequestGlobal(DataSet ds, IncludeSchema isEnum, string dataBase, string sql)
{
DB2Connection lc;
if (dataBase == "")
{
lc = OpenConnectionGlobal();
}
else
{
lc = OpenConnectionGlobal(dataBase);
}
try
{
AdministradorCarpetasRegistro.GrabarLogs(TipoRegistro.Actividad, sql, null, string.Empty);
DB2DataAdapter adapter = new DB2DataAdapter(sql, lc);
if (isEnum == IncludeSchema.YES)
{
adapter.FillSchema(ds, SchemaType.Mapped);
adapter.Fill(ds);
}
else
{
adapter.Fill(ds, "result_ " + ds.Tables.Count.ToString());
}
}
catch { }
CloseConnection(lc);
return(ds);
}
public DataSet Request(DataSet ds, IncludeSchema isEnum, string sql)
{
AdministradorCarpetasRegistro.GrabarLogs(TipoRegistro.Actividad, sql, null, string.Empty);
DB2DataAdapter adapter = new DB2DataAdapter(sql, connection);
if (isEnum == IncludeSchema.YES)
{
adapter.FillSchema(ds, SchemaType.Mapped);
adapter.Fill(ds);
}
else
{
adapter.Fill(ds, "result_ " + ds.Tables.Count.ToString());
}
return(ds);
}
public DataSet Request(DataSet ds, IncludeSchema isEnum, string sql)
{
DB2Connection lc = OpenConnection();
try
{
AdministradorCarpetasRegistro.GrabarLogs(TipoRegistro.Actividad, sql, null, string.Empty);
DB2DataAdapter adapter = new DB2DataAdapter(sql, lc);
if (isEnum == IncludeSchema.YES)
{
adapter.FillSchema(ds, SchemaType.Mapped);
adapter.Fill(ds);
}
else
{
adapter.Fill(ds, "result_ " + ds.Tables.Count.ToString());
}
}
catch (Exception z) { this.exceptions = z.Message; }
CloseConnection(lc);
return(ds);
}
protected override DataTable BuildSchemaTable(Boolean withGeometryColumn)
{
DataTable dt = null;
using (DB2Connection conn = new DB2Connection(ConnectionString))
{
conn.Open();
conn.CacheData = true;
using (DB2Command cmd = new DB2Command(string.Format("SELECT * FROM {0};", QualifiedTableName), conn))
{
DB2DataAdapter da = new DB2DataAdapter(cmd);
DataSet ds = new DataSet();
da.FillSchema(ds, SchemaType.Source);
dt = ds.Tables["Table"];
}
if (!withGeometryColumn)
{
dt.Columns.Remove(GeometryColumn);
}
}
return(dt);
}