General-purpose MES construction system

Abstract

The present invention relates to a system for implementing a production execution function in a smart factory. A general-purpose MES construction system according to the present invention has a technical feature of comprising: a drawing unit (100) for connecting and illustrating factory facilities for implementing a smart factory; a gauge window display unit (200) for displaying a gauge window indicating production-related numerical values including the state values, raw material amounts, and production quantities of the factory facilities in the smart factory illustrated by the drawing unit (100); a table making unit (300) capable of making a table for transmitting and receiving data to and from a department that provides resources for manufacturing, including raw materials and manpower; a programming unit (400) which enables the writing of a program to perform the operations of the factory facilities sequentially or according to conditions monitored in a window set in the gauge window display unit (200), wherein the table made by the table making unit (300) includes buttons usable to execute specific commands including data input, data modification, data deletion, and file storage, and the specific commands are executed by clicking the buttons.

Description

Universal MES construction system

[0001] The present invention relates to a smart factory, and more particularly, to a system for constructing a general-purpose MES (Manufacturing Execution System) that implements a production execution function in a smart factory.

[0002] The smart factory is a key concept in modern manufacturing, leveraging the latest information technology (IT) and automation technologies to innovatively improve production systems. A smart factory automates production processes through automation and robotization, reducing the workload of human workers. It also leverages various sensors and IoT technologies to monitor the status of machines and production equipment in real time and collect data to optimize production processes. This data, through big data analysis, improves production efficiency and contributes to predictive maintenance and early detection of problems. Smart factories offer greater flexibility and enable the manufacturing of customized products tailored to customer needs. Furthermore, they leverage digital integration to efficiently share and manage information such as production data, facility management, and inventory management, fostering greater connectivity. Energy efficiency is another key aspect of smart factories, enabling the adoption of environmentally friendly production methods and minimizing energy consumption. Smart factories are a key tool for manufacturers to improve productivity and enhance competitiveness, supporting high-quality product production, cost reduction, and sustainable production.

[0003] Smart factories are particularly easy to apply to manufacturing because they minimize human intervention and are not time-bound.

[0004] Additionally, because it is highly cost-effective, when converting existing factories into smart factories, the manufacturing sector is often the first step.

[0005] An example of a smart factory in the manufacturing sector is disclosed in Patent Publication No. 10-2022-0142176, and Figure 1 is a diagram of its configuration.

[0006] A typical smart factory in the manufacturing sector is composed of a standard management unit (1) that manages control standards for the process, an information collection unit (3) that acquires values ​​sensed by sensors while the process is being performed, a monitoring unit (5) that monitors the control target, an event detection unit (7) that detects events occurring in the control target, and a control unit (9) that executes commands corresponding to the control standards for the control target.

[0007] When implementing smart factories with limited resources and costs, the focus is on process automation. In this case, the supply and demand of raw materials and manpower, as well as their distribution, are often carried out by people as before.

[0008] In such cases, it is difficult for the data derived from the automatic production process of the smart factory to be transmitted to the materials department in charge of raw materials or the human resources department in charge of human resources. The materials department or human resources department must either directly receive and process the data from the production line device as they did in the conventional factory system, or request the data from the production line manager for processing. Therefore, bottlenecks occur in the raw materials, human resources, and logistics departments other than the manufacturing department, resulting in inefficiency. To solve this, the need for MES has been emphasized.

[0009] However, MES is created by the best IT experts through coding work in C / C++, C#, JAVA, etc., and it takes at least 6 months, resulting in high costs.

[0010] [Prior Art Literature]

[0011] (Patent Document 1) KR 10-2022-0142176 A (October 21, 2022)

[0012] The present invention has been devised to solve the above problems, and the problem that the present invention seeks to solve is to provide a general-purpose MES construction system that can construct an MES in a short period of time without coding work by advanced IT experts.

