CN105159997B - Report processing method and report processing system - Google Patents

Report processing method and report processing system Download PDF

Info

Publication number
CN105159997B
CN105159997B CN201510565289.6A CN201510565289A CN105159997B CN 105159997 B CN105159997 B CN 105159997B CN 201510565289 A CN201510565289 A CN 201510565289A CN 105159997 B CN105159997 B CN 105159997B
Authority
CN
China
Prior art keywords
data
server
client
form document
report processing
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.)
Expired - Fee Related
Application number
CN201510565289.6A
Other languages
Chinese (zh)
Other versions
CN105159997A (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.)
Shenzhen Digital Information Technology Co Ltd
Original Assignee
Shenzhen Digital Information Technology Co Ltd
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 Shenzhen Digital Information Technology Co Ltd filed Critical Shenzhen Digital Information Technology Co Ltd
Priority to CN201510565289.6A priority Critical patent/CN105159997B/en
Publication of CN105159997A publication Critical patent/CN105159997A/en
Application granted granted Critical
Publication of CN105159997B publication Critical patent/CN105159997B/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2425—Iterative querying; Query formulation based on the results of a preceding query

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Theoretical Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Report processing method and report processing system of the present invention, are related to data processing method and data handling system, which includes：Step S1：The form document of local side is read by client, the form document is recorded with least a line, and at least a line record at least has a row；Step S3：The form document is sent to by server by client；Step S5：The server reads the form document, and described at least a line record is packaged into object is stored in the container of template library；Step S7：The object is associated with data storage procedure by XML descriptor, obtains associated SQL statement；Step S9：By performing the SQL statement after associating, so that the database by least a line record deposit server of the form document.Implement the present invention rapidly can make a report on data based on form document batch.

Description

Report processing method and report processing system
Technical field
The present invention relates to computer digital animation, more particularly, to a kind of report processing method and report processing system.
Background technology
ERP system（Resource management system）It is important productivity tool.Traditional business intelligence modeling is all from ERP systems The access of system the inside, but still some data are that ERP system can not temporarily be taken into account, so needing to upload database and managing.
Therefore, there is an urgent need for a kind of report form processing scheme.
The content of the invention
The first aspect of the present invention, there is provided a kind of report processing method, including：Step S1：Read by client local The form document at end, the form document are recorded with least a line, and at least a line record at least has a row；Step S3：The form document is sent to by server by client；Step S5：The server reads the form document, will At least a line record is packaged into object and is stored in the container of template library；Step S7：By XML descriptor by the object Associated with data storage procedure, obtain associated SQL statement；Step S9：By performing the SQL statement after associating, so that By the database of at least a line record deposit server of the form document.
As a modification of the present invention, the step S5 is specifically included：The server reads the form document；Will At least a line record is put into the orderly container of template library；The record in order in container will be put into and be packaged into object storage Into unordered container.
As a modification of the present invention, between step S3 and step S5, further include：Step S4：The client is sentenced Whether the form document that breaks is successfully sent to the server；If so, the feedback that then runs succeeded.
As a modification of the present invention, the feedback that runs succeeded includes：Data model, institute are constructed in the client Stating data model includes field name；Data warehouse is constructed in the client；The client is based on the data model to institute State data warehouse and send data acquisition request；The data warehouse is based on asking to send number to the server required by the data According to request；The server is asked to the data warehouse returned data according to the data acquisition；The client receives institute The data of server return are stated, and are showed data according to the data model.
As a modification of the present invention, it is described by data show including：Data are constructed according to the data model Grid, the row of the data grids are associated with the corresponding field of the data model；The number is presented by the data grids According to.
As a modification of the present invention, described show data further includes：Only refresh the data grids area The display content in domain.
The second aspect of the present invention, there is provided a kind of report processing system, includes the client and server of communication connection.Institute Stating client includes file sending module, for reading the form document of local side and the form document being sent to the clothes Business device, the form document are recorded with least a line, and at least a line record at least has a row.The server bag Include：Data package module, for reading the form document, is packaged into object by described at least a line record and is stored in template library Container in；Conversion module is stored, for being associated the object with data storage procedure by XML descriptor, is obtained Associated SQL statement；Module for reading and writing is stored, for performing the SQL statement after associating, so that at least one by the form document The database of row record deposit server.
As a modification of the present invention, the storage conversion module has encapsulation unit, is used for：Will described at least a line Record is put into the orderly container of template library；The record that will be put into the orderly container is packaged into object and is stored in unordered container It is interior.
As a modification of the present invention, the client further includes：Data model constructing module, in the client End construction data model, the data model include field name；Data acquisition module, for sending number based on the data model Asked according to asking for；Data warehouse constructing module, for constructing data warehouse in the client, being asked according to the data acquisition To the server data request and receive data of the server according to request return
As a modification of the present invention, the client further includes data and module is presented, and module root is presented in the data Construct data grids according to the data model, and the data be presented by the data grids, the row of the data grids with The corresponding field association of the data model.
In the preferred embodiment of the present invention, server end can be by the data batch in form document that client sends over Amount extracts, and is stored in database；Client has data warehouse, also receives data acquisition and asks and asked for server Data, it is achieved thereby that batch, transparence data are made a report on.
【Brief description of the drawings】
Fig. 1 is the flow chart that the report that one embodiment of the invention provides makes a report on method；
Fig. 2 is the flow chart that the report that one embodiment of the invention provides makes a report on system.
【Embodiment】
With reference to figure 1, report processing method provided by one embodiment of the present invention is realized in server end and browser end.Cause For browser end i.e. user terminal, so referred to as user terminal.It should be recognized that this kind of report processing method can also service Device end, application（app）Realize that in the case of this kind, application end is known as user terminal in end.So-called application（app）, including mobile phone should With, tablet computer application etc..
The report processing method mainly includes the following steps that：
In step S1, the form document of local side is read by client, form document is recorded with least a line, at least A line record at least has a row.In patent specification and claims, form document refers to content with row, column group The file knitted, such as excel form documents, cvs form documents, form document based on xml etc..It is appreciated that form One field of the usually corresponding SQL database of a row of file；One row of form document usually corresponds to the one of SQL database Bar records.
In step S3, form document is sent to by server by client.For example, will by http or https agreements Form document is sent to server.
In step S5, server reads form document, and at least a line is recorded to the appearance for being packaged into object and being stored in template library In device.In the present embodiment, server is configured with Standard Template Library, and the list that form document is first read template library by server holds Device, which is ordered into container, but the present invention need not be ranked up the record in list containers.Then, to orderly container Interior record is packaged into object and is stored in map containers, which is ordered into container.
In step S7：Object is associated with data storage procedure by XML descriptor, obtains associated SQL statement.
In step S9, by performing the SQL statement after associating, so that at least a line record deposit service by form document The database of device.So far, complete the record inside the form document by user terminal and be stored in server-side database in bulk.
In order to improve user experience, between step S3 and step S5, step S4 is further included：Client judges form document Whether server is successfully sent to；If so, the feedback that then runs succeeded.For example, it can be a text prompt that this, which successfully feeds back, accuse Know that user's form document is received by server.
Further, the feedback that runs succeeded includes：
Data model is constructed in client, data model includes field name, i.e. one tables of data of data model definitions Field information, including mutual alignment relation of field name, field type, field etc.；
Data warehouse is constructed in client, the data warehouse of user terminal is actually virtual varehouse or transit depot, when Just send data acquisition request to data warehouse when user terminal needs data, and database be based on asking required by the data acquisition to Server sends request of data；Server based on data is asked to data warehouse returned data；Client receives server and returns Data, and data are showed according to data model.
Further, user terminal by data show including：Data grids are constructed according to data model, data grids Row are associated with the corresponding field of data model；Data are presented by data grids.
Further, in order to improve user experience, the technologies such as ajax can be applicable in and only refresh data in browser page The display content of net region, the content in other regions of the page remain unchanged.
The framework for implementing a kind of report processing system of the report processing system of the present invention is as shown in Figure 2.The report form processing System includes the client 30 and server 50 of communication connection.
Client 30 includes file sending module 31, data model constructing module 33, data acquisition module 35, data warehouse Module 39 etc. is presented in constructing module 37, data.
Wherein, file sending module 31 is used to read the form document of local side and form document is sent to server, Form document is recorded with least a line, and at least a line record at least has a row.
Data model constructing module 33 is used to construct data model in client, and data model includes field name.
Data acquisition module 35 is used to send data acquisition request based on data model.
Data warehouse constructing module 37 is used to ask to server count in client construction data warehouse, according to data acquisition The data returned according to asking and receiving server according to request.
Data are presented module 39 and construct data grids according to data model, and data, data network is presented by data grids The row of lattice are associated with the corresponding field of data model.
Server 50 includes data package module 51, storage conversion module 53 and storage module for reading and writing 56.
Data package module 51 is used to read form document, and at least a line record is packaged into object is stored in template library In container.
Storage conversion module 53 is used to associate object with data storage procedure by XML descriptor, is associated SQL statement.For example, at least a line record of form document is put into the orderly container of template library；The appearance in order will be put into Record in device is packaged into object and is stored in unordered container.
Store module for reading and writing 56 to be used to perform the SQL statement after association, so that at least a line record of form document be deposited Enter the database of server.
Embodiment described above only expresses the several embodiments of the present invention, its description is more specific and detailed, but simultaneously Therefore the limitation to the scope of the claims of the present invention cannot be interpreted as.It should be pointed out that for those of ordinary skill in the art For, without departing from the inventive concept of the premise, various modifications and improvements can be made, such as in each embodiment not It is combined with feature, these belong to protection scope of the present invention.

