public void XoaDuLieu(ECtblKhachHang et)
 {
     sql.XoaDuLieu(et);
 }
 public void SuaDuLieu(ECtblKhachHang et)
 {
     sql.SuaDuLieu(et);
 }
 public void ThemDuLieu(ECtblKhachHang et)
 {
     sql.ThemDuLieu(et);
 }
Ejemplo n.º 4
0
 public void XoaDuLieu(ECtblKhachHang et)
 {
     cn.ThucThiCauLenhSQL(@"DELETE from tblKhachHang where MaKH=N'" + et.MaKH + "'");
 }
Ejemplo n.º 5
0
 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 + "'");
 }
Ejemplo n.º 6
0
 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 + "')");
 }