A design method and system for a new energy prefabricated substation

Abstract

This invention discloses a design method and system for new energy prefabricated substations. It develops an interactive interface for inputting project parameters, establishes a database with multiple linked forms, and configures parameter linkage and automatic transmission through preset formulas. Based on Excel interoperability, it associates the control events of the interactive interface with parameters in the database. After the user inputs project parameters, the system synchronizes the project parameters to the database and triggers parameter-linked calculations, with the calculation results written to the forms. Through the SolidWorks API interface, it retrieves standard assembly templates from a standard 3D model library, opening them sequentially according to parts, subassemblies, and the final assembly. Parameters from each form in the database are assigned to the corresponding parts and subassemblies, generating the target 3D assembly model. This invention, relying on a unified database, a standard 3D model library, and parameter-driven logic, achieves automatic generation from standard solutions to project solutions, reducing design difficulty and improving design efficiency.

Description

Technical Field

[0001] This invention belongs to the field of digital and intelligent three-dimensional design technology for new energy prefabricated substations. Specifically, it relates to a design method and system for new energy prefabricated substations that includes high-voltage switchgear, low-voltage switchgear, and enclosure. Background Technology

[0002] Currently, the field of 3D product design generally relies on traditional manual design methods, resulting in cumbersome processes, weak collaboration, and low iteration efficiency. In the design of new energy prefabricated substations, designers must sequentially complete manual operations such as 3D modeling of parts, assembly constraints, and engineering drawing. This not only involves a heavy workload of repetitive tasks but also easily leads to problems such as inconsistent modeling standards for sub-assemblies and cumbersome assembly constraint settings. Traditional design methods heavily depend on the practical experience accumulated by individual designers, resulting in high design thresholds and difficulty in learning, making it difficult for newcomers with no prior experience to work independently. Mature, similar design solutions in the industry cannot be effectively solidified and quickly reused; similar projects still require designing from scratch. When facing project requirements with multiple specifications and batches, the design cycle is long, the human error rate is high, and it is difficult to adapt to the requirements of large-scale, customized production.

[0003] Currently, parametric design technology based on SolidWorks for secondary development has emerged in the industry. This technology relies on VB.NET, software API interfaces, and macro recording functions to realize parametric modeling of sub-assemblies, automated assembly, motion simulation, and other functions. It has been applied in the design of products such as massage chairs and nuclear power plant check valves, effectively simplifying the design steps of single-category products and shortening the R&D time.

[0004] However, existing design tools still have significant shortcomings for products such as new energy prefabricated substations: First, they require operators to have professional 3D design capabilities, making it impossible to achieve lightweight design from scratch; second, they lack a mechanism for rapid reuse of typical solutions, and similar projects still need to be modeled and assembled from scratch; third, data management is chaotic, with no unified standard for sub-assembly drawing numbers, model storage paths, and parameter information, and a lack of differentiated management of general and non-general components, making it easy for 3D model references to result in path errors; fourth, the data interaction capabilities of multiple modules and positions are insufficient, public project information cannot be shared across design ends, parameters of old projects are difficult to retrieve and reuse, data at each stage is disconnected, and it is impossible to achieve an end-to-end digital and intelligent design closed loop.

[0005] The aforementioned shortcomings mean that the design of new energy prefabricated substations cannot escape the reliance on the personal experience of senior designers, has a high entry threshold, and cannot meet the standardized, parameterized, collaborative, and rapidly iterative digital design requirements of new energy prefabricated substations. Summary of the Invention

[0006] This invention addresses the problems of cumbersome traditional design processes for new energy prefabricated substations, poor reusability of standard solutions, inconvenient multi-position collaboration, chaotic data management, high design thresholds, and over-reliance on personal experience. It proposes a three-dimensional digital intelligent design solution. This solution establishes a standardized model library and sub-item database, solidifies mature design schemes, unifies model storage and drawing numbering standards, and enables shared project data and rapid retrieval of historical schemes. Utilizing parameter-driven capabilities, it automatically derives customized project schemes from typical solutions, automating modeling and assembly processes and avoiding problems such as incorrect model referencing and improper parameter integration. This invention unifies the design standards for new energy prefabricated substations, reduces repetitive manual operations, shortens design time, lowers the operational threshold, and allows even inexperienced personnel to complete designs efficiently. It achieves full-process digital intelligence in design, data, and model management, comprehensively improving design quality and operational efficiency.

[0007] To solve the above-mentioned technical problems, the present invention adopts the following technical solution: A design method for new energy prefabricated substations is proposed, including: Classify the structural types of new energy prefabricated substations, and build a standard 3D model library of parts, sub-assemblies and overall assemblies of the enclosure, high voltage cabinet and low voltage cabinet based on SolidWorks; A multi-tab interactive interface for entering project parameters was built using VB.NET as the development language. Establish an Excel database with multiple linked forms, and configure parameters for linkage and automatic transfer within and between forms through preset formulas; The Excel interoperability library is used to associate the control events of the interactive interface with parameters from the Excel database. In response to the project creation command on the interactive interface, the project parameters are synchronized to the Excel database through the Excel interoperability library and the parameter linkage calculation is triggered, and the calculation results are written to the corresponding form; The corresponding standard assembly template is retrieved from the standard 3D model library through the SolidWorks API interface. The templates are opened one by one in the order of parts, subassemblies, and final assembly. The calculated parameters in each sheet of the Excel database are assigned to the corresponding parts and subassemblies to generate the target 3D final assembly model.

[0008] Compared with existing technologies, the advantages and positive effects of this invention are as follows: This invention constructs a standard 3D model library of parts, sub-assemblies, and final assemblies, including enclosures, high-voltage cabinets, and low-voltage cabinets, using SolidWorks; it builds an interactive interface for entering project parameters using VB.NET as the development language; it establishes an Excel database with multiple forms linked and configures parameter linkage and automatic transmission through preset formulas; it associates the control events of the interactive interface with parameters in the Excel database based on Excel interoperability; after the user inputs project parameters to start project creation, the system synchronizes the project parameters to the Excel database through the Excel interoperability library and triggers parameter linkage calculation, writing the calculation results into the forms; it retrieves standard final assembly templates from the standard 3D model library through the SolidWorks API interface, opens them one by one in the order of parts, sub-assemblies, and final assemblies, assigns the parameters in each form of the Excel database to the corresponding parts and sub-assemblies, and generates the target 3D final assembly model. This invention systematically encapsulates mature design experience and complete sets of typical solutions, builds a standardized 3D model library and supporting database system, and takes into account actual business scenarios such as data sharing and parameter transmission under collaborative operations. It enables zero-foundation lightweight design without requiring operators to have professional 3D design capabilities.

