这的确是个难题,用SDK也不方便,要编程。
'0<9+A# 把SDK(版本PPM 8.3)文档中相关的例子翻译如下:
dLbSvK<(I V/]o': Creating a WBS node
KsQn %mxS 建立一个WBS节点
Jd28/X5& nLY(%):(P 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.
W!V-m 一个WBS节点能被直接插入PROWBS表中。但是,一个WBS节点必须和一个项目相关联。以下例子假设数据库中有一个被称为‘System Integration'的项目,其Proj_id=3564。本(以下)命令建立一个WBS节点关联到'System Integration'项目。注意插入WBS节点需要适当的scope_level(译注:这个scope_leve可设为1、2、7,数字大表示SDK能访问项目更详尽的数据)。
`+!F#. vg8Yc INSERT INTO PROJWBS (wbs_id, proj_id) VALUES (0, 3564)
n;LjKE l#TE$d^ym The SYSTABLES can be queried to determine the wbs_id for the new entry as follows:
+-NH
4vUg 需要按以下确定SYSTABLES新条目的wbs_id:
`r]C%Y
4? 8'M:u
I SELECT last_assigned_key FROM SYSTABLES WHERE api_table_name = ‘PROJWBS’
#ri;{d^6 H'}6Mw%r
a (assume return value of 34832)
-8yN6
0| (假定返回值是34832)
2
ZyO 6&o?
#l;| UPDATE PROJWBS set wbs_name = ‘IT Systems’ WHERE wbs_id = 34832
G7%f|
Y <"yL(s^u" This statement modifies the wbs_name to ‘IT Systems’. Multiple WBS nodes can be associated with the same project.
$r)NL 以上语句修改wbs_name为‘IT System'。多个WBS节点能被关联到同一项目。
[ 此帖被gzjboy在2015-05-20 10:04重新编辑 ]