CN104715030A - Method for printing bills and reports on preprinted form - Google Patents

Method for printing bills and reports on preprinted form Download PDF

Info

Publication number
CN104715030A
CN104715030A CN201510107187.XA CN201510107187A CN104715030A CN 104715030 A CN104715030 A CN 104715030A CN 201510107187 A CN201510107187 A CN 201510107187A CN 104715030 A CN104715030 A CN 104715030A
Authority
CN
China
Prior art keywords
original document
document page
cell
page
actual
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
Application number
CN201510107187.XA
Other languages
Chinese (zh)
Other versions
CN104715030B (en
Inventor
聂作先
蒋新华
聂明星
邵明
李光洋
朱悦涵
王平阳
张顺淼
杨海燕
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fujian University of Technology
Original Assignee
Fujian University of Technology
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Fujian University of Technology filed Critical Fujian University of Technology
Priority to CN201510107187.XA priority Critical patent/CN104715030B/en
Publication of CN104715030A publication Critical patent/CN104715030A/en
Application granted granted Critical
Publication of CN104715030B publication Critical patent/CN104715030B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Landscapes

  • Processing Or Creating Images (AREA)

Abstract

The invention discloses a method for printing bills and reports on a preprinted form. The method comprises the steps that firstly, original bills are scanned into images; secondly, an original bill page is newly established; thirdly, the original bill images are imported to the original bill page; fourthly, the original bill page is designed; fifthly, an actual bill page is designed; sixthly, a report template is saved; seventhly, the reports are browsed; eighthly, the reports are printed. By means of the method, a user can select whether the reports are printed on the preprinted form or on blank paper when browsing the reports, so the printing flexibility of the bills is improved; if the bills and reports are printed on the blank paper, there is no need to use the scanning images of the original bills as background images, and therefore the printing quality of the bills and the reports is guaranteed.

Description

A kind of document form cover printing method
Technical field
The present invention relates to a kind of document form cover printing method.
Background technology
Report Form Design is the pith in IT application in enterprises, and according to statistics, 60% work of enterprise's application and development is all make all kinds of form, and wherein, document form and bill occupy consequence wherein.The printing type of document form is divided into cover to beat and non-cover is beaten, and cover is beaten and referred on the document printed, and print What is printed to like clockwork the position of specifying; But not cover is beaten finger print the full content that document form comprises form on the document printer paper of blank.Traditional report tool, needs to measure out data with a yardstick and is overlapping the position beaten in background, and then according to the position of sizing data place cell on screen, quite loaded down with trivial details, easily make mistakes.When the scheme that main flow beaten by current document form cover is Report Form Design using the scintigram of original document as document form background, the position of print What is needed to put corresponding Database field at it again, on the document printed, the data obtained from database are only printed during printing, if wish use non-cover molding formula, then by the scintigram of original document as a setting figure be printed on document.
The report form tool of current domestic main flow, the process of its design document form is as follows: 1) original document is scanned into picture, and is saved in specified folder; 2) newly-built document form in Report Designer, and using document scintigram as paper background, specify when document prints whether print document scanning background figure; 3) form is designed; 4) form is preserved to template file; 5) user browses form and execution set is beaten in a browser.There is following defect:
1) document form cover is beaten is also that non-cover plays needs by Report Form Design personnel appointment when designing, and reports user cannot select when browsing form;
2) the non-cover of document form got through by the scintigram of original document as a setting figure be printed on document and realize, easily there is the problem that font is fuzzy.
Summary of the invention
A kind of document form cover printing method is the invention provides for solving the problem.
Technical scheme provided by the invention is: a kind of document form cover printing method, comprises the steps:
Step one): original document is scanned for picture: scan original document for original document picture, described original document picture is identical with original document size;
Step 2) the newly-built original document page: create the original document page, the described original document page is the blank page;
Step 3) import original document picture to the original document page: original document picture is imported the original document page as a setting, and the size of the adjustment original document page is to overlapping completely with original document picture;
Step 4) design the original document page: on the original document page, the table border identical with background and static text are set, make the original document page and original document completely the same;
Step 5) design actual document page: create the inchoate instrument page, i.e. actual document page, then the content outside Background in the original document page is all copied to actual document page, Database field and form function are placed into the correspondence position of actual document page;
Step 6) preserve report form template: the different content node query statement of the difference of the original document page, actual document page, actual document page and the original document page, original document picture and retrieve data being saved in report form template, then preserve report form template;
Step 7) browse form: in report server, the data needed with the retrieval of report data query statement, fill it in actual document page;
Step 8) report printing: select cover molding formula or non-cover molding formula, if select non-cover molding formula, directly print actual document page; If select cover to beat, then the data retrieved by report data query statement and function expression result of evaluation are filled into the correspondence position in the difference page of actual document page and the original document page, then print this difference page.
Further improvement, the described original document page and actual document page all comprise several rows and some row, described step 4) comprise following steps:
1) col width adjusting the original document page is high with row, makes each cell in original document picture, just in time comprises the one or more cells on the original document page;
2) Merge Cells, merge the cell on the original document page, make each cell in background, correspondence comprises a cell on the original document page, even in original document Background, certain cell of document form comprises the multiple cells on the original document page, then by this multiple cell span, the cell after merging is overlapped completely with the cell in Background;
3) form and cell borders are set: according to the frame of the form on original document picture and cell, for cell corresponding on the original document page arranges identical frame;
4) static text is added: on the original document page, add the position corresponding with the word of original document picture add identical original document page word; Font and the alignment thereof of described original document page word are consistent with the word of original document picture.
Further improvement, the described original document page and actual document page all comprise several rows and some row, described step 5) comprise following steps:
A. the second worksheet is created, i.e. actual document page;
B. search the original document page actual use region: search the last location lattice in the original document page, obtain its line number and row number, determine that actual document page needs line number and the columns in the region used according to line number and the row number of this element lattice;
C. adjustment row is high with col width: be set to corresponding identical with the original document page by the height of the row in the region of using in actual document page and the width of row;
D. Merge Cells is processed: in the search original document page, effectively use each cell in district, if this cell is Merge Cells, then find out the cell set that this Merge Cells comprises, and in actual document page, merging treatment is done in the cell set of correspondence;
E. Copied Cells frame: the search original document page effectively uses each cell in district, if there is frame, then corresponding unit lattice arrange identical frame in actual document page;
F. copy text: the search original document page effectively uses each cell in district, if there is text, then corresponding unit lattice arrange identical text in actual document page;
G. setting data storehouse field and form function: obtain the position that Database field or form function are placed into the correspondence of actual document page from data source.
Further improvement, the described original document page and actual document page all comprise several rows and some row, described step 6) in, described report form template saves as XML file, the original document page, actual document page, the difference of actual document page and the original document page saves as an Area Node in described XML file, each Area Node comprises several row nodes, described row node corresponds to the row in report form template, each row node comprises some cell nodes, described cell node corresponds to the cell in report form template, the attribute kit of each cell is containing width, frame, font, fill color and text etc., the attribute of described cell arranges decision by respective cells in report form template, the region child node of the original document page and actual document page is obtained by each cell searching for report form template, the difference of actual document page and the original document page is based on the region child node of actual document page, by each cell of actual document page, deduct all properties appeared in original document corresponding unit lattice points, namely obtain the region child node of the difference of actual document worksheet and original document worksheet, under described original document picture exists assigned catalogue, preserve original document picture file name in report form template, described data query statement is also kept in report form template with the form of a node.
Further improvement, in described step 8) in, form browser interface arranges check box and beats to indicate whether to overlap, or cover is set respectively on form browser interface makes button and button made by non-cover, or arrange respectively to overlap and play menu and menu played by non-cover.
Tool of the present invention has the following advantages:
1) document form cover is beaten is also that non-cover is beaten and can be selected when browsing form by reports user, adds the dirigibility that document prints;
2) the non-cover of document form is beaten without the need to using the scintigram of original document to scheme as a setting, ensure that the print quality of document form.
Accompanying drawing explanation
When considered in conjunction with the accompanying drawings, by referring to detailed description below, more completely can understand the present invention better and easily learn wherein many adjoint advantages, but accompanying drawing described herein is used to provide a further understanding of the present invention, form a part of the present invention, schematic description and description of the present invention, for explaining the present invention, does not form inappropriate limitation of the present invention, wherein:
Fig. 1 document form cover beats/and non-cover sets meter schematic flow sheet;
Original Bill design process schematic in Fig. 2 EXCEL reporting system;
The actual Bill design schematic flow sheet of Fig. 3;
Actual document process schematic is designed in Fig. 4 EXCEL reporting system.
Embodiment
The present invention is described in detail as follows in conjunction with the embodiments:
The Report Designer of the embodiment of the present invention adopts VSTO technology to develop based on EXCEL, and Microsoft Excel interface is the Report Form Design interface of reporting system.
Step one) original document is scanned as picture: be adjusted to identical with original document with image software by scanning the original document picture size obtained.
Step 2) the newly-built original document page: create a blank workbook with Report Designer, i.e. the original document page.
Step 3) import original document picture to the original document page: import original document picture to the background of the original document page as the original document page, is alignd in the upper left corner of the upper left corner of original document picture with Microsoft Excel region.
Step 4) design the original document page: comprise following steps as shown in Figure 2:
1) col width adjusting the original document page is high with row, makes each cell of original document picture, just in time comprises the one or more cells on original document worksheet;
2) Merge Cells, merge the cell on the original document page, make each cell in background, correspondence comprises a cell on the original document page, even in original document Background, certain cell of document form comprises the multiple cells on original document worksheet, then by this multiple cell span, the cell after merging is overlapped completely with the cell in Background;
3) form and cell borders are set: according to the frame of the form on original document picture and cell, for cell corresponding on the original document page arranges identical frame;
4) static text is added: on the original document page, add the position corresponding with the word of original document picture add identical original document page word; Font and the alignment thereof of described original document page word are consistent with the word of original document picture.
Step 5) design actual document page: create the inchoate instrument page, i.e. actual document page, then the content outside Background in the original document page is all copied to actual document page, Database field and form function are placed into the correspondence position of actual document page, step as shown in Figure 3 and Figure 4:
1) the second worksheet is created, actual document page;
2) search actual document page actual use region: search the lastCell cell in actual document page, the line number of this element lattice and row number determine line number and the columns in the actual region used in worksheet, are designated as MaxRow and MaxColumn respectively;
3) the high and col width of adjustment row.For row COL each in actual document page, if its row c meets c<=MaxColumn, its width is set to arrange identical with c in the original document page, for row ROW each in actual document page, if its line number r meets r<=MaxRow, it is highly set to capable identical with r in the original document page;
4) Merge Cells is processed: in the search original document page, effectively use each cell in district, if this cell is Merge Cells, then find out the cell set that this Merge Cells comprises, and in actual document page, merging treatment is done in the cell set of correspondence;
5) Copied Cells frame: the search original document page effectively uses each cell in district, if there is frame, then corresponding unit lattice arrange identical frame in actual document page;
6) copy text: the search original document page effectively uses each cell in district, if there is text, then corresponding unit lattice arrange identical text in actual document page;
7) setting data storehouse field and form function: obtain the correct position that Database field or form function are placed into actual document page from data source.
Step 6) preserve report form template: when preserving document report form template, following content is saved in the different content node of report form template: difference, the original document picture of original document worksheet, actual document worksheet, actual document worksheet and original document worksheet, the query statement of retrieve data.In the present embodiment, report form template saves as XML file, the difference of the original document page, actual document page, actual document page and the original document page all saves as a table node in XML file, each table node comprises several row nodes, corresponding to the row in document worksheet, each row node comprises some cell nodes, corresponding to the cell in document worksheet, each cell has the attributes such as width, frame, font, fill color and text, arranges decision by respective cells in document worksheet.The table child node of original document worksheet and actual document worksheet is obtained by each cell searching for its effective workspace.The difference of actual document worksheet and original document worksheet is based on the table child node of actual document, for each cel l wherein, deduct each attribute appeared in original document table child node, namely obtain the table child node of the difference of actual document worksheet and original document worksheet.Under the picture of original document exists assigned catalogue, preserve its filename in report form template, data query statement is also kept in report form template with the form of a node.
Step 7) browse form.Under the support of report server, the data that will show are retrieved with report data query statement, and fill it in actual document, namely replace Database field in actual document table child node and form function by the real data retrieved, then generate WEB page according to this table child node and show user.
Step 8) report printing.Document report printing is divided into cover to beat and non-cover is beaten, and conveniently user selects printing type, and the form browsing web page arranges the button that cover is beaten and non-cover is beaten.When carrying out non-cover and beating, directly by the report printing of displaying in step 7 out, when carrying out cover and beating, its actual value obtained in Database field in the difference table child node of actual document and original document and form function step 7 is substituted, and generate WEB page according to this table child node and print this difference document on the document paper being printed with original document, realize cover and beat.
The explanation of above example just understands core concept of the present invention for helping; Meanwhile, for one of ordinary skill in the art, according to thought of the present invention, all will change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.

