CN106709697A - ERP system form data conversion method and conversion system - Google Patents
ERP system form data conversion method and conversion system Download PDFInfo
- Publication number
- CN106709697A CN106709697A CN201611078575.0A CN201611078575A CN106709697A CN 106709697 A CN106709697 A CN 106709697A CN 201611078575 A CN201611078575 A CN 201611078575A CN 106709697 A CN106709697 A CN 106709697A
- Authority
- CN
- China
- Prior art keywords
- report data
- data
- unit
- report
- erp system
- 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
- G06Q—INFORMATION 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/00—Administration; Management
- G06Q10/10—Office automation; Time management
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Operations Research (AREA)
- Economics (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention provides an ERP system form data conversion method and conversion system. The method comprises steps that form data of a business form is acquired from an ERP system; the form data is converted into Json format data, and the Json format data is sent to a WEB end; the Json format data is analyzed through the WEB end to generate form data in a mobile end format; the form data in the mobile end format is displayed on a terminal. The method is advantaged in that the form data of the ERP system can be automatically converted into the form data suitable for being displayed through the mobile end, designing a set of new special-purpose forms is not necessary, the same data can be viewed through a traditional PC end and the mobile end in one same format, a user has no need to invest plenty of development and maintenance resources, and the form data of the ERP system can be conveniently checked and subscribed at the mobile end.
Description
Technical field
The present invention relates to Report technique field, a kind of conversion method in particular to ERP system report data and turn
Change system.
Background technology
In existing ERP products, traditional approach is all to need to sign in just be checked in ERP system and browse form,
It is very inconvenient under present mobile Internet scene.Even if some projects can check form in mobile terminal, it is also necessary to completely
It is a set of new form independently of ERP system original form of mobile terminal customized development, not only exploitation and maintenance workload are huge, not
Effect with end is also inconsistent.
The content of the invention
It is contemplated that at least solving one of technical problem present in prior art or correlation technique.
Therefore, it is an object of the present invention to propose a kind of conversion method of ERP system report data.
It is another object of the present invention to propose a kind of converting system of ERP system report data.
In view of this, an a kind of purpose of the invention, it is proposed that conversion method of ERP system report data, bag
Include:The report data of bordereau is obtained from ERP system;Report data is converted into Json formatted datas, and by Json lattice
Formula data is activation is to WEB terminal;Json formatted datas are parsed by WEB terminal, generates the report data of mobile terminal form;Will
The report data of mobile terminal form represents in terminal.
The conversion method of the ERP system report data that the present invention is provided, obtains the form number of bordereau from ERP system
According to the report data that will be got is converted to Json formatted datas, and sends to WEB terminal, and WEB terminal gets Json formatted datas
Afterwards, parsed using JavaScript, the report data of mobile terminal form is generated, by the report data of mobile terminal form at end
Represent on end, the report data in ERP system can be automatically converted to the report data that suitable mobile terminal represents, without separately
The a set of new single purpose statement of exploitation design, same number evidence can be checked at traditional PC ends and mobile terminal with same form, made
User need not put into substantial amounts of exploitation and safeguard resource, it is possible to easily in mobile terminal is checked and subscribes to ERP system
Report data.
The conversion method of above-mentioned ERP system report data of the invention, can also have following technical characteristic:
In the above-mentioned technical solutions, it is preferable that the step of report data is converted into Json formatted datas includes:Obtain report
The start element lattice and end unit lattice of table data;The line number of accounting report data, columns and row is high, col width;Parsing form
The line information of the gauge outfit of data, cell formats information, and calculate the row height and col width of the gauge outfit.
Include in the technical scheme, the step of report data is converted into Json formatted datas:Obtain report data
Start element lattice and end unit lattice, the line number of accounting report data, columns and row is high, col width parse the table of report data
Line information, the cell formats information of head, and the row height and col width of the gauge outfit are calculated, and then realization in real time reports ERP
The format information lossless of table is converted to the form that mobile terminal can represent.
In the above-mentioned technical solutions, it is preferable that also include:When there is the form data for splitting and freezing in report data,
The form data that analytical decomposition freezes;When there is chart format and data message in report data, chart format and number are processed
It is believed that breath;When there is dynamic area information in report data, parse and conversion dynamic area information.
In the technical scheme, when there is the form data for splitting and freezing in report data, the table that analytical decomposition freezes
Lattice information, and when there is chart format and data message in report data, process chart format and data message, Yi Ji
When there is dynamic area information in report data, parse and conversion dynamic area information, and then the form of mobile terminal is directly reported from ERP
Table data source directly reads and loads data, carries out same effect and represents.
In the above-mentioned technical solutions, it is preferable that parse and include the step of changing dynamic area information:Conversion dynamic area information
Cell values, in the form of 2-D data store;The cell formats information of dynamic area information is parsed, and is converted to assembled unit
Sound of laughing formula;Change the attribute of activating business of dynamic area information;Calculate the row height and col width of assembled unit sound of laughing formula.
In the technical scheme, parse and include the step of changing dynamic area information:The Cell values of dynamic area information are changed,
Stored in the form of 2-D data, parse the cell formats information of dynamic area information, and be converted to assembled unit sound of laughing formula, turned
Change the attribute of activating business of dynamic area information, calculate assembled unit sound of laughing formula row is high and col width, without new special of exploitation design
The report data in ERP system is automatically converted to the report data that suitable mobile terminal represents with form.
In the above-mentioned technical solutions, it is preferable that cell formats information includes following a kind of or its combination:Font, unit
Whether folds show for lattice line style, alignment thereof, color, cell.
In the technical scheme, cell formats information includes following a kind of or its combination but not limited to this:Font, unit
Whether folds show for lattice line style, alignment thereof, color, cell.
In the above-mentioned technical solutions, it is preferable that the step of representing the report data of mobile terminal form in terminal includes:
According to the report data of mobile terminal form, generation report page is drawn;By links and accesses report page, by mobile terminal form
Report data is presented in terminal.
Include in the technical scheme, the step of the report data of mobile terminal form is represented in terminal:According to movement
The report data of form is held, the generation HTML5 pages are drawn, it is ensured that the form in the report style and data and ERP system that represent
Unanimously, mobile terminal can check the detailed data of bordereau by links and accesses report page.
A kind of another purpose of the invention, it is proposed that converting system of ERP system report data, including:Obtain
Unit, the report data for obtaining bordereau from ERP system;Converting unit, for report data to be converted into Json
Formatted data, and state Json formatted datas and send to WEB terminal;First resolution unit, for by WEB terminal to Json formatted datas
Parsed, generated the report data of mobile terminal form;Represent unit, for by the report data of mobile terminal form in terminal
Represent.
The converting system of the ERP system report data that the present invention is provided, acquiring unit obtains bordereau from ERP system
Report data, the report data that converting unit will get is converted to Json formatted datas, and sends to WEB terminal, the first solution
After analysis unit gets Json formatted datas, parsed using JavaScript, generated the report data of mobile terminal form, will
The report data of mobile terminal form represents on unit is represented, and can be automatically converted to the report data in ERP system suitable
The report data that mobile terminal represents, without separately developing a set of new single purpose statement of design, can be with traditional PC ends and mobile terminal
Same number evidence is checked with same form, user is put into substantial amounts of exploitation and is safeguarded resource, it is possible to easily
Report data of the ground in mobile terminal is checked and subscribes to ERP system.
The converting system of above-mentioned ERP system report data of the invention, can also have following technical characteristic:
In the above-mentioned technical solutions, it is preferable that converting unit also includes:Acquiring unit, is additionally operable to obtain report data
Start element lattice and end unit lattice;Computing unit, line number, columns and row height, col width for accounting report data;Second
Resolution unit, the line information of the gauge outfit for parsing report data, cell formats information, and calculate gauge outfit row it is high and
Col width.
In the technical scheme, converting unit includes:Acquiring unit obtains the start element lattice of report data and terminates single
First lattice, the line number of computing unit accounting report data, columns and row is high, col width, the second resolution unit parsing report data
The line information of gauge outfit, cell formats information, and the row height and col width of the gauge outfit are calculated, and then realize ERP in real time
The format information lossless of form is converted to the form that mobile terminal can represent.
In the above-mentioned technical solutions, it is preferable that converting unit, it is additionally operable to have in report data the form for splitting and freezing
During information, the form data that analytical decomposition freezes;When there is chart format and data message in report data, chart lattice are processed
Formula and data message;When there is dynamic area information in report data, parse and conversion dynamic area information.
In the technical scheme, when converting unit has the form data for splitting and freezing in report data, analytical decomposition
The form data freezed, and when having chart format and data message in report data, treatment chart format and data are believed
Breath, and when there is dynamic area information in report data, parse and conversion dynamic area information, and then make the form of mobile terminal straight
Connect from ERP report datas source and directly read and load data, carry out same effect and represent.
In the above-mentioned technical solutions, it is preferable that also include:Converting unit, the Cell values for changing dynamic area information, with
The form storage of 2-D data;Second resolution unit, is additionally operable to parse the cell formats information of dynamic area information, and be converted to
Assembled unit sound of laughing formula;Converting unit, is additionally operable to change the attribute of activating business of dynamic area information;Computing unit, is additionally operable to meter
Calculate the row height and col width of assembled unit sound of laughing formula.
In the technical scheme, converting unit also includes:Converting unit changes the Cell values of dynamic area information, with two-dimemsional number
According to form store, the second resolution unit parse dynamic area information cell formats information, and be converted to assembled unit sound of laughing
Formula, converting unit changes the attribute of activating business of dynamic area information, and computing unit calculates the row height and row of assembled unit sound of laughing formula
Width, is automatically converted to what suitable mobile terminal represented without the new single purpose statement of exploitation design by the report data in ERP system
Report data.
In the above-mentioned technical solutions, it is preferable that cell formats information includes following a kind of or its combination:Font, unit
Whether folds show for lattice line style, alignment thereof, color, cell.
In the technical scheme, cell formats information includes following a kind of or its combination but not limited to this:Font, unit
Whether folds show for lattice line style, alignment thereof, color, cell.
In the above-mentioned technical solutions, it is preferable that representing unit includes:Page generating unit, for according to mobile terminal form
Report data, draw generation report page;Represent unit, be additionally operable to by links and accesses report page, by mobile terminal form
Report data be presented in terminal.
In the technical scheme, representing unit includes:Page generating unit is drawn according to the report data of mobile terminal form
The generation HTML5 pages, it is ensured that the report style and data for representing are consistent with the form in ERP system, and mobile terminal can be by representing
Unit links and accesses report page, checks the detailed data of bordereau.
Additional aspect of the invention and advantage will become obvious in following description section, or by practice of the invention
Recognize.
Brief description of the drawings
Of the invention above-mentioned and/or additional aspect and advantage will become from description of the accompanying drawings below to embodiment is combined
Substantially and be readily appreciated that, wherein:
Fig. 1 a show the schematic flow sheet of the conversion method of the ERP system report data of one embodiment of the present of invention;
Fig. 1 b show that the flow of the conversion method of the ERP system report data of an alternative embodiment of the invention is illustrated
Figure;
Fig. 2 shows the schematic block diagram of the converting system of the ERP system report data of one embodiment of the present of invention;
Fig. 3 shows the mobile terminal form schematic diagram of a specific embodiment of the invention.
Specific embodiment
It is below in conjunction with the accompanying drawings and specific real in order to be more clearly understood that the above objects, features and advantages of the present invention
Mode is applied to be further described in detail the present invention.It should be noted that in the case where not conflicting, the implementation of the application
Feature in example and embodiment can be mutually combined.
Many details are elaborated in the following description in order to fully understand the present invention, but, the present invention may be used also
Implemented with being different from other modes described here using other, therefore, protection scope of the present invention is not limited to following public affairs
The limitation of the specific embodiment opened.
The embodiment of first aspect present invention, proposes a kind of conversion method of ERP system report data, and Fig. 1 a show this
The schematic flow sheet of the conversion method of the ERP system report data of one embodiment of invention:
Step 102, obtains the report data of bordereau from ERP system;
Step 104, Json formatted datas are converted to by report data;
Step 106, Json formatted datas are sent to WEB terminal;
Step 108, is parsed by WEB terminal to Json formatted datas, generates the report data of mobile terminal form;
Step 110, the report data of mobile terminal form is represented in terminal.
The conversion method of the ERP system report data that the present invention is provided, obtains the form number of bordereau from ERP system
According to the report data that will be got is converted to Json formatted datas, and sends to WEB terminal, and WEB terminal gets Json formatted datas
Afterwards, parsed using JavaScript, the report data of mobile terminal form is generated, by the report data of mobile terminal form at end
Represent on end, the report data in ERP system can be automatically converted to the report data that suitable mobile terminal represents, without separately
The a set of new single purpose statement of exploitation design, same number evidence can be checked at traditional PC ends and mobile terminal with same form, made
User need not put into substantial amounts of exploitation and safeguard resource, it is possible to easily in mobile terminal is checked and subscribes to ERP system
Report data.
Fig. 1 b show that the flow of the conversion method of the ERP system report data of an alternative embodiment of the invention is illustrated
Figure, the conversion method of ERP system report data described according to some embodiments of the invention is described referring to Fig. 1 b.
In one embodiment of the invention, as shown in Figure 1 b, it is preferable that step 104, report data is converted into Json
The step of formatted data, includes:
Step 1400, obtains the start element lattice and end unit lattice of report data;The line number of accounting report data, columns
And row height, col width;Line information, the cell formats information of the gauge outfit of report data are parsed, and calculates the gauge outfit
Row height and col width.
Include in the embodiment, the step of report data is converted into Json formatted datas:Obtain the starting of report data
Cell and end unit lattice, the line number of accounting report data, columns and row is high, col width parse the gauge outfit of report data
Line information, cell formats information, and the row height and col width of the gauge outfit are calculated, and then realize ERP forms in real time
Format information lossless is converted to the form that mobile terminal can represent.
In one embodiment of the invention, as shown in Figure 1 b, it is preferable that also include:
Whether step 1402, judges there is the form data for splitting and freezing in report data;
Step 1404, when there is the form data for splitting and freezing in report data, the form data that analytical decomposition freezes;
Whether step 1406, judges there is chart format and data message in report data;
Step 1408, when having chart format and data message in report data, processes chart format and data message;
Whether step 1410, judges there is dynamic area information in report data;
Step 1412, when having dynamic area information in report data, parses and conversion dynamic area information;
Step 1414, when in report data without the form data freezed is split, and does not have in report data
When having chart format and data message, and when not having dynamic area information in report data, do not process.
In this embodiment, when there is the form data for splitting and freezing in report data, the form that analytical decomposition freezes
Information, and when there is chart format and data message in report data, chart format and data message are processed, and in report
When there is dynamic area information in table data, parse and conversion dynamic area information, and then make the form of mobile terminal directly from ERP forms
Data source directly reads and loads data, carries out same effect and represents.
In one embodiment of the invention, as shown in Figure 1 b, it is preferable that step 1412, parse and change dynamic area and believe
The step of breath, includes:
Step 4122, changes the Cell values of dynamic area information, is stored in the form of 2-D data;
Step 4124, parses the cell formats information of dynamic area information, and is converted to assembled unit sound of laughing formula;
Step 4126, changes the attribute of activating business of dynamic area information;
Step 4128, calculates the row height and col width of assembled unit sound of laughing formula.
In this embodiment, parse and include the step of changing dynamic area information:The Cell values of dynamic area information are changed, with
The form storage of 2-D data, parses the cell formats information of dynamic area information, and is converted to assembled unit sound of laughing formula, changes
The attribute of activating business of dynamic area information, calculate assembled unit sound of laughing formula row is high and col width, without new special of exploitation design
Form and the report data in ERP system is automatically converted to the report data that suitable mobile terminal represents.
In one embodiment of the invention, it is preferable that cell formats information includes following a kind of or its combination:Word
Whether folds show for body, cell line style, alignment thereof, color, cell.
In this embodiment, cell formats information includes following a kind of or its combination but not limited to this:Font, cell
Whether folds show for line style, alignment thereof, color, cell.
In one embodiment of the invention, as shown in Figure 1 b, it is preferable that step 110, by the form number of mobile terminal form
Include according to the step of representing in terminal:
Step 1102, according to the report data of mobile terminal form, draws generation report page;
Step 1104, by links and accesses report page, terminal is presented in by the report data of mobile terminal form.
In this embodiment, the step of report data of mobile terminal form being represented in terminal includes:According to mobile terminal
The report data of form, draws the generation HTML5 pages, it is ensured that the form one in the report style and data and ERP system that represent
Cause, mobile terminal can check the detailed data of bordereau by links and accesses report page.
The embodiment of second aspect present invention, proposes a kind of converting system 200 of ERP system report data, and Fig. 2 shows
The schematic block diagram of the converting system 200 of the ERP system report data of one embodiment of the present of invention:
Acquiring unit 202, the report data for obtaining bordereau from ERP system;
Converting unit 204, for report data to be converted into Json formatted datas, and state Json formatted datas send to
WEB terminal;
First resolution unit 206, for being parsed to Json formatted datas by WEB terminal, generation mobile terminal form
Report data;
Represent unit 208, for the report data of mobile terminal form to be represented in terminal.
The converting system 200 of the ERP system report data that the present invention is provided, acquiring unit 202 obtains industry from ERP system
The report data of business form, the report data that converting unit 204 will get is converted to Json formatted datas, and sends to WEB
End, after the first resolution unit 206 gets Json formatted datas, is parsed using JavaScript, generates mobile terminal form
Report data, the report data of mobile terminal form is represented on unit 208 is represented, can be by the form number in ERP system
According to the report data that suitable mobile terminal represents is automatically converted to, without separately developing a set of new single purpose statement of design, in tradition
PC ends and mobile terminal can check same number evidence with same form, user is put into substantial amounts of exploitation and safeguard money
Source, it is possible to the easily report data in mobile terminal is checked and subscribes to ERP system.
In the above-mentioned technical solutions, as shown in Figure 2, it is preferable that converting unit 204 also includes:Computing unit 2042, is used for
The line number of accounting report data, columns and row is high, col width;Second resolution unit 2044, the gauge outfit for parsing report data
Line information, cell formats information, and calculate gauge outfit row is high and col width;Acquiring unit 202, is additionally operable to obtain form
The start element lattice and end unit lattice of data.
In the technical scheme, acquiring unit 202 obtains the start element lattice and end unit lattice of report data, calculates single
The line number of first 2042 accounting report data, columns and row is high, col width, the second resolution unit 2044 parses the gauge outfit of report data
Line information, cell formats information, and calculate the gauge outfit row is high and col width, and then realize ERP forms in real time
Format information lossless be converted to the form that mobile terminal can represent.
In the above-mentioned technical solutions, as shown in Figure 2, it is preferable that converting unit 204, it is additionally operable to have in report data
During the form data that fractionation is freezed, the form data that analytical decomposition freezes;There are chart format and data to believe in report data
During breath, chart format and data message are processed;When having dynamic area information in report data, parsing and conversion dynamic area are believed
Breath.
In the technical scheme, when converting unit 204 has the form data for splitting and freezing in report data, parsing is torn open
Divide the form data freezed, and when there is chart format and data message in report data, process chart format and data
Information, and when there is dynamic area information in report data, parse and conversion dynamic area information, and then make the form of mobile terminal
Data are directly directly read and loaded from ERP report datas source, same effect is carried out and is represented.
In the above-mentioned technical solutions, as shown in Figure 2, it is preferable that converting unit 204, for changing dynamic area information
Cell values, are stored in the form of 2-D data;Second resolution unit, is additionally operable to parse the cell formats letter of dynamic area information
Breath, and be converted to assembled unit sound of laughing formula;Converting unit, is additionally operable to change the attribute of activating business of dynamic area information;Calculate single
Unit, is additionally operable to calculate the row height and col width of assembled unit sound of laughing formula.
In the technical scheme, converting unit 204 changes the Cell values of dynamic area information, is deposited in the form of 2-D data
Storage, the second resolution unit 2044 parses the cell formats information of dynamic area information, and is converted to assembled unit sound of laughing formula, changes
Unit 204 changes the attribute of activating business of dynamic area information, and computing unit 2042 calculates the row height and row of assembled unit sound of laughing formula
Width, is automatically converted to what suitable mobile terminal represented without the new single purpose statement of exploitation design by the report data in ERP system
Report data.
In the above-mentioned technical solutions, it is preferable that cell formats information includes following a kind of or its combination:Font, unit
Whether folds show for lattice line style, alignment thereof, color, cell.
In the technical scheme, cell formats information includes following a kind of or its combination but not limited to this:Font, unit
Whether folds show for lattice line style, alignment thereof, color, cell.
In the above-mentioned technical solutions, as shown in Figure 2, it is preferable that representing unit 208 includes:
Page generating unit 2082, for the report data according to mobile terminal form, draws generation report page;
Represent unit 208, be additionally operable to, by links and accesses report page, the report data of mobile terminal form is presented in into end
End.
In the technical scheme, representing unit 208 includes:Form number of the page generating unit 2082 according to mobile terminal form
According to the drafting generation HTML5 pages, it is ensured that the report style and data for representing are consistent with the form in ERP system, and mobile terminal can lead to
Cross and represent the links and accesses report page of unit 208, check the detailed data of bordereau.
In specific embodiment, the bordereau data in ERP system are converted to the data of mobile terminal form, first had to
Query of subscription goes out report data (CellsModel) from ERP system, and report data then is converted into Json forms, finally will
The data of Json forms are transmitted to WEB terminal and parse, and ultimately generate the report data of mobile terminal form.
The form and data of bordereau are stored in the form of list data model (CellsModel) in ERP system, should
The data model of model record form unit behind, comprising two parts:
(1) data based on cell, format information, display content comprising cell, in addition, if being combining unit
Unit information storage is also served as, its position is the position of start element;
(2) data based on region, including two parts in position and data.Position part includes start element, phase
For the skew of start element, the data recorded in data division include region setting-out, keyword, picture of floating etc..
Specific transfer process and bandwagon effect is described below:
(1) CellsModel conversions Json processes are as follows:
1) CellsMode (report data model), AreaPosition (table sample starting and ending cell) are obtained;
2) accounting report line number, columns, width, information high;
3) configuration information that parsing form splits, freezes;
4) parsing gauge outfit line information, cell style information, calculate row col width high, and hiding row are not involved in calculating, ultra-wide
The automatic interception of row;
5) chart format and data message are processed;
6) parse and conversion dynamic area information.
Wherein, parsing and changing dynamic area information Step includes:The Cell values of dynamic area are changed, with two-dimensional data storage;
Analytic Traveling Column Properties, calculate starting row, end line, starting column, end column;Resolution unit sound of laughing formula, including font, unit ruling
Whether folds show for bar pattern, alignment thereof, color, cell;Shifting combination cell information, calculates starting row, terminates
Row, starting column, end column;Change attribute of activating business.
(2) the Json data that ERP system will be converted are transmitted to WEB terminal, after WEB terminal gets the data, use
JavaScript is parsed, and according to the report messages for parsing, draws the generation HTML5 pages, it is ensured that the report style for representing
And data are consistent with the form in ERP system, Fig. 3 shows that the mobile terminal form of a specific embodiment of the invention is illustrated
Figure, mobile terminal can check the detailed data of bordereau by links and accesses report page.
In the description of this specification, the description of term " one embodiment ", " some embodiments ", " specific embodiment " etc.
Mean that the specific features, structure, material or the feature that are described with reference to the embodiment or example are contained in of the invention at least one real
In applying example or example.In this manual, the schematic representation to above-mentioned term is not necessarily referring to identical embodiment or reality
Example.And, the specific features of description, structure, material or feature can in one or more any embodiments or example with
Suitable mode is combined.
The preferred embodiments of the present invention are the foregoing is only, is not intended to limit the invention, for the skill of this area
For art personnel, the present invention can have various modifications and variations.It is all within the spirit and principles in the present invention, made any repair
Change, equivalent, improvement etc., should be included within the scope of the present invention.
Claims (12)
1. a kind of conversion method of ERP system report data, it is characterised in that including:
The report data of bordereau is obtained from ERP system;
The report data is converted into Json formatted datas, and the Json formatted datas are sent to WEB terminal;
The Json formatted datas are parsed by the WEB terminal, generates the report data of mobile terminal form;
The report data of the mobile terminal form is represented in terminal.
2. the conversion method of ERP system report data according to claim 1, it is characterised in that described by the form
The step of data are converted to the Json formatted datas includes:
Obtain the start element lattice and end unit lattice of the report data;
Calculate line number, columns and row height, the col width of the report data;
Parse line information, the cell formats information of the gauge outfit of the report data, and calculate the gauge outfit row it is high and
Col width.
3. the conversion method of ERP system report data according to claim 2, it is characterised in that also include:
When there is the form data for splitting and freezing in the report data, the form data for splitting and freezing is parsed;
When there is chart format and data message in the report data, the chart format and data message are processed;
When there is dynamic area information in the report data, the dynamic area information is parsed and changed.
4. the conversion method of ERP system report data according to claim 3, it is characterised in that the parsing and conversion
The step of dynamic area information, includes:
The Cell values of the dynamic area information are changed, is stored in the form of 2-D data;
The cell formats information of the dynamic area information is parsed, and is converted to assembled unit sound of laughing formula;
Change the attribute of activating business of the dynamic area information;
Calculate the row height and col width of the assembled unit sound of laughing formula.
5. the conversion method of ERP system report data according to claim 4, it is characterised in that
The cell formats information includes following a kind of or its combination:Font, cell line style, alignment thereof, color,
Whether folds show cell.
6. the conversion method of ERP system report data according to any one of claim 1 to 5, it is characterised in that described
The step of report data of the mobile terminal form is represented in the terminal includes:
According to the report data of the mobile terminal form, generation report page is drawn;
By report page described in links and accesses, the report data of the mobile terminal form is presented in the terminal.
7. a kind of converting system of ERP system report data, it is characterised in that including:
Acquiring unit, the report data for obtaining bordereau from ERP system;
Converting unit, for the report data to be converted into Json formatted datas, and by the Json formatted datas send to
WEB terminal;
First resolution unit, for being parsed to the Json formatted datas by the WEB terminal, generation mobile terminal form
Report data;
Represent unit, for the report data of the mobile terminal form to be represented in terminal.
8. the converting system of ERP system report data according to claim 7, it is characterised in that the converting unit is also
Including:
Computing unit, line number, columns and row height, col width for calculating the report data;
Second resolution unit, the line information of the gauge outfit for parsing the report data, cell formats information, and calculate
The row height and col width of the gauge outfit;
The acquiring unit, is additionally operable to obtain the start element lattice and end unit lattice of the report data.
9. the converting system of ERP system report data according to claim 8, it is characterised in that
The converting unit, when being additionally operable to have the form data for splitting and freezing in the report data, parses the fractionation
The form data freezed;When there is chart format and data message in the report data, the chart format and number are processed
It is believed that breath;When there is dynamic area information in the report data, the dynamic area information is parsed and changed.
10. the converting system of ERP system report data according to claim 9, it is characterised in that
The converting unit, is additionally operable to change the Cell values of the dynamic area information, is stored in the form of 2-D data;
Second resolution unit, is additionally operable to parse the cell formats information of the dynamic area information, and it is single to be converted to combination
First sound of laughing formula;
The converting unit, is additionally operable to change the attribute of activating business of the dynamic area information;
The computing unit, is additionally operable to calculate the row height and col width of the assembled unit sound of laughing formula.
The converting system of 11. ERP system report datas according to claim 10, it is characterised in that
The cell formats information includes following a kind of or its combination:Font, cell line style, alignment thereof, color,
Whether folds show cell.
The converting system of the 12. ERP system report data according to any one of claim 7 to 11, it is characterised in that institute
State and represent unit and include:
Page generating unit, for the report data according to the mobile terminal form, draws generation report page;
It is described to represent unit, it is additionally operable to by report page described in links and accesses, by the report data exhibition of the mobile terminal form
The present terminal.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611078575.0A CN106709697A (en) | 2016-11-29 | 2016-11-29 | ERP system form data conversion method and conversion system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611078575.0A CN106709697A (en) | 2016-11-29 | 2016-11-29 | ERP system form data conversion method and conversion system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN106709697A true CN106709697A (en) | 2017-05-24 |
Family
ID=58935181
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201611078575.0A Pending CN106709697A (en) | 2016-11-29 | 2016-11-29 | ERP system form data conversion method and conversion system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106709697A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107341005A (en) * | 2017-06-20 | 2017-11-10 | 东软集团股份有限公司 | Chart generation method and its device |
CN110955715A (en) * | 2019-12-03 | 2020-04-03 | 望海康信(北京)科技股份公司 | ERP system, data conversion method and device of target platform and electronic equipment |
CN111027297A (en) * | 2019-12-23 | 2020-04-17 | 海南港澳资讯产业股份有限公司 | Method for processing key form information of image type PDF financial data |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103324731A (en) * | 2013-06-28 | 2013-09-25 | 中国农业银行股份有限公司 | Method and device for converting spreadsheet file into web format file |
CN103345522A (en) * | 2013-07-18 | 2013-10-09 | 北京润通丰华科技有限公司 | Method and device for showing and processing and showing data |
US20140149836A1 (en) * | 2012-11-29 | 2014-05-29 | Jason Bedard | Dashboard Visualizations Using Web Technologies |
CN104317925A (en) * | 2014-10-31 | 2015-01-28 | 北京思特奇信息技术股份有限公司 | Method and system for efficient front-end development and display |
CN105824642A (en) * | 2016-03-23 | 2016-08-03 | 浪潮软件集团有限公司 | JS component for rapidly developing mobile phone tax client declaration form |
-
2016
- 2016-11-29 CN CN201611078575.0A patent/CN106709697A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20140149836A1 (en) * | 2012-11-29 | 2014-05-29 | Jason Bedard | Dashboard Visualizations Using Web Technologies |
CN103324731A (en) * | 2013-06-28 | 2013-09-25 | 中国农业银行股份有限公司 | Method and device for converting spreadsheet file into web format file |
CN103345522A (en) * | 2013-07-18 | 2013-10-09 | 北京润通丰华科技有限公司 | Method and device for showing and processing and showing data |
CN104317925A (en) * | 2014-10-31 | 2015-01-28 | 北京思特奇信息技术股份有限公司 | Method and system for efficient front-end development and display |
CN105824642A (en) * | 2016-03-23 | 2016-08-03 | 浪潮软件集团有限公司 | JS component for rapidly developing mobile phone tax client declaration form |
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107341005A (en) * | 2017-06-20 | 2017-11-10 | 东软集团股份有限公司 | Chart generation method and its device |
CN107341005B (en) * | 2017-06-20 | 2020-09-18 | 东软集团股份有限公司 | Chart generation method and device |
CN110955715A (en) * | 2019-12-03 | 2020-04-03 | 望海康信(北京)科技股份公司 | ERP system, data conversion method and device of target platform and electronic equipment |
CN110955715B (en) * | 2019-12-03 | 2023-04-28 | 望海康信(北京)科技股份公司 | Data conversion method and device for ERP system and target platform and electronic device |
CN111027297A (en) * | 2019-12-23 | 2020-04-17 | 海南港澳资讯产业股份有限公司 | Method for processing key form information of image type PDF financial data |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
RU2370810C2 (en) | Methods and systems for document marking | |
CN101201832B (en) | Method and system for optimizing web page image | |
US20130191732A1 (en) | Fixed Format Document Conversion Engine | |
CN106886551B (en) | Method and device for displaying image by using markup language | |
CN101699426A (en) | Document format conversion system and method | |
CN107402985B (en) | Video special effect output control method and device and computer readable storage medium | |
CN104516867A (en) | Table reordering method and table reordering system | |
CN105808217A (en) | Flow chart drawing method and system based on XML | |
CN106709697A (en) | ERP system form data conversion method and conversion system | |
CN103365862A (en) | Method and equipment for generating pictures corresponding to pages | |
CN110008366B (en) | Construction drawing previewing method and system | |
CN103902662A (en) | Test question generating method based on browser | |
CN106776800B (en) | Page generation method, device and system for AngularJS framework | |
KR101147256B1 (en) | Producing apparatus and method for a standized electronic book | |
CN105956133B (en) | Method and device for displaying file on intelligent terminal | |
CN113867694A (en) | Method and system for intelligently generating front-end code | |
CN101577007A (en) | Method and device for generating pictures | |
CN104715054A (en) | Method for converting Silverlight content into HTML webpage content | |
CN109815451A (en) | A kind of PDF generation method, device and equipment | |
CN112560406B (en) | Method and device for generating forecast consultation demonstration manuscript | |
CN103077156A (en) | Method for producing electronic magazine in mobile equipment | |
Du et al. | A study of GIS development based on KML and Google Earth | |
CA2602749C (en) | System and method of report representation | |
CN112433995A (en) | File format conversion method, system, computer equipment and storage medium | |
CN115114556A (en) | Method and device for creating page |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170524 |