private void GoToCode_Btn_Click(object sender, EventArgs e)
{
DataTable DT = W4A.GetTableFromZapros("select * from ПерсДанныеРаботников where Код_работника = " + GoToCode_TB.Text);
if (DT.Rows.Count < 1)
{
MessageBox.Show("Пользователь с таким кодом отсутствует");
return;
}
DataRow DR = DT.Rows[0];
this.Code_Of_Rabotnick_TB.Text = DR[0].ToString();
this.Name_TB.Text = DR[1].ToString();
this.Family_TB.Text = DR[2].ToString();
this.Otchestvo_TB.Text = DR[3].ToString();
this.Pol_TB.Text = DR[4].ToString();
this.Date_TB.Text = DR[5].ToString();
DataTable DT2 = W4A.GetTableFromZapros("select * from Зачисления_зарплат where Код_работника=" + Code_Of_Rabotnick_TB.Text + ";");
if (DT2.Rows.Count != 0)
{
DGV.DataSource = DT2;
}
else
{
MessageBox.Show("Пользователь с таким кодом отсутствует");
}
}
internal Pokaz_History_Zachisleniya(Worker4Admin W4A)
{
InitializeComponent();
this.W4A = W4A;
DataTable DT = W4A.GetTableFromZapros("select top 1 * from ПерсДанныеРаботников");
DataRow DR = null;
if (DT.Rows.Count == 0)
{
MessageBox.Show("Записей нет");
this.Close();
}
DR = DT.Rows[0];
this.Code_Of_Rabotnick_TB.Text = DR[0].ToString();
this.Name_TB.Text = DR[1].ToString();
this.Family_TB.Text = DR[2].ToString();
this.Otchestvo_TB.Text = DR[3].ToString();
this.Pol_TB.Text = DR[4].ToString();
this.Date_TB.Text = DR[5].ToString();
DataTable DT2 = W4A.GetTableFromZapros("select * from Зачисления_зарплат where Код_работника=" + Code_Of_Rabotnick_TB.Text + ";");
if (DT2.Rows.Count != 0)
{
DGV.DataSource = DT2;
}
}
internal OneRabotnickForm_Admin(string Code, Worker4Admin W4A)
{
InitializeComponent();
this.Code_Of_Rabotnick_TB.Text = Code;
DataTable DT = W4A.GetTableFromZapros("select * from ПерсДанныеРаботников where Код_работника = " + Code + ";");
DataRow DR = null;
if (DT.Rows.Count == 0)
{
MessageBox.Show("Записей больше нет");
this.Close();
}
DR = DT.Rows[0];
this.Code_Of_Rabotnick_TB.Text = DR[0].ToString();
this.Name_TB.Text = DR[1].ToString();
this.Family_TB.Text = DR[2].ToString();
this.Otchestvo_TB.Text = DR[3].ToString();
this.Pol_TB.Text = DR[4].ToString();
this.Date_TB.Text = DR[5].ToString();
this.W4A = W4A;
}
private void GoToCode_Btn_Click(object sender, EventArgs e)
{
DataTable DT = W4A.GetTableFromZapros("select * from Специальности where Код_специальности = " + GoToCode_TB.Text);
if (DT.Rows.Count < 1)
{
MessageBox.Show("Запись не найдена");
return;
}
DataRow DR = DT.Rows[0];
this.Code_Of_Rabotnick_TB.Text = DR[0].ToString();
this.Name_TB.Text = DR[1].ToString();
this.Family_TB.Text = DR[2].ToString();
}
private void GoToCode_Btn_Click(object sender, EventArgs e)
{
DataTable DT = W4A.GetTableFromZapros("select * from Предприятия where Код_предприятия = " + GoToCode_TB.Text + ";");
if (DT.Rows.Count < 1)
{
MessageBox.Show("Запись не найдена");
return;
}
DataRow DR = DT.Rows[0];
this.Code_Of_Rabotnick_TB.Text = DR[0].ToString();
this.Name_TB.Text = DR[1].ToString();
this.Family_TB.Text = DR[2].ToString();
this.Otchestvo_TB.Text = DR[3].ToString();
this.Pol_TB.Text = DR[4].ToString();
}
private void FindButton_Click(object sender, EventArgs e)
{
string[] specializes = textBox1.Text.Split(' ');
string vstavSpecializes = "(";
bool uje_bilo = false;
foreach (string x in specializes)
{
if (uje_bilo)
{
vstavSpecializes = vstavSpecializes + ",'" + x + "'";
}
else
{
vstavSpecializes = vstavSpecializes + "'" + x + "'";
uje_bilo = true;
}
}
vstavSpecializes = vstavSpecializes + ")";
string[] graphic1 = textBox3.Text.Split(' ');
string graphic2 = "(";
bool uje_bilo1 = false;
foreach (string x in graphic1)
{
if (uje_bilo1)
{
graphic2 = graphic2 + ",'" + x + "'";
}
else
{
graphic2 = graphic2 + "'" + x + "'";
uje_bilo1 = true;
}
}
graphic2 = graphic2 + ")";
DataTable DT = W4A.GetTableFromZapros("select * from Резюме where Специальность in " + vstavSpecializes + " and Желаемая_з_п <= " + textBox2.Text + " and График in " + graphic2 + ";");
dataGridView1.DataSource = DT;
}
internal Find_Danniye_About_Doljnost(Worker4Admin W4A)
{
InitializeComponent();
this.W4A = W4A;
DataTable DT = W4A.GetTableFromZapros("select top 1 * from Специальности");
DataRow DR = null;
if (DT.Rows.Count == 0)
{
MessageBox.Show("Записей нет");
this.Close();
}
DR = DT.Rows[0];
this.Code_Of_Rabotnick_TB.Text = DR[0].ToString();
this.Name_TB.Text = DR[1].ToString();
this.Family_TB.Text = DR[2].ToString();
}
internal Find_Zapis_Predpriyatiya(Worker4Admin W4A, string code)
{
InitializeComponent();
this.W4A = W4A;
DataTable DT = W4A.GetTableFromZapros("select * from Предприятия where Код_предприятия = " + code + ";");
DataRow DR = null;
if (DT.Rows.Count == 0)
{
MessageBox.Show("Запись отсутствует");
this.Close();
}
DR = DT.Rows[0];
this.Code_Of_Rabotnick_TB.Text = DR[0].ToString();
this.Name_TB.Text = DR[1].ToString();
this.Family_TB.Text = DR[2].ToString();
this.Otchestvo_TB.Text = DR[3].ToString();
this.Pol_TB.Text = DR[4].ToString();
}
private void GoToCode_Btn_Click(object sender, EventArgs e)
{
DataTable DT = W4A.GetTableFromZapros("select * from ПерсДанныеРаботников where Код_работника = " + GoToCode_TB.Text);
if (DT.Rows.Count < 1)
{
MessageBox.Show("Пользователь с таким кодом отсутствует");
return;
}
DataRow DR = DT.Rows[0];
this.Code_Of_Rabotnick_TB.Text = DR[0].ToString();
this.Name_TB.Text = DR[1].ToString();
this.Family_TB.Text = DR[2].ToString();
this.Otchestvo_TB.Text = DR[3].ToString();
this.Pol_TB.Text = DR[4].ToString();
this.Date_TB.Text = DR[5].ToString();
DataTable DTable_Prin = W4A.GetTableFromZapros("select * from Принятия_и_увольнения_работников where Код_работника = " + GoToCode_TB.Text);
/*CheckedListBox.CheckedIndexCollection CLB_CIC1 = Otobr_1_Tabl.CheckedIndices;
* for(int x = DTable_Prin.Columns.Count; x>0; x--)
* {
* if(!CLB_CIC1.Contains(x-1))
* {
* DTable_Prin.Columns.RemoveAt(x-1);
* }
* }*/
this.DGV_Prin_Uvol_History.DataSource = DTable_Prin;
DataTable DTable_Hist = W4A.GetTableFromZapros("select * from Зачисления_зарплат where Код_работника = " + GoToCode_TB.Text);
/*CheckedListBox.CheckedIndexCollection CLB_CIC2 = Otobr_2_Tabl.CheckedIndices;
* for (int x = DTable_Hist.Columns.Count; x > 0; x--)
* {
* if (!CLB_CIC2.Contains(x - 1))
* {
* DTable_Hist.Columns.RemoveAt(x - 1);
* }
* }*/
this.DGV_ZP_History.DataSource = DTable_Hist;
Refresh_Demonstration_Buttom_Click(null, null);
}
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_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_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 || 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);
}
}
private void FindButton_Click_1(object sender, EventArgs e)
{
if (!((checkBox1.Checked) || (checkBox3.Checked) || (checkBox4.Checked) || (checkBox5.Checked)))
{
dataGridView1.DataSource = W4A.GetTableFromZapros("select * from Вакансии");
return;
}
string Zapros = "select * from Вакансии where ";
bool NeedAnd = false;
if (checkBox1.Checked)
{
bool first = true;
string[] Specizlices = textBox1.Text.Split(' ');
string insert = "(";
foreach (string x in Specizlices)
{
if (first)
{
insert = insert + "'" + x + "'";
first = false;
}
else
{
insert = insert + ",'" + x + "'";
}
}
insert = insert + ")";
if (NeedAnd)
{
Zapros = Zapros + " and ";
}
else
{
NeedAnd = true;
}
Zapros = Zapros + "Специальность in " + insert;
}
if (checkBox3.Checked)
{
if (NeedAnd)
{
Zapros = Zapros + " and ";
}
else
{
NeedAnd = true;
}
Zapros = Zapros + "Можно_до_18 = " + checkBox2.Checked;
}
if (checkBox4.Checked)
{
if (NeedAnd)
{
Zapros = Zapros + " and ";
}
else
{
NeedAnd = true;
}
Zapros = Zapros + "Заявленная_заработная_плата >= " + textBox2.Text;
}
if (checkBox5.Checked)
{
bool first = true;
string[] Specizlices = textBox3.Text.Split(' ');
string insert = "(";
foreach (string x in Specizlices)
{
if (first)
{
insert = insert + "'" + x + "'";
first = false;
}
else
{
insert = insert + ",'" + x + "'";
}
}
insert = insert + ")";
if (NeedAnd)
{
Zapros = Zapros + " and ";
}
else
{
NeedAnd = true;
}
Zapros = Zapros + "График in" + insert;
}
Zapros = Zapros + ";";
dataGridView1.DataSource = W4A.GetTableFromZapros(Zapros);
}