[0013] The general-purpose MES construction system according to the present invention is characterized by a device drawing unit that includes device icons capable of dropping down all device drawings of a factory so that factory facilities for implementing a smart factory can be connected and drawn; a meter window display unit that enables drawing meter windows for entering and displaying numbers indicating the status values, raw material quantities, and production quantities of the factory facilities of the smart factory drawn in the drawing unit, and characters indicating the names of raw materials, product names, and personal information; a table creation unit that enables data transmission and reception with a department that provides resources for manufacturing, including raw materials, products, and manpower, and for creating tables that display all numbers and characters processed in the MES; a programming unit that includes meter windows, tables, and files, and program buttons that enable the setting and programming of relationships between them; and a technical feature that arranges an infinite number of tables, infinite number of meter windows, and infinite number of program buttons on a PC screen, and programs specific commands between tables, tables, tables, meter windows, tables, and files, and completes the MES by executing them with the click of a button on which the program is stored.

[0014] The universal MES construction system according to the present invention enables even non-IT experts to construct an MES without the need for computer program coding, thereby shortening the MES construction period, which currently takes at least six months, to within a few weeks.

[0015] Figure 1 is an example of a smart factory.

[0016] Figure 2 is a configuration diagram of a smart factory that is the target of a universal MES construction system according to the present invention.

[0017] Figure 3 is a menu screen of a universal MES construction system according to the present invention.

[0018] Figure 4 is an example of a smart factory.

[0019] Figure 5 is a list of factory facilities.

[0020] Figure 6 is an example of an analog instrument window.

[0021] Figures 7 and 8 are examples of tables created to enable the identification of the raw material status in the smart factory of Figure 4.

[0022] Figure 9 is a button selection window that allows special function settings provided by the present invention.

[0023] Figure 10 is an example of a master table and a detail table.

[0024] Figure 11 is an example of a table and input window.

[0025] Figure 12 is an example of a table for file search.

[0026] Figure 13 is an example of a data input window.

[0027] Figure 14 is an example of a process command selection window.

[0028] Figure 15 shows the input window for details of the other page button on / off command.

[0029] Figure 16 shows the detailed entry window for the instrument window → other page command.

[0030] Figure 17 shows the detailed entry window of the instrument window → memo window command.

[0031] Figure 18 shows the detailed item input window of the instrument window↔table command.

[0032] Figure 19 shows the detailed entry window of the instrument window → file command.

[0033] Figure 20 is the file name input window

[0034] Figure 21 shows the detailed entry window of the File → Instrument Window command.

[0035] Figure 22 shows the detailed entry window of the character comparison command between instrument windows.

[0036] Figure 23 shows the detailed entry window of the instrument window character selection command.

[0037] Figure 24 shows the detailed entry window of the instrument window character combination command.

[0038] Figure 25 shows the details input window for the open / hide pop-up window command.

[0039] Figure 26 shows the details input window for the message notification command.

[0040] Figure 27 is a notification message input window.

[0041] Figure 28 is an example of a program source list.

[0042] [Explanation of symbols]

[0043] 10 PC 20 PLC

[0044] 30 factory facilities

[0045] 100th Animated Division 111th Tank

[0046] 112 2nd Tank 113 3rd Tank

[0047] 114 4th Tank 120 Reactor

[0048] 130 stirring motor 140 piping

[0049] 150 1st transfer motor 151 2nd transfer motor

[0050] 160 Valve 1 161 Valve 2

[0051] 163 3rd valve 200 instrument display

[0052] 210, 513, 542 instrument windows

[0053] 300 Table Writing Department 400 Programming Department

[0054] 410 Automatic Control Command 430 MES Command

[0055] 510 Master↔Detail Settings Button 511 Master Table

[0056] 512 detail table 514 cells

[0057] 515 Button with Master↔Detail function set

[0058] 516 Items in the pop-up window for setting the Master↔Detail function

[0059] 520 Table↔Input Window Settings Button 521 Table

[0060] 522 input window

[0061] 523 Button with table↔input window function set

[0062] 530 File → Table button 540 File Search → Table Settings button

[0063] 541 Date selection window 542 File search instrument window

[0064] 543 Button with file search function enabled

[0065] 550 Table → File Settings Button

[0066] 560 Data input window → File settings button

[0067] Hereinafter, a universal MES construction system according to the present invention will be described in detail with reference to the attached drawings.

