package com.highcom.workflow.dao.jdbc;

import org.springframework.dao.*;

import org.springframework.jdbc.core.*;import org.springframework.jdbc.core.support.*;

import java.sql.*;

import java.util.*;import com.highcom.workflow.domain.*;import com.highcom.workflow.dao.*;import com.highcom.seqgen.*;

public class WorkflowDaoJdbcImpl extends JdbcDaoSupport implements WorkflowDao { private SequenceService sequenceService = null; private String WORKFLOW_TEMPLATE_SEQ = "com.highcom.workflow.template"; private String WORKFLOW_TEMPLATE_NODE_SEQ = "com.highcom.workflow.template.node"; private String WORKFLOW_TEMPLATE_NODE_MAN_SEQ = "com.highcom.workflow.template.node.man"; // private String WORKFLOW_SEQ = "com.highcom.workflow"; private String WORKFLOW_NODE_SEQ = "com.highcom.workflow.node"; private String WORKFLOW_NODE_MAN_SEQ = "com.highcom.workflow.node.man"; // public WorkflowDaoJdbcImpl() { }

/** * 新建立一个工作流模板 * @param template WorkflowTemplate */ public void addNewTemplate(WorkflowTemplate template) { String id = sequenceService.getValue(WORKFLOW_TEMPLATE_SEQ); this.getJdbcTemplate().update("insert into workflow_template(id,name,description,createDate,createMan,status,defaultworkflow) values(?,?,?,?,?,?,?)", new Object[] { id, template.getName(), template.getDescription(), template.getCreateDate(), template.getCreateMan(), new Integer(template.getStatus()), new Integer(template.getDefaultWorkflow()) }, new int[] { Types.VARCHAR, Types.VARCHAR, Types.VARCHAR, Types.DATE, Types.VARCHAR, Types.INTEGER, Types.INTEGER }); }

public void addNewTemplateNode(WorkflowTemplateNode flowNode) { String id = this.sequenceService.getValue(this. WORKFLOW_TEMPLATE_NODE_SEQ); int maxseq = getTemplateNodeMaxSequence(flowNode.getWorkId()); maxseq += 1; this.getJdbcTemplate().update("insert into workflow_template_flow(id,template_id,sequence,name,description) values(?,?,?,?,?)", new Object[] { id, flowNode.getWorkId(), new Integer(maxseq), flowNode.getName(), flowNode.getDescription() }, new int[] { Types.VARCHAR, Types.VARCHAR, Types.INTEGER, Types.VARCHAR, Types.VARCHAR });

//插入人员信息 if (flowNode.getMans() != null) { List mans = flowNode.getMans();

for (int i = 0; i < mans.size(); i++) { String man_id = this.sequenceService.getValue(this. WORKFLOW_TEMPLATE_NODE_MAN_SEQ); String account_id = (String) mans.get(i); this.getJdbcTemplate().update("insert into workflow_template_man(id,template_flow_id,account_id