[0009] In some embodiments of the present invention, after generating the three-dimensional assembly model, the method further includes: generating a complete set of engineering drawings for parts, sub-assemblies, and the overall assembly, as well as a project BOM list.

[0010] This embodiment generates the target 3D assembly model, and then uses SolidWorks to generate a complete set of engineering drawings for parts, subassemblies and the main assembly in batches. It also iterates through all parts and subassemblies of the assembly to generate the project BOM list, so that the design results can be directly output as drawings and bills of materials required for production and manufacturing. This realizes the full-process automation from 3D model design to engineering document output, avoiding the tedious work of manual drawing and BOM compilation and the human error introduced by it.

[0011] In some embodiments of the present invention, a standard 3D model library is built based on SolidWorks, including: Use SolidWorks to design 3D modeling of all parts and subassemblies of the cabinet, high voltage cabinet, and low voltage cabinet, and unify the dimensional equations, attribute association logic, and assembly positioning datum of parts and subassemblies. The parts library and sub-assembly library are split according to the product structure. All parts and sub-assemblies are bound to a unique standard drawing number and parameterized driving logic. Pre-assemble similar parts and sub-assemblies, set assembly constraints and hierarchical relationships in batches, and generate high-voltage switchgear assembly, low-voltage switchgear assembly, and enclosure assembly. Establish a shared 3D model library, storing all part models, sub-assembly models, and final assembly models in the shared 3D model library according to their product categories.

[0012] This embodiment uses SolidWorks to uniformly design the dimensional equations, attribute association logic, and assembly positioning datums for all parts and subassemblies, ensuring the consistency of design rules between different components and laying a standardized foundation for subsequent parametric driving. The parts library and subassembly library are split according to product structure, and each part and subassembly is bound to a unique standard drawing number, giving each part and subassembly a clear identity and parametric driving logic, facilitating rapid retrieval and retrieval by the system based on project requirements. By pre-assembling similar parts and batch setting assembly constraints and hierarchical relationships, the overall assembly of high-voltage cabinets, low-voltage cabinets, and enclosures is generated, reducing repetitive assembly operations. A shared 3D model library is built and stored according to product categories, enabling standardized model resources to be reused across multiple projects and teams, reducing the cost of repetitive modeling.

[0013] In some embodiments of the present invention, a multi-tab interactive interface for entering project parameters is constructed, specifically including: A multi-tab interactive interface is built using VB.NET as the development language, including a main TabControl and multiple TabPages. The multiple TabPages include at least a common parameter page, a high-voltage cabinet page, a low-voltage cabinet page, a cabinet page, and an execution page. Declare global and dictionary variables, add core DLL references, and write core utility functions; the global variables include at least path variables, database name variables, and logical variables; the core DLL references include at least the SolidWorks main API interface, SolidWorks constant definitions, Excel interoperability, and COM component interoperability; the core utility functions include at least a recursive copy function and a component name truncation function, wherein the recursive copy function is used to completely copy the template directory of the shared 3D model library to the local project, and the component name truncation function is used to truncate the complete component path of the SolidWorks assembly into a short name format for matching the drawing number mapping dictionary; Configure the parameter linkage of the interactive interface through event-driven configuration, and configure the global variables so that the declared global parameters can be read and updated by different tabs.

[0014] This embodiment uses VB.NET to build an interactive interface containing a main TabControl and multiple TabPages. Common parameters, high-voltage cabinets, low-voltage cabinets, enclosures, and execution functions are presented in separate pages, allowing users to enter parameters according to the design process module by module. The interface structure is clear, and the operation path is explicit. Global variables are declared to enable parameter sharing between different tabs, ensuring that parameters entered by users on different pages can be read and used by other pages and execution modules, thus solving the problem of data silos between multiple pages. Core DLL references such as the SolidWorks main API interface and Excel interoperability are added to pave the way for subsequent 3D... The model-driven and database read / write functions provide the necessary program interfaces; a recursive copy function is written to completely copy the template directory of the shared 3D model library to the local project, ensuring that the local project has a complete copy of the 3D model files and filtering out irrelevant files; a component name truncation function is written to truncate the complete component path into a short name format, providing a standardized key-value format for subsequent drawing number mapping dictionary matching; through event-driven configuration of interface parameter linkage, the system automatically updates the associated parameters when the user operates a control, and combined with the cross-page sharing mechanism of global variables, real-time synchronous transmission of parameters between various modules of the interface is realized, improving the convenience and consistency of parameter input.

[0015] In some embodiments of the present invention, establishing an Excel database with multiple form associations includes: Establish a shared database, including: public interface forms, high-voltage switchgear main attribute forms, low-voltage switchgear main attribute forms, enclosure main attribute forms, high-voltage data transmission forms, low-voltage data transmission forms, and constant forms; Configure parameter linkage calculation rules within and between each form using preset Excel formulas; Establish a profile database that provides standardized profile data sources for part modeling, and establish a component database that includes the dimensional parameters, mounting hole positions, and model specifications of components.

[0016] This embodiment establishes a multi-form linked Excel database containing a public interface form, a high-voltage switchgear main attribute form, a low-voltage switchgear main attribute form, a enclosure main attribute form, a high-voltage data transmission form, a low-voltage data transmission form, and a constant form. Parameters of different types and uses are stored in separate forms, making the data structure clear and easy to maintain. Pre-set Excel formulas configure parameter linkage calculation rules within and between forms. When a parameter in a form changes, the system automatically triggers parameter recalculation and updates across forms, eliminating the need for manual modification of each form and ensuring parameter consistency and synchronization across different data tables. A profile database provides standardized profile data sources for part modeling, allowing designers to directly select standard profile specifications without manually looking up tables and inputting dimensional parameters. A component database stores the dimensional parameters, mounting hole positions, and model specifications of core components, enabling the system to automatically read complete parameters based on the user-selected component model, avoiding manual data lookup and repetitive data entry, thus improving design efficiency and accuracy.

