CN1052316C - Computer managing and designing system and method thereof - Google Patents

Abstract

The invention relates to a computer management design system. The system of the invention includes a computer, an input device, an I/O interface, a text platform module, a tabulation platform module, a management system design module, a database management module, a report generation module, a database query module, Database operation module, display and tabulation peripherals.

Description

Computer Management Design System

The present invention relates to an object-oriented computer management design system, in particular to a management design system that enables ordinary managers who do not understand computer software knowledge to design a management system on a computer through the present invention. Adopt the present invention by compiling a set of quantitative data tables, and further explain the hierarchical relationship between the set of quantitative data tables corresponding to the management affairs of the target, data transmission relationship, statistical calculation relationship, cumulative inheritance relationship and execution process control, through the above With the support of the present invention, the designed set of quantitative data tables can realize the management function on the computer. The advantage is that the designer who implements this management system can successfully complete the system design as long as he understands management knowledge and does not need to understand computer software knowledge. Its advantage is that as long as a set of data tables is designed according to the above requirements, the management system on the computer can be realized without designing a computer program.

The computer management system is a complex and changeable system. It is an important topic of modern enterprise management modernization. Domestic and foreign scientific and technological workers and large companies have invested a lot of money and manpower. They have successively launched some computer management design systems, such as: Microsoft in the United States (Microsoft) company's "Foxpro2.0", the United States' "DataBase". These software can provide people with high-level languages to write special programs for the establishment and use of the management system. There are also some software such as "Quicken" from the American Intuit company, "Money" from the Microsoft company, and "Peachtree" from the United States are specially written for financial management. In short, these software tools must be programmed to obtain management functions. IBM "Lotus 123" such as "Excel" launched by Microsoft recently uses the intuitive method of electronic table calculation to realize the general management system. Still need considerable computer software knowledge such as "DataBase" knowledge.

Management system is a kind of popular work. It is quite difficult to require enterprise managers to understand the knowledge of computing software. In the era of information processing and network communication, that is, the era when computers enter enterprise management, it is very important to enable general enterprise managers who do not need to master computer software knowledge to use computers for management.

The purpose of the present invention is to solve this difficult problem and provide a computer management design system, so that an enterprise manager who is familiar with management business can use the present invention as long as he uses the management knowledge he has mastered, and use a computer to realize his brain. management methods.

A further purpose of the present invention is to quantify the management experience and become a shared resource for public communication, so as to promote communication, promote the modernization of enterprise management, and promote social progress. A set of quantitative data tables designed by the present invention is already a resource available for communication and sharing. A set of quantitative data tables is an accurate and quantified management experience, and the exchange of experience can be done by using a set of quantitative data tables prepared by the present invention to accurately reflect the intention of managers.

Another purpose of the present invention is to quantify national and industrial policy management, and a set of management policies can be accurately quantified into a set of quantitative data tables by using the present invention, thereby promoting standardized and scientific enterprise management.

Another purpose of the present invention is to truly and thoroughly promote the networking of information communication, because if there is no quantification of enterprises, there is no way to talk about any information, and the information communication network that costs a lot of money is useless. Quantification of management, that is, informatization, can truly and thoroughly realize the networking of information and communication.

A kind of computer management design system according to the present invention comprises:

Input device for inputting text, data and control commands;

computer means for controlling the processing and operation of the design system;

A display device for displaying the system design process and the system call process in real time;

A character system and font library for providing scripts and character systems for said design system

Additional text other than ;

The I/O interface device is used for the interface between the input device and the output device;

An external output device for outputting the system processing and query results;

Management system automatic design device, which includes:

The text platform module is used for the interface text display in the system and the generation of column text, data, and pictures in the table, as well as the generation of high-precision text in the printing process of the report with high-precision text quality output by the drive module;

The tabulation platform module is used for the generation of form lines in the system and the arrangement of the column text and data format of the form, and the automatic assembly of the data of the processing results into a form according to the form designed by the operator. It further includes the form design module, format Design module, automatic table loading module;

The management system design module is used to design a management system consisting of a set of quantitative data tables;

The report generation module is used to classify, sort, count, calculate and process the established management system according to user requirements to generate periodic report tables or analysis reports, or use statistical graphs such as histograms, pie charts, curve graphs, and line graphs Generate a report in a form, which further includes: a report generation sub-module and a statistical graph generation module;

The database management module is used for the formation of data files and the unified management of data files at different levels in the entire management system. It further includes a database establishment module, a database organization module, a database security processing module, and a password processing module;

The database query module is used for users to query relevant data from the built database;

The database operation module is used for users to perform operations such as moving out, moving in, merging, and cleaning the database;

The management system design module described therein further includes:

The relationship diagram design sub-module, which will be used to form a set of quantitative data tables for management objectives, and form a "relationship diagram" with specific levels and specific data transfer relationships;

Data transfer relationship design sub-module, it transfers data between a set of quantified data tables used to form management targets through the copy-in and copy-out transfer relationship of data items between the two tables in each relationship pair It can be implemented intuitively, and it further includes copy-in sub-modules, copy-out sub-modules, conditional copy-out sub-modules and classification selection copy-in sub-modules;

Statistical calculation design sub-module, used for statistics and calculation between objects, it is represented by statistical calculation expressions among the fields of a set of quantitative data tables that make up the management target;

Time and accumulative inheritance attribute design sub-module, which will be used to form a set of quantitative data tables of the management system, according to whether there is continuous data collection, continuous data processing, or the attributes of accumulating data materials by year/month The definition is given in the design, and the definition is given according to the succession relationship of the cumulative items in these tables. The succession relationship is divided into the succession relationship between the upper and lower pages or the succession between the upper and lower months packaged by month After the relationship is defined, when the system is invoked, the system will automatically carry forward the accumulation of the previous page or last month, and transfer to the next page or next month as the initial value to continue to accumulate;

The process control design module is used to form a set of quantitative data tables of the management system. The respective hierarchical relationships of these tables are specified through the relationship diagram design module. The hierarchical relationship refers to: A table can only be made on the basis of B , then the level of table A is higher than that of table B, and the quantitative number of the level is the higher the level, the smaller the quantitative number of the level, that is, level 1 is the highest; the level is divided into three stages from low to high, the first stage is the original data The input table has the lowest level, the middle table and summary table in the second stage of processing process, the level is in the middle, and the third stage is the application of results, that is, reports and statistical charts at all levels, and the level is the highest; this module defines from the original The table-making process of data table, intermediate data table, and data summary table, and record this attribute, the execution module automatically realizes the flow control of table making when the management system is used, on the other hand, defines the report sequence from report to summary table, and Record this attribute, and the execution module can automatically execute the process control of report generation when the management system is used.

Compared with the prior art, the present invention has the following advantages and effects:

The present invention provides a management system that uses computers to realize their own management intentions and management styles for factory directors, managers, state management cadres and individual operators who do not understand computer knowledge.

The management system compiled by the present invention is a set of quantified data tables, which has the characteristics of high efficiency and high intelligence that can be automatically executed after the original data is input, easy to grasp, easy to operate, and high in efficiency.

The management system prepared by the invention is convenient for modification, and the modification does not need to be edited, and no need to ask others for help, and the manager can modify it by himself, and has strong adaptability. No other technology has this feature, and the most difficult thing to use other technologies is to modify. Modifications require assistance from software personnel for system compilation.

The management system compiled by the invention can be used as a resource to provide communication and sharing, thereby promoting management progress.

Various management systems can be used and compiled by adopting the present invention. A grassroots enterprise only needs to adopt a set of system of the present invention to realize various managements, which is easy to master. Using other technologies, one technology can only achieve one kind of management, and enterprises must use multiple technologies at the same time to achieve multiple managements, and one technology is one kind of operation. It is simply unrealistic for enterprises to face multiple technologies and learn multiple operations.

Only one set of the present invention can be used to realize multiple management purposes, which greatly reduces the burden on the enterprise. To realize multiple management purposes by using general technology, it is necessary to spend multiple times to purchase different technologies, which causes great waste to the enterprise.

Adopting the present invention can enable the government and local government policy departments, industry management departments and enterprises to obtain the best communication. The policies and management methods of leading departments only need to give enterprises a set of management systems compiled using the present invention, and enterprises can accurately The management of various affairs in accordance with the policies and regulations of the leading department is conducive to standardization and standardization, which cannot be achieved by other technologies. The invention can be compatible with other management systems, as long as the interface method is established, the data of other management systems can be used in the invention.

Various purposes, effects and advantages of the system and method according to the present invention will be more clearly reflected from the following description in conjunction with the accompanying drawings.

Figure 1 General block diagram of the accompanying drawing system in the manual

Figure 2 General block diagram of 101 text platform

Figure 3 102 tabulation general block diagram

Figure 4 General block diagram of 103 management system design module

Figure 5 104 report generation module block diagram

Figure 6 105 database management module block diagram

Figure 7 106 block diagram of database query module

Figure 8 107 database operation module block diagram

Figure 9 105-01 database structure table

Figure 10 Block Diagram of 106-02 Database Classification Query Submodule

Figure 11 Block Diagram of 102-01 Drawing Table Sub-module

Figure 12 Block Diagram of 102-02 Measuring and Calculating Submodule

Figure 13 Block Diagram of 102-03 Meter Installing Sub-module

Figure 14 Block Diagram of 102-04 Fixed Format Sub-module

Figure 15 Block Diagram of 103-01 Relational Diagram Design Submodule

Figure 16 103-02 copy into the definition sub-module block diagram

Figure 17 Block diagram of 103-03 copy-in execution sub-module

Figure 18 Block diagram of 103-04 classification copy-in definition sub-module

Figure 19 Block diagram of 103-05 classified copy-in execution sub-module

Figure 20 103-06 copy out definition sub-module block diagram

Figure 211 03-07 copy out execution sub-module block diagram

Figure 221 03-08 condition copy definition sub-module block diagram

Figure 23 103-09 conditional copy execution sub-module block diagram

Figure 24 103-10 table calculation definition sub-module block diagram

Figure 25 103-11 table calculation execution sub-module block diagram

Figure 26 Process flow diagram of the management design system (left)

Figure 27 Process flow diagram of the management design system (right)

Figure 28 Management design system interface (1)

Figure 29 Management design system interface (2)

Figure 30 Management design system function bar

Figure 31 Structure diagram of management design system library

Fig. 1 is a schematic block diagram of a computer management system according to the present invention. Wherein the label 5 represents the input device (it can be a keyboard or other devices available for input), 6 is an I/O interface circuit board, 7 is an external device (it includes a printer, a laser printer or a laser phototypesetter), and 3 is a display , 4 is a character creation system and font library, 2 is a computer, 1 is a computer management system design device, and the label 1 further includes: 101 is a text platform module, 102 is a tabulation platform module, 103 is a management system design module, and 104 is a report generation Module, 105 is a database management module, 106 is a database query module, and 107 is a database operation module.

The working principle and operation process of the computer management design system shown in Figure 1 are as follows:

At first, under the control of computer 2, the designer inputs the list of data forms required by the management system planned to be designed from the input device 5, and the designer inputs the serial number of the form to be designed first through the input interface (as shown in Figure 28). (ID) or table name, then, under the support of 101 text platform modules and 102 tabulation platform modules, the designer, under the control of computer 2, 103 management system design modules, successively carry out the relationship of 103-01 as shown in Figure 4 Diagram design, a set of quantified data tables constituting the computer management system are classified according to levels, and data transfer relationship pairs with data copy-in and copy-out, or conditional copy-out and selective copy-in are established, forming a layered and related relationship. Relationship diagram; thus, the complex composition of the computer management system is layered, the intricate data relationship is completely simplified, and the data copy-in and copy-out relationship between the two tables in each relationship pair is simplified to achieve complex management. The dimensionality reduction effect of the system makes the multi-dimensional relationship become a one-dimensional linear relationship. Then, use the 102-01 table drawing submodule in the 102 tabulation platform module to draw the table, use the 102-02 table item measurement submodule to automatically calculate the table, use the 102-04 format to define the submodule definition format, and then use 103-02 to copy Enter definition sub-module definition copy-in line, or use 103-04 classification copy-in sub-module definition classification copy-in line, or use 103-06 copy out definition sub-module definition copy-in line, or use 103-08 conditional copy-out definition sub-module definition condition copy-in line , use the 103-10 table calculation definition submodule to define the calculation line, and use the 103-12 year/month attribute definition module and 103-14 cumulative inheritance attribute submodule to define attributes. The time and accumulative inheritance attribute design sub-module will be used to form a set of quantitative data tables of the management system. According to whether there is continuous data collection, continuous data processing, or the attributes of accumulating data materials by year/month, in the design Give the definition, and give the definition according to the succession relationship of the cumulative items in these tables. The succession relationship is divided into the succession relationship between the upper and lower pages or the succession relationship between the upper and lower months packaged by month. After the definition, when calling the system, the system will automatically execute the accumulative data from the previous page or last month, and transfer to the next page or next month as the initial value to continue accumulating; finally, the next form is automatically processed through 103-16 process control definition.

The hierarchical relationship of these tables is stipulated by the relationship diagram design sub-module. The hierarchical relationship mentioned here means: the A table can only be made on the basis of the B table, so the level of the A table is higher than the B table. The quantization number of the level is that the higher the level is, the smaller the quantization number of the level is, that is, level 1 is the highest level.

The present invention will be divided into three stages according to the level from low to high, the first stage is the original data input form, the level is the lowest, the intermediate table and summary table of the second stage processing process, the level is in the middle, the third stage is the application of the results, That is, reports and statistical charts at all levels, the highest level. Based on these hierarchical relationships, this module defines the table making process from the original data table to the intermediate data table data summary table, and records this property, or defines the report sequence from the report to the summary table, and records this property. A pair of relational tables are defined as above, until the end, that is, the design of a predetermined management system is completed.

A well-designed management system can be called in the device shown in Figure 1, and its operating principle and steps are as follows:

The operator enters the name of the management system project through the No. 5 input interface (that is, a file containing the names of all data tables of the management system mentioned above), and specifies the serial number (ID) or name of the table to be called first, and the system will pass Computer 2 visually displays the form you want to operate on display 3. First, before displaying the form, if the form has data or text copied from other forms during design, it will pass through computer 2 through 103- 03 Copy-in execution sub-module is automatically copied in; if the table has a design to be copied in from other tables by selection during design, it will also be automatically copied into the execution sub-module through computer 2 through 103-05 classification according to the original design conditions The module accurately reads in the data, and then the system will automatically point the cursor to the place where you want to input data through the computer 2, waiting for your input, and the operator can input data through the input device (keyboard) 5. After the input data is completed, the system The sub-module will be calculated and executed through the computer 2 through the 103-11 form, and the arithmetic statistics and function calculation of the data will be performed according to the originally designed calculation formula, and the calculation results will be accurately filled in the originally designed table items. The statistical calculation design sub-module simplifies the operation of multi-dimensional quantitative data in daily management affairs through the data transfer between every two tables with data transfer relationship pairs, so as to achieve in an intermediate table or an application The +, -, ×, /, and % operations between the items described in the table can be used to simplify the description of the row and column; the calculation between the table items in the quantitative data table has an automatic function; if the original design is from this The table is copied out to other tables or according to the conditional design, it will also copy out the execution sub-module through 103-07 or 103-09 conditional copy out of the execution sub-module through the computer 2, and automatically copy the items that meet the requirements and conditions of the design copy out to the original Designed table to go. If the table in the original design has accumulative inherited attributes, it will pass the defined accumulative inherited attributes through 103-15 through the control of computer 2 through the accumulative execution submodule. When the system is called, the system will automatically execute the previous page or last month The accumulative number of , go to the next page or next month as the initial value to continue accumulating. If the original design of the table has process control attributes, it will be controlled by the computer 2, and the next table will be automatically called out through the 103-17 process control execution sub-module, and the execution module will automatically realize the process control of making the table when the management system is used. Or the execution module can automatically execute the flow control of report generation when the management system is in use. And can do the whole process as mentioned above, complete the copy-in, input, calculation and copy-out of the next form, so that the next form can be automatically started again, and so on, until all the work is completed.

