private void Search_Go()
{
if (comboBox2.Text == "ALL")
{
ClassMainclass.listselect = " ";
}
else
{
ClassMainclass.listselect = "TOP " + comboBox2.Text + " ";
}
fullsql = ClassAMaincList.Listsql(txtTableName.Text, " ID,", ClassMainclass.listselect);
if (txtsimpleSearch.Text == "")
{
editview = ClassAMaincList.FilterList(txtTableName.Text, txtsimpleSearch, Text, ClassMainclass.listselect);
ClassPublicclass.Filllist(listView2, fullsql + editview);
shortsql = fullsql + editview;
}
else
{
editview = ClassAMaincList.FilterList(txtTableName.Text, txtsimpleSearch, Text, ClassMainclass.listselect);
ClassPublicclass.Filllist(listView2, fullsql + editview);
shortsql = fullsql + editview;
}
label2.Text = listView2.Items.Count.ToString();
}
private void TextBox1_TextChanged(object sender, EventArgs e)
{
if (checkBox1.Checked == true)
{
if (comboBox2.Text == "ALL")
{
ClassMainclass.listselect = " ";
}
else
{
ClassMainclass.listselect = "TOP " + comboBox2.Text + " ";
}
fullsql = ClassAMaincList.Listsql(txtTableName.Text, " ID,", ClassMainclass.listselect);
if (txtsimpleSearch.Text == "")
{
editview = ClassAMaincList.FilterList(txtTableName.Text, txtsimpleSearch, Text, ClassMainclass.listselect);
ClassPublicclass.Filllist(listView2, fullsql + editview);
shortsql = fullsql + editview;
}
else
{
editview = ClassAMaincList.FilterList(txtTableName.Text, txtsimpleSearch, Text, ClassMainclass.listselect);
ClassPublicclass.Filllist(listView2, fullsql + editview);
shortsql = fullsql + editview;
}
label2.Text = listView2.Items.Count.ToString();
}
}
private void Button2_Click(object sender, EventArgs e)
{
if (comboBox2.Text == "ALL")
{
ClassMainclass.listselect = "";
}
else
{
ClassMainclass.listselect = "TOP " + comboBox2.Text + " ";
}
txtsimpleSearch.Text = "";
editview = ClassAMaincList.FilterList(txtTableName.Text, txtsimpleSearch, Text, ClassMainclass.listselect);
ClassPublicclass.Filllist(listView2, fullsql + editview);
shortsql = fullsql + editview;
}
private void Filtermenow()
{
try
{
switch (comboBox2.Text)
{
case "ALL": ClassMainclass.listselect = ""; break;
case "": ClassMainclass.listselect = ""; break;
default: ClassMainclass.listselect = "TOP " + comboBox2.Text + " "; break;
}
fullsql = ClassAMaincList.Listsql(txtTableName.Text, " ID,", ClassMainclass.listselect);
editview = ClassAMaincList.FilterList(txtTableName.Text, txtsimpleSearch, Text, ClassMainclass.listselect);
fullsql = fullsql + editview;
ClassPublicclass.Filllist(listView2, fullsql + editview);
shortsql = fullsql + editview;
label2.Text = listView2.Items.Count.ToString();
}
catch { }
}
private void Button4_Click(object sender, EventArgs e)
{
var mysql = "";
filteredprint = "";
// string sign = "LIKE";
var likesign = "%";
if (cmb0 != "")
{
if (lln0 != "LIKE")
{
likesign = "";
}
mysql = "[" + cmb0 + "] " + lln0 + " '" + likesign + txt0 + likesign + "' ";
}
if (cmb1 != "")
{
if (lln1 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor0 + " [" + cmb1 + "] " + lln1 + "'" + likesign + txt1 + likesign + "'";
}
if (cmb2 != "")
{
if (lln2 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor1 + " [" + cmb2 + "] " + lln2 + "'" + likesign + txt2 + likesign + "'";
}
if (cmb3 != "")
{
if (lln3 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor2 + " [" + cmb3 + "] " + lln3 + "'" + likesign + txt3 + likesign + "'";
}
if (cmb4 != "")
{
if (lln4 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor3 + " [" + cmb4 + "] " + lln4 + "'" + likesign + txt4 + likesign + "'";
}
if (cmb5 != "")
{
if (lln5 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor4 + " [" + cmb1 + "] " + lln5 + "'" + likesign + txt5 + likesign + "'";
}
if (cmb6 != "")
{
if (lln6 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor5 + " [" + cmb6 + "] " + lln6 + "'" + likesign + txt6 + likesign + "'";
}
if (cmb7 != "")
{
if (lln7 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor6 + " [" + cmb7 + "] " + lln7 + "'" + likesign + txt7 + likesign + "'";
}
if (cmb8 != "")
{
if (lln8 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor7 + " [" + cmb8 + "] " + lln8 + "'" + likesign + txt8 + likesign + "'";
}
if (cmb9 != "")
{
if (lln9 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor8 + " [" + cmb9 + "] " + lln9 + "'" + likesign + txt9 + likesign + "'";
}
if (cmb10 != "")
{
if (lln10 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor9 + " [" + cmb10 + "] " + lln10 + "'" + likesign + txt10 + likesign + "'";
}
if (cmb11 != "")
{
if (lln11 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor10 + " [" + cmb11 + "] " + lln11 + "'" + likesign + txt11 + likesign + "'";
}
if (cmb12 != "")
{
if (lln12 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor11 + " [" + cmb12 + "] " + lln12 + "'" + likesign + txt12 + likesign + "'";
}
if (cmb13 != "")
{
if (lln13 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor12 + " [" + cmb13 + "] " + lln13 + "'" + likesign + txt13 + likesign + "'";
}
if (cmb14 != "")
{
if (lln14 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor13 + " [" + cmb14 + "] " + lln14 + "'" + likesign + txt14 + likesign + "'";
}
if (cmb15 != "")
{
if (lln15 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor14 + " [" + cmb15 + "] " + lln15 + "'" + likesign + txt15 + likesign + "'";
}
if (cmb16 != "")
{
if (lln16 != "LIKE")
{
likesign = "";
}
mysql = mysql + " " + nor15 + " [" + cmb16 + "] " + lln16 + "'" + likesign + txt16 + likesign + "'";
}
label6.Text = mysql;
var mnewsql = fullsql;
if (fullsql.Contains("where"))
{
mnewsql = mnewsql + " AND (" + mysql + ")";
}
else
{
mnewsql = mnewsql + " WHERE (" + mysql + ")";
}
ClassPublicclass.Filllist(listView2, mnewsql);
// shortsql = fullsql + " where " + mysql;
filteredprint = mnewsql;
//}
label2.Text = listView2.Items.Count.ToString();
// classPublicclass.generateFile(mnewsql);
}
public void Refreshme()
{
ClassPublicclass.Filllist(listView2, fullsql);
txtsimpleSearch.Text = "";
label2.Text = listView2.Items.Count.ToString();
}
public void Refreshlist()
{
ClassPublicclass.Filllist(listView2, fullsql);
txtsimpleSearch.Text = "";
}
public void Filllist()
{
ClassPublicclass.Filllist(listView2, fullsql);
}