Claims (10)

  1. A kind of 1. report processing method, it is characterised in that including：
    Step S1：By client read local side form document, the form document have at least a line record, it is described extremely Few a line record at least has a row；
    Step S3：The form document is sent to by server by client；
    Step S5：The server reads the form document, and described at least a line record is packaged into object is stored in template In the container in storehouse；
    Step S7：The object is associated with data storage procedure by XML descriptor, obtains associated SQL statement；
    Step S9：By performing the SQL statement after associating, so that at least a line record deposit server by the form document Database.
  2. 2. report processing method as claimed in claim 1, it is characterised in that the step S5 is specifically included：
    The server reads the form document；
    Described at least a line record is put into the orderly container of template library；
    The record that will be put into the orderly container is packaged into object and is stored in unordered container.
  3. 3. report processing method as claimed in claim 2, it is characterised in that between step S3 and step S5, further include：Step Rapid S4：The client judges whether the form document is successfully sent to the server；If so, the feedback that then runs succeeded.
  4. 4. report processing method as claimed in claim 3, it is characterised in that the feedback that runs succeeded includes：
    Data model is constructed in the client, the data model includes field name；
    Data warehouse is constructed in the client；
    The client is based on the data model and sends data acquisition request to the data warehouse；
    The data warehouse is based on asking to send request of data to the server required by the data acquisition；
    The server is according to the request of data to the data warehouse returned data；
    The client receives the data that the server returns, and is showed data according to the data model.
  5. 5. report processing method as claimed in claim 4, it is characterised in that it is described by data show including：
    Data grids are constructed according to the data model, the row of the data grids are closed with the corresponding field of the data model Connection；
    The data are presented by the data grids.
  6. 6. report processing method as claimed in claim 5, it is characterised in that described show data further includes：
    Only refresh the display content in the data grids region.
  7. 7. a kind of report processing system, includes the client and server of communication connection, it is characterised in that：
    The client includes file sending module, for reading the form document of local side and being sent to the form document The server, the form document are recorded with least a line, and at least a line record at least has a row；
    The server includes：
    Data package module, for reading the form document, is packaged into object by described at least a line record and is stored in template In the container in storehouse；
    Conversion module is stored, for being associated the object with data storage procedure by XML descriptor, is obtained associated SQL statement；
    Module for reading and writing is stored, for performing the SQL statement after associating, so that at least a line of the form document is recorded deposit The database of server.
  8. 8. report processing system as claimed in claim 7, it is characterised in that the storage conversion module has encapsulation unit, For：
    Described at least a line record is put into the orderly container of template library；
    The record that will be put into the orderly container is packaged into object and is stored in orderly container.
  9. 9. report processing system as claimed in claim 8, it is characterised in that
    The client further includes：
    Data model constructing module, for constructing data model in the client, the data model includes field name；
    Data acquisition module, for sending data acquisition request based on the data model；
    Data warehouse constructing module, for constructing data warehouse in the client, being asked according to the data acquisition to described The data that server data request and the reception server are returned according to request.
  10. 10. report processing system as claimed in claim 9, it is characterised in that the client further includes data and module is presented, The data are presented module and construct data grids according to the data model, and the data are presented by the data grids, The row of the data grids are associated with the corresponding field of the data model.
CN201510565289.6A 2015-09-08 2015-09-08 Report processing method and report processing system Expired - Fee Related CN105159997B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201510565289.6A CN105159997B (en) 2015-09-08 2015-09-08 Report processing method and report processing system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201510565289.6A CN105159997B (en) 2015-09-08 2015-09-08 Report processing method and report processing system

Publications (2)

Publication Number Publication Date
CN105159997A CN105159997A (en) 2015-12-16
CN105159997B true CN105159997B (en) 2018-05-08

Family

ID=54800853

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201510565289.6A Expired - Fee Related CN105159997B (en) 2015-09-08 2015-09-08 Report processing method and report processing system

Country Status (1)

Country Link
CN (1) CN105159997B (en)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109325042B (en) * 2018-08-14 2023-11-24 中国平安人寿保险股份有限公司 Processing template acquisition method, form processing method, device, equipment and medium
CN109324770A (en) * 2018-10-16 2019-02-12 中山市晋华软件科技有限公司 Page Report Printing System and method
CN109388647B (en) * 2018-10-30 2020-09-29 成都四方伟业软件股份有限公司 WEB-based data filling method and system
CN110347992B (en) * 2019-07-10 2024-05-14 成都函夏科技有限公司 Data analysis method and system based on electronic report

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103034658A (en) * 2011-09-29 2013-04-10 福建睿能电子有限公司 Method and system for querying data and exporting report
CN103678575A (en) * 2013-12-11 2014-03-26 四川九洲电器集团有限责任公司 Method and system for achieving unified processing on multiple database data through middleware
CN104281447A (en) * 2014-09-01 2015-01-14 国家电网公司 Report form fast generating and issuing system and method

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103034658A (en) * 2011-09-29 2013-04-10 福建睿能电子有限公司 Method and system for querying data and exporting report
CN103678575A (en) * 2013-12-11 2014-03-26 四川九洲电器集团有限责任公司 Method and system for achieving unified processing on multiple database data through middleware
CN104281447A (en) * 2014-09-01 2015-01-14 国家电网公司 Report form fast generating and issuing system and method

Also Published As

Publication number Publication date
CN105159997A (en) 2015-12-16

Similar Documents

Publication Publication Date Title
US20200293549A1 (en) Blockchain-based data processing method and device
CN105159997B (en) Report processing method and report processing system
US10528626B2 (en) Document processing
CN104283975B (en) Document distribution method and device
CN104036375A (en) Bar-code-based material dynamic tracking warehousing data processing system and method
CN104169914A (en) Data storage method, data processing method, device and mobile terminal
CN108366109A (en) A kind of meteorological data numerical forecast cloud shared platform and data sharing method
CN106301885A (en) The method and system of uniform traffic management
CN110275861A (en) Date storage method and device, storage medium, electronic device
CN104102489A (en) Third-party database APP (Application) construction system and construction method
CN109271561B (en) Map information retrieval method and device
CN109074388A (en) The priority of thumbnail preview is divided based on message content
CN103561083B (en) Data processing method for Internet of things
CN104008485A (en) Intelligent order generation device and method
CN103886491A (en) Mobile phone network invoice system based on IOS operating system
CN103518195A (en) Apparatus, system and method for vector-based form field document
CN102156736A (en) Method for transmitting data between SAP (Systems Application) system and SQL (Structured Query Language) database
CN104219639A (en) Method and device for displaying text message record
US20120158583A1 (en) Automated bank transfers using identifier tokens
CN107403012A (en) A kind of method for interchanging data and device
US9607012B2 (en) Interactive graphical document insight element
CN106845766A (en) Information collecting method
CN105740293B (en) Data export method and device
CN113722345A (en) Method and device for displaying mapping relation, electronic equipment and storage medium
CN109308605B (en) Electronic time capsule management method and system based on block chain

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
CB02 Change of applicant information
CB02 Change of applicant information

Address after: 518053 unit A, block No. 4068, smart square, No. 4068, Nanshan District Qiao Xiang Road, Nanshan District, Guangdong Province, 501

Applicant after: Shenzhen Digital Information Technology Co., Ltd.

Address before: 518000 Changhong science and technology building, Nanshan District science and technology south twelve, Nanshan District, Shenzhen, Guangdong

Applicant before: SHENZHEN XIJIN INFORMATION TECHNOLOGY CO., LTD.

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: 20180508

Termination date: 20180908