这的确是个难题,用SDK也不方便,要编程。
4Xk
;Qd 把SDK(版本PPM 8.3)文档中相关的例子翻译如下:
4Olv8nOe< [k7N+W8 Creating a WBS node
UH&1c8y} 建立一个WBS节点
X3L[y\ JX$NEq( 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.
^O Xr: P 一个WBS节点能被直接插入PROWBS表中。但是,一个WBS节点必须和一个项目相关联。以下例子假设数据库中有一个被称为‘System Integration'的项目,其Proj_id=3564。本(以下)命令建立一个WBS节点关联到'System Integration'项目。注意插入WBS节点需要适当的scope_level(译注:这个scope_leve可设为1、2、7,数字大表示SDK能访问项目更详尽的数据)。
2n;;Tso
" V& j.>Y INSERT INTO PROJWBS (wbs_id, proj_id) VALUES (0, 3564)
+IO1ipc4cE XvkI+c The SYSTABLES can be queried to determine the wbs_id for the new entry as follows:
Pzm!`F^r} 需要按以下确定SYSTABLES新条目的wbs_id:
9H, &nET :UDn^(# SELECT last_assigned_key FROM SYSTABLES WHERE api_table_name = ‘PROJWBS’
fByh";<`P yK%GsCJd: (assume return value of 34832)
Ux)p%- (假定返回值是34832)
M$]O=2h+2 e9Ul A
UPDATE PROJWBS set wbs_name = ‘IT Systems’ WHERE wbs_id = 34832
oLqbR? Y7:Y{7E7 This statement modifies the wbs_name to ‘IT Systems’. Multiple WBS nodes can be associated with the same project.
]Ic?:lKN 以上语句修改wbs_name为‘IT System'。多个WBS节点能被关联到同一项目。
[ 此帖被gzjboy在2015-05-20 10:04重新编辑 ]