CN110362555A - Workflow form control method - Google Patents
Workflow form control method Download PDFInfo
- Publication number
- CN110362555A CN110362555A CN201910576761.4A CN201910576761A CN110362555A CN 110362555 A CN110362555 A CN 110362555A CN 201910576761 A CN201910576761 A CN 201910576761A CN 110362555 A CN110362555 A CN 110362555A
- Authority
- CN
- China
- Prior art keywords
- workflow
- control
- name
- identification code
- collection
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
Abstract
The present invention relates to a kind of workflow form control method, following steps: 1, Establishing process step table in the database；2, Establishing process circulation table；3, it is defined according to preset workflow form control design rule, carry out newly-increased control and deletes the name of control；4, process step configuration information is read from process step table according to work process flow identification code, updates the corresponding form controls information of step；5, the step identification code in the work process flow identification code of locating intermediate links, work process flow is submitted into database, database reads corresponding workflow form control name collection from the process step table that step 1 is established；6, control name is converted into the specific control of workflow form, and carries out the conversion of workflow form control type, realize the control of workflow form permission；It is not necessary to modify program, the easier realization workflow forms of energy arbitrarily to change by the present invention.
Description
Technical field
The present invention relates to field of computer technology, and in particular to a kind of workflow form control method.
Background technique
With the development in computer internet epoch, more and more enterprises carry out auxiliary enterprises operation and development using workflow,
All internal affairs of business processes are helped, realize various examination and approval works.However enterprise is with the development of business, its corresponding business
Process tends to occur change, but in workflow development design, due to workflow form and operation flow be it is one-to-one,
So process changes the variation that bring therewith is exactly workflow form format and content.So designed in traditional exploitation
In, the additions and deletions of the change especially content of workflow form often bring the variation of back-end data, are typically necessary software development
Personnel are solved by re-encoding, this brings big inconvenience to the use in system later period and maintenance personnel, it is therefore desirable to
It is a kind of it is not necessary to modify program, be easier to realize the list control method arbitrarily changed of list.
Summary of the invention
Present invention aim to provide a kind of workflow form control method, the present invention it is not necessary to modify program, can be more
Readily realize that workflow form is arbitrarily changed.
In order to solve the above technical problems, workflow form control method designed by the present invention, which is characterized in that it includes
Following steps:
Step 1: Establishing process step table in the database first, process step table for realizing workflow step with it is right
Answer can operation element stream form controls name binding, field includes work process flow identification code, work in process step table
Flow process in step identification code, step is associated can operation element stream form controls name collection；
Step 2: Establishing process circulation table in the database, workflow table are used to deposit the workflow table read during circulation
Forms data, field includes work process flow identification code, the step identification code in work process flow, step in the workflow table
Rapid associated control data collection；
Step 3: when workflow form is modified, being defined, increased newly according to preset workflow form control design rule
Control and the name for deleting control；
Step 4: by workflow form information collocation module, being established from step 1 according to work process flow identification code
Process step configuration information is read in process step table, updating the corresponding form controls information of step is modified newest shape
State, and submit in the process step table established in 1；
Step 5: workflow engine reads the workflow stream of the process identification code of some workflow instance, locating intermediate links
Journey step identification code, and submit to database, reads that process step is corresponding to be operated from the process step table that step 1 is established
Then workflow form control name collection reads all circulation letters of the workflow instance from the workflow table that step 2 is established
Breath collection；
Step 6: the workflow table that list control logic layer transmits in traversal step 5 in the top level container of workflow form
Single control name collection, according to the preset workflow form control design rule in step 3, carries out workflow in ergodic process
Control name can be converted into the specific control of workflow form, is set as to these form controls by the identification of form controls type
It can operating right；
Step 7: the retrieval of form data is presented then according to the workflow information collection transmitted in step 5, compare step 6 into
Conversion of the row control name to form controls, the assignment of ergodic flow transfering the letter breath collection and control collection progress form controls；
Step 8: page table list is finally presented according to step 6, the output result of step 7；
Step 9: the form data during workflow circulation, which saves, to be submitted, and realizes turning for control by step 5, step 6
After changing, list control logic layer reads the control content of forms pages, and control collection data are formed a word by connector
String form is accorded with, workflow engine is submitted to and carries out being saved in the workflow table transmitted established in database steps 2.
Beneficial effects of the present invention:
The list control method provided by the invention realizes that list can arbitrarily be altered without modification program with business, mentions
High list control development efficiency and later maintenance efficiency.
Detailed description of the invention
Fig. 1 be the present invention relates to database process step table design；
Fig. 2 be the present invention relates to database workflow table design；
Fig. 3 is that form controls controls implementation process schematic diagram in the present invention.
Specific embodiment
Below in conjunction with the drawings and specific embodiments, the present invention is described in further detail:
A kind of workflow form control method (such as hot rolling quality Accident Analysis rectifying and improving flow table list) that the present invention designs,
It includes the following steps:
Step 1: as shown in Figure 1, Establishing process step table in the database first, process step table is for realizing workflow
Journey step with it is corresponding can operation element stream form controls name binding, field includes that work process flow is known in process step table
Step identification code, step in other code, work process flow are associated can operation element stream form controls name collection；(multiple control names
Between with separator separate, such as ", ")；
Step 2: as shown in Fig. 2, Establishing process circulation table, workflow table read circulation process for depositing in the database
Workflow table forms data in (referring to after having initiated a workflow, specific each node handles process), the workflow
Field includes work process flow identification code, the step identification code in work process flow, the associated control data collection of step in table
(being separated between multiple control contents with separator, such as " | ")；
Step 3: when workflow form is modified, being defined, increased newly according to preset workflow form control design rule
Control and the name for deleting control, such as newly-increased TextBox control are named as txb_xxxx, and DropDownList control is named as
Ddl_xxxx, the TextBox control for needing to delete are named as Hide_txb_xxxx etc.；
Step 4: by workflow form information collocation module, being established from step 1 according to work process flow identification code
Process step configuration information is read in process step table, updating the corresponding form controls information of step is modified newest shape
State, and submit in the process step table established in 1；
Step 5: specific list control as shown in figure 3, workflow engine read some workflow instance process identification code,
The work process flow step identification code of locating intermediate links (the processing node in workflow process), and submit to data
Operating for process step corresponding (referring to step locating for present workflow) is read in library from the process step table that step 1 is established
Workflow form control name collection (which step circulation arrives, and just reads the corresponding control information of which step), then builds from step 2
All circulation information collection of the workflow instance are read in vertical workflow table；
Step 6: the workflow table that list control logic layer transmits in traversal step 5 in the top level container of workflow form
Single control name collection, according to the preset workflow form control design rule in step 3, carries out workflow in ergodic process
Control name can be converted into the specific control of workflow form, is set as to these form controls by the identification of form controls type
It can operating right；
Step 7: the retrieval of form data is presented then according to the workflow information collection transmitted in step 5, compare step 6 into
Conversion of the row control name to form controls, the assignment of ergodic flow transfering the letter breath collection and control collection progress form controls；
Step 8: page table list is finally presented according to step 6, the output result of step 7；
Step 9: the form data during workflow circulation, which saves, to be submitted, and realizes turning for control by step 5, step 6
After changing, list control logic layer reads the control content of forms pages, and control collection data are formed a word by connector
String form is accorded with, workflow engine is submitted to and carries out being saved in the workflow table transmitted established in database steps 2.
Preset workflow form control design rule is determined according to control type in the step 3 of above-mentioned technical proposal,
And it is indicated with tri-bit encoding.
In the step 4 of above-mentioned technical proposal, the process step configuration information arrives form controls for realizing control name
Conversion, and then realize operation control.
In the present invention, the definition of form controls design rule, including form controls naming rule and initialization.Define control life
Name rule, it is therefore an objective to realize automatic identification control type, and then realize the mapping of control name to form controls；Secondly all lists
Control is initialized as down state.Specially list increases control naming rule: control type (being indicated with 3)+newly " _ "+control
Part name, is txb_xxxx for text box TextBox control Uniform Name, and drop-down list box DropDownList control is then named
For ddl_xxxx etc..
Form information configuration module, realize form controls name and work process flow step binding, if step correspond to it is multiple
Control is distinguished with separator " | ".When list content changes, the list is read first and corresponds to work process flow configuration information,
Then corresponding newly-increased deletion control name is respectively filled in column in configuration module newly-increased delete, program will automatically update workflow
The form controls name information of process step binding.
Form logic control middleware includes the realization of form controls operating right and data access control.Form controls behaviour
Processing people controls the operating right of list during making the main realization circulation of permission control, and method is according to existing during circulating
The process step at place reads form controls name corresponding in process step table, is then carried out according to form controls name to list
Control visiting judges control type further according to control naming rule in the definition of form controls design rule, completes control name to table
Corresponding control priority assignation is finally that can operate by the conversion of single control part.The control of form controls data access is accomplished that stream
The submission of form controls data is saved during turning controls with retrieval.Data access control include form controls data preservation and
The reading of form controls data.The store method of form controls data is according to the process step now located in operational process, judgement
Manipulable form controls, read it is all can operational controls data and pass through connector " | " they are connected into a word
Symbol string, submission are saved in workflow circulation process table；And the reading of form controls data is then to read institute by circulation odd numbers
There is the control of bills data and the binding of each process step in workflow circulation process table, the corresponding control of assignment is split according to rule
Part realizes that the retrieval of data is shown.
The content that this specification is not described in detail belongs to the prior art well known to professional and technical personnel in the field.
Claims (6)
1. a kind of workflow form control method, which is characterized in that it includes the following steps:
Step 1: Establishing process step table in the database first, process step table for realizing workflow step with it is corresponding
Can operation element stream form controls name binding, field includes work process flow identification code, workflow stream in process step table
Step identification code, step in journey are associated can operation element stream form controls name collection；
Step 2: Establishing process circulation table in the database, workflow table are used to deposit the workflow table odd number during reading circulation
According to field includes work process flow identification code, the step identification code in work process flow, step pass in the workflow table
The control data collection of connection；
Step 3: when workflow form is modified, being defined according to preset workflow form control design rule, carry out newly-increased control
With the name for deleting control；
Step 4: by workflow form information collocation module, the process established from step 1 according to work process flow identification code
Process step configuration information is read in step table, updating the corresponding form controls information of step is modified last state, and
It submits in the process step table established in 1；
Step 5: workflow engine reads the process identification code of some workflow instance, the work process flow step of locating intermediate links
Rapid identification code, and submit to database, reading that process step is corresponding from the process step table that step 1 is established can operation element
Form controls name collection is flowed, then reads all circulation information collection of the workflow instance from the workflow table that step 2 is established；
Step 6: the workflow table single control that list control logic layer transmits in traversal step 5 in the top level container of workflow form
Part name collection, according to the preset workflow form control design rule in step 3, carries out workflow form in ergodic process
Control name, can be converted into the specific control of workflow form by the identification of control type, be set as to grasp to these form controls
Make permission.
2. workflow form control method according to claim 1, it is characterised in that: further include step after the step 6
7: the retrieval of form data is presented then according to the workflow information collection transmitted in step 5, is compareed step 6 and is carried out control name to table
The conversion of single control part, ergodic flow transfering the letter breath collection and control collection carry out the assignment of form controls.
3. workflow form control method according to claim 1, it is characterised in that: further include step after the step 7
8: page table list is finally presented according to step 6, the output result of step 7.
4. workflow form control method according to claim 1, it is characterised in that: further include step after the step 8
9: the form data during workflow circulation, which saves, to be submitted, after the conversion that control is realized by step 5, step 6, list control
Logical layer reads the control content of forms pages, and control collection data are formed a character string forms by connector, submits
It carries out being saved in the workflow table transmitted established in database steps 2 to workflow engine.
5. workflow form control method according to claim 1, it is characterised in that: preset work in the step 3
Stream form controls design rule is determined according to control type, and is indicated with tri-bit encoding.
6. workflow form control method according to claim 1, it is characterised in that: in the step 4, the process step
Rapid configuration information and then realizes that operation controls for realizing the conversion of control name to form controls.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910576761.4A CN110362555B (en) | 2019-06-28 | 2019-06-28 | Workflow list control method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910576761.4A CN110362555B (en) | 2019-06-28 | 2019-06-28 | Workflow list control method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110362555A true CN110362555A (en) | 2019-10-22 |
| CN110362555B CN110362555B (en) | 2022-04-29 |
Family
ID=68217353
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910576761.4A Active CN110362555B (en) | 2019-06-28 | 2019-06-28 | Workflow list control method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110362555B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2443454A1 (en) * | 2003-09-11 | 2005-03-11 | Teamplate Inc. | Data binding method in workflow system |
| CN103577165A (en) * | 2012-07-20 | 2014-02-12 | 杭州勒卡斯广告策划有限公司 | Form generation method and form generator |
| CN103903086A (en) * | 2014-03-06 | 2014-07-02 | 中国人民解放军装甲兵工程学院 | Method and system for developing management information system based on service model driving |
| CN105046408A (en) * | 2015-06-25 | 2015-11-11 | 国网山东省电力公司 | Configurable workflow realization method and system |
| CN109634585A (en) * | 2018-11-27 | 2019-04-16 | 浙江万朋教育科技股份有限公司 | A method of service end data is adaptively shown and updated based on list |
-
2019
- 2019-06-28 CN CN201910576761.4A patent/CN110362555B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2443454A1 (en) * | 2003-09-11 | 2005-03-11 | Teamplate Inc. | Data binding method in workflow system |
| CN103577165A (en) * | 2012-07-20 | 2014-02-12 | 杭州勒卡斯广告策划有限公司 | Form generation method and form generator |
| CN103903086A (en) * | 2014-03-06 | 2014-07-02 | 中国人民解放军装甲兵工程学院 | Method and system for developing management information system based on service model driving |
| CN105046408A (en) * | 2015-06-25 | 2015-11-11 | 国网山东省电力公司 | Configurable workflow realization method and system |
| CN109634585A (en) * | 2018-11-27 | 2019-04-16 | 浙江万朋教育科技股份有限公司 | A method of service end data is adaptively shown and updated based on list |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110362555B (en) | 2022-04-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109977110A (en) | Data cleaning method, device and equipment | |
| EP1128277A2 (en) | Data processing method and system, program for realizing the method, and computer readable storage medium storing the program | |
| WO2019204106A1 (en) | Learning etl rules by example | |
| CN112307153B (en) | Automatic construction method and device of industrial knowledge base and storage medium | |
| CN103678556A (en) | Method for processing column-oriented database and processing equipment | |
| CN108363704A (en) | A kind of neural network machine translation corpus expansion method based on statistics phrase table | |
| CN105975502A (en) | Method for realizing incremental data extract based on CDC (Change Data Capture) mode | |
| CN105808746A (en) | Relational big data seamless access method and system based on Hadoop system | |
| CN107066551A (en) | The line and column storage method and system of a kind of tree shaped data | |
| CN109213820A (en) | Method for realizing fusion use of multiple types of databases | |
| CN105183915A (en) | Multi-version management method for reducing index maintenance overhead | |
| CN101894299A (en) | Fast freight departure and entry intelligent declaration system capable of supporting RFID and HS coding and image processing | |
| EP1510935A1 (en) | Mapping a data from a data warehouse to a data mart | |
| CN114372177A (en) | Excel table data matching method | |
| CN106484815A (en) | A kind of automatic identification optimization method for retrieving scene based on mass data class SQL | |
| Veve | Supporting name authority control in XML metadata: a practical approach at the University of Tennessee | |
| CN110362555A (en) | Workflow form control method | |
| CN115455050A (en) | Distributed database and query method | |
| CN115713309A (en) | Internal auditing system | |
| Bai | Practical database programming with Java | |
| CN108509587A (en) | The inquiry inscriptions on bones or tortoise shells opens up database establishment and the search method of figure and its original text and annotations | |
| WO2022086813A1 (en) | Systems and methods for enabling relevant data to be extracted from a plurality of documents | |
| Sharma et al. | An Approach for Implementation of Cost Effective Automated Data Warehouse System | |
| Valantin | CDS/ISIS and MINISIS: a functional analysis and comparison | |
| Baird et al. | The emerging scientific water paradigm: Precursors, hallmarks, and trajectories |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |