CN101034349A

CN101034349A - Data base application system development platform based on functional design

Info

Publication number: CN101034349A
Application number: CN 200710017624
Authority: CN
Inventors: 张宽让
Original assignee: XI'AN WANNIAN TECHNOLOGY INDUSTRIAL Co Ltd
Current assignee: XI'AN WANNIAN TECHNOLOGY INDUSTRIAL Co Ltd
Priority date: 2007-04-06
Filing date: 2007-04-06
Publication date: 2007-09-12

Abstract

The present invention introduces a development platforms based on the database application systems with function design, the development platform includes system control table, the menu component kits and code generator, the menu component kits is the module of reusable menu classification implementation; System control table is the carrier of description parameters both of storage application system architecture and menu functions, the carrier is the data tables of the relational database; The code generator dynamically generates code execution under storage parameters in the system control table. Development and application of the system using development platform just require system functional design, data table design, menu Form design, without the need to write code or only a very small number of special features menu prepared by the code, which can be generated applications; Application of the system's operation, reading system control table parameters and dynamic generating code execution, completion of system functions; when users change the business model, only a modification of system parameters control table, or to amend the use of the data table menu, and the menu forms can complete system maintenance.

Description

Data base application system development platform based on the function design

Technical field

The present invention relates to a kind of data base application system development platform based on the function design.

Background technology

In order to guarantee software quality, improve software reliability, reusability and maintainability, when carrying out software development, adopted technology such as object-oriented, member; But along with continuing to increase and social quickening of transporting rhythm of software systems scale; be accompanied by the new user's request that enterprise institution's reorganization, business reorganization, scale variation etc. certainly lead to; make that the demand change is more and more frequent; brought a series of problems for the exploitation and the maintenance of software systems, caused so-called ' software crisis '.For this reason, create new software development methodology, solve ' software crisis ', the person that become the software work enjoys popular confidence.

For database application system, the Perfected process that solves ' software crisis ' is: develop a general data base application system development platform, first, when developing arbitrary application system, only make user's demand analysis, system function design, tables of data design, user-interface design, do not do or do less the program code design; Second, with the function menu name of application system, function that menu should be realized, data table name that menu uses or Data Filename, data processing method, data flow regulation, be to fill in some control tables after user's the whole parametrizations of business model, can generate application system; The 3rd, during the application system operation, read these control table parameters automatically, and dynamic generator program run time version, finish systemic-function; The 4th, when user's business model changed, only needing increased, deletes the function menu of control table, or revises tables of data, menu forms and the control table parameter that menu uses, and can finish system maintenance and need not to revise code.

Through effort in 6 years, at lan networking environment, Windows operating system and oracle database, adopt " based on the data base application system development platform of function design " of database server, application server, client station three-Tier Model to succeed in developing, this platform has reached the requirement of people to database application system development instrument basically.

Summary of the invention

The purpose of this invention is to provide a kind of data base application system development platform based on the function design, only need carry out system function design when using development platform development data storehouse application system, and need not again the coding code or only some special data processing capacity is write code, can generate the application system that satisfies functional requirement.

Development platform comprises system's control table, menu member bag and code generator, and described menu member bag is reusable menu classification execution module; The control table of described system is the carrier of storage application system architecture characterising parameter and menu function characterising parameter, and carrier is the tables of data of relational database; Described code generator is the code generator that dynamically generates run time version according to system's control table stored parameters.

Only need carry out the function module design of system when using development platform development data storehouse application system, the menu design that functional module is used, the function design of menu, the tables of data design that menu uses, the menu window design is input to menu identity, the menu member bag name of carrying out the menu use and the functional description parameter of menu in system's control table, and need not coding code again, or, can generate application system only to not using the menu coding code of menu member bag.

A function menu of the corresponding application system of one or more records of system's control table, the corresponding record of the function menu automatic Car Plate Reading System control table of carrying out by the user during application system operation, determine menu member bag name, menu forms name, the data table name that function menu uses according to the parameter value of these recording storage, the data type that menu uses and table record filtercondition, table record index and sort method, menu forms data show and editor's regulation, customer incident disposal route and background process disposal route; And dynamic generator program run time version, call database data or file data, load the menu forms, the response customer incident, Control-Menu is carried out overall process, finishes menu function.

When increasing or having deleted menu record in system's control table, the menu of application system will increase thereupon or reduce; Menu function characterising parameter in having revised system's control table, the function of menu will change thereupon.

After application system put into operation, the change of user management mechanism was by revising relevant management organization's tables of data record and using the menu authority of development platform that the function realization is set; The change of application system function is to realize by tables of data, the menu forms of revising system's control table parameter or the use of modification menu; The business model change that is the user does not need to carry out the modification of program code.

Menu member bag is 3 kinds of base attributes carrying out data processing according to the database application system menu: the reusable execution module that ' the tables of data interrelational form that menu uses ', ' menu is to the use-pattern of tables of data ', ' form types that menu uses ' are classified, development platform has designed 20 menu member bags altogether.

According to the interrelational form between the tables of data of database application system menu use menu member bag is classified as follows:

1. single tables of data is called ' single master meter ';

2. two-layer subordinate incidence relation table is called ' master meter ', ' sublist ', and many records of sublist are subordinated to a record of master meter, and sublist is called ' and subtabulation ' when being a plurality of;

3. three layers of subordinate incidence relation table, be called ' master meter ', ' sublist ', ' sublist ', many records of sublist are subordinated to a record of master meter, and many records of sublist are subordinated to a record of sublist, and sublist is called ' sub-sublist arranged side by side ' when being a plurality of;

4. coordination master meter: single data sheet field is divided into a plurality of tables when more, one of them table is called ' master meter ', and all the other a plurality of tables are called ' master meter side by side ', and the record strip number average of each master meter arranged side by side is identical with master meter record strip number, and correspondence one by one;

5. coordination master meter and subordinate sublist, many records of sublist are subordinated to a record in the coordination master meter;

6. index incidence relation table: with the index of some field value of tables of data as another tables of data, previous table is called ' concordance list ';

7. the incidence relation table of originating: with the Data Source of a data table record as the newly-increased record of another tables of data, previous table is called ' source table '.

The arbitrary menu of database application system may use single tables of data, also may use a plurality of tables of data with incidence relation.

According to the database application system menu use-pattern of tables of data is classified by following 9 kinds of methods to menu member bag:

1. single tables of data, coordination master meter, coordination master meter and subordinate sublist, two-layer subordinate incidence relation table and three layers of subordinate incidence relation table record are inquired about or edited;

2. be the reduced data typing, guarantee data consistency, when single tables of data, coordination master meter, two-layer subordinate incidence relation table and three layers of subordinate incidence relation table are increased newly record, use the source table record to increase the Data Source of record newly as these tables;

3. call speed for accelerating table record, use concordance list when the table record of single tables of data is inquired about or edited;

4. single tables of data by system's control table regulation sorting field, gather field and field gathers mode, table record is carried out random assortment gathers;

5. single tables of data record carries out the random assortment inquiry by system's control table regulation sorting field to table record;

6. single tables of data is by the date field of system control table regulation ' by the period statistics ', to table record carry out by the period statistics with gather;

7. single tables of data selects one or more record as certain purposes by the user as required;

8. single tables of data is by system's control table regulation ' substantial definition field ' and deposit ' time that entity state changes ' field name, inquires about the entity state and the state of each entity before arbitrary closing time and changes the time;

9. to a certain record of user's selected at random in the single tables of data, ' judging the field name that value equates ' and ' the field value comparison condition ' stipulated by system's control table find out other relative recording in this tables of data.

According to the form types that the database application system menu uses menu member bag is classified by the following method:

1. the forms method of calling is divided into following 6 kinds:

● master menu calls;

● button menu calls, and promptly the window function button calls;

● the paging menu call, call by the paging menu identity, each paging menu identity uses forms;

● OLE calls forms;

● the third party software embedded functional calls forms;

● the self-editing executable program of user calls forms.

2. the data type of forms use is divided into following 4 kinds:

● only use numerical value, character, the date type-word segment data of tables of data;

● only use the big binary word segment data of tables of data;

● use numerical value, character, date type-word segment data and the big binary field view data of tables of data;

● use file data.

3. the forms form is divided into following 6 kinds:

● unirecord forms: the resume formula forms of a tables of data;

● optional unirecord forms: in the same menu, the inhomogeneity of tables of data record uses different unirecord forms;

● write down forms: many record forms that tables of data shows by row more;

● the band gauge outfit writes down forms more: many fields that the record field value is identical under the single master meter one-level index are placed on forms top, and the forms bottom is placed by row and got many records of different value field;

● go up single many forms down: the master meter unirecord is placed on forms top, and many records that sublist is subordinated to this record are placed by row in the bottom; Or the unirecord of forms top placement sublist, many records that sublist is subordinated to this record are placed by row in the bottom;

● left and right sides forms: respectively place the forms of record more than about forms, be used for the choosing record as certain purposes, left side record forms to be selected, the record forms are chosen on the right.

All tables of data of database application system are all used unified major key, external key and main external key correlating method, and described method is as follows:

● single master meter, master meter, master meter arranged side by side, unique major key xuhao;

● sublist and subtabulation, two major key xuhao, xuhao1;

● sublist, sublist arranged side by side, three major key xuhao, xuhao1, xuhao2;

● sublist and subtabulation, master meter external key arranged side by side are master meter major key xuhao;

● sublist or sublist external key arranged side by side are sublist major key xuhao, xuhao1;

● master, external key xuhao, xuhao1, xuhao2 all are defined as integer type;

● two-layer subordinate incidence relation table, three layers of subordinate incidence relation table, coordination master meter, coordination master meter and subordinate sublist, according to the table record use cascading delete of main external key to subordinate list;

● index incidence relation table and source incidence relation table do not use cascading delete.

The control table of described system is divided into three major types by the stored parameters classification: system master parameter, system supplymentary controlled variable, menu background process disposal route parameter; Wherein the system master parameter is used a data table stores, is called system's control master meter; The system supplymentary controlled variable is used six data table stores, is respectively: the menu operation authority is provided with table, table record filter method table, selection input method table, management object table, tables of data primary key xuhao maximal value table, tables of data record derivation introduction method table; Menu background process disposal route parameter is stored by ' menu background process disposal route table '.

Following method is adopted in the overall design of described system control table:

1. each system's control table primary key all is defined as integer type, primary key by system's control master meter: menu sequence number, menu forms sequence number, the sub-sequence number of menu forms and other control table are carried out related, and the tables of data record filtering that the menu operation authority when being used to carry out menu, menu use, editor call and select typing, the call parameters when calling the processing of menu background process;

2. the functional description parameter of application system architecture characterising parameter and menu is used two kinds of dtds: integer type and character string type, and the numerical value of using system control table and character field are stored these parameters respectively;

3. to the definition of parameter value, adopt 10 kinds of define methods to avoid ambiguity.

Described system master parameter and system supplymentary controlled variable are:

Menu Type, pad name, menu sequencing method and menu manner of execution parameter;

The tables of data that menu uses, the use-pattern and the tables of data correlating method parameter of tables of data;

Tables of data read record mode parameter, table record filter method parameter that menu uses;

Tables of data recording indexes and parameters sortnig that menu uses;

The forms parameter that menu uses contains tables of data, forms form that forms name, the dynamic link library name of preserving forms, forms use, calls optional forms method, date and numeric type field display format;

The function button parameter of menu forms contains Edit button, background process call buttons, OLE funcall button, button menu forms call buttons, menu operation help button;

The special editting function parameter of menu forms table record contains newly-increased record and puts public variable, and newly-increased record duplicates, and selects typing to put field value, record editor shielding, field editing shielding, field condition editor shielding;

Tables of data record integrality and record repeated to judge parameter when editor preserved;

Carry out the flow process controlled variable;

The menu background process is handled call parameters;

Gather, end of term entity state inquiry, search selected at random entity correlation table record, random assortment inquiry, random assortment and gather disposal route parameter separately by the period;

Generate Web inquiry system parameter;

Menu operation authority definition parameter;

Management object, the i.e. professional responsibility compass of competency of the user of service of system defined parameters;

The introduction method parameter derived in the tables of data record;

Preserve the maximal value parameter of tables of data primary key.

The method for designing of described menu background process disposal route table comprises:

1. background process disposal route overall design:

With menu background process disposal route be decomposed into newly-increased table record, revise table record, delete list writes down three class tables of data record WriteMode, and designed the execution parameter of each WriteMode, dynamically generate SQL statement according to these parameters during execution, finish the tables of data write operation; For the function that can not use dynamic SQL statements to realize, realize by calling ' data base procedure ' of writing;

During design the user service data table is divided into two big classes: list of values and the value of writing table, list of values is the data source of dynamic SQL statements, the value of writing table is for carrying out the object table of write operation;

2. the parameter designing of menu background process disposal route table

Totally 6 of primary keys: menu sequence number, menu forms sequence number, the flow process control option that calls, the function button sequence number of calling, WriteMode, execution sequence number;

Background process calls the user intervention parameter of whether carrying out;

Flow process is controlled whole options modification field values and is unified processing parameter;

The list of values record and the value of the writing table record parameter of list of values, the value of writing table and use that write operation uses;

Judge the number of times parameter is carried out and carried out to the write operation of a certain recording prescribed of this method table whether;

Revise the manner of execution parameter of table record or delete list record;

WriteMode is when increasing the table record mode newly, the newly-increased record strip number of the value of writing table, the primary key of newly-increased record and the defined parameters of customer service key word generation method during write operation of every execution;

Field is composed the constant value method parameter;

When field is used the expression formula assignment, the enumeration type parameter that ' type expression ' uses;

Unconditional multiword section expression formula call by value parameter;

Condition multiword section expression formula call by value parameter;

With another data designated table as list of values, the write operation parameter of execution;

Sql statement assignment method parameter;

Call the data base procedure parameter;

Background process is handled and not to be allowed to carry out or the information parameter when being finished.

Described development platform is edited by system's control table stored parameters and querying method is:

System's control table can edit or inquire about by setup menu in application system, also can other system outside application system edit or inquire about;

Editor and query interface separately all adopted in each system's control table, finishes all kinds of parameter typings or the inquiry work of its storage;

Editor is divided into two big classes with the content of query interface, first parameter note, and containing parameter name, parameter operation instruction and parameter input format illustrate, it two is parameter value edit boxes;

Each parameter note to control table editor of system and query interface, all use the natural language description approach interpersonal communication, thereby system's control table also can be used as the intermediate medium that intermediate medium that the application system development personnel exchange system design and exploitation side and user side exchange systemic-function.

Described application system is meant the application system that is made of database server, application server, client workstation three-Tier Model.

When using development platform development data storehouse application system, defer to following steps and will generate application system automatically:

(1) in database, sets up the system's control table and the fundamentals of management table of development platform;

(2) carry out user requirements analysis, typing fundamentals of management table data

● analysis management mechanism, typing ' management organization's table ' data;

● analysis management standard, typing ' management regulation tables of data ' data;

● analysis management level, typing ' management object table ' data;

● typing ' personnel's duty list ' data; ' personnel's duty list ' storage system user of service's identifying data;

(3) determine the functional module of application system according to user requirements analysis, and the function menu that uses of functional module and the function menu function that should realize; Determine the menu operation authority; And set up the menu data table by development platform tables of data master, external key regulation and customer service requirement;

(4) according to function menu ' the tables of data interrelational form of use ', ' use-pattern of tables of data ', ' the menu form types of use ' determines the menu member bag that each function menu uses;

When (5) function menu did not use OLE to call forms, the tables of data and the interface of using according to function menu required to determine the forms form, create the menu forms; Determine forms date type-word section display mode, forms numeric type field display mode; Editor Web query page when menu is Web inquiry menu;

When (6) determining that all kinds of users of service carry out function menu to the filtercondition of menu data table record;

(7) determine the interrelational form shown when menu uses a plurality of tables of data; Read fields specify when using the source table;

(8) determine the tables of data index field that function menu uses; The indexed mode of date type index field; The sort field of table record, sortord; When function menu uses OLE to call forms, type field that OLE calls and value field;

(9) determine the function button of function menu, contain the paging menu identity that Edit button, background process call buttons, button menu call buttons, paging menu use;

(10) determine editor shielding, the condition editor shielding of record, the grouping editor conditioned disjunction method of function menu to the data table record;

(11) determine field shielding editor, the condition field shielding edit methods of function menu to the data table record;

(12) determine that newly-increased table record is put public variable, constant is stipulated; Newly-increased record clone method;

(13) field editing calls when selecting input method the parameter designing of finishing ' selecting the input method table ';

(14) determine to use that random assortment gathers, the random assortment inquiry, by period during statistical summaries, classification and method of summary regulation;

(15) determine to record field and table record uniqueness determination methods when editor preserves;

(16) the flow process control option of determining call flow control is stipulated;

(17) determine that the background process that menu should be realized calls, the call buttons that background process calls and call regulation;

(18) finish the parameter designing of ' menu background process disposal route table ' that the menu background process handles;

(19) menu that can not use menu member bag is write handling procedure; Determine to call the third party software method; Write ' data base procedure ';

(20) executive routine, the application server programs of installation development platform; Copy the menu forms to application server; The correlation parameter of the above-mentioned menu function design of typing in system's control table; ' self-compiling program ' and ' third party software ' is installed, and operation development platform executive routine carries out the setting of menu operation authority, carries out after system is provided with at each workstation, and system puts into operation.

To generate the Web inquiry system automatically after finishing following work:

1. need are carried out the menu editing Web query page of Web inquiry;

2. in system's control master meter, import Web page name;

3. the Web polling routine of development platform is copied to the Web server of enterprise, the Web inquiry system can put into operation;

When 4. carrying out the Web inquiry, will control the menu definition parameter of master meter according to system, the tables of data indexing parameter, Web page name parameter dynamically generates Web inquiry menu and Web query page.

Description of drawings

Fig. 1 is to use development platform development data storehouse application system process flow diagram.

Fig. 2 is the editing interface 1 of system's control master meter.

Fig. 3 is the editing interface 2 of system's control master meter.

Fig. 4 is the editing interface 3 of system's control master meter.

Fig. 5 is the editing interface 4 of system's control master meter.

Fig. 6 is the editing interface 5 of system's control master meter.

Fig. 7 is a menu background process disposal route table editing interface 1.

Fig. 8 is a menu background process disposal route table editing interface 2.

Fig. 9 is a menu background process disposal route table editing interface 3.

Figure 10 selects input method table editing interface.

Figure 11 is a table record filter method table editing interface.

Figure 12 is the menu operation permission configuration interface.

Figure 13 is a management object table editing interface.

Figure 14 is that introduction method table editing interface derived in the tables of data record.

Embodiment

In order further to understand content of the present invention, below the present invention is described in detail

Menu member bag

1, the Data Management Analysis of database application system:

The data that database application system is used are divided into two big classes by storage mode: a class is to deposit in data in the database with the tables of data form, is called database data, and another kind of is file data.

Database data is divided into two kinds of the big binary word segment data (data such as text, figure, image, sound) of tables of data and tables of data everyday character segment datas (numeric type, character type, date type data) again.

To the use of file data, adopt the management data table filename usually, call the method for file data according to filename and file storage path.

Database application system is made up of function menu one by one, arbitrary function menu of application system, nothing more than being in these several different data types one or more to be read out be shown to computer screen from database or file storage medium, be to browse or edit on the term ' forms ', carry out some back-end data works of treatment again, at last execution result is saved in database or the file.

2, the tables of data interrelational form of menu use:

The arbitrary menu of database application system may use single tables of data, also may use a plurality of tables of data with incidence relation, and sorting technique is as follows:

8. single tables of data is also referred to as ' single master meter '.

9. two-layer subordinate incidence relation table: be called for short by ' boss's table '; Two-layer table is called ' master meter ' and ' sublist ', and sublist is the subordinate list of master meter, and many records of sublist are subordinated to a record of master meter; Subordinate list can be one or more, is called when a plurality of ' and subtabulation '.

Example: transformer station's record on duty: with Field Definitions such as power transformation name of station, order of classes or grades at school on duty, dates on duty is master meter, and a plurality of attribute fields of the job record of each value are defined as sublist as the working time, action etc.; Then many job records of a certain value some day are subordinated to a record of master meter in the sublist.

10. three layers of subordinate incidence relation table: be called for short ' boss, sublist '; Three layers of table are called ' master meter ', ' sublist ', ' sublist ', and sublist is the subordinate list of master meter, and many records of sublist are subordinated to a record of master meter, and sublist is the subordinate list of sublist, and many records of sublist are subordinated to a record of sublist; Subordinate list can be one or more, and sublist is called ' and subtabulation ' when being a plurality of, and sublist is called ' sublist arranged side by side ' when being a plurality of.

 coordination master meter: single tables of data, the literary name section is more, and the different forms of different fields use, in order to design conveniently, accelerates the meter reading writing speed, and it is decomposed into a plurality of tables; One of them table is called ' master meter ', and all the other a plurality of tables are called ' master meter side by side ', and the record number of each table is identical with master meter record number in the master meter side by side, and each bar writes down a record of corresponding master meter.

Example: annual work gathers and is divided into a plurality of fixing pages, and every page has the different projects that gathers, and field is too many when using a tables of data to preserve, and it is slow to call speed; Employing is provided with a tables of data and solves this problem the project that gathers of each page, and the tables of data of each page use record is unified to call according to incidence relation again simultaneously.

 coordination master meter and subordinate sublist: one or more sublists are subordinated to the master meter in the coordination master meter, and many records of sublist are subordinated to a record of master meter; Sublist is called ' and subtabulation ' when being a plurality of.

 index incidence relation table: a tables of data is the application system base data table, as ' the name set table of thing ' or ' people's name set table ', another table is the fructification attribute description table of all entities of basic data table record, and this table record bar number is far more than base data table record strip number; Base data table is called ' concordance list ', fructification attribute description table is called ' master meter '; Call speed in order to accelerate the master meter record, the key value that the use concordance list is described entity is as index, and the incidence relation that the key value that uses according to two table description entities equates calls the master meter record, is called ' index incidence relation '.

Example: there is hundreds of bar transmission line of electricity in certain electric company, uses tables of data ' transmission line of electricity namelist ' storage line properties; Every circuit has tens bases to hundreds of base shaft tower, uses tables of data ' shaft tower detail list ' storage shaft tower attribute; The shaft tower detail list has several ten thousand records, and is slow several times when directly calling; When inquiry shaft tower attribute, as concordance list, ' shaft tower detail list ' is as master meter with ' transmission line of electricity namelist ', line name is as index key, call the shaft tower record of shaft tower detail list corresponding line according to selected line name, then record is few, and it is fast to call speed.

 source incidence relation table: use ' base data table ' record of some application systems or ' industry standard tables of data ' record increases record newly as other tables of data Data Source, to accelerate input speed and assurance data consistency, these base data table or industry standard tables of data are called as ' source table '; Call the source table record according to the source table with by the incidence relation between editor's table during execution, be called ' source incidence relation '.

Example: tables of data ' well-known doctor's prescription table ' as the source table, is called ' well-known doctor's prescription table ' record according to the doctor's name and the prescription name of patient's prescription, and the Data Source of newly-increased record when writing out a prescription as the input patient then can be accelerated input speed and guarantee data consistency.

3, menu is to the use-pattern of tables of data:

Menu is divided into following 9 kinds to the use-pattern of tables of data:

3. single tables of data, coordination master meter, coordination master meter and subordinate sublist, two-layer subordinate incidence relation table or three layers of subordinate incidence relation table table record are inquired about or edited.

2. be the reduced data typing, guarantee data consistency, when writing down, use the source table record as the newly-increased Data Source that writes down of these tables to master meter, sublist or the sublist of single tables of data, coordination master meter, subordinate incidence relation are newly-increased; Can once increase the record that the source table satisfies the record number of system's control table rated condition newly, or the record of the source table record number of selected at random; And according to system's control table regulation, one or more field values that the source epiphase should be write down copy the newly-increased corresponding field that writes down of these tables to.

Example: aforementioned input patient prescription, select certain prescription of ' well-known doctor's prescription table ' certain well-known doctor after, arrive patient's prescription table with a plurality of or whole medicinal material titles records in the prescription are newly-increased, and copy the quantity and the unit price of selected medicinal material.

3. call speed for accelerating table record, use concordance list when the table record of single tables of data is inquired about or edited.

4. single tables of data by system's control table regulation sorting field, gather field and field gathers mode, table record is carried out random assortment gathers; By user's one or more sorting fields of appointment at random, the different value of getting according to sorting field, or the classification value of appointment at random or classification value scope carry out statistic of classification and gather during execution.

Example: the substation equipment machine account, sorting field is: power transformation name of station, device class (main transformer, sf6 isolating switch, oil-break, vacuum circuit breaker, voltage transformer (VT), current transformer etc.), gather field and be ' original value of the equipment ', the mode that gathers is ' summation '; When the sorting field of user's appointment is the power transformation name of station, then by each transformer station's tabulating equipment initial value; When the sorting field of appointment is device class, then by each device class tabulating equipment initial value; During as the sorting field of appointment, then gather all original values of the equipment of this transformer station when selected a certain transformer station and with device class by device class.

5. single tables of data record carries out the random assortment inquiry by system's control table regulation sorting field to table record; The classification value or the span of one or more sorting fields of appointment are inquired by classification at random by the user during execution;

Illustrate: the random assortment inquiry is identical with the sorting technique that random assortment gathers use, but the result who obtains satisfies the tables of data record of querying condition.

6. single tables of data is by the date field of system control table regulation ' by the period statistics ', to table record carry out by the period statistics with gather; During execution by the user to this field at random the time segment limit of appointment be met the tables of data record of period condition, and the close item purpose of carrying out system's control table regulation gathers calculating.

Example: a certain tables of data is generated year, monthly, season, ten days, week, day statistical report form automatically, or the time interval statistical report form of input at random.

7. single tables of data selects one or more record as certain purposes by the user as required.

Example: when editor's outbound is single, some goods and materials that need access in the warehouse are picked out.

8. single tables of data is by system's control table regulation ' entity sorting field ' and deposit ' time that entity state changes ' field name, determine the substantial definition method of table record according to the entity sorting field, inquire about entity state and the state of each entity before arbitrary closing time and change the time.

Example: the fixed time is certain month of certain year, ' state is moved back in throwing ' of all low frequency loadshedding equipments of transformer station reaches ' time of origin of throwing for the last time or moving back ' to statistics ' transformer station's low frequency loadshedding equipment is thrown and moved back table ' when this end of month, here, ' power transformation name of station ' and ' low frequency loadshedding equipment title ' is the entity sorting field, and ' time of origin of throwing or moving back ' is ' time that entity state changes ' field.

9. to a certain record of user's selected at random in the single tables of data, find out other relative recording in this tables of data by ' the judging the field name that value equates ' of system's control table regulation and ' the field value comparison condition ' of system's control table regulation, carry out a certain work.

Example: in ' in the customer order table ', a certain client's of selected at random a certain order record is inquired about this this order of client date all order record is before taken place; Here, ' customer name ' field name for judging that value equates, ' order took place before the date ' is the field value comparison condition of regulation.

4, the form types of menu use:

The menu forms are classified by following ' forms method of calling ', ' data type that forms use ', ' forms form ', be called ' form types that menu uses ';

2. the forms method of calling is divided into following 6 kinds:

● master menu calls, and is called ' master menu forms ';

● button menu calls, and promptly the window function button calls, and is called ' button menu forms ';

● the paging menu call, call by the paging menu identity, be called ' paging forms '; Example: annual work gathers as described above a plurality of fixing pages, and every page has one ' Page Name ', and as each page of menu call, each page uses paging forms with ' Page Name ';

● OLE calls forms; Example: call CAD figure, the forms that WORD document etc. use.

● the third party software embedded functional calls forms; Example: the map forms that a certain menu of application system embeds when using Geographic Information System (GIS) software.

● the self-editing executable program of user calls forms.

2. the data type of forms use is divided into following 4 kinds:

● only use the big binary word segment data of tables of data;

● use numerical value, character, date type-word segment data and the big binary field view data of tables of data; Example: resume embeds photo;

● use file data.

3. the forms form is divided into following 6 kinds:

● the resume formula forms of a tables of data, forms only use record of tables of data, are called ' unirecord forms ', are called for short by ' list ';

● in the same menu, the inhomogeneity of tables of data record uses different unirecord forms, is called ' optional unirecord forms ', is called for short ' menu '; Be divided into and use index value menu, mouse to double-click a certain record in many records, write down two kinds of the field value menus of a certain regulation according to this;

Example: the device type of substation equipment machine account comprises main transformer, isolating switch etc., and the machine account parameter of main transformer and isolating switch is different, uses different unirecord forms; When editor, inquiry substation equipment machine account, if main transformer uses main transformer unirecord forms, if isolating switch uses isolating switch unirecord forms;

● a tables of data is called ' writing down forms ' by many record forms that row shows more, is called for short ' many ';

Can respond simultaneously ' mouse is double-clicked many recording events ' and call unirecord forms or the optional unirecord forms of being double-clicked the record correspondence, response ' mouse-click is returned many record buttons ' incident is returned many record forms;

● many fields that the record field value is identical under the single master meter one-level index are placed on forms top, the forms bottom is placed by row and is got many records of different value field, be called ' the band gauge outfit writes down forms ' more, be called for short ' taking the lead ' more, the field on forms top is called ' gauge outfit ';

' mouse the is double-clicked many records ' incident that can respond is simultaneously called and is double-clicked the corresponding unirecord forms of record, and response ' mouse-click is returned many record buttons ' incident is returned the band gauge outfit and write down forms more;

Example: during by department's inquiry, printing employee register, department's name is placed on forms top as gauge outfit, the same employee's of department many records are placed on the forms bottom by row.

● the master meter unirecord is placed on forms top, and many records that sublist is subordinated to this record are placed by row in the bottom; Or the unirecord of forms top placement sublist, many records that sublist is subordinated to this record are placed by row in the bottom; Be called ' going up single many forms down ', be called for short ' going up single many down ';

' mouse the is double-clicked many records ' incident that can respond is simultaneously called and is double-clicked the corresponding unirecord forms of record, and response ' mouse-click is returned many record buttons ' incident is returned single many forms down; Or response ' mouse double-click many record ' incident calls and double-clicked the corresponding button menu forms of record, response ' mouse-click is returned main menu button ' incident, return single under many forms;

Example: transformer station's record on duty as described above, fields such as the power transformation name of station of master meter, order of classes or grades at school on duty, date on duty are placed on forms top, and many job records of each value are placed in the bottom by row;

● respectively place the forms of record more than about forms, be used for the choosing record as certain purposes, left side record forms to be selected, the record forms are chosen on the right, are called ' left and right sides forms ';

