用友NC客户化开发帮助文档 - 图文(6)

} }

bodyvos[i+1].setAttributeValue(key, hash.get(key));

}

// HashMap存储查询结果集例二

sessionManager = PersistenceManager.getInstance(); session = sessionManager.getJdbcSession();

ArrayList rslist = (ArrayList) session.executeQuery(sql.toString(), new HashMap hashmap = new HashMap(); if(rslist!=null && rslist.size()>0){ }

for(int i=0;i

int flag = billBVO[i].getOperateflag(); if(flag == 0){

SrcBillSettle_BVO settleBVO = new SrcBillSettle_BVO(); String settlekey = billBVO[i].getSettlecode();

Object[] ncsettleinfo = (Object[])hashmap.get(settlekey); for(int i=0;i

Object[] rows = (Object[])rslist.get(i); hashmap.put(rows[0], rows);

ArrayListProcessor());

settleBVO.setPk_ncsettletype(TJYCPubVO.getString_TrimZeroLenAsNull(ncsettleinf

settleBVO.setSettlemoney(billBVO[i].getSalesum());// 销售金额

o[1]));// 外键:NC结算方式PK

settleBVO.setSettleaccount(TJYCPubVO.getString_TrimZeroLenAsNull(ncsettleinfo[

2]));// 结算科目

settleBVO.setVdef1(TJYCPubVO.getString_TrimZeroLenAsNull(ncsettleinfo[3]));//

}

SrcBillSettle_BVO[] settleBVOs = new SrcBillSettle_BVO[list.size()]; list.toArray(settleBVOs);

list.add(settleBVO); }

NC结算名称

? HashTable

// ArrayList去掉重复数据

public static void main(String[] args){ ArrayList list = new ArrayList();

list.add(\Iterator it1 = list.iterator();

HashTable hash = new HashTable(); while(it1.hasNext()){ Object obj = it1.next(); hash.put(obj, obj);

} //HashTable存储时自动去除了重复的数据

Iterator it2 = hash.keySet().iterator(); list = new ArrayList(); while(it2.hasNext()){ list.add(it2.next()); }

System.out.println(list.size()); }

? Help

//修改帮助页面的标题

E:\%ufsoft\\nchome\\resources\\lang\\simpchn\\funcode 下配置文件

? I

? IDBCacheBS

//后台查询，V55以后必须使用:利用IDBCacheBS进行一般的SQL查询 IDBCacheBS dbcf =

(IDBCacheBS) NCLocator.getInstance().lookup(IDBCacheBS.class.getName()); ArrayList result = (ArrayList) dbcf.runSQLQuery(sql, new ArrayListProcessor()); if (result.size() > 0){ for (int i = 0; i < result.size(); i++){ Object[] values = (Object[]) result.get(i); OPERATOR = (String) values[1]; }}

? Iif

公式iif函数

iif(condition,thenvalue,elsevalue)判断条件condition是否满足,如果满足返回第一个值thenvalue,如果不满足返回第二个值elsevalue,比如iif(var1==\函数支持嵌套比如:iif(var1==\例：

num->iif(num >0, num,\如果num>0，则num==num,否num=””

? Int?String

○1int i = Integer.parseInt([String]);

○2int i = Integer.valueOf(my_str).intValue();

? IVOPersistence

IVOPersistence service =

IVOPersistence)NCLocator.getInstance().lookup(IVOPersistence.class.getName());//VO持久层接口类

? J

? JFileChooser

JFileChooser chooser = new JFileChooser(); //弹出文件选择框

int result = chooser. showOpenDialog(this); if(result == JFileChooser.CANCEL_OPTION)//取消按钮 //设置上次读取文件的路径

public static File _currentDirectoryPath = null; public File getCurrentDirectoryPath() { }

public void setCurrentDirectoryPath(File currentDirectoryPath) { }

private File addFile() {

File file = null;

JFileChooser chooser = new JFileChooser(); chooser.setMultiSelectionEnabled(false);

chooser.setCurrentDirectory(this.getCurrentDirectoryPath()); ExcelFileFilter filter = new ExcelFileFilter(); chooser.setFileFilter(filter);

int returnVal = chooser.showOpenDialog(ui); if (returnVal == JFileChooser.CANCEL_OPTION) { } else {

ui.showHintMessage(\没有选择文件\);

return _currentDirectoryPath;

_currentDirectoryPath = currentDirectoryPath;

_currentDirectoryPath = chooser.getSelectedFile();// 保存文件读取路径

file = chooser.getSelectedFile();

}

}

if( !file.getPath().toLowerCase().endsWith(\) ) { }

ui.showErrorMessage(\请选择正确的数据文件\); return null;

return file;

//设置是否可多选文件

chooser.setMultiSelectionEnabled(false); //得到选择的文件(可以多选getSelectedFiles()) chooser. getSelectedFile(); //设置读取时显示指定类型的文件

class ExcelFileFilter extends javax.swing.filechooser.FileFilter

}

public String getDescription() { }

return \数据文件(.xls)\;

{//内部类.在JfileChooser打开目录时调用

public boolean accept(File file) { }

if (file.isDirectory() ||

return true; return false;

file.getPath().toLowerCase().endsWith(\) )

else

? K ? L

? Leaf

UIPane.setNotLeafSelectedEnabled(false);//设置参照中非叶子节点不可选择

? Listener

BillTabbedPaneTabChangeListener//多表体页签切换监听

? List

Collections.reverse(list); //倒序输出list

? ListPane

getBillListPanel().getHeadTable().getSelectionModel().setSelectionInterval(0, 0); //默认选中列表第一行

protected void initSelfData(){

}

this.getBillListPanel().setMultiSelect(true);//设置列表界面可多选

? Lock

ORACLE 数据库查锁

SELECT T2.USERNAME, T2.SID, T2.SERIAL#, T2.LOGON_TIME FROM V$LOCKED_OBJECT T1, V$SESSION T2 WHERE T1.SESSION_ID = T2.SID ORDER BY T2.LOGON_TIME;

ORACLE 数据库解锁

ALTER SYSTEM KILL SESSION ' sid,serial#';

? Logger

//DMO打印信息方法

Logger.error(\语法错误:\

? M

? Menu

//去掉表体右键菜单

getMainBillCardPanel().getBillCardPanel().setBodyMenuSh …… 此处隐藏：2712字，全部文档内容请下载后查看。喜欢就下载吧 ……