private void yt_Button9_Click(object sender, EventArgs e)
{
string query_id = "";
int max_id = 0;
if (textBox1.Text != String.Empty)
{
if (textBox1.Text != String.Empty)
{
try
{
conn.Close();
conn.Open();
//выбираем последний номер сохраненной записи о пересылке из бд и сохраняем
string query = "SELECT max(number) as MaxN " +
"from documents;";
using (var reader = new MySqlCommand(query, conn).ExecuteReader())
{
if (reader.Read())
{
if (!reader.IsDBNull(reader.GetOrdinal("MaxN")))
{
MaxNumber = int.Parse(reader["MaxN"].ToString()) + 1;
}
}
}
//выбираем последний номер файла из бд и сохраняем
query = "SELECT max(id) as MaxD" +
" from document_file;";
using (var reader = new MySqlCommand(query, conn).ExecuteReader())
{
if (reader.Read())
{
if (!reader.IsDBNull(reader.GetOrdinal("MaxD")))
{
MaxIdF = int.Parse(reader["MaxD"].ToString()) + 1;
}
}
}
//загружаем файлы на сервер и в бд
for (int i = 0; i < listBox1.Items.Count; i++)
{
//try
// {
string s = listBox3.Items[i].ToString();
string f = "\\\\" + IP_SERVER + "\\Программа\\" +
DEPARTMENT + "\\" + LAST_NAME + " " +
FIRST_NAME + " " + MIDDLE_NAME + "\\" +
DateTime.Today.ToString("d");
if (!Directory.Exists(f))
{
Directory.CreateDirectory(f);
}
f = f + "\\" + Path.GetFileName(s);
File.Copy(s, f, true);
string q = "INSERT INTO `document_file`" +
" (`id` ,`path`, `file`)" +
" VALUES (" + MaxIdF + ",'" + f.Replace("\\", "\\\\") + "','" + Path.GetFileName(s) + "');";
MySqlCommand command = new MySqlCommand(q, conn);
// выполняем запрос
command.ExecuteNonQuery();
IdFile.Add(MaxIdF);//записываем все номера в массив (( номера файлов))
MaxIdF += 1;
//MessageBox.Show( "ок");
/* }
* catch(Exception ex)
* {
* MessageBox.Show(ex.Message,"ошибка");
* }*/
}
try
{
//выбираем все id получателей
if (IdlistBox.Items.Count != 0)
{
for (int i = 0; i < IdlistBox.Items.Count; i++)
{
string words = IdlistBox.Items[i].ToString();
query = "SELECT id,E_MAIL From users where id = " +
words + ";";
using (var reader = new MySqlCommand(query, conn).ExecuteReader())
{
if (reader.Read())
{
Id_s.Add(reader["id"].ToString());
e_mail.Add(reader["E_MAIL"].ToString());
}
}
//IdRecipient[i] = id_send;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка пользователя, Документ не добавлен!");
}
try
{
if (DepcomboBox.Items.Count != 0)
{
for (int i = 0; i < NameDeplistBox.Items.Count; i++)
{
string words = listBox4.Items[i].ToString();
string query1 = "select id,E_MAIL from users " +
"where Dep_id=" +
words + ";";
using (var reader = new MySqlCommand(query1, conn).ExecuteReader())
{
while (reader.Read())
{
Id_s.Add(reader["id"].ToString());
e_mail.Add(reader["E_MAIL"].ToString());
//MessageBox.Show(reader["E_Mail"].ToString(), "мыло");
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка при добавлении департаментов, Документ не добавлен!");
}
try
{
for (int i = 0; i < Id_s.Count; i++)
{
if (checkBox1.Checked) //если стоит флажок на сроке подписания
{
string q = "INSERT INTO `documents`" +
" ( `number`,`namedoc`, " +
"`id_sender`, `id_recipient`,`date`,`from_date`,`comments`," +
"`document_type`,`origin`,`sign`,`incom_number`)" +
" VALUES" +
" (" + MaxNumber + ",'" + textBox1.Text + "'," +
ID + "," +
Id_s[i] + ",'" +
dateTimePicker1.Value.ToString("s") + ",'" +
richTextBox1.Text + "','" +
typeComboBox1.Text + "','Оригинал','" + comboBox1.Text +
"','" + MaxNumber + "');";
MySqlCommand command = new MySqlCommand(q, conn);
// выполняем запрос
command.ExecuteNonQuery();
query_id = "SELECT max(id_document) as MaxIID" +
" from documents;";
using (var reader = new MySqlCommand(query_id, conn).ExecuteReader())
{
if (reader.Read())
{
if (!reader.IsDBNull(reader.GetOrdinal("MaxIID")))
{
max_id = int.Parse(reader["MaxIID"].ToString());
}
}
}
string query1 = "INSERT INTO `coments`" +
" (`Id_doc` ,`number`,`Statuscol`, `usercol`)" +
" VALUES (" + max_id + "," + MaxNumber
+ ",'документ добавлен'," + ID + ");";
MySqlCommand command1 = new MySqlCommand(query1, conn);
int UspeshnoeIzmenenie1 = command1.ExecuteNonQuery();
try
{
SendMail.SEND_MAIlTORECIP(e_mail[i], textBox1.Text);
}
catch { }
}
else
{
//MessageBox.Show(id_send.ToString(), "id");
string q = "INSERT INTO `documents`" +
" ( `number`,`namedoc`, " +
"`id_sender`, `id_recipient`,`comments`," +
"`document_type`,`origin`,`sign`,`incom_number`)" +
" VALUES" +
" (" + MaxNumber + ",'" +
textBox1.Text + "'," +
ID + "," + Id_s[i] + ",'" + richTextBox1.Text +
"','" + typeComboBox1.Text +
"','Оригинал','" + comboBox1.Text +
"','" + MaxNumber + "');";
MySqlCommand command = new MySqlCommand(q, conn);
// выполняем запрос
command.ExecuteNonQuery();
query_id = "SELECT max(id_document) as MaxIID" +
" from documents;";
using (var reader = new MySqlCommand(query_id, conn).ExecuteReader())
{
if (reader.Read())
{
if (!reader.IsDBNull(reader.GetOrdinal("MaxIID")))
{
max_id = int.Parse(reader["MaxIID"].ToString());
}
}
}
string query1 = "INSERT INTO `coments`" +
" (`Id_doc` ,`number`,`Statuscol`, `usercol`)" +
" VALUES (" + max_id + "," + MaxNumber
+ ",'документ добавлен'," + ID + ");";
MySqlCommand command1 = new MySqlCommand(query1, conn);
int UspeshnoeIzmenenie1 = command1.ExecuteNonQuery();
try
{
SendMail.SEND_MAIlTORECIP(e_mail[i], textBox1.Text);
}
catch { }
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка при добавлении, Документ не добавлен!");
}
// MessageBox.Show(id_send.ToString(), "id_______hgkv");
foreach (int i in IdFile)
{
string q = "INSERT INTO `all_one`" +
" (`id_doc`, `id_file`)" + " VALUES ("
+ MaxNumber + "," + i + ");";
MySqlCommand command = new MySqlCommand(q, conn);
// выполняем запрос
command.ExecuteNonQuery();
}
conn.Close();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ошибка, Документ не добавлен!");
}
}
else
{
MessageBox.Show("Заполните номер", "");
}
}
else
{
MessageBox.Show("Заполните исходящий номер", "");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (checkBox1.Checked)
{
ID = "24";
}
conn.Close();
conn.Open();
string later = "Select namedoc,number,incom_number,out_number,comments, date_added,date," +
"to_date,from_date,status,document_type " +
"from documents where id_document=" + ID_Doc + ";";
string out_number = "";
string namedoc = "";
string comments = "";
string date_added = "";
string date = "";
string status = "";
string document_type = "";
string number = "";
string incom_number = "";
string q = "";
string to_date = "";
string from_date = "";
// try
// {
using (var reader = new MySqlCommand(later, conn).ExecuteReader())
{
if (reader.Read())
{
namedoc = reader["namedoc"].ToString();
out_number = reader["out_number"].ToString();
comments = reader["comments"].ToString();
date = reader["date"].ToString();
//MessageBox.Show(date, "ДАТАЭ");
date_added = reader["date_added"].ToString();
status = reader["status"].ToString();
document_type = reader["document_type"].ToString();
number = reader["number"].ToString();
incom_number = reader["incom_number"].ToString();
to_date = reader["to_date"].ToString();
from_date = reader["from_date"].ToString();
}
}
for (int i = 0; i < listBox1.Items.Count; i++)
{
string words = ids.Items[i].ToString();
string query = "SELECT id,E_MAIL From users where id = " +
words + ";";
int id_send = 0;
string e_mail = "";
using (var reader = new MySqlCommand(query, conn).ExecuteReader())
{
if (reader.Read())
{
id_send = int.Parse(reader["id"].ToString());
e_mail = reader["E_MAIL"].ToString();
}
}
if (!String.IsNullOrEmpty(from_date))
{
DateTime from_dateDate = DateTime.Parse(from_date);
if (!String.IsNullOrEmpty(to_date))
{
DateTime to_dateDate = DateTime.Parse(to_date);
if (!String.IsNullOrEmpty(date))
{
DateTime enteredDate = DateTime.Parse(date);
q = "INSERT INTO `documents`" +
" ( `number`,`incom_number`,`out_number`, `id_sender`, " +
"`id_recipient`,`date`,`comments`,`document_type`," +
"`from_date`,`to_date`,`namedoc`,`origin`)" +
" VALUES" +
"(" + number + ",'" + incom_number + "','" + out_number + "'," +
ID + "," + id_send + ",'" +
enteredDate.ToString("s") + "','" + comments + "','" +
document_type +
"','" + from_dateDate.ToString("s") + "','" +
to_dateDate.ToString("s") + "','" + namedoc + "','Пересланный');";
}
else
{
q = "INSERT INTO `documents`" +
" ( `number`,`incom_number`,`out_number`, `id_sender`, " +
"`id_recipient`,`comments`,`document_type`," +
"`from_date`,`to_date`,`namedoc`,`origin`)" +
" VALUES" +
"(" + number + ",'" + incom_number + "','" + out_number + "'," +
ID + "," + id_send + ",'" + comments + "','" +
document_type + "','" + from_dateDate.ToString("s") + "','" +
to_dateDate.ToString("s") + "','" + namedoc + "','Пересланный');";
}
}
else
{
q = "INSERT INTO `documents`" +
" ( `number`,`incom_number`,`out_number`, `id_sender`, " +
"`id_recipient`,`comments`,`document_type`," +
"`from_date`,`namedoc`,`origin`)" +
" VALUES" +
"(" + number + ",'" + incom_number + "','" + out_number + "'," +
ID + "," + id_send + ",'" + comments + "','" +
document_type + "','" + from_dateDate.ToString("s") + "','" + namedoc +
"','Пересланный');";
}
}
else
{
if (!String.IsNullOrEmpty(date))
{
DateTime enteredDate = DateTime.Parse(date);
q = "INSERT INTO `documents`" +
" ( `number`,`incom_number`,`out_number`, `id_sender`, " +
"`id_recipient`,`date`,`comments`,`document_type`" +
",`namedoc`,`origin`)" +
" VALUES" +
"(" + number + ",'" + incom_number + "','" + out_number + "'," +
ID + "," + id_send + ",'" +
enteredDate.ToString("s") + "','" + comments + "','" +
document_type +
"','" + namedoc + "','Пересланный');";
}
else
{
q = "INSERT INTO `documents`" +
" ( `number`,`incom_number`,`out_number`, `id_sender`, " +
"`id_recipient`,`comments`,`document_type`," +
"`namedoc`,`origin`)" +
" VALUES" +
"(" + number + ",'" + incom_number + "','" + out_number + "'," +
ID + "," + id_send + ",'" + comments + "','" +
document_type + "','" + namedoc + "','Пересланный');";
}
}
try
{
SendMail.SEND_MAIlTORECIP(e_mail, out_number);
}
catch { }
MySqlCommand command = new MySqlCommand(q, conn);
// выполняем запрос
command.ExecuteNonQuery();
string query1 = "INSERT INTO `coments`" +
" (`Id_doc`,`number`,`forward`, `usercol`,`recipcol`)" +
" VALUES (" + ID_Doc + "," + number
+ ",'пересылка'," + ID + "," + id_send + "); ";
MySqlCommand command1 = new MySqlCommand(query1, conn);
// выполняем запрос
int UspeshnoeIzmenenie1 = command1.ExecuteNonQuery();
}
for (int i = 0; i < listBox2.Items.Count; i++)
{
string words = ido.Items[i].ToString();
string query = "SELECT id,E_MAIL From users where dep_id = " +
words + ";";
List <int> id_send = new List <int>();
List <string> e_mail = new List <string>();
using (var reader = new MySqlCommand(query, conn).ExecuteReader())
{
while (reader.Read())
{
id_send.Add(int.Parse(reader["id"].ToString()));
e_mail.Add(reader["E_MAIL"].ToString());
}
}
for (int j = 0; j < id_send.Count(); j++)
{
if (!String.IsNullOrEmpty(date))
{
DateTime enteredDate = DateTime.Parse(date);
q = "INSERT INTO `documents`" +
" ( `number`,`out_number`, `id_sender`, `id_recipient`,`date`,`comments`,`document_type`)" +
" VALUES" +
"(" + number + ",'" + out_number + "'," +
ID + "," + id_send[j] + ",'" +
enteredDate.ToString("s") + "','" + comments + "','" +
document_type + "');";
}
else
{
q = "INSERT INTO `documents`" +
" ( `number`,`out_number`, `id_sender`, `id_recipient`,`comments`,`document_type`)" +
" VALUES" +
"(" + number + ",'" + out_number + "'," +
ID + "," + id_send[j] + ",'" + comments + "','" +
document_type + "');";
}
SendMail.SEND_MAIlTORECIP(e_mail[j], out_number);
MySqlCommand command = new MySqlCommand(q, conn);
command.ExecuteNonQuery();
}
}
conn.Close();
/* }
* catch(Exception ex)
* {
* MessageBox.Show(ex.Message, "Ошибка отправки");
* }*/
this.Close();
}