Response ' mouse is double-clicked record ' incident makes to be recorded between the forms of the left and right sides and moves (double-click a certain record of left side forms, this record moves to the right forms, double-clicks a certain record of the right forms, and this record moves to left side forms); Can once select one, many or whole record the in the record forms to be selected of the left side as required, move on to the right and choose the record forms as choosing record;

Two forms can use same tables of data, also can use the different pieces of information table;

Example: edit the outbound list as described above, left side forms are optional goods and materials record in the warehouse, and the right forms are for choosing the goods and materials record, and a certain goods and materials record execution of the mouse double-click left side or the right forms is chosen or abandoned.

5, menu member bag design concept:

Above-mentioned ' the tables of data interrelational form that menu uses ', ' menu is to the use-pattern of tables of data ', ' form types that menu uses ' are the sorting technique of development platform to menu execution data processing, are called ' menu data processing type '.

Development platform is classified to the database application system menu by menu data processing type, and each class menu uses an execution module, is called ' menu member bag '.

Menu member bag adopts the method for designing that is similar to function, and call parameters is used system's control table storage of development platform, reads these parameters during the application system operation, dynamically generates run time version, finishes menu function.

Menu member bag is based on the execution module that menu data is handled the exploitation of type aspect, so all menus that database application system belongs to same data processing type can use same menu member bag, has realized that module reuses requirement.

6, menu member bag is to the standard designing requirement of tables of data:

Call speed and be convenient to the design of menu member bag in order to accelerate table record, development platform has following standard designing requirement to the tables of data of using system:

1. to all tables of data of menu use, major key (primary key) and external key (foreign key) all are defined as integer type, and use unified major key, external key and main external key correlating method, and method for designing is as follows:

Single master meter, master meter, master meter arranged side by side, unique major key xuhao;

Sublist and subtabulation, two major key xuhao, xuhao1;

Sublist, sublist arranged side by side, three major key xuhao, xuhao1, xuhao2;

Sublist and subtabulation, master meter external key arranged side by side are master meter major key xuhao;

Sublist, sublist external key arranged side by side are sublist major key xuhao, xuhao1;

Major key xuhao, xuhao1, xuhao2 all are defined as integer type.

3. subordinate incidence relation table (boss table, boss, sublist), coordination master meter, coordination master meter and subordinate sublist, according to main external key to subordinate list and side by side the table record of master meter use cascading delete; Index incidence relation table and source incidence relation table do not use cascading delete.

3. the various types of data table that menu is used all increases by two numerical value type-word sections, a character type field, and date type-word section, and use unified field name, and being used for the human editor identity and the newly-increased record date of the newly-increased record of store data table, the field name of use is as follows:

Ejbmbh1: department's numbering of human editor; Bzbh: teams and groups' numbering of human editor; Operator: personnel's numbering of human editor; Operdate: newly-increased record date;

Preceding two is the numeric type field, and operdate is a date type-word section, and operator is the character type field;

When increasing table record newly, put above-mentioned four field values with login people's identity and system time, be used for using by operator's identity filter table record or other function.

7, development platform has designed 20 menu member bags altogether, is listed below:

(1) one table one page forms member bag is called for short w_1table_1page, uses a tables of data, and function is as follows:

● to the master meter of single master meter, two-layer and three layers of subordinate incidence relation, carry out table record inquiry, editor; The forms that use are divided into four kinds: write down forms, the band gauge outfit writes down forms, unirecord forms, optional unirecord forms more more;

● single master meter record is exported as Excel table data;

● Excel is shown data importing to single master meter;

● a certain field value of single master meter is carried out batch replacement.

(2) boss shows forms member bag, is called for short w_zhu_zi; Use two-layer subordinate incidence relation table: a master meter and a sublist; Function is as follows:

● the master meter field is made index, and single many forms are down inquired about, edited master meter record and sublist subordinate record in the use;

● master meter and sublist field are made index, use the unirecord forms, and optional unirecord forms write down forms antithetical phrase table record more and inquire about, edit.

(3) boss, sublist forms member bag are called for short w_zhu_zi_zizi; Use three layers of subordinate incidence relation table: a master meter, a sublist and a sublist; Function is as follows:

● master meter and sublist field are made index, single many forms down in the use, and antithetical phrase table record and sublist subordinate record are inquired about, are edited;

● master meter and sublist field are made index, use the unirecord forms, and optional unirecord forms write down forms more, and sublist or sublist record are inquired about, edited.

(4) master meter, many sublists, sublist paging forms member bag are called for short w_zhu_duozi_zizi; Use three layers of subordinate incidence relation table: master meter and subtabulation and sublist arranged side by side; Use paging menu identity, master meter and sublist field to make index, different table classes or different table classes are made up: master meter, sublist, sublist, master meter and sublist, sublist and sublist, use the paging forms to inquire about, edit;

The paging forms can be unirecord forms, optional unirecord forms, write down forms more, go up single many forms down;

The paging forms can use secondary paging forms, are called by secondary paging menu identity;

Example: three layers of subordinate incidence relation table are used in transformer station's service work: ' service work planning chart ' is master meter, ' teams and groups' personnel assignment table ', ' teams and groups' work ticket table ', ' teams and groups' material is received table ' are and subtabulation that ' material list ' is the subordinate sublist of ' teams and groups' material is received table '; ' power transformation name of station ', ' date of survey ' and the paging menu identity of use and maintenance work schedule: ' teams and groups' personnel assignment ', ' work ticket ', ' material requistion ' are as index;

At first obtain master meter key word xuhao value according to power transformation name of station, the date of survey selected, the incidence relation according to master meter, sublist, sublist filters sublist, sublist record then;

If select paging menu ' teams and groups' personnel assignment ', then use the many records that write down forms inquiry teams and groups personnel assignment more;

If select paging menu ' work ticket ', then with ' teams and groups' name ' of teams and groups' work ticket table as the next stage index, use the unirecord forms to inquire about the unirecord of the work ticket of each class;

If select paging menu ' material requistion ', ' the teams and groups' name ' of then teams and groups' material being received table is as the next stage index, after selecting teams and groups' name, ' material requistion front cover ' forms that show this class material requistion, show secondary paging menu identity above the forms: ' material requistion front cover ' and ' material specification ', choosing ' material specification ' then uses many record forms to inquire about many records of this teams and groups' material specification, material requistion front cover forms are returned in choosing ' material requistion front cover '.

(5) multilist multipage forms member bag is called for short w_ntable_npage;

The table that uses is divided into 4 kinds: 1. coordination master meter, 2. master meter with and subtabulation, 3. coordination master meter and sublist, 4. single master meter;

The forms that use: paging forms; Each paging forms can use one or two table;

Forms form: the unirecord forms, write down forms more, go up single many forms down;

Function: 1. use master meter field and paging menu identity to carry out index, call corresponding paging forms, carry out inquiry, editing operation to different table or same table different field; 2. use the newly-increased master meter record of source table, use source literary name section and paging menu identity to carry out index, call corresponding paging forms, carry out inquiry, editing operation different table or same table different field;

Example: annual work gathers and uses the coordination master meter as described above, also has one ' individual event work sublist ', store each year work gather in many records of this individual event work; The Page Name that annual work is gathered a plurality of pages is as each page of menu call, and each page uses paging menu forms; When calling this ' individual event work ', use many record forms, when calling other page, use the unirecord forms.

(6) use source table editor's master meter or the inquiry of use concordance list, editor's master meter, master meter forms member bag is called for short w_ly_zhu; Use a master meter and a source to show or a master meter and a concordance list; Use master meter to write down forms, unirecord forms or band gauge outfit more and write down forms more;

Function: 1. use source table and master meter field to make index, or only use source literary name section to make index, carry out and use the newly-increased master meter record of source table; 2. use the concordance list field to make index, master meter is inquired about or edited.

(7) use source table editor sublist, boss shows forms member bag, is called for short w_ly_zi; Use a master meter, a sublist and a source table; Use boss to show single many forms down;

Function: use master meter to make index, call the source table record, carry out and use the newly-increased sublist record of source table according to master meter and source table incidence relation.

Example: all have a plurality of equipment to join when each transformer station relieves, the equipment that each transformer station need join is stored with a source table, power transformation name of station and changeover time are stored with master meter, the equipment state when joining is each time stored with sublist; Then when the master meter of relieving of a newly-increased transformer station write down, just the armamentarium that need join from source this transformer station of table copy recorded sublist.

(8) the newly-increased master meter record of source table choosing record, left and right sides forms member bag is called for short w_ly_xz_zhu; Use a master meter and a source table; Use left and right sides forms;

Function: source table and master meter field are made index or are only used source literary name section to make index, carry out and use the newly-increased master meter record of source table choosing record; Source table record to be selected uses left side forms, and the newly-increased record of master meter uses the right forms.

(9) master meter left and right sides forms select the recording member bag, are called for short w_zhu_xz_zhu; Use a master meter; Use left and right sides forms;

Function: the master meter field is made index, selects record, left side forms record to be selected, and the right forms are chosen record.

This member bag can be used as master menu and uses, and also can be used as button menu and uses.

(10) the newly-increased sublist record of source table choosing record, left and right sides forms member bag is called for short w_ly_xz_zi; Use a master meter, a sublist and a source table; Use left and right sides forms;

Function: the master meter field is made index, uses the newly-increased sublist record of source table choosing record; Left side forms source table record to be selected, the right forms sublist increases record newly.

(11) the newly-increased sublist record of source table choosing record, left and right sides forms member bag is called for short w_ly_xz_zi zi; Use a master meter, a sublist and a source table; Use left and right sides forms;

Function: master meter, sublist field are made index, use the newly-increased sublist record of source table choosing record; Left side forms source table record to be selected, the right forms sublist increases record newly.

(12) the source table is related with master meter, inquiry editor boss relation table record, and last single many forms member bag down is called for short w_ly_zhu_zi; A master meter, a sublist and a source table; Use boss to show single many forms down, forms top is the master meter unirecord, and the bottom is the many records of sublist subordinate;

Function: 1. use source table record newly-increased master meter record, editor boss's table record then; 2. use source literary name section as index, according to source table and master meter incidence relation, inquiry master meter, sublist record.

(13) random assortment gathers the member bag, is called for short w_grop_by_total; Use the forms of record more than, the classification value selector button of sorting field is placed on forms top, and the classification summary record is placed in the forms bottom;

Function: single master meter does not all repeat value by each field of a plurality of sorting fields that the user selects, or the classification value of selecting, table record is carried out random assortment, and wherein the type sorting field can be selected as required the date: per year, by half a year, quarterly, monthly, by first quarter moon, by ten days, by week, per diem, on time, classify by the time-division; And the numeric field of a plurality of regulations is carried out classification gather, or statistic record number; Method of summary comprises: summation, ask average, and maximizing is minimized, and asks variance; Automatically generate the classification summary record during execution.

(14) random assortment inquiry forms member bag is called for short w_grop_by_query, uses the forms of record more than, and the classification value selector button of sorting field is placed on forms top, and the record that satisfies querying condition is placed in the forms bottom;

Function: the classification value that each field in a plurality of sorting fields that single master meter is selected by the user is got, or the date type sorting field span of input at random filters table record as the table record filtercondition, is met the record of querying condition.

Date sorting field span can be used: 1. a certain year, 2. a certain year: the first half of the year, the second half year, certain season, certain January, 3. certain January: a certain ten days, a certain week, a certain day, 4. before a certain day, 5. after a certain day, 6. between two dates, 7. specify the not same month in the same year, 8. specify same day of different months of the same year not;

' specifying the not same month in the same year ' example: the record of the generation in Dec that a certain tables of data is all;

' specifying the not same day in different months of the same year ' example: the record that a certain tables of data took place in all 1 day.

(15), be called for short w_ly_zi_by_date_total by period statistical summaries member bag; Single down many record forms in the use; Depositing the date type-word section of carrying out statistics is specified by system's control table;

Function: single master meter is by the statistical time range of importing at random, and the his-and-hers watches record filtering is met the table record of statistical condition, and the classification of carrying out specific project gathers; Single many forms down in the use; Forms top is statistical time range and gathers project that the forms bottom is the many records of entity that satisfy the statistical time range condition;

Example: various years, monthly, season or period statistical form at random.

(16) end of term entity state inquiry component bag is called for short w_ly_zhu_date_last; Use many record forms;

Function: to single master meter, determine the substantial definition method of table record by the entity sorting field of system's control table, by the time field name of the date type index field designated entities particular community state variation of system's control table, by time in the end of term classification of the date type-word segment index mode designated entities state variation inquiry of system's control table; Date type-word segment index mode can be a year, month, day, and corresponding time in end of term classification is respectively: by a certain year last daies 24 point, by certain last daies 24 in January point, by a certain day 24 points;

During execution with the Time To Event index value as end of term time conditions, inquire about each entity particular state and last state before should closing time be changed the time of taking place;

Example: by certain of some last daies 24 in January, ' opening ' of the whole switches of transformer station or ' closing ' state, and last ' opening ' or ' closing ' time of origin.

(17) search selected at random entity correlation table recording member bag, be called for short w_ly_zhu_dt_filter_zhu;

Function: a certain record of single master meter user selected at random, substantial definition field value and the comparison condition stipulated by system's control table filter out the relative recording of choosing entity.

Use a master meter and a source table; Forms, the alternative many records in top, the following many records relevant with choosing record;

Example:, inquire about this this order of client date all order record before take place in a certain client's of ' in the customer order table ' selected at random a certain order record.

(18) call big scale-of-two and file data member bag, be called for short w_call_blob_file; Function: file data is write the big binary field of tables of data, the big binary field data of tables of data are converted to file, big binary word segment data of tables of data or file data execution OLE are called;

(19) third party software component invoking bag:, third party software is carried out embedded functional call by the data of system's control table definition menu and use.

(20) the self-editing independent executable program component invoking bag of user uses menu call, carries out user's self-compiling program, but can not use the data by system's control table definition.

Annotate 1: in the above-mentioned menu member bag: w_1table_1page, w_zhu_zi, w_zhu_zi_zizi, w_ly_zhu, w_ly_zi, w_ly_xz_zhu, w_zhu_xz_zhu, w_ly_xz_zi, w_ly_xz_zizi, w_ly_zhu_zi can use button menu, and master menu tables of data and button menu tables of data or file data are inquired about, edited.

Annotate 2: each master menu of application system all uses in above-mentioned 20 menu member bags as required; Button menu all is not provided with the member bag name of use except that using ' OLE calls forms ' and using the member bag of ' left and right sides forms '; The member bag name that the paging menu only needs the master menu definition to use.

System's control table

1, the design concept of system's control table

The global design thought of development platform is to adopt the method for designing be similar to function, with all functions modular design of the database application system execution pattern for the parameter call of being deposited by outer carrier.

The systemic-function of database application system is made up of function menu one by one, and in arbitrary moment of system's operation, any user only may use a function menu, belongs to the discrete way operation.The record format of relational database tables of data can satisfy the parameter designing requirement of database application system menu discrete way operation.

Development platform is called ' system's control table ' with a plurality of tables of data of the relational database of memory function module call parameters, to the design of system's control table, following 3 basic demands is arranged:

1. She Ji parameter satisfies the demand of describing the application system architecture and carrying out menu member bag;

2. the definition of the parameter ambiguity that do not have, the explanation to these parameters during calling functional modules is unique;

3. editor and the modification to parameter is easily.

2, database application system architecture characterising parameter and menu function characterising parameter are avoided ambiguous method for designing:

(1) database application system architecture characterising parameter and menu function characterising parameter fundamental type are divided into: three kinds of non-enumeration type parameter, enumeration type parameter and expression arguments are described as follows:

1. non-enumeration type parameter comprises two kinds of numeric parameter and string arguments, and numeric parameter uses the integer definition, and string argument is used the character string definition; For example, write down the record line number of forms more and use the integer definition, menu identity, the data table name that menu uses etc. use the character string definition.

2. enumeration type parameter: the value number of parameter is denumerable, then parameter enumeration type parameter-definition; The enumeration type parameter value uses the integer sequence number definition of sign enumerated value.

Example: ' menu background process disposal route table ' write record mode is divided into six kinds, and is as follows with the enumeration type parametric description: 0 judges whether to withdraw from and calls, 1 newly-increased record, and 2 amendment records, 3 deletion records, 4 have record modification, and no record increases newly, and 5 call data base procedure; Parameter value uses enumerates sequence number: 0,1,2,3,4,5 definition; As: parameter value equals at 1 o'clock for ' newly-increased record ', can not produce ambiguity when editing parameter and module invokes.

3. expression argument: identical with the expression formula define method that uses in the database SQL statement, as the filtercondition expression formula of data table record.

(2) concrete regulation to parameter-definition is as follows:

First: non-enumeration type numeric parameter uses the agreement separator to separate with integer or integer sequence definition, the integer in the integer sequence.

Second: non-enumeration type string argument character string, character string sequence or text definition; Wherein character string sequence is used for a plurality of character strings, separates with the agreement separator between the character string.

Example: the data table name that menu uses defines with character string; The character string sequence definition that a plurality of index field names of tables of data separate with comma; The operation of menu helps to use text definition.

The 3rd: the enumeration type parameter is enumerated the integer definition of sequence number with sign.

The the 4th: when parameter is conditional expression, date expression formula, numerical expression, character expression, statistical computation expression formula, use the corresponding expression formula definition in the database SQL statement; Be called ' expression argument '.

The the 5th: when a parameter is used a plurality of enumeration type subparameter, be called ' enumeration type subparameter ', define this parameter with integer sequence or with an integer; When defining with integer sequence, the subparameter number equals the integer number of integer sequence, uses the agreement separator between the integer in the integer sequence separately, the corresponding subparameter of each integer; When with an integer definition, the subparameter number equals the figure place of integer, the corresponding subparameter of each of integer; Notice that when using an integer definition, enumerated value can not be above 9.

Example 1: the enumeration type parameter is used in the ordering of tables of data record: 1 ascending order, and 2 descendings, and define a plurality of field sort methods with an integer; When using a field ordering, parameter is 1 integer; When using two field orderings, parameter is two integers, first field sort method of ten bit-identifies of integer, second field sort method of individual bit-identify; A certain tables of data has two sort field: field1, and field2, field field1 are by descending sort, and field field2 is by ascending sort, and then parameter is used integer ' 21 ' sign.

Example 2: the date field indexed mode uses the enumeration type parameter: 1 year, and 2 half a year, the third quarter, April, 5 first quarter moons, 6 ten days, 7 weeks, 8 days, 9 time-divisions, and define with integer sequence; A certain tables of data has a date index field date1, and first order index is index per year, and second level index is index per diem, and then parameter is used integer sequence ' 1,8 ' sign.

When six: one parameter used a plurality of available enumeration type parameter, be called ' enumeration type optional parameter ', use not numeral 01 sequence definition with separator, the figure place of 01 sequence equals the optional parameter number, each corresponding 1 optional parameter, a certain position equals 1, and sign is used the optional parameter of this correspondence, equal 0, sign is not used the optional parameter of this correspondence.

Example: the table record Edit button uses 8 bit digital, 01 sequence definition, each corresponding Edit button of 01 sequence is defined as: 1 newly-increased master meter record, 2 deletion master meter records, 3 newly-increased sublist records, 4 deletion sublist records, 5 newly-increased sublist records, 6 deletion sublist records, 7 preserve, and 8 abandon editor;

When a certain position of 8 bit digital, 01 sequence equals 1, then use the Edit button of this correspondence, a certain position equals 0, does not then use the Edit button of this correspondence.As: 01 sequence definition is ' 11000011 ', and then the Edit button of Shi Yonging is: newly-increased master meter record, deletion master meter record is preserved, and abandons editor.

Seven: one parameter used a plurality of subparameters, and subparameter can be non-enumeration type parameter, enumeration type parameter or expression argument, and the separator with agreement between the subparameter separates, and is called ' combination parameter '.

The the 8th: when using character string, character string sequence, integer sequence or expression formula to define, use the identifier of agreement to draw together their, be labeled as a subparameter as if a certain subparameter in the combination parameter.

The the 9th: when the parameter of describing with combination parameter has two kinds and two or more different usage, use the identifier of agreement to draw together the combination parameter of each using method, separate with the separator of arranging between the method.

Example: menu forms date type-word section display format is defined as: [table class, { year field name tabulation }, { field name tabulation on days }, { date field name tabulation }, { the field name tabulation of time-division date }];

Wherein ' table class ' is the enumeration type subparameter, states ' the enumeration type parameter that system's control table is public ' as follows, the character string sequence definition that all the other subparameters are drawn together with { }; The format parameter of each table class of menu forms is drawn together with [], and the format parameter of a plurality of table classes separates with comma.

The the tenth: the enumeration type parameter that system's control table is public:

1. ' table class ', the tables of data that tables of data that the menu forms use or execution reading and writing are manipulated: 1 master meter, 2 sublists, 3 sublists, 4 source tables, 5 master meters arranged side by side, 6 and subtabulation, 7 sublists arranged side by side, the new master meter of 8 button menus, the new boss's table of 9 button menus, 10 menu member bag W_zhu_xz_zhu left side forms tables.

Illustrate: with corresponding ' table name ' parameter identification, the tables of data that tables of data that the menu forms use or execution reading and writing are manipulated is called corresponding tables of data with ' table class ' sign according to ' table class ' to the data table name that menu uses in system's control table; As: the table class equals 1, then calls the tables of data of ' master meter name ' sign.

2. ' public variable ' preserves the global variable of login people identity: 1 department's name, 2 teams and groups' names during the application system operation, 3 names, 4 teams and groups' classes, 5 order of classes or grades at school on duty, 6 system datas, 7 system times, 8 tier-2 department's names, the set name of the thing of 9 management, the people's of 10 management set name, 11 department's classes, 12 logouts of taking turns at keeping watch number, 13 departments number, 14 classes of group numbers, 15 unit names.

3, system's control table overall design

The data processing object of database application system is divided into four layers: function menu, tables of data, table record, literary name section; System process is divided into two big classes: foreground process and background process; System's control table is exactly the difference requirement set handling parameter by this four layer data processing of database application system and two type systematic processes.During design system's control table stored parameters is divided into three major types: system master parameter, system supplymentary controlled variable, menu background process processing execution method parameter; Wherein preceding two classes belong to application system architecture characterising parameter and call the manner of execution parameter of the utility function of menu member Bao Shiying realization, and back one class is to finish the manner of execution parameter that menu background process specific function is handled.

The system master parameter is used a data table stores, is called ' system's control master meter ';

The system supplymentary controlled variable is used six data table stores, is respectively: ' the menu authority is provided with table ', ' table record filter method table ', ' selecting the input method table ', ' management object table ', ' tables of data primary key xuhao maximal value table ', ' the introduction method table derived in the tables of data record ';

Menu background process disposal route parameter is stored by ' menu background process disposal route table '.

Each system's control table primary key all is defined as integer type;

Primary key by system's control master meter: menu sequence number, menu forms sequence number, secondary paging menu sequence number and other control table are carried out related, and the tables of data record filtering that the menu operation authority when being used to carry out menu, menu use, editor call and select typing, the call parameters when calling the background process processing.

4, system's control master meter design

4.1 menu classification and primary key

The menu that database application system is used is divided three classes: master menu, button menu, paging menu.

Arbitrary menu can have only a master menu; Also can comprise a master menu and a plurality of button menu; Or comprise a master menu and a plurality of paging menu; The paging menu also can have a plurality of secondary paging menus; Paging menu and button menu general designation ' submenu '.

Totally 3 of primary keys: menu sequence number, menu forms sequence number, secondary paging menu sequence number.

' menu sequence number ' is used to identify different master menus; The a plurality of button menus or the paging menu that belong to same master menu are distinguished with ' menu forms sequence number ', and ' menu sequence number ' is identical with master menu; Secondary paging menu is distinguished with ' secondary paging menu sequence number ', and ' menu sequence number ' is identical with master menu, and ' menu forms sequence number ' is identical with the paging menu.

The menu forms sequence number regulation of master menu equals 1, and the menu forms sequence number regulation of submenu is greater than 1.

Application system when operation, the executive system control table menu forms sequence number master menu record that equals 1 at first, and then executive button menu or paging menu; Do not equal 1 menu record if a certain ' menu sequence number ' has ' menu forms sequence number ' down, then ignore whole records of this ' menu sequence number '; Menu forms sequence number that can master menu is set to be less than or equal to 0, and sign master menu and subordinate's submenu wouldn't use, if want to enable this menu, changes this parameter into 1 and gets final product; But if deleted a certain menu record, want to reactivate, then must update menu parameter.

4.2 menu identity parameter and operation instruction

The parameter of using: one-level menu identity, second-level menu name, three-stage menu name, level Four menu identity, Pyatyi menu identity, and menu sequencing methods at different levels; Pad name and sort method; Button menu or paging menu identity; Secondary paging menu identity.

Menu must have pad name, and preceding Pyatyi menu can be provided with as required; During the application system operation, one-level menu, second-level menu, three-stage menu, level Four menu, Pyatyi menu, master menu and paging menu will generate the menu index tree automatically according to sort method; The button menu name is placed on the function button district of master menu forms top automatically; Secondary paging menu identity is placed on paging forms top automatically.

All menu identities all define with character string; Preceding Pyatyi menu and master menu index order method define with integer; Paging menu index sorts with primary key menu forms sequence number.

4.3 the menu manner of execution is used 4 parameter-definitions:

1. menu executive mode, be divided into three kinds: 1 calls development platform menu member bag, and 2 third party software embedded functionals call, and 3 self-editing executable programs call.

Menu member bag name, third party software name, the self-compiling program name used when 2. carrying out menu; They are corresponding with the menu executive mode.

3. when menu uses W_ly_zhu member bag, can be changed into W_1table_1page member bag and carry out inquiry, use a parameter regulation whether to need such use, 0 is not, and the 1st; Can between inquiry and editor, change during execution, when the login people does not have editing authority, can only use W_1table_1page member bag to carry out inquiry.

4. judgement on duty, 0 is not, and the 1st; Equal at 1 o'clock, the personnel non-on duty that take turns at keeping watch do not allow to use this menu; Equal at 0 o'clock, do not do this judgement; When a certain class personnel have the menu operation authority to some menus, but this parameter is set when needing further regulation to use menu by the personnel on duty that take turns at keeping watch.

4. 3. 1. parameter use the enumeration type parameter-definition, and 2. parameter defines with character string;

Annotate: ' calling development platform menu member bag ' refers to call preceding 18 menu member bags of aforementioned development platform.

4.4 the submenu type is used two enumeration type parameter-definitions:

1. submenu class: 0 no submenu, 1 paging menu, 2 button menus, 3 use the button menus of the newly-increased different purposes records of table for the master menu forms;

2. submenu class 3 increases the record sheet classes newly: 1 master meter, 2 sublists, 3 sublists;

Illustrate 1: paging menu and button menu use forms separately;

Illustrate 2: submenu class 3 is used the master menu forms, and the button menu name of use is used to identify different purposes, clicks the button menu name of a certain purposes correspondence, then gives the record of newly-increased this purposes regulation of master menu forms; As: click ' the normal tour ', increase by one ' the normal record of making an inspection tour ', click ' tour of relieving ', increase by one ' relieve and make an inspection tour record ' to logout to logout.

4.5 tables of data and tables of data using method that menu uses are used 16 class parameter-definitions:

1. menu can use: one or more in master meter, sublist, sublist, concordance list or source table, master meter arranged side by side and subtabulation, the sublist arranged side by side; Preceding 5 are used corresponding table name parameter identification respectively in master menu, as: the master meter that ' master meter name ' sign menu uses; 3 of backs and tabulation only need in master menu with corresponding ' and the table name of tabulating ' parameter identification;

2. the correlating method when using the subordinate incidence relation between the table: master meter and sublist, sublist and sublist;

3. the table class of source table or concordance list association: 0 uses whole records, 1 master meter, 2 sublists, 3 sublists;

4. the correlating method of source table or concordance list and contingency table;

5. source table or concordance list are read the field mode: 1 whole fields, 2 part fields;

6. the field name when source table or concordance list are read the part field;

7. database read table record mode: 1 once runs through whole table records, and 2 once read the part table record;

Annotate: ' once reading the part table record ' refers to read earlier index field, after the user selects index, reads to satisfy index condition record again, to accelerate meter reading speed, be used for ' index incidence relation ' and read the master meter record, or single tables of data record uses more for a long time;

8. subordinate incidence relation boss table and boss, the filtration of sublist table record are in proper order: 1 filters master meter earlier, filters sublist according to incidence relation again, is called for short ' sub behind the former head '; 2 filter sublist earlier, filter master meter according to incidence relation again, are called for short ' the son back is main earlier ';

Annotate: when using login people identity filter table record, if the corresponding sublist of login people identity adopts ' the son back is main earlier ', if the corresponding master meter of login people identity adopts ' son behind the former head ';

9. the index order of each table; (use the ordering of integer identification index, 0, index not ,-1, do not have table);

10. the index field of each table;

11. the date index field of each table;

12. the date field indexed mode is used for fixed date index field index value mode: 1 year, 2 half a year, the third quarter, April, 5 first quarter moons, 6 ten days, 7 weeks, 8 days, 9 time-divisions;

Example: the indexed mode of certain date field is ' 1,4,8 ', then the ground floor index was pressed ' year mode ' index (2000, calendar year 2001 ...), second layer index is by ' days ' mode index (in January, 2000, in February, 2000 ...), the 3rd layer index is by ' date ' mode index (on January 10th, 2000, on January 11st, 2000 ...); ' half a year ' mode example: the first half of the year in 2000, the second half year in 2000; ' season ' mode example: the first quarter in 2000, the second quarter in 2000; ' first quarter moon ' mode example: first half of the month in January, 2000, the second half of the month in January, 2000; ' ten days ' mode example: in early January, 2000, in mid-January, 2000; ' week ' mode will be weekly initial with the date of expiry as index value; ' time-division ' mode adds the time-division after ' day ' mode;

13. one or more sort fields of the table record of each table;

14. the sort method of each list sorting field: 1 liter, 2 fall;

15. the table class of whether carrying out table record number statistics and adding up: 0 does not add up, 1 master meter, 2 sublists, 3 sublists;

Annotate: after having specified the table class of adding up, the one-level index of every this table of selection then is presented at the forms lower left corner with the record number under this grade index;

16. no record information when carrying out menu; Annotate: when pressing filtercondition filter table record, do not have the record that does not satisfy condition, then this information of screen display;

Illustrate:

1. the parameter enumeration type parameter-definition of 3.5.7.8.12.14.15. sign wherein 9. identifies with integer;

2. in 1. and the table name parameter format of tabulating be: master meter name sequence, and subtabulation name sequence side by side, { sublist name sequence arranged side by side };

3. when the menu forms be single data watchband gauge outfit when writing down forms more, master meter and sublist correlating method parameter are used to define the gauge outfit field.

4.6 the forms parameter that menu uses:

1. forms can use one or two tables of data as required, can be: master meter, sublist, sublist, source table, master meter arranged side by side and subtabulation, sublist arranged side by side, new master meter, new boss's table;

The table class of using two parameter identification forms to use: the table class 1 that forms use, the table class 2 that forms use;

Annotate: have only the button menu forms can use new master meter, new boss's table; New master meter name is used the definition of master meter name, and new sublist name is used the definition of sublist name, and new boss shows correlating method and uses master meter and the definition of sublist correlating method;

2. the new master meter contingency table class used of forms: 0 is not related, 1 master meter, 2 sublists, 3 sublists;

3. the correlating method of new master meter and contingency table;

4. forms form: 1 is single, more than 2, double-clicks with mouse more than 3 and call list, many under single on 4, single many down double-click with mouse called list on 5, singly on 6 manyly down double-clicks call buttons menu forms with mouse, more than 7 and mouse double-click menu, taking the lead 9 index menus, 10 left and right sides forms 8 more;

5. whether full screen display of forms: 0 is not, and the 1st;

Annotate: parameter value is 0 o'clock, is normal condition, and promptly the screen left side is an index tree, and the right is forms; Parameter value is 1 o'clock, is defaulted as normal condition, and button click ' full screen display ' then forms occupies full framely, and this button becomes ' demonstration index ', and button click ' demonstration index ' recovers normal condition, and this button becomes ' full screen display ';

6. write down forms record line number more; Annotate: reduce line number, but character display field alphabet;

7. menu forms index progression; Annotate: stipulate which rank of index is the key word of menu forms;

8. the menu forms are got the table class of key value;

9. the menu forms are got the key value field name;

10. menu forms field value tabulation; Annotate: when last field value is ALL, corresponding all the other all field values, a plurality of different values that are used for the key value field are used same forms situation;

11. the forms list of file names of menu forms different value correspondence;

12. forms use and during tabulation and the sequence number of tabulating: master meter sequence number, and subtabulation sequence number side by side;

13. tables of data date field display format;

14. tables of data numeric field display format;

15. boss shows the date common parameter: master meter date field name, sublist date field name, sublist date field classification: January, 2 days, 3 o'clock, 4 time-divisions;

Example: the master meter date category is ' year ', is worth to be ' 1949 '; The sublist date category is ' moon ', and then the sublist date field only shows ' January ', ' February ' ... ' Dec ', but the time on sublist date is identical with master meter; The master meter date category is ' days ', and the sublist date category is ' day ', and then the sublist date field only shows 1-31 day, and days, value was identical with master meter; The master meter date category is ' date ', and the sublist date category is ' time ' or ' time-division ', and then the sublist date field only shows 0-23 point or time-division, and days, the earning in a day was identical with master meter;

16. preserve the dynamic link library name (DLL) of forms;

17. forms name;

18. mouse is double-clicked the unirecord forms name that record calls;

19. the printing reports name that forms use; Double-click forms behind the preceding Main form, comma separates, and one without comma;

Illustrate:

Wherein 1.2.4.5.8. and 15. ' sublist date field classification ' are used the enumeration type parameter-definition, and 6.7.12. defines with integer, and 13.14. defines with combination parameter; All the other parameters define with character string or character string sequence;

13.14. the combination parameter design is as follows:

Date type-word section display format: [table class, { year field name tabulation }, { field name tabulation on days }, { date field name tabulation }, { the field name tabulation of time-division date }]

Numeric type field display format: [table class, decimal digits, format character, { field name tabulation }]

Format character: handle decimal place for 0; 1 is with thousand fens position section breaks; 2 floating numbers are used scientific notation (decimal digits is significant figure); 3 add value of money symbol $; 4 add value of money symbol $; 5 negatives are shown in red; 35 and 45 are two kinds share.

4.7 the function button of menu design:

Function button is divided into: five kinds of Edit buttons, background process call buttons, OLE funcall button, button menu forms call buttons, menu operation help button;

1. Edit button and background process call buttons are totally 10: newly-increased master meter record, deletion master meter record, newly-increased sublist record, deletion sublist record, the sublist record deleted in newly-increased sublist record, preserves, abandon editor, the master meter field value decomposes automatically newly-increased sublist record, and background process calls.

Whether they use the optional subparameter of enumeration types, used by the button of 10 01 sequence identifier correspondences; When equaling 2 for first, the newly-increased simultaneously record of sign master meter and sublist; Master meter does not use ' newly-increased record ' and ' deletion record ' button side by side; And subtabulation, sublist arranged side by side use sublist, sublist Edit button.

10 button names define with character string sequence; The button name can rename as required.

Annotate 1: after having imported a certain field value of master meter, click ' the master meter field value decomposes automatically newly-increased sublist record ' button, the character string sequence that then decomposes this field input gives sublist the newly-increased automatically bar number scale record identical with the character string number of decomposing, and decomposition value is inserted the field of regulation;

Annotate 2: ' background process calls ' button is ' further work process title ' button, as: ' issuing a notice ' after ' notice ' editor finishes etc.; Click this button, then call ' menu background process disposal route table ' this menu record, carry out next process of menu and handle;

Annotate 3: these 10 buttons can rename as required, and manner of execution is constant.

2. OLE funcall button is totally 5: select disk file, file data deposits the big binary field of tables of data in, the big binary data of browsing data table, and big binary data saves as new file, returns the master menu page;

Use 5 corresponding funcall buttons of the optional subparameter sign of enumeration type whether to use;

5 OLE funcall button names define with character string sequence; The button name can rename as required, and manner of execution is constant;

Other parameter of OLE funcall: ' the OLE funcall is got big binary data or got the field name of filename ', ' OLE type field ' ' the OLE funcall is got the path of filename ' and ' preserving the field name of the source filename of big binary data ' are used character string identification respectively.

3. master menu call buttons menu forms button, and button menu forms returns master menu forms button, uses two parameter-definitions: ' button menu name sequence ' and ' 01 sequences of call buttons menu forms ';

' 01 sequence ' first of call buttons menu forms fills out 0 during for master menu; Second begins to fill out 1, corresponding each button menu name, and 1 number equals the button menu number;

Button menu only needs first of 01 sequence and fills out 1, and correspondence is returned the main menu button name;

' button menu name sequence ' identifies its sort method simultaneously;

When button menu did not allow some people to use, by ' button menu do not allow use condition ' parameter identification, this parameter was a conditional expression; Can use data sheet field conditioned disjunction public variable condition, when using the public variable condition, public variable identifies with ' management organization's table ' or ' personnel's duty list ' corresponding field name.

4. third party software embedded functional button uses the button menu definition.

5. ' open the index progression of newly-increased record button ' and ' opening the index progression of background process call buttons ': be used to stipulate that newly-increased record button or background process call buttons allow the index progression that uses, respectively with integer definition (when the index progression of opening during less than the index progression of regulation, the corresponding button is in masked state).

6. the regulation of other operation of shielding behind the newly-increased record button of click is used combination parameter: { the newly-increased button shield type of master meter is tabulated }, { the newly-increased button shield type tabulation of sublist }, { the newly-increased button shield type tabulation of sublist };

Shield type in the combination parameter uses enumeration type argument sequence sign: the newly-increased and delete button of 1 master meter record, newly-increased and the delete button of 2 sublists record, newly-increased and the delete button of 3 sublists record, 4 index trees, 5 button menus, the newly-increased button of 6 master meters record, the newly-increased button of 7 sublists record, the newly-increased button of 8 sublists record, 9 the 9th Edit buttons, 10 background process call buttons; When being empty, parameter do not use shielding.

7. shield the condition of background process call buttons: use combination parameter: table class, { condition }; The table class is ' table class ' parameter, and ' condition ' is conditional expression; When condition is true time shielding ' background process calls ' button.

Whether shield index when 8. editing, use the enumeration type parameter identification, 0 is not, and the 1st.

9. ' menu operation help ', the parameter text definition, screen is released help information when clicking this button.

10. ' data flowchart ', parameter identifies with filename, releases the menu data process flow diagram according to filename when clicking this button.

4.8 the special editting function design of menu forms table record

Totally 6 kinds of special editting functions can be used wherein one or more as required; They are respectively: public variable put in newly-increased record, newly-increased record duplicates, calls and selects typing to put field value, record editor shielding, field editing shielding and field condition editor shielding.

1. login people identity public variable value put in newly-increased record, uses two groups of combination parameters:

Combination parameter 1 form: [table class, and tabulation sequence number, { tabulation of assignment field name }, { the public variable sequence number tabulation of field assignment correspondence }, { the constant value tabulation that field is composed }];

Combination parameter 2 forms: table class, and tabulation sequence number, { compose management object value field name, call the public variable class of management object table record, call the management object name of management object table record }, { reading the entity attribute list of fields of management organization's table }, { writing management organization's entity property value list of fields };

Wherein combination parameter 1 is used for composing login people's identity public variable value and constant value to field, and public variable is the public enumeration type parameter of system's control table; Parameter value equals 0, and field is composed constant value; Parameter value is greater than 0, and field is composed the public variable value; When public variable is: during people's the set name of the set name of the things of 9 management or 10 management, as chosen candidate value, use the method identical to put field value the element of correspondence set with selecting typing.

Example: the tabulation of assignment field name is ' bdzm, xm, lb1, lb2 ', the public variable sequence number tabulation of field assignment correspondence is for ' 2,3,0,0 ', the constant value tabulation that field is composed is ' team or group plan, power failure work ', during then newly-increased the record, will login people ' teams and groups' name ' automatically and compose, will login people's ' name ' tax and give field xm to field bdzm, constant ' team or group plan ' is composed to field lb1, constant ' power failure work ' is composed to field lb2;

Combination parameter 2 has two kinds of usages, first is used for composing the management object value to field, list of values is ' a management object table ', filter this table record according to ' calling the public variable class of management object table record ' and ' calling the management object name of management object table record ', the management object value that reads this record is used the method identical with selecting typing to give and is write the value field assignment as chosen candidate value; Second is used for composing management organization's entity property value to field, and list of values is ' management organization's table ', according to the corresponding record of login people at management organization's table, reads the entity attribute field value, composes to give and writes value field.

Management organization's table entity attribute field can be provided with as required, as: transformer substation voltage grade, teams and groups' number etc.

2. newly-increased record duplicates, and uses four parameters: the table record clone method, according to condition write down clone method, the meter reading field when record duplicates, write down and write the literary name section when duplicating, be described as follows:

● the table record clone method, totally 16 kinds, show and object table with the source that enumeration type parameter identification executive logging duplicates, and the record that duplicates: 0 does not duplicate, 1 master meter current record copies to master meter, 2 sublist current records copy to sublist, 3 sublist current records copy to sublist, 4 master meter current records copy to sublist, 5 sublist current records copy to sublist, 6 bosses show the forms sublist all record copy to sublist, 7 sublists and sublist forms sublist all record copy to sublist, 8 master meters sublist the sublist minute book table that satisfies condition duplicate, 9 master meter field decomposition values generate the many records of sublist, 10 source table records duplicate, and 11 master meter current records copy to button menu forms table, and 12 sublist current records copy to button menu forms table, 13 sublist current records copy to button menu forms table, 14 master meter current records and source table current record copy to master meter, and 44 master meter current records and source table current record copy to sublist, and 41 sources table all record copies to master meter;

● according to condition record duplicates, and only is used for table record clone method 8, uses combination parameter, form: record copy table class, and { asking the field name of maximin } asks the method for maximin, the public variable of filter record, { conditional expression of filter record };

It can be date type or numeric type field that its neutron parameter ' is asked the field name of maximin ', and ' asking the method for maximin ' uses the enumeration type parameter identification: 1 minimum, 2 maximums; ' public variable of filter record ', use the enumeration type parameter identification: 0 does not use, 1 department number, 2 classes of group numbers, 3 operator's names, the normative field of corresponding tables record respectively: ejbmbh1, bzbh, operator;

● the meter reading list of fields when record duplicates: identify with character string sequence;

● the literary name section of writing when record duplicates is tabulated: identify with character string sequence;

Annotate 1: the 9th of clone method 9 corresponding Edit button: ' the master meter field value decomposes automatically newly-increased sublist record ', master meter is got the decomposition value field name by the meter reading Field Definition; The field that decomposition value writes is by writing the definition of literary name section;

Annotate 2: determining of the menu member bag that the source table of clone method 10 duplicated records and object table and the record that duplicates are used by menu only needs definition meter reading field and writes the literary name section;

Annotate 3: the meter reading field is with to write the literary name section corresponding one by one.

3. whether use and select typing to put field value; With numeral 01 sign, equal to call the selection typing at 1 o'clock, use the field name of selecting typing and select input method by ' selecting the input method table ' definition.

4. record editor shielding, use four parameters:

● shielding mode, use the enumeration type parameter identification: 1 record editor shielding, the shielding of 2 flow processs control page editing, 3 record grouping editor shieldings;

● mode 1,3 shielding editor's table classes and mode 1,2 condition table classes (mode 1 the two identical)

● editor's shielding condition: identify with conditional expression;

● do not allow the information of editing: use Text Flag.

Annotate 1: record editor shielding: to satisfying the record executive logging editor shielding of ' editor's shielding condition ';

Annotate 2: the shielding of flow process control page editing: when ' editor's shielding condition ' satisfied in the unirecord that the afterbody index obtains, to the master menu page and whole button menu page shielding editor;

Annotate 3: record grouping editor shielding: the record that has allows some to edit, and other people can only inquire about, and is called ' record grouping editor shielding '; Example: during professional teams and groups recording device machine accounts, can only edit this professional machine account record, but can inquire about the machine account record of other specialty input; ' management object table grouping editor condition ' that the editable record of grouping editor reads in when pressing ' table record filtration ' carried out.

5. field editing shielding is used combination parameter, form: [table class, shield type, { field name sequence }];

Shield type enumeration type parameter identification: 1 whole fields do not allow editor, 2 ' field name sequences ' are for allowing the edit field tabulation, 3 ' field name sequences ' are not for allowing the edit field tabulation, and 4 ' field name sequences ' write down the gauge outfit list of fields that forms allow editor for the band gauge outfit more;

The table class is used the enumeration type parameter, and the table class of the some tables that use with the menu forms is identical.

Annotate: the band gauge outfit writes down forms after having edited the gauge outfit field more, employs these field values that the gauge outfit field value is replaced the whole records in many record forms certainly.

6. field condition editor shielding, use combination parameter, form: [condition table class, condition table sequence number arranged side by side, { condition }, the mask field editor shows class, { mask field tabulation }];

Condition is a conditional expression; The mask field tabulation identifies with character string sequence; Condition table sequence number is a numeric parameter side by side; Two table classes are used the enumeration type parameter;

Annotate: ' condition table class ' and ' the mask field editor shows class ' can be same tables of data, also can be the different pieces of information tables, when condition is true time mask field editor.

4.9 editor must record when preserving, and field is judged and the record uniqueness is judged

1. must record field and judge parameter format, be divided into unconditional and two kinds of tape spares:

● unconditionally must record field and judge, judge that class equals 1 or 2, use combination parameter, form:

[the table class is judged class, carries out class, { carrying out the control option of class 2 or the generation p.m.entry keyword option of execution class 1 }, { must record list of fields }, { must record the tabulation of field name mark }]

● tape spare must be recorded field and judge that the judgement class equals 4, uses combination parameter, form:

[the table class is judged class, { must record list of fields }, { must record the tabulation of field name mark }, condition table class, condition table sequence number arranged side by side, { condition }];

Parameter declaration: table class, condition table class are ' table class ' parameter; Condition is a conditional expression; Condition table sequence number is used the integer sign side by side; Carry out class and use following enumeration type parameter with the judgement class; All the other parameters are used the character string sequence sign;

Carry out class: 0 not keeping records, 1 keeping records, 2 keeping records but do not carry out flow process control;

Judge class: 1 forms current record unconditionally must be recorded field, and the whole records of 2 forms unconditionally must be recorded field, and 4 forms current record condition judgment must be recorded field;

2. must record the explanation of field arbitration functions:

Must record field judge be divided into ' unconditionally must record field ' and ' condition must be recorded field ' two kind, the latter judges that when satisfying condition the former unconditionally carries out judgement;

To the index field of tables of data, be defined as and record field; If these field values are null, then generate and provide information according to ' must record the field name mark ', do not preserve the record of being edited;

To non-index field, if these field values are null, but allow user's typing next time, then generate and provide information according to ' must record the field name mark ', preserve the record of being edited, and, show login people's p.m.entry after the login system automatically according to the p.m.entry of ' generating the p.m.entry key word ' generation at the login people next time;

What the convection current process control required must record field, if these field values are null, then generates and provide information according to ' must record the field name mark ', preserves the record of being edited, but does not carry out the flow processing of ' control option ' regulation.

3. table record uniqueness or menu forms record uniqueness is judged, uses combination parameter, form:

[the table class is judged class, { the record uniqueness is judged the key field list of file names }, { tabulation of field mark }];

Judge class, use the enumeration type parameter: the whole records of 1 menu forms, the whole records of 2 tables;

The character string sequence sign is used in subparameter ' the record uniqueness is judged the key field tabulation ', ' tabulation of field name mark ';

Subparameter ' table class ' equals at 4 o'clock, is used to use table newly-increased record in source to repeat to judge that field is labeled as information, and list of fields is newly-increased record object table field name; Be not equal at 4 o'clock, carry out by the table class.

4. write down uniqueness and judge explanation:

If it is not unique that the record of input is judged as, then generate and provide information according to ' tabulation of field name mark ', do not preserve the record of being edited.

4.10 by period statistical summaries Parameters design

The single tables of data record of appointment carried out by the period of input at random filter, generate the sublist record, and carry out fixedly that project gathers, statistical time range and summarized results are kept in the master meter; The statistics table name is by ' source table table name ' parameter-definition; Use 4 parameters:

Segmented mode when 1. getting, totally 4 kinds: 1 one field identification period intervals, 2 two field identification period intervals, 3 time values, 4 time values more than or equal to input smaller or equal to input;

2. master meter is imported the date field name of period;

3. the date field name that gathers by the period of source table;

4. master meter is imported the value classification of period, totally 4 kinds: 1 year, and 2 days, 3 dates, 4 time-divisions date;

1. and 4. parameter uses the enumeration type parameter identification, and all the other parameters identify with character string or character string sequence;

Function declaration is seen ' by period statistical summaries member bag ' method for designing.

4.11 random assortment inquiry, random assortment gather method for designing

Random assortment carried out in the single tables of data record of appointment gather or inquire about, the table name parameter-definition is shown in table name origin source; Query Result generates the master meter record; Totally 7 parameters:

1. gather sorting field or querying condition field;

Show direct value field when 2. source table gathers field or inquiry from the source;

3. source table gathers or the master meter of value field correspondence is write value field;

4. classification or querying condition field name mark;

5. the method for summary that gathers field, totally 7 kinds: 1 asks the record number, 2 summations, 3 ask average, 4 maximizings, 5 minimize, and 6 ask variance, and 7 get initial value;

6. the date field name is shown in the source;

7. date field value classification is shown in the source, totally 4 kinds: 1 year, and 2 days, 3 dates, 4 time-divisions date;

Wherein 5. and 7. parameter identifies with enumeration type parameter or enumeration type argument sequence, and all the other parameters identify with character string or character string sequence; 5. random assortment inquires about not operation parameter;

Function declaration is seen ' random assortment inquiry component bag ' and ' random assortment gathers the member bag ' method for designing.

4.12 end of term entity state inquiry method for designing

Source table record to appointment carries out end of term entity state inquiry, totally three of processing parameters:

1. entity sorting field: use the character string sequence definition;

2. the time field name that changes of entity state: origin source table date index field sign;

3. the indexed mode of end of term date category origin source table date index field identifies;

Function declaration: the user generates master meter end of term entity state query note according to entity sorting field and end of term date category after clicking source table date field afterbody index; The corresponding relation of ' indexed mode ' and ' end of term date category ' is seen ' end of term entity state inquiry component bag ' method for designing.

4.13 search selected at random entity correlation table record method for designing

Function declaration: to a certain record of single master meter user selected at random, substantial definition field value and the comparison condition stipulated by system's control table filter out the relative recording of choosing entity; Use a master meter and a source table; The table that the choosing record uses source table definition, the relative recording that obtains is preserved with master meter; Forms, the alternative many records in forms top, the following many records relevant of forms with choosing record;

Totally two of processing parameters:

1. substantial definition field: use source table and the definition of master meter associate field;

2. comparison condition: conditional expression;

4.14 call the Parameters design that background process is handled:

Calling ' background process processing ' can be master menu or button menu;

Method for designing: system is controlled two primary key values (menu sequence number, menu forms sequence number), ' login people carry out menu function button sequence number ' and ' flow process that the login people selects is controlled the option sequence number ' of master meter as call parameters; Use the integer sequence sign when parameter value of latter two parameter is a plurality of, call the different recording of ' menu background process disposal route table ' during execution respectively; Parameter designing is as follows:

● call the function button sequence number that background process is handled: use the enumeration type parameter: 0 is not, and 1,2,3 are respectively master meter, sublist, and sublist increases record button newly; 4,5,6 are respectively master meter, sublist, the save button when sublist increases record newly; Save button when 7 master meters, sublist all have record; Save button when 8 master meters, sublist, sublist all have record; 9 save buttons; 10 background process call buttons; 11,12,13 are respectively master meter, sublist, sublist deletion record button;

● flow process control option list: when further work calls different background process, use the tabulation mode to select for the login people; String argument; Example: during checking report forms that certain grade of responsible official of management organization reports next stage 3 control options are arranged, be listed as follows: 1 returns and rewrites; 2 audits are passed through; 3 wouldn't determine.

● control option: the option sequence number of ' flow process control option list ' that the login people selects;

As above-mentioned ' checking report forms ', when the login people selects: ' 1 return rewrite ' time, with 1 as call parameters; Select: ' 2 audits by ' time, with 2 as call parameters;

● ' user clicks that Edit button is newly-increased, deletion, whether preserve when preserving former current record value be background process handle use ' parameter, when carrying out the tables of data write operation, whether use the judgement and the execution parameter of ' former current record ' field value;

This parameter is used two integer signs: first, Edit button: 1 newly-increased 2 deletions 3 are preserved; Second, table class: 1 master meter, 2 sublists, 3 sublists; Do not preserve former current record field value during for sky, when not being empty, before the user edits, preserve the current record value, and the former current record field value that in ' menu background process disposal route table ', uses with prefix LAO_ field name sign; When being a plurality of, parameter value separates with comma.

4.15 generate Web inquiry system Parameters design

Need are carried out the Web inquiry menu editing after the Web query page, can generate the Web inquiry system automatically;

Parameter designing:

● Web query page name: string argument, when not being empty, menu is inquired about menu as Web;

● during execution according to the menu definition parameter, the tables of data parameter that menu uses, the table index parameter, Web query page name parameter dynamically generates Web inquiry menu and Web query page.

4.16 the editing interface of ' system's control master meter ' is seen Fig. 2-Fig. 6.

5, table record filter method table design

1. primary key is totally 5: menu sequence number, menu forms sequence number, secondary paging menu sequence number, filter table class and filter record number;

Wherein first three is identical with key word that system control master meter identifies menu, according to keywords is worth equal principle during execution and calls; That table that ' filter table class ' sign is used menu is carried out and is filtered; ' filter record number ' is for distinguishing the different recording setting that different system login people uses this method table.

During the execution list record filtering, at first determine this method table record that the login people uses, according to the corresponding record parameter value menu data table record is filtered then; When a certain login people does not have this corresponding method table record, use whole records of menu data table.

2. totally 6 parameters of following 2 identity conditions of using the login people are determined this method table record that arbitrary system login people uses:

Condition 1: identity public variable class 1, identity public variable value list 1, determination methods 1;

Condition 2: identity public variable class 2, identity public variable value list 2, determination methods 2;

' the identity public variable class ' of two conditions is the enumeration type parameter: 1 department's class, 2 department's names, 3 classes of station classes, 4 classes of names of station, 5 personnel's responsibilities, 6 names, 0 arbitrary login people;

The identity public variable class of condition 2 is 0 o'clock, and an expression service condition 1 is not 0 o'clock, and condition 1 and condition 2 are the and relation;

' determination methods ' of two conditions is the enumeration type parameter: 0 does not satisfy condition to very, and 1 satisfies condition to very.

Example: if identity public variable class 1 equals 3, identity public variable value list 1 is ' teams and groups, a transformer station ', and determination methods 1 equals 1; When being ' teams and groups ' or ' transformer station ', class's station class of then a certain login people uses the filter method filter table record of this record; If determination methods 1 equals 0, when class's station class of then a certain login people is not ' teams and groups ' or ' transformer station ', use the filter method filter table record of this record;

3. table record filter method:

First: equate with corresponding data sheet field value or relation of inclusion is filtered by public variable;

Second: filter with corresponding data sheet field value relation of inclusion by the management object value;

The 3rd: 16 kinds of above-mentioned two filter methods are described with following 16 public variable 01 argument sequences, and a certain position equals 1, carries out accordingly and filters, and equals 0, does not carry out corresponding filtration;

Filter 16 01 sequences of public variable: 1 department numbering, 2 teams and groups numbering, 3 logout sequence numbers, 4 department's names, 5 teams and groups' names, 6 names, 7 order of classes or grades at school on duty, 8 tier-2 department's names, the set name of the thing of 9 management, the people's of 10 management set name, 11 department's classes, 12 teams and groups' classes, 13 unit names, 14 management object values are filtered, and 15 management object expression formulas are filtered, 16 personnel numbering;

Department's numbering in the public variable, teams and groups' numbering, personnel number ejbmbh1, bzbh, the operator field of automatic corresponding data table; The data sheet field of all the other public variable values and management object value correspondence is specified by parameter ' the data sheet field name of public variable correspondence ';

The set name of the thing of the management of ' 9 in the public variable ', the people's of ' 10 management set name ' to filter by relation of inclusion, all the other filter by relation of equality;

' 14 management object values in the public variable are filtered ', ' 15 management object expression formulas are filtered ', according to parameter ' call the public variable class of management object value ', ' calling the management object name of management object value ' or ' calling the public variable class of management object expression formula ', ' calling the management object name of management object expression formula ' filter ' management object table ' record, obtains corresponding ' management object value ' or ' management object expression formula '; ' calling the public variable class of management object value and expression formula ' uses the enumeration type parameter: 1 department's name, 2 tier-2 departments, 3 teams and groups' names, 4 teams and groups' classes, 5 names, 6 personnel's responsibilities;

' management object expression formula class ' equals 2, and ' 15 management object expression formulas are filtered in the public variable ' the filtercondition of expression formula for carrying out; Equal at 3 o'clock, ' 15 management object expression formulas are filtered in the public variable ' expression formula for carrying out the conditional expression of ' record grouping editor shielding ' in ' record editor shielding ';

The 4th: by parameter ' the SQL conditional expression of filtration ', the SQL condition that given filter is carried out; This parameter is a conditional expression.

4. ' table record filter method table ' editing interface is seen Figure 11.

6, select the design of input method table

When ' selection typing ' method was adopted in the typing of his-and-hers watches field value, the chosen candidate value of selection typing can be a certain field value of ' non-menu forms use table ' table record or a certain field value of ' the current set of menu forms use table ' table record; The login people can select one or more chosen candidate values to write edit field.

It can be one or more using this method table Same Way to select the field of typing, with ' writing the value field tabulation ' sign; When carrying out the different choice input method, different field uses the different recording of this method table respectively.

Parameter type: parameter is all used the enumeration type parameter for the table time-like; During for condition, the service condition expression argument; During for field name, use character string or character string sequence parameter; And the tabulation sequence number is used numeric parameter.

1. primary key is totally 3: menu sequence number, menu forms sequence number and ' selecting the typing recording mechanism ', and the key word that wherein preceding two and system's control master meter identify menu is identical, according to keywords is worth equal principle during execution and calls; ' selecting the typing recording mechanism ' for distinguishing same menu forms, different ' writing the value field tabulation ' when adopting the different choice input method, use the different recording setting of this method table.

2. alternate key is totally 2: editor's table class, editor and tabulation sequence number, that table that sign is used menu is carried out and is selected typing.

3. the selection input method execution parameter of literary name section:

Parameter: ' write value field tabulation ', sign is selected typing to those fields by the method for current record regulation, can be a field, or field combination (the field name sequence that separates with comma);

Parameter: ' condition table class ' and ' calling the typing condition of selecting ' judges whether to carry out the selection typing; Condition is that true time is carried out, for fictitious time is not carried out.

4. filter the parameter that chosen candidate value tables of data record uses:

By following parameter-definition 3 kinds of filter methods, be used to filter the chosen candidate value tables of data record of selecting typing to use;

● chosen candidate value data table name;

● the menu forms must be recorded the field list class in advance; Must record field in advance; Must record the chosen candidate value literary name section of field correspondence in advance;

● filter the public variable and the corresponding chosen candidate value data sheet field name of chosen candidate value tables of data record;

● chosen candidate value tables of data record filtering conditional expression;

Illustrate: wherein ' pressing public variable filters ' is identical with ' table record filter method table ' method for designing with ' according to condition filtering '; And use simultaneously the menu forms ' must record field in advance ' and ' corresponding chosen candidate value literary name section ' value relation of equality as chosen candidate value table record filtercondition;

5. according to parameter: ' chosen candidate value field name ' and ' reading the chosen candidate value mode ' determines to select the chosen candidate value of typing;

Read the chosen candidate value mode and use the enumeration type parameter: the chosen candidate value field of 1 one records has only a chosen candidate value, and the chosen candidate value field of 2 one records has a plurality of chosen candidate values.

6. determine to carry out select the method for typing according to ' getting the selective value mode ' parameter: once select 1 chosen candidate value to write edit field or once select a plurality of chosen candidate values to write edit field;

' getting the selective value mode ' uses the enumeration type parameter: 1 selects 1 chosen candidate value, and 2 select a plurality of chosen candidate values.

7. according to following 3 class parameters, after typing was selected in definite execution, other of execution write table handling:

● ' the chosen candidate value table is got other value field list of file names ', ' editor shows correspondence and writes the value field list of file names ';

● ' field name that the decomposition value of selection result is write ';

● ' putting the table class of selecting number ', ' put and select the number field name ';

Execution writes editor and shows corresponding field from other field value of chosen candidate value table or with the decomposition value of selection result, and puts the write operation of selecting number.

8. carry out other regulation of selecting typing

● determine to select typing whether to carry out password authentification according to ' password confirming ' parameter value;

● carry out selective value according to ' selective value repeats to judge class ' parameter and repeat to judge, provide error message during repetition;

● whether allow to carry out keyboard editor typing when determining to select typing according to ' whether allowing editor ' parameter;

