mybatis
来源:互联网 发布:redhat yum源配置 编辑:程序博客网 时间:2024/05/02 05:01
DAO public List<ChargeInfoMainDTO> findChargeInfoMainMapParams(Map<String,Object> params);
<select id="findChargeInfoMainMapParams" resultMap="BaseResultMap" >
selectt.CHARGE_INFO_MAIN_ID,
t.CHARGE_NO,
t1.NAME as PATIENT_NAME,
t2.NAME as CHARGE_NAME
from CS_CHARGE_INFO_MAIN t
left join HR_PATIENT_INFO t1 on t.PATIENT_ID=t1.PATIENT_ID
left join SYS_USER t2 on t.USER_ID=t2.USER_ID
where t.NONCHARGE_FLAG in
<foreach collection="flags" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
<if test="chargeInfoMainId!=null and chargeInfoMainId!=''">
and t.CHARGE_INFO_MAIN_ID = #{chargeInfoMainId}
</if>
<if test="chargeNo!=null and chargeNo!=''">
and t.CHARGE_NO like '%'||#{chargeNo}||'%'
</if>
<if test="patientName!=null and patientName!=''">
and t1.NAME like '%'||#{patientName}||'%'
</if>
<if test="chargeName!=null and chargeName!=''">
and t2.NAME like '%'||#{chargeName}||'%'
</if>
<if test="chargeDateStart!=null and chargeDateStart!=''">
<![CDATA[ and t.CHARGE_DATE>=#{chargeDateStart,jdbcType=VARCHAR}]]>
</if>
<if test="chargeDateEnd!=null and chargeDateEnd!=''">
<![CDATA[ and t.CHARGE_DATE<=#{chargeDateEnd,jdbcType=VARCHAR} ]]>
</if>
order by t.CHARGE_DATE desc
</select>
0 0
- MyBatis
- MyBatis
- Mybatis
- myBatis
- mybatis
- MyBatis
- mybatis
- Mybatis
- MyBatis
- Mybatis
- mybatis
- MyBatis
- MyBatis
- mybatis
- MyBatis
- mybatis
- mybatis
- mybatis
- 为王菲写的第十首《雄心永在》
- MyEclipse使用总结——MyEclipse10安装SVN插件
- Android Asynchronous Http Client-Android异步网络请求客户端接口
- 14、实例 通用兄弟元素选择器
- H头文件管理
- mybatis
- 也谈基于NodeJS的全栈式开发(基于NodeJS的前后端分离)
- 设计模式 - 组合模式(composite pattern) 详解
- Python多线程协同(C/P)完成设备[反复重启]疲劳测试
- 任务管理器测试内存泄露
- 仿iOS通讯录页面设计
- GBD 调试(一)
- DRP——Dom4j使用
- Android 中对于图片的内存优化方法