/** * @功能描述:查询库存表 @2015年9月6日 * * @param * @version * @throws MbvException */ @RequestMapping(value = "/queryByParams", method = RequestMethod.POST) @ResponseBody public JqGridBaseEntityVo<WnBean> queryByParams( JqGridBaseEntityVo<WnBean> entity, WnVo vo, HttpServletRequest request, HttpServletResponse response) throws MbvException { // 如果vo为空,则抛出异常 if (vo == null || vo.getBean() == null) { throw new MbvException("传入参数有误!"); } try { List<WnBean> list = new ArrayList<WnBean>(); // 查询总条数 WnBean bean = vo.getBean(); String weekFrom = bean.getWeekFrom(); String weekTo = bean.getWeekTo(); log.info("WnController.queryByParams -> weekFrom: " + weekFrom + ", weekTo:" + weekTo); // date if (StringUtils.isNotEmpty(weekFrom) && StringUtils.isNotEmpty(weekTo)) { bean.setWeekFrom(weekFrom); bean.setWeekTo(weekTo); bean.setDay(""); bean.setMonth(""); } else if ((StringUtils.isNotEmpty(weekFrom) && weekFrom.trim().length() == 10) || (StringUtils.isNotEmpty(weekTo) && weekTo.trim().length() == 10)) { bean.setWeekFrom(""); bean.setWeekTo(""); bean.setMonth(""); bean.setDay(weekFrom + weekTo); } else if ((StringUtils.isNotEmpty(weekFrom) && weekFrom.trim().length() == 7) || (StringUtils.isNotEmpty(weekTo) && weekTo.trim().length() == 7)) { bean.setWeekFrom(""); bean.setWeekTo(""); bean.setDay(""); bean.setMonth(weekFrom + weekTo); } else { bean.setWeekFrom(""); bean.setWeekTo(""); bean.setDay(""); bean.setMonth(""); } HttpSession session = request.getSession(); String user = (String) session.getAttribute(MbvConstant.USER_CODE); String unitCode = (String) session.getAttribute(MbvConstant.UNIT_CODE); bean.setUnitCode(unitCode); int totalCount = wnService.queryByParamsCount(bean); log.info("totalCount:" + totalCount); // 如果查询不到,择返回 if (totalCount > 0) { // 组装分页数据 int offset = (entity.getPage() - 1) * entity.getRows(); int limit = entity.getRows(); // 获取数据 list = wnService.queryByParams(vo.getBean(), offset, limit); // 设置分页条数 JqGridPagesUtils.setPagingParams(entity, list, totalCount); } } catch (MbvException e) { throw new MbvException(MbvConstant.MBV_SYS_ERROR_TIP); } catch (RuntimeException e) { throw new MbvException(MbvConstant.MBV_SYS_ERROR_TIP); } // 返回查询结果 return entity; }