Method for displaying manually generated BOM table based on double Listview

Abstract

The application discloses a method for displaying a manually generated BOM table based on double Listviews, which comprises a first user interface component and a second user interface component, the first user interface component and the second user interface component contain Listview controls and button controls, the first user interface component comprises part information and product information, and the product information of the first user interface component provides parent item information basis for generation of the second user interface component. The application selects product information on the first user interface component to generate the second user interface component, selects part information on the first user interface component, adds part information used for producing products to the second user interface component, and thus facilitates collection of information of products and parts, is not prone to errors, and is convenient for searching, checking and determining part information required for generating a BOM, and the generation efficiency of the BOM table is improved.

Description

TECHNICAL FIELD

[0001] The present application relates to warehouse management and production information technology field, specifically to a method for generating BOM table based on double Listview display. BACKGROUND

[0002] BOM refers to a bill of materials, which is a document or data table that records all the raw materials, parts, subassemblies and their quantities, input processes and other information required for a product. BOM plays a crucial role in MES system, mainly used for production planning and scheduling, inventory management, cost control and quality management, etc.

[0003] The traditional BOM generation method is to find and select the product (parent item) and subassembly (child item) of BOM through ComboBox (drop-down box / combo box). In the case of a large number of product and component varieties, the operation is cumbersome, inefficient and prone to errors. SUMMARY

[0004] The purpose of the present application is to provide a method for generating BOM table based on double Listview display, design a first user interface component and a second user interface component, display two controls at the same time, display the data of the warehouse management system on the first user interface component, select the parts on the first user interface component by using the interaction of the two controls, add the part information used by the production product to the second user interface component, facilitate the collection of product and part information, reduce the error, and also facilitate the search, view and determination of the part information required for generating BOM, thereby improving the generation efficiency of BOM table.

[0005] The present application provides the following technical scheme: a method for generating BOM table based on double Listview display, comprising a first user interface component and a second user interface component, the first user interface component and the second user interface component comprising Listview control and button control, the first user interface component comprising part information and product information, the product information of the first user interface component providing parent item information basis for the generation of the second user interface component, the second user interface component being generated after selecting a product in the first user interface component, the part information in the first user interface component providing information basis for information filling of the second user interface component, the part information and the product information being displayed in the Listview control;

[0006] The generation steps of the BOM table are as follows:

[0007] S1, open the first user interface component, and display the data of the warehouse management system in the Listview control of the first user interface component;

[0008] S2, selecting product information in the first user interface component, triggering the BOM parent item confirmation control, generating a second user interface component with the product information as the parent item according to the product information;

[0009] S3, selecting the part information for producing the product in the first user interface component, triggering the BOM information confirmation control, and adding the part information in the first user interface component to the Listview control of the second user interface component one by one;

[0010] S4, confirming the part information in the Listview control of the second user interface component, triggering the BOM table upload control, uploading the information in the Listview control of the second user interface component, and generating the BOM table corresponding to the product production.

[0011] The first user interface component also includes a picture display box. When different rows of products or parts are selected in the Listview control of the first user interface component, the corresponding pictures are read from the warehouse management system and displayed in the picture display box.

[0012] In S1, the warehouse data is captured by querying the warehouse management system through SQL, including the detailed information of the number, name, model, category, quantity, and location of raw materials, semi-finished products, and finished products, and the warehouse data is transmitted to the first user interface component and displayed in the Listview control of the first user interface component in the form of a list.

[0013] In order to generate the BOM table through the second user interface component, the second user interface component includes a Listview control of the BOM data of the product and a BOM table upload control, and the second user interface component is used to collect all part information for product production. The first user interface component also includes a BOM information confirmation control. By manually selecting part information in the first user interface component, the selected part information is added to the Listview control of the second user interface component one by one through the BOM information confirmation control. According to the part information in the Listview control of the second user interface component, the BOM table upload control is used to generate the BOM table corresponding to the product.

