This paper comprehensively analyzes the various standard parts information involved in the establishment of the standard parts library, and proposes a corresponding general storage method for each type of information. Based on this, a three-dimensional standard parts library building tool in a network environment is discussed. The system - NPUPart, studied the overall structure of the NPUPart and analyzed the key technologies realized by the system. In the national standard for information analysis of standard parts, the information of standard parts includes the following five parts: (1) the subject matter explains the content of the standard (2) the reference standard describes the standard number (3) quoted by the standard. This part includes two aspects. The content, the geometric shape, describes the geometry of the standard parts; the second is the size information, using a table to illustrate the geometric dimensions of the various parts of the standard specified by the standard. (4) Technical conditions This section explains Information on the material of the part, heat treatment, etc. (5) Marking This section explains how to mark the part of the standard parts library system. The most important content is: size, technical conditions and marking. Dimensional information is used to create standard part geometry models (3D or 2D) in CAD systems. Technical conditions and markings are additional information for standard parts. They are generally used for BOM creation and standard part information query. Dimensional information in the size table information standard is generally given in tabular form, which is easily mapped to a table in a relational database. In fact, most standard parts systems store size information in the form of tables in the database. When storing, a size information table is usually directly mapped into a database table, and each parameter in the size information table is mapped into a field of the database table. This method can only save the main information of the size information table, and cannot save the complete size information. The main reasons are as follows: (1) The field type provided by the relational database cannot meet the needs of the parameter type. The field types provided by relational databases generally include integers, floats, characters, etc. These types can satisfy the needs for most parameters, but for a few special types of parameters, the full parameter meaning cannot be preserved. Generally, floating-point fields are used. Storage, that is, only the basic size is retained, and the deviation information is ignored. (2) A single database table cannot explain the relationship between parameters. One of the characteristics of a relational database system is that the fields of the table are independent. However, there are some parameters in the dimension table. For example, the nominal diameter of the parameters in Table 2, K and the number No have the order of selection. In addition, the number of parameters specified by different standard numbers and the type of each parameter are not necessarily the same, so the storage structure of the size data cannot be determined in advance, that is, the database table structure that is not common for the size data can be used, and must be specified for different standard numbers. Size data Customize the data table structure. The data tables in the existing standard parts system are generally manually created in advance. This brings difficulties to the scalability of the standard parts library system. For the problem, this paper adopts the method of establishing the intermediate conversion layer between the database field type and the parameter type, so that the indirect mapping relationship between the parameter type and the database field type is established, so that the size can be saved in the database; the conversion layer is also responsible for the database. Two-way interpretation conversion between data and parameter data. In this paper, the types of parameters appearing in the standard are divided into: primary key type, single value type, value range type, with deviation type, series type, associative series type and expression type, etc. The conversion layer provides for each parameter type. Fixed storage methods and data interpretation methods. For example, the parameter with deviation is mapped to a character field. For data with a basic size of "1.5" and the upper and lower deviations are "+0.010" and "0", the data can be stored with the string "1.50.0100"; when reading data, The data can be interpreted by dividing the string by space. When the parameter type is expanded, only the corresponding parameter storage method and interpretation mechanism need to be added in the conversion layer. In addition, the data entered by the user can be analyzed and checked through the conversion layer. Aluminum die casting housing for LED Light frame parts Led Street Lights Led Street Lights,Solar Led Street Lights,Colorful Led Bulb,Solar Led Street Dongguan Hongge Hardware Technology Co., Ltd , http://www.honggecasting.com
Colorful Led Bulb We have two colors,black and gold,the quality is good,the product is firm
Production flow:
samples → mould making →die casting and other processes →get samples and send samples to customer for confirm → mass production (casual inspection avoid unintentional situation) → QC → packing →shipping →cycle to next order
Our Secondary processes:
Solar Led Street Lights Various in-house and contracted secondary processes including shot-blast, vibratory deburr, heat treating, sanding, ball burnishing, impregnation, rubberizing, polish, buffing, painting, anodizing, and plating.