CN112347117A - Method and system for realizing PCB design resource sharing based on ERP system - Google Patents
Method and system for realizing PCB design resource sharing based on ERP system Download PDFInfo
- Publication number
- CN112347117A CN112347117A CN202011382986.5A CN202011382986A CN112347117A CN 112347117 A CN112347117 A CN 112347117A CN 202011382986 A CN202011382986 A CN 202011382986A CN 112347117 A CN112347117 A CN 112347117A
- Authority
- CN
- China
- Prior art keywords
- file
- dblib
- erp
- pcb
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F16/275—Synchronous replication
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Marketing (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Computer Security & Cryptography (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Computing Systems (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention discloses a method and a system for realizing PCB design resource sharing based on an ERP system, which utilize an AD software Dblib library and the ERP system to share a raw material database, realize the consistency and synchronous updating of PCB component parameter information and ERP raw material parameter information, and call the Dblib library through AD software to realize the purpose of resource sharing with the ERP system. When a hardware engineer designs a circuit by using AD software, the dynamic information of Dblib library components can be checked in real time, and the invention has the advantages that: the system can help a hardware designer to check the material stock in real time, fully utilize the material stock and reduce the material stagnation rate; the ERP raw material library and the PCB component library are managed and maintained in a unified mode, the consistency of circuit design styles is guaranteed, the readability and the transportability of circuits are improved, and the labor cost is reduced; the circuit design and model selection efficiency of a hardware engineer is improved; communication and purchase error cost caused by inconsistent description of the component information is reduced; the ERP raw material library can be accessed without installing an ERP system client and ERP accounts, so that the number of the ERP accounts is saved, and the cost of an enterprise is saved.
Description
Technical Field
The embodiment of the invention relates to the technical field of electronic information, in particular to a method and a system for realizing PCB design resource sharing based on an ERP system.
Background
At present, when enterprises are in such a fierce competition, the boss of each enterprise wants to fully utilize the existing raw material inventory so as to save cost and avoid waste. The inventory fund of an Enterprise accounts for a large part, and although the inventory condition of raw materials can be monitored in real time through the management of an ERP (Enterprise Resource Planning) system, if the inventory condition of the raw materials is preferred, a hardware engineer needs to know the inventory condition of the raw materials in real time to fully utilize the inventory condition, so that the stay rate of the materials is reduced, the stock shortage or new raw materials are prepared and purchased in advance, and the research and development progress of products is accelerated.
The existing ERP system raw material library and the PCB component library of an enterprise are independently input and maintained, cannot be kept synchronous with a material management system of the enterprise in real time, information in a research and development material packaging library is often updated, information of the material management system is not updated, purchased materials are inconsistent with research and development designed materials, and when BOM is finally generated, the purchased materials and the information in the ERP raw material library are required to be re-checked and input. When a hardware designer designs a circuit to select components, the hardware designer independently searches and searches on the internet in an ERP (enterprise resource planning) raw material library, even if the used materials are not recorded into a system and are not arranged in time, the data are checked again, and a large amount of time is wasted. If the project schedule is urgent, many hardware engineers simply do not remove the kernel data, and the final product has more problems by directly depending on experience and utilizing the previous circuit. Technical data, material information and design results cannot be inherited, each person or each department has a set of design library and designed circuit drawing, and due to incomplete parameter information, readability is poor, transplanting is difficult, and great management difficulty is brought to technical managers.
Disclosure of Invention
Therefore, the embodiment of the invention provides a method and a system for realizing PCB design resource sharing based on an ERP system, which are used for solving the problems that when the circuit design is used for component selection, information parameters of a material packaging library for research and development and an enterprise material management system are asynchronous, so that purchased materials are inconsistent with the materials for research and development and design, the cost of data checking time is high, the circuit design efficiency is low, and the technical management difficulty is high.
In order to achieve the above object, the embodiments of the present invention provide the following technical solutions:
according to a first aspect of the embodiments of the present invention, a method for implementing PCB design resource sharing based on an ERP system is provided, where the method includes:
deploying an ERP system at a server side, wherein the ERP system provides a raw material database;
inputting material parameter information into the ERP system, maintaining the material parameter information, and automatically generating a raw material database file;
inputting and maintaining a PCB component library file at a server side, wherein the PCB component library file comprises SchLib, PcbLib and DbLib files;
the AD software is opened at a client, and the automatic binding of the DbLib file link raw material database and the DbLib file with the SchLib file and the PcbLib file is configured;
the AD software is opened at the client, and the DbLib file stored at the server is loaded into a library manager;
and calling the DbLib file at the client to design the PCB, and selecting components from the DbLib library to complete resource sharing, wherein the components have material parameter information consistent with that in the raw material database.
Further, the material parameter information includes enterprise interested parameters such as material name, material number, specification description, model, manufacturer, SCH symbol, PCB package, SCH symbol path, PCB package path, inventory quantity, Datasheet, design case, device status, shelf life, supplier, price, etc.
Further, the ERP system adopts an SAP system.
Further, the method further comprises:
and setting user information and user authority for accessing the server.
According to a second aspect of the embodiments of the present invention, there is provided a system for implementing a method for sharing PCB design resources based on an ERP system as described in any one of the above, where the system includes the server and a plurality of clients connected via a network;
the server side includes:
the ERP deployment module is used for deploying an ERP system at a server side, and the ERP system provides a raw material database;
the material information input module is used for inputting material parameter information into the ERP system, maintaining the material parameter information and automatically generating a raw material database file;
the PCB component library file entry module is used for entering and maintaining a PCB component library file at a server side, wherein the PCB component library file comprises SchLib, PcbLib and DbLib files;
the DbLib file storage module is used for storing the configured DbLib file at the Server side, and the DbLib file is configured by opening AD software at the client side, so that the DbLib file automatically binds an SQL Server raw material database, a SchLib file and a PcbLib file;
the client comprises:
the DbLib file loading module is used for opening AD software at a client and loading the DbLib file stored at a server into a library manager;
and the resource sharing module is used for calling the DbLib file at the client to design the PCB, selecting components from the DbLib library to complete resource sharing, and the components have material parameter information consistent with that in the raw material database at the moment.
The embodiment of the invention has the following advantages:
according to the method and the system for realizing the sharing of the PCB design resources based on the ERP system, disclosed by the embodiment of the invention, the AD software Dblib library and the ERP system are used for sharing the raw material database, so that the parameter information of the PCB components and the parameter information of the ERP raw materials are consistent and are kept to be updated synchronously, and the Dblib library is called through AD to realize the purpose of sharing the resources with the ERP system. The invention has the advantages that the invention can help a hardware designer to check the material inventory in real time, reduce the stay rate of materials, carry out advance stock and purchase on new raw materials or replenishment to ensure the correctness of circuit design, and inherit and fully utilize the technical achievements of enterprises; the ERP raw material library and the PCB component library are managed and maintained in a unified mode, the consistency of circuit design styles is guaranteed, the readability and the transportability of circuits are improved, and the human redundancy cost caused by separate management or private management of each department is avoided; the circuit design and model selection efficiency of a hardware designer is improved; communication and purchase error cost caused by inconsistent description of the component information is reduced; the ERP raw material library can be accessed without installing an ERP system client and ERP accounts, so that the number of the ERP accounts is saved, and the cost of an enterprise is saved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below. It should be apparent that the drawings in the following description are merely exemplary, and that other embodiments can be derived from the drawings provided by those of ordinary skill in the art without inventive effort.
Fig. 1 is a schematic flowchart of a method for implementing PCB design resource sharing based on an ERP system according to embodiment 1 of the present invention;
fig. 2 is an operation schematic diagram of a method for implementing PCB design resource sharing based on an ERP system according to embodiment 1 of the present invention;
fig. 3 is a schematic diagram of material parameter information in a method for implementing PCB design resource sharing based on an ERP system according to embodiment 1 of the present invention;
fig. 4 is a schematic view of a topology structure for implementing a PCB design resource sharing system based on an ERP system according to embodiment 1 of the present invention;
fig. 5 is a schematic structural diagram of a system for implementing PCB design resource sharing based on an ERP system according to embodiment 1 of the present invention.
Detailed Description
The present invention is described in terms of particular embodiments, other advantages and features of the invention will become apparent to those skilled in the art from the following disclosure, and it is to be understood that the described embodiments are merely exemplary of the invention and that it is not intended to limit the invention to the particular embodiments disclosed. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
and S110, deploying an ERP system at the server side, wherein the ERP system provides a raw material database.
An ERP (enterprise Resource planning) system is a short term for enterprise Resource planning, and is a management platform which is established on the basis of information technology, integrates the information technology and advanced management ideas, and provides decision means for enterprise employees and decision layers by using a systematized management idea. The system is a new generation of integrated management information system developed from MRP (material demand planning), expands the functions of MRP and has the core idea of supply chain management. It breaks the traditional enterprise boundary and optimizes the resources of the enterprise from the supply chain scope.
SAP (Germany) system, Oracle (USA) are commonly used in ERP system; the ERP systems of the domestic user friend, the golden butterfly, the Dingjie, the forward navigation and the like can directly or secondarily develop the conversion module to realize the invention.
The ERP system in the embodiment of the invention adopts an SAP system and provides an SQL Server database or other database formats supported by AD.
And S120, inputting and maintaining material parameter information in the ERP system, and automatically generating a raw material database file.
All raw material information is accurately input and maintained in an SAP raw material library according to a certain rule, and specifically, as shown in FIG. 3, the material parameter information comprises enterprise interested parameters such as material name, material number, specification description, model, manufacturer, SCH symbol (consistent with the name in SchLib), PCB packaging (consistent with the name in PcbLib), SCH symbol path, PCB packaging path, inventory quantity, Datasheet, design case, device state, shelf life, supplier, price and the like. After the input is finished, the SAP system automatically generates and updates the SQL Server database.
And S130, inputting and maintaining a PCB component library file at the server side, wherein the PCB component library file comprises SchLib, PcbLib and DbLib files.
The DbLib is one of AD various types of libraries, is called Database Library, and has the idea that a Database (table) is used as a core, and data entries are associated with corresponding schematic diagram symbols and PCB packaging, namely the schematic diagram symbols (or PCB packaging symbols) of a general device can correspond to materials of various types. Such as a resistor symbol, can correspond to a plurality of models. User information and user authority for accessing the server can be set, and users with corresponding authority are allowed to perform corresponding operations. The SchLib, PcbLib and DbLib files can be stored on a server, and the three files can be stored on any storage device according to needs.
S140, opening AD software at the client, and configuring automatic binding of the DbLib file link raw material database and the DbLib file with the SchLib file and the PcbLib file.
In this embodiment, the PCB design software adopts AD software, and additionally, design software such as cadence and PADS can also replace the function realized by the AD software of the present invention.
The DbLib file can be configured through the client with the authority and stored at the server, and during specific application, the client with the access authority can access the server, find the stored DbLib library and then open the DbLib library by AD software.
S150, opening AD software at the client, and loading the DbLib file stored at the server into the library manager.
User information and user authority for accessing the server can be set, and users with corresponding authority are allowed to perform corresponding operations. After steps S110 to S140 are completed, for the local computer client, only the AD software needs to be opened, and the DbLib library is loaded, so as to perform online operation on the components in the DbLib library, where the device parameter information in the DbLib library is information in an ERP raw material library (such as SAP).
And S160, calling the DbLib file at the client to design the PCB, and selecting components from the DbLib library to complete resource sharing, wherein the components have material parameter information consistent with that in the raw material database.
And (3) resource sharing operation, the AD software can directly check the information in the Dblib, and can also perform operations such as information parameter filtering, sorting according to each parameter keyword, parameter increasing and the like.
Patents for implementing the method by only modifying a specific ERP system or a system pdm (product Data management) with similar ERP functions and PCB EDA design software (such as PADS, cadence, etc.) are all included in the protection scope of the present invention.
The enterprise realizes parameter information sharing of an ERP raw material library and a PCB component library by using an AD software Dblib library, and the information of the Dblib library and the material information of the ERP system keep real-time synchronization. When the AD is used for designing the circuit, a hardware engineer can synchronously check the parameter information of the device, so that the aim of sharing resources with an ERP system is fulfilled; when the mature circuit is shifted and reused, the AD software menu command is clicked to keep synchronization with an ERP system Database, and the operation of the AD software menu command can finish the updating of all device parameters by executing the Tools > > UpdateParameter From Database command in a schematic diagram editing environment. By executing the Tools > > Update From Libraries command in the schematic editing environment, complete updating of all devices, including parameters, models, packaging, schematic symbols, etc., can be accomplished.
Corresponding to the above embodiment 1, embodiment 2 of the present invention proposes a system for implementing any one of the above methods for sharing PCB design resources based on an ERP system, and as shown in fig. 4 and 5, the system includes a server 200 and a plurality of clients 300 (local computers) connected via a network;
the server 200 includes:
the ERP deployment module 210 is configured to deploy an ERP system on a server side, where the ERP system provides a raw material database;
the material information input module 220 is used for inputting material parameter information into the ERP system, maintaining the material parameter information and automatically generating a raw material database file;
a PCB library file entry module 230, configured to enter and maintain a PCB library file at a server, where the PCB library file includes SchLib, pcbllb, and DbLib files;
the DbLib file storage module 240 is used for storing the configured DbLib file at the Server side, and the DbLib file is configured by opening AD software at the client side, so that the DbLib file automatically binds an SQL Server raw material database, a Schlib file and a Pcblib file;
the client 300 includes:
the DbLib file loading module 310 is configured to open AD software at a client, and load a DbLib file stored at a server into a library manager;
and the resource sharing module 320 is used for calling the DbLib file at the client to design the PCB, selecting components from the DbLib library to complete resource sharing, wherein the components have material parameter information consistent with that in the raw material database.
The functions performed by each component in the system for implementing resource sharing of PCB design based on the ERP system according to the embodiment of the present invention have been described in detail in embodiment 1, and therefore, are not described in detail herein.
Although the invention has been described in detail above with reference to a general description and specific examples, it will be apparent to one skilled in the art that modifications or improvements may be made thereto based on the invention. Accordingly, such modifications and improvements are intended to be within the scope of the invention as claimed.
Claims (5)
1. A method for realizing PCB design resource sharing based on an ERP system is characterized by comprising the following steps:
deploying an ERP system at a server side, wherein the ERP system provides a raw material database;
inputting material parameter information into the ERP system, maintaining the material parameter information, and automatically generating a raw material database file;
inputting and maintaining a PCB component library file at a server side, wherein the PCB component library file comprises SchLib, PcbLib and DbLib files;
the AD software is opened at a client, and the automatic binding of the DbLib file link raw material database and the DbLib file with the SchLib file and the PcbLib file is configured;
the AD software is opened at the client, and the DbLib file stored at the server is loaded into a library manager;
and calling the DbLib file at the client to design the PCB, and selecting components from the DbLib library to complete resource sharing, wherein the components have material parameter information consistent with that in the raw material database.
2. The method for realizing PCB design resource sharing based on the ERP system as claimed in claim 1, wherein the material parameter information includes enterprise-interested parameters such as material name, material number, specification description, model, manufacturer, SCH symbol, PCB package, SCH symbol path, PCB package path, inventory quantity, Datashet, design case, device status, shelf life, supplier, price, etc.
3. The method for realizing PCB design resource sharing based on ERP system as claimed in claim 1, wherein the ERP system employs SAP system.
4. The method for implementing PCB design resource sharing based on ERP system as claimed in claim 1, wherein the method further comprises:
and setting user information and user authority for accessing the server.
5. A system for implementing the method for sharing PCB design resources based on the ERP system according to any one of claims 1 to 4, wherein the system comprises the server and a plurality of the clients connected through a network;
the server side includes:
the ERP deployment module is used for deploying an ERP system at a server side, and the ERP system provides a raw material database;
the material information input module is used for inputting material parameter information into the ERP system, maintaining the material parameter information and automatically generating a raw material database file;
the PCB component library file entry module is used for entering and maintaining a PCB component library file at a server side, wherein the PCB component library file comprises SchLib, PcbLib and DbLib files;
the DbLib file storage module is used for storing the configured DbLib file at the Server side, and the DbLib file is configured by opening AD software at the client side, so that the DbLib file automatically binds an SQL Server raw material database, a SchLib file and a PcbLib file;
the client comprises:
the DbLib file loading module is used for opening AD software at a client and loading the DbLib file stored at a server into a library manager;
and the resource sharing module is used for calling the DbLib file at the client to design the PCB, selecting components from the DbLib library to complete resource sharing, and the components have material parameter information consistent with that in the raw material database at the moment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011382986.5A CN112347117A (en) | 2020-12-01 | 2020-12-01 | Method and system for realizing PCB design resource sharing based on ERP system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011382986.5A CN112347117A (en) | 2020-12-01 | 2020-12-01 | Method and system for realizing PCB design resource sharing based on ERP system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112347117A true CN112347117A (en) | 2021-02-09 |
Family
ID=74427167
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011382986.5A Pending CN112347117A (en) | 2020-12-01 | 2020-12-01 | Method and system for realizing PCB design resource sharing based on ERP system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112347117A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113573477A (en) * | 2021-06-21 | 2021-10-29 | 广州添利电子科技有限公司 | PCB (printed Circuit Board) manufacturing indication method, production coefficient generation method, pre-expansion system, medium and equipment |
| CN117474504A (en) * | 2023-12-28 | 2024-01-30 | 广东美创希科技有限公司 | Device information management method, device, electronic equipment and medium |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111507056A (en) * | 2020-04-17 | 2020-08-07 | 成都寰蓉光电科技有限公司 | PCB design method and system for realizing component management and sharing |
-
2020
- 2020-12-01 CN CN202011382986.5A patent/CN112347117A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111507056A (en) * | 2020-04-17 | 2020-08-07 | 成都寰蓉光电科技有限公司 | PCB design method and system for realizing component management and sharing |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113573477A (en) * | 2021-06-21 | 2021-10-29 | 广州添利电子科技有限公司 | PCB (printed Circuit Board) manufacturing indication method, production coefficient generation method, pre-expansion system, medium and equipment |
| CN117474504A (en) * | 2023-12-28 | 2024-01-30 | 广东美创希科技有限公司 | Device information management method, device, electronic equipment and medium |
| CN117474504B (en) * | 2023-12-28 | 2024-05-10 | 广东美创希科技有限公司 | Device information management method, device, electronic equipment and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102236672B (en) | A kind of data lead-in method and device | |
| CN107193545B (en) | Component-oriented multi-language collaborative development device, method and system | |
| US8312419B2 (en) | Automated lifecycle management of a computer implemented service | |
| Hallerbach et al. | Context-based configuration of process variants | |
| KR102237877B1 (en) | Intelligent software auto development system with real-time collaboration support and method thereof | |
| US20100114618A1 (en) | Management of Variants of Model of Service | |
| US20110004564A1 (en) | Model Based Deployment Of Computer Based Business Process On Dedicated Hardware | |
| US20100110933A1 (en) | Change Management of Model of Service | |
| CN112347117A (en) | Method and system for realizing PCB design resource sharing based on ERP system | |
| Capilla et al. | An enhanced architectural knowledge metamodel linking architectural design decisions to other artifacts in the software engineering lifecycle | |
| CN102799709B (en) | System simulation test environment building and configuring system and method based on extensive markup language (XML) | |
| CN103744647A (en) | Java workflow development system and method based on workflow GPD | |
| CN102203767A (en) | Reconfiguring a model | |
| CN112347084A (en) | Intelligent PCB BOM generation method and system | |
| CN109656528A (en) | Measured modularization software development methodology | |
| CN115480810A (en) | Low-code platform based on cloud protogenesis | |
| CN104850925A (en) | Integrated management system for process data | |
| CN111930354A (en) | Framework component for software development and construction method thereof | |
| CN109840074A (en) | A kind of business generating method, device and the network equipment | |
| CN102609266A (en) | Flex-based rich client platform system and operation method therefor | |
| CN112100984A (en) | Data conversion method and system from EBOM to SBOM | |
| Tirpak | Design-to-manufacturing information management for electronics assembly | |
| CN115951970A (en) | Heterogeneous multi-simulation software integrated development environment | |
| CN115827051A (en) | Software integration management system, method and server | |
| CN101937361A (en) | Method and device for establishing and managing simulation subsystem |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210209 |