public zayavki() { InitializeComponent(); var dbCon = DBConn.Instance(); dbCon.Connection = null; dbCon.DatabaseName = "570_abp"; dbCon.Host = "5.187.7.31"; if (dbCon.IsConnect()) { string query = "SELECT num FROM zayvki"; var cmd = new MySqlCommand(query, dbCon.Connection); var reader = cmd.ExecuteReader(); while (reader.Read()) { allCount = reader.GetInt32(0); allCount++; zayavkaLabel.Text = "Заявка №" + allCount + " от " + thisDay.ToString("d"); } } else { MessageBox.Show("Ошибка связи с сервером"); } dbCon.Close(); dbCon.Connection = null; dbCon.DatabaseName = "570_abp"; dbCon.Host = "5.187.7.31"; if (dbCon.IsConnect()) { string query = "SELECT name FROM spisokDronov"; var cmd = new MySqlCommand(query, dbCon.Connection); var reader = cmd.ExecuteReader(); while (reader.Read()) { droneList.Items.Add(reader.GetValue(0).ToString()); } } else { MessageBox.Show("Ошибка связи с сервером"); } }
private void sendButton_Click(object sender, EventArgs e) { var dbCon = DBConn.Instance(); dbCon.Connection = null; dbCon.DatabaseName = "570_abp"; dbCon.Host = "5.187.7.31"; if (dbCon.IsConnect()) { string query = ""; try { if (fio.Text.ToString() != "" // && dataGridView1.Rows[i].Cells[1].Value.ToString() != "" && count.Text != "") { if (droneList.SelectedItem != null) { query = String.Format("INSERT INTO zayvki(fio, drone, count, date_of_zakaz, date_of_change, state, num) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", fio.Text.ToString(), droneList.SelectedItem.ToString(), count.Text.ToString(), thisDay.ToString("d"), thisDay.ToString("d"), "Создан", allCount.ToString()); var cmd = new MySqlCommand(query, dbCon.Connection); cmd.ExecuteNonQuery(); MessageBox.Show("Заявка отправлена."); this.Close(); } else { MessageBox.Show("Ошибка добавления. Выберите дрон."); } } else { MessageBox.Show("Ошибка добавления. Одно из полей не заполнено."); } } catch (MySqlException ee) { MessageBox.Show("MysqlError: " + ee.ToString()); } } }
private void PosmotrZv_Load(object sender, EventArgs e) { var dbCon = DBConn.Instance(); dbCon.Connection = null; dbCon.DatabaseName = "570_abp"; dbCon.Host = "5.187.7.31"; string query = ""; if (dbCon.IsConnect()) { query = String.Format("SELECT * FROM zayvki"); var cmd = new MySqlCommand(query, dbCon.Connection); //cmd.ExecuteNonQuery(); // SqlConnection dataBaseConnection = new SqlConnection(conn); var reader = cmd.ExecuteReader(); List <string[]> data = new List <string[]>(); int i = 1; while (reader.Read()) { data.Add(new string[7]); data[data.Count - 1][0] = reader[0].ToString(); data[data.Count - 1][1] = reader[1].ToString(); data[data.Count - 1][2] = reader[2].ToString(); data[data.Count - 1][3] = reader[3].ToString(); data[data.Count - 1][4] = reader[4].ToString(); data[data.Count - 1][5] = reader[5].ToString(); data[data.Count - 1][6] = reader[6].ToString(); } reader.Close(); dbCon.Close(); GC.Collect(); GC.WaitForPendingFinalizers(); foreach (string[] s in data) { dataGridView1.Rows.Add(s); } } }
private void LoadData() { var dbCon = DBConn.Instance(); dbCon.Connection = null; dbCon.DatabaseName = "570_abp"; dbCon.Host = "5.187.7.31"; string query = ""; if (dbCon.IsConnect()) { query = String.Format("SELECT name,SUM(count) FROM priem WHERE `date`='{0}' GROUP BY name", dateTimePicker1.Value.ToString("d")); var cmd = new MySqlCommand(query, dbCon.Connection); //cmd.ExecuteNonQuery(); // SqlConnection dataBaseConnection = new SqlConnection(conn); var reader = cmd.ExecuteReader(); List <string[]> data = new List <string[]>(); int i = 1; while (reader.Read()) { data.Add(new string[3]); data[data.Count - 1][0] = (i++).ToString(); data[data.Count - 1][1] = reader[0].ToString(); data[data.Count - 1][2] = reader[1].ToString(); } reader.Close(); dbCon.Close(); GC.Collect(); GC.WaitForPendingFinalizers(); foreach (string[] s in data) { dataGridViewOst.Rows.Add(s); } } }
public Form2() { var dbCon = DBConn.Instance(); dbCon.Connection = null; dbCon.DatabaseName = "570_abp"; dbCon.Host = "5.187.7.31"; InitializeComponent(); if (dbCon.IsConnect()) { string query = "SELECT num_post FROM priem"; var cmd = new MySqlCommand(query, dbCon.Connection); var reader = cmd.ExecuteReader(); while (reader.Read()) { allCount = reader.GetInt32(0); label1.Text = "Поступление комплектующих № " + reader.GetString(0) + " от " + thisDay.ToString("d"); } } else { MessageBox.Show("Ошибка связи с сервером"); } dbCon.Close(); }
public void OpenExcel(string path, int textbox) { Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(path); Microsoft.Office.Interop.Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1]; Microsoft.Office.Interop.Excel.Range xlRange = xlWorksheet.UsedRange; int rowCount = xlRange.Rows.Count; int colCount = xlRange.Columns.Count; var dbCon = DBConn.Instance(); dbCon.DatabaseName = "570_abp"; dbCon.Host = "5.187.7.31"; string query = ""; if (dbCon.IsConnect()) { if (textbox == 1) { try { for (int i = 2; i <= rowCount; i++) { query = String.Format("INSERT INTO parts(name, category) VALUES('{0}','{1}')", xlRange.Cells[i, 2].Value2.ToString(), xlRange.Cells[i, 3].Value2.ToString()); var cmd = new MySqlCommand(query, dbCon.Connection); cmd.ExecuteNonQuery(); /* for (int j = 1; j <= colCount; j++) * { * * if (xlRange.Cells[i, j] != null && xlRange.Cells[i, j].Value2 != null) * MessageBox.Show(xlRange.Cells[i, j].Value2.ToString()); * }*/ } } catch (MySqlException err) { MessageBox.Show("MysqlError: " + err.ToString()); } textBoxDron.Text = "Данные успешно добавились"; } if (textbox == 0) { for (int i = 2; i <= rowCount; i++) { try { int num; if (Int32.TryParse(xlRange.Cells[i, 3].Value2.ToString(), out num)) { query = String.Format("INSERT INTO spisokDronov(name, cost) VALUES('{0}','{1}')", xlRange.Cells[i, 2].Value2.ToString(), xlRange.Cells[i, 3].Value2.ToString()); var cmd = new MySqlCommand(query, dbCon.Connection); cmd.ExecuteNonQuery(); } } catch (MySqlException err) { MessageBox.Show("MysqlError: " + err.ToString()); return; } /* for (int j = 1; j <= colCount; j++) * { * * if (xlRange.Cells[i, j] != null && xlRange.Cells[i, j].Value2 != null) * MessageBox.Show(xlRange.Cells[i, j].Value2.ToString()); * }*/ } textBoxDron.Text = "Данные успешно добавились"; } if (textbox == 2) { for (int i = 2; i <= rowCount; i++) { try { int num; if (Int32.TryParse(xlRange.Cells[i, 4].Value2.ToString(), out num)) { query = String.Format("INSERT INTO technologicalMap(dron, detail, count) VALUES('{0}','{1}','{2}')", xlRange.Cells[i, 2].Value2.ToString(), xlRange.Cells[i, 3].Value2.ToString(), xlRange.Cells[i, 4].Value2.ToString()); var cmd = new MySqlCommand(query, dbCon.Connection); cmd.ExecuteNonQuery(); } } catch (MySqlException err) { MessageBox.Show("MysqlError: " + err.ToString()); return; } /* for (int j = 1; j <= colCount; j++) * { * * if (xlRange.Cells[i, j] != null && xlRange.Cells[i, j].Value2 != null) * MessageBox.Show(xlRange.Cells[i, j].Value2.ToString()); * }*/ } textBoxDron.Text = "Данные успешно добавились"; } } else { MessageBox.Show("Ошибка связи с сервером"); } dbCon.Close(); GC.Collect(); GC.WaitForPendingFinalizers(); xlWorkbook.Close(); }
private void uploadB_Click(object sender, EventArgs e) { var dbCon = DBConn.Instance(); dbCon.Connection = null; dbCon.DatabaseName = "570_abp"; dbCon.Host = "5.187.7.31"; if (dbCon.IsConnect()) { allCount++; string query = ""; try { for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { if (dataGridView1.Rows[i].Cells[0].Value.ToString() != "" // && dataGridView1.Rows[i].Cells[1].Value.ToString() != "" && dataGridView1.Rows[i].Cells[2].Value.ToString() != "" && nameTBox.Text!="") { if ((Regex.IsMatch(dataGridView1.Rows[i].Cells[0].Value.ToString(), "\\bАКБ\\b") || Regex.IsMatch(dataGridView1.Rows[i].Cells[0].Value.ToString(), "\\bакб\\b")) && dataGridView1.Rows[i].Cells[1].Value.ToString() != "") { query = String.Format("INSERT INTO priem(name, serial,count,employee,date,num_post) VALUES('{0}','{1}','{2}','{3}','{4}','{5}')", dataGridView1.Rows[i].Cells[0].Value.ToString(), dataGridView1.Rows[i].Cells[1].Value.ToString(), dataGridView1.Rows[i].Cells[2].Value.ToString(), nameTBox.Text.ToString(), thisDay.ToString("d"), allCount.ToString()); var cmd = new MySqlCommand(query, dbCon.Connection); cmd.ExecuteNonQuery(); } else if (!(Regex.IsMatch(dataGridView1.Rows[i].Cells[0].Value.ToString(), "\\bАКБ\\b"))){ query = String.Format("INSERT INTO priem(name,count,employee,date,num_post) VALUES('{0}','{1}','{2}','{3}','{4}')", dataGridView1.Rows[i].Cells[0].Value.ToString(), dataGridView1.Rows[i].Cells[2].Value.ToString(), nameTBox.Text.ToString(), thisDay.ToString("d"), allCount.ToString()); var cmd = new MySqlCommand(query, dbCon.Connection); cmd.ExecuteNonQuery(); } } else { MessageBox.Show("Ошибка добавления"); } //for(int j = 0; j < 3; j++) // { // if (dataGridView1.Rows[i].Cells[j].Value != null) // } } }catch(MySqlException ee) { MessageBox.Show("MysqlError: " + ee.ToString()); } } else { MessageBox.Show("Ошибка с сервером"); } dbCon.Close(); }