TWI536287B - Integrated user acceptance test T & B system - Google Patents

Description

Integrated user acceptance test quality assurance system

The present invention relates to an integrated user acceptance test quality assurance system, in particular to a website system that utilizes a cross-platform programming language to integrate user acceptance test related operations and information.

According to the original user acceptance test work (including before the acceptance test, after the acceptance test), it takes a lot of manual processing, the most labor-intensive and time-consuming work is as follows:

1. Test Case Assignment: Assign hundreds of test cases to dozens of testers, each of which must be assigned to 5 to 7 people for testing.

2. Make a master list for paper printing: In each tester's acceptance summary, each case must be manually noted for the test results of all the testers in the previous case (one case will be assigned to a multi-person test, Everyone's test results are not necessarily the same).

3. Collection and verification of acceptance results: Each time the test is completed, thousands of paper cases and acceptance checklists must be brought back and manually checked one by one.

4. Statistics of acceptance results: Manually input the test results of thousands of cases into the archives, and then make summary statistics and individual statistics according to the North, Central and South regions.

5. Analysis of the causes of test obstacles: The obstacle number of the case that was not passed by the tester on the manual on the manual checklist was entered and checked into the obstacle management system.

6. Obstacle treatment progress tracking: The manual daily access to the obstacle management system to check the processing status of each obstacle of the responsible function, whether it can be retested.

In addition, the acceptance test is carried out manually, and the main problems are:

1. The above-mentioned work that consumes manpower and time, most of the projects need to be mobilized, divided and processed, and each item still takes a week to complete.

2. The information generated, such as test results and obstacle analysis, is scattered in file files of different specifications and is not easy to integrate or reuse. Manual processing costs are high and the utility is low.

3. The collection and statistics of test results are carried out by manual operation. It is necessary to summarize the division of labor and adopt multiple procedures. The processing speed is slow and easy to be overlooked, and the correctness is considered.

4. If you find that the acceptance checklist is not filled or the information is incomplete, you must manually check the notes on the paper case and correct it. If you still don't know, you must try to find the acceptance tester to correct the information. Because the acceptance testers are distributed everywhere, even off the island, making these corrections difficult and time consuming.

5. It takes a long time to obtain the pass rate statistics after the test is completed. It is impossible to judge whether the online standard is reached immediately after the test is completed.

6. Manually track the results of each obstacle repair, lacking efficiency. The obstacle handling operation is ongoing, so the result of the obstacle processing is changing at any time. The manual collection cannot reflect the current situation immediately. In order to make the information close to the current situation, it must be continuously collected, updated, and wasted manpower.

It can be seen that there are still many shortcomings in the above-mentioned conventional methods (manual processing), which is not a good design, and needs to be improved.

In order to solve the above problems, analyze the current operations and the required information~ Write this integrated web application system, and use this system to replace most of the manual operations with electronic processing. The benefits are summarized as follows:

1. To make a master list for the printing of papers, it is necessary to manually note each case to test the test results of all the testers in this case. It takes almost all the general mobilization and division of labor, and it still takes a week to complete. With electronic processing, only one operator is required, and the time is less than 5 minutes.

2. The test case assignment is automatically executed by the program, which is fast and accurate. Even if the list of testers is constantly changing, or there are new cases, just re-execute the distribution program.

3. The acceptance result is input to the system by each tester. The original result is not known until one week after the manual collection and statistical test. It can be inquired at any time during the test.

4. Controlled by the system, there will be no test to find the problem ~ but the situation of the barrier management system.

5. The situation can be known at any time during the test. If the test data is problematic and cannot be tested, a new batch of test data can be provided immediately.

6. Each tester has a statistical analysis of the results of the execution, which shows the efficiency of its execution.

7. Each test case is statistically analyzed by the results of multiple testers. It can be seen whether an amendment is required.

8. Analysis of the causes of test obstacles, presented by the system in real time.

9. Obstacle processing progress tracking, presented by the system in real time.

In summary, the present invention not only reduces personnel costs, but also ensures the accuracy and timeliness of information, thereby improving operational efficiency, and its economic benefits are undoubted.

In view of the shortcomings derived from the above-mentioned conventional methods, the inventor of the present invention has improved and innovated, and after years of painstaking research, he finally successfully developed and completed the integrated user acceptance test quality assurance system.

The object of the present invention is to provide an integrated user acceptance test quality assurance system, which is to perform all relevant operations of the original manual user acceptance test, such as: personnel and case confirmation, case assignment, paper printing (acceptance) General Table/Case) Production and inspection of archives and catalogues, inspection of test data required for inspection, acceptance of inspection results, real-time inquiry and monitoring of acceptance results, output of statistical reports, analysis of causes of test obstacles, progress tracking of obstacles and their operation The information produced is written in a cross-platform programming language to create an integrated website system to achieve operational efficiency and information accuracy, and to increase flexibility in software and hardware.

The integrated user acceptance test quality assurance system that achieves the above object of the invention is to use the cross-platform programming language to write an integrated website system by using all the related operations of the manually processed user acceptance test and the information generated by the user. In order to achieve the purpose of improving work efficiency and information accuracy, and increasing flexibility of software and hardware. The composition mainly includes: converting a plurality of Excel multi-sheet contents into a database form data module, a case allocation module with multiple processing rules, and a paper printing (acceptance summary table/case) file and Catalogue (one catalog per person) production module, one tree menu for setting dynamic generation and test data capture module, one acceptance result registration module, one acceptance result statistics module, one for setting dynamic generation Layer menu and data query module, a test obstacle and processing status real-time analysis module, and an external permission management module.

1‧‧‧Excel multi-table content converted into database form data module

2‧‧‧Multiple Excel multi-sheets

3‧‧‧Receipt related data sheet

31‧‧‧System Profile

32‧‧‧ Case Word Original File

33‧‧‧Receipt summary form template

4‧‧‧ Case Assignment Module

5‧‧‧Printing and Printing (General Acceptance Form/Case) File and Catalog Production Module

6‧‧‧Printing of papers (acceptance summary list / case) Word output files and directories

7‧‧‧Tree menu and test data capture module

8‧‧‧ Acceptance result login module

9‧‧‧ Acceptance Results Statistics Module

10‧‧‧Single-level menu and data query module

11‧‧‧Test obstacles and processing status real-time analysis module

12‧‧‧Permission Management Module

FIG. 1 is an architectural diagram of an integrated user acceptance test quality assurance system of the present invention.

The invention relates to an integrated user acceptance test quality assurance system, which uses the cross-platform programming language to write an integrated website system by using all the related operations of the manually processed user acceptance test and the information generated by the user. Achieve operational efficiency and information accuracy, and increase flexibility in software and hardware. Please refer to FIG. 1 , which is a structural diagram of an integrated user acceptance test quality assurance system provided by the present invention; in order to increase system flexibility, the system uses the variables used in each module in the system as much as possible to make the system configuration file 31 Setting, the system only loads a share of memory to save resources and improve performance; if modified, each module provides the function of immediate reloading of memory; the main settings include: company name, system name, acceptance System code, acceptance test phase, acceptance period, page menu, multiple data query or transaction SQL template, page SQL capture condition description, test data capture menu expansion project, job permission role permission, output file name and Its working directory, acceptance and registration of the open operation logo, IP address of the environmental system of the obstacle boarding system, and database connection code...etc. The main components of the system design operation and mutual relationship, as follows: an Excel multi-table content converted into a database table data module 1: multiple Excel multi-table 2 content (with a list of acceptance personnel, acceptance Test case project, etc., the text strike line: on behalf of the cancellation), converted into the database acceptance data 3 (inspectors and cases and other information). The web page first presents the generated SQL and writes it to the database after confirmation.