[0014] In order to display the picture in the user interface component and facilitate the confirmation of the part, the second user interface component also includes a picture display box. By selecting a part in the Listview control of the second user interface component, the picture information of the selected part is read from the warehouse management system and displayed in the picture display box.

[0015] In order to ensure the accuracy of the number of parts and the feeding process, the parts in the first user interface component are manually selected and the information box of the parts is opened, the information box further includes the number of parts and the feeding process, the number of parts is manually filled, and the feeding process is selected by a drop-down box.

[0016] In order to facilitate the modification of the BOM table, after the BOM table is generated, the product of the generated BOM table is selected again in the first user interface component, and the generated BOM information is displayed again in the Listview control of the second user interface component through the BOM parent item confirmation control.

[0017] Compared with the prior art, the beneficial effects achieved by the present application are:

[0018] (1) By designing the first user interface component and the second user interface component, the two controls are displayed at the same time, the data of the warehouse management system is displayed on the first user interface component, the parts are selected on the first user interface component by using the interaction of the two controls, and the information of the parts used for producing products is added to the second user interface component, so that the information of the products and the parts is collected, errors are not easy to occur, and it is convenient to search, view and determine the part information required for generating BOM, and the generation efficiency of the BOM table is improved;

[0019] (2) The picture display box is arranged in the first user interface component and the second user interface component, the picture information of the selected parts or products in the warehouse management system can be read, and the picture information is displayed in the picture display box. Because the data amount of the picture is large, the picture information is read when needed, compared with batch importing pictures at one time, the communication time and the memory of the computer are saved, the correctness of the parts and the products is confirmed through the picture, the operation intuitiveness and accuracy are enhanced, and the human operation error is reduced. DETAILED DESCRIPTION

[0020] The accompanying drawings are used to provide a further understanding of the present application, and constitute a part of the specification, and are used to explain the present application together with embodiments of the present application, and do not constitute a limitation to the present application. In the drawings:

[0021] Figure 1 is a control schematic diagram of the present application;

[0022] Figure 2 is a data table schematic diagram of the warehouse management system of the present application;

[0023] Figure 3 is a first user interface component schematic diagram of the present application;

[0024] Figure 4 is a second user interface component schematic diagram of the present application;

[0025] Figure 5 is the schematic diagram of the information frame of the parts of the present application;

[0026] Figure 6 is the schematic diagram of the BOM table of the present application;

[0027] In the figure: 1, first user interface component; 2, second user interface component; 3, BOM parent item confirmation control; 4, BOM information confirmation control; 5, BOM table uploading control; 6, BOM table. DETAILED DESCRIPTION

[0028] The technical solutions in the embodiments of the present application will be described clearly and completely below with the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, rather than all the embodiments. Based on the embodiments in the present application, all the other embodiments obtained by those skilled in the art without creative labor fall within the scope of protection of the present application.

[0029] Please refer to Figures 1 to 6 The present application provides the technical solution: a method for manually generating a BOM table based on double Listview, which comprises a first user interface component 1 and a second user interface component 2. The first user interface component 1 and the second user interface component 2 comprise Listview controls and button controls. The Listview control in the first user interface component 1 comprises at least one part information and at least one product information, such as Figure 3 The first user interface component 1 further comprises a BOM parent item confirmation control 3, i.e. a BOM button. According to the selected product information in the first user interface component 1, the BOM button is used to generate the second user interface component 2. The specific operation is as follows: the product to be produced is selected by a mouse, and then the BOM button is pressed to trigger the BOM parent item confirmation control 3. The second user interface component 2 with the product information as the parent item is generated. The part information is selected by a mouse and double-clicked to generate the information frame of the part. The confirmation button on the information frame, i.e. the BOM information confirmation control 4, is used to add the information of the part to the Listview control in the second user interface component 2. The second user interface component 2 is also provided with a confirmation button, i.e. the BOM table uploading control 5, which is used to confirm the information in the second user interface component 2. The product and part information are corresponded, and the information in the Listview control of the second user interface component 2 is transmitted to the production management system to generate a BOM table.

