public DataTable LayDanhSachNSX()
{
string sqlQuery = "select * from NHASANXUAT";
DataTable tbNhaSanXuat = db.Execute(sqlQuery);
return(tbNhaSanXuat);
}
public DataTable LayDanhSachSanPham()
{
string sqlQuery = "select a.masanpham,a.tensanpham,b.tenloai,c.tennsx,a.giamua,a.giaban,a.soluongton,a.ngaycapnhat,a.hinhsanpham,a.thongtin from SANPHAM a,LOAISANPHAM b, NHASANXUAT c where a.maloai = b.maloai and a.mansx = c.mansx";
DataTable tbSanPham = db.Execute(sqlQuery);
return(tbSanPham);
}
public DataTable LayDsHoaDon()
{
string sqlQuery = "select a.mahoadon,c.tennv,b.tenkhachhang,a.ngaydat,a.tongtien from HOADON a,KHACHHANG b, NHANVIEN c where a.makh = b.makh and a.manv = c.manv ";
DataTable tbHoaDon = db.Execute(sqlQuery);
return(tbHoaDon);
}
public DataTable LayDSKhachHang()
{
string sqlQuery = "select * from KHACHHANG";
DataTable tbKhachHang = db.Execute(sqlQuery);
return(tbKhachHang);
}
public DataTable LayDSNhanVien()
{
string sqlQuery = "select manv,tennv,gioitinh = (case when gioitinh= 1 then 'Nam' when gioitinh=0 then N'Nữ' end),diachi,dienthoai,ngaysinh from NHANVIEN";
DataTable tbNhanVien = db.Execute(sqlQuery);
return(tbNhanVien);
}
public DataTable LayDsChiTietHoaDon(string mahd)
{
string sqlQuery = string.Format("select a.masanpham,b.tensanpham,a.soluong,a.dongia,(soluong*dongia) as [thanhtien] from CHITIETHOADON a, SANPHAM b where a.masanpham = b.masanpham and a.mahoadon = '{0}'", mahd);
return(db.Execute(sqlQuery));
}