A case allocation module 4 with multiple processing rules: After the execution of the previous operation, the acceptance information of the acceptance personnel and cases of the database are accepted, and the information is converted according to the difficulty of the case. The weight, the coverage of each case unit, and the personnel expertise are equally distributed to the acceptance personnel, and the initial acceptance record of the acceptance related data sheet 3 is generated. The web page first presents the generated SQL and writes it to the database after confirmation.

A paper printing (acceptance summary table / case) file and catalog production module 5: According to the first two operations after the transaction after the acceptance of the relevant data sheet (eg, acceptance project, case details, personnel, acceptance results ...etc.) 3 information, as well as the case Word original file 32, the acceptance summary form sample 33, the production of the paper for printing (acceptance summary table / case) Word output file and directory 6 → according to the inspection personnel and units to save The catalogue (one catalog per person) is used to facilitate the printing of paper and binding operations; each case of the acceptance checklist indicates the status of the acceptance of the same case for reference. In addition, it also outputs: copy command file, error log file. (Acceptance summary table / case paper, issued to the acceptance tester at the beginning of the acceptance test, and recovered at the end; when the acceptance tester forgets to enter the system registration acceptance result, the staff member can input the system according to the paper content)

A tree menu and test data acquisition module 7 for dynamically generating: 7: increase the menu of the system configuration file 31, expand the project and SQL settings, and quickly generate the acceptance data required for the case. Table 3 Qualified test Information; if you need to display whether the data has a previous case, the SQL setting only needs to increase the specific field and use a specific name (such as serviceno) to display all the previous cases of the data, and provide the case logout function. If the data has been used (there can be no more cases in the previous case), press the button on the front to cancel the case~ let the data resume use. Due to the system requirements specification (SRS) classification design, and the acceptance system adopts phased acceptance and on-line (each stage of acceptance of some SRS classification), the acceptance case is based on SRS, so the test data menu required for the case must have a tree structure (eg, Acceptance phase → SRS → case). For the case logout function, an input page is also provided - the environment and the input order can be directly selected, and the logout menu 7 and the test data capture function can be used to cancel the logout function; if the case number is not known, the file can be lost. Incoming calls and the environment, all relevant telephone cases in the environment are queried through the function of setting the dynamically generated tree menu and test data.

An acceptance result registration module 8: The page first checks the system registration file 31 acceptance registration open setting, if it is open for acceptance check, and then according to the system configuration file 31 acceptance test information query SQL setting, read acceptance data 3 A record of the statistical snapshot used to display the menu (default is the latest acceptance period); when the user selects, all the cases of the registrant in the acceptance phase of the acceptance related data table 3 are displayed, and the case number is provided. Hyperlink can download the case Word original file 32, each case and prompt to assign the same case to the relevant data of the acceptance of the relevant table 3 for reference (the system automatically updates the display when the modification is determined to be sent); the acceptance personnel are responsible for the acceptance of each case Enter the test results one by one (for example: untested, passed, failed, data error, no data...); if you do not pass, you must first go to the obstacle management system proposal (enter the case number in the case field), after the proposal is sent out Then enter the obstacle number obtained into the system; if the data error cannot be tested, you must enter the problematic device number. With this function, the acceptance result is input by the acceptance personnel. If the input is not correct, the system blocks the delivery, which avoids many errors collected by the artificial eye check of the paper; the acceptance result is input → the acceptance result statistics module 9 and the single-layer menu and The data query module 10 can immediately reflect the current status of the acceptance related data table 3, the obstacle directly into the obstacle management system → the acceleration obstacle processing, which can greatly improve the efficiency and save manpower; and because it is electronic information, it is easy to integrate the system and obstacle management System information, the acceptance of the acceptance criteria according to the acceptance of the relevant data in Table 3 of the acceptance data or the acceptance of the system requirements specification of the relevant data sheet 3, the information on the availability and value of the inspection.

A check result statistics module 9: Immediately present the statistical chart of the current status of the relevant data table 3 through pass, fail, etc., and provide the historical information during the process of saving the statistical snapshot function (written into the acceptance related data table 3). As it is possible to go online, it is necessary to see whether the acceptance rate of the acceptance test meets the set standards, if it is not up to the standard. A number of tests must be held; therefore, a statistical snapshot is performed before the acceptance test, and a snapshot of the statistical results is first stored to preserve the historical information in the process. Acceptance of relevant data Table 3 data grows rapidly, must be deleted after backup, and a statistical snapshot must be performed before deletion to save statistical data of acceptance results.

A single-layer menu and data query module 10 that dynamically generates settings: only the menu and SQL settings of the system configuration file 31 are added, and the required system acceptance data table (or the related information table of the obstacle management system) is quickly and quickly generated. 3 query function. The supervisors of the various circles or the relevant personnel of the acceptance system often have irregular inquiry requirements for irregular inspections; therefore, they can respond in time.

A test obstacle and processing state real-time analysis module 11: automatically generate various test problem analysis required according to the current situation of the obstacle, and immediately give feedback to the user for reference. For example, the reply to the operation of the acceptance system of others, using the "Keyword Search Operation Q&A" provided by the system, can learn the correct operation mode; integrate the system and the obstacle management system information, and generate the "according to the acceptance class or "Acceptance Barrier Processing Progress Management Information for System Requirements Specification Classification"; and "Multiple Key Values (eg, Question Description Keywords, Proposal Date Range, Proposer Menu, Online Menu, One or More Obstacle Numbers, etc.)" ....

An external permission management module 12: focuses on the control and checking operation of the module to check whether the user has logged in and has the right to execute the operation; other operations do not need to write code processing. When performing any of the operations of the system, the system starts the execution of the module, and the steps are as follows: (1) first check the system configuration file 31 whether the operation belongs to the permission control operation item, if it belongs to the permission control item and the user has not yet Login, the system automatically guides the page to the system login page; (2) If you have logged in, check the acceptance related data table 3 whether the registrant has the job execution role, the owner release, no guide page to the system message display page .

The input and processing of each major module of the system are separately added, and the detailed design method is as follows:

(1) The plurality of Excel multi-sheet contents are converted into a database form data module, and the deleted line of the text represents the logout, and the generated SQL is written to the database after being confirmed.

1, its input instructions -

