public static DataTable ConsultarBD(string nombreStore, Dictionary <string, string> parametros)
{
DataTable dt = new DataTable();
SqlConnection conn = BDConn.getConnection();
try
{
SqlCommand cmd = new SqlCommand(nombreStore, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
foreach (KeyValuePair <String, String> entry in parametros)
{
cmd.Parameters.Add(new SqlParameter(entry.Key, entry.Value));
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
catch (Exception e)
{
dt.Columns.Add("Columna1");
DataRow Row = dt.NewRow();
Row["Columna1"] = e.Message.ToString();
//workRow[1] = "ERROR";
dt.Rows.Add(Row);
}
finally
{
conn.Close();
}
return(dt);
}
public static int EjecutarStoreProc(string nombreStore, List <parametros> parametros, Boolean ParamOutInt, string nombreParamOut)
{
int exito = 0;
SqlConnection conn = BDConn.getConnection();
try
{
SqlCommand cmd = new SqlCommand(nombreStore, conn);
cmd.CommandTimeout = 200;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
foreach (var p in parametros)
{
switch (p.tipodato)
{
case "string":
cmd.Parameters.Add(p.parametro, SqlDbType.VarChar).Value = p.valorCadena;
break;
case "int":
cmd.Parameters.Add(p.parametro, SqlDbType.Int).Value = p.valorEntero;
break;
case "double":
cmd.Parameters.Add(p.parametro, SqlDbType.BigInt).Value = p.valorDouble;
break;
case "datetime":
cmd.Parameters.Add(p.parametro, SqlDbType.DateTime).Value = p.valorFecha ?? null;
break;
}
}
if (ParamOutInt == true)
{
cmd.Parameters.Add(nombreParamOut, SqlDbType.Int);
cmd.Parameters[nombreParamOut].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
exito = (Int32)cmd.Parameters[nombreParamOut].Value;
}
else
{
cmd.ExecuteNonQuery();
exito = 1;
}
}
catch (Exception e)
{
exito = -1;
}
finally
{
conn.Close();
}
return(exito);
}
public static DataTable ConsultarBD(string nombreStore, List <parametros> parametros)
{
DataTable dt = new DataTable();
SqlConnection conn = null;
try
{
conn = BDConn.getConnection();
SqlCommand cmd = new SqlCommand(nombreStore, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
foreach (var p in parametros)
{
switch (p.tipodato)
{
case "string":
cmd.Parameters.Add(p.parametro, SqlDbType.VarChar).Value = p.valorCadena;
break;
case "int":
cmd.Parameters.Add(p.parametro, SqlDbType.Int).Value = p.valorEntero;
break;
case "double":
cmd.Parameters.Add(p.parametro, SqlDbType.BigInt).Value = p.valorDouble;
break;
case "datetime":
cmd.Parameters.Add(p.parametro, SqlDbType.DateTime).Value = p.valorFecha ?? null;
break;
}
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
catch
{
dt.Columns.Add("FolioAsignado");
DataRow Row = dt.NewRow();
Row["FolioAsignado"] = "ERROR";
//workRow[1] = "ERROR";
dt.Rows.Add(Row);
}
finally
{
conn.Close();
}
return(dt);
}
