<!-- 在历史订单界面执行有条件的查询 -->
    <select id="getHisInfoList" parameterType="com.gdmu.hnrs.model.ComplexBean" resultMap="getHisInfoListMap">
        <![CDATA[ 
            select NUT_PRIINFO.p_id,NUT_PRIINFO.p_name,NUT_FDML.f_id,NUT_FDML.f_name,NUT_DIS.d_id,NUT_DIS.d_name,NUT_HISTFOD.l_time
            from NUT_PRIINFO,NUT_FDML,NUT_HISTFOD,NUT_DIS,NUT_DEPT
            where NUT_HISTFOD.P_ID=NUT_PRIINFO.P_ID and NUT_HISTFOD.D_ID=NUT_DIS.D_ID and 
                  NUT_HISTFOD.F_ID=NUT_FDML.F_ID and NUT_DIS.k_Id=NUT_DEPT.K_ID and
                  NUT_DEPT.M_ID = #{managerBean.m_id}
        ]]>
</select>

<resultMap id="getHisInfoListMap" type="com.gdmu.hnrs.model.ComplexBean" >
        <association property="patientBean" javaType="com.gdmu.hnrs.model.PatientBean">
           <id property="p_id" column="p_id"/>
           <result property="p_name" column="p_name"/>
        </association>
        <association property="foodBean" javaType="com.gdmu.hnrs.model.FoodBean">
           <id property="f_id" column="f_id"/>
           <result property="f_name" column="f_name"/>
        </association>
        <association property="diseaseBean" javaType="com.gdmu.hnrs.model.DiseaseBean">
           <id property="d_id" column="d_id"/>
           <result property="d_name" column="d_name"/>
        </association>
        <association property="historyListBean" javaType="com.gdmu.hnrs.model.HistoryListBean">
           <result property="l_time" column="l_time"/>
        </association>
     </resultMap>

/**
     * 在历史订单界面执行有条件的查询
     */
    public List<ComplexBean> getHisInfoList(ComplexBean complexBean);