A. List of inspection personnel Excel: The file name does not have a fixed date; there is more than one worksheet, in addition to the worksheet for storing personnel information, there is also a worksheet for storing the description of the field (such as the description of the field of expertise), and the personnel information is stored. The worksheet is named after the unit (such as X to distinguish the company); the worksheet for storing personnel data: the first column of each worksheet is the column name, the rest is the data column, the number of data columns is not limited, and each data column stores an acceptance. Personnel information, data items include operation office/office, service center/section, name, employee code, email account number, contact number, mobile number, area of expertise, seed personnel (yes/no), remarks, etc.; There is a strike-off line → representative personnel cancellation; B, acceptance test case project Excel: file name includes acceptance phase is not fixed; there is more than one work table, in addition to the worksheet for storing case data, there is also a worksheet for storing field writing instructions (such as the test case difficulty description) and the test summary table (this work includes the scope of acceptance / period, project number, project name, case negative People, reviewers, analysts, developers, demand windows, etc.), the worksheet for storing case data is named after the "project number" of the test summary plus the "project name" (for example, P22-F1 is more product type - ADSL is attached) Hanging), storing case information belonging to this project; working table for storing case data: the first column of each worksheet is the column name, the rest is the data column, the number of data columns is not limited, and each data column stores an acceptance test case. Information, data items include case number, case description, application Matters, difficulty, file location; case number (or project number) fonts have strikethrough → representative case (or project) cancellation; C, system settings: mainly include the above Excel input file name, output file name, output / input The directory of the file, the system name, the acceptance system code, the acceptance phase, the period, and the related data sheets add the transaction SQL generation template and the database connection code.

2, its output description -

The executed SQL command is written into the output file according to the setting, and displayed on the webpage, and is written into the database after being confirmed; the output data table includes: (1) acceptance test item: the column mainly has the item number, the project name, Case responsible person, reviewer, analyst, developer, demand window, affiliated acceptance stage, acceptance period, etc.; (2) Acceptance test case details: The column mainly includes project number, case number, case description, difficulty level, and belonging Professional field, acceptance stage, acceptance period, rare mark, retest or new case identification, need to print paper/statistical mark, etc.; (3) Acceptance personnel: The main division of the field is the division, operation department/office, service center / section, name, employee code, email account, contact number, mobile number, area of expertise, role, remarks, acceptance phase, acceptance period, etc.

3, its processing instructions -

