Добавлен: 14.06.2023
Просмотров: 348
Скачиваний: 12
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();