● according to parameter: ' get selective value mode=2 o'clock whether allow to import new option ', whether can use the keyboard editor to append chosen candidate value when determining to select typing.

Annotate: selective value repeats to judge class use enumeration type parameter: 0 is not, the whole records of 1 current form, the whole records of 2 tables of data; Other 3 parameters are used the enumeration type parameter: 0 is not, and the 1st.

9. editing interface is seen Figure 10 ' to select the input method table '.

7, menu background process disposal route table design

The foreground process that development platform should realize menu member bag is handled, and by system's control master meter and system supplymentary control table parameter-definition, the background process that menu should be finished is handled, by ' menu background process disposal route table ' parameter-definition.

Development platform with the background process disposal route of database application system menu be decomposed into newly-increased table record, revise table record, delete list writes down three class tables of data WriteModes, and designed the execution parameter of each WriteMode, dynamically generate SQL statement according to these parameters during execution, finish the tables of data write operation, realize the functional requirement that background process is handled; For the function that can not use dynamic SQL statements to realize, realize by calling ' data base procedure ' code of writing.

During design the user service data table is divided into two big classes: list of values and the value of writing table, list of values is the Data Source of dynamic SQL statements, is called for short ' meter reading '; The value of writing table is called for short ' writing table ' for carrying out the object table of write operation; List of values and the value of writing table can be menu use tables, also can not be menu use tables, and the latter is called for short ' new table '.

(1) primary key is totally 6: menu sequence number, menu forms sequence number, the flow process control option that calls, the function button sequence number of calling, WriteMode, execution sequence number;

They are all described with integer, and wherein to identify the key word of menu identical for the first two and system's control master meter;

Filter this method table record according to ' menu sequence number ', ' menu forms sequence number ', ' flow process control option ', ' function button sequence number ' during execution, then the record that filters out is carried out by ' execution sequence number ' order;

The menu function button of ' function button sequence number ' corresponding system control master meter enumerate sequence number;

The option sequence number of ' the flow process control option list ' of ' flow process control option ' corresponding system control master meter;

WriteMode is divided into 6 kinds, uses the enumeration type parameter: 0 judges whether to withdraw from and calls, 1 newly-increased record, and 2 amendment records, 3 deletion records, 4 have record modification, and no record is newly-increased, and 5 call data base procedure;

Be divided into 5 kinds for the method for field assignment: ' tax constant ', ' unconditionally composing transition formula evaluation ', ' condition tax transition formula evaluation ', ' another data designated table is carried out write operation as meter reading ', ' sql statement assignment '; These 5 kinds of methods can be used wherein one or more as required;

WriteMode equals 0, is used to judge whether this later method table record of current ' execution sequence number ' is carried out;

WriteMode equals 1, is used to increase newly ' writing table ' record, at first generates ' writing table ' record primary key and customer service key word, gives other field assignment with 5 kinds of methods of giving the field assignment then;

WriteMode equals 2, is used for revising ' writing table ' record, at first determines to carry out the record of retouching operation according to ' revising or deletion write operation manner of execution ', revises field value with 5 kinds of methods of giving the field assignment then;

WriteMode equals 3, is used for deletion ' writing table ' record, according to ' revising or deletion write operation manner of execution ' definite record of carrying out deletion action, deletion ' writing table ' record again;

WriteMode equals 4, judges that at first ' writing table ' has or not the record that satisfies condition, and carries out the amendment record operation when satisfying condition record, does not have and carries out newly-increased recording operation when satisfying condition record; Like this, when satisfying condition record, can not do the deletion record operation;

WriteMode equals 5, is used for the write operation that can not realize with dynamic sql statement; During execution, call ' data base procedure ' of writing and realize write operation.

(2) ' background process calls ' user intervention of whether carrying out

For prevent the user overdue ' background process call buttons ', but temporarily also do not need to carry out the request for utilization that next step process is handled, ' information whether process transfer is carried out ' parameter is set; During execution, if the function button sequence number called equals 10, and this parameter value be empty, then releases this information, receives the keyboard input, and input Y carries out write operation, imports N, withdraws from background process and calls.

(3) when control option=99, carry out ' flow process control whole options revise field values are unified to be handled ', write down and be convenient to the parameter editor in order to reduce ' menu background process disposal route table ', irrelevant with the execution parameter of 6 kinds of WriteModes, use combination parameter, form: [{ value class, table class, and tabulation sequence number, WriteMode, write the value field name }, { flow process control option list }, { flow process is controlled the value list of writing of option correspondence }];

Each is write the write method of value field name and draws together with [], a plurality ofly separates with comma;

The enumeration type parameter of using is as follows: table class: ' table class ' parameter; WriteMode: 1 forms current record, the whole records of 2 forms; Value class: 0 constant, 4 public variables;

Annotate: when the value class is public variable, identify corresponding public variable value with the sequence number of enumerating of public variable;

(4) ' meter reading ', ' writing table ' and the meter reading of write operation use are write down and are write table record totally 6 parameters:

● the meter reading class; Write the table class;

● the read record mode: 1 forms current record, the whole records of 2 forms, 3 with sublist, sublist all record read in new result set and use, 4 use the whole records of new result sets;

Annotate: when forms have only sublist to be subordinated to master meter or sublist is subordinated to the partial record of sublist, but when needing that whole subordinates records are carried out write operation, use-pattern 3 or 4;

● meter reading and the sequence number of tabulating; Write table and the sequence number of tabulating;

● write new table name (the data table name when writing non-menu use table);

Annotate: the meter reading class, to write the table class be ' table class ' parameter; The read record mode is the enumeration type parameter; Two and the sequence number of tabulating are numeric parameter; Writing new table name is string argument.

(5) whether the write operation of judging a certain recording prescribed of this method table is carried out and write operation execution number of times

Use two set condition parameters ' the meter reading condition of execution ', ' date terms of execution ' and ' write operation execution number of times ' parameter-definition; Determine ' write operation execution number of times ' according to satisfying ' the meter reading condition of execution ' record strip number during execution;

● the meter reading condition of execution: be conditional expression; Be defaulted as unconditional during for sky;

● write operation execution number of times is the enumeration type parameter: each carries out 0 each record once, and 1 each record that satisfies condition is respectively carried out once, and the one of record more than 2 satisfies condition and only carries out once, and record more than 3 all satisfies condition and only carries out once;

● the date terms of execution uses 4 parameters: date field table class, date field and the sequence number of tabulating, date field name, date judgment mode;

Wherein ' date field table class ' is ' table class ' parameter; ' date field and the sequence number of tabulating ' is the integer type parameter; ' date field name ' is string argument;

' date judgment mode ' is the enumeration type parameter: 1 every month last day, 2 first day every month, 3 per last daies in season, 4 first day per season, 5 last daies every half a year, first day 6 every half a year, 7 annual last daies, 8 annual first day, 9 Mondays, 10 Sundays;

● WriteMode=0 o'clock, do not satisfy the information of executive condition, be string argument;

Annotate 1: ' WriteMode ' equals 0, is used to judge whether the later method table record of current execution sequence number is carried out; When not satisfying ' the meter reading condition of execution ', do not carry out the write operation of this later method table record regulation of current execution sequence number, and provide and do not allow the information carried out; Otherwise continue to carry out subsequent write operation;

Annotate 2: if ' WriteMode ' is not equal to 0, if do not satisfy ' the meter reading condition of execution ', the write operation of this recording prescribed of manner of execution table not then; Otherwise, carry out write operation by ' write operation execution number of times ';

Annotate 3: if ' WriteMode ' is not equal to 0, and satisfy ' the meter reading condition of execution ', but when not satisfying ' date terms of execution ', not the write operation of this recording prescribed of manner of execution table;

Annotate 4: ' date field table class ' equals not judge date terms at 0 o'clock.

(6) revise or delete write operation manner of execution, totally 5 parameters:

● recording interval and manner of execution that the value of writing table is revised or deleted: 1 forms current record, 2 forms or newly show whole records, and the read-write table is many records and writes down number 1*N the recycle design of revising one to one when equating, the a certain field of 3 meter readings is preserved writes table record xuhao record, M*N recycle design when 4 read-write tables are write down more, 5:for I=1 TO N recycle design;

● when writing the table result set for many records, reading and writing table associate field;

● the field name of modification or deletion record xuhao is preserved in meter reading, and only ' manner of execution 3 ' is used;

● write the new table record filtercondition of conditioned disjunction that table record should satisfy when deletion and amendment record;

● meter reading with write literary name section comparison condition, use two parameters:

1. conditional formats: 0 is unconditional, 1 read to write field before the field after, 2 write read field before the field after;

2. condition: use '＞', '＜', and '=', ' in ' be operational symbol as a comparison, connects ' meter reading ' and ' writing table ' field, composition condition comparison expression;

Annotate: ' value of writing table is revised or deletion record scope and manner of execution ', ' conditional formats ' use the enumeration type parameter; ' field name of modification or deletion record xuhao is preserved in meter reading ' uses integer sequence; Two conditional parameter service condition expression formulas; Other parameter is used character string or character string sequence;

Illustrate 1: ' forms current record ' and ' forms or new table be record all ' is used for the table record of writing that write operation is carried out in explicit appointment;

Illustrate 2: 1*N the recycle design of ' revising one to one ' is used for ' meter reading ' and ' writing table ' all has N bar record, reads ' meter reading ' record, writes a corresponding record of ' writing table ' order;

Illustrate 3: ' the table record xuhao that writes of a certain field preservation of meter reading writes down ': be used to write ' writing table ' fixing one or more xuhao records;

Illustrate 4: ' M*N recycle design when the read-write table is write down more ': be used for order and carry out ' meter reading ' all M records: read ' meter reading ' record, according to ' read-write table incidence relation ', ' meter reading with write literary name section comparison condition ' and ' writing surface condition ', judge each the bar record in ' writing table ' N record, carry out write operation when condition satisfies;

5:for I=1 TO N recycle design is described: be used for carrying out write operation by for recycle design, loop parameter is filled in ' meter reading with write literary name section comparison condition ';

Parameter format: the field name that loop variable is used, the circulation initial value, the circulation final value, circular increment ,+/-;

Loop variable must be the integer type field, and the circulation initial value can use this field current record value, LAO_FIELD (this field current record value before the editor) or MIN (this field minimum value of tables of data); The circulation final value can be used MAX (this field maximal value of tables of data); Circular increment is positive integer or negative integer; +/-: be used to specify the loop variable method of revising.

(7) WriteMode is when increasing recording mode newly, the newly-increased record strip number of the value of writing table, the primary key of newly-increased record and the defined parameters of customer service key word generation method during write operation of every execution:

● newly-increased recording mode: write operation of 1 every execution increases a record newly; Write operation of 2 every execution is according to newly-increased many records of decomposition value;

● newly-increased many record executive modes of write operation of every execution: the tabulation of 1 constant is decomposed, and 2 list of values fields are decomposed, and 3 use the sql statement to get a certain field value of many records of other table;

● newly-increased record major key generating mode: 1 list of values xuaho, 2 list of values xuaho, xuaho1,3 list of values xuaho, xuaho1, xuhao2,4 list of values max xuaho, 5 value of writing table max xuaho, 6 operation job record xuhao, the 0 current value of writing sublist xuhao or the current value of writing sublist xuaho, xuaho1;

● newly-increased record write key number; (equal 1, only write xuaho, equal 2, write xuaho, xuaho1 equals 3, writes xuaho, xuaho1, xuhao2)

● write key number last key word assignment method when getting number: 0 puts 0; 1 decomposes sequence number; 2 write sublist: maximum xuhao1; Write sublist: maximum xuhao2;

● the constant tabulation of decomposition;

● ' meter reading ' gets the decomposition value field name;

● ' writing table ' writes the field name of decomposition value;

● get the sql statement of ' meter reading ' a plurality of record values of field;

Annotate 1: the enumeration type parameter of use: ' newly-increased recording mode ', ' newly-increased record major key generating mode ', when getting number ' write key number greater than last key word assignment method ', ' newly-increased many record executive modes ';

Annotate 2: the key word of write key number in the middle of when getting number puts 0;

Annotating 3:3 kind ' newly-increased many record executive modes ' can use separately, and use also capable of being combined is with one, two or three integer signs; The constant tabulation is decomposed or the list of values field is decomposed, the newly-increased record of decomposition value; Mode 3 newly-increased record strip numbers are identical with the table record bar number that satisfies ' sql statement value condition ';

(8) field is composed constant value, uses 2 parameters: ' composing constant value field name sequence ', ' the constant value sequence of tax ', all use the character string sequence definition;

Annotate 1: character string constant does not add quotation marks, when character string comprises comma, draws together with { };

Annotate 2: the date constant uses four kinds of fixing date formats:

YYYY；YYYY-MM；YYYY-MM-DD；YYYY-MM-DD?hh:mm

Annotate 3: the constant value of composing constant value field name and tax is corresponding one by one;

' type expression ' when (9) field is used the expression formula assignment, use the enumeration type parameter identification:

1 numerical expression, 2 character expressions, 3 statistical computation expression formulas, 4 compose the public variable value, record more than 5 is got a field value and is connected with comma, and 6 meter readings are given and write literary name section copy, and 7 write table gives meter reading field copy, 8 date expression formulas, field of record more than 9 gets not that repetition values connects with comma, 0 constant;

Annotate 1: when composing the public variable value, parameter value identifies with the public variable sequence number;

Annotate 2: at first according to the type expression calculation expression value of assignment, carry out assignment or field value copy then during execution.

(10) unconditional multiword section expression formula assignment

Use 3 parameters: ' the expression formula class tabulation of assignment ', ' writing the value field list of file names ', ' assignment expression tabulation ';

Annotate 1: the expression formula class does not use 0: compose constant;

Annotate 2: each expression formula is drawn together with { }, a plurality ofly separates with comma;

Annotate 3: ' the expression formula class tabulation of assignment ' is for enumerating argument sequence; ' writing the value field list of file names ' is character string sequence; Each assignment expression is a kind of in above-mentioned ' type expression '; Corresponding one by one during assignment.

(11) condition multiword section expression formula assignment

Use 5 parameters: ' the expression formula class tabulation of assignment ', ' condition class ', ' condition list ', ' writing the value field list of file names ', ' assignment expression tabulation ';

Annotate 1: ' condition class ', use the enumeration type parameter: 1 meter reading field condition, 2 public variable conditions; ' condition ' is conditional expression, the corresponding field name of public variable use and management mechanism table; Its excess-three parameter-definition is identical with ' unconditional multiword section expression formula assignment ';

Annotate 2: each condition write the value field list of file names and conditional expression is drawn together with { }, { } number is identical, correspondence one by one a plurality ofly separates with comma; Each assignment expression is drawn together with { }, and and assignment expression class and to write the value field name corresponding one by one.

(12) with another data designated table as ' meter reading ', be called for short that ' write operation is carried out in meter reading 2 '

Use 5 parameters: ' meter reading class 2 ', ' read record mode 2 ', ' writing the value field name ', ' tabulation of assignment expression class ', ' assignment expression tabulation ';

Annotate 1: ' meter reading class 2 ' is ' table class ' parameter; ' read record mode 2 ' with 4. in the read record mode stipulate identical; Its excess-three parameter-definition is identical with ' unconditional multiword section expression formula assignment ';

Annotate 2: each assignment expression is drawn together with { }, and corresponding one by one with ' assignment expression class ' and ' writing the value field name '.

(13) sql statement assignment

Use combination parameter:: { appending the table class of xuhao condition }, { writing the value field list of file names }, { sql statement }, { value condition }, { sql statement sequence number }