[0068] FIG. 2 is a configuration diagram of a smart factory that is the target of a universal MES construction system according to the present invention, and the smart factory is composed of a PC (10), a PLC (20, Programmable Logic Controller), and factory equipment (30), and receives an analog signal or digital signal {AI (Analog Input), DI (Digital Input)} from the factory equipment (30) through the PLC (20) in the PC (10), and outputs an analog signal or digital signal {AO (Analog Output), DO (Digital Output)} to the factory equipment (30) through the PLC (20), so that the factory equipment (30) performs automatic production.

[0069] The PC (10) is a component that monitors factory equipment (30) by installing a universal MES construction system according to the present invention and transmits pre-programmed commands to the PLC (20) based on various sensed instrument values ​​such as temperature, humidity, and motor speed involved in monitoring.

[0070] PLC (20) is a component that performs I / O commands that define each operation and sequence to be performed by the factory equipment (30), and the handling in case of a failure, and controls the factory equipment (30) according to each command sent by the PC (10).

[0071] Factory equipment (30) refers to components installed in the factory and performing actual manufacturing activities, such as reactors, tanks, motors, pumps, pipes, and valves.

[0072] FIG. 3 is a menu screen of a general-purpose MES construction system according to the present invention, and the general-purpose MES construction system according to the present invention is configured to include a drawing unit (100) that depicts a smart factory, a meter window display unit (200) that displays the status of the drawn factory equipment or the amount of raw materials in the equipment, a table creation unit (300) that creates a table for transmitting and receiving data with departments other than the manufacturing department, such as the materials department and the human resources department (hereinafter referred to as “departments other than manufacturing”), and a programming unit (400) that programs the operation of the factory equipment and programs data processing for the MES.

[0073] The drawing unit (100) is a component that enables connecting and drawing factory facilities for implementing a smart factory. Icons of factory facilities such as reactors, tanks, motors, pipes, and valves are provided, and by clicking on this icon in the form of a drop-down (drop-down: defined as selecting one of several factory facility icons and clicking the screen to draw a picture identical to the picture of the icon at the clicked location), and then clicking on the screen, a picture of the factory facilities can be drawn on the screen with one click. FIG. 4 is an example of a smart factory illustrated in a drawing section, and is a chemical manufacturing smart factory composed of first to third tanks (111 to 113) in which raw materials are stored, a reactor (120) for receiving and mixing raw materials from the first to third tanks (111 to 113), a stirring motor (130) for stirring the inside of the reactor (120), a fourth tank (114) for storing reacted products, a pipe (140) connecting the tank and the reactor, and a transport motor (150, 151) or valve (160 to 162) provided in the pipe (140).

[0074] That is, by using the drop-down method through the drawing unit (100), the manufacturing process can be drawn with just a mouse click, thereby defining the factory equipment and its connection relationship that constitute a smart factory.

[0075] FIG. 5 is a list of factory equipment provided in the drawing section of a universal MES construction system according to the present invention, in which the switch item indicates whether a switching signal that can be used as an input signal for other factory equipment is generated, and the contact designation item indicates whether it is connected to a PLC contact.

[0076] The instrument window display unit (200) of FIG. 3 is a component that can display an instrument window that indicates production-related figures such as the status values, raw material amounts, and production volume of each factory facility of the smart factory depicted in the drawing unit (100). As shown in FIG. 4, the instrument window (210) can be corresponded to each factory facility to monitor the status of the factory facility or the status of raw materials.

[0077] The instrument window (210) set in the instrument window display unit (200) is linked to the table created in the table creation unit (300) to enable implementation of the MES function in the present invention.

[0078] Fig. 6 illustrates an analog instrument window as an example of an instrument window displayed in an instrument window display unit, and includes a clock window (221), a date selection window (222), a combo box (2223), a check box (224), and a note memo window (225) as a display window (220) required to perform MES.

[0079] The table creation unit (300) of FIG. 3 is a component that enables the creation of a table that transmits and receives data with a department that provides resources for manufacturing, such as raw materials and manpower, while performing a role other than manufacturing, such as a non-manufacturing department. The table is generally composed of a set of cells in which horizontal rows and vertical columns intersect, as in the well-known Excel.

