CN101968782A - Sample report conversion method and system - Google Patents
Sample report conversion method and system Download PDFInfo
- Publication number
- CN101968782A CN101968782A CN 200910089920 CN200910089920A CN101968782A CN 101968782 A CN101968782 A CN 101968782A CN 200910089920 CN200910089920 CN 200910089920 CN 200910089920 A CN200910089920 A CN 200910089920A CN 101968782 A CN101968782 A CN 101968782A
- Authority
- CN
- China
- Prior art keywords
- file
- attribute information
- report
- sample
- financial statements
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Abstract
The invention provides a sample report conversion method and a system. The method comprises the following steps of: acquiring a sample report file of a bank report terminal and a general report file of a bank report customizing server; acquiring the format and attribute information of the sample report file; recording the format and attribute information of the sample report file in the general report file and acquiring the format and attribute information of the general report file recording the format and attribute information of the sample report file; and converting the general report file recording the format and attribute information of the sample report file into a target report file recognized by the bank report customizing server according to the format and attribute information of the general report file recording the format and attribute information of the sample report file. A report file recognized by the report customizing platform is generated according to the sample report file, thus the processing efficiency of report files is improved.
Description
Technical field
The form technology is closed in the present invention, especially in regard to a kind of report form sample converting system and method for form technology.
Background technology
Along with the widespread use of computing machine, every field is all finished routine work with software in a large number, and form is a necessary part in the enterprise application software system.In the form performance history, table sample and logic that the developer need provide according to the business personnel use form customization instrument to finish final form.The table sample that the business personnel provides often leaves in WORD or the EXCEL file, form customization platform can not be continued to use table sample form wherein, the developer need customize drafting table sample in the platform at form again according to the table sample file that the business personnel provides, and could generate the report file that form customization platform uses.The problem of bringing of above-mentioned way is: generally there are a lot of table samples in large enterprise, and shows the change that sample does not also stop, and the workload of drawing the table sample is very big; And form customizes the drawing tool complicated operation of platform, has reduced the speed of enterprise response form demand.
At present, more common way is to provide an OFFICE plug-in unit by form customization instrument, on the basis of the table sample file of WORD/EXCEL form, add logic (as adding data field, subtotal total etc.) in conjunction with the WORD/EXCEL instrument, with recycling table sample.As shown in Figure 1, an OFFICE plug-in unit has been installed on the client 101, the developer uses this OFFICE plug-in unit to carry out the interpolation of form logic, and the table sample file distribution that will have logic then is to form application server 102.Business personnel's (as client 103 and client 104) sends report generation order by the WEB application server to the form application server by access to netwoks WEB application server.After the form application server receives order, utilize the report form showing module that the table sample file of the WORD/EXCEL form that has logic is resolved; And connect the database application server and obtain report data, generate and have the form of data, and will generate the result and return to WEB application server confession business personnel and check and print.
Form application server his-and-hers watches sample file focuses on, and access data sources generates the result, causes report server and data access network pressure very big, can not satisfy enterprise-level client's user demand.
Summary of the invention
The purpose of the embodiment of the invention is to provide a kind of report form sample conversion method and system, generates the form file destination that form customization platform can be discerned, to improve the report file treatment effeciency.
To achieve these goals, the embodiment of the invention provides a kind of report form sample conversion method, and described method comprises: obtain the report form sample file of bank return terminal and the all-purpose financial statements file of bank return customization server; Obtain the form and the attribute information of described report form sample file; The form and the attribute information of described report form sample file are recorded in the described all-purpose financial statements file, and obtain the form and the attribute information of the all-purpose financial statements file of the form that write down described report form sample file and attribute information; According to the form of the all-purpose financial statements file of form that has write down described report form sample file and attribute information and form that attribute information will write down described report form sample file and the all-purpose financial statements file conversion of attribute information is the form file destination of described bank return customization server identification.
To achieve these goals, the embodiment of the invention also provides the report form sample converting system, and described system comprises: the file deriving means is used to obtain the report form sample file of bank return terminal and the all-purpose financial statements file of bank return customization server; Information acquisition device is used to obtain the form and the attribute information of described report form sample file; Information record carrier is used for the form and the attribute information of described report form sample file are recorded described all-purpose financial statements file, and obtains the form and the attribute information of the all-purpose financial statements file of the form that write down described report form sample file and attribute information; File conversion device, being used for according to the form of the all-purpose financial statements file of form that has write down described report form sample file and attribute information and form that attribute information will write down described report form sample file and the all-purpose financial statements file conversion of attribute information is the form file destination of described bank return customization server identification.
The useful technique effect of the embodiment of the invention: the table sample file that the business personnel is made generates the report file that form customization platform can be discerned as input, has improved the report file treatment effeciency.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art, to do one to the accompanying drawing of required use in embodiment or the description of the Prior Art below introduces simply, apparently, accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the table sample file handling procedure synoptic diagram of prior art;
Fig. 2 is an embodiment of the invention report form sample conversion method process flow diagram;
Fig. 3 A is an embodiment of the invention report form sample converting system structural representation;
Fig. 3 B is another embodiment of the present invention report form sample converting system structural representation;
Fig. 4 is the synoptic diagram of each ingredient in the report form sample converting system of the embodiment of the invention;
Fig. 5 is the fixing row of the embodiment of the invention, every page of unfixing report form sample file synoptic diagram of going;
Fig. 6 is embodiment of the invention client 401 structural representations;
Fig. 7 is the structural representation of embodiment of the invention data storage device 603;
Fig. 8 is the structural representation that embodiment of the invention table sample form is inherited analytical equipment 601;
Fig. 9 is the structural representation of embodiment of the invention form customizing device 602;
Figure 10 is the not structural representation of the form of fixing row of the embodiment of the invention;
Figure 11 is the composition synoptic diagram of embodiment of the invention type form;
Figure 12 is the composition synoptic diagram of embodiment of the invention headers and footers part;
Figure 13 is the composition synoptic diagram of the detailed part of the embodiment of the invention;
Figure 14 is the all-purpose financial statements form XML file synoptic diagram of the table sample file of embodiment of the invention Fig. 5;
Figure 15 is a structural representation for embodiment of the invention statement;
Figure 16 is the all-purpose financial statements form XML file synoptic diagram of embodiment of the invention statement;
Figure 17 is the realization flow figure of the invention process WORD/EXCEL table sample document analysis module 801;
Figure 18 is the realization flow figure of embodiment of the invention statement form file generating module 802.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the invention, the technical scheme in the embodiment of the invention is clearly and completely described, obviously, described embodiment only is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, those of ordinary skills belong to the scope of protection of the invention not making the every other embodiment that is obtained under the creative work prerequisite.
The embodiment of the invention provides a kind of report form sample converting system and method, the form style and the form that define in the WORD/EXCEL table sample file that the business personnel can be submitted to are translated into all-purpose financial statements form XML file through parsing, and with all-purpose financial statements form XML file conversion to the discernible statement form file destination of different form customization platform, edit and revise the form service logic for the developer.
Fig. 2 is an embodiment of the invention report form sample conversion method process flow diagram, and as shown in Figure 2, described method comprises:
Step S201: obtain the report form sample file of bank return terminal and the all-purpose financial statements file of bank return customization server;
Step S202: obtain form and attribute information in the described report form sample file; Promptly obtain gauge outfit, detail and the table tail information of described report form sample file, and obtain the attribute information of described gauge outfit, detail and table tail information, information such as gauge outfit, detail and table tail are the format information in the described report form sample file.The attribute information of described gauge outfit, detail and table tail comprises: literal, cell, lines and colouring information.
Step S203: the form and the attribute information of described report form sample file are recorded in the described all-purpose financial statements file, and obtain the form and the attribute information of the all-purpose financial statements file of the form that write down described report form sample file and attribute information;
Step S204: according to the form of the all-purpose financial statements file of form that has write down described report form sample file and attribute information and form that attribute information will write down described report form sample file and the all-purpose financial statements file conversion of attribute information is the form file destination of described bank return customization server identification.To obtain the report form type information of described bank return customization server identification earlier, and be the form file destination according to the form of the all-purpose financial statements file of described report form type information, the form that has write down described report form sample file and attribute information and form that attribute information will write down described report form sample file and the all-purpose financial statements file conversion of attribute information.The report file type of described bank return customization server identification comprises XML form or non-XML form.Before being the form file destination, the all-purpose financial statements file conversion of form that will write down described report form sample file and attribute information needs to judge whether the report file that the form customization platform of generation is discerned is the XML form, if be the XML form, reading format element control documents obtains the XML pattern of report file.In the format item control XML file, be an XML Schema file, the report file structure and the content model of the bank return customization server of XML form accepted in definition and description, and this XMLSchema file can be provided by the form customization server.If be non-XML form, obtain the text message in the all-purpose financial statements form XML file, call the programmable interface that the form customization server provides, the text node attribute is set.
Before form that obtains described report form sample file and attribute information, described method also comprises: judge whether described report form sample file is to preserve with the XML form; If visit described report form sample file by XML; If not, use programmable interface to visit described table sample file.
Optionally, described method also comprises: add logic in described form file destination, will change described form file destination.
Fig. 3 A is an embodiment of the invention report form sample converting system structural representation, and as shown in Figure 3A, described system comprises: file deriving means 301, information acquisition device 302, information record carrier 303 and file conversion device 304.
File deriving means 301 is used to obtain the report form sample file of bank return terminal and the all-purpose financial statements file of bank return customization server.Information acquisition device 302 is used for obtaining the form and the attribute information of described report form sample file; Specifically be used to obtain gauge outfit, detail and the table tail information of described report form sample file; Obtain the attribute information of described gauge outfit, detail and table tail information.The attribute information of described gauge outfit, detail and table tail comprises: literal, cell, lines and colouring information.Information record carrier 303 is used for the form and the attribute information of described report form sample file are recorded described all-purpose financial statements file, and obtains the form and the attribute information of the all-purpose financial statements file of the form that write down described report form sample file and attribute information.File conversion device 304, being used for according to the form of the all-purpose financial statements file of form that has write down described report form sample file and attribute information and form that attribute information will write down described report form sample file and the all-purpose financial statements file conversion of attribute information is the form file destination of described bank return customization server identification, specifically be used to obtain the report form type information of described bank return customization server identification, according to described report form type information, having write down the form of all-purpose financial statements file of the form of described report form sample file and attribute information and form that attribute information will write down described report form sample file and the all-purpose financial statements file conversion of attribute information is the form file destination.The report file type of described bank return customization server identification comprises XML form or non-XML form.Before being the form file destination, the all-purpose financial statements file conversion of form that will write down described report form sample file and attribute information needs to judge whether the report file that the form customization platform of generation is discerned is the XML form, if be the XML form, reading format element control documents obtains the XML pattern of report file.In the format item control XML file, be an XML Schema file, the report file structure and the content model of the bank return customization server of XML form accepted in definition and description, and this XML Schema file can be provided by the form customization server.If be non-XML form, obtain the text message in the all-purpose financial statements form XML file, call the programmable interface that the form customization server provides, the text node attribute is set.
Optional described device also comprises: logic adding set 305 is used for adding logic at described form file destination, will change described form file destination.
Shown in Fig. 3 B, described system also comprises: form judgment means 306 is used to judge whether described report form sample file is to preserve with the XML form; File access device 307 when described report form sample file is when preserving with the XML form, is used for visiting described report form sample file by XML; When described report form sample file is when preserving with the XML form, be used to use programmable interface to visit described table sample file.
Describe in detail below and how will show the sample document analysis and become the all-purpose financial statements formatted file, and all-purpose financial statements formatted file all-purpose financial statements formatted file is transformed into different forms customizes the discernible statement form file destination of platform (being the bank return customization server).
Fig. 4 is the synoptic diagram of each ingredient in the report form sample converting system of the embodiment of the invention, as shown in Figure 4, the report form sample converting system comprises client 401, client 402, form application server 403, and client 401 is obtained the report form sample file of bank return terminal and the all-purpose financial statements file of bank return customization server; From the report form sample file, obtain described form and attribute information; The form and the attribute information of described report form sample file are recorded in the described all-purpose financial statements file, and obtain the form and the attribute information of the all-purpose financial statements file of the form that write down described report form sample file and attribute information; According to the form of the all-purpose financial statements file of form that has write down described report form sample file and attribute information and form that attribute information will write down described report form sample file and the all-purpose financial statements file conversion of attribute information is the form file destination that described bank return customization server can be discerned.Client 401 can also be carried out logic to the form file destination and be added generation table sample file 404, obtains report file 405 according to table sample file 404, and report file 405 is sent to form application server 403; The business personnel utilizes client 402 (being the bank return terminal) to download report file 405 and data file 406 from form application server 403, the report data of data file 406 can be inserted report file 405.Alternatively, client 401 can not send report file 405 to form application server 403 yet, and client 402 is directly obtained report file 405 and data file 406 from client 401.
As shown in Figure 6, client 401 comprises the succession of table sample form analytical equipment 601, form customizing device 602 and data storage device 603.Form customizing device 602 is provided by form customization platform, is used to provide logical edit and print preview function to report file.Data storage device 603 is file system, is used for stored table sample file 404, all-purpose financial statements formatted file 701, format item control documents 702, statement form file destination 703, report file 405 and data file 406 etc., as shown in Figure 7.
It is that a report form sample is inherited program automatically that table sample form is inherited analytical equipment 601, and it is used to resolve the report form sample file and generates and can be customized the statement form file destination of showing sample having of land identification by form.It at first receives the table sample file that leaves in the WORD/EXCEL document, resolves to generate an all-purpose financial statements formatted file, the all-purpose financial statements formatted file is translated into the different discernible statement form file destinations of form customization platform again.
As shown in Figure 8, table sample form is inherited analytical equipment 601 and is comprised table sample document analysis module 801 and statement form file generating module 802, table sample file 404 carries out dissection process in 801 pairs of data memory storages 603 of table sample document analysis module, obtains all-purpose financial statements formatted file 701.Statement form file generating module 802 reads all-purpose financial statements form XML file, therefrom obtains the report form sample format information, and all-purpose financial statements formatted file 701 is generated statement form file destination 703.Format item control documents 702 is XML Schema files, and the report file structure and the content model of the form customization platform of XML form accepted in definition and description.This XML Schema file, can customize platform by form provides.Statement form file destination 703 is the files that contain report form sample and form that can be customized land identification by form, and it is inherited analytical equipment resolution table sample file by table sample form and generates automatically.
Fig. 9 is the structural representation of embodiment of the invention form customizing device 602, and as shown in Figure 9, form customizing device 602 comprises logical edit module 901 and report form showing module 902.Logical edit module 901 is added logic and is generated report file 405 in statement form file destination 703.Report file 405 be the form developer on the basis of statement form file destination, added the report file after the form service logic, this file just can the demonstrating data result after connecting data source.In statement form file destination 703, add logic, be meant on the basis of statement form file destination 703 add, operation (changing " * * * form " as " XXXX form " with Fig. 5 into) such as deletion and modification, generate report file, embody the extensibility of statement form file destination 703, the invention is not restricted to this; If statement form file destination 703 is not added logic, statement form file destination 703 is report file.
Wherein, the form developer generally is the personnel of the departments of science and technology, and they receive the table sample file 404 that the business personnel provides, and form customization platform editor service logic is used in the design back by analysis, but finally generates demonstrating data result's report file.The business personnel utilizes client 402 to download report file and data file and print preview on individual PC from form application server 403 or client 401.
For the technical scheme of the clearer description embodiment of the invention, form can be divided into: the form of " fixing row, every page fixing row ", the form of " fixing row, every page of unfixing row " and three kinds of report form type of form of " unfixing row ".
Figure 10 is the not structural representation of the form of fixing row of the embodiment of the invention, as can be seen from Figure 10, growth along with the professional time, gauge outfit will occur 2009,2010,2011 ..., for the unfixed form of this gauge outfit, the business personnel can't directly draw and cover the table sample in whole times, and the developer is merely able to realize by the non-standard report function that form customization platform provides, no longer describes in detail here.
The embodiment of the invention is only carried out the report form sample conversion to the form of " fixing row, every page fixing row " and these two types of forms of form of " fixing row, every page of unfixing row ".
Table sample document analysis module 801 is analyzed the table sample file of WORD/EXCEL form, as shown in Figure 5, form is divided into three big major parts such as gauge outfit, detail, table tail, obtain attributes such as literal, cell, lines, finally above information with in certain format record to XML file (all-purpose financial statements form XML file).All-purpose financial statements form XML file is a predefined XML file, and it is the intermediate result that table sample form is inherited analytical equipment, has write down the table sample information of a form.As shown in figure 11, any type form all is made up of gauge outfit, detail, table tail three parts, in all-purpose financial statements form XML file, at＜report〉use＜reportheader under the root node〉node represents the table header branch,＜detail〉node represents detailed part,＜reportfooter〉node represents portion.At gauge outfit＜reportheader〉in two parts, can add line＜row with table tail＜reportfooter, as shown in figure 12.At detail＜detail〉part, further be subdivided into detailed header line＜title 〉, detailed data is capable＜data and detailed packet row＜group at detailed header line＜title, detailed data is capable＜data and detailed packet row＜group down can adding device lattice＜cell, as shown in figure 13.
At detailed header line＜title 〉, detailed data is capable＜data and detailed packet row＜group down can adding device lattice＜cell.For each row＜row〉or each cell＜cell, can add text＜text 〉, and be provided with the cell text formatting (＜font〉font and＜align alignment thereof).Cell can also add the form＜border of frame 〉, the thickness and the color that whether need to add frame line and lines around showing, as shown in figure 14.Figure 14 is the all-purpose financial statements form XML file of the WORD document table sample of Fig. 5, wherein, gauge outfit part＜reporthearder〉two＜row is arranged under the node〉node, the gauge outfit that shows this form partly has two style of writing words, first＜row one＜text is arranged under the node node " XXXX form ", be the title " XXXX form " of Fig. 5, its form can be at font＜font〉etc. be provided with in the node, in this few description.
Detailed part＜detail〉detailed header line＜title is arranged under the node, detailed data is capable＜data and detailed packet row＜group.With detailed header line＜title〉be example, it has a plurality of cell＜cell 〉, the literal of first cell is " number of the account ", is upper left side first cell in the form of Fig. 5, its form can be at font＜font 〉, frame＜border etc. be provided with in the node, in this few description.
Table portion＜the reportfooter of form〉one＜row is arranged under the node〉node, the table portion that shows this form has delegation's literal, at＜row〉one＜text is arranged under the node〉node " date printed: on February 11st, 2009 ", footline " date printed: on February 11st, 2009 " for the form of Fig. 5, its form can be at font＜font〉etc. be provided with in the node, in this few description.
All-purpose financial statements form XML file is not only applicable to the form of " the unfixing row of fixing row " in the above-mentioned type, is applicable to the form of " the fixing row of fixing row " yet.
Figure 15 is a structural representation for embodiment of the invention statement, and statement is the fixedly row of a WORD form, the report form sample file of every page fixing row.The all-purpose financial statements form XML file of XXXX statement as shown in figure 16.Wherein, " XXXX statement " leaves gauge outfit part＜reportheader in〉under the node.Detailed part＜detail〉node has a plurality of detailed header line＜title〉node, the cell in all forms all leaves detailed header line＜title in〉under the node, detailed header line＜title of each row form correspondence〉node.
How the table sample document analysis module 801 and the statement form file generating module 802 that describe in detail below among Fig. 8 realize showing sample file 404 generation statement form file destinations 703.
The realization flow figure of Figure 17 the invention process WORD/EXCEL table sample document analysis module 801, this flow process comprises:
Step S1701: the progress zone bit of initialization analysis program is set to gauge outfit.
The progress zone bit is meant the form part of current parsing, as gauge outfit, detail and table tail.For form, the ingredient of form must represent successively with the order of gauge outfit, detail, table tail, that is to say, when analysis program is resolved to detailed part, remaining form part only may be detailed or table tail, can not be gauge outfit, so initialization value that will resolving is set to gauge outfit.
Step S1702: whether the WORD/EXCEL table sample file of judging input is to preserve with the XML form, if not, carries out step S1703; If carry out step S304.WORD and EXCEL file are all supported the XML form, and when being when preserving with the XML form, we need use the method for analyzing XML file to read.
Step S1703: when WORD/EXCEL table sample file is not when preserving with the XML form, the programmable interface that use WORD/EXCEL provides conducts interviews, and reads data line.
Step S1704: when WORD/EXCEL table sample file is when preserving with the XML form, use XML resolver visits, and reads an XML node.
Step S1705: judge the progress zone bit of analysis program, directly enter the judgement and the parsing of form part according to the progress zone bit.
When the progress zone bit is gauge outfit, judge whether current line/node is gauge outfit.Generally speaking, the gauge outfit of form is delegation's literal (in the literal of WORD), perhaps unit lattice (in the form of WORD or EXCEL) that do not have frame.
If current line/node progress zone bit is not a gauge outfit, and when being detail, judge whether current line/node is detailed title.Generally speaking, the detailed title of form is a series of cells that have literal and frame of detailed part first row.If the progress zone bit is that detail and current line/node are not detailed titles, judge whether current line/node is detailed data.Generally speaking, the detailed data of form be a series of do not contain literal, the cell that has frame.If the progress zone bit is that detail and current line/node are not detailed datas, judge whether current line/node is detailed grouping.Generally speaking, the grouping of the detail of form is the one or more cells that have literal and frame that occur behind detailed title.Detailed grouping also may appear at after the detailed data before may appearing at detailed data.
If current line/node is not detailed grouping, when perhaps the progress zone bit is for the table tail, judge whether current line/node is the table tail.Generally speaking, the table tail of form is delegation's literal (in the literal of WORD), perhaps unit lattice (in the form of WORD or EXCEL) that do not have frame.
Step S1706:, the progress zone bit of analysis program is set according to above-mentioned judged result.
Step S1707: the text and the format information (as font, cell width etc.) that read table sample file.
Step S1708:, format information is write all-purpose financial statements form XML file with predefined XML structure according to different progress zone bits.
Step S1709: finish.
Judge whether to arrive end of file, if read the end, then expression table sample has been resolved and has been finished EOP (end of program).
Above step cycle is carried out, and constantly reads WORD/EXCEL table sample file, finishes EOP (end of program) up to whole parsings.
With Fig. 5 is example, supposes that initialization progress zone bit is " gauge outfit ".Read " XXXX form ", the progress zone bit is " gauge outfit ", and judged result is provided with the progress zone bit and is " gauge outfit ", capable the writing of all-purpose financial statements form XML file 2-8 for being gauge outfit.When read " number of the account | the amount of money | Currency Type | name in an account book | type of credential " time, the progress zone bit is " gauge outfit ", judged result is detailed title, the progress zone bit is set is " detail ", capable the writing of the all-purpose financial statements form XML file 9-18 of Figure 14: when reading " date printed: on February 11st, 2009 ", the progress zone bit is " detail ", judges and becomes the table tail, the progress zone bit is set is " table tail ", capable the writing of the all-purpose financial statements form XML file 37-42 of Figure 14.After whole table sample reads and changes and finishes, preserve all-purpose financial statements form XML file and terminator.Last generation result as shown in figure 14.
Figure 18 is the realization flow figure of embodiment of the invention statement form file generating module 802.This flow process comprises:
Step S1801: read the all-purpose financial statements form XML file that WORD/EXCEL table sample document analysis program generates.
Step S1802: use XML resolver resolves all-purpose financial statements form XML file.
Step S1803: whether the report file that the form customization platform that judging needs generation is discerned is the XML form, if carry out step S1804; Otherwise carry out step S1809.
Step S1804: reading format element control documents obtains the XML pattern of report file.
The format item control documents is an XML Schema file, and the report file structure and the content model of the form customization platform of XML form accepted in definition and description.This XML Schema file, can customize platform by form provides, and reading format element control documents obtains the XML pattern of report file, to add the form element.
Step S1805: obtain text message in the all-purpose financial statements form XML file (＜text〉node),, add text node according to the XML form that defines in the format item control documents.
Step S1806: obtain text attribute in the all-purpose financial statements form XML file (＜font〉node, as font, font size, position, color etc.),, the text node attribute is set according to the XML form that defines in the format item control documents.
Step S1807: obtain lines/frame information in the all-purpose financial statements form XML file (＜border〉node),, add lines/frame node according to the XML form that defines in the format item control documents.
Step S1808: obtain lines/frame attribute in the all-purpose financial statements form XML file (＜border〉node, as: length, width, position, color etc.), according to the XML form that defines in the format item control documents, lines/frame nodal community is set, carry out step S1813 then.
Step S1809: if report file is non-XML form, obtain text message in the all-purpose financial statements form XML file (＜text〉node), call the programmable interface that form customization platform provides, add text box.
Step S1810: obtain text attribute in the all-purpose financial statements form XML file (＜font〉node, as font, font size, position, color etc.), call the programmable interface that form customization platform provides, the text node attribute is set.
Step S1811: obtain lines/frame information in the all-purpose financial statements form XML file (＜border〉node), call the programmable interface that form customization platform provides, add lines/frame node.
Step S1812: obtain lines/frame attribute in the all-purpose financial statements form XML file (＜border〉node), call the programmable interface that form customization platform provides, lines/frame nodal community is set.
Step S1813: report form sample and form are preserved the statement form file destination after all changing and finishing.
Below with the detailed part＜detail among Figure 14〉the detailed header line＜title of node〉node is the step of example simple declaration Figure 18.
First cell＜cell〉a text＜text is arranged under the node〉node, according to this information, be that form object format file adds a text box or text node, word content is " number of the account "; Text＜text〉be font＜font behind the node node, it has pointed out current cell＜cell〉in word attribute, according to this information, for text box or the text node that adds in the first step is provided with text attribute; The 3rd step, font＜font〉be frame＜border behind the node node, it has pointed out current cell＜cell〉around whether need to add frame, according to this information, be that text box or the text node add in the first step add lines or lines node; At frame＜border〉intranodal has also been described the attribute of frame, according to this information, is lines or the lines node that adds in the 3rd step.Process above repeating is finished detailed header line＜title〉second cell＜cell of node〉conversion of node.
The statement form file destination that generates after above step is finished can be customized land identification by form and represent, and the developer can carry out the exploitation of form logic and the maintenance of table sample on this basis.
The table sample file that the embodiment of the invention is made according to the business personnel generates the report file that form customization platform can be discerned, and has improved the report file treatment effeciency.Concrete useful technique effect is as follows:
1) defined a kind of general XML file, the report form sample form behind the preservation WORD/EXCEL document analysis is convenient to convert to the discernible statement form file destination of form customization instrument;
2) statement form file destination of Sheng Chenging and manual drawing result are consistent, and can add the form logic on this basis, need not rely on server parses, just directly preview and printing;
3) solve the manual problem that repeats drafting table sample, reduced workload, reduced cost of development, satisfied the frequent change request of form more efficiently.
4) reduce the dependence that the form application server is represented function, disperseed the pressure of report generation, improved the efficient of report form showing.
Above-described embodiment; purpose of the present invention, technical scheme and beneficial effect are further described; institute is understood that; the above only is the specific embodiment of the present invention; and be not intended to limit the scope of the invention; within the spirit and principles in the present invention all, any modification of being made, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (14)
1. a report form sample conversion method is characterized in that, described method comprises:
Obtain the report form sample file of bank return terminal and the all-purpose financial statements file of bank return customization server;
Obtain the form and the attribute information of described report form sample file;
The form and the attribute information of described report form sample file are recorded in the described all-purpose financial statements file, and obtain the form and the attribute information of the all-purpose financial statements file of the form that write down described report form sample file and attribute information;
According to the form of the all-purpose financial statements file of form that has write down described report form sample file and attribute information and form that attribute information will write down described report form sample file and the all-purpose financial statements file conversion of attribute information is the form file destination of described bank return customization server identification.
2. the method for claim 1 is characterized in that, the form and the attribute information that obtain in the described report form sample file comprise:
Obtain gauge outfit, detail and the table tail information of described report form sample file;
Obtain the attribute information of described gauge outfit, detail and table tail information.
3. the method for claim 1, it is characterized in that, be that the form file destination of described bank return customization server identification comprises according to the all-purpose financial statements file conversion of the form of the all-purpose financial statements file of form that has write down described report form sample file and attribute information and form that attribute information will write down described report form sample file and attribute information:
Obtain the identification of described bank return customization server report form type information;
According to the form of the all-purpose financial statements file of described report form type information, the form that has write down described report form sample file and attribute information and form that attribute information will write down described report form sample file and the all-purpose financial statements file conversion of attribute information is the form file destination.
4. the method for claim 1 is characterized in that, described method also comprises: add logic in described form file destination, will change described form file destination.
5. the method for claim 1 is characterized in that, before form that obtains described report form sample file and attribute information, described method also comprises:
Judge whether described report form sample file is to preserve with the XML form;
If visit described report form sample file by XML;
If not, use programmable interface to visit described table sample file.
6. the method for claim 1 is characterized in that, the report file type of described bank return customization server identification comprises XML form or non-XML form.
7. method as claimed in claim 2 is characterized in that, the attribute information of described gauge outfit, detail and table tail comprises: literal, cell, lines and colouring information.
8. a report form sample converting system is characterized in that, described system comprises:
The file deriving means is used to obtain the report form sample file of bank return terminal and the all-purpose financial statements file of bank return customization server;
Information acquisition device is used to obtain the form and the attribute information of described report form sample file;
Information record carrier is used for the form and the attribute information of described report form sample file are recorded described all-purpose financial statements file, and obtains the form and the attribute information of the all-purpose financial statements file of the form that write down described report form sample file and attribute information;
File conversion device, being used for according to the form of the all-purpose financial statements file of form that has write down described report form sample file and attribute information and form that attribute information will write down described report form sample file and the all-purpose financial statements file conversion of attribute information is the form file destination of described bank return customization server identification.
9. system as claimed in claim 8 is characterized in that,
Described information acquisition device specifically is used to obtain gauge outfit, detail and the table tail information of described report form sample file and obtains described gauge outfit, detail and show the attribute information of tail.
10. system as claimed in claim 8,
Described file conversion device, specifically being used to obtain the report form type information of described bank return customization server identification, is the form file destination according to the form of the all-purpose financial statements file of described report form type information, the form that has write down described report form sample file and attribute information and form that attribute information will write down described report form sample file and the all-purpose financial statements file conversion of attribute information.
11. system as claimed in claim 8 is characterized in that, described system also comprises:
The logic adding set is used for adding logic at described form file destination, will change described form file destination.
12. system as claimed in claim 8 is characterized in that, described system also comprises:
The form judgment means is used for judgment means and judges;
File access device when described report form sample file is when preserving with the XML form, is used for visiting described report form sample file by XML; When described report form sample file is when preserving with the XML form, be used to use programmable interface to visit described table sample file.
13. system as claimed in claim 8 is characterized in that, the report file type of described bank return customization server identification comprises XML form or non-XML form.
14. system as claimed in claim 9 is characterized in that, the attribute information of described gauge outfit, detail and table tail comprises: literal, cell, lines and colouring information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200910089920 CN101968782B (en) | 2009-07-28 | 2009-07-28 | Sample report conversion method and system based on bank system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200910089920 CN101968782B (en) | 2009-07-28 | 2009-07-28 | Sample report conversion method and system based on bank system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101968782A true CN101968782A (en) | 2011-02-09 |
| CN101968782B CN101968782B (en) | 2012-12-26 |
Family
ID=43547941
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200910089920 Active CN101968782B (en) | 2009-07-28 | 2009-07-28 | Sample report conversion method and system based on bank system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101968782B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102750306A (en) * | 2012-02-28 | 2012-10-24 | 新奥特（北京）视频技术有限公司 | Matching method of match report data |
| CN102750304A (en) * | 2012-02-28 | 2012-10-24 | 新奥特（北京）视频技术有限公司 | Method for generating match report data |
| CN106844323A (en) * | 2017-02-20 | 2017-06-13 | 济南浪潮高新科技投资发展有限公司 | A kind of entity construction method and device |
| CN107341005A (en) * | 2017-06-20 | 2017-11-10 | 东软集团股份有限公司 | Chart generation method and its device |
| CN107562704A (en) * | 2017-08-01 | 2018-01-09 | 浙江鸿程计算机系统有限公司 | A kind of method that Fastreport templates are quickly generated based on word |
| CN110991150A (en) * | 2019-12-16 | 2020-04-10 | 中国铁塔股份有限公司 | Data format conversion method and device and account reporting system |
| CN111045614A (en) * | 2019-12-12 | 2020-04-21 | 中国建设银行股份有限公司 | Running statement printing method, nested file generation method, client and server |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101122899B (en) * | 2007-09-18 | 2011-01-05 | 杭州华三通信技术有限公司 | Report generation method and device |
-
2009
- 2009-07-28 CN CN 200910089920 patent/CN101968782B/en active Active
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102750306A (en) * | 2012-02-28 | 2012-10-24 | 新奥特（北京）视频技术有限公司 | Matching method of match report data |
| CN102750304A (en) * | 2012-02-28 | 2012-10-24 | 新奥特（北京）视频技术有限公司 | Method for generating match report data |
| CN102750306B (en) * | 2012-02-28 | 2017-08-04 | 新奥特（北京）视频技术有限公司 | A kind of matching process for report data of competing |
| CN106844323A (en) * | 2017-02-20 | 2017-06-13 | 济南浪潮高新科技投资发展有限公司 | A kind of entity construction method and device |
| 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 |
| CN107562704A (en) * | 2017-08-01 | 2018-01-09 | 浙江鸿程计算机系统有限公司 | A kind of method that Fastreport templates are quickly generated based on word |
| CN107562704B (en) * | 2017-08-01 | 2020-06-23 | 浙江鸿程计算机系统有限公司 | Method for rapidly generating Fastreport template based on word |
| CN111045614A (en) * | 2019-12-12 | 2020-04-21 | 中国建设银行股份有限公司 | Running statement printing method, nested file generation method, client and server |
| CN111045614B (en) * | 2019-12-12 | 2023-07-21 | 中国建设银行股份有限公司 | Method for printing running water report, method for generating overprint file, client and server |
| CN110991150A (en) * | 2019-12-16 | 2020-04-10 | 中国铁塔股份有限公司 | Data format conversion method and device and account reporting system |
| CN110991150B (en) * | 2019-12-16 | 2023-10-03 | 中国铁塔股份有限公司 | Data format conversion method, device and account reporting system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101968782B (en) | 2012-12-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101968782B (en) | Sample report conversion method and system based on bank system | |
| CN101122899B (en) | Report generation method and device | |
| Billington et al. | The petri net markup language: Concepts, technology, and tools | |
| CN100524306C (en) | Method for leading-in and deriving data in browser/servicer system | |
| US20070106932A1 (en) | System and method for the creation of virtual information packages | |
| CN109933752A (en) | A kind of method and apparatus exporting electronic document | |
| CN101976235A (en) | Extensible Word report automatically-generating method based on dynamic web page | |
| CN103136173A (en) | Method converting mass word or excel format form documents into webpages | |
| CN101149737A (en) | Method for quickly establishing web form and automatically establishing corresponding data table in database through Microsoft Word | |
| CN101488086A (en) | Software generation method and apparatus based on field model | |
| CN103136317A (en) | Implement method of on-line examination and approval informatization of engineering contracts in engineering management system | |
| CN101290559A (en) | Information processing apparatus and information processing method | |
| CN101446971A (en) | Method for building content management system and device thereof | |
| CN101668047B (en) | Method and device for automatically generating composite service description language | |
| KR20010032334A (en) | Document control and transmission system | |
| CN102273203B (en) | Image to html-table conversion with color quantization | |
| CN102855244A (en) | Method and device for file catalogue processing | |
| CN101702218B (en) | Information sending method applied to enterprise resource planning ERP and device | |
| CN109034622A (en) | A kind of data processing method and system | |
| CN104090920A (en) | System for realizing digital content cross-terminal publishing | |
| Blackmore | Biodiversity Update--Progress in Taxonomy | |
| CN106156075B (en) | A kind of method and device of report generation and displaying | |
| CN111898351B (en) | Automatic Excel data importing method and device based on Aviator, terminal equipment and storage medium | |
| CN101241576A (en) | Method, system and program for providing printed matter | |
| KR100762712B1 (en) | Method for transforming of electronic document based on mapping rule and system thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |