public void XoaDuLieu(ECtblKhachHang et) { sql.XoaDuLieu(et); }
public void SuaDuLieu(ECtblKhachHang et) { sql.SuaDuLieu(et); }
public void ThemDuLieu(ECtblKhachHang et) { sql.ThemDuLieu(et); }
public void XoaDuLieu(ECtblKhachHang et) { cn.ThucThiCauLenhSQL(@"DELETE from tblKhachHang where MaKH=N'" + et.MaKH + "'"); }
public void SuaDuLieu(ECtblKhachHang et) { cn.ThucThiCauLenhSQL(@"UPDATE tblKhachHang SET TenKH =N'" + et.TenKH + "', MaLoaiKH =N'" + et.MaLoaiKH + "', DiaChi =N'" + et.Diachi + "', DienThoai =N'" + et.DienThoai + "', TinhTrang = N'" + et.TinhTrang + "'where MaKH=N'" + et.MaKH + "'"); }
public void ThemDuLieu(ECtblKhachHang et) { cn.ThucThiCauLenhSQL(@"INSERT INTO tblKhachHang (MaKH, TenKH, MaLoaiKH, DiaChi, DienThoai, TinhTrang) VALUES(N'" + et.MaKH + "',N'" + et.TenKH + "',N'" + et.MaLoaiKH + "',N'" + et.Diachi + "',N'" + et.DienThoai + "',N'" + et.TinhTrang + "')"); }