TW201523449A - Opencommand, opendoor.tool.studio - Google Patents

Abstract

1. The sketchy description of the patent-right application content: OpenCommand is a kind of exploiting method developed by our company. By utilizing computer instructions, aligning back-end programming implementations, and coordinating OpenCommand Module of the data bank, the originally complex program codes are used to access information. It, combined with the simple and quick Open.Tool.Studio tool, can effectively shorten working hours, reduce probability of error of programs, and procure the maximum value of effective production. 2. OpenCormmand Module is a series of data bank modules, catering to the needs of about 85% customers in the market. Furthermore, it not only can provide the functions of access control and load balance, but also is able to expand continuously and optimize. 3. OpenCommand is a way of simplifying complex program instruction codes. It requires working with OpenCommand Module to do the writing of instruction codes. The combined outcome can effectively shorten the working hours, increase work efficiency, decrease error probability of programs, and attain the maximum value of effective production. 4. Opendoor.Tool.Studio (OTS) is an exploiting tool. It needs to work with OpenCommand Module and OpenCommand to do program writing. Its simplified and standardized instruction codes SOPs can promote the work production efficiency rate and reduce the probability of instruction codes writing.

Description

Module program instruction system

The OpenCommand module uses MS SQL, which is mainly a decentralized database structure. According to its function, the data inventory is placed on different hosts, and then combined with the needs of the project, so that it can be used for the database of personal data. Better security control, avoiding the outflow of personal data, and because of the use of a decentralized database, you can achieve effective database load balancing, avoiding excessive data traffic, resulting in a database downtime or delayed opportunity. To improve the stability and security of the database, and to perform regular remote backup operations for each database and server using the database schedule, to reduce the probability of irreparable data damage, and to provide users. High stability and data integrity.

※Proper noun explanation:

1. Database: It can be regarded as an electronic filing cabinet. The location where electronic files are stored, users can perform operations such as adding, extracting, updating, and deleting data in the file. A database refers to a collection of data that is stored together in a certain way, can be shared by multiple users, has as little redundancy as possible, and is independent of the application.

2. Decentralized database: It is a logically unified database composed of a plurality of physically dispersed database units connected by a computer network. Each connected database unit is called a site or node. The distributed database has a unified database management system for management, called a distributed database management system.

3. Load Balancing : A computer networking technology that distributes load across multiple computers, network connections, CPUs, disk drives, or other resources to optimize resource usage, maximize throughput, and minimize response time. At the same time, avoid the purpose of overload. Using multiple service components with load balancing instead of a single component can increase reliability through redundancy. Load balancing services are usually done by dedicated software and hardware. .

4. Scheduling: The main purpose of the scheduling multi-programming system is to maintain a trip at any time to improve CPU usage. In fact, the itinerary is a task, and the resources available are the CPU. If the calculation is done most efficiently, it does not have to be long-term for the user.

5. Remote backup : Remote Backup is a backup strategy adopted by the computer information industry for important data on the server. It backs up important data to another location to avoid loss of important data due to disaster (fire and water theft).

The OpenCommand instruction code is a method for simplifying the code. The program uses a simple instruction method to issue instructions to the latter program. After the instruction code is parsed by the rear VB code, the instruction code can be converted into a corresponding VB program. Verify data, add data, modify data, delete data, read data or perform logical operation VB programs and other related actions.

The Opendoor.Tool.Studio (OTS) system consists of three blocks. Its command code system is a tool for quickly generating commands. The system is designed with a simple and user-friendly operation screen to assist the instruction code editor to quickly edit the command code. Mainly a set of Window Form applications developed by ASP.NET, using its built-in control items, matching the VB corresponding to the control items. The grammar allows the user to click on the application system tool that quickly outputs the corresponding text after the application. The second is the virtual data table system. The virtual data table system is a tool for opening and managing virtual data. Because the OpenCommand module meets 85% of customer requirements, some customers still have their own unique needs. The requirement of the virtual data table, the virtual data table is the virtual database function achieved by the entity database using the association of the data table, and the virtual data table is established with the unique requirements of the customer, and the virtual data table field is established corresponding to the virtual data table. The fields can be associated with each other for deletion or update of data. The function is the same as the entity data table. You can also view the virtual data table data in the interface. The third is the verification engine management tool. The system, the verification engine management tool system, records the commonly used verification rules in the corresponding data field in the corresponding database final record data table, and the verification function is basically specific, if the verification of the field is violated The rule displays a verification error message stored in the data column of the database to remind the user that the content of the data has Wrong.

According to the project and customer needs to open a project-specific database, you need to do system analysis first, after planning, design its customer-specific database, optimize and improve its database system according to customer needs, it takes a lot of time to analyze the database and planning.

According to the project needs and the project-specific database opened for program editing, it takes time to respond to the difficulty of the program. Even if other projects have used the same or similar syntax, you still need to re-edit.

There is no need to do script generation, no such technology, but you need to use Notepad or code editing system to do code editing.

The source of the development technology is: due to the old development methods and modes, it takes a lot of labor and time costs, and the probability of programming errors is also high. In order to improve this state, the technology "module program instruction system" is developed and is expected to be utilized. This technology achieves the goal of shortening the operation time, simplifying the operation process, reducing the probability of error, and maximizing production and optimizing production.

The technology utilizes the OpenCommand database module architecture to quickly generate OpenCommand commands in conjunction with the user-friendly Opendoor.Tool.Studio (OTS) tool, and cooperates with the project client's needs to combine the required database, omitting the work of building a database. And unified database, easy to do database permissions control and backup scheduling settings, and with load balancing function, even if there are a lot of data in the database, you can still provide the data at the fastest speed, will not Therefore, the quality of service customers is reduced. In short, it is possible to achieve the function of unified control, which can save time and meet customer needs.

Opendoor.Tool.Studio (OTS), a tool that can easily and quickly generate OpenCommand scripts, has a simple and user-friendly interface, and relatively simple and fast generation of relative OpenCommand commands, reducing the editing time of scripts and greatly improving production efficiency. Reduce the operation process, and cooperate with the command code test function in OTS, you can test the good script at any time to reduce the probability of error in the script. OTS also contains the development and management tools of virtual data table, which can be effective and fast. Generate virtual data table virtual data table fields and associations, create a simple and convenient data table to provide the project, which also contains the verification engine function, which can be easily adjusted at any time in accordance with the verification required by each project. , can be processed immediately, that is, modify the verification conditions of the project, in order to enhance customer satisfaction with us.

