// xóa
public void Delete(EC_KHACH et)
{
sql.Delete(et);
}
// sửa
public void Update(EC_KHACH et)
{
sql.Update(et);
}
// thêm
public void Insert(EC_KHACH et)
{
sql.Insert(et);
}
// xóa
public void Delete(EC_KHACH et)
{
cn.ExecuteSql(@"DELETE FROM KHACH WHERE MaKH = N'" + et.MaKH + "' ");
}
// sửa
public void Update(EC_KHACH et)
{
cn.ExecuteSql(@"UPDATE KHACH SET MaKH = N'" + et.MaKH + "', TenKH = N'" + et.TenKH + "', DiaChi = N'" + et.DiaChi + "' WHERE MaKH = N'" + et.MaKH + "'");
}
// thêm
public void Insert(EC_KHACH et)
{
cn.ExecuteSql(@"INSERT INTO KHACH(MaKH, TenKH, DiaChi) VALUES(N'" + et.MaKH + "',N'" + et.TenKH + "',N'" + et.DiaChi + "')");
}
