CN106776839B - Method for hierarchical deployment of report forms - Google Patents

Method for hierarchical deployment of report forms Download PDF

Info

Publication number
CN106776839B
CN106776839B CN201611063560.7A CN201611063560A CN106776839B CN 106776839 B CN106776839 B CN 106776839B CN 201611063560 A CN201611063560 A CN 201611063560A CN 106776839 B CN106776839 B CN 106776839B
Authority
CN
China
Prior art keywords
unit
data
web service
level
database
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
Application number
CN201611063560.7A
Other languages
Chinese (zh)
Other versions
CN106776839A (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.)
Inspur General Software Co Ltd
Original Assignee
Inspur General Software 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 Inspur General Software Co Ltd filed Critical Inspur General Software Co Ltd
Priority to CN201611063560.7A priority Critical patent/CN106776839B/en
Publication of CN106776839A publication Critical patent/CN106776839A/en
Application granted granted Critical
Publication of CN106776839B publication Critical patent/CN106776839B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting
    • G06Q40/125Finance or payroll

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Finance (AREA)
  • Data Mining & Analysis (AREA)
  • Accounting & Taxation (AREA)
  • General Engineering & Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Development Economics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Technology Law (AREA)
  • General Business, Economics & Management (AREA)
  • Storage Device Security (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a method for the hierarchical deployment of reports, which comprises the following steps: firstly, respectively deploying application systems of the current level in different level units; configuring Web services for each level unit, and respectively checking whether the Web services are available; when one hierarchy unit sends data to another hierarchy unit, the sending hierarchy unit writes the data into a database and packs the data, writes related records into the database, and stores a compressed packet into an application server of the unit; and the receiving level unit calls the Web service to check the record sent by the sending level unit, calls the Web service again to select to download the data packet to the application server of the unit, reads the data of the database and returns the receiving record to the sending level unit. Compared with the prior art, the method for the report hierarchical deployment saves manpower and material resources, combines Web service and SQLite light database, ensures simple and high-speed data intercommunication, and ensures the integrity, consistency and safety of the data.

Description

Method for hierarchical deployment of report forms
Technical Field
The invention relates to the technical field of computer application, in particular to a method for hierarchical deployment of reports.
Background
In a large-scale enterprise in the prior art, such as various group companies, the large-scale enterprise generally includes a plurality of subsidiaries such as secondary units, tertiary units, and the like, and in order to realize real-time financial supervision of the group company on the subsidiaries, the subsidiaries need to report financial data to the group company regularly. The group company also needs to issue the table sample of the financial statement to the subsidiary company. Each subsidiary company has independent finance and a set of financial system. In the prior art, the report can be issued step by step only through the spreadsheet, and the data can be reported step by step. Because the financial data is complicated, huge manpower and material resources are consumed for transferring, receiving and verifying the data.
Based on this, the user hopes to conveniently and quickly complete the sending and receiving of the data, and simultaneously keeps the integrity, consistency, effectiveness and confidentiality of the data, so the invention provides a method for the hierarchical deployment of the report.
Disclosure of Invention
Aiming at the defects, the technical task of the invention is to provide a method for the hierarchical deployment of the report.
A method for hierarchical deployment of reports comprises the following implementation processes:
firstly, respectively deploying application systems of the level in different level units, wherein the application systems comprise published Web services;
configuring Web services for each level unit, and respectively checking whether the Web services are available;
after the service configuration is completed, when one hierarchy unit sends data to another hierarchy unit, the sending hierarchy unit writes the data into a database and packs the data, writes related records into the database, and stores a compressed packet into an application server of the unit;
and the receiving level unit calls the Web service to check the record sent by the sending level unit, calls the Web service again to select to download the data packet to the application server of the unit, reads the data of the database and returns the receiving record to the sending level unit.
The configuration of the Web service refers to the configuration of the address of the Web service at the current level, the addresses of the Web services at other levels, a user name and a password by a user at a higher level, namely, the data transmission of the Web service is encrypted, and the security of the data is ensured.
And writing the data sent by the sending level unit user into the embedded relational database SQLite, generating and packaging database files, and writing data sending records after successful packaging.
Before receiving a data packet, a receiving level unit firstly verifies whether Web service is available or not and whether a user is legal or not; after the verification is passed, calling the Web service, selecting data to be received according to the transmission record, calling the Web service to acquire a transmitted data packet, namely a packed SQLite database file, decrypting and decompressing, and writing the data packet into the unit database.
Compared with the prior art, the method for the hierarchical deployment of the report forms has the following beneficial effects:
the method for the hierarchical deployment of the report forms is convenient for companies with similar group scales to monitor the finance of subsidiaries, provides great convenience, does not use the traditional spreadsheet layer-by-layer summary mode any more, saves manpower and material resources, combines Web services and SQLite light databases, enables the intercommunication of data to be simple and high-speed, ensures the integrity, consistency and safety of the data, has strong practicability and wide application range, and has good popularization and application values.
Drawings
FIG. 1 is a diagram of a Web service authentication process in accordance with the present invention.
Fig. 2 is a diagram of a packet packing process.
Fig. 3 is a schematic diagram of a packet reception process.
Detailed Description
The present invention will be further described with reference to the following specific examples.
As shown in fig. 1, a method for hierarchical deployment of reports includes the following steps:
firstly, respectively deploying application systems of the level in different level units, wherein the application systems comprise published Web services;
configuring Web services for each level unit, and respectively checking whether the Web services are available;
after the service configuration is completed, when one hierarchy unit sends data to another hierarchy unit, the sending hierarchy unit writes the data into a database and packs the data, writes related records into the database, and stores a compressed packet into an application server of the unit;
and the receiving level unit calls the Web service to check the record sent by the sending level unit, calls the Web service again to select to download the data packet to the application server of the unit, reads the data of the database and returns the receiving record to the sending level unit.
Taking a group unit report diversity deployment as an example, the group unit includes: the group company, the secondary unit, the tertiary unit and the like, and the concrete realization process is as follows:
step S01: the group company, the secondary unit, the tertiary unit and the like respectively deploy the application systems of the unit, and the application systems comprise the issued Web services.
Step S02: the upper unit user configures the current Web service address, the lower Web service address, the user name and the password; the lower-level unit user configures the current-level Web service address, the upper-level Web service address, the user name and the password; and the Web services of the upper unit and the lower unit are tested successfully.
Step S03: and the superior unit user selects the data to be issued, writes the data into an SQLite light database, packs the data, and writes the issuing records.
Step S04: and the lower unit calls the Web service to check the issued record of the upper unit, selects the received data and returns the received record to the upper unit.
Step S05: the upper unit calls the Web service to confirm that the lower unit has successfully received the data.
Wherein the step S02 includes the following steps: the upper level unit user configures the Web service address, the user name and the password of the level, and the Web service address, the user name and the password of the lower level. The lower level unit user configures the Web service address, the user name and the password of the level, and the Web service address, the user name and the password of the upper level. The data transmission of the Web service is encrypted, and the safety of the data is ensured. The upper and lower levels can verify whether the Web service is matched and communicated at any time, and the seamless data butt joint can be realized only on the premise of matching and communicating the service.
Wherein step S03 includes the following: and the superior unit user issues data, writes the data into an embedded relational database SQLite, generates and packages a database file, and needs to write data issuing records after successful packaging. The SQLite belongs to a light database, but has the advantages of strong function, quick reading and writing, no need of installation and management configuration, and support of multi-language cross-platform, and is one of the advantages of the method. Similarly, the subordinate unit may also report data using this process.
Wherein the step S04 includes the following steps: before receiving the data packet, the lower unit needs to verify whether the Web service is available or not and whether the user is legal or not. And after the verification is passed, calling the Web service to check whether the upper level has the issued record. After the lower unit selects the data to be received, the Web service is called to obtain the data packet sent by the upper unit, namely the packed SQLite database file, the decryption and decompression are carried out, and the data packet is written into the unit database. The process of receiving data by the upper unit is the same as the above-described process.
Wherein step S05 includes the following: and after the lower unit receives the data, calling the Web service to return the received record information to the upper unit. The upper level can see the receiving record of the transmitted data, and the lower level can see the receiving record of the reported data, so that the data intercommunication is completely realized.
FIG. 1 illustrates a Web service authentication process. The upper level unit user configures the Web service address, the user name and the password of the level, and the Web service address, the user name and the password of the lower level. The lower level unit user configures the Web service address, the user name and the password of the level, and the Web service address, the user name and the password of the upper level. The data transmission of the Web service is encrypted, and the safety of the data is ensured. The upper and lower levels can verify whether the Web service is matched and communicated at any time, and the seamless data butt joint can be realized only on the premise of matching and communicating the service.
Fig. 2 shows the process of packaging data packets and logging by using the SQLite embedded database. And the superior unit user issues data, writes the data into an embedded relational database SQLite, generates and packages a database file, and needs to write data issuing records after successful packaging. The SQLite belongs to a light database, but has the advantages of strong function, quick reading and writing, no need of installation and management configuration, and support of multi-language cross-platform, and is one of the advantages of the method. Similarly, the subordinate unit may also report data using this process.
Figure 3 shows the process of receiving data packets in conjunction with Web services and SQLite embedded databases. Before receiving the data packet, the lower unit needs to verify whether the Web service is available or not and whether the user is legal or not. And after the verification is passed, calling the Web service to check whether the upper level has the issued record. After the lower unit selects the data to be received, the Web service is called to obtain the data packet sent by the upper unit, namely the packed SQLite database file, the decryption and decompression are carried out, and the data packet is written into the unit database. The process of receiving data by the upper unit is the same as the above-described process.
The present invention can be easily implemented by those skilled in the art from the above detailed description. It should be understood, however, that the intention is not to limit the invention to the particular embodiments described. On the basis of the disclosed embodiments, a person skilled in the art can combine different technical features at will, thereby implementing different technical solutions.
In addition to the technical features described in the specification, the technology is known to those skilled in the art.

Claims (1)

1. A method for hierarchical deployment of reports is characterized in that the implementation process is as follows:
firstly, respectively deploying application systems of the level in different level units, wherein the application systems comprise published Web services;
configuring Web services for each level unit, and respectively checking whether the Web services are available;
after the service configuration is completed, when one hierarchy unit sends data to another hierarchy unit, the sending hierarchy unit writes the data into a database and packs the data, writes related records into the database, and stores a compressed packet into an application server of the unit;
the receiving level unit calls the Web service to check the record sent by the sending level unit, calls the Web service again to select to download the data packet to the application server of the receiving level unit, reads the data of the database and returns the receiving record to the sending level unit;
configuring Web service means that a superior unit user configures a current-level Web service address, other-level Web service addresses, a user name and a password, namely, data transmission of the Web service is encrypted, and the safety of data is ensured;
data sent by a user of a sending level unit are written into an embedded relational database SQLite, a database file is generated and packaged, and after the packaging is successful, data sending records are written;
before receiving a data packet, a receiving level unit firstly verifies whether Web service is available or not and whether a user is legal or not; after the verification is passed, calling the Web service, selecting data to be received according to the transmission record, calling the Web service to acquire a transmitted data packet, namely a packed SQLite database file, decrypting and decompressing, and writing the data packet into the unit database.
CN201611063560.7A 2016-11-28 2016-11-28 Method for hierarchical deployment of report forms Active CN106776839B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201611063560.7A CN106776839B (en) 2016-11-28 2016-11-28 Method for hierarchical deployment of report forms

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201611063560.7A CN106776839B (en) 2016-11-28 2016-11-28 Method for hierarchical deployment of report forms

Publications (2)

Publication Number Publication Date
CN106776839A CN106776839A (en) 2017-05-31
CN106776839B true CN106776839B (en) 2020-05-26

Family

ID=58904404

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201611063560.7A Active CN106776839B (en) 2016-11-28 2016-11-28 Method for hierarchical deployment of report forms

Country Status (1)

Country Link
CN (1) CN106776839B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114500223B (en) * 2022-01-21 2024-01-16 深圳日浩科技现代服务业有限公司 Cloud application-based double-organization management system and method thereof

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101610291A (en) * 2009-08-06 2009-12-23 杭州高达软件系统有限公司 Data uploading method, method for down loading and system based on third party's platform
CN103491169A (en) * 2013-09-24 2014-01-01 长沙裕邦软件开发有限公司 Method and system for uploading and downloading files

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9417119B2 (en) * 2012-06-04 2016-08-16 Abion Llc System and method to detect hidden materials using a mobile device

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101610291A (en) * 2009-08-06 2009-12-23 杭州高达软件系统有限公司 Data uploading method, method for down loading and system based on third party's platform
CN103491169A (en) * 2013-09-24 2014-01-01 长沙裕邦软件开发有限公司 Method and system for uploading and downloading files

Also Published As

Publication number Publication date
CN106776839A (en) 2017-05-31

Similar Documents

Publication Publication Date Title
US11310227B2 (en) Securely provisioning a target device
CN110912937B (en) Block chain-based digital certificate storage platform and certificate storage method
CN110597832A (en) Government affair information processing method and device based on block chain network, electronic equipment and storage medium
CN109286632B (en) Block chain-based big data authorization and evidence-storing method and system
US20070088825A1 (en) System and method of distributed license management
CN103166911B (en) A kind of version management server right management method and equipment
CN112235193B (en) Data transmission method, device, equipment and medium based on cross-network multi-level routing
CN111415233B (en) Bank electronic certificate inquiry function generation method based on blockchain multiparty authorization
US8387877B2 (en) Systems and methods for the secure control of data within heterogeneous systems and networks
CN107370604A (en) A kind of more granularity access control methods under big data environment
CN105635320A (en) Method and equipment for calling configuration information
CN105933374A (en) Mobile terminal data backup method, system and mobile terminal
CN112583887A (en) Data credible sharing method based on block chain
CN106776839B (en) Method for hierarchical deployment of report forms
CN109918867B (en) Peer-to-peer system file tracing method based on block chain
CN114036560A (en) Charging pile subsidy data management method based on block chain
CN110602051B (en) Information processing method based on consensus protocol and related device
CN113496002A (en) Mobile application platform based on mobile middle station
CN112416764A (en) Distributed integrated test method, equipment, system and storage medium based on gPC
CN106934706A (en) A kind of method and system of synchronous sales invoice
CN103136482A (en) Method of limiting opening time of document
CN105635132A (en) User authentication method and system
CN106470107A (en) A kind of message security control method, device and system
CN115208630A (en) Block chain based data acquisition method and system and block chain system
CN113158211A (en) High-safety geomagnetic detection device and system capable of being in butt joint with multiple signal machines

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
TA01 Transfer of patent application right
TA01 Transfer of patent application right

Effective date of registration: 20200426

Address after: 250100 Ji'nan high tech Zone, Shandong, No. 1036 wave road

Applicant after: INSPUR GENERAL SOFTWARE Co.,Ltd.

Address before: 250100, Ji'nan province high tech Zone, Sun Village Branch Road, No. 2877, building, floor, building, on the first floor

Applicant before: JINAN INSPUR HI-TECH INVESTMENT AND DEVELOPMENT Co.,Ltd.

GR01 Patent grant
GR01 Patent grant