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