[0080] Inside the cell of the table, a gauge window that indicates the status of factory equipment or the amount of raw materials formed using the gauge window display unit (200), a calculation window that indicates the calculated value of the number displayed in the gauge window, a program button that executes a command, an image, etc. may be included.

[0081] Here, a program button refers to a graphic image that synchronizes the execution of a specific command, such as data entry, modification, deletion, and file saving, with the click of the button, so that clicking the button executes the command.

[0082] That is, the universal 'MES construction' included in the title of the present invention can be said to be essentially the creation of such tables and data processing by buttons. More specifically, the universal MES construction system is based on the ability to program all types of data processing between tables, instrument windows, and files to be set and executed by program buttons.

[0083] Figures 7 and 8 are examples of tables created to enable identification of raw material and product receipt and delivery, and product recipes in the smart factory of Figure 4.

[0084] In the present invention, a special function is set and provided in a table to enable the manufacturing department to easily exchange data with non-manufacturing departments and to smoothly perform the production execution function.

[0085] FIG. 9 illustrates buttons capable of performing special functions provided by the present invention. In the present invention, the functions of the master↔detail button (510), table↔input window button (520), file→table button (530), file search→table button (540), table→file button (550), and data input window→file button (560) are defined, and data input / output, display, storage, etc. are performed accordingly.

[0086] First, the master↔detail button (510) is a component that facilitates data input / output between the master table and the detail table in a set of tables consisting of a master table (511) and a detail table (512).

[0087] Figure 10 is an example diagram of a master table and a detail table that can be viewed when the master↔detail button is clicked. The detail table (512) is a table that includes detailed data, and the master table (511) is a table that briefly displays only some data of the detail table.

[0088] In order to use the master↔detail button (510), first, create a master table (511) and a detail table (512) by dropping them down on the table screen with a single mouse click using the table creation section (300), and then complete the table by entering the table size, the number of rows and columns, and the height and width.

[0089] And by clicking the button icon of the programming section (400), the program button (515) to perform the master↔detail function is dropped down under the master↔detail table.

[0090] Initially, all cells in the master table (511) and detail table (512) are empty.

[0091] First, as shown in Fig. 10, a window (513, which serves as a label) is formed in the detail table (512) where detailed data will be included, to display the entry date, company code, company name, location, person in charge, contact information, etc. in the rows of the master table (511), and specific data such as the entry date and company code are entered into the window. The company code is automatically generated by programming.

[0092] In the cell (514) of the detail table (512) without an instrument window, specific data such as specifications and unit prices of valves and pipes can be entered.

[0093] To set up master↔detail, right-click the master↔detail button (515) and click the special function setting item (516) of the button in the pop-up window (516). Then, the special function setting window of the button, as shown in Fig. 9, appears. Here, if you click the master↔detail button (510), an input window for entering the file name in which data is to be saved appears. After entering the save file name, click the master table (511) and the detail table (512) sequentially to activate them, and then sequentially click the instrument window that configures the row of the master table (511) in the detail table (512) so that the name of the instrument window, such as the entry date and company code, is displayed in the master table (511). This completes the master↔detail setting.

[0094] This completes the setup of one set of master table (511) and detail table (512).

[0095] Afterwards, by simply clicking the master↔detail button (515), field data such as raw materials and work status are automatically entered into the detail table (512) through the PLC, and specific data such as personnel are manually entered, and the data of the detail table (512) is linked to each row of the master table (511) and saved in a storage file, and the saved file thus created is transmitted to departments other than manufacturing to perform material purchases, personnel hiring, etc.

[0096] That is, in the present invention, an infinite number of pairs of master tables (511) and detail tables (512) can be created in a free format, and input, modification, and saving of data can be easily performed by simply clicking the master↔detail button (515).

[0097] In addition, these master tables (511) and detail tables (512) can be created in departments other than manufacturing, and the storage files created in this way can be transferred to the manufacturing department, so that the manufacturing department can use the master table (511) and detail table (512) in the same way as described above to input and modify data.

[0098] That is, you can request and receive data in the required format from departments other than manufacturing.