OpenCommand, which uses complex code and code to edit, can reduce the time spent by programmers in editing simple programs. The time is allocated to do its corresponding logical operation and difficult database processing, reduce the editing staff's working time, improve work efficiency and company growth rate, speed up the closing process, and increase customer service satisfaction.

Figure 1 is a complete architecture diagram of a system according to one of the patent applications

Figure 2 is the OpenCommand module database module architecture diagram

Figure 3-1 (OTS) instruction code generator structure flow chart

Figure 3-2 (OTS) instruction code generator structure flow chart_Reader

Figure 4 is a virtual data table structure flow chart of (OTS)

Figure 5 (OTS) verification engine structure flow chart

Figure 6 is the project manager interface of the (OTS) instruction code generator.

Figure 7 is the project manager search result interface of the (OTS) instruction code generator.

Figure 8 is the project command management interface of the (OTS) instruction code generator.

Figure 9 is a new interface for the project command of the (OTS) instruction code generator.

Figure 10 is the instruction code list interface of the project command of the (OTS) instruction code generator.

Figure 11 is the (OTS) instruction code generator's project command quick search window

Figure 12 is the application instruction interface of the instruction code generator of the (OTS) (OTS)

Figure 13 is the set command code generation interface of the instruction code of the instruction code list of the project code generator of the (OTS) instruction code generator.

Figure 14 shows the instruction code generation interface of the instruction code list of the instruction code list of the instruction code generator of the (OTS) instruction code generator (OTS).

Figure 15 is an instruction code generation interface for the instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code generator (OTS).

Figure 16 is an instruction code generation interface for the instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code generator (OTS).

Figure 17 is the instruction code of the command code list of the instruction code generator of the (OTS) instruction code generator. The Delete instruction code generation interface is applied.

Figure 18 is the instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code generator. The Reader instruction code Reader instruction detail interface is applied.

Figure 19 is the instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code generator. The Reader instruction code Reader basic instruction interface is applied.

Figure 20 is the instruction code of the instruction code list of the instruction code generator of the (OTS) (OTS). The Reader instruction code Reader merges the field instruction interface.

Figure 21 is the instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code. The Reader instruction code of the Reader merge field contains the delimiter instruction interface.

Figure 22 is the instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code generator. The Reader instruction code Reader merge field and the merge data table instruction interface are applied.

Figure 23 is the instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code generator. Reader instruction code Reader data table conditional instruction interface

Figure 24 is the instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code. The Reader instruction code of the Reader data table is matched with the comparison value instruction interface.

Figure 25 is the instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code. Reader command code Reader data table group field instruction interface

Figure 26 is the instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code. Reader command code Reader data table group field with comparison value command interface

Figure 27 is a list of instruction codes for the project instructions of the (OTS) instruction code generator. Reader code for the instruction code application Reader data table sorting power and power instruction interface

Figure 28 is the instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code. The Reader instruction code of the Reader data sheet lists the previous instruction interfaces.

Figure 29 is the instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code. The Reader instruction code of the Reader instruction code in the select list of the Reader data table.

Figure 30 is the instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code generator. The Reader instruction code Reader merges the data table instruction interface.

Figure 31 is an instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code. The Reader instruction code Reader selects the DataTable instruction interface to be outputted into the DataSet.

Figure 32 is the instruction code of the instruction code list of the instruction code generator of the (OTS) instruction code. The Reader instruction code Reader selects the DataTable instruction interface to be output.

Figure 33 is the test interface of the instruction code of the instruction code list of the project instruction of the (OTS) instruction code generator.

Figure 34 is the history record list interface of the instruction code of the instruction code list of the project code generator of the (OTS) instruction code generator.

Figure 35 is the project master list interface of the virtual data table (OTS)

Figure 36 is the project data table interface of the virtual data table of the (OTS) system.

Figure 37 is an additional project data sheet interface for the virtual data table (OTS).

Figure 38 is the (OTS) virtual data table of the project data table field list interface

Figure 39 shows the new project data table field interface of the virtual data table (OTS).

Figure 40 is the data list interface of the project data sheet of the virtual data table (OTS).

Figure 41 is the (OTS) virtual data table project data table association setting interface

Figure 42 is a module list interface managed by the verification engine of the (OTS) system.

Figure 43 is an authentication type management interface managed by the verification engine of the (OTS) system.

Figure 44 is the (OTS) verification engine management data table and data table field setting interface (when the data table has not been selected) interface

Figure 45 is the (OTS) verification engine management data table and data table field settings (when the data table is selected) interface

Figure 46 (OTS) verification engine management default verification _ data table verification list interface

Figure 47 (OTS) verification engine management default verification _ data table verification new interface

Figure 48 (OTS) verification engine management customization verification _ custom project list interface

Figure 49 (OTS) verification engine management customization verification _ data table verification list interface

Figure 50 (OTS) verification engine management customization verification _ data table verification New interface

Figure 51 is a classification list interface interface managed by the verification engine of the (OTS) system.

Figure 52 is the classification module list interface interface managed by the verification engine of the (OTS) system.

This architecture uses a series of interlocking architectures (see Figure 1). It must be combined with the OpenCommand module to generate the corresponding scripts using Opendoor.Tool.Studio (OTS) system. Its OpenCommand module and script code. For the database and application syntax, there is no corresponding physical interface, and it needs to be operated with the OTS system, but there is a supplementary explanation for the OpenCommand module architecture (Fig. 2).

The OTS system is divided into three architectures, such as the instruction code system, the virtual data table system, and the verification engine management system. The instruction code system is mainly used to generate the corresponding instruction code with the OpenCommand module. The data sheet system is not enough to supplement the OpenCommand module. According to the customized customer, the relevant virtual data table and the data field matching instruction can be used together. The verification engine management system can quickly set the data of the verification data table. The field and the verification of its data produce a corresponding error message system.

