//xoa
public void XoaDuLieu(EC_MatHang et)
{
sql.XoaDuLieu(et);
}
//sua
public void SuaDuLieu(EC_MatHang et)
{
sql.SuaDuLieu(et);
}
//them du lieu
public void ThemDuLieu(EC_MatHang et)
{
sql.ThemDuLieu(et);
}
//xoa
public void XoaDuLieu(EC_MatHang et)
{
cn.ThucThiCauLenhSQL(@"delete from MATHANG where MaMH = '" + et.MaGH1 + "'");
}
//sua
public void SuaDuLieu(EC_MatHang et)
{
cn.ThucThiCauLenhSQL(@"update MATHANG set TenMH = N'" + et.TenMH1 + "',SoLuong='" + et.SoLuong1 + "',GiaMH = '" + et.GiaMH1 + "',NSX = '" + et.NSX1 + "',MaGH = N'" + et.MaGH1 + "',MaNV = N'" + et.MaNV1 + "' where MaMH = '" + et.MaMH1 + "'");
}
//them du lieu
public void ThemDuLieu(EC_MatHang et)
{
cn.ThucThiCauLenhSQL(@"insert into MATHANG values ('" + et.MaMH1 + "', N'" + et.TenMH1 + "','" + et.SoLuong1 + "','" + et.GiaMH1 + "','" + et.NSX1 + "', N'" + et.MaGH1 + "', N'" + et.MaNV1 + "'");
}
