private void button6_Click(object sender, EventArgs e) { filter_bill f = new filter_bill(); f.ShowDialog(); if (Data_bill.date_from != false || Data_bill.ser_num != false || Data_bill.ser_aggr != false || Data_bill.crp != false || Data_bill.inn != false || Data_bill.pinfl != false || Data_bill.code_nds != false || Data_bill.name != false || Data_bill.serv != false || Data_bill.status != false || Data_bill.fio != false) { string request = ""; string name_cl = ""; OracleCommand cmd = con.CreateCommand(); if (Data_bill.date_from == true) { request = $" AND date_of_bill >= '{Data_bill.s_date_from}' AND date_of_bill <= '{Data_bill.s_date_to}' "; } if (Data_bill.ser_num == true) { request = request + $" AND num_aggr = {Data_bill.s_ser_num} "; } if (Data_bill.ser_aggr == true) { request = request + $" AND sres_aggr = '{Data_bill.s_ser_aggr}' "; } if (Data_bill.crp == true) { request = request + $" AND CRP_CD = {Data_bill.s_crp} "; } if (Data_bill.name == true) { for (int i = 0; i < Data_bill.s_name.Length; i++) { if (Data_bill.s_name[i] == '%') { name_cl += '_'; } else { name_cl += Data_bill.s_name[i]; } } request = request + $" AND CRP_NM LIKE '%{name_cl}%' "; } if (Data_bill.inn == true) { request = request + $" AND dist_id_2 = '{Data_bill.s_inn}'"; } if (Data_bill.pinfl == true) { request = request + $" AND pinfl = '{Data_bill.s_pinfl}'"; } if (Data_bill.code_nds == true) { request = request + $" and nds = '{Data_bill.s_code_nds}'"; } if (Data_bill.serv == true) { request = request + $" AND type_sres = '{Data_bill.s_serv}'"; } if (Data_bill.fio == true) { request = request + $" AND fio = '{Data_bill.s_fio}'"; } if (Data_bill.status == true) { request = request + $" AND state = '{Data_bill.s_status}'"; } if (Data_bill.its_ok) { string str = "SELECT * from table_billing where 1 = 1 " + request + "order by num_of_bill desc "; cmd.CommandText = str; bool find_val = false; cmd.CommandType = CommandType.Text; OracleDataReader dr = cmd.ExecuteReader(); try { if (dr.Read()) { LoadData(str); } else { MessageBox.Show("Не найдено по данному запросу!"); } } catch { } } Data_bill.clear(); } }
private void filtr_Click(object sender, EventArgs e) { filter_for_invoice r = new filter_for_invoice(); r.StartPosition = FormStartPosition.CenterParent; r.ShowDialog(); if (Data_bill.date_from != false || Data_bill.ser_num != false || Data_bill.ser_aggr != false || Data_bill.crp != false || Data_bill.inn != false || Data_bill.pinfl != false || Data_bill.code_nds != false || Data_bill.name != false || Data_bill.serv != false || Data_bill.status != false || Data_bill.fio != false) { string request = ""; string name_cl = ""; OracleCommand cmd = con.CreateCommand(); if (Data_bill.date_from == true) { request = $" AND DATE_T >= '{Data_bill.s_date_from}' AND DATE_T <= '{Data_bill.s_date_to}' "; } if (Data_bill.ser_num == true) { request = request + $" AND ser LIKE '{Data_bill.s_ser_num}/%'"; } if (Data_bill.ser_aggr == true) { request = request + $" AND ser LIKE '%/{Data_bill.s_ser_aggr}'"; } if (Data_bill.crp == true) { request = request + $" AND CRP = {Data_bill.s_crp} "; } if (Data_bill.name == true) { for (int i = 0; i < Data_bill.s_name.Length; i++) { if (Data_bill.s_name[i] == '%') { name_cl += '_'; } else { name_cl += Data_bill.s_name[i]; } } request = request + $" AND CRP_NM LIKE '%{name_cl}%' "; } if (Data_bill.inn == true) { request = request + $" AND INN = '{Data_bill.s_inn}'"; } if (Data_bill.pinfl == true) { request = request + $" AND NDS_PINFL = '{Data_bill.s_pinfl}' AND IF_FIZ = 1"; } if (Data_bill.code_nds == true) { request = request + $" AND NDS_PINFL = '{Data_bill.s_code_nds}' AND IF_FIZ = 0"; } if (Data_bill.serv == true) { request = request + $" AND SERVICE_T = '{Data_bill.s_serv}'"; } if (Data_bill.fio == true) { request = request + $" AND FIO = '{Data_bill.s_fio}'"; } if (Data_bill.status == true) { request = request + $" AND STATUS = '{Data_bill.s_status}'"; } if (Data_bill.its_ok) { string str = "SELECT * from registration_of_invoice where 1 = 1 " + request + " order by ID desc "; cmd.CommandText = str; cmd.CommandType = CommandType.Text; OracleDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { LoadData(str); } else { MessageBox.Show("Не найдено по данному запросу!"); } Data_bill.clear(); } } }