Storage process driven flow configuration system and method
By using a stored procedure-driven process configuration system and customizing the syntax and parsing algorithm of the configuration file, the system achieves flexibility and maintainability in process configuration, solving the problems of poor flexibility and high coupling in traditional configuration methods, and ensuring data accuracy and business process stability.
Patent Information
- Application Number
- CN202510620073.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-05-14
- Publication Date
- 2026-01-09
Smart Images
Figure CN121301043A_ABST
Abstract
Description
Technical Field
[0001] This invention belongs to the field of computer technology, specifically relating to a stored procedure-driven process configuration system and method. Background Technology
[0002] According to the "2023 Global Industrial Software Development Report," 89% of manufacturing enterprises face the dual challenges of "rapid iteration of business processes" and "compatibility with legacy systems." In the smart manufacturing industry, the management and execution of production processes require a high degree of flexibility and configurability. Initially, process implementation largely relied on hard-coding, such as creating UI elements like input boxes and buttons in C# development and binding fixed event handling logic to buttons. This approach made process modification and expansion extremely difficult; each change in business requirements necessitated extensive code modifications, resulting in long development cycles and low efficiency. With the industry's development, the demand for process configuration systems capable of rapidly responding to business changes is growing.
[0003] In the field of intelligent manufacturing, traditional process configuration methods (code development, low-code platforms, declarative configuration) have problems such as poor flexibility, high coupling, and insufficient verification, making it difficult to adapt to the rapid iteration of business processes and the compatibility requirements of legacy systems. Summary of the Invention
[0004] The purpose of this invention is to solve the problem by proposing a stored procedure-driven process configuration system and method.
[0005] In a first aspect of the invention, a stored procedure-driven process configuration system is provided, the system comprising a client and a server; wherein:
[0006] The client is configured to receive configuration instructions for the display interface and send the configuration instructions to the server; the configuration instructions are generated by preset syntax rules.
[0007] The server is used to verify the configuration command, and when the configuration command is successful, it parses the configuration command to obtain configuration information and sends the configuration information to the client.
[0008] The client is used to dynamically create and render input controls and process options for the display interface based on configuration information.
[0009] In a second aspect of this invention, a stored procedure-driven process configuration method is also provided, the method being applied to a server, the method comprising:
[0010] Receive configuration instructions for the display interface sent by the client; the configuration instructions are generated by preset syntax rules;
[0011] The configuration command is verified. If the configuration command is successful, the configuration command is parsed to obtain configuration information, and the configuration information is sent to the client so that the input controls and process options of the display interface can be dynamically created and rendered according to the configuration information.
[0012] Optionally, the preset syntax rules include:
[0013] UNIT represents the name of a process unit. There is a blank line between each UNIT. Stored procedures in a UNIT begin with #.
[0014] FLOW represents menu options, including parameter one and parameter two; parameter one is a fixed list or a called stored procedure; parameter two is a custom temporary variable.
[0015] INPUT represents other inputs such as keyboard or barcode scanner input, including parameters three, four, five, and six; parameter three represents the data format, including TXT and INT; parameter four represents the prompt text; parameter five represents a custom temporary variable; and parameter six is the format verification value.
[0016] Optionally, the configuration instruction includes an input value dictionary and a processing configuration object, and verifying the configuration instruction includes:
[0017] Iterate through each cell in the configuration object to obtain a cell set;
[0018] For each unit in the unit set, traverse each input configuration in that unit, and for each input configuration, determine whether the regular expression of the input configuration satisfies a preset condition; the preset condition is that the input configuration is not empty and the input value dictionary contains the variable of the input configuration.
[0019] If the preset conditions are met, a database connection object and an SQL command object are created, and the command type is set to stored procedure;
[0020] If all input configurations meet the corresponding preset conditions, the rule verification result is qualified.
[0021] Optionally, parsing the configuration instructions to obtain configuration information includes:
[0022] Create a ProcessConfig object, get the configuration file path, read all lines of the configuration file, iterate through each line, and if the line starts with [UNIT], create a new ProcessUnit object, set the name and add it to the unit list of ProcessConfig;
[0023] If the line begins with [FLOW], the stream options are extracted, split into key-value pairs, and added to the ProcessUnit's stream options dictionary;
[0024] If the line begins with [INPUT], create an InputConfig object, set the relevant information, and add it to the ProcessUnit's input list;
[0025] Retrieves the result after traversing all rows and returns a ProcessConfig object as configuration information.
[0026] In a third aspect of this invention, a stored procedure-driven process configuration method is also provided, the method being applied to a client, the method comprising:
[0027] The system receives a configuration instruction for the display interface and sends the configuration instruction to the server. The server then verifies the configuration instruction; upon successful verification, it parses the configuration instruction to obtain configuration information and sends the configuration information to the client. The configuration instruction is generated using preset syntax rules.
[0028] The input controls and process options of the display interface are dynamically created and rendered based on the configuration information.
[0029] Optionally, the preset syntax rules include:
[0030] UNIT represents the name of a process unit. There is a blank line between each UNIT. Stored procedures in a UNIT begin with #.
[0031] FLOW represents menu options, including parameter one and parameter two; parameter one is a fixed list or a called stored procedure; parameter two is a custom temporary variable.
[0032] INPUT represents other inputs such as keyboard or barcode scanner input, including parameters three, four, five, and six; parameter three represents the data format, including TXT and INT; parameter four represents the prompt text; parameter five represents a custom temporary variable; and parameter six is the format verification value.
[0033] Optionally, parsing the configuration instructions to obtain configuration information includes:
[0034] Create a ProcessConfig object, get the configuration file path, read all lines of the configuration file, iterate through each line, and if the line starts with [UNIT], create a new ProcessUnit object, set the name and add it to the unit list of ProcessConfig;
[0035] If the line begins with [FLOW], the stream options are extracted, split into key-value pairs, and added to the ProcessUnit's stream options dictionary;
[0036] If the line begins with [INPUT], create an InputConfig object, set the relevant information, and add it to the ProcessUnit's input list;
[0037] Retrieves the result after traversing all rows and returns a ProcessConfig object as configuration information.
[0038] Optionally, the input controls and flow options for the display interface can be dynamically created and rendered based on configuration information, including:
[0039] Step 1, Start: The process begins; enter the ProcessConfig object.
[0040] Step 2, Initialization: Create an empty List <control>Used to store controls, initialize yOffset to 10;
[0041] Step 3, Cell Traversal: Begin traversing each cell in the ProcessConfig object;
[0042] Step 4, Input Configuration Traversal: For each input configuration in the current cell, create a Label control and set its text and position, add it to the control list, create a TextBox control and set its position, if the input configuration variable is not empty, set the name of the TextBox, add the TextBox to the control list, and increase yOffset by 30;
[0043] Step 5, process option traversal: For each process option in the current cell, create a Button control and set its text and position, add processing logic for the Button's click event, add the Button to the control list, and increase yOffset by 30;
[0044] Step 6, End Judgment: If there are still unprocessed units, execute steps 1 to 5 for the unprocessed units; otherwise, convert the control list to an array and return it, and the process ends.
[0045] The beneficial effects of this invention are:
[0046] This invention proposes a stored procedure-driven process configuration system, comprising a client and a server. The client receives configuration instructions for the display interface and sends these instructions to the server. These configuration instructions are generated using preset syntax rules. The server verifies the configuration instructions; upon successful verification, it parses the instructions to obtain configuration information and sends this information to the client. The client dynamically creates and renders input controls and process options for the display interface based on the configuration information. This invention's process configuration system features a customizable configuration file syntax and parsing algorithm, enabling accurate parsing of various instructions and parameters within the configuration file. Its dynamic rendering mechanism dynamically creates and renders input controls and process options based on the configuration information. The system also includes input data validation and unified processing of business logic, ensuring data accuracy and the normal execution of the business process. Attached Figure Description
[0047] The invention will now be further described with reference to the accompanying drawings.
[0048] Figure 1 A flowchart illustrating a stored procedure-driven process configuration method provided in an embodiment of the present invention;
[0049] Figure 2 A framework diagram of a stored procedure-driven process configuration system provided in an embodiment of the present invention;
[0050] Figure 3 A flowchart illustrating a stored procedure-driven process configuration method applied to a client, as provided in an embodiment of the present invention;
[0051] Figure 4 A flowchart illustrating another stored procedure-driven process configuration method applied to a client, provided as an embodiment of the present invention. Detailed Implementation
[0052] The technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments.
[0053] Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.
[0054] This invention provides a stored procedure-driven process configuration system, see [link to relevant documentation]. Figure 1 , Figure 1 This invention provides a system block diagram of a stored procedure-driven process configuration system, the system including a client and a server; wherein:
[0055] The client is used to receive configuration instructions for the display interface and send configuration instructions to the server; the configuration instructions are generated by preset syntax rules.
[0056] The server is used to verify configuration commands. When a configuration command is successful, it parses the configuration command to obtain configuration information and sends the configuration information to the client.
[0057] The client is used to dynamically create and render input controls and flow options for the display interface based on configuration information.
[0058] Based on the embodiments of the present invention, a stored procedure-driven process configuration system is provided, which features a custom syntax and parsing algorithm for the configuration file to accurately parse various instructions and parameters in the configuration file, a dynamic rendering mechanism for controls to dynamically create and render input controls and process options based on configuration information, and unified processing of input data validation and business logic to ensure data accuracy and normal execution of business processes.
[0059] In one implementation, the client includes a data acquisition module and a control rendering module. The data acquisition module is used to collect configuration instructions input by technicians, and the control rendering module is used to dynamically create and render input controls and process options for the display interface based on the configuration information.
[0060] The server includes a validation module, a cache processing module, a syntax parsing module, a stored procedure execution module, a routing control module, and a control output module. The validation module is used to validate configuration instructions, and the syntax parsing module is used to parse configuration instructions.
[0061] In one embodiment, the preset syntax rules include:
[0062] UNIT represents the name of the process unit. Each UNIT is separated by a blank line. Stored procedures within a UNIT begin with #. FLOW represents menu options, including parameter one and parameter two. Parameter one is a fixed list or a called stored procedure. Parameter two is a custom temporary variable. INPUT represents other inputs such as keyboard or barcode scanner input, including parameter three, parameter four, parameter five, and parameter six. Parameter three represents the data format, including TXT and INT. Parameter four represents the prompt text. Parameter five represents a custom temporary variable. Parameter six is the format validation value.
[0063] In one implementation, UNIT specifies the name of the process unit.
[0064] Note: Each UNIT should be separated by a blank line, and all stored procedures within a UNIT should begin with #.
[0065] Example: [UNIT] = TEST
[0066] FLOW Description: Menu option.
[0067] Parameter description: Parameter 1: Fixed list or called stored procedure; Parameter 2 (can be omitted): Custom temporary variable.
[0068] Note: Enclose each option in parentheses (), and separate each option with a comma.
[0069] example:
[0070] [FLOW]=(2:2th floor,3:3th floor;@floor_code)
[0071] [FLOW]=(#FLOWOPTION@TERMINAL_ID)
[0072] [FLOW]=(2:2th floor,3:3th floor)
[0073] INPUT Description: Input from keyboard, barcode scanner, or other sources;
[0074] Parameter description: Parameter 1: Data format (TXT or INT); Parameter 2: Prompt text; Parameter 3 (optional): Custom temporary variable; Parameter 4 (optional): Format verification.
[0075] Example: [INPUT]=TXT; User ID; @user; ^[a-zA-Z0-9]{6}$
[0076] This invention provides a process configuration method for stored procedure-driven applications on servers. See [link to relevant documentation]. Figure 2 , Figure 2 This invention provides a flowchart of a process configuration method for a stored procedure driven by a server, as described in an embodiment of the present invention. The method includes:
[0077] S201, Receive configuration instructions for the display interface sent by the client; the configuration instructions are generated by preset syntax rules;
[0078] S202, Verify configuration command. If the configuration command is successful, parse the configuration command to obtain configuration information and send the configuration information to the client; so that the input controls and process options of the display interface can be dynamically created and rendered according to the configuration information.
[0079] Based on the embodiments of the present invention, a storage procedure-driven process configuration method for servers is provided. The method features a custom syntax and parsing algorithm for the configuration file, which can accurately parse various instructions and parameters in the configuration file. The dynamic rendering mechanism of the controls dynamically creates and renders input controls and process options according to the configuration information. The method also includes input data validation and unified processing of business logic to ensure data accuracy and normal execution of business processes.
[0080] In one embodiment, the configuration instructions include an input value dictionary and a processing configuration object, and the verification configuration instructions include:
[0081] Iterate through each cell in the configuration object to obtain a cell set;
[0082] For each cell in the cell set, iterate through each input configuration in that cell. For each input configuration, determine whether the regular expression of that input configuration meets the preset conditions. The preset conditions are that the input configuration is not empty and the input value dictionary contains the variable of that input configuration.
[0083] If the preset conditions are met, a database connection object and an SQL command object are created, and the command type is set to stored procedure;
[0084] If all input configurations meet the corresponding preset conditions, the rule verification result is qualified.
[0085] In one embodiment, parsing configuration instructions to obtain configuration information includes:
[0086] Create a ProcessConfig object, get the configuration file path, read all lines of the configuration file, iterate through each line, and if the line starts with [UNIT], create a new ProcessUnit object, set the name and add it to the unit list of ProcessConfig;
[0087] If the line begins with [FLOW], the stream options are extracted, split into key-value pairs, and added to the ProcessUnit's stream options dictionary;
[0088] If the line begins with [INPUT], create an InputConfig object, set the relevant information, and add it to the ProcessUnit's input list;
[0089] Retrieves the result after traversing all rows and returns a ProcessConfig object as configuration information.
[0090] This invention provides a method for configuring a stored procedure-driven process applied to a client, see [link to relevant documentation]. Figure 3 , Figure 3 This invention provides a flowchart of a stored procedure-driven process configuration method applied to a client, the method comprising:
[0091] S301 receives configuration instructions for the display interface and sends the configuration instructions to the server; the server then verifies the configuration instructions, parses the configuration instructions to obtain configuration information after successful configuration, and sends the configuration information to the client; the configuration instructions are generated by preset syntax rules.
[0092] S302 dynamically creates and renders input controls and process options for the display interface based on configuration information.
[0093] Based on the embodiments of the present invention, a stored procedure-driven process configuration method for client applications is provided. The method features a custom syntax and parsing algorithm for the configuration file, which can accurately parse various instructions and parameters in the configuration file. The dynamic rendering mechanism of the controls dynamically creates and renders input controls and process options according to the configuration information. The method also includes input data validation and unified processing of business logic to ensure data accuracy and normal execution of the business process.
[0094] In one embodiment, see Figure 4 Based on step 3, step S302 includes:
[0095] S3021, Start: Process begins, input ProcessConfig object;
[0096] S3022, Initialization: Create an empty List <control>Used to store controls, initialize yOffset to 10;
[0097] S3023, Cell Traversal: Begin traversing each cell in the ProcessConfig object;
[0098] S3024, Input Configuration Traversal: For each input configuration in the current cell, create a Label control and set its text and position, add it to the control list, create a TextBox control and set its position, if the input configuration variable is not empty, set the name of the TextBox, add the TextBox to the control list, and increase yOffset by 30;
[0099] S3025, Process Option Traversal: For each process option in the current unit, create a Button control and set its text and position, add processing logic for the Button's click event, add the Button to the control list, and increase yOffset by 30;
[0100] S3026, End judgment: If there are still unprocessed units, then execute steps S3021 to S3025 for the unprocessed units; otherwise, convert the control list into an array and return it, and the process ends.
[0101] In one embodiment, a comparative experiment is used to verify the improved flexibility, enhanced maintainability, and effective data verification of the system and method of the present invention.
[0102] 1. Enhanced flexibility: By using custom syntax configuration files, the system can quickly adjust processes according to business needs without modifying the code.
[0103] For example, when a new process option or input item needs to be added, simply make the corresponding modification in the configuration file.
[0104] Test scenario:
[0105] 50 process changes (adding input items / modifying business rules)
[0106] Metrics: Development cycle (hours), number of code modifications (lines), number of test case adjustments (items);
[0107] Test results:
[0108] index control group experimental group Improvement rate Average development cycle 48h 4h 91.7％ Average code modification count 1200 lines 80 lines 93.3％ Test case adjustment amount 45 articles 5 items 88.9％
[0109] 2. Enhanced Maintainability: Separating business rules and interface configurations reduces system coupling. When business processes change, only the configuration file needs to be modified, reducing code changes and improving system maintainability.
[0110] Test scenario:
[0111] 100 production environment maintenance requests
[0112] Indicators: Average response time (hours), post-maintenance failure rate (%), maintenance cost (RMB / time);
[0113] Test results:
[0114] index control group experimental group Improvement rate Average response time 8h 2h 75％ Failure rate after maintenance 12％ 2％ 83.3％ Maintenance costs ￥2000 ￥300 85％
[0115] 3. Effective data validation: Input data validation and business rule processing are carried out in a unified manner, enabling real-time validation of user input, preventing erroneous data from entering the business process, and improving the stability and reliability of the system.
[0116] Test scenario: 100,000 instances of abnormal data injection test metrics:
[0117] False interception rate (%)
[0118] Effective data processing speed (data entries / second)
[0119] Test results:
[0120] index control group experimental group Improvement rate Error interception rate 68％ 99.2％ 45.9％ Data processing speed 1200 messages / s 2800 messages / s 133.3％
[0121] The foregoing has provided a detailed description of one embodiment of the present invention, but this description is merely a preferred embodiment and should not be construed as limiting the scope of the invention. All equivalent variations and modifications made within the scope of the claims of this invention should still fall within the patent coverage of this invention.< / control> < / control>
Claims
1. A stored procedure-driven process configuration system, characterized in that, The system includes a client and a server; wherein: The client is configured to receive configuration instructions for the display interface and send the configuration instructions to the server; the configuration instructions are generated by preset syntax rules. The server is used to verify the configuration command, and when the configuration command is successful, it parses the configuration command to obtain configuration information and sends the configuration information to the client. The client is used to dynamically create and render input controls and process options for the display interface based on configuration information.
2. A stored procedure-driven process configuration method, characterized in that, The method is applied to a server, and the method includes: Receive configuration instructions for the display interface sent by the client; the configuration instructions are generated by preset syntax rules; The configuration command is verified. If the configuration command is successful, the configuration command is parsed to obtain configuration information, and the configuration information is sent to the client so that the input controls and process options of the display interface can be dynamically created and rendered according to the configuration information.
3. The stored procedure-driven process configuration method according to claim 2, characterized in that, The preset syntax rules include: UNIT represents the name of a process unit. There is a blank line between each UNIT. Stored procedures in a UNIT begin with #. FLOW represents menu options, including parameter one and parameter two; parameter one is a fixed list or a called stored procedure; parameter two is a custom temporary variable. INPUT represents other inputs such as keyboard or barcode scanner input, including parameters three, four, five, and six; parameter three represents the data format, including TXT and INT; parameter four represents the prompt text; parameter five represents a custom temporary variable; and parameter six is the format verification value.
4. The stored procedure-driven process configuration method according to claim 3, characterized in that, The configuration instructions include an input value dictionary and a processing configuration object. Verification of the configuration instructions includes: Iterate through each cell in the configuration object to obtain a cell set; For each unit in the unit set, traverse each input configuration in that unit, and for each input configuration, determine whether the regular expression of the input configuration satisfies a preset condition; the preset condition is that the input configuration is not empty and the input value dictionary contains the variable of the input configuration. If the preset conditions are met, a database connection object and an SQL command object are created, and the command type is set to stored procedure; If all input configurations meet the corresponding preset conditions, the rule verification result is qualified.
5. A stored procedure-driven process configuration method according to claim 3, characterized in that, Parsing the configuration instructions to obtain configuration information includes: Create a ProcessConfig object, get the configuration file path, read all lines of the configuration file, iterate through each line, and if the line starts with [UNIT], create a new ProcessUni t object, set the name and add it to the cell list of ProcessConfig; If the line begins with [FLOW], the stream options are extracted, split into key-value pairs, and added to the ProcessUni t stream options dictionary; If the line begins with [INPUT], create an InputConf ig object, set the relevant information, and add it to the ProcessUni t input list; Retrieves the result after traversing all rows and returns a ProcessConfig object as configuration information.
6. A stored procedure-driven process configuration method, characterized in that, The method is applied to a client, and the method includes: The system receives a configuration instruction for the display interface and sends the configuration instruction to the server. The server then verifies the configuration instruction; upon successful verification, it parses the configuration instruction to obtain configuration information and sends the configuration information to the client. The configuration instruction is generated using preset syntax rules. The input controls and process options of the display interface are dynamically created and rendered based on the configuration information.
7. A stored procedure-driven process configuration method according to claim 6, characterized in that, The preset syntax rules include: UNIT represents the name of a process unit. There is a blank line between each UNIT. Stored procedures in a UNIT begin with #. FLOW represents menu options, including parameter one and parameter two; parameter one is a fixed list or a called stored procedure; parameter two is a custom temporary variable. INPUT represents other inputs such as keyboard or barcode scanner input, including parameters three, four, five, and six; parameter three represents the data format, including TXT and INT; parameter four represents the prompt text; parameter five represents a custom temporary variable; and parameter six is the format verification value.
8. A stored procedure-driven process configuration method according to claim 7, characterized in that, Parsing the configuration instructions to obtain configuration information includes: Create a ProcessConfig object, get the configuration file path, read all lines of the configuration file, iterate through each line, and if the line starts with [UNIT], create a new ProcessUnit object, set the name and add it to the unit list of ProcessConfig; If the line begins with [FLOW], the stream options are extracted, split into key-value pairs, and added to the ProcessUnit's stream options dictionary; If the line begins with [INPUT], create an InputConfig object, set the relevant information, and add it to the ProcessUnit's input list; Retrieves the result after traversing all rows and returns a ProcessConfig object as configuration information.
9. A stored procedure-driven process configuration method according to claim 8, characterized in that, The input controls and flow options for the display interface are dynamically created and rendered based on configuration information, including: Step 1, Start: The process begins; enter the ProcessConfig object. Step 2, Initialization: Create an empty List <control> Used to store controls, initialize yOffset to 10;< / control> Step 3, Cell Traversal: Begin traversing each cell in the ProcessConfig object; Step 4, Input Configuration Traversal: For each input configuration in the current cell, create a Label control and set its text and position, add it to the control list, create a TextBox control and set its position, if the input configuration variable is not empty, set the name of the TextBox, add the TextBox to the control list, and increase yOffset by 30; Step 5, process option traversal: For each process option in the current cell, create a Button control and set its text and position, add processing logic for the Button's click event, add the Button to the control list, and increase yOffset by 30; Step 6, End Judgment: If there are still unprocessed units, execute steps 1 to 5 for the unprocessed units; otherwise, convert the control list to an array and return it, and the process ends.