public void XoaDuLieu(ECtblHoaDon et) { cn.ThucThiCauLenhSQL(@"DELETE from tblHoaDon where MaHD=N'" + et.MaHD + "'"); }
public void SuaDuLieu(ECtblHoaDon et) { cn.ThucThiCauLenhSQL(@"UPDATE tblHoaDon SET NgayLap ='" + et.NgayLap + "', MaKH ='" + et.MaKH + "', MaNV ='" + et.MaNV + "' where MaHD='" + et.MaHD + "'"); }
public void ThemDuLieu(ECtblHoaDon et) { cn.ThucThiCauLenhSQL(@"INSERT INTO tblHoaDon (MaHD, NgayLap, MaKH, MaNV) VALUES (N'" + et.MaHD + "',N'" + et.NgayLap + "',N'" + et.MaKH + "',N'" + et.MaNV + "')"); }
public void XoaDuLieu(ECtblHoaDon et) { sql.XoaDuLieu(et); }
public void SuaDuLieu(ECtblHoaDon et) { sql.SuaDuLieu(et); }
public void ThemDuLieu(ECtblHoaDon et) { sql.ThemDuLieu(et); }