81,122
社区成员




queryParam.put("merid", "1001");// 测试参数
// queryParam.put("merid", user.getCustomerId());
queryParam.put("merorderid", "%" + merorderid + "%");
if ("0".equals(state)) {
String sta = "('2', '4', '6')";
queryParam.put("state", sta);
}
else if ("1".equals(state)) {
queryParam.put("state", "7");
}
else if ("2".equals(state)) {
String sta = "('1', '3', '5')";
queryParam.put("state", sta);
}
@Select({
"select * from ",
"(select tmp.*,rownum rr from ",
"( ",
"select REQ.* ",
"from TBL_GPY_RTNREQ REQ ",
"where REQ.MER_ID=#{merid,jdbcType=VARCHAR} ",
"and (REQ.RTN_TYPE='0' or REQ.RTN_TYPE is null) ",
//我的sql语句用到了in,该怎么把参数传过来?
"and (#{state,jdbcType=VARCHAR} is null ORREQ.RTN_STA IN #{state,jdbcType=VARCHAR})",
"and (#{merorderid,jdbcType=VARCHAR} is null OR REQ.MER_ORDER_NO like #{merorderid,jdbcType=VARCHAR}) ",
"and (#{starttime,jdbcType=VARCHAR} is null OR substr(REQ.PLAT_DATE,0,8)>=#{starttime,jdbcType=VARCHAR}) ",
"and (#{endtime,jdbcType=VARCHAR} is null OR substr(REQ.PLAT_DATE,0,8)<=#{endtime,jdbcType=VARCHAR}) ",
"order by REQ.PLAT_DATE desc ",
") tmp ",
"where rownum <= #{end,jdbcType=VARCHAR}) ",
"where rr > #{begin,jdbcType=VARCHAR} "
})