public new List <Class_ChiTietHoaDonNhap> Select()
{
string sql = "Select * from ChiTietHoaDonNhap";
List <Class_ChiTietHoaDonNhap> list = new List <Class_ChiTietHoaDonNhap>();
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=DESKTOP-MFCIF4Q\SQLEXPRESS;Initial Catalog=QLNhaHang;Integrated Security=True";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
String MaNguyenLieu = reader.GetString(0);
String MaHoaDonNhap = reader.GetString(1);
double SoLuong = (double)reader.GetValue(2);
double DonGia = reader.GetDouble(3);
double KhuyenMai = (double)reader.GetValue(4);
double ThanhTien = reader.GetDouble(5);
Class_ChiTietHoaDonNhap chiTietHoaDonNhap1 = new Class_ChiTietHoaDonNhap(MaNguyenLieu, MaHoaDonNhap, SoLuong, DonGia, KhuyenMai, ThanhTien);
list.Add(chiTietHoaDonNhap1);
}
}
}
con.Close();
return(list);
}
private List <Class_ChiTietHoaDonNhap> Select()
{
string sql = "Select * from ChiTietHoaDonNhap";
List <Class_ChiTietHoaDonNhap> list = new List <Class_ChiTietHoaDonNhap>();
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=MINH_VU_PC\SQLEXPRESS;Initial Catalog=BTL;Integrated Security=True";
con.Open();
SqlCommand cmd = new SqlCommand(sql, con);
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
String MaNguyenLieu = reader.GetString(0);
String MaHoaDonNhap = reader.GetString(1);
decimal SoLuong = reader.GetDecimal(2);
decimal DonGia = reader.GetDecimal(3);
decimal KhuyenMai = reader.GetDecimal(4);
decimal ThanhTien = reader.GetDecimal(5);
Class_ChiTietHoaDonNhap chiTietHoaDonNhap1 = new Class_ChiTietHoaDonNhap(MaNguyenLieu, MaHoaDonNhap, SoLuong, DonGia, KhuyenMai, ThanhTien);
list.Add(chiTietHoaDonNhap1);
}
}
}
con.Close();
return(list);
}
public new List <Class_ChiTietHoaDonNhap> Select()
{
string sql = "Select * from ChiTietHoaDonNhap";
List <Class_ChiTietHoaDonNhap> list = new List <Class_ChiTietHoaDonNhap>();
query.ketnoiSQL();
using (DbDataReader reader = query.Reader(sql))
{
if (reader.HasRows)
{
while (reader.Read())
{
String MaNguyenLieu = reader.GetString(0);
String MaHoaDonNhap = reader.GetString(1);
double SoLuong = (double)reader.GetValue(2);
double DonGia = reader.GetDouble(3);
double KhuyenMai = (double)reader.GetValue(4);
double ThanhTien = reader.GetDouble(5);
Class_ChiTietHoaDonNhap chiTietHoaDonNhap1 = new Class_ChiTietHoaDonNhap(MaNguyenLieu, MaHoaDonNhap, SoLuong, DonGia, KhuyenMai, ThanhTien);
list.Add(chiTietHoaDonNhap1);
}
}
}
query.DongketnoiSQL();
return(list);
}
public void update(Class_ChiTietHoaDonNhap CTHDN)
{
string sql = "UPDATE ChiTietHoaDonNhap WHERE SET MaHoaDonNhap=" + CTHDN.MaHoaDonNhap1 + ",MaNguyenLieu=N'" +
CTHDN.MaNguyenLieu1 + "', SoLuong='" + CTHDN.SoLuong1 + "', DonGia='" + CTHDN.DonGia1 + ",KhuyenMai='"
+ CTHDN.KhuyenMai1 + ",ThanhTien='" + CTHDN.ThanhTien1 + "')";
query.insert(sql);
}
public void insert(Class_ChiTietHoaDonNhap CTHDN)
{
string sql = "INSERT INTO ChiTietHoaDonNhap(MaHoaDonNhap,MaNguyenLieu,SoLuong,DonGia,KhuyenMai,ThanhTien) VALUES(";
sql += CTHDN.MaHoaDonNhap1 + ",N'" + CTHDN.MaNguyenLieu1 + "',N'" + CTHDN.SoLuong1 + "',N'" + CTHDN.DonGia1
+ "',N'" + CTHDN.KhuyenMai1 + "',N'" + CTHDN.ThanhTien1 + "')";
query.insert(sql);
}
public void delete(Class_ChiTietHoaDonNhap CTHDN)
{
string sql = "DELETE FROM ChiTietHoaDonNhap WHERE MaHoaDonNhap = " + CTHDN.MaHoaDonNhap1 + " and MaNguyenLieu = " + CTHDN.MaNguyenLieu1;
query.insert(sql);
}
