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; }
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; } }
private void GoButton_Click(object sender, EventArgs e) { if (Local_RB.Checked) { if (!File.Exists(Local_Rasp_TB.Text)) { MessageBox.Show("Указанного файла не существует"); return; } try { if (Password_TB.Text == "") { W4A = new Worker4Admin(true, Local_Rasp_TB.Text); } else { W4A = new Worker4Admin(true, Local_Rasp_TB.Text, Password_TB.Text); } } catch (Exception ex) { MessageBox.Show("Не удается подключиться у указанной базе данных"); return; } MessageBox.Show("Вы авторизованы!"); Form x = new AsAdministrator(W4A); x.Show(); } else { if (!File.Exists(Local_Rasp_TB.Text)) { MessageBox.Show("Указанного файла не существует"); return; } try { W4A = new Worker4Admin(false, Local_Rasp_TB.Text, "qwerty"); } catch (Exception ex) { MessageBox.Show("Не удается подключиться у указанной базе данных"); return; } MessageBox.Show("Вы авторизованы!"); Form x = new AsAdministrator(W4A); x.Show(); } }
internal OnePredpritatiyeForm_Admin(string code, string nazv, string address, string telephone, string colvo, DataTable RabotnikyPredpriyatiya, Worker4Admin W4A) { InitializeComponent(); this.W4A = W4A; this.Code_Of_Rabotnick_TB.Text = code; this.Name_TB.Text = nazv; this.Family_TB.Text = address; this.Otchestvo_TB.Text = telephone; this.Pol_TB.Text = colvo; this.DGV_Prin_Uvol_History.DataSource = RabotnikyPredpriyatiya; }
internal Admin_Person_danniye(Worker4Admin W4A) { InitializeComponent(); this.W4A = W4A; TekZapros_TB.Text = "select * from ПерсДанныеРаботников;"; GridViewTable.DataSource = W4A.GetFullTableFromZapros("ПерсДанныеРаботников"); for (int x = 0; x < PokazStolbChB.Items.Count; x++) { PokazStolbChB.SetItemChecked(x, true); } }
internal Admin_Accept_Resumes(Worker4Admin W4A, string CodeOfRabotnick, string name, string family, string otchestvo, string Pol, string date, string JelauemayaZP, string graph, string Specializes, DataTable Table) { InitializeComponent(); this.W4A = W4A; textBox1.Text = name; textBox2.Text = family; textBox3.Text = otchestvo; textBox4.Text = date; textBox5.Text = JelauemayaZP; textBox6.Text = graph; textBox7.Text = Pol; textBox8.Text = CodeOfRabotnick; richTextBox1.Text = Specializes; dataGridView1.DataSource = Table; }
internal Admin_Prin_U_Rabotnikov(Worker4Admin W4A) { InitializeComponent(); this.W4A = W4A; try { GridViewTable.DataSource = W4A.GetFullTableFromZapros("Принятия_и_увольнения_работников"); TekZapros_TB.Text = "select * from Принятия_и_увольнения_работников;"; } catch (Exception ex) { MessageBox.Show(ex.Message); } for (int x = 0; x < PokazStolbChB.Items.Count; x++) { PokazStolbChB.SetItemChecked(x, true); } }
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 Admin_Zachisleniya_Zarplat(Worker4Admin W4A) { InitializeComponent(); this.W4A = W4A; try { GridViewTable.DataSource = W4A.GetFullTableFromZapros("Зачисления_зарплат"); TekZapros_TB.Text = "select * from Зачисления_зарплат;"; } catch (Exception ex) { MessageBox.Show(ex.Message); } for (int x = 0; x < PokazStolbChB.Items.Count; x++) { PokazStolbChB.SetItemChecked(x, true); } }
internal Admin_Predpriyatiya(Worker4Admin W4A) { InitializeComponent(); this.W4A = W4A; try { GridViewTable.DataSource = W4A.GetFullTableFromZapros("Предприятия"); TekZapros_TB.Text = "select * from Предприятия;"; } catch (Exception ex) { MessageBox.Show(ex.Message); } for (int x = 0; x < PokazStolbChB.Items.Count; x++) { PokazStolbChB.SetItemChecked(x, true); } }
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(); }
internal OneRabotnickForm_Admin(string Code, string Name, string Family, string Otchestvo, string Pol, string Date, DataTable HistOfPrinAndUv, DataTable HistOfZpHistory, Worker4Admin W4A) { InitializeComponent(); this.Code_Of_Rabotnick_TB.Text = Code; this.Name_TB.Text = Name; this.Family_TB.Text = Family; this.Otchestvo_TB.Text = Otchestvo; this.Pol_TB.Text = Pol; this.Date_TB.Text = Date; this.DGV_Prin_Uvol_History.DataSource = HistOfPrinAndUv; this.DGV_ZP_History.DataSource = HistOfZpHistory; this.W4A = W4A; for (int x = 0; x < Otobr_1_Tabl.Items.Count; x++) { Otobr_1_Tabl.SetItemChecked(x, true); } for (int x = 0; x < Otobr_2_Tabl.Items.Count; x++) { Otobr_2_Tabl.SetItemChecked(x, true); } }
internal Dobavit_Vacansy(Worker4Admin W4A) { InitializeComponent(); this.W4A = W4A; }
internal Dobavit_Sotrudnika(Worker4Admin W4A) { InitializeComponent(); this.W4A = W4A; }
internal Dobavit_Zapis_Predpriyatiya(Worker4Admin W4A) { InitializeComponent(); this.W4A = W4A; }
internal OneRabotnickForm_Admin(Worker4Admin W4A) { InitializeComponent(); this.W4A = W4A; }
internal AsAdministrator(Worker4Admin W4A) { InitializeComponent(); this.W4A = W4A; }
internal Dobavit_Danniye_About_Doljnost(Worker4Admin W4A) { InitializeComponent(); this.W4A = W4A; }
internal Find_Resume(Worker4Admin W4A) { InitializeComponent(); this.W4A = W4A; }
internal ServerForm(Worker4Admin W4A) { InitializeComponent(); DataGridView_Connections.Rows.Add("192.168.0.1", "1234", "DefaultLogin", "21.12.21"); this.W4A = W4A; }