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