CN106445536B

CN106445536B - Automatic business design management system

Info

Publication number: CN106445536B
Application number: CN201610866574.6A
Authority: CN
Inventors: 刘建辉
Original assignee: Zhanjiang Xiashan District Xinruanjia Technology Co ltd
Current assignee: Bozhi network technology (Zhanjiang) Co.,Ltd.
Priority date: 2016-09-28
Filing date: 2016-09-28
Publication date: 2021-06-25
Anticipated expiration: 2036-09-28
Also published as: CN106445536A

Abstract

The invention provides an automatic business design management system which can be developed, used and maintained by business personnel and meets the business requirements of the business personnel. The system comprises a server and a client, wherein the server comprises a server program and a database. The client program collects user service design information through a design tool and submits the user service design information to the server. And the server program is used for receiving the user service design information and carrying out design processing. And the server program provides data information or service processing results related to the service according to the service use requirements of the client. And the client program displays a corresponding service interface according to the service data and the interface information returned by the server program. The invention is suitable for all software development adopting the relational database, guides service personnel to quickly complete service development and put into production and use immediately, can reuse the service and can modify the service according to requirements at any time, and greatly reduces the cost of service development and maintenance.

Description

Automatic business design management system

Technical Field

The embodiment of the invention relates to an industry or enterprise informatization oriented management system, in particular to a design management system which can be used by business personnel to develop, use and maintain program modules meeting the business requirements of the business personnel.

Background

With the development of computer technology, social aspects and software are more and more closely combined, and particularly, business enterprises rely on an application management system based on a relational database to process daily matters. However, developing a software system meeting self business requirements relates to multiple technical types and strong specialization, enterprises often adopt a mode of entrusting a software developer to develop, and development process links are multiple, so that the development period is long, and the development can be completed in months. If the demand changes greatly, the software system which is delivered for use faces the situation that the maintenance difficulty is large or the business needs to be redesigned. The business is in the dominant position among them.

Software developers can greatly accelerate development progress if they use Computer Aided Software Engineering (CASE) tools. The CASE tool is composed of a plurality of parts, and is generally divided into an upper CASE product and a lower CASE product according to different stages of software development. The upper-level CASE tool automatically performs planning, design and analysis of the application, helps a user define requirements, generates requirement specifications, and can complete all planning work related to application development. The lower-layer CASE tool automatically performs programming, testing and maintenance work on the application system. Unless the suppliers of the lower CASE and upper CASE tools provide a unified interface, the user must write or re-convert all information from the upper CASE tool to the lower CASE tool. The CASE tool mainly comprises: drawing tools, report generation tools, data dictionaries, database management systems and specification inspection tools, code generation tools and document material generation tools, etc. The current standard for CASE is UML. The tools are integrated in a unified CASE environment, so that the transferability of data among the tools can be realized through a public interface, all steps in the development and maintenance process of the system are connected, and finally, all development work of the system is realized on a unified software and hardware platform.

The invention is similar to the design concept of the CASE tool. The invention adopts visual design tool, message mechanism, database operation of design processing, code generation, design document generation downloading and the like, and provides high efficiency and high reliability which are common with CASE tool. However, the embodiments are significantly different from the CASE tool: the CASE tool belongs to the technical field of computer aided software engineering, is service-oriented to developers, has no client interface, completes a part of a software life cycle by a single tool, does not have necessarily have relevance among the tools, and is difficult to form an integrity system; the system mainly aims at business personnel in the enterprise, fully considers the usability and the standardability in the implementation, pays attention to a client interface, has strong business adaptability and reusability, and forms an independent whole aiming at the development, the use and the maintenance of the business. The enterprise is in the leading position among the enterprises, and is an implementation method of a user generation program.

The problems existing in the current software system development are summarized as follows:

1. the technical requirement of the software system is high, the development period is long, and the cost for entrusting software developers to develop the software system is high;

2. software developers use auxiliary tools to improve efficiency, which may not necessarily reduce enterprise development software overhead significantly.