As mentioned above, the computer management design system implemented by the present invention has a highly intelligent effect, which makes it easy for the operator to operate, and a lot of work is automatically completed by the computer 2 .

The computer management design system realized by the present invention can modify the system easily, and its operation principle and steps are as follows:

Input the name of the management system (that is, a text file containing all table names) to be modified through the No. 5 input device and the interface, and input the serial number (ID) or table name of the table to be modified to the system. Then modify the copy-in line through the 103-02 copy-in definition sub-module and 103-04 classification copy-in definition sub-module, or modify the copy-out through the 103-06 copy-out definition sub-module and 103-08 conditional copy-out sub-module, or Modify the calculation formula through the 103-10 table calculation definition submodule, or through the 103-12 year/month attribute submodule, 103-14 cumulative inheritance attribute definition submodule, and 103-16 process control definition submodule, respectively for the year/month Modify the monthly attribute, cumulative inheritance attribute, and process control, or modify the table through the 102-01 drawing table sub-module, re-calculate the modified table through the 102-02 table item measurement sub-module, and modify it through the 102-04 format definition sub-module Format, by modifying the original system through the above-mentioned possible modification procedures, a brand-new and improved management system is produced. The knowledge used by the operator is only the management knowledge he is familiar with, and it is not necessary to master computer software knowledge. This is exactly the purpose of the present invention. A particularly meaningful feature.

The computer management system that adopts the present invention to realize can also generate report form and the statistical diagram of intuitive image easily, and its operating principle and steps are as follows:

As shown in Figure 1, by calling the 102-03 automatic table loading submodule shown in Figure 13 in the 104 report generation module and 104-01 shown in Figure 5, the result data can be automatically loaded into a table according to the required form to generate a report. And according to the needs, the two-dimensional data of the report can be generated through the sub-module 104-02 histogram, the sub-module 102-03 pie chart, the sub-module 102-04 graph, and the sub-module 102-05 line graph to generate the required histogram respectively Statistical graphs such as graphs, pie charts, curve graphs, or line graphs.

Then these reports or statistical charts are output high-quality reports and statistical charts through the computer 2, the I/O interface and the driver module, and through the external device 7 (printer or laser printer, laser phototypesetting machine).

The computer management system realized by the present invention can also conveniently call and establish a database to realize management, query and other operations on the database. Its operating principle and steps are as follows:

As mentioned above, calling the management system designed by this management design system will automatically create a database, as shown in Figure 1, through the 105 database management module, and the 105-01 database structure sub-module shown in Figure 6, 105-02 database access The sub-module, 105-03 database sorting sub-module realizes a database structure that is convenient for management and access.

Through the 106 data query module and as shown in Figure 7 through the processing of the 106-01 general query module, you can easily query the data files of the established database, and you can also pass through the 16-02 classification query submodule and the following as shown in Figure 10 The step is to realize the classification retrieval query. First, the classification query table module is made through 106-02-01, and the classification query table is made by the operator according to the classification retrieval requirements, or the query table is added to the system relationship diagram through the 106-02-02 step. Then use the same method of modifying the system as mentioned above, and perform the steps shown in 106-02-03 to define the copy-in, copy-out, conditional copy-out, classification copy-in, calculation, and year between the classification table and the relationship table. Various definitions such as /month time attribute, cumulative inheritance attribute, process control, etc., and then execute the step 106-02-04 to generate the classification retrieval table as mentioned above in the same way as the calling system and report generation method, and then 106-02 - Classified query results as described in -05.

The established database can be used as the 107-01 database shifting submodule as shown in Figure 8 through the 107 database operation module, and the database can be moved from one computer to another computer through the external memory or online mode, or can be moved through the 107-01 database operation module. 02 Copy library sub-module copy backup in external memory, or copy to another computer through online mode.

Figure 2 shows that the 101 Chinese platform module belongs to the 01 picture processing sub-module, the 02 font changing sub-module, the 03 font size changing sub-module, the 04 character deformation sub-module, the 05 character rotation sub-module, the 06 character moving sub-module, and the 07 character sub-module Copy block and 08 drawing sub-module, many of the above sub-modules provide rich word processing and editing functions for the system.

