public void XoaDuLieu(ECtblHang et)
{
sql.XoaDuLieu(et);
}
public void SuaDuLieu(ECtblHang et)
{
sql.SuaDuLieu(et);
}
public void ThemDuLieu(ECtblHang et)
{
sql.ThemDuLieu(et);
}
public void XoaDuLieu(ECtblHang et)
{
cn.ThucThiCauLenhSQL(@"DELETE from tblHang where MaHang='" + et.MaHang + "'");
}
public void SuaDuLieu(ECtblHang et)
{
cn.ThucThiCauLenhSQL(@"UPDATE tblHang SET TenHang ='" + et.TenHang + "', DVT ='" + et.DVT + "', DonGiaHang ='" + et.DonGia + "',NhaSX ='" + et.NhaSX + "', SoLuongCon ='" + et.SoLuongCon + "',MoTa='" + et.MoTa + "' where MaHang='" + et.MaHang + "'");
}
public void ThemDuLieu(ECtblHang et)
{
cn.ThucThiCauLenhSQL(@"INSERT INTO tblHang(MaHang, TenHang, DVT, DonGiaHang, SoLuongCon, NhaSX, MoTa) VALUES ( N'" + et.MaHang + "',N'" + et.TenHang + "',N'" + et.DVT + "',N'" + et.DonGia + "',N'" + et.SoLuongCon + "',N'" + et.NhaSX + "','" + et.MoTa + "')");
}