public void executesql(MSBusqueda the, string thewhere, bool ascendente, bool withData, bool fulltext)
{
if (fulltext)
{
checkBoxVerSoloPalabras.Enabled = false;
checkBoxVerSoloPalabras.Checked = true;
}
else
{
checkBoxVerSoloPalabras.Enabled = true;
checkBoxVerSoloPalabras.Checked = false;
}
is_fullsearch = fulltext;
is_withData = withData;
where = thewhere;
internalbusqueda = the;
internalbusqueda.arrayMaestros.Clear();
internal_asc = ascendente;
internalbusqueda.ascendente = internal_asc;
this.listViewMaestro.Items.Clear();
internalbusqueda.fillMaestro(thewhere, is_withData, fulltext);
foreach (Maestro value in internalbusqueda.arrayMaestros)
{
ListViewItem listViewItem1 = new ListViewItem();
listViewItem1.Tag = value;
listViewItem1.Text = value.visto;
listViewItem1.SubItems.Add(value.tvchannels_Name);
listViewItem1.SubItems.Add(value.tvshows_name);
if (value.tvdatafiles_recordDate != "")
{
string aux = value.tvdatafiles_recordDate.Substring(0, 2) + "-" + internalbusqueda.getDateNew(value.tvdatafiles_recordDate.Substring(3, 2)) + "-" + value.tvdatafiles_recordDate.Substring(6, 4);
listViewItem1.SubItems.Add(aux);
String newdata = value.tvdatafiles_recordDate.Substring(6, 4) + value.tvdatafiles_recordDate.Substring(3, 2) + value.tvdatafiles_recordDate.Substring(0, 2);
listViewItem1.SubItems[3].Tag = System.Convert.ToInt32(newdata);
listViewItem1.SubItems.Add(value.users_Name);
listViewItem1.SubItems.Add(value.storagetype_name);
listViewItem1.SubItems.Add(value.tvdatafiles_name);
}
else
{
}
this.listViewMaestro.Items.Add(listViewItem1);
}
labelPaginaDesc.Text = "Resultados del " + ((this.internalbusqueda.pagina * 100) + 1) + " a " + ((this.internalbusqueda.pagina * 100) + (internalbusqueda.arrayMaestros.Count + 1));
}
public Form1()
{
myformresultado = null;
InitializeComponent();
thebusqueda = new MSBusqueda();
}