[0017] In some embodiments of the present invention, the control events of the interactive interface are associated with parameters of the Excel database based on the Excel interoperability library, specifically as follows: In VB.NET code, write read / write logic for each control event on the interactive interface, and use the Excel interop library to perform read or write operations on the Excel database file to achieve synchronization between interface parameters and Excel database storage parameters.

[0018] This embodiment achieves data synchronization between interface controls and the Excel database by writing read / write logic for each control event on the interactive interface in VB.NET code and calling the Excel interoperability library to perform read or write operations on the Excel database file: when the user enters or modifies parameters through the interface controls, the system automatically writes the data to the Excel database for persistent storage. When it is necessary to load existing project data, the system reads data from the Excel database and automatically populates it into the interface controls, ensuring that the data entered in the user interface is always consistent with the parameters stored in the Excel database, avoiding manual re-entry and human transcription errors.

[0019] In some embodiments of the present invention, in response to a project creation command on the interactive interface, project parameters are synchronized to an Excel database via the Excel interoperability library and parameter-linked calculations are triggered, and the calculation results are written to the corresponding form, specifically including: After receiving instructions to create a project, a project identifier is generated to name the local directory and 3D files; Create a local directory, including the database, project drawings, BOM list, and standard solutions; Use File.Copy to copy the project-related database from the shared database to the local database directory; Open the local database using the Excel interop library and write common parameters and individual interface parameters to Excel. Excel calculates the box structure dimensions, high and low pressure installation positioning, hole coordinates, and profile cutting dimensions based on the built-in calculation formulas in the logic library. If it is a cabinet design, the installation positions and structural parameters of the components of the high and low voltage cabinet are transmitted to the cabinet through the high and low voltage data transmission form, which drives the corresponding installation structure and opening positions of the cabinet to automatically adapt and update. Based on the component database, the corresponding installation dimensions, hole position parameters, and structural adaptation are updated in a linked manner.

[0020] In this embodiment, upon receiving the project creation instruction, a unique project identifier containing the WBS number and project name is first generated, ensuring the uniqueness and traceability of the naming of the local directory and 3D files. Subsequently, a local directory structure containing the database, project drawings, BOM list, and standard solutions is created, and File.Copy is called to copy related files from the shared database to the local database directory, giving each project an independent and complete data copy and avoiding data conflicts during parallel design of multiple projects. The local database is opened using the Excel interoperability library, and common parameters and sub-interface parameters are written, achieving synchronization of interface parameters to the database. Excel automatically calculates the cabinet structure dimensions, high and low voltage installation positioning, hole coordinates, and profile cutting dimensions based on the calculation formulas built into the logic library, combining the dimension calculation logic with data storage, making the calculation results traceable and the calculation rules easy to maintain. For cabinet design scenarios, the component installation positions and structural parameters of the high and low voltage cabinet are automatically transferred to the cabinet module through the high and low voltage data transfer form, driving the corresponding installation structure and opening positions of the cabinet to automatically adapt and update, realizing parameter linkage between the high and low voltage module and the cabinet module, avoiding manual comparison and coordination modifications. Based on the automatic linkage update of the component database, the corresponding installation dimensions, hole position parameters and structural adaptation are automatically updated. When users switch component models, the system automatically completes the update of relevant structural parameters without the need for manual verification and modification, which significantly reduces the design error rate.

[0021] In some embodiments of the present invention, generating a target three-dimensional assembly model specifically includes: In response to the drawing generation command in the interactive interface, the standard 3D model related to the project in the shared database is completely copied to the 3D template directory of the local project; By calling SolidWorks API functions through VB.NET, the corresponding standard sub-assembly model can be retrieved from the 3D model library based on the category identifier; Batch assign all calculated dimensions, specifications, component models, positioning coordinates, drawing numbers, and other parameters from the forms to the corresponding parts and subassemblies; The model is updated sequentially according to the hierarchy of parts, sub-assemblies at each level, and the final assembly. Automatically switch between standard and project-specific drawing numbers for parts and subassemblies, synchronously update model file names and storage paths, and automatically archive according to project rules; Based on parameter updates, the model automatically completes the deformation of the box openings, installation structure, and profile dimensions to generate a 3D assembly model adapted to the current project.

[0022] In this embodiment, in response to the drawing generation command on the interactive interface, the standard 3D model related to the project in the shared database is first completely copied to the 3D template directory of the local project to ensure that a complete copy of the model file is available locally; then, SolidWorks is called via VB.NET. API functions retrieve the corresponding standard parts and sub-assemblies based on category identifiers, enabling precise model retrieval and loading. All calculated dimensions, specifications, component models, positioning coordinates, and drawing numbers from all forms are batch-assigned to the corresponding parts and sub-assemblies, ensuring each model file receives the correct project parameters. Model updates are driven level by level according to the hierarchy of parts, sub-assemblies at each level, and the final assembly, ensuring the correctness and integrity of the assembly hierarchy and avoiding assembly errors caused by disordered hierarchy. Standard drawing numbers are automatically switched to project-specific drawing numbers, and model file names and storage paths are updated synchronously, ensuring all generated model files have a unified project naming convention, resolving issues of abnormal model reference paths and chaotic drawing numbers. Based on parameter updates, model deformation for box openings, installation structures, and profile dimensions is automatically completed, generating a complete 3D assembly model adapted to the current project without manual modification of model geometry features, significantly reducing repetitive modeling work.

[0023] In some embodiments of the present invention, the project creation instruction is generated in response to the interactive interface receiving project data; wherein, the project data is input through the interactive interface, or obtained by reading historical project data and making differentiated modifications to it.

[0024] In this invention, the project creation command is generated in response to the interactive interface receiving project data. The project data can be input through the interactive interface or obtained by reading historical project data and making differentiated modifications. This technique allows designers to reuse the complete parameter configuration of existing projects when starting a new project. They only need to modify the differentiated parameters that are different from the current project to quickly complete the parameter preparation for the new project, effectively reducing the workload of repetitive parameter input. At the same time, reading historical project data ensures the continuity and accuracy of existing mature parameter configurations.

