public static DataTable ObtenerEmpleados()
{
SqlCommand _comando = MetodosDatos.CrearComando();
_comando.CommandText = "SELECT * FROM [Empleados]";
return(MetodosDatos.EjecutarComandoSelect(_comando));
}
public static DataTable obtenerImpresorasTable()
{
SqlCommand _comando = MetodosDatos.CrearComando();
_comando.CommandText = "select dbo.impresoras.nombre,dbo.impresoras.marca,CAST(ROUND((cast(dbo.impresoras.ip as bigint)/16777216),0,1) as varchar(4))+'.'+ CAST((ROUND((cast(dbo.impresoras.ip as bigint) / 65536),0,1) %256) as varchar(4))+'.'+ CAST((ROUND((cast(dbo.impresoras.ip as bigint) / 256),0,1) %256) as varchar(4))+'.'+ CAST((cast(dbo.impresoras.ip as bigint) %256) as varchar(4)) as IPDottedNotation from dbo.impresoras";
return(MetodosDatos.EjecutarComandoSelect(_comando));
}