|
发表于 2016-4-8 20:00:10
|
显示全部楼层
ProcessControl flowControl=(ProcessControl)ContextHelper.getActionContext().getParameter("control");
for (ProcessControlItem to : flowControl.getFlowTos()){
for (OrgUnit ect : to.getExecutors()){
String name=ect.getFName();
int one = name.lastIndexOf("/");
String name123=name.substring((one+1),name.length());
String ksql = "SELECT o.sMobilePhone FROM SA_OPPerson o WHERE o.sName like '"+name123+"'" ;
Table table = KSQL.select(ksql, null, "/system/data", null);
Iterator<Row> rows = table.iterator();
Row row = rows.next();
String phone123=row.getString("sMobilePhone");
System.out.println("phone:"+phone123); |
|