|
发表于 2016-6-16 08:02:58
|
显示全部楼层
- public static void auditAfterAdvance() {
- //审核流转之后,将用户审核留言信息填写到库表中
- try{
- String key=com.justep.system.process.ProcessUtils.getProcessData1();
- String taskID=ProcessUtils.getProcessContext().getTask().getId();
- String ksql="select sContent as sContent from SA_Task SA_Task where SA_Task='"+taskID+"'";
- com.justep.system.data.Table table= KSQL.select(ksql, null, "/system/data", null);
- Iterator<Row> rows=table.iterator();
- Row row;
- row=rows.next();
- String str=row.getString("sContent");
- String kSql="update JT_Signature JT_Signature set JT_Signature.f1stName='"+ContextHelper.getOperator().getName()+"', JT_Signature.f1stID='"+ContextHelper.getOperator().getID()+"', "+
- "JT_Signature.f1stTime= :currentDateTime() ";
- if(str!=null ){
- kSql=kSql+",JT_Signature.f1stAdvice='"+str+"' ";}
- kSql=kSql+"where JT_Signature='"+key+"'";
- KSQL.executeUpdate(kSql, null, "/JTNS/JTOA/data", null);
- }catch(Exception e){
- throw new RuntimeException (e.getMessage());
- }}
复制代码 可以参考下面的代码
|
|