[0025] This invention also proposes a design system for a new energy prefabricated substation, comprising: A standardized 3D model library for storing standard 3D models of parts, sub-assemblies, and final assemblies built on SolidWorks, categorized by product structure into enclosures, high-voltage cabinets, and low-voltage cabinets. A multi-tab interactive interface, built with VB.NET as the development language, is used to input project parameters; An Excel database with multiple linked forms, where parameters are linked and automatically transferred within and between forms via preset formulas; The parameter association module is used to associate the control events of the interactive interface with the Excel database based on the Excel interoperability library; The project database driver module is used to respond to the project creation command on the interactive interface, synchronize project parameters to the Excel database through the Excel interoperability library and trigger parameter linkage calculation, and write the calculation results to the corresponding form. The project model generation module is used to retrieve the corresponding standard assembly template from the standard 3D model library through the SolidWorks API interface, open them one by one in the order of parts, subassemblies and general assemblies, assign the calculated parameters from each form in the Excel database to the corresponding parts and subassemblies, and generate the target 3D general assembly model.

[0026] The design system of this invention constructs an automated design system from parameter input and data calculation to 3D model generation. During the design process, users only need to input project parameters on the interactive interface, and the system can automatically complete data linkage calculation and 3D model-driven generation, which significantly improves the intelligence level and work efficiency of new energy box-type substation design. Attached Figure Description

[0027] Figure 1 This is a flowchart illustrating the design method for a new energy prefabricated substation proposed in this invention. Figure 2 This is a schematic diagram of the hierarchical organization of the shared 3D model library built in this embodiment of the invention; Figure 3 This is a schematic diagram of the project creation and automatic 3D model generation process in an embodiment of the present invention; Figure 4 This invention presents the design system structure for a new energy prefabricated substation. Detailed Implementation

[0028] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0029] The purpose of this invention is to build a three-dimensional digital intelligent design system adapted to the characteristics of new energy prefabricated substations. Mature design schemes, assembly rules, and parameter calculation logic are fully solidified into the system's bottom layer. Relying on a unified database, a standard three-dimensional model library, and parameter-driven logic, the system can automatically generate project solutions from typical schemes. This allows personnel without design experience to complete the entire design work. At the same time, it connects the entire process of design, data flow, and model management, comprehensively improving product design efficiency and standardization.

[0030] The specific implementation method includes the following steps: S1. Classify the structural types of new energy prefabricated substations, and build a standard 3D model library of parts, sub-assemblies and overall assemblies of the enclosure, high-voltage cabinet and low-voltage cabinet based on SolidWorks.

[0031] (1) Classify products.

[0032] The product categories are divided according to the enclosure structure, functional modules, and application scenarios of new energy prefabricated substations. The two major application scenarios are photovoltaic prefabricated substations and wind power prefabricated substations. The products are divided into three categories: prefabricated substations, high-voltage switchgear, and low-voltage switchgear. Each product category is further subdivided into multiple standard structural schemes. A unique category identifier is defined for each standard structure, which serves as the identification basis for subsequent retrieval of parts database and subassembly database.

[0033] (2) Build a standardized three-dimensional model library and a database of supporting parts and subassemblies for various types of new energy box-type substations.

[0034] Specifically, it includes: (21) Use SolidWorks to design 3D modeling of all parts and subassemblies of the cabinet, high voltage cabinet, and low voltage cabinet, and unify the size equations, attribute association logic, and assembly positioning datum of parts and subassemblies.

[0035] Create a new field for the part's "Custom Properties (for parameter-driven)". The field name should be completely aligned with the "Attribute Name Column" in the Excel database. This field will be used to receive parameter values ​​read from the Excel database and associate them with modeling dimensions through the SolidWorks equation function. Create four fixed fields for the part's configuration properties: drawing code, product name, WBS number, and specifications. These fields will be automatically written by the secondary development program later.

[0036] Establish standardized assembly positioning benchmarks for all parts and subassemblies, and compile benchmark naming and storage paths for parts and subassemblies according to unified rules.

[0037] (22) The parts library and sub-assembly library are split according to the product structure. The high voltage switch parts library, low voltage switch parts library, and enclosure parts library (base parts, frame parts, door panel parts, top cover parts) are built respectively. The supporting high voltage switch sub-assembly library, low voltage switch assembly library, and enclosure sub-assembly library (base sub-assembly, frame sub-assembly, door panel assembly, top cover assembly) are also built. All parts and sub-assemblies are bound to a unique standard drawing number and parameterized driving logic.

[0038] (23) Pre-assemble parts and sub-assemblies of the same type, set assembly constraints and hierarchical relationships in batches, and generate high-voltage switchgear assembly, low-voltage switchgear assembly and enclosure assembly.

[0039] (24) Storage in the warehouse.

[0040] Establish a shared 3D model library, stored on a local area network, such as the path \\10.20.xx.xx\xx\01 New Energy Box-Type Substation Digital Intelligent Design Library\02 3D Parametric Model. Store all part models, sub-assembly models at all levels, and overall assembly models in the shared 3D model library according to product categories. Distinguish between general parts and sub-assemblies, and non-general parts and sub-assemblies, storing them in separate directories. Organize them hierarchically according to "Module Type - Base - Scheme Name - Sub-Module," see [link / reference]. Figure 2 Example shown.

[0041] S2: A multi-tab interactive interface for entering project parameters is built using VB.NET as the development language.

[0042] (1) First, a multi-tab interactive interface is built using VB.NET as the development language.

[0043] It includes one main TabControl and six TabPages. The main TabControl is named TabControl1; the six TabPages are: TabPage1 for common parameters, two pages for high-voltage cabinets (gaoyagui1 / gaoyagui2), page diyagui1 for low-voltage cabinets, page xiangti1 for the enclosure, and page zhixing for execution.