The 102 tabulation platform module shown in Figure 3 further includes the 01 table drawing submodule, the 02 table item measurement submodule, the 03 automatic table loading submodule, and the 04 format definition submodule. Its operation steps are as follows, usually using the 01 table drawing submodule The module draws tables, which can draw arbitrarily complex line tables, and then automatically measure and calculate through the 02 table item measurement sub-module, so that the computer can memorize the row and column numbers of each item in an arbitrarily complex table, as well as the width and height of each item. In order to enter text and data, define the format of the data or text to be written in the table item through 04, so as to achieve the purpose of simplifying the operation and format specification during use, or automatically pass 102-03 to a group of data according to the format Load the form.

Figure 4 shows the 103 management system design module, which further includes 01 relationship diagram design sub-module, 02 copy-in definition sub-module, 03 copy-in execution sub-module, 04 classification copy-in definition sub-module, 05 classification copy-in execution sub-module , 06 Copy out definition submodule, 07 Copy out execution submodule, 08 Conditional copy out submodule, 09 Conditional copy out execution submodule, 10 Table calculation definition submodule, 11 Table calculation execution submodule, 12 Year/month attribute definition submodule, 13 Year/month attribute execution sub-module, 14 accumulative inheritance attribute definition sub-module, 15 cumulative inheritance attribute execution sub-module, 16 process control attribute definition sub-module, 17 process control execution sub-module. Its basic operating principle is as follows:

The operator uses the 01 relationship diagram design sub-module to generate a relationship diagram for all the tables contained in the management system to be designed, and defines the hierarchical relationship of each table, and defines whether there is a data transfer relationship between each two tables. Then it defines whether the table is classified, and whether it is paginated. Through the design of this sub-module, the basic pattern and model of the management system are basically established. 02, 04, 06, 08, 10, 12, 14, and 16 respectively classify the copy-in data between each table design and relational table Copy-in data, or copy-out data, or conditionally copy-out data, table calculation, year/month attributes, cumulative inheritance, process control, etc., through the above definitions, specifically and clearly express the designer's management requirements and rules for the management system, Therefore, it can be said that this module is the core part of the management design system. Through the definition of the above sub-modules, the design of the management system is completed; At the same time, it explains and executes functions and attributes such as pre-designed data copy-in, data selection and classification copy-in, data copy-out or data conditional copy-out, table calculation, year/month attribute, cumulative inheritance, process control, etc., to achieve highly intelligent data Automatic processing of information, so as to win efficient, accurate and convenient use effects.

Figure 5 shows the 104 report generation module, which further includes 01 report generation, 02 histogram sub-module, 03 pie chart sub-module, 04 graph sub-module, and 05 line graph sub-module. Their operating principles and steps are as follows: After the user establishes the database by calling the management system, he can use 01 to further call the above-mentioned (as shown in Figure 13) 102-03 report to automatically load the submodule to generate a report as required, or Call 02, or 03, or 04, or 05 as needed to generate histograms, pie charts, curve charts, line charts and other intuitive statistical charts.

Shown in Fig. 6 is 105 database management modules, which further includes 01 database structure submodule, 02 database access submodule, 03 database sorting submodule. Its working principle is as follows. After the user calls the management system to build the database, he generally needs to use the database. Therefore, a reasonable and easy-to-access structure must be generated through the 01 database structure sub-module, and the database can be accessed through the 02 database access sub-module. Through the 03 database sorting sub-module, the database is structured, checked and repaired to ensure data security.

Shown in Fig. 7 is 106 database query submodules, which further includes 01 general query submodules and 02 classification query submodules. Its working principle and operation steps are: the general query directly queries the data through the structure of the database itself, and the other is to perform classified query through the 2-category query sub-module (see Figure 10 for details).

What Fig. 8 shows is 107 database operation modules, and it further comprises 01 moving database submodule, and 02 duplicating database submodule, its function is to move database from one computer to another computer, or move to external memory, It can also be copied to another computer or to external storage.

Figure 9 shows the data structure of the database. The database mainly includes several data types such as text, numbers, and pictures. It also includes item data separators, table names, and accumulated inheritance data, which are convenient for storing and loading tables ( See Fig. 9 for details); adopting this structure is convenient for storage, and it is also convenient for data processing, and is more suitable for automatic table loading.

Figure 10 shows the 16-02 classification query sub-module. Its operation steps are: first execute 01 to create a classification query table, then execute 02 to add the query table as a report to the system relationship diagram, and 03 to define the relationship between the table and the relevant The data transfer relationship and calculation relationship between the tables of the relationship, etc., and then call the query table in the same way as a report, and the required results can be obtained. This method does not require programming and is suitable for general managers.

Figure 11 shows the 102-01 table drawing sub-module. Its operation steps are 01 to determine the line width of the table frame, then 02 to define the width and number of horizontal/vertical lines, 03 to automatically make a table by the computer, and 04 to judge whether there is Change lines or add or delete lines, if there are no lines, complete the tabulation, if there are lines, you can add, delete, and move lines, and you can set the width of the table frame to 0, and then use steps 01, 02, and 03 to draw the table twice, like this Very complex tables can be drawn multiple times.

