public List <XActivo> mostrar_xActivos(string familia, string conexionF) { List <XActivo> l = new List <XActivo>(); //string connString = "Data Source=DESKTOP-LS14HCO;Initial Catalog=DT2021;Integrated Security=True"; //string connString = "Data Source=DESKTOP-8CV6UC2;Initial Catalog=DT4333;Integrated Security=True"; using (SqlConnection myConn = new SqlConnection(conexionF)) { try { myConn.Open(); var mycmd = myConn.CreateCommand(); mycmd.CommandText = "Execute SP_FiltraActivoFamilia @idfamilia"; mycmd.Parameters.Add("@idfamilia", SqlDbType.Int, 150).Value = Convert.ToInt16(familia); SqlDataReader rdr = mycmd.ExecuteReader(); while (rdr.Read()) { XActivo f = new XActivo() { id_Activo = rdr["id_Activo"].ToString(), placa_Activo = rdr["placa_Activo"].ToString() }; l.Add(f); } } catch (Exception EX) { EX.GetBaseException(); } finally { myConn.Close(); } return(l); } }
public List <XActivo> mostrar_stock(string conexionF) { List <XActivo> l = new List <XActivo>(); // string connString = "Data Source=DESKTOP-LS14HCO;Initial Catalog=DT2021;Integrated Security=True"; //string connString = "Data Source=DESKTOP-8CV6UC2;Initial Catalog=DT4333;Integrated Security=True"; using (SqlConnection myConn = new SqlConnection(conexionF)) { try { myConn.Open(); var mycmd = myConn.CreateCommand(); mycmd.CommandText = "Execute SP_DameStock"; SqlDataReader rdr = mycmd.ExecuteReader(); while (rdr.Read()) { XActivo f = new XActivo() { id_Activo = rdr["id_Activo"].ToString(), placa_Activo = rdr["placa_Activo"].ToString() }; l.Add(f); } } catch (Exception EX) { EX.GetBaseException(); } finally { myConn.Close(); } return(l); } }