[0044] The layout of the TabPage controls mentioned above: Public Parameters Page: TextBox (Project Name / WBS Number / Number of Units), ComboBox (Base / Module / Solution Type), PictureBox (Schematic Diagram), Button (Write to Shared / Read from Old Project); Low-voltage cabinet page: ComboBox (frame / shell / busbar model), TextBox (cabinet dimensions / positioning), PictureBox (structural diagram); High-voltage switchgear page: ComboBox (vacuum circuit breaker / counter / PT configuration), TextBox (G3 / G4 positioning / instrument door dimensions), PictureBox (sectional schematic diagram); Box page: ComboBox (Transformer capacity / data transmission method), TextBox (Panel size / XY coordinates), PictureBox (Overall assembly layout diagram); Execution page: Buttons (Create Project / Generate Part / Generate Subassembly / Generate Final Assembly / Relink / One-Click Generate), ProgressBar (Progress Display); Tab switching events: Dynamic tab loading is achieved through ComboBox1_SelectedIndexChanged: Selecting "Low-voltage cabinet" loads TabPage1 + diayagui1 + zhixing; selecting "High-voltage cabinet" loads TabPage1 + gaoyagui1 + gaoyagui2 + zhixing; selecting "enclosure" loads TabPage1 + xiangti1 + zhixing.

[0045] (2) Declare global variables and dictionary variables, add core DLL references and write core utility functions.

[0046] (21) Declare 25 global variables and 8 dictionary variables: 10 path variables: sourceDir1 (shared database root), L70ku02 (shared 3D library root), destinationDir1 (local database directory), destinationDir2 (local 3D template directory), destinationDir3-6 (4 local drawing subdirectories, dedicated to the box body).

[0047] 12 database name variables: Excelzname (current module Excel file name), Llinzname / Llinzname1-3 (4 part library sheet names, the box body is divided into 4 sub-modules), Zhuangzname / Zhuangzname1-3 (4 sub-assembly library sheet names), Fanganzname (scheme name), Zongzname01 (original standard general assembly drawing name), Zongzname02 (project general assembly drawing name).

[0048] Three logical variables: Num666 (frame circuit breaker header number: 0 / 1 / 2), CopyNo (project creation flag: 0 / 1), and Noz (progress bar count).

[0049] Eight dictionary variables: general dataMapz01 (part + subassembly mapping), dataMapz02 (part mapping only), dataMapz03 (subassembly mapping only); and box-specific dataMapz01_xdz (base), dataMapz01_xkj (frame), dataMapz01_xmb (door panel), and dataMapz01_xdg (top cover).

[0050] (22) Add 4 core DLL references: SolidWorks.Interop.sldworks.dll: SolidWorks main API interface; SolidWorks.Interop.swconst.dll: SolidWorks constant definitions; Microsoft.Office.Interop.Excel.dll: Excel interoperability; System.Runtime.InteropServices.dll: COM component interoperability.

[0051] (23) Write a public class module Mkz.vb to implement two core utility functions.

[0052] The CopyAllz function (recursive copy) is used to completely copy the template directory of a shared 3D model library to the local project, excluding temporary files (11 file extensions such as .tmp / .suo / .pdb, etc.) and avoiding redundant irrelevant files.

[0053] The ConvertAToB function (component name truncation) is used to truncate the complete component path of a SolidWorks assembly (e.g., 5T.K05.000.0001_assembly / 5T.K05.001.0001_part) into a short name format (e.g., 5T.K05.001.0001), which is used to match the drawing number mapping dictionary.

[0054] (3) Implement parameter linkage of the interactive interface through event-driven mechanism, and configure global variables to be global parameters that can be read and updated by different tabs.

[0055] For each control on each tab, write the automatic update logic in its handler function when the control changes.

[0056] The global parameters declared can be read and updated by configuring different tabs, so that the parameters can be used centrally even if they are scattered across different pages.

[0057] S3: Establish an Excel database with multiple linked forms, and configure parameters for linkage and automatic transfer within and between forms through preset formulas.

[0058] (1) Build a shared database and store it on the local area network, such as the path \\10.20.xx.xx\xx\01 New Energy Box-type Substation Digital Intelligent Design Library\01 database, including: New Energy Box-type Substation Digital Intelligent Design Public Interface Form, High Voltage Cabinet / Low Voltage Cabinet / Box Body 3 Main Attribute Forms, High Voltage Data Transmission Form, Low Voltage Data Transmission Form and Constant Form 7 Independent Related Forms.

[0059] The public interface form uses the WBS number as a globally unique index to store global public parameters such as production base, design module, project name, solution type (photovoltaic / wind power), number of units, altitude, corrosion resistance level, incoming and outgoing line method, metering configuration, UPS power supply configuration, cabinet length, width and height, high and low voltage room dimensions, and number of incoming and outgoing line circuits. Each parameter setting has drop-down options or default values ​​to ensure standardized and consistent input.

[0060] The main attribute form of the enclosure stores core parameters of the enclosure, such as transformer capacity, transformer panel height, high and low voltage panel length, low voltage cabinet positioning XY coordinates, and high and low voltage data transmission methods.

[0061] The main attribute form of the high-voltage switchgear stores core parameters of the high-voltage module, such as circuit breaker specifications and models, installation positioning dimensions, counter type, copper busbar specifications, grounding layout, PT and secondary grounding configuration.

[0062] The low-voltage switchgear main attribute form stores core parameters of the low-voltage module, such as cabinet length, width, and depth, circuit breaker cabinet width, circuit breaker model, molded case model, busbar clamp model, and fixing hole position parameters.

[0063] The high-voltage data transmission form and the low-voltage data transmission form serve as a parameter linkage bridge between the high-voltage and low-voltage modules and the enclosure module. They store the installation positioning dimensions, hole coordinates, and structural adaptation parameters transmitted from the high-voltage and low-voltage modules to the enclosure module, thereby enabling automatic linkage and adaptation between the high-voltage and low-voltage modules and the enclosure structure.

[0064] The constant library forms store fixed parameters, welding allowances, profile specifications, mounting hole spacing constants, and standard part parameters that are universal across the entire system, providing a unified benchmark data source for parameter calculations throughout the entire process.

[0065] (2) Configure parameter linkage calculation rules in each form and between each form through preset Excel formulas, including cross-sheet cell references and calculation formula binding, to realize automatic calculation and linkage update of box structure dimensions, high and low pressure installation positioning, hole coordinates and profile cutting dimensions.

[0066] (3) Build a supporting profile database, including standard profile parameter library such as equal angle steel, unequal angle steel, channel steel, rectangular square tube, etc., to provide standardized profile data source for part modeling.

