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