源代码:
public FormListResult querySendPageList(PageListIO io) {
PageHelper.startPage(io.currentPage(), io.pageSize());
WorkOrderSendIO workOrderSendIO = (WorkOrderSendIO) io.getFormData();
Integer resutl = settingControlConfigMapper.findOverTimeByControlType(2);
workOrderSendIO.setOutTimeS(resutl);
//...其他代码
Page page = (Page<WorkOrderSendResult>) workOrderMapper.queryWorkOrderSendPageList(io.buildSQLMap());
return new FormListResult<WorkOrderSendResult>(page);
}
说明:
PageHelper只会对靠近的第一个select查询语句进行分页,在这里对findOverTimeByControlType进行分页了,没有对queryWorkOrderSendPageList分页
解决方案:
将PageHelper移动一下位置就可以了
public FormListResult querySendPageList(PageListIO io) {
WorkOrderSendIO workOrderSendIO = (WorkOrderSendIO) io.getFormData();
Integer resutl = settingControlConfigMapper.findOverTimeByControlType(2);
workOrderSendIO.setOutTimeS(resutl);
//...其他代码
PageHelper.startPage(io.currentPage(), io.pageSize());
Page page = (Page<WorkOrderSendResult>) workOrderMapper.queryWorkOrderSendPageList(io.buildSQLMap());
return new FormListResult<WorkOrderSendResult>(page);
}