The instructions for using the OTS script system are as follows: (Please refer to the simplified flowchart in Figure 3) Open the OTS system, click on the script to edit, and generate the project manager to list all the projects (see Figure 6), which can be entered in the input box. After the project name, press the Save Project button to add a new project action, or click the Modify button. The project name will appear in the input box. After modifying the project name, press the Save Project button to save the project. Click Delete. ICON can delete the selected project, enter the search keyword in the input box and click KeyWord Search. You can do keyword search. The search results are shown in Figure 7. If you click on the project name, the script code classification and command code list paging interface of the project appears. As shown in Figure 8, the page is divided into two. Block, the left block is the block of the instruction code classification, the right side is the block of the instruction code list, the instruction code is classified into the tree structure list display, and there is an input box at the top of the list to input the category name and check the category below. Classification (you can choose not to classify the first layer) Press the right button to save the classification settings, or click the right triangle ICON of the category to display the category name and display the category in the upper category input box. The classification can be modified at will. After the modification is completed, press the right + button to save the classification setting, or click the category name in the category list, then all the instructions in the category will appear in the right instruction code block. Code, command code block can enter the keyword in the list above. Press the right magnifying glass button to do the command code search. Display the search result in the list below, or click New Comman. The operation of the new instruction code in d is as shown in Figure 9. There will be the instruction number field, the instruction name field, the instruction category drop-down menu, and the instruction description field. Please check the left category list. The classification of the instruction category drop-down menu has new, modified, deleted, list, detail, etc., which is convenient for sorting and categorizing. After the data is input, press the SaveCommand button to complete the new command action. Press the command. The EditICON of the list has the same action as the newly added action, but it will bring out the corresponding data content for the modification action. Pressing Del ICON will delete the selected command. Clicking this command will open the new page to enter the command code editing screen. (Refer to Figure 10), each instruction code is covered by a number of instructions into a single instruction code, so here you will see that there are instruction code editing mode buttons above all instructions of the instruction code, source code Edit mode button, file save button, file import button, file export button, below is the command list, the left side has the command code list zoom out window button, the right side has Application code so narrow window button, test scripts narrow window buttons, depending on the script history The window zoom-out button is preset to the command code editing mode. It is necessary to generate an instruction in the lower list block via the related operation. Click the original code editing mode to switch to the notebook mode, and the text can be written in the lower block. Edit the action, after editing, you can click on the file to save the current edited instructions. You can also use the file import function to import the txt file that has been edited into the OTS. Click on the export action. The file edited in the OTS can be exported to a txt file. The instruction list can be dragged to change the order of the instruction, or the X button at the top right can be used to delete the instruction, or double-click the instruction. Then enter the command editing screen, click on the left command code list (please refer to Figure 11), then the command code classification of the project, and the command code list, you can do the quick selection action, click the right command code application, then The command editing interface appears (please check the 12th picture), click the right command code test to display the command code test screen (please refer to Figure 33), click on the right The command history button, the relevant history stored before (see Figure 34), the editing process of the script, after entering the script editing interface (see Figure 12), select the command to be edited. Code type, click SET command, then enter (see Figure 13) SET command editing screen, the left side is the command code editing block, the right side is the module type drop-down menu, the database drop-down menu, the data table drop-down menu The corresponding table of the data table, and the insert and cancel buttons, after entering the SET screen, first select the module type, the database related to the library pull-down menu appears, in the database selected according to the selected data table, the corresponding data table drop-down menu is displayed. Display the fields in the data table according to the selected data table. Check the field and press the insert button to display the field in the left block for editors to edit, or After canceling, cancel the previous setting. After editing, select the new button at the top right to add the command. The screen will return to the command list screen (please refer to Figure 10), in the command code editing interface (please refer to FIG. 12), after clicking Check command, the process proceeds Check command editing screen (see FIG. 14), which is left to mean The code editing block, the right side is the module type drop-down menu, the database drop-down menu, the data table drop-down menu, and the insert and cancel buttons, after entering the Check screen, first select the module type, the database related to the module appears. Pull down the menu, in the database selected according to it, display the corresponding data table drop-down menu, select the required data table, press the insert button to display the field in the left block for the editor to do For editing, or cancel the previous setting after canceling, select the new button at the top right after editing, you can add this command, in the command code editing interface (please refer to Figure 12), click the Insert command, then enter Insert command editing screen (see Figure 15), the left side is the command code editing block, the right side is the module type drop-down menu, the database drop-down menu, the data table drop-down menu, the data table corresponding field, and the insert and After canceling the button, after entering the Insert screen, first select the module type, and the relevant database drop-down menu appears. In the database selected according to the data, the corresponding data table drop-down menu is displayed. Display the fields in the data table according to the selected data table. Check the field and press the insert button to display the field in the left block for editors to edit, or After canceling, cancel the previous setting. After editing, select the new button at the top right to add the command. The screen will return to the command list screen (please refer to Figure 10) in the command code editing interface (please refer to Figure 12). ), after clicking the Update command, enter the Update command editing screen (see Figure 16). The left side is the command code editing block, the right side is the module type drop-down menu, the database drop-down menu, the data table drop-down menu. , corresponding to the data table, and the insert and cancel buttons, after entering the Update screen, first select the module type, the database related to the library drop-down menu appears, in the database selected according to its selection, display the corresponding data table drop-down menu Display the fields in the data table according to the selected data table. Check the field and press the insert button to display the field in the left block for editors to edit, or Choose to take Cancel previous settings, select the top right of the button to be edited to add new instruction, the screen Go back to the command list screen (see Figure 10), in the command code editing interface (see Figure 12), click on the Delete command, then enter the Delete command edit screen (see Figure 17), left The square is the instruction code editing block, the right side is the module type drop-down menu, the database drop-down menu, the data table drop-down menu, and the insert and cancel buttons. After entering the Delete screen, the module type is selected first, and the module related The database drop-down menu displays the corresponding data table drop-down menu according to the selected database. After selecting the required data table, press the insert button to display the field in the left block for editing. For editing, or cancel the previous setting after canceling. After editing, select the new button at the top right to add the command. In the command code editing interface (please refer to Figure 12), click the Reader command. Then enter the Reader list (see Figure 18), the Reader command is combined by a number of Reader conditions, so use the list mode for presentation, each Reader condition can be dragged to change its original order There is a delete button at the top right of the condition. After clicking, the condition can be deleted. Double-click the conditional click to enter the conditional editing screen. Click the Add Reader condition command to enter the Reader condition editing screen (see Figure 19). The main instruction is Reader, the second instruction is the custom DataSetName (can be manually input), the third instruction is the custom DataTableName (can be manually input), and the left block is the Reader list. Block, you can drag and change its order position, press the delete button on the right to delete the field, the right side is the database module drop-down menu, the database drop-down menu, the data table drop-down menu, the data table column Bit list, insert and cancel button, after basically entering the Reader editing screen, input the DataSetName of the second-order instruction and the DataTableName of the third-order instruction, then you can start the following operations, select the database module on the right, and the corresponding database appears. Pull down the menu, select the corresponding database and the corresponding data table drop-down menu appears, select the corresponding data table drop-down menu, then Bit list of columns corresponding to the check needed After the field, insert the button after the point, you can insert the left editing area, you can modify its field name or delete the field, or click the Cancel button to cancel the previous setting behavior. After editing, click the upper right. The new button can be returned to the Reader list page (see Figure 18). Click the Add Reader condition command to enter the Reader condition edit screen (see Figure 19). In the second stage, select Merge ( Please refer to Figure 20). The third stage command inputs the merged field name (can be manually entered), the left side is the edit block, and the right side is the current DataSet drop-down menu in the Reader list, and the DataTable in the DataSet. Pull down the menu, insert and cancel the corresponding field list in the DataTable, enter the screen, select the DataSet to be used, the corresponding DataTable appears, select the corresponding ColumnName after the DataTable, select the ColumnName to be merged , click the Insert button, it can appear in the left block, you can drag and drop to change its order or click the Delete button to delete the action, edit completed Click the new button at the top right to return to the Reader list page (see Figure 18). Click the Add Reader condition command to enter the Reader conditional editing screen (see Figure 19). The command selects Merge (see Figure 20), the third stage enters the link symbol between the merged fields (can be entered manually), and the fourth stage command inputs the merged field name (can be entered manually) (see section 21)), the left side is the editing block, the right side is the current DataSet drop-down menu in the Reader list, and the DataTable drop-down menu in the DataSet, and the corresponding field list in the DataTable, insert and cancel buttons, after entering the screen After selecting the DataSet to be used, the corresponding DataTable appears. After selecting the DataTable, the corresponding ColumnName appears. After checking the ColumnName to be merged, click the Insert button, which can appear in the left block. You can change it by dragging at will. Order or click the delete button to delete the action. After editing, click the new button at the top right to return to the Reader list page (see Figure 18), click on the new button. Reader conditions refer to Order, you can enter the Reader condition editing screen (see Figure 19), select Merge in the second stage command (see Figure 20), select the Join in the third stage command (see Figure 22), the fourth stage command Input DataSetName (can be manually entered), the fifth stage command input DataTableName (can be manually entered), the sixth stage command input merged field name (can be manually entered), the left side is the edit block, the right side is At present, all DataSet drop-down menus in the Reader list, and the DataTable drop-down menu in the DataSet, and the corresponding field list in the DataTable, insert and cancel buttons, enter the screen, select the DataSet to be used, the corresponding DataTable appears, select After the DataTable, the corresponding ColumnName appears. After checking the ColumnName to be merged, click the Insert button, which can appear in the left block. You can drag and change the order at random or click the Delete button to delete the action. After editing, click Select the new button at the top right to return to the Reader list page (see Figure 18). Click the Add Reader condition command to enter R. The eader condition editing screen (see Figure 19), selects Where in the second stage (see Figure 23), the third stage selects the existing DataSetName (can be manually entered), and the fourth stage inputs the current The existing DataTableName (can be manually entered), the left side is the field condition editing block, the right side is the list of all the fields in the DataTable in the DataSet, select the required field, then click to insert it. The selected field is inserted into the left side and the area. The first instruction has no link symbol. After the second item, there will be a link symbol in front of each condition. You can select (AND or OR), and the second field of the condition is the column. Bit name, the third column is the field comparison symbol can be selected (=, <>, >, <, >=, <=, Like), the fourth field is the field search value (can be done manually) The fifth field is the delete button, the search condition value can be deleted, and each condition value can be dragged to change its order position. After editing, click the new button at the upper right to return to the Reader list page ( Please refer to Figure 18), click the new Reader condition command. You can enter Reader condition editing screen (see Figure 19), choose Where in the second stage (see Figure 23), and select the comparison condition (Max, Min, Count, Sum, Avg) in the third stage (see page 24) Figure), the fourth stage command enters its field name (can be manually entered), the bottom is the source of the field, all existing DataSet drop-down menus, the DataTable drop-down menu in the DataSet, the Column drop-down menu in the DataTable After entering the screen, first select the comparison condition, then enter its field name, then select the corresponding DataSet to display the corresponding DataTable drop-down menu, select the corresponding DataTable and the corresponding Column drop-down menu, select the desired drop-down menu. Menu, after editing, click the new button at the top right to return to the Reader list page (see Figure 18). Click the Add Reader condition command to enter the Reader condition editing screen (see Figure 19). In the second stage, select GroupBy (see Figure 25), the Groupby field edit block appears on the lower left, and the DataSet drop-down menu on the lower right, and the DataTable drop-down menu. After the list, insert and cancel buttons, after entering the screen, select the DataSet to be grouped in sequence, and the corresponding DataTable appears. After selecting the DataTable to be grouped, the corresponding field name appears, check the box. The required field name, click the Insert button, you can appear in the left editing area, you can do the drag change order according to your personal needs or click the delete button to delete the action, or press the Cancel button to cancel the previous set behavior. After editing, click the new button at the top right to return to the Reader list page (see Figure 18). Click the Add Reader condition command to enter the Reader condition editing screen (see Figure 19). In the second stage, the instruction selects GroupBy (see Figure 25). The third stage instruction selects the comparison condition (Max, Min, Count, Sum, Avg) (see Figure 26). The fourth stage instruction inputs its field name. (You can do manual input), the DataSet drop-down menu below, DataTable drop-down menu, field drop-down menu, after entering the screen, first select the required comparison conditions, enter the field name, select by order DataSet, appears with Corresponding to the grouped DataTable, after selecting the DataTable to be used, the corresponding field drop-down menu appears, select the required field name, and after editing, click the new button at the top right to return to the Reader list. Page (see Figure 18), click on the new Reader conditional command to enter the Reader conditional editing screen (see Figure 19), and select OrderBy in the second stage (see Figure 27). The stage instruction selects the sorting state (Up, Down), the OrderBy field editing block appears in the lower left, the DataSet drop-down menu in the lower right, the DataTable drop-down menu, the field list, the insert and cancel buttons, after entering the screen, select sequentially The DataSet to be sorted, the corresponding DataTable appears. After selecting the DataTable to be sorted, the corresponding field name appears. Check the column name to be sorted according to the sorted field. Click the Insert button to appear in the left editing area. In the middle, you can do the drag change order according to your personal needs or click the delete button to delete the action, or press the cancel button to cancel the previous set behavior, edit completed After clicking the new button at the top right, you can return to the Reader list page (see Figure 18). Click the Add Reader condition command to enter the Reader condition editing screen (see Figure 19). The stage command selects Top (please refer to Figure 28), enters the number of pens in the third stage command (you can input the action action), and the existing DataSet drop-down menu appears. The DataTable pull-down menu, after entering the screen, select the desired one. The corresponding DataTable appears in the DataSet. Select the required DataTable. After editing, click the new button at the top right to return to the Reader list page (see Figure 18). Click the Add Reader condition command to enter Reader condition editing screen (please refer to Fig. 19), select Limit in the second stage command (please refer to Fig. 29), input the starting number in the third stage command (hand motion input action), and command in the fourth stage Enter the number of pens in the input (you can input the action by hand), the current DataSet drop-down menu appears, and the DataTable drop-down menu. After entering the screen, select the required DataSet to appear relative. The DataTable, election Select the required DataTable. After editing, click the new button at the top right to return to the Reader list page (see Figure 18). Click the Add Reader condition command to enter the Reader condition editing screen (see section 19)), select Join in the second stage instruction (please refer to Figure 30), input DataSetName in the third stage instruction (can input action action), input DataTableName in the third stage instruction (can input action action) The left and right blocks appear. The left block is the current DataSet drop-down menu. The existing DataTable drop-down menu, the existing list of existing fields, and the right block are sequentially the existing DataSet drop-down menu. The currently existing DataTable drop-down menu, the list of currently existing fields, after entering this screen, the first step is to input the DataSetName to be output in the third instruction, and then input the DataTableName to be output in the fourth instruction block, and then Start at the left block, first select the first DataTable to be combined, first select the first DataSet to be combined, and the corresponding After the DataTable drop-down menu, select the DataTable to be combined, and display the list of all the fields in the DataTable. After selecting the field to be combined, select the second DataSet to be combined. After the corresponding DataTable drop-down menu appears, select the combination. The DataTable, the list of all the fields in the DataTable appears, select the field according to the combination, after editing, click the new button at the top right to return to the Reader list page (see Figure 18), click If you add a Reader conditional instruction, you can enter the Reader conditional editing screen (see Figure 19), select GetDataSet in the second stage (see Figure 31), and enter the DataSetName to be output in the third stage of the instruction. The existing DataSet drop-down menu, DataTable drop-down menu, insert button and edit block, enter the screen, input the DataSetName to be output before the third stage instruction, and then select the corresponding DataTable drop-down menu for the DataSet to be output. After selecting the DataTable to be output, click the Insert button to add it to the lower block. To change the order position by dragging at random, or click the delete button to delete the DataTable. After editing, click the new button at the top right to return to the Reader list page (see Figure 18), click Add. The Reader conditional instruction can enter the Reader conditional editing screen (see Figure 19). In the second stage, the instruction selects GetDataTable (see Figure 32), and enters the DataTableName to be output in the third stage instruction. There is a DataSet drop-down menu, DataTable drop-down menu. After entering the screen, input the DataTableName to be output before the third-stage instruction, then select the corresponding DataTable drop-down menu for the DataSet to be output, select the DataTable to be output, and edit it. After clicking the new button at the top right, you can return to the Reader list page (see Figure 18). At this point, the Reader edit description ends here. If the Reader is edited, click the new button at the top right to return to the command. List page (please refer to Figure 10), you can click the command code on the right to test the zoom out window button, after expansion (please Referring to Figure 33), the upper block and the lower block appear from the upper left of the upper block to the StringDataName input box, the StringData input box, and the upper right block of the upper block sequentially pulls down the module drop-down menu, database Drop-down menu, data table drop-down menu, data table field list, insert and cancel button, lower block is the default expanded window check block, test result expand button, test result export button, timely test result window, enter the page After that, the system will automatically generate the corresponding StringData in the StringData box according to the input command. You can select DataSetName, DataTableName in the upper right order according to your personal needs, and click the Insert button in the field to insert the left StringData. In the area, the user is provided for editing, or the cancel button is selected to cancel the previous setting behavior. After the editing is completed, the test button can be pressed, and the test result will be displayed in the instant test window below, which can be pre-previously If you open the checkbox in the expanded window, or click the test result to expand the button, a new one will pop up. Window displays the test results, The result can be clicked on the test result export button, the test result is exported. If you need to store the StringData, you can enter the name in the input box of StringDataName, press the save button to save the action, you can click in the future. After entering the preset test code, select the StringData of this edit to provide future test and use. After the test is completed, return to the instruction list (please refer to Figure 10). After editing the command, you can click the file save button to save the command. You can expand it in the command code history reduction window button on the right (see Figure 34), you can see the history list of all the instructions, click to load the action, and return to the instruction list. (Please refer to Figure 10), or click the delete button to delete its history record. The instruction code has been completely completed until the current action. The code is stored according to the instructions established by the user. In the database, the user can call the instruction in the project for use.

