Автоматизированная система учета передвижения продукции на ОАО "Беларуськалий"

excelcells = excelworksheet.get_Range("D" + (i + 4).ToString(), Type.Missing);

excelcells.Value2 = "тонн";

excelcells = excelworksheet.get_Range("E" + (i + 4).ToString(), Type.Missing);

excelcells.Value2 = Adres[j];

i++;

}

myConnection1.Close(); //Обязательно закрываем соединение!

//заполнение данными

excelcells = excelworksheet.get_Range("A3", "E" + (i + 3).ToString());

excelcells.Borders.ColorIndex = 5;

excel.Visible = true;

}

}

}

//ZakAdd.cs

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace Sklad

{

public partial class ZakAdd : Form

{

public ZakAdd()

{

InitializeComponent();

}

public string Connect = "Database=as_product;Data Source=localhost;User=root;Password=pass;charset=cp1251;";

public int ID_red;

public void ShowStrana()

{

MySqlConnection myConnection = new MySqlConnection(Connect);

myConnection.Open(); //Устанавливаем соединение с базой данных.

string CommandText = "Select name_str from strana";

MySqlCommand myCommand = new MySqlCommand(CommandText, myConnection);

MySqlDataReader myReader1 = myCommand.ExecuteReader();

comboBox1.Items.Clear();

while (myReader1.Read())

{

comboBox1.Items.Add(myReader1.GetString(0));

}

myConnection.Close(); //Обязательно закрываем соединение!

}

private void ZakAdd_Load(object sender, EventArgs e)

{

if(button1.Visible)ShowStrana();

}

private void button1_Click(object sender, EventArgs e)

{

if (comboBox1.Text == "" || textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" )

MessageBox.Show("Необходимо заполнить все данные", "Добавление записи", MessageBoxButtons.OK, MessageBoxIcon.Information);

else

{MySqlConnection myConnection = new MySqlConnection(Connect);

myConnection.Open(); //Устанавливаем соединение с базой данных.

string CommandText = "SELECT min(C.ID_zak+1) FROM zakazchik C LEFT JOIN zakazchik b ON C.ID_zak+1 = b.ID_zak where b.ID_zak is null";

MySqlCommand myCommand = new MySqlCommand(CommandText, myConnection);

Int32 nom = Convert.ToInt32(myCommand.ExecuteScalar().ToString());

string CommandText1 = "SELECT id_str from strana where name_str = '"+comboBox1.Text+"'";

MySqlCommand myCommand1 = new MySqlCommand(CommandText1, myConnection);

Int32 nom1 = Convert.ToInt32(myCommand1.ExecuteScalar().ToString());

string TextCommand = "Insert into zakazchik (id_zak, id_str, name_zak, adres_zak, tel_zak, kontact) values(" + Convert.ToString(nom) + ",";

TextCommand += Convert.ToString(nom1) + ",'";

TextCommand += textBox1.Text + "','";

TextCommand += textBox2.Text + "','";

TextCommand += textBox3.Text + "','";

TextCommand += textBox4.Text + "')";

myCommand = new MySqlCommand(TextCommand, myConnection);

myCommand.ExecuteNonQuery();

MessageBox.Show("Данные добавлены", "Добавление записи", MessageBoxButtons.OK, MessageBoxIcon.Information);

comboBox1.Text = "";

textBox1.Text = "";

textBox2.Text = "";

textBox3.Text = "";

textBox4.Text = "";

myConnection.Close(); //Обязательно закрываем соединение!

this.Close();

}

}

private void button2_Click(object sender, EventArgs e)

{

if (comboBox1.Text == "" || textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "")

MessageBox.Show("Необходимо заполнить все данные", "Добавление записи", MessageBoxButtons.OK, MessageBoxIcon.Information);

else

{

MySqlConnection myConnection = new MySqlConnection(Connect);

myConnection.Open(); //Устанавливаем соединение с базой данных.

string CommandText1 = "SELECT id_str from strana where name_str = '" + comboBox1.Text + "'";

MySqlCommand myCommand1 = new MySqlCommand(CommandText1, myConnection);

Int32 nom1 = Convert.ToInt32(myCommand1.ExecuteScalar().ToString());

string TextCommand = "Update zakazchik Set id_str = ";

TextCommand += Convert.ToString(nom1) + ",name_zak = '";

TextCommand += textBox1.Text + "', adres_zak = '";

TextCommand += textBox2.Text + "', tel_zak = '";

TextCommand += textBox3.Text + "',kontact = '";

TextCommand += textBox4.Text + "' where id_zak = " + Convert.ToString(ID_red);

MySqlCommand myCommand = new MySqlCommand(TextCommand, myConnection);

myCommand.ExecuteNonQuery();

MessageBox.Show("Данные изменены", "Изменение записи", MessageBoxButtons.OK, MessageBoxIcon.Information);

comboBox1.Text = "";

textBox1.Text = "";

textBox2.Text = "";

textBox3.Text = "";

textBox4.Text = "";

myConnection.Close(); //Обязательно закрываем соединение!

this.Close();

}

} }}

//Sotr.cs

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace Sklad

{

public partial class Sotr : Form

{

public Sotr()

{

InitializeComponent();

}

public string Connect = "Database=as_product;Data Source=localhost;User=root;Password=pass;charset=cp1251;";

public int ID_red;

public void ShowSklad()

{

MySqlConnection myConnection = new MySqlConnection(Connect);

myConnection.Open(); //Устанавливаем соединение с базой данных.

string CommandText = "Select id_skl from sklad";

MySqlCommand myCommand = new MySqlCommand(CommandText, myConnection);

MySqlDataReader myReader1 = myCommand.ExecuteReader();

comboBox1.Items.Clear();

while (myReader1.Read())

{ comboBox1.Items.Add(myReader1.GetString(0));

}

myConnection.Close(); //Обязательно закрываем соединение!

}

private void Sotr_Load(object sender, EventArgs e)

{

string CommandText = "Select Count(*) from sotrudniki";

MySqlConnection myConnection = new MySqlConnection(Connect);

MySqlCommand myCommand = new MySqlCommand(CommandText, myConnection);

myConnection.Open(); //Устанавливаем соединение с базой данных.

Int32 kol = Convert.ToInt32(myCommand.ExecuteScalar().ToString());

if (kol > 0)

dataGridView1.RowCount = kol;

else dataGridView1.RowCount = 1;

for (int k = 0; k < kol; k++) dataGridView1[0, k].Value = "";

string TextCommand = "Select * ";

TextCommand += " from sotrudniki ";

MySqlCommand comm1 = new MySqlCommand(TextCommand, myConnection);

MySqlDataReader myReader = comm1.ExecuteReader();

int i = 0;

while (myReader.Read())

{

for (int j = 0; j < 8; j++)

{

dataGridView1[j, i].Value = myReader.GetString(j);

}

i++;

}

myConnection.Close(); //Обязательно закрываем соединение!

ShowSklad();

this.button2.Enabled = true;

}

private void button1_Click(object sender, EventArgs e)

{

if (comboBox1.Text == "" || textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" || textBox5.Text == "" || textBox6.Text == "")

MessageBox.Show("Необходимо заполнить все данные", "Добавление записи", MessageBoxButtons.OK, MessageBoxIcon.Information);

else

{

MySqlConnection myConnection = new MySqlConnection(Connect);

myConnection.Open(); //Устанавливаем соединение с базой данных.

string CommandText = "SELECT min(C.ID_sotr+1) FROM sotrudniki C LEFT JOIN sotrudniki b ON C.ID_sotr+1 = b.ID_sotr where b.ID_sotr is null";

MySqlCommand myCommand = new MySqlCommand(CommandText, myConnection);

Int32 nom = Convert.ToInt32(myCommand.ExecuteScalar().ToString());

string TextCommand = "Insert into sotrudniki (id_sotr, fam, imya, otch, dolzn, razr, id_skl, passw) values(" + Convert.ToString(nom) + ",'";

TextCommand += textBox1.Text + "','";

TextCommand += textBox2.Text +"','";

TextCommand += textBox3.Text + "','";

TextCommand += textBox6.Text + "',";

TextCommand += textBox5.Text + ",";

TextCommand += comboBox1.Text + ",'";

TextCommand += textBox4.Text + "')";

myCommand = new MySqlCommand(TextCommand, myConnection);

myCommand.ExecuteNonQuery();

MessageBox.Show("Данные добавлены", "Добавление записи", MessageBoxButtons.OK, MessageBoxIcon.Information);

this.Sotr_Load(sender, e);

comboBox1.Text = "";

textBox1.Text = "";

textBox2.Text = "";

textBox3.Text = "";

textBox4.Text = "";

textBox5.Text = "";

textBox6.Text = "";

myConnection.Close(); //Обязательно закрываем соединение!

}

}

private void редактироватьЗаписьToolStripMenuItem_Click(object sender, EventArgs e)

{

ID_red = Convert.ToInt32(dataGridView1[0, dataGridView1.CurrentCell.RowIndex].Value);

textBox1.Text = Convert.ToString(dataGridView1[1, dataGridView1.CurrentCell.RowIndex].Value);

textBox2.Text = Convert.ToString(dataGridView1[2, dataGridView1.CurrentCell.RowIndex].Value);

textBox3.Text = Convert.ToString(dataGridView1[3, dataGridView1.CurrentCell.RowIndex].Value);

textBox4.Text = Convert.ToString(dataGridView1[6, dataGridView1.CurrentCell.RowIndex].Value);

textBox5.Text = Convert.ToString(dataGridView1[5, dataGridView1.CurrentCell.RowIndex].Value);

textBox6.Text = Convert.ToString(dataGridView1[4, dataGridView1.CurrentCell.RowIndex].Value);

comboBox1.Text = Convert.ToString(dataGridView1[7, dataGridView1.CurrentCell.RowIndex].Value);

this.button2.Enabled = true;

}

private void button2_Click(object sender, EventArgs e)

{

if (comboBox1.Text == "" || textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || textBox4.Text == "" || textBox5.Text == "" || textBox6.Text == "")

MessageBox.Show("Необходимо заполнить все данные", "Изменение записи", MessageBoxButtons.OK, MessageBoxIcon.Information);

else

{

MySqlConnection myConnection = new MySqlConnection(Connect);

myConnection.Open(); //Устанавливаем соединение с базой данных.

string TextCommand = "Update sotrudniki Set fam = '" + textBox1.Text + "', imya = '" + textBox2.Text;

TextCommand += "', otch = '" + textBox3.Text;

TextCommand += "', dolzn = '" + textBox6.Text;

TextCommand += "', razr = " + textBox5.Text;

TextCommand += ", passw = '" + textBox4.Text;

TextCommand += "', id_skl = " + comboBox1.Text;

TextCommand += " where id_sotr = " + ID_red;

MySqlCommand myCommand = new MySqlCommand(TextCommand, myConnection);

myCommand.ExecuteNonQuery();

MessageBox.Show("Данные изменены", "Изменение записи", MessageBoxButtons.OK, MessageBoxIcon.Information);

this.Sotr_Load(sender, e);

comboBox1.Text = "";

textBox1.Text = "";

textBox2.Text = "";

textBox3.Text = "";

textBox4.Text = "";

textBox5.Text = "";

textBox6.Text = "";

myConnection.Close(); //Обязательно закрываем соединение!

}

this.button2.Enabled = false;

}

private void удалитьЗаписьToolStripMenuItem_Click(object sender, EventArgs e)

{

MySqlConnection myConnection = new MySqlConnection(Connect);

myConnection.Open(); //Устанавливаем соединение с базой данных.

string DelId = Convert.ToString(dataGridView1[0, dataGridView1.CurrentCell.RowIndex].Value);

string TextCommand = "Delete from sotrudniki where id_sotr =" + DelId;

MySqlCommand myCommand = new MySqlCommand(TextCommand, myConnection);

myCommand.ExecuteNonQuery();

myConnection.Close(); //Обязательно закрываем соединение!

this.Sotr_Load(sender, e);

MessageBox.Show("Данные удалены", "Удаление записи", MessageBoxButtons.OK, MessageBoxIcon.Information);

}

}

}

Размещено на Allbest.ur