private void cargarRInventario() { if ((Request.QueryString["Invet"] != null) && (Request.QueryString["Prod"] != null)) { int _ivent = int.Parse(Request.QueryString["Invet"].ToString()); int _prod = int.Parse(Request.QueryString["Prod"].ToString()); DataSet _cat = _consulta.Com21_consulta_inventario_productos_id(_ivent, _prod); if (_cat.Tables[0].Rows.Count > 0) { foreach (DataRow r in _cat.Tables[0].Rows) { lblcantidadini.Text = r["Cantidad"].ToString(); lblprecionini.Text = r["Precio"].ToString().Replace(".", ","); lbltitulo.Text = r["Titulo"].ToString(); lblmarca.Text = r["Marca"].ToString(); lblpreciocompra.Text = r["PrecioCompra"].ToString().Replace(".", ","); lblsubcategoria.Text = r["SubCategoria"].ToString(); lblCategoria.Text = r["Categoria"].ToString(); imgRuta.ImageUrl = r["Ruta"].ToString(); } } if (_cat.Tables[1].Rows.Count > 0) { pInvetS.Visible = true; pInvetN.Visible = false; decimal _totalC = 0; decimal _totalV = 0; foreach (DataRow r in _cat.Tables[1].Rows) { if (r["IdentificadorCV"].ToString() == "Compra") { _totalC = _totalC + decimal.Parse(r["Subtotal"].ToString()); } if (r["IdentificadorCV"].ToString() == "Venta") { _totalV = _totalV + decimal.Parse(r["Subtotal"].ToString()); } } lbltotalC.Text = "$" + Convert.ToString(_totalC); lbltotalV.Text = "$" + Convert.ToString(_totalV); lbltotalCV.Text = "$" + Convert.ToString(_totalC - _totalV); GvRProductos.DataSource = _cat.Tables[1]; GvRProductos.DataBind(); } else { pInvetS.Visible = false; pInvetN.Visible = true; } } }