CN106776986B - A kind of configurable list extension information transmitting methods - Google Patents
A kind of configurable list extension information transmitting methods Download PDFInfo
- Publication number
- CN106776986B CN106776986B CN201611109775.8A CN201611109775A CN106776986B CN 106776986 B CN106776986 B CN 106776986B CN 201611109775 A CN201611109775 A CN 201611109775A CN 106776986 B CN106776986 B CN 106776986B
- Authority
- CN
- China
- Prior art keywords
- information
- upstream
- assignment
- data
- list
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 40
- 238000011144 upstream manufacturing Methods 0.000 claims abstract description 62
- 238000012423 maintenance Methods 0.000 claims description 5
- 238000006073 displacement reaction Methods 0.000 claims description 3
- 238000004321 preservation Methods 0.000 claims description 3
- 230000006835 compression Effects 0.000 description 2
- 238000007906 compression Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004883 computer application Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 235000013399 edible fruits Nutrition 0.000 description 1
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/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- 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/242—Query formulation
- G06F16/2433—Query languages
- G06F16/2448—Query languages for particular applications; for extensibility, e.g. user defined types
-
- 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/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Computer And Data Communications (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a kind of configurable lists to extend information transmitting methods, by obtaining information realization to the customized assignment of downstream form fields from background data base, realizes process are as follows: creation information first transmits allocation list；It parses above-mentioned allocation list and upstream form information is set and obtain interface；The acquisition interface for calling upstream form information obtains upstream form information and to downstream form fields assignment.A kind of configurable list extension information transmitting methods of the invention are compared with prior art, it can be attached on original system in the form of plug-in plug-in unit, information is obtained by the database that detours and is transmitted backward, on the basis of not changing original software system architecture, help original system realize list extension information document between transmit, have the characteristics that on existed system influence it is small, realization it is simple, it is practical, it is applied widely, there is good application value.
Description
Technical field
The present invention relates to computer application technology, specifically a kind of configurable list extends information transmitting side
Method.
Background technique
Most information system business softwares are all the fields for supporting that business form extension addition is personalized, business form it
Between be to have stream compression relationship (the negotiable information for forming sale outbound list of information on such as stock transfer order), system again
Built-in field is this information flow to be realized by Software Coding, and add for voluntarily being extended on list when application by user
Field, how to realize by upstream document information transmit automatically assignment to these fields become a problem to be solved.
Based on this, the present invention provides a kind of configurable list extension information transmitting methods, so as to plug-in plug-in unit
Form be attached on original system, information is obtained by the database that detours and is backward transmitted, original system realization list is helped
It is transmitted between the document of extension information.
Summary of the invention
Technical assignment of the invention is place against the above deficiency, provides a kind of configurable list extension information transmitting side
Method.
A kind of configurable list extension information transmitting methods, give downstream table by obtaining information realization from background data base
The customized assignment of individual character section realizes process are as follows:
Creation information first transmits allocation list；
It parses above-mentioned allocation list and upstream form information is set and obtain interface；
The acquisition interface for calling upstream form information obtains upstream form information and to downstream form fields assignment.
When creating information transmitting allocation list, need to store the relevant configuration of form information transmitting, institute in the allocation list
Stating relevant configuration includes: ID, i.e. allocation list primary key column；Upstream type, i.e. upstream document type；Downstream type, i.e. downstream document
Type；Serial number；Assignment field, downstream document need the field of assignment；Assignment opportunity；Data source types；Data source；In life
Effect or dead status.
When creating information transmitting allocation list, configuration information delivery rules in the table:
Pass through the increase of database built table sql like language and complete data structure；
Then by the maintenance interface on foreground or the data manipulation on backstage, maintenance configuration is advised in allocation list as needed
Then.
The upstream form information obtains interface, and there are two parameters:
Data source string: string type, for receiving data source SQL or storing process name；
Upstream data ID character string: string type, for receiving upstream data ID.
The specific implementation process of upstream form information acquisition interface are as follows:
It parses information and transmits allocation list, obtain data source and confirm that the data source is the implementing result of SQL or storing process；
When data source is SQL implementing result, with accounting in the upstream data ID parametric variable displacement SQL character string received
Position symbol, obtains final SQL character string, then executes in the database and obtains final upstream form information；
When data source is storing process implementing result, using upstream data ID parametric variable as the parameter of storing process, In
The storing process is executed in database obtains final upstream form information.
Downstream list parses allocation list, calls the acquisition interface of upstream form information, obtains upstream form information and give down
Swim the detailed process of form fields assignment are as follows:
Allocation list is parsed first, obtains assignment opportunity, the assignment field of downstream list needs；
Upstream data id information is obtained from the list of downstream；
The acquisition interface that upstream form information is called using upstream data ID as parameter, obtains upstream form information；
According to assignment opportunity, upstream form information is assigned to assignment field.
According to the difference on assignment opportunity, it is divided to two kinds of form breath assignment:
When interface is opened: giving foreground field assignment, then store data into database by the preservation event on interface；
When data save: directly updating backstage field by update sentence.
Compared to the prior art a kind of configurable list extension information transmitting methods of the invention, have below beneficial to effect
Fruit:
A kind of configurable list of the invention extends information transmitting methods, can be attached to original in the form of plug-in plug-in unit
Have in system, information is obtained by the database that detours and transmits backward, on the basis of not changing original software system architecture, side
Help original system realize list extension information document between transmit, have the characteristics that on existed system influence it is small, realize it is simple, reality
It is strong with property, it is applied widely, there is good application value.
Specific embodiment
The present invention is further explained in the light of specific embodiments.
Most information system business softwares are all the fields for supporting that business form extension addition is personalized, business form it
Between be to have stream compression relationship (the negotiable information for forming sale outbound list of information on such as stock transfer order), system again
Built-in field is this information flow to be realized by Software Coding, and add for voluntarily being extended on list when application by user
Field, how to realize by upstream document information transmit automatically assignment to these fields become a problem to be solved.
Based on this, the present invention is to provide a kind of configurable list extension information transmitting methods, by from background data base
Customized assignment of the acquisition information realization to downstream form fields, specifically a kind of extension process applied on list,
By obtaining information realization to the customized assignment of downstream form fields from background data base, original software system can not changed
It unites on the basis of framework, calls this device by encoding on a small quantity, passed between helping original system to realize the document of list extension information
It passs, realizes process are as follows:
It defines information and transmits allocation list, the relevant configuration of storage form information transmitting；
It parses information and transmits allocation list, realize the acquisition interface of upstream document information；
The acquisition interface for calling upstream document information, by return information assignment to downstream document relevant field.
Wherein the basic table structure of information transmitting allocation list is as follows:
More specifically, realization of the invention the following steps are included:
One, creation information transmitting allocation list and the configuration information delivery rules in table.
1.1, pass through the increase of database built table SQL and complete data structure；
It 1.2, can be by the maintenance interface on foreground or the data manipulation on backstage, as needed toward allocation list maintenance configuration rule
Then.
Realize that code is as described below:
Two, realize that upstream form information obtains interface.
2.1, there are two parameters for the interface:
Data source string: string type, for receiving data source SQL or storing process name；
Upstream data ID character string: string type, for receiving [upstream data ID]；
2.2, parsing information transmits allocation list, obtains data source SQL or storing process；
2.3, when data source is SQL, with the@in [upstream data ID] parametric variable displacement SQL character string received
SYID@placeholder obtains final SQL character string, then executes in the database and obtains final upstream form information；
2.4, when data source is storing process, by parameter of [upstream data ID] parametric variable as storing process, in number
Final upstream form information is obtained according to the storing process is executed in library.
Realize that code is as described below:
Three, downstream list parse allocation list, call upstream form information acquisition interface, obtain upstream form information and to
Downstream form fields assignment.
3.1, allocation list is parsed, [assignment opportunity], [the assignment field] of downstream list needs are obtained；
3.2, [upstream data ID] information is obtained from downstream list or other source relation records；
3.3, it is the acquisition interface of parameter calling upstream form information with [upstream data ID], obtains upstream form information；
3.4, it is divided to two kinds of forms that upstream form information is assigned to [assignment field] according to the difference on assignment opportunity:
When interface is opened: give foreground field assignment, after database stored data by the preservation event on interface；
When data save: directly updating backstage field by update sentence.
Realize that code is as described below:
The technical personnel in the technical field can readily realize the present invention with the above specific embodiments,.But it answers
Work as understanding, the present invention is not limited to above-mentioned specific embodiments.On the basis of the disclosed embodiments, the technical field
Technical staff can arbitrarily combine different technical features, to realize different technical solutions.
Except for the technical features described in the specification, it all is technically known to those skilled in the art.
Claims (4)
1. a kind of configurable list extends information transmitting methods, which is characterized in that real by obtaining information from background data base
The customized assignment for now giving downstream form fields, realizes process are as follows:
Creation information first transmits allocation list；
It parses above-mentioned allocation list and upstream form information is set and obtain interface；
The acquisition interface for calling upstream form information obtains upstream form information and to downstream form fields assignment；
When creating information transmitting allocation list, need to store the relevant configuration of form information transmitting, the phase in the allocation list
Closing configuration includes: ID, i.e. allocation list primary key column, including upstream data ID；Upstream type, i.e. upstream document type；Downstream type,
That is downstream document types；Serial number；Assignment field, downstream document need the field of assignment；Assignment opportunity；Data source types；Number
According to source；In the still dead status that comes into force；
The upstream form information obtains interface, and there are two parameters:
Data source string: string type, for receiving data source SQL or storing process name；
Upstream data ID character string: string type, for receiving upstream data ID；
The specific implementation process of upstream form information acquisition interface are as follows:
It parses information and transmits allocation list, obtain data source and confirm that the data source is the implementing result of SQL or storing process；
When data source is SQL implementing result, with the occupy-place in the upstream data ID parametric variable displacement SQL character string received
Symbol, obtains final SQL character string, then executes in the database and obtains final upstream form information；
When data source is storing process implementing result, using upstream data ID parametric variable as the parameter of storing process, in data
The storing process is executed in library obtains final upstream form information.
2. a kind of configurable list according to claim 1 extends information transmitting methods, which is characterized in that believe in creation
When breath transmitting allocation list, configuration information delivery rules in the table:
Pass through the increase of database built table sql like language and complete data structure；
Then by the maintenance interface on foreground or the data manipulation on backstage, configuration rule is safeguarded in allocation list as needed.
3. a kind of configurable list according to claim 1 extends information transmitting methods, which is characterized in that downstream list
Allocation list is parsed, the acquisition interface of upstream form information is called, obtains upstream form information and to downstream form fields assignment
Detailed process are as follows:
Allocation list is parsed first, obtains assignment opportunity, the assignment field of downstream list needs；
Upstream data id information is obtained from the list of downstream；
The acquisition interface that upstream form information is called using upstream data ID as parameter, obtains upstream form information；
According to assignment opportunity, upstream form information is assigned to assignment field.
4. a kind of configurable list according to claim 3 extends information transmitting methods, which is characterized in that according to assignment
The difference on opportunity is divided to two kinds of form breath assignment:
When interface is opened: giving foreground field assignment, then store data into database by the preservation event on interface；
When data save: directly updating backstage field by update sentence.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611109775.8A CN106776986B (en) | 2016-12-06 | 2016-12-06 | A kind of configurable list extension information transmitting methods |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611109775.8A CN106776986B (en) | 2016-12-06 | 2016-12-06 | A kind of configurable list extension information transmitting methods |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106776986A CN106776986A (en) | 2017-05-31 |
| CN106776986B true CN106776986B (en) | 2019-12-03 |
Family
ID=58878256
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611109775.8A Active CN106776986B (en) | 2016-12-06 | 2016-12-06 | A kind of configurable list extension information transmitting methods |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106776986B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110795335A (en) * | 2019-09-24 | 2020-02-14 | 北京首钢自动化信息技术有限公司 | Parameter domain checking method for parameter setting |
| CN110727670B (en) * | 2019-10-11 | 2022-08-09 | 北京小向创新人工智能科技有限公司 | Data structure prediction transfer and automatic data processing method based on flow chart |
| CN111581108B (en) * | 2020-05-14 | 2024-02-23 | 中国银行股份有限公司 | Input data acquisition method and device based on business system transaction test |
| CN112035510B (en) * | 2020-08-28 | 2023-12-19 | 中电长城(长沙)信息技术有限公司 | Method and system for inquiring complex data of information system |
| CN115914381A (en) * | 2022-10-27 | 2023-04-04 | 北京沃东天骏信息技术有限公司 | Upstream and downstream platform communication method and device and electronic equipment |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2000058869A1 (en) * | 1999-03-26 | 2000-10-05 | Intelligent Learning Systems, Inc. | A system and method for dynamic knowledge generation and distribution |
| CN101706716A (en) * | 2009-09-08 | 2010-05-12 | 南京师范大学 | VO-based form customization, configuration and parsing operation method |
| CN101777143A (en) * | 2009-12-22 | 2010-07-14 | 金蝶软件（中国）有限公司 | Method, device and system for business bill conversion |
| CN101894149A (en) * | 2010-06-23 | 2010-11-24 | 畅捷通软件有限公司 | Method and device for tracking and inquiring document |
| CN103020137A (en) * | 2012-11-21 | 2013-04-03 | 用友软件股份有限公司 | System and method for expanding self-defining item for data receipt |
| CN103218417A (en) * | 2013-03-27 | 2013-07-24 | 广东全通教育股份有限公司 | Configurable form generation device and form generation method |
| CN103679355A (en) * | 2013-12-03 | 2014-03-26 | 金蝶软件（中国）有限公司 | Method and device for controlling operation flow |
| CN104077372A (en) * | 2014-06-24 | 2014-10-01 | 用友优普信息技术有限公司 | Flexible custom field transfer method and system |
| CN105117431A (en) * | 2015-08-07 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Dynamic configuration method and system for external imported data |
-
2016
- 2016-12-06 CN CN201611109775.8A patent/CN106776986B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2000058869A1 (en) * | 1999-03-26 | 2000-10-05 | Intelligent Learning Systems, Inc. | A system and method for dynamic knowledge generation and distribution |
| CN101706716A (en) * | 2009-09-08 | 2010-05-12 | 南京师范大学 | VO-based form customization, configuration and parsing operation method |
| CN101777143A (en) * | 2009-12-22 | 2010-07-14 | 金蝶软件（中国）有限公司 | Method, device and system for business bill conversion |
| CN101894149A (en) * | 2010-06-23 | 2010-11-24 | 畅捷通软件有限公司 | Method and device for tracking and inquiring document |
| CN103020137A (en) * | 2012-11-21 | 2013-04-03 | 用友软件股份有限公司 | System and method for expanding self-defining item for data receipt |
| CN103218417A (en) * | 2013-03-27 | 2013-07-24 | 广东全通教育股份有限公司 | Configurable form generation device and form generation method |
| CN103679355A (en) * | 2013-12-03 | 2014-03-26 | 金蝶软件（中国）有限公司 | Method and device for controlling operation flow |
| CN104077372A (en) * | 2014-06-24 | 2014-10-01 | 用友优普信息技术有限公司 | Flexible custom field transfer method and system |
| CN105117431A (en) * | 2015-08-07 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Dynamic configuration method and system for external imported data |
Non-Patent Citations (2)
| Title |
|---|
| 教室预约系统中可定制扩展表单的实现;张兴旺;《电子技术与软件工程》;20151231;全文 * |
| 源头数据采集表单动态生成开发技术--井地质数据库源头数据采集系统为例;曹烈;《石油工业计算机应用》;20111231;全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106776986A (en) | 2017-05-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106776986B (en) | A kind of configurable list extension information transmitting methods | |
| CN105512139B (en) | The implementation method and device of data visualization | |
| Arim et al. | On the relationship between trophic position, body mass and temperature: reformulating the energy limitation hypothesis | |
| CN104765751B (en) | Using recommended method and device | |
| CN108292323A (en) | Use the database manipulation of the metadata of data source | |
| Raja et al. | Android and ODK based data collection framework to aid in epidemiological analysis | |
| CN107092625A (en) | data configuration method, data processing method and device | |
| CN107273122A (en) | Based on decoupling mechanism can iteration set up operation system method and its terminal | |
| CN105512326A (en) | Picture recommending method and system | |
| CN105118518B (en) | A kind of semantic analysis and device of sound | |
| CN109145027A (en) | Data statistical approach, device, equipment and computer readable storage medium | |
| US20230244653A1 (en) | Semantic compliance validation for blockchain | |
| US20140082002A1 (en) | Apparatus and method for processing unstructured data event in real time | |
| CN108960672A (en) | The air control method, apparatus and computer readable storage medium of limit limit time | |
| CN107506383A (en) | A kind of audit data processing method and computer equipment | |
| CN106921795A (en) | A kind of contact data management method and its system | |
| CN112802607A (en) | Medical data treatment system | |
| CN111782653A (en) | Data query method and device, electronic equipment and storage medium | |
| CN107766431A (en) | It is a kind of that Parameter Function Unit method and system are gone based on syntax parsing | |
| CN110633331A (en) | Method, system and related equipment for extracting data in relational database | |
| CN104572939B (en) | A kind of data query method of heterogeneous database exchange in industry | |
| CN105912723B (en) | A kind of storage method of custom field | |
| Pinelis | Evolutionary models of phylogenetic trees | |
| CN106055657A (en) | Evaluation system for film viewing index of specific population | |
| CN105094843B (en) | A kind of inspection method and device of tables of data |
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 |