[0030] The generation steps of the BOM table 6 are as follows:

[0031] S1, open the first user interface component 1, by transmitting the data of the warehouse management system into the first user interface component 1, and displaying in the Listview control in the form of a list in the first user interface component 1, facilitate the collection of product and spare parts, raw material inventory number ID and other information, not easy to make mistakes;

[0032] S2, select product information in the Listview control of the first user interface component 1, generate the second user interface component 2 with product information as the parent item;

[0033] S3, the first user interface component 1 and the second user interface component 2 are displayed simultaneously, and the first user interface component 1 and the second user interface component 2 can interact, select the spare part information of the product in the Listview control of the first user interface component 1, double-click the mouse, and the information box of the spare part will pop up, as shown in Figure 5 , use the confirmation button on the information box, that is, the BOM information confirmation control 4, to add the multiple spare part information in the first user interface component 1 to the Listview control of the second user interface component 2 one by one, through the design of the two user interface components, the user operation interface is facilitated, and engineers, production planners and the like can conveniently search, view and determine the spare parts required for generating the BOM table, improve the efficiency, and prevent the introduction of wrong BOM information into the manufacturing system;

[0034] S4, after the spare part information is added, use the confirmation button on the second user interface component 2, that is, the BOM table upload control 5, to confirm the information in the Listview control of the second user interface component 2, and transmit the spare part information in the Listview control of the second user interface component 2 to the production management system to generate the BOM table 6 with product information as the parent item.

[0035] The first user interface component 1 includes a picture display box, the picture information of the selected product or spare part in the warehouse management system is extracted, and the corresponding picture is displayed in the picture display box of the first user interface component 1, the picture information is displayed in the picture display box by selecting the spare part or product first and then reading the picture information of the selected spare part or product in the warehouse management system, because the data amount of the picture is large, the picture information is read when needed, compared with importing all the pictures, the communication time and the computer memory are saved, and the operation is more smooth.

[0036] In S1, the warehouse data is captured by querying the warehouse management system through SQL, including the number and name, model, category, quantity, and location of raw materials, semi-finished products, and finished products. The warehouse data is transmitted to and displayed by the first user interface component 1. The inventory information in the warehouse is displayed in the Listview control of the first user interface component 1 in the form of a list. When a component or product is selected, the corresponding component or product image is read and displayed in the image display box of the first user interface component 1 in real time. Reading and displaying the image after selecting the component or product reduces the import of data volume, saves communication time and computer memory, and facilitates quick search of component and product information through the use of images, enhancing the intuitiveness and accuracy of operation and reducing the probability of human error.

[0037] The second user interface component 2 includes a BOM data Listview and a BOM table upload control 5. The second user interface component 2 is used to collect all component information for product production. The first user interface component 1 also includes a BOM information confirmation control 4. By manually selecting component information in the Listview control of the first user interface component 1, the selected component information is added to the Listview control of the second user interface component 2 one by one through the BOM information confirmation control 4. According to the component information in the Listview control of the second user interface component 2, the BOM table 6 corresponding to the product is generated using the BOM table upload control 5, and the BOM table 6 is uploaded to the corresponding management system, facilitating production arrangement.

[0038] The information of the selected components in the first user interface component 1 is added to the second user interface component 2, including ID, name, model, category, quantity, and location. The component information is displayed in the Listview control in the form of a list. The second user interface component 2 also includes an image display box. By selecting a component in the second user interface component 2, the image of the corresponding component is read from the warehouse management system and displayed in the image display box, facilitating personnel confirmation of the component through the image, greatly improving the generation efficiency of the BOM table, reducing the probability of human error, ensuring that the BOM closely matches the actual inventory and production process, and helping to improve product quality.

[0039] As Figure 5As shown, manually select the component in the Listview control of the first user interface component 1. Double-click the component to pop up the component's information box on the interface of the first user interface component 1. The information box also includes the quantity of the component and the feeding process. The quantity and remarks of the component are filled in manually. The feeding process of the component is selected through a drop-down box. After the information of the component is completed, click the confirmation button, and the information of the component will be added to the second user interface component 2.

