1

 1 <select id="findList" resultType="BndExport">
 2         SELECT 
 3             <include refid="bndExportColumns"/>
 4         FROM bnd_export a
 5         <include refid="bndExportJoins"/>
 6         <where>
 7             a.del_flag = #{DEL_FLAG_NORMAL}
 8             <if test="createDate != null and createDate != ''">
 9                 AND a.create_date = #{createDate}
10             </if>
11             <if test="createDateStart!=null and createDateStart!='' and createDateEnd!=null and createDateEnd!=''">
12                 AND a.create_date between to_date('${createDateStart}','yyyy-mm-dd hh24:mi:ss') and to_date('${createDateEnd}','yyyy-mm-dd hh24:mi:ss')
13             </if>
14             <if test="company != null and company != ''">
15                 AND a.company = #{company}
16             </if>
17             <if test="bndExportFreight != null and bndExportFreight != '' and bndExportFreight.vessel != null and bndExportFreight.vessel != ''">
18                 AND b.vessel= #{bndExportFreight.vessel}
19             </if>
20             <if test="bndExportFreight != null and bndExportFreight != '' and bndExportFreight.voyage != null and bndExportFreight.voyage != ''">
21                 AND b.vessel= #{bndExportFreight.voyage}
22             </if>
23         </where>

 

posted on 2016-11-15 19:29  Sharpest  阅读(315)  评论(0编辑  收藏  举报