The main steps are as follows: (1) The first time the module is started, the system settings mentioned in item (1) and 1c are loaded into the memory, and the module is shared during execution; (2) if the initialization parameters are input, Reload the above settings into the memory; (3) Design the exclusive function module processing for each output data table, first execute the "Acceptance Test Item Data Table SQL Generation Module", and then call the rest of the "XX Data Table SQL" one by one. The module is generated. The processing of each module is different. The steps are as follows: Except for the "Acceptance Test Project Data Sheet SQL Generation Module", the loops read Excel worksheets one by one ("Acceptance Test Project Data Sheet SQL Generation Module" , the required information comes from a worksheet, the worksheet is read by the specified name and executed only once, no loops): I. Worksheets without specific naming rules, do not perform the following steps; II. Meet specific naming rules The worksheet is processed, and the substitution of the SQL template is not a parameter from the data sheet content, for example: (a) from the acceptance phase and acceptance period information of the system setting, and (b) from the "acceptance test project data sheet SQL generation module" Contained Memory ("Acceptance Test Case Details Data Sheet SQL Generation Module" required) "Project No., Acceptance Period" mapping information, (c) From the worksheet name ("Acceptance Test Case Details Data Sheet SQL Generation Module""Required""Case Item Number" information, ("Required Personnel Data Sheet SQL Generation Module" required) "Personnel Division Company"information...; III. Re-circle one by one to process each worksheet The information in the data is as follows: (a) The loops process each item of the column one by one: i. If there is a strikethrough (such as employee code, case number, item number) for specific data, the relevant data items are substituted into "specific" The data table is deleted from the SQL generation template", the SQL for the data table is deleted, and the loop is interrupted; ii. If there is a non-compliant data specification, the loop is interrupted; iii. In addition, the data item is substituted into the data sheet. The transaction SQL generation template sets the parameter position of the mapping, and generates the SQL for execution of the data table; (b) the data table generated by the data column is executed and written into the output file by SQL ("Acceptance Test Item Data Sheet SQL Generation Module" Group Exclusive processing: loading the "project number, acceptance period" mapping information into the memory); (4) displaying the generated data table in SQL on the webpage, and writing it to the database after confirmation.

(2) The case allocation module with multiple processing rules, which assigns the factors such as the difficulty weight of each case, the coverage of each case unit, and the personnel expertise to the acceptance personnel, and generates the data of the acceptance result data sheet. The initial record is accepted, and the generated SQL is not confirmed until it is written into the database.

1. Its input description -

A. The data sheet exported by the first item (1) includes the details of the acceptance personnel and the acceptance test case; B. System setting: mainly includes the system name, acceptance system code, acceptance stage, acceptance period, and multiple related data sheets. The query or transaction SQL template, database connection code, etc.; C, web page input parameters: the selected acceptance case allocation method.

2. Its output description -

The generated SQL command will be displayed on the webpage, and will be written into the database after confirmation; the output data table is the ~ acceptance result data table: the field mainly has the test case number, the tester code, the acceptance result, the obstacle number/data error. Equipment number, acceptance stage, acceptance period, etc. (The acceptance result is preset to be untested and the obstacle number is preset to a null value, and the rest is from the input)

3. Its processing instructions -

The main steps are as follows: (1) The module is started for the first time, and the system settings mentioned in item (2) 1 are loaded into the memory, and the module is shared during execution; (2) if the initialization parameters are input, The above settings are reloaded into the memory; (3) Since the number of acceptance test cases varies and the characteristics are different, the method of assigning the acceptance cases is often adjusted. For each different demand, the system design has multiple allocation methods: including A. "Evaluate the difficulty according to the difficulty" and "based on the expertise of the personnel" and "average all cases" and "each case is assigned to each of the acceptance personnel participating in the acceptance test unit according to a certain proportion (for example: North District X / Central District Y Name / Southern District Z)), B. All acceptance personnel are divided into one case, C. Each inspection personnel allocates all cases, D. Copy an acceptance phase, period, acceptance project acceptance results ~ generate new case assignment And adjust the untested acceptance results; the "acquisition of the designated unit's acceptance personnel", "the case data of the specified sorting method", "calculate the total case weights", "designated acceptance personnel, cases, orders" Sections and period acceptance data are newly added...", designed as a number of function modules; based on the selected distribution method parameters, these functions are combined to perform different allocation methods, and the steps are as follows: I. 『D. Copying the acceptance phase, the period, the acceptance result of the acceptance project~ generating a new case allocation and adjusting the untested acceptance result”, and executing the “acceptance data of the designated unit’s acceptance personnel” The module, according to the SQL query template set by the system, the acceptance phase and the period of the system setting, etc., obtain the list of the participants (sorted by professional classification) of the unit; II. In addition to the D. copy of an acceptance phase, period In addition, the acceptance result of the acceptance project is ~ the new case assignment is generated and the untested acceptance result is adjusted. In addition, the "case data acquisition method of the specified sorting method" is executed, and the system setting of the mapping is obtained according to the distribution method selected by the input parameter. The SQL query template, the acceptance phase and the period of the system setting, and the case information that meets the needs of the selected distribution method (sorted by professional classification or case number); III. Perform different allocation processing and generate execution SQL. Among them, the more complicated allocation methods are handled as follows: ● "A. "Effects the difficulty according to the difficulty" and "based on the expertise of the personnel" and "average all cases" and "each case is assigned to a specific proportion The procedures for assigning the acceptance personnel of the acceptance test unit (for example: X in the North District / Y in the Central District / Z in the Southern District)" are as follows: i. Execute the "Calculate Total Case Weights Total" module: Get Pair The SQL query template of the system setting, the acceptance phase and period of the replacement system setting, calculate the total weight of all cases in the specific stage and the period of the acceptance test case detail table; ii. Calculate "per person should handle Case weight number = total case weight total * (X + Y + Z) / personnel total (decimal unconditionally rounded off); iii. Loop processing until all the personnel participating in the acceptance test unit are read or the case is complete - (i) First take out from the list of personnel of each unit (for example: X in the North District / Y in the Central District / Z in the Southern District). If one of the districts is under-staffed, the rest of the district will be replenished; (ii) Loop processing Up to this (X+Y+Z) the number of cases weights that should be handled by each person--Sequentially take out the case from the case list, obtain the SQL transaction template of the system setting of the mapping, and accept the stage, period, acceptance of the system setting Personnel code and case number, each (X+Y+Z) person's (X+Y+Z) SQL write variables are assigned to each case; ■ Calculate the cumulative weight.

● "D. Copy a certain acceptance phase, period, acceptance project acceptance results ~ generate new case assignments and adjust untested acceptance results" The allocation process steps are as follows: i. Modify the "copy source" of the relevant SQL template settings and The difference between the acceptance period of the "newly generated distribution" (preset to 1) and the acceptance item (preset by default), and the implementation of memory weight loading; ii. Read the "SQL template for generating new case allocation data" System setting, substitution acceptance phase and period, the data sheet generated by the execution of the data is written in the variable; iii. Read the "SQL template for all untested acceptance results of the copy source" system setting, replace the acceptance phase and For the period, obtain the unallocated case allocation information to be adjusted, and the loops are processed one by one as follows: Then loop the case to deal with the case~ from the time of the decrease of 1 to 1 time until the "first time": ■ If the acceptance result of the distribution case is untested, the next one (find the previous time); ■ If you find the result of the test, read the SQL template that produces the result of the modification, replace the acceptance phase, period, personnel code and case number, and write the data table to the variable.

(4) The generated data sheet is displayed on the webpage in SQL and written to the database after confirmation.

(3) The file and catalog production module used for the printing of the paper (acceptance summary table/case) shall be divided into storage catalogues (one catalogue per person) according to the inspection personnel and units to facilitate the printing of paper and binding operations; Each case of the acceptance checklist indicates the status of the acceptance results of the same case for reference.

1. Its input description -

A. The data sheets exported by items (1) and (2) include the acceptance test items, the details of the acceptance test cases, the acceptance personnel, and the acceptance result data sheets; the case Word original file and the acceptance summary form file file; System setting: mainly includes system name, acceptance system code, acceptance stage, root directory of input and output files, and SQL template and database connection code of multiple related data table queries; and, C, web page input parameters: acceptance period Don't wait.

2. Its output description -

The paper output file (the acceptance summary table / case) Word output file and its directory structure. According to the inspection personnel and units, the storage catalogue (one catalog per person); each case of the acceptance summary table and the acceptance of the acceptance results of the same case are for reference. In addition, it also outputs: copy command file, error log file.

3. Its processing instructions -

Modular design: "Case the data of the case manager", "Copy the original Word of the case Word to the output directory" ("Case the original file of the Word Word to the output directory"), "Get all the current assignments of the specified case." "Acceptance results of case personnel", "Achievement of all inspection personnel in the specified period", "Production of output data for an inspection personnel"..., designed into many functional modules (inquiries for each module) The SQL template is taken from the system settings. The main steps are as follows: (1) The first time the module is started, the system settings mentioned in item (3) and (1) are loaded into the memory, and the module is shared during execution. Implement the “Case of Project Leader Data Acquisition”, obtain the information of the acceptance test project data sheet (project number, case leader) at this stage, and generate the sampled items of the test project case person, and also load the memory share; (2) If the input initialization parameter or the test item case leader is null, the above settings and information are reloaded into the memory; (3) the main execution procedure is as follows: I. Clear the existing old directory and file, And re-generate the empty directory structure; II. Incoming (system-set) acceptance phase and (in the input parameters of the web page) acceptance period, execute the function module of "acquiring all the acceptance personnel in the specified phase period" to obtain the production paper This column prints the information required for the files and catalogues; produces sample materials for the temporary storage variables of the printed materials, announces the backup personnel and the unit information variables, etc.; loops one by one until the case data of all the inspectors is completed, as follows -i. In the case of each inspection personnel data, when the personnel code has not changed, the case number, acceptance phase, period, etc. are transmitted and the implementation of the specified case is currently performed. The module of all the results of the distribution of the personnel of the case, the execution result and other relevant information of the personnel are written into the temporary data of the printing data; ii. when the personnel code is changed, the relevant directory structure of the personnel and the unit is generated. Incoming the printing data temporary storage variable and executing the "Production Output Data for an Acceptance Personnel" module, the execution result (person code and number of cases) is displayed when the execution is completed → (The module is for failing Case, obtain the working directory system setting and obtain the file name and directory of the case manager information group, detect and confirm the auxiliary file name is doc or docx; if the file does not exist, the case number for the production acceptance checklist will be passed. The project adds "missing" and writes the error log file; if the file exists, executes the "Case Word original file copy to output directory" module, and writes the executed copy command to the output file; the incoming and processed data will be processed. Production and acceptance checklist); back-up personnel and unit information, and sample production of re-creation of temporary storage variables; III. Data of the last person in the temporary data of production printing (same as II Ii, but do not need to back up variables and reproduce the sample material).

(4) To set up the dynamically generated tree menu and the test data capture module, and only increase the menu of the system configuration file, expand the project and SQL settings, and quickly generate the test data required for the case; In the case of the previous case, the SQL setting only needs to add a specific field and use a specific naming (eg, serviceno) to display all the previous cases of the data and provide the case logout function. If the data has been used (there can be no more cases in the previous case), press the button on the front to cancel the case~ let the data resume use. For the case logout function, an input page is also provided - you can directly select the environment and input the order, through The function of this module is cancelled. If you do not know the connection number of the case, you can enter the phone number and the environment. You can query all relevant telephone cases of the environment through the function of this module.

1. Its input description -

A. Multiple data sheets related to the environment of the acceptance system, including the acceptance environment of different units (for example: North District, Central District, Southern District), and the whole measurement environment; B. System setting: mainly including system name, acceptance system code, Checklists for the acceptance phase, multiple acceptance project menus indexed by the acceptance phase, multiple accession conditions for the index of the acceptance project and the SQL for the questionnaire, the development of the test data retrieval menu, and the prior case enquiries and cases Logout transaction SQL template, database connection code, etc.; and, C, web page input parameters: environment code, etc.

2. Its output description -

The SQL condition description of the web page and the test data captured are displayed; if the SQL has a specific field and uses a specific name (eg, serviceno), then all the previous cases of the data are displayed, and a button is provided. The function can log out the case~ let the data be used again.

3. Its processing instructions -

The main steps are as follows: (a) menu module, (b) test data query web module, (c) case cancellation and web page module search, etc. The main steps are as follows: (1) Module (A) And (c) the first start, the system settings mentioned in item (4)1(b) are loaded into the memory, and the modules are shared when they are executed; (2) modules (a) and (c) Input initialization parameters, reload the above settings into the memory; (3) each module mainly executes the program, the steps are as follows:

I. Module (A) menu page -

Write the environment code (in the web page) into the query string variable; write the expansion item of the (system-set) test data capture menu to the menu to expand the project variable (purpose: when the menu directory is generated, the directory is generated The code is stored here; generate some fixed links (for example: return to the main menu, return to the home page, etc.); obtain the (system-set) acceptance phase menu, and the loops are processed one by one as follows - ● generate the menu of the acceptance phase; obtain (system Set the acceptance project menu for this stage, and the loops are processed one by one as follows - Generate a menu list of the acceptance items; obtain the (system-set) reading conditions of the acceptance items and the SQL of the data table query, and the loops are processed one by one as follows: generate the link of the extracted SQL, and the acceptance item, 撷Take the index of the SQL and the contents of the query string variable to bring in the link. After the menu page is generated, the project variables (the menu directory code recorded) are expanded according to the menu, and the related menu items are expanded one by one.

II. Module (B) test data query page -

Write (web page input) environment code, acceptance item, SQL index, etc. into the query string variable; if the query string ~ no SQL index → display the job operation instructions; there is SQL index → then display the SQL capture condition description, then Use the acceptance project, SQL index to obtain SQL, and then pass the SQL and (page input) environment code into the "data query module" to obtain the query result, and announce the specific item position index variable (preset-1), the serial number variable (initial Value 0), loops one by one to process the data as follows (the first pen is the project name) - i. "Serial number" processing: If it is the first pen, display the project name (such as serial number), the serial number is increased by 1; otherwise, the display The value of the serial number, the serial number plus 1; ii. The processing of "retrieving data": the variable of the webpage text declared empty; the data items of each record are processed one by one - The first one: if it is a specific item, record its location index; otherwise, display the name of the data item; Non-first pen: If it is a specific project, pass in the environment code, query string, etc. and execute the "pre-case information capture module (read the system to set the query before the SQL template, enter the value of the specific project to execute, get the environment In the previous case and the case, the text message of the "including the query string" link was cancelled and returned)", the return value was written into the webpage text variable; otherwise, the value of the data item was displayed; iii. The handling of the "specific item": When the specific item position index variable value is not -1, the following is performed - if it is the first pen, the item name is displayed (if the uncompleted joint order); otherwise, the web page text variable obtained in the previous item is displayed (previous case and case cancellation link) Web page text information).

III. Module (C) Case Cancellation and Enquiry Page -

After removing the case number from the environment code (inputted by the web page), write the query string variable; obtain the environment code, case number or phone number entered by the web page, i. If the input parameter is the case number: read the system setting case After logging out the transaction SQL template, the transaction result list object is generated after the value of the case number is entered, and the "data transaction module (executing in the environment and returning the execution result)" is transmitted and executed together with the environment code; if the return result is successful Display success information, otherwise display failure information; ii. If the input parameter is a phone number, read the relevant query SQL execution, return the previous information of the phone; press the button or link (such as leaving) → guide to the module ( B) Test the data query page and bring in the value of the pre-stored query string variable.

(5) The acceptance result registration module, the page first checks the acceptance and login open system settings, if it is open for acceptance check, and then according to the acceptance test information query SQL system settings, read the acceptance test information data table without making a statistical snapshot record, use To display the menu (the default is the latest acceptance period); when the user selects, the account will be displayed in the acceptance phase of all cases, the case number provides a hyperlink to download the case Word original file, each case and prompt The status of the acceptance results of the same cases is for reference (the system automatically updates the display when the changes are determined to be sent). It can be roughly divided into: (a) the acceptance result login webpage module, and (b) the acceptance result update webpage module.

1. Its input description -

A, case Word original file and related data table: including the acceptance test items, acceptance test case details, acceptance personnel, acceptance results, and acceptance test information and other data sheets; among them, the acceptance test information data sheet items are: acceptance system code , acceptance phase, period, start date, deadline, description, scope, statistical snapshot identification, online indicators Criteria-user acceptance test pass rate; (the rest of the data sheet items are described in the preceding paragraphs, not to be repeated) B. System settings: mainly include system name, acceptance system code, file working directory, acceptance registration operation open mark, and more Relevant data sheet query or transaction SQL template, database connection code, etc.; and, C, web page input parameters: selected acceptance test period, and the test results and obstacle number/abnormal equipment of each case entered No..

2. Its output description -

The page module (A) page first checks the acceptance and login open system settings. If the non-acceptance login is open, the message is displayed and the page is displayed to the main menu; if it is open for acceptance check, then the SQL system settings are read according to the acceptance test information, and read. The acceptance test information data sheet has not been recorded as a statistical snapshot to display the menu (default is the latest acceptance period); according to the user selected period, all the cases of the registrant during the acceptance phase are displayed, the case number Provide hyperlinks to download the original Word file, each case and prompt the assignment of the same case to the current status of the review for reference; when the modification is determined to be sent, the guide to the web module (B) processing updates, after completion, return to the web module (A) The system automatically updates to show the status of the acceptance results.

3. Its processing instructions -

The main steps are as follows: (1) The first time the two modules are started, the system settings mentioned in item (5) and (1) are loaded into the memory, and the modules are shared when they are executed; the module (A) is read more. Acceptance test project data sheet (project number, case manager) information, generate test project case person to instantiate the object, load memory share; (2) two modules such as input initialization parameters, the aforementioned settings or The information is reloaded into the memory; (3) The two modules mainly execute the program, and the steps are as follows: I. Module (A) Acceptance result login page -i. The page first checks the acceptance and login open system settings, such as non-acceptance login open During the period, the message is displayed and the page is displayed to the main menu; if it is open for acceptance check, and then the SQL system setting is checked according to the acceptance test information, the record of the acceptance test information data table has not been recorded for the purpose of displaying the menu (default is the latest) Ii. According to the relevant query SQL model system settings, enter the acceptance phase, period, personnel code, get all the cases of the login registrant during the acceptance phase, if there is no information to display the message, if any迴圈 case by case basis do the following: Common treatment of each project: the project name is displayed for the first time, and the value of the project is displayed for each of the remaining times; For the special treatment of each project, explain: ■ "Case No." project: obtain the working directory system setting and obtain the file name and directory of the case manager information group, and detect and confirm the auxiliary file name doc or docx, such as The existence of the file provides a hyperlink to the original Word of the download case; ■ "Current Acceptance Result" item: According to the relevant query SQL template system setting, the case number is entered, and the acceptance result of the same case is obtained and prompted for reference; ■ can be input Project: Back up the original information of the project; iii. Check each acceptance result (a) item and obstacle number/abnormal equipment number (b) when the modification is determined to be sent out. If (a) is passed, you cannot enter (b), such as (a) If it is not passed, you need to enter (b), etc. If it is not correct, stop at the first error data and wait for correction; if all the data is checked, the page will be directed to module (B).

II. Module (B) Acceptance Results Update Webpage -

i. The page first checks (the number of parameters passed in the page), if it is 0, it displays the transaction 0; ii. If it is not 0, the relevant transaction SQL template system setting is obtained, and the first generation is replaced by the personnel code, stage, and period. And then loop through the pen: If the input data is different from the backup original data, if the result is not passed, check whether the obstacle management system database does have the obstacle proposal of the acceptance person. If it does not exist, the reason for the data is not changed. Skip the next stroke, if there is any other result, replace the case number and the transaction item, generate the transaction instruction and write the list object; iii. Pass the transaction instruction list into the "data transaction module" to execute, according to the return result display Number of changes: iv. Press the button or link (if left) → guide back to the module (A).

(6) The statistical module of the acceptance result immediately presents the statistical chart of the current status of acceptance and failure, and provides the historical information during the process of saving the statistical snapshot function.

1. Its input description -

A. Relevant data sheet: including the details of the acceptance case, the acceptance personnel, the acceptance result, the acceptance test information, and the snapshot of the acceptance statistics; among them, the item of the acceptance statistics snapshot data sheet The objectives are: acceptance stage, period, execution period, personnel code, acceptance items, whether it is included in the statistics, acceptance results, number of pens, statistical time; (the rest of the data sheet has been explained in the above, not to repeat) System setting: mainly includes system name, acceptance system code, multiple related data table query or transaction SQL template, database connection code, etc.; and, C, web page input parameters: selected acceptance test period.

2. Its output description -

According to the acceptance test information query SQL system settings, read the record of the acceptance test information data table, used to display the menu (default is the latest acceptance period); according to the user selected periodic - (a) acceptance results statistics page function Module: Display the statistical chart of the current period of acceptance, not pass, etc.; (b) Acceptance result statistics snapshot webpage function module: display the generated SQL command on the webpage, and write it after confirmation Into the database.

3. Its processing instructions -

(A) Acceptance Results Statistics Webpage Function Module (B) Acceptance Results Statistics Snapshot Webpage Function Module: The two modules operate independently. The main steps are as follows: (1) The first two modules are started, and the first (6) 1 B The system settings mentioned in the item are loaded into the memory, and each module is shared by the module; (2) the two modules input the initialization parameters, and re-load the aforementioned settings or information into the memory; (3) the main execution program, The steps are as follows:

I. Module (A) Acceptance Results Statistics Page -

i. According to the acceptance test information query SQL system settings, read the acceptance test information data table to display the menu (default is the latest acceptance period); ii. according to the selected period has made statistical snapshots, read The mapping of the query SQL template system is entered into the acceptance phase, the execution period (or the period included in the scope), and the data sheet such as "statistical snapshot" (or "acceptance result") is obtained to obtain the acceptance phase and execution period. No, it must be included in the statistics, the number of non-passages, and the subtotals of all units and the total units of all the units. iii. Finally, the forms and statistics are presented simultaneously; and the test information is displayed. The criteria for the on-line indicators set in this period are the user acceptance test pass rate and the actual pass rate of the acceptance test.

II. Module (B) Acceptance Results Statistics Snapshot Page -

i. According to the acceptance test information query SQL system settings, read the acceptance test information data table to display the menu (default is the latest acceptance period); ii. read the relevant data table transaction SQL template system settings, substitute for the selected In the acceptance phase and the execution period, a new record of the "statistical snapshot" data sheet is generated (the acceptance result of the period included in the execution period range) and the "acceptance test information" data sheet is modified. Project; display the executed SQL command on the web page, and write it to the database after confirmation.

(7) The single-layer menu and data query module generated by the dynamic setting will only add the menu and SQL settings of the system configuration file, and immediately generate the required data sheet (or obstacles) for the system. The management system related data sheet) query function; in this way, the party can timely respond to the relevant personnel of the various departments or the acceptance system, and the acceptance information often has irregular query requirements.

1. Its input description -

A, the system acceptance related data sheet (or obstacle management system related data sheet); B, system settings: multiple data retrieval menu, multiple acceptance data table query SQL, database connection code, etc.; and, C, webpage Input parameters: selected data capture items, etc.

2. Its output description -

According to the system setting of the data retrieval menu, the menu and code number are generated (the first one is preset); the relevant information is obtained according to the code selected by the user, and the reading condition description and the table column display the information obtained.

3. Its processing instructions -

The main steps are as follows: (1) The module is started for the first time, and the system setting mentioned in item (7) 1 is loaded into the memory, and the module is shared during execution; (2) the module inputs the initialization parameters. Re-load the above settings or information into the memory; (3) The module mainly executes the program, and the steps are as follows: I. According to the system setting of the data acquisition instructions, generate the menu and code (default is the first stroke); II According to the data selected by the user, replace the number, obtain the acceptance data table to query the SQL system settings, enter the "data query module" to execute and return the relevant information obtained, display the description of the retrieval conditions and the loopback Processing - The table column shows the information it has obtained.

(8) The test obstacle and processing status real-time analysis module automatically analyzes the various test problems required according to the current situation of the obstacle, and immediately gives feedback to the user for reference. It includes: (a) Acceptance Disorder Management Webpage Module - Provides information on the classification of management acceptance and obstacle processing according to the classification of acceptance personnel or system requirements; (b) Operational Q&A webpage module - provides keyword search for "online/acceptance" Operational Q&A; and, (C) More Version Information Query Webpage Module - provides a variety of key values (eg, question description keyword, proposal date range, sponsor list, online date menu, more than one obstacle number, etc.) "Online/Acceptance" obstacle handling status.

1. Its input description -

A, obstacle boarding system (acceptance and on-site) database and the system acceptance related data sheet; B, system settings: mainly including system name, acceptance system code, multiple related data table query SQL, working directory, obstacles hit System environmental website IP, and database connection code, etc.; and, C, web page input parameters: each module is - (A) selected acceptance period and acceptance personnel (or system requirements specification category); (b) Input keywords, proposal date range, and environment selection; (c) input multiple key values (eg, question description keyword, proposal date range, sponsor, online date, more than one obstacle number, and environmental selection, etc.) ).

