|
![](template/yudi_2016_bbs/ybimg/common/ico_lz.png)
楼主 |
发表于 2019-5-27 14:04:16
|
显示全部楼层
这是我流程文件里的代码:
public static void leaderSignAfterAdvance() {
try{
String photo=null;
String key=ProcessUtils.getProcessData1();
String ID=ContextHelper.getOperator().getID();
String sql="select a.* from SA_OPPerson a where SID='"+ID+"'";
Table table=SQL.select(sql, null,"/V3ERP/SCM/data");
Iterator<Row> it=table.iterator();
if(it.hasNext()){
Row row=it.next();
photo=row.getValue("sPhoto").toString();
System.out.print(photo);
}
String updatesql="update SCM_PRMst set Sign='"+photo+"' where fID='"+key+"'";
SQL.executeUpdate(updatesql,null,"/V3ERP/SCM/data");
}catch(Exception e){
throw new RuntimeException(e.getMessage());
}
} |
|