Ejemplo n.º 1
0
 private List doQueryPage(String sql, Class className) {
   int recordCount = doQueryForInt("select count(*) from (" + sql + ") rm_a");
   int[] aPage_size_current =
       (int[])
           RmRequestMonitor.getCurrentThreadRequest().getAttribute(ICoreConstants.RM_CURRENT_PAGE);
   RmPageVo pageVo = new RmPageVo(recordCount, aPage_size_current[0]);
   pageVo.setCurrentPage(aPage_size_current[1]);
   RmRequestMonitor.getCurrentThreadRequest().setAttribute(ICoreConstants.RM_PAGE_VO, pageVo);
   return doQuery(
       sql, getDefaultRowMapper(className), pageVo.getCurrentPage(), pageVo.getPageSize());
 }
  /**
   * 简单查询,分页显示,支持表单回写
   *
   * @param mapping
   * @param form
   * @param request
   * @param response
   * @return
   * @throws Exception
   */
  public ActionForward simpleQuery(
      ActionMapping mapping,
      ActionForm form,
      HttpServletRequest request,
      HttpServletResponse response)
      throws Exception {
    if (RM_YES.equals(request.getParameter(REQUEST_IS_READ_ONLY))) {
      request.setAttribute(REQUEST_IS_READ_ONLY, request.getParameter(REQUEST_IS_READ_ONLY));
    }
    IRmCodeTypeService service = getService();
    String queryCondition = super.getQueryCondition(request); // 从request中获得查询条件
    String bs_keyword = IOrgauthConstants.Authorize.RM_CODE_TYPE.bsKeyword();
    RmAuthorizeVo authorize = RmAuthorizeCache.getAuthorizeByBs_keyword(bs_keyword);

    RmPageVo pageVo =
        RmJspHelper.transctPageVo(
            request,
            getService()
                .getRecordCount(
                    queryCondition,
                    authorize,
                    RmProjectHelper.getRmUserVo(request).getParty_id_all()));
    String orderStr = RmJspHelper.getOrderStr(request); // 得到排序信息
    List<RmCodeTypeVo> beans =
        service.queryByCondition(
            queryCondition,
            orderStr,
            pageVo.getStartIndex(),
            pageVo.getPageSize(),
            authorize,
            RmProjectHelper.getRmUserVo(request).getParty_id_all()); // 按条件查询全部,带排序
    RmJspHelper.saveOrderStr(orderStr, request); // 保存排序信息
    request.setAttribute(REQUEST_QUERY_CONDITION, queryCondition);
    request.setAttribute(REQUEST_BEANS, beans); // 把结果集放入request

    request.setAttribute(
        REQUEST_WRITE_BACK_FORM_VALUES,
        RmVoHelper.getMapFromRequest((HttpServletRequest) request)); // 回写表单
    return mapping.findForward(FORWARD_LIST_PAGE);
  }