CN101866297B - Method and device for generating management platform - Google Patents

Abstract

The invention discloses a method for generating a management platform, comprising: obtaining a database name input by a user; importing all fields in the corresponding database into a preset first data dictionary according to the database name; obtaining a function setting instruction input by the user; Determine the corresponding function of the first data dictionary; obtain the menu information input by the user; set the menu of the first data dictionary according to the menu information; output the first data dictionary as a management platform. The invention also provides a corresponding device. The present invention adopts a preset data dictionary, and when a developer needs to develop and apply, by calling the data dictionary, function setting is performed on the basis of the data dictionary, which reduces the threshold of program development and improves the development efficiency of management software.

Description

Management platform generation method and device

technical field

The invention relates to the field of application software development, in particular to a method and device for generating a management platform.

Background technique

As the needs of enterprises for management platforms become more and more diverse, the research and development of new management platforms also require faster speed. The research and development of the existing management platform must be developed by specialized R&D personnel. This type of management platform is characterized by a variety of functions, but most of the functions are simple.

During the specific implementation process, the inventors of the present invention found that the research and development of the management platform occupies the working time of many high-level program developers, and the system has a lot of repetitive labor, the productivity of the developers is low, and the labor cost is very high. , but the final output is very low.

Contents of the invention

The main purpose of the present invention is to provide a method for generating a management platform and a corresponding device that lowers the threshold of program development and improves the development efficiency of management software.

The present invention proposes a method for generating a management platform, comprising:

Get the database name entered by the user;

importing fields in the corresponding database into the preset first data dictionary according to the database name;

setting the corresponding function of the first data dictionary according to the function setting instruction input by the user;

setting the menu of the first data dictionary according to the menu information input by the user;

Outputting the first data dictionary as a management platform.

Further, before obtaining the database name input by the user, the method includes:

Obtain user login information;

verify said login information;

When the login information is verified, the user login is accepted.

Further, the function setting instruction input by the user includes:

Acquire window setting instructions and/or advanced query setting instructions and/or report setting instructions and/or time setting instructions and/or workflow setting instructions input by the user.

Further, the menu information input by the user includes: acquiring basic menu information and menu corresponding function information input by the user.

Further, setting the menu of the first data dictionary according to the menu information includes:

Obtain permission information input by the user, where the setting permission information includes menu permission information and/or function permission information and/or data permission information;

A corresponding relationship between menus and permissions is set according to the permission information.

Further, before the output data dictionary is used as the management platform, it includes:

Obtain the second data dictionary;

Importing the second data dictionary into the first data dictionary.

The present invention also proposes a management platform generation device, including:

The acquiring module is used to acquire the database name input by the user; acquire the function setting instruction input by the user; acquire the menu information input by the user;

An import module, configured to import all fields in the corresponding database into the preset first data dictionary according to the database name;

A setting module, configured to set a corresponding function of the first data dictionary according to the function setting instruction; set a menu of the first data dictionary according to the menu information;

An output module, configured to output the first data dictionary as a management platform.

Further, the device also includes:

The verification module is used to acquire user login information; verify the login information; and accept user login when the verification of the login information is passed.

Further, the acquiring module is specifically configured to: acquire a window setting instruction and/or an advanced query setting instruction and/or a report setting instruction and/or a time setting instruction and/or a workflow setting instruction input by a user.

Further, the acquisition module is specifically used for:

Obtain the basic information of the menu and the corresponding function information of the menu input by the user.

Further, the obtaining module is also used to obtain permission information input by the user, and the setting permission information includes menu permission information and/or function permission information and/or data permission information;

The setting module is also used to set the corresponding relationship between menus and permissions according to the permission information.

Further, the import module is further configured to: obtain a second data dictionary; import the second data dictionary into the first data dictionary.

The present invention adopts a preset data dictionary, and when a developer needs to develop and apply, by calling the data dictionary, function setting is performed on the basis of the data dictionary, which reduces the threshold of program development and improves the development efficiency of management software.

Description of drawings

Fig. 1 is a flowchart of an embodiment of a method for generating a management platform of the present invention;

Fig. 2 is a flow chart of another embodiment of a method for generating a management platform of the present invention;

Fig. 3 is a schematic structural diagram of an embodiment of a management platform generation device according to the present invention.

The realization of the purpose of the present invention, functional characteristics and advantages will be further described in conjunction with the embodiments and with reference to the accompanying drawings.

Detailed ways

It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

Referring to Fig. 1, it is a flowchart of an embodiment of a method for generating a management platform of the present invention;

In the embodiment of the present invention, a set of database table structures needs to be pre-designed, which can also be a defined format of a set of files, or other storage methods on a set of storage media. The embodiment of the present invention is called a data dictionary.

The data dictionary can include the following information:

The data dictionary of the interface window, the data dictionary of the labels under each window, the data dictionary of the attributes under each label, the data dictionary of each attribute corresponding to the drop-down box, the data dictionary of each attribute corresponding to the trigger event, the report or query definition data dictionary , department role authority data dictionary, menu data dictionary, menu and function corresponding relationship data dictionary (function can be window, report, query), workflow data dictionary, etc.

The import and export function is set in advance, so that these data dictionaries can be imported and exported conveniently, so that application development can be carried out on any terminal. The file format of import and export can be text or binary, such as TXT or XML of.

The operator can use the following steps to implement the secondary research and development:

Step S101, the operator logs into the management platform generating device;

When the operator performs the login operation, the following verification steps can be used:

A. The management platform generation device acquires user login information;

B. The management platform generation device verifies the login information;

C. The management platform generation device accepts user login when the login information is verified.

Step S102, the management platform generating device imports the data dictionary;

The operator can use the import function provided by the management platform generation device to input the name of the database table, and the management platform generation device will automatically import all the fields in the database table into the data dictionary, and all attributes are defaulted to text boxes.

Step S103, the management platform generation device acquires the function setting instruction input by the user and sets it;

Specifically, the management platform generation device acquires the function setting instruction input by the operator; and sets the corresponding function of the first data dictionary according to the function setting instruction.

Operators can send function setting instructions according to requirements to set related functions, and the functions include window, advanced query, report, time and workflow, etc. The same function setting instructions sent by the operator to the management platform generation device can also include: window setting Instructions and/or advanced query setting instructions and/or report setting instructions and/or time setting instructions and/or workflow setting instructions, etc. The relevant information of the window may further include: basic information of the window, basic information of the label, and basic information of the attribute. Basic attribute information The information for selection includes: attribute display mode, such as edit box, text box, drop-down box, pop-up window, button, whether it is writable or read-only, alignment, if it is the event type triggered by the button, event name, etc. wait.

Step S104, the management platform generation device acquires menu information and sets it;

The management platform generation device acquires menu information input by the operator; and sets the menu of the first data dictionary according to the menu information.

The menu information includes basic information of the menu and function information corresponding to the menu.

Step S105, obtaining permission information;

The management platform generation device obtains the authority information input by the operator; the authority information includes menu authority, function authority and data authority.

Step S106, the management platform generation device sets the corresponding relationship between the menu and the authority according to the authority information;

The management platform generation device sets the corresponding relationship between the menu and the authority after obtaining the information of the whole county.

Step S107, importing other data dictionaries;

The management platform generation device imports the definition of the data dictionary according to user requirements, and imports data dictionaries defined by other systems or backup application data dictionaries.

Step S108, the management platform generation device exports the data dictionary.

The management platform generation device can provide a caching function, and put the definition information including the database dictionary and other necessary information into the memory for buffering, so that the display speed of the interface can be improved.

The management platform generation device may be based on a traditional C/S architecture, or a B/S architecture, or other architectures that provide a terminal interface;

Operators or secondary developers can enter the following operations:

Set the basic information of the window to be displayed;

Set the basic information of the label under each window;

According to the import tool provided by the system, enter the name of the database table, and import all the attributes in the table into the attribute data dictionary. Each attribute has a default value, for example, each attribute defaults to a text box;

Modify the basic information of each attribute under each tag, such as modifying the text box to a radio box;

Set the basic information of each attribute corresponding to the drop-down box;

Set the basic information of each attribute corresponding to the trigger event;

Set the basic information of department role permissions;

Set the basic information of the menu;

Set the basic information of the report or query;

Set the corresponding relationship between menus and functions;

Set the basic information of the workflow;

The import and export function provided by the present invention makes the transplantation and upgrade of the system simple and convenient. The caching mechanism can improve the speed of interface display.

The embodiment of the present invention adopts a preset data dictionary. When a developer needs to develop an application, by calling the data dictionary, the function is set on the basis of the data dictionary, which reduces the threshold of program development and improves the development efficiency of management software. .

Referring to Fig. 2, it is a flowchart of another embodiment of a method for generating a management platform of the present invention;

The embodiment of the present invention uses a specific example to demonstrate the secondary development process of the above embodiment. This embodiment takes the need to develop a bank account system as an example. One of the functions is customer information, and the customer information function has a window. There is a label under the label to display four attributes: customer name, customer gender, customer password, and customer city. Among them, the customer name is an edit box, customer gender is a radio button, customer password is a password edit box, and the customer city is a drop-down box, the function will be developed below.

Step S201. Create a customer information table in the database, including four fields: customer name, customer gender, customer password, and the city to which the customer belongs;

Step S202, the management platform generation device creates a new window according to the operator's input instruction, and the name is bank customer information maintenance;

Step S203, the management platform generation device creates a new label, the name is the basic information of the customer, and selects the name of the customer information table corresponding to the label;

Step S204, the management platform generation device imports the four fields below the customer information table into the platform, which are four edit boxes by default;

Step S205, the management platform generation device performs attribute maintenance according to the operator's control;

The operator can control the management platform generating device to query the four attributes related to customer information and modify them one by one. The customer name edit box remains unchanged, the customer gender selection is a radio box, the customer password selection is a password edit box, and the customer's city is changed to drop-down box;

Step S206, the management platform generation device adds the city to which the customer belongs;

The management platform generation device adds a new list according to the operator's request, corresponding to the city to which the customer belongs;

Step S207, the management platform generation device adds customer information maintenance;

The management platform generation device adds a new menu according to the operator's requirements, which is associated with the customer information maintenance window, and the name is customer information maintenance;

Step S208, setting authority of the management platform generation device;

The management platform generation device adds a new role, bank information administrator, according to the operator's requirements, and grants the customer information maintenance menu authority to this role;

Step S209, the management platform generation device sets the operator role according to the authority.

The management platform generating device adds an operator bank001 according to the operator's request, and assigns the bank information administrator role to the operator;

The completed data dictionary is set everywhere as a new system.

Operator bank001 can log in to the system, use the customer information maintenance function, and perform operations such as adding, deleting, modifying, and checking.

The embodiment of the present invention can improve the development efficiency of the application system, and has very low requirements on the technical ability of the developers. It can be developed only after simple training. In addition, the present invention can also develop some functions for skilled customers, allowing them to choose what they need Window properties, advanced queries you need, statistical reports.

Referring to FIG. 3 , it is a schematic structural diagram of an embodiment of a management platform generating device according to the present invention.

The management platform generating device proposed by the embodiment of the present invention includes:

The obtaining module 31 is used to obtain the database name input by the user; obtain the function setting instruction input by the user; obtain the menu information input by the user;

An import module 32, configured to import all fields in the corresponding database into the preset first data dictionary according to the database name;

A setting module 33, configured to set the corresponding function of the first data dictionary according to the function setting instruction; set the menu of the first data dictionary according to the menu information;

An output module 34, configured to output the first data dictionary as a management platform.

Further, the device also includes:

The verification module 35 is configured to acquire user login information; verify the login information; and accept user login when the verification of the login information is passed.

Further, the acquiring module 31 is specifically configured to: acquire a window setting instruction and/or an advanced query setting instruction and/or a report setting instruction and/or a time setting instruction and/or a workflow setting instruction input by a user.

Further, the acquiring module 31 is specifically used for:

Obtain the basic information of the menu and the corresponding function information of the menu input by the user.

Further, the obtaining module 31 is also used to obtain permission information input by the user, and the setting permission information includes menu permission information and/or function permission information and/or data permission information;

The setting module 33 is further configured to set a corresponding relationship between menus and permissions according to the permission information.

Further, the import module 32 is further configured to: obtain a second data dictionary; import the second data dictionary into the first data dictionary.

The user can use the import module 32 provided by the management platform generating device to input the name of the database table, and the import module 32 will import all fields in the database table into the data dictionary, and all attributes are defaulted to text boxes.

