Unlock instant, AI-driven research and patent intelligence for your innovation.

BOM automatic arrangement method based on C#

A technology for automatic sorting and sorting of tables, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of unreliable manual sorting, long sorting time, manual BOM tables, etc., to improve efficiency and reduce work. quantity, and the effect of improving reliability

Inactive Publication Date: 2019-11-19
SICHUAN CHANGHONG ELECTRIC CO LTD
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to provide a kind of BOM automatic sorting method based on C#, solve the deficiency that the existing BOM table sorting mainly relies on manual work, use the c# programming language programming to the BOM that PCB derives in the sorting process at the same time, each sorted out The data is stored in an array. When all the materials are sorted according to the requirements, they are written back to the EXCEL table, which solves the problem of unreliable manual sorting and long time for sorting directly in EXCEL

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0055] The embodiment of the present invention is based on the BOM automatic sorting method of C# when concrete application, comprises the following steps:

[0056] 1. Use the PCB design tool, execute the script, select the field names that need to export the BOM, which are NAME, VALUE, DECAL, MODEL, CODE, and get the sorted BOM source data table.

[0057] 2. Use the C# language to write the console program, put the BOM source data table into the specified directory of the program project, and start the program to start the automatic finishing work.

[0058] 3. Create a new table and copy the source BOM data to the table, delete the data items of irrelevant materials in the BOM source data table, and save the rows with invalid data to the two-dimensional array array 1.

[0059] 4. Compare the data of rows and rows, merge the same VALUE, DECAL, MODEL, and CODE items in the two rows, and generate a new title column number and quantity, separate the merged NAME with commas, and p...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a BOM automatic arrangement method based on C#, and belongs to the field of circuit design. The key points of the technical scheme are as follows: a script file is executed based on a PCB design tool; after the exported field prototype is selected, a BOM source data table is exported, meanwhile, a console arrangement program is compiled based on the C# programming language,the data arranged in each step is stored in an array mode, the data is written into the arrangement table through a DLL interface, and finally BOM arrangement work is achieved. According to the invention, the defect that the existing BOM table arrangement mainly depends on manpower is overcome; meanwhile, a c # programming language is used for programming the BOM exported by the PCB in the arrangement process. According to the method, the sorted data is stored by the array, and after all materials are sorted according to requirements, the sorted data is written back to the EXCEL table in a unified manner, so that the problems of unreliability of manual sorting and long sorting time in EXCEL are solved.

Description

technical field [0001] The invention relates to circuit design technology, in particular to a method for automatically sorting out BOMs based on C#. Background technique [0002] As the number and types of materials used on the PCB increase, hardware developers need to sort out more. When the quantity is a few and the types are few, it can be done in a few minutes, but when the quantity is large and there are many kinds of materials, the hardware developers may spend a few days to sort them out, and there is no guarantee correctness. At this time, an automatic sorting solution is urgently needed to solve this problem. Contents of the invention [0003] The purpose of the present invention is to provide a kind of BOM automatic sorting method based on C#, solve the deficiency that the existing BOM table sorting mainly relies on manual work, use the c# programming language programming to the BOM that PCB derives in the sorting process at the same time, each sorted out The ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F8/30G06F17/50
CPCG06F8/315
Inventor 周林张强
Owner SICHUAN CHANGHONG ELECTRIC CO LTD