public void XoaDuLieu(ECtblCTHD et)
{
sql.XoaDuLieu(et);
}
public void SuaDuLieu(ECtblCTHD et)
{
sql.SuaDuLieu(et);
}
public void ThemDuLieu(ECtblCTHD et)
{
sql.ThemDuLieu(et);
}
public void XoaDuLieu(ECtblCTHD et)
{
cn.ThucThiCauLenhSQL(@"DELETE from tblCTHD where MaHD='" + et.MaHD + "' And MaHang='" + et.MaHang + "'");
}
public void SuaDuLieu(ECtblCTHD et)
{
cn.ThucThiCauLenhSQL(@"UPDATE tblCTHD SET SoLuongMua = '" + et.SoLuongMua + "', DonGia = '" + et.DonGia + "', ThanhTien = (" + et.SoLuongMua + "*" + et.DonGia + ") where MaHD='" + et.MaHD + "' And MaHang='" + et.MaHang + "'");
}
public void ThemDuLieu(ECtblCTHD et)
{
cn.ThucThiCauLenhSQL(@"INSERT INTO tblCTHD (MaHD, MaHang, SoLuongMua, DonGia, ThanhTien ) VALUES (N'" + et.MaHD + "',N'" + et.MaHang + "',N'" + et.SoLuongMua + "',N'" + et.DonGia + "',(" + et.SoLuongMua + " * " + et.DonGia + "))");
}
