CN111191299A - Automatic generation method for computer interlocking system cabinet production drawing - Google Patents
Automatic generation method for computer interlocking system cabinet production drawing Download PDFInfo
- Publication number
- CN111191299A CN111191299A CN201911370311.6A CN201911370311A CN111191299A CN 111191299 A CN111191299 A CN 111191299A CN 201911370311 A CN201911370311 A CN 201911370311A CN 111191299 A CN111191299 A CN 111191299A
- Authority
- CN
- China
- Prior art keywords
- cabinet
- production
- configuration
- configuration file
- library
- 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.)
- Pending
Links
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 41
- 238000000034 method Methods 0.000 title claims abstract description 22
- 238000005065 mining Methods 0.000 claims abstract 4
- 238000006243 chemical reaction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012827 research and development Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to an automatic generation method of a cabinet production drawing of a computer interlocking system, which adopts a combination mode of Python and AutoCAD to automatically generate the cabinet production drawing, and comprises the following steps: 1) detecting whether the configuration file and the CAD drawing library exist or not, if any one of the configuration file and the CAD drawing library does not exist, exiting, otherwise, executing the step 2); 2) reading related contents in an interlocking machine cabinet configuration form in the config.xlsx configuration file, and calling a module in a CAD drawing library to automatically generate an interlocking machine cabinet; 3) circularly reading related contents configured by the mining and driving cabinets in the config.xlsx configuration file, and calling a module in a CAD drawing library to generate a plurality of mining and driving cabinets; 4) counting and generating a cabinet equipment list, and recording the quantity of all equipment in the cabinet; 5) and storing the generated cabinet production drawing. Compared with the prior art, the invention has the advantages of improving the efficiency, reducing the labor cost and the like.
Description
Technical Field
The invention relates to an automatic generation method of a production drawing, in particular to an automatic generation method of a production drawing of a cabinet of a computer interlocking system based on Python.
Background
The drawing of the production drawing of the computer interlocking system cabinet is important work in the implementation process of the interlocking project. With the gradual development of the interlocking project of the all-electronic computer, the difference between the cabinet configuration and the configuration of various board cards of different projects is large, and more labor is needed in the conversion process from the production drawing to the project drawing due to the fact that the types and the configuration combinations of the board cards of the system are too many. The existing mode of manufacturing production drawings on large, medium and small scales according to stations cannot meet new requirements.
Disclosure of Invention
The invention aims to overcome the defects in the prior art and provide an automatic generation method of a production drawing of a cabinet of a computer interlocking system.
The purpose of the invention can be realized by the following technical scheme:
an automatic generation method for a production drawing of a cabinet of a computer interlocking system adopts a Python and AutoCAD combination mode to automatically generate the production drawing of the cabinet, and the production method specifically comprises the following steps:
1) detecting whether the configuration file and the CAD drawing library exist or not, if any one of the configuration file and the CAD drawing library does not exist, exiting, otherwise, executing the step 2);
2) reading related contents in an interlocking machine cabinet configuration form in the config.xlsx configuration file, and calling a module in a CAD drawing library to automatically generate an interlocking machine cabinet;
3) circularly reading related contents of the configuration of the execution cabinets in the config.xlsx configuration files, and calling modules in a CAD drawing library to generate a plurality of execution cabinets;
4) counting and generating a cabinet equipment list, and recording the quantity of all equipment in the cabinet;
5) and storing the generated cabinet production drawing.
Preferably, the config.xlsx configuration file includes interlocking machine cabinet configuration, execution cabinet 1 configuration and cabinet equipment list.
Preferably, the number of the cabinets can be increased, and the arrangement of internal equipment of the cabinets and the input of the number of the board cards and the cages need to be completed.
Preferably, the interlocking machine cabinet configuration comprises:
the "device name" column, which selects the specific device through the drop-down menu of each cell;
the size column is obtained by automatic calculation according to the selected content of the equipment name column;
the line of the board name selects the board name through the pull-down menu of each cell;
the "explanatory text" column, which is used to generate the text description part of the device in the drawing, needs to manually fill in the description of the device name.
Preferably, the configuration of the execution cabinet 1 includes:
the "device name" column, which selects the specific device through the drop-down menu of each cell;
the line of the board name selects the board name through the pull-down menu of each cell;
the number of the board cards is listed, and the number of the simplex board cards is selected through a pull-down menu of each cell;
the "explanatory text" column, which is used to generate the text description part of the device in the drawing, needs to manually fill in the description of the device name.
Preferably, the CAD drawing library is used as a standard library, and is inserted into the Autocad software drawing after being called by a program according to the content in the config.xlsx configuration file, so as to further generate a cabinet production drawing.
Preferably, the profile production process is as follows:
(1) confirming that the 'DWG' folder and the content in the folder exist;
(2) the config.xlsx file is filled in and saved;
(3) opening AutoCAD software;
(4) and (4) double-clicking the executable file, automatically running the program, drawing the cabinet drawing in the AutoCAD software, and automatically saving the cabinet drawing as a Model _ SaveAs.
Preferably, the content in (1) is all device maps distributed by the product.
Compared with the prior art, the invention has the following advantages:
1. the mode of combining Python and AutoCAD is firstly used in railway signal industry, and is suitable for large-scale popularization and application of engineering products.
2. The production process of production drawings and project-level cabinet production drawings is simplified, the workload of research and development engineers and project engineers is reduced, the efficiency is improved, and meanwhile the labor cost is reduced.
3. The standardization degree of the interlocking product drawing is improved, and the manufacturing quality of the project drawing is improved.
4. The flexibility is high, and only a small amount of template files need to be updated in the product upgrading process.
Drawings
FIG. 1 is a flow chart of the present invention;
figure 2 is a schematic view of a configuration interface of an interlocker cabinet of the present invention;
FIG. 3 is a schematic diagram of a configuration interface of an implementation cabinet of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, shall fall within the scope of protection of the present invention.
As shown in fig. 1, an automatic generation method for a production drawing of a cabinet of a computer interlocking system automatically generates a production drawing of a cabinet by adopting a Python and AutoCAD combination mode, and the production method specifically includes the following steps:
1) detecting whether the configuration file and the CAD drawing library exist or not, if any one of the configuration file and the CAD drawing library does not exist, the program exits, and if not, executing the step 2);
2) reading related contents in an interlocking machine cabinet configuration form in the config.xlsx configuration file, and calling a module in a CAD drawing library to automatically generate an interlocking machine cabinet;
3) circularly reading related contents of the configuration of the execution cabinets in the config.xlsx configuration files, and calling modules in a CAD drawing library to generate a plurality of execution cabinets;
4) counting and generating a cabinet equipment list, and recording the quantity of all equipment in the cabinet;
5) and storing the generated cabinet production drawing.
The basic components of the automatic tool are as follows:
xlsx configuration file. The configuration file comprises a plurality of configuration pages such as interlocking machine cabinet configuration, execution cabinet 1 configuration, cabinet equipment list and the like. Project personnel can increase a plurality of execution cabinets according to the actual requirements of projects, and complete the arrangement of internal equipment of the cabinets and the input of the number of board cards and cages.
And the CAD drawing library of each device is published by the production drawing. The drawing library is used as a standard library, and is inserted into an Autocad software drawing after being called by a program according to the content in the config.xlsx configuration file, so that a cabinet production drawing is further generated.
Config. xlsx file configuration process
As shown in fig. 2, the "interlocking cabinet configuration" page configuration: the device name column may be used to select a specific device via a drop-down menu for each cell, and the size column may be automatically calculated based on the selection of the device name column without manual filling. The "explanatory text" column, which is used to generate the text description part of the device in the drawing, needs to manually fill in the description of the device name.
As shown in fig. 3, the "perform cabinet 1 configuration" page configuration: the equipment name column can select specific equipment through a drop-down menu of each cell, the board name column can select the board name through the drop-down menu of each cell, and the board number (single system) column can select the number of single system boards through the drop-down menu of each cell. The "explanatory text" column, which is used to generate the text description part of the device in the drawing, needs to manually fill in the description of the device name.
2. Configuration generation process
(1) Confirm the existence of the "DWG" folder and its contents (contents are all device drawings of product distribution)
(2) The config.xlsx file is filled out and saved
(3) Opening AutoCAD software
(4) And (4) double-clicking the executable file, automatically running the program, drawing the cabinet drawing in the AutoCAD software, and automatically saving the cabinet drawing as a Model _ SaveAs.
While the invention has been described with reference to specific embodiments, the invention is not limited thereto, and various equivalent modifications and substitutions can be easily made by those skilled in the art within the technical scope of the invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (8)
1. An automatic generation method for a production drawing of a cabinet of a computer interlocking system is characterized in that the method adopts a Python and AutoCAD combination mode to automatically generate the production drawing of the cabinet, and the production method specifically comprises the following steps:
1) detecting whether the configuration file and the CAD drawing library exist or not, if any one of the configuration file and the CAD drawing library does not exist, exiting, otherwise, executing the step 2);
2) reading related contents in an interlocking machine cabinet configuration form in the config.xlsx configuration file, and calling a module in a CAD drawing library to automatically generate an interlocking machine cabinet;
3) circularly reading related contents configured by the mining and driving cabinets in the config.xlsx configuration file, and calling a module in a CAD drawing library to generate a plurality of mining and driving cabinets;
4) counting and generating a cabinet equipment list, and recording the quantity of all equipment in the cabinet;
5) and storing the generated cabinet production drawing.
2. The method for automatically generating the production drawing of the cabinet of the computer interlocking system as claimed in claim 1, wherein the config.xlsx configuration file comprises interlocking machine cabinet configuration, execution cabinet 1 configuration and a cabinet equipment list.
3. The method for automatically generating the production drawing of the cabinet of the computer interlocking system as claimed in claim 2, wherein the number of the cabinets can be increased, and the arrangement of the internal equipment of the cabinets and the input of the number of the board cards and the cages are required to be completed.
4. The method for automatically generating the production drawing of the cabinet of the computer interlocking system as claimed in claim 2, wherein the configuration of the cabinet of the interlocking machine comprises:
the "device name" column, which selects the specific device through the drop-down menu of each cell;
the size column is obtained by automatic calculation according to the selected content of the equipment name column;
the line of the board name selects the board name through the pull-down menu of each cell;
the "explanatory text" column, which is used to generate the text description part of the device in the drawing, needs to manually fill in the description of the device name.
5. The method for automatically generating the production drawing of the cabinet of the computer interlocking system as claimed in claim 2, wherein the executing of the configuration of the cabinet 1 comprises:
the "device name" column, which selects the specific device through the drop-down menu of each cell;
the line of the board name selects the board name through the pull-down menu of each cell;
the number of the board cards is listed, and the number of the simplex board cards is selected through a pull-down menu of each cell;
the "explanatory text" column, which is used to generate the text description part of the device in the drawing, needs to manually fill in the description of the device name.
6. The method for automatically generating the production drawing of the cabinet of the computer interlocking system as claimed in claim 1, wherein the CAD drawing library is used as a standard library, and is inserted into an Autocad software drawing after being called by a program according to the content in the config.xlsx configuration file, so as to further generate the production drawing of the cabinet.
7. The method for automatically generating the production drawing of the cabinet of the computer interlocking system as claimed in claim 1, wherein the production process of the configuration file is as follows:
(1) confirming that the 'DWG' folder and the content in the folder exist;
(2) the config.xlsx file is filled in and saved;
(3) opening AutoCAD software;
(4) and (4) double-clicking the executable file, automatically running the program, drawing the cabinet drawing in the AutoCAD software, and automatically saving the cabinet drawing as a Model _ SaveAs.
8. The method for automatically generating the production drawing of the cabinet of the computer interlocking system as claimed in claim 7, wherein the content in (1) is all the equipment drawings distributed by a product.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911370311.6A CN111191299A (en) | 2019-12-26 | 2019-12-26 | Automatic generation method for computer interlocking system cabinet production drawing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911370311.6A CN111191299A (en) | 2019-12-26 | 2019-12-26 | Automatic generation method for computer interlocking system cabinet production drawing |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111191299A true CN111191299A (en) | 2020-05-22 |
Family
ID=70707592
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911370311.6A Pending CN111191299A (en) | 2019-12-26 | 2019-12-26 | Automatic generation method for computer interlocking system cabinet production drawing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111191299A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112307585A (en) * | 2020-11-11 | 2021-02-02 | 浙江中控技术股份有限公司 | Automatic design method and device for industrial personal computer cabinet assembly drawing |
| CN112632904A (en) * | 2020-12-24 | 2021-04-09 | 青岛鼎信通讯消防安全有限公司 | Method for automatically generating fire-fighting equipment cabinet diagram based on EXCEL |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110213480A1 (en) * | 2010-03-01 | 2011-09-01 | Genexis Design Inc. | Parametric product configuration system |
| CN105045948A (en) * | 2015-05-25 | 2015-11-11 | 中国华电工程(集团)有限公司 | Method for automatically batch generating configuration diagrams of transmitter protection box |
| CN107220465A (en) * | 2017-07-04 | 2017-09-29 | 山东爱普电气设备有限公司 | The automatic generation method of switch cubicle metal plate material type selecting inventory based on Auto CAD |
-
2019
- 2019-12-26 CN CN201911370311.6A patent/CN111191299A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110213480A1 (en) * | 2010-03-01 | 2011-09-01 | Genexis Design Inc. | Parametric product configuration system |
| CN105045948A (en) * | 2015-05-25 | 2015-11-11 | 中国华电工程(集团)有限公司 | Method for automatically batch generating configuration diagrams of transmitter protection box |
| CN107220465A (en) * | 2017-07-04 | 2017-09-29 | 山东爱普电气设备有限公司 | The automatic generation method of switch cubicle metal plate material type selecting inventory based on Auto CAD |
Non-Patent Citations (1)
| Title |
|---|
| 刘娜: "利用Python语言实现集中监测CAD施工图辅助设计", 《铁路通信信号工程技术》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112307585A (en) * | 2020-11-11 | 2021-02-02 | 浙江中控技术股份有限公司 | Automatic design method and device for industrial personal computer cabinet assembly drawing |
| CN112307585B (en) * | 2020-11-11 | 2023-12-22 | 浙江中控技术股份有限公司 | Automatic design method and device for assembly drawing of industrial personal computer cabinet |
| CN112632904A (en) * | 2020-12-24 | 2021-04-09 | 青岛鼎信通讯消防安全有限公司 | Method for automatically generating fire-fighting equipment cabinet diagram based on EXCEL |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101713823B (en) | Satellite telemetry data reduction processing method | |
| DE112018005582T5 (en) | Customer-specific quick design process for smart workshops and its system | |
| CN104407976B (en) | A kind of interface robustness testing case generation method and device | |
| CN103336805A (en) | Method and device for automatic customized report form generation based on graphical mapping relationship | |
| CN101859135B (en) | Method and device for controlling distributed automation system | |
| CN111191299A (en) | Automatic generation method for computer interlocking system cabinet production drawing | |
| CN104407576A (en) | Realization method for general type production and manufacturing unit and control system thereof | |
| CN102043719A (en) | Method for testing IEC61850 configuration description file | |
| CN102750301A (en) | Blueprint generating method for integrated avionic system model aiming at architecture analysis and design language (AADL) description | |
| CN106327100A (en) | Change list generation method and device | |
| CN109274178B (en) | Automatic analysis system and method for power dispatching preposed operation information | |
| CN103208087A (en) | Power distribution network data checking method based on international electrotechnical commission (IEC) 61968 standard | |
| CN112631937A (en) | Automatic CAN operation testing method and device for T-Box | |
| CN202092966U (en) | Automatic hole plugging checking instrument for SMT (surface mounting technology) steel mesh | |
| CN105045948A (en) | Method for automatically batch generating configuration diagrams of transmitter protection box | |
| CN104036372A (en) | Method for identifying suspected repeating data of electrical equipment | |
| CN101739497A (en) | Method for automatically computing figure labeling position | |
| CN105488271A (en) | Automatic matching method for oil gas module section steel | |
| CN104199663A (en) | Comprehensive automated information table automatic generating method and system | |
| CN115269502A (en) | Bid document processing method, device and storage medium | |
| CN106925415A (en) | A kind of ceramic raw material energy-saving control method and system | |
| CN109167354B (en) | Power grid expected fault parallel analysis and calculation method based on file exchange | |
| CN113821881A (en) | Large-scale amphibious aircraft iron bird test bed structure installation coordination data construction method | |
| CN112684404A (en) | Analog detection system and method for metering core | |
| CN114253222A (en) | Distributed control system DCS control cabinet set diagram generation method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200522 |
|
| RJ01 | Rejection of invention patent application after publication |