Method for manually generating BOM table based on double Listview display

Abstract

The invention discloses a method for manually generating a 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 comprise a Listview control and a key control, the first user interface component comprises part information and product information, and the second user interface component comprises part information and product information. The product information of the first user interface component provides a parent item information basis for the generation of the second user interface component, the product information is selected on the first user interface component to generate the second user interface component, and the part information is selected on the first user interface component; according to the BOM table generation method and device, the information of the parts used for product production is added to the second user interface component, so that the information of the products and the information of the parts are conveniently collected, errors are not prone to occurring, the information of the parts needed for generating the BOM table is conveniently searched, checked and determined, and the generation efficiency of the BOM table is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of warehouse management and production informationization, and in particular to a method for manually generating a BOM table based on dual Listview displays. Background Art

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

[0003] The traditional BOM generation method is to search and select the BOM product (parent item) and subcomponent (child item) through the ComboBox (drop-down box / combo box). When there are many varieties of products and components, the operation is cumbersome, inefficient and prone to errors. Summary of the invention

[0004] The purpose of the present invention is to provide a method for manually generating a BOM table based on a dual Listview display, design a first user interface component and a second user interface component, display the two controls at the same time, display the data of the warehouse management system on the first user interface component, utilize the interaction of the two controls, select parts on the first user interface component, and add the parts information used to produce the product to the second user interface component, so as to facilitate the collection of information on products and parts, not prone to errors, and conveniently search, view, and determine the parts information required to generate the BOM, thereby improving the generation efficiency of the BOM table.

[0005] The present invention provides the following technical solution: a method for manually generating a BOM table based on dual Listview display, comprising a first user interface component and a second user interface component, wherein 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 a parent item 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 an information basis for filling in information of the second user interface component, and the component information and product information are both displayed in the Listview control;

[0006] The steps for generating 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, and generating a second user interface component with the product information as the parent item according to the product information;

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

[0010] 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 a BOM corresponding to product production.

[0011] The first user interface component also includes a picture display box. When products or parts in different rows 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 management system is queried through SQL to capture warehouse data, which includes the numbers of raw materials, semi-finished products and finished products, as well as detailed information on their names, models, categories, quantities and storage locations. The warehouse data is passed 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 a BOM table through the second user interface component, the second user interface component includes a Listview control of the product's BOM data and a BOM table upload control. The second user interface component is used to collect all component information used 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, all selected component information is added one by one to the Listview control of the second user interface component through the BOM information confirmation control. According to the component information in the Listview control of the second user interface component, the BOM table upload control is used to generate the BOM table of the corresponding product.

[0014] In order to display pictures in the user interface component and facilitate the confirmation of parts, the second user interface component also includes a picture display box. By selecting parts in the Listview control of the second user interface component, the picture information of the selected parts is read from the warehouse management system and the picture information is 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 also includes the number of parts and the feeding process. The number of parts is filled in manually, and the feeding process is selected through the drop-down box.

[0016] In order to facilitate the modification of the BOM table, after the BOM table is generated, the product with 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 in 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 invention are:

[0018] (1) By designing a first user interface component and a second user interface component, the two controls are displayed simultaneously, the data of the warehouse management system is displayed on the first user interface component, and the interaction of the two controls is utilized to select parts on the first user interface component, and the parts information used in the production of the product is added to the second user interface component, which facilitates the collection of information on products and parts, is less prone to errors, and is also convenient for searching, viewing, and determining the parts information required for generating the BOM, thereby improving the efficiency of generating the BOM table;

[0019] (2) A picture display box is provided in both the first user interface component and the second user interface component, which can read the picture information of the selected parts or products in the warehouse management system and display the picture information in the picture display box. Since the amount of picture data is large, the picture information can be read when needed. Compared with one-time batch import of pictures, communication time and computer memory are saved. At the same time, the correctness of parts and products can be confirmed through pictures, which enhances the intuitiveness and accuracy of operations and reduces human operational errors. BRIEF DESCRIPTION OF THE DRAWINGS

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

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

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

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

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

[0025] Figure 5 It is a schematic diagram of an information frame of a component of the present invention;

[0026] Figure 6 It is a schematic diagram of the BOM table of the present invention;

[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 upload control; 6. BOM table. DETAILED DESCRIPTION

[0028] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0029] See also Figures 1 to 6 The present invention provides a technical solution: a method for manually generating a BOM table based on dual Listview display, comprising a first user interface component 1 and a second user interface component 2, wherein the first user interface component 1 and the second user interface component 2 include a Listview control and a button control, and the Listview control of the first user interface component 1 includes at least one component information and at least one product information, such as Figure 3 The first user interface component 1 also includes a BOM parent item confirmation control 3, namely a BOM button. According to the product information selected in the first user interface component 1, the second user interface component 2 is generated using the BOM button. The specific operation is as follows: select the product to be produced by the mouse, and then press the BOM button to trigger the BOM parent item confirmation control 3 to generate the second user interface component 2 with the product information as the parent item. Select the component information by the mouse and double-click to generate the component information box. Use the confirmation button on the information box, namely the BOM information confirmation control 4, to add the component information to the Listview control of the second user interface component 2. The second user interface component 2 is also provided with a confirmation button. Use the confirmation button of the second user interface component 2, namely the BOM table upload control 5, to confirm the information in the second user interface component 2, correspond the product and component information, and pass the information in the Listview control of the second user interface component 2 to the production management system to generate a BOM table.

[0030] The steps to generate BOM table 6 are as follows:

[0031] S1. Open the first user interface component 1, transfer the data of the warehouse management system to the first user interface component 1, and display it in the Listview control in the first user interface component 1 in the form of a list, so as to facilitate the collection of information such as inventory IDs of products, parts and components, and raw materials, and avoid errors;

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

[0033] S3, the first user interface component 1 and the second user interface component 2 are displayed at the same time, the first user interface component 1 and the second user interface component 2 can interact with each other, select the component information for producing the product in the Listview control of the first user interface component 1, double-click the mouse, and the information box of the component will pop up, such as Figure 5 As shown, by using the confirmation button on the information box, i.e., the BOM information confirmation control 4, the multiple parts information in the first user interface component 1 is added one by one to the Listview control of the second user interface component 2. Through the design of the two user interface components, it is convenient for users to operate the interface, and it is convenient for engineers, production planners, etc. to search, view, and determine the parts required to generate the BOM table, thereby improving efficiency and preventing the introduction of erroneous BOM information into the manufacturing system.

[0034] S4. After the parts information is added, use the confirmation button on the second user interface component 2, i.e., the BOM upload control 5, to confirm the information in the Listview control of the second user interface component 2, pass the parts information in the Listview control of the second user interface component 2 to the production management system, and generate a BOM 6 with the product information as the parent item.

[0035] The first user interface component 1 includes a picture display box. By extracting the picture information of the selected product or component in the warehouse management system, the corresponding picture is displayed in the picture display box of the first user interface component 1. By first selecting the component or product and then reading the picture information of the selected component or product in the warehouse management system, the picture information is displayed in the picture display box. Since the amount of picture data is large, the picture information is read when needed, which saves communication time and computer memory compared to importing all the pictures, making the operation smoother.

[0036] In S1, the warehouse management system is queried through SQL to capture warehouse data, which includes the numbers of raw materials, semi-finished products and finished products, as well as detailed information on their names, models, categories, quantities and storage locations. The warehouse data is passed to the first user interface component 1 and displayed through 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 image of the corresponding component or product is read, and the read image information is displayed in real time in the image display box of the first user interface component 1. After the component or product is selected, the image is read and displayed, which reduces the amount of data imported and saves communication time and computer memory. At the same time, the use of images facilitates quick search for information on components and products, enhances the intuitiveness and accuracy of operations, and reduces the probability of errors in human operations.

[0037] The second user interface component 2 includes a product's BOM data Listview and a BOM table upload control 5. The second user interface component 2 is used to collect all component information used 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 one by one to the Listview control of the second user interface component 2 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 upload control 5 is used to generate a BOM table 6 for the corresponding product, and the BOM table 6 is uploaded to the corresponding management system to facilitate production scheduling.

[0038] All the information of the parts selected in the first user interface component 1 is added to the second user interface component 2. The part information includes the ID, name, model, category, quantity, location, etc., and is displayed in a list in the Listview control. The second user interface component 2 also includes a picture display box. By selecting parts in the second user interface component 2, the pictures of the corresponding parts are read from the warehouse management system and displayed in the picture display box, which makes it convenient for personnel to confirm the parts through pictures, greatly improves the efficiency of BOM generation, reduces the probability of human errors, ensures that the BOM is closely aligned with the actual inventory and production process, and helps to improve product quality.

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

[0040] like Figure 3 As shown, after the BOM table 6 is generated, the product with the generated BOM table 6 is selected again in the first user interface component 1, and the information of the generated BOM table 6 is displayed again in the Listview control of the second user interface component 2 through the BOM parent item confirmation control 3, that is, clicking the BOM button in the first user interface component 1, so that the information in the BOM table 6 can be easily checked or modified. At the same time, an upper button and a lower button are provided on the right side of the window of the second user interface component 2, and the upper and lower sorting order of the component information can be adjusted by using the buttons. A delete button is provided at the bottom of the window of the second user interface component 2. The component information can be deleted by selecting the delete button.

[0041] Finally, it should be noted that the above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art can still modify the technical solutions described in the aforementioned embodiments or replace some of the technical features therein by equivalents. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A method for manually generating a BOM 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 a parent item 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 an information basis for filling in information in the second user interface component. The component information and product information are both 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, selecting product information in the first user interface component, triggering the BOM parent item confirmation control, and generating a second user interface component with the product information as the parent item according to the product information; S3, selecting the component information for producing the product in the first user interface component, triggering the BOM information confirmation control, and adding 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 a BOM corresponding to product production.

2. The method for manually generating a BOM table based on dual Listview display according to claim 1, characterized in that: The first user interface component also includes a picture display box. When products or parts in different rows are selected in the Listview control of the first user interface component, corresponding pictures are read from the warehouse management system and displayed in the picture display box.

3. 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 through SQL to capture warehouse data, which includes the numbers of raw materials, semi-finished products and finished products, as well as detailed information on their names, models, categories, quantities and storage locations. The warehouse data is passed to the first user interface component and displayed in the Listview control of the first user interface component in the form of a list.

4. The method for manually generating a BOM table based on dual Listview display according to claim 2 is characterized in that: The second user interface component includes a Listview control of the product's BOM data and a BOM table upload control. The second user interface component is used to collect all component information used 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, all selected component information is added one by one to the Listview control of the second user interface component through the BOM information confirmation control. According to the component information in the Listview control of the second user interface component, the BOM table upload control is used to generate the BOM table of the corresponding product.

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

6. The method for manually generating a BOM table based on dual Listview display according to claim 4 is characterized in that: Manually select a component in the first user interface component and open the component information box, the information box also includes the quantity of the component and the feeding process, the quantity of the component is filled in manually, and the feeding process is selected through a drop-down box.

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

Images