public DataSet DoTaiKhoan1(string user, string pass, string Quyen) { return(db.ExecuteQueryDataSetWithPra("dbo.spDoTkQuyen", CommandType.StoredProcedure, new SqlParameter("@user", user), new SqlParameter("@pass", pass), new SqlParameter("@Quyen", Quyen))); }
public DataSet KiemTraMaDH(string MaDH) { return(db.ExecuteQueryDataSetWithPra("spKiemTraMaHDNH", CommandType.StoredProcedure, new SqlParameter("@MaDH", MaDH))); }
public DataSet DoMaBH(string MaBH) { return(db.ExecuteQueryDataSetWithPra("spDoMaBH", CommandType.StoredProcedure, new SqlParameter("@MaBH", MaBH))); }
public DataSet LayThongKeTheoThangNam(int Thang, int Nam) { return(db.ExecuteQueryDataSetWithPra("spThongKeChiPhiBanTheoThangNam", CommandType.StoredProcedure, new SqlParameter("@Thang", Thang), new SqlParameter("@Nam", Nam))); }
public DataSet KiemTraMaThahHToan(string MaThanhToan) { return(db.ExecuteQueryDataSetWithPra("spKiemTraMaThanhToan", CommandType.StoredProcedure, new SqlParameter("@MaThanhToan", MaThanhToan))); }
public DataSet InHoaDon(string MaDH) { return(db.ExecuteQueryDataSetWithPra("spInHoaDonBanHang", CommandType.StoredProcedure, new SqlParameter("@MaHD", MaDH))); }
public DataSet ThongKeSLTheoLoai(string MaLoai) { return(db.ExecuteQueryDataSetWithPra("spThongKeSoLuongSPBanRaTheoLoai", CommandType.StoredProcedure, new SqlParameter("@MaLoai", MaLoai))); }
public DataSet LayListSanPhamTheoLoai(string MaLoai) { return(db.ExecuteQueryDataSetWithPra("spLayListSanPhamTheoLoai", CommandType.StoredProcedure, new SqlParameter("@MaLoai", MaLoai))); }
// Lấy giá trị HĐ bán hàng public DataSet GiaTriDonBan(string maHoaDon) { return(db.ExecuteQueryDataSetWithPra("spLayGiaTriHDBan", CommandType.StoredProcedure, new SqlParameter("@MaDon", maHoaDon))); }
// Lấy chi tiết nhập theo mã đơn nhập public DataSet LayChiTietNhapTheoMaDon(string MaDonNhap) { return(db.ExecuteQueryDataSetWithPra("spLayChiTietNhapTheoMaHD", CommandType.StoredProcedure, new SqlParameter("@MaDonNhap", MaDonNhap))); }
// lấy chi tiết hóa đơn theo mã hóa đơn public DataSet LayChiTietHDBanHangTheoMaHD(string maHoaDon) { return(db.ExecuteQueryDataSetWithPra("spLayChiTietHDBanHangTheoMa", CommandType.StoredProcedure, new SqlParameter("@MaHD", maHoaDon))); }