Файл: Учет топлива заправочной станции.pdf

try

{

command.CommandText = "SELECT * FROM Zakaz WHERE Id_tovar = " + tab;

command.CommandType = CommandType.Text;

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

while (reader.Read())

{

zad.Id = Convert.ToInt32(reader["Id"].ToString());

zad.Id_tovar = Convert.ToInt32(reader["Id_tovar"].ToString());

zad.Id_klient = Convert.ToInt32(reader["Id_klient"].ToString());

zad.Id_vid = Convert.ToInt32(reader["Id_vid"].ToString());

zad.Data = reader["Data"].ToString();

zad.Kol = Convert.ToInt32(reader["Kol"].ToString());

zad.Ed_izm = reader["Ed_izm"].ToString();

zad.Zena = reader["Zena"].ToString();

}

return zad;

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

public zakaz Get_zakaz_idklient(String tab)

{

zakaz zad = new zakaz();

try

{

command.CommandText = "SELECT * FROM Zakaz WHERE Id_klient = " + tab;

command.CommandType = CommandType.Text;

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

while (reader.Read())

{

zad.Id = Convert.ToInt32(reader["Id"].ToString());

zad.Id_tovar = Convert.ToInt32(reader["Id_tovar"].ToString());

zad.Id_klient = Convert.ToInt32(reader["Id_klient"].ToString());

zad.Id_vid = Convert.ToInt32(reader["Id_vid"].ToString());

zad.Data = reader["Data"].ToString();

zad.Kol = Convert.ToInt32(reader["Kol"].ToString());

zad.Ed_izm = reader["Ed_izm"].ToString();

zad.Zena = reader["Zena"].ToString();

}

return zad;

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

//Klient

public void Inser_klient(klient zad)

{

try

{

command.CommandText = "INSERT INTO Klient (Name,Tel,Adress,Email) VALUES('" + zad.Name + "', '" + zad.Tel + "', '" + zad.Adress +"','"+zad.Emaill+ "')";

command.CommandType = CommandType.Text;

connection.Open();

command.ExecuteNonQuery();

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

public List<klient> Fill_klient()

{

List<klient> spisok = new List<klient>();

try

{

command.CommandText = "SELECT * FROM Klient";

command.CommandType = CommandType.Text;

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

while (reader.Read())

{

klient zad = new klient();

zad.Id = Convert.ToInt32(reader["Id"].ToString());

zad.Name = reader["Name"].ToString();

zad.Tel = reader["Tel"].ToString();

zad.Adress = reader["Adress"].ToString();

zad.Emaill = reader["Email"].ToString();

spisok.Add(zad);

}

return spisok;

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null)

{

connection.Close();

}

}

}

public klient Get_klient_name(String id)

{

klient zad = new klient();

try

{

command.CommandText = "SELECT * FROM Klient WHERE Name = '" + id + "'";

command.CommandType = CommandType.Text;

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

while (reader.Read())

{

zad.Id = Convert.ToInt32(reader["Id"].ToString());

zad.Name = reader["Name"].ToString();

zad.Tel = reader["Tel"].ToString();

zad.Adress = reader["Adress"].ToString();

zad.Emaill = reader["Email"].ToString();

}

return zad;

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

public List<klient> Fill_klient_name(String tab)

{

List<klient> spisok = new List<klient>();

try

{

command.CommandText = "SELECT * FROM Klient WHERE Name = '" + tab + " '";

command.CommandType = CommandType.Text;

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

---

while (reader.Read())

{

klient zad = new klient();

zad.Id = Convert.ToInt32(reader["Id"].ToString());

zad.Name = reader["Name"].ToString();

zad.Tel = reader["Tel"].ToString();

zad.Adress = reader["Adress"].ToString();

zad.Emaill = reader["Email"].ToString();

spisok.Add(zad);

}

return spisok;

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

public void Update_klient(klient st, klient now)

{

try

{

command.CommandText = "UPDATE Klient SET Name = '" + now.Name + "',Tel ='" + now.Tel + "',Adress ='" + now.Adress + "',Email ='" + now.Emaill + "' WHERE ID =" + st.Id;

command.CommandType = CommandType.Text;

connection.Open();

command.ExecuteNonQuery();

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

public klient Get_klient_id(String id)

{

klient zad = new klient();

try

{

command.CommandText = "SELECT * FROM Klient WHERE Id = " + id;

command.CommandType = CommandType.Text;

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

while (reader.Read())

{

zad.Id = Convert.ToInt32(reader["Id"].ToString());

zad.Name = reader["Name"].ToString();

zad.Tel = reader["Tel"].ToString();

zad.Adress = reader["Adress"].ToString();

zad.Emaill = reader["Email"].ToString();

}

return zad;

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

// Имя товара

public void Inser_tovar(tovar zad)

{

try

{

command.CommandText = "INSERT INTO Tovar (Name,Strana, Vid) VALUES('" + zad.Name + "', '" + zad.Strana + "', '" + zad.Vid + "')";

command.CommandType = CommandType.Text;

connection.Open();

command.ExecuteNonQuery();

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

public List<tovar> Fill_tovar()

{

List<tovar> spisok = new List<tovar>();

try

{

command.CommandText = "SELECT * FROM Tovar";

command.CommandType = CommandType.Text;

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

while (reader.Read())

{

tovar zad = new tovar();

zad.Id = Convert.ToInt32(reader["Id"].ToString());

zad.Name = reader["Name"].ToString();

zad.Vid = reader["Vid"].ToString();

zad.Strana = reader["Strana"].ToString();

spisok.Add(zad);

}

return spisok;

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null)

{

connection.Close();

}

}

}

public tovar Get_tovar_name(String id)

{

tovar zad = new tovar();

try

{

command.CommandText = "SELECT * FROM Tovar WHERE Name = '" + id + "'";

command.CommandType = CommandType.Text;

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

while (reader.Read())

{

zad.Id = Convert.ToInt32(reader["Id"].ToString());

zad.Name = reader["Name"].ToString();

zad.Vid = reader["Vid"].ToString();

zad.Strana = reader["Strana"].ToString();

}

return zad;

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

public List<tovar> Fill_tovar_name(String tab)

{

List<tovar> spisok = new List<tovar>();

try

{

command.CommandText = "SELECT * FROM Tovar WHERE Name = '" + tab + " '";

command.CommandType = CommandType.Text;

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

while (reader.Read())

{

tovar zad = new tovar();

zad.Id = Convert.ToInt32(reader["Id"].ToString());

zad.Name = reader["Name"].ToString();

zad.Vid = reader["Vid"].ToString();

zad.Strana = reader["Strana"].ToString();

---

spisok.Add(zad);

}

return spisok;

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

public void Update_tovar(tovar st, tovar now)

{

try

{

command.CommandText = "UPDATE Tovar SET Name = '" + now.Name + "',Vid ='" + now.Vid + "',Strana ='" + now.Strana + "' WHERE ID =" + st.Id;

command.CommandType = CommandType.Text;

connection.Open();

command.ExecuteNonQuery();

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

public tovar Get_tovar_id(String id)

{

tovar zad = new tovar();

try

{

command.CommandText = "SELECT * FROM Tovar WHERE Id = " + id;

command.CommandType = CommandType.Text;

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

while (reader.Read())

{

zad.Id = Convert.ToInt32(reader["Id"].ToString());

zad.Name = reader["Name"].ToString();

zad.Vid = reader["Vid"].ToString();

zad.Strana = reader["Strana"].ToString();

}

return zad;

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

//Количество товаров

public void Inser_koll(koll zad)

{

try

{

command.CommandText = "INSERT INTO Koll (Id_tovar, Kol, Ed_izm) VALUES('" + zad.Id_tovar + "', '" + zad.Koll + "', '" + zad.Ed_izm + "')";

command.CommandType = CommandType.Text;

connection.Open();

command.ExecuteNonQuery();

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

public List<koll> Fill_koll()

{

List<koll> spisok = new List<koll>();

try

{

command.CommandText = "SELECT * FROM Koll";

command.CommandType = CommandType.Text;

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

while (reader.Read())

{

koll zad = new koll();

zad.Id = Convert.ToInt32(reader["Id"].ToString());

zad.Id_tovar = Convert.ToInt32(reader["Id_tovar"].ToString());

zad.Koll = Convert.ToInt32(reader["Kol"].ToString());

zad.Ed_izm = reader["Ed_izm"].ToString();

spisok.Add(zad);

}

return spisok;

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null)

{

connection.Close();

}

}

}

public void Update_koll(koll st, koll now)

{

try

{

command.CommandText = "UPDATE Koll SET Id_tovar = '" + now.Id_tovar + "',Kol ='" + now.Koll + "',Ed_izm ='" + now.Ed_izm + "' WHERE ID =" + st.Id;

command.CommandType = CommandType.Text;

connection.Open();

command.ExecuteNonQuery();

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

public koll Get_koll_id(String id)

{

koll zad = new koll();

try

{

command.CommandText = "SELECT * FROM Koll WHERE Id_tovar = " + id;

command.CommandType = CommandType.Text;

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

while (reader.Read())

{

zad.Id = Convert.ToInt32(reader["Id"].ToString());

zad.Id_tovar = Convert.ToInt32(reader["Id_tovar"].ToString());

zad.Koll = Convert.ToInt32(reader["Kol"].ToString());

zad.Ed_izm = reader["Ed_izm"].ToString();

}

return zad;

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null) { connection.Close(); }

}

}

//Вид клиента

public List<vid> Fill_vid()

{

List<vid> spisok = new List<vid>();

try

{

command.CommandText = "SELECT * FROM Vid";

command.CommandType = CommandType.Text;

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

while (reader.Read())

{

vid zad = new vid();

---

zad.Id = Convert.ToInt32(reader["Id"].ToString());

zad.Status = reader["Status"].ToString();

spisok.Add(zad);

}

return spisok;

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null)

{

connection.Close();

}

}

}

public vid Get_vid_id(string id)

{

vid zad = new vid();

try

{

command.CommandText = "SELECT * FROM Vid";

command.CommandText = "SELECT * FROM Vid WHERE Id = " + id;

command.CommandType = CommandType.Text;

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

while (reader.Read())

{

zad.Id = Convert.ToInt32(reader["Id"].ToString());

zad.Status = reader["Status"].ToString();

}

return zad;

}

catch (Exception)

{

throw;

}

finally

{

if (connection != null)

{

connection.Close();

} } } }}

ПРИЛОЖЕНИЕ В

Товары в БД

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Drawing.Drawing2D;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace Apteka

{

public partial class Form_tovar : Form

{

public Form_tovar()

{

InitializeComponent();

}

private void Form_apteka_Load(object sender, EventArgs e)

{

GraphicsPath gPath = new GraphicsPath();

Rectangle rect = new Rectangle(0, 0, 680, 510);

gPath.AddRectangle(rect);

this.Region = new Region(gPath);

next();

}

private void next()

{

BD bd = new BD();

List<tovar> spisok = new List<tovar>();

spisok = bd.Fill_tovar();

dataGridView1.DataSource = spisok;

}

private void выходToolStripMenuItem_Click_1(object sender, EventArgs e)

{

this.Close();

}

private void бДToolStripMenuItem_Click(object sender, EventArgs e)

{

next();

}

private void button1_Click(object sender, EventArgs e)

{

if (textBox_FIO.Text == "")

{

MessageBox.Show("Заполните поля поиска!!!");

}

else

{

BD bd = new BD();

List<tovar> spisok = new List<tovar>();

spisok = bd.Fill_tovar_name(textBox_FIO.Text);

dataGridView1.DataSource = spisok;

}

}

private void button2_Click(object sender, EventArgs e)

{

if (textBox_name.Text == "" || textBox_strana.Text == "" || textBox_vid.Text == "")

{

MessageBox.Show("Заполните поля данных!!!");

}

else

{

tovar z = new tovar();

z.Name = textBox_name.Text;

z.Strana = textBox_strana.Text;

z.Vid = textBox_vid.Text;

BD bd = new BD();

try

{

bd.Inser_tovar(z);

tovar z1 = new tovar();

z1 = bd.Get_tovar_name(z.Name);

koll k = new koll();

k.Id_tovar = z1.Id;

k.Koll = 0;

k.Ed_izm = "Л";

bd.Inser_koll(k);

MessageBox.Show("Успешно!!!");

textBox_strana.Text = "";

textBox_name.Text = "";

textBox_vid.Text = "";

next();

}

catch (FormatException)

{ MessageBox.Show("Ошибка!"); }

}

}

private void button_delete_Click(object sender, EventArgs e)

{

if (textBox_id.Text == "")

{

MessageBox.Show("Заполните поля!!!");

}

else

{

BD bd = new BD();

bd.Delete(textBox_id.Text, "Tovar");

next();

}

}

private void button_update_Click(object sender, EventArgs e)

{

if (textBox_nam.Text == "" || textBox_stranna.Text == "" || textBox_idd.Text == "" || textBox_vidd.Text=="")

{

MessageBox.Show("Заполните поля данных!!!");

}

else

{

tovar z = new tovar();

---