| | |
| | | } |
| | | |
| | | /** |
| | | * 查询数据 |
| | | * 查询数据+附件 |
| | | */ |
| | | private void queryData(DownloadReqEntity dr, Map<String, List<?>> dataMap, Map<String, List<AttachEntity>> annexMap) { |
| | | for (String enity : dr.getEntities()) { |
| | |
| | | </select> |
| | | |
| | | <select id="selectDirRoot" resultType="com.lf.server.entity.data.DirEntity"> |
| | | select a.*, fn_get_fullname(a.code, 2) fullName from lf.sys_dir a where pid = 0 order by order_num; |
| | | select a.*, fn_get_fullname(a.code, 2) fullName |
| | | from lf.sys_dir a |
| | | where pid = 0 |
| | | order by code; |
| | | </select> |
| | | |
| | | <select id="selectProject" resultType="com.lf.server.entity.data.DirEntity"> |
| | | select a.*, fn_get_fullname(a.code, 2) fullName |
| | | from lf.sys_dir a |
| | | <where> |
| | | pid = 0 |
| | | pid = 0 and id > 1 |
| | | <if test="name != null"> |
| | | and upper(name) like #{name} |
| | | </if> |
| | | </where> |
| | | order by order_num; |
| | | order by code; |
| | | </select> |
| | | |
| | | <select id="selectDirRecursive" resultType="com.lf.server.entity.data.DirEntity"> |