[go: up one dir, main page]

CN110348803A - Cooperate with approval system - Google Patents

Cooperate with approval system Download PDF

Info

Publication number
CN110348803A
CN110348803A CN201910487311.8A CN201910487311A CN110348803A CN 110348803 A CN110348803 A CN 110348803A CN 201910487311 A CN201910487311 A CN 201910487311A CN 110348803 A CN110348803 A CN 110348803A
Authority
CN
China
Prior art keywords
approval
data
business
database
collaboration
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201910487311.8A
Other languages
Chinese (zh)
Inventor
卢伟涛
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
ZTE ICT Technologies Co Ltd
Original Assignee
ZTE ICT Technologies Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by ZTE ICT Technologies Co Ltd filed Critical ZTE ICT Technologies Co Ltd
Priority to CN201910487311.8A priority Critical patent/CN110348803A/en
Publication of CN110348803A publication Critical patent/CN110348803A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2379Updates performed during online database operations; commit processing
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • General Engineering & Computer Science (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Operations Research (AREA)
  • General Business, Economics & Management (AREA)
  • Tourism & Hospitality (AREA)
  • Quality & Reliability (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

本发明提供了一种协同审批系统。协同审批系统,包括:企业数据服务总线,用于接收业务数据,将业务数据适配到相应的前置机数据库,并将业务数据下发至相应的前置机数据库;多个前置机数据库,分别与企业数据服务总线相连接,前置机数据库用于接收并存储业务数据;多个审批单元,与多个前置机数据库一一对应连接,审批单元用于从对应的前置机数据库中读取业务数据,以对业务数据进行审批。本发明提供的协同审批系统,通过“企业数据服务总线+前置机数据库”这种模式,可以高效的解决跨系统数据共享的问题,实现可扩展、数据可追溯、易排查错误数据。

The invention provides a collaborative approval system. Collaborative approval system, including: enterprise data service bus, used to receive business data, adapt the business data to the corresponding front-end database, and send the business data to the corresponding front-end database; multiple front-end databases , are respectively connected to the enterprise data service bus, and the front-end database is used to receive and store business data; multiple approval units are connected to multiple front-end databases one by one, and the approval unit is used to obtain data from the corresponding front-end database Read the business data in to approve the business data. The collaborative approval system provided by the present invention can efficiently solve the problem of cross-system data sharing through the mode of "enterprise data service bus + front-end database", realize scalability, data traceability, and easy troubleshooting of wrong data.

Description

协同审批系统Collaborative Approval System

技术领域technical field

本发明涉及电子政务技术领域,具体而言,涉及一种协同审批系统。The invention relates to the technical field of electronic government affairs, in particular to a collaborative approval system.

背景技术Background technique

在软件开发中,经常会碰到各部门数据拉通、协同审批办理一些业务,例如协同审批系统涉及16个职能部门的400多个事项的办理,要求‘一窗受理、并联办理、依责监管、全程监察’,促进项目监管的高效、透明化、科学化,若政府部门,各市区的业务系统供应商不一致,系统架构、数据结构、系统化水平不一致,沟通协同成本高,各部门协同审批、数据共享实施难可想而知。In software development, it is often encountered that the data of various departments is connected, and collaborative approval is handled for some businesses. For example, the collaborative approval system involves the handling of more than 400 items in 16 functional departments, requiring "one-window acceptance, parallel processing, and responsibility-based supervision." , Whole-process supervision' to promote efficient, transparent, and scientific project supervision. If the government departments and business system suppliers in various urban areas are inconsistent, the system architecture, data structure, and systematization level are inconsistent, the cost of communication and coordination is high, and various departments coordinate approval , The implementation of data sharing is difficult to imagine.

现有技术方案,采用消息队列activemq来实现数据共享和同步,协同审批系统把收件相关信息放入消息队列中,开放接口给各个委办局,各委办局读取消息队列的信息,然后解析数据。该技术方案虽简单、容易实现,但具有以下缺点:The existing technical solution adopts the message queue activemq to realize data sharing and synchronization, and the collaborative approval system puts the relevant information of the receipt into the message queue, and opens the interface to each committee and bureau, and each committee and bureau reads the information of the message queue, and then Analytical data. Although this technical solution is simple and easy to implement, it has the following disadvantages:

1、错误数据不好追踪,消息队列挂了,数据会丢失;1. The error data is not easy to track, the message queue hangs up, and the data will be lost;

2、大附件下发不了,导致消息队列卡死;2. Unable to send large attachments, causing the message queue to freeze;

3、各委办局需要写接口读取消息队列数据,系统耦合性增加。3. All committees, offices and bureaus need to write interfaces to read message queue data, which increases the coupling of the system.

为满足上面的情形,相关技术使用WebService,通过远程过程调用RPC调用实现数据共享。但由于协同审批系统数据共享是双向共享,协同审批系统提供WebService接口给各委办局,各委办局还要提供数据接口给平台调用,服务太多,不利于管理,系统的耦合性大大加大,错误数据不好排查。In order to meet the above situation, related technologies use WebService to realize data sharing through remote procedure call (RPC). However, due to the two-way sharing of data in the collaborative approval system, the collaborative approval system provides WebService interfaces to the commissions, offices, and bureaus, and the commissions, offices, and bureaus also provide data interfaces for platform calls. Too many services are not conducive to management, and the coupling of the system is greatly increased. Large, the wrong data is not easy to troubleshoot.

发明内容Contents of the invention

本发明旨在至少解决现有技术或相关技术中存在的技术问题之一。The present invention aims to solve at least one of the technical problems existing in the prior art or related art.

为此,本发明的一方面在于提出了一种协同审批系统。Therefore, one aspect of the present invention is to propose a collaborative approval system.

有鉴于此,本发明提出了一种协同审批系统,包括:企业数据服务总线,用于接收业务数据,将业务数据适配到相应的前置机数据库,并将业务数据下发至相应的前置机数据库;多个前置机数据库,分别与企业数据服务总线相连接,前置机数据库用于接收并存储业务数据;多个审批单元,与多个前置机数据库一一对应连接,审批单元用于从对应的前置机数据库中读取业务数据,以对业务数据进行审批。In view of this, the present invention proposes a collaborative approval system, including: an enterprise data service bus for receiving business data, adapting the business data to the corresponding front-end database, and sending the business data to the corresponding front-end Set-up database; multiple front-end databases are respectively connected to the enterprise data service bus, and the front-end database is used to receive and store business data; multiple approval units are connected to multiple front-end databases one by one, and the approval The unit is used to read business data from the corresponding front-end database to approve the business data.

根据本发明的协同审批系统,企业数据服务总线是构建基于面向服务体系结构SOA解决方案时所使用基础架构的关键部分,是由中间件技术实现并支持SOA的一组基础架构功能,它是由信息交换服务总线iESB和数iETL协同配合组成工作的。前置机数据库是各协同审批部门(委办局)的数据库。通过企业数据服务总线与各前置机数据库相连接,所有与协同审批系统相关的同步协同、适配下发、集成优化都是通过企业数据服务总线总体调度。具体而言,用户通过网上办事大厅提交审批申请,协同审批系统收件,待审批的业务数据进入协同审批系统,附件进入文件系统,协同审批系统调用企业数据服务总线,接收到业务数据后,通过iESB将业务数据适配到所属部门,可能是一个部门,也可能是多个部门,通过指定下发接口将业务数据推送到所属部门的前置机数据库,通过与该前置机数据库相连接的审批单元读取业务数据,并对其进行审批。本发明提供的协同审批系统,通过“企业数据服务总线+前置机数据库”这种模式,实现了统一收件,跨系统分发、协同审批,极大提高了各委办局协同审批的效率,且各委办局有专门的数据库对接,避免数据量过大,系统性能得到保证,同时可扩展性高,如增加委办局,只需添加前置机数据库即可,此外系统的耦合度基本没有,各委办局的系统的实现技术没有任何限制。According to the collaborative approval system of the present invention, the enterprise data service bus is a key part of the infrastructure used when constructing SOA solutions based on service-oriented architecture, and is a group of infrastructure functions that are implemented by middleware technology and support SOA. The information exchange service bus iESB and digital iETL work together. The front-end database is the database of each collaborative approval department (committee, office and bureau). The enterprise data service bus is connected to each front-end database, and all synchronous collaboration, adaptation and distribution, and integration optimization related to the collaborative approval system are all dispatched through the enterprise data service bus. Specifically, the user submits an application for approval through the online service hall, and the collaborative approval system receives the documents. The business data to be approved enters the collaborative approval system, and the attachments enter the file system. The collaborative approval system calls the enterprise data service bus. After receiving the business data, it passes The iESB adapts the business data to the department it belongs to, which may be one department or multiple departments, and pushes the business data to the front-end database of the department through the specified delivery interface, and connects to the front-end database through the The approval unit reads business data and approves it. The collaborative approval system provided by the present invention realizes unified receipt, cross-system distribution, and collaborative approval through the mode of "enterprise data service bus + front-end database", which greatly improves the efficiency of collaborative approval by various committees, offices, and bureaus. Moreover, each committee office has a dedicated database docking to avoid excessive data volume, guarantee system performance, and high scalability. If more committee offices are added, only the front-end database needs to be added. In addition, the coupling degree of the system is basically No, there are no restrictions on the implementation technologies of the systems of the various commissions and bureaus.

在上述技术方案中,优选地,企业数据服务总线,还用于在将业务数据下发至相应的前置机数据库时,设置第一标示位的标识;审批单元,还用于在对业务数据进行审批的步骤之前,判断第一标示位的标识是否为第一预设标识,若是,则对业务数据进行审批。In the above technical solution, preferably, the enterprise data service bus is also used to set the identification of the first flag when sending the business data to the corresponding front-end database; the approval unit is also used to check the business data Before the step of approval, it is judged whether the identifier of the first flag is the first preset identifier, and if so, the business data is approved.

在该技术方案中,将业务数据下发至所属部门的前置机数据库,并设置第一标示位的标识,这样审批单元在读取到业务数据后,便可根据第一标识的标识,来判断该业务数据是否已经被消费,或是企业数据服务总线又发起了新的业务流程。具体来说,在第一标识位的标识为第一预设标识时,表示业务数据还未被消费,此时审批单元可对业务数据进行审批,由此,可以避免重复审批,并使得业务数据可追踪,复杂环境下可快速定位错误原因,各部门协同办理不会出现互相推卸责任,进一步提高了各委办局协同审批的效率。In this technical solution, the business data is sent to the front-end database of the department, and the identification of the first marking position is set, so that after the approval unit reads the business data, it can be based on the identification of the first identification. Determine whether the business data has been consumed, or whether the enterprise data service bus has initiated a new business process. Specifically, when the identifier of the first identification bit is the first preset identifier, it means that the business data has not been consumed. At this time, the approval unit can approve the business data, thereby avoiding repeated approval and making the business data It can be tracked, and the cause of the error can be quickly located in a complex environment, and various departments will not shirk their responsibilities in the collaborative process, which further improves the efficiency of the collaborative approval of various committees, offices, and bureaus.

在上述任一技术方案中,优选地,企业数据服务总线,还用于每隔第一预设时长进行一次轮询,查看是否有下发失败的业务数据,若有,则重新下发。In any of the above technical solutions, preferably, the enterprise data service bus is also used to perform polling every first preset time length to check whether there is any business data that fails to be delivered, and if so, to deliver it again.

在该技术方案中,企业数据服务总线每隔第一预设时长轮询一次,查看下发失败的业务数据,并重新下发,从而形成定时补发机制,避免业务数据下发失败,影响协同审批进度。In this technical solution, the enterprise data service bus polls every first preset time, checks the business data that failed to be delivered, and re-delivers, thereby forming a timing reissue mechanism, avoiding the failure of business data delivery and affecting collaboration Approval progress.

在上述任一技术方案中,优选地,审批单元,还用于将审批结果回写至对应的前置机数据库,并设置第二标示位的标识;企业数据服务总线,具体用于每隔第二预设时长进行一次轮询,读取各个前置机数据库中第二标示位的标识为第二预设标识的数据,根据约定标志,将审批结果回写至协同审批系统的数据库。In any of the above technical solutions, preferably, the approval unit is also used to write back the approval result to the corresponding front-end database, and set the identification of the second flag; the enterprise data service bus is specifically used to Perform one polling for two preset durations, read the data whose second flag is the second preset flag in each front-end database, and write back the approval result to the database of the collaborative approval system according to the agreed flag.

在该技术方案中,审批单元将审批结果回写至对应的前置机数据库中,并设置好回写标示位,具体包括第二标示位的标识和审批结果的约定标志,第二标识位的标识为第二预设标识时,表示业务数据已经被审批完毕,企业数据服务总线通过iETL每隔第二预设时长轮询一次,读取已被审批完毕的数据,并读取审批结果的约定标志,将对应的审批结果回写至协同审批系统的数据库中,进一步地,将审批结果显示在协同审批系统。本发明提供的协同审批系统,通过“企业数据服务总线+前置机数据库”这种模式,在结合iESB、IETL技术,可以高效的解决跨系统数据共享的问题,实现可扩展、数据可追溯、易排查错误数据。In this technical solution, the approval unit writes back the approval result to the corresponding front-end computer database, and sets the write-back flag, specifically including the second flag and the agreed mark of the approval result, the second flag When the flag is the second preset flag, it means that the business data has been approved. The enterprise data service bus polls once every second preset time length through iETL, reads the data that has been approved, and reads the agreement of the approval result mark, write back the corresponding approval result to the database of the collaborative approval system, and further display the approval result in the collaborative approval system. The collaborative approval system provided by the present invention can efficiently solve the problem of cross-system data sharing through the mode of "enterprise data service bus + front-end database" combined with iESB and IETL technologies, and realize scalability, data traceability, Easy to troubleshoot wrong data.

在上述任一技术方案中,优选地,审批结果包括以下任一项或其组合:是否通过、补交材料、补正材料。In any of the above technical solutions, preferably, the examination and approval results include any one or a combination of the following: whether to pass, supplementary materials, and supplementary materials.

在该技术方案中,审批单元在拿到待审批的业务数据后,进行审批,或者发现资料不全、资料有误,则发起补交材料、补正材料等业务流程,最后根据事先约定的标志,将审批结果回写至前置机数据库中。In this technical solution, the approval unit conducts the approval after obtaining the business data to be approved, or if the data is found to be incomplete or incorrect, it will initiate business processes such as supplementary submission of materials, supplementary materials, etc., and finally according to the previously agreed signs, the The approval results are written back to the front-end database.

在上述任一技术方案中,优选地,第一预设时长的范围:5至10分钟。In any of the above technical solutions, preferably, the first preset duration ranges from 5 to 10 minutes.

在该技术方案中,第一预设时长的范围为5至10分钟,但不限于此。In this technical solution, the range of the first preset duration is 5 to 10 minutes, but is not limited thereto.

在上述任一技术方案中,优选地,第二预设时长的范围:10分钟至20分钟。In any of the above technical solutions, preferably, the second preset duration ranges from 10 minutes to 20 minutes.

在该技术方案中,第二预设时长的范围为10分钟至20分钟,但不限于此。In this technical solution, the second preset duration ranges from 10 minutes to 20 minutes, but is not limited thereto.

在上述任一技术方案中,优选地,企业数据服务总线,还用于在接收业务数据的步骤之前,将预先设置好的下发数据表和回写数据表下发至各前置机数据库;下发数据表至少包括:第一标示位及其对应的标识、第二标示位及其对应的标识;回写数据表至少包括:第一标示位及其对应的标识、第二标示位及其对应的标识、审批结果及其对应的约定标志。In any of the above technical solutions, preferably, the enterprise data service bus is also used to send the pre-set delivery data table and write-back data table to each front-end database before the step of receiving business data; The issued data table at least includes: the first flag and its corresponding logo, the second flag and its corresponding logo; the write-back data table at least includes: the first flag and its corresponding logo, the second flag and its corresponding Corresponding logos, approval results and their corresponding agreed signs.

在该技术方案中,本发明的前期准备工作需要根据协同业务的情况,设计前置机数据库的表结构,给各委办局下发同一套数据表,包括从协同审批系统下发到各委办局的下发数据表,以及从各委办局上报到协同审批系统的回写数据表。每张表都有第一标示位及其对应的标识和第二标示位及其对应的标识,以约定数据已读和未读的标注规则;此外回写数据表中还包括审批结果,如审批通过、审批不通过、补齐材料等,以及审批结果对应的约定标志。例如,每张表都有JHFLAG_IN、JHFLAG_OUT回写标志字段,约定JHFLAG_IN=0,表示委办局没有读这条数据,JHFLAG_IN=1,表示委办局已消费了这条记录;JHFLAG_OUT=0表示协同审批系统还没有读取这条记录,JHFLAG_OUT=1表示企业服务总线已经消费了这条办理结果记录;本发明通过企业数据服务总线统一定义下发约定,各委办局遵守,通过标志数据状态来判断数据是否已经被消费,或是又发起了新的业务流程,极大提高了各委办局数据交换的效率。In this technical solution, the preparatory work of the present invention needs to design the table structure of the front-end computer database according to the situation of collaborative business, and issue the same set of data tables to all committees, offices, and bureaus, including sending them from the collaborative approval system to each committee. The data sheets issued by the offices and bureaus, as well as the write-back data sheets reported from the commissions, offices, and bureaus to the collaborative approval system. Each table has the first flag and its corresponding logo and the second flag and its corresponding logo to agree on the marking rules for data read and unread; in addition, the write-back data table also includes approval results, such as approval Approval, approval failure, supplementary materials, etc., as well as the agreed signs corresponding to the approval results. For example, each table has JHFLAG_IN and JHFLAG_OUT write-back flag fields. It is agreed that JHFLAG_IN=0 means that the Commission has not read this data; JHFLAG_IN=1 means that the Commission has consumed this record; JHFLAG_OUT=0 means collaboration The approval system has not read this record yet, and JHFLAG_OUT=1 indicates that the enterprise service bus has consumed this processing result record; the present invention uses the unified definition of the enterprise data service bus to issue the agreement, and all committees, offices and bureaus abide by it, and mark the data status to Judging whether the data has been consumed, or a new business process has been initiated, greatly improves the efficiency of data exchange between various committees, offices and bureaus.

在上述任一技术方案中,优选地,下发数据表还包括以下任一项或其组合:受理流水号、原业务流水号、审批事项编号、审批事项名称、规定办理时限、受理单位名称、申请单位编码、申请单位申请人名称、申请单位办结人名称、受理时间;回写数据表还包括以下任一项或其组合:受理流水号、原业务流水号、审批事项编号、办结人姓名、办结时间。In any of the above technical solutions, preferably, the issued data table further includes any one or a combination of the following: acceptance serial number, original business serial number, approval item number, approval item name, specified processing time limit, acceptance unit name, The code of the application unit, the name of the applicant of the application unit, the name of the person responsible for the application unit, and the time of acceptance; the write-back data sheet also includes any of the following items or a combination: acceptance serial number, original business serial number, approval item number, and completion person Name, closing time.

在该技术方案中,下发数据表包括但不限于以下任一项或其组合:受理流水号、原业务流水号、审批事项编号、审批事项名称、规定办理时限、受理单位名称、申请单位编码、申请单位申请人名称、申请单位办结人名称、受理时间;回写数据表包括但不限于以下任一项或其组合:受理流水号、原业务流水号、审批事项编号、办结人姓名、办结时间。通过设计同一套表结构,统一定义下发约定,各委办局遵守,使业务数据可追踪,复杂环境下可快速排查定位错误原因,各部门协同办理不会出现互相推卸责任。In this technical solution, the issued data sheet includes but is not limited to any of the following or a combination thereof: acceptance serial number, original business serial number, approval item number, approval item name, prescribed processing time limit, acceptance unit name, application unit code , the name of the applicant of the application unit, the name of the person responsible for the application unit, and the time of acceptance; the write-back data sheet includes but is not limited to any of the following or a combination: acceptance serial number, original business serial number, approval item number, and name of the person in charge , Closing time. By designing the same set of table structures, uniformly defining and issuing agreements, all commissions, offices and bureaus abide by it, so that business data can be traced, and the cause of positioning errors can be quickly checked in complex environments, and various departments will not shirk their responsibilities in coordination.

在上述任一技术方案中,优选地,前置机数据库为Mysql数据库。In any of the above technical solutions, preferably, the front-end database is a Mysql database.

在该技术方案中,前置机数据库为Mysql数据库,但不限于此。In this technical solution, the front-end database is a Mysql database, but not limited thereto.

本发明的附加方面和优点将在下面的描述部分中变得明显,或通过本发明的实践了解到。Additional aspects and advantages of the invention will become apparent in the description which follows, or may be learned by practice of the invention.

附图说明Description of drawings

本发明的上述和/或附加的方面和优点从结合下面附图对实施例的描述中将变得明显和容易理解,其中:The above and/or additional aspects and advantages of the present invention will become apparent and comprehensible from the description of the embodiments in conjunction with the following drawings, wherein:

图1示出了根据本发明的一个实施例的协同审批系统的示意图;FIG. 1 shows a schematic diagram of a collaborative approval system according to an embodiment of the present invention;

图2示出了根据本发明的一个具体实施例的协同审批系统的示意图。Fig. 2 shows a schematic diagram of a collaborative approval system according to a specific embodiment of the present invention.

具体实施方式Detailed ways

为了能够更清楚地理解本发明的上述目的、特征和优点,下面结合附图和具体实施方式对本发明进行进一步的详细描述。需要说明的是,在不冲突的情况下,本申请的实施例及实施例中的特征可以相互组合。In order to understand the above-mentioned purpose, features and advantages of the present invention more clearly, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments. It should be noted that, in the case of no conflict, the embodiments of the present application and the features in the embodiments can be combined with each other.

在下面的描述中阐述了很多具体细节以便于充分理解本发明,但是,本发明还可以采用其他不同于在此描述的其他方式来实施,因此,本发明的保护范围并不受下面公开的具体实施例的限制。In the following description, many specific details are set forth in order to fully understand the present invention. However, the present invention can also be implemented in other ways different from those described here. Therefore, the protection scope of the present invention is not limited by the specific details disclosed below. EXAMPLE LIMITATIONS.

如图1所示,根据本发明的一个实施例的协同审批系统的示意图。其中,该协同审批系统100,包括:As shown in FIG. 1 , it is a schematic diagram of a collaborative approval system according to an embodiment of the present invention. Wherein, the collaborative approval system 100 includes:

企业数据服务总线102,用于接收业务数据,将业务数据适配到相应的前置机数据库104,并将业务数据下发至相应的前置机数据库104;The enterprise data service bus 102 is used to receive business data, adapt the business data to the corresponding front-end database 104, and deliver the business data to the corresponding front-end database 104;

多个前置机数据库104,分别与企业数据服务总线102相连接,前置机数据库104用于接收并存储业务数据;A plurality of front-end databases 104 are respectively connected to the enterprise data service bus 102, and the front-end databases 104 are used to receive and store business data;

多个审批单元106,与多个前置机数据库104一一对应连接,审批单元106用于从对应的前置机数据库104中读取业务数据,以对业务数据进行审批。A plurality of approval units 106 are connected to a plurality of front-end databases 104 in one-to-one correspondence, and the approval unit 106 is used to read business data from the corresponding front-end database 104 to approve the business data.

本发明提供的协同审批系统100,企业数据服务总线102是构建基于面向服务体系结构SOA解决方案时所使用基础架构的关键部分,是由中间件技术实现并支持SOA的一组基础架构功能,它是由信息交换服务总线iESB和数iETL协同配合组成工作的。前置机数据库104是各协同审批部门(委办局)的数据库。通过企业数据服务总线102与各前置机数据库104相连接,所有与协同审批系统100相关的同步协同、适配下发、集成优化都是通过企业数据服务总线102总体调度。具体而言,用户通过网上办事大厅提交审批申请,协同审批系统100收件,待审批的业务数据进入协同审批系统100,附件进入文件系统,协同审批系统100调用企业数据服务总线102,接收到业务数据后,通过iESB将业务数据适配到所属部门,可能是一个部门,也可能是多个部门,并通过指定下发接口将业务数据推送到所属部门的前置机数据库104,通过与该前置机数据库104相连接的审批单元106读取业务数据,并对其进行审批。本发明提供的协同审批系统,通过“企业数据服务总线+前置机数据库”这种模式,实现了统一收件,跨系统分发、协同审批,极大提高了各委办局协同审批的效率,且各委办局有专门的数据库对接,避免数据量过大,系统性能得到保证,同时可扩展性高,如增加委办局,只需添加前置机数据库104即可,此外系统的耦合度基本没有,各委办局的系统的实现技术没有任何限制。In the collaborative approval system 100 provided by the present invention, the enterprise data service bus 102 is a key part of the infrastructure used when constructing SOA solutions based on service-oriented architecture, and is a group of infrastructure functions that are implemented by middleware technology and support SOA. It is composed of information exchange service bus iESB and digital iETL. The front-end database 104 is the database of each collaborative approval department (committee office). The enterprise data service bus 102 is connected to each front-end database 104 , and all synchronous collaboration, adaptation distribution, and integration optimization related to the collaborative approval system 100 are generally dispatched through the enterprise data service bus 102 . Specifically, the user submits an application for approval through the online service hall, and the collaborative approval system 100 receives the application. The business data to be approved enters the collaborative approval system 100, and the attachments enter the file system. The collaborative approval system 100 invokes the enterprise data service bus 102, and receives the business After the data is collected, the business data is adapted to the department through iESB, which may be one department or multiple departments, and the business data is pushed to the front-end database 104 of the department through the specified delivery interface. The approval unit 106 connected to the machine database 104 reads and approves business data. The collaborative approval system provided by the present invention realizes unified receipt, cross-system distribution, and collaborative approval through the mode of "enterprise data service bus + front-end database", which greatly improves the efficiency of collaborative approval by various committees, offices, and bureaus. In addition, each committee office has a dedicated database docking to avoid excessive data volume, guarantee system performance, and high scalability. If more committee offices are added, only the front-end database 104 needs to be added. In addition, the coupling degree of the system Basically none, there are no restrictions on the implementation technologies of the systems of various committees, offices and bureaus.

在本发明的一个实施例中,优选地,企业数据服务总线102,还用于在将业务数据下发至相应的前置机数据库104时,设置第一标示位的标识;审批单元106,还用于在对业务数据进行审批的步骤之前,判断第一标示位的标识是否为第一预设标识,若是,则对业务数据进行审批。In one embodiment of the present invention, preferably, the enterprise data service bus 102 is also used to set the identification of the first flag when sending the business data to the corresponding front-end database 104; the approval unit 106 is also Before the step of approving the business data, it is used to judge whether the identifier of the first flag is the first preset identifier, and if so, to approve the business data.

在该实施例中,将业务数据下发至所属部门的前置机数据库104,并设置第一标示位的标识,这样审批单元106在读取到业务数据后,便可根据第一标识的标识,来判断该业务数据是否已经被消费,或是企业数据服务总线102又发起了新的业务流程。具体来说,在第一标识位的标识为第一预设标识时,表示业务数据还未被消费,此时审批单元106可对业务数据进行审批,由此,可以避免重复审批,并使得业务数据可追踪,复杂环境下可快速定位错误原因,各部门协同办理不会出现互相推卸责任,进一步提高了各委办局协同审批的效率。In this embodiment, the business data is sent to the front-end database 104 of the department, and the identification of the first flag is set, so that after the approval unit 106 reads the business data, it can , to determine whether the business data has been consumed, or the enterprise data service bus 102 has initiated a new business process. Specifically, when the identifier of the first identifier is the first preset identifier, it means that the business data has not been consumed. At this time, the approval unit 106 can approve the business data, thereby avoiding repeated approval and making the business The data can be tracked, and the cause of the error can be quickly located in a complex environment. The collaborative handling of various departments will not cause each other to shirk their responsibilities, which further improves the efficiency of the collaborative approval of various committees, offices and bureaus.

在本发明的一个实施例中,优选地,企业数据服务总线102,还用于每隔第一预设时长进行一次轮询,查看是否有下发失败的业务数据,若有,则重新下发。In one embodiment of the present invention, preferably, the enterprise data service bus 102 is also used to perform polling every first preset time length to check whether there is any business data that failed to be delivered, and if so, to re-deliver .

在该实施例中,企业数据服务总线102每隔第一预设时长轮询一次,查看下发失败的业务数据,并重新下发,从而形成定时补发机制,避免业务数据下发失败,影响协同审批进度。In this embodiment, the enterprise data service bus 102 polls once every first preset time length, checks the business data that failed to be delivered, and re-delivers, thereby forming a timing reissue mechanism, avoiding the failure of delivering business data and affecting Coordinate approval progress.

在本发明的一个实施例中,优选地,审批单元106,还用于将审批结果回写至对应的前置机数据库104,并设置第二标示位的标识;企业数据服务总线102,具体用于每隔第二预设时长进行一次轮询,读取各个前置机数据库104中第二标示位的标识为第二预设标识的数据,根据约定标志,将审批结果回写至协同审批系统的数据库。In one embodiment of the present invention, preferably, the approval unit 106 is also used to write back the approval result to the corresponding front-end database 104, and set the identification of the second flag; the enterprise data service bus 102 is specifically used to Carry out polling every second preset time length, read the data whose second flag in each front-end processor database 104 is the second preset flag, and write back the approval result to the collaborative approval system according to the agreed flag database.

在该实施例中,审批单元106将审批结果回写至对应的前置机数据库104中,并设置好回写标示位,具体包括第二标示位的标识和审批结果的约定标志,第二标识位的标识为第二预设标识时,表示业务数据已经被审批完毕,企业数据服务总线102通过iETL每隔第二预设时长轮询一次,读取已被审批完毕的数据,并读取审批结果的约定标志,将对应的审批结果回写至协同审批系统的数据库中,进一步地,将审批结果显示在协同审批系统。本发明提供的协同审批系统100通过“企业数据服务总线+前置机数据库”这种模式,在结合iESB、IETL技术,可以高效的解决跨系统数据共享的问题,实现可扩展、数据可追溯、易排查错误数据。In this embodiment, the approval unit 106 writes back the approval result to the corresponding front-end processor database 104, and sets the write-back flag, specifically including the second flag and the agreed flag of the approval result, the second flag When the flag of the bit is the second preset flag, it means that the business data has been approved, and the enterprise data service bus 102 polls once every second preset time length through iETL, reads the data that has been approved, and reads the approved data. The agreed sign of the result writes back the corresponding approval result to the database of the collaborative approval system, and further displays the approval result in the collaborative approval system. The collaborative approval system 100 provided by the present invention can efficiently solve the problem of cross-system data sharing through the mode of "enterprise data service bus + front-end database" combined with iESB and IETL technologies, and realize scalability, data traceability, Easy to troubleshoot wrong data.

在本发明的一个实施例中,优选地,审批结果包括以下任一项或其组合:是否通过、补交材料、补正材料。In an embodiment of the present invention, preferably, the approval result includes any one or a combination of the following: whether to pass, supplementary materials, supplementary materials.

在该实施例中,审批单元106在拿到待审批的业务数据后,进行审批,或者发现资料不全、资料有误,则发起补交材料、补正材料等业务流程,最后根据事先约定的标志,将审批结果回写至前置机数据库104中。In this embodiment, after obtaining the business data to be approved, the approval unit 106 conducts the approval, or finds that the data is incomplete or incorrect, and then initiates business processes such as supplementary submission of materials, supplementary materials, etc., and finally according to the pre-agreed sign, Write back the approval result to the front-end database 104.

在本发明的一个实施例中,优选地,第一预设时长的范围:5至10分钟。In an embodiment of the present invention, preferably, the first preset duration ranges from 5 to 10 minutes.

在该实施例中,第一预设时长的范围为5至10分钟,但不限于此。In this embodiment, the first preset duration ranges from 5 to 10 minutes, but is not limited thereto.

在本发明的一个实施例中,优选地,第二预设时长的范围:10分钟至20分钟。In an embodiment of the present invention, preferably, the second preset duration ranges from 10 minutes to 20 minutes.

在该实施例中,第二预设时长的范围为10分钟至20分钟,但不限于此。In this embodiment, the second preset duration ranges from 10 minutes to 20 minutes, but is not limited thereto.

在本发明的一个实施例中,优选地,企业数据服务总线102,还用于在接收业务数据的步骤之前,将预先设置好的下发数据表和回写数据表下发至各前置机数据库104;下发数据表至少包括:第一标示位及其对应的标识、第二标示位及其对应的标识;回写数据表至少包括:第一标示位及其对应的标识、第二标示位及其对应的标识、审批结果及其对应的约定标志。In one embodiment of the present invention, preferably, the enterprise data service bus 102 is also used to deliver the pre-set delivery data table and write-back data table to each front-end processor before the step of receiving business data Database 104; the issued data table at least includes: the first flag and its corresponding logo, the second flag and its corresponding logo; the write-back data table at least includes: the first flag and its corresponding logo, the second flag bit and its corresponding identification, approval result and its corresponding agreed sign.

在该实施例中,本发明的前期准备工作需要根据协同业务的情况,设计前置机数据库104的表结构,给各委办局下发同一套数据表,包括从协同审批系统100到各委办局的下发数据表,以及从各委办局上报到协同审批系统100的回写数据表。每张表都有第一标示位及其对应的标识和第二标示位及其对应的标识,以约定数据已读和未读的标注规则;此外回写数据表中还包括审批结果,如审批通过、审批不通过、补齐材料等,以及审批结果对应的约定标志。例如,每张表都有JHFLAG_IN、JHFLAG_OUT回写标志字段,约定JHFLAG_IN=0,表示委办局没有读这条数据,JHFLAG_IN=1,表示委办局已消费了这条记录;JHFLAG_OUT=0表示协同审批系统还没有读取这条记录,JHFLAG_OUT=1表示企业服务总线已经消费了这条办理结果记录;本发明通过企业数据服务总线102统一定义下发约定,各委办局遵守,通过标志数据状态来判断数据是否已经被消费,或是又发起了新的业务流程,极大提高了各委办局数据交换的效率。In this embodiment, the preparatory work of the present invention needs to design the table structure of the front-end computer database 104 according to the situation of the collaborative business, and issue the same set of data tables to each committee, office and bureau, including from the collaborative approval system 100 to each committee. The data sheet issued by the office and bureau, and the write-back data sheet reported to the collaborative approval system 100 by each committee, office, and bureau. Each table has the first flag and its corresponding logo and the second flag and its corresponding logo to agree on the marking rules for data read and unread; in addition, the write-back data table also includes approval results, such as approval Approval, approval failure, supplementary materials, etc., as well as the agreed signs corresponding to the approval results. For example, each table has JHFLAG_IN and JHFLAG_OUT write-back flag fields. It is agreed that JHFLAG_IN=0 means that the Commission has not read this data; JHFLAG_IN=1 means that the Commission has consumed this record; JHFLAG_OUT=0 means collaboration The approval system has not read this record, and JHFLAG_OUT=1 indicates that the enterprise service bus has consumed this processing result record; the present invention uniformly defines and issues agreements through the enterprise data service bus 102, and all committees, offices and bureaus abide by it, and pass the flag data status To judge whether the data has been consumed, or a new business process has been initiated, which greatly improves the efficiency of data exchange between various committees, offices and bureaus.

在本发明的一个实施例中,优选地,下发数据表还包括以下任一项或其组合:受理流水号、原业务流水号、审批事项编号、审批事项名称、规定办理时限、受理单位名称、申请单位编码、申请单位申请人名称、申请单位办结人名称、受理时间;回写数据表还包括以下任一项或其组合:受理流水号、原业务流水号、审批事项编号、办结人姓名、办结时间。In one embodiment of the present invention, preferably, the issued data table also includes any one or a combination of the following: acceptance serial number, original business serial number, approval item number, approval item name, specified processing time limit, and acceptance unit name , the code of the application unit, the name of the applicant of the application unit, the name of the person responsible for the application unit, and the time of acceptance; the write-back data sheet also includes any of the following items or a combination: acceptance serial number, original business serial number, approval item number, settlement The name of the person and the closing time.

在该实施例中,下发数据表包括但不限于以下任一项或其组合:受理流水号、原业务流水号、审批事项编号、审批事项名称、规定办理时限、受理单位名称、申请单位编码、申请单位申请人名称、申请单位办结人名称、受理时间;回写数据表包括但不限于以下任一项或其组合:受理流水号、原业务流水号、审批事项编号、办结人姓名、办结时间。通过设计同一套表结构,统一定义下发约定,各委办局遵守,使业务数据可追踪,复杂环境下可快速排查定位错误原因,各部门协同办理不会出现互相推卸责任。In this embodiment, the issued data table includes but is not limited to any of the following or a combination thereof: acceptance serial number, original business serial number, approval item number, approval item name, prescribed processing time limit, acceptance unit name, application unit code , the name of the applicant of the application unit, the name of the person responsible for the application unit, and the time of acceptance; the write-back data sheet includes but is not limited to any of the following or a combination: acceptance serial number, original business serial number, approval item number, and name of the person in charge , Closing time. By designing the same set of table structures, uniformly defining and issuing agreements, all commissions, offices and bureaus abide by it, so that business data can be traced, and the cause of positioning errors can be quickly checked in complex environments, and various departments will not shirk their responsibilities in coordination.

在本发明的一个实施例中,优选地,前置机数据库104为Mysql数据库。In an embodiment of the present invention, preferably, the front-end database 104 is a Mysql database.

在该实施例中,前置机数据库104为Mysql数据库,但不限于此。In this embodiment, the front-end database 104 is a Mysql database, but it is not limited thereto.

具体实施例,如图2所示,提供了一种协同审批系统,包括:预审单元、企业数据服务总线、四个前置机数据库、四个委办局系统。A specific embodiment, as shown in FIG. 2 , provides a collaborative approval system, including: a pre-examination unit, an enterprise data service bus, four front-end databases, and four commissioning and bureau systems.

其中,企业数据服务总线是构建基于面向服务体系结构SOA解决方案时所使用基础架构的关键部分,是由中间件技术实现并支持SOA的一组基础架构功能,它是由iESB和iETL协同配合组成工作的。前置机数据库是各居委办系统的Mysql数据库。协同审批系统通过企业数据服务总线与其它四个委办局系统相连,所有与协同审批系统相关的同步协同、适配下发、集成优化都是通过企业数据服务总线总体调度。企业数据服务总线通过iESB事件驱动、轮询等方式驱动数据下发(从协同审批系统下发到各委办局)和上报(从各委办局上报到协同审批系统),数据清洗、转换、加载通过iETL实现,iETL又由企业数据服务总线调度。Among them, the enterprise data service bus is a key part of the infrastructure used when building SOA solutions based on service-oriented architecture. It is a set of infrastructure functions implemented by middleware technology and supports SOA. It is composed of iESB and iETL. work. The front-end computer database is the Mysql database of each neighborhood committee office system. The collaborative approval system is connected to the other four commissioning and bureau systems through the enterprise data service bus. All synchronous collaboration, adaptation and distribution, and integration optimization related to the collaborative approval system are all dispatched through the enterprise data service bus. The enterprise data service bus drives data delivery (from the collaborative approval system to the committees, offices and bureaus) and reporting (from the committees, offices and bureaus to the collaborative approval system) through iESB event-driven, polling, etc., data cleaning, conversion, Loading is achieved through iETL, which in turn is dispatched by the Enterprise Data Service Bus.

本发明实施例的前期准备工作需要根据协同业务需要,指定下发和上报的接口。根据业务的情况,设计前置机数据库的表结构,给各个委办局下发同一套数据库表。每张表都有JHFLAG_IN、JHFLAG_OUT回写标志字段,约定JHFLAG_IN=0,表示委办局没有读这条数据,JHFLAG_IN=1,表示委办局已消费了这条记录;JHFLAG_OUT=0表示协同审批系统还没有读取这条记录,JHFLAG_OUT=1表示企业服务总线已经消费了这条办理结果记录,统一定义下发约定,各委办局遵守,通过标志数据状态来判断数据是否已经被消费,或是又发起了新的业务流程。如下协同审批系统下发数据表、各委办局审批系统回写数据表:The preparatory work of the embodiment of the present invention needs to designate an interface for sending and reporting according to the needs of collaborative services. According to the business situation, design the table structure of the front-end computer database, and issue the same set of database tables to each committee, office and bureau. Each table has JHFLAG_IN and JHFLAG_OUT write-back flag fields. It is agreed that JHFLAG_IN=0 means that the committee has not read this data; JHFLAG_IN=1 means that the committee has consumed this record; JHFLAG_OUT=0 means that the collaborative approval system This record has not been read yet, JHFLAG_OUT=1 indicates that the enterprise service bus has consumed this processing result record, and the unified definition of the distribution agreement, all committees, offices and bureaus abide by it, and judge whether the data has been consumed by marking the data status, or A new business process was initiated. The following collaborative approval system will issue data sheets, and the approval systems of various committees, offices and bureaus will write back the data sheets:

表1下发数据表Table 1 Release data table

表2回写数据表Table 2 write back data table

协同审批业务具体实现方案如下:The specific implementation plan of the collaborative approval business is as follows:

1、用户通过网上办事大厅提交审批申请,预审单元收件,并对其进行预审,预审通过后,业务数据进入协同审批系统的数据库,附件进入文件系统;1. The user submits an approval application through the online service hall, and the pre-examination unit receives the application and conducts a pre-examination. After the pre-examination is passed, the business data enters the database of the collaborative approval system, and the attachment enters the file system;

2、协同审批系统调用企业数据服务总线iESB接口,通过iESB将业务数据适配到所属部门,通过下发接口将业务数据推送到对应的委办局前置机数据库,并设置好标示位,将收件信息下发到委办局的前置机;2. The collaborative approval system calls the iESB interface of the enterprise data service bus, adapts the business data to the department through the iESB, pushes the business data to the corresponding front-end computer database of the committee, office, and bureau through the delivery interface, and sets the marking bit, and the The receiving information is sent to the front-end computer of the commission office;

3、各委办局系统到各自对应的前置机读取待审批事项,然后进行审批,或者发现资料不全,发起补交材料、补齐补正等业务,最后将结果回写到前置机,并设置好标示位;3. Each committee, office and bureau system reads the items to be approved from their corresponding front-end computers, and then approves them, or if they find that the materials are incomplete, they initiate businesses such as resubmitting materials, supplementing and correcting, etc., and finally write the results back to the front-end computers. And set the flag position;

4、企业数据服务总线通过iETL每5分钟轮询读取各委办局的前置机,读取JHFLAG_OUT=0的数据,企业服务总线通过约定的标志,判断数据是审批结果、补交材料、补齐补正,回写到协同审批系统数据库,显示在协同审批系统;4. The enterprise data service bus polls and reads the front-end processors of all committees, offices and bureaus through iETL every 5 minutes, reads the data of JHFLAG_OUT=0, the enterprise service bus passes the agreed flag, and judges that the data is the result of approval, supplementary materials, Complete the corrections, write back to the collaborative approval system database, and display in the collaborative approval system;

5、企业数据服务总线iESB每10分钟轮询一次,查看下发失败的数据,重新下发。5. The enterprise data service bus iESB polls once every 10 minutes, checks the data that failed to be delivered, and sends it again.

自此,业务数据实现了一个流程,如图2所示。Since then, business data has implemented a process, as shown in Figure 2.

相对于现有技术本发明具有如下有益效果:Compared with the prior art, the present invention has the following beneficial effects:

1、极大提高了各委办局数据交换的效率,各委办局有专门的数据库对接,数据量不会太大,性能得到保证;1. Greatly improved the efficiency of data exchange between committees, offices and bureaus. Each committee, office, and bureau has a dedicated database connection, the amount of data will not be too large, and the performance is guaranteed;

2、数据可追踪,复杂环境下可快速排查定位错误原因,各部门协同办理不会出现互相推卸责任。另外数据下发失败有定时补发机制;2. The data can be traced, and the cause of positioning errors can be quickly checked in a complex environment, and the coordination of various departments will not cause each other to shirk responsibility. In addition, if the data delivery fails, there is a timing reissue mechanism;

3、系统的耦合度基本没有,各委办局的系统的实现技术没有任何限制;3. There is basically no coupling degree of the system, and there are no restrictions on the implementation technology of the system of various committees and bureaus;

4、可扩展性高,如增加委办局,只需添加数据库前置机即可。4. High scalability. If you add more committees and bureaus, you only need to add a database front-end processor.

在本发明中,术语“第一”、“第二”仅用于描述的目的,而不能理解为指示或暗示相对重要性;术语“多个”表示两个或两个以上。对于本领域的普通技术人员而言,可以根据具体情况理解上述术语在本发明中的具体含义。In the present invention, the terms "first" and "second" are only used for the purpose of description, and should not be understood as indicating or implying relative importance; the term "plurality" means two or more. Those of ordinary skill in the art can understand the specific meanings of the above terms in the present invention according to specific situations.

以上所述仅为本发明的优选实施例而已,并不用于限制本发明,对于本领域的技术人员来说,本发明可以有各种更改和变化。凡在本发明的精神和原则之内,所作的任何修改、等同替换、改进等,均应包含在本发明的保护范围之内。The above descriptions are only preferred embodiments of the present invention, and are not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and changes. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principles of the present invention shall be included within the protection scope of the present invention.

Claims (10)

1. a kind of collaboration approval system characterized by comprising
The business datum is fitted to corresponding front end processor database for receiving business datum by business data service bus, And the business datum is issued to corresponding front end processor database;
Multiple front end processor databases, are connected with the business data service bus respectively, and the front end processor database is used In receiving and storing the business datum;
Multiple examination & approval units connect one to one with multiple front end processor databases, and the examination & approval unit is used for from corresponding The business datum is read in front end processor database, to examine to the business datum.
2. collaboration approval system according to claim 1, which is characterized in that
The business data service bus is also used to the business datum being issued to corresponding front end processor database When, the mark of the first mark of setting position;
The examination & approval unit, was also used to before the step of examining to the business datum, judged first mark position Identify whether as the first default mark, if so, being examined to the business datum.
3. collaboration approval system according to claim 1, which is characterized in that
The business data service bus is also used to carry out a poll every the first preset duration, has checked whether to issue mistake The business datum lost, if so, then re-issuing.
4. collaboration approval system according to claim 1, which is characterized in that
The examination & approval unit is also used to for approval results being written back to corresponding front end processor database, and the second mark position is arranged Mark;
The business data service bus, be specifically used for every the second preset duration carry out a poll, read it is each it is described before The data for being identified as the second default mark for setting the second mark position described in machine database, according to promissory marker, by the examination & approval As a result it is written back to the database of the collaboration approval system.
5. collaboration approval system according to claim 4, which is characterized in that
Whether the approval results include any one of following or combinations thereof: passing through, hand in material, correction material retroactively.
6. collaboration approval system according to claim 3, which is characterized in that
The range of first preset duration: 5 to 10 minutes.
7. collaboration approval system according to claim 4, which is characterized in that
The range of second preset duration: 10 minutes to 20 minutes.
8. collaboration approval system according to any one of claim 1 to 7, which is characterized in that
The business data service bus will be pre-set down before being also used to the reception business datum the step of Hair tables of data and write-back table are issued to each front end processor database;
It is described to issue tables of data and include at least: the first mark position and its corresponding mark, the second mark position and its corresponding mark Know;
The write-back table includes at least: first mark position and its it is corresponding mark, second mark position and its it is corresponding mark, Approval results and its corresponding promissory marker.
9. collaboration approval system according to claim 8, which is characterized in that
The tables of data that issues further includes any one of following or combinations thereof: accepting serial number, former business serial number, examination and approval procedure and compiles Number, examination and approval procedure title, regulation handle the time limit, accept organization, applying unit coding, applying unit's applicant's title, Shen Please unit finish name claim, handling time;
The write-back table further includes any one of following or combinations thereof: accepting serial number, former business serial number, examination and approval procedure and compiles Number, finish people's name, finish the time.
10. collaboration approval system according to any one of claim 1 to 7, which is characterized in that
The front end processor database is Mysql database.
CN201910487311.8A 2019-06-05 2019-06-05 Cooperate with approval system Pending CN110348803A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910487311.8A CN110348803A (en) 2019-06-05 2019-06-05 Cooperate with approval system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910487311.8A CN110348803A (en) 2019-06-05 2019-06-05 Cooperate with approval system

Publications (1)

Publication Number Publication Date
CN110348803A true CN110348803A (en) 2019-10-18

Family

ID=68181537

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910487311.8A Pending CN110348803A (en) 2019-06-05 2019-06-05 Cooperate with approval system

Country Status (1)

Country Link
CN (1) CN110348803A (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111553663A (en) * 2020-05-06 2020-08-18 中建材信息技术股份有限公司 A workflow-based automated collaborative approval system and method
CN112365234A (en) * 2020-11-10 2021-02-12 中国平安人寿保险股份有限公司 Sign-up approval management method and device and electronic equipment
CN112862445A (en) * 2021-02-22 2021-05-28 浪潮云信息技术股份公司 High-concurrency data exchange processing method and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2004199599A (en) * 2002-12-20 2004-07-15 Sumitomo Chem Co Ltd Analysis work order / report method, server and program, and analysis work request / report system
US20120143634A1 (en) * 2010-12-02 2012-06-07 American International Group, Inc. Systems, Methods, and Computer Program Products for Processing Insurance Claims
CN105787633A (en) * 2014-12-26 2016-07-20 远光软件股份有限公司 System and method for processing concurrent examining and approving flow
CN109087004A (en) * 2018-08-03 2018-12-25 北京东软望海科技有限公司 A kind of public workflow engine system based on domain model

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2004199599A (en) * 2002-12-20 2004-07-15 Sumitomo Chem Co Ltd Analysis work order / report method, server and program, and analysis work request / report system
US20120143634A1 (en) * 2010-12-02 2012-06-07 American International Group, Inc. Systems, Methods, and Computer Program Products for Processing Insurance Claims
CN105787633A (en) * 2014-12-26 2016-07-20 远光软件股份有限公司 System and method for processing concurrent examining and approving flow
CN109087004A (en) * 2018-08-03 2018-12-25 北京东软望海科技有限公司 A kind of public workflow engine system based on domain model

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
佟文娟: "基于J2EE的税企互动平台的设计与实现", 中国优秀硕士学位论文全文数据库信息科技辑, no. 03, 15 March 2017 (2017-03-15), pages 138 - 3244 *
石波: "电子政务数据交换系统的设计与实现", 中国优秀硕士学位论文全文数据库 信息科技辑, no. 02, 15 February 2012 (2012-02-15), pages 138 - 1071 *

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111553663A (en) * 2020-05-06 2020-08-18 中建材信息技术股份有限公司 A workflow-based automated collaborative approval system and method
CN112365234A (en) * 2020-11-10 2021-02-12 中国平安人寿保险股份有限公司 Sign-up approval management method and device and electronic equipment
CN112862445A (en) * 2021-02-22 2021-05-28 浪潮云信息技术股份公司 High-concurrency data exchange processing method and storage medium

Similar Documents

Publication Publication Date Title
CN102903171B (en) Self-service type intelligent entering checking invoice processing system and method
CN110348803A (en) Cooperate with approval system
CN104299152A (en) Client management information system
EP1332430A2 (en) Sytems and methods for providing centralized management of heterogeneous distributed enterprise application integration objects
CN101977164B (en) Data interactive method and system in SaaS mode
CN112070452A (en) Distributed workflow management system
CN105159873A (en) Online patent drafting business processing system
CN105094959A (en) Method and device for providing account checking document
CN110782223A (en) General workflow device of OA system and general workflow implementation method
CN106951341A (en) A kind of database backup method for realizing distributed structure/architecture
CN103729455A (en) Master data storage method based on primary copy storage pattern
CN101996235A (en) Report submitting method and device
CN112231401A (en) A blockchain-based model management method and device
CN118689862A (en) Heterogeneous database data migration method, device, equipment and storage medium
CN110852700A (en) Data sorting method and device for workflow system
CN205176938U (en) Professional worker's single electron real time transport system of power consumption
CN115713313A (en) Temporary work account management method, temporary work management system and management method
CN111754184A (en) Cross-enterprise workflow control method, system, device, and storage medium
TWI490794B (en) Purchasing management system and its management method
CN114693082A (en) Power plant equipment defect management method and system, data processing equipment and storage medium
CN115775188A (en) Asset financial integrated system
CN107230162A (en) Equipment alteration treating method and apparatus based on production management system
US20240242144A1 (en) System and method of undoing data based on data flow management
US12164975B2 (en) Federated distributed mutation
CN121147353A (en) Conference certificate intelligent generation method, system and device based on dynamic template positioning technology

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
WD01 Invention patent application deemed withdrawn after publication

Application publication date: 20191018

WD01 Invention patent application deemed withdrawn after publication