[0067] (4) Build a component database, including the size parameters, mounting hole positions, model specifications and other parameters of core components such as vacuum circuit breakers, molded case circuit breakers, bus clamps, and surge arresters, to support one-click switching of component models and automatic adaptation to corresponding installation structures.

[0068] The Excel sheet names in the component database are bound to their types. Each sheet has a list of storage device models in the E1:AZ1 area. These models are then automatically added to the drop-down list in the interactive interface using the LoadComboBoxItemsFormExcel function in the development program.

[0069] S4: Based on the Excel interoperability library, associate the control events of the interactive interface with the parameters of the Excel database.

[0070] In VB.NET code, read and write logic is written for each control event on the interactive interface. By calling the Excel interop library (Microsoft.Office.Interop.Excel.dll) to perform read or write operations on the Excel database file, the interface parameters and the parameters stored in the Excel database are synchronized, thereby binding the controls to each Excel cell.

[0071] S5: Responding to the project creation command in the interactive interface, the project parameters are synchronized to the Excel database through the Excel interoperability library and the parameter linkage calculation is triggered, and the calculation results are written to the corresponding form.

[0072] Users first enter global project identification parameters on the public information page, including production base, design module, project name, WBS number, solution type, and quantity. Then, they switch between the low-voltage switchgear, high-voltage switchgear, and enclosure parameter tabs in sequence, selecting component models and structural configuration options from the drop-down menus on each page, and entering dimensional parameters in the input boxes. The interface PictureBox simultaneously displays the corresponding structural schematic diagram to help users verify the parameter positions. After all parameters are entered, users click the "Create Project" button, and the system automatically generates a local project folder and corresponding sub-item database files in the background, completing the saving of project parameters.

[0073] Specifically, such as Figure 3 The following are included: (1) After receiving the project parameters and project creation instructions, generate a project identifier for naming the local directory and 3D files.

[0074] The WBS number and project name are concatenated to form a unique project identifier Xmnamez (e.g., 20260707001XX photovoltaic transformer), which is used to name the local directory and 3D files.

[0075] (2) Create local directories: Automatically create 4 types of local directories (the root directory is D:\Project\Xmnamez).

[0076] This includes databases, project drawings, BOM lists, and standard solutions, such as Figure 3 The illustrated embodiment.

[0077] (3) Copy the shared database: Copy the project-related database from the shared database to the local 01 database directory using File.Copy.

[0078] (4) Write project parameters to Excel through Excel interop library: Open Excel and write two types of parameters according to the preset control-cell mapping relationship: public parameters and sub-item interface Sheet.

[0079] Common parameters are written according to the mapping of Excel columns to UI controls (corresponding to code such as worksheet.Range("C2").Value = ComboBox2.Text, etc.).

[0080] The sub-item interface sheet is written with the corresponding lines according to the module type (high voltage cabinet D3-D18, low voltage cabinet D2-D18, enclosure D3-D8).

[0081] (5) Excel uses the built-in calculation formulas in the logic library to calculate the box structure dimensions, high and low pressure installation positioning, hole coordinates, and profile cutting dimensions.

[0082] The calculation formulas in the logic library are bound to Excel cell addresses to ensure that the calculation logic is stable and traceable.

[0083] (6) If it is a cabinet design, the installation position and structural parameters of the components of the high and low voltage cabinet are automatically transmitted to the cabinet through the high and low voltage data transmission form, and the corresponding installation structure and opening position of the cabinet are automatically adapted and updated.

[0084] Parameter transfer from high and low voltage switchgear to enclosure: If "enclosure design + online transfer" is selected, the program will automatically copy the high voltage switchgear / low voltage switchgear database to the local machine, and paste the A1:K120 area of ​​its high voltage data transfer / low voltage data transfer sheet into the enclosure database to achieve parameter linkage.

[0085] (7) Based on the component database, the corresponding installation dimensions, hole position parameters and structural adaptation are automatically updated.

[0086] S6: Retrieve the corresponding standard assembly template from the standard 3D model library through the SolidWorks API interface, open them one by one in the order of parts, subassemblies and assembly, assign the calculated parameters from each sheet in the Excel database to the corresponding parts and subassemblies, and generate the target 3D assembly model.

[0087] (1) In response to the drawing generation command of the interactive interface, call the CopyAllz function to completely copy the standard 3D model related to the project in the shared database to the 3D template directory of the local project.

[0088] (2) Call SolidWorks API functions through VB.NET to retrieve the corresponding standard sub-assembly model in the 3D model library according to the category identifier.

[0089] (3) Batch assign all calculated dimensions, specifications, component models, positioning coordinates, drawing numbers and other parameters in the forms to the corresponding parts and subassemblies.

[0090] (4) Drive the model update step by step in the hierarchical order of “independent parts → sub-assemblies at all levels → final assembly”.

[0091] (5) Automatically switch standard / project-specific drawing numbers for parts and subassemblies, synchronously update model file names and storage paths, and automatically archive according to project rules to solve the problems of abnormal model reference paths and chaotic drawing numbers.

[0092] (6) Based on parameter updates, the model deformation of the box opening, installation structure and profile size is automatically completed to generate a customized three-dimensional assembly model that is adapted to this project.

[0093] The following example, using a frame circuit breaker parameter-driven scheme, illustrates the implementation plan for parameter linkage calculation and standard 3D model-driven generation of a customized 3D assembly model: (1) When designing the low-voltage switchgear, determine the parameter reading logic of the frame circuit breaker according to Num666 (row number): select "upper and lower ports horizontal" (Num666=0) → read the E column parameters of the frame circuit breaker database 0 (from row 2 to row 74), open the corresponding circuit breaker part (such as frame circuit breaker with both upper and lower ports horizontal.SLDPRT), and modify the custom attributes through Set2.

[0094] (2) Traverse each row of the Excel parts library sheet and perform 5 modification steps: 1. Validity check: Check whether the L / M / N columns (generation flags) are not empty and ≠ 0, and whether the G column is a .SLDPRT file.

[0095] 2. Construct drawing number mapping: Store the standard drawing number → project drawing number into the dataMapz01 / dataMapz02 dictionary. When designing the box, additional sub-dictionary dataMapz01_xdz, etc. are stored.

