泛微 E8 配置自定义触发流程

已于 2023-09-05 16:08:51 修改
阅读量1.6k 收藏 1
点赞数
分类专栏： # 泛微Ecology 文章标签： 数据库 泛微OA
于 2023-08-18 13:36:31 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u013948083/article/details/132357573
版权

在新公司接了个配置泛微流程触发的活。因为泛微的官方文档并没有详细的操作指引，在测试环境配置之后、要触发的流程可以手工提交，但是触发一直不成功。经过修复，实现了触发推送。简单记录下业务场景和其他处理信息，以供参考。

应用版本

目前使用了泛微 E8 （8.100.0531）的版本。2018年上线的老系统了。

业务场景

目前使用的泛微 OA 启用了“会议”应用。我们需要定时抓取会议状态为“退回”和“取消”的会议、并将每一条记录自动转化为一个流程发送出去。我们选取了会议应用的 Meeting 表（会议管理表详细信息），并选择 “meetingstatus” 字段作为会议状态的来源。通过文档得知：当会议状态为“退回”，字段取值 3 ；当会议状态为“取消”，字段取值 4 。

 设置的自定义表单 / 流程如下图所示, 目前手工提交 / 流转均正常操作：

处理步骤

首先配置了回写部分，但是不成功。根据 2012 - 2016 年的资料，文档是这么记录的。

1:该流程自动触发时，将根据外部主表条件搜索外部主表，有多少条记录即触发多少条流程；
流程主字段的值来源于外部主表，而每条流程的各明细值将分别根据明细表条件搜索明细表
得到的结果进行赋值；主表中必须包含主键(默认为id)
2:条件以“where”开头，如：“where fieldname1=1 and fieldname2='value2'”；
回写设置以“set”开头，如：“set flag=1,isok=true”，FtriggerFlag和requestid字段
自动更新，不能在此设置；
3:流程触发时如果需要回写外部主表，需要设置是否回写、流程ID字段、标志字段、标志字段
需要回写的值(字符型)，回写数据时，默认标志字段=1：表示已触发，
流程ID字段=0：表示流程创建人对应的外部字段值为空，
流程ID字段=-1：表示外部字段保存的人员信息在oa中不存在，流程ID
4:外部明细表数据如需与主表数据关联，可将外部明细表条件设置为
“where '明细表.字段'='主表.字段'”。

非常 ... 语焉不详。我怀疑当年这个屌茅甚至喝大了。:)

配置数次无果之后，泛微的工程师提醒我找下日志。根据操作日期，我分别在服务器下载了泛微应用目录下的   ecology/log/integration/integration.log 、 ecology/log/ecology 、Resin/log/stderr.log 、Resin/log/stdout.log 这几个文件。

打开 integration.log 文件。发现触发的过程报错、 提示 CREATER 在外部表不存在。

2023-08-18 00:00:14,812 INFO  [Thread:AutoWorlflowThread] weaver.general.AutoWorlflowThread.saveTrigLog() - saveTrigLog 记录日志 sql : update outerdatawfdetail set requestid=-1 where mainid=11 and workflowid=466 and outermaintable = 'Meeting' and keyfieldvalue='141'
2023-08-18 00:00:14,827 INFO  [Thread:AutoWorlflowThread] weaver.general.AutoWorlflowThread.doActiveOutDataWF() - 检查是否已触发 : select 1 from outerdatawfdetail where workflowid=466 and mainid=11 and keyfieldvalue='142' and outermaintable = 'Meeting' and requestid>0
2023-08-18 00:00:14,827 INFO  [Thread:AutoWorlflowThread] weaver.general.AutoWorlflowThread.doActiveOutDataWF() - ===================SQL:select * from outerdatawfsetdetail where (wffieldid=-1 or wffieldid=-2) and mainid=11 order by wffieldid
2023-08-18 00:00:14,827 ERROR [Thread:AutoWorlflowThread] weaver.general.AutoWorlflowThread.doActiveOutDataWF() - THE CREATER IN THE OUTER TABLE IS NOT EXIST!

于是找到应用的源代码。

package weaver.general;

import java.io.Writer;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.HashMap;
import java.util.Hashtable;
import java.util.Iterator;
import java.util.Map;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import oracle.sql.CLOB;
import weaver.conn.ConnStatement;
import weaver.conn.RecordSet;
import weaver.conn.RecordSetDataSource;
import weaver.hrm.resource.ResourceComInfo;
import weaver.integration.logging.Logger;
import weaver.integration.logging.LoggerFactory;
import weaver.system.SysCreateWF;
import weaver.system.SysUpdateWF;
import weaver.system.ThreadWork;
import weaver.workflow.automatic.automaticconnect;
import weaver.workflow.dmlaction.DBTypeUtil;
import weaver.workflow.request.RequestManager;
import weaver.workflow.workflow.WorkflowComInfo;
import weaver.workflow.workflow.WorkflowVersion;

public class AutoWorlflowThread extends BaseBean implements ThreadWork {
  private Logger newlog = LoggerFactory.getLogger(AutoWorlflowThread.class);
  
  public void doThreadWork() {
    Thread.currentThread().setUncaughtExceptionHandler(new AutoWorkFlowThreadExceptionHandler());
    doActiveOutDataWF();
  }
  
