CN112559837A - Business electronic file development method - Google Patents
Business electronic file development method Download PDFInfo
- Publication number
- CN112559837A CN112559837A CN202110005276.9A CN202110005276A CN112559837A CN 112559837 A CN112559837 A CN 112559837A CN 202110005276 A CN202110005276 A CN 202110005276A CN 112559837 A CN112559837 A CN 112559837A
- Authority
- CN
- China
- Prior art keywords
- electronic
- description file
- file
- content
- rule
- 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.)
- Withdrawn
Links
- 238000011161 development Methods 0.000 title claims abstract description 38
- 238000000034 method Methods 0.000 title claims abstract description 36
- 238000012545 processing Methods 0.000 claims abstract description 10
- 238000006243 chemical reaction Methods 0.000 claims description 23
- 238000004458 analytical method Methods 0.000 claims description 5
- 239000000463 material Substances 0.000 claims description 5
- 239000012776 electronic material Substances 0.000 claims description 2
- 238000009417 prefabrication Methods 0.000 claims description 2
- 230000007547 defect Effects 0.000 abstract description 2
- 238000010276 construction Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 238000009472 formulation Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
Images
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/90—Details of database functions independent of the retrieved data types
- G06F16/93—Document management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Business, Economics & Management (AREA)
- General Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention aims to overcome the defects of the prior art and provide an electronic file development method with general service, which standardizes the development standard through a general service description file according to different service requirements and quickly generates various electronic files with common types through a preset operation rule so as to solve the problems of low efficiency and poor service flexibility of the conventional electronic file development method by means of manual coding. In order to achieve the above object, the method for developing business electronic files provided by the present invention writes the business basic information metadata of the electronic files into a rule according to the standard in the pre-established general description file, and formulates different rule items for different business requirements, so as to adapt to electronic files with different contents and different formats, and no special development is needed for the electronic files with different contents, thereby efficiently and high-quality completing the electronic processing of the documents, and greatly reducing the workload of manual development.
Description
Technical Field
The invention relates to the technical field of electronic development of electronic government affair files, in particular to a method for quickly generating various common types of electronic files by standardizing a development standard through a business general description file and by presetting operation rules when a large number of electronic files are required to be developed according to different business requirements, so that the development efficiency is improved, and the maintenance cost is reduced.
Background
In an electronic government software development project, various common types of electronic archives are developed, including Excel forms, Word documents and PDF archives. Different types of electronic archives, document formats, and protocol standards are different.
In the development process, different code logics are required to be written according to different service types and different document formats, and finally, the development of electronic files of different services and different document formats is realized. At present, the development of electronic files mainly depends on manual coding, and the processing efficiency is very low. And once the business requirement is changed, the code logic of a plurality of electronic files is required to be modified to realize the business requirement, which consumes more time.
Therefore, there is a need to introduce a method for developing an electronic file with general service to further optimize the development process.
Disclosure of Invention
The invention aims to overcome the defects of the prior art and provides a business general electronic file development method, which is characterized in that a preset general description file is used as an operation rule of a subsequent link, the electronic file required by a business is subjected to rule formulation according to business requirements to generate and output a general description file, then the operation rule of the description file is analyzed in an execution stage, and the generation of the electronic file is finally completed by combining data acquired from an external data source.
In order to achieve the above object, the present invention provides an electronic archive development method based on a universal service description file, which is characterized in that: in the pre-established general description file, the service basic information metadata of the electronic file is compiled into a rule according to the standard, and different rule items can be established for different service requirements, so that the electronic file with different contents is adapted, and special development for the electronic file with different contents is not needed.
Further, the electronic archive development method based on the universal service description file is characterized in that: the development method comprises the following steps in the prefabrication of the fixed ring section:
a1, identifying the title of the electronic archive material and other general display areas, and compiling and formulating the title to be displayed and the contents of the general display areas of the electronic archive into a general description file;
a2, compiling and formulating field attributes, field formats, field reading rules and field conversion rules to be displayed aiming at dynamic content data to be displayed of the electronic material document, and storing the field attributes, the field formats, the field reading rules and the field conversion rules into a general description file;
and step A3, storing the preset general description file into a corresponding program resource file directory.
Further, in the method for developing the electronic archive based on the universal service description file, in the execution stage link, the operation rule can be read from the description file according to the universality of the description file, and different types of electronic archives including but not limited to Excel forms, Word documents, PDF archives and the like can be generated by matching with the data content information read from the database.
Further, the execution phase link comprises the following steps:
step B1, an execution link firstly receives operation input of a user, the operation of the user on an interface is converted into a requested parameter, and the parameter content comprises: an electronic archive description file ID to be generated, and data information ID of the electronic archive to be generated;
b2, converting the user operation into parameters for analysis, firstly finding the position of the description file by using the ID of the description file during execution, and reading the content of the description file;
b3, reading the operation rule in the content according to the content of the description file, and analyzing title content information and field attribute metadata required for generating the content of the required electronic document according to different operation rules;
step B4., according to the field information metadata analyzed from the description file, executing the field reading rule for querying the database in the description file, reading the required content data information from the database, and caching the content data information in the internal memory for further processing;
step B5., according to the field conversion rule and the field format rule analyzed from the description file, processing the content data read in the step B4 into the field format meeting the rule requirement;
in step B6., because different electronic files have different generation tools, the electronic file generation tool is called according to the electronic file type requirement of the description file, and the results of parsing, reading and processing in steps B3 to B5 are transmitted to the electronic file generation tool, and finally the electronic file meeting the requirement of the description file is generated.
In step B6, the electronic file generation tool is a software development tool that is developed by using program codes and can generate electronic file files according to different electronic document file format specifications.
Further, the standard basis of the universal description file comprises:
-electronic archive type criteria: establishing a type consisting of preset 'keywords' based on service characteristics for configuration;
-electronic archive description file standard: based on the establishment of business content, dividing and defining the corresponding content of different types of document materials;
-electronic archive content format rules: based on the establishment of business content, setting format requirements for displaying different types of electronic files, so that the development method can display corresponding formats as required;
-electronic archive content reading rules: setting a mode and a way when reading the content to be generated aiming at different types of electronic files based on the establishment of the business content;
-electronic archive content conversion rules: based on the establishment of business content, setting a conversion mode and a conversion path aiming at different types of electronic files when the data source format is inconsistent with the electronic file generation target format.
The invention adopts the scheme, and has the beneficial effects that: through the general description file of the business and the establishment of the standard of the operation rule, the technology of the rule execution analysis is combined, and the actual business situation is deeply fused, so that the electronic files of different businesses and different types can be developed in batch, the electronic processing of the files can be efficiently completed with high quality, and the utilization and sharing of the electronic files can be continuously promoted. The invention can greatly reduce the workload of manual development, save a large amount of development cost and test cost, unify and standardize management and greatly improve the development efficiency and the service application value of the electronic file.
Drawings
FIG. 1 is a schematic diagram illustrating a method for developing an electronic file according to an embodiment of the present invention.
Fig. 2 is a schematic flow chart of a predetermined procedure in this embodiment.
Fig. 3 is a schematic flow chart of the execution stage link according to this embodiment.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings and specific embodiments. The detailed description, while indicating exemplary embodiments of the invention, is given by way of illustration only, in which various details of embodiments of the invention are included to assist understanding. Accordingly, it will be appreciated by those skilled in the art that various changes and modifications may be made to the embodiments described herein without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.
The embodiment described herein is an exemplary case, and is used to describe a business electronic file development method according to the present invention.
As shown in fig. 1, a business electronic archive development method comprises a standard foundation, a predetermined link and an execution stage, wherein the standard foundation is a standard to be followed by the development method and comprises an electronic archive type standard, an electronic archive description file standard, an electronic archive content format rule, an electronic archive content reading rule and an electronic archive content conversion rule; the prefabricated fixed ring festival is based on a standard foundation, a description file which is general for the service is compiled according to specific requirements of the service, and an output is the description file; and the execution stage can produce the electronic archive file meeting the business requirements according to the description file, and the output is the electronic archive.
The standard basis of the embodiment comprises an electronic archive type standard, an electronic archive description file standard, an electronic archive content format rule, an electronic archive content reading rule and an electronic archive content conversion rule, and specifically comprises the following steps:
-electronic archive type criteria: and establishing a type consisting of preset 'keywords' based on the service characteristics, and configuring the type of the electronic file to be developed and generated. In this embodiment, the type of Excel table used as the electronic file is specified, i.e. the case will generate an Excel table electronic file as the final output.
-electronic archive description file standard: and based on the establishment of the business content, dividing and defining the corresponding content of the document materials of different types. In the present embodiment, the content to be developed and defined is divided into a document name, a title, a field name, a field source, a field format, a field reading rule, and a field content conversion rule. The content of the division is a description file standard which is common to the services.
-electronic archive content format rules: based on the establishment of the business content, the format requirements for displaying different types of electronic files are set, so that the development method can display the corresponding formats as required. In this embodiment, the content format rule includes content composed of preset keywords, including: numeric, text, date, custom.
-electronic archive content reading rules: based on the business content establishment, the mode and the way when the content to be generated is read aiming at different types of electronic archives are set. In this embodiment, the reading rule of the electronic file content is defined, the electronic file content is read from the database, the database table name is derived from the title attribute in the description file, the field name is derived from the field source attribute, and the query filtering rule is set as a paging query with 10 records per page.
-electronic archive content conversion rules: based on the establishment of business content, setting a conversion mode and a conversion path aiming at different types of electronic files when the data source format is inconsistent with the electronic file generation target format. In the embodiment, a data conversion rule is defined, and date field data in the data conversion rule is converted from database long integer type to date type data for display.
Based on the standard basis as the basis of the preset link, the method specifically comprises the following steps in the preset link as shown in the attached figure 2:
a1, a developer confirms the type and content of an electronic file to be developed according to requirements and prepares to compile a service general description file;
step A2, a developer writes a service general description file according to service requirements, in the step, a document name, a title, a field name, a field source, a field format, a field reading rule and a field content conversion rule are respectively defined according to the electronic file description file standard and in combination with the service requirements, and the contents required to be filled in by the development all need to accord with the standard rule of the method.
And A3, after the description file is written, the developer needs to be placed in a resource directory of the program for reading and using by the program in the execution stage.
As shown in fig. 3, in this embodiment, the flow of the execution phase link illustrates operations when the program generates an electronic archive according to the general service description file during normal operation, and for convenience of understanding, the link specifically includes the following steps:
and B1, correctly starting a program, wherein the program can correctly load the service general description file from the resource file directory.
And B2, operating on a program interface by a user, wherein for convenience of understanding, the operation of the user is assumed to be divided into 2 steps: selecting a data record for generating an Excel table of the electronic file; and step 2, clicking a button on the interface corresponding to the generated electronic document.
Step B3. the user operation in the step B2 converts the program into parameters, and the contents of the parameters include: an electronic archive description file ID to be generated and a data information ID list of the electronic archive to be generated;
step B4., the program receives the input request of user, analyzes the parameter in the request; acquiring an ID value of the description file from the analyzed result, then finding the position of the description file in the program resource directory through the ID value of the description file, and reading the content of the description file;
step B5., entering the electronic document generation process, according to the content of the description file, the program will read the operation rule in the content, in this step, the title of the electronic document and the content of the document name will be read and stored in the variable in the generation process;
step B6., according to the field information metadata analyzed from the description file, executing the field reading rule for querying the database in the description file, reading the required content data information from the database, and caching the content data information into the variable of the internal memory;
step B7., sequentially converting the content data read in the step B6 according to the field conversion rule analyzed from the description file, and caching the conversion result into the variable of the internal memory;
step B8., generating a corresponding format label for the content data converted in the step B7 according to the field format rule analyzed from the description file, and then executing the Excel table generation process;
step B9. calls a tool for generating an Excel table, the contents of the step B5, the step B6 and the step B7 are input, and the Excel table sequentially generates table title contents, table header contents and data contents of the table according to the contents and caches the table header contents, the table header contents and the data contents in internal variables;
and B10, establishing a binary stream, converting the generated Excel form data into the binary stream, writing the binary stream into an external file, and storing the electronic file of the Excel form into a local directory by a user after the user sees the program prompt.
In conclusion, the processing method of the embodiment effectively solves the problem of low development efficiency of the electronic file, saves the labor cost, fully utilizes the existing resources and reduces the repeated construction; the development multiplexing and sharing are convenient. Through the general description file of the business and the establishment of the standard of the operation rule, the technology of the rule execution analysis is combined, and the actual business situation is deeply fused, so that the electronic files of different businesses and different types can be developed in batch, the electronic processing of the files can be efficiently completed with high quality, and the utilization and sharing of the electronic files can be continuously promoted. The invention can greatly reduce the workload of manual development, save a large amount of development cost and test cost, unify and standardize management and greatly improve the development efficiency and the service application value of the electronic file.
The above-described embodiments are merely preferred embodiments of the present invention, which is not intended to limit the present invention in any way. Those skilled in the art can make many changes, modifications, and equivalents to the embodiments of the invention without departing from the scope of the invention as set forth in the claims below. Therefore, equivalent variations made according to the idea of the present invention should be covered within the protection scope of the present invention without departing from the contents of the technical solution of the present invention.
Claims (6)
1. An electronic archive development method based on a universal service description file is characterized in that: the method comprises the steps of carrying out rule making on an electronic file required by a service, such as the service of an Excel table, based on a pre-made general description file as an operation rule of a subsequent link, generating and outputting the general description file, then carrying out an execution stage, analyzing the operation rule of the description file, and finally completing the generation of the electronic file by combining data acquired from an external data source.
2. The method for developing an electronic archive based on a generic service description file according to claim 1, characterized in that: in the pre-established general description file, the service basic information metadata of the electronic file is compiled into a rule according to the standard, and different rule items can be established for different service requirements, so that the electronic file with different contents is adapted, and special development for the electronic file with different contents is not needed.
3. The method for developing an electronic archive based on a generic service description file according to claim 2, characterized in that: the development method comprises the following steps in the prefabrication of the fixed ring section:
a1, identifying the title of the electronic archive material and other general display areas, and compiling and formulating the title to be displayed and the contents of the general display areas of the electronic archive into a general description file;
a2, compiling and formulating field attributes, field formats, field reading rules and field conversion rules to be displayed aiming at dynamic content data to be displayed of the electronic material document, and storing the field attributes, the field formats, the field reading rules and the field conversion rules into a general description file;
and step A3, storing the preset general description file into a corresponding program resource file directory.
4. The method for developing an electronic archive based on a generic service description file according to claim 1, characterized in that: in the execution stage link, the development method can read the operation rule from the description file according to the universality of the description file, and generate different types of electronic files including but not limited to Excel files, Word files and the like by matching with data content information read from a database.
5. The method for developing an electronic archive based on a generic service description file according to claim 4, characterized in that: the execution phase link comprises the following steps:
step B1, an execution link firstly receives operation input of a user, the operation of the user on an interface is converted into a requested parameter, and the parameter content comprises: an electronic archive description file ID to be generated, and data information ID of the electronic archive to be generated;
b2, converting the user operation into parameters for analysis, firstly finding the position of the description file by using the ID of the description file during execution, and reading the content of the description file;
b3, reading the operation rule in the content according to the content of the description file, and analyzing title content information and field attribute metadata required for generating the content of the required electronic document according to different operation rules;
step B4., according to the field information metadata analyzed from the description file, executing the field reading rule for querying the database in the description file, reading the required content data information from the database, and caching the content data information in the internal memory for further processing;
step B5., according to the field conversion rule and the field format rule analyzed from the description file, processing the content data read in the step B4 into the field format meeting the rule requirement;
b6., because different electronic files have different generation tools, the electronic file generation tool is called according to the electronic file type requirement of the description file, the results of analysis, reading and processing in the steps B3 to B5 are transmitted to the electronic file generation tool, and finally the electronic file meeting the requirement of the description file is generated;
in step B6, the electronic file generation tool is a software development tool that is developed by using program codes and can generate electronic file files according to different electronic document file format specifications.
6. The method for developing an electronic archive based on a generic service description file according to claim 1, characterized in that: the standard basis of the universal description file comprises the following steps:
-electronic archive type criteria: establishing a type consisting of preset 'keywords' based on service characteristics for configuration;
-electronic archive description file standard: based on the establishment of business content, dividing and defining the corresponding content of different types of document materials;
-electronic archive content format rules: based on the establishment of business content, setting format requirements for displaying different types of electronic files, so that the development method can display corresponding formats as required;
-electronic archive content reading rules: setting a mode and a way when reading the content to be generated aiming at different types of electronic files based on the establishment of the business content;
-electronic archive content conversion rules: based on the establishment of business content, setting a conversion mode and a conversion path aiming at different types of electronic files when the data source format is inconsistent with the electronic file generation target format.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110005276.9A CN112559837A (en) | 2021-01-05 | 2021-01-05 | Business electronic file development method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110005276.9A CN112559837A (en) | 2021-01-05 | 2021-01-05 | Business electronic file development method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112559837A true CN112559837A (en) | 2021-03-26 |
Family
ID=75035175
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110005276.9A Withdrawn CN112559837A (en) | 2021-01-05 | 2021-01-05 | Business electronic file development method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112559837A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117875299A (en) * | 2024-03-13 | 2024-04-12 | 南京智握信息技术有限公司 | Electronic file integrated processing method and system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109658062A (en) * | 2018-12-13 | 2019-04-19 | 广州华资软件技术有限公司 | A kind of electronic record intelligent processing method based on deep learning |
| CN111666747A (en) * | 2020-05-29 | 2020-09-15 | 中国工程物理研究院计算机应用研究所 | Method for generating WORD document into description class data module conforming to S1000D standard |
| CN112114787A (en) * | 2020-09-27 | 2020-12-22 | 睿视(苏州)视频科技有限公司 | Report generation method and device and storage medium |
-
2021
- 2021-01-05 CN CN202110005276.9A patent/CN112559837A/en not_active Withdrawn
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109658062A (en) * | 2018-12-13 | 2019-04-19 | 广州华资软件技术有限公司 | A kind of electronic record intelligent processing method based on deep learning |
| CN111666747A (en) * | 2020-05-29 | 2020-09-15 | 中国工程物理研究院计算机应用研究所 | Method for generating WORD document into description class data module conforming to S1000D standard |
| CN112114787A (en) * | 2020-09-27 | 2020-12-22 | 睿视(苏州)视频科技有限公司 | Report generation method and device and storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117875299A (en) * | 2024-03-13 | 2024-04-12 | 南京智握信息技术有限公司 | Electronic file integrated processing method and system |
| CN117875299B (en) * | 2024-03-13 | 2024-05-24 | 南京智握信息技术有限公司 | Electronic file integrated processing method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108762743A (en) | Data table operation code generation method and device | |
| WO2020223997A1 (en) | Data analysis software architecture design method capable of implementing global configuration of storage, calculation and display | |
| CN106339363A (en) | PPT report making method and device | |
| CN112464632A (en) | Form style dynamic storage and conversion method under excel report | |
| CN110750553A (en) | Method for self-defining export of data in service management system | |
| CN115729938A (en) | Data rapid uploading engine implementation method based on DataX | |
| CN112559837A (en) | Business electronic file development method | |
| CN113254457B (en) | Account checking method, account checking system and computer readable storage medium | |
| CN1808428A (en) | Information searching criteria presentation and editing system and method | |
| CN112506488A (en) | Method for generating programming language class based on sql creating statement | |
| CN116956845A (en) | Method for rapidly configuring form field, page field generation mode and system | |
| CN116303359A (en) | Method for realizing multi-type document export of database structure | |
| CN108090034B (en) | Cluster-based uniform document code coding generation method and system | |
| CN111008011A (en) | System builder for power platform application development | |
| CN113239016B (en) | Database design assistance apparatus and method | |
| CN115114321A (en) | Dynamic query method and system | |
| CN112631567A (en) | Method and device for generating database operation file | |
| CN111310414B (en) | RDF format file analysis method and generation method | |
| US20230169088A1 (en) | Method and system for producing data visualizations via limited bandwidth communication channels | |
| Zhang et al. | A dynamic form rendering method for web multi-front framework | |
| CN113157726B (en) | Database processing method and device | |
| JP3050467B2 (en) | Data item dictionary generation method | |
| CN115952203B (en) | Data query method, device, system and storage medium | |
| CN113296763A (en) | Application capability management method and system | |
| CN114417448A (en) | Data standard model design system and method based on Internet of things |
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 | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20210326 |
|
| WW01 | Invention patent application withdrawn after publication |