CN106951577A - A kind of automatic immediate processing method of I/O point information based on AutoCAD - Google Patents
A kind of automatic immediate processing method of I/O point information based on AutoCAD Download PDFInfo
- Publication number
- CN106951577A CN106951577A CN201610009356.0A CN201610009356A CN106951577A CN 106951577 A CN106951577 A CN 106951577A CN 201610009356 A CN201610009356 A CN 201610009356A CN 106951577 A CN106951577 A CN 106951577A
- Authority
- CN
- China
- Prior art keywords
- points
- databases
- autocad
- functional diagram
- point
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Computer Hardware Design (AREA)
- Evolutionary Computation (AREA)
- Geometry (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention belongs to CAD and digital chemical industry control technology field, and in particular to a kind of automatic immediate processing method of I/O point information based on AutoCAD.First when receiving design input, first by the information solicitation of all I/O points into I/O databases, each I/O points have one uniquely No. ID；Secondly when drawing functional diagram, when needing to add I/O points in the functional diagrams, it is only necessary to an I/O block is added in figure, and fills in No. ID of the I/O points, the attribute of other I/O points need not be filled in；Complete after all functional diagrams, imported all other information of I/O points from I/O databases using import feature plug-in unit.The present invention realizes the automatic of substantial amounts of I/O points information and quickly introduced, and realizes database and AutoCAD information Fast synchronization, not only greatly reduces workload, and ensure that accuracy.
Description
Technical field
The invention belongs to CAD and digital chemical industry control technology field, and in particular to a kind of automatic immediate processing method of I/O point information based on AutoCAD.
Background technology
AutoCAD is the Interactive Drawing Software of autodesk, inc. of U.S. exploitation, and for two dimension and three dimensional design, the system tool drawn, user can use it to create, browse, manage, print and share the design configuration rich in information.As universal graphics software, AutoCAD is widely used in industry-by-industry.
Although AutoCAD function is very powerful, when facing different engineering demands, substantial amounts of work needs for manually completing, inefficiency and error rate height.For example in digitlization industrial control field, it usually needs engineering design configuration software is drawn out with the form of drawing, in order to be audited and verified, this figure for representing configuration software logic is referred to as functional diagram.Not only to include the process logic (such as AND OR NOT gate) realized in configuration software in functional diagram, and also need to include the information of specific I/O (input and output signal) points, the fastener type distributed such as the type (such as On-off signal point or output switch parameter point etc.) called the roll, put, range, the point and channel number etc..
For one than relatively large Industry Control project, there are nearly up to ten thousand points to need to be entered into AutoCAD, not only workload is big but also error rate is high if manual entry, it is impossible to ensure the quality of engineering, in addition it is also necessary to subsequently spend substantial amounts of manpower to go to proofread and audit.
The content of the invention
It is an object of the invention to provide a kind of automatic immediate processing method of I/O point information based on AutoCAD, the automatic of substantial amounts of I/O points information is realized to quickly introduce, database and AutoCAD information Fast synchronization are realized, workload is not only greatly reduced, and ensure that accuracy.
To reach above-mentioned purpose, the technical solution used in the present invention is：
A kind of automatic immediate processing method of I/O point information based on AutoCAD, comprises the following steps：(1) an I/O point data base is created；(2) it is that each I/O points distribute one uniquely No. ID when adding I/O points in I/O databases；(3) create a block using the method for graph block in AutoCAD, and be named as I/O blocks, the block should include the base attribute name of I/O points, this block is to need just to add this block when addition I/O points in the template of I/O points, each functional diagram；(4) AutoCAD.NET secondary developing platforms are based on, using C# language, realize that import feature is as follows in the way of plug-in unit：Cad file is opened first, I/O blocks are searched in figure；Read property parameters therein and inserted in a table object LIST_A；Then the data read channel with I/O databases is set up by ODBC method, reads I/O tables of data, and all I/O point attributes are filled up in another table object LIST_B；In LIST_A, using LINQ query language, poll searches No. ID of each I/O points, according to No. ID other attributes that the points of the I/O of No. ID are extracted in table LIST_B, and these attributes are write in LIST_A tables；In the last I/O blocks that No. ID of the information in LIST_A based on I/O points is written in CAD again；(5) realize that the synchronizing function between functional diagram and database is as follows：First the I/O point datas in CAD are all imported into different table objects from the I/O point datas in I/O databases；Then LINQ language is utilized, the attribute based on No. ID to same I/O points compares the content in two tables, and result of the comparison is saved in Excel file.
Function above application method is as follows：First when receiving design input, first by the information solicitation of all I/O points into I/O databases, each I/O points have one uniquely No. ID；Secondly when drawing functional diagram, when needing to add I/O points in the functional diagrams, it is only necessary to an I/O block is added in figure, and fills in No. ID of the I/O points, the attribute of other I/O points need not be filled in；Complete after all functional diagrams, imported all other information of I/O points from I/O databases using import feature plug-in unit.
When I/O databases and functional diagram are all after repeatedly modification, between the two it is possible that inconsistent situation, data that can be to both sides by the way of I/O databases are synchronous with functional diagram are contrasted, by checking the Excel file of final result, the difference between I/O databases and functional diagram is found out.
Described base attribute name includes I/O roll-calls, vertex type, the fastener number and channel number distributed.
Having the beneficial effect that acquired by the present invention：
The present invention is directed in the common functional diagram of digitlization industrial control field, the method for proposing addition importing and synchrodata function in AutoCAD, the automatic batch that I/O points can not only be completed is imported, and can synchronous autocad file and database, the input of manpower is greatly reduced, resource has been saved；Artificial caused mistake is avoided simultaneously, greatly improves the accuracy of functional diagram；Data processing function is realized by .NET LINQ language simultaneously, the speed of data processing is accelerated, is more suitable in large-scale digitlization Industry Control project and uses.
By taking data importing work as an example, such as using manually importing, the drawings of page 100 need 10-20 people's man-hour.If the software designed using the present invention, treatment time was at 2-3 minutes or so.If manually complete to import data task simultaneously, accuracy is typically 90% or so.And if using the present invention, accuracy keeps 100%, the accuracy of functional diagram is greatly improved.
Brief description of the drawings
Fig. 1 is importing I/O point information flow charts；
Fig. 2 is synchronizing function figure and I/O databases.
Embodiment
The present invention is described in detail with specific embodiment below in conjunction with the accompanying drawings.
(1) firstly the need of centralized management I/O point information.In Industry Control project, the information of I/O points is usually to concentrate on to be managed in database or Excel tables.(2) it is that each I/O points determine a unique mark, referred to as ID in database.Ensure its be in whole database it is unique, and No. ID with I/O points correspond.(3) graph block (block) is set up in AutoCAD, be named as in I/O blocks, block need comprising I/O points institute the attribute in need being shown in functional diagram, such as I/O roll-call, fastener type and channel number etc., while also needing to I/O ID attributes.(4) secondary development is carried out in AutoCAD, this programme is not using conventional ODBC passage methods come frequent reading database, ODBC has no problem for less application of counting, but for common large-scale digitlization Industry Control Application, the reading of the relevant information of nearly 20,000 points and comparing requires a great deal of time, and larger also can result in system in case of system halt due to counting.Therefore the method that this programme employs .NET LINQ language, tables of data is disposably directly read by ODBC to internal memory, then data are inquired about and compared using LINQ language, due to being all to exist to carry out inside, and ODBC passage reading databases need not be travelled frequently over, therefore accelerate processing speed.(5) secondary development is carried out to AutoCAD first, realizes that automatic batch imports data function according to Fig. 1 flow.(6) secondly, secondary development is carried out in AutoCAD, synchronizing function is realized.
Because functional diagram and database are two files respectively, it can be changed and be safeguarded by different people, therefore in project implementing process, it may appear that the problem of following：(1) not necessarily all I/O points can be all imported into functional diagram.All I/O points should be all assigned in corresponding functional diagram, but are due to that the reasons such as the point that mistake either newly adds may miss some I/O points；(2) I/O databases and functional diagram can all be changed frequently.When I/O databases comparisons, if without functional diagram is updated simultaneously, may result in I/O databases inconsistent with functional diagram.Similarly, if only functional diagram is updated, if updating I/O databases, inconsistent situation also occurs.
Therefore need to add synchronizing function, comparing function figure and the information in I/O databases, the difference for finding both sides analyzes reason for designer.Its flow is as shown in Figure 2.
(1) an I/O point data base is created first
(2) it is that each I/O points distribute one uniquely No. ID when adding I/O points in I/O databases
(3) block is created using the method for graph block in AutoCAD, and is named as I/O blocks, the block should include the base attribute name of some I/O points, such as I/O roll-calls, vertex type, the fastener number distributed and channel number etc..This block is exactly to need in the template of I/O points, each functional diagram just to add this block when addition I/O points.
(4) the data import feature in AutoCAD is realized according to Fig. 1 flow, the present invention is based on AutoCAD.NET secondary developing platforms, using C# language, required function is realized in the way of plug-in unit.Import feature realizes that flow is as follows：
A) cad file is opened first, I/O blocks is searched in figure；Read property parameters therein and inserted in a table object LIST_A；
B) data read channel with I/O databases and then by ODBC method is set up, I/O tables of data is read, and all I/O point attributes are filled up in another table object LIST_B；
C) in LIST_A, using LINQ query language, poll searches No. ID of each I/O points, according to No. ID other attributes that the points of the I/O of No. ID are extracted in table LIST_B, and these attributes are write in LIST_A tables；
D) in the last I/O blocks that No. ID of the information in LIST_A based on I/O points is written in CAD again.
(5) synchronizing function between functional diagram and database is realized.Its step is as follows：
A) it is identical with data import feature, first the I/O point datas in CAD are all imported into different table objects from the I/O point datas in I/O databases；
B) and then using LINQ language, the attribute based on No. ID to same I/O points compares the content in two tables, and result of the comparison is saved in Excel file, is searched problem for designer.
Describe below how the function of more than use developing：
(1) first when receiving design input, first by the information solicitation of all I/O points into I/O databases,
Each I/O points have one uniquely No. ID；
(2) secondly when drawing functional diagram, when needing to add I/O points in the functional diagrams, it is only necessary to an I/O block is added in figure, and fills in No. ID of the I/O points, the attribute of other I/O points need not be filled in；
(3) complete after all functional diagrams, imported all other informations of I/O points from I/O databases using import feature plug-in unit；
(4) when I/O databases and functional diagram are all after repeatedly modification, between the two it is possible that inconsistent situation, such as add new I/O points, but have forgotten situations such as adding in the functional diagrams in I/O databases；
Data that can be to both sides by the way of I/O databases are synchronous with functional diagram are contrasted, by the Excel file for checking final result, it becomes possible to find out the difference between I/O databases and functional diagram.
Claims (4)
1. a kind of automatic immediate processing method of I/O point information based on AutoCAD, it is characterised in that：Bag
Include following steps：(1) an I/O point data base is created；(2) when adding I/O points in I/O databases,
One uniquely No. ID is distributed for each I/O points；(3) created using the method for graph block in AutoCAD
One block, and I/O blocks are named as, the block should include the base attribute name of I/O points, and this block is I/O points
Template, need in each functional diagram just to add this block when addition I/O points；(4) it is based on
AutoCAD.NET secondary developing platforms, using C# language, realize that import feature is as follows in the way of plug-in unit：
Cad file is opened first, I/O blocks are searched in figure；Read property parameters therein and inserted one
In individual table object LIST_A；Then set up by ODBC method and the digital independent of I/O databases leads to
Road, reads I/O tables of data, and all I/O point attributes are filled up in another table object LIST_B；
In LIST_A, using LINQ query language, poll searches No. ID of each I/O points, according to No. ID
Other attributes of the points of the I/O of No. ID are extracted in table LIST_B, and these attributes are write into LIST_A
In table；In the last I/O blocks that No. ID of the information in LIST_A based on I/O points is written in CAD again；
(5) realize that the synchronizing function between functional diagram and database is as follows：First by the I/O point datas in CAD with
I/O point datas in I/O databases are all imported into different table objects；Then LINQ language, base are utilized
Compare the content in two tables in No. ID attribute to same I/O points, and result of the comparison is saved in
In Excel file.
2. a kind of I/O point information based on AutoCAD according to claim 1 is quickly handled automatically
Method, it is characterised in that：Function above application method is as follows：First when receiving design input, first by institute
There is the information solicitation of I/O points into I/O databases, each I/O points have one uniquely No. ID；Secondly
When drawing functional diagram, when needing to add I/O points in the functional diagrams, it is only necessary to an I/O is added in figure
Block, and fill in No. ID of the I/O points, the attribute of other I/O points need not be filled in；Complete all
After functional diagram, all other information of I/O points are imported from I/O databases using import feature plug-in unit.
3. a kind of I/O point information based on AutoCAD according to claim 2 is quickly handled automatically
Method, it is characterised in that：When I/O databases and functional diagram are all after repeatedly modification, between the two may
Inconsistent situation occurs, data that can be to both sides by the way of I/O databases are synchronous with functional diagram are entered
Row contrast, by checking the Excel file of final result, finds out between I/O databases and functional diagram not
Same point.
4. a kind of I/O point information based on AutoCAD according to claim 1 is quickly handled automatically
Method, it is characterised in that：Described base attribute name includes I/O roll-calls, vertex type, the fastener number distributed
And channel number.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610009356.0A CN106951577A (en) | 2016-01-07 | 2016-01-07 | A kind of automatic immediate processing method of I/O point information based on AutoCAD |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610009356.0A CN106951577A (en) | 2016-01-07 | 2016-01-07 | A kind of automatic immediate processing method of I/O point information based on AutoCAD |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106951577A true CN106951577A (en) | 2017-07-14 |
Family
ID=59466034
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610009356.0A Pending CN106951577A (en) | 2016-01-07 | 2016-01-07 | A kind of automatic immediate processing method of I/O point information based on AutoCAD |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106951577A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111124680A (en) * | 2019-12-23 | 2020-05-08 | 浙江中控技术股份有限公司 | Intelligent I/O distribution method and system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2372533A1 (en) * | 2009-07-16 | 2011-10-05 | Tangshan Railway Vehicle Co., Ltd | Method and platform for integrating a heterogeneous collaborative design system of work group and product lifecycle management system |
| CN103530436A (en) * | 2013-06-26 | 2014-01-22 | 厦门钨业股份有限公司 | Tooling layout drawing parameterization generation method based on AUTOCAD. NET API |
| CN103853759A (en) * | 2012-12-03 | 2014-06-11 | 方正国际软件(北京)有限公司 | Self-adaptive form generation method and self-adaptive form generation system |
-
2016
- 2016-01-07 CN CN201610009356.0A patent/CN106951577A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2372533A1 (en) * | 2009-07-16 | 2011-10-05 | Tangshan Railway Vehicle Co., Ltd | Method and platform for integrating a heterogeneous collaborative design system of work group and product lifecycle management system |
| CN103853759A (en) * | 2012-12-03 | 2014-06-11 | 方正国际软件(北京)有限公司 | Self-adaptive form generation method and self-adaptive form generation system |
| CN103530436A (en) * | 2013-06-26 | 2014-01-22 | 厦门钨业股份有限公司 | Tooling layout drawing parameterization generation method based on AUTOCAD. NET API |
Non-Patent Citations (2)
| Title |
|---|
| 任继文: "用VBA实现AUTOCAD图形明细表与数据库的链接", 《机械设计与制造》 * |
| 周春波等: "基于AutoCAD的地下管网图形属性一体化方案", 《城市勘测》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111124680A (en) * | 2019-12-23 | 2020-05-08 | 浙江中控技术股份有限公司 | Intelligent I/O distribution method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102128628B (en) | Difference analysis method and difference analysis device for electronic maps | |
| CN104317624B (en) | Data assembly method based on plug-in unit treatment | |
| EP3451206B1 (en) | Method, apparatus, and device for generating a visual model layout of a space | |
| CN105095319A (en) | Time serialization based document identifying, associating, searching and showing system | |
| CN110442847B (en) | Code similarity detection method and device based on code warehouse process management | |
| CN112883042A (en) | Data updating and displaying method and device, electronic equipment and storage medium | |
| CN102968539A (en) | Method for massively and quickly generating format drawing | |
| CN110795835A (en) | Three-dimensional process model reverse generation method based on automatic synchronous modeling | |
| CN115168971A (en) | Component parameter library-based integrated collaborative method for design and construction of fabricated building | |
| CN110866024B (en) | Vector database increment updating method and system | |
| CN103927402A (en) | Control logic diagram modular design management system implementation method | |
| CN110705969A (en) | Transformer substation monitoring system, main station and method for automatically associating measuring point ID | |
| CN110908978B (en) | Database data structure verification method and device | |
| CN106951577A (en) | A kind of automatic immediate processing method of I/O point information based on AutoCAD | |
| CN110633084B (en) | Transcoding derivation method and device based on single sample | |
| CN110932929B (en) | Method, system and medium for classifying and extracting satellite telemetry packets in CCSDS system | |
| CN110188156B (en) | Transmission line engineering three-dimensional design result key information extraction method and system | |
| CN111752958A (en) | Intelligent associated label method, device, computer equipment and storage medium | |
| CN110147396B (en) | Mapping relation generation method and device | |
| CN112015850B (en) | Method and system for updating POI electronic map data based on data mining and POI vertical industry data characteristics | |
| Lecallard et al. | Automatic hexahedral-dominant meshing for decomposed geometries of complex components | |
| CN111143356B (en) | Report retrieval method and device | |
| CN114118944A (en) | Forensic laboratory grading management method, terminal device and storage medium | |
| CN112287005A (en) | Data processing method, device, server and medium | |
| CN113094861B (en) | Data storage method, device, equipment and storage medium |
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: 20170714 |
|
| RJ01 | Rejection of invention patent application after publication |