Disclosure of Invention

The invention aims to solve the technical problem of providing an automatic service design management system which can be used efficiently and repeatedly, wherein enterprise service personnel can develop, use and maintain program modules meeting self service requirements by themselves. The concrete solution is as follows:

the automatic business design management system comprises a server and a client, wherein the server comprises an automatic business design management system server program and a database; the client comprises an automated business design management system client program. The automatic service design management system client program of the client collects user service design information through a design tool and submits the information to the server. And the server-side program of the automatic service design management system of the server is used for receiving the user service design information and carrying out design processing. And the automatic service design management system server-side program of the server provides data information or service processing results related to the service according to the service use requirements of the client-side. And the automatic service design management system client program of the client displays a corresponding service use interface according to the service data and the interface information returned by the server program.

The invention has the advantages that by establishing the automatic service design management system at the server and the client, service personnel can design a database model which is modeled according to service requirements by using a design tool, set relevant interface attributes and submit to design processing, the system automatically generates a table or a view, generates a design document, establishes relevant entity classes, completes a program module of the service, prepares for the use of the service and effectively reduces the dependence on the development personnel; when a service person uses a service module, a client program automatically calls a related interface control according to a used service function to send a request to a server program and acquire service data and related interface attribute information, and interface display is completed.

Drawings

FIG. 1 is a schematic diagram of an automated business design management system using a development tool to develop and maintain a business.

FIG. 2 is a schematic diagram of the automated business design management system using developed business.

Detailed Description

In the development process shown in fig. 1, the development tool is a set of form sets, and the development tool is responsible for collecting business information, forming design information and submitting the design information to an automated business design management system server program for design processing. The submitted design information is indispensable information set according to business requirements, and comprises the content (table, column, range and constraint) required by the complete database modeling of the business part and the attribute information of the use interface of the business part in the client. The service part is represented by a two-dimensional table, and each service element is converted into columns, ranges and constraints of the two-dimensional table. The design tool can reuse previous design solutions. Multiplexing in a table constrained manner: the logic relation between the services is embodied by multiplexing a certain column of a currently designed table and a certain column of a multiplexed table (a table of a database which is generated after design processing) through setting a foreign key constraint relation, and a setting step is provided by a design tool, wherein the multiplexed table can be a main key table or a foreign key table. And (3) view mode multiplexing generation: the method comprises the steps of taking a multiplexed table (a table of a database which is designed and processed to generate) as a driving table, acquiring data of other tables by utilizing a foreign key constraint relation which is set by a column of the table and is related to other tables, belonging to typical multi-table connection, generating a view in the database, representing all relevant business logic taking a business represented by the multiplexed table as a viewport, and providing a setting step by a design tool. Multiplexing in a multi-table connected sql statement manner: the method comprises the steps of taking a multiplexing table (a table of a database which is generated after design processing) as a driving table, obtaining data of other tables by utilizing a foreign key constraint relation which is set by a column of the table and is connected with other tables, belonging to typical multi-table connection, but not generating a view in the database, embodying all related business logics which take business represented by the multiplexing table as a viewport, providing a setting step by a design tool, and dynamically generating corresponding multi-table connection sql statements for operation by utilizing design redundancy information (a design information redundancy table or entity class mark redundancy information) generated in the design processing during operation to achieve the effect of view similarity. The design processing models the design information according to the database of the business, and a DDL statement is used for generating a table or a view in the database; according to the overall design information, a design document can be generated for a user to store and download, the design document can provide reversible operation, can generate a database business model, can also generate the document from the database business model, and can restore the design information (for modification and viewing) before the design tool submits; generating a corresponding entity class according to the generated service database table or view; the entity class is enabled to run in a runtime environment, methods including, but not limited to, "dynamic compilation. The design processing can save the submitted design information in a database table to form a redundant table independent of the design document, or adopt a marking mode as a redundant record when generating an entity class, or adopt both modes, or can directly use the design document to obtain the design information without adopting redundancy. Design information before the design tool submission (for modification viewing) may be restored from the redundant table.

In the use process shown in fig. 2, the interface control belongs to a client program, and has an interface for acquiring related service data and interface attribute information of the interface from a server according to service use requirements, or an interface for completing a service related function by inputting the service data and submitting the service data to the server, or both interfaces. The interface is composed of 1 or more interface controls, and the interface controls are distinguished according to functions and include but are not limited to search controls, function button area controls, form controls, data display controls, newly-added form controls, modified form controls, and exported data controls. The interface for the interface control to obtain the self interface attribute information is connected with the service function for obtaining the service related interface attribute information provided by the server program, the interface attribute information is obtained, and the interface control is provided for generating a corresponding interface according to an agreed form. The self interface attribute information acts on the service column to show the appearance of the column on the client interface control, the column is in a corresponding relation of multiple pairs 1 with the column, the column is considered by the interface control in advance, and a service designer can only adjust the column within a limited range at most. A business column represents an element of a business, being a column (projection) of a business table or business view generated in the design process or a multi-table connection that is equivalent to a view but does not generate a view in the database. The service function for obtaining the service related interface attribute information provided by the server program has a list of all interface attributes of the existing interface control, the list is classified according to the functions of the control and the data types of the column range of the described service list, 1 service column can have a corresponding relation with one or more attributes on the list, and the service function obtains all the interface attributes of all the service columns belonging to the service of the control according to the classification of the function of the calling control and transmits the interface attributes to the interface control called by the client in an agreed form. All interface property list existence modes of the existing interface control include but are not limited to: 1 or more data table stores, 1 or more server file stores, and 1 or more server program variable assignments. After the interface control acquires the interface attribute information, the appearance of the columns is determined one by one according to the design sequence of the service columns and following a certain interface layout rule: with that basic control, shape size, color, etc. An interface control can include one or more base controls. The basic control is controlled by the interface control to complete a single function, and is a basic container of business data. Including but not limited to input controls, single (multiple) drop-down box controls, single (multiple) tree control, date and time controls, upload picture controls, upload attachment controls, basic form controls, and the like. The interface control is connected with the functions of adding, deleting, modifying, exporting and the like of the service provided by the server program through the interface which inputs the service data and submits the service data to the server to complete the functions of adding, deleting, modifying, exporting and the like of the service provided by the server program, and the server program carries out the processing of adding, deleting, modifying, exporting and the like on the service table record determined by the information input from the interface through the entity class, thereby realizing the functions.

For example, the following steps are carried out:

a middle school needs to be provided with a teaching staff management system, and a schoolmate of a programming interest group is entrusted to design by using an automatic business design management system of a B/S mode. Xiaoming analysis: a master form of the teaching staff is required to meet the requirements, and basic information, belonging level group information and belonging department group information are recorded. Therefore, the modeling setting information of the design tool at the client end of Xiaoming is as follows: tables (table name: teacher table; table english name: Teachers), columns and ranges (column name: teacher number, column english name: TNO, data type: character string, length: 6, interface control attribute: new modification control must fill in the field & new modification control use input control fill in & data presentation table control & table control the column displays cell length 150px & table control the selection judgment condition of the field ordered before & search control is fuzzy query, [ column name: year of birth month, column english name: Birthday, data type: date, interface control attribute: date control must fill in the field & data presentation table control & table control the column displays cell length 100px & table control the column ordered before & search the selection judgment condition of the field ordered before & search control is equal to value ], … … is a basic information field such as name, cell number, address, etc.), constraint (because teachers and level groups are in a many-to-one relationship, all the main keys of the level group fields and the level group tables of the teachers and the level groups are set to be in an external key constraint relationship, the column names of the level groups are belonged to, the English names of BelongGrade, the newly-added modification search interface controls use single-selection drop-down frames, and the newly-added modification interface controls are filled in the fields), (the main keys of the department group fields and the department group tables of the teachers and the level groups are set to be in an external key constraint relationship, and the TNO is set to be in a unique constraint). The Xiaoming submits design information, the server completes design processing (a Teachers table is generated in a relational database, table fields comprise TNO, Birthay, … …, BellingGrade and BellingSubject, foreign key relations of BellingGrade and BellingSubject are established, a Teachers entity class is generated through dynamic compiling, redundant design information such as foreign key relations, main key information and the like is marked on class and field, the design information is respectively inserted into corresponding redundant tables according to the attributes of the table, the column and the interface control, a design document bkd file is generated), and after processing, a message mechanism is called to prompt that the generation is successful, and bkd file downloading is provided. The generated teacher's table ' is put under the basic data menu of the left menu to form a new sub-menu ' teacher's table '. Thus, clicking the sub-menu "teacher's table" can start using the service module.

