public List queryProjectWarning(Map projectMap) {
try {
return dao.queryForList("MapService.queryProjectWarning", projectMap);
} catch (SQLException e) {
log.error(e);
throw new RuntimeException(e);
}
}
select id="queryProjectWarning" resultClass="java.util.HashMap">
SELECT * FROM PD_ALARM_PROJ_VOU
dynamic prepend = " where ">
isNotNull prepend="and" property="coCode">
co_code like #coCode#||'%'
/isNotNull>
isNotNull prepend="and" property="uScaleText">
level_name = #uScaleText#
/isNotNull>
isNotNull prepend="and" property="projectText">
project_name like '%'|| #projectText# ||'%'
/isNotNull>
isNotNull prepend="and" property="pScaleText">
scale_name = #pScaleText#
/isNotNull>
isNotNull prepend="and" property="beginText">
vou_date >= #beginText#
/isNotNull>
isNotNull prepend="and" property="endText">
vou_date <= #endText#
/isNotNull>
/dynamic>
ORDER BY co_name,project_code,acc_code,outlay_code
/select>