The OTS virtual data table management system is described as follows: (Please refer to the simplified flow chart 4) Open the OTS system, click the virtual data table management button, and generate the project manager to list all the projects (please refer to Figure 35). Enter the project name in the input box and press the Save Project button to add a new project action, or click the Modify button. The project name will appear in the input box. After modifying the project name, press the Save Project button to save the project. Click to delete ICON to delete the selected project. Enter the search keyword in the input box and click KeyWord Search to search for the keyword. The search result is displayed in the list below. To open the project, please click first. Project name, open the project data list (see Figure 36), this page has search input box, search button, add data table button, the data table list below has its data sheet name, field ICON, associated ICON , ICON, modify ICON, delete ICON, enter the screen, you can make key input in the input box, click on the right to search for ICON, search for the knot Will appear below the list, new data table after referral click a new table button (NewTable) Face (please refer to Figure 37), enter the data sheet number, data sheet name, data sheet description, click the SaveTable button, the screen will return to the project data list (see Figure 36), click After modifying the ICON of the list, the data table modification interface appears (please refer to Figure 37). After the data of the data sheet is generated in advance, the user can make modifications. You can enter the data sheet number, the data sheet name, and the data sheet description. Click the SaveTable button, the screen will return to the project data list (see Figure 36), or click the delete button to delete the data table, or click the field ICON, will Display the column list of all the fields in the data table (please refer to Figure 38). The page has a field search input box, search ICON, add a new field ICON (New Column), a list of fields, the list has a primary key ICON, ID value, field name, field type, field preset value, field attribute, field description, modify ICON, delete ICON, after entering the screen, you can input in the input box according to the keyword you want to query. , click on the right to search for ICON, search The result will be presented in the list below. After clicking the New Field button on the top right (NewColumn), the new field interface appears (see Figure 39). The new field interface has a field name input box, field type. State drop-down menu (with Nvarchar, Ntext, Time, Money, TinyInteger, Integer, BigInteger), field preset input box, primary key check block and automatic number check block of field attribute, field description input block, SaveColumn button, after the user fills in the above fields, click the SaveColumn button, the screen will return to the list of all the fields in the data table (see Figure 38), if you click the modified ICON in the list, The modified field interface appears (see Figure 39). The modified field interface has a field name input box, and the field type drop-down menu (with Nvarchar, Ntext, Time, Money, TinyInteger, Integer, BigInteger), field Preset value input box, primary key selection block and automatic number verification block of field attribute, field description input block, SaveColumn button, after entering the modification page, the previously stored data will be pre-loaded for use. By After filling in the above fields and modifying them, click the SaveColumn button, the screen will return to the column list of all the fields in the data table (please refer to Figure 38), or click to delete ICON to delete the selected column. Bit, field setting is the function currently displayed. After the field setting is completed, return to the list of data sheets of the project (please refer to Figure 36). Click on the information ICON in the list to enter the data sheet of the data sheet (please See Figure 40), the screen for all the data lists in its data sheet can be clicked on the right side of the list to delete ICON to delete its data, return to the project data list (see Figure 36), click on the list The associated ICON can be associated with its data table, and the data table association setting interface is opened (see Figure 41). There is a data table name drop-down menu, a data column name drop-down menu, and the associated data table name drop-down. Menu, associated data table field name drop-down menu, association type drop-down menu (synchronous update, synchronous deletion), and SaveRelation button, the list is the current association list of the data table, record and the data table Linked data table, the list content has ID value, data table, data table field, associated data table, associated data table field, modify ICON, delete ICON, enter the screen, its data sheet name The drop-down menu is preset to the data sheet selected by the project's data sheet list (see Figure 36). The field drop-down menu is the field menu in the data sheet. The associated data sheet name drop-down menu is currently all. In the data table, the associated data table field name drop-down menu is the relevant field of the associated data table. After selecting the data table name, the corresponding field name appears. After selecting the field name to be associated, the selection is associated. The data table, the corresponding associated data table field appears, select the field to be associated, select its interconnection type, press the SaveRelation button to appear in the list below, the association is formally established, can be below Click to modify ICON in the list, the related information will appear in the data table name drop-down menu above, the data column name drop-down menu, the associated data table name drop-down menu, be Associated table column names the drop-down menu, association type drop-down menu, providing users Make edits and edits. After editing, click the SaveRelation button, or click the Delete button to associate it with the delete action. After the association settings are completed, the basic settings of the virtual data table have been completed and can be edited in the script. In the system, use it for editing.

