void muestra_info()
{
using (SqlConnection connection = new SqlConnection(Sserver))
{
try
{
connection.Open();
// SqlCommand cmd = new SqlCommand("web_informa_parametros_web", connection);
// cmd.CommandType = CommandType.StoredProcedure;
// Parámetros
SqlDataAdapter da = new SqlDataAdapter("web_informa_parametros_web", connection);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable dt = new DataTable();
da.Fill(dt);
Lst_Info.DataSource = dt;
Lst_Info.DataBind();
connection.Close();
connection.Dispose();
}
catch (Exception ex)
{
lbl_error.Text = ex.Message;
}
finally
{
connection.Close();
}
}
}
void ejecuta_crud(string mov, int id_nivel, string nivel, int v_min, int v_max, int id_bodega, int activo, int stock, int stock_critico)
{
using (SqlConnection connection = new SqlConnection(Sserver))
{
try
{
connection.Open();
SqlDataAdapter da = new SqlDataAdapter("web_adm_crud_stock_web", connection);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.AddWithValue("@v_mov", mov);
da.SelectCommand.Parameters["@v_mov"].Direction = ParameterDirection.Input;
if (id_nivel == 0)
{
da.SelectCommand.Parameters.AddWithValue("@v_id_nivel", DBNull.Value);
}
else
{
da.SelectCommand.Parameters.AddWithValue("@v_id_nivel", id_nivel);
}
da.SelectCommand.Parameters["@v_id_nivel"].Direction = ParameterDirection.Input;
if (nivel == "")
{
da.SelectCommand.Parameters.AddWithValue("@v_nivel", DBNull.Value);
}
else
{
da.SelectCommand.Parameters.AddWithValue("@v_nivel", nivel);
}
da.SelectCommand.Parameters["@v_nivel"].Direction = ParameterDirection.Input;
if (v_min == 0)
{
da.SelectCommand.Parameters.AddWithValue("@v_min", DBNull.Value);
}
else
{
da.SelectCommand.Parameters.AddWithValue("@v_min", v_min);
}
da.SelectCommand.Parameters["@v_min"].Direction = ParameterDirection.Input;
if (v_max == 0)
{
da.SelectCommand.Parameters.AddWithValue("@v_max", DBNull.Value);
}
else
{
da.SelectCommand.Parameters.AddWithValue("@v_max", v_max);
}
da.SelectCommand.Parameters["@v_max"].Direction = ParameterDirection.Input;
if (id_bodega == 0)
{
da.SelectCommand.Parameters.AddWithValue("@v_id_bodega", DBNull.Value);
}
else
{
da.SelectCommand.Parameters.AddWithValue("@v_id_bodega", id_bodega);
}
da.SelectCommand.Parameters["@v_id_bodega"].Direction = ParameterDirection.Input;
if (stock == 0)
{
da.SelectCommand.Parameters.AddWithValue("@v_stock", DBNull.Value);
}
else
{
da.SelectCommand.Parameters.AddWithValue("@v_stock", stock);
}
da.SelectCommand.Parameters["@v_stock"].Direction = ParameterDirection.Input;
if (stock_critico == 0)
{
da.SelectCommand.Parameters.AddWithValue("@v_stock_critico", DBNull.Value);
}
else
{
da.SelectCommand.Parameters.AddWithValue("@v_stock_critico", stock_critico);
}
da.SelectCommand.Parameters["@v_stock_critico"].Direction = ParameterDirection.Input;
if (activo == 0)
{
da.SelectCommand.Parameters.AddWithValue("@v_activo", DBNull.Value);
}
else
{
da.SelectCommand.Parameters.AddWithValue("@v_activo", activo);
}
da.SelectCommand.Parameters["@v_activo"].Direction = ParameterDirection.Input;
// if (mov == "L")
// {
DataTable dt = new DataTable();
da.Fill(dt);
Lst_Info.DataSource = dt;
Lst_Info.DataBind();
// }
/* else
* {
* SqlDataReader dr = da.SelectCommand.ExecuteReader();
*
* while (dr.Read())
* {
* if (!dr.IsDBNull(0))
* {
* lbl_status.Text = dr.GetString(0);
* }
* }
* }*/
connection.Close();
connection.Dispose();
}
catch (Exception ex)
{
lbl_error.Text = ex.Message;
}
finally
{
connection.Close();
}
}
}