[0096] 3. Open SolidWorks parts: Open parts in silent mode using Sapp.GetOpenDocSpec to avoid pop-up window interference.

[0097] 4. Modify attributes: Custom attributes: Traverse columns 15-738 of Excel (groups of 3: attribute name → empty column → attribute value), match the attribute name of the part, and assign the value using Set2.

[0098] Configuration attributes: Fixed to include drawing code, product name, WBS number, and specifications.

[0099] 5. Modify the associated engineering drawing: Open the corresponding .SLDDRW file, delete all floating annotations, and ensure that the engineering drawing is associated with the part.

[0100] (3) Batch modification of subassemblies.

[0101] The logic is the same as that for modifying parts, except that the drawing number is mapped to dataMap03.

[0102] (4) Rename the assembly components.

[0103] 1. Open the original standard assembly drawing Zongzname01.

[0104] 2. Iterate through all components and use ConvertAToB to extract the shortest name.

[0105] 3. Match the dataMapz01 dictionary and call RenameDocument to change the component name to the project drawing number.

[0106] 4. Save as Zongzname02 (Project Assembly Drawing).

[0107] (5) Relink the engineering drawings: 1. Traverse the dataMapz02 / dataMapz03 dictionary and physically rename the engineering drawing (.SLDDRW).

[0108] 2. Call Sapp.ReplaceReferencedDocument to fix the reference relationship between the engineering drawing and the model.

[0109] 3. Delete old model files and clean up redundancies.

[0110] 4. Use MoveDrawingsAfterRelink to move the engineering drawing to the project drawing directory and complete the archiving.

[0111] In some embodiments of this invention, if the current design can reuse existing project data, after the designer enters the production base, design module, project name, WBS number, and scheme, clicking the "Read Shared Interface Data" button allows for one-click retrieval of all project parameters stored in the shared database, including public data, low-voltage cabinets, high-voltage cabinets, and enclosure forms, which are then automatically filled into the corresponding input controls on the interface. After the parameters are modified, clicking "Write to Shared" batches all form parameters back to the shared database for retrieval by other production bases and design personnel, enabling parallel collaborative design by multiple teams. The invention also supports searching local historical projects by WBS number, project name, and scheme type. Clicking "Read Local Old Project Data" loads the complete set of historical parameters, model configurations, and BOM structure with one click, allowing for quick completion of new project designs by modifying only the differentiating parameters, reducing repetitive design workload. Supporting forms such as review catalogs, finished product delivery information notifications, mechanical material packing lists, and technical specifications enable automatic generation and unified management of project-wide documentation.

[0112] S7: Generates a complete set of parts, subassemblies, final assembly engineering drawings, and project BOM list.

[0113] The system uses SolidWorks to sequentially open all part and subassembly files, generating a complete set of standardized engineering drawings in batches. The drawing parameters are synchronized with the database forms and 3D models in real time. Clicking the "Print Engineering Drawings" button will automatically print non-standard engineering drawings. Clicking the "Generate BOM" button will automatically traverse all parts and subassemblies of the assembly, matching the specifications, models, materials, and weight information in the material master data to automatically generate a complete BOM list for this project. Clicking the "Print Documents" button will automatically print project documents such as mechanical surface treatment details and material packing lists, achieving seamless data flow from design to production.

[0114] BOM generation includes: (1) Traverse from assembly: Traverse all parts of SolidWorks assembly, extract drawing code, name, material, specification, quantity and quality, and generate structured BOM.

[0115] (2) Extract from Excel: Read the BOM Sheet of this project from the local Excel file, automatically format it (clear blank values, adjust column widths), and generate a printable BOM.

[0116] Document printing is handled by matching the Excel print-specific sheet (such as text-proofreading list, text-packing list) to the base / module and automatically calling the Excel print interface for output.

[0117] Based on the above design method, this invention also proposes a design system for the new energy prefabricated substation, such as... Figure 4 As shown, it includes: A standardized 3D model library for storing standard 3D models of parts, sub-assemblies, and final assemblies built on SolidWorks, categorized by product structure into enclosures, high-voltage cabinets, and low-voltage cabinets.

[0118] A multi-tab interactive interface, built with VB.NET as the development language, is used for entering project parameters.

[0119] An Excel database with multiple linked forms, where parameters are linked and automatically transferred within and between forms via preset formulas.

[0120] The parameter association module is used to associate the control events of the interactive interface with the Excel database based on the Excel interoperability library.

[0121] The project database driver module is used to respond to project creation commands in the interactive interface, synchronize project parameters to the Excel database through the Excel interoperability library, trigger parameter linkage calculations, and write the calculation results to the corresponding forms.

[0122] The project model generation module is used to retrieve the corresponding standard assembly template from the standard 3D model library through the SolidWorks API interface, open them one by one in the order of parts, subassemblies and general assemblies, assign the calculated parameters from each form in the Excel database to the corresponding parts and subassemblies, and generate the target 3D general assembly model.

[0123] The specific design process of this system for new energy prefabricated substations has been described in detail and will not be repeated here.

[0124] It should be noted that the above description is not intended to limit the present invention, and the present invention is not limited to the examples given above. Any changes, modifications, additions or substitutions made by those skilled in the art within the scope of the present invention should also fall within the protection scope of the present invention.

Claims

1. A new energy box-type substation design method, characterized in that, The method comprises the following steps: Divide the structure types of new energy box-type substations, and build a standard three-dimensional model library of parts, sub-assemblies and total assemblies of the box, high-voltage cabinet and low-voltage cabinet based on SolidWorks; Build a multi-tabbed interactive interface for inputting project parameters by using VB.NET as the development language; Build an Excel database with multiple forms, and configure parameters in each form and between forms through preset formulas for linkage and automatic transmission; Associate the control events of the interactive interface with the Excel database based on the Excel interoperability library; In response to a project creation instruction of the interactive interface, synchronize the project parameters to the Excel database through the Excel interoperability library, trigger parameter linkage calculation, and write the calculation results into the corresponding forms; Call the corresponding standard total assembly template from the standard three-dimensional model library through the SolidWorks API interface, open the parts, sub-assemblies and total assemblies one by one in sequence, assign the calculated parameters in each form of the Excel database to the corresponding parts and sub-assemblies, and generate a target three-dimensional total assembly model.