The OTS verification engine management system is described as follows: (See the simple flow chart, Figure 5) Open the OTS system, click the verification engine management button, and generate the module management interface (see Figure 42). The interface has an input box. Keyword search button, storage module button, category management button, module list (item, module name, category ICON, preset ICON, custom ICON, data table ICON, type ICON, modify ICON, delete ICON), enter After the screen, you can enter the module keyword to be searched in the input box, click the right keyword search button, and then click the list to display the search results. If you want to add a module, enter it in the input box. After clicking the storage module button after the module name, and adding new ones, if you want to modify the module, you can click the modified ICON in the list below. The module name will appear in the input box, and the user can modify it. After the user modifies and presses the storage module button, if you want to delete the module, you can delete the ICON by clicking the list. Each module has its type of verification. Click on the list. Type I After CON, you can enter the verification type management interface (see Figure 43). The interface has input box, search ICON, storage type button, verification type list (item, type name, modify ICON, delete ICON), in the input box. After entering the keyword and clicking the search ICON on the right, the search result will be displayed in the list below. To add the verification type, enter the type name in the input box and click the storage type to display the verification in the list below. Type, if you want to modify the verification type, click Modify ICON in the list below, the modified verification type name will be displayed in the input box, provide the user to modify, click the storage type button after editing. If you want to delete the verification type, click Delete ICON in the list below, you can delete the selected verification type, verification type. After editing, return to the module management interface (please refer to Figure 42). After clicking the data table ICON, open the data sheet management interface page of the module (please refer to Figure 44). The interface is divided into two majors. Block, the left block is the data table management block, the right block is the management block of the data table field, the left block is the input box, the search ICON, the storage data table button, the data table list (ID Value, data table name, Select check block, modify ICON, delete ICON), the right block is the input box, search ICON, store field button, data table field list (ID value, data table name, modification) ICON, delete ICON), after entering the interface, if you want to search the data table, enter the field name in the input box, click the search ICON on the right to display the search result in the list of data tables below. Search results, if you want to add a data sheet, enter the data sheet name in the input box, press the save data sheet button to appear in the list below. To modify the data sheet name, click on the list below. After modifying ICON, its data sheet name will appear In the input box, the user is allowed to make edits and edits. After editing, click the Save Data Table button, or click Delete ICON in the list to delete the selected data table. The relevant field of the data table, that is, the check box in the check box next to the data table, the associated data table field appears in the column list on the right (see Figure 45), if you want to search The field information, in the input box, after entering the keyword, click on the search ICON, the column list will appear its search results, if you want to add a field, enter the field name in the input box, click The storage field is newly added. If you want to modify the field, in the lower field list, after clicking ICON, the field name will be displayed in the input box, and the user will be used for editing. After editing, Press the storage field. To delete the field, click Delete ICON in the field list to delete it. After the setting is completed, you can return to the module management interface (see Figure 42). Click the preset ICON in the verification list to enable the default verification settings. Fixed interface paging (see Figure 46), the interface has two major areas Block, the left block is the data table block, the right block is the verification setting block, the left block has the input box, the search ICON, the data table list, the right block has the input box, the search ICON, Add verification button, verification list (ID value, field name, verification type, verification value, error message, modify ICON, delete ICON), if you want to search the data table, enter the keyword in the input box on the left, click Selecting the right side to search for ICON, the search result list appears in the data list. If you want to view the verification type of the data table, select SelectICON in the list of the left data list, then all the verifications of the data table appear in the verification list on the right. For the list, if you want to query the verification data, enter the keyword in the input box on the right and click the search ICON on the right. The search result will be displayed in the verification list below. If you want to add verification, click the new one. Add verification button, the new verification input block appears (please refer to Figure 47). The interface has the verification field drop-down menu, verification type drop-down menu, verification data input box, error message input box, and storage verification button. After the screen, select the field to be verified, select its verification type, input the verification data, input the error message that needs to appear after the verification error, click the save verification and complete the new action after the editing is completed, the screen will return. The default verification setting interface page (see Figure 46), if you want to modify the verification data, click Modify ICON in the verification list, and the modification verification input block appears (see Figure 47). The interface has a verification field. Drop-down menu, verification type drop-down menu, verification data input box, error message input box, and storage verification button. After entering the screen, the system will pre-load the previously stored content, and provide the user for editing and use. Select the field to be verified, select its verification type, enter the verification data, input the error message that needs to appear after the verification error, click the save verification after the editing is completed, the modification action will be completed, and the screen will return to the preset verification setting interface page. (Please refer to Figure 46). If you want to delete the verification type, you can delete the verification data after deleting ICON in the list. After editing the verification, return to the module management interface (see Figure 42), click on the module list Customized ICON, open the list of verified customized groups (see Figure 48), this interface has input box, search ICON, storage group button, group list (ID value, group name, join category ICON, Modify ICON, delete ICON). To search for a group, enter the keyword in the input box and click the search ICON on the right. The search result will be displayed in the list below. If you want to add a group, enter the box. After entering the group name and clicking the Save Group button, it will appear in the group list below. If you want to modify the group name, click Edit ICON in the group list, the group name will be displayed in the input box. To provide users with editing and editing, click the Save Group button after editing. If you want to delete the group, click Delete ICON in the group list, that is, you can delete the selected group. To edit the group verification content, click the group name in the group list to open the customized group verification interface page (see Figure 49). The interface has two left and right blocks, and the left block is Data table block, right block for verification Fixed block, left block has input box, search ICON, data list, right block has input box, search ICON, new verification button, verification list (ID value, field name, verification type, Verify value, error message, modify ICON, delete ICON), if you want to search the data table, enter the keyword in the input box on the left, click on the right to search for ICON, then the search results appear in the data list, if it is new The module will load the preset verification data for the first time, and then it will store the verification content. If you want to view the verification type of the data table, select SelectICON in the list of data sheets on the left. The verification list of the party will display all the verification lists of the data table. If you want to query the verification data, enter the keyword in the input box on the right and click the search ICON on the right. The search results will be in the verification list below. Display, if you want to add verification, click the Add New Validation button and the new verification input block appears (see Figure 50). The interface has a verification field drop-down menu, a verification type drop-down menu, and a verification data input box. Error message Input box, and save verification button, after entering the screen, select the verification that needs to be verified. Field, select its verification type, enter the verification data, input the error message that needs to appear after the verification error, click the save verification after editing to complete the new action, the screen will return to the default verification setting interface page (see Figure 49) If you want to modify the verification data, click Modify ICON in the verification list, and the modification verification input block appears (see Figure 50). The interface has the verification field drop-down menu, verification type drop-down menu, and verification. Data input box, error message input box, and save verification button. After entering the screen, the system will pre-load the previously stored content, and provide the user for editing. The user can select the field to be verified and select it. The type of verification, input the verification data, input the error message that needs to appear after the verification error, click the save verification after editing to complete the modification action, and the screen will return to the preset verification setting interface page (see Figure 49), such as To delete the verification type, click Delete ICON in the list to delete the verification data. After editing the verification, return to the module management. Face (see Figure 42), click on the category ICON in the module list to open the custom category setting screen (see Figure 51). There is an input box, search ICON, new category button, category list. (ID value, category name, modify ICON, delete ICON), if you want to search for classification, enter the keyword in the input box and click Search ICON. The search result appears in the category list below. If you want to add a category, Enter the category name in the input box and click on the storage category to appear in the list below. If you want to modify the category, click on the modified ICON in the category list, the category name will be displayed in the input box, and the user will be edited. Modify the use, click on the save category after editing. If you want to delete the category, click the delete button to delete the selected category. If you need to edit the category or open the category, select the category list. The category name, that is, you can open the category content editing interface page (see Figure 52). The interface has input box, search ICON, module list (ID value, module name, GroupID, group name, Open ICON, delete ICON), if you want to search for modules, enter the input in the input box. After the key, click Search ICON, the search result will be displayed in the list. If you want to delete the set module, click Delete ICON in the list to delete the set module. If you want to open the module's verification settings. Interface, that is, click OpenICON in the list to open its verification module component page, the verification engine can directly play the role after the setting is completed, no need to do other setting actions.

