| | |
| | | |
| | | public Response<PageInfo<WorksheetMain>> getHandlingListPage(DocUser user, int pageNum, int pageSize) { |
| | | PageHelper.startPage(pageNum,pageSize); |
| | | List<WorksheetMain> worksheetMainList = linkService.getInfoList2(user.getId(),0); |
| | | List<WorksheetMain> worksheetMainList = linkService.getInfoList3(user.getId(),0); |
| | | PageInfo<WorksheetMain> pageInfo = new PageInfo<>(worksheetMainList); |
| | | return new Response<PageInfo<WorksheetMain>>().set(1,pageInfo); |
| | | } |
| | |
| | | </select> |
| | | <select id="getInfoList3" resultMap="com.whyc.mapper.WorksheetMainMapper.Map_WorksheetMain"> |
| | | SELECT |
| | | m.id mid,m.*,l.deal_reason,l.deal_time |
| | | m.id mid,m.*,l.deal_desc,l.deal_reason,l.deal_time |
| | | FROM |
| | | db_doc.tb_worksheet_main m, |
| | | db_doc.tb_worksheet_link l |