Claims (5)

1. a document form cover printing method, is characterized in that, comprise the steps:
Step one): original document is scanned for picture: scan original document for original document picture, described original document picture is identical with original document size;
Step 2) the newly-built original document page: create the original document page, the described original document page is the blank page;
Step 3) import original document picture to the original document page: original document picture is imported the original document page as a setting, and the size of the adjustment original document page is to overlapping completely with original document picture;
Step 4) design the original document page: on the original document page, the table border identical with background and static text are set, make the original document page and original document completely the same;
Step 5) design actual document page: create the inchoate instrument page, i.e. actual document page, then the content outside Background in the original document page is all copied to actual document page, Database field and form function are placed into the correspondence position of actual document page;
Step 6) preserve report form template: the different content node query statement of the difference page of the original document page, actual document page, actual document page and the original document page, original document picture and retrieve data being saved in report form template, then preserve report form template;
Step 7) browse form: in report server, the data needed with the retrieval of report data query statement, fill it in actual document page;
Step 8) report printing: select cover molding formula or non-cover molding formula, if select non-cover molding formula, directly print actual document page; If select cover to beat, then the data retrieved by report data query statement and function expression result of evaluation are filled into the correspondence position in the difference page of actual document page and the original document page, then print.
2. document form cover printing method as claimed in claim 1, it is characterized in that, the described original document page and actual document page all comprise several rows and some row, described step 4) comprise following steps:
1) col width adjusting the original document page is high with row, makes each cell of original document picture, just in time comprises the one or more cells on the original document page;
2) Merge Cells: merge the cell on the original document page, make each cell in background picture, correspondence comprises a cell on the original document page, even in original document Background, certain cell of document form comprises the multiple cells on the original document page, then by this multiple cell span, the cell after merging is overlapped completely with the cell in Background;
3) form and cell borders are set: according to the frame of the form on original document picture and cell, for cell corresponding on the original document page arranges identical frame;
4) static text is added: on the original document page, add the position corresponding with the word of original document picture add identical original document page word; Font and the alignment thereof of described original document page word are consistent with the word of original document picture.
3. document form cover printing method as claimed in claim 1, it is characterized in that, the described original document page and actual document page all comprise several rows and some row, described step 5) comprise following steps:
A. the second worksheet is created, i.e. actual document page;
B. search the original document page actual use region: search the last location lattice (LastCell) in the original document page, determine that actual document page needs line number and the columns in the region used according to line number and the row number of this element lattice;
C. adjustment row is high with col width: the width height of the row of actual document page and the width of row being set to the height of the row corresponding with the original document page and row is identical;
D. Merge Cells is processed: in the search original document page, effectively use each cell in district, if this cell is Merge Cells, then find out the cell set that this Merge Cells comprises, and in actual document page, merging treatment is done in the cell set of correspondence;
E. Copied Cells frame: the search original document page effectively uses each cell in district, if there is frame, then corresponding unit lattice arrange identical frame in actual document page;
F. copy text: the search original document page effectively uses each cell in district, if there is text, then corresponding unit lattice arrange identical text in actual document page;
G. setting data storehouse field and form function: obtain the position that Database field or form function are placed into the correspondence of actual document page from data source.
4. document form cover printing method as claimed in claim 1, it is characterized in that, the described original document page and actual document page all comprise several rows and some row, described step 6) in, described report form template saves as XML file, the original document page, actual document page, the difference Page-saving of actual document page and the original document page is an Area Node in described XML file, each Area Node comprises several row nodes, described row node corresponds to the row in report form template, each row node comprises some cell nodes, described cell node corresponds to the cell in report form template, the attribute kit of each cell is containing width, frame, font, fill color and text etc., the attribute of described cell arranges decision by respective cells in report form template, the region child node of the original document page and actual document page is obtained by each cell searching for report form template, the difference of actual document page and the original document page is based on the region child node of actual document page, by each cell of actual document page, deduct all properties appeared in original document corresponding unit lattice points, namely obtain the region child node of the difference of actual document worksheet and original document worksheet, under described original document picture exists assigned catalogue, preserve original document picture file name in report form template, described data query statement is also kept in report form template with the form of a node.
5. document form cover printing method as claimed in claim 1, it is characterized in that, in described step 8) in, form browser interface arranges check box beat to indicate whether to overlap, or cover is set respectively on form browser interface and makes button and button made by non-cover, or arrange respectively to overlap and play menu and menu played by non-cover.
CN201510107187.XA 2015-03-12 2015-03-12 A kind of document form covers printing method Expired - Fee Related CN104715030B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201510107187.XA CN104715030B (en) 2015-03-12 2015-03-12 A kind of document form covers printing method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201510107187.XA CN104715030B (en) 2015-03-12 2015-03-12 A kind of document form covers printing method