A2‧‧‧OpenCommand.Basic

A3‧‧‧OpenCommand.Command

A4‧‧‧OpenCommand.SQL

A5‧‧‧OpenCommand.System

AA1‧‧‧OpenCommand.App

A6‧‧‧OpenCommand.Admin

A7‧‧‧OpenCommand.Table

A8‧‧‧OpenCommand.File

A9‧‧‧OpenCommand.Form

A10‧‧‧OpenCommand.Log

AA2‧‧‧OpenCommand.App.Basic

A11‧‧‧OpenCommand.CMS

A12‧‧‧OpenCommand.Web

A13‧‧‧OpenCommand.Member

A14‧‧‧OpenCommand.Banner

A15‧‧‧OpenCommand.Service

A16‧‧‧OpenCommand.People

AA3‧‧‧OpenCommand.App.Basic

A17‧‧‧OpenCommand.Product

A18‧‧‧OpenCommand.Store

A19‧‧‧OpenCommand.Point

A20‧‧‧OpenCommand.Code

A21‧‧‧OpenCommand.Finance

A22‧‧‧OpenCommand.Order

AA4‧‧‧OpenCommand.App.Shop

A23‧‧‧OpenCommand.Ticket

A24‧‧‧OpenCommand.Vote

A25‧‧‧OpenCommand.Message

