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)); }