金蝶EAS,KDTable数据填充,需重新解析表格tblMain.checkParsed()

来源:互联网 发布:windows swift 编译器 编辑:程序博客网 时间:2024/05/24 15:39

业务场景:GUI界面含有KDTable表格时,代码实现数据填充。以下代码示例中,表格名称为tblMain。

填充数据之前需要重新解析表格tblMain.checkParsed()。

/** * 填充科目余额数据到KDTable表格 */@SuppressWarnings("unchecked")private void fillData(List dataList) {tblMain.checkParsed(); //重新解析tblMain.removeRows(); //删除所有行for(int i = 0; i < dataList.size(); i++){if(i > 999){break; //只填充1000行数据}List rowList = (List) dataList.get(i); //行数据队列String orgUnitNumber = (String) rowList.get(0); //组织编码orgUnitNumber = orgUnitNumberMapping.get(orgUnitNumber);String orgUnitName = orgNumberNameMapping.get(orgUnitNumber); //组织名称String year = (String) rowList.get(1); //期间年String month = (String) rowList.get(2); //期间月String accountNumber = (String) rowList.get(3); //科目编码String key = orgUnitNumber + "-" + accountNumber;accountNumber = accountNumberMapping.get(key);String accountName = acctNumberNameMapping.get(key); //科目名称String yearBegin = (String) rowList.get(5); //年初余额String accumulDebit = (String) rowList.get(6); //本年累计借方String accumulCredit = (String) rowList.get(7); //本年累计贷方String periodEnd = (String) rowList.get(8); //期末余额IRow row = tblMain.addRow();row.getCell("orgUnitNumber").setValue(orgUnitNumber); //组织编码row.getCell("orgUnitName").setValue(orgUnitName); //组织名称row.getCell("year").setValue(year); //期间年row.getCell("month").setValue(month); //期间月row.getCell("accountNumber").setValue(accountNumber); //科目编码row.getCell("accountName").setValue(accountName); //科目名称row.getCell("yearBegin").setValue(yearBegin); //年初余额row.getCell("accumulDebit").setValue(accumulDebit); //本年累计借方row.getCell("accumulCredit").setValue(accumulCredit); //本年累计贷方row.getCell("periodEnd").setValue(periodEnd); //期末余额}}


阅读全文
0 0
原创粉丝点击