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);
}
