CN111241089B - ERP system secondary development method, system, device and readable storage medium - Google Patents
ERP system secondary development method, system, device and readable storage medium Download PDFInfo
- Publication number
- CN111241089B CN111241089B CN201910965323.7A CN201910965323A CN111241089B CN 111241089 B CN111241089 B CN 111241089B CN 201910965323 A CN201910965323 A CN 201910965323A CN 111241089 B CN111241089 B CN 111241089B
- Authority
- CN
- China
- Prior art keywords
- window
- designer
- user
- scheme
- standard field
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Computational Linguistics (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Stored Programmes (AREA)
Abstract
The invention discloses a scheme design modularized ERP system secondary development method and a scheme design modularized ERP system secondary development system.A field designer window, a table designer window, a data window designer window, a scheme designer window and a window designer window are provided on an ERP system constructed on a client, and five dimensions are sequentially progressively designed autonomously, so that the autonomous design of a page scheme and a window control can be realized, the secondary development threshold is reduced, and anyone can perform secondary development based on a system platform; while allowing for the generation of new controls or programs by autonomously writing code through SQL.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a scheme design modularized ERP system secondary development method, a scheme design modularized ERP system secondary development system, a computer device and a computer readable storage medium.
Background
The ERP system is a short term for EntERPrise Resource Planning (EntERPrise Resource Planning), and refers to a management platform which is established on the basis of information technology, integrates information technology and advanced management ideas, and provides decision means for EntERPrise employees and decision layers by using a systematized management idea. The system is a new generation of integrated management information system developed from a material demand plan, and the core idea of the system is supply chain management. The current ERP system has the functions of production resource planning, manufacturing, finance, selling, purchasing and the like, and also has a quality management system, a laboratory management system, a business process management system, a product data management system, an inventory, distribution and transportation management system, a human resource management system and a regular reporting system.
However, whether the ERP system can be successfully implemented and effectively applied depends on a key factor, namely, the customization and secondary development of the ERP system. Any ERP software, whether domestic or imported, is more or less customized and sometimes subject to secondary development.
In the prior art, three important secondary development projects, namely, a data input Form (Entry Form), a Query (Query/inquiry) and a Report (Report), are provided. The existing ERP system or other enterprise management systems supporting customer self-definition generally support users to acquire data and define processes, and can automatically complete definition and management of a data table to realize new business process definition; however, the method can only define the data table and the approval process, and does not support the self-definition of more page design contents such as the whole system page form, the page control and the like.
Disclosure of Invention
In view of the above technical problems, a primary object of the present invention is to provide a completely open and self-designed secondary development method for a modular ERP system with a solution design, a computer device and a computer-readable storage medium.
In order to achieve the purpose, the invention provides a scheme design modularized ERP system secondary development method, wherein a field designer window, a table designer window, a data window designer window, a scheme designer window and a window designer window are provided on an ERP system of a framework on a client, wherein a preset standard field name is provided on the field designer window, a common control is arranged in the scheme designer window, and the control comprises a logic realization module, an interface design module and a functional service logic control module; the method comprises the following steps:
step S1, receiving the standard field name selected by a user in the field designer window, and using the selected standard field name for the pull-down selection of the column in the table designer window and the generation of the column information in the data window designer window, wherein the standard field name is used for positioning the data mapped by the standard field name in a database of a server;
s2, generating a table building SQL statement for managing and creating the table according to a table name input by a user in the table designer window and a row attribute and a column attribute of the input table and according to an SQL statement written by the user or a called standard SQL statement, wherein the row attribute and the column attribute comprise contents and fields displayed by the row and the column, and the fields are selected from the selected standard field names;
s3, according to the table building SQL sentence, matching the selected standard field name on the field designer window, and automatically generating a data display window for the scheme designer window to call;
s4, executing the table building SQL sentence on a database of a server side, displaying data in the table of the data display window, and storing the scheme design of the user according to the control called by the user on the scheme designer window;
and S5, generating a new functional window according to one or more schemes and layout settings stored in the scheme designer window selected by the user in the window designer.
Further, the method also comprises the following steps:
and reading the standard field names on the database of the server side through an open data interface, and providing the standard field names on the field designer form.
Further, step S1 includes a step of entering, on the field designer form, a width parameter, a display format parameter, and a drop-down parameter of a row or a column in the table of the data corresponding to the standard field name.
Further, step S2 includes a step of entering format parameters of cells of the table on the table designer window.
Further, the step S3 further includes the steps of:
and when the standard field name selected by the user is not received in the field designer, reading the standard field name on the database of the server end, and providing the standard field name on the automatically generated data display window for the scheme designer form to call.
Further, the step S4 further includes a step of embedding the button, the graphic or the text box in the data display window according to the button, the graphic or the text box which needs to be added to the data display window and is set by the user on the project composer.
The invention also provides an ERP system, which is configured on a client and comprises a secondary development unit, wherein the secondary development unit comprises:
a field designer module, wherein a preset standard field name is provided on a field designer window and used for receiving the standard field name selected by a user, and the selected standard field name is used for pull-down selection of a column in the table designer window and generation of column information in the data window designer window and is used for positioning data mapped by the standard field name in a database of a server;
a table designer module, configured to generate a table building SQL statement for managing and creating the table according to a table name entered by a user and a row attribute and a column attribute of the entered table and according to a SQL statement written by the user or a standard SQL statement called by the user, so as to generate a database storage object, where the row attribute and the column attribute include displayed contents and fields of the row and the column, and the fields are selected from the selected standard field names;
the data window designer module is used for matching the selected standard field name on the field designer window according to the table building SQL sentence and automatically generating a data display window for the scheme designer module to call;
the scheme designer module is internally provided with a common control, the control comprises a logic implementation module, an interface design module and a functional service logic control module, the scheme designer window is used for executing the table building SQL statement on a database at a server end, displaying data in the table of the data display window, and storing the scheme design of a user according to the control called by the user on the scheme designer window; and
and the window designer window is used for generating a new function window according to one or more schemes and layout settings stored in the scheme designer module selected by the user.
Further, the secondary development unit of the ERP system further includes a database management module, which is used for reading the standard field names on the database of the server side and providing the standard field names on the field designer form.
The invention also provides computer equipment which comprises a memory, a processor and a computer program which is stored in the memory and can run on the processor, wherein the processor executes the computer program to realize the steps of the ERP system secondary development method.
The invention also provides a computer readable storage medium, which stores a computer program, and the computer program realizes the steps of the ERP system secondary development method when being executed by a processor.
According to the method, a field designer window, a table designer window, a data window designer window, a scheme designer window and a window designer window are provided on an ERP system of a framework on a client, wherein a preset standard field name is provided on the field designer window, a common control is arranged in the scheme designer window, and the control comprises a logic implementation module, an interface design module and a functional service logic control module; then, through step S1, receiving the standard field name selected by the user in the field designer window, and using the selected standard field name for the pull-down selection of the column in the table designer window and the generation of the column information in the data window designer window, where the standard field name is used to locate the data mapped by the standard field name in the database of the server; s2, generating a table building SQL statement for managing and creating the table according to a table name input by a user in the table designer window and a row attribute and a column attribute of the input table and according to an SQL statement written by the user or a called standard SQL statement, wherein the row attribute and the column attribute comprise contents and fields displayed by the row and the column, and the fields are selected from the selected standard field names; s3, according to the table building SQL sentence, matching the selected standard field name on the field designer window, and automatically generating a data display window for the scheme designer window to call; s4, executing the table building SQL sentence on a database of a server side, displaying data in the table of the data display window, and storing the scheme design of the user according to the control called by the user on the scheme designer window; and S5, generating a new functional window according to one or more schemes and layout settings stored in the scheme designer window selected by the user in the window designer. The secondary development function is sequentially and progressively designed by five dimensions through a field designer, a table designer, a data window designer, a scheme designer and a window designer, so that the independent design of a page scheme and a window control can be realized, the secondary development threshold is reduced, and anyone can perform secondary development based on a system platform; while allowing for the generation of new controls or programs by autonomously writing code through SQL.
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the structures shown in the drawings without creative efforts.
FIG. 1 is a diagram illustrating an application scenario of secure data transmission according to an embodiment of the present invention;
FIG. 2 is a flow chart illustrating a secure data transmission according to a first embodiment of the present invention;
FIG. 3 is a block diagram of an information verification apparatus according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a computer device in an embodiment of the present invention.
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The following description will first describe, by way of example, a network architecture to which the solution of the embodiments of the present application will be applied, with reference to the accompanying drawings.
As shown in fig. 1, the ERP system provided by the present application may be applied to an application environment shown in fig. 1. Wherein the client 10 communicates with the background server 20 over a network. Wherein different users can interact data with the background server 20 through software or web pages installed on the respective clients 10. The client 10 may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, and the background server 20 may be implemented by an independent server or a server cluster formed by a plurality of servers.
Further, in this embodiment, the client 10 and the server 20 are a server and a client of an ERP system, and the ERP system can be customized by a user in secondary development of the client.
As shown in fig. 2, in the secondary development method for an ERP system provided in the first embodiment of the present invention, a field designer window, a table designer window, a data window designer window, a scheme designer window, and a window designer window are provided on an ERP system configured on a client, where a preset standard field name is provided on the field designer window, and a common control is built in the scheme designer window, and the control includes a logic implementation module, an interface design module, and a functional service logic control module.
The ERP system secondary development method comprises the following steps:
step S21, receiving the standard field name selected by the user in the field designer window, and using the selected standard field name for the pull-down selection of the column in the table designer window and the generation of the column information in the data window designer window, where the standard field name is used to locate the data mapped by the standard field name in the database of the server.
A standardized field type set is presented on a field designer of the ERP system, a standard field name is defined, and the method can be used for drop-down selection of a field column of a table field designer and generation of information of a data window designer column. Specifically, after receiving the standard field name selected by the user in the field designer window, the selected standard field name is used for the pull-down selection of the column in the table designer window and the generation of the column information in the data window designer window, and the standard field name is used for positioning the data mapped by the standard field name in the database of the server.
Further, in an embodiment, step S1 further includes a step of entering, on the field designer form, a width parameter of a row or a column in the table, a display format parameter, and a drop-down parameter of the row or the column of the data corresponding to the standard field name. In a field designer, some common attributes of a field may be set for use by other designers.
Step S22, generating a table building SQL statement for managing and creating the table according to the table name input by the user in the table designer window and the row attribute and the column attribute of the input table and the SQL statement written by the user or the called standard SQL statement for generating a database storage object, wherein the row attribute and the column attribute comprise the displayed content and fields of the row and the column, and the fields are selected from the selected standard field name.
The table designer is used for freely selecting field columns according to the content of the field designer; and generating a database object creating statement according to the table name and the field list attribute, and generating a database storage object.
Specifically, according to a table name entered by a user in the table designer window and row attributes and column attributes of the entered table, a table building SQL statement for managing and creating the table is generated according to an SQL statement written by the user or a called standard SQL statement, so as to generate a database storage object. The called standard SQL statement can be read to a server through a network and a data interface; and the new SQL sentence is used for reading the label of the data corresponding to the field after the field is edited and the inquiry of the field is requested to the server background, storing the new SQL after the verification is finished, and directly displaying the new field and the label when being called next time.
Wherein the row attribute and the column attribute comprise contents and fields displayed by the row and the column, and the fields are selected from the selected standard field names.
Further, in an embodiment, said step S2 further includes a step of entering format parameters of cells of said table on said table designer window.
And step S23, according to the table building SQL sentence, matching the selected standard field name on the field designer window, and automatically generating a data display window for the scheme designer window to call.
Further, in an embodiment, when the standard field name selected by the user is not received in the field designer, the standard field name on the database of the server is read and provided on the automatically generated data display window for the scheme designer form to call.
And step S24, executing the table building SQL sentence on a database of the server side, displaying the data in the table of the data display window, and storing the scheme design of the user according to the control called by the user on the scheme designer window.
After the data display window is made, dragging a control built in the scheme designer, executing the table building SQL statement on a database at the server end, displaying data in the table of the data display window, and realizing service logic control and data flow control. And the layout and the function are quickly realized by the built-in common control type.
Further, in an embodiment, the button, the graphic or the text box is embedded in the data display window according to the button, the graphic or the text box which needs to be added in the data display window and is set by the user on the scheme designer.
And step S25, generating a new functional window according to one or more schemes and layout settings stored in the scheme designer window selected by the user in the window designer.
In this way, through the field designer, the table designer, the data window designer, the scheme designer and the window designer and the sequentially progressive independent design of five dimensions, the independent design of the page scheme and the window control can be realized, the secondary development threshold is reduced, and anyone can perform secondary development based on a system platform; while allowing for the generation of new controls or programs by autonomously writing code through SQL. And reading the standard field names on the database of the server side through an open data interface, and providing the standard field names on the field designer form.
Further, in an embodiment, the method further comprises the steps of:
and reading the standard field names on the database of the server side through an open data interface, and providing the standard field names on the field designer form.
Referring to fig. 3, the present invention further provides an ERP system 40, which is configured on the client and includes a secondary development unit. It can be understood that the ERP system includes other functional units to implement the conventional functional flow of the ERP system, which is not described herein again.
The secondary development unit includes:
a field designer module 401, where a preset standard field name is provided on the field designer window, and is used to receive the standard field name selected by a user, and use the selected standard field name for pull-down selection of a column in the table designer window and generation of column information in the data window designer window, where the standard field name is used to locate data mapped by the standard field name in a database of a server;
a table designer module 402, configured to generate a table building SQL statement for managing and creating the table according to a table name entered by a user and a row attribute and a column attribute of the entered table, according to a SQL statement written by the user or a standard SQL statement called by the user, so as to generate a database storage object, where the row attribute and the column attribute include contents and fields displayed by the row and the column, and the fields are selected from the selected standard field names;
a data window designer module 403, configured to match the selected standard field name on the field designer window according to the table building SQL statement, and automatically generate a data display window for the scheme designer module to call;
the project designer module 404 is internally provided with common controls, the controls include a logic implementation module, an interface design module and a functional service logic control module, the project designer window is used for executing the table building SQL statement on a database at a server end, displaying data in the table of the data display window, and storing project design of a user according to the controls called by the user on the project designer window; and
the window designer module 405 is configured to generate a new function window according to one or more schemes and layout settings stored in the scheme designer module selected by the user.
The field designer module 401 of the ERP system presents a standardized field type set, defines a standard field name, and can be used for drop-down selection of a field column of a table field designer and generation of information of a data window designer column. Specifically, after receiving the standard field name selected by the user in the field designer window, the selected standard field name is used for the pull-down selection of the column in the table designer window and the generation of the column information in the data window designer window, and the standard field name is used for positioning the data mapped by the standard field name in the database of the server.
In a preferred embodiment, field designer module 401 is further configured to enter, on said field designer form, a width parameter of a row or column in said table, a display format parameter, and a drop-down parameter of said row or column of said data corresponding to said standard field name. In a field designer, some common attributes of a field may be set for use by other designers.
Further, in one embodiment, table designer module 402 is also configured to enter format parameters for cells of the table in the table designer window.
Further, in an embodiment, data window designer module 403 is further configured to, when the standard field name selected by the user is not received in the field designer, read the standard field name on the database of the server side, and provide the standard field name on the automatically generated data display window for the scheme designer window to call.
Further, in an embodiment, the project designer module 404 is further configured to embed the button, the graphic or the text box in the data presentation window according to the button, the graphic or the text box which needs to be added to the data presentation window and is set by the user on the project designer.
In summary, in the specific embodiment of the present invention, a field designer window, a table designer window, a data window designer window, a scheme designer window and a window designer window are provided on an ERP system configured on a client, where a preset standard field name is provided on the field designer window, a common control is built in the scheme designer window, and the control includes a logic implementation module, an interface design module and a functional service logic control module; then, by receiving the standard field name selected by a user in the field designer window, using the selected standard field name for the pull-down selection of the column in the table designer window and the generation of the column information in the data window designer window, wherein the standard field name is used for positioning the data mapped by the standard field name in a database of a server; generating a table building SQL sentence for managing and creating the table according to a table name input by a user in the table designer window and a row attribute and a column attribute of the input table and according to an SQL sentence written by the user or a called standard SQL sentence for generating a database storage object, wherein the row attribute and the column attribute comprise displayed contents and fields of the row and the column, and the fields are selected from the selected standard field names; matching the selected standard field name on the field designer window according to the table building SQL sentence, and automatically generating a data display window for the scheme designer window to call; executing the table building SQL sentence on a database of a server side, displaying data in the table of the data display window, and storing the scheme design of the user according to the control called by the user on the scheme designer window; and generating a new functional window according to one or more schemes and layout settings stored in the scheme designer window selected by the user in the window designer. The secondary development function is sequentially and progressively designed by five dimensions through a field designer, a table designer, a data window designer, a scheme designer and a window designer, so that the independent design of a page scheme and a window control can be realized, the secondary development threshold is reduced, and anyone can perform secondary development based on a system platform; while allowing for the generation of new controls or programs by autonomously writing code through SQL.
In addition, as shown in fig. 4, the embodiment of the present invention also provides a computer apparatus, which may be implemented in various forms. For example, the computer devices described in the present invention may include mobile terminals such as mobile phones, tablet computers, notebook computers, palmtop computers, personal Digital Assistants (PDAs), wearable devices, and mobile or stationary terminals such as TVs, desktop computers, and the like.
The computer device may include: display unit 77, user input unit 76, interface unit 73, memory 71, processor 72, and power supply 74. Those skilled in the art will appreciate that the configuration shown in FIG. 4 does not constitute a limitation of computer devices, which may include more or fewer components than those shown, or some components may be combined, or a different arrangement of components; for example, in the example shown in fig. 4, the computer device further includes the communication unit 75, and in addition, the computer device may further include an audio output unit, the sensor 105, and the like.
The memory 71 may be used to store software programs as well as various data. Further, the memory 71 may include high speed random access memory, and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other volatile solid state storage device.
The processor 72 is a control center of the computer device 7, connects various parts of the entire computer device by various interfaces and lines, and performs various functions of the computer device and processes data by running or executing software programs and/or modules stored in the memory 71 and calling data stored in the memory 71, thereby monitoring the computer device as a whole. Processor 72 may include one or more processing units; preferably, the processor 72 may integrate an application processor, which primarily handles operating systems, user interfaces, applications, etc., and a modem processor, which primarily handles wireless communications. It will be appreciated that the modem processor described above may not be integrated into the processor 72.
In this embodiment, the computer device includes a computer program stored in the memory 71 and executable on the processor 72, and the processor 72 executes the computer program to implement the steps of the ERP system secondary development method in any of the above embodiments.
It should be noted that, since the processor 72 of the computer device executes the computer program to implement the above-mentioned secondary development method of the ERP system, all embodiments of the above-mentioned method are applicable to the computer device and can achieve the same or similar beneficial effects, and no further description is given here.
In addition, the embodiment of the present invention further provides a computer-readable storage medium, where a computer program is stored, and when the computer program is executed by a processor, the computer program implements the steps of the above-mentioned ERP system secondary development method.
Illustratively, the computer program of the computer-readable storage medium comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, and the like. The computer readable medium may include: any entity or device capable of carrying computer program code, recording medium, U.S. disk, removable hard disk, magnetic disk, optical disk, computer Memory, read-Only Memory (ROM), random Access Memory (RAM), electrical carrier wave signals, telecommunications signals, software distribution media, and the like.
That is, when the computer program of the computer-readable storage medium is executed by the processor, the steps of the ERP system secondary development method are implemented, so that the information uploaded by the user can be more accurately judged.
It should be noted that, because the computer program of the computer readable storage medium is executed by the processor to implement the steps of the ERP system secondary development method, all the embodiments of the ERP system secondary development method are applicable to the computer readable storage medium, and can achieve the same or similar beneficial effects.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. A secondary development method of an ERP system is characterized in that a field designer window, a table designer window, a data window designer window, a scheme designer window and a window designer window are provided on the ERP system of a framework on a client, wherein a preset standard field name is provided on the field designer window, a common control is arranged in the scheme designer window, and the control comprises a logic realization module, an interface design module and a functional service logic control module; the method comprises the following steps:
step S1, receiving the standard field name selected by a user in the field designer window, and using the selected standard field name for pull-down selection of a column in the table designer window and generation of column information in the data window designer window, wherein the standard field name is used for positioning data mapped by the standard field name in a database of a server;
s2, generating a table building SQL statement for managing and creating the table according to a table name input by a user in the table designer window and a row attribute and a column attribute of the input table and according to an SQL statement written by the user or a called standard SQL statement, wherein the row attribute and the column attribute comprise contents and fields displayed by the row and the column, and the fields are selected from the selected standard field names;
s3, according to the table building SQL sentence, matching the selected standard field name on the field designer window, and automatically generating a data display window for the scheme designer window to call;
s4, executing the table building SQL sentence on a database of a server side, displaying data in the table of the data display window, and storing the scheme design of the user according to the control called by the user on the scheme designer window;
and S5, generating a new functional window according to one or more schemes and layout settings stored in the scheme designer window selected by the user in the window designer.
2. The ERP system secondary development method according to claim 1, further comprising the steps of:
and reading the standard field names on the database of the server side through an open data interface, and providing the standard field names on the field designer form.
3. The ERP system secondary development method according to claim 1, wherein the step S1 further includes a step of entering, on the field designer form, a width parameter of a row or a column in the table, a display format parameter, and a drop-down parameter of the row or the column of the data corresponding to the standard field name.
4. The ERP system secondary development method according to claim 1, wherein the step S2 further comprises a step of entering format parameters of cells of the table on the table designer window.
5. The ERP system secondary development method according to claim 1, wherein in the step S3, further comprising the steps of:
and when the standard field name selected by the user is not received in the field designer, reading the standard field name on the database of the server end, and providing the standard field name on the automatically generated data display window for the scheme designer form to call.
6. The ERP system secondary development method according to claim 1, wherein the step S4 further comprises a step of embedding a button, a graphic or a text box in the data display window according to the button, the graphic or the text box which needs to be added in the data display window and is set by a user on the project designer.
7. An ERP system, wherein the ERP system is configured on a client and comprises a secondary development unit, wherein the secondary development unit comprises:
a field designer module, wherein a preset standard field name is provided on a field designer window and used for receiving the standard field name selected by a user, and the selected standard field name is used for pull-down selection of a column in the table designer window and generation of column information in the data window designer window and is used for positioning data mapped by the standard field name in a database of a server;
the table designer module is used for generating a table building SQL statement for managing and creating the table according to a table name input by a user and a row attribute and a column attribute of the input table and according to an SQL statement written by the user or a called standard SQL statement so as to generate a database storage object, wherein the row attribute and the column attribute comprise displayed contents and fields of the row and the column, and the fields are selected from the selected standard field names;
the data window designer module is used for matching the selected standard field name on the field designer window according to the table building SQL sentence and automatically generating a data display window for the scheme designer module to call;
the scheme designer module is internally provided with a common control, the control comprises a logic implementation module, an interface design module and a functional service logic control module, the scheme designer window is used for executing the table building SQL statement on a database at a server end, displaying data in the table of the data display window, and storing the scheme design of a user according to the control called by the user on the scheme designer window; and
and the window designer window is used for generating a new function window according to one or more schemes and layout settings stored in the scheme designer module selected by a user.
8. The ERP system according to claim 7, wherein the secondary development unit of the ERP system further includes a database management module for reading the standard field names on the database of the server side and providing them on the field designer window.
9. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor when executing the computer program implements the steps of the ERP system secondary development method of any one of claims 1 to 7.
10. A computer-readable storage medium storing a computer program, wherein the computer program, when executed by a processor, performs the steps of the ERP system secondary development method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910965323.7A CN111241089B (en) | 2019-10-11 | 2019-10-11 | ERP system secondary development method, system, device and readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910965323.7A CN111241089B (en) | 2019-10-11 | 2019-10-11 | ERP system secondary development method, system, device and readable storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111241089A CN111241089A (en) | 2020-06-05 |
| CN111241089B true CN111241089B (en) | 2023-03-24 |
Family
ID=70865473
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910965323.7A Active CN111241089B (en) | 2019-10-11 | 2019-10-11 | ERP system secondary development method, system, device and readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111241089B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2001037170A2 (en) * | 1999-11-19 | 2001-05-25 | Science Management Corporation | Forms creation method and e-commerce method |
| CN104123138A (en) * | 2014-07-25 | 2014-10-29 | 诺伊曼(福建)信息科技有限公司 | Rapid building method for ERP system |
| CN104715032A (en) * | 2015-03-12 | 2015-06-17 | 福建工程学院 | Mapping system and method of Chinese and English table name and field name of report system |
| CN105447122A (en) * | 2015-11-16 | 2016-03-30 | 中国人民解放军理工大学 | Implementation method for autonomously creating file system based on multi-table association |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150051929A1 (en) * | 2013-08-19 | 2015-02-19 | Microsoft Corporation | Ad hoc reporting with smart lists |
-
2019
- 2019-10-11 CN CN201910965323.7A patent/CN111241089B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2001037170A2 (en) * | 1999-11-19 | 2001-05-25 | Science Management Corporation | Forms creation method and e-commerce method |
| CN104123138A (en) * | 2014-07-25 | 2014-10-29 | 诺伊曼(福建)信息科技有限公司 | Rapid building method for ERP system |
| CN104715032A (en) * | 2015-03-12 | 2015-06-17 | 福建工程学院 | Mapping system and method of Chinese and English table name and field name of report system |
| CN105447122A (en) * | 2015-11-16 | 2016-03-30 | 中国人民解放军理工大学 | Implementation method for autonomously creating file system based on multi-table association |
Non-Patent Citations (2)
| Title |
|---|
| DCERP系统的个性设计;邹金兰等;《机电工程技术》;20060628(第06期);123-126页 * |
| 基于.Net的代码生成工具的设计与实现;金雪云等;《计算机工程与应用》;20050901(第21期);28-33页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111241089A (en) | 2020-06-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Joss et al. | The smart city as global discourse: Storylines and critical junctures across 27 cities | |
| US8849854B2 (en) | Method and system for providing detailed information in an interactive manner in a short message service (SMS) environment | |
| CN111126019B (en) | Report generation method and device based on mode customization and electronic equipment | |
| CN107861933A (en) | The method and apparatus for generating O＆M form | |
| US20170010869A1 (en) | Multistage customizing of web-based application in a browser independent of platform and operating system | |
| CN102880683A (en) | Automatic network generation system for feasibility study report and generation method thereof | |
| CN111897890A (en) | Financial business processing method and device | |
| KR102547033B1 (en) | Method for providing information in the way user selected using keyword recognition function | |
| CN111241089B (en) | ERP system secondary development method, system, device and readable storage medium | |
| CN104699477A (en) | Near field communication based data transfer | |
| CN109376148B (en) | Data processing method and device for slow change dimension table and electronic equipment | |
| CN114968917A (en) | Method and device for rapidly importing file data | |
| CN114201157A (en) | Method and system for customizing target service module by low code | |
| CN114239525A (en) | Contract template editing method and device, computer equipment and storage medium | |
| CN112395366A (en) | Data processing and creating method and device of distributed database and electronic equipment | |
| CN106716403A (en) | Automated generation of web site entry pages | |
| CN100498765C (en) | Method and device for making electric newspaper printing plate | |
| CN111930690A (en) | File generation method and device | |
| CN113326680A (en) | Method and device for generating table | |
| Anido-Rifón et al. | Recommender systems | |
| CN113704593B (en) | Operation data processing method and related device | |
| US20240078728A1 (en) | Infrastructure for retargeting dashboard content as interactive data snapshots | |
| CN116415914A (en) | Service data processing method, device, computer equipment and storage medium | |
| CN117370558A (en) | Data integration method, device, equipment and storage medium thereof | |
| CN118051206A (en) | Intelligent construction method and device for enterprise application system software products |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |