/** * 列印公務車車籍資料 * * @pdOid 60365696-e13e-4db6-bb22-47b491b7003d */ @SuppressWarnings("unchecked") public String doPrintAction() { // 查詢條件: 查詢條件擇一輸入即可 Map map = getFindCriteriaMap(); CarLoan carLoan = (CarLoan) map.get("carLoan"); // 貸款別 String userCode = (String) map.get("userCode"); // 車號 String userName = (String) map.get("userName"); // 車號 // String queryString = ""; if (null == carLoan && StringUtils.isBlank(userCode) && StringUtils.isBlank(userName)) { throw new ExpRuntimeException(ErrorCode.B10055); // 請輸入至少一個查詢欄位。 } // 組queryString StringBuffer queryString = new StringBuffer(); queryString.append("1 "); if (StringUtils.isNotBlank(userCode)) { queryString.append("AND TBEXP_USER.CODE = '"); queryString.append(userCode); queryString.append("'"); } if (StringUtils.isNotBlank(userName)) { queryString.append("AND TBEXP_USER.NAME LIKE '"); queryString.append(userName); queryString.append("%'"); } if (null != carLoan) { queryString.append("AND TBEXP_CAR_LOAN.CODE = '"); queryString.append(carLoan.getCode()); queryString.append("'"); } Map<String, Object> params = new HashMap<String, Object>(); // 報表名稱與路徑 params.put( "rptName", CrystalReportConfigManagedBean.getManagedBean().getPubAffCarRegisterQueryReportName()); // 查詢字串 params.put("queryString", queryString.toString()); // 產生報表 CrystalReportConfigManagedBean.generateReport(params); return "dialog:print"; }
/** * 執行查詢功能。 * * @return */ public String doQueryAction() { Calendar eDate = (Calendar) ((Map<String, Object>) getFindCriteriaMap()).get("eDate"); if (eDate == null) { String[] paramStrs = { Messages.getString( "applicationResources", "tw_com_skl_exp_web_jsf_managed_gl_report_AirportExpandBizManagedBean_query_end_date", null) }; // {0}欄位-必須有值。 throw new ExpRuntimeException(ErrorCode.A10039, paramStrs); } Map<String, Object> params = new HashMap<String, Object>(); // Crystal Report 檔案。 CrystalReportConfigManagedBean crConfig = CrystalReportConfigManagedBean.getManagedBean(); params.put( "rptName", crConfig.getReportRootPath() + crConfig.getEconomyInstituteBudgeExecuteReportName()); params.put("eDate", DateUtils.getRocDateStrByCalendar(eDate)); CrystalReportConfigManagedBean.generateReport(params); return "dialog:print"; }