Examples of SchemaContext


Examples of org.huihoo.workflow.store.SchemaContext

    PreparedStatement pstmt6 = null;
    PreparedStatement pstmt7 = null;
    try
    {
      SpiCaseIdGenerator caseIdGenerator=gCaseDatabaseImpl.getCaseIdGenerator();
      SchemaContext      schemaContext=gCaseDatabaseImpl.getSchemaContext()
      Store         storeConfig=  gCaseDatabaseImpl.getStore();
     
      String packageId = workflowProcess.getWorkflowPackage().getUUID();
      String processId = workflowProcess.getUUID();

      if (canRelease)
      {
        conn.setAutoCommit(false);
      }

      String strSQL =
        "DELETE FROM "
          + schemaContext.getTableName(SchemaContext.SCHEMA_CASE)
          + " "
          + "WHERE    vc_packageId=? "
          + "AND      vc_processid=? "
          + "AND      vc_uuid=?";

      pstmt1 = conn.prepareStatement(strSQL);
      pstmt1.setString(1, packageId);
      pstmt1.setString(2, processId);
      pstmt1.setString(3, workflowCase.getUUID());
      pstmt1.executeUpdate();

      strSQL =
        "DELETE FROM "
          + schemaContext.getTableName(SchemaContext.SCHEMA_CASE_DATAFIELD)
          + " "
          + "WHERE    vc_packageId=? "
          + "AND      vc_processid=? "
          + "AND      vc_caseid=?";

      pstmt2 = conn.prepareStatement(strSQL);
      pstmt2.setString(1, packageId);
      pstmt2.setString(2, processId);
      pstmt2.setString(3, workflowCase.getUUID());
      pstmt2.executeUpdate();

      strSQL =
        "DELETE FROM "
          + schemaContext.getTableName(SchemaContext.SCHEMA_WORK)
          + " "
          + "WHERE    vc_packageId=? "
          + "AND      vc_processid=? "
          + "AND      vc_caseid=?";

      pstmt3 = conn.prepareStatement(strSQL);
      pstmt3.setString(1, packageId);
      pstmt3.setString(2, processId);
      pstmt3.setString(3, workflowCase.getUUID());
      pstmt3.executeUpdate();

      strSQL =
        "DELETE FROM "
          + schemaContext.getTableName(SchemaContext.SCHEMA_PATH)
          + " "
          + "WHERE    vc_packageId=? "
          + "AND      vc_processid=? "
          + "AND      vc_caseid=?";

      pstmt4 = conn.prepareStatement(strSQL);
      pstmt4.setString(1, packageId);
      pstmt4.setString(2, processId);
      pstmt4.setString(3, workflowCase.getUUID());
      pstmt4.executeUpdate();

      strSQL =
        "DELETE FROM "
          + schemaContext.getTableName(SchemaContext.SCHEMA_CASE_EVENT)
          + " "
          + "WHERE    vc_packageId=? "
          + "AND      vc_processid=? "
          + "AND      vc_caseid=?";

      pstmt5 = conn.prepareStatement(strSQL);
      pstmt5.setString(1, packageId);
      pstmt5.setString(2, processId);
      pstmt5.setString(3, workflowCase.getUUID());
      pstmt5.executeUpdate();

      strSQL =
        "DELETE FROM "
          + schemaContext.getTableName(SchemaContext.SCHEMA_WORK_EVENT)
          + " "
          + "WHERE    vc_packageId=? "
          + "AND      vc_processid=? "
          + "AND      vc_caseid=?";

      pstmt6 = conn.prepareStatement(strSQL);
      pstmt6.setString(1, packageId);
      pstmt6.setString(2, processId);
      pstmt6.setString(3, workflowCase.getUUID());
      pstmt6.executeUpdate();
 
      strSQL =
        "DELETE FROM "
          + schemaContext.getTableName(SchemaContext.SCHEMA_ACTIVITY_DISPATCH)
          + " "
          + "WHERE    vc_packageId=? "
          + "AND      vc_processid=? "
          + "AND      vc_caseid=?";
View Full Code Here

Examples of org.huihoo.workflow.store.SchemaContext

  {
    PreparedStatement pstmt = null;
    try
    {
      SpiCaseIdGenerator caseIdGenerator=gCaseDatabaseImpl.getCaseIdGenerator();
      SchemaContext      schemaContext=gCaseDatabaseImpl.getSchemaContext()
      Store         storeConfig=  gCaseDatabaseImpl.getStore();
     
      String packageId = workflowProcess.getWorkflowPackage().getUUID();
      String processId = workflowProcess.getUUID();
      String strSQL =
        "UPDATE "
          + schemaContext.getTableName(SchemaContext.SCHEMA_CASE)
          + " "
          + "SET  int_status=?"
          + " "
          + "WHERE    vc_packageId=?"
          + " "
View Full Code Here

Examples of org.huihoo.workflow.store.SchemaContext

    PreparedStatement pstmt = null;
    String workId = null;
    try
    {
      SpiCaseIdGenerator caseIdGenerator=gCaseDatabaseImpl.getCaseIdGenerator();
      SchemaContext      schemaContext=gCaseDatabaseImpl.getSchemaContext()
      Store         storeConfig=  gCaseDatabaseImpl.getStore();
     
      String packageId = workflowProcess.getWorkflowPackage().getUUID();
      String processId = workflowProcess.getUUID();
      String caseId = workflowCase.getUUID();
      workId = caseIdGenerator.genWorkflowWorkID(packageId, processId, caseId);
      String strSQL =
        "INSERT INTO "
          + schemaContext.getTableName(SchemaContext.SCHEMA_WORK)
          + "(vc_packageid,vc_processid,vc_caseid,vc_owner_processid,vc_activityid,vc_uuid,vc_performer,dat_arriveTime) "
          + "VALUES(?,?,?,?,?,?,?,?)";
      pstmt = conn.prepareStatement(strSQL);
      pstmt.setString(1, packageId);
      pstmt.setString(2, processId);
View Full Code Here

Examples of org.huihoo.workflow.store.SchemaContext

    PreparedStatement pstmt = null;
    String workId = null;
    try
    {
      SpiCaseIdGenerator caseIdGenerator=gCaseDatabaseImpl.getCaseIdGenerator();
      SchemaContext      schemaContext=gCaseDatabaseImpl.getSchemaContext()
      Store         storeConfig=  gCaseDatabaseImpl.getStore();
     
      String pkgId = workflowProcess.getWorkflowPackage().getUUID();
      String processId = workflowProcess.getUUID();
      String caseId = workflowCase.getUUID();
      workId = caseIdGenerator.genWorkflowWorkID(pkgId, processId, caseId);
      String strSQL =
        "INSERT INTO "
          + schemaContext.getTableName(SchemaContext.SCHEMA_WORK)
          + "(vc_packageid,vc_processid,vc_caseid,vc_owner_processid,vc_activityid,vc_uuid,vc_performer,dat_arriveTime,vc_parent_workid) "
          + "VALUES(?,?,?,?,?,?,?,?,?)";
      pstmt = conn.prepareStatement(strSQL);
      pstmt.setString(1, pkgId);
      pstmt.setString(2, processId);
View Full Code Here

Examples of org.huihoo.workflow.store.SchemaContext

  {
    PreparedStatement pstmt = null;
    try
    {
      SpiCaseIdGenerator caseIdGenerator=gCaseDatabaseImpl.getCaseIdGenerator();
      SchemaContext      schemaContext=gCaseDatabaseImpl.getSchemaContext()
      Store         storeConfig=  gCaseDatabaseImpl.getStore();
     
      WorkflowCase workflowCase = workflowWork.getWorkflowCase();
     
      String packageId = workflowProcess.getWorkflowPackage().getUUID();
      String processId = workflowProcess.getUUID();
      String caseId = workflowCase.getUUID();
      String workId = workflowWork.getUUID();
      String strSQL =
        "UPDATE "
          + schemaContext.getTableName(SchemaContext.SCHEMA_WORK)
          + " "
          + "SET  vc_performer=?,"
          + "dat_arriveTime=?,"
          + "dat_acceptTime=?,"
          + "dat_dispatchTime=?, "
View Full Code Here

Examples of org.huihoo.workflow.store.SchemaContext

  {
    PreparedStatement pstmt = null;
    try
    {
      SpiCaseIdGenerator caseIdGenerator=gCaseDatabaseImpl.getCaseIdGenerator();
      SchemaContext      schemaContext=gCaseDatabaseImpl.getSchemaContext()
      Store         storeConfig=  gCaseDatabaseImpl.getStore();
     
     
      WorkflowCase workflowCase = workflowWork.getWorkflowCase();
     
      String packageId = workflowProcess.getWorkflowPackage().getUUID();
      String processId = workflowProcess.getUUID();
      String caseId = workflowCase.getUUID();
      String workId = workflowWork.getUUID();
      String strSQL =
        "DELETE FROM "
          + schemaContext.getTableName(SchemaContext.SCHEMA_WORK)
          + " "
          + "WHERE    vc_packageId=?"
          + " "
          + "AND      vc_processid=?"
          + " "
View Full Code Here

Examples of org.huihoo.workflow.store.SchemaContext

    ResultSet jrs = null;

    try
    {
      SpiCaseIdGenerator caseIdGenerator=gCaseDatabaseImpl.getCaseIdGenerator();
      SchemaContext      schemaContext=gCaseDatabaseImpl.getSchemaContext()
      Store         storeConfig=  gCaseDatabaseImpl.getStore();
     
      WorkflowPackage workflowPackage = workflowProcess.getWorkflowPackage();
      String packageId = workflowPackage.getUUID();
      String processId = workflowProcess.getUUID();
      String caseId = workflowCase.getUUID();
      String strSQL =
        "SELECT * FROM "
          + schemaContext.getTableName(SchemaContext.SCHEMA_WORK)
          + " "
          + "WHERE  vc_packageId=?"
          + " "
          + "AND    vc_processid=?"
          + " "
View Full Code Here

Examples of org.huihoo.workflow.store.SchemaContext

    PreparedStatement pstmt = null;
    String pathId = null;
    try
    {
      SpiCaseIdGenerator caseIdGenerator=gCaseDatabaseImpl.getCaseIdGenerator();
      SchemaContext      schemaContext=gCaseDatabaseImpl.getSchemaContext()
      Store         storeConfig=  gCaseDatabaseImpl.getStore();
     
      String pkgId = workflowProcess.getWorkflowPackage().getUUID();
      String processId = workflowProcess.getUUID();
      String caseId = workflowCase.getUUID();
     
      String transitionId=null;
      String owner_processId=null;
      WorkflowActivity fromActivity=(fromWork!=null)?fromWork.getWorkflowActivity():null;
      WorkflowActivity toActivity=(toWork!=null)?toWork.getWorkflowActivity():null;
     
      if(fromActivity!=null && toActivity!=null)
      {
        WorkflowProcess owner_process=fromActivity.getWorkflowProcess();
        owner_processId=owner_process.getUUID();
        transitionId=owner_process.findWorkflowTransition(fromActivity,toActivity).getUUID();
      }
      pathId = caseIdGenerator.genWorkflowPathID(pkgId, processId, caseId);
      String strSQL =
        "INSERT INTO "
          + schemaContext.getTableName(SchemaContext.SCHEMA_PATH)
          + "(vc_packageid,vc_processid,vc_caseId,vc_uuid,vc_from,vc_to,vc_batchNo,int_eventType,vc_owner_processid,vc_transitionId) "
          + "VALUES(?,?,?,?,?,?,?,?,?,?)";
      pstmt = conn.prepareStatement(strSQL);
      pstmt.setString(1, pkgId);
      pstmt.setString(2, processId);
View Full Code Here

Examples of org.huihoo.workflow.store.SchemaContext

    PreparedStatement pstmt = null;

    try
    {
      SpiCaseIdGenerator caseIdGenerator=gCaseDatabaseImpl.getCaseIdGenerator();
      SchemaContext      schemaContext=gCaseDatabaseImpl.getSchemaContext()
      Store         storeConfig=  gCaseDatabaseImpl.getStore();
     
      WorkflowPackage workflowPackage = workflowProcess.getWorkflowPackage();
      String packageId = workflowPackage.getUUID();
      String processId = workflowProcess.getUUID();
      String caseId = workflowCase.getUUID();
      String strSQL =
        "SELECT * FROM "
          + schemaContext.getTableName(SchemaContext.SCHEMA_PATH)
          + " "
          + "WHERE  vc_packageId=?"
          + " "
          + "AND    vc_processid=?"
          + " "
View Full Code Here

Examples of org.huihoo.workflow.store.SchemaContext

  {
    PreparedStatement pstmt = null;
    try
    {
      SpiCaseIdGenerator caseIdGenerator=gCaseDatabaseImpl.getCaseIdGenerator();
      SchemaContext      schemaContext=gCaseDatabaseImpl.getSchemaContext()
      Store         storeConfig=  gCaseDatabaseImpl.getStore();
     
      WorkflowCase workflowCase = workflowPath.getFromWorkflowWork().getWorkflowCase();
     
      String packageId = workflowProcess.getWorkflowPackage().getUUID();
      String processId = workflowProcess.getUUID();
      String caseId = workflowCase.getUUID();
      String strSQL =
        "DELETE FROM "
          + schemaContext.getTableName(SchemaContext.SCHEMA_PATH)
          + " "
          + "WHERE  vc_packageId=?"
          + " "
          + "AND    vc_processid=?"
          + " "
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.