Figure 12 shows the 102-02 table item measurement sub-module. Its operating principle and steps are to scan from left to right from 01 from the upper left corner within a table frame until it encounters a 02 line, and make a 03 record table Item width, 04 and then scan from top to bottom, 05 until it meets a line, 06 records the height of the item, and records the row and column numbers of item i, j, advance to the right line of the item, and continue scanning cycle, 07 until it exceeds the line Frame width; 08 returns to the left end of the table frame, pushes down from the first item to continue scanning the second row of table items, and so on, and 09 until it exceeds the height of the table frame, all scanning is completed. This method can accurately convert any complex table Automatically calculate the table item row and column number and the size of the table item, which is conducive to table text filling and data loading.

Figure 13 shows the 102-03 automatic table loading sub-module, the operation steps: 01 open the table data file, 02 take out the characters, judge whether 03 item number, 04 number, 05 text/picture, 06 whether it is over, if it is over, save If it is not finished, if it is 03 item number, enter the item number and wait for the data to be loaded. If it is 04 numbers, spell the number and load the item. If it is 05 text/picture, also load the item, and finish Each of the above types advances the pointer, and then goes to 02 to fetch the character cycle until all the data is loaded into the table.

Figure 14 shows the 102-04 fixed format submodule, and its execution steps are if it is a text field of 01, define it according to the text field pull-down box, if it is a number of 03, set the data format, and set the integer and decimal places. If it is a picture, set the picture to the project, after setting, save it in the form.

Figure 15 shows that 103-01 is the relationship diagram design sub-module, and its execution steps are: 01 open the table name file, 02 put the table names one by one in the work area corresponding to the layout table name box, if use 03 mouse to move the left key, it can be pulled to another table frame related to it, which defines the data transfer relationship between the pair of tables. If the line is pulled again, the displayed line disappears, and the original registered relationship is also cancelled. If you hold down the Ctrl key with 11, you can move the pointed table frame by holding down the left button with the mouse. If you use 13 to hold down the ALT key, use the defined color to represent the level at this time, and then click the table frame with the left mouse button, the table frame will be colored with the color representing the level, and the level will be defined in the table at the same time. If you click twice on the table list, you can enter the category and page number.

Figure 16 shows the 103-02 copy-in definition sub-module. Its operation steps are firstly 01, the user defines the source table name of the copy-in data, and records it in the copy-in line, and then 02, the user directly points to the table to be copied in Table item position, 03 automatically finds the table item (row, column) number according to the table item array, 04 enters the copy-in line, 05 judges whether it is finished (end is specified by the operator), if it is not finished, continue to 02, 03, 04. In this way, the definition of the copy-in line can be completed.

Figure 17 shows the 103-03 copy-in execution sub-module. Its operation steps are used when the user calls the management system. First, the system takes out the copy-in source table name from the copy-in line at 01, opens the file at 02, and fetches the data at 03. , then 04 takes a copy-in item (row, column) number from the copy-in row, and then does 05, sends the data into the table item of the (row, column) number, 06 advances the file pointer and fetches the copy-in line (row , column) number pointer, 07 if the copy-in item (row, column) number has not been taken out, then do 03, 04, 05, 06 until the copy-in item is taken out, then do 08 to close the file, and the copy-in is completed execution work.

Figure 18 shows the 103-04 category copy-in definition sub-module, its operation steps are: 01 is specified by the user to copy into the source table, the system finds the file name of the table, records are entered into the category and copy-in row, and then 02 is assigned by the user Facing the designation of table items that can be copied in, the system automatically finds out the (row, column) number and enters it into the line to be copied in. 03 judges whether the user’s designation is completed. If it is not finished, continue to step 02 until the end, that is, You can complete the definition of the classification copy-in line.

Figure 19 shows the 103-05 classification copy-in execution sub-module, which is automatically executed by the system when the user invokes the designed management system. The execution steps are as follows: first, the system performs 01 to take out the copy-in source file name , and open the file, and then do 02 to get a number from the file, the number is the sub-subject serial number, record it into the sub-subject number, and 03 take the sub-subject number as the serial number to take out the corresponding copy in the classification copy-in line Enter the table item (row, column) number, then make 04, get the number from the file and send it into the table item represented by the (row, column), close the data file, and at this time, the classification and copy-in execution sub-module operation ends.

Figure 20 shows the 103-06 copy-out definition sub-module, and its operation steps are as follows: firstly do 01, the user specifies the copy-out destination table when designing the system, the system automatically finds the file name, and records it in the copy-out line Go in, then do 02, let the user visually designate the table item to be copied out by facing the form, and then the system automatically finds the number of the table item <row, column> in 03, records from 04 to the copied row, and does 02, 03 all the time , Step 04 until the end of step 06 specified by the user.

What Fig. 21 shows is 103-07 read out execution sub-module, and it is automatically executed by the system when the user invokes the designed management system. The execution steps are as follows: first, the system performs 01, takes out and copies the target file name, and then uses 02 to judge whether there is a continuous attribute, if yes, execute 03, open the file, and place the pointer to the end of the file, if there is no continuous attribute, then execute 04 , open the file, set the pointer to the file header, and then the system performs 05 to read the entry <row, column> number in the row, and then the system executes 06 to obtain the number in the entry according to the <row, column> number , make 07 by the system, write the retrieved number into the file, 08 advance the pointer of the item number of the copied row, 09 advance the pointer of the file, and execute 10 by the system, judge whether the table item number of the copied row has been fetched or not, and then execute 05, 06, 07, 08, 09, until after finishing, do 11 to close the file, then copy out and execute.

