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