Because the "teacher sheet" service is set to present data using the form interface controls, clicking on the sub-menu "teacher sheet" appears to be a typical form presentation data interface: the system comprises a search interface control, a function button interface control and a table interface control. In order to display the interface, the form interface control sends a request for acquiring service data and interface attributes to the server, the server inquires the service function and returns the form name, the column sorting information, the form cell shape and the like interface attributes required by the form interface control, the form interface control finishes the drawing of a form frame according to the information, and fills the service data into the cells according to the sorting sequence to finish the display of the form; the search control forms a search form according to the returned list of column names, and the form is as follows: [ column names: basic controls ], for example: (class group of belonging: when the form is submitted, the server program generates a where clause of an entity class persistence concept according to an 'equivalent' or 'fuzzy' attribute set by an interface attribute, calls the persistence entity class of the service to complete a search query function, and displays a returned data result in the form control. The function button area provides general functions of adding, deleting, modifying, checking and exporting data EXCEL, and also adds function buttons which belong to the specific function buttons of the currently used interface control or function buttons which are customized by a designer and are used for mathematical processing or logical judgment of single or combined service columns. Determining the record needing to be processed in the form control, submitting the record ID to a server-side program, processing the record of the business data table by the server-side program through calling a persistent entity class, returning the result through a message mechanism, and updating the business data of the form interface control.

Therefore, the modeling development of the main form of the teaching staff is completed only in half an hour, and the system automatically completes other parts of the business to obtain a program module with complete functions. Xiaoming, a business effort, continues to develop the staff payroll, attendance sheet, etc.

The above description is only a preferred embodiment of the present invention, and is not intended to limit the scope of the present invention.

Claims

1. The automatic business design management system is characterized by comprising a server and a client; the server comprises a server program of an automatic service design management system and a relational database, wherein the relational database stores services, information of each element of the services and interface attribute information required by service display, and the server program comprises a function of designing and processing an indefinite number table and view, indefinite number series, range and constrained database elements to which the full-automatic management services belong, a function of automatically managing the services through an entity class and a service interface attribute management function, so that a service worker can automatically complete the modeling or model maintenance of a back-end entity class and a database of a complex service through one-time design submission and then can operate and manage the services through an interface control without worrying about the binding and control management of a back-end complex data model and the integrity and consistency of complex service data in the database; the client comprises an automatic business design management system client program; a client program collects user service design information through a design tool and submits the user service design information to a server; the server program receives user service design information and carries out design processing; the server program provides data information or service processing results related to the service according to the service use requirements of the client; the client program displays a corresponding service use interface according to the service data and the interface information returned by the server program; the server displays the processing result responding to the client request or the running state of the server program on the client through a message return or push mechanism; the services can be multiplexed to form high complexity services; the interface control is a client program which reflects the use of the service elements of the complex service with indefinite number; the "indeterminate number" ranges from 1 to the maximum value that the database can support.

2. The automated business design management system of claim 1, wherein the design information submitted by the design tool is indispensable information set according to business requirements, and comprises columns, ranges, constraints of a two-dimensional table for modeling each element transformation of the business by a complete database, and interface attribute information for representing the appearance of the business columns of the business element transformation on the user interface of the client.

3. The automated business design management system of claim 1, wherein the design process models the design information per database of the business, generates tables or views in the database using DDL statements, and generates corresponding entity classes that enable the entity classes to run in a runtime environment, methods including but not limited to "dynamic compilation"; the design process can generate a design document for a user to store and download, the design document provides reversible operation, can generate a database business model, and can also generate the document from the database business model, the design process can also store design information in a database table to form a redundant table independent of the design document, and can also adopt a marking mode as a redundant record when generating an entity class, and the design information before the design tool is submitted can be restored according to the modes for maintenance and modification.

4. The automated business design management system of claim 1, wherein tables or views can be multiplexed in a manner including, but not limited to: multiplexing in a table constraint mode, setting an external key constraint relation through a certain column of a currently designed table and a certain column of a multiplexed table for multiplexing, reflecting the logic relation among services, providing a setting step by a design tool, wherein the multiplexed table can be a main key table or an external key table; multiplexing in a view generating mode, taking a multiplexed table as a driving table, acquiring data of other tables by utilizing a foreign key constraint relation set by a column of the table and the other tables, belonging to typical multi-table connection, generating a view in a database, reflecting all relevant business logics taking a business represented by the multiplexed table as a viewport, and providing a setting step by a design tool; multiplexing by using an sql statement mode of multi-table connection, taking the multiplexed table as a driving table, acquiring data of other tables by using a foreign key constraint relation set by a column of the table and other tables, belonging to typical multi-table connection, but not generating a view in a database, embodying all related business logics taking business represented by the multiplexed table as a viewport, providing a setting step by a design tool, dynamically generating a corresponding sql statement of multi-table connection to run by using design redundancy information generated in design processing during running, and achieving the effect of view identity.

5. The automated business design management system of claim 1, wherein the user interface comprises 1 or more interface controls, the interface controls belong to a client program and are differentiated according to functions, including but not limited to search controls, function button area controls, form controls, data display controls, new form controls, form modification controls, and data export controls, after the interface controls acquire interface attribute information, the appearance of the columns is determined one by one according to the design order of the business columns, including but not limited to determining which basic controls for loading business column data are used, shape size and color, the basic controls include but not limited to single-row input controls, multi-row input controls, single-selection drop-down controls, multi-selection drop-down controls, single-selection tree controls, multi-selection tree controls, date and time controls, upload picture controls, and upload attachment controls.

6. The automated business design management system of claim 1, wherein the interface control has an interface or both interfaces for acquiring relevant business data and its own interface attribute from the server according to the business usage requirement, or an interface for completing the business related function by inputting the business data and submitting it to the server, wherein the interface for acquiring relevant business data from the server is interfaced with the business query function provided by the server program, acquiring business form data, and displaying it according to the agreed form by the interface control, the interface for acquiring its own interface attribute interface from the server is interfaced with the business function for acquiring business related interface attribute information provided by the server program, acquiring interface attribute information, and generating a corresponding interface according to the agreed form by the interface control, and the interface for completing the business related function by inputting the business data and submitting it to the server is interfaced with the processing function provided by the server program including but not limited to business addition, deletion, modification, export statistics, the server program carries out corresponding processing on the specific business table record determined by the information transmitted by the interface through the entity class, and the function is realized.

7. The automated business design management system of claim 1, wherein the service management functions provided by the server-side program provide basic add-drop census and data export functions by operating persistent entity class objects corresponding to the business, and further comprising functions for mathematically processing, statistically or logically determining individual or combined columns based on the add-drop census functions.

8. The automated business design management system of claim 1, wherein the business interface attribute management function has a list of all interface attributes of an existing interface control, the list is categorized according to the function of the control and the data type of the column range of the described business table, 1 business column has a corresponding relationship with one or more attributes on the list, and the business function acquires all interface attributes of all business columns belonging to the business of the control according to the classification of the calling control function and transmits the interface attributes to the interface control called by the client in a convention form.