2. The design method of a new energy box-type substation according to claim 1, characterized in that, After generating the three-dimensional total assembly model, the method further comprises the following steps: Generate a complete set of engineering drawings of the parts, sub-assemblies and total assemblies and a project BOM list.

3. The design method of a new energy box-type substation according to claim 1, characterized in that, Build a standard three-dimensional model library based on SolidWorks, which comprises the following steps: Design all parts and sub-assemblies of the box, high-voltage cabinet and low-voltage cabinet by using SolidWorks, and unify the size equations, property association logic and assembly positioning reference of the parts and sub-assemblies; Split the part library and sub-assembly library according to the product structure, and bind a unique standard drawing number and parameterized driving logic to all parts and sub-assemblies; Pre-assemble the same type of parts and sub-assemblies, set assembly constraints and hierarchical association relationships in batches, and generate high-voltage cabinet total assemblies, low-voltage cabinet total assemblies and box total assemblies; Build a shared three-dimensional model library, and store all part models, sub-assembly models and total assembly models in the shared three-dimensional model library according to the transmission product classification.

4. The new energy box-type substation design method of claim 1, wherein, Build a multi-tabbed interactive interface for inputting project parameters, which comprises the following steps: Build a multi-tabbed interactive interface by using VB.NET as the development language, which comprises a main TabControl and multiple TabPages, and the multiple TabPages at least include a common parameter page, a high-voltage cabinet page, a low-voltage cabinet page, a box page and an execution page; Declare global variables and dictionary variables, add core DLL references, and write core tool functions; the global variables at least include a path variable, a database name variable and a logic variable; the core DLL references at least include a SolidWorks main API interface, SolidWorks constant definitions, an Excel interoperability and a COM component interoperability; the core tool functions at least include a recursive copy function and a component name extraction function, wherein the recursive copy function is used to copy the template directory of the shared three-dimensional model library to the local project completely, and the component name extraction function is used to extract the complete component path of the SolidWorks assembly into a short name format for matching the drawing number mapping dictionary; The parameter linkage of the interactive interface is configured through event driving, and the global variable is configured to declare the global parameters that can be read and updated by different Tab pages.

5. The new energy box-type substation design method of claim 1, wherein An Excel database with multiple forms is established, including: A shared database is built, including: a public interface form, a high-voltage cabinet main attribute form, a low-voltage cabinet main attribute form, a box main attribute form, a high-voltage data transmission form, a low-voltage data transmission form, and a constant form; Parameter linkage calculation rules are configured in each form and between forms through preset Excel formulas; A profile database is built to provide standardized profile data sources for part modeling, and a component database is built to include size parameters, mounting hole positions, and model specifications of components.

6. The new energy box-type substation design method of claim 1, wherein, The control events of the interactive interface are associated with the Excel database based on the Excel interoperability library, specifically: In the VB.NET code, read and write logic is written for each control event on the interactive interface, which reads or writes to the Excel database file through the Excel interoperability library, and synchronizes the interface parameters with the Excel database storage parameters.

7. The new energy box-type substation design method of claim 1, wherein, In response to the project creation instruction of the interactive interface, the project parameters are synchronized to the Excel database through the Excel interoperability library and trigger parameter linkage calculation, and the calculation results are written to the corresponding form, including: Upon receiving the project creation instruction, generate a project identifier for naming the local directory and three-dimensional file; Create a local directory, including the database, project drawing, BOM list, and standard scheme; Copy the databases related to the project in the shared database to the local database directory through File.Copy; Open the local database through the Excel interoperability library and write the public parameters and sub-item interface parameters to Excel; Excel calculates the box structure size, high-low voltage installation positioning, hole coordinates, and profile cutting size based on the built-in calculation formula in the logic library. If it is a box design, the high-low voltage data transmission form is used to transmit the component installation position and structure parameters of the high-low voltage cabinet to the box, driving the box to automatically adapt and update the corresponding installation structure and hole position. Based on the component database, the corresponding installation size, hole position parameters, and structure adaptation are updated.

8. The new energy box-type substation design method of claim 1, wherein, Generate the target three-dimensional assembly model, including: In response to the drawing generation instruction of the interactive interface, copy the standard three-dimensional model related to the project in the shared database to the local project three-dimensional template directory; Call the standard part and sub-assembly body model in the three-dimensional model library according to the category identifier through the SolidWorks API function in VB.NET; Batch assign the size, specification, component model, positioning coordinates, and drawing number parameters calculated in all forms to the corresponding parts and sub-assemblies; Update the model according to the hierarchical order of parts, sub-assemblies, and assemblies; Automatically switch between part and sub-assembly standard / project-specific drawing numbers, synchronize model file names and storage paths, and automatically archive according to project rules. Based on the parameter update, the model deformation of box opening, mounting structure and profile size is automatically completed, and the three-dimensional assembly model adapted to the current project is generated.

9. The new energy box-type substation design method according to claim 1 or 7, characterized in that, The project creation instruction is generated in response to the project data received by the interactive interface; wherein the project data is input through the interactive interface, or obtained by reading historical project data and implementing differential modification thereon.

10. A new energy box-type substation design system, characterized by, It comprises: A standardized three-dimensional model library for storing the product structure division of box, high-voltage cabinet and low-voltage cabinet, and the standardized three-dimensional models of parts, sub-assemblies and total assemblies based on SolidWorks; A multi-tab page interactive interface built with VB.NET for inputting project parameters; An Excel database with multiple forms, and the parameters in each form and between forms are linked and automatically transmitted through preset formulas; A parameter association module for associating the control events of the interactive interface with the Excel database based on the Excel interoperability library; A project database driving module for synchronizing the project parameters to the Excel database through the Excel interoperability library and triggering parameter linkage calculation in response to the project creation instruction of the interactive interface, and writing the calculation results into the corresponding form; A project model generation module for calling the corresponding standard total assembly template from the standardized three-dimensional model library through the SolidWorks API interface, opening the parts, sub-assemblies and total assemblies one by one in sequence, assigning the calculated parameters in the forms of the Excel database to the corresponding parts and sub-assemblies, and generating the target three-dimensional total assembly model.

Images