CN103020033B - A kind of support off-line to use Electronic Bill System and construction method - Google Patents

Abstract

The invention discloses a kind of Electronic Bill System supporting off-line to use, comprise list DHTML design module, form data design module, form data adaptation module and the public DHTML module of list, list offline storage module, wherein list DHTML design module is used for the pattern of designing form, form data design module is according to the data structure of the form automatically generate form of list, form data adaptation module is used for form data transmitted in both directions between server and client side, the public DHTML module of list provides form data to combine list pattern DHTML display complete form, list offline storage module is used for the list pattern DHTML in system, this locality that the public DHTML of list and form data are stored as client stores and provides off-line look facility.Electronic Bill System of the present invention, can not only realize the online use of electronic spreadsheet, and can support that the off-line of electronic spreadsheet is applied.

Description

A kind of support off-line to use Electronic Bill System and construction method

Technical field

The present invention relates to a kind of electronic spreadsheet, especially the Data Structure Design of electronic spreadsheet, belongs to computer realm.

Background technology

Along with the development of computer industry, the extensive employing of information system, electronic spreadsheet widespread use in the informatization of all trades and professions.Government, enterprise, by building the infosystem (office system, operation system etc.) of various electronization, use electronic spreadsheet fill in for user and check various data.

Existing electronic spreadsheet is all based in Data Structure Design and in the generation of list that object that line uses carries out building, once depart from network, user is difficult to continue the information of checking.For this problem, existing Electronic Bill System provides reporting system usually, make various form and check form data for user's download, but form is all the secondary treating processing of original electronic form data, there is very large difference with original electronic spreadsheet data and pattern, user cannot check and examine original electronic spreadsheet data.

The pattern of electronic spreadsheet and realize structure and generally made by the developer of infosystem or managerial personnel, be separated with the form data that user fills in and deposit, in existing Electronic Bill System, if user needs to check form data, by system, data and list pattern must be integrated, be shown to user by browser or client.If what user needed off-line checks form information, just can only generate formfile by infosystem and download for user.Such as, a kind of way of the prior art is: developer or managerial personnel make Word document template in addition, and development of information system corresponding software module is inserted into form data in document template, forms final Word document.

In the market existing Electronic Bill System all can not simple and fast, realize the off-line look facility of all lists completely.

Summary of the invention

For the problems referred to above, first object of the present invention there is provided a kind of Electronic Bill System supporting off-line to use, and online use and the off-line that can realize electronic spreadsheet use simultaneously.

Second object of the present invention is to provide a kind of electronic spreadsheet construction method, and the electronic spreadsheet constructed by it can support off-line and online use.

An also object of the present invention is to provide a kind of electronic spreadsheet, and its Data Structure Design can support that online and off-line uses.

In the present invention, industry technical term used adopts this area generic concept, such as:

DHTML (Dynamic HyperText Markup Language) Dynamic Hyper Text Makeup Language, merge HTML (HyperText Markup Language HTML (Hypertext Markup Language)), script (based on JavaScript), a special kind of skill of DOM model (Document Object Model DOM Document Object Model) and CSS (Cascading Style Sheets cascading style list), for strengthening dynamic effect and the interactivity of webpage.

XML (Extensible Markup Language) is a kind of markup language, for structuring, storage and transmission data, by definition rule coded document, makes its form have the readability of human oriented and the readability of Machine oriented.Current XML is widely used in the storage of various data, retrieval and mutual.

JSON (JavaScript Object Notation) is a kind of text based open standard, is the exchanges data design that human oriented is readable.Breaking up out from this script of JavaScript, for representing the various simple data structure and the associating array that are called as object, is a kind of technology irrelevant with language, and there is various resolver can be also various language service.

For achieving the above object, the present invention is achieved through the following technical solutions:

A kind of Electronic Bill System supporting off-line to use, comprise list DHTML design module, form data design module, form data adaptation module and the public DHTML module of list, list offline storage module, wherein list DHTML design module is used for the pattern of designing form, form data design module is according to the data structure of the form automatically generate form of list, form data adaptation module is used for form data transmitted in both directions between server and client side, the public DHTML module of list provides form data to combine list pattern DHTML display complete form, list offline storage module is used for the list pattern DHTML in system, this locality that the public DHTML of list and form data are stored as client stores and provides off-line look facility.

Pass through said structure, Electronic Bill System of the present invention is able between server end and client, realize the multiplexing of electronic spreadsheet data, due to electronic spreadsheet data two-way circulating between server end and client can be realized by form data adaptation module, client is able to the electronic spreadsheet data of server end to be stored in offline storage module in conjunction with list DHTML, thus can exhaustively reappear the electronic spreadsheet that server end stores by complete, accurate, milli when needed, the off-line realizing electronic spreadsheet uses.

Meanwhile, said system still can be supported electronic spreadsheet at online access and fill in as existing Electronic Bill System, can support the electronic spreadsheet of traditional application on site.

Concrete, the cooperative working process of each module is:

The public DHTML module of list DHTML design module, form data design module, form data adaptation module and list is deployed in server end, the DHTML of single list pattern is transferred to client by list DHTML design module, list public DHTML module is by DHTML fragments for transport public for all lists to client, and form data adaptation module transmission electronic form data is to client and/or collect the electronic spreadsheet data of client and be transferred to server and carry out form data storage.

Described list offline storage module is deployed in client, and this locality that the form data store server end and list pattern DHTML, the public DHTML of list and form data are stored as client stores.

Wherein, electronic spreadsheet data can be transmitted in any form in Electronic Bill System, and in order to realize the structuring of list and data and the separable design of sheet format, the form of electronic spreadsheet data is XML or JSON, and transmission mode is synchronous or asynchronous.

Above-mentioned transmission mode, i.e. asynchronous transmission, synchronous transmission are that computing machine, communications industry technician are known.

In the offline storage of client this locality, various existing mode can be adopted to realize, include but not limited to that local storage can use HTML, compressed package (ZIP, CAB, RAR etc.), the mode such as MHTML, program module (DLL/OCX/EXE etc.) resource carrys out the various resources (comprising list pattern DHTML, the public DHTML of list and electronic spreadsheet data) of store electrons list, the data of offline storage can use the browser of this module self or Web browser to check off-line list.

Concrete, the way of realization that online resource (list pattern DHTML, the public DHTML of list and form data) dump is offline resources can be provide after integrating on system server download or in client, current server list resource of checking saved as independent file by list offline storage module.

Corresponding with said system, the invention discloses a kind of electronic spreadsheet construction method supporting off-line to use, be included in the step that client integrates form data and list pattern.

Concrete, comprise the steps:

(1) from server end by list DHTML, comprise the DHTML of single list pattern and the public DHTML fragments for transport of all lists to client;

(2) electronic spreadsheet data are transferred to client by server end; If list to be filled out, then data are empty.

(3) DHTML of list loads electronic spreadsheet data display list in client; If data are empty.Initialization list

(4) client fills in list, sends to server end to store the data of filling in;

(5) client is by the DHTML of list, comprises the DHTML of single list pattern and the public DHTML fragment of all lists and electronic spreadsheet data and is saved to offline storage.

When client needs off-line to check list, open the list DHTML in offline storage, the list DHTML of off-line loads electronic spreadsheet data display list automatically, thus the off-line achieving electronic spreadsheet uses, simultaneously this mode can't destroy the data of list, data display layout, list pattern.

The Electronic Bill System that the whole implementation procedure of above-mentioned construction method is above-mentioned with the present invention is corresponding, transmission as the DHTML of single list pattern is realized by list DHTML design module, the transmission of the DHTML fragment that all lists are public is realized by the public DHTML module of list, the transmission of form data is then realized by form data adaptation module, the offline storage of list and checking, is realized by list offline storage module.

Wherein, electronic spreadsheet data are synchronous or asynchronous transmission between server end and client, and its form is XML or JSON.

Further, in order to realize above-mentioned construction method and Electronic Bill System, the invention also discloses a kind of electronic spreadsheet, the data structure of described electronic spreadsheet is made up of list DHTML and electronic spreadsheet data, due to by form data and list pattern separate design, two-way circulating and using of form data can be realized.

Wherein, described list DHTML comprises the DHTML (correspond to list pattern) used in individual system or project of single list pattern and the public DHTML fragment (the general list pattern corresponding to being applied in any form system in the initial designs moment) of all lists, described electronic spreadsheet data acquisition XML or JSON form.

In sum, electronic spreadsheet of the present invention not only achieves traditional online use, the more important thing is, electronic spreadsheet of the present invention can use by off-line, and it is synchronous to keep with the electronic spreadsheet of server end on list pattern, form data.

Accompanying drawing explanation

Fig. 1 is the schematic diagram of the Electronic Bill System that the present invention supports off-line to use.

Embodiment

With reference to figure 1, be appreciated that the construction method of Electronic Bill System of the present invention and electronic spreadsheet, wherein list DHTML design module, form data design module, form data adaptation module and the public DHTML module of list are deployed in server end, the DHTML of single list pattern is transferred to client by list DHTML design module, list public DHTML module by DHTML fragments for transport public for all lists to client, form data adaptation module transmission electronic form data is to client and/or collect the electronic spreadsheet data of client and be transferred to server and carry out form data storage, list offline storage module is deployed in client, the form data that server end is stored and list pattern DHTML, this locality that the public DHTML of list and form data are stored as client stores.

Claims (3)

1. the Electronic Bill System supporting off-line to use, it is characterized in that comprising list DHTML design module, form data design module, form data adaptation module and the public DHTML module of list, list offline storage module, wherein list DHTML design module is used for the pattern of designing form, form data design module is according to the data structure of the form automatically generate form of list, form data adaptation module is used for form data transmitted in both directions between server and client side, the public DHTML module of list provides form data to combine list pattern DHTML display complete form, list offline storage module is used for the list pattern DHTML in system, this locality that the public DHTML of list and form data are stored as client stores and provides off-line look facility, wherein, the public DHTML module of list DHTML design module, form data design module, form data adaptation module and list is deployed in server end, the DHTML of single list pattern is transferred to client by list DHTML design module, list public DHTML module is by DHTML fragments for transport public for all lists to client, and form data adaptation module transmission electronic form data is to client and/or collect the electronic spreadsheet data of client and be transferred to server and carry out form data storage, list offline storage module is deployed in client, and this locality that the form data store server end and list pattern DHTML, the public DHTML fragment of list and form data are stored as client stores, the form of electronic spreadsheet data is XML or JSON, and transmission mode is synchronous or asynchronous.

2. Electronic Bill System according to claim 1, is characterized in that the local implementation stored is HTML, compressed package, MHTML or program module resource.

3. support the electronic spreadsheet construction method that off-line uses, the Electronic Bill System that the support off-line based on claim 1 uses, it is characterized in that being included in the step that client integrates form data and list pattern; Concrete comprises the steps:

(1) from server end by list DHTML, comprise the DHTML of single list pattern and the public DHTML fragments for transport of all lists to client;

(2) electronic spreadsheet data are transferred to client by server end;

(3) DHTML of list loads electronic spreadsheet data display list in client;

(4) client fills in list, sends to server end to store the data of filling in;

(5) client is by the DHTML of list, comprises the DHTML of single list pattern and the public DHTML fragment of all lists and electronic spreadsheet data and is saved to offline storage;

Wherein, electronic spreadsheet data are synchronous or asynchronous transmission between server end and client, and its form is XML or JSON.