办公自动化系统基于表单的工作流设计及实现.pdf

Computer Science and Application 计算机科学与应用, 2016, 6(1), 50-57 Published Online January 2016 in Hans. /journal/csa /10.12677/csa.2016.61006 Design and Implementation of Workflow Based on Form for Office Automation System Mengsu Liu Guangzhou Grandbuy Company Limited, Guangzhou Guangdong th rd th Received: Jan. 7 , 2016; accepted: Jan. 23 , 2016; published: Jan. 30 , 2016 Copyright © 2016 by author and Hans Publishers Inc. This work is licensed under the Creative Commons Attribution International License (CC BY). /licenses/by/4.0/ Abstract Based on approval affairs of an appliances company’s wholesale and retail supplier, this paper electronically achieves standardization and approval process for internal business data. The workflow module is based on existing OA system and uses HTML technology electronic flow form. The secondary development uses SQL Server, Oracle database technology and synchronization part of the data from the OA system to the relevant business system. This work fully and efficiently uses resources of the enterprise personnel, time, space and information. Through the work flow opti- mization design, the working efficiency of enterprises is improved. Keywords Office Automation, Form, Workflow, Stored Procedure 办公自动化系统基于表单的工作流设计与实现 刘梦苏 广州市广百股份有限公司，广东 广州 收稿日期：2016年1月7 日；录用日期：2016年1月23 日；发布日期：2016年1月30 日 摘 要 本文以某企业电器分公司批发零售供应商审批事务为基础，实现电子化、规范化内部业务数据的审批流 文章引用: 刘梦苏. 办公自动化系统基于表单的工作流设计与实现[J]. 计算机科学与应用, 2016, 6(1): 50-57. /10.12677/csa.2016.61006 刘梦苏 程，基于现有OA系统的工作流模块，应用HTML技术电子化流程表单，应用SQL Server及Oracle数据库 技术进行二次开发，将部分数据从OA系统同步到相关业务系统，实现跨系统、