[0040] like Figure 3 As shown, after BOM 6 is generated, by selecting the product for which BOM 6 has been generated again within the first user interface component 1, and clicking the BOM button within the first user interface component 1 via the BOM parent item confirmation control 3, the information of the generated BOM 6 will be displayed again in the Listview control of the second user interface component 2. This facilitates the verification or modification of the information in BOM 6. At the same time, up and down buttons are provided on the right side of the window of the second user interface component 2. These buttons can be used to adjust the sorting order of the component information. A delete button is provided at the bottom of the window of the second user interface component 2. Selecting component information and clicking the delete button will delete that component information.

[0041] Finally, it should be noted that the above descriptions are merely preferred embodiments of the present invention and are not intended to limit the present invention. Although the present invention has been described in detail with reference to the foregoing embodiments, those skilled in the art can still modify the technical solutions described in the foregoing embodiments or make equivalent substitutions for some of the technical features. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the protection scope of the present invention.

Claims

1. A method for manually generating a BOM (Bill of Materials) table based on dual ListView display, comprising a first user interface component and a second user interface component, characterized in that: The first user interface component and the second user interface component include a Listview control and a button control. The first user interface component includes component information and product information. The product information of the first user interface component provides the parent information basis for the generation of the second user interface component. The second user interface component is generated after selecting a product in the first user interface component. The component information in the first user interface component provides the information basis for filling in the information of the second user interface component. Both the component information and the product information are displayed in the Listview control. The steps for generating the BOM table are as follows: S1. Open the first user interface component and display the data of the warehouse management system in the Listview control of the first user interface component; S2. Select product information in the first user interface component, trigger the BOM parent item confirmation control, and generate a second user interface component with the product information as the parent item based on the product information. S3. Select the component information for producing the product in the first user interface component, trigger the BOM information confirmation control, and add the multiple component information in the first user interface component to the Listview control of the second user interface component one by one. S4. Confirm the component information in the Listview control of the second user interface component, trigger the BOM upload control, upload the information in the Listview control of the second user interface component, and generate the BOM corresponding to the product production. The first user interface component also includes an image display box. When different rows of products or parts are selected in the Listview control of the first user interface component, the corresponding images are read from the warehouse management system and displayed in the image display box.

2. The method for manually generating a BOM table based on dual Listview display according to claim 1, characterized in that: In S1, the warehouse management system is queried via SQL to retrieve warehouse data. The warehouse data includes the numbers, names, models, categories, quantities, and storage locations of raw materials, semi-finished products, and finished products. The warehouse data is then passed to the first user interface component and displayed in a list view control within the first user interface component.

3. The method for manually generating a BOM table based on dual Listview display according to claim 1, characterized in that: The second user interface component includes a Listview control for the product's BOM data and a BOM upload control. The second user interface component is used to collect all component information for product production. The first user interface component also includes a BOM information confirmation control. By manually selecting component information in the first user interface component, the selected component information is added one by one to the Listview control of the second user interface component through the BOM information confirmation control. Based on the component information in the Listview control of the second user interface component, the BOM table for the corresponding product is generated using the BOM upload control.

4. The method for manually generating a BOM table based on dual Listview display according to claim 3, characterized in that: The second user interface component also includes an image display box. By selecting a component in the Listview control of the second user interface component, the image information of the selected component is read from the warehouse management system and displayed in the image display box.

5. The method for manually generating a BOM table based on dual Listview display according to claim 3, characterized in that: Manually select the component within the first user interface component and open the component's information box. The information box also includes the quantity of the component and the feeding process. The quantity of the component is entered manually, and the feeding process is selected from a drop-down list.

6. The method for manually generating a BOM table based on dual Listview display according to claim 1, characterized in that: After the BOM is generated, select the product with the generated BOM again in the first user interface component, and the generated BOM information will be displayed again in the Listview control in the second user interface component through the BOM parent item confirmation control.

Images