一个用数据库实现的工作流(10)

wfNode.setStartDate(rs.getTimestamp("start_date"));
wfNode.setEndDate(rs.getTimestamp("end_date"));
wfNode.setAuditMan(rs.getString("audit_man"));
return wfNode;
}
});
if (list != null && list.size() > 0) {
return (WorkflowNode[]) list.toArray(new WorkflowNode[list.size()]);
}
return null;

}

public WorkflowNode[] getAllBackedWorkflowNode() {
WorkflowNode[] wfNodes = getWorkflowNodeByStatus(Workflow.
WORKFLOW_STATUS_RUNNING,
WorkflowNode.WORKFLOW_NODE_STATUS_BACKED);
return wfNodes;
}

public WorkflowNode[] getAllReEditWorkflowNode() {
WorkflowNode[] wfNodes = getWorkflowNodeByStatus(Workflow.
WORKFLOW_STATUS_BACKED,
WorkflowNode.WORKFLOW_NODE_STATUS_DECLINED);
return wfNodes;
}
/**
* 取得默认的工作流模板
* @return WorkflowTemplate
*/
public WorkflowTemplate getDefaultWorkflow() {
Object obj = this.getJdbcTemplate().query(
"select * from workflow_template where defaultworkflow=?",
new Object[] {new Integer(0)}, new int[] {Types.INTEGER},
new ResultSetExtractor() {
public Object extractData(ResultSet rs) throws SQLException,
DataAccessException {
if (rs.next()) {
WorkflowTemplate temp = new WorkflowTemplate();
temp.setId(rs.getString("id"));
temp.setName(rs.getString("name"));
temp.setDescription(rs.getString("description"));
temp.setCreateMan(rs.getString("createMan"));
temp.setCreateDate(rs.getTimestamp("createDate"));
temp.setStatus(rs.getInt("status"));
temp.setDefaultWorkflow(rs.getInt("defaultworkflow"));
return temp;
}
return null;
}
});
if (obj != null) {
return (WorkflowTemplate) obj;
}
return null;
}
}

上一篇： 一个生成唯一序号的服务，虽然技术不先进，但是很好用
下一篇： 处理系统中的各类附件，上传下载

标签：

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有