CN105512392A - State grid ERP material device coding and application system - Google Patents
State grid ERP material device coding and application system Download PDFInfo
- Publication number
- CN105512392A CN105512392A CN201510890743.5A CN201510890743A CN105512392A CN 105512392 A CN105512392 A CN 105512392A CN 201510890743 A CN201510890743 A CN 201510890743A CN 105512392 A CN105512392 A CN 105512392A
- Authority
- CN
- China
- Prior art keywords
- data
- excel
- software tool
- data source
- material code
- 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02E—REDUCTION OF GREENHOUSE GAS [GHG] EMISSIONS, RELATED TO ENERGY GENERATION, TRANSMISSION OR DISTRIBUTION
- Y02E60/00—Enabling technologies; Technologies with a potential or indirect contribution to GHG emissions mitigation
Landscapes
- Stored Programmes (AREA)
Abstract
The invention provides a state grid ERP material device coding and application system. Data integration and application of a transformer substation digitized three-dimensional electrical design system and a state grid company material system are achieved, and a matched software tool is researched and developed. The Excel material coding data source technology is applied, the material coding data source of the Excel format is exported from the state grid company material system through the core of the technology, and data integration and share between different software systems are achieved according to the data source. In the application process, firstly, the electrical device type selection design is completed in the transformer substation digitized three-dimensional electrical design system, data of the Excel material coding data source is read through the software tool, material codes are obtained from the Excel material coding source and stored in a project database of the transformer substation digitized three-dimensional electrical design system with device parameters as matching conditions, and an electrical device material table with the material codes is generated in the transformer substation digitized three-dimensional electrical design system and used during material declaration.
Description
Technical field:
When the present invention is used for Substation Design, state net ERP material equipment is carried out encoding and applied, facilitates the material in later stage to report and submit, as the capsule information that design is transferred to electrical network owner digitizing, facilitate the lifecycle management in the later stage of owner.
Background technology:
1, state's net ERP material system;
2, BentlySubstationSS7 software platform;
3, Windows7X64 Professional operating system;
4, SQLServer2008R2 edition data storehouse;
5, MicrosoftVisualStudio2008 programming technique.
Summary of the invention:
Technical matters to be solved by this invention is the defect overcoming prior art, provides a kind of state to net ERP material device coding and application system.
Technical matters to be solved by this invention realizes by the following technical solutions.
A kind of state net ERP material device coding and application system, is characterized in that: comprise the following steps:
1) in transformer station's Digital Three-Dimensional electrical design system, complete the design of main wiring diagram and complete the type selecting of electrical equipment, the parameter of electrical equipment is saved in the project database of electrical design system;
2) on Software tool interface, select the scope of synchronous material code, " current drawing ", " current volume " and " current engineering " three different scopes can be selected, software by automatic according to selected range query to needing to carry out the synchronous facility information of material code;
3) on Software tool interface, select the Excel material code data source of latest edition, and read the data message in data source;
4) Software tool is with device parameter in project database for matching condition, and the value that in retrieval material code Excel data source, " material is long to be described " arranges, finds matched data;
5) if obtain the material code less than coupling, Software tool can provide prompting, and prompting designer checks that whether the design data of electrical design system is correct;
6) if successfully get the material code of equipment, then Software tool can by material code Data Update in the project database of electrical design system;
7) generate with the electrical equipment material list of material code, material list can export as Excel file form, and this form can be supplied to follow-up system, is used for the material declaring work of finished item.
Material system of the present invention can derive an Excel data source, this tables of data comprises the design parameter information of material code and equipment, also concrete parameter information is contain in the standard device model storehouse of transformer station's Digital Three-Dimensional electrical design system, with device parameter information for matching condition, can by " unit type index " information association of " material code " of material system and design system, and then the electrical equipment material code data of transformer station's Digital Three-Dimensional electrical design system and state's net Company material system are integrated, generate the equipment and materials table with material code information, facilitate follow-up data recycle, designer uses transformer station Digital Three-Dimensional electrical design system to generate equipment list, comprises material coded message in inventory, like this, when carrying out bid for a project, and just can direct spent material coded message.
Accompanying drawing illustrates:
Fig. 1 is schematic diagram of the present invention;
Fig. 2 is schematic flow sheet of the present invention.
Embodiment:
The technological means realized to make the present invention, creation characteristic, reaching object and effect is easy to understand, below in conjunction with concrete diagram, setting forth the present invention further.
As shown in Figure 1: in conjunction with state's net Company material security of system sexual demand and data source operation convenience, the Middle Data Source using the Middle Data Source of Excel form to carry out data integration as state's net Company material system and transformer station's Digital Three-Dimensional design system is determined in the present invention, according to Data Update situation, state's net Company material system can divide version to derive the Middle Data Source of Excel form;
Material system stores material information data in structural data mode, take database as core, there is statistical conversion instrument electrical equipment-data can be exported to the data source of Excel form, electrical equipment information data with " material code " for unique index, electrical equipment information data comprises detailed device parameter information, be stored in " material is long to be described " row, " material is long to be described " data of equipment are uniquely corresponding with equipment material code;
The device parameter information that " material is long to be described " row store has specific rule, can extract easily and transform, use between distinct device parameter "; " separate, separate with ": " between parameter name and parameter values;
In transformer station's Digital Three-Dimensional electrical design system, device data is stored in standard device model storehouse, and when designing, designer selects the unit type needed to carry out finishing equipment Selection and Design from standard model storehouse;
In standard device model storehouse, electrical equipment-data is used as unique index with " unit type index ", have " AttributeText " row and carry out memory device parameter, it is uniquely corresponding with " unit type index " that " AttributeText " arranges the device parameter stored.The device parameter information stored has specific rule, can extract easily and transform, use between distinct device parameter "; " separate, separate with ": " between parameter name and parameter values;
In transformer station's Digital Three-Dimensional electrical design system, complete the design of main wiring diagram as shown in Figure 2 and complete the type selecting of electrical equipment, the parameter of electrical equipment is saved in the project database of electrical design system;
Software tool interface is selected the scope of synchronous material code, " current drawing ", " current volume " and " current engineering " three different scopes can be selected, software by automatic according to selected range query to needing to carry out the synchronous facility information of material code;
Software tool interface is selected the Excel material code data source of latest edition, and reads the data message in data source;
Software tool is with device parameter in project database for matching condition, and the value that in retrieval material code Excel data source, " material is long to be described " arranges, finds matched data;
If obtain the material code less than coupling, Software tool can provide prompting, and prompting designer checks that whether the design data of electrical design system is correct;
If successfully get the material code of equipment, then Software tool can by material code Data Update in the project database of electrical design system;
Generate with the electrical equipment material list of material code, material list can export as Excel file form, and this form can be supplied to follow-up system, is used for the material declaring work of finished item.
More than show and describe ultimate principle of the present invention, principal character and advantage of the present invention.The technician of the industry should understand; the present invention is not restricted to the described embodiments; what describe in above-described embodiment and instructions just illustrates principle of the present invention; without departing from the spirit and scope of the present invention; the present invention also has various changes and modifications, and these changes and improvements all fall in the claimed scope of the invention.Application claims protection domain is defined by appending claims and equivalent thereof.
Claims (1)
1. state's net ERP material device coding and application system, is characterized in that: comprise the following steps:
1) in transformer station's Digital Three-Dimensional electrical design system, complete the design of main wiring diagram and complete the type selecting of electrical equipment, the parameter of electrical equipment is saved in the project database of electrical design system;
2) on Software tool interface, select the scope of synchronous material code, " current drawing ", " current volume " and " current engineering " three different scopes can be selected, software by automatic according to selected range query to needing to carry out the synchronous facility information of material code;
3) on Software tool interface, select the Excel material code data source of latest edition, and read the data message in data source;
4) Software tool is with device parameter in project database for matching condition, and the value that in retrieval material code Excel data source, " material is long to be described " arranges, finds matched data;
5) if obtain the material code less than coupling, Software tool can provide prompting, and prompting designer checks that whether the design data of electrical design system is correct;
6) if successfully get the material code of equipment, then Software tool can by material code Data Update in the project database of electrical design system;
7) generate with the electrical equipment material list of material code, material list can export as Excel file form, and this form can be supplied to follow-up system, is used for the material declaring work of finished item.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510890743.5A CN105512392A (en) | 2015-12-03 | 2015-12-03 | State grid ERP material device coding and application system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510890743.5A CN105512392A (en) | 2015-12-03 | 2015-12-03 | State grid ERP material device coding and application system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105512392A true CN105512392A (en) | 2016-04-20 |
Family
ID=55720372
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510890743.5A Pending CN105512392A (en) | 2015-12-03 | 2015-12-03 | State grid ERP material device coding and application system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105512392A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106528512A (en) * | 2016-10-12 | 2017-03-22 | 国脉科技股份有限公司 | EXCEL preliminary budget table automatic compiling method |
| CN108764830A (en) * | 2018-05-18 | 2018-11-06 | 王建兵 | Civil air defense constructions and installations equipment quality relevant information acquisition analysis system |
| CN110096687A (en) * | 2019-05-10 | 2019-08-06 | 国网江苏省电力有限公司经济技术研究院 | Substation equipment summary of materials production method based on Three-dimensional Design Software |
| CN110837526A (en) * | 2019-11-14 | 2020-02-25 | 陕西航空电气有限责任公司 | Electronic component type selection method and system based on material information management platform |
| CN111581914A (en) * | 2020-04-29 | 2020-08-25 | 中通客车控股股份有限公司 | Linear steel part coding transmission system and method |
| WO2022253139A1 (en) * | 2021-06-04 | 2022-12-08 | 中兴通讯股份有限公司 | Matching method and apparatus, and computer readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101169804A (en) * | 2007-11-30 | 2008-04-30 | 北京数码大方科技有限公司 | Electronic drawing data recording method and system |
| CN102208067A (en) * | 2011-07-05 | 2011-10-05 | 广州视源电子科技有限公司 | Method and system for generating bill of material based on hardware circuit principle diagram |
| CN102298739A (en) * | 2011-08-19 | 2011-12-28 | 迈普通信技术股份有限公司 | Method for changing bill of materials (BOM) and apparatus thereof |
| KR20130044880A (en) * | 2011-10-25 | 2013-05-03 | 현대중공업 주식회사 | System for managing the amount of materials |
-
2015
- 2015-12-03 CN CN201510890743.5A patent/CN105512392A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101169804A (en) * | 2007-11-30 | 2008-04-30 | 北京数码大方科技有限公司 | Electronic drawing data recording method and system |
| CN102208067A (en) * | 2011-07-05 | 2011-10-05 | 广州视源电子科技有限公司 | Method and system for generating bill of material based on hardware circuit principle diagram |
| CN102298739A (en) * | 2011-08-19 | 2011-12-28 | 迈普通信技术股份有限公司 | Method for changing bill of materials (BOM) and apparatus thereof |
| KR20130044880A (en) * | 2011-10-25 | 2013-05-03 | 현대중공업 주식회사 | System for managing the amount of materials |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106528512A (en) * | 2016-10-12 | 2017-03-22 | 国脉科技股份有限公司 | EXCEL preliminary budget table automatic compiling method |
| CN106528512B (en) * | 2016-10-12 | 2019-05-21 | 国脉科技股份有限公司 | A kind of EXCEL preliminary budget table automatic editing method |
| CN108764830A (en) * | 2018-05-18 | 2018-11-06 | 王建兵 | Civil air defense constructions and installations equipment quality relevant information acquisition analysis system |
| CN110096687A (en) * | 2019-05-10 | 2019-08-06 | 国网江苏省电力有限公司经济技术研究院 | Substation equipment summary of materials production method based on Three-dimensional Design Software |
| CN110837526A (en) * | 2019-11-14 | 2020-02-25 | 陕西航空电气有限责任公司 | Electronic component type selection method and system based on material information management platform |
| CN111581914A (en) * | 2020-04-29 | 2020-08-25 | 中通客车控股股份有限公司 | Linear steel part coding transmission system and method |
| CN111581914B (en) * | 2020-04-29 | 2023-07-14 | 中通客车股份有限公司 | Linear steel part coding transmission system and method |
| WO2022253139A1 (en) * | 2021-06-04 | 2022-12-08 | 中兴通讯股份有限公司 | Matching method and apparatus, and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105512392A (en) | State grid ERP material device coding and application system | |
| CN102622463A (en) | Drawing-model uniformity based method for automatic check of design drawings | |
| CN103577611A (en) | Data unifying device and data unifying method | |
| CN104461649B (en) | chip compatible method and device | |
| CN107368621B (en) | Method for generating CAD format two-dimensional standard three-view by three-dimensional support model in PDMS | |
| CN105447253A (en) | Three-dimensional process data integration method | |
| CN102609520A (en) | Method for exporting model data of substation by filtering | |
| CN102857949B (en) | A kind of method and apparatus that layout data consistency guarantees | |
| CN104008485A (en) | Intelligent order generation device and method | |
| CN102880748A (en) | Method for automatically drawing electric diagrams | |
| CN104158679A (en) | Apparatus for setting network of decentralized Profibus peripheral devices | |
| CN112397210B (en) | Digital design system, method and equipment for nuclear power plant control system of database | |
| CN113094932A (en) | Method, device, equipment and storage medium for acquiring construction cost of power transformation project | |
| CN104572153A (en) | Update data conversion method for vehicle updating | |
| CN105868196A (en) | Method for generating industrial data report in server | |
| CN105760272A (en) | Monitoring background service customization method based on plug-in and system based on method | |
| CN103034703A (en) | Method for data exchange among multiple systems based on rule configuration | |
| CN106021344A (en) | A multi-adaptive CIME power grid model sharing method | |
| CN103942280A (en) | Automatic code generating method based on data structure | |
| US20140095550A1 (en) | Converting source objects to target objects | |
| CN109274742A (en) | A kind of internet of things data acquisition and supervisor control | |
| CN102855305A (en) | Data upgrading method and device | |
| CN103268568A (en) | Method for determining relay protection device definite value by utilizing formula editor self-defined template | |
| CN109740223B (en) | Auxiliary drawing method for direct-current power supply system of transformer substation | |
| CN104484640A (en) | Method of two-dimension code reading end for managing number of reading times of current two-dimension code |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160420 |
|
| RJ01 | Rejection of invention patent application after publication |