/** * 根据结算单位,账户取账户对应的VO 拆分出来做公用方法 * * @return */ public static CurrtypeVO getCurrTypeVO(String pk_accid) throws BusinessException { StringBuffer whereClause = new StringBuffer() .append(" bd_currtype.pk_currtype = ") .append(" (select e.pk_currtype from bd_accid e where ") .append(" e.pk_accid='") .append(pk_accid) .append("')"); SuperVO[] vos = null; try { vos = HYPubBO_Client.queryByCondition(CurrtypeVO.class, whereClause.toString()); } catch (UifException e) { Logger.error(e.getMessage(), e); throw new BusinessException( nc.ui.ml.NCLangRes.getInstance().getStrByID("fbmcomm", "UPPFBMComm-000155") /* * @res * "根据结算单位和账户查询账户币种异常" */); } if (vos == null || vos.length == 0) { throw new BusinessException( nc.ui.ml.NCLangRes.getInstance().getStrByID("fbmcomm", "UPPFBMComm-000156") /* * @res * "根据结算单位和账户无法查询到账户对应币种" */); } return (CurrtypeVO) vos[0]; }
public void end() { // 处理组合单元格 if (!mergeCells.isEmpty()) { Region[] regs = new Region[mergeCells.size()]; mergeCells.values().toArray(regs); int len = regs.length; for (int i = 0; i < len; i++) m_sheet.addMergedRegion(regs[i]); } try { flushToFile(); } catch (Exception e) { m_spool.setErrorMsg(e.getMessage()); } finally { if (out != null) try { out.close(); } catch (IOException e) { Logger.error(e.getMessage(), e); } } StringBuffer msg = new StringBuffer(); // 最后给出完整的提示 if (sheetCounter > 1) { String filename = m_filepath.substring(m_filepath.lastIndexOf(System.getProperty("file.separator")) + 1); msg.append( nc.ui.ml.NCLangRes.getInstance() .getStrByID( "10100108", "UPP10100108-000856") /*@res "\n您要导出的内容太多,为减小内存的使用量,它们被存储到目录 \n"*/); msg.append( m_filepath.substring(0, m_filepath.lastIndexOf(System.getProperty("file.separator")))); msg.append( nc.ui.ml.NCLangRes.getInstance() .getStrByID("10100108", "UPP10100108-000857") /*@res " 下的多个Excel文件中,分别是:\n"*/); msg.append(filename).append(","); for (int i = 2; i <= sheetCounter; i++) { if (i != sheetCounter) { msg.append(filename.substring(0, filename.indexOf('.')) + "-" + i + ".xls").append(","); } else { msg.append(filename.substring(0, filename.indexOf('.')) + "-" + i + ".xls"); } } } else { msg.append( nc.ui.ml.NCLangRes.getInstance() .getStrByID("10100108", "UPP10100108-000858") /*@res "导出内容被存放在文件 \n"*/ + m_filepath + nc.ui.ml.NCLangRes.getInstance() .getStrByID("10100108", "UPP10100108-000859") /*@res " 中."*/); } m_spool.setMsg(msg.toString()); mergeCells = new Hashtable(); // 存放所有组合单元格 styles = new Hashtable(); }
/** * 设置进度条信息 * * @param progressValue */ private void setProgressBarHintMsg() { m_spool.setHintmessage( nc.ui.ml.NCLangRes.getInstance() .getStrByID("10100108", "UPP10100108-001014") /*@res "共要导出"*/ + m_spool.getWholeLineCount() + nc.ui.ml.NCLangRes.getInstance() .getStrByID("10100108", "UPP10100108-001015") /*@res "行数据,"*/ + nc.ui.ml.NCLangRes.getInstance() .getStrByID("10100108", "UPP10100108-001016") /*@res "已完成,"*/ + m_spool.getCurrentLineCount() * 100 / m_spool.getTotalLineCount() + "%,"); m_spool.setMsg( nc.ui.ml.NCLangRes.getInstance() .getStrByID("10100108", "UPP10100108-001017") /*@res "正在导出数据...已导出,"*/ + m_spool.getExportedLineCount() + nc.ui.ml.NCLangRes.getInstance() .getStrByID("10100108", "UPP10100108-001018") /*@res "行数据,"*/); }
public void run() { int pagesize = PAGESIZE; try { while (!m_spool.isHasError() && !m_spool.isEmpty()) { if (linecounter >= pagesize) { // 处理组合单元格 if (!mergeCells.isEmpty()) { Region[] regs = new Region[mergeCells.size()]; mergeCells.values().toArray(regs); int len = regs.length; for (int i = 0; i < len; i++) m_sheet.addMergedRegion(regs[i]); } try { flushToFile(); } catch (Exception e) { Logger.error(e.getMessage(), e); m_spool.setErrorMsg(e.getMessage()); } finally { if (out != null) try { out.close(); } catch (IOException e) { Logger.error(e.getMessage(), e); } } m_workbook = new HSSFWorkbook(); // 创建工作薄 m_sheet = m_workbook.createSheet(); // 创建表单 mergeCells = new Hashtable(); // 存放所有组合单元格 styles = new Hashtable(); linecounter = 0; sheetCounter++; } PrintCellData[] data = null; data = (PrintCellData[]) m_spool.retrieve(); linecounter = linecounter + data.length; // 其实为单元格数目,非行数 fileUtil.exportSheet2(m_templateData, data, m_sheet, m_workbook, styles, mergeCells); /* 每往Excel写入一行,进度条+1,已导出的行数+1 */ m_spool.setExportedLineCount(m_spool.getExportedLineCount() + 1); stepProgressBar(1); setProgressBarHintMsg(); } } catch (Exception e) { Logger.error(e.getMessage(), e); m_spool.setErrorMsg(e.getMessage()); } catch (OutOfMemoryError e) { Logger.error(e.getMessage(), e); m_spool.setErrorMsg( nc.ui.ml.NCLangRes.getInstance() .getStrByID( "10100108", "UPP10100108-000860") /*@res "内存不足,请修改Java Plugin参数,将内存调整大一些"*/); } }
public ButtonVO getButtonVO() { ButtonVO bvo = new ButtonVO(); bvo.setBtnNo(IFBMButton.Discount_Calculate); bvo.setBtnChinaName("лЫожйткЦ"); bvo.setBtnCode("DISCOUNT"); bvo.setBtnName( nc.ui.ml.NCLangRes.getInstance() .getStrByID("fbmcomm", "UPPFBMComm-000012") /* @res"лЫожйткЦ"*/); bvo.setHintStr( nc.ui.ml.NCLangRes.getInstance() .getStrByID("fbmcomm", "UPPFBMComm-000012") /* @res"лЫожйткЦ"*/); bvo.setHotKey("D"); bvo.setDisplayHotKey("(Shift+D)"); bvo.setModifiers(Event.SHIFT_MASK); // bvo.setOperateStatus(new int[]{IBillOperate.OP_NOTEDIT,IBillOperate.OP_INIT}); // bvo.setBusinessStatus(new int[]{IFBMStatus.Transact}); return bvo; }
public ButtonVO getButtonVO() { ButtonVO btnVo = new ButtonVO(); btnVo.setBtnChinaName("全消"); btnVo.setBtnName( nc.ui.ml.NCLangRes.getInstance().getStrByID("36201005", "UPP36201005-000030") /* * @res * "全消" */); btnVo.setHintStr( nc.ui.ml.NCLangRes.getInstance().getStrByID("36201005", "UPP36201005-000030") /* * @res * "全消" */); btnVo.setBtnCode("CANCELSELECT"); btnVo.setBtnNo(IFBMButton.FBM_CANCELSELECT); btnVo.setOperateStatus(new int[] {IBillOperate.OP_NOTEDIT}); btnVo.setModifiers(Event.CTRL_MASK); btnVo.setHotKey("N"); btnVo.setDisplayHotKey("(Ctrl+N)"); return btnVo; }
private SortDLG getSortDlg() { if (sortDlg == null) sortDlg = new SortDLG( getReportBaseUI(), nc.ui.ml.NCLangRes.getInstance() .getStrByID( "uifactory_report", "UPPuifactory_report-000006") /* @res "ÅÅÐòÉèÖÃ" */, getReportBaseUI().getVisibleFields(), null); return sortDlg; }
public void execute() throws Exception { if (getSortDlg().showModal() == UIDialog.ID_OK) { if (getSortDlg().getSortFields() != null) { String[] fields = getSortDlg().getSortFields(); int[] asc = getSortDlg().getAscOrDesc(); getReportBaseUI().onSort(fields, asc); getReportBaseUI() .showHintMessage( nc.ui.ml.NCLangRes.getInstance() .getStrByID( "uifactory_report", "UPPuifactory_report-000034") /* @res "ÅÅÐò³É¹¦" */); } } }
/* (non-Javadoc) * @see nc.ui.fbm.pub.AbstractUIChecker#check() */ @Override public String check() { String cctype = (String) getUI().getBillCardPanel().getHeadItem(RegisterVO.CCTYPE).getValueObject(); String pk_loanbank = (String) getUI().getBillCardPanel().getHeadItem(RegisterVO.PK_LOANBANK).getValueObject(); if (!cctype.equals(FbmBusConstant.CCTYPE_NONE)) { if (CommonUtil.isNull(pk_loanbank)) { return nc.ui.ml.NCLangRes.getInstance() .getStrByID("36201505", "UPP36201505-000002") /* @res" 使用授信额度,贷款银行不能为空"*/; } } return null; }