CN111124385A - Automatic generation method and system of power supply design software based on database - Google Patents
Automatic generation method and system of power supply design software based on database Download PDFInfo
- Publication number
- CN111124385A CN111124385A CN201911214250.4A CN201911214250A CN111124385A CN 111124385 A CN111124385 A CN 111124385A CN 201911214250 A CN201911214250 A CN 201911214250A CN 111124385 A CN111124385 A CN 111124385A
- Authority
- CN
- China
- Prior art keywords
- control
- database
- data table
- information
- calculation
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/33—Intelligent editors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02E—REDUCTION OF GREENHOUSE GAS [GHG] EMISSIONS, RELATED TO ENERGY GENERATION, TRANSMISSION OR DISTRIBUTION
- Y02E60/00—Enabling technologies; Technologies with a potential or indirect contribution to GHG emissions mitigation
Abstract
The invention provides a database-based automatic generation method and a database-based automatic generation system for power supply design software, wherein the automatic generation method for the power supply design software comprises the following steps of: establishing a data table, wherein the data table contains description information of software pages and control composition information; describing the calculation information in a data table; establishing a dynamic link library, and calculating an output parameter set by an input parameter set; building a software general framework and generating an executable program; the software general frame function comprises the contents of reading data table information, generating and automatically laying out interface controls and calling a dynamic link library; putting the data table and the dynamic link library to the path of the executable program; the executable program responds to the calculation operation of the user to complete the design of the power supply topology. By adopting the technical scheme of the invention, power supply design software with different topologies can be generated only by filling in the data form content and compiling the dynamic link library, thereby saving the time of developers and improving the efficiency.
Description
Technical Field
The invention belongs to the technical field of software development, relates to an automatic generation method of special software, and particularly relates to an automatic generation method and system of power supply design software based on a database.
Background
The development steps of the power supply design software generally comprise the steps of manually creating a page, laying out corresponding controls on the page, and writing codes to complete functions of topology calculation, control display and the like. Because power supply design software has various topologies and often needs to be dynamically expanded, a manually created development mode is complicated and inefficient, and in addition, a calculation book and a simulation schematic diagram file cannot be automatically generated.
In the prior art, for Web application, a method for dynamically generating a form page exists at present, but the method is not suitable for special software such as power supply design software, cannot design power supply topology according to constraint conditions and a calculation formula, and cannot automatically generate a word calculation book and a simulation principle graph file.
Disclosure of Invention
Aiming at the technical problems, the invention discloses a method and a system for automatically generating power supply design software based on a database, which can automatically generate interface layout information, can interact with a control to read control data and display the control information, greatly save the time of developers and solve the problem of low efficiency of manual creation of power supply design software in the prior art.
In contrast, the technical scheme adopted by the invention is as follows:
a method for automatically generating power supply design software based on a database comprises the following steps:
step S1, establishing a data table or a database, wherein the data table or the database comprises description information formed by software pages and controls;
step S2, describing calculation information in a data table or a database; the calculation information comprises the file name of a dynamic link library corresponding to the control used for calculation, the name of a function in the dynamic link library, and input parameter set information and output parameter set information of each function;
step S3, establishing a dynamic link library, and calculating an output parameter set from an input parameter set according to a designed calculation formula in a function of the dynamic link library;
the file name and function name of the dynamic link library correspond to those in the data table or database in step S2;
the function parameters in the dynamic link library at least comprise two pointer variables, wherein one pointer variable points to the input parameter set in the step 2, and the other pointer variable points to the output parameter set in the step 2;
step S4, building a general software framework and generating an executable program;
the software general frame function comprises the contents of reading data table or database information, generating and automatically laying out interface controls and calling a dynamic link library;
in step S5, the data table or the database and the dynamic link library are placed in the path of the executable program.
And step S6, the executable program responds to the calculation operation of the user, reads the input parameter data in the input parameter set from the interface according to the calculation information in the data table or the database, dynamically calls the dynamic link library and the used dynamic link library function to obtain the output parameter, namely the calculation result, and displays the output parameter on the corresponding control on the interface according to the calculation information in the data table or the database to complete the design of the power supply topology.
The data table may be an excel table, and the database may be a conventional database such as Access.
As a further improvement of the present invention, in step S1, the description information formed by the software page and the control includes interface information of each page; further, each type of control includes a variety of interface controls.
As a further improvement of the present invention, in step S1, the page and control composition information includes "control number", "parameter name", "unit", "control type", "default value" of each page; the control type comprises input, output, static text, page name, first-stage grouping frame, second-stage grouping frame, xy curve and baud graph.
Further, the "input" control includes information such as an input parameter name (static text), an input edit box (edit box), and an input unit (static text).
Further, in step S2, the input parameter set information and the output parameter set information for each function are indicated by an english parenthesis, a "control number" of the input/output parameter, and a comma and a semicolon, after the function name. I.e., "function name (input parameter set represented by control number; output parameter set represented by control number)". "(" after ";" before is a set of input parameters, ";" after ")" before is a set of output parameters. An input/output collection consists of input/output parameters represented by control numbers, separated by a "break" between the parameters.
As a further improvement of the present invention, in step S4, the functions of the software general framework include reading the page and control composition information of a certain topology in the data table or database, dynamically generating the controls of various "control types" in step S1 according to the hierarchical relationship of all the controls related to the topology in the data table or database, and performing automatic layout according to the hierarchical relationship to generate the user interface.
As a further improvement of the present invention, the hierarchical relationship comprises a first hierarchy, a second hierarchy, and a third hierarchy;
the first level is a page, a control with the control type as the page name is used as a dividing line to divide each page, and a certain page comprises the following ranges: starting from a certain "page name" control until the end of the next "page name" control or data is encountered;
the second level is a first-level grouping frame, and the range of a certain first-level grouping frame is as follows: starting from a control of a certain primary grouping frame until the control of the next primary grouping frame or the control of the next page name or the data is finished;
the third level is a two-level grouping frame, and a certain two-level grouping frame comprises the following ranges: starting from a control of a certain secondary grouping box until the control of the next secondary grouping box or the control of the next primary grouping box or the control of the next page name or the end of data is met.
Further, the automatic layout includes: the heights of the primary grouping frame control and the secondary grouping frame control are set according to the controls contained in the primary grouping frame control and the secondary grouping frame control, and the heights of other controls are constants; the software general framework realizes the automatic layout of the controls on the automatically generated power supply design software space according to the sequence and the hierarchical relation in the data table or the database, and adds scroll bars as required to accommodate all the controls.
Further, the generating the user interface includes generating an interface control ID, and the generation rules of the interface control ID are the same.
Further, the generation rule of the interface control ID is: ID base + control number 10+ column number.
Further, the generation rule of the interface control ID is: the ID base + number of control × 10+ column count, where the ID base is the initial value of the selected ID, is used to avoid collision with the system ID, and the "number of control × 10+ column count" is that 1 control in the data table or database may correspond to multiple controls in the interface, for example, an "input" parameter in the data table or database may correspond to multiple controls in the interface, such as "input parameter name", "input edit box", "parameter unit", and the like.
As a further improvement of the present invention, the automatic generation method of the database-based power supply design software comprises:
generating a calculation book template, and writing corresponding design parameters and design charts into corresponding positions of the calculation book by utilizing an OLE (on-line analytical tool) automation technology according to a design result of an executable program;
and/or generating a simulation principle graph file template file, analyzing the simulation principle graph file, and writing the design result of the executable program into the corresponding position of the simulation principle graph file according to the corresponding position of the analyzed parameter value in the simulation principle graph file template file.
Further, the simulation principle graph file template file comprises a Saber, simplex or Simulink simulation principle graph file template file.
The invention also discloses an automatic generation system of the power supply design software based on the database, which comprises the following steps:
the data table or the database comprises description information and calculation information which are formed by the software page and the control; the calculation information comprises the file name of a dynamic link library corresponding to the control used for calculation, the name of a function in the dynamic link library, and input parameter set information and output parameter set information of each function;
the file name and the function name of the dynamic link library correspond to those in the data table or the database; the function parameters in the dynamic link library at least comprise two pointer variables, wherein one pointer variable points to an input parameter set, and the other pointer variable points to the output parameter set;
the software general framework comprises the functions of reading information of a data table or a database, generating and automatically laying out interface controls and calling contents of a dynamic link library;
the executable program generation module responds to the calculation operation of a user, reads input parameter data in the input parameter set from the interface according to calculation information in a data table or a database, dynamically calls a dynamic link library and a used dynamic link library function to obtain an output parameter, namely a calculation result, and displays the output parameter, namely the calculation result, on a corresponding control on the interface according to the calculation information in the data table or the database;
the data table or the database and the dynamic link library are positioned on the path of the executable program.
Furthermore, the description information formed by the pages and the controls comprises various interface information of each page; each type of control includes a variety of interface controls.
Further, the page and control composition information includes a "control number", "parameter name", "unit", "control type", "default value" of each page; the control type comprises input, output, static text, page name, first-stage grouping frame, second-stage grouping frame, xy curve and baud graph.
Further, the input control comprises an input parameter name, an input edit box and input unit information;
furthermore, the input parameter set information and the output parameter set information of each function are located behind the function name and are represented by an English parenthesis, a control number of the input/output parameter, and a comma and a semicolon.
Further, the function of the software general framework includes reading page and control composition information of a certain topology in the data table or the database, dynamically generating various controls of the "control type" in step S1 according to the hierarchical relationship of all the controls related to the topology in the data table or the database, and automatically laying out according to the hierarchical relationship to generate the user interface.
Wherein the hierarchical relationship comprises a first hierarchy, a second hierarchy, and a third hierarchy;
the first level is a page, a control with the control type as the page name is used as a dividing line to divide each page, and a certain page comprises the following ranges: starting from a certain "page name" control until the end of the next "page name" control or data is encountered;
the second level is a first-level grouping frame, and the range of a certain first-level grouping frame is as follows: starting from a control of a certain primary grouping frame until the control of the next primary grouping frame or the control of the next page name or the data is finished;
the third level is a two-level grouping frame, and a certain two-level grouping frame comprises the following ranges: starting from a control of a certain secondary grouping frame until the control of the next secondary grouping frame, the control of the next primary grouping frame or the control of the next page name or data is met;
the automatic layout includes: the heights of the primary grouping frame control and the secondary grouping frame control are set according to the controls contained in the primary grouping frame control and the secondary grouping frame control, and the heights of other controls are constants; the software general framework realizes the automatic layout of the controls on the automatically generated power supply design software space according to the sequence and the hierarchical relation in the data table or the database, and adds scroll bars as required to accommodate all the controls.
As a further improvement of the present invention, the automatic generation system of the database-based power supply design software comprises:
the calculation book generation module is used for generating a calculation book template and writing corresponding design parameters and design charts into corresponding positions of the calculation book by utilizing an OLE (on-line analytical tool) automation technology according to a design result of the executable program;
and/or the simulation principle graph file generating module is used for generating a simulation principle graph file template file, analyzing the simulation principle graph file, and writing the design result of the executable program into the corresponding position of the simulation principle graph file according to the corresponding position of the analyzed parameter value in the simulation principle graph file template file.
Further, the simulation schematic diagram file comprises a Saber simulation schematic diagram file, a Simplis simulation schematic diagram file and a Simulink simulation schematic diagram file.
The present invention also discloses a computer-readable storage medium comprising a computer program which, when run on an electronic device, causes the electronic device to execute the method for automatic generation of database-based power supply design software as described above.
The invention also discloses a device which comprises a processor and a memory which are connected, and is characterized in that the processor is used for executing the computer program stored in the memory so as to execute the automatic generation method of the power supply design software based on the database.
Specifically, the method for automatically generating the power supply design software based on the data table or the database comprises the following steps:
And 2, describing the calculation information in a data table or a database. The calculation information refers to the name of the dynamic link library related to the control used for the related design calculation, the name of the function in the dynamic link library, and the input parameter set information and the output parameter set information used by each function. The problem that the number of input parameters and output parameters is uncertain during calculation is solved through the input parameter set and the output parameter set. After the input parameter set information and the output parameter set information of the function are located in the name of the function, the function is represented by English braces, control numbers of the input parameter and the output parameter, commas and semicolons. The specific meanings are as follows: "(" before "is a function name;", "" after ";" before is a set of input parameters, ";" after ")" is preceded by a set of output parameters, with "between" the input/output parameters, separate.
And 3, compiling a dynamic link library for calculation, and calculating an output parameter set from the input parameter set. (1) The file name and function name of the dynamic link library are consistent with those filled in the data table or database in step 2. (2) And (3) the function parameters in the dynamic link library are pointer variables and respectively point to the input parameter set and the output parameter set in the step (2). (3) In the dynamic link library function, a calculation function is realized according to a design calculation formula, and an output parameter is obtained by calculating an input parameter.
And 4, building a software general framework and generating an executable program. The generic framework implements the following functions:
(1) and reading page and control composition information of a certain topology in a data table or a database. And necessary controls are automatically supplemented as required.
(2) And (3) dynamically generating the controls of various control types in the step (1) according to the hierarchical relation of all the controls related to the topology in a data table or a database, and automatically laying out to generate a user interface.
a. And (4) hierarchical relation. The first level is a page, a control with the control type as the page name is used as a dividing line to divide each page, and a certain page comprises the following ranges: starting from a certain "page name" control until the end of the next "page name" control or data is encountered;
the second level is a first-level grouping frame, and the range of a certain first-level grouping frame is as follows: starting from a control of a certain primary grouping frame until the control of the next primary grouping frame or the control of the next page name or the data is finished;
the third level is a two-level grouping frame, and a certain two-level grouping frame comprises the following ranges: starting from a control of a certain secondary grouping box until the control of the next secondary grouping box or the control of the next primary grouping box or the control of the next page name or the end of data is met.
b. And (6) automatic layout. And laying out the controls according to the hierarchical relationship. The heights of the primary grouping frame control and the secondary grouping frame control are set according to the control contained in the primary grouping frame control and the heights of other controls are constants. The software general framework realizes the automatic layout of the controls in the software according to the sequence and the hierarchical relation in the data table or the database, and adds scroll bars as required to accommodate all the controls.
c. And generating an interface control ID. In order to facilitate automatic generation and data interaction of the interface control, unified regulation is carried out on the ID generation of the interface control. A row in a data table or database may correspond to multiple controls in the interface, so the rule for generating the control ID is: ID base + control number 10+ column number.
(3) Responding to the calculation operation of a user, reading input parameter data in an input parameter set from the interface according to calculation information in a data table or a database, dynamically calling a dynamic link library and a used dynamic link library function to obtain an output parameter, namely a calculation result, and displaying the output parameter, namely the calculation result, on a corresponding control on the interface according to the calculation information in the data table.
Step 5, putting the data table or the database and the dynamic link library into the specified path of the software (corresponding to the path of the executable program in step 4)
And 6, designing by the user by using the executable program generated in the step 4. Including calculations, graphical displays, etc.
And 7, after the design is finished, the software can automatically generate a word-format calculation book according to the design result. The software internal implementation process comprises the following steps: firstly, generating a calculation book template, and secondly, writing corresponding design parameters, design charts and the like into corresponding positions of the calculation book by utilizing an OLE (on-line analytical tool) automation technology according to a design result.
And 8, after the design is finished, the software can automatically generate Saber, Simplis and Simulink simulation principle graph files according to the design result. The realization process is as follows: firstly, generating template files of Saber, Simplis and Simulink simulation principle diagrams; secondly, the analysis of the simulation schematic diagram file is completed, and the corresponding position of the parameter value in the schematic diagram file can be analyzed; and converting the design result into a plaintext analysis again, finding a corresponding position according to the special symbol in the plaintext analysis, and writing the position into the corresponding position of the simulation schematic diagram file.
Compared with the prior art, the invention has the beneficial effects that:
by adopting the technical scheme of the invention, the universal software framework is built, the framework reads page and control component information from the data table or the database, interface layout information can be automatically generated, the framework can interact with the control to read control data and display the control information, the development difficulty of power supply design software is greatly reduced, and power supply design software with different topologies can be generated only by filling in data table contents and compiling a dynamic link library for calculation. The development time is short, and the efficiency is high; and the generated software interface is uniform and standard, and the expandability is strong. And simulation schematic diagrams such as computer books, Saber, Simplis, Simulink and the like can be automatically generated according to needs, so that the time and the energy of developers are saved.
Drawings
FIG. 1 is a flow chart of the method for automatically generating power supply design software based on data table according to the present invention.
FIG. 2 is the contents of the data table portion of the embodiment.
FIG. 3 is a screenshot of an automatically generated software portion interface in an embodiment.
FIG. 4 is a word computing book automatically generated in an embodiment.
Fig. 5 is a Saber simulation diagram automatically generated in the embodiment.
Detailed Description
Preferred embodiments of the present invention are described in further detail below.
A method for automatically generating power supply design software based on a database is disclosed, a flow chart is shown in figure 1, and the method comprises the following steps:
And 2, describing calculation information in a data table. And filling in the dynamic link library name and the function name corresponding to the control used for designing and calculating, and the input parameter set information and the output parameter set information of the function. The input parameter set information and the output parameter set information of the function are represented by English braces, control numbers of the input/output parameters, commas and semicolons after being positioned at the name of the function. The specific meanings are as follows: "(" before "is a function name;", "" after ";" before is a set of input parameters, ";" after ")" is preceded by a set of output parameters, with "between" the input/output parameters, separate.
For example, as shown in fig. 2, the control in the row where the "control number" is "11" is the output control, and calculation is required, the "dynamic link library name for calculation" hebootcall.dll "column is filled in the" dynamic link library name for calculation ", the" powercall "for calculation is filled in the" function information "column in the" dynamic link library for calculation ", and the" powercall "is filled in after the function name" (5,6;11) ", which indicates that the input parameters for the calculation function are the parameters of the" control number "5" and the "control number" 6 ", and the output parameters are the parameters of the" control number "11".
And 3, compiling a dynamic link library for calculation, and calculating an output parameter set from the input parameter set.
(1) The file name and function name of the dynamic link library are consistent with those filled in the data table in step 2.
(2) The function parameters in the dynamic link library are 2 pointer variables of double types, the 1 st pointer variable points to the input parameter set in the step 2, and the 2 nd pointer variable points to the output parameter set in the step 2. For example, the PowerCalc function in step 2 is: PowerCalc (double pInput, double pout).
(3) In the dynamic link library function, a calculation function is realized according to a design calculation formula, and an output parameter is obtained by calculating an input parameter.
And 4, building a software general framework and generating an executable program. The software general framework function comprises the contents of reading data table information, generating and automatically laying out interface controls and calling a dynamic link library, and specifically comprises the following steps:
(1) and reading page and control composition information in the data table.
(2) Necessary controls are automatically supplemented as required, such as adding a 'calculation' button beside the output parameters.
(3) And realizing the dynamic generation and automatic layout of all the controls and generating a user interface.
(4) Responding to the calculation operation of a user, reading input parameter data in the input parameter set from the interface according to the calculation information in the data table, dynamically calling the dynamic link library and the used dynamic link library function to obtain an output parameter, namely a calculation result, and displaying the output parameter on a corresponding control on the interface according to the calculation information in the data table.
a. And (4) hierarchical relation. The first level is a page, a control with the control type as the page name is used as a dividing line to divide each page, and a certain page comprises the following ranges: starting from a certain "page name" control until the end of the next "page name" control or data is encountered; the second level is a first-level grouping frame, and the range of a certain first-level grouping frame is as follows: starting from a control of a certain primary grouping frame until the control of the next primary grouping frame or the control of the next page name or the data is finished; the third level is a two-level grouping frame, and a certain two-level grouping frame comprises the following ranges: starting from a control of a certain secondary grouping box until the control of the next secondary grouping box or the control of the next primary grouping box or the control of the next page name or the end of data is met.
b. And (6) automatic layout. And laying out the controls according to the hierarchical relationship. The heights of the primary grouping frame control and the secondary grouping frame control are set according to the control contained in the primary grouping frame control and the heights of other controls are constants. The software generic framework adds a scroll bar as needed to accommodate all controls.
c. And generating an interface control ID. In order to facilitate automatic generation and data interaction of the interface control, unified regulation is carried out on the ID generation of the interface control. A row in the data table may correspond to multiple controls in the interface, so the control ID generation rule is: ID base + control number 10+ column number.
And step 5, putting the data table and the dynamic link library into the specified path of the software (corresponding to the path of the executable program in the step 4).
And 6, performing power supply design by using the executable program generated in the step 4 by a user, wherein the power supply design comprises operations such as calculation, graph display and the like, and finishing the design of the power supply topology, as shown in fig. 3.
And 7, after the design is finished, the software can automatically generate a word-format calculation book according to the design result. The software internal implementation process comprises the following steps: firstly, a calculation book template is generated, and secondly, corresponding design parameters, design charts and the like are written into corresponding positions of the calculation book by utilizing an OLE (on-line analytical engineering) automation technology according to a design result, as shown in FIG. 4.
And 8, after the design is finished, the software can automatically generate Saber, Simplis and Simulink simulation principle graph files according to the design result. The realization process is as follows: firstly, generating template files of Saber, Simplis and Simulink simulation principle diagrams; secondly, the analysis of the simulation schematic diagram file is completed, and the corresponding position of the parameter value in the schematic diagram file can be analyzed; the design result is again written into the corresponding location of the simulation schematic file as shown in fig. 5.
The technical scheme of the embodiment adopts a software general framework, the framework reads page and control composition information from a data table, interface layout information can be automatically generated, the framework can interact with a control to read control data and display control information, for the control needing to be calculated, calculation is carried out by calling a specified dynamic link library and a specified function in the data table, and the problem that the number of input parameters and output parameters is uncertain during calculation is solved through an input parameter set and an output parameter set. Developers only need to fill topology related information in a data table or a database and compile a corresponding dynamic link library, and power supply design software with a corresponding topology design function can be automatically generated. And the user can operate the controls on the interface, including calculation, chart display and other operations, and finally the design work is finished. In addition, after the design is finished, a word-format calculation book and Saber, Simplis and Simulink simulation principle diagram files can be automatically generated according to the design result.
The foregoing is a more detailed description of the invention in connection with specific preferred embodiments and it is not intended that the invention be limited to these specific details. For those skilled in the art to which the invention pertains, several simple deductions or substitutions can be made without departing from the spirit of the invention, and all shall be considered as belonging to the protection scope of the invention.
Claims (10)
1. A method for automatically generating power supply design software based on a database is characterized in that: which comprises the following steps:
step S1, establishing a data table or a database, wherein the data table or the database comprises description information formed by software pages and controls;
step S2, describing calculation information in a data table or a database; the calculation information comprises the file name of a dynamic link library corresponding to the control used for calculation, the name of a function in the dynamic link library, and input parameter set information and output parameter set information of each function;
step S3, establishing a dynamic link library, and calculating an output parameter set from an input parameter set according to a designed calculation formula in a function of the dynamic link library;
the file name and function name of the dynamic link library correspond to those in the data table or database in step S2;
the function parameters in the dynamic link library at least comprise two pointer variables, wherein one pointer variable points to the input parameter set in the step 2, and the other pointer variable points to the output parameter set in the step 2;
step S4, building a general software framework and generating an executable program;
the software general frame function comprises the steps of reading information of a data table or a database, generating and automatically arranging an interface control and calling a dynamic link library;
step S5, put the data table or database and dynamic link library to the path of the executable program;
and step S6, the executable program responds to the calculation operation of the user, reads the input parameter data in the input parameter set from the interface according to the calculation information in the data table or the database, dynamically calls the dynamic link library and the used dynamic link library function to obtain the output parameter, namely the calculation result, and displays the output parameter on the corresponding control on the interface according to the calculation information in the data table or the database to complete the design of the power supply topology.
2. The method of claim 1, wherein the database-based power supply design software comprises: in step S1, the description information composed of the software page and the control includes interface information of each page; each type of control includes a variety of interface controls.
3. The method of claim 2, wherein the database-based power supply design software comprises: in step S1, the page and control composition information includes "control number", "parameter name", "unit", "control type", and "default value" of each page; the control type comprises input, output, static text, page name, first-stage grouping frame, second-stage grouping frame, xy curve and baud diagram;
the input control comprises an input parameter name, an input edit box and input unit information;
in step S2, the input parameter set information and the output parameter set information of each function are located behind the function name and are indicated by an english parenthesis, a "control number" of the input/output parameter, and a comma and a semicolon.
4. The method of claim 1, wherein the database-based power supply design software comprises:
in step S4, the function of the software universal framework includes reading the page and control composition information of a certain topology in the data table or database, dynamically generating various controls of the "control type" in step S1 according to the hierarchical relationship of all the controls related to the topology in the data table or database, and automatically laying out according to the hierarchical relationship to generate the user interface.
5. The method of claim 4, wherein the database-based power supply design software comprises: the hierarchical relationship comprises a first hierarchy, a second hierarchy and a third hierarchy;
the first level is a page, a control with the control type as the page name is used as a dividing line to divide each page, and a certain page comprises the following ranges: starting from a certain "page name" control until the end of the next "page name" control or data is encountered;
the second level is a first-level grouping frame, and the range of a certain first-level grouping frame is as follows: starting from a control of a certain primary grouping frame until the control of the next primary grouping frame or the control of the next page name or the data is finished;
the third level is a two-level grouping frame, and a certain two-level grouping frame comprises the following ranges: starting from a control of a certain secondary grouping frame until the control of the next secondary grouping frame, the control of the next primary grouping frame or the control of the next page name or data is met;
the automatic layout includes: the heights of the primary grouping frame control and the secondary grouping frame control are set according to the controls contained in the primary grouping frame control and the secondary grouping frame control, and the heights of other controls are constants; the software general framework realizes the automatic layout of the controls on the automatically generated power supply design software space according to the sequence and the hierarchical relation in the data table or the database, and adds scroll bars as required to accommodate all the controls.
6. The method of claim 1, comprising:
generating a calculation book template, and writing corresponding design parameters and design charts into corresponding positions of the calculation book by utilizing an OLE (on-line analytical tool) automation technology according to a design result of an executable program;
and/or generating a simulation principle graph file template file, analyzing the simulation principle graph file, and writing the design result of the executable program into the corresponding position of the simulation principle graph file according to the corresponding position of the analyzed parameter value in the simulation principle graph file template file.
7. An automatic generation system of power supply design software based on a database, characterized by comprising:
the data table or the database comprises description information and calculation information which are formed by the software page and the control; the calculation information comprises the file name of a dynamic link library corresponding to the control used for calculation, and input parameter set information and output parameter set information in the dynamic link library;
the file name and the function name of the dynamic link library correspond to those in the data table or the database; the function parameters in the dynamic link library at least comprise two pointer variables, one pointer variable points to the input parameter set, and the other pointer variable points to the output parameter set;
the software general framework comprises the functions of reading data table or database information, generating and automatically laying out interface controls and calling a dynamic link library;
the executable program generation module responds to the calculation operation of a user, reads input parameter data in the input parameter set from the interface according to calculation information in a data table or a database, dynamically calls a dynamic link library and a used dynamic link library function to obtain an output parameter, namely a calculation result, and displays the output parameter, namely the calculation result, on a corresponding control on the interface according to the calculation information in the data table or the database;
the data table or the database and the dynamic link library are positioned on the path of the executable program.
8. The system for automatic generation of database-based power supply design software of claim 7, characterized in that it comprises:
the calculation book generation module is used for generating a calculation book template and writing corresponding design parameters and design charts into corresponding positions of the calculation book by utilizing an OLE (on-line analytical tool) automation technology according to a design result of the executable program;
and/or the simulation principle graph file generating module is used for generating a simulation principle graph file template file, analyzing the simulation principle graph file, and writing the design result of the executable program into the corresponding position of the simulation principle graph file according to the corresponding position of the analyzed parameter value in the simulation principle graph file template file.
9. A computer-readable storage medium, comprising a computer program which, when run on an electronic device, causes the electronic device to perform the method of automatic generation of database-based power supply design software according to any one of claims 1 to 6.
10. An apparatus comprising a processor and a memory coupled together, wherein the processor is configured to execute a computer program stored in the memory to perform the method of automatically generating database-based power design software of any of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911214250.4A CN111124385B (en) | 2019-12-02 | 2019-12-02 | Automatic generation method and system of power supply design software based on database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911214250.4A CN111124385B (en) | 2019-12-02 | 2019-12-02 | Automatic generation method and system of power supply design software based on database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111124385A true CN111124385A (en) | 2020-05-08 |
| CN111124385B CN111124385B (en) | 2022-05-20 |
Family
ID=70496825
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911214250.4A Active CN111124385B (en) | 2019-12-02 | 2019-12-02 | Automatic generation method and system of power supply design software based on database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111124385B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114385388A (en) * | 2022-03-25 | 2022-04-22 | 广东美的暖通设备有限公司 | Algorithm processing method and device, electronic equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050086635A1 (en) * | 2003-10-20 | 2005-04-21 | Pegasus Technologies, Inc. | Visual programming system and method |
| CN101082865A (en) * | 2007-06-29 | 2007-12-05 | 中兴通讯股份有限公司 | Automatically generating method based on data driving interface |
| US20100325606A1 (en) * | 2004-03-15 | 2010-12-23 | Ramco Systems Limited | Component based software system |
| CN106250116A (en) * | 2016-07-21 | 2016-12-21 | 武汉精伦电气有限公司 | A kind of software generic skeleton code generates method and system |
| CN110325961A (en) * | 2016-12-03 | 2019-10-11 | 托马斯·斯塔胡拉 | Software application exploitation based on electrical form |
-
2019
- 2019-12-02 CN CN201911214250.4A patent/CN111124385B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050086635A1 (en) * | 2003-10-20 | 2005-04-21 | Pegasus Technologies, Inc. | Visual programming system and method |
| US20100325606A1 (en) * | 2004-03-15 | 2010-12-23 | Ramco Systems Limited | Component based software system |
| CN101082865A (en) * | 2007-06-29 | 2007-12-05 | 中兴通讯股份有限公司 | Automatically generating method based on data driving interface |
| CN106250116A (en) * | 2016-07-21 | 2016-12-21 | 武汉精伦电气有限公司 | A kind of software generic skeleton code generates method and system |
| CN110325961A (en) * | 2016-12-03 | 2019-10-11 | 托马斯·斯塔胡拉 | Software application exploitation based on electrical form |
Non-Patent Citations (3)
| Title |
|---|
| KE GAO ET AL.: "Study of software development method of battery test platform based on Simulink and C#", 《2014 IEEE CONFERENCE AND EXPO TRANSPORTATION ELECTRIFICATION ASIA-PACIFIC (ITEC ASIA-PACIFIC)》 * |
| 何正文: "探讨可视化无功优化软件的开发技巧", 《广西电力》 * |
| 雒福生: "面向客户的船用装卸臂智能化设计平台开发", 《中国优秀博硕士学位论文全文数据库(硕士)工程科技Ⅱ辑》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114385388A (en) * | 2022-03-25 | 2022-04-22 | 广东美的暖通设备有限公司 | Algorithm processing method and device, electronic equipment and storage medium |
| CN114385388B (en) * | 2022-03-25 | 2022-09-13 | 广东美的暖通设备有限公司 | Algorithm processing method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111124385B (en) | 2022-05-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Reps et al. | The Synthesizer Generator: A system for constructing language-based editors | |
| Reiss | Graphical program development with PECAN program development systems | |
| CN106775725B (en) | Visual configuration editing method and device | |
| US7444612B2 (en) | Apparatus, method and program for supporting designing of integrated circuit using a common format | |
| CN101957745B (en) | Method for converting ladder diagram language into structure text language | |
| EP1211624A2 (en) | Methods and apparatus for automatically producing spreadsheet-based models | |
| JPH0640302B2 (en) | Schematic / source program automatic generation method | |
| WO2003098500A1 (en) | Method and apparatus for automatically producing spreadsheet-based models | |
| CN112199855B (en) | Dynamic generation method, device, equipment and medium for thermal hydraulic simulation software | |
| EP0676707B1 (en) | Expression promotion for hierarchical netlisting | |
| CN110597842A (en) | Service data query method and system | |
| CN104504214A (en) | Electrical schematic diagram generation method | |
| CN104267962A (en) | Interface UI (user interface) control configuration method based on description | |
| Pereira et al. | Web based IOPT Petri net Editor with an extensible plugin architecture to support generic net operations | |
| CN113268227A (en) | Zero-code visualization software development platform and development method | |
| CN109213480A (en) | A kind of method, storage medium, equipment and system for developing the back-stage management page | |
| CN111124385B (en) | Automatic generation method and system of power supply design software based on database | |
| CN110502735B (en) | Method and system for quickly manufacturing universal process file of electronic equipment | |
| CN103177064B (en) | A kind of method automatically enrolling given content in electronic document | |
| CN111506306A (en) | Method and device for compiling Ansible script and electronic equipment | |
| US7240301B2 (en) | System and method to insert new pages with a schematic capture tool | |
| Iglewski et al. | Editor for the Trace Assertion Method | |
| CN116151162A (en) | Automatic design method, device, equipment and medium for register codes and documents | |
| Tsygankov et al. | Constructive & Functional Representation of Engineering Products in a CAD-system at the Stage of Technical Design | |
| JPS62145424A (en) | Program managing method |
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 |