Figure 22 shows the 103-08 conditional copy-out definition sub-module, firstly do 01, the user specifies to copy out the destination table, the system automatically finds the corresponding file name, and writes the conditional copy-out line; then do 02, by user Specify the table item to be used as the judgment condition, and the system will automatically generate the <row, column> number of the judgment table item, and then do 03, and write the judgment item <row, column> number into the conditional copy line; next step, do 04 , the user faces the condition or interface, specifies the conditional expression (including <, >, ≥, ≤, ≠, and, or and other conditional operators), and records it in the condition copy line; the following is 06, and the user faces the form Specify the table item to be copied in if the condition is met, and the system will generate the <line, column> number, write the conditional copying line, and define it until 06 is specified by the user, and the conditional copying definition operation and processing are completed.

What Fig. 23 shows is 103-09 conditional copying execution sub-module, which is automatically executed by the system when the user invokes the designed management system. The execution steps are as follows: firstly, the system performs 01, takes out and copies the target file name, and then uses 02 to judge whether there is a continuous attribute, and if so, executes 03, opens the file, and sets the pointer to the end of the file; if there is no continuous attribute, executes 04, and opens File, set the pointer to the file head, and then the system will make 05, take out the conditional expression, make 06, take out the <row, column> number of the discriminant item, and make 07, get the number according to the <row, column> number, and then make 08 , the system will automatically make a conditional judgment on the obtained value and the conditional expression, if the condition is not met, then execute 09, close the file, do not execute the copying out of the current table, and end the export; if the condition is met, the system will execute 10, press the order Copy out the <row, column> number specified in the line, execute data copying, and write to the file until the specified copying item number is finished (12), and finally 13, close the file and end.

Figure 24 shows the 103-10 table calculation definition submodule, and its operation steps are as follows: 01, firstly, after the user selects the table calculation definition operation from the interface, the calculator tool bar is displayed; 02, the user faces the current table, Point to the table item with the mouse, and the system will automatically generate the <row, column> number as a variable, and use the numbers on the calculator, +, -, ×, /, % and other operators to form a calculation formula, 03, put this Write the calculation formula into the calculation line, and do it until it is finished. If there is a loop, do 04, use [] and <row>, <column> to specify the loop body and the number of loops respectively, and use <row> or <column> to specify the loop by row , or loop by column, and record the expression specified above into the calculation row, and the definition of the table calculation is completed.

Figure 25 shows the 103-11 table calculation execution sub-module, which is automatically executed by the system when the user invokes the designed management system. Its execution step 01, firstly, the system scans the calculation line, encounters %, +, -, ×, / operators shown in 13, 14, 15, 16, 17 and enters the operation stack, and encounters 02"[", then Do 03, continue to scan and spell the number of rows or columns, and record it in the unit of the number of cycles. When encountering 04 "]", then do 05 again, use the operation stack to calculate the cycle body once, and reduce the number of cycles by 1. If it is not 0, then do 05 again. Do 05 until the end of the 06 judgment cycle, and then continue to scan, when encountering 07 "(", until encountering 09 ")", all the calculation formulas are recorded in the priority calculation stack, that is, they must be calculated first, and the calculated results are sent to the calculation Stack, if encounter 19<carriage return>, and there is no cycle, then operate the stack once, if encounter 11 "<", then continue to scan the <line, column> number of the reading and spelling item until encountering ">", And write it into the stack, encounter the number until the end of the number string, and send the number to the operation stack. According to the operation rules of the operation stack, its <row, column> number indicates that the system will automatically fetch data from the entry of the <row, column>. If the <row, column> number indicates the result unit in the stack, the operation will be The result is automatically sent to the table item specified by the <row, column> by the system, and the pre-designed table item calculation can be completed in this operation step, and various complex automatic calculations between table items are realized, reaching a high level. Smart effects.

Figure 26 and Figure 27 are stitched together to form a complete figure, which shows the process flow of the management design system. The entire process of this figure has been described many times before, and will not be repeated here.

What Fig. 28 shows is the design interface (1) of the management design system by the embodiment of the present invention, which includes table copy-in, copy-out, calculation definition operation interface and input interface.

Fig. 29 shows the relationship design interface and attribute design interface of the management design system according to the embodiment of the present invention.

Figure 30 shows the interface operation function bar of the management design system of the embodiment of the present invention.

Figure 31 is a block diagram of the database structure of an embodiment of the present invention.

Figures 26, 27, 28, 29, 30, and 31 are for reference when referring to the instructions.

Claims (8)

1, a kind of computer managing and designing system comprises:

Input media is used for input characters, data and control command;

Computer installation is used to control processing, the operation operation of described design system;

Display device is used for real-time display system design process and system call process;

Coinage system and character library are used to described design system that literal and coinage system are provided

In addition newly add literal;

The I/O interface arrangement is used for the interface of input media and output unit;

Output peripheral equipment is used for described system handles and Query Result output;

It is characterized in that also comprising:

The management system automatic design device, it comprises:

The literal console module be used for that system median surface literal shows and the generation of the column literal of form, data, picture, and output is by the generation of the high precision literal in the printing technology of the form of the high precision text quality of driver module execution;

