CN106814984A - A kind of data integration method based on Print Preview control - Google Patents
A kind of data integration method based on Print Preview control Download PDFInfo
- Publication number
- CN106814984A CN106814984A CN201710039367.8A CN201710039367A CN106814984A CN 106814984 A CN106814984 A CN 106814984A CN 201710039367 A CN201710039367 A CN 201710039367A CN 106814984 A CN106814984 A CN 106814984A
- Authority
- CN
- China
- Prior art keywords
- layout
- data
- method based
- integration method
- 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
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/12—Digital output to print unit, e.g. line printer, chain printer
- G06F3/1201—Dedicated interfaces to print systems
- G06F3/1202—Dedicated interfaces to print systems specifically adapted to achieve a particular effect
- G06F3/1203—Improving or facilitating administration, e.g. print management
- G06F3/1208—Improving or facilitating administration, e.g. print management resulting in improved quality of the output result, e.g. print layout, colours, workflows, print preview
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/12—Digital output to print unit, e.g. line printer, chain printer
- G06F3/1201—Dedicated interfaces to print systems
- G06F3/1223—Dedicated interfaces to print systems specifically adapted to use a particular technique
- G06F3/1237—Print job management
- G06F3/1253—Configuration of print job parameters, e.g. using UI at the client
- G06F3/1257—Configuration of print job parameters, e.g. using UI at the client by using pre-stored settings, e.g. job templates, presets, print styles
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Human Computer Interaction (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention discloses a kind of data integration method based on Print Preview control, its implementation process is：The data item of configuration data bag first：Layout is introduced, and acquisition conditions are configured according to layout；The displaying form of configuration data bag：Based on above-mentioned layout, Tab pages where it of displaying order and Tab pages of title is determined；It is last that packet displaying is carried out in the way of Tab pages, and allow Print All or part to print.A kind of data integration method based on Print Preview control of the invention is compared with prior art, the layout that will can be enriched in ERP system is organically combined, all kinds of comprehensive inquiries that user is concerned about, penetrate inquiry and business datum tracking information passes through the data preview function of the orthogonal multiple layouts of the script that combines and shows, it is practical.
Description
Technical field
The present invention relates to Computer Applied Technology field, specifically a kind of Data Integration based on Print Preview control
Method.
Background technology
Business paper and dictionary in ERP system are all to support printing and Print Preview.For different purposes, it is same
Typically can all there are multiple layouts in bar business datum, abundant layout has become the information resources of enterprise-essential.
And on the other hand, with going deep into for IT application in enterprises, all kinds of comprehensive inquiries, penetrate inquiry and business datum tracking demand layer go out
Not poor, closely, software supplier is difficult to be standardized the specific business association of this kind of general and specific client of demand, even if making
Form is defined with special form developing instrument, no small workload is also required for.
Thus, the present invention provides a kind of implementation method of conventional data Fabric Interface, the data based on Print Preview control
Integration technology, the layout that will be enriched in ERP system is organically combined, by user be concerned about all kinds of comprehensive inquiries,
The data that inquiry and business datum tracking information are penetrated by the orthogonal multiple layouts of the script for combining are pre-
Function of looking at shows.
The content of the invention
Technical assignment of the invention is directed to above weak point, there is provided one kind is practical, can be widely applied to isomery
The data integration method based on Print Preview control in data integration and exchange system.
A kind of data integration method based on Print Preview control, its implementation process is：
The data item of configuration data bag first：Layout is introduced, and acquisition conditions are configured according to layout；
The displaying form of configuration data bag：Based on above-mentioned layout, the displaying order and Tab at its Tab pages of place are determined
The title of page；
It is last that packet displaying is carried out in the way of Tab pages, and allow Print All or part to print.
During the data item of configuration data bag, the layout of integral data is increased or introduced newly first；Then index ginseng is set
Exponential model, model is added to by the attribute that layout is relied on；Access model and acquisition conditions are finally set, according to layout
The model of dependence sets acquisition conditions.
It is by the process that the attribute that layout is relied on is added to model：The query SQL of all execution is captured first, is captured
Mode is that application database implementation procedure is filtered or data base tool performs analysis；By query SQL feature, using character
String manipulation strategy is parsed to sentence, obtains the attribute that layout is relied on.
The acquisition conditions are stored in user-defined data table ScReportCondition, the user-defined data table
ScReportCondition kinds have also recorded id field, are unique guid marks；Form ID, form is represented for recording
ID；Acquisition conditions, are set with xml modes or model, document ID to record, including filter condition, sequence.
Result set is shown on Tab pages according to acquisition conditions, layout, the result set includes layout and product
Data, different Tab pages represent different layouts.
The packet includes unique ID, acquisition conditions, i.e. parameterized template.
, it is necessary to when introducing product structure, product structure be defined first after the completion of the displaying form of configuration data bag, set
BOM information or sequence number information, configuration data bag；Then packet is exported, preview data is shown according to product structure information.
The product structure includes ID, as one mark；Packet, that is, the packet to be shown；Inventory organization, that is, quote
Layout；Descriptive labelling, i.e. record product description information；Sequence number, i.e. record product sequence number；BOM information, i.e. material are clear
Single information；Parent node, i.e. tree construction are identified.
A kind of data integration method based on Print Preview control of the invention compared to the prior art, with following beneficial
Effect：
A kind of data integration method based on Print Preview control of the invention, the printing that will can be enriched in ERP system
Form is organically combined, by user be concerned about all kinds of comprehensive inquiries, penetrate inquiry and business datum tracking information pass through
The data preview function of the orthogonal multiple layouts of the script that combines shows；The present invention takes full advantage of
The existing layout resource of system, it is not necessary to which special report tool defines form, it is not required that any secondary development, with regard to energy
Enough meet the demand of usertracking composite information, the characteristic with general, easy, practical, easy popularization is practical, be applicable model
Enclose extensively, it is easy to promote.
Brief description of the drawings
Accompanying drawing 1 realizes flow chart for of the invention.
Accompanying drawing 2 realizes Organization Chart for of the invention.
Specific embodiment
Below in conjunction with the accompanying drawings and specific embodiment the invention will be further described.
As shown in Figure 1, a kind of data integration method based on Print Preview control, its implementation process is：
1st, the different pieces of information of configuration data bag.
Layout is introduced by data item management function, and acquisition conditions are configured according to the access model of layout.
What the 2nd, configuration data bag was different Tab pages represents form.
The layout introduced by packet configuration feature reference data management function, and specify Tab pages of place
Represent order, Tab pages of title.
3rd, configuration data bag preview represents, and allows Print All or part to print.
In the packet output function layout that demonstrating data bag configuration feature is configured in the way of Tab pages and product not
The data of same level, different Tab pages represent different layouts.
The data item of configuration data bag first：Layout is introduced, and acquisition conditions are configured according to layout；
The displaying form of configuration data bag：Based on above-mentioned layout, the displaying order and Tab at its Tab pages of place are determined
The title of page；
It is last that packet displaying is carried out in the way of Tab pages, and allow Print All or part to print.
During the data item of configuration data bag, the layout of integral data, layout storage are increased or introduced newly first
In layout storehouse, as shown in Figure 2, it includes purchase order information, buying arrival information etc.；Then indexing parameter is set
Model, model is added to by the attribute that layout is relied on；Finally set access model and acquisition conditions, according to layout according to
Bad model sets acquisition conditions.
It is by the process that the attribute that layout is relied on is added to model：The query SQL of all execution is captured first, is captured
Mode is that application database implementation procedure is filtered or data base tool performs analysis；By query SQL feature, using character
String manipulation strategy is parsed to sentence, obtains the attribute that layout is relied on.
Result set is shown on Tab pages according to acquisition conditions, layout, the result set includes layout and product
Data, different Tab pages represent different layouts.
, it is necessary to when introducing product structure, product structure be defined first after the completion of the displaying form of configuration data bag, set
BOM information or sequence number information, configuration data bag；Then packet is exported, preview data is shown according to product structure information.
Acquisition conditions, packet, packet content, the base table structure of product structure definition being related in above-mentioned steps are such as
Lower described, wherein acquisition conditions are recorded with table ScReportCondition.
| Field number | Field name | Field type | Explanation |
| ConditionID | ID | Varchar(36) | Unique mark |
| ReportID | Form ID | Varchar(36) | Form ID |
| Conditions | Acquisition conditions | Varchar(4000) | Acquisition conditions |
A) ConditionID fields are guid marks；
B) ReportID fields are used to record the ID for representing form；
C) conditions field is used to record acquisition conditions, with xml modes or model, document ID to record；
Packet table：
| Field number | Field name | Field type | Explanation |
| QCSJB_SJBID | ID | Varchar(36) | Unique mark |
| QCSJB_CSMB | Parameterized template | Varchar(36) | Acquisition conditions |
Different Tab pages of configuration data bag is used for recording with table QCSJBNR, and the structure of table is as follows：
Product structure definition table, record product structure, it is allowed to introduce BOM information or sequence number information.
| Field number | Field name | Field type | Explanation |
| QCCPJG_JGID | ID | Varchar(36) | Unique mark |
| QCCPJG_SJBID | Packet | Varchar(36) | The packet of displaying |
| QCCPJG_OrgID | Inventory organization | Varchar(36) | Quote layout |
| QCCPJG_MS | Product description | Varchar(255) | Record product description information |
| QCCPJG_SN | Sequence number | Varchar(36) | Record product sequence number |
| MaterialID | Material | Varchar(36) | Material information |
| ParentID | Parent node | Varchar(36) | Tree construction is identified |
The data that the present invention needs in service management software systems according to existing layout displaying user in system,
And represented according to the ways of presentation of user, the present invention is actual closer to application with the actually used situation of system user, is more easy to solve
Practical problem；According to practical situations, can at any time strain, adjust at any time, more adapt to the demand of different application scene；It is more easy to
In system administrator maintenance, intuitively function treatment displaying more easy to get started.
Data Integration based on Print Preview control of the invention has been successfully applied in the GS products of certain enterprise ERP
In, product data bag can be with the related printing lattice in the complete business flows such as configuration association buying, quality inspection, production, storage, delivery
Formula, whole service link is tracked by the preview of layout, is met the need for client sees the whole aspect.
By specific embodiment above, the those skilled in the art can readily realize the present invention.But should
Work as understanding, the present invention is not limited to above-mentioned specific embodiment.On the basis of disclosed embodiment, the technical field
Technical staff can be combined different technical characteristics, so as to realize different technical schemes.
In addition to the technical characteristic described in specification, the known technology of those skilled in the art is.
Claims (8)
1. a kind of data integration method based on Print Preview control, it is characterised in that its implementation process is：
The data item of configuration data bag first：Layout is introduced, and acquisition conditions are configured according to layout；
The displaying form of configuration data bag：Based on above-mentioned layout, determine Tab page of displaying order where it with Tab pages
Title；
It is last that packet displaying is carried out in the way of Tab pages, and allow Print All or part to print.
2. a kind of data integration method based on Print Preview control according to claim 1, it is characterised in that configuration number
During according to the data item wrapped, the layout of integral data is increased or introduced newly first；Then indexing parameter model is set, lattice will be printed
The attribute that formula is relied on is added to model；Access model and acquisition conditions are finally set, and the model relied on according to layout is set
Acquisition conditions.
3. a kind of data integration method based on Print Preview control according to claim 2, it is characterised in that will print
The attribute that form is relied on is added to the process of model：The query SQL of all execution is captured first, and acquisition mode is application program
Database implementation procedure is filtered or data base tool performs analysis；By query SQL feature, using string processing strategy to language
Sentence is parsed, and obtains the attribute that layout is relied on.
4. a kind of data integration method based on Print Preview control according to claim 2, it is characterised in that described to take
Said conditions are stored in user-defined data table ScReportCondition, and user-defined data table ScReportCondition kinds have also been recorded
Id field, is unique guid marks；Form ID, the ID of form is represented for recording；Acquisition conditions, with xml modes or model,
Document ID is set to record, including filter condition, sequence.
5. a kind of data integration method based on Print Preview control according to claim 2, it is characterised in that according to taking
Said conditions, layout show result set on Tab pages, and the result set includes the data of layout and product, different Tab pages
Represent different layouts.
6. a kind of data integration method based on Print Preview control according to claim 2, it is characterised in that the number
Include unique ID, acquisition conditions, i.e. parameterized template according to bag.
7. a kind of data integration method based on Print Preview control according to claim 1, it is characterised in that work as configuration
, it is necessary to when introducing product structure, product structure be defined first after the completion of the displaying form of packet, BOM information or sequence are set
Number information, configuration data bag；Then packet is exported, preview data is shown according to product structure information.
8. a kind of data integration method based on Print Preview control according to claim 7, it is characterised in that the product
Product structure includes ID, as one mark；Packet, that is, the packet to be shown；Inventory organization, that is, quote layout；Commodity
Description, i.e. record product description information；Sequence number, i.e. record product sequence number；BOM information, i.e. BOM information；Parent section
Point, i.e. tree construction are identified.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710039367.8A CN106814984A (en) | 2017-01-19 | 2017-01-19 | A kind of data integration method based on Print Preview control |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710039367.8A CN106814984A (en) | 2017-01-19 | 2017-01-19 | A kind of data integration method based on Print Preview control |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106814984A true CN106814984A (en) | 2017-06-09 |
Family
ID=59112486
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710039367.8A Pending CN106814984A (en) | 2017-01-19 | 2017-01-19 | A kind of data integration method based on Print Preview control |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106814984A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108052491A (en) * | 2017-11-22 | 2018-05-18 | 李晓妮 | A kind of automatic processing method and device of certificate document |
| CN108762693A (en) * | 2018-04-03 | 2018-11-06 | 四川九阵科技股份有限公司 | A kind of print from the definition design system and method |
| CN109471600A (en) * | 2018-10-31 | 2019-03-15 | 中国银行股份有限公司 | A kind of Method of printing, device and a kind of print system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101408841A (en) * | 2008-11-26 | 2009-04-15 | 浪潮集团山东通用软件有限公司 | General-purpose data multidimensional component exhibiting method |
| CN101706720A (en) * | 2009-11-23 | 2010-05-12 | 浪潮集团山东通用软件有限公司 | Method for showing interface according to customized information during operation |
| CN102314414A (en) * | 2010-07-01 | 2012-01-11 | 上海宝信软件股份有限公司 | Realization method of configurable main and detailed data processing table |
| CN102426588A (en) * | 2011-10-31 | 2012-04-25 | 北京空间飞行器总体设计部 | Product collaborative design supporting method based on key factor |
| CN103679515A (en) * | 2012-09-26 | 2014-03-26 | 梅特勒-托利多(常州)测量技术有限公司 | Receipt printing method and receipt printing system |
-
2017
- 2017-01-19 CN CN201710039367.8A patent/CN106814984A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101408841A (en) * | 2008-11-26 | 2009-04-15 | 浪潮集团山东通用软件有限公司 | General-purpose data multidimensional component exhibiting method |
| CN101706720A (en) * | 2009-11-23 | 2010-05-12 | 浪潮集团山东通用软件有限公司 | Method for showing interface according to customized information during operation |
| CN102314414A (en) * | 2010-07-01 | 2012-01-11 | 上海宝信软件股份有限公司 | Realization method of configurable main and detailed data processing table |
| CN102426588A (en) * | 2011-10-31 | 2012-04-25 | 北京空间飞行器总体设计部 | Product collaborative design supporting method based on key factor |
| CN103679515A (en) * | 2012-09-26 | 2014-03-26 | 梅特勒-托利多(常州)测量技术有限公司 | Receipt printing method and receipt printing system |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108052491A (en) * | 2017-11-22 | 2018-05-18 | 李晓妮 | A kind of automatic processing method and device of certificate document |
| CN108052491B (en) * | 2017-11-22 | 2021-02-26 | 中贸促商事服务有限公司 | Automatic processing method and device for certificate document |
| CN108762693A (en) * | 2018-04-03 | 2018-11-06 | 四川九阵科技股份有限公司 | A kind of print from the definition design system and method |
| CN109471600A (en) * | 2018-10-31 | 2019-03-15 | 中国银行股份有限公司 | A kind of Method of printing, device and a kind of print system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8234312B2 (en) | Schema mapping and data transformation on the basis of layout and content | |
| US7017112B2 (en) | Importing and exporting markup language data in a spreadsheet application document | |
| US7080067B2 (en) | Apparatus, method, and program for retrieving structured documents | |
| US7613688B2 (en) | Generating business warehouse reports | |
| US9798781B2 (en) | Strategy trees for data mining | |
| US7765236B2 (en) | Extracting data content items using template matching | |
| EP4339802A2 (en) | Methods and apparatus for integrated management of structured data from various sources and having various formats | |
| US20080114740A1 (en) | System and method for maintaining conformance of electronic document structure with multiple, variant document structure models | |
| KR101013810B1 (en) | An excel-based management system for updating db tables and the method thereof | |
| US8825633B2 (en) | System, method, and data structure for automatically generating database queries which are data model independent and cardinality independent | |
| JP2009509271A (en) | Apparatus and method for data profiling based on composition of extraction, transformation and reading tasks | |
| CN104715032A (en) | Mapping system and method of Chinese and English table name and field name of report system | |
| AU2012327168B2 (en) | Amethod and structure for managing multiple electronic forms and their records using a static database | |
| CN107145480A (en) | A kind of method that XBRL Report workouts are carried out based on Word | |
| DE102012221251A1 (en) | Semantic and contextual search of knowledge stores | |
| CN106814984A (en) | A kind of data integration method based on Print Preview control | |
| CN101710336A (en) | Method for accelerating data processing by using relational middleware | |
| CN105260300A (en) | Service test method based on CAS (General Classification Standards of China Accounting Standards) application platform | |
| CN116680354A (en) | Metadata management method and system for lithium battery production and manufacturing industry | |
| JP4373470B2 (en) | Document conversion utilization system | |
| CN107562949B (en) | Method for writing merged report Excel template into database | |
| US20070282804A1 (en) | Apparatus and method for extracting database information from a report | |
| CN114817171B (en) | Buried point data quality control method | |
| CN116010439A (en) | Visual Chinese SQL system and query construction method | |
| US8719693B2 (en) | Method for storing localized XML document values |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170609 |
|
| RJ01 | Rejection of invention patent application after publication |