<selectid="getTotalCount"resultType="java.lang.Integer">
SELECT COUNT(1) FROM T_USER
<where><iftest="yhbm != null">
YHBM = #{yhbm} ORDER BY PXH ASC
</if><iftest="yh != null">
YHID = #{yh} OR BINARY YHXM LIKE #{yhxm} ORDER BY PXH ASC
</if></where></select>