CN103092631B - A kind of data base application system development platform and development approach - Google Patents
A kind of data base application system development platform and development approach Download PDFInfo
- Publication number
- CN103092631B CN103092631B CN201310066589.0A CN201310066589A CN103092631B CN 103092631 B CN103092631 B CN 103092631B CN 201310066589 A CN201310066589 A CN 201310066589A CN 103092631 B CN103092631 B CN 103092631B
- Authority
- CN
- China
- Prior art keywords
- menu
- data
- record
- parameter
- tables
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the present application discloses a kind of data base application system development platform.The platform includes system control table storage unit, menu widget packet and code generator, wherein: system control table storage unit, for storing the system control table for the parameter called at runtime comprising menu widget packet, the parameter includes that system master parameter, system secondary control parameter and the processing of menu background process execute method parameter;Menu widget packet is the execution module that parameter in the calling system control table for handle type based on menu data completes menu function, and menu data processing type includes the form types that menu the tables of data interrelational form, the menu that use use the usage mode of tables of data, menu;Code generator executes code for generating in the operation of menu widget packet according to the dynamic state of parameters of system control table storage unit.Disclosed herein as well is a kind of database application system development approaches.The embodiment of the present application improves the versatility of exploitation database application system.
Description
The application be entitled " data base application system development platform based on Functional Design ", application No. is
200710017624.4, the applying date is the divisional application of China's application on April 6th, 2007.
Technical field
The present invention relates to a kind of data base application system development platforms based on Functional Design.
Background technique
In order to guarantee software quality, software reliability, reusability and maintainability are improved, when carrying out software development,
Using technologies such as object-oriented, components;But with software systems scale continue to increase and society fortune rhythm quickening, it is adjoint
The new user demand that necessarily leads to such as enterprise institution's recombination, business reorganization, scale variation so that demand change increasingly frequency
It is numerous, a series of problems is brought to the exploitation and maintenance of software systems, has caused so-called ' software crisis '.For this purpose, creation is new
Software development methodology, solve ' software crisis ', it has also become software work person's enjoys popular confidence.
For database application system, the ideal method for solving ' software crisis ' is: one general database of exploitation
Application system development platform, first, when developing any application system, only make user requirements analysis, system function design, tables of data
Design, user-interface design, do not make or make less program code design;Second, the function menu name of application system, menu are answered real
Data table name or Data Filename that existing function, menu use, data processing method, data flow regulation, the i.e. industry of user
Business model is filled in some control tables after all parameterizing, that is, produces application system;Third, when application system is run, from
It is dynamic to read these control table parameters, and dynamic generator executes code, completes system function;4th, the business model of user
When change, the function menu for increasing, deleting control table, or tables of data, menu forms and control table that modification menu uses only are needed
System maintenance can be completed without modifying code in parameter.
By effort in 6 years, for lan networking environment, Windows operating system and Orac1e database, using number
According to library server, application server, client workstation three-Tier Model the " database application system based on Functional Design
Development platform " is succeeded in developing, which has substantially achieved requirement of the people to database application system development tool.
Summary of the invention
The object of the present invention is to provide a kind of data base application system development platforms based on Functional Design, flat using exploitation
Platform need to only carry out system function design when developing database application system, without writing program code again or only to certain special
Data processing function writes code, that is, produces the application system for meeting functional requirement.
Development platform includes system control table, menu widget packet and code generator, and the menu widget packet is reusable
Menu categories execution module;The system control table is storage application system architecture characterising parameter and menu function description
The carrier of parameter, carrier are the tables of data of relational database;The code generator is the parameter stored according to system control table
The code generator of dynamic generation execution code.
The function module design of system need to be only carried out when developing database application system using development platform, functional module makes
Menu design, the Functional Design of menu, the Data Sheet Design that menu uses, menu window design, then by menu identity, execute
The function characterising parameter of menu widget packet name and menu that menu uses is input in system control table, without writing again
Program code, or only to the menu of menu widget packet cannot be used to write program code, that is, produce application system.
One or more function menus for recording corresponding application system of system control table, application system are pressed when running
The corresponding record for the function menu automatic Car Plate Reading System control table that user executes, determines function according to the parameter value of these record storages
Menu widget packet name, the menu forms name, data table name that energy menu uses, the data type and table record filtering item that menu uses
Part, table recording indexes and sort method, menu forms data are shown and editor's regulation, customer incident processing method and background process
Processing method;And dynamic generator executes code, calls database data or file data, Loading Menu forms, response is used
Family event, control menu execute overall process, complete menu function.
When increasing or deleting the menu record in system control table, the menu of application system will increase or decrease therewith;
When having modified the menu function characterising parameter in system control table, the function of menu will be changed correspondingly.
After application system puts into operation, the change of user management mechanism is by modifying relevant management organization's tables of data note
Record and use the menu priority assignation function of development platform to realize;The change of application system function is controlled by modification system
Table parameter or modification menu use tables of data, menu forms realize;That is the business model change of user does not need to carry out journey
The modification of sequence code.
Menu widget packet is 3 kinds of essential attributes that data processing is executed according to database application system menu: ' menu uses
Tables of data interrelational form ', weighing of classifying of ' usage mode of the menu to tables of data ', ' form types that menu uses '
With execution module, development platform devises 20 menu widget packets altogether.
The interrelational form between tables of data used according to database application system menu is to menu widget packet by such as lower section
Method classification:
1. single tables of data, referred to as ' single main table ';
2. two layers of subordinate incidence relation table, is referred to as ' main table ', ' sublist ', a plurality of record of sublist is subordinated to main table
One record, is known as ' and subtabulation ' when sublist is multiple;
3. three layers of subordinate incidence relation table, are referred to as ' main table ', ' sublist ', ' sublist ', a plurality of record of sublist from
Belong to a record of main table, a plurality of record of sublist is subordinated to a record of sublist, is known as ' simultaneously when sublist is multiple
Arrange sublist ';
4. the main table of coordination: single data sheet field is divided into multiple tables when more, and one of table is known as ' main table ',
Remaining multiple table is known as ' main table arranged side by side ', and the record strip number of each main table arranged side by side is identical as main table record strip number, and one by one
It is corresponding;
5. the main table of coordination and subordinate sublist, sublist is a plurality of to record a record being subordinated in the main table of coordination;
6. indexing incidence relation table: previous using the certain field values of tables of data as the index of another tables of data
Table is known as ' concordance list ';
7. source incidence relation table: the data source by a tables of data record as the newly-increased record of another tables of data,
Previous table is known as ' source table '.
Any menu of database application system may use single tables of data, it is also possible to using multiple with incidence relation
Tables of data.
Menu widget packet is carried out by following 9 kinds of methods according to usage mode of the database application system menu to tables of data
Classification:
1. to single tables of data, the main table of coordination, the main table of coordination and subordinate sublist, two layers of subordinate incidence relation table
And three layers of subordinate incidence relation table record are inquired or are edited;
2. guaranteeing data consistency to simplify data inputting, single tables of data, the main table of coordination, two layers of subordinate are closed
Join relation table and three layers of subordinate incidence relation table increase newly when recording, uses table record in source as the data of the newly-increased record of these tables
Source;
3. to accelerate to use concordance list when table record calls speed, table record queries to single tables of data or editor;
4. single tables of data by system control table regulation sorting field, summarize field and field summarized manner, to table record
Random assortment is carried out to summarize;
5. single tables of data record provides sorting field by system control table, table is recorded and carries out random assortment inquiry;
6. single tables of data is provided the date field of ' counting by the period ' by system control table, table record was carried out by the period
It counts and summarizes;
7. single tables of data selects one or more record as certain purposes as needed by user;
8. single tables of data is provided the time that ' substantial definition field ' and storage ' entity state change by system control table '
Field name inquires entity state and state of each entity before any deadline and changes the time;
9. ' judging value phase by as defined in system control table to a certain record that user in single tables of data chooses at random
Deng field name ' and ' field value comparison condition ' find out other relative recordings in the tables of data.
The form types used according to database application system menu classify by the following method to menu widget packet:
1. forms method of calling is divided into following 6 kinds:
● entree unitary call;
● button menu calls, i.e., window function button calls;
● paging menu call is called by paging menu identity, each paging menu identity uses a forms;
● OLE calls forms;
● third party software embedded functional calls forms;
● the self-editing executable program of user calls forms.
2. the data type that forms use is divided into following 4 kinds:
● only use the numerical value, character, date type-word segment data of tables of data;
● only use the big binary word segment data of tables of data;
● use the numerical value of tables of data, character, date type-word segment data and big binary field image data;
● use file data.
3. forms form is divided into following 6 kinds:
● unirecord forms: the resume formula forms of a tables of data;
● optional unirecord forms: in same menu, the inhomogeneity record of a tables of data uses different unirecord windows
Body;
● record forms: a plurality of record forms that a tables of data is shown by row more;
● it records forms with gauge outfit more: placing a plurality of record field value phase under single main table level-one index in forms top
Same field, forms lower part are taken a plurality of record of different value fields by row placement;
● more forms under upper list: main list record is placed on forms top, and lower part places sublist by row and is subordinated to the record
A plurality of record;Or sublist unirecord is placed on forms top, lower part is placed a plurality of record that sublist is subordinated to the record by row;
● left and right forms: forms or so are respectively placed and record forms more one, for selecting record to be used as certain purposes,
Left side record forms to be selected, record forms are chosen on the right.
Unified major key, external key and main external key correlating method, institute are used to all tables of data of database application system
It is as follows to state method:
● single main table, main table, side by side main table, unique major key xuhao;
● sublist and subtabulation, two major keys xuhao, xuhao1;
● sublist, side by side sublist, three major keys xuhao, xuhao1, xuhao2;
● sublist, simultaneously subtabulation, side by side main off-balancesheet key are main table major key xuhao;
● sublist or side by side sublist external key are sublist major key xuhao, xuhao1;
● main, external key xuhao, xuhao1, xuhao2 are defined as integer type;
● two layers of subordinate incidence relation table, the main table of coordination, closes at three layers of subordinate incidence relation table side by side
Owner's table and subordinate sublist are deleted according to table record of the main external key to subordinate list using cascade;
● index incidence relation table and source incidence relation table are deleted without using cascade.
The system control table is divided into three categories by the clock rate of storage: system master parameter, system auxiliary control ginseng
Number, menu background process processing method parameter;Wherein system master parameter is stored using a tables of data, referred to as system control master
Table;System secondary control parameter is stored using six tables of data, is respectively as follows: menu operation priority assignation table, table record filtering side
Method table, Select input method table, management Object table, tables of data major key xuhao maximum value table, tables of data record export import
Method table;Menu background process processing method parameter is stored by ' menu background process processing method table '.
The master-plan of the system control table uses the following method:
1. each system control table major key is defined as integer type, the major key of main table: menu is controlled by system
Serial number, menu forms serial number, the sub- serial number of menu forms and other control tables are associated, for executing menu operation when menu
Tables of data record filtering that permission, menu use, editor call Select input, calling ginseng when calling the processing of menu background process
Number;
2. the function characterising parameter of application system architecture characterising parameter and menu uses two kinds of dtd--data type definitions: whole
Number type and character string type, store these parameters using the numerical value of system control table and character field respectively;
3. the definition to parameter value avoids ambiguity using 10 kinds of definition methods.
The system master parameter and system secondary control parameter are:
Menu Type, pad name, menu sequencing method and menu execute method parameter;
The usage mode and data table correlation method parameter of tables of data, tables of data that menu uses;
Tables of data read record mode parameter that menu uses, table record filtering method parameter;
The tables of data recording indexes and parameters sortnig that menu uses;
The forms parameter that menu uses, name containing forms, save the dynamic link library names of forms, the tables of data that forms use,
Forms form calls optional forms method, date and numeric type field display format;
The function button parameter of menu forms containing Edit button, background process call buttons, OLE funcall button, is pressed
Button menu forms call buttons, menu operation help button;
Menu forms table records special editting function parameter, sets public variable containing newly-increased record, increases record duplication, selection newly
Field value, record editor's shielding, field editing shielding, field condition editor shielding are set in typing;
Tables of data record integrality and record repeat to judge parameter when editor saves;
Execute Row control parameter;
Menu background process handles call parameters;
Summarize by the period, the end of term entity state inquiry, search at random choose entity correlation table record, random assortment inquiry,
Random assortment summarizes respective processing method parameter;
Generate Web query system parameter;
Menu operation authority definition parameter;
Manage object, i.e. system user of service business responsibility compass of competency defined parameters;
Tables of data record export introduction method parameter;
Save the maximum value parameter of tables of data major key.
The design method of the menu background process processing method table includes:
1. background process processing method master-plan:
Menu background process processing method is decomposed into newly-increased table record, modification table record, deletion table record three classes data
Table records WriteMode, and devises the execution parameter of each WriteMode, generates SQL language according to these dynamic state of parameters when execution
Sentence completes tables of data write operation;For the function that dynamic SQL statements cannot be used to realize, by calling ' the database mistake write
Journey ' it realizes;
User service data table is divided into two major classes when design: value table and writing value table, value table is dynamic SQL statements
Data source, writing value table is the object table for executing write operation;
2. the parameter designing of menu background process processing method table
Major key totally 6: menu serial number, menu forms serial number, the Row control option of calling, calling function button
Serial number, executes serial number at WriteMode;
Background process calls the user intervention parameter whether executed;
Parameter is uniformly processed in Row control whole option modification field value;
Value table that write operation uses, the value table writing value table and using record and write value table recording parameters;
Judge whether write operation as defined in a certain record of this method table executes and execute count parameter;
It modifies table record or deletes the execution method parameter of table record;
When WriteMode is newly-increased table recording mode, a when write operation of every executions write the newly-increased record strip number of value table,
The major key of newly-increased record and the defined parameters of customer service keyword generation method;
Field assigns constant value method parameter;
When field uses expression formula assignment, what ' type expression ' used enumerates shape parameter;
Unconditional multi-field expression formula call by value parameter;
Condition multi-field expression formula call by value parameter;
Using another specified data table as value table, the write operation parameter of execution;
Sql sentence assignment method parameter;
Call data base procedure parameter;
Background process processing does not allow prompt information parameter when executing or being finished.
The development platform carries out editor to the parameter that system control table stores and querying method is:
System control table can be arranged menu in application system and be edited or be inquired, can also be in its except application system
Its system is edited or is inquired;
Each system control table is all made of respective editor and query interface, completes all kinds of parameter typings of its storage or looks into
Ask work;
Editor is divided into two major classes with the content of query interface, one is parameter annotates, containing parameter name, parameter operation instruction and
Parameter input format explanation, the second is parameter value edit box;
To each parameter annotation of system control table editor and query interface, the nature close to interpersonal communication is used
Language description, thus system control table be alternatively arranged as application system development personnel to the system intermediate medium that is exchanged of design and
The intermediate medium that exploitation side exchanges system function with user side.
The application system refers to be made of database server, application server, client workstation three-Tier Model
Application system.
When developing database application system using development platform, application system will be automatically generated by deferring to following steps:
(1) system control table and the fundamentals of management table of development platform are established in the database;
(2) user requirements analysis, typing fundamentals of management table data are carried out
● analysis management mechanism, typing ' management organization's table ' data;
● analysis management specification, typing ' management regulation tables of data ' data;
● analysis management level, typing ' management Object table ' data;
● typing ' Responsibility of Staff table ' data;The identifying data of ' Responsibility of Staff table ' storage system user of service;
(3) according to user requirements analysis determine function menu that the functional module of application system and functional module use and
The function that function menu should be realized;Determine menu operation permission;And by development platform tables of data master, external key regulation and customer service
It is required that establishing menu data table;
(4) according to function menu ' the tables of data interrelational form used ', ' usage mode of tables of data ', ' menu used
Form types ' determine the menu widget packet that each function menu uses;
(5) when function menu calls forms without using OLE, the tables of data and interface requirements used according to function menu is determined
Forms form creates menu forms;Determine forms date type-word section display mode, forms numeric type field display mode;Menu
To edit the Web query page when Web query menu;
(6) it determines when all kinds of users of service execute function menu to the filter condition of menu data table record;
(7) determine that menu uses the interrelational form of table when multiple tables of data;Reading field regulation when using source table;
(8) the data table index fields that function menu uses are determined;The indexed mode of date type index field;Table record
Sort field, sortord;When function menu calls forms using OLE, type field and value field that OLE is called;
(9) function button for determining function menu is pressed containing Edit button, background process call buttons, button menu calling
The paging menu identity that button, paging menu use;
(10) editor's shielding, the condition editor shielding of record, grouping editor's item that function menu records tables of data are determined
Part or method;
(11) determine that function menu edits the field shielding that tables of data records, condition field shields edit methods;
(12) determine that newly-increased table record sets public variable, constant regulation;Newly-increased record clone method;
(13) parameter designing of ' Select input method table ' is completed when field editing calls Select input method;
(14) determine summarized using random assortment, random assortment inquiry, when summarizing by period statistics, classification and method of summary
Regulation;
(15) determine that field and table must be recorded when editor saves records uniqueness judgment method;
(16) the Row control option regulation of call flow control is determined;
(17) determine that the background process that menu should be realized calls, the call buttons and call regulation that background process calls;
(18) parameter designing of ' the menu background process processing method table ' of the processing of menu background process is completed;
(19) processing routine is write to the menu that cannot use menu widget packet;It determines and calls third party software method;It compiles
Write ' data base procedure ';
(20) execution program, the application server programs of development platform are installed;Copy menu forms to application server;
The relevant parameter of the above-mentioned menu function design of typing in system control table;It installs ' self-compiling program ' and ' third party software ', fortune
Row development platform executes program and carries out menu operation priority assignation, and after each work station carries out system setting, system puts into operation.
Web query system will be automatically generated after completing following work:
1. to the menu editing Web query page that need to execute Web query;
2. being controlled in system and inputting Web page name in main table;
3. the Web query program of development platform to be copied to the Web server of enterprise, Web query system can put into fortune
Row;
4. execute Web query, the menu definition parameter of main table, tables of data indexing parameter, Web page will be controlled according to system
Face name parameter, dynamic generation Web query menu and the Web query page.
Detailed description of the invention
Fig. 1 is to develop database application system flow chart using development platform.
Fig. 2 is the editing interface 1 that system controls main table.
Fig. 3 is the editing interface 2 that system controls main table.
Fig. 4 is the editing interface 3 that system controls main table.
Fig. 5 is the editing interface 4 that system controls main table.
Fig. 6 is the editing interface 5 that system controls main table.
Fig. 7 is menu background process processing method table editing interface 1.
Fig. 8 is menu background process processing method table editing interface 2.
Fig. 9 is menu background process processing method table editing interface 3.
Figure 10 is Select input method table editing interface.
Figure 11 is table record filtering method table editing interface.
Figure 12 is menu operation permission configuration interface.
Figure 13 is management Object table editing interface.
Figure 14 is tables of data record export introduction method table editing interface.
Specific embodiment
In order to further appreciate that the contents of the present invention, the present invention is described in detail below.
Menu widget packet
1, the Data Management Analysis of database application system:
The data that database application system uses are divided into two major classes by storage mode: one kind is with the storage of data sheet form
Data in database, referred to as database data, another kind of is file data.
Database data is divided into the big binary word segment data (data such as text, figure, image, sound) of tables of data again,
Two kinds of field data (numeric type, character type, date type data) is often used with tables of data.
Use to file data generallys use management data table filename, according to filename and file store path tune
With the method for file data.
Database application system is made of function menu one by one, any function menu of application system, no
Be outside different one or more of the data type of these types is read out from database or file storage medium it is aobvious
Show computer screen, i.e., browsed or edited on term ' forms ', then carry out some back-end data processing work, finally will
Implementing result is saved in database or file.
2, the tables of data interrelational form that menu uses:
Any menu of database application system may use single tables of data, it is also possible to using multiple with incidence relation
Tables of data, classification method are as follows:
1. single tables of data, also referred to as ' single main table '.
2. two layers of subordinate incidence relation table: referred to as ' boss's table ';Two layers of table is referred to as ' main table ' and ' sublist ', sublist are
The subordinate list of main table, a plurality of record of sublist are subordinated to a record of main table;Subordinate list can be one or more, be multiple
When be known as ' and subtabulation '.
Example: substation's record on duty: being main table, each value by field definitions such as power transformation station name, shift on duty, dates on duty
Logging multiple attribute fields, such as working time, action be defined as sublist;Then a certain value some day in sublist
A plurality of logging be subordinated to one of main table record.
3. three layers of subordinate incidence relation table: referred to as ' boss, sublist ';Three layers of table be referred to as ' main table ', ' sublist ',
' sublist ', sublist are the subordinate list of main table, and a plurality of record of sublist is subordinated to a record of main table, and sublist is sublist
Subordinate list, a plurality of record of sublist are subordinated to a record of sublist;Subordinate list can be one or more, and sublist is multiple
When be known as ' and subtabulation ', be known as ' arranged side by side sublist ' when sublist is multiple.
4. the main table of coordination: single tables of data, literary name section is more, and different fields uses different forms, in order to
Design is convenient, accelerates meter reading writing speed, is broken down into multiple tables;One of table is known as ' main table ', remaining multiple table
Referred to as ' main table arranged side by side ', the record number of each table is identical as main table record number in main table side by side, and each record pair
It should one of main table record.
Example: annual work summarizes the page for being divided into multiple fixations, every page have it is different summarize project, use a tables of data
Field is too many when preservation, calls speed slow;Using summarizing one tables of data of item setup and solve this problem to every page,
The tables of data record that each page uses simultaneously carries out unified call according to incidence relation again.
5. the main table of coordination and subordinate sublist: one or more sublists are subordinated to the main table in the main table of coordination, son
The a plurality of record of table is subordinated to a record of main table;It is known as ' and subtabulation ' when sublist is multiple.
6. index incidence relation table: a tables of data is application system base data table, such as ' the name set table of object ' or
' the name set table of people ', another table are the fructification attribute description table of all entities of base data table record, table note
Item number is recorded far more than base data table record strip number;Base data table is known as ' concordance list ', fructification attribute description table is known as
' main table ';Speed is called in order to accelerate main table record, concordance list is used to describe the key value of entity as indexing, according to two
Table describes the equal incidence relation of key value that entity uses and calls main table record, referred to as ' index incidence relation '.
Example: there are several hundred transmission lines of electricity in certain power supply company, stores line properties using tables of data ' transmission line of electricity title table ';
Every route has tens bases to several hundred base shaft towers, stores shaft tower attribute using tables of data ' shaft tower detail list ';Shaft tower detail list can
There can be tens of thousands of records, it is slow several times when calling directly;When inquiring shaft tower attribute, by ' transmission line of electricity title table ' as index
Table, ' shaft tower detail list ' are used as main table, and line name calls shaft tower detail as index key, according to selected line name
The shaft tower of table corresponding line records, then record is few, calls speed fast.
7. source incidence relation table: using ' base data table ' record of some application systems or ' industry standard tables of data '
The data source as the newly-increased record of other tables of data is recorded, to accelerate input speed and guarantee data consistency, these bases
Plinth tables of data or industry standard tables of data are referred to as ' source table ';It is closed when execution according to source table and by the association between editor's table
Source table record calls in system, referred to as ' source incidence relation '.
Example: being used as source table for tables of data ' name doctor prescription table ', calls ' name according to the doctor of patient's prescription name and prescription name
Cure prescription table ' record, it increases the data source of record when as input patient's prescription newly, then can accelerate input speed and guarantee data
Consistency.
3, usage mode of the menu to tables of data:
Menu is divided into following 9 kinds to the usage mode of tables of data:
1. to single tables of data, the main table of coordination, the main table of coordination and subordinate sublist, two layers of subordinate incidence relation table
Or three layers of subordinate incidence relation table table record are inquired or are edited.
2. guaranteeing data consistency to simplify data inputting, single tables of data, the main table of coordination, subordinate association are closed
When main table, sublist or the sublist of system increase record newly, use table record in source as the data source of the newly-increased record of these tables;It can
Primary newly-increased source table meets the record of the record number of system control table rated condition, or the source table record chosen at random
Several records;And provided according to system control table, copy one or more field values of source table respective record to these tables
The corresponding field of newly-increased record.
Example: aforementioned input patient's prescription, after certain prescription for selecting ' name doctor prescription table ' certain to cure, by multiple in prescription or
Whole medicinal material title records increase patient's prescription table newly, and copy the quantity and unit price of selected medicinal material.
3. to accelerate to use concordance list when table record calls speed, table record queries to single tables of data or editor.
4. single tables of data by system control table regulation sorting field, summarize field and field summarized manner, to table record
Random assortment is carried out to summarize;The one or more sorting fields being randomly assigned when execution by user, take not according to sorting field
With value, or the classification value or classification value range that are randomly assigned, carries out statistic of classification and summarize.
Example: substation equipment account, sorting field are as follows: power transformation station name, device class (main transformer, sf6 breaker, oil-break
Device, vacuum circuit breaker, voltage transformer, current transformer etc.), summarizing field is ' original value of the equipment ', and summarized manner is ' summation ';
When the sorting field that user specifies is power transformation station name, then each substation's tabulating equipment initial value is pressed;When specified category words
When section is device class, then each device class tabulating equipment initial value is pressed;When selecting a certain substation and make device class
When for specified sorting field, then summarize all original values of the equipment of the substation by device class.
5. single tables of data record provides sorting field by system control table, table is recorded and carries out random assortment inquiry;It holds
The classification value or value range for the one or more sorting fields being randomly assigned when row by user are inquired by classification;
Illustrate: random assortment inquiry summarizes that the classification method that uses is identical with random assortment, but obtain the result is that satisfaction
The tables of data of querying condition records.
6. single tables of data is provided the date field of ' counting by the period ' by system control table, table record was carried out by the period
It counts and summarizes;Remember when execution by the tables of data that user obtains meeting period condition to the when segment limit that the field is randomly assigned
Record, and execute and calculating is summarized to close item purpose as defined in system control table.
Example: to a certain tables of data automatically generate annual, monthly, season, ten days, week, day statistical report form or stochastic inputs when
Between interval stats report.
7. single tables of data selects one or more record as certain purposes as needed by user.
Example: when editor's outbound list, the goods and materials recalled are needed to pick out by some in warehouse.
8. single tables of data is provided the time that ' entity classification field ' and storage ' entity state change by system control table '
Field name, according to entity classification field determine table record substantial definition method, inquire each entity any deadline it
Preceding entity state and state change the time.
Example: specified time is certain moon in year, when statistics ' substation's Load Shedding According To Frequency device throwing move back table ' ends the end of month
' state is moved back in throwing ' and ' time of origin thrown or moved back for the last time ' of all Load Shedding According To Frequency devices of substation, here, ' substation
Name ' and ' Load Shedding According To Frequency device name ' be entity classification field, ' time of origin thrown or moved back ' be ' entity state change when
Between ' field.
9. ' judging value phase by as defined in system control table to a certain record that user in single tables of data chooses at random
Deng field name ' and system control table as defined in ' field value comparison condition ' find out other relative recordings in the tables of data, hold
The a certain work of row.
Example: in ' in customer order table ', choosing a certain order record of a certain client at random, inquires this order of client hair
All order records before phase birthday;Here, ' customer name ' is to judge the equal field name of value, ' order date of occurrence it
Before ' it is defined field value comparison condition.
4, the form types that menu uses:
Menu forms are divided by following ' forms method of calling ', ' data type that forms use ', ' forms form '
Class, referred to as ' form types that menu uses ';
1. forms method of calling is divided into following 6 kinds:
● entree unitary call, referred to as ' main menu forms ';
● button menu calls, i.e., window function button calls, referred to as ' button menu forms ';
● paging menu call is called by paging menu identity, referred to as ' paging forms ';Example: as aforementioned annual work summarizes
There is the page of multiple fixations, every page has one ' Page Name ', and ' Page Name ' is used as each page of menu call, each
A page uses a paging forms;
● OLE calls forms;Example: CAD diagram, the forms that WORD document etc. uses are called.
● third party software embedded functional calls forms;Example: a certain menu of application system is soft using GIS-Geographic Information System
The map forms being embedded in when part.
● the self-editing executable program of user calls forms.
2. the data type that forms use is divided into following 4 kinds:
● only use the numerical value, character, date type-word segment data of tables of data;
● only use the big binary word segment data of tables of data;
● use the numerical value of tables of data, character, date type-word segment data and big binary field image data;
Example:
Resume is embedded in photo;
● use file data.
3. forms form is divided into following 6 kinds:
● the resume formula forms of a tables of data, forms only use tables of data one record, referred to as ' unirecord window
Body ', referred to as ' list ';
● in same menu, the inhomogeneity record of a tables of data uses different unirecord forms, referred to as ' can menu note
Record forms ', referred to as ' menu ';Be divided into using index value menu, double click record more in a certain record, according to this record it is a certain
Defined two kinds of field value menu;
Example: the device type of substation equipment account includes main transformer, breaker etc., and the account parameter of main transformer and breaker is not
Together, using different unirecord forms;When editor, inquiry substation equipment account, if main transformer, main transformer unirecord window is used
Body uses breaker unirecord forms if breaker;
● a tables of data is by a plurality of record forms of row display, referred to as ' mostly record forms ', referred to as ' more ';It can ring simultaneously
It answers ' double click records event ' to call more and corresponding unirecord forms or optional unirecord forms is recorded by double-click, respond ' mouse
Mark, which is clicked, returns to more record button ' events, returns to more record forms;
● place the identical field of a plurality of record field value under single main table level-one index, forms lower part in forms top
The a plurality of record of different value fields, referred to as ' band gauge outfit records forms more ', referred to as ' taking the lead ', forms top are taken by row placement more
Field is known as ' gauge outfit ';
' double click records more ' event calling can be responded simultaneously, corresponding unirecord forms are recorded by double-click, respond ' mouse
Mark, which is clicked, returns to more record button ' events, returns to band gauge outfit and records forms more;
Example: when by department's inquiry, printing employee's register, department's name is placed on forms top, same portion as gauge outfit
The a plurality of record of door employee is placed on forms lower part by row.
● main list record is placed on forms top, and lower part is placed a plurality of record that sublist is subordinated to the record by row;Or window
Sublist unirecord is placed on body top, and lower part is placed a plurality of record that sublist is subordinated to the record by row;Referred to as ' above more windows under list
Body ', referred to as ' upper single lower more ';
' double click records more ' event calling can be responded simultaneously, corresponding unirecord forms are recorded by double-click, respond ' mouse
Mark clicks more record button ' events that return, more forms under list in return;Or response ' double click mostly record ' event calling is double
It hits and records corresponding button menu forms, response ' mouse-click return main menu button ' event, more forms under list in return;
Example: such as aforementioned substation record on duty, the power transformation station name, shift on duty, date on duty of main table are placed in forms top
Etc. fields, lower part a plurality of logging of each value is placed by row;
● forms or so are respectively placed and record forms more one, and for selecting record to be used as certain purposes, the left side is waited for
Choosing record forms, record forms, referred to as ' left and right forms ' are chosen in the right;
Response ' double click record ' event make to be recorded between the forms of left and right and move (the double-click a certain record of left side forms,
The record moves to the right forms, double-clicks the right a certain record of forms, which moves to left side forms);It can once select as needed
Select one in the record forms to be selected of the left side, it is a plurality of or all record as choosing record, move on on the right of choose record forms;
Same tables of data can be used in two forms, it is possible to use different data table;
Example: such as aforementioned editor's outbound list, left side forms are that optional goods and materials record, the right forms are that goods and materials is chosen to remember in warehouse
The a certain goods and materials record of record, the double click left side or the right forms, which executes, to be chosen or abandons.
5, menu widget packet design principle:
Above-mentioned ' the tables of data interrelational form that menu uses ', ' usage mode of the menu to tables of data ', ' window that menu uses
Body type ', it is the classification method that development platform executes data processing to menu, referred to as ' menu data processing type '.
Development platform classifies to database application system menu by menu data processing type, and every one kind menu uses
One execution module, referred to as ' menu widget packet '.
Menu widget packet uses the design method similar to function, and call parameters are deposited using the system control table of development platform
Storage, application system read these parameters when running, dynamic generation executes code, complete menu function.
Menu widget packet is the execution module based on menu data processing type level exploitation, so, database application system
The same menu widget packet can be used in all menus of same data processing type in subordination, realizes module reuse requirement.
6, Specification Design requirement of the menu widget packet to tables of data:
Call speed and in order to accelerate table record convenient for the design of menu widget packet, tables of data of the development platform to application system
There is Specification Design requirement below:
1. major key (primary key) and external key (foreign key) are defined as to all tables of data that menu uses
Integer type, and as follows using unified major key, external key and main external key correlating method, design method:
Single main table, main table, side by side main table, unique major key xuhao;
Sublist and subtabulation, two major keys xuhao, xuhao1;
Sublist, side by side sublist, three major keys xuhao, xuhao1, xuhao2;
Sublist, simultaneously subtabulation, side by side main off-balancesheet key are main table major key xuhao;
Sublist, side by side sublist external key are sublist major key xuhao, xuhao1;
Major key xuhao, xuhao1, xuhao2 are defined as integer type.
2. subordinate incidence relation table (boss's table, boss, sublist), the main table of coordination, the main table of coordination and subordinate
Sublist is deleted according to table record of the main external key to subordinate list and main table arranged side by side using cascade;It indexes incidence relation table and source is closed
Join relation table to delete without using cascade.
3. increasing two values type-word section, a character type field and one to the various types tables of data that menu uses
A date type-word section, and unified field name is used, for storing the human editor identity of the newly-increased record of tables of data and increasing record newly
Date, the field name used are as follows:
Ejbmbh1: the industry number of human editor;Bzbh: teams and groups' number of human editor;Operator: the personnel of human editor
Number;Operdate: newly-increased record date;
The first two is numeric type field, and operdate is date type-word section, and operator is character type field;
When newly-increased table record, aforementioned four field value is set with the personal part of login and system time, for personal by operation
Part filter table record or other functions use.
7, development platform devises 20 menu widget packets altogether, is listed below:
(1) one table one page forms component packet, abbreviation w_ltable_lpage, using a tables of data, function is as follows:
● to the main table of single main table, two layers and three layers subordinate incidence relation, carry out table record queries, editor;It uses
Forms are divided into four kinds: mostly record forms, and band gauge outfit records forms, unirecord forms, optional unirecord forms more;
● single main table record is exported as into Excel table data;
● Excel table data are imported into single main table;
● batch replacement is executed to the single main a certain field value of table.
(2) boss's table forms component packet, abbreviation w_zhu_zi;Use two layers of subordinate incidence relation table: a main table and one
A sublist;Function is as follows:
● main literary name section indexes, and using more forms under upper list, is inquired main table record and sublist subordinate record, is compiled
Volume;
● main table is indexed with sublist field, and using unirecord forms, optional unirecord forms, the forms that record to sublist more
Record is inquired, is edited.
(3) boss, sublist forms component packet, abbreviation w_zhu_zi_zizi;Use three layers of subordinate incidence relation table: one
A main table, a sublist and a sublist;Function is as follows:
● main table and sublist field index, using more forms under upper list, to sublist record and sublist subordinate record into
Row inquiry, editor;
● main table and sublist field index, using unirecord forms, optional unirecord forms, mostly record forms, and antithetical phrase
Table or sublist record are inquired, are edited.
(4) main table, more sublists, sublist paging forms component packet, abbreviation w_zhu_duozi_zizi;Use three layers of subordinate
Incidence relation table: a main table and subtabulation and side by side sublist;It is indexed using paging menu identity, main table and sublist field,
Different table classes or different table classes are combined: main table, sublist, sublist, main table and sublist, sublist and sublist, using point
Page forms are inquired, are edited;
Paging forms can be unirecord forms, optional unirecord forms, record more windows under forms, upper list more
Body;Second level paging forms can be used in paging forms, are called by second level paging menu identity;
Example: station work uses three layers of subordinate incidence relation table: ' service work planning chart ' is main table, ' teams and groups
Personnel assignment table ', ' teams and groups' work ticket table ', ' teams and groups' material receives table ' be and subtabulation, ' material list ' be ' teams and groups' material
Receive table ' subordinate sublist;' power transformation station name ', ' date of survey ' and the paging menu identity of use and maintenance work schedule: ' class
Group personnel assignment ', ' work ticket ', ' material requistion ' as index;
Main table keyword xuhao value is obtained according to power transformation station name, the date of survey of selection first, then according to main table, son
Table, the incidence relation filtering sublist of sublist, sublist record;
If selecting paging menu ' teams and groups' personnel assignment ', more notes of more record forms inquiry teams and groups' personnel assignments are used
Record;
If selecting paging menu ' work ticket ', ' the teams and groups' name ' of teams and groups' work ticket table is indexed as next stage, is used
Unirecord forms inquire the unirecord of each class of work ticket;
If selecting paging menu ' material requistion ', ' teams and groups' name ' that teams and groups' material receives table is indexed as next stage, choosing
After teams and groups' name, ' the material requistion cover ' forms, forms second level paging menu identity shown above: ' material requistion of this class of material requistion are shown
Cover ' and ' material specification ', it selects ' material specification ', then inquires more records of teams and groups' material specification, choosing using more record forms
' material requistion cover ' returns to material requistion cover forms.
(5) multilist multipage forms component packet, abbreviation w_ntable_npage;
The table used is divided into 4 kinds: the 1. main table of coordination, 2. main table with and subtabulation, 3. the main table of coordination with
Sublist, 4. single main table;
The forms used: paging forms;One or two table can be used in each paging forms;
Forms form: unirecord forms record more forms under forms, upper list more;
Function: being 1. indexed using main literary name section and paging menu identity, and corresponding paging forms are called, and is executed to different tables
Or inquiry, the edit operation of same table different field;2. increasing main table newly using source table to record, source literary name section and paging are used
Menu identity is indexed, and calls corresponding paging forms, executes inquiry, edit operation to different tables or same table different field;
Example: as aforementioned annual work summarizes using the main table of coordination, it is also possible to have one ' individual event work sublist ', store
The work of each year summarize in individual event work a plurality of record;Using annual work summarize the Page Names of multiple pages as
Each page of menu call, each page use a paging menu forms;When calling is somebody's turn to do ' individual event work ', using more
Record forms use unirecord forms when calling other pages.
(6) it inquired using the main table of source table editor or using concordance list, edit main table, main table forms component packet, abbreviation w_
ly_zhu;Use a main table and a source table or a main table and a concordance list;Record forms, Dan Ji using main table more
Record forms record forms with gauge outfit more;
Function: 1. being indexed using source table and main literary name section, or only use source literary name section and index, and is executed using next
Source table increases main table record newly;2. being indexed using index literary name section, main table is inquired or edited.
(7) source table editor's sublist, boss's table forms component packet, abbreviation w_ly_zi are used;Use a main table, one
Sublist and a source table;Use more forms under list on boss's table;
Function: being indexed using main table, is called source table record according to main table and source table incidence relation, is executed using next
Source table increases sublist record newly.
Example: each substation has multiple equipment to be joined when relieving, and the equipment that each substation need to be joined is used
One source table storage stores power transformation station name and changeover time with main table, equipment state sublist when joining each time
Storage;As soon as then whenever handover head of a theatrical troupe's table record of newly-increased substation, from source table copy the substation need to join it is complete
Sublist is recorded in portion's equipment.
(8) source table choosing record increases main table record, left and right forms component packet, abbreviation w_ly_xz_zhu newly;Use a master
Table and a source table;Use left and right forms;
Function: source table and main literary name section are made to index or only use source literary name section to index, and execute and are selected using source table
Record increases main table record newly;Table record to be selected in source uses left side forms, forms on the right of the newly-increased record use of main table.
(9) main table or so forms select recording member packet, abbreviation w_zhu_xz_zhu;Use a main table;Use left and right window
Body;
Function: main literary name section indexes, and choosing record, left side forms record to be selected, the right forms choose record.
The component packet can be used as main menu use, also can be used as button menu use.
(10) table choosing in source records newly-increased sublist record, left and right forms component packet, abbreviation w_ly_xz_zi;Use a master
Table, a sublist and a source table;Use left and right forms;
Function: main literary name section indexes, and records newly-increased sublist using the choosing of source table and records;Left side forms source table note to be selected
Record, the newly-increased record of the right forms sublist.
(11) source table choosing record increases sublist record, left and right forms component packet, abbreviation w_ly_xz_zi zi newly;It uses
One main table, a sublist and a source table;Use left and right forms;
Function: main table, sublist field index, and increase sublist newly using source table choosing record and record;Left side forms source
Table record to be selected, the newly-increased record of the right forms sublist.
(12) source table is associated with main table, inquiry editor boss's relation table record, more forms component packets under upper list, abbreviation w_
ly_zhu_zi;One main table, a sublist and a source table;Using more forms under list on boss's table, forms top is main table
Unirecord, lower part are that sublist subordinate records more;
Function: main table 1. is increased newly using source table record and is recorded, then editor boss's table records;2. using source literary name section
Main table, sublist record are inquired according to source table and main table incidence relation as index.
(13) random assortment summarizes component packet, abbreviation w_grop_by_total;Using recording forms one, on forms more
The classification value select button of sorting field is placed in portion, and Classifying Sum record is placed in forms lower part;
Function: single main table does not repeat value, or selection all by each field of multiple sorting fields of user's selection
Classification value, to table record carry out random assortment, wherein date type sorting field may be selected as needed: per year, by half a year,
Quarterly, monthly, by half a month, by ten days, by week, per diem, on time, classify by the time-division;And to multiple defined numeric fields
Execute Classifying Sum or statistic record number;Method of summary includes: summation, is averaging, and maximizing is minimized, the side of asking
Difference;Classifying Sum record is automatically generated when execution.
(14) random assortment inquires forms component packet, and abbreviation w_grop_by_query uses record forms, window more than one
The classification value select button of sorting field is placed on body top, and the record for meeting querying condition is placed in forms lower part;
Function: the classification value that each field in multiple sorting fields that single main table is selected by user takes, or it is random defeated
The date type sorting field value range entered is filtered table record as table record filtering condition, obtains meeting inquiry item
The record of part.
Date classification field value range 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. two dates it
Between, the same month in not the same year is 7. specified, the same day of the not different moons in the same year is 8. specified;
' the same month ' the example in specified not the same year: the record of all generations in December of a certain tables of data;
' same day ' the example of the specified difference moon in not the same year: all records occurred on the 1st of a certain tables of data.
(15) summarize component packet, abbreviation w_ly_zi_by_date_total by period statistics;Record window using under upper list more
Body;The date type-word section that storage executes statistics is specified by system control table;
Function: single main table presses the statistical time range of stochastic inputs, and the table for obtaining meeting statistical condition to table record filtering is remembered
Record, and execute the Classifying Sum to specific project;Use more forms under upper list;Statistical time range is in forms top and summarizes project,
Forms lower part is the entity mostly record for meeting statistical time range condition;
Example: various annual, monthly, seasons or random time interval statistical form.
(16) end of term entity state inquiry component packet, abbreviation w_ly_zhu_date_last;Use more record forms;Function
Can: to single main table, the substantial definition method of table record is determined by the entity classification field of system control table, by system control table
Date type index field designated entities particular community state change time field name, by the date type-word section of system control table
Time in the end of term classification of indexed mode designated entities state change inquiry;Date type-word segment index mode can be year, month, day,
Corresponding time in end of term classification be respectively as follows: by 24 points of a certain last day in year, by 24 points of last day in certain in January, by certain
One day 24 points;
Using Time To Event index value as the end of term time conditions when execution, inquires each entity and correspond to the deadline
Particular state and last time state before changes the time occurred;
Example: by 24 points of last day of certain January, ' opening ' or ' conjunction ' state that substation all switchs, and last time
' opening ' or ' conjunction ' time of origin.
(17) it searches and chooses entity correlation table recording member packet, abbreviation w_ly_zhu_dt_filter_zhu at random;
Function: single main table user chooses a certain item to record at random, takes by substantial definition field as defined in system control table
Value and comparison condition filter out the relative recording for choosing entity.
Use a main table and a source table;One forms, the alternative more records in top, below to choose record it is relevant
More records;
Example: choosing a certain order record of a certain client in ' in customer order table ' at random, inquires this order of client hair
All order records before phase birthday.
(18) big binary system and file data component packet, abbreviation w_call_blob_file are called;Function: by file data
The big binary field data of tables of data are converted to file, to the big binary word of tables of data by the big binary field of write-in tables of data
Segment data or file data execute OLE and call;
The component packet can be used as main menu use, also can be used as button menu use.
(19) third party software component invoking packet: the data for being defined menu by system control table and being used, it is soft to third party
Part carries out embedded functional calling.
(20) the self-editing standalone executable program component invoking packet of user executes user's self-compiling program using menu call, but
The data defined by system control table cannot be used.
Note 1: in above-mentioned menu widget packet: w_ltable_lpage, 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 make
With button menu, main menu tables of data and button menu tables of data or file data are inquired, edited.
Note 2: each main menu of application system is all in accordance with needing using one in above-mentioned 20 menu widget packets;Button
Menu in addition to using ' OLE call forms ' and using the component packet of ' left and right forms ', be not provided with using component packet name;Paging
Menu only needs main menu to define the component packet name used.
System control table
1, the design principle of system control table
The whole design thought of development platform is using the design method similar to function, by the institute of database application system
Functional module design is the execution pattern that the parameter stored by outer carrier is called.
The system function of database application system is made of function menu one by one, any moment of system operation,
Any one user is only possible to use a function menu, belongs to discrete way operation.The record format of relational database tables of data,
It can satisfy the parameter designing requirement of database application system menu discrete way operation.
Development platform is by the multiple tables of data of the relational database of memory function module call parameters, referred to as ' system control
Table ', the design to system control table has following 3 basic demands:
1. the needs of parameter designed meets description application system architecture and executes menu widget packet;
2. the definition of parameter should not have an ambiguity, whens calling functional modules is unique to the explanation of these parameters;
3. the editor and modification to parameter are convenient.
2, database application system architecture characterising parameter and menu function characterising parameter avoid ambiguous design side
Method:
(i) database application system architecture characterising parameter and menu function characterising parameter fundamental type are divided into: non-to enumerate
Shape parameter enumerates shape parameter and three kinds of expression argument, is described as follows:
1. non-shape parameter of enumerating includes numeric parameter and two kinds of string argument, numeric parameter is defined using integer, character
String parameter is defined using character string;For example, the record line number of mostly record forms is defined using integer, menu identity, what menu used
Data table name etc. is defined using character string.
2. enumerating shape parameter: the value number of parameter is denumerable, then parameter enumeration type parameter definition;Enumerate shape parameter
Value is defined using the integer serial number of mark enumerated value.
Example: ' menu background process processing method table ' write record mode is divided into six kinds, is described as follows with shape parameter is enumerated: 0
Judge whether to exit calling, 1 newly-increased record, 2 modification records, 3 deletion records, 4 have record modification, and no record is newly-increased, and 5 call number
According to library process;Serial number: 0,1,2,3,4,5 definition is enumerated in parameter value use;Such as: being ' increasing record newly ' when parameter value is equal to 1, compiling
Ambiguity will not be generated when collecting parameter and module calling.
3. expression argument: defining that method is identical with expression formula used in database SQL sentence, as tables of data records
Filter condition expression formula.
(ii) as follows to the concrete regulation of parameter definition:
First: non-enumeration type numeric parameter integer or integer sequence define, and the integer in integer sequence uses agreement point
It is separated every symbol.
Second: non-enumeration type string argument character string, character string sequence or text definition;Wherein character string sequence is used
It is separated between multiple character strings, character string with agreement separator.
Example: the data table name that menu uses is defined with character string;What multiple index field names of tables of data were separated with comma
Character string sequence definition;Text definition is used in the operation help of menu.
Third: the integer definition that shape parameter mark enumerates serial number is enumerated.
4th: parameter is conditional expression, date expression formula, numerical expression, character expression, statistics calculation expression
When, it is defined using the corresponding expression formula in database SQL sentence;Referred to as ' expression argument '.
5th: when a parameter uses multiple enumeration type subparameters, referred to as ' enumeration type subparameter ', with integer sequence or
The parameter is defined with an integer;When being defined with integer sequence, subparameter number is equal to the integer number of integer sequence, integer
It is separated between integer in sequence using agreement separator, the corresponding subparameter of each integer;When being defined with an integer,
Subparameter number is equal to the digit of integer, and each of integer corresponds to a subparameter;Note that when being defined using an integer,
Enumerated value is no more than 9.
Example 1: shape parameter: 1 ascending order, 2 descendings are enumerated in the sequence use of tables of data record, and define multiple words with an integer
Section sort method;When being sorted using a field, parameter is 1 integer;When being sorted using two fields, parameter is two whole
Number, ten bit identification first character section sort methods of integer, second field sort method of a bit identification;A certain tables of data has two
A sort field: field1, field2, field field1 sort in descending order, and field field2 is sorted in ascending order, then parameter uses
Integer ' 21 ' identifies.
Example 2: shape parameter is enumerated in date field indexed mode use: 1 year, 2 half a year, and the third quarter, April, 5 half a months, 6 ten days, 7 weeks,
8 days, 9 time-divisions, and defined with integer sequence;A certain tables of data has a date index field datel, and the first order indexes rope per year
Draw, second level index per diem indexes, then parameter is identified using integer sequence ' 1,8 '.
Six: one parameter using it is multiple it is available enumerate shape parameter when, referred to as ' enumeration type optional parameters ', using not
The digit of 01 sequence definition of number with separator, 01 sequence is equal to optional parameters number, each corresponds to 1 optional parameters,
A certain position is equal to 1, and mark uses this corresponding optional parameters, is equal to 0, mark does not use this corresponding optional ginseng
Number.
Example: table records Edit button and uses 8 bit digital, 01 sequence definition, the corresponding Edit button rule of each of 01 sequence
Be set to: 1 increases main table record newly, and 2 delete main table record, and 3 newly-increased sublist records, 4 delete sublist record, and 5 increase sublist record newly,
6 delete sublist record, and 7 save, and 8 abandon editing;
When a certain position of 8 bit digital, 01 sequence is equal to 1, then using the corresponding Edit button of this, a certain position is equal to 0, then not
Use the corresponding Edit button of this.Such as: 01 sequence definition is ' 11000011 ', then the Edit button used are as follows: increase main table newly
Record deletes main table record, saves, abandon editing.
Seven: one parameter uses multiple subparameters, subparameter can with right and wrong enumeration type parameter, enumerate shape parameter or expression
Formula parameter is separated between subparameter, referred to as ' combination parameter ' with the separator of agreement.
8th: if a certain subparameter is defined using character string, character string sequence, integer sequence or expression formula in combination parameter
When, they are included using the identifier of agreement, is labeled as a subparameter.
9th: the parameter described with combination parameter there are two types of and when two or more different usages, by each user
The combination parameter of method is included using the identifier of agreement, is separated between method with the separator of agreement.
Example: menu forms date type-word section display format is defined as: [table class, { year field list of file names }, { days field name
List }, { date field list of file names }, { time-division date field list of file names }];
Wherein ' table class ' is enumeration type subparameter, is seen below ' system control table is common to enumerate shape parameter ', minor ginseng
Number is defined with the character string sequence that { } includes;The format parameter of each table class of menu forms is included with [], the lattice of multiple table classes
Formula parameter is separated with comma.
Tenth: system control table is common to enumerate shape parameter:
' 1. table class ', the tables of data or execute the tables of data that reading and writing operate with that menu forms use: 1 main table, 2 sublists,
3 sublists, 4 source tables, 5 main tables arranged side by side, 6 and subtabulation, 7 sublists arranged side by side, 8 button menus newly newly lead by main table, 9 button menus
Sublist, 10 left side menu widget packet W_zhu_xz_zhu forms tables.
Illustrate: the data table name that menu uses is in system control table with corresponding ' table name ' parameter identification, menu forms
The tables of data that the tables of data or execution reading and writing used operates with is identified with ' table class ', calls corresponding data according to ' table class '
Table;Such as: table class is equal to 1, then the tables of data for calling ' main table name ' to identify.
' 2. public variable ', the global variable of preservation login personal part when application system is run: 1 department name, 2 teams and groups name, 3
Name, 4 teams and groups' classes, 5 shifts on duty, 6 system datas, 7 system times, 8 tier-2 departments name, the set name of the object of 9 management, 10 pipes
The set name of the people of reason, 11 department's classes, 12 logs number taken turns at keeping watch, departments No. 13, teams and groups No. 14,15 unit names.
3, system control table master-plan
The data processing object of database application system is divided into four layers: function menu, tables of data, table record, literary name section;System
System process is divided into two major classes: foreground process and background process;System control table is exactly by this four layer data of database application system
Processing and the different of two class system process require setting processing parameter.The parameter that system control table stores is divided into three greatly when design
Class: system master parameter, system secondary control parameter, the processing of menu background process execute method parameter;Wherein preceding two class belongs to
The execution method parameter of application system architecture characterising parameter and the utility function for calling menu widget Bao Shiying to realize, it is latter
Class is to complete the execution method parameter of menu background process specific function processing.
System master parameter is stored using a tables of data, referred to as ' system controls main table ';
System secondary control parameter is stored using six tables of data, is respectively as follows: that ' menu priority assignation table ', ' table recorded
Filtering method table ', ' Select input method table ', ' management Object table ', ' tables of data major key xuhao maximum value table ', ' tables of data
Record export introduction method table ';
Menu background process processing method parameter is stored by ' menu background process processing method table '.
Each system control table major key is defined as integer type;
Control the major key of main table by system: menu serial number, menu forms serial number, second level paging menu serial number and other
Control table is associated, and tables of data record filtering that menu operation permission when for executing menu, menu use, editor call
Call parameters when Select input, calling background process processing.
4, system controls main table design
4.1 menu categories and major key
The menu that database application system uses is divided into three classes: main menu, button menu, paging menu.
But only one main menu of any menu;It also may include a main menu and multiple buttons menu;Or include one
Main menu and multiple paging menus;Paging menu can also have multiple second level paging menus;Paging menu and button menu are referred to as ' son
Menu '.
Major key totally 3: menu serial number, menu forms serial number, second level paging menu serial number.
' menu serial number ' is for identifying different main menus;Belong to the multiple buttons menu or paging menu of same main menu
It is distinguished with ' menu forms serial number ', ' menu serial number ' is identical as main menu;Second level paging menu uses ' second level paging menu serial number '
It distinguishes, ' menu serial number ' is identical as main menu, and ' menu forms serial number ' is identical as paging menu.
The menu forms serial number regulation of main menu is equal to 1, and the menu forms serial number regulation of submenu is greater than 1.
When application system is run, the entree unirecord that system control table menu forms serial number is equal to 1 is first carried out, then again
Executive button menu or paging menu;If the menu under a certain ' menu serial number ' without ' menu forms serial number ' equal to 1 records, neglect
Slightly it is somebody's turn to do whole records of ' menu serial number ';The menu forms serial number of main menu can be set smaller than or be equal to 0, mark entree
List and the submenu of subordinate wouldn't use, if wanting to enable the menu, which is changed to 1;If but deleting a certain menu
Record, to reactivate, then must update menu parameter.
4.2 menu identity parameters and operation instruction
The parameter used: further menu name, 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;Second level paging menu identity.
Menu must have pad name, and preceding Pyatyi menu can be set as needed;When application system is run, further menu,
Second-level menu, three-stage menu, level Four menu, Pyatyi menu, main menu and paging menu will automatically generate dish according to sort method
Single index tree;Button menu name is placed on the function button area above main menu forms automatically;Second level paging menu identity is placed on automatically
Above paging forms.
All menu identities are defined with character string;Preceding Pyatyi menu and main menu index order method are defined with integer;Point
Page menu index is sorted with major key menu forms serial number.
4.3 menus execute method, use 4 parameter definitions:
1. menu executive mode is divided into three kinds: 1 calling development platform menu widget packets, 2 third party software embedded functionals
It calls, 3 self-editing executable programs call.
Menu widget packet name, third party software name, the self-compiling program name used when 2. executing menu;They and menu execute
Mode is corresponding.
3. can be changed to W_ltable_lpage component packet when menu uses W_ly_zhu component packet and execute inquiry, use
One parameter defines whether to need to use in this way, and 0 is not, and 1 is;It can be converted between inquiry and editor when execution, log in people without volume
When collecting permission, W_ltable_lpage component packet can only be used to hold
Row inquiry.
4. 0 is not, and 1 is when value judges;When equal to 1, the non-person on duty to take turns at keeping watch does not allow using the menu;Equal to 0
When, the judgement is not done;When certain one kind, personnel have menu operation permission to some menu, but need to further provide for can only be by
The parameter is set when the person on duty to take turns at keeping watch is using menu.
1. 3. 4. parameter uses enumeration type parameter definition, 2. parameter is defined with character string;
Note: ' calling development platform menu widget packet ' refers to the preceding 18 menu widget packets for calling aforementioned development platform.
4.4 submenu types use two enumeration type parameter definitions:
1. submenu class: 0 without submenu, and 1 paging menu, 2 button menus, 3 use the newly-increased difference of table to main menu forms
The button menu of purposes record;
2. submenu class 3 increases record sheet class: 1 main table, 2 sublists, 3 sublists newly;
Illustrate 1: paging menu and button menu use respective forms;
Illustrate 2: submenu class 3 uses main menu forms, and the button menu name used is clicked for identifying different purposes
The corresponding button menu name of a certain purposes, then to record as defined in the newly-increased purposes of main menu forms;Such as: clicking ' normal
Make an inspection tour ', increase by one ' normal to make an inspection tour record ' to log, clicks ' tour of relieving ', increase by one to log and ' hand over
Tour of succeeding records '.
The tables of data and tables of data application method that 4.5 menus use, use 16 class parameter definitions:
1. menu can be used: main table, sublist, sublist, concordance list or source table, side by side main table and subtabulation, side by side son
One of sublist is a variety of;First 5 use corresponding table name parameter identification respectively in main menu, such as: ' main table name ' mark
The main table that menu uses;3 and list only need to be in main menus with corresponding ' and list table name ' parameter identification afterwards;
2. using the correlating method between table when subordinate incidence relation: main table and sublist, sublist and sublist;
3. source table or the associated table class of concordance list: 0 uses all records, 1 main table, 2 sublists, 3 sublists;
4. the correlating method of source table or concordance list and contingency table;
5. source table or concordance list read field mode: 1 whole fields, 2 part fields;
6. source table or concordance list read the field name when field of part;
7. database meter reading recording mode: 1 once runs through whole table records, and 2 primary part tables of reading record;
Note: ' primary to read part table record ' refers to and first reads index field, after user selects index, then reads to meet index condition note
Record, to accelerate meter reading speed, for ' use when the main table record of index incidence relation ' reading or single tables of data record more;
8. subordinate incidence relation boss table and boss, sublist table record filtering sequence: 1 first filters main table, further according to pass
Connection relationship filters sublist, referred to as ' sub after the former head ';2 first filter sublist, main table are filtered further according to incidence relation, referred to as ' first after son
It is main ';
Note: when using logging in personal part filter table and recording, if logging in personal part correspond to sublist, using ' first master after son ',
If logging in personal part corresponds to main table, using ' son after the former head ';
9. the index order of each table;(it is sorted using integer identification index, 0, do not index, -1, no table);
10. the index field of each table;
11. the date index field of each table;
12. date field indexed mode, for fixed date index field index value mode: 1 year, 2 half a year, the third quarter,
April, 5 half a months, 6 ten days, 7 weeks, 8 days, 9 time-divisions;
Example: the indexed mode of certain date field be ' Isosorbide-5-Nitrae, 8 ', then the first layer index by ' year mode ' index (2000,
2001 ...), the second layer index is indexed (in January, 2000,2 months 2000 ...) by ' days ' mode, and third layer index presses ' year
Month day ' mode indexes (on January 10th, 2000, January 11 ... in 2000);' half a year ' mode example: the first half of the year in 2000,2000
The second half year in year;' season ' mode example: the first quarter in 2000, the second quarter in 2000;' half a month ' mode example: in January, 2000
Half a month, the second half of the month in January, 2000;' ten days ' mode example: in early January, 2000, in mid-January, 2000;' week ' mode will rise weekly
Begin with the date of expiry as index value;' time-division ' mode added-time point after ' day ' mode;
13. one or more sort fields that the table of each table records;
14. the sort method of each list sorting field: 1 liter, 2 drops;
15. whether carry out table records the table class that number is counted and counted: 0 does not count, 1 main table, 2 sublists, 3 son
Table;
Note: after specifying the table class counted, every level-one index for selecting the table, then by the record under this grade index
Number is shown in the forms lower left corner;
16. no record prompt information when executing menu;Note: when by filter condition filter table record, nothing does not meet condition
Record, then screen shows the prompt information;
Illustrate:
1. wherein the parameter of 3.5.7.8.12.14.15. mark is identified with enumeration type parameter definition, 9. with integer;
1. 2. in and list table name parameter format are as follows: { main table name sequence arranged side by side }, and subtabulation name sequence, { side by side
Sublist name sequence };
3. main table is used for sublist correlating method parameter when menu forms are that single tables of data band gauge outfit records forms more
Define gauge outfit field.
The forms parameter that 4.6 menus use:
1. forms can use one or two tables of data as needed, may is that main table, sublist, sublist, source table,
Main table arranged side by side and subtabulation, side by side sublist, new main table, new boss's table;
The table class used using two parameter identification forms: the table class 1 that forms use, the table class 2 that forms use;
Note: only new main table, new boss's table can be used in button menu forms;New main table name is defined using main table name, new son
Table name is defined using sublist name, and new boss's table correlating method is defined using main table and sublist correlating method;
2. the new main table contingency table class that forms use: 0 is not associated with, 1 main table, 2 sublists, 3 sublists;
3. the correlating method of new main table and contingency table;
4. forms form: 1 is single, call more than 2, more than 3 with double click it is single, it is singly lower more on 4, on 5 under list mostly with double click
List is called, is mostly taken the lead 8 with double click call buttons menu forms with double click menu more than 7 under list on 6 more, 9 index choosings
It is single, 10 or so forms;
5. whether forms are displayed in full screen: 0 is not, and 1 is;
Note: being normal condition when parameter value is 0, i.e. the screen left side is index tree, and the right is forms;When parameter value is 1,
It is defaulted as normal condition, clicking button ' full screen display ', then forms occupy full frame, which becomes ' display index ', click button
' display index ', restores normal condition, which becomes ' being displayed in full screen ';
It records forms more 6. and records line number;Note: line number is reduced, can show character field alphabet;
7. menu forms index series;Note: provide which rank of index is the keyword of menu forms;
8. the table class that menu forms take key value;
9. menu forms take key value field name;
10. menu forms field value list;Note: when the last one field value is ALL, remaining corresponding all field value are used
The same forms situation is used in multiple and different values of key value field;
11. the corresponding forms list of file names of menu forms different value;
When 12. forms are using simultaneously list and list serial number: main table serial number arranged side by side, and subtabulation serial number;
13. tables of data date field display format;
14. tables of data numeric field display format;
15. boss's table date common parameter: main table date field name, sublist date field name, sublist date field classification:
January, 2 days, when 3,4 time-divisions;
Example: main table date category is ' year ', and being worth is ' 1949 ';Sublist date category is ' moon ', then sublist date field
Show ' January ', ' 2 months ' ... ' December ', but the time on sublist date is identical with main table;Main table date category is ' days ', sublist
Date category is ' day ', then sublist date field only shows that days value is identical as main table 1-31 days;Main table date category is ' year
When month day ', sublist date category be ' ' or ' time-division ', then sublist date field only shows 0-23 point or time-division, the days earning in a day with
Main table is identical;
16. saving the dynamic link library name (DLL) of forms;
17. forms name;
18. the unirecord forms name that double click record calls;
19. the printing reports name that forms use;Forms are double-clicked after preceding Main form, comma separates, and one does not have to comma;
Illustrate:
Wherein ' the sublist date field classification ' of 1.2.4.5.8. and 15. enumeration type parameter definition, 6.7.12. integer
Definition, 13.14. are defined with combination parameter;Remaining parameter character string or character string sequence definition;
13.14. combination parameter design is as follows:
Date type-word section display format: [table class, { year field list of file names }, { days field list of file names }, { date field
List of file names }, { time-division date field list of file names }]
Numeric type field display format: [table class, decimal digits, format character, { field list of file names }]
Format character: 0 processing decimal place;1 band, thousand quartile section break;Using scientific notation, (decimal digits is 2 floating numbers
Effective digital);3 plus value of money symbol $;4 plus value of money symbol $;5 negatives are shown in red;35 and 45 share for two kinds.
The function button of 4.7 menus designs:
Function button is divided into: Edit button, background process call buttons, 0LE funcall button, button menu forms tune
With five kinds of button, menu operation help button;
1. Edit button and background process call buttons totally 10: increasing main table record newly, delete main table record, increase sublist newly
Record deletes sublist record, increases sublist record newly, deletes sublist record, saves, abandon editing, main literary name segment value decomposes
Automatically newly-increased sublist record, background process call.
Whether they use the optional subparameter of enumeration type, used by the corresponding button of 10 01 sequence identifiers;When first
When equal to 2, identifies main table and sublist and increase record newly simultaneously;Main table arranged side by side is without using ' newly-increased record ' and ' deletion record ' button;
And subtabulation, sublist arranged side by side use sublist, sublist Edit button.
10 button names are defined with character string sequence;Button name can rename as needed.
Note 1: it after having input main table a certain field value, clicks ' main literary name segment value decomposes newly-increased sublist record automatically ' and presses
Button then decomposes the character string sequence of field input, increases newly automatically and identical number scale of character string number of decomposition to sublist
Record, and decomposition value is placed in defined field;
Note 2: ' background process calling ' button be ' further work process title ' button, such as: after ' notice ' editor
' issuing a notice ' etc.;Click the button, then call ' menu background process processing method table ' menu record, execute menu under
The processing of one process;
Note 3: this 10 buttons can rename as needed, and it is constant to execute method.
2. totally 5, OLE funcall button: selecting disk file, file data is stored in the big binary field of tables of data, browsing
The big binary data of tables of data, big binary data save as new file, return to the main menu page;
Identify whether corresponding funcall button uses using the optional subparameter of 5 enumeration types;
5 OLE funcall button names are defined with character string sequence;Button name can rename as needed, the side of execution
Method is constant;
The other parameters of OLE funcall: ' OLE funcall takes big binary data or takes the field name of filename ',
' OLE type field ' ' path that OLE funcall takes filename ' and ' save the field of the source filename of big binary data
Name ' character string identification is used respectively.
3. main menu call buttons menu forms button and button menu forms return to main menu forms button, two are used
A parameter definition: ' button menu name sequence ' and ' 01 sequences of call buttons menu forms ';
' 01 sequence ' first of call buttons menu forms fills out 0 when for main menu;Second starts to fill out 1, and correspondence is each
A button menu name, 1 number are equal to button menu number;
Button menu only needs first of 01 sequence to fill out 1, corresponding return main menu button name;
' button menu name sequence ' identifies its sort method simultaneously;
Button menu do not allow certain people in use, by ' button menu do not allow using condition ' parameter identification, the ginseng
Number is conditional expression;Data sheet field condition or public variable condition, when using public variable condition, public variable can be used
With ' management organization's table ' or ' Responsibility of Staff table ' corresponding field name mark.
4. third party software embedded functional button is defined using button menu.
' 5. the index series for opening newly-increased record button ' and ' the index series for opening background process call buttons ': being used for
Provide newly-increased record button or background process call buttons allow using index series, defined respectively with integer (when open
When indexing series less than defined index series, the corresponding button is in masked state).
6. shielding the regulation of other operations after clicking newly-increased record button, use combination parameter: { main table increases button shielding newly
Class list }, { sublist increases the list of button shield type newly }, { sublist increases the list of button shield type newly };
Shield type in combination parameter is identified using enumeration type argument sequence: 1 main table record increases newly and delete button, 2 sons
Table record is newly-increased and delete button, 3 sublists record newly-increased and delete button, and 4 index trees, 5 button menus, 6 main tables record new
Increase button, 7 sublists record newly-increased button, and 8 sublists record newly-increased button, 9 the 9th Edit buttons, and 10 background process calling is pressed
Button;Without using shielding when parameter is empty.
7. shielding the condition of background process call buttons: using combination parameter: table class, { condition };Table class is ' table class ' ginseng
Number, ' condition ' are conditional expression;' background process calling ' button is shielded when condition is true.
8. whether shielding index when editor, using enumeration type parameter identification, 0 is not, and 1 is.
9. ' menu operation help ', parameter text definition, screen releases help information when clicking the button.
' 10. data flowchart ', parameter is identified with filename, releases menu data stream according to filename when clicking the button
Cheng Tu.
4.8 menu forms tables record special editting function design
Totally 6 kinds of special editting functions, can be as needed using one such or a variety of;They are respectively as follows: newly-increased record
It sets public variable, newly-increased record duplication, Select input is called to set field value, record editor shielding, field editing shielding and field
Condition editor shielding.
1. newly-increased record sets the personal part public variable value of login, two groups of combination parameters are used:
1 format of combination parameter: [table class, and list serial number, { assignment field list of file names }, { the corresponding public change of field assignment
Measure serial number list }, { the constant value list that field is assigned }];
2 format of combination parameter: table class, and list serial number { assign management object value field name, call management Object table record
Public variable class, call management Object table record management object name, read management organization's table entity attribute field column
Table }, { writing management organization's entity property value list of fields };
Wherein combination parameter 1 is used to assign the personal part public variable value of login to field and constant value, public variable are system
Control table is public to enumerate shape parameter;Parameter value is equal to 0, and field assigns constant value;Parameter value is greater than 0, and field assigns public variable value;When
Public variable are as follows: when the set name of the people of the set name of the object of 9 management or 10 management, alternately by the element of corresponding set
Value, sets field value using method identical with Select input.
Example: assignment field list of file names is ' bdzm, xm, lb1, lb2 ', and the corresponding public variable serial number list of field assignment is
' 2,3,0,0 ', the constant value list that field is assigned is ' team or group plan, power failure work ', then when increasing record newly, will log in people's automatically
' teams and groups' name ' is assigned to field bdzm, will log in people ' name ' and is assigned to field xm, constant ' team or group plan ' is assigned to field lb1, will
Constant ' power failure work ' is assigned to field lb2;
Combination parameter 2 is there are two types of usage, and first for assigning management object value to field, and value table is ' management Object table ',
According to ' the public variable class for calling management Object table record ' and ' the management object name for calling management Object table record ' filtering should
Table record, the management object value for reading the record are alternately worth, and are assigned using method identical with Select input to value field is write
Value;Second for assigning management organization's entity property value to field, and value table is ' management organization's table ', according to login people in supervisor
The corresponding record of structure table reads entity attribute field value, is assigned to write value field.
Management organization's table entity attribute field can according to need setting, such as: transformer substation voltage grade, teams and groups' number etc..
2. newly-increased record duplication, use four parameters: table record clone method, according to condition record clone method, record are multiple
Literary name section is write when meter reading field, record when processed replicate, is described as follows:
● table records clone method, and totally 16 kinds, the source table and object table of record duplication are executed with enumeration type parameter identification, and
The record of duplication: 0 does not replicate, and 1 main table current record copies to main table, and 2 sublist current records copy to sublist, and 3 sublists are worked as
Preceding record copies to sublist, and 4 main table current records copy to sublist, and 5 sublist current records copy to sublist, 6 boss's tables
All record copies to sublist for forms sublists, and all record copies to sublist for 7 sublists and sublist forms sublist, 8 main tables
Sublist sublist meet the duplication of condition minute book table, 9 main literary name section decomposition values generate sublists and record more, and 10 source tables record is multiple
System, 11 main table current records copy to button menu forms table, and 12 sublist current records copy to button menu forms table, 13 sons
Sublist current record copies to button menu forms table, and 14 main table current records and the current record of source table copy to main table, and 44
Main table current record and the current record of source table copy to sublist, and all record copies to main table to 41 source tables;
● according to condition record duplication is served only for table record clone method 8, uses combination parameter, format: record duplication table
Class, { field name for seeking maximin }, the method for seeking maximin, the public variable of the filter record, { item of filter record
Part expression formula };
Its neutron parameter ' field name for seeking maximin ' can be date type or numeric type field, ' seek minimax
The method of value ', minimum with enumeration type parameter identification: 1,2 is maximum;' public variable of filter record ', with enumeration type parameter identification:
0 does not use, department No. 1, teams and groups No. 2,3 operator's names, respectively corresponds the normative field of table record: ejbmbh1, bzbh,
operator;
● meter reading list of fields when record duplication: identified with character string sequence;
● literary name section list is write when record duplication: being identified with character string sequence;
Note 1: the corresponding Edit button the 9th of clone method 9: ' main literary name segment value decomposes newly-increased sublist record automatically ', main table
Take decomposition value field name by meter reading field definition;The field of decomposition value write-in is defined by writing literary name section;
Note 2: the menu structure that the source table and object table and the record of duplication of 10 duplicated record of clone method are used by menu
The determination of part packet need to only define meter reading field and write literary name section;
Note 3: meter reading field is corresponded with literary name section is write.
3. whether using Select input setting field value;It is identified with number 01, calls Select input when equal to 1, use selection
The field name and Select input method of typing are defined by ' Select input method table '.
4. record editor's shielding, uses four parameters:
● shielding mode, with enumeration type parameter identification: 1 record editor's shielding, the shielding of 2 Row control page editings, 3 record
Grouping editor's shielding;
● the shielding of mode 1,3 editor's table class and mode 1,2 condition table classes (both modes 1 are identical)
● editor's shielding condition: identified with conditional expression;
● do not allow the prompt information edited: using Text Flag.
Note 1: record editor's shielding record editor's shielding: is executed to the record of satisfaction ' editor's shielding condition ';
Note 2: Row control page editing shielding: when the unirecord that afterbody indexes meets ' editor's shielding condition '
When, to the main menu page and whole button menu page shielding editors;
Note 3: record grouping editor's shielding: the record having allows some to edit, and other people can only inquire, referred to as
' record grouping editor shielding ';Example: when professional teams and groups' recording device account, the account that can only edit this profession is recorded, but can be with
Inquire the account record of other profession inputs;' the management pair read in when the editable record of grouping editor is by ' table record filtering '
As table is grouped edit condition ' it executes.
5. field editing shields, combination parameter, format: [table class, shield type, { field name sequence }] are used;Shield type is used
Enumeration type parameter identification: 1 whole fields do not allow to edit, and 2 ' field name sequences ' are to allow edit field list, 3 ' field name sequences
Column ' it is not allow edit field list, 4 ' field name sequences ' are the gauge outfit field column for recording forms more with gauge outfit and allowing to edit
Table;
Shape parameter is enumerated in table class use, identical as the table class of some table that menu forms use.
Note: band gauge outfit records forms after editing gauge outfit field more, employs the replacement of gauge outfit field value certainly and records forms more
In these field values all recorded.
6. field condition editor shields, using combination parameter, format: [condition table class, condition table serial number arranged side by side, { condition },
Mask field editor's table class, { mask field list }];
Condition is conditional expression;Mask field list is identified with character string sequence;Condition table serial number integer ginseng arranged side by side
Number;Shape parameter is enumerated in two table class uses;
Note: ' condition table class ' and ' mask field editor's table class ' can be same tables of data, be also possible to different data table,
The mask field editor when condition is true.
4.9 editors must record field judgement and record uniqueness judgement when saving
1. must record field judges parameter format, it is divided into unconditional and two kinds of conditional:
● field judgement must be unconditionally recorded, judges that class is equal to 1 or 2, using combination parameter, format:
[table class judges class, executes class, { executes the control option of class 2 or executes the generation memorandum keyword choosing of class 1
, { list of fields must be recorded }, { field name annotation list must be recorded }]
● conditional must record field judgement, judge that class is equal to 4, using combination parameter, format:
[table class, judges class, { must record list of fields }, { must record field name annotation list }, condition table class, condition table arranged side by side
Serial number, { condition }];
Parameter declaration: table class, condition table class are ' table class ' parameter;Condition is conditional expression;Condition table serial number arranged side by side makes
It is identified with integer;It executes class and judges that class enumerates shape parameter using following;Remaining parameter is identified using character string sequence;
Execute class: 0 does not keep records of, and 1 keeps records of, and 2 keep records of but do not execute Row control;
Judge class: 1 forms current record must unconditionally record field, and all record must unconditionally record field, 4 forms to 2 forms
The judgement of current record condition must record field;
2. field arbitration functions explanation must be recorded:
It must record that field judgement is divided into ' must unconditionally record field ' and ' condition must record field ' two kind, the latter is when the condition is satisfied
Judged, the former unconditionally executes judgement;
Index field to tables of data is, it is specified that for that must record field;If these field values are null, basis ' must record field
Name mark ' it generates and provides prompt information, edited record is not saved;
To non-index field, if these field values are null, but allow user's typing next time, then basis ' must record field
Name marks ' generation simultaneously provides prompt information, the edited record of preservation, and generates to be directed to according to ' generating memorandum keyword ' and step on
The memorandum of people is recorded, shows the memorandum for logging in people after login system automatically next time;
Field must be recorded to what Row control required, it is raw according to ' field name mark must be recorded ' if these field values are null
At and provide prompt information, save edited record, but do not execute flow processing as defined in ' control option '.
3. table records uniqueness or the record uniqueness judgement of menu forms, using combination parameter, format:
[table class, judges class, { record uniqueness judges key field list of file names }, { field annotation list }];
Judge class, using enumerating shape parameter: 1 menu forms all record, and 2 tables all record;
Subparameter ' record uniqueness judges key field list ', ' field name annotation list ', use character string sequence
Mark;
When subparameter ' table class ' is equal to 4, for repeating to judge using the newly-increased record of source table, field is labeled as prompt letter
Breath, list of fields are newly-increased record object table field name;When not equal to 4, executed by table class.
4. recording uniqueness judgement explanation:
If the record of input is judged as not unique, is generated according to ' field name annotation list ' and provide prompt information, no
Save edited record.
4.10 summarize Parameters design by period statistics
Filtering is executed by the period of stochastic inputs to specified single tables of data record, generates sublist record, and execute solid
Determine project to summarize, statistical time range and summarized results are stored in main table;Table name is counted by ' come source table table name ' parameter definition;It uses
4 parameters:
1. taking time-slice method, totally 4 kinds: 1 one field identification period sections, 2 two field identification period sections, 3 are less than
It is more than or equal to the time value of input equal to the time value of input, 4;
2. the date field name of main table input period;
3. the date field name that source table is summarized by the period;
4. the value classification of main table input period, totally 4 kinds: 1 years, 2 days, 3 dates, 4 time-divisions date;
1. and 4. parameter uses enumeration type parameter identification, remaining parameter character string or character string sequence mark;
Function declaration, which is shown in, ' summarizes component packet ' design method by period statistics.
The inquiry of 4.11 random assortments, random assortment summarize design method
Specified single tables of data record execution random assortment is summarized or inquired, table name origin source table table name parameter is fixed
Justice;Query result generates main table record;Totally 7 parameters:
1. pooled classification field or querying condition field;
From the direct value field of source table when 2. source table summarizes field or inquires;
3. source table summarizes or the corresponding main table of value field writes value field;
4. classification or querying condition field name mark;
5. summarizing the method for summary of field, record number is sought totally for 7 kinds: 1,2 summations, 3 are averaging, and 4 maximizings, 5 ask most
Small value, 6 seek variance, and 7 take initial value;
6. source table date field name;
7. source table date field value classification, totally 4 kinds: 1 years, 2 days, 3 dates, 4 time-divisions date;
5. and 7. wherein parameter is with enumerating shape parameter or enumeration type argument sequence identifies, remaining parameter character string or character
String sequence mark;5. random assortment inquiry does not use parameter;
Function declaration sees ' random assortment inquiry component packet ' and ' random assortment summarizes component packet ' design method.
4.12 end of term entity state Query Design methods
Specified source table is recorded and carries out the inquiry of end of term entity state, processing parameter totally three:
1. entity classification field: being defined using character string sequence;
2. the time field name of entity state variation: origin source table date index field mark;
3. the indexed mode of end of term date category origin source table date index field identifies;
Function declaration: after user clicks source table date field afterbody index, according to entity classification field and the end of term
Date category generates main table end of term entity state inquiry record;' indexed mode ' and the corresponding relationship of ' end of term date category ' are shown in
' end of term entity state inquiry component packet ' design method.
4.13 lookups choose entity correlation table to record design method at random
Function declaration: a certain item is chosen to record at random single main table user, by substantial definition as defined in system control table
Field value and comparison condition filter out the relative recording for choosing entity;Use a main table and a source table;Choosing record makes
Table is defined with source table, and obtained relative recording is saved with main table;One forms, forms top alternatively more to be recorded, forms
Relevant more record is recorded to choosing below;
Processing parameter totally two:
1. substantial definition field: being defined using source table and main table associate field;
2. comparison condition: conditional expression;
4.14 call the Parameters design of background process processing:
' background process processing ' is called to can be main menu or button menu;
Design method: system is controlled into two primary key values (menu serial number, menu forms serial number) of main table, ' is logged in
The menu function button serial number ' and ' that people executes logs in the Row control option serial number that person selects ' it is used as call parameters;Latter two
The parameter value of parameter is identified when being multiple using integer sequence, calls ' menu background process processing method table ' respectively when execution
Difference record;Parameter designing is as follows:
● call the function button serial number of background process processing: using enumerating shape parameter: 0 is not, and 1,2,3 is main table respectively,
Sublist, sublist increase record button newly;4,5,6 be main table respectively, sublist, save button when the newly-increased record of sublist;7 is main
Table, sublist have save button when record;8 main tables, sublist, sublist have save button when record;9 save buttons;
10 background process call buttons;11,12,13 be main table, sublist, sub- sublist deletion record button respectively;
● Row control option list: when further work calls different background process, using list mode for stepping on
Record person selects;String argument;Example: there are 3 control choosings when the checking report forms that certain grade of management organization responsible person reports next stage
, be listed as follows: 1 return is rewritten;2 audits pass through;3 wouldn't determine.
● control option: log in the option serial number of ' Row control option list ' that person selects;
Such as above-mentioned ' checking report forms ', select when logging in person: ' 1 return is rewritten ' when, call parameters are used as by 1;Selection:
' 2 audits pass through ' when, call parameters are used as by 2;
● ' whether user saves former current record value when clicking newly-increased Edit button, deletion, saving as background process processing
Using ' parameter, when as executing tables of data write operation, if use ' the judgement and execution parameter of former current record ' field value;
The parameter is identified using two integers: first, Edit button: 1 newly-increased 2, which deletes 3, saves;Second, table class: 1
Main 2 sublist of table, 3 sublist;Not save former current record field value when sky, when not for sky, current note is saved before user edits
Record value, and the former current record field used is identified with prefix LA0_ field name in ' menu background process processing method table '
Value;Parameter value is separated when being multiple with comma.
4.15 generate Web query System Parameter Design method
After the menu editing that need to the execute Web query Web query page, Web query system can be automatically generated;Parameter is set
Meter:
● Web query page name: string argument, when not for sky, using menu as Web query menu;
● according to menu definition parameter when execution, the tables of data parameter that menu uses, table index parameter, the Web query page
Name parameter, dynamic generation Web query menu and the Web query page.
The editing interface of 4.16 ' system controls main table ' is shown in Fig. 2-Fig. 6.
5, table record filtering method table designs
1. major key totally 5: menu serial number, menu forms serial number, second level paging menu serial number, filter table class and filtering
Recording mechanism;
Wherein first three controls main table with system to identify the keyword of menu identical, and when execution is according to keywords worth equal original
Then call;' filter table class ' mark executes filtering to that table that menu uses;' filter record number ' is to distinguish different to be
System logs in people and uses the different record settings of this method table.
When executing table record filtering, it is first determined log in this method table record that people uses, then joined according to corresponding record
Numerical value is filtered menu data table record;When a certain login people records without corresponding this method table, menu data table is used
Whole records.
2. using the following 2 identity conditions for logging in people, totally 6 parameters determine that any system logs in this method for using of people
Table record:
Condition 1: identity public variable class 1, identity public variable value list 1, judgment method 1;
Condition 2: identity public variable class 2, identity public variable value list 2, judgment method 2;
' the identity public variable class ' of two conditions is to enumerate shape parameter: 1 department's class, 2 departments name, 3 classes of station classes, 4 classes of stations
Name, 5 Responsibility of Staff, 6 names, 0 any login people;
When the identity public variable class of condition 2 is 0, expression only uses condition 1, and when not being 0, condition 1 and condition 2 are and
Relationship;
' judgment method ' of two conditions is to enumerate shape parameter: 0 be unsatisfactory for condition be it is true, 1 to meet condition be true.
Example: if identity public variable class 1 is equal to 3, identity public variable value list 1 is ' teams and groups, substation ', judgment method
1 is equal to 1;Remembered when then a certain class's station class for logging in people is ' teams and groups ' or ' substation ' using the filter method filter table of the record
Record;If judgment method 1 is equal to 0, when a certain class's station class for logging in people is not ' teams and groups ' or ' substation ', the mistake of the record is used
Filtering method filter table record;
3. table record filtering method:
First: equal with corresponding data sheet field value by public variable or inclusion relation is filtered;
Second: being filtered by management object value with corresponding data sheet field value inclusion relation;
Third: above-mentioned two 16 kinds of filter methods are described with 01 argument sequence of following 16 public variables, a certain position etc.
In 1, corresponding filtering is executed, is equal to 0, does not execute corresponding filtering;
16 01 sequences of public variable: 1 industry number are filtered, 2 teams and groups number, 3 log serial numbers, 4 departments name, and 5 classes
Group name, 6 names, 7 shifts on duty, 8 tier-2 departments name, the set name of the object of 9 management, the set name of the people of 10 management, 11 departments
Class, 12 teams and groups' classes, 13 unit names, 14 management object value filterings, 15 management object expression filterings, 16 person numbers;
Ejbmbh1, bzbh of industry number, teams and groups' number, the automatic corresponding data table of person number in public variable,
Operator field;' public variable is corresponding by parameter for remaining public variable value data sheet field corresponding with management object value
Data sheet field name ' it is specified;
The set name of the object of ' 9 management in public variable ', the set name of the people of ' 10 management ' it was carried out by inclusion relation
Filter, remaining is filtered by relation of equality;
' 14 management object value filterings in public variable ', ' 15 management object expression filterings ', ' call and manage according to parameter
The public variable class ', ' for managing object value calls the management object name of management object value ' or ' call the public of management object expression
Variable class ', ' calls the management object name of management object expression ' filtering ' management Object table ' record obtains corresponding ' management
Object value ' or ' management object expression ';' call the public variable class ' use of management object value and expression formula to enumerate shape parameter:
1 department name, 2 tier-2 departments, 3 teams and groups name, 4 teams and groups' classes, 5 names, 6 Responsibility of Staff;
' management object expression class ' is equal to 2, ' 15 management object expressions filterings in public variable ' expression formula be to hold
Capable filter condition;When equal to 3, ' 15 management object expressions filtering ' expression formula be execute ' record editor in public variable
Shielding ' in ' record grouping editor shielding ' conditional expression;
4th: by the SQL conditional expression of parameter ' filtering ', the SQL condition that given filter executes;The parameter is condition table
Up to formula.
4. ' table record filtering method table ' editing interface is shown in Figure 11.
6, Select input method table designs
When to literary name segment value typing using ' Select input ' method, the chosen candidate value of Select input can be ' non-menu forms
The a certain field value that a certain field value of record ' table or ' the current set of menu forms that use table use table ' table to record;It is optional to log in people
Select one or more chosen candidate value write-in edit fields.
Using this method table Same Way carry out Select input field can be one or more, with ' write value field column
Table ' mark;The different records of this method table are used when different field executes different Select input methods respectively.
Parameter type: when parameter is table class, using enumerating shape parameter;When for condition, use condition expression argument;For
When field name, character string or character string sequence parameter are used;And list serial number uses numeric parameter.
1. major key totally 3: menu serial number, menu forms serial number and ' Select input recording mechanism ', wherein the first two and
The keyword that system controls main table mark menu is identical, and when execution is according to keywords worth equal principle and calls;' Select input record
Number ' it is to distinguish same menu forms, when different ' writing value field list ' is using different Select input methods, not using this method table
Same record setting.
2. alternate key totally 2: editor's table class, editor and list serial number, mark hold that table that menu uses
Row Select input.
3. the Select input method of literary name section executes parameter:
Parameter: ' writing value field list ', mark carry out Select input by method as defined in current record to those fields, can
To be a field or field combination (the field name sequence separated with comma);
Parameter: ' condition table class ' and ' calling Select input condition ' judges whether to execute Select input;It is held when condition is true
Row does not execute for fictitious time.
4. filtering chosen candidate value tables of data records the parameter used:
3 kinds of filter methods are defined by parameters described below, the chosen candidate value tables of data record used for filtering Select input;
● chosen candidate value data table name;
● menu forms must record field list class in advance;Field must be recorded in advance;The corresponding chosen candidate value literary name of field must be recorded in advance
Section;
● the public variable of filtering chosen candidate value tables of data record and corresponding chosen candidate value data sheet field name;
● chosen candidate value tables of data record filtering conditional expression;
Illustrate: wherein ' filtering ' and ' according to condition filtering by public variable ' and ' table record filtering method table ' design method phase
Together;And use menu forms ' field must be recorded in advance ' and ' corresponding chosen candidate value literary name section ' value relation of equality is alternately worth simultaneously
Table record filtering condition;
5. according to parameter: ' chosen candidate value field name ' and ' reading chosen candidate value mode ' determines the chosen candidate value of Select input;
Chosen candidate value mode is read using enumerating shape parameter: only one chosen candidate value of the alternative value field of 1 one records, 2 one
The alternative value field of record has multiple chosen candidate values.
6. according to ' taking selective value mode ' parameter to determine the method for executing Select input: 1 chosen candidate value write-in of primary selection
Edit field once selects multiple chosen candidate value write-in edit fields;
' selective value mode ' use is taken to enumerate shape parameter: 11 chosen candidate value of selection, the 2 multiple chosen candidate values of selection.
7. being determined after executing Select input, the other of execution write table handling according to following 3 class parameters:
● ' chosen candidate value table takes other value field list of file names ', ' editor's table correspondence writes value field list of file names ';
● ' field name that the decomposition value of selection result is written ';
● ' the table class for setting selection number ', ' setting selection number field name ';
It executing from the other field values of chosen candidate value table or by the decomposition value of selection result, table corresponding field is edited in write-in, and
Set the write operation of selection number.
8. executing other regulations of Select input
● determine whether Select input executes password authentification according to ' password confirming ' parameter value;
● according to ' selective value repeats to judge that class ' parameter carries out selective value and repeats to judge, provides error message when repeating;
● whether determined according to ' whether allowing to edit ' parameter allows to carry out keypad editor typing when Select input;
● according to parameter: ' whether allowing to input new option when taking selective value mode=2 ', when determining Select input whether
The additional chosen candidate value of keypad editor can be used.
Note: selective value repeats to judge that shape parameter is enumerated in class use: 0 is not, and 1 current form all records, and 2 tables of data are all remembered
Record;Shape parameter is enumerated in other 3 parameter uses: 0 is not, and 1 is.
9. ' Select input method table ' editing interface is shown in Figure 10.
7, menu background process processing method table designs
Development platform handles the foreground process that menu widget packet should be realized, controls main table and system auxiliary control by system
Table parameter definition is handled the background process that menu should be completed, by ' menu background process processing method table ' parameter definition.
The background process processing method of database application system menu is decomposed into newly-increased table record, modification table by development platform
Record deletes table and records three classes tables of data WriteMode, and devises the execution parameter of each WriteMode, according to these when execution
Dynamic state of parameters generates SQL statement, completes tables of data write operation, realizes the functional requirement of background process processing;For that cannot use
The function that dynamic SQL statements are realized, by calling ' data base procedure ' code write to realize.
User service data table is divided into two major classes when design: value table and writing value table, value table is dynamic SQL statements
Data source, referred to as ' meter reading ';Writing value table is the object table for executing write operation, referred to as ' writing table ';Value table and write value table can be with
It is menu using table, may not be menu using table, the latter is referred to as ' new table '.
(1) major key totally 6: menu serial number, menu forms serial number, the Row control option of calling, calling function
Button serial number, executes serial number at WriteMode;
They are described with integer, and wherein the first two and system control main table to identify the keyword of menu identical;
It is filtered when execution according to ' menu serial number ', ' menu forms serial number ', ' Row control option ', ' function button serial number '
Then this method table record is executed the record filtered out by ' executing serial number ' sequence;
' function button serial number ' correspondence system control the menu function button of main table enumerate serial number;
' Row control option ' correspondence system controls the option serial number of ' the Row control option list ' of main table;
WriteMode is divided into 6 kinds, using enumerating shape parameter: 0 judges whether to exit calling, 1 newly-increased record, 2 modification records, and 3
Deletion record, 4 have record modification, and no record is newly-increased, and 5 call data base procedure;
Be divided into 5 kinds to the method for field assignment: ' assign constant ', ' unconditionally assigning transition formula evaluation ', ' condition tax transition formula evaluation ',
' executing write operation for another specified data table as meter reading ', ' sql sentence assignment ';This 5 kinds of methods can use as needed
It is one such or a variety of;
WriteMode is equal to 0, for judging whether current ' executing serial number ' later this method table record executes;
WriteMode is equal to 1, for increasing ' writing table ' record newly, firstly generates ' writing table ' record major key and customer service is closed
Then key word gives other field assignment with 5 kinds of methods to field assignment;
WriteMode is equal to 2, for modifying ' writing table ' record, is determined first according to ' modification or deletion write operation execute method '
The record of modification operation is executed, then modifies field value with 5 kinds of methods to field assignment;
WriteMode is equal to 3, for deleting ' writing table ' record, is determined and is executed according to ' modification or deleting write operation execution method '
The record of delete operation, then delete ' writing table ' record;
WriteMode is equal to 4, first determines whether that ' writing table ' whether there is or not condition record is met, has and execute modification note when meeting condition record
Record operation increases record operation newly without executing when meeting condition record;In this way, can not make to delete note when there is the condition that meets to record
Record operation;
WriteMode is equal to 5, the write operation for dynamic s ql sentence cannot to be used to realize;When execution, ' the data write are called
Library process ' realize write operation.
(2) user intervention whether ' background process calling ' executes
To have prevented user overdue ' background process call buttons ', but temporarily it is not necessary to perform the next step process processing
Requirement, setting ' process call the prompt information ' parameter whether executed;When execution, if the function button serial number called is equal to
10, and the parameter value is not sky, then releases the prompt information, receives keyboard input, inputs Y, executes write operation, input N is exited
Background process calls.
(3) when controlling option=99, ' Row control whole option modification field value is uniformly processed ' is executed, to reduce
' menu background process processing method table ' records and is convenient for parameter editor, unrelated with the execution parameter of 6 kinds of WriteModes, uses combination
Parameter, format: [{ value class, table class, and list serial number, WriteMode, write value field name }, { Row control option list }, { process
Option is corresponding writes value list for control }];
Each write method for writing value field name is included with [], multiple to be separated with comma;
Use to enumerate shape parameter as follows: table class: ' table class ' parameter;WriteMode: 1 forms current record, 2 forms are all remembered
Record;It is worth class: 0 constant, 4 public variables;
Note: when value class is public variable, corresponding public variable value is identified with the serial number of enumerating of public variable;
(4) ' meter reading ', ' writing table ' and the meter reading record that write operation uses record totally 6 parameters with table is write:
● meter reading class;Write table class;
● read record mode: 1 forms current record, 2 forms all record, and 3 is new by sublist, sublist whole record reading
Result set uses, and 4 are all recorded using new result set;
Note: when forms only have, sublist is subordinated to main table or sublist is subordinated to the part record of sublist, but need to all from
When belonging to record execution write operation, usage mode 3 or 4;
● meter reading and list serial number;Write table and list serial number;
● write new table name (writing data table name of the non-menu using table when);
Note: meter reading class writes table class as ' table class ' parameter;Read record mode is to enumerate shape parameter;Two and list serial number
Numeric parameter;Writing new table name is string argument.
(5) judge whether write operation as defined in a certain record of this method table executes and write operation executes number
', ' date terms of execution ' and the one ' write operation that uses the meter reading condition of two groups of conditional parameter ' execution executes time
Number ' parameter definition;' write operation execution number ' is determined according to the meter reading condition of satisfaction ' execution ' record strip number when execution;
● the meter reading condition of execution: for conditional expression;It is unconditional to be defaulted as when sky;
● write operation executes number, to enumerate shape parameter: 0 it is each record it is each execute primary, 1 each to meet condition record each
It executes once, records one more 2 and meet condition Exactly-once, recorded 3 more and all meets condition Exactly-once;
● the date terms of execution uses 4 parameters: date field table class, date field and list serial number, date field
Name, date judgment mode;
Wherein ' date field table class ' is ' table class ' parameter;' date field and list serial number ' is integer
Shape parameter;' date field name ' is string argument;
' date judgment mode ' is to enumerate shape parameter: 1 monthly last day, 2 monthly first day, 3 quarterly last days,
4 quarterly first day, 5 last days every half a year, 6 first day every half a year, 7 annual last days, 8 annual first day, 9 Mondays,
10 Sundays;
● when WriteMode=0, it is unsatisfactory for the prompt information of execution condition, is string argument;
Note 1: ' WriteMode ' is equal to 0, currently executes whether the later method table record of serial number executes for judging;When discontented
When foot ' the meter reading condition of execution ', the current later this method table of serial number that executes is not executed and records defined write operation, and is provided
Do not allow the prompt information executed;Otherwise subsequent write operation is continued to execute;
Note 2: if ' WriteMode ' is not equal to 0, if being unsatisfactory for ' the meter reading condition of execution ', method table record rule are not executed
Fixed write operation;Otherwise, write operation is executed by ' write operation execution number ';
Note 3: if ' WriteMode ' is not equal to 0, and meet ' the meter reading condition of execution ', but be unsatisfactory for ' date terms of execution '
When, write operation as defined in the method table record is not executed;
Note 4: ' date field table class ' does not judge date terms when being equal to 0.
(6) it modifies or deletes write operation and execute method, totally 5 parameters:
● it writes the modification of value table or the recording interval deleted and executes method: 1 forms current record, 2 forms or new table are whole
1*N endless form of one-to-one modification when record and read-write table are more records and equal record number, 3 meter readings are a certain
What field saved writes table record xuhao record, M*N endless form when 4 read-write tables are more records, 5:for I=1TO N
Endless form;
● writing table result set is reading and writing table associate field when more recording;
● meter reading saves modification or the field name of deletion record xuhao, only ' executes method 3 ' to use;
● deletion records the condition or new table record filtering condition that should meet with table is write when modification record;
● meter reading and literary name section comparison condition is write, uses two parameters:
1. conditional formats: 0 is unconditional, after section of writing before 1 reading field, 2 write read field before section after;
2. condition: it uses ' > ', ' < ', '=', ' in ' is used as comparison operator, ' meter reading ' and ' writing table ' field is connected,
Composition condition comparison expression;
Note: shape parameter is enumerated in ' write the modification of value table or deletion record range and execute method ', ' conditional formats ' use;It ' reads
Table saves modification or the field name of deletion record xuhao ' use integer sequence;Two conditional parameter use condition expression formulas;Its
Its parameter uses character string or character string sequence;
Illustrate 1: ' forms current record ' and ' forms or new table all record ' executes writing for write operation for Explicit designation
Table record;
Illustrate 2: the 1*N endless form of ' one-to-one modification ' has N item record for ' meter reading ' and ' writing table ', reads ' to read
Table ' one record writes the corresponding record of ' writing table ' sequence;
Illustrate 3: ' a certain field of meter reading save write table record xuhao record ': for write ' writing table ' fixed one or
Multiple xuhao records;
Illustrate 4: ' M*N endless form when read-write table is more records ': for sequentially executing ' meter reading ' whole M notes
Record: reading ' meter reading ' one record, according to ' read-write table incidence relation ', ' meter reading and write literary name section comparison condition ' and ' writes table item
Part ', judge each record in ' writing table ' N number of record, write operation is executed when condition meets;
Illustrate 5:for I=1TO N endless form: for by for endless form execution write operation, loop parameter fill in
In ' meter reading and write literary name section comparison condition ';
Parameter format: the field name that cyclic variable uses recycles initial value, recycles final value, and circular increment is +/-;
Cyclic variable must be integer type field, and the field current record value, LAO_FIELD can be used (to compile for circulation initial value
The field current record value before volume) or MIN (the tables of data field minimum value);Recycling final value can be used MAX (tables of data word
Section maximum value);Circular increment is positive integer or negative integer;It is +/-: to be used for specified modification cyclic variable method.
(7) when WriteMode is newly-increased recording mode, a when write operation of every executions write the newly-increased record strip number of value table,
The major key of newly-increased record and the defined parameters of customer service keyword generation method:
● newly-increased recording mode: 1 every newly-increased record of write operation of execution;2 write operations of every execution according to point
Solution value increases a plurality of record newly;
● write operation of every execution increases a plurality of record executive mode newly: 1 constant list is decomposed, and 2 value literary name sections are decomposed,
3 take a certain field value of a plurality of record of other tables using sql sentence;
● newly-increased record major key generating mode: 1 value table xuaho, 2 value table xuaho, xuaho1,3 value table xuaho,
Xuaho1, xuhao2,4 value table max xuaho, 5 write value table max xuaho, and 6 operation logging xuhao, 0 currently writes value
Sublist xuhao currently writes value sublist xuaho, xuaho1;
● newly-increased record write key number;(it is equal to 1, only writes xuaho, be equal to 2, write xuaho, xuaho1, be equal to 3, write
xuaho、xuaho1、xuhao2)
● write key number is greater than the last one keyword assignment method when taking number: 0 sets 0;1 decomposes serial number;2 write son
Table: maximum xuhao1;Write sublist: maximum xuhao2;
● the constant list of decomposition;
● ' meter reading ' takes decomposition value field name;
● ' writing table ' writes the field name of decomposition value;
● take the s ql sentence of ' meter reading ' multiple record values of field;
Note 1: what is used enumerates shape parameter: ' newly-increased recording mode ', ' newly-increased record major key generating mode ', ' write key
Number is greater than the last one keyword assignment method when taking number ', ' increasing a plurality of record executive mode newly ';
Note 2: write key number, which is greater than, takes the keyword among when number to set 0;
Note 3:3 kind ' increasing a plurality of record executive mode newly ' can be used alone, and also can be used in combination, with one, two or three
Position integer mark;Constant list decomposition or value literary name section are decomposed, the newly-increased record of a decomposition value;The newly-increased record of mode 3
Item number is identical as the table record strip number of ' sql sentence value condition ' is met;
(8) field assigns constant value, uses 2 parameters: ' assigning constant value field name sequence ', ' the constant value sequence of tax ',
It is defined using character string sequence;
Note 1: character string constant is not added quotation marks and is included when character string includes comma with { };
Note 2: date constant uses four kinds of fixed date formats:
YYYY;YYYY-MM;YYYY-MM-DD;YYYY-MM-DD hh:mm
Note 3: the constant value for assigning constant value field name and tax corresponds;
(9) ' type expression ' when field is using expression formula assignment, uses enumeration type parameter identification:
1 numerical expression, 2 character expressions, 3 statistics calculation expressions, 4 assign public variable value, and record takes a word more than 5
Segment value is connected with comma, and 6 meter readings are to literary name section copy is write, and 7 write table copies to meter reading field, and 8 date expression formulas record one more 9
A field take not repetition values connected with comma, 0 constant;
Note 1: when assigning public variable value, parameter value is identified with public variable serial number;
Note 2: it first according to the type expression calculation expression value of assignment when execution, then executes assignment or field value is copied
Shellfish.
(10) unconditional multi-field expression formula assignment
Use 3 parameters: ' the expression formula class list of assignment ', ' writing value field list of file names ', ' assignment expression list ';
Note 1: expression formula class does not use 0: assigning constant;
Note 2: each expression formula is included with { }, multiple to be separated with comma;
Note 3: ' the expression formula class list of assignment ' is to enumerate argument sequence;' writing value field list of file names ' is character string sequence;
Each assignment expression is one of above-mentioned ' type expression ';It is corresponded when assignment.
(11) condition multi-field expression formula assignment
Use 5 parameters: ' the expression formula class list of assignment ', ' condition list ', ' writes value field to rank ' condition class '
Table ', ' assignment expression list ';
Note 1: ' condition class ', using enumerating shape parameter: 1 meter reading field condition, 2 public variable conditions;' condition ' is condition
Expression formula, public variable use the corresponding field name of management organization's table;Its excess-three parameter definition and ' unconditional multi-field expression
Formula assignment ' it is identical;
Note 2: each condition write value field list of file names and conditional expression is included with { }, { } number is identical, correspond,
It is multiple to be separated with comma;Each assignment expression is included with { }, and with assignment expression class and write value field name correspond.
(12) using another specified data table as ' meter reading ', referred to as ' meter reading 2 ' executes write operation and uses 5 parameters:
' meter reading class 2 ', ' read record mode 2 ', ' writing value field name ', ' list of assignment expression class ', ' assignment expression list ';
Note 1: ' meter reading class 2 ' is ' table class ' parameter;' read record mode 2 ' and 4. middle read record mode provide identical;Remaining
Three parameter definitions are identical as ' unconditional multi-field expression formula assignment ';
Note 2: each assignment expression is included with { }, and is corresponded with ' assignment expression class ' and ' writing value field name '.
(13) sql sentence assignment uses combination parameter:: { the table class of additional xuhao condition }, { writing value field list of file names },
{ sql sentence }, { value condition }, { sql sentence serial number }
Note 1: ' value condition ' is conditional expression;' sql sentence serial number ' is used to use when debugging;' additional xuhao condition
Table class ' be it is specified using which tables of data of menu forms when taking ' meter reading ' current record, it is identical to define method with ' table class '.
Note 2: ' sql sentence ' is identical as database sql Sentence format;A plurality of sql sentence is separated with &&;
Note 3: ' sql sentence assignment ' parameter is defined with character string.
(14) data base procedure is called
Use combination parameter: { procedure name }, { the main literary name section list for passing to process } { pass to the sublist word of process
Duan Liebiao }, { the sublist list of fields for passing to process }, { the source literary name section list for passing to process }, { public variable sequence
Number, { sequence number parameter of calling };
Note 1: ' sequence number parameter of calling ', which is used to distinguish multiple menus or ' the different records of same menu this method table ', to be made
The call parameters of different disposal method when with same ' data base procedure ';
Note 2: in addition to ' procedure name ' parameter cannot be empty, remaining parameter is all in accordance with needing to be arranged;
Note 3: ' data base procedure ' parameter is called to be defined with character string.
(15) background process handles the prompt information parameter that is finished
' after maximum execution serial number ' write operation is finished, or controlling option and being equal to 99 when each control option<>99
After write operation is finished, the prompt information is provided;It with ' when WriteMode=0, do not allow prompt information ' public one executed
A parameter.
(16) ' menu background process processing method table ' editing interface is shown in Fig. 7-Fig. 9.
8, menu operation priority assignation table designs
To the tables of data that menu uses, when different system login people logs in application system, to the operating right of menu
By the control table parameter definition, there are six parameters altogether: menu serial number, class's station class, authority definition class, Responsibility of Staff or personnel compile
Number, menu read right, menu write permission;
1. the parameter used:
● menu serial number: it is identical that main table menu serial number is controlled with system;
● class's station class: identical as table class of management organization station class;
● authority definition class, enumerate shape parameter: 1 is defined by Responsibility of Staff, and 2 are defined by person number;
● Responsibility of Staff or person number: Responsibility of Staff or person number's list using menu operation permission;
● menu read right, enumerate shape parameter: 0 nothing, 1 has;
● menu write permission, enumerate shape parameter: 0: nothing, 1 has;
2. menu operation permission uses ' menu operation permission configuration interface ' by the corresponding system function button of development platform
Setting;
3. ' menu operation permission configuration interface ' is shown in Figure 12.
9, management Object table design
1. database application system management set and management step analysis:
● any management set for logging in people of database application system is divided into three categories: the set of object, the set of people, people with
The set of object;
● the set of object: such as warehouse, substation, workshop, the goods and materials of storage or the equipment used;
● the set of people: such as teams and groups, department, warehouse, substation, workshop, the personnel having under its command;
● the set of people and object: such as warehouse, substation, workshop, the existing personnel having under its command, and there are goods and materials or the use of storage
Equipment;
● management level is divided into two classes: ' vertical management level ' and ' intersecting management level ';
● ' management organization's table ' and ' personnel are used such as unit → department → teams and groups → personnel for vertical management level
Table ', with unit name, department's name, teams and groups' name, personnel's name (person number), department number, teams and groups number mark management set;
● level, i.e. business responsibility compass of competency are managed for intersecting, such as the teams and groups of personnel's first management, Ren Yuanyi in department
The teams and groups of management;The warehouse of personnel's first management, personnel's second management warehouse, use ' management Object table ' mark management set.
2. to the tables of data that menu uses, when different system login people is recorded using the different tables of same tables of data,
In addition to use vertical management range as defined in ' management organization's table ' (unit → department → teams and groups → personnel) to tables of data record into
Row filtering is outer, can also be filtered or execute record editor's screen to tables of data record by the business responsibility compass of competency for logging in people
It covers, the business responsibility compass of competency for logging in people is stored in ' management Object table '.
3. management Object table shares seven parameters: ' serial number ' ' management object name ', ' uses the public variable of management object
Class ', ' using management object public variable value ', ' person number when public variable class is name ', ' management object user
Method ', ' technical jurisdiction value range or technical jurisdiction range expression ';
' serial number ' is major key, integer type;' management object application method ' is to enumerate shape parameter: the value of 1 filter record
List;The conditional expression of 2 filter records;3 grouping edit condition expression formulas.
4. by ' public variable class ', ' public variable value ', ' person number ' and ' management that need to be used for logging in people when executing
Object name ' filtering management Object table record, crosses filter data using class, technical jurisdiction value range or expression formula further according to management object
Table record executes record grouping editor's shielding.
5. ' management Object table ' editing interface is shown in Figure 13.
10, tables of data record export introduction method table design
When single main table uses menu widget packet w_ltable_lpage, table can be recorded and export as Excel table data,
Excel table data can be imported into single main table;Tables of data import and derived field name be stored in ' tables of data record lead
Enter method table ' in;It is called when execution by the corresponding system function button of development platform.
This method table has 3 parameters: ' data table name ', ' importing and derived field name sequence ' ' import and derived word
Section name annotated sequence ';Field name and field name mark correspond.
When execution by system control main table ' the main table name ' parameter that menu uses filter this method table record;Then by word
Longitudinal arrangement then chooses field to move to section name mark in the screen left side, double click either field or the whole fields of selection in order
It moves on the right of screen as export or the field name imported, longitudinal arrangement sequence identification field sort method;Double click screen
The right either field returns to the screen left side;Field sort method can also be modified;After choosing the field that need to be exported or import, click
System ' export ' or ' importing ' function button, and input Excel list file name, then execute corresponding export or importing work.
' tables of data record export introduction method table ' editing interface is shown in Figure 14.
11, tables of data major key maximum value table designs
The major key of the development platform menu data table all to application system is disposed as integer type, and uses ' tables of data
Major key maximum value table ' record all customer data table ' main table keyword xuhao maximum value '.
Parameter designing: serial number, data table name, major key maximum value;
' serial number ', ' major key maximum value ' are argument of type integer;' data table name ' is string argument;
When newly-increased table record, the primary key value for setting tables of data automatically is corresponding data table ' xuhao maximum value+1 ', so
' the tables of data major key maximum value table ' tables of data ' xuhao maximum value ' is updated afterwards, to meet tables of data record major key
The uniqueness requirement of value;
Menu data table keyword ' xuhao ', ' xuhao1 ', ' xuhao2 ' are invisible in menu forms, tables of data
The key value of record is arranged automatically by development platform;
The uniqueness of tables of data record controls main table according to system by development platform and ' records uniqueness and judge key field
List of file names ' parameter is judged.
Tables of data major key maximum value table record executes backstage by development platform correlation module and edits.
Database application system step is developed using development platform
When developing database application system using development platform, application system will be automatically generated by deferring to following steps:
(1) system control table and the fundamentals of management table of development platform are established in the database;
(2) user requirements analysis, typing fundamentals of management table data are carried out
● analysis management mechanism, typing ' management organization's table ' data;
● analysis management specification, typing ' management regulation tables of data ' data;
● analysis management level, typing ' management Object table ' data;
● typing ' Responsibility of Staff table ' data;The identifying data of ' Responsibility of Staff table ' storage system user of service.
(3) according to user requirements analysis determine function menu that the functional module of application system and functional module use and
The function that function menu should be realized;Determine menu operation permission;And by development platform tables of data master, external key regulation and customer service
It is required that establishing menu data table;
(4) according to function menu ' the tables of data interrelational form used ', ' usage mode of tables of data ', ' menu used
Form types ' determine the menu widget packet that each function menu uses;
(5) when function menu calls forms without using OLE, the tables of data and interface requirements used according to function menu is determined
Forms form creates menu forms;Determine forms date type-word section display mode, forms numeric type field display mode;Menu
To edit the Web query page when Web query menu;
(6) it determines when all kinds of users of service execute function menu to the filter condition of menu data table record;
(7) determine that menu uses the interrelational form of table when multiple tables of data;Reading field regulation when using source table;
(8) the data table index fields that function menu uses are determined;The indexed mode of date type index field;Table record
Sort field, sortord;When function menu calls forms using OLE, type field and value field that OLE is called;
(9) function button for determining function menu is pressed containing Edit button, background process call buttons, button menu calling
The paging menu identity that button, paging menu use;
(10) determine that function menu shields the editor that tables of data records, the condition editor of record shielding, is grouped editor's
Condition or method;
(11) determine that function menu edits the field shielding that tables of data records, condition field shields edit methods;
(12) determine that newly-increased table record sets public variable, constant regulation;Newly-increased record clone method;
(13) parameter designing of ' Select input method table ' is completed when field editing calls Select input method;
(14) determine summarized using random assortment, random assortment inquiry, classification when summarizing by period statistics and the side of summarizing
Law regulation;
(15) determine that field and table must be recorded when editor saves records uniqueness judgment method;
(16) the Row control option regulation of call flow control is determined;
(17) determine that the background process that menu should be realized calls, the call buttons and call regulation that background process calls;
(18) parameter designing of ' the menu background process processing method table ' of the processing of menu background process is completed;
(19) processing routine is write to the menu that cannot use menu widget packet;It determines and calls third party software method;It compiles
Write ' data base procedure ';
(20) execution program, the application server programs of development platform are installed;Copy menu forms to application server;
The relevant parameter of the above-mentioned menu function design of typing in system control table;It installs ' self-compiling program ' and ' third party software ', fortune
Row development platform executes program and carries out menu operation priority assignation, and after each work station carries out system setting, system puts into operation.
Fig. 1 is seen using development platform exploitation database application system flow chart.
Database application system advantage is developed using development platform
1, the application system stability developed using development platform is good
The stability of application system depends on overall system design and program code designs, without using development platform exploitation system
When system, stability requirement need to be just able to satisfy by repeatedly modification code, system debug.If function change occurs for period, it is also necessary to
Carry out code revision, system debug.
The application system developed using development platform, is used " menu widget packet " processing module, does not need to write journey
Sequence code.Application system stability is determined by the stability of development platform.By being used for a long time, development platform tends into
It is ripe, it is ensured that the stability of system.
2, the development cycle can be shortened, reduce development cost and system maintenance expense
Database application system is developed using development platform, progress is Functional Design, rather than program code designs, no
It needs to write program code, or need to only write a small amount of program code.Specializing in personnel or user has basic database knowledge
When with programming experience, tables of data and edit menu forms, input " system control table " parameter can be established.Menu forms editor is complete
Finish, after inputting call parameters, can operating system immediately, check implementing result.Thus, can shorten the development cycle, reduce exploitation at
This.
When system maintenance, modification program code is not needed, it is only necessary to modify user data table, menu forms and system control
The call parameters of table;When condition has, user can also participate in system maintenance.Thus, system maintenance expense can be reduced.
3, different industries, the database application system of different application are applicable to
First: development platform is to the function menu of application system using ' handling type level based on menu data '
The method of classification, different industries, the application system function menu of different business, if belonging to same data processing class
Same menu widget packet execution module may be used in type.
Second: the function menu of same data processing type, though the tables of data used, menu forms, data processing method
It is so different, but tables of data and menu forms are established and are edited in exterior, and the application method of function menu, i.e. user
Business model be to be described using system control table parameter.So to the different business for using same menu forms component packet
Function menu, only different parameters need to be filled in system control table can be realized menu function.
Third: to the irrealizable special menu function of development platform, stand-alone program module can be write, corresponding tune is filled in
After parameter, system will be called automatically.
4th: to the irrealizable special data processing function of development platform, can write ' data base procedure ', and will
' procedure name ' and ' call parameters ' is filled in ' menu background process processing method table ', then will be adjusted automatically when development platform is run
With completion corresponding function.
Thus, 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 widget packet " realizes the multiplexing of application systems software component grade.
(2) the operation specification of " system control table " to application system function menu, the i.e. business model of user, using relationship
The numerical value and character field of database data table define, and meet ' software architecture formalizes parameter description, unambiguity '
The requirement of ' expression customer service logic '.
(3) software architecture of application system is changed correspondingly with the variation of " system control table ".Both using opening
The application system that platform is set up is sent out, software architecture is adaptive.
Therefore, it is possible to say the target call that development platform has reached people to Software Architecture Design:
(1) export-oriented target: expression customer service logic.
(2) to target in: describing the tectonic system of software systems.
(3) practical target: the description of architecture should meet the description of formalization parameter, unambiguity.
(4) high level goal: when the variation of customer service logic, architecture is adaptive.
Ultimate aim: automatically generating program code and application system.
Claims (9)
1. a kind of data base application system development platform, which is characterized in that the database application system is to be taken using database
The database application system of business device, application server and client workstation three-Tier Model, the development platform include being
System control table storage unit, menu widget packet and code generator, in which:
The system control table storage unit, for storing the system control for the parameter called at runtime comprising menu widget packet
Table, the parameter in the system control table include system master parameter, system secondary control parameter and the processing of menu background process
Method parameter, the system master parameter and system secondary control parameter are the architecture characterising parameter of database application system
With the parameter for the execution method for handling the utility function realized in menu widget packet by foreground process, at the menu background process
Managing method parameter is the execution method parameter for handling the specific function realized in menu widget packet by background process;The menu structure
The execution method parameter for the utility function realized is handled by foreground process in part packet and menu backstage carries out processing execution method ginseng
Number is menu function characterising parameter;When modifying the menu function characterising parameter in system control table, the function of menu will change therewith
Become;
The menu widget packet is that the parameter in the calling system control table for handle type based on menu data completes menu function
Reusable execution module, all menus for being reused as belonging in database application system same data processing type can
Using the same menu widget packet, the menu data processing type includes tables of data interrelational form, the menu pair that menu uses
The form types that the usage mode of tables of data, menu use;
The code generator, for being controlled in the operation of menu widget packet according to the system of system control table storage unit storage
Dynamic state of parameters in table generates executable code;
The architecture characterising parameter of the database application system and the type of menu function characterising parameter include non-enumeration type
Parameter enumerates shape parameter and expression argument;When using multiple subparameters in a parameter, subparameter includes non-enumeration type ginseng
Number enumerates shape parameter or expression argument, is separated between subparameter with agreement separator;The system control table uses public
Shape parameter of enumerating include table class and public variable, the table class is the tables of data that menu forms use or executes read-write operation and make
Tables of data, the public variable are used to save the identity of login personnel in database application system operation, in which:
The non-shape parameter of enumerating includes numeric parameter and string argument, and the numeric parameter is integer or integer sequence, whole
It is separated between integer in Number Sequence using agreement separator, the string argument is character string or character string sequence, character
It is separated between character string in string sequence with agreement separator;
The shape parameter of enumerating is the integer for indicating to enumerate serial number;
The expression argument is to use corresponding expression argument in SQL statement when database SQL sentence.
2. development platform according to claim 1, which is characterized in that the system control table includes that system controls main table,
For storage system main contral parameter, the system controls main table and records including one or more menu, and every menu record includes
It is such as properties: the tables of data and tables of data application method, menu that Menu Type, menu identification, menu executive mode, menu use
The function button of the forms and menu that use, the menu identification are major key, are recorded when increasing or deleting menu, database
The menu of application system will increase or decrease therewith.
3. development platform according to claim 2, which is characterized in that
The Menu Type includes main menu, button menu and paging menu, when Menu Type is main menu, the menu mark
Knowing is menu serial number, and when Menu Type is button menu and paging menu, the menu identification is menu forms serial number;
The menu executive mode includes calling menu widget packet, third party software embedded functional calling, self-editing executable journey
Sequence is called;
The tables of data that the menu uses includes main table, sublist, sublist, concordance list, source table and subtabulation and son is sub side by side
Table, the tables of data application method include that table record is read, filtering and sequence, the main table are that can derive subordinate incidence relation
The tables of data of table, the sublist are the tables of data to lay under tribute in two layers of subordinate incidence relation table, and the sublist is three
The subordinate tables of data of sublist in layer subordinate incidence relation, the concordance list are data of the table record as another data table index
Table, the source table are the tables of data that table records data source when increasing table record newly as another tables of data, the son arranged side by side
Table is two or more tables of data that table record is subordinated to the same main table in two layers of subordinate incidence relation, the sublist side by side
Two or more tables of data of the same sublist are subordinated to for table record in three layers of subordinate incidence relation;
The function button of the menu includes Edit button, background process call buttons, OLE funcall button, button menu
Forms call buttons and menu operation help button.
4. development platform according to claim 1, which is characterized in that
The system control table includes system control supplementary table, is used for storage system secondary control parameter, system control auxiliary
Table includes menu priority assignation table, Select input method table, management Object table, tables of data major key maximum value table and tables of data
Record export introduction method table, in which:
The menu priority assignation table includes menu sheet menu identification, authority definition class, personnel's duty using menu operation permission
Duty or person number, menu read right and menu write permission;
The Select input method table includes menu identification, Select input recording mechanism, the method for executing Select input, when system control
When the menu identification that the menu identification of the Select input method table of supplementary table processed and system control main table is identical, menu widget packet is held
It is called when row according to the equal principle of key value;
It is described management Object table include manage object name, using management object public variable class, using management object it is public
Person number, management object application method and technical jurisdiction value range or business pipe when variate-value, public variable class are name
Have jurisdiction over range expression;
Tables of data record export introduction method table include export import data table name, import and export field name sequence,
The field name annotated sequence imported and exported;
The tables of data major key maximum value table includes serial number, data table name and data table major key maximum value.
5. development platform according to claim 4, which is characterized in that
The system control supplementary table further includes table record filtering method table, which includes menu identification, filter table class, filtering note
Record number and table record filtering method, the filter table class are used to distinguish the different data table that menu uses when executing filter operation,
The filter record number is used to distinguish different system login personnel using the different record settings of filter method table, when system control
When the menu identification that the menu identification of the table record filtering method table of supplementary table processed and system control main table is identical, menu widget packet
It is called when execution according to the equal principle of key value.
6. development platform according to claim 1, which is characterized in that
The system control table includes menu background process processing method table, is joined for storage menu background process processing method
Number, menu widget packet generate SQL statement according to menu background process processing method dynamic state of parameters, complete the write operation of tables of data,
For the function that dynamic SQL statements cannot be used to realize, by calling the data base procedure code write to realize;The write operation
Including newly-increased table record, modification table record and table record is deleted, the meter reading of write operation and table and meter reading record is write and writes table and remember
Record the parameter that uses include meter reading class, write table class, read record mode, meter reading and list serial number, write table and list serial number, hold
Row reading condition and write operation execute number.
7. development platform according to claim 1, which is characterized in that
The tables of data interrelational form that the menu uses includes single data relationship, subordinate incidence relation, coordination, closes side by side
Subordinate relation, index incidence relation and the source incidence relation of owner's table and subordinate sublist, tables of data association it is unified using major key,
External key is associated with main external key, to the number of the subordinate relation of subordinate incidence relation, coordination, the main table of coordination and subordinate sublist
It is deleted according to table record of the main external key to subordinate list and main table arranged side by side using cascade according to table, index incidence relation is associated with source
The tables of data of system is deleted without using cascade;
The menu includes to single data relationship, subordinate incidence relation, coordination, side by side pass to the usage mode of tables of data
Owner's table and the table record of the tables of data of the subordinate relation of subordinate sublist are inquired or are edited, wherein to single data relationship
Tables of data table record queries or editor when use concordance list;The table record of the tables of data of single data relationship is carried out random
Classifying Sum, random assortment inquiry, temporally count and summarize, entity state of the query entity before any deadline and
State changes the time and/or goes out relative recording according to the record search that user chooses at random;
The form types that the menu uses include that forms method of calling, forms use the mode and forms form of data, in which:
The mode that the forms call includes entree unitary call, the button menu called by window function button calling, by paging menu
Paging menu call, OLE calling, third party software embedded functional calling and the self-editing executable program that name is called call;Institute
It includes the numerical value for only using tables of data, character, date type-word segment data that forms, which are stated, using the mode of data, only uses tables of data
Big binary word segment data, uses the numerical value of tables of data, character, date type-word segment data and big binary field image data;
The forms form includes the unirecord forms for only using one of tables of data record, a tables of data is not in same menu
Similar record using the optional unirecord forms of different unirecords, tables of data by row show a plurality of record more record forms,
The identical field of a plurality of record field value under single main table level-one index is placed on forms top and forms lower part is placed by row
Take the band gauge outfit of a plurality of record of different value fields to record forms, main list record is placed on forms top and lower part is placed by row more
Sublist is subordinated to a plurality of record of the record or sublist unirecord is placed on forms top and lower part is placed sublist by row and is subordinated to
More forms, forms or so respectively place the left and right forms that forms are recorded one more under the upper list of a plurality of record of the record.
8. a kind of database application system development approach, which is characterized in that the database application system is to be taken using database
The database application system of business device, application server and client workstation three-Tier Model, which comprises
System control table is established, the system control table includes the parameter that menu widget packet calls at runtime, the system control
Parameter in tabulation includes system master parameter, system secondary control parameter and menu background process processing method parameter, described
System master parameter and system secondary control parameter are the architecture characterising parameter and menu widget packet of database application system
In handled by foreground process the utility function realized execution method parameter, the menu background process processing method parameter is
The execution method parameter for the specific function realized is handled in menu widget packet by background process;By foreground in the menu widget packet
The execution method parameter for the utility function that process processing is realized and menu backstage carry out processing and execute method parameter to be menu function
Characterising parameter;When modifying the menu function characterising parameter in system control table, the function of menu will be changed correspondingly;
The function menu that database application system is determined according to user demand determines according to the function of function menu and is based on menu number
The reusable execution module of menu function is completed according to the parameter in the calling system control table of processing type, it is described to be reused as counting
The same menu widget packet, the menu number can be used according to all menus for belonging to same data processing type in the application system of library
It include the forms that menu the tables of data interrelational form, the menu that use use the usage mode of tables of data, menu according to processing type
Type;
Parameter assignment is received, based on the received parameter assignment dish corresponding with the matching result of the parameter in system control table calling
Single member packet dynamic generation executable code is to complete the exploitation of database application system;
The architecture characterising parameter of the database application system and the type of menu function characterising parameter include non-enumeration type
Parameter enumerates shape parameter and expression argument;When using multiple subparameters in a parameter, subparameter includes non-enumeration type ginseng
Number enumerates shape parameter or expression argument, is separated between subparameter with agreement separator;The system control table uses public
Shape parameter of enumerating include table class and public variable, the table class is the tables of data that menu forms use or executes read-write operation and make
Tables of data, the public variable are used to save the identity of login personnel in database application system operation, in which:
The non-shape parameter of enumerating includes numeric parameter and string argument, and the numeric parameter is integer or integer sequence, whole
It is separated between integer in Number Sequence using agreement separator, the string argument is character string or character string sequence, character
It is separated between character string in string sequence with agreement separator;
The shape parameter of enumerating is the integer for indicating to enumerate serial number;
The expression argument is to use corresponding expression argument in SQL statement when database SQL sentence.
9. development approach according to claim 8, which is characterized in that the method specifically includes:
System control table and the fundamentals of management table of development platform are established in the database;
Carry out user requirements analysis, typing fundamentals of management table data, comprising: analysis management mechanism, typing management organization table data;
Analysis management specification, typing management regulation data table data;Analysis management level, typing manage object table data;Typing personnel
Duty list data, the identifying data of Responsibility of Staff table storage system user of service;
The function menu and function menu that the functional module of application system and functional module use are determined according to user requirements analysis
The function that should be realized;It determines menu operation permission, and is established by development platform tables of data master, external key regulation and customer service requirement
Menu data table;
The tables of data interrelational form used according to function menu, the usage mode of tables of data, the menu form types used determine
The menu widget packet that each function menu uses;
When function menu calls forms without using OLE, the tables of data and interface requirements used according to function menu determines forms shape
Formula, creation menu forms;Determine forms date type-word section display mode, forms numeric type field display mode;Menu is looked into for Web
The Web query page is edited when asking menu;
It determines when all kinds of users of service execute function menu to the filter condition of menu data table record;It is multiple to determine that menu uses
The interrelational form of table when tables of data;Reading field regulation when using source table;
Determine the sequence word of the data table index fields that function menu uses, the indexed mode of date type index field, table record
The type field and value field that OLE is called when section, sortord, function menu call forms using OLE;
Determine that the function button of function menu, the function button include Edit button, background process call buttons, button menu
The paging menu identity button that call buttons and paging menu use;
Determine editor's shielding that function menu records tables of data, the condition editor shielding, grouping edit condition or the method that record;
Determine that function menu edits the field shielding that tables of data records, condition field shields edit methods;
Determine that newly-increased table record sets public variable, constant regulation, newly-increased record clone method, field editing and calls Select input side
The parameter designing of Select input method table is completed when method;
It is determining to be summarized using random assortment, random assortment inquiry, count classification and method of summary regulation when summarizing by the period;
Determine that field and table must be recorded when editor saves records uniqueness judgment method;
Determine the Row control option regulation of call flow control;
Determine that the background process that menu should be realized calls, the call buttons and call regulation that background process calls;
Complete the parameter designing of the menu background process processing method table of menu background process processing;
To cannot use the menu of menu widget packet write processing routine, determine call third party software method, write database
Process;
Execution program, the application server programs of development platform are installed;Copy menu forms to application server;In system control
The relevant parameter that typing menu function designs in tabulation;Self-compiling program and third party software are installed, operation development platform executes journey
Sequence carries out menu operation priority assignation, and after each work station carries out system setting, system puts into operation.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201310066589.0A CN103092631B (en) | 2007-04-06 | 2007-04-06 | A kind of data base application system development platform and development approach |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN 200710017624 CN101034349A (en) | 2007-04-06 | 2007-04-06 | Data base application system development platform based on functional design |
CN201310066589.0A CN103092631B (en) | 2007-04-06 | 2007-04-06 | A kind of data base application system development platform and development approach |
Related Parent Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN 200710017624 Division CN101034349A (en) | 2007-04-06 | 2007-04-06 | Data base application system development platform based on functional design |
Publications (2)
Publication Number | Publication Date |
---|---|
CN103092631A CN103092631A (en) | 2013-05-08 |
CN103092631B true CN103092631B (en) | 2019-02-19 |
Family
ID=48205242
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201310066589.0A Active CN103092631B (en) | 2007-04-06 | 2007-04-06 | A kind of data base application system development platform and development approach |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN103092631B (en) |
Families Citing this family (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103488692B (en) * | 2013-09-02 | 2017-02-08 | 用友网络科技股份有限公司 | Data query system and data query method |
CN103530378B (en) * | 2013-10-15 | 2017-01-18 | 福建榕基软件股份有限公司 | Data paging query method and device and data base construction method and device |
CN104077133A (en) * | 2014-06-24 | 2014-10-01 | 中国地质大学(北京) | Configuration type menu generating method |
CN104331445B (en) * | 2014-10-27 | 2018-01-23 | 北京金和软件股份有限公司 | A kind of menu automatic loading method of personalized APP management platforms |
CN107193963B (en) * | 2017-05-24 | 2020-04-21 | 中国人民解放军陆军勤务学院 | Distributed development method of database application system |
CN107634996A (en) * | 2017-09-08 | 2018-01-26 | 苏州数睿云信息技术有限公司 | A kind of framework of unified data and business operation service development platform |
CN108319694B (en) * | 2018-02-02 | 2023-01-20 | 中国银行股份有限公司 | Automatic historical data cleaning method and device |
CN110389959A (en) * | 2019-07-26 | 2019-10-29 | 中移电子商务有限公司 | A kind of data managing method, device and storage medium |
TWI764305B (en) * | 2020-09-30 | 2022-05-11 | 中華電信股份有限公司 | Group order linked management method |
CN114138363A (en) * | 2021-11-27 | 2022-03-04 | 深圳市元征科技股份有限公司 | Program data calling method, device, equipment and storage medium |
CN114741072B (en) * | 2022-04-20 | 2024-03-12 | 苏州峰之鼎信息科技有限公司 | Page generation method, device, equipment and storage medium |
Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1367448A (en) * | 2001-01-26 | 2002-09-04 | 国际商业机器公司 | Code generator system for digital library and its method |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7398474B2 (en) * | 2005-01-31 | 2008-07-08 | Microsoft Corporation | Method and system for a digital device menu editor |
-
2007
- 2007-04-06 CN CN201310066589.0A patent/CN103092631B/en active Active
Patent Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1367448A (en) * | 2001-01-26 | 2002-09-04 | 国际商业机器公司 | Code generator system for digital library and its method |
Non-Patent Citations (1)
Title |
---|
《基于J2EE的WEB界面定制通用平台的设计与开发》;洪建宇;《中国优秀博硕士学位论文全文数据库 (硕士) 信息科技辑》;20070215(第2期);第19-54页 |
Also Published As
Publication number | Publication date |
---|---|
CN103092631A (en) | 2013-05-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN103092631B (en) | A kind of data base application system development platform and development approach | |
Couger | Evolution of business system analysis techniques | |
Bracchi et al. | The design requirements of office systems | |
AU780565B2 (en) | Method and apparatus for selecting aggregate levels and cross product levels for a data warehouse | |
US5930806A (en) | Method and system for data migration from network database to relational database | |
Herbst et al. | The specification of business rules: A comparison of selected methodologies. | |
US7979475B2 (en) | Coherent data identification method and apparatus for database table development | |
Dinkhoff et al. | Business process modeling in the workflow management environment LEU | |
CN111984709A (en) | Visual big data middle station-resource calling and algorithm | |
CN101539855A (en) | Service basic software platform | |
CN106372044A (en) | Method for generating typed dimension XBRL (Extensible Business Reporting Language) report based on report form | |
CN110442620A (en) | A kind of big data is explored and cognitive approach, device, equipment and computer storage medium | |
CN112506892A (en) | Index traceability management system based on metadata technology | |
Di Leva et al. | Information system analysis and conceptual database design in production environments with M∗ | |
Berio et al. | The M*-OBJECT methodology for information system design in CIM environments | |
Lenard | A prototype implementation of a model management system for discrete-event simulation models | |
Shikhli et al. | Data Acquisition Model for Analyzing Schedule Delays Using KDD: Knowledge Discovery and Datamining | |
Barbic et al. | Modeling and integrating procedures in office information systems design | |
Rahimifard | A methodology to develop EXPRESS data models | |
Kim et al. | Comparing object-oriented and relational data models for project control | |
Di Leva et al. | Enterprise analysis and data base design with M∗: a case study | |
Haseman et al. | Implementation of a large scale water quality data management system | |
Vernadat | Databases for CIMS and IMS | |
Pavković et al. | Two examples of database structures in management of engineering data | |
Kirschenbauer et al. | Data derivation in information systems. |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |