TW523700B - Function program system and method based on a table structure - Google Patents

Abstract

A function program system based on a table structure comprises a database with multiple tables and a main system. The main system receives a program trigger in response to a function to further establish a program template and searches relevant tables in accordance with the function name. The search result is adopted in the program template. The main system creates a user interface window with respect to the function in accordance with the program template. Meanwhile, a user command is accepted to execute the corresponding action of the user command and to trigger the corresponding business logic processing unit to execute the function, and display the corresponding processing result of the business logic processing unit on the user interface window.

Description

523700 The code used for processing is mostly different. Many unnecessary codes can generally be two parts. Repeatedly wrote the program that is used to process and use the commands of the opposite party or class. It is divided into two programs. It is used in a limited number of similar programs that involve the planners and improvers. It also requires an interface and a design interface that needs to be modified. New compile or update. V. Description of the invention (1) The present invention relates to a function and a method based on a table structure. In the conventional window (wi n d 0 w) process, the user must first design the interface (UI) and layout in each program. Then, the developer must work in the interface for the user to input and enter the code (c0de). In most programs, the procedures for manipulating actions are usually written at different locations in a program or repeatedly. Therefore, it is often wasted to repeatedly write similar user interfaces. For general window programs and business logic, because a lot of time is wasted in the code, it also indirectly reduces part of the time. In addition, because it is used to repeat at different positions in a program, it takes time to perform maintenance. In addition, if the user of the program is a developer, the user-client program must also be reprogrammed. The system and method must be reprogrammed. More specifically, in the functional program system development method of the structured window program, first, the use of development The user interface (use the corresponding layout of the user interface must be written separately for each user component design program is user-like, and often develop the time user interface to develop the time user interface business logic code in Time consuming, programmatic and for each code

0503-6453TWf; TSMC2001-0323; y i anhou.ptd 523700

Action ’to achieve consistency in the overall client program. Similarly, this is a time-consuming task. Herein, the main purpose of the present invention is to provide a functional program system 2 and a method which can design the program ^ user interface separately from the business logic part. In addition, the function program provided in the present invention is expressed using the form of the data table, and when a program that needs to execute a certain function is used, the user interface and business logic part of this function are started based on the basis of the table structure Build dynamically. In order to achieve the above objective, a functional program system and method based on a table structure provided by the present invention can be used to achieve the same. A functional program system based on a table structure according to an embodiment of the present invention includes a database having a plurality of tables and a main system. The main system receives a program trigger corresponding to a function, thereby creating a program template, and searching the tables in the database according to the name of the function, and applying the search result to the program template. The main system creates a corresponding user interface window in the main system according to the content of the program template, and at the same time, accepts user commands, executes the corresponding actions of the user commands, and triggers the corresponding business logic processing to execute this function. Unit, and display the corresponding processing result of the business logic processing unit in the user interface window. In order to make the above-mentioned objects, features, and advantages of the present invention clearer and easier to understand, an example is given below in conjunction with the accompanying drawings to make a detailed description as follows: FIG. 1 shows an embodiment according to the present invention A system architecture of a functional programming system based on a table structure.

0503-6453TWf; TSMC2001-0323; y i anhou.ptd Page 5 523700 V. Description of the invention (3) Figure 2 shows an example of the first table according to the embodiment of the present invention. FIG. 3 shows an example of a second table according to an embodiment of the present invention. FIG. 4 shows an example of a third table according to an embodiment of the present invention. FIG. 5 shows an example of a fourth table according to an embodiment of the present invention. FIG. 6 shows an example of a fifth table according to an embodiment of the present invention. FIG. 7 shows an example of a sixth table according to an embodiment of the present invention. FIG. 8 shows the operation flow of a function program method based on a table structure according to an embodiment of the present invention. Explanation of symbols 100 to 120 to 140 to 160 to 180 to 210 to 30 0 to S500 database, second form; fourth form sixth form eighth form program template 11 0 to first form 1 3 0 to third form 1 50 ~ 5th form 170 ~ 7th form; 2000 ~ main system; 21 user interface window business logic processing unit; S510, ..., S5 60 ~~ operation steps embodiment Next, the FIG. 1 shows a system architecture of a function program system based on a table structure according to an embodiment of the present invention. Referring to FIG. 1, an embodiment of the present invention will be described in detail as follows. First, the system architecture of the embodiment of the present invention includes a database 100 and a main system 2000. Database 100 stores multiple related forms, which may include a first form 110, a second form 120, a third form 130, and a fourth form

0503-6453TWf; TSMC2001-0323; yi anhou.ptd Page 6 523700 V. Description of the invention (4) =, grid = table 15 °, sixth table 16 °, 71st, "and next, each will be explained What is stored in the form. 110 is used to record at least the function name of the table function in the system of the embodiment of the present invention (functi ON. For example, == all no, the name of all functions in the system is recorded in the second figure, such as Figure 2 shows the WAT-Analysis, WAT-by Part, etc. The second form 1 20 is used to record at least the corresponding user interface window ^ and Y author, the display order of the I window. For example, In other words, the function WAT —by Part is used during operation. The second table 120 in the figure 3 at least includes the function name p. It is not used! It should be viewed from its stop, window name, etc. With WAT — by p: ,, the window code MT-by Part program provides two views 7 two work 1 as an example, the implementation is Kawami window 'for the user to make a condition. Step 1 is G1 fixation; Step 2 Di Er Form 1 3 0 is used to at least order you—the components included in these structures are different from those in the user interface window structure. For example, as shown in Figure 4—shown at 4 ° m: fine layout The s contained in the user interface window § The recorded window code is the G1 bureau structure. Among them, the layout type The number of ^ / knives and their corresponding detailed layouts, such as the pull-down menu, the click-type selection of Cui 3, and the display and input of the fourth form 140 are used to record different items. For example, as the 5th The composition code in the selection window G1 to be displayed in the Chengdao knife is the lean material that should be displayed in the 'Recording User Interface in Figure 5.' Among them, the structure 523700 5. Description of the invention (5) " ---- The data that should be displayed in the code 1 are Cp, pr〇cess, and WAT, while the data that should be displayed in the code 6 are pr〇ducti〇n L〇t, rd Lot, Engineer Lot, and producti〇n Pil〇. t L〇t. J i 格 150 is used to record each component (the query command (SQL instruction) that contains the component of the query function. For example, as shown in Figure 6 :: Library 杳 Figure: Eight Records Eight Record the corresponding query commands corresponding to the constituent codes 7 and 8 in the user interface window G1. ^ Form 160 records the corresponding actions of each constituent part * for different messenger operations (commands) in the library. For example, the seventh In the picture, the user interface window G1 records the phases of different user operations as shown in Figure ^ 7. == 分 In addition, the seventh form is used to record the same action: The one that should be generated corresponding to a user's input condition μ face view by the grid 180 is used to record the corresponding different functions, and the eighth table is processed The business logic of the call On the other hand, the main system 20 0 is mainly used to determine the program triggers for using functions, so as to construct and request a template 2 1 0 by the user, and then retrieve the above database 1 0 0 The program of Mody's function establishes the content of the program template of this function and the table of the eighth user, so that the main system 2 0 0 handles all users to operate a window 2 11 at the same time. In addition, the corresponding actions, requirements (commands) of the parent-user operation and command can be executed, and the corresponding business logic unit 30 can be displayed, and the execution of this function can be triggered. In addition, the system frame of the embodiment of the present invention is only 1 " More \ After the results. Face (not shown). This interface can include an operation interface ...

〇503-6453TWf; TSMC2001-0323; yianhou.ptd η 523700 V. Description of the invention (6) ~----functions, and users can use this operation interface to trigger ΙοίΓ. Click on 'to send the above-mentioned program trigger signal to the main system. Next, Fig. 8 shows an operation flow of a functional method based on the table structure according to an embodiment of the present invention, while referring to Fig. I and In FIG. 8, the operation steps of the embodiment of the present invention will be described in detail as follows. First, in step S500, the main system 20 receives a corresponding program trigger, so as to create a program template 21 according to the program trigger. Among them, this program trigger corresponds to the function provided in a system. Then, in step S5 丨 〇, the main system 200 triggers to search the first to eighth tables (110 to 180) in the database 100 according to this program, and applies a search result to this program 21 〇 . Next, in step S520, the corresponding user interface window 211 (if there are multiple windows, they are sequentially created according to the operation steps) in the function template 21 is set up according to the search results described above. After the person, as in step §53, the main system 200 can accept a user command, and the user can issue this user command by entering 仃 # work on the above-mentioned user interface window 211. The main system 200 performs the corresponding action of the above user command (step S54) (this action can also be learned by searching the above table). In addition, in step S550, the main system 200 triggers the corresponding execution of this function, the business logic processing unit 300, and, as in step 8560, the processed result of the business logic processing unit 300 is displayed in the user interface window 211. in.

523700 V. Description of the invention (7) Similarly, in this method, an operation interface (not shown) can also be provided to display the function names of all functions recorded in the first form, and the user can click here Click a function on the operation interface to generate a program trigger. It should be noted that the first to eighth tables mentioned in the embodiments of the present invention are the best embodiments in which a program is appropriately divided and stored according to its corresponding structure. However, the first to eighth tables may also be used. Combined into a table or any other number of tables. Therefore, with the function program system based on the table structure provided by the present invention, the user interface of the program can be designed separately from the business logic part, and the form of the table can be used for retrieval and representation, and when the function needs to be executed Based on the foundation of the table structure, the functional user interface and business logic are dynamically established. _ Although the present invention has been disclosed as above with preferred embodiments, it is not intended to limit the present invention. Anyone skilled in the art can make some changes and retouching without departing from the spirit and scope of the present invention. The scope of protection of the invention shall be determined by the scope of the attached patent application.

0503-6453TWf; TSMC2001-0323; yianhou.ptd page 10

Claims (1)

523700 l · A functional program system based on a table structure The system includes: a database including a plurality of tables; and-— 口-^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ corresponding to the function-the trigger of the program, so as to establish a private model, sub-foundation The program triggers the retrieval of the tables, and the results are applied to the program template, and the second one is created based on the search results: 2: A corresponding user interface window is in the program template, and at the same time, it is assumed that = user command and executed The user commands a corresponding action, and executes a corresponding commercial logic processing unit corresponding to the function, and displays a corresponding processing result of the logical logic processing unit in the user interface view window ° 2 · If a patent is applied for The system described in item 丨, wherein the forms include a first table 袼, which records the functions provided by the system. The function ^ name 3. The system described in item 丨 of the patent application, wherein These forms include a second form for recording the corresponding function during the operation steps. The user interface window and the corresponding display of the user interface window are required. Preface: 4. The system described in item 3 of the patent application, wherein the tables include a third table for recording the detailed layout structure of the part included in the user interface window and the corresponding part. . s < Configuration 5 • The system as described in the fourth item of the patent application ', wherein a fourth form is included in these forms to record the display data of the component. 6. The system as described in the fourth item of the patent application, wherein the forms include a fifth form for recording the inquiry order of the component. 7. The system described in item 4 of the patent application, wherein the forms include 0503-6453TWf; TSMC2001-0323; y i anhou.ptd 523700 and set a search result to the user interface window Force, patent application scope-forms to record the correspondence of this component-the user ordered the cup to be the system described in item 3 of the patent, which makes these forms include ^ ow, ^, It is used to record additional information of the user interface window corresponding to a user input condition. There is a system described in item 9 of the patent, where the tables contain the corresponding business logic corresponding to the function. 10. The system described in item 2 of the patent application, which also includes One interface >, used. It is displayed by the function name of the function recorded in the first form, and the program trigger is generated by clicking the function on the operation interface. 0 11 · A function program method based on a table structure, the method includes The following steps: ^ 彳 Receive a program trigger of a corresponding function to create a program template; 7 Trigger retrieval of multiple tables to use in the program template based on the program trigger; Create a corresponding one of the functions based on the read search results to use in the program In the template; accepting a user command; executing a corresponding action of the user command; triggering a business logic processing unit corresponding to the function; and displaying a corresponding processing result of the business logic processing unit in the use 0503-6453TWf; TSMC2001-0323; y i anhou.ptd 523700 6. The scope of patent application interface window. 1 2 · The method as described in item 11 of the patent application, wherein the forms include a first form for recording the name of the Fenzhong \ ° provided in the method. 1 3 · The method described in item 11 of the patent application, wherein the forms include a second form for recording the corresponding user interface window corresponding to the function in the operation steps " the corresponding user interface window The display sequence is 14. The method as described in item 13 of the patent application, wherein the tables include a third table for recording the constituent parts contained in the user interface window corresponding to the constituent parts. Detailed layout structure. 15 · The method described in item 14 of the patent application, wherein the form includes a fourth form for recording the display information of the component. 16 · The method described in item 14 of the patent application, wherein the forms include a fifth form for recording the inquiry order of the component. 17 • The method described in item 14 of the patent application, wherein the forms include a sixth form for recording the corresponding actions of the component corresponding to a user order. 1 8. The method described in item 13 of the patent application, wherein the forms include a seventh form for recording additional information of the user interface window corresponding to a user input condition. > Α, 1 9 · The method described in item 11 of the patent application, in which the forms such as 0H include the eighth form for recording the corresponding business logic processing unit corresponding to the function. 20. The method described in item 12 of the application for patent, which is more provided ----- 0503-6453TWf; TSMC2001-0323; y i anhou.ptd page 13 523700 0503-6453TWf; TSMC2001-0323; yi anhou.ptd Page 14