public Object listAsGrid(JqPager pemail) {
JqGridReturn returnResult = new JqGridReturn();
MessageNoteExample messageNoteExample = new MessageNoteExample();
if (null != pemail.getPage() && null != pemail.getRows()) { // 设置排序信息
messageNoteExample.setLimitStart((pemail.getPage() - 1) * pemail.getRows());
messageNoteExample.setLimitEnd(pemail.getRows());
}
if (StringUtils.isNotBlank(pemail.getSort())
&& StringUtils.isNotBlank(pemail.getOrder())) { // 设置排序信息
messageNoteExample.setOrderByClause(pemail.getOrderBy("temp_message_note_"));
}
List<MessageNote> messageNotes =
messageNoteMapper.selectByExample(messageNoteExample); // 查询所有广告列表
int total = messageNoteMapper.countByExample(messageNoteExample); // 查询总页数
returnResult.setRows(messageNotes);
returnResult.setTotal(total);
return returnResult; // 返回ExtGrid表
}