[0099] Until now, MES construction has been done by building the master↔detail function one by one using C / C++, C#, or JAVA, etc., with coding amounting to thousands to tens of thousands of lines, thus consuming a lot of time in repetitive coding and debugging. However, using the universal MES construction system of the present invention, the master↔detail function can be set up and used immediately with just a few mouse clicks.

[0100] The table↔input window button (520) of Fig. 9 is a button that can set the table↔input window function, and is a component for facilitating data input into a table and alleviating display limitations of the display.

[0101] Fig. 11 is an example diagram of a table (521) and an input window (522) that can show the function of the table↔input window button. When the table↔input window function is set to the program button (523) in the same order as when setting the master↔detail, data entered in the input window (522) is transferred and saved to the table (521) by clicking this button (523), so that the table can be saved after confirmation while the entire data is displayed.

[0102] As can be seen in <Employee Personal Information> of Figure 11, when writing letters or numbers in a table, there is an inconvenience in that the table size is small and the entire letters or numbers are not displayed.

[0103] When a specific row of a table (521) such as <Employee Personal Information> is clicked, the contents of each cell of the specific row are displayed in a large input window (522), and when the contents are modified in the input window (522) and the table↔input window button (523) is pressed, the modified contents are updated in a specific row of the table (521), thereby modifying the table (521). This is the function of the table↔input window button (523).

[0104] That is, by entering content in the input window (522), clicking a specific row of the table (521), and then clicking the table↔input window button (523), the content of the input window (522) is entered in a specific row of the table (521).

[0105] In this way, the table↔input window button (523) can easily input new content such as multiple raw material data and personnel data.

[0106] Also, when a specific row of the table (521) is clicked, the contents written in each cell of the specific row are displayed in the input window (522). Therefore, after modifying the contents in the input window (522), by sequentially clicking the row of the table (521) and the table↔input window button (523), the contents of the specific row can be modified, or other rows with a lot of the same data as the specific row can be easily created and stored in the table (521) (for example, a row with only the raw material name different, such as Raw Material 1, 100kg, 2023. 6. 21. can be easily created as Raw Material 2, 100kg, 2023. 6. 21.).

[0107] The File → Table button (530) of Fig. 9 is a button that sets a component that reads a file and displays it in a table format. When the button is set to the program button in the same order as the master↔detail setting and the button with this function set is clicked, the file contents of the file set at the time of setting are displayed in a table format.

[0108] Therefore, the format of the file that can be read with the File → Table function must be csv (comma separated variables), and in the present invention, all files created with the Master↔Detail button (515) and the Table↔Input Window button (523) are saved in the csv format as a table format, so there is no problem in reading the file created in the universal MES construction system according to the present invention with the File → Table button.

[0109] The File Search → Table button (540) in Fig. 9 is a button that sets a function to find a row containing specific data in a file and display it as a table. This function is set to the program button in the same order as when setting the master↔detail.

[0110] Figure 12 is an example of a table for file search. When a search period is set with two date selection windows (541), one or more texts to be searched are entered in four instrument windows (542), and a file is selected by clicking the button (543) with the file search → table function set, rows of the selected file that include the search text written in the search period are displayed in table form.

[0111] The Table → File button (550) of Fig. 9 is a button that sets a component for saving a table in a file format, and performs the opposite function of the File → Table button (530).

[0112] The data input window of Fig. 9 → file button (560) is a button for setting a component that modifies or adds data to a file, and is set to the program button in the same order as when setting the master↔detail, and overwrite and continue are provided as setting options.

[0113] In case of overwriting, the existing contents of the file are modified with the contents in the data input window, and in case of continuing, the contents in the data input window are added to the end of the existing contents of the file.

[0114] Figure 13 is an example of a data input window, in which the date, region, and contents (data) of data 1 to 10 in the data input window items can be overwritten or continued to a specified file.

[0115] The six buttons (510, 520, 530, 540, 550, 560) in Fig. 9 are pre-programmed and coded as components so that they set all operations that occur between tables, instrument windows, and files occurring in MES and can immediately perform their functions when these settings are completed with a simple mouse operation. Thus, MES can be simply constructed by dropping down the required number of tables, instrument windows, and buttons with just a mouse click and setting each function to the button.