  public void doActiveOutDataWF() {
    automaticconnect automaticconnect = new automaticconnect();
    Connection connection = null;
    String str = "";
    try {
      WorkflowComInfo workflowComInfo = new WorkflowComInfo();
      ResourceComInfo resourceComInfo = new ResourceComInfo();
      SysCreateWF sysCreateWF = new SysCreateWF();
      RecordSet recordSet1 = new RecordSet();
      RecordSet recordSet2 = new RecordSet();
      ArrayList<String> arrayList1 = new ArrayList();
      ArrayList<String> arrayList2 = new ArrayList();
      ArrayList<String> arrayList3 = new ArrayList();
      ArrayList<String> arrayList4 = new ArrayList();
      ArrayList<String> arrayList5 = new ArrayList();
      ArrayList<String> arrayList6 = new ArrayList();
      ArrayList<String> arrayList7 = new ArrayList();
      ArrayList<String> arrayList8 = new ArrayList();
      ArrayList<String> arrayList9 = new ArrayList();
      ArrayList<String> arrayList10 = new ArrayList();
      ArrayList<String> arrayList11 = new ArrayList();
      ArrayList<String> arrayList12 = new ArrayList();
      ArrayList<String> arrayList13 = new ArrayList();
      ArrayList<String> arrayList14 = new ArrayList();
      ArrayList<String> arrayList15 = new ArrayList();
      ArrayList<String> arrayList16 = new ArrayList();
      ArrayList<String> arrayList17 = new ArrayList();
      WorkflowVersion workflowVersion = new WorkflowVersion();
      recordSet1.executeSql("select * from outerdatawfset");
      while (recordSet1.next()) {
        String str1 = Util.null2String(recordSet1.getString("id"));
        String str2 = Util.null2String(recordSet1.getString("workflowid"));
        String str3 = Util.null2String(recordSet1.getString("datasourceid"));
        String str4 = Util.null2String(recordSet1.getString("outermaintable"));
        String str5 = Util.null2String(recordSet1.getString("keyfield"));
        String str6 = Util.null2String(recordSet1.getString("datarecordtype"));
        String str7 = Util.null2String(recordSet1.getString("requestid"));
        String str8 = Util.null2String(recordSet1.getString("FTriggerFlag"));
        String str9 = Util.null2String(recordSet1.getString("FTriggerFlagValue"));
        String str10 = Util.null2String(recordSet1.getString("outermainwhere"));
        String str11 = Util.null2String(recordSet1.getString("successback"));
        String str12 = Util.null2String(recordSet1.getString("failback"));
        String str13 = Util.null2String(recordSet1.getString("outerdetailtables"));
        String str14 = Util.null2String(recordSet1.getString("outerdetailwheres"));
        String str15 = Util.null2String(recordSet1.getString("isnextnode"));
        String str16 = Util.null2String(recordSet1.getString("isupdatewfdata"));
        String str17 = Util.null2String(recordSet1.getString("isupdatewfdataField"));
        arrayList1.add(str1);
        arrayList2.add(str2);
        arrayList3.add(str3);
        arrayList4.add(str4);
        arrayList15.add(str15);
        arrayList16.add(str16);
        arrayList17.add(str17);
        arrayList5.add(str5);
        arrayList6.add(str6);
        arrayList7.add(str7);
        arrayList8.add(str8);
        arrayList9.add(str9);
        arrayList10.add(str10);
        arrayList11.add(str11);
        arrayList12.add(str12);
        arrayList13.add(str13);
        arrayList14.add(str14);
      } 
      RecordSet recordSet3 = new RecordSet();
      for (byte b = 0; b < arrayList1.size(); b++) {
        try {
          String str1 = arrayList1.get(b);
          recordSet3.executeSql("select mainid from outerdatawfsetdetail where mainid=" + str1);
          if (!recordSet3.next()) {
            this.newlog.error("+ str1 + ");
          } else {
            String str2 = arrayList2.get(b);
            String str3 = WorkflowVersion.getActiveVersionWFID(str2);
            String str4 = arrayList3.get(b);
            if (!str4.equals("")) {
              connection = automaticconnect.getConnection("datasource." + str4);
              if (connection != null && !connection.isClosed()) {
                str = automaticconnect.getDBType();
                Statement statement1 = connection.createStatement();
                Statement statement2 = connection.createStatement();
                ResultSet resultSet = null;
                String str5 = arrayList4.get(b);
                String str6 = arrayList5.get(b);
                String str7 = arrayList6.get(b);
                String str8 = arrayList7.get(b);
                String str9 = arrayList8.get(b);
                String str10 = arrayList9.get(b);
                String str11 = arrayList15.get(b);
                String str12 = arrayList16.get(b);
                String str13 = arrayList17.get(b);
                if ("".equals(str10))
                  str10 = "1"; 
                String str14 = arrayList10.get(b);
                String str15 = arrayList11.get(b);
                String str16 = arrayList12.get(b);
                String str17 = arrayList13.get(b);
                String str18 = arrayList14.get(b);
                RecordSetDataSource recordSetDataSource = new RecordSetDataSource();
                Map map = new HashMap<Object, Object>();
                if (!str4.equals(""))
                  map = recordSetDataSource.getAllColumnWithTypes(str4, str5); 
                String str19 = "";
                if (str.toLowerCase().indexOf("oracle") > -1) {
                  str19 = "select 1 from user_tables a where a.TABLE_NAME = upper('" + str5 + "') union ALL select 1 from user_views b where  b.VIEW_NAME = upper('" + str5 + "')";
                } else if (str.toLowerCase().indexOf("sqlserver") > -1 || str.toLowerCase().indexOf("sybase") > -1) {
                  str19 = "select 1 from sysobjects where name = '" + str5 + "' ";
                } else if (str.toLowerCase().indexOf("informix") > -1) {
                  str19 = "select 1 from systables where lower(tabname) = lower('" + str5 + "') ";
                } else if (str.toLowerCase().indexOf("mysql") > -1) {
                  str19 = "select 1 from information_schema.Tables where LOWER(Table_Name)=LOWER('" + str5 + "') ";
                } else if (str.toLowerCase().indexOf("db2") > -1) {
                  str19 = "select 1 from SYSIBM.SYSTABLES where lower(name)= lower('" + str5 + "') ";
                } else {
                  str19 = "select 1 from " + str5;
                } 
                resultSet = statement1.executeQuery(str19);
                if (!resultSet.next()) {
                  this.newlog.error("TABLE " + str5 + " IS NOT EXIST!");
                } else {
                  ArrayList<String> arrayList = new ArrayList();
                  Hashtable<Object, Object> hashtable1 = new Hashtable<Object, Object>();
                  Hashtable<Object, Object> hashtable2 = new Hashtable<Object, Object>();
                  Hashtable<Object, Object> hashtable3 = new Hashtable<Object, Object>();
                  Hashtable<Object, Object> hashtable4 = new Hashtable<Object, Object>();
                  Hashtable<Object, Object> hashtable5 = new Hashtable<Object, Object>();
                  Hashtable<Object, Object> hashtable6 = new Hashtable<Object, Object>();
                  Hashtable<Object, Object> hashtable7 = new Hashtable<Object, Object>();
                  String str20 = "";
                  int i = Util.getIntValue(Util.null2String(workflowComInfo.getIsBill(str2)), -1);
                  String str21 = Util.null2String(workflowComInfo.getFormId(str2));
                  if (i == 0) {
                    str20 = "select workflow_formfield.fieldid as id,fieldname as name,workflow_fieldlable.fieldlable as label,workflow_formdict.fieldhtmltype as htmltype,workflow_formdict.type as type,workflow_formdict.fielddbtype from workflow_formfield,workflow_formdict,workflow_fieldlable where workflow_fieldlable.formid = workflow_formfield.formid and workflow_fieldlable.isdefault = 1 and workflow_fieldlable.fieldid =workflow_formfield.fieldid and workflow_formdict.id = workflow_formfield.fieldid and workflow_formfield.formid=" + str21;
                  } else if (i == 1) {
                    str20 = "select id as id,fieldname as name,fieldlabel as label,fieldhtmltype as htmltype,type as type,fielddbtype from workflow_billfield where viewtype=0 and billid = " + str21 + " order by dsporder ";
                  } 
                  recordSet1.executeSql(str20);
                  while (recordSet1.next()) {
                    String str23 = recordSet1.getString("id");
                    String str24 = recordSet1.getString("name");
                    String str25 = recordSet1.getString("htmltype");
                    String str26 = recordSet1.getString("type");
                    String str27 = recordSet1.getString("fielddbtype");
                    String str28 = "";
                    String str29 = "";
                    String str30 = "";
                    recordSet2.executeSql("select outerfieldname,changetype,customsql from outerdatawfsetdetail where wffieldid=" + str23 + " and mainid=" + str1);
                    if (recordSet2.next()) {
                      str28 = recordSet2.getString("outerfieldname");
                      str29 = recordSet2.getString("changetype");
                      str30 = recordSet2.getString("customsql");
                    } 
                    arrayList.add(str23);
                    hashtable1.put(str23, str24);
                    hashtable2.put(str23, str25);
                    hashtable3.put(str23, str26);
                    hashtable4.put(str23, str27);
                    hashtable5.put(str23, str28);
                    hashtable6.put(str23, str29);
                    hashtable7.put(str23, str30);
                  } 
                  if (str14.equals(""))
                    str14 = " where 1=1  "; 
                  if ("2".equals(str7) || "".equals(str7)) {
                    str14 = str14 + " and ((1=1 ";
                    if (str.toLowerCase().indexOf("oracle") > -1) {
                      if (!"".equals(str8))
                        str14 = str14 + " and nvl(" + str8 + ",'0')='0' "; 
                      if (!"".equals(str9) && !"".equals(str10))
                        str14 = str14 + " and nvl(" + str9 + ",'0')!='" + str10 + "' "; 
                    } else if (str.toLowerCase().indexOf("sqlserver") > -1 || str.toLowerCase().indexOf("sybase") > -1) {
                      if (!"".equals(str8))
                        str14 = str14 + " and isnull(" + str8 + ",'0')='0' "; 
                      if (!"".equals(str9) && !"".equals(str10))
                        str14 = str14 + " and isnull(" + str9 + ",'0')!='" + str10 + "' "; 
                    } else if (str.toLowerCase().indexOf("informix") > -1) {
                      if (!"".equals(str8))
                        str14 = str14 + " and " + str8 + " is null "; 
                      if (!"".equals(str9) && !"".equals(str10))
                        str14 = str14 + " and " + str9 + "!='" + str10 + "' "; 
                    } else if (str.toLowerCase().indexOf("mysql") > -1) {
                      if (!"".equals(str8))
                        str14 = str14 + " and IFNULL(" + str8 + ",'0')='0' "; 
                      if (!"".equals(str9) && !"".equals(str10))
                        str14 = str14 + " and IFNULL(" + str9 + ",'0')!='" + str10 + "' "; 
                    } else if (str.toLowerCase().indexOf("db2") > -1) {
                      if (!"".equals(str8))
                        str14 = str14 + " and coalesce(" + str8 + ",'0')='0' "; 
                      if (!"".equals(str9) && !"".equals(str10))
                        str14 = str14 + " and coalesce(" + str9 + ",'0')!='" + str10 + "' "; 
                    } else {
                      if (!"".equals(str8))
                        str14 = str14 + " and " + str8 + " is null "; 
                      if (!"".equals(str9) && !"".equals(str10))
                        str14 = str14 + " and " + str9 + "!='" + str10 + "' "; 
                    } 
                    str14 = str14 + " ) ";
                    if (str12.equals("2") && !str13.equals(""))
                      str14 = str14 + " or " + str13 + "='1' "; 
                    str14 = str14 + " ) ";
                  } 
                  this.newlog.info("select * from " + str5 + " " + str14);
                  ResultSet resultSet1 = statement1.executeQuery("select * from " + str5 + " " + str14);
                  String str22 = "";
                  while (resultSet1.next()) {
                    try {
                      if ("2".equals(str7) || "".equals(str7)) {
                        if (str6.equals(""))
                          str6 = "id"; 
                        if (str9.equals(""))
                          str9 = "FTriggerFlag"; 
                        if (str8.equals(""))
                          str8 = "requestid"; 
                      } 
                      String str23 = resultSet1.getString(str6).replace("'", "''");
                      boolean bool1 = false;
                      if (str12.equals("2") && !str13.equals("")) {
                        String str27 = Util.null2String(resultSet1.getString(str13));
                        if (str27.equals("1"))
                          bool1 = true; 
                      } 
                      if (bool1)
                        this.newlog.info("." + str13 + "=" + Util.null2String(resultSet1.getString(str13))); 
                      boolean bool2 = false;
                      str22 = "select 1 from outerdatawfdetail where workflowid=" + str2 + " and mainid=" + str1 + " and keyfieldvalue='" + str23 + "' and outermaintable = '" + str5 + "' and requestid>0";
                      this.newlog.info(": " + str22);
                      recordSet1.executeSql(str22);
                      if (recordSet1.next()) {
                        this.newlog.info("keyid : " + str23 + " );
                        bool2 = true;
                      } 
                      if (!bool1 && bool2)
                        continue; 
                      String str24 = "";
                      String str25 = "";
                      ArrayList<Integer> arrayList18 = new ArrayList();
                      boolean bool3 = false;
                      recordSet1.executeSql("select * from outerdatawfsetdetail where (wffieldid=-1 or wffieldid=-2) and mainid=" + str1 + " order by wffieldid");
                      this.newlog.info("===================SQL:select * from outerdatawfsetdetail where (wffieldid=-1 or wffieldid=-2) and mainid=" + str1 + " order by wffieldid");
                      while (recordSet1.next()) {
                        String str27 = Util.null2String(recordSet1.getString("wffieldid"));
                        if (str27.equals("-2")) {
                          String str28 = Util.null2String(recordSet1.getString("outerfieldname"));
                          String str29 = Util.null2String(recordSet1.getString("changetype"));
                          String str30 = Util.null2String(recordSet1.getString("customsql"));
                          if (str29.equals("5")) {
                            str25 = Util.null2String(getCreater(str28, "5"));
                            if (str25.equals("")) {
                              this.newlog.error("THE CREATER IN THE OUTER TABLE IS NOT EXIST!");
                              if ("2".equals(str7) || "".equals(str7))
                                saveOutTrigLog(statement2, str5, str16, str6, str9, str8, str23, str10, "-1"); 
                              if (str12.equals("2") && !str13.equals(""))
                                saveUpdateWfFlag(statement2, str5, str6, str23, str12, str13); 
                              saveTrigLog(str3, "-1", str1, str23, str5);
                              bool3 = true;
                              break;
                            } 
                            continue;
                          } 
                          if (str29.equals("6")) {
                            if (str28.indexOf(".") > -1)
                              str28 = str28.substring(str28.indexOf(".") + 1); 
                            String str32 = Util.null2String(resultSet1.getString(str28));
                            if (!"".equals(str30)) {
                              str30 = str30 + " and status<4  and (loginid !='' Or  loginid is not  null) ";
                              str25 = getTranSqlValue(str30, str32);
                            } else {
                              str25 = str32;
                            } 
                            if (str25.equals("")) {
                              this.newlog.error("THE CREATER IN THE OUTER TABLE IS NOT EXIST!");
                              if ("2".equals(str7) || "".equals(str7))
                                saveOutTrigLog(statement2, str5, str16, str6, str9, str8, str23, str10, "-1"); 
                              if (str12.equals("2") && !str13.equals(""))
                                saveUpdateWfFlag(statement2, str5, str6, str23, str12, str13); 
                              saveTrigLog(str3, "-1", str1, str23, str5);
                              bool3 = true;
                              break;
                            } 
                            continue;
                          } 
                          if (str28.equals("")) {
                            this.newlog.error(");
                            str25 = "1";
                            continue;
                          } 
                          str28 = str28.substring(str28.indexOf(".") + 1);
                          String str31 = Util.null2String(resultSet1.getString(str28));
                          if (str31.equals("")) {
                            this.newlog.error("VALUE OF THE FIELD IN THE OUTER TABLE IS NULL!");
                            if ("2".equals(str7) || "".equals(str7))
                              saveOutTrigLog(statement2, str5, str16, str6, str9, str8, str23, str10, "0"); 
                            if (str12.equals("2") && !str13.equals(""))
                              saveUpdateWfFlag(statement2, str5, str6, str23, str12, str13); 
                            saveTrigLog(str3, "0", str1, str23, str5);
                            bool3 = true;
                            break;
                          } 
                          str25 = Util.null2String(getCreater(str31, str29));
                          if (str25.equals("")) {
                            this.newlog.error("THE CREATER IN THE OUTER TABLE IS NOT EXIST!");
                            if ("2".equals(str7) || "".equals(str7))
                              saveOutTrigLog(statement2, str5, str16, str6, str9, str8, str23, str10, "-1"); 
                            if (str12.equals("2") && !str13.equals(""))
                              saveUpdateWfFlag(statement2, str5, str6, str23, str12, str13); 
                            saveTrigLog(str3, "-1", str1, str23, str5);
                            bool3 = true;
                            break;
                          } 
                          continue;
                        } 
                        if (str27.equals("-1")) {
                          String str28 = Util.null2String(recordSet1.getString("outerfieldname"));
                          String str29 = Util.null2String(workflowComInfo.getWorkflowname(str3));
                          String str30 = Util.toScreen(resourceComInfo.getResourcename(str25), 7);
                          String str31 = "";
                          Calendar calendar = Calendar.getInstance();
                          str31 = Util.add0(calendar.get(1), 4) + "-" + Util.add0(calendar.get(2) + 1, 2) + "-" + Util.add0(calendar.get(5), 2);
                          DateUtil dateUtil = new DateUtil();
                          if (str28.equals("")) {
                            str24 = Util.null2String(dateUtil.getWFTitleNew("" + str3, "" + str25, "" + str30, "1"));
                            if (str24.equals(""))
                              str24 = str29 + "-" + str30 + "-" + str31; 
                            continue;
                          } 
                          str28 = str28.substring(str28.indexOf(".") + 1);
                          String str32 = Util.null2String(resultSet1.getString(str28));
                          if (!str32.equals("")) {
                            str24 = str32;
                            continue;
                          } 
                          str24 = Util.null2String(dateUtil.getWFTitleNew("" + str3, "" + str25, "" + str30, "1"));
                          if (str24.equals(""))
                            str24 = str29 + "-" + str30 + "-" + str31; 
                        } 
                      } 
                      if (bool3)
                        continue; 
                      for (byte b1 = 0; b1 < arrayList.size(); b1++) {
                        String str27 = Util.null2String(arrayList.get(b1));
                        String str28 = Util.null2String((String)hashtable1.get(str27));
                        if (!str28.equals("")) {
                          String str29 = Util.null2String((String)hashtable2.get(str27));
                          String str30 = Util.null2String((String)hashtable3.get(str27));
                          String str31 = Util.null2String((String)hashtable4.get(str27));
                          String str32 = Util.null2String((String)hashtable5.get(str27));
                          String str33 = Util.null2String((String)hashtable6.get(str27));
                          String str34 = Util.null2String((String)hashtable7.get(str27));
                          String str35 = "";
                          if (!str32.equals("")) {
                            str32 = str32.substring(str32.indexOf(".") + 1);
                            String str36 = (String)map.get(str32.toLowerCase());
                            if (str36.contains("("))
                              str36 = str36.substring(0, str36.indexOf("(")); 
                            if (str36.equals("number") || str36.equals("NUMBER") || str36.equals("float") || str36.equals("Real") || str36.equals("real")) {
                              str35 = Util.null2String(resultSet1.getString(str32));
                              if (str35.startsWith("."))
                                str35 = "0" + str35; 
                              if (str35.startsWith("-."))
                                str35 = str35.replaceFirst("-.", "-0."); 
                            } else {
                              str35 = Util.null2String(resultSet1.getString(str32));
                            } 
                            if (!"6".equals(str33)) {
                              if (str29.equals("3"))
                                if (str30.equals("1")) {
                                  str35 = getCreater(str35, str33);
                                } else if (str30.equals("4")) {
                                  str35 = getDept(str35, str33);
                                } else if (str30.equals("164")) {
                                  str35 = getSubCom(str35, str33);
                                }  
                            } else if (!"".equals(str34)) {
                              str35 = getTranSqlValue(str34, str35);
                            } 
                          } 
                          if (str35.equals("")) {
                            if (str29.equals("4")) {
                              arrayList18.add(Integer.valueOf(0));
                            } else if (!str29.equals("6") && !str29.equals("2") && (!str29.equals("1") || (!str30.equals("1") && !str30.equals("5"))) && (!str29.equals("3") || (!str30.equals("2") && !str30.equals("19") && !str30.equals("161") && !str30.equals("162")))) {
                              arrayList18.add(null);
                            } else {
                              arrayList18.add("");
                            } 
                          } else {
                            if (str31.startsWith("text") || str31.startsWith("char") || str31.startsWith("varchar") || str31.indexOf(".") > -1 || str31.startsWith("clob")) {
                              if (str31.startsWith("char") || str31.startsWith("varchar")) {
                                int k = Util.getIntValue(str31.substring(str31.indexOf("(") + 1, str31.indexOf(")")), 0);
                                if (Util.length2(str35) > k)
                                  do {
                                    str35 = str35.substring(0, str35.length() - 1);
                                  } while (Util.length2(str35) > k); 
                              } 
                              str35 = str35.replace("'", "''");
                            } else if (str31.equals("int") || str31.equals("integer")) {
                              str35 = Util.getIntValue(str35, 0) + "";
                            } else if (str31.indexOf("decimal") == 0 || str31.indexOf("number") == 0) {
                              str35 = str35.replace(",", "");
                              str35 = Util.getDoubleValue(str35, 0.0D) + "";
                            } else if (str31.indexOf("text") == 0) {
                              str35 = str35.replaceAll("'", "''");
                            } 
                            arrayList18.add(str35);
                          } 
                        } 
                      } 
                      if (bool1 && bool2) {
                        String str27 = "";
                        str22 = "select requestid from outerdatawfdetail where workflowid=" + str2 + " and mainid=" + str1 + " and keyfieldvalue='" + str23 + "' and outermaintable = '" + str5 + "' and requestid>0";
                        this.newlog.info(": " + str22);
                        RecordSet recordSet = new RecordSet();
                        recordSet.executeSql(str22);
                        if (recordSet.next())
                          str27 = Util.null2String(recordSet.getString("requestid")); 
                        if (str27.equals("")) {
                          this.newlog.info(");
                          continue;
                        } 
                        SysUpdateWF sysUpdateWF = new SysUpdateWF();
                        if (sysUpdateWF.updateWorkflowInfo(Util.getIntValue(str3, 0), str24, Util.getIntValue(str25, 1), arrayList18, Util.getIntValue(str27, 0))) {
                          String str28 = str15;
                          if ("2".equals(str7) || "".equals(str7))
                            saveOutTrigLog(statement2, str5, str28, str6, str9, str8, str23, str10, "" + str27); 
                          if (str12.equals("2") && !str13.equals(""))
                            saveUpdateWfFlag(statement2, str5, str6, str23, str12, str13); 
                          saveTrigLog(str3, "" + str27, str1, str23, str5);
                          saveRequestLog(str1, str23, str3, Util.getIntValue(str27, 0));
                          UpdateIntoDetailTable(statement2, str5, str, str1, str2, Util.getIntValue(str27, 0), str6, str23, str17, str18, str8, str7);
                          continue;
                        } 
                        if ("2".equals(str7) || "".equals(str7))
                          saveOutTrigLog(statement2, str5, str16, str6, str9, str8, str23, str10, "0"); 
                        if (str12.equals("2") && !str13.equals(""))
                          saveUpdateWfFlag(statement2, str5, str6, str23, str12, str13); 
                        saveRequestLog(str1, str23, str3, Util.getIntValue(str27, 0));
                        continue;
                      } 
                      this.newlog.info("=======+ str24);
                      sysCreateWF = new SysCreateWF();
                      RequestManager requestManager = sysCreateWF.setWorkflowInfo(Util.getIntValue(str3, 0), str24, 0, Util.getIntValue(str25, 1), arrayList18, false, str11);
                      int j = requestManager.getRequestid();
                      String str26 = str15;
                      if (j > 0) {
                        if ("2".equals(str7) || "".equals(str7))
                          saveOutTrigLog(statement2, str5, str26, str6, str9, str8, str23, str10, "" + j); 
                        if (str12.equals("2") && !str13.equals(""))
                          saveUpdateWfFlag(statement2, str5, str6, str23, str12, str13); 
                        saveTrigLog(str3, "" + j, str1, str23, str5);
                        saveRequestLog(str1, str23, str3, j);
                        this.newlog.info("****insertIntoDetailTable = " + str + "^^^^^^^^^^^^^:requestid = " + j);
                        insertIntoDetailTable(str4, statement2, str5, str, str1, str2, j, str6, str23, str17, str18, str8, str7);
                        this.newlog.info("+ str11 + ",workflowid=" + str2);
                        if (str11.equals("1"))
                          requestManager.flowNextNode(); 
                        continue;
                      } 
                      if ("2".equals(str7) || "".equals(str7))
                        saveOutTrigLog(statement2, str5, str16, str6, str9, str8, str23, str10, "0"); 
                      if (str12.equals("2") && !str13.equals(""))
                        saveUpdateWfFlag(statement2, str5, str6, str23, str12, str13); 
                      saveTrigLog(str3, "-2", str1, str23, str5);
                      saveRequestLog(str1, str23, str3, j);
                    } catch (Exception exception) {
                      this.newlog.error(", exception);
                    } 
                  } 
                  resultSet1.close();
                  resultSet.close();
                  statement1.close();
                  statement2.close();
                  automaticconnect.closeConnection(connection);
                } 
              } 
            } 
          } 
        } catch (Exception exception) {
          this.newlog.error(", exception);
        } 
      } 
    } catch (Exception exception) {
      this.newlog.error(", exception);
    } 
  }
  
  public String getTranSqlValue(String paramString1, String paramString2) {
    paramString2 = paramString2.replace("'", "''");
    paramString1 = DBTypeUtil.replaceString(paramString1, "{?currentvalue}", paramString2);
    RecordSet recordSet = new RecordSet();
    recordSet.executeSql(paramString1);
    if (recordSet.next())
      return recordSet.getString(1); 
    return "";
  }
  
  public void insertIntoDetailTable(String paramString1, Statement paramStatement, String paramString2, String paramString3, String paramString4, String paramString5, int paramInt, String paramString6, String paramString7, String paramString8, String paramString9, String paramString10, String paramString11) throws Exception {
    ResultSet resultSet = null;
    HashMap<Object, Object> hashMap = new HashMap<Object, Object>();
    WorkflowComInfo workflowComInfo = new WorkflowComInfo();
    String str1 = Util.null2String(workflowComInfo.getIsBill(paramString5));
    String str2 = Util.null2String(workflowComInfo.getFormId(paramString5));
    ArrayList<String> arrayList1 = new ArrayList();
    ArrayList<String> arrayList2 = new ArrayList();
    String str3 = "mainid";
    String str4 = "";
    ArrayList<String> arrayList3 = Util.TokenizerString(paramString8, ",");
    String[] arrayOfString = paramString9.split("\\$@\\|@\\$");
    ArrayList<String> arrayList4 = new ArrayList();
    for (byte b1 = 0; b1 < arrayOfString.length; b1++)
      arrayList4.add(arrayOfString[b1]); 
    RecordSet recordSet = new RecordSet();
    boolean bool = recordSet.getDBType().equals("oracle");
    RecordSetDataSource recordSetDataSource = new RecordSetDataSource();
    boolean bool1 = false;
    if (!str2.equals(""))
      if (str1.equals("0")) {
        recordSet.executeSql("select distinct groupId from Workflow_formfield where formid=" + str2 + " and isdetail='1' order by groupid");
        while (recordSet.next()) {
          arrayList1.add("workflow_formdetail");
          arrayList2.add(recordSet.getString(1));
        } 
      } else if (str1.equals("1")) {
        recordSet.executeSql("select tablename from Workflow_billdetailtable where billid=" + str2 + " order by orderid");
        while (recordSet.next()) {
          String str = Util.null2String(recordSet.getString(1));
          if (!str.equals(""))
            arrayList1.add(recordSet.getString(1)); 
        } 
        recordSet.executeSql("select tablename,detailtablename,detailkeyfield from workflow_bill where id=" + str2);
        if (recordSet.next()) {
          str3 = Util.null2String(recordSet.getString("detailkeyfield"));
          if (arrayList1.size() == 0) {
            String str5 = Util.null2String(recordSet.getString("detailtablename"));
            if (!str5.equals(""))
              arrayList1.add(str5); 
          } 
          String str = recordSet.getString("tablename");
          recordSet.executeSql("select id from " + str + " where requestid=" + paramInt);
          if (recordSet.next())
            str4 = recordSet.getString("id"); 
        } 
      }  
    if (arrayList1.size() != arrayList3.size()) {
      writeLog(");
      return;
    } 
    for (byte b2 = 0; b2 < arrayList1.size(); b2++) {
      String str5 = arrayList1.get(b2);
      String str6 = arrayList3.get(b2);
      String str7 = "";
      if (paramString3.toLowerCase().indexOf("oracle") > -1) {
        str7 = "select 1 from user_tables a where a.TABLE_NAME = upper('" + str6 + "') union ALL select 1 from user_views b where  b.VIEW_NAME = upper('" + str6 + "')";
      } else if (paramString3.toLowerCase().indexOf("sqlserver") > -1 || paramString3.toLowerCase().indexOf("sybase") > -1) {
        str7 = "select 1 from sysobjects where name = '" + str6 + "' ";
      } else if (paramString3.toLowerCase().indexOf("informix") > -1) {
        str7 = "select 1 from systables where lower(tabname) = lower('" + str6 + "') ";
      } else if (paramString3.toLowerCase().indexOf("mysql") > -1) {
        str7 = "select 1 from information_schema.Tables where LOWER(Table_Name)=LOWER('" + str6 + "') ";
      } else if (paramString3.toLowerCase().indexOf("db2") > -1) {
        str7 = "select 1 from SYSIBM.SYSTABLES where lower(name)= lower('" + str6 + "') ";
      } else {
        str7 = "select 1 from " + str6;
      } 
      resultSet = paramStatement.executeQuery(str7);
      if (!resultSet.next()) {
        this.newlog.error("TABLE " + str6 + " IS NOT EXIST!");
      } else {
        Map map = new HashMap<Object, Object>();
        if (!paramString1.equals(""))
          map = recordSetDataSource.getAllColumnWithTypes(paramString1, str6); 
        ArrayList<String> arrayList = new ArrayList();
        Hashtable<Object, Object> hashtable1 = new Hashtable<Object, Object>();
        Hashtable<Object, Object> hashtable2 = new Hashtable<Object, Object>();
        Hashtable<Object, Object> hashtable3 = new Hashtable<Object, Object>();
        Hashtable<Object, Object> hashtable4 = new Hashtable<Object, Object>();
        Hashtable<Object, Object> hashtable5 = new Hashtable<Object, Object>();
        Hashtable<Object, Object> hashtable6 = new Hashtable<Object, Object>();
        Hashtable<Object, Object> hashtable7 = new Hashtable<Object, Object>();
        String str = Util.null2String(arrayList4.get(b2));
        if (str.equals("-"))
          str = ""; 
        recordSet.executeSql("select * from outerdatawfsetdetail where outerfieldname like '" + str6 + ".%' and mainid=" + paramString4);
        while (recordSet.next()) {
          String str8 = recordSet.getString("wffieldid");
          String str9 = recordSet.getString("wffieldname");
          String str10 = recordSet.getString("wffieldhtmltype");
          String str11 = recordSet.getString("wffieldtype");
          String str12 = recordSet.getString("wffielddbtype");
          String str13 = recordSet.getString("outerfieldname");
          String str14 = recordSet.getString("changetype");
          String str15 = recordSet.getString("customsql");
          arrayList.add(str8);
          hashtable1.put(str8, str9);
          hashtable2.put(str8, str10);
          hashtable3.put(str8, str11);
          hashtable4.put(str8, str12);
          hashtable5.put(str8, str13);
          hashtable6.put(str8, str14);
          hashtable7.put(str8, str15);
        } 
        Pattern pattern = Pattern.compile("where");
        Matcher matcher = pattern.matcher(str);
        str = matcher.replaceFirst(" and ");
        if (!paramString11.equals("1") && !paramString10.equals("")) {
          str7 = "select * from " + str6 + " ," + paramString2 + " " + " where 1=1" + " and " + paramString2 + "." + paramString10 + " = " + paramInt + str;
        } else {
          str7 = "select * from " + str6 + " ," + paramString2 + " " + " where 1=1" + " and " + paramString2 + "." + paramString6 + " = '" + paramString7 + "'" + str;
        } 
        this.newlog.info("querysql:" + str7);
        resultSet = paramStatement.executeQuery(str7);
        while (resultSet.next()) {
          String str8 = "";
          String str9 = "";
          if (str1.equals("0")) {
            str8 = "insert into " + str5 + "(requestid,groupId";
            str9 = " values(" + paramInt + "," + (String)arrayList2.get(b2);
          } else if (str1.equals("1")) {
            str8 = "insert into " + str5 + "(" + str3;
            str9 = " values(" + str4;
          } 
          for (byte b = 0; b < arrayList.size(); b++) {
            String str10 = Util.null2String(arrayList.get(b));
            String str11 = Util.null2String((String)hashtable1.get(str10));
            if (!str11.equals("")) {
              String str12 = Util.null2String((String)hashtable2.get(str10));
              String str13 = Util.null2String((String)hashtable3.get(str10));
              String str14 = Util.null2String((String)hashtable4.get(str10));
              String str15 = Util.null2String((String)hashtable5.get(str10));
              String str16 = Util.null2String((String)hashtable6.get(str10));
              String str17 = Util.null2String((String)hashtable7.get(str10));
              String str18 = "";
              if (!str15.equals("")) {
                str15 = str15.substring(str15.indexOf(".") + 1);
                String str19 = (String)map.get(str15.toLowerCase());
                if (str19.contains("("))
                  str19 = str19.substring(0, str19.indexOf("(")); 
                if (str19.equals("number") || str19.equals("NUMBER") || str19.equals("float") || str19.equals("real") || str19.equals("Real")) {
                  str18 = Util.null2String(resultSet.getString(str15));
                  if (str18.startsWith("."))
                    str18 = "0" + str18; 
                  if (str18.startsWith("-."))
                    str18 = str18.replaceFirst("-.", "-0."); 
                } else {
                  str18 = Util.null2String(resultSet.getString(str15));
                } 
                if (!"6".equals(str16)) {
                  if (str12.equals("3"))
                    if (str13.equals("1")) {
                      str18 = getCreater(str18, str16);
                    } else if (str13.equals("4")) {
                      str18 = getDept(str18, str16);
                    } else if (str13.equals("164")) {
                      str18 = getSubCom(str18, str16);
                    }  
                } else if (!"".equals(str17)) {
                  str18 = getTranSqlValue(str17, str18);
                } else {
                  str18 = str18;
                } 
              } 
              if (str18.equals("")) {
                if (!str12.equals("2") && (!str12.equals("1") || (!str13.equals("1") && !str13.equals("5"))) && (!str12.equals("3") || (!str13.equals("2") && !str13.equals("19") && !str13.equals("161") && !str13.equals("162"))))
                  str18 = "NULL"; 
                if (str12.equals("5")) {
                  str18 = "-1";
                } else if (str12.equals("4")) {
                  str18 = "0";
                } 
              } else if (str14.indexOf("varchar") == 0 || str14.indexOf("char") == 0) {
                int i = Util.getIntValue(str14.substring(str14.indexOf("(") + 1, str14.indexOf(")")), 0);
                if (Util.length2(str18) > i)
                  do {
                    str18 = str18.substring(0, str18.length() - 1);
                  } while (Util.length2(str18) > i); 
                str18 = str18.replace("'", "''");
              } else if (str14.equals("int") || str14.equals("integer")) {
                str18 = Util.getIntValue(str18, -1) + "";
              } else if (str14.indexOf("decimal") == 0 || str14.indexOf("number") == 0) {
                str18 = str18.replace(",", "");
                str18 = Util.getDoubleValue(str18, -1.0D) + "";
              } else if (str12.equals("3") && str13.equals("17") && bool) {
                hashMap.put(str11, str18);
                str18 = " empty_clob() ";
              } 
              str8 = str8 + "," + str11;
              if (str14.startsWith("text") || str14.startsWith("char") || str14.startsWith("varchar") || str14.indexOf(".") > -1) {
                str9 = str9 + ",'" + str18 + "'";
              } else if (str12.equals("3") && (str13.equals("256") || str13.equals("257"))) {
                str9 = str9 + ",'" + str18 + "'";
              } else if (str14.startsWith("clob")) {
                str9 = str9 + "," + str18;
              } else {
                str9 = str9 + "," + str18;
              } 
            } 
          } 
          str8 = str8 + ") ";
          str9 = str9 + ") ";
          this.newlog.info("detail sql:" + str8 + str9);
          recordSet.executeSql(str8 + str9);
          if (bool)
            try {
              String str10 = "";
              if (str1.equals("0")) {
                str10 = "select max(id) dtid from " + str5 + " where requestid =" + paramInt + " and groupId = " + (String)arrayList2.get(b2);
              } else if (str1.equals("1")) {
                str10 = "select max(id) dtid from " + str5 + " where " + str3 + " =" + str4;
              } 
              recordSet.executeSql(str10);
              if (recordSet.next()) {
                String str11 = Util.null2String(recordSet.getString("dtid"));
                if (!"".equals(str11)) {
                  String str12 = "";
                  str12 = " select ";
                  byte b3 = 0;
                  String str13 = " ";
                  Iterator<Map.Entry> iterator = hashMap.entrySet().iterator();
                  while (iterator.hasNext()) {
                    b3++;
                    Map.Entry entry = iterator.next();
                    String str14 = entry.getKey().toString();
                    String str15 = "";
                    if (entry.getValue() != null)
                      if (String.valueOf(entry.getValue()).equals(" ")) {
                        str15 = "";
                      } else {
                        str15 = String.valueOf(entry.getValue());
                      }  
                    if (b3 > 1) {
                      str12 = str12 + str13 + " , " + str14;
                      continue;
                    } 
                    str12 = str12 + str13 + " " + str14;
                  } 
                  str12 = str12 + " from " + str5;
                  if (str1.equals("0")) {
                    str12 = str12 + " where requestid = " + paramInt + " and groupId = " + (String)arrayList2.get(b2) + " and id = " + str11 + " for update";
                  } else if (str1.equals("1")) {
                    str12 = str12 + " where " + str3 + " = " + str4 + "and id = " + str11 + " for update";
                  } 
                  if (b3 > 0) {
                    ConnStatement connStatement = null;
                    try {
                      connStatement = new ConnStatement();
                      connStatement.setStatementSql(str12, false);
                      connStatement.executeQuery();
                      if (connStatement.next()) {
                        iterator = hashMap.entrySet().iterator();
                        b3 = 0;
                        while (iterator.hasNext()) {
                          b3++;
                          Map.Entry entry = iterator.next();
                          String str14 = entry.getKey().toString();
                          String str15 = "";
                          if (entry.getValue() != null)
                            if (String.valueOf(entry.getValue()).equals(" ")) {
                              str15 = "";
                            } else {
                              str15 = String.valueOf(entry.getValue());
                            }  
                          CLOB cLOB = connStatement.getClob(b3);
                          char[] arrayOfChar = str15.toCharArray();
                          Writer writer = cLOB.getCharacterOutputStream();
                          writer.write(arrayOfChar);
                          writer.flush();
                          writer.close();
                        } 
                      } 
                    } catch (Exception exception) {
                      this.newlog.error(", exception);
                    } finally {
                      if (connStatement != null)
                        connStatement.close(); 
                    } 
                  } 
                } 
              } 
              hashMap.clear();
            } catch (Exception exception) {
              this.newlog.error(", exception);
            }  
        } 
      } 
    } 
  }
  
  public void UpdateIntoDetailTable(Statement paramStatement, String paramString1, String paramString2, String paramString3, String paramString4, int paramInt, String paramString5, String paramString6, String paramString7, String paramString8, String paramString9, String paramString10) throws Exception {
    ResultSet resultSet = null;
    HashMap<Object, Object> hashMap = new HashMap<Object, Object>();
    WorkflowComInfo workflowComInfo = new WorkflowComInfo();
    String str1 = Util.null2String(workflowComInfo.getIsBill(paramString4));
    String str2 = Util.null2String(workflowComInfo.getFormId(paramString4));
    ArrayList<String> arrayList1 = new ArrayList();
    ArrayList<String> arrayList2 = new ArrayList();
    String str3 = "mainid";
    String str4 = "";
    ArrayList<String> arrayList3 = Util.TokenizerString(paramString7, ",");
    String[] arrayOfString = paramString8.split("\\$@\\|@\\$");
    ArrayList<String> arrayList4 = new ArrayList();
    for (byte b1 = 0; b1 < arrayOfString.length; b1++)
      arrayList4.add(arrayOfString[b1]); 
    RecordSet recordSet = new RecordSet();
    boolean bool = recordSet.getDBType().equals("oracle");
    boolean bool1 = false;
    if (!str2.equals(""))
      if (str1.equals("0")) {
        recordSet.executeSql("select distinct groupId from Workflow_formfield where formid=" + str2 + " and isdetail='1' order by groupid");
        while (recordSet.next()) {
          arrayList1.add("workflow_formdetail");
          arrayList2.add(recordSet.getString(1));
        } 
      } else if (str1.equals("1")) {
        recordSet.executeSql("select tablename from Workflow_billdetailtable where billid=" + str2 + " order by orderid");
        while (recordSet.next()) {
          String str = Util.null2String(recordSet.getString(1));
          if (!str.equals(""))
            arrayList1.add(recordSet.getString(1)); 
        } 
        recordSet.executeSql("select tablename,detailtablename,detailkeyfield from workflow_bill where id=" + str2);
        if (recordSet.next()) {
          str3 = Util.null2String(recordSet.getString("detailkeyfield"));
          if (arrayList1.size() == 0) {
            String str5 = Util.null2String(recordSet.getString("detailtablename"));
            if (!str5.equals(""))
              arrayList1.add(str5); 
          } 
          String str = recordSet.getString("tablename");
          recordSet.executeSql("select id from " + str + " where requestid=" + paramInt);
          if (recordSet.next())
            str4 = recordSet.getString("id"); 
        } 
      }  
    if (arrayList1.size() != arrayList3.size()) {
      writeLog(");
      return;
    } 
    for (byte b2 = 0; b2 < arrayList1.size(); b2++) {
      String str5 = arrayList1.get(b2);
      String str6 = arrayList3.get(b2);
      String str7 = "";
      if (paramString2.toLowerCase().indexOf("oracle") > -1) {
        str7 = "select 1 from user_tables a where a.TABLE_NAME = upper('" + str6 + "') union ALL select 1 from user_views b where  b.VIEW_NAME = upper('" + str6 + "')";
      } else if (paramString2.toLowerCase().indexOf("sqlserver") > -1 || paramString2.toLowerCase().indexOf("sybase") > -1) {
        str7 = "select 1 from sysobjects where name = '" + str6 + "' ";
      } else if (paramString2.toLowerCase().indexOf("informix") > -1) {
        str7 = "select 1 from systables where lower(tabname) = lower('" + str6 + "') ";
      } else if (paramString2.toLowerCase().indexOf("mysql") > -1) {
        str7 = "select 1 from information_schema.Tables where LOWER(Table_Name)=LOWER('" + str6 + "') ";
      } else if (paramString2.toLowerCase().indexOf("db2") > -1) {
        str7 = "select 1 from SYSIBM.SYSTABLES where lower(name)= lower('" + str6 + "') ";
      } else {
        str7 = "select 1 from " + str6;
      } 
      resultSet = paramStatement.executeQuery(str7);
      if (!resultSet.next()) {
        this.newlog.error("TABLE " + str6 + " IS NOT EXIST!");
      } else {
        String str8 = "";
        RecordSet recordSet1 = new RecordSet();
        if (str1.equals("0")) {
          str8 = "delete " + str5 + " where requestid='" + paramInt + "' and groupId='" + (String)arrayList2.get(b2) + "' ";
        } else if (str1.equals("1")) {
          str8 = "delete " + str5 + " where " + str3 + "='" + str4 + "'  ";
        } 
        recordSet1.executeSql(str8);
        ArrayList<String> arrayList = new ArrayList();
        Hashtable<Object, Object> hashtable1 = new Hashtable<Object, Object>();
        Hashtable<Object, Object> hashtable2 = new Hashtable<Object, Object>();
        Hashtable<Object, Object> hashtable3 = new Hashtable<Object, Object>();
        Hashtable<Object, Object> hashtable4 = new Hashtable<Object, Object>();
        Hashtable<Object, Object> hashtable5 = new Hashtable<Object, Object>();
        Hashtable<Object, Object> hashtable6 = new Hashtable<Object, Object>();
        Hashtable<Object, Object> hashtable7 = new Hashtable<Object, Object>();
        String str9 = Util.null2String(arrayList4.get(b2));
        if (str9.equals("-"))
          str9 = ""; 
        recordSet.executeSql("select * from outerdatawfsetdetail where outerfieldname like '" + str6 + ".%' and mainid=" + paramString3);
        while (recordSet.next()) {
          String str10 = recordSet.getString("wffieldid");
          String str11 = recordSet.getString("wffieldname");
          String str12 = recordSet.getString("wffieldhtmltype");
          String str13 = recordSet.getString("wffieldtype");
          String str14 = recordSet.getString("wffielddbtype");
          String str15 = recordSet.getString("outerfieldname");
          String str16 = recordSet.getString("changetype");
          String str17 = recordSet.getString("customsql");
          arrayList.add(str10);
          hashtable1.put(str10, str11);
          hashtable2.put(str10, str12);
          hashtable3.put(str10, str13);
          hashtable4.put(str10, str14);
          hashtable5.put(str10, str15);
          hashtable6.put(str10, str16);
          hashtable7.put(str10, str17);
        } 
        Pattern pattern = Pattern.compile("where");
        Matcher matcher = pattern.matcher(str9);
        str9 = matcher.replaceFirst(" and ");
        if (!paramString10.equals("1") && !paramString9.equals("")) {
          str7 = "select * from " + str6 + " ," + paramString1 + " " + " where 1=1" + " and " + paramString1 + "." + paramString9 + " = " + paramInt + str9;
        } else {
          str7 = "select * from " + str6 + " ," + paramString1 + " " + " where 1=1" + " and " + paramString1 + "." + paramString5 + " = '" + paramString6 + "'" + str9;
        } 
        this.newlog.info("querysql:" + str7);
        resultSet = paramStatement.executeQuery(str7);
        while (resultSet.next()) {
          String str10 = "";
          String str11 = "";
          if (str1.equals("0")) {
            str10 = "insert into " + str5 + "(requestid,groupId";
            str11 = " values(" + paramInt + "," + (String)arrayList2.get(b2);
          } else if (str1.equals("1")) {
            str10 = "insert into " + str5 + "(" + str3;
            str11 = " values(" + str4;
          } 
          for (byte b = 0; b < arrayList.size(); b++) {
            String str12 = Util.null2String(arrayList.get(b));
            String str13 = Util.null2String((String)hashtable1.get(str12));
            if (!str13.equals("")) {
              String str14 = Util.null2String((String)hashtable2.get(str12));
              String str15 = Util.null2String((String)hashtable3.get(str12));
              String str16 = Util.null2String((String)hashtable4.get(str12));
              String str17 = Util.null2String((String)hashtable5.get(str12));
              String str18 = Util.null2String((String)hashtable6.get(str12));
              String str19 = Util.null2String((String)hashtable7.get(str12));
              String str20 = "";
              if (!str17.equals("")) {
                str17 = str17.substring(str17.indexOf(".") + 1);
                str20 = Util.null2String(resultSet.getString(str17));
                if (!"6".equals(str18)) {
                  if (str14.equals("3"))
                    if (str15.equals("1")) {
                      str20 = getCreater(str20, str18);
                    } else if (str15.equals("4")) {
                      str20 = getDept(str20, str18);
                    } else if (str15.equals("164")) {
                      str20 = getSubCom(str20, str18);
                    }  
                } else if (!"".equals(str19)) {
                  str20 = getTranSqlValue(str19, str20);
                } else {
                  str20 = str20;
                } 
              } 
              if (str20.equals("")) {
                if (!str14.equals("2") && (!str14.equals("1") || (!str15.equals("1") && !str15.equals("5"))) && (!str14.equals("3") || (!str15.equals("2") && !str15.equals("19") && !str15.equals("161") && !str15.equals("162"))))
                  str20 = "NULL"; 
                if (str14.equals("5")) {
                  str20 = "-1";
                } else if (str14.equals("4")) {
                  str20 = "0";
                } 
              } else if (str16.indexOf("varchar") == 0 || str16.indexOf("char") == 0) {
                int i = Util.getIntValue(str16.substring(str16.indexOf("(") + 1, str16.indexOf(")")), 0);
                if (Util.length2(str20) > i)
                  do {
                    str20 = str20.substring(0, str20.length() - 1);
                  } while (Util.length2(str20) > i); 
                str20 = str20.replace("'", "''");
              } else if (str16.equals("int") || str16.equals("integer")) {
                str20 = Util.getIntValue(str20, -1) + "";
              } else if (str16.indexOf("decimal") == 0 || str16.indexOf("number") == 0) {
                str20 = str20.replace(",", "");
                str20 = Util.getDoubleValue(str20, -1.0D) + "";
              } else if (str14.equals("3") && str15.equals("17") && bool) {
                hashMap.put(str13, str20);
                str20 = " empty_clob() ";
              } 
              str10 = str10 + "," + str13;
              if (str16.startsWith("text") || str16.startsWith("char") || str16.startsWith("varchar") || str16.indexOf(".") > -1 || str16.startsWith("clob")) {
                str11 = str11 + ",'" + str20 + "'";
              } else if (str14.equals("3") && (str15.equals("256") || str15.equals("257"))) {
                str11 = str11 + ",'" + str20 + "'";
              } else {
                str11 = str11 + "," + str20;
              } 
            } 
          } 
          str10 = str10 + ") ";
          str11 = str11 + ") ";
          this.newlog.info("detail sql:" + str10 + str11);
          recordSet.executeSql(str10 + str11);
          if (bool)
            try {
              String str = "";
              if (str1.equals("0")) {
                str = "select max(id) dtid from " + str5 + " where requestid =" + paramInt + " and groupId = " + (String)arrayList2.get(b2);
              } else if (str1.equals("1")) {
                str = "select max(id) dtid from " + str5 + " where " + str3 + " =" + str4;
              } 
              recordSet.executeSql(str);
              if (recordSet.next()) {
                String str12 = Util.null2String(recordSet.getString("dtid"));
                if (!"".equals(str12)) {
                  String str13 = "";
                  str13 = " select ";
                  byte b3 = 0;
                  String str14 = " ";
                  Iterator<Map.Entry> iterator = hashMap.entrySet().iterator();
                  while (iterator.hasNext()) {
                    b3++;
                    Map.Entry entry = iterator.next();
                    String str15 = entry.getKey().toString();
                    String str16 = "";
                    if (entry.getValue() != null)
                      if (String.valueOf(entry.getValue()).equals(" ")) {
                        str16 = "";
                      } else {
                        str16 = String.valueOf(entry.getValue());
                      }  
                    if (b3 > 1) {
                      str13 = str13 + str14 + " , " + str15;
                      continue;
                    } 
                    str13 = str13 + str14 + " " + str15;
                  } 
                  str13 = str13 + " from " + str5;
                  if (str1.equals("0")) {
                    str13 = str13 + " where requestid = " + paramInt + " and groupId = " + (String)arrayList2.get(b2) + " and id = " + str12 + " for update";
                  } else if (str1.equals("1")) {
                    str13 = str13 + " where " + str3 + " = " + str4 + "and id = " + str12 + " for update";
                  } 
                  if (b3 > 0) {
                    ConnStatement connStatement = null;
                    try {
                      connStatement = new ConnStatement();
                      connStatement.setStatementSql(str13, false);
                      connStatement.executeQuery();
                      if (connStatement.next()) {
                        iterator = hashMap.entrySet().iterator();
                        b3 = 0;
                        while (iterator.hasNext()) {
                          b3++;
                          Map.Entry entry = iterator.next();
                          String str15 = entry.getKey().toString();
                          String str16 = "";
                          if (entry.getValue() != null)
                            if (String.valueOf(entry.getValue()).equals(" ")) {
                              str16 = "";
                            } else {
                              str16 = String.valueOf(entry.getValue());
                            }  
                          CLOB cLOB = connStatement.getClob(b3);
                          char[] arrayOfChar = str16.toCharArray();
                          Writer writer = cLOB.getCharacterOutputStream();
                          writer.write(arrayOfChar);
                          writer.flush();
                          writer.close();
                        } 
                      } 
                    } catch (Exception exception) {
                      this.newlog.error(", exception);
                    } finally {
                      if (connStatement != null)
                        connStatement.close(); 
                    } 
                  } 
                } 
              } 
              hashMap.clear();
            } catch (Exception exception) {
              this.newlog.error(", exception);
            }  
        } 
      } 
    } 
  }
  
  public String getCreater(String paramString1, String paramString2) {
    paramString1 = paramString1.replace("'", "''");
    RecordSet recordSet = new RecordSet();
    String str = "";
    if (paramString2.equals("0")) {
      recordSet.executeSql("select id from HrmResource where id='" + paramString1 + "' and status<4  and (loginid !='' Or  loginid is not  null) ");
      if (recordSet.next())
        str = recordSet.getString("id"); 
    } else if (paramString2.equals("1")) {
      recordSet.executeSql("select id from HrmResource where workcode='" + paramString1 + "' and  status<4 and (loginid !='' Or  loginid is not  null) ");
      if (recordSet.next())
        str = recordSet.getString("id"); 
    } else if (paramString2.equals("2")) {
      recordSet.executeSql("select id from HrmResource where loginid='" + paramString1 + "' and  status<4 and (loginid !='' Or  loginid is not  null) ");
      if (recordSet.next())
        str = recordSet.getString("id"); 
    } else if (paramString2.equals("3")) {
      recordSet.executeSql("select id from HrmResource where mobile='" + paramString1 + "' and  status<4  and (loginid !='' Or  loginid is not  null) ");
      if (recordSet.next())
        str = recordSet.getString("id"); 
    } else if (paramString2.equals("4")) {
      recordSet.executeSql("select id from HrmResource where email='" + paramString1 + "' and  status<4  and (loginid !='' Or  loginid is not  null) ");
      if (recordSet.next())
        str = recordSet.getString("id"); 
    } else if (paramString2.equals("5")) {
      recordSet.executeSql("select id from HrmResource where id='" + paramString1 + "' and  status<4  and (loginid !='' Or  loginid is not  null) ");
      if (recordSet.next())
        str = recordSet.getString("id"); 
    } 
    return str;
  }
  
  public String getDept(String paramString1, String paramString2) {
    paramString1 = paramString1.replace("'", "''");
    RecordSet recordSet = new RecordSet();
    String str = "";
    if (paramString2.equals("0")) {
      recordSet.executeSql("select id from HrmDepartment where id='" + paramString1 + "'");
      if (recordSet.next())
        str = recordSet.getString("id"); 
    } else if (paramString2.equals("1")) {
      recordSet.executeSql("select id from HrmDepartment where departmentcode='" + paramString1 + "'");
      if (recordSet.next())
        str = recordSet.getString("id"); 
    } 
    return str;
  }
  
  public String getSubCom(String paramString1, String paramString2) {
    paramString1 = paramString1.replace("'", "''");
    RecordSet recordSet = new RecordSet();
    String str = "";
    if (paramString2.equals("0")) {
      recordSet.executeSql("select id from HrmSubCompany where id='" + paramString1 + "'");
      if (recordSet.next())
        str = recordSet.getString("id"); 
    } else if (paramString2.equals("1")) {
      recordSet.executeSql("select id from HrmSubCompany where subcompanycode='" + paramString1 + "'");
      if (recordSet.next())
        str = recordSet.getString("id"); 
    } 
    return str;
  }
  
  private boolean saveOutTrigLog(Statement paramStatement, String paramString1, String paramString2, String paramString3, String paramString4, String paramString5, String paramString6, String paramString7, String paramString8) {
    try {
      String str = "";
      if (!"".equals(paramString4))
        str = str + paramString4 + "='" + paramString7 + "'"; 
      if (!"".equals(paramString4))
        str = str + ("".equals(str) ? (paramString5 + "='" + paramString8 + "'") : ("," + paramString5 + "='" + paramString8 + "'")); 
      if (!"".equals(paramString2)) {
        paramString2 = paramString2.trim();
        if (paramString2.indexOf("set") == 0)
          paramString2 = paramString2.substring(4); 
        str = str + ("".equals(str) ? paramString2 : ("," + paramString2));
      } 
      if (!"".equals(str)) {
        String str1 = "update " + paramString1 + " set " + str + " where " + paramString3 + "='" + paramString6 + "'";
        this.newlog.info("saveOutTrigLog sql : " + str1);
        paramStatement.executeUpdate(str1);
      } 
    } catch (Exception exception) {
      this.newlog.error(", exception);
      return false;
    } 
    return true;
  }
  
  private boolean saveUpdateWfFlag(Statement paramStatement, String paramString1, String paramString2, String paramString3, String paramString4, String paramString5) {
    try {
      String str1 = "";
      String str2 = "";
      if (paramString4.equals("2") && !"".equals(paramString5))
        str2 = str2 + ("".equals(str2) ? (paramString5 + "='0'") : ("," + paramString5 + "='0'")); 
      if (!"".equals(str1)) {
        str1 = str1.trim();
        if (str1.indexOf("set") == 0)
          str1 = str1.substring(4); 
        str2 = str2 + ("".equals(str2) ? str1 : ("," + str1));
      } 
      if (!"".equals(str2)) {
        String str = "update " + paramString1 + " set " + str2 + " where " + paramString2 + "='" + paramString3 + "'";
        paramStatement.executeUpdate(str);
        this.newlog.info("saveUpdateWfFlag sql : " + str);
      } 
    } catch (Exception exception) {
      this.newlog.error(", exception);
      return false;
    } 
    return true;
  }
  
  private boolean saveTrigLog(String paramString1, String paramString2, String paramString3, String paramString4, String paramString5) {
    try {
      boolean bool = false;
      RecordSet recordSet = new RecordSet();
      String str = "select requestid from outerdatawfdetail where keyfieldvalue='" + paramString4 + "' and outermaintable = '" + paramString5 + "' and workflowid=" + paramString1 + " and mainid=" + paramString3;
      recordSet.executeSql(str);
      if (recordSet.next())
        bool = true; 
      if (bool) {
        str = "update outerdatawfdetail set requestid=" + paramString2 + " where mainid=" + paramString3 + " and workflowid=" + paramString1 + " and outermaintable = '" + paramString5 + "' and keyfieldvalue='" + paramString4 + "'";
      } else {
        str = "insert into outerdatawfdetail(mainid,workflowid,requestid,keyfieldvalue,outermaintable) values(" + paramString3 + "," + paramString1 + "," + paramString2 + ",'" + paramString4 + "','" + paramString5 + "')";
      } 
      this.newlog.info("saveTrigLog sql : " + str);
      recordSet.executeSql(str);
    } catch (Exception exception) {
      this.newlog.error(", exception);
      return false;
    } 
    return true;
  }
  
  private void saveRequestLog(String paramString1, String paramString2, String paramString3, int paramInt) {
    SimpleDateFormat simpleDateFormat1 = new SimpleDateFormat("yyyy-MM-dd");
    SimpleDateFormat simpleDateFormat2 = new SimpleDateFormat("HH:mm:ss");
    Date date = new Date();
    String str1 = simpleDateFormat1.format(date);
    String str2 = simpleDateFormat2.format(date);
    String str3 = "";
    if (paramInt > -1) {
      str3 = "1";
    } else {
      str3 = "0";
    } 
    RecordSet recordSet = new RecordSet();
    String str4 = "insert into outerdatawflog(Outerdatawfid,Outkey,Workflowid,RequestId,Triggerflag,CreateDate,CreateTime) values('" + paramString1 + "','" + paramString2 + "','" + paramString3 + "','" + paramInt + "','" + str3 + "','" + str1 + "','" + str2 + "')";
    recordSet.executeSql(str4);
    this.newlog.info("saveRequestLog sql : " + str4);
  }
}

很长一段，核心检查逻辑在 public void doActiveOutDataWF() 这里。下面的参数除了 “FTriggerFlag” 属性必须在触发的外部主表中有一个同名字段、且类型为整数；其他属性可以按具体场景配置自己喜欢的名字的字段。

而且需要注意：外部表主表如果为视图，则无法实现成功 / 失败时回写内容的配置。因此，如果外部表（主表 / 明细表）需要不重复推送，可以设置形如 where 外部表.[流程requestid对应的字段] not in (select id from formtable_main_xxx)  等的条件。

一个常用的技巧是：如果需要把一个普通的表转为“明细表” 并输出到对应流程（ps. 只有一个源表、且原本就没有可用的主-子表关系时）、可以写一个 MASTER_VIEW 视图。具体步骤如下：

  • 在 MASTER_VIEW 视图中用 where exists() 限定“明细表” 的条件，并指定一个固定值的字段【A】。
  • 再写一个 DETAIL_VIEW 视图、实现流程明细表要查询的真正逻辑；同时返回一列和【A】同样名字和值的固定列。
  • 最后，在触发配置的 “外部明细表1条件” 处填写  where MASTER_VIEW.【A】 = DETAIL_VIEW.【A】。

完成上述配置之后，可以在系统的 workflow_requestbase 表 / 流程监控中查看、是否正常触发了流程。

泛微E8自定义触发流程检查参数
参数名含义用途
id
外部表的主键项，可以是任何名字
workflowid
需要被触发创建的流程id
datasourceid
数据源id、即使是泛微自己的表作为外部表、也需要创建数据源
outermaintable
外部表（主表）的名字
keyfield
datarecordtype
requestid
外部表触发成功后、回写产生的流程请求id的列的名字
FTriggerFlag
默认不可更名：触发成功的回写列，不能在其他条件中进行数据修改。
FTriggerFlagValue
outermainwhere
外部表的数据筛选条件，必须以 where 开头。
successback
failback
outerdetailtables
外部表的明细表（可选）
outerdetailwheres
外部表的明细表筛选条件、用作判断和主表关联（可选）
isnextnode
isupdatewfdata
isupdatewfdataField

目前看来、在最简单的配置方法下：CREATER 和流程标题是必须提供外部表字段的。转换配置规则如下：

  • 当外部表 / 视图的 “流程创建人”  字段和 泛微E8 的 Hrmresource 表 - id 字段完全对应时、 其 “转换规则” 不需要选择任何内容。
  • 当 “流程创建人” 字段对应人员工号、即泛微E8的 Hrmresource 表 - workcode 字段完全对应时、其 “转换规则” 需要选择 “登录名” 。如下图所示。

否则待触发的流程会一直无法创建。

除此以外，在测试环境进行流程触发后、如需再次实现触发：需要清除 outerdatawfdetail 表中对应 mainid （代表触发配置项）和 workflowid (对应流程路径) 的记录。outerdatawfdetail 表和其他流程相关的表结构如下图所示：

总结

综上所述，泛微E8 的流程触发可选表 / 视图两种外部数据表。触发成功的记录保存在系统的 outerdatawfdetail 表中。其他注意事项包括：

  • 如果触发失败，请调取 /ecology/log/integration/integration.log 查看具体的报错原因。
  • 如果要单独设置每个流程触发的周期、请使用更高版本的 泛微E9。

（完）

无名无姓某罗
关注
专栏目录
E8一个项目综合教程、泛微Ecology8简单一个完整项目代码
11-01
jsp显示界面 流程java action调用事件完整例子 java发短信完整例子 java webservice接口写方法，提供第三方调用 java 定时任务例子
泛微OA流程自动汇总触发（流程触发集成）
一粒大榴莲的博客
12-06 3998
泛微OA流程自动汇总触发（流程触发集成）
泛微OA主流程节点设置子流程归档后主流程自动跳转下一个节点，子流程已归档主流程不自动跳转
最新发布
baidu_32426435的博客
09-05 348
主流程节点中存在必填字段中有空值，需要检查主流程节点排查把空值的必填字段设置成只读或者编辑。主流程节点已设置触发的子流程归档后自动跳转下个节点。再干预一次子流程归档，主流程即跳转下个节点。当子流程归档后主流程不自动跳转下个节点。
易飞9.0提交触发泛微8.0流程
10-14
易飞ERP采购单提交生成泛微OA8.0采购流程，OA审核完毕回写ERP，C#，winfrom写的，简单的小例子，仅供学习。
泛微设置子流程自动触发
liuxinmmmmm的博客
12-25 1482
泛微OA流程自动触发设置子流程设置
泛微e-cology接口之外部发起流程C#实例
qq_14813665的博客
01-27 4724
1、添加WSDL http://****/services/WorkflowService?wsdl 2、C#测试发起流程代码，对应测试流程如下图，有四个字段没有明细表。注意设置的字段必填项对于外部接口发起无效，而那些自动生成的字段在代码中必须指定值，如下图的填单人和时间必须指定。 WorkflowServicePortTypeClient iedc= new WorkflowServicePortTypeClient(); WorkflowBa...
jira自定义流程配置方式
Jinda的博客
10-27 3811
1、单独定义好流程要用的问题属性-->>状态的节点。 2、定义问题类型。 3、定义问题类型方案。 3、新建工作流。 4、新建工作流方案。 5、新建项目管理项目。 6、设置项目管理版本。 7、重新选择项目流程，同时为流程绑定问题类型。不同的问题类型可以分配到不同的流程方案里。 8、这是发布问题时就可以选择不同类型。
泛微E8表结构
10-15
泛微OA E8 表结构，OA开发管理及数据库使用说明文件 。
2020收集——泛微 Ecology流程表单常用JS脚本
03-09
3. 泛微OA系统支持通过流程节点操作菜单自定义名称的维护，相关表名为WORKFLOW_NODECUSTOMRCMENU。 4. 获取手机端明细表行数的方法是使用jQuery选择器，例如：jQuery("#nodenum1").val()。 5. 门户个人数据页面的...
E9流程表单前端接口API(2021)
01-06
- **方式3**：在“路径管理”->“应用设置”->“流程表单自定义页面设置”中进行配置，这种方式适用于整个系统的非模板模式场景。 需要注意的是，第三种方式的自定义页面为全局custompage，应避免写入ready、...
泛微oa接口开发经验
10-11
泛微OA支持自定义工作流，每个工作流程节点都可以配置相应的事件，例如任务创建、审批通过等。开发者需要理解如何定义和监听这些事件，以便在特定事件发生时执行相应的业务逻辑。这通常涉及到对工作流引擎的理解和...
泛微ecology E8协同办公系统详细的表结构（OA数据字典）
10-11
本文件包括ecology所有的数据库表的结构，例如工作流引擎常用的表：workflow_base 工作流信息表 workflow_bill 工作流单据信息表 workflow_billfield 工作流单据字段表 workflow_flownode 工作流节点信息表 workflow_nodelink 工作流出口信息表 workflow_nodebase 工作流节点基本信息表 workflow_nownode 工作流当前节点信息表 workflow_nodegroup 工作流节点操作组表 workflow_groupdetail 工作流程节点操作组操作人明细表 workflow_requestbase 工作流请求基本信息表 workflow_requestLo g 工作流请求签字日志表 workflow_requestViewLog 工作流请求查看日志 workflow_currentoperator 工作流当前操作人信息表 workflow_browserurl 工作流自定义浏览按钮信息表 workflow_selectitem 工作流下拉选择框选择项信息表
JIRA配置管理指南--自定义工作流流程
06-20
快速熟悉掌握 JIRA配置管理--在用户组管理 自定义工作流流程方面
泛微OA E8表结构.rar
08-14
泛微OA E8 官方数据表结构。有 E-message、表单建模、公文、会议、集成中心、客户、流程引擎、门户、内容引擎、人力资源、日程、微博、相册、协作、移动引擎、邮件、预算、证照、资产、组织权限等模块中的数据表的数据结构。每个表的表描述信息，表字段的中文名称、英文名称、数据类型、长度、允许空值、主键、默认值、自增、说明的属性。
泛微E8 E9二次开发资料完整总结版 超全 泛微 E8 E9开发资料大全 开源资源下载 泛微 E8 E9 泛微实战Demo
03-06
超全 泛微 E9 Ecology 9开发资料大全 开源资源下载 泛微E9二次开发 泛微开发实战经验 泛微开发实战例子 泛微二次开发项目例子 泛微二次开发Demo 泛微二次开发完整例子 泛微二次开发入门 目​前把 E8、E9之前开发使用到知识点全整理资料，资料包括webservice、action功能使用java实现、前端知识等多技术要点汇总、分类、归纳，并且有做过其中一个项目代码实例。 理论这些资料包括了在泛微平台实现大部分企业信息化的业务开发场景 把这些开发技术文档分享出来，希望通过这个资料，为大家学习开发大大减少时间。期待大家能快速上手开发业务，只要会些开发就会泛微平台的开发，例子全有，只需要耐心花点时间学习就可以了。 详情 https://blog.csdn.net/weijia3624/article/details/127993477 https://8ma.co/res/VSSF34S8
泛微二开时自动提交审批节点
flying86的博客
09-24 1752
在泛微二开时需要自动提交审批节点，可以先在workflow_currentoperator、workflow_nodebase、workflow_flownode及业务表中及数据查出，接着将相关审批人带入以下代码即可。 WorkflowService workflowService = new WorkflowServiceImpl(); Integer requestId = 100; Integer userId = 10; String userTyp
泛微OA资产表同步事件/资产修改表同步到资产信息表触发器
wuzuozhen的博客
07-14 184
泛微OA资产表同步事件/资产修改表同步到资产信息表触发器
【泛微ecology】表单建模批量操作发起指定流程，对选中的行引入流程明细表单
fwecology的博客
06-22 3007
在建模中新建页面扩展，扩展用途为查询列表（批量操作） 效果：在建模查询界面增加批量操作按钮，对选中的行操作 javascript: var a=_xtable_CheckedCheckboxId(); window.open('/spa/workflow/static4form/index.html?_rdm=1615967102987#/main/workflow/req?iscreate=1&workflowid=12&field6079='+a); _xtable_Checke
泛微OA流程节点附加操作-自定义接口动作
reneeyau的博客
10-20 4398
泛微OA流程节点附加操作-自定义接口动作
泛微ecology9流程 仿真
11-10
泛微Ecology9流程仿真是指使用泛微Ecology9工作流平台进行流程模拟和仿真的过程。在这个过程中，我们可以使用Ecology9的模型设计和调试功能，对各种业务流程进行模拟和优化。 首先，我们需要明确要仿真的流程目标。比如，我们想要优化一个采购流程，提高采购效率和减少采购成本。 接下来，我们可以使用Ecology9的模型设计工具，建立一个采购流程的模型。在模型中，我们将定义流程的各个环节、审批人员、流程规则等信息。 然后，我们可以通过Ecology9的模拟功能，对建立的模型进行仿真。在仿真过程中，我们可以根据实际情况调整各个环节的处理时间、审批人员的工作效率等参数，模拟不同的流程场景。 通过多次的仿真运行，我们可以观察到不同参数对流程效率和成本的影响。我们可以通过分析仿真结果，找到流程中的瓶颈和问题，并提出优化方案。 最后，我们可以根据仿真结果进行优化调整，并在实际应用中验证改进后的流程效果。 总之，泛微Ecology9流程仿真是一种基于工作流平台的流程优化方法。通过模拟和调整各个环节的参数，我们可以找到流程中的问题，并进行针对性的优化，提高流程效率和降低成本。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值