这的确是个难题,用SDK也不方便,要编程。
<$`
^ 把SDK(版本PPM 8.3)文档中相关的例子翻译如下:
};>~P%u32 m{rsj
dnA Creating a WBS node
WG5)-;>q| 建立一个WBS节点
ooN?x31 90a!_8o A WBS node can be inserted directly in the PROJWBS table. However, a WBS node must be associated with a project. The example below assumes that a project called ‘System Integration’ with proj_id = 3564 exists in the database. This command creates A WBS node that is associated with ‘System Integration’. Note that the appropriate scope_level is required to insert a WBS node.
!<0 `c 一个WBS节点能被直接插入PROWBS表中。但是,一个WBS节点必须和一个项目相关联。以下例子假设数据库中有一个被称为‘System Integration'的项目,其Proj_id=3564。本(以下)命令建立一个WBS节点关联到'System Integration'项目。注意插入WBS节点需要适当的scope_level(译注:这个scope_leve可设为1、2、7,数字大表示SDK能访问项目更详尽的数据)。
-&LF`V&3w ~<3J9\z1 INSERT INTO PROJWBS (wbs_id, proj_id) VALUES (0, 3564)
Mg\8m-L^ xGw|
@d
The SYSTABLES can be queried to determine the wbs_id for the new entry as follows:
'RIx}vPf 需要按以下确定SYSTABLES新条目的wbs_id:
*7yrm&@nG G;^,T/q47 SELECT last_assigned_key FROM SYSTABLES WHERE api_table_name = ‘PROJWBS’
34aSRFsk* mFuHZ)iQG (assume return value of 34832)
8qv>C)~~` (假定返回值是34832)
rCdTn+O2
tr%VYc|} UPDATE PROJWBS set wbs_name = ‘IT Systems’ WHERE wbs_id = 34832
cg}lF9;d <e$%m(] This statement modifies the wbs_name to ‘IT Systems’. Multiple WBS nodes can be associated with the same project.
RnUud\T/ 以上语句修改wbs_name为‘IT System'。多个WBS节点能被关联到同一项目。
[ 此帖被gzjboy在2015-05-20 10:04重新编辑 ]