workflowloginfocontrol.java

公司自己开发的工作流引擎

package cn.com.iaspec.workflow.engine.business;

/**
 * <p>Title:流程记录查看功能 </p>
 *
 * <p>Description: 深圳市劳动仲裁信息管理系统</p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: 永泰软件工程有限公司</p>
 *
 * @author syj
 * @version 1.0
 */
import java.sql.*;
import java.util.*;
import cn.com.iaspec.workflow.db.*;
import cn.com.iaspec.workflow.engine.dao.*;
import cn.com.iaspec.workflow.vo.workflow.*;
import com.sunyard.sunflow.client.*;
import com.sunyard.sunflow.engine.context.*;

public class WorkflowLogInfoControl{
  WorkflowLogDAO workflowLogDAO=new WorkflowLogDAO();
  public ArrayList QueryWorkflowLogInfo(UserInfo userinfo,String registerNO){
    SunflowClient sunflowclient=WorkflowSession.getSunflowClient(userinfo);
    ArrayList list=new ArrayList();
    WorkItemContextCollection ContextCollection=null;
    Connection conn=null;
    try{
      ArrayList list1=workflowLogDAO.getWorkflowLogInfo(registerNO);
      Iterator it=list1.iterator();
      conn=WorkflowDBConnectionManager.getInstance().getConnection();
      int j=0;
      while(it.hasNext()){
        workflowLogInfo loginfo=(workflowLogInfo)it.next();
        long proInstID=loginfo.getProInstanceID();
        ContextCollection=sunflowclient.listWorkitemByProInstID(proInstID);
        for(int i=0;i<ContextCollection.size();i++){
          j=j+1;
          workflowLogInfo workflowlog=new workflowLogInfo();
          WorkItemContext workcontext=(WorkItemContext)ContextCollection.get(i);
          workflowlog.setFlowtype(loginfo.getFlowtype());
          workflowlog.setProInstanceID(loginfo.getProInstanceID());
          workflowlog.setFproInstanceID(loginfo.getFproInstanceID());
          workflowlog.setRegisterNO(loginfo.getRegisterNO());
          workflowlog.setSequencenumber(j);
          //System.out.println("------getWorkItemID="+workcontext.getWorkItemID()+"======"+j);
          workflowlog.setWorkItemID(workcontext.getWorkItemID());
          workflowlog.setWorkItemName(workcontext.getWorkItemName());
          workflowlog.setInstanceStartTime(workcontext.getDeliverTime());
          workflowlog.setWorkItemCheckedInTime(workcontext.
              getWorkItemCheckedInTime());
          workflowlog.setWorkItemCheckedOutTime(workcontext.
              getWorkItemCheckedOutTime());
          workflowlog.setProInstanceName(workcontext.getProInstanceName());
          workflowlog.setExecutorID(workcontext.getExecutorID());
          workflowlog.setDescriptionURL(workcontext.getDescription());
          workflowlog.setExecutorName(workflowLogDAO.
              getTransactionWorkflowUserName(conn,workcontext.getExecutorID()));
          workflowlog.setSendusername(workflowLogDAO.getSendWorkflowUserName(
              conn,workcontext.getWorkItemID()));
          workflowlog.setPurviewUserList(workflowLogDAO.getPurviewUserList(
              workcontext.getWorkItemID()));
          list.add(workflowlog);
        }

      }
    }
    catch(Exception e){
      e.printStackTrace();
    }
    finally{
      WorkflowDBConnectionManager.getInstance().close(conn);
      WorkflowSession.deleteSunflowClient(userinfo);
    }

    return list;
  }

}