AA5‧‧‧OpenCommand.App.Protal

A26‧‧‧OpenCommand.HR

A27‧‧‧OpenCommand.Attendance

A28‧‧‧OpenCommand.Leave

A29‧‧‧OpenCommand.KPI

A30‧‧‧OpenCommand.Bonus

A31‧‧‧OpenCommand.Salary

AA6‧‧‧OpenCommand.App.HR

A32‧‧‧OpenCommand.Bill

A33‧‧‧OpenCommand.CRM

A34‧‧‧OpenCommand.My

A35‧‧‧OpenCommand.Quotation

AA7‧‧‧OpenCommand.App.CRM

A36‧‧‧OpenCommand.Flow

A37‧‧‧OpenCommand.Project

A38‧‧‧OpenCommand.WorkForm

A39‧‧‧OpenCommand.Asset

AA8‧‧‧OpenCommand.App.EIP

A40‧‧‧OpenCommand.Purchase

A41‧‧‧OpenCommand.Receivable

A42‧‧‧OpenCommand.Payable

A43‧‧‧OpenCommand.Tax

A44‧‧‧OpenCommand.Production

AA9‧‧‧OpenCommand.App.ERP

A45‧‧‧ currently in expansion

AA10‧‧‧OpenCommand.App.Rich

A46‧‧‧OpenCommand.Plugin.Contract

