private void webBrowserDetail_TitleChange(object sender, AxSHDocVw.DWebBrowserEvents2_TitleChangeEvent e)
{
Console.Write(e.text + "\n");
#if (DEBUG)
#endif
if (listViewMaestro.SelectedItems.Count == 1)
{
if (myformvisualizador == null)
{
myformvisualizador = new formVisualizador();
}
myformvisualizador.calledForm = this;
Maestro maestroselected = (Maestro)listViewMaestro.SelectedItems[0].Tag;
Int32 mes = System.Convert.ToInt32(maestroselected.tvdatafiles_recordDate.Substring(3, 2));
string strmes = mes.ToString();
Detalle Detalleselected;
if (Convert.ToInt32(e.text) == -1)
{
if (internalbusqueda.arrayDetalle.Count == 0)
{
//string iphostname = hosttoip(maestroselected.serverlist_hostname);
string iphostname = maestroselected.serverlist_hostname;
myformvisualizador.filename_path = @"\\" + iphostname + @"\tvfiles\" + maestroselected.tvdatafiles_recordDate.Substring(6, 4) + @"\" + strmes + @"\";
myformvisualizador.filename = maestroselected.tvdatafiles_name;
myformvisualizador.filename_to_reproduce = @"\\" + iphostname + @"\tvfiles\" + maestroselected.tvdatafiles_recordDate.Substring(6, 4) + @"\" + strmes + @"\" + maestroselected.tvdatafiles_name;
}
else
{
Detalleselected = (Detalle)internalbusqueda.arrayDetalle[0];
//string iphostname = hosttoip(Detalleselected.serverlist_hostname);
string iphostname = Detalleselected.serverlist_hostname;
myformvisualizador.filename_path = @"\\" + iphostname + @"\tvfiles\" + maestroselected.tvdatafiles_recordDate.Substring(6, 4) + @"\" + strmes + @"\";
myformvisualizador.filename = Detalleselected.tvdatafiles_name;
myformvisualizador.filename_to_reproduce = @"\\" + iphostname + @"\tvfiles\" + maestroselected.tvdatafiles_recordDate.Substring(6, 4) + @"\" + strmes + @"\" + Detalleselected.tvdatafiles_name;
}
myformvisualizador.timeframe = 0;
}
else
{
Detalleselected = (Detalle)internalbusqueda.arrayDetalle[Convert.ToInt32(e.text)];
//string iphostname = hosttoip(Detalleselected.serverlist_hostname);
string iphostname = Detalleselected.serverlist_hostname;
myformvisualizador.filename_path = @"\\" + iphostname + @"\tvfiles\" + maestroselected.tvdatafiles_recordDate.Substring(6, 4) + @"\" + strmes + @"\";
myformvisualizador.filename = Detalleselected.tvdatafiles_name;
myformvisualizador.filename_to_reproduce = @"\\" + iphostname + @"\tvfiles\" + maestroselected.tvdatafiles_recordDate.Substring(6, 4) + @"\" + strmes + @"\" + Detalleselected.tvdatafiles_name;
myformvisualizador.timeframe = System.Convert.ToInt32(Detalleselected.tvinfo_timepoint);
}
Console.Write(myformvisualizador.filename_to_reproduce + "\n timeframe" + myformvisualizador.timeframe + "\n");
myformvisualizador.Show();
myformvisualizador.WindowState = FormWindowState.Normal;
myformvisualizador.TopMost = true;
myformvisualizador.play();
myformvisualizador.TopMost = false;
}
}
public int fillMaestro(string strwhere, bool is_withData, bool fulltext)
{
string sql;
if (ascendente)
{
if (is_withData)
{
if (fulltext)
{
sql = "select distinct tvdatafiles_name, tvdatafiles_id, tvdatafiles_recordDate ,tvdatafiles_Starttime,tvchannels_Channel,tvchannels_Name, tvdatafiles_tvshow,tvshows_name,users_Name, storagetype_name ,tvdatafiles_host , serverlist_hostname from (SELECT * FROM `vw_consulta_fulltext` WHERE " + strwhere + " ) tabla order by tvdatafiles_recordDate ";
}
else
{
sql = "select distinct tvdatafiles_name, tvdatafiles_id, tvdatafiles_recordDate ,tvdatafiles_Starttime,tvchannels_Channel,tvchannels_Name, tvdatafiles_tvshow,tvshows_name,users_Name, storagetype_name ,tvdatafiles_host , serverlist_hostname from (SELECT * FROM `vw_consulta` WHERE " + strwhere + " ) tabla order by tvdatafiles_recordDate ";
}
}
else
{
sql = "select distinct tvdatafiles_name, tvdatafiles_id, tvdatafiles_recordDate ,tvdatafiles_Starttime,tvchannels_Channel,tvchannels_Name, tvdatafiles_tvshow,tvshows_name,users_Name, storagetype_name ,tvdatafiles_host , serverlist_hostname from (SELECT * FROM `vw_consulta_no_data` WHERE " + strwhere + " ) tabla order by tvdatafiles_recordDate ";
}
}
else
{
if (is_withData)
{
if (fulltext)
{
sql = "select distinct tvdatafiles_name, tvdatafiles_id, tvdatafiles_recordDate ,tvdatafiles_Starttime,tvchannels_Channel,tvchannels_Name, tvdatafiles_tvshow,tvshows_name,users_Name, storagetype_name ,tvdatafiles_host , serverlist_hostname from (SELECT * FROM `vw_consulta_fulltext` WHERE " + strwhere + " ) tabla order by tvdatafiles_recordDate desc ";
}
else
{
sql = "select distinct tvdatafiles_name, tvdatafiles_id, tvdatafiles_recordDate ,tvdatafiles_Starttime,tvchannels_Channel,tvchannels_Name, tvdatafiles_tvshow,tvshows_name,users_Name, storagetype_name ,tvdatafiles_host , serverlist_hostname from (SELECT * FROM `vw_consulta` WHERE " + strwhere + " ) tabla order by tvdatafiles_recordDate desc ";
}
}
else
{
sql = "select distinct tvdatafiles_name, tvdatafiles_id, tvdatafiles_recordDate ,tvdatafiles_Starttime,tvchannels_Channel,tvchannels_Name, tvdatafiles_tvshow,tvshows_name,users_Name, storagetype_name ,tvdatafiles_host , serverlist_hostname from (SELECT * FROM `vw_consulta_no_data` WHERE " + strwhere + " ) tabla order by tvdatafiles_recordDate desc ";
}
}
sql = sql + " LIMIT " + this.pagina * 100 + " , " + 99;
Console.Write(sql + "\n");
MySqlCommand command = connection.CreateCommand();
MySqlDataReader Reader;
int int_tvdatafiles_id;
int int_tvdatafiles_name;
int int_tvdatafiles_recordDate;
int int_tvdatafiles_Starttime;
int int_tvchannels_Channel;
int int_tvchannels_Name;
int int_tvdatafiles_tvshow;
int int_tvshows_name;
int int_storagetype_name;
int int_users_Name;
int int_tvdatafiles_host;
int int_serverlist_hostname;
command.CommandText = sql;
command.CommandTimeout = int.MaxValue;
Reader = command.ExecuteReader();
int_tvdatafiles_id = Reader.GetOrdinal("tvdatafiles_id");
int_tvdatafiles_name = Reader.GetOrdinal("tvdatafiles_name");
int_tvdatafiles_recordDate = Reader.GetOrdinal("tvdatafiles_recordDate");
int_tvdatafiles_Starttime = Reader.GetOrdinal("tvdatafiles_Starttime");
int_tvchannels_Channel = Reader.GetOrdinal("tvchannels_Channel");
int_tvchannels_Name = Reader.GetOrdinal("tvchannels_Name");
int_tvdatafiles_tvshow = Reader.GetOrdinal("tvdatafiles_tvshow");
int_tvshows_name = Reader.GetOrdinal("tvshows_name");
int_storagetype_name = Reader.GetOrdinal("storagetype_name");
int_users_Name = Reader.GetOrdinal("users_Name");
int_tvdatafiles_host = Reader.GetOrdinal("tvdatafiles_host");
int_serverlist_hostname = Reader.GetOrdinal("serverlist_hostname");
int resultado = 0;
while (Reader.Read())
{
resultado++;
Maestro amaestro = new Maestro();
amaestro.tvdatafiles_id = Reader.GetValue(int_tvdatafiles_id).ToString();
amaestro.tvdatafiles_name = Reader.GetValue(int_tvdatafiles_name).ToString();
if (Reader.GetValue(int_tvdatafiles_recordDate) != null)
{
amaestro.tvdatafiles_recordDate = Reader.GetValue(int_tvdatafiles_recordDate).ToString();
}
else
{
amaestro.tvdatafiles_recordDate = "";
}
amaestro.tvdatafiles_Starttime = Reader.GetValue(int_tvdatafiles_Starttime).ToString();
amaestro.tvchannels_Channel = Reader.GetValue(int_tvchannels_Channel).ToString();
amaestro.tvchannels_Name = Reader.GetValue(int_tvchannels_Name).ToString();
amaestro.tvdatafiles_tvshow = Reader.GetValue(int_tvdatafiles_tvshow).ToString();
amaestro.tvshows_name = Reader.GetValue(int_tvshows_name).ToString();
amaestro.storagetype_name = Reader.GetValue(int_storagetype_name).ToString();
amaestro.users_Name = Reader.GetValue(int_users_Name).ToString();
amaestro.tvdatafiles_host = Reader.GetValue(int_tvdatafiles_host).ToString();
amaestro.serverlist_hostname = Reader.GetValue(int_serverlist_hostname).ToString();
arrayMaestros.Add(amaestro);
}
Reader.Close();
return(resultado);
}
void doitnow()
{
if (listViewMaestro.SelectedItems.Count == 1)
{
Maestro maestroselected = (Maestro)listViewMaestro.SelectedItems[0].Tag;
listViewMaestro.SelectedItems[0].Text = "X";
maestroselected.visto = "X";
internalbusqueda.arrayDetalle.Clear();
//this.listViewDetalle.Items.Clear();
if (!checkBoxVerSoloPalabras.Checked)
{
internalbusqueda.fillDetalle(where, maestroselected.tvdatafiles_id, is_withData);
}
else
{
internalbusqueda.fillDetalleAll(maestroselected.tvdatafiles_id, is_withData);
}
// string str_to_display = "<html><body oncontextmenu=\"return false;\">";
string str_to_display = "<html>";
str_to_display = str_to_display + "<script type=\"text/javascript\"> function changeTitle(title,ran) { document.title = title; }</script>";
str_to_display = str_to_display + "<table border=1>";
str_to_display = str_to_display + "<tr>";
str_to_display = str_to_display + "<td width=50>";
str_to_display = str_to_display + "Timeline";
str_to_display = str_to_display + "</td>";
str_to_display = str_to_display + "<td width=50>";
str_to_display = str_to_display + "Info";
str_to_display = str_to_display + "</td>";
str_to_display = str_to_display + "<td width=500>";
str_to_display = str_to_display + "Detalle";
str_to_display = str_to_display + "</td>";
str_to_display = str_to_display + "</tr>";
str_to_display = str_to_display + "<tr>";
str_to_display = str_to_display + "<td width=50>";
str_to_display = str_to_display + getNewLink("00" + ":" + "00" + ":" + "00", -1);
str_to_display = str_to_display + "</td>";
str_to_display = str_to_display + "<td width=50>";
str_to_display = str_to_display + "-";
str_to_display = str_to_display + "</td>";
str_to_display = str_to_display + "<td width=500>";
str_to_display = str_to_display + "Comienzo";
str_to_display = str_to_display + "</td>";
str_to_display = str_to_display + "</tr>";
int posicion = 0;
foreach (Detalle value in internalbusqueda.arrayDetalle)
{
str_to_display = str_to_display + "<tr>";
Int32 timepoint = System.Convert.ToInt32(value.tvinfo_timepoint);
int segundos = timepoint % 60;
int minutos = (timepoint / 60) % 60;
int horas = (timepoint / 60 / 60);
string str_horas;
string str_minutos;
string str_segundos;
if (segundos < 10)
{
str_segundos = "0" + segundos.ToString();
}
else
{
str_segundos = segundos.ToString();
}
if (minutos < 10)
{
str_minutos = "0" + minutos.ToString();
}
else
{
str_minutos = minutos.ToString();
}
if (horas < 10)
{
str_horas = "0" + horas.ToString();
}
else
{
str_horas = horas.ToString();
}
str_to_display = str_to_display + "<td>";
str_to_display = str_to_display + getNewLink(str_horas + ":" + str_minutos + ":" + str_segundos, posicion);
posicion++;
str_to_display = str_to_display + "</td>";
str_to_display = str_to_display + "<td>";
if (value.tvinfo_infotype == "")
{
str_to_display = str_to_display + "-";
}
else
{
str_to_display = str_to_display + value.tvinfo_infotype;
}
str_to_display = str_to_display + "</td>";
str_to_display = str_to_display + "<td>";
str_to_display = str_to_display + getNewText(value.tvinfo_data);
str_to_display = str_to_display + "</td>";
str_to_display = str_to_display + "</tr>";
}
str_to_display = str_to_display + "</table>";
str_to_display = str_to_display + "</body></html>";
string strfile = System.IO.Path.GetTempFileName();
System.IO.StreamWriter file = new System.IO.StreamWriter(strfile);
file.WriteLine(str_to_display);
file.Close();
object Zero = 0;
object EmptyString = "";
webBrowserDetail.Navigate("file:" + strfile, ref Zero, ref EmptyString, ref EmptyString, ref EmptyString);
}
}
