To address the issue of the low compression–tension ratio in the traditional parallel bond model (PBM), this study proposes an improved PBM incorporating a random distribution strategy of strong–weak contact groups. An L₂₇(3¹²) orthogonal experimental design was employed to construct 27 sets of numerical simulation schemes. Combined with Pearson correlation coefficient analysis and multivariate regression, the influence of twelve microscopic parameters on seven of the macroscopic mechanical properties of sandstone was systematically investigated, including elastic modulus (E), Poisson’s ratio (v), uniaxial compressive strength (σ_c), internal friction angle (φ), cohesion (c), crack damage stress ratio (σ_cd/σ_c), and compressive–tensile strength ratio (σ_c/σ_t). Based on these analyses, a quantitative relationship model between the macro and micro parameters was established and validated through numerical simulation and experimental comparison. The proposed method provides a theoretical foundation for the mechanical modeling of sandstone and the inversion of microscopic parameters.