2. Its output description - each module is -

(a) sorted by case number, the table shows the relevant acceptance information (including case and supporting evidence) of the selected acceptance period and the acceptance personnel (or system requirements specification category), and (displayed by obstacle number) All the reported obstacles and their current status (including the case of the obstacles boarding system); (b) sorted by the obstacle number, the table shows the selected environment, the date range of the proposal, and the entered keywords (not entered) All) all the reported obstacles and their current status (including the case of the obstacles boarding system); (c) sorted by the obstacle number, the list shows the selected environment, the various key values entered (eg, question description keywords) , the date of the proposal, the sponsor, the date of the launch, more than one obstacle number, etc.), the content of all the reporting obstacles and the current status of the handling (including the case of the obstacle boarding system);

3. Its processing instructions -

The main steps are as follows: (1) Module (A) (B) (C) is started for the first time, and the system settings mentioned in Item (8) 1 are loaded into the memory, and the modules are shared when executed; Module (A) multi-read acceptance test project data sheet (project number, case leader) information, generate test project case person to instantiate the object, load memory share; (2) module (A (b) (c) If the initialization parameters are entered, the above settings or information are reloaded into the memory; (3) Modules (A) (B) (C) are independent main execution procedures, and the steps are as follows: Module (A) Acceptance Barrier Management Page - i. The page is based on the acceptance test information query SQL system settings, read the record of the acceptance test information data table, to display the menu (default is the latest acceptance period); ii. According to the selected schedule and related query SQL model system settings, enter the acceptance phase, period, obtain all the personnel (or acceptance project) information during the acceptance phase, and generate the inspection personnel (or system requirements specification category) menu; iii. The case number is sorted, and the list shows the selected acceptance period and the acceptance personnel ( System requirements specification category) acceptance of each case related information (including case and evidence), and (depending on obstacles Code Sort display) reported the case to mention all obstacles and content processing status (including the case system disorders Dundas link). Explain the special treatment of each item: "Case No." project: Get the working directory system setting and obtain the file name and directory of the case manager information group, detect and confirm the auxiliary file name is doc or docx, if the file exists, provide the download case Word original file (including corroboration) Hyperlink; Handling of obstacles and their processing status - such as: changing the size of the image file, adding line breaks, text forms, etc. for consistency, and (in accordance with the obstacle system, the environment website IP system settings) for link processing, etc.

II. Module (B) Operational Problems Q&A Website -

Sort by obstacle number, the table column shows the selected environment, the proposal date range, and the entered keyword (not entered All) All the reported obstacles and their current status (including the case of the obstacle boarding system). The content of the obstacles and the processing status of the obstacles are handled by the module (A) acceptance barrier management webpage.

III. Module (C) version of the information query page -

i. According to the relevant query SQL system settings, obtain the sponsor, the online date information, generate the proposer, the online selection list; ii. Sort by the obstacle number, the list shows the selected environment, the input multiple key values (eg, the problem description key The content of all the reporting obstacles and the status of the handling of the words (the date of the proposal, the date of the proposal, the date of the proposal, the date of the launch, more than one obstacle number, etc.) (including the case of the obstacle boarding system). The content of the obstacles and the processing status of the obstacles are handled by the module (A) acceptance barrier management webpage.

(9) The plug-in rights management module focuses on the control and control operations of the module to check whether the user has logged in and has permission to perform operations; other operations do not need to write code processing. It mainly includes: (a) filtering and checking modules, (b) login webpage module, (c) password change webpage module, and (d) system message display webpage module. This system does not require all accounts and permissions for all functions, such as test data retrieval, query and statistics - anyone can use, do not need to apply for accounts and permissions; this system records the operations that need to be controlled by the setting method, when If the operation is such, the module (A) checks whether the user is logged in and has the right to execute; if not, the page is directed to the module (B) to log in to the webpage; if the user is logged in, but the user does not have the To execute the right to operate the web page, the page to the module (D) system message display page. If you are logged in, you can execute the module (C) password change page.

1. Its input description -

A, the inspection personnel data sheet; B, system settings: mainly including the company name, system name, acceptance system code, job permission role permissions, multiple related data table query or transaction SQL template, database connection code, etc.; , C, web page input parameters: (a) Filtering and checking modules: each webpage to be executed (including its link and query string); (b) login webpage module: account number, password, and the previous item (A) The link and its query string; (c) password change webpage module: old password, new password, new password confirmation, execution status and the return page of the caller's incoming webpage: (d) system message display webpage module : The message passed by the caller.

2. Its output description -

(A) Filtering and inspection module: According to the inspection result, the relative mapping guide page - the system records the operation that needs to be controlled by the setting method. When the operation belongs to this type, the module (A) checks whether the user is Has been logged in and has the right to execute; if not logged in, the page is directed to the login module (B); if the user is logged in, but the user does not have the right to execute the webpage, the page is directed to the module (D); (b) Login to the webpage module: ● Press the button (for example, login system), if the account password is checked, the success message is displayed, there is a link to the webpage to be executed and the query string, and the guide page is to be executed. And the query string is passed in. If there is no incoming, the page is directed to the main menu of the system; if the account password check fails, the failure information is displayed; ● Press the button (for example: cancel) to clear the input data; ● Press the button Or link (for example: leave), return to the main menu of the system; (c) password change webpage module: press the button (for example: change password) → display the execution result; if the execution status is successful, return the incoming web link; Incoming return link, then return to the login page (D) System Message Display Web Page Module: Display the incoming message and display the link (for example: go to the main menu of this system).

3. Its processing instructions -

(A) Filtering and inspection module: When performing any operation of the system, the system starts the execution of this module - its steps: (1) first check whether the job is a permission control project, and if it belongs to the permission control project And the user has not logged in, the system automatically guides the page to the system login page; (2) if the login is logged in, it checks whether the registrant has the job execution role, and the owner has a release, no guide page to the system message display page; B) Login to the web module: The main steps are as follows: (1) The module is started for the first time, and the system settings mentioned in item (9) 1 are loaded into the memory, and the module is shared during execution; (2) If the module inputs the initialization parameters, the above settings or information are reloaded into the memory; (3) the main execution program, the steps are as follows: ● Press the button (for example: login system), check whether the input has an input account; , block the delivery; enter the check pass, obtain the relevant SQL query template, enter the account to obtain the password encryption, check the password is correct; if the password is wrong, write the error message to the execution result variable; such as password check Passing, there is a link to the webpage to be executed and the query string, the guide page is sent to the webpage to be executed and the query string is passed in. If there is no incoming, the page is directed to the main menu of the system; if the password check fails, the display is displayed. Failure information; ● press the button (for example: cancel), then clear the input data; ● Press the button or link (for example: leave) to return to the main menu of the system; (C) Password change webpage module: The main steps are as follows: (1) The module is started for the first time, and the (9) 1 item is The system setting is loaded into the memory, and the module is shared during execution; (2) the module inputs the initialization parameters, and reloads the above settings or information into the memory; (3) mainly executes the program, and the steps are as follows: I. Read the execution status, such as the null value to the initial value (for example: set to 0) II. Press the button (for example: change the password), first perform the input check; check the passer, change the execution status (for example: set 1); If not, write the error message to the execution result variable; III. If the execution status is input check (for example: 1), obtain the relevant SQL query template, enter the account to obtain the password encryption, and check whether the password is correct; If the password is incorrect, write the error message to the execution result variable; IV. If the password is correct, read the relevant SQL transaction template, enter the account number, execute the new password, and successfully change the execution status (for example: set to 2), and the success message Write execution result; If the failure occurs, the failure reason information is written into the execution result; V. If the execution result is not empty, the execution result is displayed; if the execution status is successful (for example, 2), the incoming web link is returned; if the return link is not returned, then Login page; (D) system message display webpage module: display the incoming message and display the link (for example: go to the main menu of the system); press the link to return to the main menu.

The integrated user acceptance test quality assurance system provided by the invention has the following advantages when compared with other conventional technologies:

1. The invention can greatly improve the speed of the user acceptance test related work, and provide better acceptance test output information quality. (Acceptance result collection, test obstacle reason analysis, obstacle processing progress tracking - are all presented by the system in real time, so the original work, the inspection after the work - acceptance results collection, test obstacles analysis, obstacle processing... Can be processed synchronously during the test)

2. The present invention additionally provides an immediate monitoring function that was previously lacking in manual work. (According to the acceptance result registration and instant inquiry function provided by the system, if there is any error that the acceptance personnel cannot test because of incorrect data, forget to input the acceptance result, or fail to enter the obstacle number... etc., the acceptance can be immediately found and solved in time)

3. The invention not only can reduce the manual processing cost, greatly shorten the processing time of each operation, but also ensures the accuracy and timeliness of the user acceptance test data and improves the work efficiency, and the economic benefit is very obvious.

The detailed description of the present invention is intended to be illustrative of a preferred embodiment of the invention, and is not intended to limit the scope of the invention. The patent scope of this case.

To sum up, this case is not only innovative in terms of technical thinking, but also has many of the above-mentioned functions that are not in the traditional methods of the past. It has fully complied with the statutory invention patent requirements of novelty and progressiveness, and applied for it according to law. Approved this invention patent application, in order to invent invention, to the sense of virtue.

1‧‧‧Excel multi-table content converted into database form data module

2‧‧‧Multiple Excel multi-sheets

3‧‧‧Receipt related data sheet

31‧‧‧System Profile

32‧‧‧ Case Word Original File

33‧‧‧Receipt summary form template

4‧‧‧ Case Assignment Module

5‧‧‧Printing and Printing (General Acceptance Form/Case) File and Catalog Production Module

6‧‧‧Printing of papers (acceptance summary list / case) Word output files and directories

7‧‧‧Tree menu and test data capture module

8‧‧‧ Acceptance result login module

9‧‧‧ Acceptance Results Statistics Module

10‧‧‧Single-level menu and data query module

11‧‧‧Test obstacles and processing status real-time analysis module

12‧‧‧Permission Management Module

Claims (10)

An integrated user acceptance test quality assurance system, which comprises: converting Excel multi-worksheet content into a database form data module, converting multiple Excel multi-worksheet contents into data repository acceptance related data table; case allocation The module is converted into the data table of the Excel multi-worksheet, and converts the contents of multiple Excel multi-sheets into the data of the relevant data sheet of the database, and then uses the acceptance personnel and cases of the data into the database. And other information, the case according to the difficulty of conversion conversion weight, each case unit coverage, and personnel expertise, etc., are equally distributed to the inspection personnel, the initial acceptance record of the acceptance result data table; the file for printing on paper And the catalog production module, when the Excel multi-sheet content is converted into the database form data module and the case distribution module is executed, according to the information generated after the transaction related acceptance data table, and the case Word original file, acceptance The total model plate, the production of the Word output file and catalogue for paper printing and the storage directory according to the inspection personnel and units, in addition Out: copy command file, error log file; tree menu and test data capture module, add system configuration file menu, project and SQL settings to quickly generate the test data required for the case; acceptance result login module For the inspection personnel to log in and select the display menu, according to the selected items, to display all the cases of the acceptance personnel during the acceptance phase, and prompt the acceptance results of other acceptance personnel assigned the same case for the reference personnel to refer to and It is responsible for the acceptance of each case, and selects the test results one by one. The cases that fail the test must be sent to the obstacle management system proposal beforehand; the statistical results of the acceptance results are used to present the statistical charts of the acceptance and acceptance status, and Provide statistical information during the process of saving the snapshot function; Single-layer menu and data query module, which is used to add menus and SQL settings of system configuration files, and quickly generate the required inspection-related data query function; test obstacles and processing status real-time analysis module, automatically generate the situation according to the current situation of obstacles Need to analyze a variety of test problems, instant feedback to the user reference; and rights management module, to check whether the user has logged in and has the authority to perform operations such as control operations. For example, the integrated user acceptance test quality assurance system described in claim 1 of the patent scope, wherein the Excel multi-worksheet content is converted into a database form data module, the deleted line of the text represents the cancellation, and the generated SQL is to be confirmed. Only after writing to the database. For example, the integrated user acceptance test quality assurance system described in claim 1 of the patent scope, wherein the case allocation module is a factor for considering the difficulty of the case, the coverage of each case unit, and the personnel expertise. The average is assigned to the acceptance personnel, and the initial acceptance record of the acceptance result data table is generated, and the generated SQL is written into the database after being confirmed. For example, the integrated user acceptance test quality assurance system described in item 1 of the patent application, wherein the file and catalog production module for printing the paper is divided into storage catalogues by the inspection personnel and the unit to facilitate printing of the paper. And the binding work is carried out. For example, the integrated user acceptance test quality assurance system described in claim 1 of the patent scope, wherein the tree menu and the test data capture module can be quickly added only by selecting a system configuration file menu, an expansion project, and a SQL setting. Generate the test data required for the case; if it is necessary to display whether the data has a previous case, the SQL setting only needs to add a specific field and use a specific name to display all the previous cases of the data, and provide the case cancellation function; The data has been used, press the button on the front to cancel the case~ let the data be used again, for the case logout function, and provide the input page - you can directly select the environment and input the order. If you do not know the contact number of the case, you can enter the phone number and the environment. You can use the tree menu and the test data capture module function to query the environment. All related phone cases. For example, the integrated user acceptance test quality assurance system described in claim 1 of the patent scope, wherein the acceptance result registration module, the page first checks and accepts the login open system setting, if the registration is open for acceptance, and then according to the acceptance test information query SQL System setting, reading the record of the acceptance test information data sheet without statistical snapshot, used to display the menu; when the user selects, the user is displayed in the acceptance phase of the case, the case number provides a hyperlink to download the case Word The original file, each case and prompted to assign the same case to the acceptance status for reference. For example, the integrated user acceptance test quality assurance system described in claim 1 of the patent scope, wherein the statistical module of the acceptance result immediately presents a statistical chart of the acceptance and acceptance status, and provides a statistical snapshot function during the preservation process. Historical information. For example, the integrated user acceptance test quality assurance system described in claim 1 of the patent scope, wherein the test obstacle and processing status real-time analysis module, the analysis includes the keyword search operation problem Q&A, the acceptance personnel classification or the system requirement The classification of the acceptance barrier processing progress management information, and a variety of key value barrier processing status query. The integrated user acceptance test quality assurance system described in claim 8 is characterized in that the key value of the plurality of key value obstacle processing status query values is a problem description keyword, a proposal date interval, a sponsor list, an online date menu, Or more than one obstacle number. For example, the integrated user acceptance test quality assurance system described in claim 1 of the patent scope, wherein the authority management module checks whether the user has logged in and has the authority to perform operations such as operation, and the other operations do not need to write the code. Processing; when Excel multi-table content is converted into a database table Data module, case allocation module, file and catalog production module for paper printing, tree menu and test data capture module, acceptance result registration module, acceptance result statistics module, or single layer When the menu and the data query module are executed, the rights management module executes whether the job is required to control the job item first. If the job item is required to be controlled and the user has not logged in, the system automatically guides the page to the system login page; If you log in, check if the registrant has the job execution role, and the owner has a release, no guide page to the system message display page.