public List<Sucursal> ObtenerSucursales(string idLaboratorio) { List<Sucursal> sucursales = null; CrearConexion(); try { sucursales = new List<Sucursal>(); OracleCommand query = new OracleCommand("SELECT B.ID, B.CLAVE, B.DENOMINACION " + "FROM SUBUNIDADORGANIZACIONAL A JOIN UNIDADORGANIZACIONAL B" + " ON B.ID = A.IDHIJO WHERE IDPADRE = :IDLABORATORIO" + " ORDER BY B.CLAVE", _conec); query.Parameters.Add("IDLABORATORIOS", OracleDbType.Varchar2).Value = idLaboratorio; OracleDataReader reader = query.ExecuteReader(); while (reader.Read()) { Sucursal tmp = new Sucursal { IdSucursal = Int32.Parse(reader["ID"].ToString()), ClaveSucursal = reader["CLAVE"].ToString(), Descripcion = reader["DENOMINACION"].ToString() }; sucursales.Add(tmp); } reader.Close(); } catch (Exception ex) { Console.WriteLine("Error: {0}", ex.Message); Console.WriteLine("StackTrace: {0}", ex.StackTrace); } finally { CerrarConexion(); } return sucursales; }
public void CrearComponente(SplitterPanel host, int columna, int fila, int indice, Sucursal tmpSucursal) { _hostForm = host; Index = indice; Col = columna; Row = fila; SucursalAsignada = tmpSucursal; //Botones = new Button[2]; Etiqueta = AgregarEtiqueta(tmpSucursal.ClaveSucursal); VideoEnLinea = new PictureBox(); _hostForm.Controls.Add(VideoEnLinea); VideoEnLinea.Top = _posTopLabel[Row]; VideoEnLinea.Left = _posLeftElem1[Col]; VideoEnLinea.Tag = Index; VideoEnLinea.Size = new Size(100, 100); VideoEnLinea.BorderStyle = BorderStyle.FixedSingle; //VideoEnLinea = AgregarVideoSnapshot(); //Botones[0] = AgregarBoton("Cam.", ClickVideo, 1); //Botones[0] = AgregarBoton("Aud.", ClickAudio, 2); AgregarVideoSnapshot(urlcam, puerto, root, pass); }