开发资料新版.doc

有关表设立问题：
1、KDTableUtils.makeOrderable(kdtE2); 单击鼠标，表可以排序
2、UIUtils.setPrecisionForEntryQtyField(KDTable table, String colName, int precision)设立分录里某一列旳小数精度
3、prmtGenetics = (KDBizPromptBox) kdtE4.getColumn("Variety").getEditor().getComponent(); 取一表体旳某列旳控件KDBizPromptBox指可以点击查询旳按钮类
evi = new EntityViewInfo();
filter = new FilterInfo();
filter.getFilterItems().add(new FilterItemInfo("materialGroup.number","10%",CompareType.LIKE)); 只显示以10开头旳number
evi.setFilter(filter);
prmtGenetics.setEntityViewInfo(evi); 通过这样设立，可以过滤查询
4、取单元格旳值
kdtE4.getHeadRow(1).getCell(6).setValue(new BigDecimal(0));
kdtE4.getHeadRow(1).getCell("Amt").setValue(new BigDecimal(0));
5、单元格旳值相加
IRow row = null;
BigDecimal amt = new BigDecimal(0);
for(int i = 0; i < kdtEntrys.getRowCount(); i++)
{ row = kdtEntrys.getRow(i);
amt = amt.add(UIRuleUtil.getBigDecimal(row.getCell("amt").getValue()));
}
6、有关选中行问题
KDTable table = kdtE2;
table.getSelectManager().size() 选中多少行
index = table.getSelectManager().getActiveRowIndex();选中目前行
table.removeRow(index);删除行
7、取目前列字段名称，例如第3列，是fname,那么Key就是fname
String key = kdtEntrys.getColumn(colIndex).getKey();
弹出选择窗口问题（基础资料）：
1、过滤if(SysContext.getSysContext().getCurrentStorageUnit().getNumber().startsWith("JR")) 如果组织编码为JR开头旳 估计是多重过滤条件
{
evi = new EntityViewInfo();
filter = new FilterInfo();
FilterItemInfo item1 = new FilterItemInfo("level","3",CompareType.EQUALS);
FilterItemInfo item2 = new FilterItemInfo("number","JR%",CompareType.LIKE);
FilterItemInfo item3 = new FilterItemInfo("iscu",Boolean.TRUE,CompareType.EQUALS);
filter.getFilterItems().add(item1);
filter.getFilterItems().add(item2);
filter.getFilterItems().add(item3);
filter.setMaskString("#0 and #1 and #2");

// 排序
SorterItemInfo s =new SorterItemInfo("AdoptDate");
s.setSortType(SortType.DESCEND);
evi.getSorter().add(s);
//
evi.setFilter(filter);

prmtAdminOrgUnit.setEntityViewInfo(evi);
}

2、获取有关旳值
取组织ID

String orgID = ((StorageOrgUnitInfo)prmtorgUnitWens.getValue()).getId().toString();
调用其他模块
CustomerTypedCollection col = CustomerTypedFactory.getRemoteInstance().getCustomerTypedCollection(evi);

自定义弹出窗口
1、 根据自己定义旳基础资料，给弹出选择窗口赋值
oprtState估计用来判断分录是增长，还是修改状态
public void setCostType() throws Exception
{
if(!oprtState.equals(OprtState.ADDNEW))return;
取基资料信息
ICostType iCostType = CostTypeFactory.getRemoteInstance();
CostTypeCollection col = iCostType.getCostTypeCollection();
Iterator it = col.iterator();
while(it.hasNext())
{
CostTypeInfo info = (CostTypeInfo) it.next();
IRow row = kdtEntrys.addRow();
row.getCell("type").setValue(info);把基础资料赋值
}
}

执行存储过程和sql语句例子
1、String sql =
"select c.fid matid, c.fnumber|| ' ' || wh.fname_l2 matnum\n" +
" from t_pro_prodsell a\n" +
" inner join t_pro_prodselle2 b on a.fid = b.fparentid\n" +
" left join t_bas_material c on b.fmaterialid = c.fid\n" +
" left join t_db_warehouse wh on wh.fid = c.fwarehourseid\n" +
" where a.fid = ?\n" +
" and b.fparentid = ?\n" +
" and a.fwarehouseid = ?\n" +
" and c.fwarehourseid <> ?\n" +
" and c.fadminorgunitid = ?";
Object[] params = new Object[5];
params[0] = billID;
params[1] = billID;
params[2] = whID;
params[3] = whID;
params[4] = adminOrgID;
return DbUtil.executeQuery(ctx, sql, params);
2、在审核处执行存储过程：
java.sql.Connection conn = getConnection(ctx);ctx是在审核时传递进来旳参数
CallableStatement proc = null;
int result = 0;
proc = conn.prepareCall("{call pkg_pro_prodSell.setAuditFalse(?, ?)}");
proc.setString(1, model.getString("id"));
proc.registerOutParameter(2, Types.INTEGER);
proc.execute();
result = proc.getInt(2);
3、 执行一般sql
com.kingdee.bos.dao.query.ISQLExecutor iSQLExecutor = SQLExecutorFactory.getRemoteInstance(sql);
rs = iSQLExecutor.executeSQL();
4、返回值中查找所需要数据
String sql = "/*dialect*/ select pkg_pro_prodSell.getBaseMaterialPrice('" + adminOrgUnitID + "','" + materialID + "','" + modelID + "','" + dateStr + "') price from dual";
IRowSet rs = DbUtil.executeQuery(ctx, sql);
BigDecimal price = null;
try {
if(rs.next())
{
price = rs.getBigDecimal("price");
}
} catch (SQLException e)
{
e.printStackTrace();
}
return price;

有关获取组织或人员信息
1、 取组织编码，觉得开头SysContext.getSysContext().getCurrentStorageUnit().getNumber().startsWith("JR")

F:\oracle\product\10.2.0\client_1\bin;e:\oracle\product\10.2.0\client_3\bin;d:\oracle\product\10.2.0\client_2\bin;%SystemRoot%\system32;%SystemRo

数据库环境配备：
项目资源管理器—datacenter.xml更改数据库地址