/**
* @Title: listAsGrid @Description: TODO(获取所有货物档案信息)
*
* @param @param pager
* @param @return 设定文件
* @return Object 返回类型
* @throws
*/
public Object listAsGrid(JqPager jqPager, GoodsListQueryDTO goodsListQueryDTO) {
JqGridReturn returnResult = new JqGridReturn();
GoodsListExample goodsListExample = new GoodsListExample();
Criteria queryCriteria = goodsListExample.createCriteria();
goodsListQueryDTO.setQueryCondition(queryCriteria);
if (null != jqPager.getPage() && null != jqPager.getRows()) { // 设置排序信息
goodsListExample.setLimitStart((jqPager.getPage() - 1) * jqPager.getRows());
goodsListExample.setLimitEnd(jqPager.getRows());
}
if (StringUtils.isNotBlank(jqPager.getSort())
&& StringUtils.isNotBlank(jqPager.getOrder())) { // 设置排序信息
goodsListExample.setOrderByClause(jqPager.getOrderBy("temp_goods_list_"));
}
List<GoodsList> goodsList = goodsListMapper.selectByExample(goodsListExample); // 查询所有会员列表
int total = goodsListMapper.countByExample(goodsListExample); // 查询总页数
returnResult.setRows(goodsList);
returnResult.setTotal(total);
return returnResult; // 返回ExtGrid表
}
