private void CreateSostavniyZapros_Click(object sender, EventArgs e) { string Zapros = ""; bool NeedSetAnd = false; if (!(Zapros_Code_Of_Rabotnick_ChB.Checked || Zapros_Name_ChB.Checked || Zapros_Family_ChB.Checked || Zapros_Otchestvo_ChB.Checked || Zapros_Date_ChB.Checked)) { Zapros = "select * from Предприятия;"; TekZapros_TB.Text = Zapros; GridViewTable.DataSource = W4A.GetTableFromZapros(Zapros); return; } Zapros = "select * from Предприятия where "; if (Zapros_Code_Of_Rabotnick_ChB.Checked) { switch (TabPage_Zapros_Code_Perechisleniye.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = Zapros_TextBox_Worker_Name_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_предприятия", "value", Zapros_ChBox_Worker_Name_Value.Text, "int", NeedSetAnd, Peredat, null); break; } case ("Регион"): { string[] Args = new string[2]; Args[0] = Zapros_TextBox_Worker_Name_VerkhnZnachemiye.Text; Args[1] = Zapros_TextBox_Worker_Name_NijnZnachemiye.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_предприятия", "region", Zapros_CheckBoxBox_Worker_Name_Region.Text, "int", NeedSetAnd, null, Args); break; } case ("Перечисление"): { string[] Peredat = Zapros_TextBoxBox_Worker_Name_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_предприятия", "perechisleniye", Zapros_CheckBoxBox_Worker_Name_Perechisleniye.Text, "int", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Name_ChB.Checked) { switch (Zapros_Name_TabControl.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = TextBox_Zapros_Code_Name_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Название", "value", CheckBox_Zapros_Code_Name_Value.Text, "string", NeedSetAnd, Peredat, null); break; } case ("Перечисление"): { string[] Peredat = TextBox_Zapros_Code_Name_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Название", "perechisleniye", ComboBox_Zapros_Code_Name_Perechisleniye.Text, "string", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Family_ChB.Checked) { switch (Zapros_Family_TabControl.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = TextBox_Zapros_Code_Family_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Адрес", "value", CheckBox_Zapros_Code_Family_Value.Text, "string", NeedSetAnd, Peredat, null); break; } case ("Перечисление"): { string[] Peredat = TextBox_Zapros_Code_Family_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Адрес", "perechisleniye", ComboBox_Zapros_Code_Family_Perechisleniye.Text, "string", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Otchestvo_ChB.Checked) { switch (Zapros_Otchestvo_TabControl.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = TextBox_Zapros_Code_Otchestvo_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Телефон", "value", CheckBox_Zapros_Code_Otchestvo_Value.Text, "string", NeedSetAnd, Peredat, null); break; } case ("Перечисление"): { string[] Peredat = TextBox_Zapros_Code_Otchestvo_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Телефон", "perechisleniye", ComboBox_Zapros_Code_Otchstvo_Perechisleniye.Text, "string", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Date_ChB.Checked) { switch (Zapros_CheckBoxBox_Worker_Date.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = TextBox_Zapros_Code_Date_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Количество_работников", "value", CheckBox_Zapros_Code_Date_Value.Text, "int", NeedSetAnd, Peredat, null); break; } case ("Регион"): { string[] args = new string[2]; args[0] = Zapros_TextBox_Worker_Date_VerkhnZnachemiye.Text; args[1] = Zapros_TextBox_Worker_Date_NijnZnachemiye.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Количество_работников", "region", Zapros_CheckBoxBox_Worker_Date_Region.Text, "int", NeedSetAnd, null, args); break; } case ("Перечисление"): { string[] Peredat = Zapros_TextBoxBox_Worker_Date_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Количество_работников", "perechisleniye", ComboBox_Zapros_Code_Date_Perechisleniye.Text, "int", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } Zapros = Zapros + ";"; try { GridViewTable.DataSource = W4A.GetTableFromZapros(Zapros); Reload_Pokaz_Button_Click(null, null); TekZapros_TB.Text = Zapros; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void CreateSostavniyZapros_Click(object sender, EventArgs e) { string Zapros = ""; bool NeedSetAnd = false; if (!(Zapros_Code_Of_Rabotnick_ChB.Checked || Zapros_Name_ChB.Checked || Zapros_Family_ChB.Checked || Zapros_Razm_ChB.Checked || Zapros_Date_ChB.Checked || Zapros_Code_Of_Tranzaction_ChB.Checked)) { Zapros = "select * from Зачисления_зарплат;"; TekZapros_TB.Text = Zapros; GridViewTable.DataSource = W4A.GetTableFromZapros(Zapros); return; } Zapros = "select * from Зачисления_зарплат where "; if (Zapros_Code_Of_Tranzaction_ChB.Checked) { switch (TabPage_Zapros_Tranzact_Perechisleniye.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = Zapros_TextBox_Code_Tranzact_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_транзакции", "value", Zapros_ChBox_Code_Tranzact_Value.Text, "int", NeedSetAnd, Peredat, null); break; } case ("Регион"): { string[] Args = new string[2]; Args[0] = Zapros_TextBox_Worker_Tranz_VerkhnZnachemiye.Text; Args[1] = Zapros_TextBox_Worker_Tranzact_NijnZnachemiye.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_транзакции", "region", Zapros_CheckBoxBox_Worker_Tranzact_Region.Text, "int", NeedSetAnd, null, Args); break; } case ("Перечисление"): { string[] Peredat = Zapros_TextBoxBox_Worker_Tranzact_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_транзакции", "perechisleniye", Zapros_CheckBoxBox_Worker_Tranzact_Perechisleniye.Text, "int", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Code_Of_Rabotnick_ChB.Checked) { switch (TabPage_Zapros_Code_Perechisleniye.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = Zapros_TextBox_Worker_Name_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_работника", "value", Zapros_ChBox_Worker_Name_Value.Text, "int", NeedSetAnd, Peredat, null); break; } case ("Регион"): { string[] Args = new string[2]; Args[0] = Zapros_TextBox_Worker_Name_VerkhnZnachemiye.Text; Args[1] = Zapros_TextBox_Worker_Name_NijnZnachemiye.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_работника", "region", Zapros_CheckBoxBox_Worker_Name_Region.Text, "int", NeedSetAnd, null, Args); break; } case ("Перечисление"): { string[] Peredat = Zapros_TextBoxBox_Worker_Name_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_работника", "perechisleniye", Zapros_CheckBoxBox_Worker_Name_Perechisleniye.Text, "int", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Name_ChB.Checked) { switch (Zapros_Name_TabControl.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = TextBox_Zapros_Code_Name_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Банк_зачисления", "value", CheckBox_Zapros_Code_Name_Value.Text, "string", NeedSetAnd, Peredat, null); break; } case ("Перечисление"): { string[] Peredat = TextBox_Zapros_Code_Name_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Банк_зачисления", "perechisleniye", ComboBox_Zapros_Code_Name_Perechisleniye.Text, "string", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Family_ChB.Checked) { switch (Zapros_Family_TabControl.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = TextBox_Zapros_Code_Family_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Заявленный_тип_оплаты", "value", CheckBox_Zapros_Code_Family_Value.Text, "string", NeedSetAnd, Peredat, null); break; } case ("Перечисление"): { string[] Peredat = TextBox_Zapros_Code_Family_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Заявленный_тип_оплаты", "perechisleniye", ComboBox_Zapros_Code_Family_Perechisleniye.Text, "string", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Razm_ChB.Checked) { switch (Zapros_Zachisl_TabControl.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = TextBox_Zapros_Code_Razm_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Размер_оплаты", "value", CheckBox_Zapros_Code_Razm_Value.Text, "int", NeedSetAnd, Peredat, null); break; } case ("Регион"): { string[] args = new string[2]; args[0] = Zapros_TextBox_Worker_Razm_VerkhnZnachemiye.Text; args[1] = Zapros_TextBox_Worker_Razm_NijnZnachemiye.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Размер_оплаты", "region", Zapros_CheckBoxBox_Worker_Razm_Region.Text, "int", NeedSetAnd, null, args); break; } case ("Перечисление"): { string[] Peredat = Zapros_TextBoxBox_Worker_Razm_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Размер_оплаты", "perechisleniye", Zapros_CheckBoxBox_Worker_Razm_Perechisleniye.Text, "int", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Date_ChB.Checked) { switch (Zapros_CheckBoxBox_Worker_Date.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = TextBox_Zapros_Code_Date_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Дата", "value", CheckBox_Zapros_Code_Date_Value.Text, "date", NeedSetAnd, Peredat, null); break; } case ("Регион"): { string[] args = new string[2]; args[0] = Zapros_TextBox_Worker_Date_VerkhnZnachemiye.Text; args[1] = Zapros_TextBox_Worker_Date_NijnZnachemiye.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Дата", "region", Zapros_CheckBoxBox_Worker_Date_Region.Text, "date", NeedSetAnd, null, args); break; } case ("Перечисление"): { string[] Peredat = Zapros_TextBoxBox_Worker_Date_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Дата", "perechisleniye", ComboBox_Zapros_Code_Date_Perechisleniye.Text, "date", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } Zapros = Zapros + ";"; try { GridViewTable.DataSource = W4A.GetTableFromZapros(Zapros); Reload_Pokaz_Button_Click(null, null); TekZapros_TB.Text = Zapros; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void CreateSostavniyZapros_Click(object sender, EventArgs e) { string Zapros = ""; bool NeedSetAnd = false; if (!(Zapros_Code_Of_Tranzaction_ChB.Checked || Zapros_Code_Of_Rabotnick_ChB.Checked || Zapros_Razm_ChB.Checked || checkBox1.Checked || Zapros_Name_ChB.Checked)) { Zapros = "select * from Резюме;"; TekZapros_TB.Text = Zapros; GridViewTable.DataSource = W4A.GetTableFromZapros(Zapros); return; } Zapros = "select * from Резюме where "; if (Zapros_Code_Of_Tranzaction_ChB.Checked) { switch (TabPage_Zapros_Tranzact_Perechisleniye.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = Zapros_TextBox_Code_Tranzact_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_резюме", "value", Zapros_ChBox_Code_Tranzact_Value.Text, "int", NeedSetAnd, Peredat, null); break; } case ("Регион"): { string[] Args = new string[2]; Args[0] = Zapros_TextBox_Worker_Tranz_VerkhnZnachemiye.Text; Args[1] = Zapros_TextBox_Worker_Tranzact_NijnZnachemiye.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_резюме", "region", Zapros_CheckBoxBox_Worker_Tranzact_Region.Text, "int", NeedSetAnd, null, Args); break; } case ("Перечисление"): { string[] Peredat = Zapros_TextBoxBox_Worker_Tranzact_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_резюме", "perechisleniye", Zapros_CheckBoxBox_Worker_Tranzact_Perechisleniye.Text, "int", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Code_Of_Rabotnick_ChB.Checked) { switch (TabPage_Zapros_Code_Perechisleniye.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = Zapros_TextBox_Worker_Name_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_работника", "value", Zapros_ChBox_Worker_Name_Value.Text, "int", NeedSetAnd, Peredat, null); break; } case ("Регион"): { string[] Args = new string[2]; Args[0] = Zapros_TextBox_Worker_Name_VerkhnZnachemiye.Text; Args[1] = Zapros_TextBox_Worker_Name_NijnZnachemiye.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_работника", "region", Zapros_CheckBoxBox_Worker_Name_Region.Text, "int", NeedSetAnd, null, Args); break; } case ("Перечисление"): { string[] Peredat = Zapros_TextBoxBox_Worker_Name_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_работника", "perechisleniye", Zapros_CheckBoxBox_Worker_Name_Perechisleniye.Text, "int", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Razm_ChB.Checked) { switch (Zapros_Zachisl_TabControl.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = TextBox_Zapros_Code_Razm_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Образование", "value", CheckBox_Zapros_Code_Razm_Value.Text, "string", NeedSetAnd, Peredat, null); break; } case ("Перечисление"): { string[] Peredat = Zapros_TextBoxBox_Worker_Razm_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Образование", "perechisleniye", Zapros_CheckBoxBox_Worker_Razm_Perechisleniye.Text, "string", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (checkBox1.Checked) { switch (tabControl1.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = textBox1.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Желаемая_з_п", "value", comboBox1.Text, "int", NeedSetAnd, Peredat, null); break; } case ("Регион"): { string[] Args = new string[2]; Args[0] = textBox3.Text; Args[1] = textBox2.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Желаемая_з_п", "region", comboBox2.Text, "int", NeedSetAnd, null, Args); break; } case ("Перечисление"): { string[] Peredat = richTextBox1.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Желаемая_з_п", "perechisleniye", comboBox3.Text, "int", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Name_ChB.Checked) { switch (Zapros_Name_TabControl.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = TextBox_Zapros_Code_Name_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("График", "value", CheckBox_Zapros_Code_Name_Value.Text, "string", NeedSetAnd, Peredat, null); break; } case ("Перечисление"): { string[] Peredat = TextBox_Zapros_Code_Name_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("График", "perechisleniye", ComboBox_Zapros_Code_Name_Perechisleniye.Text, "string", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } Zapros = Zapros + ";"; try { GridViewTable.DataSource = W4A.GetTableFromZapros(Zapros); Reload_Pokaz_Button_Click(null, null); TekZapros_TB.Text = Zapros; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void CreateSostavniyZapros_Click(object sender, EventArgs e) { string Zapros = ""; bool NeedSetAnd = false; if (!(Zapros_Code_Of_Tranzaction_ChB.Checked || Zapros_Code_Of_Rabotnick_ChB.Checked || Zapros_Razm_ChB.Checked || Zapros_Pol_ChB.Checked || checkBox1.Checked || Zapros_Date_ChB.Checked)) { Zapros = "select * from Вакансии;"; TekZapros_TB.Text = Zapros; GridViewTable.DataSource = W4A.GetTableFromZapros(Zapros); return; } Zapros = "select * from Вакансии where "; if (Zapros_Code_Of_Tranzaction_ChB.Checked) { switch (TabPage_Zapros_Tranzact_Perechisleniye.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = Zapros_TextBox_Code_Tranzact_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_записи", "value", Zapros_ChBox_Code_Tranzact_Value.Text, "int", NeedSetAnd, Peredat, null); break; } case ("Регион"): { string[] Args = new string[2]; Args[0] = Zapros_TextBox_Worker_Tranz_VerkhnZnachemiye.Text; Args[1] = Zapros_TextBox_Worker_Tranzact_NijnZnachemiye.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_записи", "region", Zapros_CheckBoxBox_Worker_Tranzact_Region.Text, "int", NeedSetAnd, null, Args); break; } case ("Перечисление"): { string[] Peredat = Zapros_TextBoxBox_Worker_Tranzact_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_записи", "perechisleniye", Zapros_CheckBoxBox_Worker_Tranzact_Perechisleniye.Text, "int", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Code_Of_Rabotnick_ChB.Checked) { switch (TabPage_Zapros_Code_Perechisleniye.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = Zapros_TextBox_Worker_Name_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Специальность", "value", Zapros_ChBox_Worker_Name_Value.Text, "string", NeedSetAnd, Peredat, null); break; } case ("Перечисление"): { string[] Peredat = Zapros_TextBoxBox_Worker_Name_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Специальность", "perechisleniye", Zapros_CheckBoxBox_Worker_Name_Perechisleniye.Text, "string", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Razm_ChB.Checked) { switch (Zapros_Zachisl_TabControl.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = TextBox_Zapros_Code_Razm_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_предприятия", "value", CheckBox_Zapros_Code_Razm_Value.Text, "int", NeedSetAnd, Peredat, null); break; } case ("Регион"): { string[] Args = new string[2]; Args[0] = Zapros_TextBox_Worker_Razm_VerkhnZnachemiye.Text; Args[1] = Zapros_TextBox_Worker_Razm_NijnZnachemiye.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_предприятия", "region", Zapros_CheckBoxBox_Worker_Razm_Region.Text, "int", NeedSetAnd, null, Args); break; } case ("Перечисление"): { string[] Peredat = Zapros_TextBoxBox_Worker_Razm_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Код_предприятия", "perechisleniye", Zapros_CheckBoxBox_Worker_Razm_Perechisleniye.Text, "int", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Pol_ChB.Checked) { if (NeedSetAnd) { Zapros = Zapros + " and "; } else { NeedSetAnd = true; } if (Zapros_Pol_ComboBox.Text == "Да") { Zapros = Zapros + " Можно_до_18= true"; } else if (Zapros_Pol_ComboBox.Text == "Нет") { Zapros = Zapros + " Можно_до_18= false"; } } if (checkBox1.Checked) { switch (tabControl1.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = textBox1.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Заявленная_заработная_плата", "value", comboBox1.Text, "int", NeedSetAnd, Peredat, null); break; } case ("Регион"): { string[] Args = new string[2]; Args[0] = textBox3.Text; Args[1] = textBox2.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Заявленная_заработная_плата", "region", comboBox2.Text, "int", NeedSetAnd, null, Args); break; } case ("Перечисление"): { string[] Peredat = richTextBox1.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Заявленная_заработная_плата", "perechisleniye", comboBox3.Text, "int", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } if (Zapros_Date_ChB.Checked) { switch (Zapros_CheckBoxBox_Worker_Date.SelectedTab.Text) { case ("Значение"): { string[] Peredat = new string[1]; Peredat[0] = TextBox_Zapros_Code_Date_Value.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Актуально_до", "value", CheckBox_Zapros_Code_Date_Value.Text, "date", NeedSetAnd, Peredat, null); break; } case ("Регион"): { string[] args = new string[2]; args[0] = Zapros_TextBox_Worker_Date_VerkhnZnachemiye.Text; args[1] = Zapros_TextBox_Worker_Date_NijnZnachemiye.Text; Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Актуально_до", "region", Zapros_CheckBoxBox_Worker_Date_Region.Text, "date", NeedSetAnd, null, args); break; } case ("Перечисление"): { string[] Peredat = Zapros_TextBoxBox_Worker_Date_Perechisleniye.Text.Split(' '); Zapros = Zapros + W4A.ReturnChastZaprosaFromArguments("Актуально_до", "perechisleniye", ComboBox_Zapros_Code_Date_Perechisleniye.Text, "date", NeedSetAnd, Peredat, null); break; } } NeedSetAnd = true; } Zapros = Zapros + ";"; try { GridViewTable.DataSource = W4A.GetTableFromZapros(Zapros); Reload_Pokaz_Button_Click(null, null); TekZapros_TB.Text = Zapros; } catch (Exception ex) { MessageBox.Show(ex.Message); } }