CN1052316C - Computer managing and designing system and method thereof - Google Patents
Computer managing and designing system and method thereof Download PDFInfo
- Publication number
- CN1052316C CN1052316C CN95116973A CN95116973A CN1052316C CN 1052316 C CN1052316 C CN 1052316C CN 95116973 A CN95116973 A CN 95116973A CN 95116973 A CN95116973 A CN 95116973A CN 1052316 C CN1052316 C CN 1052316C
- Authority
- CN
- China
- Prior art keywords
- data
- module
- submodule
- design
- management system
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Lifetime
Links
Images
Abstract
The present invention relates to a computer management design system and a method thereof. The system of the present invention comprises a computer, an input device, an I/O interface, a character platform module, a tabulation platform module, a management system design module, a database management module, a report generation module, a database search module, a database operation module, a display and a peripheral tabulation device. If only a set of quantized data forms are designed for a prearranged managed object, an operator inputs the initial data in the system which runs automatically to carry out classification and calculation, and finally, results of report forms, analysis reports, etc. required by the operator are obtained. A management purpose is reached.
Description
The present invention relates to a kind of object oriented calculation machine managing and designing system, relate in particular to a kind of make be ignorant of a kind of managing and designing system of common management person by the present invention design management system on computers of computing machine software knowledge.Adopt the present invention by establishment one cover quantized data form, and further specify hierarchical relationship between this corresponding cover quantized data form of management transaction with target, data transfer relation, statistical computation relation, accumulative total inheritance and implementation control, this cover quantized data form by above design just can be implemented in the management function on the computing machine under support of the present invention.As long as its advantage is to realize that this Design of Management System person understands managerial knowledge and needn't understand computer software knowledge, can finish system design smoothly.It is also advantageous in that as long as design a sets of data form by above-mentioned requirements, needn't designing computer programs, just can be implemented in the management system on the computing machine.
Computer management system is a system complicated and changeable, it is the modern important topic of modern business administration, scientific worker and major company have all dropped into substantial contribution and manpower both at home and abroad, some computer managing and designing systems had been released once, for example: " Foxpro2.0 " of Microsoft (Microsoft) company, " DataBase " of the U.S..These softwares can provide people with higher level lanquage come for the foundation of management system with use the write specialized program, also " Quicken " of some software such as American I ntuit company, " Money " of Microsoft company, " Peachtree " of the U.S. is the management system of writing for financial management specially, these Software tools all will pass through coding in a word, could obtain management function.Recently as the IBM " Lotus123 " of " Excel " of Microsoft release, the direct-vision method that adopts electronic watch to calculate realizes the general management system, but be to use this instrument can only handle general simple management system, complicated management system can not be handled, and still needs suitable computer software knowledge as the knowledge of " DataBase " etc.
Management system is a kind of work of universalness, require enterprise administrator all will understand quite difficulty of software for calculation knowledge, yet, it is imperative again that a large amount of employing computing machines carry out Modern Enterprise Administration, 20 end of the centurys and 21 century, the brainstrust prophesy is the epoch of computer information processing, network communication, and how importantly just computing machine enters the age of business administration, can make the general company manager that needn't grasp computer software knowledge can utilize computing machine to manage and seem.
Purpose of the present invention is to solve this difficult problem just, a kind of computer managing and designing system is provided, make a company manager who is familiar with management service,, realize management method in his brains with computing machine as long as the managerial knowledge of using him to grasp just enough can be used the present invention.
Further purpose of the present invention is to make the managerial experience quantification, becomes the shared resource of public exchange, promotes exchange with this, promotes business management modernization, promotes social progress.Using a cover quantized data form of the present invention's design is a kind of for exchanging and resources shared already.One cover quantized data form is exactly managerial experience that accurately, quantized, the interchange of experience just can adopt a cover that the present invention works out accurately the quantized data form that is intended to of reflection supvr exchange.
Another object of the present invention is to allow country and industry policy management quantification, a cover management policy can adopt the present invention to be quantified as a cover quantized data form exactly, thereby promotes Standardize Enterprise Management, scientific.
Another object of the present invention is the real information communication networkization that thoroughly promotes, because if there is not the quantification of enterprise, just have no way of having spoken of any information, so costly information communication network is also just lack scope for their abilities, have only the management of social grass-roots unit, enterprise to realize quantification, just information-based, could really realize information communication networkization completely.
A kind of computer managing and designing system according to the present invention 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;
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, after the continuous relationship definition between next month, 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.
Be compared with the prior art, the present invention has following advantage and effect:
The present invention be ignorant of factory director, manager, national management cadre, the sole proprietor of computer literacy, a kind of management system that adopts computer realization oneself management intention and style of management is provided.
The management system that adopts the present invention's establishment is exactly the data form that a cover has quantized, and it has the high-level efficiency that just can automatically perform, the characteristics of high intelligence after the raw data input, grasp easily, operates the efficient height easily.
Adopt the management system of the present invention's establishment, be convenient to revise, change needn't be programme, and needn't seek help other people, can be started to revise by supvr oneself, has very strong adaptability.This point other technologies all do not have these characteristics, and what the use other technologies were the most difficult is to revise.Modification will be sought help from the peopleware of system's establishment.
Adopt the management system of the present invention's establishment to can be used as resource, provide to exchange,, can promote management progressive with this with shared.
Adopt the present invention can use and work out various management systems.An enterprise of basic unit only need adopt the present invention's one cover system, just can realize multiple management, is easy to grasp.Adopt other technologies, a kind of technology can only realize a kind of management, and enterprise will use multiple technologies simultaneously, could realize multiple management, and a kind of technology is exactly a kind of operation.Multiple operation will be learnt in the face of multiple technologies by enterprise, and this is unpractical at all thing.
Adopt the present invention only to need to realize multiple management purposes, alleviated business burden greatly, adopt general technology, realize multiple management purposes, repeatedly spend and buy different technology, cause significant wastage to enterprise once overlapping.
Adopt the present invention can make government and each policy section industry administrative authority of local government and enterprise obtain best communication, the policy of leading department and management method are assigned only needs to give enterprise's one cover to use the management system of the present invention's establishment, enterprise just can carry out the management of every affairs exactly according to the policies and regulations of leading department, help standardization, standardization, other technologies can't reach this point.Adopt the present invention can with other management system compatibilities, just can use other Management System Data in the present invention as long as formulated interface method.
The various purposes of system and a method according to the invention, effect, advantage will be from more clearly embodying below in conjunction with description of drawings.
Fig. 1 Figure of description system general diagram
Fig. 2 101 literal platform general diagrams
Fig. 3 102 tabulation general diagrams
Fig. 4 103 management system design module general diagrams
Fig. 5 104 report generation module frame charts
Fig. 6 105 database management module block diagrams
Fig. 7 106 database query module block diagrams
Fig. 8 107 database manipulation module frame charts
Fig. 9 105-01 database structure table
Figure 10 106-02 database classified inquiry submodule block diagram
Figure 11 102-01 draws table submodule block diagram
Figure 12 102-02 list item measuring and calculating submodule block diagram
Figure 13 102-03 dress table submodule block diagram
Figure 14 102-04 formula module frame chart that fixes
Figure 15 103-01 graph of a relation design submodule block diagram
Figure 16 103-02 copies into definition submodule block diagram
Figure 17 103-03 copies into the implementation sub-module block diagram
Figure 18 103-04 classification is copied into definition submodule block diagram
Figure 19 103-05 classification is copied into the implementation sub-module block diagram
Figure 20 103-06 is ferreted out definition submodule block diagram
Figure 21 1 03-07 is ferreted out the implementation sub-module block diagram
Figure 22 1 03-08 condition is ferreted out definition submodule block diagram
Figure 23 103-09 condition is ferreted out the implementation sub-module block diagram
Figure 24 103-10 table calculates definition submodule block diagram
Figure 25 103-11 table calculates the implementation sub-module block diagram
Figure 26 managing and designing system process flow diagram (left side)
Figure 27 managing and designing system process flow diagram (right side)
Figure 28 managing and designing system interface (one)
Figure 29 managing and designing system interface (two)
Figure 30 managing and designing system function bar
Figure 31 managing and designing system library structure block diagram
Figure 1 shows that schematic block diagram according to computer management system of the present invention.Label 5 expression input medias (it can be keyboard or other can for the device of input) wherein, the 6th, the I/O interface card, the 7th, (it comprises printer to external unit, laser printer or laser photocomposing machine), the 3rd, display, the 4th, coinage system and character library, the 2nd, computing machine, the 1st, the computer management system design apparatus, label 1 further comprises: the 101st, the literal console module, the 102nd, the tabulation console module, the 103rd, management system design module, the 104th, report generation module, the 105th, database management module, the 106th, database query module, the 107th, database manipulation module.
The principle of work and the operating process thereof of computer managing and designing system shown in Figure 1 are as described below:
At first by the designer under computing machine 2 control, the register of the needed data form of management system that will design from plan of input media 5 input, and by the designer by inputting interface (as Figure 28), form sequence number (ID) or table name that input at first will design, then, the designer is under the support by 101 literal console modules and 102 tabulation console modules under computing machine 2 controls, 103 management system design modules, successively carry out the graph of a relation design of 103-01 as shown in Figure 4, a cover quantized data form that constitutes computer management system is pressed hierarchical classification, foundation has data between any two and copies into being ferreted out, 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; Thus, make the formation stratification of computer management system complexity, complicated data relationship is thoroughly simplified, be simplified to data between each two form that concern centering copy into, be ferreted out relation, reached the effect of the dimensionality reduction of complex management system, made the pass of multidimensional be tied to form the linear relationship of one dimension.Then, draw the table submodule with the 102-01 in the 102 tabulation console modules and draw form, automatically calculate form with 102-02 list item measuring and calculating submodule, with 102-04 formal definition submodule definition format, copy to copy with 103-02 again and enter a profession into definition submodule definition, or copy to copy with 103-04 classification and enter a profession into the submodule defining classification, or be ferreted out definition submodule definition with 103-06 and be ferreted out row, or be ferreted out definition submodule definite condition with the 103-08 condition and be ferreted out row, calculate the definition of definition submodule with 103-10 table and calculate row, and add up the inherited attribute submodule with 103-12/moon attribute definition module and 103-14 and carry out attribute definition.Time and accumulative total inherited attribute design submodule 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 the 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; Automatically handle next form by 103-16 flow process control definition at last.
Stipulated the hierarchical relationship separately of these forms by graph of a relation design submodule, here said 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, here the level of indication quantizes numeral to be that level heals level quantification numeral high littler, and just 1 grade of level is for the highest.
The present invention will be divided into three phases from low to high according to level, 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, level is placed in the middle, and the phase III is result's application, be forms at different levels and statistical graph, level is the highest.This module defines the table process of doing from raw data table intermediate data table data summary table, and writes down this attribute according to these hierarchical relationships, or the form order of definition from the form to the summary sheet, and writes down this attribute.Relation table is in pairs done definition as mentioned above, up to end, has promptly finished a predetermined Design of Management System.
Can call in the device as Fig. 1 a management system that designs, its principle of operation and step are as follows:
Operating personnel are by No. 5 inputting interface input manager systems engineering titles, (a just foregoing file that comprises all data form titles of management system), specify the form sequence number (ID) or the table name that at first will call, system will intuitively demonstrate the form that you will operate by computing machine 2 on display 3, at first, it can be before showing form, if this table design the time have from other forms, copy into data or literal, its can by computing machine 2 through 103-03 copy into implementation sub-module copy automatically into; If this table design the time have from other forms by select to copy into design, it also can be according to intrinsic condition, automatically copy into implementation sub-module through 103-05 classification by computing machine 2 and to copy exactly into data, system can point to the place that you will import data by computing machine 2 with cursor automatically automatically then, wait for that you import, the operator promptly can pass through input media (keyboard) 5 input data, after the input data are finished, implementation sub-module can calculate through the 103-11 table by computing machine 2 again in system, according to the computing formula that designed originally, arithmetic to data is added up and function calculation, and result of calculation is accurately inserted in the intrinsic list item.Statistical computation design submodule is by having the data transfer between right per two forms of data transfer relation, and then reach the computing between the quantized data of multidimensional in the daily management affairs is simplified, thereby accomplish in an intermediate table or application table, to describe between the project+,-, * ,/, the % computing, can carry out looping discription to row and column in order to simplify; Make to calculate between the list item in the quantized data form and have automatic function; If the design that former design will be ferreted out or according to condition be ferreted out to other forms from this table, it also can be ferreted out implementation sub-module or the 103-09 condition is ferreted out implementation sub-module through 103-07 by computing machine 2, will meet the requirement that design is ferreted out and the project of condition automatically and copy in the intrinsic table.If the attribute that this table of former design has accumulative total to inherit, the accumulative total inherited attribute that it can will define through 103-15 by the control of computing machine 2 is passed through the accumulative total implementation sub-module, 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.If this table of former design has the flow process controlled attribute, it can be by the control of computing machine 2, automatically access next form through 103-17 flow process control implementation sub-module, when management system is used, realize doing the flow process control of table automatically by execution module, or when management system is used, can automatically perform the flow process control of report generation by execution module.And can make aforesaid all processes, finish next form copy into, import, calculate, be ferreted out so that start next form more automatically, by that analogy, till finishing whole work.
As mentioned above, by computer managing and designing system of the invention process, have highly intelligent effect, make operator's easy operating, a lot of work is finished automatically by computing machine 2.
The computer managing and designing system that adopts the present invention to realize can be revised system easily, and its principle of operation and step are as follows:
The management system title (text that promptly contains all forms title) that will revise by No. 5 input medias and interface input, and the sequence number (ID) or the table name of the form that will change to system's input.Copy into the definition submodule by 103-02 then, 103-04 classification is copied into the definition submodule and is carried out the modification of entering a profession to copying, perhaps being ferreted out definition submodule and 103-08 condition by 103-06 is ferreted out submodule and makes amendment to being ferreted out, perhaps calculating the definition submodule by the 103-10 table makes amendment to calculating formula, perhaps by 103-12/moon attribute submodule, 103-14 accumulative total inherited attribute definition submodule, 103-16 flow process control definition submodule, respectively to the year/moon attribute, the accumulative total inherited attribute, flow process control is made amendment, perhaps draw the table submodule and revise form by 102-01, by 102-02 list item measuring and calculating submodule amended form is calculated again, revise form by 102-04 formal definition submodule, by the above-mentioned operation that may revise is made amendment to original system, produce a brand-new improvement management system, operator to knowledge be the managerial knowledge that he is familiar with, needn't grasp computer software knowledge, these significant especially characteristics of the present invention just.
The computer management system that adopts the present invention to realize can also generate the statistical graph of form and visual pattern easily, and its principle of operation and step are as follows:
As Fig. 1, by in the 104 report generation modules and 104-01 as shown in Figure 5 call as shown in figure 13 102-03 automatically dress table submodule can with result data on request tabular form automatically the dress table generate form, and as required with the 2-D data of form by generate vivid statistical graph such as needed histogram or pie chart or curve map or broken line graph respectively as Figure 104-02 histogram sub-module, 102-03 pie chart submodule, 102-04 curve map submodule, 102-05 broken line graph submodule.
Then with these forms or statistical graph process computing machine 2, I/O interface and driver module, through the form and the statistical graph of external unit 7 (printer or laser printer, laser photocomposing machine) outputting high quality.
The computer management system that employing the present invention realizes is the call establishment database easily, realizes management, inquiry and other operations to database, and its principle of operation and step are as follows:
As mentioned above, call the designed management system of this managing and designing system, can be created as database automatically, as Fig. 1, by 105 database management modules, and 105-01 database structure submodule shown in Figure 6,105-02 database access submodule, 105-03 database grooming submodule is realized convenient management, the database structure of convenient visit.
By 106 data query modules with pass through 106-01 general inquiry resume module as shown in Figure 7, can inquire about easily and set up the data of database file, can also inquire submodule and following step as shown in figure 10 by classification by 16-02, the inquiry of realization systematic searching, at first by 106-02-01 system classification inquiry table module, make classification inquiry table or by the 106-02-02 step this question blank is added among the phylogenetic relationship figure again by the systematic searching requirement by the operator and go, use the same method of foregoing modification system again, do between step defining classification table shown in the 106-02-03 and the relation table copy into, be ferreted out, condition is ferreted out, the classification copy into, calculate, year/month attribute, the accumulative total inherited attribute, various definition such as flow process control, foregoing then calling system is the same with the report generation mode, carry out the 106-02-04 step, carry out the systematic searching table and generate, can reach the described classified inquiry result of 106-02-05.
Can move the storehouse submodule by the 107-01 that 107 database manipulation modules are done as shown in Figure 8 to the database of setting up, database is moved on to another computing machine by external storage or on-line mode from a computing machine, also can duplicate the memory copy backup outside of storehouse submodule, or copy in another computing machine by on-line mode and to go by 107-02.
Shown in Figure 2 is 01 picture processing sub, 02 mutilation body submodule, 03 mutilation work song module, 04 word deformation sub-module to be arranged under the 101 Chinese platform modules, submodule, 07 word copy piece and 08 mapping submodule moved in 05 word gyrator module, 06 word, more than many submodules provide abundant word processing function and editting function for system.
102 tabulation console modules shown in Figure 3, it further comprises 01 picture table submodule, 02 list item measuring and calculating submodule, 03 adorns the table submodule automatically, 04 formal definition submodule, its operation steps is as follows, usually adopt 01 to draw table submodule picture form, can draw the lines form of any complexity, automatically after calculating by 02 list item measuring and calculating submodule then, allow computing machine can remember each project ranks sequence number of the form of any complexity, and the wide and high size of each, so that enter literal and data usefulness, by the data or the literal definition form that will write in 04 pair of list item, reach with this and to simplify the operation when using and the purpose of format specification, also can be to one group of data according to form by the 102-03 form of packing into automatically.
Shown in Figure 4 is 103 management system design modules, it further comprises 01 graph of a relation design submodule, 02 copies into the definition submodule, 03 copies into implementation sub-module, 04 classification is copied into the definition submodule, and 05 classification is copied into implementation sub-module, and 06 is ferreted out the definition submodule, 07 is ferreted out implementation sub-module, 08 condition is ferreted out submodule, and 09 condition is ferreted out implementation sub-module, and 10 tables calculate the definition submodule, 11 tables calculate implementation sub-module, 12 years/month attribute definition submodules, 13 years/month attribute implementation sub-modules, 14 accumulative total inherited attribute definition submodules, 15 accumulative total inherited attribute implementation sub-modules, 16 flow process controlled attributes definition submodule, 17 flow processs control implementation sub-module.Its basic principle of operation is as described below:
The operator uses 01 graph of a relation design submodule, all forms that the management system that will design can be comprised generate graph of a relation, and defined the hierarchical relationship of each form, defined and had or not the data transfer relation between per two forms mutually, and then defined form and whether classify, defined whether paging.Design by this submodule, basic set up the basic configuration and the model of management system, 02,04,06,08,10,12,14,16 copy into data copying into data qualification between each form design and the relation table respectively, or be ferreted out data, or condition is ferreted out data, table calculates, year/the moon attribute, accumulative total is inherited, flow process control etc., by above-mentioned definition, particularly, expressed the management expectancy and rule of deviser clearly to management system, therefore, we can say that this module is the core of managing and designing system, by the definition of above-mentioned submodule, Design of Management System is finished at this point; 03,05,07,09,11,13,15,17 when calling the management system that designs, explain to carry out respectively the data that design in advance copy into or data selection sort copy into, function and attributes such as data are ferreted out or data qualification is ferreted out, show to calculate, year/moon attribute, totally succession, flow process control, reach highly the automatic processing procedure of data message of intelligence, thus win efficient, accurately, be convenient to use effect.
Shown in Figure 5 is 104 report generation modules, and it further comprises 01 report generation, 02 histogram sub-module, 03 pie chart submodule, 04 curve map submodule, 05 broken line graph submodule.Their principle of operation and step are as described below: the user is by calling after management system set up database, can be with 01, further call above-mentioned (as Figure 13) 102-03 form submodule of packing into automatically, generate form on request, perhaps call 02 or 03 or 04 or 05 statistical graph that generates visual patterns such as histogram, pie chart, curve map, broken line graph respectively as required.
Shown in Figure 6 is 105 database management modules, and it further comprises 01 database structure submodule, 02 database access submodule, 03 database grooming submodule.Its principle of work is as follows, the user is calling after management system builds up database, generally to use database, therefore to generate by 01 database structure submodule and reasonably be convenient to the structure of visiting, by 02 database access submodule database is conducted interviews, and can carry out the structure arrangement and check reparation database through 03 database grooming submodule, with guaranteeing data security property.
Shown in Figure 7 is 106 data base querying submodules, and it further comprises 01 general inquiry submodule and 02 classified inquiry submodule.Its principle of work and operation steps are: general inquiry is by the database self structure, and direct data query, another kind are to inquire (seeing Figure 10 for details) by classification by 2 classified inquiry submodules.
Shown in Figure 8 is 107 database manipulation modules, it comprises that further 01 moves storehouse submodule and 02 coping database submodule, and its function is that database is shifted to another computing machine from a computing machine, or move on to external storage, also can copy to another machine or copy to external storage.
Shown in Figure 9 is the data of database structure, and database mainly comprises text, numeral, several data types of picture, and it also comprises the item number that is convenient to deposit in dress table usefulness according to separator, and tabular form name, accumulative total are inherited (seeing Fig. 9 for details) such as data; Adopt this structure to deposit conveniently, take data processing and also make things convenient for, be more suitable in automatic dress table.
Shown in Figure 10 is 16-02 classified inquiry submodule, its operation steps is, at first carry out 01, make classification inquiry table, carrying out 02 then joins question blank among the phylogenetic relationship figure and goes as form, data transfer relation between this table of 03 definition and the related table and calculated relationship etc. are called this question blank as the same mode of form then, can obtain desired result.Adopt this method to program, be fit to the general management personnel and use.
Shown in Figure 11 is 102-01 picture table submodule, its operation steps is 01 to decide the bezel, cluster live width, 02 definition horizontal stroke/vertical line width and bar number then, and 03 by Computerized automatic tabulation, by 04 judge have or not change lines or increase, the delete line bar, then do not finish tabulation if having, if having can increase, delete, mobile lines, and the bezel, cluster width can be made as 0, adopt 01 again, 02,03 step is made secondary picture table, so can repeatedly draw very numerous and diverse form.
Shown in Figure 12 is 102-02 list item measuring and calculating submodule, its principle of operation and step are in a bezel, cluster scope, begin 01 scanning from left to right from the upper left corner, up to running into 02 lines, make 03 record list item width, 04 scanning from top to bottom again, 05 until running into lines, 06 record list item height, and record list item i, j ranks number, be advanced to outside this list item right side bearing, continue scan cycle, 07 until surpassing the bezel, cluster width; 08 gets back to the bezel, cluster left end, push the continuation scanning second row list item downwards from first, so circulation, 09 is whole been scanned up to surpassing the bezel, cluster height, adopt this method can be exactly complicated arbitrarily form be calculated the size of list item ranks number and list item automatically, help showing literary composition and insert, and data are packed into.
Shown in Figure 13 is 102-03 dress table submodule automatically, operation steps: 01 opens the table data file, 02 takes out character, judges whether 03 item number, 04 numeral, 05 literal/picture, whether 06 finish, if finish then deposit in to finish outlet, if do not finish, if 03 item number, entries etc. are housed to data, if 04 numeral is pieced together number, the project of packing into, if 05 literal/picture, the project of also packing into is finished above every type and is all advanced pointer, go 02 to get the character circulation again, till total data has been adorned form.
102-04 fixes formula module that shown in Figure 14 is, its execution in step are if 01 literal section, draw by the literal section and confine justice, if 03 numeral is provided with data layout, and integer-bit and decimal place are set.If picture is provided with picture in project, setting completed, deposits tabular form in.
Shown in Figure 15 is that 103-01 is a graph of a relation design submodule, its execution in step is: 01 opens the table name file, 02 with table name the corresponding layout table name frame in the workspace one by one, if with 03 mouse crawl left button, can pull to related with it another bezel, cluster, promptly define this to the data transfer relation is arranged between the form, if heavily draw primary line, show that then lines disappear, the relation of former login also is cancelled.If pin Ctrl with 11, pin left button with mouse and the bezel, cluster that points to can be moved this moment.If pin the ALT key with 13, this moment is with the color of the representational level that defines, again with bezel, cluster in the left mouse button point, then this bezel, cluster is by the inferior color in previous generation top layer, this table has been defined this level simultaneously, as if crawl twice on the table name list, then can import classification and branch number of pages.
Shown in Figure 16 is that 103-02 copies into the definition submodule, and its operation steps is the 01 source table name of copying into data defined by the user at first, and charges to copy and enter a profession, then 02 by the user directly point to form to copy into the list item position, 03 checks in list item (OK, row) number automatically according to the list item array, and 04 charges to copy and enters a profession, 05 judges that end is not, (specifying end by the operator) then do not continue to do 02,03 if finish, 04, so just can finish and copy the definition of entering a profession.
Shown in Figure 17 is that 103-03 copies into implementation sub-module, its operation steps is to use when the user calls management system, at first 01 system copies into the source table name from copying to take out entering a profession, 02 opens this document, and 03 fetches data, and 04 gets one entering a profession and copies into (OK from copying again then, be listed as) number, do 05 then, data are sent in the list item of this (OK, row) number, 06 advances file pointer to enter a profession (OK with getting to copy, row) number pointer is if 07 copy into (OK, be listed as) and number do not got, remake 03,04,05,06, up to copy the item got till, make 08 close file then, promptly finished copy into execution work.
Shown in Figure 180 is, and the 103-04 classification is copied into the definition submodule, in its operation is suddenly, and 01 is specified to copy into the source by the user and shows, find the list file name by system, record advances classification to be copied and enters a profession, then 02 by the user in the face of form select copy into list item specify, system finds (OK automatically, be listed as) number, and charge to copy and enter a profession, judge by 03 whether the user specifies end, if do not finish to continue to do 02 step, up to end, can finish classification and copy the definition of entering a profession.
Shown in Figure 19 is that the 103-05 classification is copied into implementation sub-module, it is when the user calls the management system that designs, automatically perform by system, its execution in step is as follows: at first do 01 taking-up by system and copy into coming source filename, and open this document, do 02 then and from file, get a number, this number is scarabaeidae order sequence number, it is charged in the scarabaeidae order number go, and 03 to copy in entering a profession in classification number be that sequence number is taken out corresponding copying into list item (OK with the scarabaeidae order, be listed as) number, do 04 then, send into from the file peek in the list item of this (OK, row) expression, close data file, this moment, classification was copied into the implementation sub-module EO.
Shown in Figure 20 is that 103-06 is ferreted out the definition submodule, its operation steps is as follows: at first do 01, specify the purpose table that is ferreted out when the design system by the user, find this document name automatically, and record to be ferreted out in the row and go by system, do 02 then, specify the list item that will be ferreted out by the user intuitively in the face of form, find list item＜OK, be listed as automatically by 03 system then number, record by 04 and to be ferreted out row, do so always 02,03,04 step up to 06 specify end by the user till.
Shown in Figure 21 is that 103-07 is ferreted out implementation sub-module, and it is when the user calls the management system that designs, and is automatically performed by system.Its execution in step is as follows: at first do 01 by system, take out and be ferreted out destination name of the file, judged whether connection attribute by 02 then, if have, do 03, open file, pointer is put end-of-file, if no connection attribute energy then does 04, open file, pointer is put file header, does 05 by system then, gets the list item that is ferreted out in the row＜OK, row〉number, do 06 by system again, by should＜OK, be listed as number in list item, peek, do 07 by system, to get number and write file, 08 propelling is ferreted out row and gets the item No. pointer, and 09 advances file pointer, do 10 by system, judge that being ferreted out capable table item No. has got not, finish then to remake 05,06,07,08,09, after finishing, make 11 close files, then be ferreted out to carry out and finish.
Shown in Figure 22 is that the 103-08 condition is ferreted out the definition submodule, at first does 01, is specified by the user to be ferreted out the purpose table, find the corresponding file name automatically by system, and Writing condition is ferreted out row; Do 02 then, by specifying the list item will make criterion with note, and by system produce automatically differentiate list item＜OK, row〉number, remake 03, this is differentiated＜OK, be listed as〉number Writing condition is ferreted out row; Next step does 04, by the user in the face of the conditioned disjunction interface, the specified requirements expression formula (comprise＜,＞, 〉=,≤, ≠, with or etc. conditional operator), and entry condition is ferreted out row; Below do 06, if by the user in the face of form specify will copy after eligible into list item, and by system produce＜OK, row〉number, Writing condition is ferreted out row, so always definition, up to 06 specify end by the user till, condition is ferreted out defining operation and finishes dealing with.
Shown in Figure 23 is that the 103-09 condition is ferreted out implementation sub-module, and it is when the user calls the management system that designs, and is automatically performed by system.Its execution in step is as follows: at first do 01 by system, take out and be ferreted out destination name of the file, judged whether connection attribute by 02 then, do 03 if having, open file, pointer is put end-of-file, if no connection attribute then does 04, open file, pointer is put file header, does 05 by system then, takes out conditional expression, do 06, taking-up differentiation item＜OK, row〉number, do 07, by＜OK, and row〉number peek, then, do 08, automatically numerical value and the conditional got are made condition judgment by system, if ineligible, then do 09, close file does not carry out to be ferreted out to current table, finish outlet; If eligible, then do 10 by system, by be ferreted out successively appointment in the row＜OK, row〉number, carry out data and be ferreted out, and write file, get the bundle (12) that finishes up to the item No. that is ferreted out of appointment, do 13 at last, the close file end.
Shown in Figure 24 is that the 103-10 table calculates the definition submodule, its operation steps is as follows: 01, after at first choosing table to calculate defining operation from the interface by the user, display calculator tool bar, 02, the user is in the face of active sheet, use the mouse-pointing list item, produce automatically＜OK, be listed as by system number, make variable with this, and the numeral on the utilization counter ,+,-, *, /, operational symbols such as % constitute calculating formula, 03, this formula is write the calculating row, till finishing,, do 04 if circulation is arranged so always, with [] and＜OK,＜row〉difference designated cycle body and cycle index, and with＜OK〉or＜row〉specify by row and circulate, still by the row circulation, and the expression formula of above appointment charged to calculate in the row go, so the table definition of calculating is promptly finished.
Shown in Figure 25 is that the 103-11 table calculates implementation sub-module, and it is when calling the management system that has designed by the user, to be automatically performed by system.Its execution in step 01 is at first calculated row by system scan, runs into 13,14,15,16, % shown in 17, +,-, *, / operational symbol enters the computing storehouse, run into 02 " [", then do 03, continue scanning and risk the row or column cycle index, charge to the cycle index unit, run into 04 "] ", then remake 05,, cycle index is subtracted 1 with loop body of computing storehouse computing, be not 0, then remake 05, till 06 judgement loop ends, continue scanning again, run into 07 " (", up to running into 09 ") " whole arithmetic expressions charge to preferential operator stack, promptly to calculate earlier, the calculation fruit that finishes is sent into operator stack, if run into 19＜carriage return 〉, and do not have circulation, then storehouse of computing is 11 "＜" if run into, then continue scanning read to piece together project＜OK, row〉number, up to meeting "〉" end, and charge to storehouse, run into numeral and piece together the numeric string end always, send the computing storehouse numeral.The computing storehouse is according to operation rule, its＜OK, row〉number expression system will be automatically from this＜OK, row〉list item in peek, as if＜OK, row〉number institute is shown in the storehouse is unit as a result, then with operation result by system deliver to this automatically＜OK, row〉go in the list item of appointment, so the calculation step list item that can will design in advance calculates and is finished, realize the automatic calculating of the various complexity between the form project, reached the highly effect of intelligence.
Be spliced into a complete figure about Figure 26 and Figure 27, the technological process of expression managing and designing system, the whole flow processs of this figure such as preceding the description are not repeatedly repeated at this.
The design interface (one) that shown in Figure 28 is by embodiment of the invention managing and designing system, it comprise table copy into, be ferreted out, calculate defining operation interface and inputting interface.
What shown in Figure 29 was by embodiment of the invention managing and designing system concerns design interface and attribute design interface.
Shown in Figure 30 is the interface operation function bar of embodiment of the invention managing and designing system.
Shown in Figure 31 is the block diagram of the database structure of one embodiment of the invention.
Reference when Figure 26,27,28,29,30,31 supplies referring to 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.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN95116973A CN1052316C (en) | 1995-09-15 | 1995-09-15 | Computer managing and designing system and method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN95116973A CN1052316C (en) | 1995-09-15 | 1995-09-15 | Computer managing and designing system and method thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1149160A CN1149160A (en) | 1997-05-07 |
| CN1052316C true CN1052316C (en) | 2000-05-10 |
Family
ID=5081072
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN95116973A Expired - Lifetime CN1052316C (en) | 1995-09-15 | 1995-09-15 | Computer managing and designing system and method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1052316C (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100419674C (en) * | 2002-05-06 | 2008-09-17 | 鸿富锦精密工业（深圳）有限公司 | Report forms generating system and method |
| CN100452021C (en) * | 2005-07-15 | 2009-01-14 | 英业达股份有限公司 | Computer program development system and method |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100377157C (en) * | 2003-10-25 | 2008-03-26 | 鸿富锦精密工业（深圳）有限公司 | Computer aided design report generating system and method |
| CN100549949C (en) * | 2006-07-21 | 2009-10-14 | 石自力 | A kind of design system of computer application system |
| CN101763348B (en) * | 2008-12-26 | 2011-12-07 | 英业达股份有限公司 | Dynamic table type data acquisition system and method |
| CN102402376B (en) * | 2010-09-16 | 2015-06-17 | 齐营股份有限公司 | Method for electronic system to draw statistical chart |
| KR102129643B1 (en) * | 2012-10-22 | 2020-07-02 | 아브 이니티오 테크놀로지 엘엘시 | Profiling data with source tracking |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0314595A2 (en) * | 1987-10-28 | 1989-05-03 | International Business Machines Corporation | Bill of material interface to CAD/CAM environment |
| EP0314594A2 (en) * | 1987-10-28 | 1989-05-03 | International Business Machines Corporation | Conceptual design tool |
-
1995
- 1995-09-15 CN CN95116973A patent/CN1052316C/en not_active Expired - Lifetime
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0314595A2 (en) * | 1987-10-28 | 1989-05-03 | International Business Machines Corporation | Bill of material interface to CAD/CAM environment |
| EP0314594A2 (en) * | 1987-10-28 | 1989-05-03 | International Business Machines Corporation | Conceptual design tool |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100419674C (en) * | 2002-05-06 | 2008-09-17 | 鸿富锦精密工业（深圳）有限公司 | Report forms generating system and method |
| CN100452021C (en) * | 2005-07-15 | 2009-01-14 | 英业达股份有限公司 | Computer program development system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN1149160A (en) | 1997-05-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Das et al. | Falcon: Scaling up hands-off crowdsourced entity matching to build cloud services | |
| Jayram et al. | Avatar information extraction system. | |
| Yu et al. | Materialized view selection as constrained evolutionary optimization | |
| Franklin et al. | CrowdDB: answering queries with crowdsourcing | |
| Lo et al. | Olap on sequence data | |
| Srivastava et al. | Warehouse creation-a potential roadblock to data warehousing | |
| CN1967533A (en) | Gateway personalized recommendation service method and system introduced yuan recommendation engine | |
| Braga et al. | Optimization of multi-domain queries on the web | |
| CN1711522A (en) | Modeling system for graphic user interface | |
| CN109857833B (en) | Rule engine implementation method and device and electronic equipment | |
| Yu et al. | Query-driven discovery of semantically similar substructures in heterogeneous networks | |
| CN1052316C (en) | Computer managing and designing system and method thereof | |
| CN1777901A (en) | Cascaded planning of an enterprise planning model | |
| CN116361487A (en) | Multi-source heterogeneous policy knowledge graph construction and storage method and system | |
| Nabli et al. | Two-ETL phases for data warehouse creation: Design and implementation | |
| CN113362072A (en) | Wind control data processing method and device, electronic equipment and storage medium | |
| Chen et al. | Optimizing complex extraction programs over evolving text data | |
| JPH113357A (en) | Technological information managing device | |
| Halevy | Structures, semantics and statistics | |
| Zhao | Workflow-centric distribution of organizational knowledge: the case of document flow coordination | |
| Romanowski et al. | A data mining-based engineering design support system: a research agenda | |
| Sharma et al. | Review Of Data Mining Techniques: An Empirical Study | |
| Ohge et al. | Encoding and Analysis, and Encoding as Analysis, in Textual Editing | |
| Jagadish et al. | Organic databases | |
| Acosta et al. | A SPARQL engine for crowdsourcing query processing using microtasks–Technical Report |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| EE01 | Entry into force of recordation of patent licensing contract |
Assignee: Shantou base software Co., Ltd. Assignor: Yin Bujiu Contract fulfillment period: 2004-06-17 to the contract period Contract record no.: 041000030058 Denomination of invention: Computer Management Design System Granted publication date: 20000510 License type: Exclusive license Record date: 20040709 |
|
| LIC | Patent licence contract for exploitation submitted for record |
Free format text: EXCLUSIVE LICENCE; TIME LIMIT OF IMPLEMENTING CONTACT:2004-06-17 TO CONTRACT Name of requester: SHANTOU HUALUOGENG SOFTWARE BASE CO., LTD. Effective date: 20040709 |
|
| PP01 | Preservation of patent right |
Effective date of registration: 20091221 Pledge (preservation): Preservation |
|
| PD01 | Discharge of preservation of patent |
Date of cancellation: 20100719 Granted publication date: 20000510 |
|
| PP01 | Preservation of patent right |
Effective date of registration: 20110311 Granted publication date: 20000510 |
|
| PD01 | Discharge of preservation of patent |
Date of cancellation: 20110311 Granted publication date: 20000510 |
|
| CX01 | Expiry of patent term |
Granted publication date: 20000510 |
|
| EXPY | Termination of patent right or utility model |