[0116] The programming section (400) of Fig. 3 is a component that enables the creation of a program that sequentially performs operations of factory equipment and MES, and is a component that saves programming to a program button with only a mouse click and parameter input.

[0117] FIG. 14 illustrates a process command selection window included in the technology of the present invention, and includes 19 automatic control commands (410) used as basic commands for automation of factory equipment and 11 MES commands (430) used to provide various functions to MES.

[0118] The six buttons (510, 520, 530, 540, 550, 560) of Fig. 9 are buttons that perform preset functions between given tables, tables and instrument windows, and tables and instrument windows and files. In order to perform the functions of these buttons, the operator directly clicks these buttons with the mouse or calls these buttons from other program buttons.

[0119] In addition, MES commands are used to further diversify the use of the above six buttons and to easily execute complex MES functions.

[0120] This MES command (430) is composed of commands such as another page button on / off command (431), instrument window → another page command (432), instrument window → memo window command (433), instrument window ↔ table command (434), instrument window → file command (435), file → instrument window command (436), character comparison command between instrument windows (437), instrument window character selection command (438), instrument window character combination command (439), pop-up window open / hide command (440), and message notification command (441), as shown in FIG. 14, and enables all basic tasks required for MES execution to be performed.

[0121] The other page button on / off command (431) of Fig. 14 is used to perform the function of executing or stopping the program button on another page and then moving on to the next command when the program reaches this command. Fig. 15 illustrates the detailed item input window of this command. In the first box, enter the page number to which the button to be turned ON / OFF belongs, in the second box, enter the button number, and in the third box, enter 1 or 2 depending on ON / OFF. Fig. 3 is one project page for building a smart factory, and in the present invention, an infinite number of such pages can be created.

[0122] The instrument window → other page command (432) of Fig. 14 is used to perform a function of sending numbers or characters to the instrument window of another page and then moving on to the next command when the program reaches this command. Fig. 16 illustrates the detailed item input window of this command.

[0123] In the first item, enter the project page to which the instrument window of another page belongs, in the second item, enter the contact number of the instrument window that receives the data, and in the third item, enter the data to be entered (numbers or characters).

[0124] The instrument window → memo window command (433) of Fig. 14 performs the function of adding a line of letters or numbers from the instrument window to the memo window displayed on the screen when the program reaches this command and then moving on to the next command. Fig. 17 illustrates the detailed item input window of this command. In the first item, the contact number of the instrument window where the text to be sent is displayed and the contact number of the memo window to receive are entered.

[0125] The instrument window↔table command (434) of Fig. 14 is a command used to perform a function of exchanging characters between the instrument window and the cell of the table when the program reaches this command and then moving on to the next command. Fig. 18 illustrates a detailed entry window of this command. In the first item, enter the contact number of the instrument window, and in the second and third instrument windows, enter the cell of the table to be exchanged with this instrument window, and then enter 1 when sending data from the instrument window to the table, or 2 when sending data from a table cell to the instrument window.

[0126] The instrument window → file command (435) of Fig. 14 is used to perform a function of saving characters or numbers of one or more instrument windows to a file and then moving on to the next command when the program reaches this command. Fig. 19 illustrates a detailed item input window of this command. In the first item, the contact number of the instrument window is entered. When the “(Click here)” part of the second item is clicked, a file name selection window as in Fig. 20 appears, where the file in which the instrument window data is to be saved is selected or the file name is directly entered.

[0127] The instrument window → file command (435) of FIG. 14 allows one or more data to be saved to a file at once. In this case, the number of data to be continuously input from this instrument window is entered in the third item of FIG. 19, and the separator between data is entered in the fourth item. In the fifth item, if you want to overwrite this data in the file, enter 1, and if you want to continue, enter 2. If you overwrite, the data in the file will be continuously created as one line, and if you want to continue, new data will be added to the very last line of the file. The instrument window → file command (435) of FIG. 14 can save data from an infinite number of instrument windows to a file with a single step command.

