Evaluation of weakly singular integrals via generalized Cartesian product rules based on the double exponential formula