Annotate 1: ' value condition ' is conditional expression; ' sql statement sequence number ' used when being used for debugging; ' appending the table class of xuhao condition ' specified when getting ' meter reading ' current record and used which tables of data of menu forms, and be identical with ' table class ' define method.

Annotate 2: ' sql statement ' is identical with database sql statement form; Many sql statement ﹠amp; ﹠amp; Separate;

Annotate 3: ' sql statement assignment ' parameter defines with character string.

(14) call data base procedure

Use combination parameter: { procedure name }, { passing to the master meter list of fields of process }, { passing to the sublist list of fields of process }, { passing to the sublist list of fields of process }, { passing to the source literary name section tabulation of process }, { public variable sequence number }, { the sequence number parameter of calling };

Annotate 1: the call parameters of the different disposal method when ' the sequence number parameter of calling ' is used to distinguish a plurality of menus or ' different recording of this method table of same menu ' use same ' data base procedure ';

Annotate 2: except that ' procedure name ' parameter can not be for the sky, all the other parameters all are provided with as required;

Annotate 3: ' calling data base procedure ' parameter defines with character string.

(15) the background process processing execution information parameter that finishes

After ' the maximum sequence number of carrying out ' write operation of each control option ◇ 99 is finished, or after the control option equals 99 write operation and be finished, provide this information; It and ' WriteMode=0 o'clock, do not allow the information of a carrying out ' public parameter.

(16) ' menu background process disposal route table ' editing interface is seen Fig. 7-Fig. 9.

8, the menu operation authority is provided with the table design

Tables of data to the menu use, when different system login people logins application system, the operating right of menu by this control table parameter-definition, is had six parameters: menu sequence number, class's station class, authority definition class, personnel's responsibility or personnel's numbering, menu read right, menu write permission;

1. the parameter of Shi Yonging:

● menu sequence number: identical with system control master meter menu sequence number;

● class station class: identical with table class of management organization station class;

● the authority definition class, the enumeration type parameter: 1 by the definition of personnel's responsibility, and 2 by personnel's number definition;

● personnel's responsibility or personnel's numbering: the personnel's responsibility or the personnel's numbered list that use the menu operation authority;

● the menu read right, the enumeration type parameter: 0 does not have, and 1 has;

● the menu write permission, enumeration type parameter: 0: do not have, 1 has;

2. the menu operation authority uses ' menu operation permission configuration interface ' to be provided with by the corresponding systemic-function button of development platform;

3. ' menu operation permission configuration interface ' sees Figure 12.

9, management object table design

1. database application system management set and management hierarchy analysis:

● the arbitrary login of database application system people's management set is divided into three major types: the set of the set of thing, people's set, people and thing;

● the set of thing: as warehouse, transformer station, workshop, the goods and materials of depositing or the equipment of use;

● people's set: as teams and groups, department, warehouse, transformer station, workshop, the personnel that have under its command;

● the set of people and thing: as warehouse, transformer station, workshop, the existing personnel that have under its command have the goods and materials deposited or the equipment of use again;

● management hierarchy is divided into two classes: ' vertical management level ' and ' intersection management hierarchy ';

● for the vertical management level,, use by ' management organization's table ' and ' person chart ', with unit name, department's name, teams and groups' name, personnel's name (personnel's numbering), department's number, class group number identity management set as unit → department → teams and groups → personnel;

● for intersecting management hierarchy, promptly professional responsibility compass of competency is as the teams and groups of personnel's first management in the department, the teams and groups of personnel's second management; The warehouse of the warehouse of personnel's first management, the management of personnel's second uses the set of ' management object table ' identity management.

2. the tables of data that menu is used, when different system login people uses the different table record of same tables of data, except the vertical management scope (unit → department → teams and groups → personnel) of using ' management organization's table ' regulation is filtered the data table record, can also filter the data table record or executive logging editor shielding by login people's professional responsibility compass of competency, login people's professional responsibility compass of competency is kept in ' management object table '.

3. the management object table has seven parameters: ' sequence number ', ' management object name ', ' the public variable class of use and management object ', ' the public variable value of use and management object ', ' the personnel's numbering when the public variable class is name ', ' management object using method ', ' technical jurisdiction value range or technical jurisdiction range expression ';

' sequence number ' is primary key, integer type; ' management object using method ' is the enumeration type parameter: the value list of 1 filter record; The conditional expression of 2 filter records; 3 grouping editor conditional expressions.

Filter management Object table record by login people's ' public variable class ', ' public variable value ', ' personnel's numbering ' and ' the management object name ' that needs to use when 4. carrying out, use class, technical jurisdiction value range or expression formula filtering data table record or executive logging grouping editor shielding according to management object again.

5. ' management object table ' editing interface is seen Figure 13.

10, the design of introduction method table derived in the tables of data record

When single master meter uses menu member bag w_1table_1page, table record can be exported as Excel table data, also Excel can be shown data importing to single master meter; The field name that tables of data imports and derives is kept in ' the introduction method table derived in the tables of data record '; Call by the corresponding systemic-function button of development platform during execution.

This method table has 3 parameters: ' data table name ', ' the field name sequence that imports and derive ', ' the field name mark sequence that imports and derive '; Field name and field name mark are corresponding one by one.

' the master meter name that menu uses ' parameter by system's control master meter during execution is filtered this method table record; Then the field name mark vertically is arranged in the screen left side in order, mouse is double-clicked either field or is selected whole fields, then chooses field to move to screen the right as the field name of deriving or importing, the identification field that vertically puts in order sort method; Mouse is double-clicked screen the right either field, returns the screen left side; Also can revise the field sort method; After choosing the field that needs to derive or import, click system ' derivation ' or ' importing ' function button, and input Excel list file name are then carried out corresponding derivation or importing work.

' the introduction method table derived in the tables of data record ' editing interface is seen Figure 14.

11, tables of data primary key maximal value table design

Development platform all is set to integer type to the major key of all menu data tables of application system, and uses ' tables of data primary key maximal value table ' record all customer data table ' master meter key word xuhao maximal value '.

Parameter designing: sequence number, data table name, major key maximal value;

' sequence number ', ' major key maximal value ' is argument of type integer; ' data table name ' is string argument;

When increasing table record newly, the primary key value of putting tables of data automatically is corresponding data table ' xuhao maximal value+1 ', upgrade ' tables of data primary key maximal value table ' this tables of data ' xuhao maximal value ' then, thereby satisfied the uniqueness requirement of tables of data record Major key;

Menu data table key word ' xuhao ', ' xuhao1 ', ' xuhao2 ' are all invisible in the menu forms, and the key value of tables of data record is provided with automatically by development platform;

The uniqueness of tables of data record is controlled master meter ' the record uniqueness is judged the key field list of file names ' parameter by development platform according to system and is judged.

Tables of data primary key maximal value table record is carried out the backstage editor by the development platform correlation module.

Use development platform development data storehouse application system step

● analysis management level, typing ' management object table ' data;

● typing ' personnel's duty list ' data; ' personnel's duty list ' storage system user of service's identifying data.

(10) determine that function menu is to editor's shielding of data table record, condition editor's shielding of record, grouping editor's conditioned disjunction method;

(14) determine to use that random assortment gathers, the random assortment inquiry, by classification and the method for summary regulation of period during statistical summaries;

Use development platform development data storehouse application system process flow diagram to see Fig. 1.

Use development platform development data storehouse application system advantage

1, uses the application system good stability of development platform exploitation

The stability of application system depends on overall system design and program code design, when not using the development platform development system, needs could satisfy stability requirement through repeatedly revising code, system debug.If the function change takes place, also need to carry out code revision, system debug during this time.

Use the application system of development platform exploitation, use be " menu member bag " processing module, do not need the coding code.Application system stability is to be determined by the stability of development platform.Use through long-term, it is ripe that development platform has been tending towards, can guarantee the stability of system.

2, the construction cycle be can shorten, cost of development and system maintenance expense reduced

Use development platform development data storehouse application system, what carry out is the function design, rather than the program code design, does not need the coding code, or only need write the small number of programs code.Specialize in personnel or user and have basic database knowledge and programming during experience, can set up tables of data and edit menu forms, input " system's control table " parameter.The menu forms editor finish, and after the input call parameters, operational system is checked execution result immediately.Thereby, can shorten the construction cycle, reduce cost of development.

During system maintenance, do not need the update routine code, only need to revise the call parameters of user data table, menu forms and system's control table; During conditions being possessed, the user also can safeguard by participation system.Thereby, can reduce the system maintenance expense.

3, applicable to different industries, the database application system of different application

First: development platform adopts the method for ' handling the type aspect based on menu data ' classification to the function menu of using system, different industries, the application system function menu of different business if belong to same data processing type, then can use same menu member bag execution module.

Second: the function menu of same data processing type, though the tables of data of using, menu forms, data processing method difference, but tables of data and menu forms are outside foundation of system and editor, and the using method of function menu, promptly user's business model is to use system control table parametric description.So,, only need in system's control table, to fill in different parameters and can realize menu function using the different business function menu of same menu forms member bag.

The 3rd: to the irrealizable special menu function of development platform, can write the stand-alone program module, fill in corresponding call parameters after, system will call automatically.

The the 4th: to the irrealizable special data processing capacity of development platform, can write ' data base procedure ', and ' procedure name ' and ' call parameters ' filled in ' menu background process disposal route table ', then will call automatically during the development platform operation, finish corresponding function.

Thereby development platform is applicable to different industries, the database application system of different application.The Software Architecture Design target that development platform reaches

(1) " menu member bag " realized that application systems software member level is multiplexing.

(2) " system's control table " is to using the operation stipulations of systemic-function menu, it is user's business model, adopt the numerical value and the character field definition of relational database tables of data, satisfied the requirement of ' software architecture formalization parametric description, unambiguity ' and ' expressing the customer service logic '.

(3) software architecture of application system is to change along with the variation of " system's control table " thereupon.The application system of both having used development platform to set up, its software architecture is adaptive.

Thereby, we can say that development platform has reached the target call of people to Software Architecture Design:

(1) export-oriented target: express the customer service logic.

(2) interior to target: the tectonic system of describing software systems.

(3) practical target: the description of architecture should be satisfied formalization parametric description, unambiguity.

(4) high level goal: when the customer service logic changes, the architecture self-adaptation.

(5) ultimate aim: automatically generating program code and application system.

Claims

1, a kind of data base application system development platform based on the function design is characterized in that development platform comprises system's control table, menu member bag and code generator, and described menu member bag is reusable menu classification execution module; The control table of described system is the carrier of storage application system architecture characterising parameter and menu function characterising parameter, and carrier is the tables of data of relational database; Described code generator is the code generator that dynamically generates run time version according to system's control table stored parameters;

Only need carry out the function module design of system when using development platform development data storehouse application system, the menu design that functional module is used, the function design of menu, the tables of data design that menu uses, the menu window design is input to menu identity, the menu member bag name of carrying out the menu use and the functional description parameter of menu in system's control table, and need not coding code again, or, can generate application system only to not using the menu coding code of menu member bag;

A function menu of the corresponding application system of one or more records of system's control table, the corresponding record of the function menu automatic Car Plate Reading System control table of carrying out by the user during application system operation, determine menu member bag name, menu forms name, the data table name that function menu uses according to the parameter value of these recording storage, the data type that menu uses and table record filtercondition, table record index and sort method, menu forms data show and editor's regulation, customer incident disposal route and background process disposal route; And dynamic generator program run time version, call database data or file data, load the menu forms, the response customer incident, Control-Menu is carried out overall process, finishes menu function;

When increasing or having deleted menu record in system's control table, the menu of application system will increase thereupon or reduce; Menu function characterising parameter in having revised system's control table, the function of menu will change thereupon;

2, development platform as claimed in claim 1, it is characterized in that menu member bag is 3 kinds of base attributes carrying out data processing according to the database application system menu: the reusable execution module that ' the tables of data interrelational form that menu uses ', ' menu is to the use-pattern of tables of data ', ' form types that menu uses ' are classified, development platform has designed 20 menu member bags altogether.

3, development platform as claimed in claim 2, the interrelational form between the tables of data that it is characterized in that using according to the database application system menu is classified as follows to menu member bag:

1. single tables of data is called ' single master meter ';

7. the incidence relation table of originating: with the Data Source of a data table record as the newly-increased record of another tables of data, previous table is called ' source table ';

4, development platform as claimed in claim 2 is characterized in that according to the database application system menu use-pattern of tables of data being classified by following 9 kinds of methods to menu member bag:

5, development platform as claimed in claim 2 is characterized in that the method for menu member bag being classified according to the form types that the database application system menu uses, and described method is as follows:

1. the forms method of calling is divided into following 6 kinds:

● master menu calls;

● button menu calls, and promptly the window function button calls;

● OLE calls forms;

● the third party software embedded functional calls forms;

● the self-editing executable program of user calls forms;

2. the data type of forms use is divided into following 4 kinds:

● only use the big binary word segment data of tables of data;

● use file data;

3. the forms form is divided into following 6 kinds:

● unirecord forms: the resume formula forms of a tables of data;

● write down forms: many record forms that tables of data shows by row more;

6, development platform as claimed in claim 1 is characterized in that all tables of data of database application system are all used unified major key, external key and main external key correlating method, and described method is as follows:

● sublist and subtabulation, two major key xuhao, xuhao1;

● master, external key xuhao, xuhao1, xuhao2 all are defined as integer type;

7, development platform as claimed in claim 1 is characterized in that the control table of described system is divided into three major types by the stored parameters classification: system master parameter, system supplymentary controlled variable, menu background process disposal route parameter; Wherein the system master parameter is used a data table stores, is called system's control master meter; The system supplymentary controlled variable is used six data table stores, is respectively: the menu operation authority is provided with table, table record filter method table, selection input method table, management object table, tables of data primary key xuhao maximal value table, tables of data record derivation introduction method table; Menu background process disposal route parameter is stored by ' menu background process disposal route table '.

8, development platform as claimed in claim 1 is characterized in that following method is adopted in the overall design of described system control table:

9, development platform as claimed in claim 7 is characterized in that described system master parameter and system supplymentary controlled variable are:

Tables of data recording indexes and parameters sortnig that menu uses;

Carry out the flow process controlled variable;

The menu background process is handled call parameters;

Generate Web inquiry system parameter;

Menu operation authority definition parameter;

The introduction method parameter derived in the tables of data record;

Preserve the maximal value parameter of tables of data primary key.

10, development platform as claimed in claim 7 is characterized in that the method for designing of described menu background process disposal route table comprises:

1. background process disposal route overall design:

2. the parameter designing of menu background process disposal route table

Revise the manner of execution parameter of table record or delete list record;

Field is composed the constant value method parameter;

Unconditional multiword section expression formula call by value parameter;

Condition multiword section expression formula call by value parameter;

Sql statement assignment method parameter;

Call the data base procedure parameter;

11, development platform as claimed in claim 7 is characterized in that described development platform is edited system's control table stored parameters and querying method is:

12, development platform as claimed in claim 1 is characterized in that described application system is meant the application system that is made of database server, application server, client workstation three-Tier Model.

13, a kind of method of using development platform development data as claimed in claim 1 storehouse application system, when it is characterized in that using development platform development data storehouse application system, defer to following steps and will generate application system automatically:

● analysis management level, typing ' management object table ' data;

14, the method for development data as claimed in claim 13 storehouse application system will generate the Web inquiry system after it is characterized in that finishing following work automatically:

1. need are carried out the menu editing Web query page of Web inquiry;

2. in system's control master meter, import Web page name;