EOS流程开发实例一、任务要求 徐州管道操作系统申请流程管理，首先由申请人填写申请表，然后将申请表提交给信息部门负责人审批，最后由信息部门负责人转派系统管理员为此申请人分配操作系统登录的账号与密码。表1为操作系统用户申请表。操作系统用户申请表单位/部门申请人申请时间服务器名称IP地址申请账号原因/用途用户名密码系统管理员信息部审批表1二、开发步骤1、数据库表的开发A、新建业务流程表 每个流程都应该具有四张表： IPTWF_*_DUPLICATE、IPTWF_*_LINK、IPTWF_*_TASK、IPTWF_*_MAIN。它们的建表语句如下：create table IPTWF_*_DUPLICATE( DUPLICATE_ID NUMBER(12) not null, MAIN_ID NUMBER(12), PROCESS_INST_ID NUMBER(12), FROM_USER_ID VARCHAR2(32), FROM_USER_NAME VARCHAR2(32), TO_USER_ID VARCHAR2(32), TO_USER_TYPE VARCHAR2(32), TO_USER_NAME VARCHAR2(32), SEND_TIME DATE, ACTIVITY_DEF_ID VARCHAR2(32), ACTIVITY_DEF_NAME VARCHAR2(32), ACCEPT_FLAG NUMBER(1), ACCEPT_TIME DATE, DELETED_FLAG NUMBER(1);comment on column IPTWF_*_DUPLICATE.DUPLICATE_ID is 抄送表ID;comment on column IPTWF_*_DUPLICATE.MAIN_ID is 工单ID;comment on column IPTWF_*_DUPLICATE.PROCESS_INST_ID is 流程实例ID;comment on column IPTWF_*_DUPLICATE.FROM_USER_ID is 发送者ID;comment on column IPTWF_*_DUPLICATE.FROM_USER_NAME is 发送者名称;comment on column IPTWF_*_DUPLICATE.TO_USER_ID is 接收抄送人ID;comment on column IPTWF_*_DUPLICATE.TO_USER_TYPE is 接收抄送人类型;comment on column IPTWF_*_DUPLICATE.TO_USER_NAME is 接收抄送人中文名;comment on column IPTWF_*_DUPLICATE.SEND_TIME is 发送时间;comment on column IPTWF_*_DUPLICATE.ACTIVITY_DEF_ID is 发送所处的环节ID;comment on column IPTWF_*_DUPLICATE.ACTIVITY_DEF_NAME is 发送所处的环节名称;comment on column IPTWF_*_DUPLICATE.ACCEPT_FLAG is 是否已打开查看;comment on column IPTWF_*_DUPLICATE.ACCEPT_TIME is 第一次打开时间;comment on column IPTWF_*_DUPLICATE.DELETED_FLAG is 是否已删除;alter table IPTWF_*_DUPLICATE add constraint PK_*_DUPLICATE_ID primary key (DUPLICATE_ID);create table IPTWF_*_LINK( LINK_ID NUMBER(12) not null, PHASE_ADVICE_FLAG NUMBER(1), MAIN_ID NUMBER(12), PROCESS_INST_ID NUMBER(12), ACTIVITY_DEF_ID VARCHAR2(64), ACTIVITY_INST_NAME VARCHAR2(64), ACTIVITY_INST_ID NUMBER(12), OPERATE_TYPE NUMBER(12), OPERATE_TIME DATE, OPERATE_USER_ID VARCHAR2(50), OPERATE_DEPT_ID NUMBER(12), OPERATE_CONTACT VARCHAR2(32), OPERATE_ROLE_ID VARCHAR2(32), NEXT_ACCEPT_LIMIT DATE, NEXT_COMPLETE_LIMIT DATE, ACCEPT_TIME DATE, ACCEPT_FLAG NUMBER(12), COMPLETE_TIME DATE, COMPLETE_FLAG NUMBER(12), SHEET_ACCESSORIES VARCHAR2(256), REMARK VARCHAR2(256), WORKITEM_ID NUMBER(12), OPERATE_USER_NAME VARCHAR2(50), NEXTSTEPPROCESSOR VARCHAR2(256), DESCRIPTION VARCHAR2(256);comment on column IPTWF_*_LINK.LINK_ID is link表主键;comment on column IPTWF_*_LINK.PHASE_ADVICE_FLAG is 阶段建议标志，默认为空，1：阶段建议;comment on column IPTWF_*_LINK.MAIN_ID is main表主键;comment on column IPTWF_*_LINK.PROCESS_INST_ID is 流程实例id;comment on column IPTWF_*_LINK.ACTIVITY_DEF_ID is 活动定义id;comment on column IPTWF_*_LINK.ACTIVITY_INST_NAME is 活动项名称;comment on column IPTWF_*_LINK.ACTIVITY_INST_ID is 活动实例id;comment on column IPTWF_*_LINK.OPERATE_TYPE is 操作类型：1.普通处理,2转派,3驳回,4直接提交,5阶段回复,6终止流程;comment on column IPTWF_*_LINK.OPERATE_TIME is 操作时间;comment on column IPTWF_*_LINK.OPERATE_USER_ID is 操作人;comment on column IPTWF_*_LINK.OPERATE_DEPT_ID is 操作部门;comment on column IPTWF_*_LINK.OPERATE_CONTACT is 操作人联系方式 ;comment on column IPTWF_*_LINK.OPERATE_ROLE_ID is 操作人角色;comment on column IPTWF_*_LINK.NEXT_ACCEPT_LIMIT is 当前操作人对下一环节的接单时限要求：接单时限(派单操作专用) 回复时限;comment on column IPTWF_*_LINK.NEXT_COMPLETE_LIMIT is 当前操作人对下一环节的完成时限要求：回复时限(派单操作专用);comment on column IPTWF_*_LINK.ACCEPT_TIME is 接单时间(接单操作专用);comment on column IPTWF_*_LINK.ACCEPT_FLAG is 接单及时标志(接单操作专用);comment on column IPTWF_*_LINK.COMPLETE_TIME is 回复时间(回单操作专用);comment on column IPTWF_*_LINK.COMPLETE_FLAG is 回复及时标志(回单操作专用);comment on column IPTWF_*_LINK.SHEET_ACCESSORIES is 附件，如果在一个页面中有多个附件分组，那么就建立多个字段，分别记录;comment on column IPTWF_*_LINK.REMARK is 处理意见;comment on column IPTWF_*_LINK.WORKITEM_ID is 工作项id;comment on column IPTWF_*_LINK.OPERATE_USER_NAME is 操作中文名;comment on column IPTWF_*_LINK.NEXTSTEPPROCESSOR is 下一步处理者;comment on column IPTWF_*_LINK.DESCRIPTION is 处理描述;alter table IPTWF_*_LINK add constraint PK_*_LINK_ID primary key (LINK_ID);create table IPTWF_*_TASK( TASK_ID NUMBER(12) not null, PROCESS_INST_ID NUMBER(12), ACTIVITY_DEF_ID VARCHAR2(64), ACTIVITY_INST_NAME VARCHAR2(64), ACTIVITY_INST_ID NUMBER(12), WORKITEM_ID NUMBE