|
楼主 |
发表于 2018-5-21 17:45:05
|
显示全部楼层
- public static void modifyPlanProcessAfterStart() {
- List<Map<String, String>> list = (List<Map<String, String>>)ContextHelper.getActionContext().getActionResult();
- for(Map<String, String> map: list){
- // System.out.println(map.get("task")+"输入生成的任务ID");
- }
- String SID=list.get(0).get("task");
- //取SID
- String Sql="select SA_TASK.* from SA_TASK where SA_TASK.sID='"+SID+"'";
- com.justep.system.data.Table table = SQL.select(Sql, null, "/projectPlanning/planTable/data", null);
- Iterator<Row> rows = table.iterator();
- Row row;
- row = rows.next();
- //用SID取SDATA1过滤出项目信息
- String Sql1="select T_JH_DZB.* from T_JH_DZB where T_JH_DZB.fID='"+row.getString("SDATA1")+"'";
- System.out.println(Sql1);
- com.justep.system.data.Table table1 = SQL.select(Sql1, null, "/projectPlanning/planTable/data", null);
- Iterator<Row> rows1 = table1.iterator();
- Row row1;
- row1 = rows1.next();
- //用SID和过滤出的项目信息更新SA_TASK表
- String update="update SA_TASK set sESField01='"+row1.getString("FLSXMMC")+"',sESField02='"+row1.getString("FLSXMBH")+"',sESField03='"+row1.getString("FLSYSLX")+"',sESField04='"+row1.getString("FLSXMXZ")+"',sESField05='"+row1.getString("FLSXMCDDW")+"',sESField06='"+row1.getString("FLSXMFZR")+"' where SA_TASK.sID='" + SID+"'";
- SQL.select(update, null, "/projectPlanning/planTable/data", null);
- }
复制代码
报错
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP050006; 提示: 参数"name,type"不允许为空
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.util.Utils.check(Unknown Source)
at com.justep.system.data.impl.TableImpl.addColumns(Unknown Source)
at com.justep.system.data.impl.TableImpl.createTable(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.createTable(Unknown Source)
at com.justep.system.data.TableUtils.createTable(Unknown Source) |
|