In this paper, the design parameters of the first case are used, and the latter is directly expressed by the relational expression without setting the parameters. At the same time, the relationship between design parameters and 3D model size variables must be correctly established. Only in this way can the user interact with the design parameters, use the Pro/Toolkit function to transfer the design parameter changes to the 3D model size variables, and finally implement the model update to generate a new model. It is worth noting that the name of each design parameter is as good as the standard part manual (not case sensitive), so that the meaning of the parameter can be clearly understood even if it is not indicated.
The establishment of the general data table structure uses SQLSERVER2000 to establish a standard parts library, which is used to store the size control parameter names, numbers, parameter values, standard part names, country labels, materials and other important information of various standard parts. The standard parts can be divided into the following hierarchy according to the type of standard parts, as shown in 1. To do this, you need to create three tables: Protype, Product, and Part.
The Protype table stores the category information of the standard parts. The fields are TypeId (category number), TypeName (category name) and UpperId (upper category number). This table has a tree structure and is more suitable for display by a tree control, as shown in 2. The structure of the classification tree is adopted to facilitate the quick search of standard parts.
Access and operation of SQLSERVER2000 database In this topic, two ways to access SQLSERVER2000 database: (1) use ADODATA control and DATAGrid control and other common database access control, this method is relatively simple, just simple configuration; 2) Design and use a special connection database class ADOConn, which contains the code to connect to the database, can perform Select, Update, Insert and Delete operations on the database. It is worth noting that if there are ActiveX controls such as ADOData and DataGrid in the dialog box, you need to use the entry function extern "C".
The algorithm flow of adding new standard parts and the algorithm of various specifications below. (1) Whether the superior category of this standard part exists, if it exists, turn (2); otherwise, turn (4); (2) Enter the number, national standard, standard part name and other information. If it meets the specifications, go to (3); otherwise, re-enter it until it is correct; (3) Create or open a reference part model with parameters set, and call ParamsGet() function to get All parameter objects (except those that have been filtered in the filter function), fill in the name and number of these parameters, and just the input information and the superior category number to the corresponding fields of the new record in the Product table, the path of the reference model file and The content is also saved to the pathname and part fields respectively. If there is a gesture or preview, save it to the photo field and complete the new operation; (4) Add the corresponding record in the Protype table. For example, if the category of bolts does not exist, add a record (12, bolt, 1) to the Protype table, 12 is the number of the bolt, and 1 is the number of the upper fastener of the bolt. Then, turn (2).
The algorithm flow of various standard parts under the standard parts is added. (1) Whether the standard part exists in the Product table, if it exists, turn (2); otherwise, the operation of the above new standard parts is performed, and then (2); (2) Read the record in the Product table. If the photo field contains preview or indication information, it will be displayed in the interactive interface to facilitate the user to understand the meaning of the parameter name; (3) for the field pname0, pname1... The parameter names are assigned to the corresponding parameter values ​​value0, value1..., the number of parameters is the content of the num field; (4) the file path of the reference model represented by the pathname field is opened, if successful, turn (4); otherwise, turn (6) (5) With the parameter name and the corresponding parameter value, it is easy to update the parameter value of each parameter object, generate the required specification part, turn (6); if the generation fails, check whether the parameter is correct, turn (3); 6) Add the corresponding record in the Part table, where value0, value1...must correctly fill in the pvalue0, pvalue1... fields in order, thus ensuring the parameter name in the Product table and the parameter value in the Part table. If the generated specification part is saved, the pathname field is updated to the corresponding save path and ends; (7) according to the information saved in the part field, restore the base model and open it, and turn it (5).
In this paper, we use the above algorithm to successfully add various standard parts and the following specification parts to the parts library, which is convenient to realize the expansion of the parts library. Many of the standard parts in 2 and many of the standard parts in 3 were added using this algorithm.
Conclusion This paper discusses the establishment of a general data table structure in SQLSERVER2000 to store different types of standard part parameter names and parameter values, which can not only achieve parametric modeling, but also solve the problem of difficult expansion of standard parts library in the existing methods. problem. Using this technology, a standard parts library was established for the Tangshan Locomotive and Rolling Stock Factory and achieved good results.
Ultra Plantâ„¢ Grow Light offers One Chip Technology aimed to meet your indoor growing expectation such as improve plants' quality, increase yield, or better the margin, etc., all for helping you realize a higher return on your crops.
Ultra Plantâ„¢ Grow Light is combined our advanced All-In-One technology with patented optical design and customized light full spectrum supported from our experienced LED engineers, plant specialists and other partners working on horticulture.
From Ultra Plantâ„¢ APP, you are able to schedule the growing process including photoperiod, brightness and spectral in advance. The lighting system will help you grow smarter, easier and better.
Ultra Plantâ„¢ is the most versatile horticultural grow lighting fixture for indoor plants with flexible full spectrum, brightness control and uniform, wider light distribution, suitable for top lighting of all types of crops. No matter it applies to anywhere for any crop, Ultra Plantâ„¢ can do perfect work for you.
Full Spectrum Grow Light,Full Spectrum Led,Led Cob Full Spectrum,Best Full Spectrum Led Grow Lights
Feton Corporation , https://www.ultraplantgrowlights.com