Publications (2)

Publication Number Publication Date
CN104715030A true CN104715030A (en) 2015-06-17
CN104715030B CN104715030B (en) 2018-02-02

Family

ID=53414357

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201510107187.XA Expired - Fee Related CN104715030B (en) 2015-03-12 2015-03-12 A kind of document form covers printing method

Country Status (1)

Country Link
CN (1) CN104715030B (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105196708A (en) * 2015-09-22 2015-12-30 深圳前海百递网络有限公司 Printing setting method and printing device
CN108805684A (en) * 2018-04-17 2018-11-13 海闻科技有限公司 A kind of tax administration platform application system
CN111367945A (en) * 2020-02-28 2020-07-03 平安医疗健康管理股份有限公司 Report query method, device, equipment and computer readable storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1227407A2 (en) * 2001-01-24 2002-07-31 Seiko Instruments Inc. User interface for creating printing templates
CN101577009A (en) * 2008-05-08 2009-11-11 北京润乾信息系统技术有限公司 Method for realizing overlay printing on prior form
CN102722899A (en) * 2012-05-28 2012-10-10 重庆大学 Positioning printing system for report
CN103713901A (en) * 2013-12-24 2014-04-09 金蝶软件(中国)有限公司 Showing method and system of bills

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1227407A2 (en) * 2001-01-24 2002-07-31 Seiko Instruments Inc. User interface for creating printing templates
CN101577009A (en) * 2008-05-08 2009-11-11 北京润乾信息系统技术有限公司 Method for realizing overlay printing on prior form
CN102722899A (en) * 2012-05-28 2012-10-10 重庆大学 Positioning printing system for report
CN103713901A (en) * 2013-12-24 2014-04-09 金蝶软件(中国)有限公司 Showing method and system of bills

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
HEZONGWU2009: ""EXCEL实现票据套打高效化"", 《百度文库》 *
NHPNTYHHT,: ""如何用excel制作表格套打格式"", 《百度文库》 *

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105196708A (en) * 2015-09-22 2015-12-30 深圳前海百递网络有限公司 Printing setting method and printing device
CN108805684A (en) * 2018-04-17 2018-11-13 海闻科技有限公司 A kind of tax administration platform application system
CN111367945A (en) * 2020-02-28 2020-07-03 平安医疗健康管理股份有限公司 Report query method, device, equipment and computer readable storage medium

Also Published As

Publication number Publication date
CN104715030B (en) 2018-02-02

Similar Documents

Publication Publication Date Title
CN101025738B (en) Template-free dynamic website generating method
Jacobs et al. Adaptive grid-based document layout
US7363581B2 (en) Presentation generator
CN111753500A (en) Method for merging and displaying formatted electronic form and OFD (office file format) and generating catalog
CN110032720A (en) A kind of visualization report typesetting and automatic generation method and system based on XML
CN103365855A (en) Method and server for generating web pages
CA2773152A1 (en) A method for users to create and edit web page layouts
CN106021394A (en) Website construction method and apparatus
CN103258015A (en) Method for dynamically generating questionnaire based on XML
CN105094930A (en) Image positioning system and method
CN101828165A (en) Watching of feeds
CN104715030B (en) A kind of document form covers printing method
CN104679453A (en) Information input, storage, typesetting and printing general system and information input, storage, typesetting and printing method
CN112307720A (en) PSD (position sensitive Detector) document-based HTML (Hypertext markup language) design template automatic conversion method and system
CN109213480A (en) A kind of method, storage medium, equipment and system for developing the back-stage management page
CN107193549A (en) Webpage quick development method based on metadata
CN104424174A (en) Document processing system and document processing method
US11644949B2 (en) Autotagging a template of a reporting workbook
US20070162848A1 (en) Predictive styling
US8788926B1 (en) Method of content filtering to reduce ink consumption on printed web pages
US20090249192A1 (en) Creating a view from multiple templates
US8185818B2 (en) Mixed techniques for HTML crosstab rendering
CN103605640B (en) Form adaption method and device
CN112558894B (en) Canvas-based dynamic webpage printing method, system and storage medium
CN115272530A (en) Intelligent dynamic cover synthesis method and system for enterprise online education

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant
CF01 Termination of patent right due to non-payment of annual fee
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20180202

Termination date: 20210312