BEX5下新建任务到待办任务

最新推荐文章于 2024-06-13 23:05:37 发布

weixin_33805992

最新推荐文章于 2024-06-13 23:05:37 发布

阅读量116

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/WongHugh/p/5212661.html

本文介绍了一种通过SQL查询执行者信息的方法，并展示了如何使用查询结果创建任务，包括设置任务属性及保存任务。

 1     List<OrgUnit> list = new ArrayList<OrgUnit>();
 2         
 3         // 1、查询出执行者
 4         String sql = "select t.fCreatePsnID from PM_KM_Executors t where t.fMasterID = '" +rowID+ "'";
 5         Table table = KSQL.select(sql, null, "/PM/knowledge/data", null);
 6         Iterator<Row> it = table.iterator();
 7         
 8         while(it.hasNext()){
 9             // 2、添加执行者
10             Row row = it.next();
11             list.add(OrgUtils.findOnePersonMemberByID(null,row.getString("fCreatePsnID")).get(0));
12         }
13         Map<String, Object> varMap = new HashMap<String, Object>();
14         varMap.put("sKindID", com.justep.system.process.TaskKind.NOTICE );
15         Task task = TaskHelper.createTask(title, "/PM/knowledge/process/publishKnowledge/publishKnowledgeProcess", "businessActivity2", 
16                     "/PM/knowledge/process/publishKnowledge/htmlActivity.w", "/PM/knowledge/process/publishKnowledge/businessActivity2.w", 
17                     rowID, list,varMap);
18         task.setExecuteMode2(TaskExecuteMode2.FINISH_WHEN_OPEN);
19         task.save();