[0128] The file → instrument window command (436) of Fig. 14 is used to perform the function of outputting one or more data in a file to the same number of instrument windows when the program reaches this command and then moving on to the next command. Fig. 21 illustrates the detailed entry window of this command. In the first item, a file name is entered. When the “(click here)” part is clicked, a window like Fig. 20 appears where the file name can be entered. In the second item, the number of texts to be read from the file is entered, and in the third item, the type of delimiter, such as a comma (','), space (' '), slash (' / '), or backslash (' / ') exists between the texts in the file, and in the fourth window, the contact number of the first instrument window where the data read from the file will be output is entered.

[0129] The character comparison command (437) between instrument windows in Fig. 14 is used to compare numbers or characters between instrument windows when the program reaches this command and to perform a function of moving on to the next command when a condition is satisfied. Fig. 22 illustrates a detailed item input window of this command. When comparing Korean characters in two instrument windows, the sizes increase in the order of ㄱ, ㄴ, and ㄷ, that is, 'Na' is larger than 'Ga', 'B' is larger than 'A' in English, lowercase letters are larger than uppercase letters, and Korean letters are larger than English letters. Comparison of characters is to compare the sizes of the ASCII code numbers of each character.

[0130] The command (438) for filtering out characters in a window of FIG. 14 is used to filter out necessary characters from the string of a window of a window and output them to its own or another window of a window before moving on to the next command when the program reaches this command. FIG. 23 illustrates a detailed input window of this command. In the first item, the contact number of the window of a window is entered, the first and last positions of the characters to be filtered out from among the characters in the window of a window are entered, and in the fourth item, the instrument wheel on which the filtered characters are to be displayed is entered. Filtering out characters in a window of a window can be used to extract necessary information from data read from an external barcode reader and RFID (Radio-Frequency Identification).

[0131] The command (439) for combining instrument windows' characters in FIG. 14 is used to perform a function that combines characters between instrument windows when the program reaches this command, outputs them to its own or another instrument window, and then moves on to the next command. FIG. 24 illustrates the input window for details of this command. Enter the contact numbers of the first and second instrument windows to be combined, and in the third item, enter the instrument window on which the combined characters will be displayed. This command can be used to automatically generate barcodes, employee numbers, business partner numbers, etc.

[0132] The pop-up window open / hide command (440) of Fig. 14 is a command that, when the program reaches this command, performs the function of displaying or hiding a pop-up window or auxiliary window during program execution and then moving on to the next command. Fig. 25 illustrates the detailed item input window of this command.

[0133] The message notification command (441) of Fig. 14 is used to notify of necessary alarms, process progress, exceptional situations, etc. during program execution when the program reaches this command, and then performs the function of moving on to the next command. Fig. 26 illustrates the detailed item input window of this command. Clicking the first item to input a message displays the notification message input window as shown in Fig. 27.

[0134] Figure 28 illustrates an example of a program source list programmed with the above MES commands, with all commands being executed sequentially from top to bottom.

[0135] The first command begins on the line following the first line: “1. Proceed with the program.”

[0136] The first command (451): “2. Button ON / OFF of another page (3,21,1)” line shows the programming of the “other page button on / off command” (431), which is a command to turn on button number ‘21’ on page ‘3’ by ‘1’, and when this command is executed, it immediately moves on to the next command.

[0137] The second command: “3. Enter data in the instrument window of another page (2,201,300)” is executed. This command is executed by clicking “Instrument window → Other page command (432)” and then entering the parameter (2,201,300). When this command is executed, the next command is executed immediately.

[0138] Third command: Execute “4. Add to text memo window of instrument window (101,5)” and terminate program execution.

[0139] This program is stored in program button 10 (454), and you can also repeat the program by entering the number of repetitions in this button.

[0140] The 11 MES commands (430) of the above-described Fig. 14, together with the 6 buttons (510, 520, 530, 540, 550, 560) of the above-described Fig. 9 having special functions, set and program the relationships between an infinite number of tables and tables, an infinite number of tables and instrument windows, an infinite number of tables and files, and an infinite number of instrument windows and files to the program buttons, thereby enabling the construction of an MES that could actually be constructed only by coding by existing advanced IT technicians in a short period of time without a single line of coding in order to complete a smart factory.