The tabulation console module, be used for the column literal and the data layout arrangement of system's Form Frame Line generation and form, and the data of result are realized being assembled into table automatically according to the tabular form of operator's design, it further comprises form design module, format design module, dress table module automatically;

The management system design module is used to design the management system that is made of a cover quantized data form;

The report generation module, be used for the management system of having set up is made classification, ordering, statistics, computing generation cycle account or analysis report or generated report with statistical graph forms such as histogram, pie chart, curve map, broken line graphs by user's requirement, it further comprises: report generation submodule and statistical graph generation module;

Database management module is used for the unified management of the data file of the formation of data file and whole management system different levels, and it comprises that further database sets up module, database grooming module, database security processing module, Cipher Processing module;

Database query module is used for the database inquiry relevant data data of user from building up;

The database manipulation module is used for the user database is shifted out, moves into operations such as merging, cleaning;

Wherein said management system design module further comprises:

Graph of a relation design submodule, it will be used to constitute a cover quantized data form of management objectives, constitute one and have " graph of a relation " that specific level and specific data transfer concern mutually;

Data transfer relation design submodule, it by the data item between two forms that each concerned centering copy into the transitive relation that is ferreted out, the data transfer that will be used to constitute between the cover quantized data form of management objectives realized intuitively, it further comprise copy into submodule, be ferreted out submodule, condition is ferreted out submodule and categorizing selection is copied into submodule;

Statistical computation design submodule is used for statistics and calculating between the object things, and it is represented by statistical computation expression formula between the field of a cover quantized data form of forming management objectives;

Time and accumulative total inherited attribute design submodule, it will be used for a cover quantized data form of configuration management system, have or not the continuous acquisition data according to it, continuous deal with data, or per year/attribute of month segmentation accumulation data data, in design, provide definition, and the continuous relationship according to accumulation in these forms provides definition, continuous relationship is divided into again, continuous relationship between the following paging or with the moon be partition packetization on, continuous relationship between next month, after providing definition, when calling system, system can automatically perform the accumulative total of brought forward or last month, forwards to nextpage or next month to continue accumulative total as initial value;

Flow process controlling Design module, a cover quantized data form that is used for configuration management system, stipulated the hierarchical relationship separately of these forms by the graph of a relation design module, described hierarchical relationship is meant: the A table will be by just making on B table basis, the level of A table is higher than the B table so, level quantizes numeral, and to be that level heals level quantification numeral high littler, and just 1 grade of level is for the highest; Level is divided into three phases from low to high, and the phase one is a raw data input table, and level is minimum, the middle table of subordinate phase processing procedure and summary sheet, and level is placed in the middle, and the phase III is result's application, forms promptly at different levels and statistical graph, level is the highest; This module is according to these hierarchical relationships, definition is from the table process of doing of raw data table, intermediate data table, data summary table, and write down this attribute, when using, management system realizes doing the flow process control of table automatically by execution module, define the form order from the form to the summary sheet on the other hand, and write down this attribute, when management system is used, can automatically perform the flow process control of report generation by execution module.

2, computer managing and designing system as claimed in claim 1 is characterized in that described literal console module comprises that further literal demonstration, Font Change, font size change, font is out of shape, submodule is rotated, tilted, moves, duplicates, deletes to font;

By these processing sub, make in the interface operation, output function of design system about the demonstration of literal, data, by form dress table, meet with a response by operations such as form outputs.

3, computer managing and designing system as claimed in claim 1, the console module that it is characterized in that wherein tabulating comprises that further Form Frame Line is operated submodule, list item is calculated submodule, list item composing submodule, automatic dress table submodule automatically, operation and processing by these submodules reach the Form Frame Line design operation, and calculate submodule automatically by list item, the form composition dataization that draw arbitrarily at the interface that makes the user pass through computer input unit; List item composing submodule calculates composing with literal or the data that will arrange in the list item in the good list item grid of measuring and calculating, dress table submodule is according to the form of list item results of measuring data of description, by calculating composing item by item with automatic dress table automatically.

4, computer managing and designing system as claimed in claim 1, it is characterized in that the cover quantized data form that described graph of a relation design submodule is used for constituting computer management system has data between any two and copies into being ferreted out by hierarchical classification, foundation, or condition be ferreted out and select to copy into the data transfer relation right, constituted one and had levels, related graph of a relation.

5, computer managing and designing system as claimed in claim 1, it is characterized in that described data transfer relation design submodule will be used to constitute set up between two right tables of each relation of a cover quantized data table of computer management system data be ferreted out and copy into transitive relation, to simplify the statistical computation of the complexity between the multidimensional data.

6, the described computer managing and designing system of claim 1, it is characterized in that described statistical computation design submodule will be used to constitute the simplification of a cover quantized data form of computer management system by level simplification and data transfer relation, statistical computation between the multidimensional form is carried out in a form, and as long as it is the statistical computation between the data item in the same form of design.

7, the described computer managing and designing system of claim 1 is characterized in that the cover quantized data form that described time and accumulative total inherited attribute design submodule will be used to constitute computer management system is divided into continuous input data and periodic segment input data.

8, the described computer managing and designing system of claim 1, it is characterized in that described periodic segment input data for per year/the input data of month segmentation.

Images