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