AB1‧‧‧OpenCommand.Plugin.App.Basic

A47‧‧‧OpenCommand.Plugin.Fish

A48‧‧‧OpenCommand.Plugin.Harbor

AB2‧‧‧OpenCommand.Plugin.App.Sea

A49‧‧‧OpenCommand.Plugin.Country

A50‧‧‧OpenCommand.Plugin.House

A51‧‧‧OpenCommand.Plugin.Room

AB3‧‧‧OpenCommand.Plugin.App.Ground

A52‧‧‧OpenCommand.Plugin.School

AB4‧‧‧OpenCommand.Plugin.App.Area

A53‧‧‧OpenCommand.Plugin.Bicycle

A54‧‧‧OpenCommand.Plugin.Car

A55‧‧‧OpenCommand.Plugin.Motorcycle

A56‧‧‧OpenCommand.Plugin.Ship

AB5‧‧‧OpenCommand.Plugin.App.Vehocle

A57‧‧‧OpenCommand.Plugin.Class

A58‧‧‧OpenCommand.Plugin.Curriclum

AB6‧‧‧OpenCommand.Plugin.App.Regular

AC1‧‧‧OpenCommand.SI.Protal

AC2‧‧‧OpenCommand.SI.ERP

B1‧‧‧Opendoor.Tool.Studio(OTS)

BA1‧‧‧ Code Management

BB1‧‧‧Project Management

BC1‧‧‧Project Command Management

BD1‧‧‧ instruction code classification management

BD2‧‧‧code management

Code management for BE1‧‧‧ instructions

BG1‧‧‧ instruction code editing mode

BG2‧‧‧ source code editing mode

BG3‧‧‧ file import

BG4‧‧‧ file remittance

BG5‧‧‧ instruction code instruction editing

BH1‧‧‧Set

BH2‧‧Check

BH3‧‧‧Insert

BH4‧‧‧Update

BH5‧‧‧Delete

BH6‧‧‧Logic

BH7‧‧‧Use

BH8‧‧‧Reader

BH9‧‧‧Code History

BH10‧‧‧ instruction code test function

BA2‧‧‧Virtual Data Sheet Management

BB2‧‧‧Virtual Data Sheet Management

BC2‧‧‧Virtual Data Table Settings

BC3‧‧‧Virtual Data Table Field Settings

BC4‧‧‧Virtual Data Table Association Settings

BA3‧‧‧Verification Engine Management

BB3‧‧‧Module Management

BB4‧‧‧Classification Management

BB5‧‧‧ Type Management

BB6‧‧‧ Data Sheet Management

BC5‧‧‧Data Sheet Management

BC6‧‧‧Data Sheet Field Management

BB7‧‧‧Default verification management

BB8‧‧‧Customized verification management

C1‧‧‧OpenCommand Directive

CA1‧‧‧Set

CA2‧‧Check

CA3‧‧‧Insert

CA4‧‧‧Update

CA5‧‧‧Delete

CA6‧‧‧Logic

CA7‧‧‧Use

CA8‧‧‧Reader

CB1‧‧‧Max

CB2‧‧‧Min

CB3‧‧‧Sum

CB4‧‧‧Count

CB5‧‧‧Avg

CB6‧‧‧Where

CC1‧‧‧Max

CC2‧‧‧Min

CC3‧‧‧Sum

CC4‧‧‧Count

CC5‧‧‧Avg

CB7‧‧‧Groupby

CC6‧‧‧Max

CC7‧‧‧Min

CC8‧‧‧Sum

CC9‧‧‧Count

CC10‧‧‧Avg

CB8‧‧Join

CB9‧‧‧Orderby

CC11‧‧‧Up

CC12‧‧‧Down

CB10‧‧‧Merge

CC12‧‧Join

CB11‧‧‧Top

CB12‧‧‧Limit

CB13‧‧‧GetDataSet

CB14‧‧‧GetDataTable

Claims (3)

A database modular design system divides the database into several different databases according to each function. According to the customer's needs and required functions, the database can meet the customer's demand standard, and the unified operation program and convenient management can be facilitated. The task of load balancing and permission control of the database, as well as the optimization of the database system, is aimed at simplifying the workflow and accelerating the operation time. An instructional program that uses a command to write a script and converts it into a corresponding program syntax through a back-end code. The code needs to be used in conjunction with the database module applied for in this patent. A Window Form tool, the tool contains three major blocks, including script editing system, virtual data table system, and verification engine management system.