CN101968782B - Sample report conversion method and system based on bank system - Google Patents
Sample report conversion method and system based on bank system Download PDFInfo
- Publication number
- CN101968782B CN101968782B CN 200910089920 CN200910089920A CN101968782B CN 101968782 B CN101968782 B CN 101968782B CN 200910089920 CN200910089920 CN 200910089920 CN 200910089920 A CN200910089920 A CN 200910089920A CN 101968782 B CN101968782 B CN 101968782B
- Authority
- CN
- China
- Prior art keywords
- file
- report
- attribute information
- report form
- 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.)
- Active
Links
Images
Landscapes
- Document Processing Apparatus (AREA)
Abstract
The invention provides a sample report conversion method and a system based on a banking 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 the form technology based on banking system.
Background technology
Along with the widespread use of computing machine, every field is all accomplished 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 appearance and logic that the developer need provide according to the business personnel use form customization instrument to accomplish final form.The table appearance that the business personnel provides is often left in WORD or the EXCEL file; Form customization platform can not be continued to use table appearance form wherein; The developer need customize drafting table appearance in the platform at form again according to the table appearance 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 appearance in large enterprise, and the table kind change that does not also stop, and the workload of drawing table appearance 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 by form customization instrument an OFFICE plug-in unit to be provided; On the basis of the table appearance file of WORD/EXCEL form, add logic (as adding data field, subtotal total etc.) in conjunction with the WORD/EXCEL instrument, with recycling table appearance.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 appearance file distribution that will have logic then is to form application server 102.Business personnel's (like client 103 and client 104) sends report generation order by the WEB application server to the form application server through access to netwoks WEB application server.After the form application server receives order, utilize the report form showing module that the table appearance 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 appearance 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 based on banking 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 said method comprises: obtain the report form sample file at bank return terminal and the all-purpose financial statements file of bank return customization server; Obtain the form and the attribute information of said report form sample file; The form and the attribute information of said 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 said report form sample file and attribute information; According to the form of the all-purpose financial statements file of form that has write down said report form sample file and attribute information and form that attribute information will write down said 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 a kind of report form sample converting system based on banking system; Said system comprises: the file deriving means is used to obtain the report form sample file at 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 said report form sample file; Information record carrier is used for the form and the attribute information of said 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 said 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 said report form sample file and attribute information and form that attribute information will write down said 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 appearance 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; Obviously, the 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 property, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the table appearance 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 appearance 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 appearance 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 implements the realization flow figure of WORD/EXCEL table appearance document analysis module 801 for the present invention;
Figure 18 is the realization flow figure of embodiment of the invention statement form file generating module 802.
Embodiment
To combine the accompanying drawing in the embodiment of the invention below, the technical scheme in the embodiment of the invention is carried out clear, intactly description, 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 are not making the every other embodiment that is obtained under the creative work prerequisite, all belong to the scope of the present invention's protection.
The embodiment of the invention provides a kind of report form sample converting system and method; Form style and the form that can the WORD/EXCEL that the business personnel submits to shown define in the appearance file be 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, supply the developer to edit and revise the form service logic.
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 at bank return terminal and the all-purpose financial statements file of bank return customization server;
Step S202: obtain form and attribute information in the said report form sample file; Promptly obtain gauge outfit, detail and the table tail information of said 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 said 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 said 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 said 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 said report form sample file and attribute information and form that attribute information will write down said 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 said report form sample file and attribute information and form that attribute information will write down said 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.Whether the report file that the form customization platform that before the all-purpose financial statements file conversion of form that will write down said report form sample file and attribute information is the form file destination, needs judgement to generate 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 said 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 through XML; If, do not use the described table appearance of programmable interface visit file.
Optional, described method also comprises: in said form file destination, add logic, will change described form file destination.
Fig. 3 A is an embodiment of the invention report form sample converting system structural representation, and shown in Fig. 3 A, 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 at 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 said report form sample file; Specifically be used to obtain gauge outfit, detail and the table tail information of said 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 said 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 said 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 said report form sample file and attribute information and form that attribute information will write down said 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 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 said report form sample file and attribute information and form that attribute information will write down said 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.Whether the report file that the form customization platform that before the all-purpose financial statements file conversion of form that will write down said report form sample file and attribute information is the form file destination, needs judgement to generate 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 said 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 through XML; When described report form sample file is when preserving with the XML form, be used to use the described table of programmable interface visit kind file.
Specify below and how will show an appearance 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 at bank return terminal and the all-purpose financial statements file of bank return customization server; From the report form sample file, obtain said form and attribute information; The form and the attribute information of said 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 said report form sample file and attribute information; According to the form of the all-purpose financial statements file of form that has write down said report form sample file and attribute information and form that attribute information will write down said 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 added generation table appearance file 404, obtains report file 405 according to table appearance 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, can the report data of data file 406 be inserted report file 405.Alternatively, client 401 can not sent 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 appearance 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 the print preview function to report file.Data storage device 603 is file system, is used for stored table appearance 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., and is as shown in Figure 7.
It is that a report form sample is inherited program automatically that table appearance form is inherited analytical equipment 601, and it is used to resolve the report form sample file and generates the statement form file destination that has table appearance that can be customized land identification by form.It at first receives the table appearance file that leaves in the WORD/EXCEL document, resolves to generate an all-purpose financial statements formatted file, again the all-purpose financial statements formatted file is translated into the different discernible statement form file destinations of form customization platform.
As shown in Figure 8; Table appearance form is inherited analytical equipment 601 and is comprised table appearance document analysis module 801 and statement form file generating module 802; Table appearance file 404 carries out dissection process in 801 pairs of data memory storages 603 of table appearance 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 appearance file by table appearance form and generates automatically.
Fig. 9 is the structural representation of embodiment of the invention form customizing device 602, and is as shown in Figure 9, and 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 (" the XXXX form " as with Fig. 5 changes " * * * form " 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 appearance file 404 that the business personnel provides, and uses form customization platform editor service logic through analyzing the design back, 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, can form 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 beappreciated from fig. 10, along with the growth in 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 appearance in whole times, and the developer is merely able to realize through the non-standard report function that form customization platform provides, no longer details 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 appearance document analysis module 801 is analyzed the table appearance 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 appearance form is inherited analytical equipment, has write down the table appearance information of a form.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; Under < report>root node, use < reportheader>node to represent the table header branch, < detail>node is represented detailed part, and < reportfooter>node is represented portion.In gauge outfit < reportheader>and two parts of table tail < reportfooter >, can add line < row >, shown in figure 12.In detailed < detail>part; Further being subdivided into detailed header line < title >, detailed data capable < data>and detailed packet row < group>down can adding device lattice < cell>in detailed header line < title >, detailed data capable < data>and detailed packet row < group >, shown in figure 13.
Down can adding device lattice < cell>in detailed header line < title >, detailed data capable < data>and detailed packet row < group >.For each row < row>or each cell < cell >, can add text < text >, and cell text formatting (< font>font and < align>alignment thereof) is set.Cell can also add the form <border>of frame, and thickness and the color that whether need add frame line and lines around showing are shown in figure 14.Figure 14 is the all-purpose financial statements form XML file of the WORD document table appearance of Fig. 5; Wherein, under gauge outfit part < reporthearder>node two < row>nodes are arranged, show that the gauge outfit of this form partly has two style of writing words; < text>node " XXXX form " is arranged under first < row>node; Be the title " XXXX form " of Fig. 5, its form can be provided with in font nodes such as < font >, in this few description.
Under detailed part < detail>node detailed header line < title >, detailed data capable < data>and detailed packet row < group>are arranged.With detailed header line < title>is example; It has a plurality of cells < cell >, and 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 provided with in font < font >, frame nodes such as <border >, in this few description.
Under table portion < reportfooter>node of form < row>node is arranged; The table portion that shows this form has delegation's literal; < text>node " date printed: on February 11st, 2009 " is arranged under < row>node; Be the footline " date printed: on February 11st, 2009 " of the form of Fig. 5, its form can be provided with in font nodes such as < font >, 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 is shown in figure 16.Wherein, " XXXX statement " leaves under gauge outfit part < reportheader>node.Detailed part < detail>node has a plurality of detailed header lines < title>node, and the cell in all forms all leaves under detailed header line < title>node, a corresponding detailed header line < title>node of each row form.
How the table appearance document analysis module 801 and the statement form file generating module 802 that specify below among Fig. 8 realize showing appearance file 404 generation statement form file destinations 703.
Figure 17 the present invention implements the realization flow figure of WORD/EXCEL table appearance document analysis module 801, and 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, like gauge outfit, detail and table tail.For form; The ingredient of form must represent with the order of gauge outfit, detail, table tail successively; That is to say that when analysis program was resolved to detailed part, remaining form part only possibly or shown tail for detail; Can not be gauge outfit, so initialization value that will resolving is set to gauge outfit.
Step S1702: whether the WORD/EXCEL table appearance 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 a WORD/EXCEL table appearance 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 a WORD/EXCEL table appearance 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 get into 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 the grouping.Generally speaking, the grouping of the detail of form is the one or more cells that have literal and frame that behind detailed title, occur.Detailed grouping also possibly appear at after the detailed data before possibly appearing at detailed data.
If current line/node is not detailed the 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 (like font, cell width etc.) that read table appearance 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 appearance has been resolved and has been finished EOP (end of program).
Above step cycle is carried out, and constantly reads WORD/EXCEL table appearance 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.Whole table appearance is preserved all-purpose financial statements form XML file and terminator after reading and change and finishing.Last generation result is 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 appearance document analysis program generates.
Step S1802: use XML resolver resolves all-purpose financial statements form XML file.
Step S1803: whether the report file that judgement needs the form customization platform of generation to discern 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 the text message (< text>node) in the all-purpose financial statements form XML file,, 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 the lines/frame information (<border>node) in the all-purpose financial statements form XML file,, add lines/frame node according to the XML form that defines in the format item control documents.
Step S1808: obtain lines/frame attribute (<border>node in the all-purpose financial statements form XML file; 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 the text message (< text>node) in the all-purpose financial statements form XML file, 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 the lines/frame information (<border>node) in the all-purpose financial statements form XML file, call the programmable interface that form customization platform provides, add lines/frame node.
Step S1812: obtain the lines/frame attribute (<border>node) in the all-purpose financial statements form XML file, 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.
Detailed header line < title>node with detailed part < detail>node among Figure 14 is the step of example simple declaration Figure 18 below.
A text < text>node is arranged under first cell < cell>node, and according to this information, for form object format file adds a text box or text node, word content is " number of the account "; Be font < font>node behind text < text>node, it has pointed out the word attribute in the current cell < cell >, 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 was frame <border>node behind font < font>node, it pointed out current cell < cell>around whether need add frame, according to this information, be that text box or the text node add in the first step add lines or lines node; Also having described the attribute of frame at frame <border>intranodal, according to this information, is lines or the lines node that adds in the 3rd step.Process above repeating is accomplished the conversion of second cell < cell>node of detailed header line < title>node.
The statement form file destination that generates after above step is accomplished can be customized land identification and represent by form, and the developer can carry out the exploitation of form logic and the maintenance of table appearance on this basis.
The table appearance 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 following:
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) the statement form file destination and the manual drawing result that generate 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 appearance, 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; The object of the invention, technical scheme and beneficial effect have been carried out further explain, and institute it should be understood that the above is merely embodiment of the present invention; And be not used in qualification protection scope of the present invention; All within spirit of the present invention and principle, any modification of being made, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. report form sample conversion method based on banking system is characterized in that said method comprises:
Obtain the report form sample file at bank return terminal and the all-purpose financial statements file of bank return customization server;
Obtain the form and the attribute information of said report form sample file;
The form and the attribute information of said 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 said report form sample file and attribute information;
According to the form of the all-purpose financial statements file of form that has write down said report form sample file and attribute information and form that attribute information will write down said 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, comprising: the report form type information of obtaining described bank return customization server identification; According to the form of the all-purpose financial statements file of described report form type information, the form that has write down said report form sample file and attribute information and form that attribute information will write down said report form sample file and the all-purpose financial statements file conversion of attribute information is the form file destination;
Wherein, the format information of report form sample file comprises font, cell width, and the attribute information of report form sample file comprises literal, cell, lines and colouring information.
2. the method for claim 1 is characterized in that, the form and the attribute information that obtain in the said report form sample file comprise:
Obtain gauge outfit, detail and the table tail information of said report form sample file;
Obtain the attribute information of described gauge outfit, detail and table tail information.
3. the method for claim 1 is characterized in that, described method also comprises: in said form file destination, add logic, will change described form file destination.
4. the method for claim 1 is characterized in that, before form that obtains said 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 through XML;
If, do not use the described table appearance of programmable interface visit file.
5. 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.
6. report form sample converting system based on banking system is characterized in that said system comprises:
The file deriving means is used to obtain the report form sample file at 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 said report form sample file;
Information record carrier is used for the form and the attribute information of said 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 said 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 said report form sample file and attribute information and form that attribute information will write down said 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 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 said report form sample file and attribute information and form that attribute information will write down said report form sample file and the all-purpose financial statements file conversion of attribute information;
Wherein, the format information of report form sample file comprises font, cell width, and the attribute information of report form sample file comprises literal, cell, lines and colouring information.
7. system as claimed in claim 6 is characterized in that,
Described information acquisition device specifically is used to obtain gauge outfit, detail and the table tail information of said report form sample file and obtains described gauge outfit, detail and show the attribute information of tail.
8. system as claimed in claim 6 is characterized in that, described system also comprises:
The logic adding set is used for adding logic at said form file destination, will change described form file destination.
9. system as claimed in claim 6 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 through XML; When described report form sample file is when preserving with the XML form, be used to use the described table of programmable interface visit kind file.
10. system as claimed in claim 6 is characterized in that, the report file type of described bank return customization server identification comprises XML form or non-XML form.
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 CN101968782A (en) | 2011-02-09 |
| CN101968782B true 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) |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102750306B (en) * | 2012-02-28 | 2017-08-04 | 新奥特（北京）视频技术有限公司 | A kind of matching process for report data of competing |
| 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 |
| CN107341005B (en) * | 2017-06-20 | 2020-09-18 | 东软集团股份有限公司 | Chart generation method and device |
| CN107562704B (en) * | 2017-08-01 | 2020-06-23 | 浙江鸿程计算机系统有限公司 | Method for rapidly generating Fastreport template based on word |
| CN111045614B (en) * | 2019-12-12 | 2023-07-21 | 中国建设银行股份有限公司 | Method for printing running water report, method for generating overprint file, client and server |
| CN110991150B (en) * | 2019-12-16 | 2023-10-03 | 中国铁塔股份有限公司 | Data format conversion method, device and account reporting system |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101122899A (en) * | 2007-09-18 | 2008-02-13 | 杭州华三通信技术有限公司 | Report generation method and device |
-
2009
- 2009-07-28 CN CN 200910089920 patent/CN101968782B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101122899A (en) * | 2007-09-18 | 2008-02-13 | 杭州华三通信技术有限公司 | Report generation method and device |
Non-Patent Citations (1)
| Title |
|---|
| 陈婷等.基于XML的Web报表生成系统的设计和实现.《福建电脑》.2003,(第4期),第34，35，32页. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101968782A (en) | 2011-02-09 |
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 | |
| CN101976235B (en) | Extensible Word report automatically-generating method based on dynamic web page | |
| CN100524306C (en) | Method for leading-in and deriving data in browser/servicer system | |
| Messner et al. | User's Guide for MESSAGE III | |
| KR101067398B1 (en) | Method and computer-readable medium for importing and exporting hierarchically structured data | |
| CN102270224B (en) | Information system data output device and method | |
| US20070106932A1 (en) | System and method for the creation of virtual information packages | |
| CN103914438A (en) | Template and tag implementation based excel display and export method and system | |
| CN102662928A (en) | Rich text editing method for importing documents and device thereof | |
| KR20060061790A (en) | An automated publishing system that facilitates collaborative editing and accountability through virtual document architecture | |
| CN101488086A (en) | Software generation method and apparatus based on field model | |
| CN104123269A (en) | Semi-automatic publication generation method and system based on template | |
| CN101702218B (en) | Information sending method applied to enterprise resource planning ERP and device | |
| CN101650745A (en) | Method and device for rapidly generating WEB page based on data definition | |
| KR20010032334A (en) | Document control and transmission system | |
| CN102855244A (en) | Method and device for file catalogue processing | |
| Palo et al. | Sustainable forestry challenges for developing countries | |
| CN104090920A (en) | System for realizing digital content cross-terminal publishing | |
| CN106599324B (en) | CAD data capturing method | |
| Kuloor et al. | Aspect-oriented requirements engineering for software product lines | |
| CN101859293B (en) | Electronic reader and edition document storage method | |
| CN111898351B (en) | Automatic Excel data importing method and device based on Aviator, terminal equipment and storage medium | |
| KR100762712B1 (en) | Method for transforming of electronic document based on mapping rule and system thereof | |
| JP2002288153A (en) | Application-independent data forming method, information processing program, and layout information processing system |
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 |