[0141] In other words, the six special function buttons (510, 520, 530, 540, 550, 560) of FIG. 9 and the eleven MES commands (430) of FIG. 14 can be used in conjunction with each other at the programming stage to pre-program all operations occurring between tables, instrument windows, and files in MES, and this programming can be completed with only simple mouse operations and input of parameters required in the detailed item input window of each command, thereby shortening the construction time of MES, which takes several months to several years to complete with tens to hundreds of thousands of lines of coding, to several tens to several hundred times less.

[0142] The universal MES construction system according to the present invention can provide technology that can construct an MES (Manufacturing Execution System) in a short period of time without coding work by advanced IT experts, and thus has very useful industrial applicability in implementing production execution functions in smart factories.

Claims

1. In order to build an MES for a smart factory, a universal MES building system that can set up and operate the relationship between tables, instrument windows, and files without computer program coding is provided. The above universal MES construction system: A device drawing unit (100) including a device icon that can drop down all device drawings of the factory so that factory facilities can be connected to implement a smart factory; A meter window display unit (200) that can display a meter window that shows production-related figures such as status values, raw material quantities, and production volumes of each factory facility of the smart factory depicted in the above drawing unit (100); A table creation unit (300) that transmits and receives data with the department that provides resources for manufacturing, including raw materials, products, and manpower, and enables the creation of a table that displays all numbers and characters processed by MES; It is composed of a programming section (400) that enables the writing of a program to sequentially perform the operations of factory equipment and MES, saves the programming in a program button by mouse click and parameter input, and includes an automatic control command (410) for automating factory equipment and an MES command (430) that enables the execution of MES functions. A universal MES construction system characterized in that the MES is constructed by arranging a table dropped down from the table creation unit (300), an instrument window dropped down from the instrument window display unit (200), and a program button dropped down from the programming unit (400) on a PC screen, and setting the relationship between tables, tables, and instrument windows, tables and files, and instrument windows and files to the program buttons and programming.

2. In paragraph 1, A general-purpose MES construction system characterized in that the above MES command (430) includes a command for turning on / off a button on another project page or sending data to another project page and then moving on to the next command, and a command for turning on / off another page button (431) and a command for turning on / off another page button and sending data to another project page, which can be programmed with only a mouse click and parameter input.

3. In paragraph 1, A general-purpose MES construction system characterized in that the above MES command (430) includes a instrument window↔table command (434) that enables programming with only a mouse click and parameter input to perform a function of passing data between an instrument window and a table and then moving on to the next command.

4. In paragraph 1, A general-purpose MES construction system characterized in that the above MES command (430) includes a command for instrument window → file (435) and a command for file → instrument window (436) that enable programming with only a mouse click and parameter input to perform a function of passing data between an instrument window and a file and then moving on to the next command.

5. In paragraph 1, A general-purpose MES construction system characterized in that the above MES command (430) includes a character comparison command (437) between instrument windows that enables programming with only a mouse click and parameter input to perform a function of comparing characters between instrument windows and moving on to the next command if a condition is met.

6. In paragraph 1, A general-purpose MES construction system characterized in that the above MES command (430) includes a command for selecting instrument windows characters (438) and a command for combining instrument windows characters (439), which enable programming with only a mouse click and parameter input to perform a function of selecting characters in an instrument window or combining characters between instrument windows and then moving on to the next command.

7. In paragraph 1, The above table creation unit (300) is a universal MES construction system characterized in that it displays on the screen with a mouse click only a master↔detail button (510) made as a component to enable data input / output between the master table and the detail table in a set of tables composed of a master table and a detail table, a table↔input window button (520) that facilitates data input into the table, a file→table button (530) that reads a file and displays it in the form of a table, a file search→table button (540) that finds a row containing specific data in a file and displays it as a table, a table→file button (550) that saves a table as a file, and a data input window→file button (560) that has a function of modifying or adding data to a file, and that its function can be used with a mouse click only.

8. In paragraph 1, A general-purpose MES construction system characterized in that the above MES command (430) includes a command (433) for instrument window → memo window that enables programming with only a mouse click and parameter input to perform a function of adding a line of letters or numbers in an instrument window to a memo pad and then moving on to the next command.

Images