The acquisition module 31 obtains the user to send a function setting instruction according to the requirement to set related functions, wherein the functions include window, advanced query, report, time and workflow, etc., and the same function setting instruction sent by the user to the management platform generation device may also include: window Setting instructions and/or advanced query setting instructions and/or report setting instructions and/or time setting instructions and/or workflow setting instructions, etc. The relevant information of the window may further include: basic information of the window, basic information of the label, and basic information of the attribute. Basic attribute information The information for selection includes: attribute display mode, such as edit box, text box, drop-down box, pop-up window, button, whether it is writable or read-only, alignment, if it is the event type triggered by the button, event name, etc. wait.

The user can perform the following operations through the setting module 33:

Set the basic information of the window to be displayed;

Set the basic information of the label under each window;

According to the import tool provided by the system, enter the name of the database table, and import all the attributes in the table into the attribute data dictionary. Each attribute has a default value, for example, each attribute defaults to a text box;

Modify the basic information of each attribute under each tag, such as modifying the text box to a radio box;

Set the basic information of each attribute corresponding to the drop-down box;

Set the basic information of each attribute corresponding to the trigger event;

Set the basic information of department role permissions;

Set the basic information of the menu;

Set the basic information of the report or query;

Set the corresponding relationship between menus and functions;

Set basic workflow information.

The embodiment of the present invention can improve the development efficiency of the application system, and has very low requirements on the technical ability of the developers. It can be developed only after simple training. In addition, the present invention can also develop some functions for skilled customers, allowing them to choose what they need Window properties, advanced queries you need, statistical reports.

The above descriptions are only preferred embodiments of the present invention, and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made by using the description of the present invention and the contents of the accompanying drawings, or directly or indirectly used in other related All technical fields are equally included in the scope of patent protection of the present invention.

Claims (7)

1. a management platform generation method, is characterized in that, comprising:

Obtain the database table name of user's input;

According to field in the database table star correspondence database table obtaining, import the first preset data dictionary;

According to the function setting instruction of user's input, set the corresponding function of described the first data dictionary; Described function setting instruction comprises: window arranges instruction and/or advanced inquiry and instruction and/or form are set instruction and/or set of time instruction and/or workflow are set instruction is set;

According to the menu information of user's input, set the menu of described the first data dictionary; Described menu information comprises: the function information that the essential information of menu and menu are corresponding;

The authority information that obtains user's input, described authority information comprises menu authority information and/or function privilege information and/or data permission information;

The corresponding relation of menu and authority is set according to described authority information;

Export described the first data dictionary as management platform.

2. method according to claim 1, is characterized in that, described in comprise before obtaining the database table name of user input:

Obtain user login information;

Verify described log-on message;

When described log-on message is verified, accept user's login.

3. a management platform generating apparatus, is characterized in that, comprising:

Acquisition module, for obtaining the database table name of user's input; Obtain the function setting instruction of user's input; Obtain the menu information of user's input;

Import module, for importing preset the first data dictionary according to all fields of described database table star correspondence database table;

Setting module, for setting the corresponding function of described the first data dictionary according to described function setting instruction; According to described menu information, set the menu of described the first data dictionary; Described function setting instruction comprises: window arranges instruction and/or advanced inquiry and instruction and/or form are set instruction and/or set of time instruction and/or workflow are set instruction is set; Described menu information comprises: the function information that the essential information of menu and menu are corresponding;

Output module, for exporting described the first data dictionary as management platform;

Described acquisition module is also for obtaining the authority information of user's input, and described authority information comprises menu authority information and/or function privilege information and/or data permission information;

Described setting module is also for arranging the corresponding relation of menu and authority according to described authority information.

4. device according to claim 3, is characterized in that, described device also comprises:

Authentication module, for obtaining user login information; Verify described log-on message; When described log-on message is verified, accept user's login.

5. device according to claim 3, it is characterized in that, described acquisition module arranges instruction and/or advanced inquiry specifically for: the window that obtains user input and instruction and/or form are set instruction and/or set of time instruction and/or workflow are set instruction is set.

6. device according to claim 3, is characterized in that, described acquisition module specifically for:

Obtain menu essential information and the menu corresponding function information of user's input.

7. according to arbitrary described device in claim 3 to 6, it is characterized in that, described importing module also for: obtain the second data dictionary; Described the second data dictionary is imported to described the first data dictionary.