private void buttonRegister_Click(object sender, EventArgs e) { if (textBox1.Text.Contains(' ') || textBox2.Text.Contains(' ')) { MessageBox.Show("Введите корректные значения"); return; } else if (textBox1.Text == "Правки и изменения" || textBox2.Text == "Статус документа") { MessageBox.Show("Введите данные"); return; } DateTime dt = DateTime.Now; string curDate = dt.ToShortDateString(); DB db = new DB(); MySqlCommand command1 = new MySqlCommand("UPDATE DOKUMENT " + "SET `Дата` = CURDATE()," + " Текущий_статус = @stat," + " Правки_и_изменения = @prav " + "where id = @doc_id", db.getConnection()); MySqlCommand command2 = new MySqlCommand("UPDATE HISTORY " + "SET `Дата_Отправки` = CURDATE()" + " WHERE DOKUMENT_id = (SELECT id FROM DOKUMENT WHERE `id` = @idv) AND `Дата_Отправки` IS NULL", db.getConnection()); command1.Parameters.Add("@prav", MySqlDbType.VarChar).Value = textBox1.Text; command1.Parameters.Add("@stat", MySqlDbType.VarChar).Value = textBox2.Text; //command1.Parameters.Add("@time", MySqlDbType.Date).Value = curDate; command1.Parameters.Add("@doc_id", MySqlDbType.Int32).Value = id_doc.Value; //command2.Parameters.Add("@time", MySqlDbType.Date).Value = curDate; command2.Parameters.Add("@idv", MySqlDbType.VarChar).Value = id_doc.Value; db.openConnection(); if (command1.ExecuteNonQuery() == 1) { command2.ExecuteNonQuery(); MessageBox.Show("Запись добавлена"); } else { MessageBox.Show("Запись не добавлена"); } db.closeConnection(); }
private void buttonRegister_Click(object sender, EventArgs e) { if (textBox1_name.Text.Contains(' ')) { MessageBox.Show("Введите корректные значения"); return; } else if (textBox1_name.Text == "Наименование подразделения") { MessageBox.Show("Введите данные"); return; } if (isUserExists()) { return; } DB db = new DB(); MySqlCommand command = new MySqlCommand("INSERT INTO `oborot`.`PODRAZDELENIE` (`Наименование_подразделения`) VALUES (@name)", db.getConnection()); MySqlCommand command1 = new MySqlCommand("INSERT INTO PODRAZDELENIE " + "SET `Наименование_подразделения` = @name)", db.getConnection()); //Может пригодится //MySqlCommand command1 = new MySqlCommand("INSERT INTO company " + // "SET `Наименование` = @name, `E-mail` = @mail, `ОГРН` = @ogrn, `ИНН` = @inn, `КПП` = @kpp," + // " gen_direct_id = (SELECT id FROM gen_direct WHERE `id` = @direct)", db.getConnection()); command.Parameters.Add("@name", MySqlDbType.VarChar).Value = textBox1_name.Text; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Запись добавлена"); } else { MessageBox.Show("Запись не добавлена"); } db.closeConnection(); }
private void buttonRegister_Click(object sender, EventArgs e) { if (textBox1.Text.Contains(' ') || textBox2.Text.Contains(' ') || textBox3.Text.Contains(' ') || openFileDialog1.FileName == "") { MessageBox.Show("Введите корректные значения"); return; } else if (textBox1.Text == "Статус документа" || textBox2.Text == "Правки и изменения" || textBox3.Text == "Тип документа" || openFileDialog1.FileName == "") { MessageBox.Show("Введите данные"); return; } if (FileMove() == false) { MessageBox.Show("error"); return; } DB db = new DB(); MySqlCommand command1 = new MySqlCommand("INSERT INTO DOKUMENT " + "SET `Дата` = CURDATE(), `Содержание` = @name, `Текущий_статус` = @stat, `Правки_и_изменения` = @text," + " TIP_DOKUMENTA_id = @tip_id", db.getConnection()); command1.Parameters.Add("@stat", MySqlDbType.VarChar).Value = textBox1.Text; command1.Parameters.Add("@name", MySqlDbType.VarChar).Value = openFileDialog1.SafeFileName; command1.Parameters.Add("@text", MySqlDbType.VarChar).Value = textBox2.Text; command1.Parameters.Add("@tip_id", MySqlDbType.Int32).Value = textBox3.Text; db.openConnection(); if (command1.ExecuteNonQuery() == 1) { MessageBox.Show("Запись добавлена"); } else { MessageBox.Show("Запись не добавлена"); } db.closeConnection(); }
private void button3_Click_1(object sender, EventArgs e) { flagTbl = "0"; string ids = dataGridView1[0, dataGridView1.CurrentRow.Index].Value.ToString(); int id = int.Parse(ids); DateTime date = DateTime.Now; DB db = new DB(); MySqlDataReader reader; MySqlCommand slka = new MySqlCommand("select Ссылка from `doc` where id = @uL", db.getConnection()); slka.Parameters.Add("@uL", MySqlDbType.Int32).Value = id; MySqlCommand command1 = new MySqlCommand("INSERT INTO work_user_doc " + "SET `Время` = @time," + " users_id = (SELECT id FROM users WHERE `Логин` = @idu)," + " doc_id = (SELECT id FROM doc WHERE `id` = @idd)", db.getConnection()); command1.Parameters.Add("@time", MySqlDbType.DateTime).Value = date; command1.Parameters.Add("@idu", MySqlDbType.VarChar).Value = login.Value; command1.Parameters.Add("@idd", MySqlDbType.Int32).Value = id; db.openConnection(); if (command1.ExecuteNonQuery() == 1) { MessageBox.Show("Принят в работу"); } else { MessageBox.Show("Не принят в работу"); } reader = slka.ExecuteReader(); while (reader.Read()) { slka1 = reader["Ссылка"].ToString(); } db.closeConnection(); }
private void buttonRegister_Click(object sender, EventArgs e) { DateTime dt1 = dateTimePicker1.Value; DateTime dt2 = dateTimePicker2.Value; if (textBox1_ind.Text.Contains(' ') || textBox1_obl.Text.Contains(' ')) { MessageBox.Show("Введите корректные значения"); return; } else if (textBox1_ind.Text == "id сотрудника" || textBox1_obl.Text == "id документа") { MessageBox.Show("Введите данные"); return; } DB db = new DB(); MySqlCommand command = new MySqlCommand("INSERT INTO `oborot`.`HISTORY` (`Дата_Получения`, `SOTRUDNIK_id`, `DOKUMENT_id`," + " `Дата_Отправки`)" + " VALUES (@otch, @name, @surname, @pol)", db.getConnection()); command.Parameters.Add("@name", MySqlDbType.VarChar).Value = textBox1_ind.Text; command.Parameters.Add("@surname", MySqlDbType.VarChar).Value = textBox1_obl.Text; command.Parameters.Add("@otch", MySqlDbType.Date).Value = dt1; command.Parameters.Add("@pol", MySqlDbType.Date).Value = dt2; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Запись добавлена"); } else { MessageBox.Show("Запись не добавлена"); } db.closeConnection(); }
private void button1_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select * from users", db.getConnection()); db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); }
public void noneid_DOLZNOST() { string ids = dataGridView1[0, dataGridView1.CurrentRow.Index].Value.ToString(); DB db = new DB(); MySqlCommand command = new MySqlCommand("DELETE FROM DOLZNOST " + " WHERE `id` = @idx", db.getConnection()); command.Parameters.Add("@idx", MySqlDbType.Int32).Value = ids; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Запись удалена"); } else { MessageBox.Show("Запись не удалена"); } db.closeConnection(); }
private void buttonRegister_Click(object sender, EventArgs e) { if (textBox1.Text.Contains(' ') || textBox2.Text.Contains(' ') || textBox3.Text.Contains(' ')) { MessageBox.Show("Введите корректные значения"); return; } else if (textBox1.Text == "Логин" || textBox2.Text == "Пароль" || textBox3.Text == "id сотрудника") { MessageBox.Show("Введите данные"); return; } if (isUserExists()) { return; } DB db = new DB(); MySqlCommand command = new MySqlCommand("INSERT INTO `oborot`.`vxod` (`login`, `password`, `SOTRUDNIK_id`) VALUES (@name, @info, @sotr_id)", db.getConnection()); command.Parameters.Add("@name", MySqlDbType.VarChar).Value = textBox1.Text; command.Parameters.Add("@info", MySqlDbType.VarChar).Value = textBox2.Text; command.Parameters.Add("@sotr_id", MySqlDbType.VarChar).Value = textBox3.Text; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Запись добавлена"); } else { MessageBox.Show("Запись не добавлена"); } db.closeConnection(); }
private void buttonRegister_Click(object sender, EventArgs e) { if (textBox1_name.Text.Contains(' ')) { MessageBox.Show("Введите корректное значение"); return; } else if (textBox1_name.Text == "Наименование_должности") { MessageBox.Show("Введите данные"); return; } if (isUserExists()) { return; } DB db = new DB(); MySqlCommand command = new MySqlCommand("INSERT INTO `oborot`.`DOLZNOST` (`Наименование_должности`)" + " VALUES (@name)", db.getConnection()); command.Parameters.Add("@name", MySqlDbType.VarChar).Value = textBox1_name.Text; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Запись добавлена"); } else { MessageBox.Show("Запись не добавлена"); } db.closeConnection(); }
private void buttonRegister_Click(object sender, EventArgs e) { if (textBox1.Text.Contains(' ') || textBox2.Text.Contains(' ') || textBox3.Text.Contains(' ')) { MessageBox.Show("Введите корректные значения"); return; } else if (textBox1.Text == "Время входа" || textBox2.Text == "Время выхода" || textBox2.Text == "Логин пользователя") { MessageBox.Show("Введите данные"); return; } DB db = new DB(); MySqlCommand command1 = new MySqlCommand("INSERT INTO session " + "SET `Вход` = @vh, `Выход` = @vhd," + " users_id = (SELECT id FROM users WHERE `Логин` = @log)", db.getConnection()); command1.Parameters.Add("@vh", MySqlDbType.VarChar).Value = textBox1.Text; command1.Parameters.Add("@vhd", MySqlDbType.VarChar).Value = textBox2.Text; command1.Parameters.Add("@log", MySqlDbType.VarChar).Value = textBox3.Text; db.openConnection(); if (command1.ExecuteNonQuery() == 1) { MessageBox.Show("Запись добавлена"); } else { MessageBox.Show("Запись не добавлена"); } db.closeConnection(); }
private void label9_Click(object sender, EventArgs e) { flagTable = 7; flagTbl = "DOKUMENT"; ds.Reset(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select id, Дата, Текущий_статус, Правки_и_изменения, TIP_DOKUMENTA_id from DOKUMENT", db.getConnection()); db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); }
private void button4_Click(object sender, EventArgs e) { button5.Visible = false; FlagTbl = "3"; ds.Reset(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select * from `HISTORY` where Дата_Отправки > 0", db.getConnection()); db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); }
private void buttonRegister_Click(object sender, EventArgs e) { DB db = new DB(); MySqlCommand command = new MySqlCommand("INSERT INTO `oborot`.`history` (`Дата_Получения`, SOTRUDNIK_id, DOKUMENT_id)" + " VALUES (CURDATE(), @sotr_id, @doc_id)", db.getConnection()); command.Parameters.Add("@sotr_id", MySqlDbType.Int32).Value = id; command.Parameters.Add("@doc_id", MySqlDbType.Int32).Value = id_doc.Value; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Запись добавлена"); } else { MessageBox.Show("Запись не добавлена"); } db.closeConnection(); }
private void label11_Click(object sender, EventArgs e) { flagTable = 9; flagTbl = "gotov_doc"; ds.Reset(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select * from gotov_doc", db.getConnection()); db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); }
public ShowUsers() { InitializeComponent(); DataSet ds = new DataSet(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select * from users", db.getConnection()); db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); }
private void button1_Click(object sender, EventArgs e) { button5.Visible = true; FlagTbl = "1"; ds.Reset(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select `DOKUMENT`.`id`, `Дата`, `Содержание`, `Текущий_статус`, `Правки_и_изменения`, `Тип_Документа`" + " from DOKUMENT join `TIP_DOKUMENTA` on TIP_DOKUMENTA_id = TIP_DOKUMENTA.id" + " where DOKUMENT.id NOT IN (SELECT DOKUMENT_id FROM HISTORY)", db.getConnection()); db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); }
private void LoadData() { DB db = new DB(); DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand("Selet * from users order by id", db.getConnection()); db.openConnection(); adapter.SelectCommand = command; adapter.Fill(table); List <string[]> data = new List <string[]>(); /* * while (table.Rows.Count()) * { * data.Add(new string[3]); * * data[data.Count - 1][0] = reader[0].ToString(); * data[data.Count - 1][1] = reader[1].ToString(); * data[data.Count - 1][2] = reader[2].ToString(); * } * * reader.Close(); * * myConnection.Close(); * * foreach (string[] s in data) * dataGridView1.Rows.Add(s); */ db.closeConnection(); }
private void buttonRegister_Click(object sender, EventArgs e) { DB db = new DB(); MySqlDataReader reader; MySqlCommand command_log = new MySqlCommand("select sotrudnik.id from `sotrudnik` join vxod on SOTRUDNIK.id = SOTRUDNIK_id WHERE login = @login", db.getConnection()); command_log.Parameters.Add("@login", MySqlDbType.VarChar).Value = userNameField.Text; db.openConnection(); reader = command_log.ExecuteReader(); while (reader.Read()) { log_id = reader["id"].ToString(); } db.closeConnection(); MySqlCommand command_vxod_id = new MySqlCommand("select vxod.id from `sotrudnik` join vxod on SOTRUDNIK.id = SOTRUDNIK_id WHERE login = @login", db.getConnection()); command_vxod_id.Parameters.Add("@login", MySqlDbType.VarChar).Value = userNameField.Text; db.openConnection(); reader = command_vxod_id.ExecuteReader(); while (reader.Read()) { vxod_id = reader["id"].ToString(); } db.closeConnection(); MySqlCommand command_del_vxod = new MySqlCommand("DELETE FROM `oborot`.`vxod` WHERE (`id` = @vxod_id);", db.getConnection()); command_del_vxod.Parameters.Add("@vxod_id", MySqlDbType.VarChar).Value = vxod_id; db.openConnection(); command_del_vxod.ExecuteNonQuery(); db.closeConnection(); MySqlCommand command = new MySqlCommand("DELETE FROM `oborot`.`sotrudnik` WHERE (`id` = @log_id);", db.getConnection()); command.Parameters.Add("@log_id", MySqlDbType.VarChar).Value = log_id; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Аккаунт удален"); } else { MessageBox.Show("Аккаунт не удален"); } db.closeConnection(); }
private void button1_Click(object sender, EventArgs e) { login.Value = textBox_login.Text; DB db = new DB(); DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlDataReader reader; MySqlDataReader reader1; MySqlDataReader reader2; MySqlCommand command = new MySqlCommand("select * from `vxod` where login = @uL AND password = @uP", db.getConnection()); MySqlCommand command_category = new MySqlCommand("select наименование_должности from sotrudnik join dolznost on DOLZNOST_id = dolznost.id join VXOD on SOTRUDNIK_id = SOTRUDNIK.id where login = @uL", db.getConnection()); MySqlCommand command_name = new MySqlCommand("select имя from `SOTRUDNIK` join VXOD on SOTRUDNIK_id = SOTRUDNIK.id where login = @uL", db.getConnection()); MySqlCommand command_podrazdelenie = new MySqlCommand("select PODRAZDELENIE.id from `PODRAZDELENIE` " + "join SOTRUDNIK on PODRAZDELENIE_id = PODRAZDELENIE.id join VXOD on SOTRUDNIK_id = SOTRUDNIK.id " + "where login = @uL;", db.getConnection()); command.Parameters.Add("@uL", MySqlDbType.VarChar).Value = textBox_login.Text; command.Parameters.Add("@uP", MySqlDbType.VarChar).Value = textBox_pass.Text; command_category.Parameters.Add("@uL", MySqlDbType.VarChar).Value = textBox_login.Text; command_name.Parameters.Add("@uL", MySqlDbType.VarChar).Value = textBox_login.Text; command_podrazdelenie.Parameters.Add("@uL", MySqlDbType.VarChar).Value = textBox_login.Text; db.openConnection(); adapter.SelectCommand = command; adapter.Fill(table); reader = command_category.ExecuteReader(); while (reader.Read()) { categoryUser.Value = reader["наименование_должности"].ToString(); } db.closeConnection(); db.openConnection(); reader2 = command_podrazdelenie.ExecuteReader(); while (reader2.Read()) { podrazdelenie.Value = reader2["id"].ToString(); } db.closeConnection(); db.openConnection(); reader1 = command_name.ExecuteReader(); while (reader1.Read()) { logos.Value = reader1["имя"].ToString(); } if (table.Rows.Count > 0 && categoryUser.Value == "admin") { this.Hide(); MainForm mainForm = new MainForm(); mainForm.Show(); } else if (table.Rows.Count > 0 && categoryUser.Value == "rukovoditel") { this.Hide(); RukovosShow RukovosShow = new RukovosShow(); RukovosShow.Show(); } else if (table.Rows.Count > 0 && categoryUser.Value == "sotrudnik") { this.Hide(); UserMain UserMain = new UserMain(); UserMain.Show(); } else { MessageBox.Show("Неверный логин или пароль"); } db.closeConnection(); }
private void buttonRegister_Click(object sender, EventArgs e) { if (userNameField.Text.Contains(' ') || userSurnameField.Text.Contains(' ') || textBox_login.Text.Contains(' ') || textBox_pass.Text.Contains(' ') || textBox1_otch.Text.Contains(' ') || textBox1_pol.Text.Contains(' ') || textBox1_pas.Text.Contains(' ') || textBox1_tel.Text.Contains(' ') || textBox1_cat.Text.Contains(' ')) { MessageBox.Show("Введите корректные значения"); return; } else if (userNameField.Text == "Введите имя" || userSurnameField.Text == "Введите фамилию" || textBox_login.Text == "Введите логин" || textBox_pass.Text == "Введите пароль" || textBox1_otch.Text == "Введите отчество" || textBox1_pol.Text == "Введите подразделение" || textBox1_pas.Text == "Электронная почта" || textBox1_tel.Text == "Номер телефона" || textBox1_cat.Text == "Введите должность") { MessageBox.Show("Введите данные"); return; } if (isUserExists()) { return; } DB db = new DB(); MySqlDataReader reader; MySqlCommand command = new MySqlCommand("INSERT INTO `oborot`.`sotrudnik` (`Фамилия`, `Имя`, `Отчество`," + " `Телефон`, `Электронная почта`, `DOLZNOST_id`, `PODRAZDELENIE_id`)" + " VALUES (@surname, @name, @otch, @tel, @mail, @dol_id, @pod_id)", db.getConnection()); command.Parameters.Add("@name", MySqlDbType.VarChar).Value = userNameField.Text; command.Parameters.Add("@surname", MySqlDbType.VarChar).Value = userSurnameField.Text; command.Parameters.Add("@otch", MySqlDbType.VarChar).Value = textBox1_otch.Text; command.Parameters.Add("@tel", MySqlDbType.VarChar).Value = textBox1_tel.Text; command.Parameters.Add("@mail", MySqlDbType.VarChar).Value = textBox1_pas.Text; command.Parameters.Add("@dol_id", MySqlDbType.VarChar).Value = textBox1_cat.Text; command.Parameters.Add("@pod_id", MySqlDbType.VarChar).Value = textBox1_pol.Text; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Аккаунт создан"); } else { MessageBox.Show("Аккаунт не создан"); } db.closeConnection(); MySqlCommand command_vxod_id = new MySqlCommand("select id from `sotrudnik` where Имя = @name AND Фамилия = @surname AND Отчество = @otch AND Телефон = @tel AND `Электронная почта` = @mail AND DOLZNOST_id = @dol_id AND PODRAZDELENIE_id = @pod_id", db.getConnection()); command_vxod_id.Parameters.Add("@name", MySqlDbType.VarChar).Value = userNameField.Text; command_vxod_id.Parameters.Add("@surname", MySqlDbType.VarChar).Value = userSurnameField.Text; command_vxod_id.Parameters.Add("@otch", MySqlDbType.VarChar).Value = textBox1_otch.Text; command_vxod_id.Parameters.Add("@tel", MySqlDbType.VarChar).Value = textBox1_tel.Text; command_vxod_id.Parameters.Add("@mail", MySqlDbType.VarChar).Value = textBox1_pas.Text; command_vxod_id.Parameters.Add("@dol_id", MySqlDbType.VarChar).Value = textBox1_cat.Text; command_vxod_id.Parameters.Add("@pod_id", MySqlDbType.VarChar).Value = textBox1_pol.Text; db.openConnection(); reader = command_vxod_id.ExecuteReader(); while (reader.Read()) { vxod_id = reader["id"].ToString(); } db.closeConnection(); MySqlCommand command_vxod = new MySqlCommand("INSERT INTO `oborot`.`vxod` (`login`, `password`, `SOTRUDNIK_id`)" + " VALUES (@login, @pas, @sotr_id)", db.getConnection()); command_vxod.Parameters.Add("@login", MySqlDbType.VarChar).Value = textBox_login.Text; command_vxod.Parameters.Add("@pas", MySqlDbType.VarChar).Value = textBox_pass.Text; command_vxod.Parameters.Add("@sotr_id", MySqlDbType.VarChar).Value = vxod_id; db.openConnection(); command_vxod.ExecuteNonQuery(); db.closeConnection(); }
private void button1_Click(object sender, EventArgs e) { if (flagTable == 0) { MessageBox.Show("Выберите таблицу"); return; } if (flagTable == 1) { noneid_SOTRUDNIK(); return; } if (flagTable == 2) { noneidVXOD(); return; } if (flagTable == 3) { noneid_PODRAZDELENIE(); return; } if (flagTable == 4) { noneid_DOLZNOST(); return; } if (flagTable == 6) { noneid_HISTORY(); return; } if (flagTable == 7) { noneid_DOKUMENT(); return; } if (flagTable == 8) { noneidWork(); return; } if (flagTable == 9) { noneidWork(); return; } string ids = dataGridView1[0, dataGridView1.CurrentRow.Index].Value.ToString(); int id = int.Parse(ids); DB db = new DB(); MySqlCommand command = new MySqlCommand("DELETE FROM " + flagTbl + " WHERE `id` = @idx", db.getConnection()); command.Parameters.Add("@idx", MySqlDbType.Int32).Value = id; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Запись удалена"); } else { MessageBox.Show("Запись не удалена"); } db.closeConnection(); }
public void noneid_PODRAZDELENIE() { string ids = dataGridView1[0, dataGridView1.CurrentRow.Index].Value.ToString(); DB db = new DB(); MySqlCommand command = new MySqlCommand("DELETE FROM PODRAZDELENIE " + " WHERE `id` = @idx", db.getConnection()); command.Parameters.Add("@idx", MySqlDbType.Int32).Value = ids; db.openConnection(); if (command.ExecuteNonQuery() == 1) { MessageBox.Show("Запись удалена"); } else { MessageBox.Show("Запись не удалена"); } db.closeConnection(); //Это было до изменения программы может пригодится //DB db = new DB(); //MySqlCommand command = new MySqlCommand("DELETE FROM company " + // " WHERE `id` = @idx", db.getConnection()); //MySqlCommand command1 = new MySqlCommand("DELETE FROM adres " + // " WHERE `company_id` = @idx", db.getConnection()); //MySqlCommand command2 = new MySqlCommand("DELETE FROM doc " + // " WHERE `company_id` = @idx", db.getConnection()); //MySqlCommand command3 = new MySqlCommand("DELETE FROM work_user_doc " + // " WHERE `doc_id` IN (select id from doc where company_id = @idx)", db.getConnection()); //MySqlCommand command4 = new MySqlCommand("DELETE FROM gotov_doc " + // " WHERE `doc_id` IN (select id from doc where company_id = @idx)", db.getConnection()); //command.Parameters.Add("@idx", MySqlDbType.Int32).Value = ids; //command1.Parameters.Add("@idx", MySqlDbType.Int32).Value = ids; //command2.Parameters.Add("@idx", MySqlDbType.Int32).Value = ids; //command3.Parameters.Add("@idx", MySqlDbType.Int32).Value = ids; //command4.Parameters.Add("@idx", MySqlDbType.Int32).Value = ids; //db.openConnection(); //command4.ExecuteNonQuery(); //command3.ExecuteNonQuery(); //command1.ExecuteNonQuery(); //command2.ExecuteNonQuery(); //if (command.ExecuteNonQuery() == 1) //{ // MessageBox.Show("Запись удалена"); //} //else // MessageBox.Show("Запись не удалена"); //db.closeConnection(); }
private void button3_Click(object sender, EventArgs e) { if (flagTbl == "SOTRUDNIK") { flagTable = 1; flagTbl = "SOTRUDNIK"; ds.Reset(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select * from SOTRUDNIK", db.getConnection()); db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); } else if (flagTbl == "VXOD") { flagTable = 2; flagTbl = "VXOD"; ds.Reset(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select * from VXOD", db.getConnection()); db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); } else if (flagTbl == "PODRAZDELENIE") { flagTable = 3; flagTbl = "PODRAZDELENIE"; ds.Reset(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select * from PODRAZDELENIE", db.getConnection()); db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); } //else //if (flagTbl == "sessions") //{ // flagTable = 5; // flagTbl = "sessions"; // ds.Reset(); // MySqlDataAdapter adapter = new MySqlDataAdapter(); // DB db = new DB(); // dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; // dataGridView1.AllowUserToAddRows = false; // MySqlCommand command = new MySqlCommand("select * from session", db.getConnection()); // db.openConnection(); // adapter.SelectCommand = command; // adapter.Fill(ds); // dataGridView1.DataSource = ds.Tables[0]; // db.closeConnection(); //} else if (flagTbl == "DOLZNOST") { flagTable = 4; flagTbl = "DOLZNOST"; ds.Reset(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select * from DOLZNOST", db.getConnection()); db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); } else if (flagTbl == "HISTORY") { flagTable = 6; flagTbl = "HISTORY"; ds.Reset(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select * from HISTORY", db.getConnection()); db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); } else if (flagTbl == "DOKUMENT") { flagTable = 7; flagTbl = "DOKUMENT"; ds.Reset(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select * from DOKUMENT", db.getConnection()); db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); } else if (flagTbl == "TIP_DOKUMENTA") { flagTable = 8; flagTbl = "TIP_DOKUMENTA"; ds.Reset(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select * from TIP_DOKUMENTA", db.getConnection()); db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); } //else //if (flagTbl == "gotov_doc") //{ // flagTable = 9; // flagTbl = "gotov_doc"; // ds.Reset(); // MySqlDataAdapter adapter = new MySqlDataAdapter(); // DB db = new DB(); // dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; // dataGridView1.AllowUserToAddRows = false; // MySqlCommand command = new MySqlCommand("select * from gotov_doc", db.getConnection()); // db.openConnection(); // adapter.SelectCommand = command; // adapter.Fill(ds); // dataGridView1.DataSource = ds.Tables[0]; // db.closeConnection(); //} else if (flagTbl == "") { MessageBox.Show("Выберите таблицу"); } }
private void button2_Click(object sender, EventArgs e) { obnovTbl = "2"; if (logos.Value == "office") { button5.Visible = false; flagTblcomp = "1"; } else if (logos.Value == "company") { button5.Visible = true; } if (logos.Value == "company") { flagTbl = "1"; ds.Reset(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select * from work_user_doc where users_id = (select id from users where логин = @uL)", db.getConnection()); command.Parameters.Add("@uL", MySqlDbType.VarChar).Value = login.Value; db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); } else if (logos.Value == "office") { flagTbl = "2"; ds.Reset(); MySqlDataAdapter adapter = new MySqlDataAdapter(); DB db = new DB(); dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView1.AllowUserToAddRows = false; MySqlCommand command = new MySqlCommand("select * from work_user_doc", db.getConnection()); command.Parameters.Add("@uL", MySqlDbType.VarChar).Value = login.Value; db.openConnection(); adapter.SelectCommand = command; adapter.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; db.closeConnection(); } }