public int Them(EC_KhachHang et)
{
string a = "1995-12-12";
return(cn.ThucHienLenh(@"insert into tblKhachHang values ('" + et.MaKH + "',N'" + et.TenKH + "','" + et.NgaySinh + "',N'" + et.GT + "','" + et.SoDT + "','" + et.CMND + "',N'" + et.DiaChi + "')"));
//return (cn.ThucHienLenh(@"themkh '" + et.MaKH + "',N'" + et.TenKH + "','" + et.NgaySinh + "',N'" + et.GT + "','" + et.SoDT + "','" + et.CMND + "',N'" + et.DiaChi + "'"));
}
public void Xoa(EC_KhachHang et)
{
cn.ThucHienLenh(@"DELETE FROM tblKhachHang where MaKH = '" + et.MaKH + "'");
}
public int Sua(EC_KhachHang et)
{
string a = "1995-12-12";
return(cn.ThucHienLenh(@"update tblKhachHang SET TenKH = N'" + et.TenKH + "',NgaySinh = '" + et.NgaySinh + "',GT = N'" + et.GT + "', SoDT = '" + et.SoDT + "',CMND = '" + et.CMND + "',DiaChi = N'" + et.DiaChi + "' where MaKH = '" + et.MaKH + "'"));
}
