public static DataTable GetListNhanVien() { return(ConnectToSQLTr.GetData(" select * from NhanVien ")); }
public static DataTable GetListTuDongThemGia(SanPhamObjTr dvobj) { return(ConnectToSQLTr.GetData(" select TenSP, DonGia from SanPham where SanPham.MaSP = '" + dvobj.MaSP + "'")); }
public static DataTable GetListSanPham() { return ConnectToSQLTr.GetData(" select * from SanPham "); }
public static DataTable GetListData(ChiTietPhieuNhapObjTr cthddv) { return(ConnectToSQLTr.GetData(" select PhieuNhapChiTiet.MaSP, TenSP,PhieuNhapChiTiet.ChungLoai,PhieuNhapChiTiet.SoLuong , PhieuNhapChiTiet.DonGia , ThanhTien from PhieuNhap , SanPham , PhieuNhapChiTiet where PhieuNhap.MaPN= PhieuNhapChiTiet.MaPN and SanPham.MaSP = PhieuNhapChiTiet.MaSP and PhieuNhapChiTiet.MaPN = '" + cthddv.MaPN + "'")); }
public static DataTable GetListPhieuNhap() { return(ConnectToSQLTr.GetData("select MaPN,NgayNhap,TenNV,TenNCC,TongTien from PhieuNhap hd,NHANVIEN nv, NhaCC kh where hd.MaNV=nv.MaNV and hd.MaNCC=kh.MaNCC")); }