<sqlMap namespace="Server">

    <sql id="sql_select_BeneficiaryUmInfo">

        select id_beneficiary, id_um, remark from sibrms_beneficiary_um

        <dynamic prepend="where">

            <isNotEmpty prepend="and" property="id_beneficiary">

                id_beneficiary = #id_beneficiary#

            </isNotEmpty>

            <isNotEmpty prepend="and" property="id_um">

                id_um = #id_um#

            </isNotEmpty>

        </dynamic>

    </sql>

    <!-- 查询数据集合 -->

    <select id="select_BeneficiaryUmInfo"

        parameterClass="java.util.HashMap"

        resultClass="server.report.model.BeneficiaryUmInfo">

        <include refid="sql_select_BeneficiaryUmInfo" />

    </select>

    <!-- 查询数据集合总记录数 -->

    <select id="select_BeneficiaryUmInfo_count"

        parameterClass="java.util.Map" resultClass="java.lang.Integer">

        select count(0) from(

        <include refid="sql_select_BeneficiaryUmInfo" />

        )

    </select></sqlMap>