private void filtrarGrillaCombos()
{
CCInventario oCCInventario = new CCInventario();
CEInventario oCEInventario = new CEInventario();
oCEInventario.tipo_Inventario = dpdl_inv.SelectedItem.Text.Trim();
oCEInventario.almacen = dpdl_alm.SelectedItem.Text.Trim();
DataTable oDT= oCCInventario.getinventarioGriewList(oCEInventario);
Gdv_inv.DataSource = oDT;
Gdv_inv.DataBind();
}
public DataTable getGriewList(CEInventario oEntidad)
{
String procedure_alm = "sp_inv";
try
{
SqlConnection oSqlConnection = new SqlConnection();
CDConnection oCDConnection = new CDConnection();
oSqlConnection = oCDConnection.openDB();
SqlCommand oSqlCommand = new SqlCommand(procedure_alm, oSqlConnection);
oSqlCommand.CommandType=CommandType.StoredProcedure;
oSqlCommand.Parameters.Add("@nom_alm", SqlDbType.Char, 15).Value = oEntidad.almacen;
oSqlCommand.Parameters.Add("@nom_est", SqlDbType.VarChar, 20).Value = oEntidad.tipo_Inventario;
SqlDataAdapter oSqlDataAdapter = new SqlDataAdapter(oSqlCommand);
DataTable oDataTable = new DataTable();
oSqlDataAdapter.Fill(oDataTable);
return oDataTable;
}
catch (Exception e)
{
e.ToString();
return null;
}
}
public DataTable getinventarioGriewList(CEInventario oEntidad)
{
CDinventario oCDinventario = new CDinventario();
return oCDinventario.getGriewList(oEntidad);
}