CN113191128A - Report form checking tool generation method and device and electronic equipment - Google Patents
Report form checking tool generation method and device and electronic equipment Download PDFInfo
- Publication number
- CN113191128A CN113191128A CN202110562899.6A CN202110562899A CN113191128A CN 113191128 A CN113191128 A CN 113191128A CN 202110562899 A CN202110562899 A CN 202110562899A CN 113191128 A CN113191128 A CN 113191128A
- Authority
- CN
- China
- Prior art keywords
- data
- column
- report
- mark
- row
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 50
- 230000006870 function Effects 0.000 claims description 194
- 238000004364 calculation method Methods 0.000 claims description 14
- 238000000605 extraction Methods 0.000 claims description 5
- 238000012795 verification Methods 0.000 claims description 3
- 238000004590 computer program Methods 0.000 claims description 2
- 238000005516 engineering process Methods 0.000 abstract description 4
- 238000012360 testing method Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 238000003491 array Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 239000000284 extract Substances 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- NAWXUBYGYWOOIX-SFHVURJKSA-N (2s)-2-[[4-[2-(2,4-diaminoquinazolin-6-yl)ethyl]benzoyl]amino]-4-methylidenepentanedioic acid Chemical compound C1=CC2=NC(N)=NC(N)=C2C=C1CCC1=CC=C(C(=O)N[C@@H](CC(=C)C(O)=O)C(O)=O)C=C1 NAWXUBYGYWOOIX-SFHVURJKSA-N 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 125000004122 cyclic group Chemical group 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000008570 general process Effects 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the application discloses a generation method and a generation device of a report form checking tool and electronic equipment, and relates to the field of financial science and technology, wherein the method comprises the following steps: acquiring an operation rule of report data, wherein the operation rule is used for restricting the relationship between data in rows or columns of a report; extracting parameters from the operation rule, wherein the parameters at least comprise row marks and/or column marks; calling a preset write operation function, writing a code for calling a preset function into a VBA editing window of a table, and taking a parameter as an actual parameter of the preset function; when the preset function is executed, judging whether a group of data positioned by a row mark and a column mark in the actual parameters accords with an operation rule; writing in a code for displaying a checking result so as to obtain a report checking tool code; when the report checking tool is executed, the data in the report is automatically checked whether the data meet the operation rule. According to the scheme, the checking tool codes are automatically generated according to the report operation rule, and the generated report checking tool codes are wide in application range.
Description
Technical Field
The application relates to the field of financial science and technology, in particular to a method and a device for generating a report form checking tool and electronic equipment.
Background
In the process of version testing, the display of some report data is often required to be tested, and because the report data is large in quantity and needs to be tested in multiple rounds, a large amount of manpower is required to be consumed to complete the test. The general process flow for this type of test is: the tester confirms the logic and logic transformation condition of the report with the service personnel and the developer, and after the report data comes out, the service personnel checks the accuracy of the data to complete the first test and submit the test problem. And after the defects are repaired by the patches, performing a second round of test until the verification of all logics is completed.
In the testing process, data operation needs to be checked one by one manually, a large amount of time is consumed, and errors exist.
Disclosure of Invention
The embodiment of the application aims to provide a method and a device for generating a report checking tool and electronic equipment, so as to improve the report checking efficiency and accuracy.
In order to solve the above technical problem, an embodiment of the present specification provides a method for generating a report verification tool, where the method includes: acquiring an operation rule of report data, wherein the operation rule is used for restricting the relationship between data in rows or columns of a report; extracting parameters from the operation rule, wherein the parameters at least comprise row marks and/or column marks; calling a preset write operation function, writing a code for calling a preset function into a VBA editing window of a table, and taking the parameter as an actual parameter of the preset function; when the preset function is executed, judging whether a group of data positioned by a row mark and a column mark in the actual parameters accords with the operation rule; writing in a code for displaying a checking result so as to obtain a report checking tool code; and when the report checking tool is executed, automatically checking whether the data in the report conforms to the operation rule.
An embodiment of the present specification provides an apparatus for generating a report collation tool, the apparatus including: the acquisition module is used for acquiring the operation rule of the report data, and the operation rule is used for restricting the relationship among the data in the row or the column of the report; the extraction module is used for extracting parameters from the operation rule, and the parameters at least comprise row marks and/or column marks; the first writing-in module is used for calling a preset writing operation function, writing a code for calling a preset function into a VBA editing window of a table, and taking the parameter as an actual parameter of the preset function; when the preset function is executed, judging whether a group of data positioned by a row mark and a column mark in the actual parameters accords with the operation rule; the second writing module is used for writing in codes for displaying the checking result so as to obtain report checking tool codes; and when the report checking tool is executed, automatically checking whether the data in the report conforms to the operation rule.
The generation method of the report form checking tool provided by the embodiment of the specification acquires the operation rule of report form data, extracts parameters from the rule in budget, writes codes for calling a preset function into a VBA editing window of a table, takes the extracted parameters as actual parameters of the preset function, judges whether a group of data positioned by a row mark and a column mark in the actual parameters accords with the operation rule when the preset function is executed, and writes codes for displaying a checking result to further obtain a checking tool code, wherein the checking tool can assist in checking the report forms, so that the data between the report forms do not need to be checked manually one by one, the checking efficiency is higher, and the accuracy is higher; and the report form checking tool can also realize the efficient checking of all data and the logic correctness of the management data among different report forms. According to the scheme, the check tool codes are automatically generated according to the operation rules of the report, and the check tool codes for a specific operation rule are not independently written aiming at the specific operation rule, so that the generated report check tool codes have a wide application range.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings needed to be used in the description of the embodiments or the prior art will be briefly introduced below, it is obvious that the drawings in the following description are only some embodiments described in the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 shows a schematic diagram of an Excel table and data ranges;
FIG. 2 illustrates a scenario diagram of report reconciliation tool execution;
FIG. 3 is a diagram showing the detailed contents of the report reconciliation table;
FIG. 4 is a flow chart illustrating a method for generating a report reconciliation tool in accordance with an embodiment of the present description;
FIG. 5 is a schematic block diagram of an apparatus for generating a report reconciliation tool according to an embodiment of the present disclosure.
Detailed Description
In order to make those skilled in the art better understand the technical solutions in the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments obtained by a person of ordinary skill in the art without any inventive work based on the embodiments in the present application shall fall within the scope of protection of the present application.
Fig. 1 shows a schematic diagram of an Excel form file (. xls format), where a form file may include multiple pages, i.e., multiple sheets, each column of the form is denoted by a letter (A, B … … Z), each row of the form is denoted by a number (1, 2, 3 … …), and data in a form can be uniquely located by the row and column marks. The row number is added with 1 in sequence, the column index letters are sequentially converted into the next letter in the alphabet, and the column Z is followed by the column AA, the column AB, the column AC … … column BA, the column BB and the column BC … ….
Fig. 2 shows four tables to be checked, namely: "full channel + all customers. xls", "full channel + no-credit-household. xls", "full channel + credit-household. xls", and "full channel + institutional-household. xls". When the forms are checked, the forms can be placed in a folder, and a check result form (in an xlsm format) is also placed in the file directory, wherein a check tool code is built in the check result form, a control (for example, in a button form) is arranged in the check result form and used for triggering a report check tool to automatically execute so as to check the report to be checked, and a check result is presented in the check result form. The contents of the collation result table are shown in fig. 3. Clicking the 'check report' button control in fig. 3 can trigger the report check tool code to execute. The report form collation tool generation method provided in this specification is to write a code in the VBA edit window of the collation result table.
The embodiment of the present specification takes a checking method of a "surreptitious payroll business development condition table" of a bank as an example, and introduces a specific implementation manner of the embodiment of the present specification. The embodiment may be implemented by an electronic device having a computing function.
For example, the page Sheet1 of a table file is a "pay business development situation table", and the data of the table has the following operation rules: (1) determining that the row number does not contain or is equal to the row number according to the operation rule, and determining that the row number is transverse comparison; (2) b2> B3+ B4+ … … + B7, which is determined to be a vertical comparison according to the same column numbers in the operation rule. It is assumed that only the table data covered by the shading in fig. 1 needs to be checked, or that only the table covered by the shading has data.
For the operation rule (1) of the horizontal comparison, first, parameters are extracted according to the rule. Taking the letter C appearing first as a first column mark, taking the letter DE appearing later as a second column mark, marking the minimum row of a row filled with data in the query table as 2 and the maximum row as 8, taking the operator "+" appearing first as a first operational relation, and taking the operator "+" appearing later as a fourth operational relation.
And then starts writing code in the VBA editing window. Before that, a packaged first preset function match 1 (table name, page name, first column mark, second column mark, first operation relation, fourth operation relation, line mark) is set in advance.
Specifically, when writing a code, first, a first preset function match 1(inFile (j), insleet (j), C, DE, and k) is filled, where inFile () is an array, a table name of a report to be checked is stored in the array, insleet () is also an array, a page name of a report to be checked is stored in the array, a table may have multiple pages, and the table names and the page names stored in the corresponding sequence numbers of the two arrays are corresponding, for example, insleet (1), insleet (2), and insleet (3) are different pages in the same table, and then the table names stored in inFile (1), inFile (2), and inFile (3) are the same. The code of the first preset function implements functions including: finding a table file with a table name of infile (J), finding a page with a page name of insleet (J), acquiring data of Ck, Dk and Ek, comparing whether Ck is equal to Dk + Ek, and returning to pass if Ck is equal to Dk + Ek, and returning to fail if Ck is not equal to Ek.
And then assembling codes for circularly calling the first preset function on the basis of the first preset function, so that the first preset function is called once when data of any one of the lines from 2 nd to 8 th in the figure 1 are checked, and thus the check of each line in the range of the data to be checked is realized. Specifically, a minimum row number m and a maximum row number n of a data range to be checked may be obtained first; assembling codes for circularly calling a first preset function, wherein a circular variable is a line mark k; the circulation condition is from m to n, and the step length is 1; the loop is a first preset function match 1(infile (j), infosheet (j), C, ═ DE, +, k), which when executed, determines whether the sum of the data in column C of row k and the data in column DE is equal.
Then, a code for displaying the collation result is written: sysoutf (j) compare1(infile (j), insleet (j), C, DE ═ k); the "sysoutf (j) &" code segment is used to display the display result in the collation result table shown in fig. 3, that is, to display the collated table name, page name and collation result in correspondence.
For the operation rule (2) of vertical comparison, a packaged second preset function match 2 (table name, page name, third column label, third row label, start row label, end row label, second operation relation) is preset before the operation rule.
Specifically, when writing a code, first, a second preset function match 2(inFile (j), insleet (j), B, 2, 3, 7, >) is filled, where inFile () is an array, a table name of a report to be checked is stored in the array, insleet () is also an array, a page name of a report to be checked is stored in the array, a table may have multiple pages, and the table names and the page names stored in the corresponding sequence numbers of the two arrays are corresponding, for example, insleet (1), insleet (2), and insleet (3) are different pages in the same table, and then the table names stored in inFile (1), inFile (2), and inFile (3) are the same. The code of the second preset function implements functions including: finding a table file with a table name of infile (j), finding a page with a page name of insleet (j), acquiring data of B2 and B3-B7, calculating the sum of the data of B3-B7, judging whether B2 is greater than the sum, and returning 'pass' if the sum is greater than the sum, and returning 'fail' if the sum is not equal to the sum.
The check of the operation rule (2) in the table shown in fig. 1 can be realized by performing the second preset function match 2 once according to the parameters.
Based on the above specific embodiments, the embodiments of the present specification provide a method for generating a report checking tool, which can be used in any electronic device with a computing function. As shown in fig. 4, the method includes the steps of:
s10: and acquiring an operation rule of report data, wherein the operation rule is used for restricting the relationship between data in rows or columns of the report.
A report, as used herein, refers to a table used to display data, including tabular formats and data within the table. Data in the same report usually needs to be checked, and data in different reports has correlation and also needs to be checked.
Although the embodiment only provides the method for checking the data in the same report, since the specific embodiment provides the operation of opening the report file, when the data between the report J and the report K needs to be checked, only the two reports need to be opened to obtain the data, and therefore the method for checking the reports provided by the embodiment can also be used for checking the data between different reports. The different reports can be in the same format, that is, the contents represented by the corresponding columns are consistent, or the contents represented by the corresponding rows are consistent.
The calculation rule between the report data usually comes from the business rule, for example, the loan amount of the head office of a bank, the loan amount of a certain branch in Jiangsu and the loan amount of a certain branch in Zhejiang are respectively in C column, D column and E column, and then the calculation rule "C > D + E" can be obtained according to the business rule that the loan amount of the head office of a bank should be greater than the sum of the loan amount of a certain branch in Jiangsu and the loan amount of a certain branch in Zhejiang.
In some embodiments, the operation rule between report data may also be derived from a calculation formula, for example, the side length of the cube and the volume of the cube are respectively in F column and G column, and then the operation rule "G ═ F ^ 3" may be obtained according to the calculation formula "the volume of the cube ═ side length ^ side length".
In some embodiments, the operation rule of the F column and the G column may also be G-sinF, G-lnF, and so on, and the embodiments in this specification cannot be exhaustive.
The operation rules in the embodiments of this specification may include arithmetic operations (addition, subtraction, multiplication, and division), and may also include mathematical operations such as sine and cosine functions and log functions, and/or unequal boolean operations, and relational operations such as greater than, less than, and equal to, which are not exhaustive in the embodiments of this specification.
The operation rule can be programmed by a mathematical expression program or a character description mode.
S20: and extracting parameters from the operation rule, wherein the parameters at least comprise row marks and/or column marks.
The preset function refers to a function which is packaged, has a specified function name and a specified code in the function body, when the execution of the code in the function requires the data provided outside the function body, the preset function also has a form parameter in the bracket behind the function name, and the form parameter is processed when the code in the function is executed. When the preset function is called and the parameter needs to be transferred, data provided externally when the preset function is called is filled in brackets of the preset function as an actual parameter, and the position of the actual parameter in the brackets corresponds to the position of the form parameter in the brackets.
When extracting the parameters, the comparison direction of the operation rule may be determined, for example, a horizontal comparison and a vertical comparison, where the horizontal comparison is a comparison between different data in the same row, and the vertical comparison is a comparison between different data in the same column, and then the parameters are extracted as actual parameters of the preset function according to the comparison direction. Of course, the conclusion of the transverse comparison or the longitudinal comparison may not be obtained, and the parameters may be extracted directly according to the features corresponding to the conclusion.
The method for determining the comparison direction may be determined according to the expression rule, specification or format of the operation rule, for example, the comparison direction shown in the table may be extracted by directly aligning the operation rules in the following tables 1 and 2. For tables 1 and 2, the rule expression rules are as follows: "A to B" represents the sum of data from A to B, for example "B6 to B41" represents the sum of data from B6+ B7+ … … + B41; only the sum operation of data among columns uses a plus sign, and the operation rules among different columns do not contain row marks; in the operation rule, compared data is in front of other data; and, the arithmetic relationship between the data other than the compared data is only one.
Based on the operation rule, judging the comparison direction according to whether the operation rule contains a plus sign, and if the operation rule contains the plus sign, performing transverse comparison; when there is no "+" present, there is a vertical comparison. Or, the comparison direction can be judged according to whether the operation rule contains the row mark represented by the number, and when the operation rule contains the row mark represented by the number, the comparison is vertical; when the row labels of the numerical representations are not included, the comparison is transverse. Or, judging the comparison direction according to whether the column marks in the operation rule are the same or whether the letters in the operation rule are the same, and when the letters are the same, namely the column marks are the same, performing longitudinal comparison; when the letters are not the same, i.e., the column designations are not the same, a lateral comparison is made.
The above three examples are only used to describe the method for determining comparison, which can be determined according to the expression rule, specification or format of the operation rule, and when the expression rule, specification or format is different, the method for determining the comparison direction may also be different. Other methods for determining the comparison direction will also occur to those skilled in the art based on the above three examples, and are not exhaustive here.
TABLE 1
TABLE 2
The method for extracting the parameters may also be determined according to the comparison direction of the operation rule or the above-mentioned features corresponding to the comparison direction, and the expression rule, specification or format of the operation rule, for example, the above-mentioned parameters may be extracted for the operation rules in table 1 and table 2.
Specifically, the extraction rule may be: when the comparison direction is transverse, taking the first appearing letter as a first column mark, taking the subsequent appearing letter as a second column mark, taking the first appearing operator as a first operational relation, and taking the subsequent appearing operator as a fourth operational relation; when the comparison direction is vertical, the letter appearing first is taken as the third column label (when only one letter exists in the operation rule, any letter appearing first can be taken as the third column label), the number appearing first is taken as the first row label, the number appearing second is taken as the starting row label, the number appearing third is taken as the ending row label, the operator appearing first is taken as the second operation relation, and the operator appearing or hidden subsequently is taken as the sixth operation relation (the operation relation is hidden by the rules "a to B" in table 1).
The method for extracting the parameters in the above example can be determined according to the expression rule, the specification or the format of the operation rule, and when the expression rule, the specification or the format are different, the method for judging the extraction also can be different. Other methods of extracting parameters will also occur to those skilled in the art based on the above teachings and are not exhaustive herein.
The comparison direction can be used not only to extract parameters for reference, but also to select a preset function. Usually there is more than one preset function, and different preset functions differ in the form parameter or the implemented function. When the coding language has the function of function reloading, the preset function can be automatically matched and preset to the proper preset function according to the actual parameters of the preset function transmitted by the code for calling the preset function without selecting the preset function.
S30: calling a preset write operation function, writing a code for calling a preset function into a VBA editing window of a table, and taking a parameter as an actual parameter of the preset function; when the preset function is executed, whether a group of data positioned by the row mark and the column mark in the actual parameter accords with the operation rule or not is judged.
One Excel is provided with a VBA editing window and used for code writing, and written codes are related to table contents, so that the table processing efficiency can be improved. Usually, a mouse is placed at the page name position at the lower left by manual operation, then a right key is clicked, and then a 'view code' is clicked to call out a VBA editing window. The method provided by the embodiment of the specification enables the electronic equipment executing the method to automatically open the VBA editing window and write codes in the editing window.
The "table" in this step may be an existing table (a check result table) or a table newly created during the execution of the method provided in this specification for storing a check result.
S40: writing in a code for displaying a checking result so as to obtain a report checking tool code; when the report checking tool is executed, the data in the report is automatically checked whether the data meet the operation rule.
Because the transverse comparison mode needs to check row by row, a cyclic code needs to be supplemented, and the longitudinal comparison mode does not need to check row by row or column by column, the generation method of the report checking tool provided by the specification adopts different modes to assemble program codes according to different comparison directions when the codes are written.
When the comparison direction is a horizontal comparison, the first preset function may be any one of the following four functions (the following is only used for illustrating the name and form parameters of the function, and is not taken as a function header when defining the function):
match 1 (first column, second column, row); - (1)
Match 1 (first column, second column, row, first arithmetic relation); - (2)
Match 1 (first column, second column, row, first operational relationship, fourth operational relationship); - (3)
Match 1 (first column, second column, row, first operational relationship, fourth operational relationship, third operational relationship); - (4)
The first column mark and the second column mark are column marks respectively positioned at two sides of a relation operator, wherein the relation operator can be represented by symbols or words.
In some embodiments, it is only necessary to check whether the data of the first and second columns satisfy a certain operational relationship, and at this time, the certain operational relationship may be fixedly written in the implementation code of the first preset function (for example, equal), and the form parameter of the function may default to the first operational relationship, which is the operational relationship between the first and second columns, and the first preset function is as the above formula (1). When assembling a loop code for circularly calling a first preset function, a loop variable is a line mark k; the circulation condition is from m to n, and the step length is 1; the cycle body is a first preset function, the first column mark, the second column mark and the row mark k are used as actual parameters of the first preset function, and the first preset function is as the formula (1); when the first preset function is executed, whether the data of the first column mark column and the data of the second column mark column of the k rows meet the preset operational relationship (for example, equal) or not is judged. Finally, a code for displaying the result of the collation is written, for example, a code segment "sysoutf (j) ═ sysoutf (j) &" is added before the first preset function compare1 function. The m is the minimum row mark of the report data, and the n is the maximum row mark of the report data, which can be obtained when the parameters are extracted.
In some embodiments, the data operation relationship between the first and second columns is uncertain, such as being greater than, less than, or equal to, and the formal parameters of the first preset function must have the first operation relationship, and the first preset function is as shown in the above equations (2), (3) and (4). For example, column C is larger than column D + column E and column F is smaller than column D + column E. When assembling a loop code for circularly calling a first preset function, a loop variable is a line mark k; the circulation condition is from m to n, and the step length is 1; the cycle body is a first preset function, the first column mark, the second column mark, the row mark k and the first operational relation are used as actual parameters of the first comparison function, and the first preset function is as the above formulas (2), (3) and (4); when the first preset function is executed, whether the data of the first column mark column and the data of the second column mark column of the k rows meet a first operation relation or not is judged. Finally, a code for displaying the result of the collation is written, for example, a code segment "sysoutf (j) ═ sysoutf (j) &" is added before the first preset function compare1 function. The m is the minimum row mark of the report data, and the n is the maximum row mark of the report data, which can be obtained when the parameters are extracted.
In some embodiments, the number of the second labels is more than one, but it is only necessary to calculate the data between different second labels according to a fixed operational relationship, at this time, the determined operational relationship between the second labels may be fixedly written in the implementation code of the first preset function, and the form parameter of the first preset function may default to a fourth operational relationship, which is an operational relationship between at least two second labels. For example, column C is larger than column D + column E and column F is smaller than column D + column E. The first preset function is as in equations (1) (2) above.
In other embodiments, the number of the second columns is more than one, and the operation relationship between the second columns is uncertain, and may be a summation operation relationship, a multiplication operation relationship, or a logical and operation relationship, in which case the formal parameter of the first preset function must have a fourth operation relationship, and the first preset function is as the above equation (3) (4). For example, column C is equal to column D + column E, and column F is equal to column D × column E (× denotes the product). When assembling a loop code for circularly calling a first preset function, a loop variable is a line mark k; the circulation condition is from m to n, and the step length is 1; the loop body is a first preset function; taking the first column mark, the second column mark, the row mark k, the first operational relation and the fourth operational relation as actual parameters of a first preset function; when the first preset function is executed, the second row and column data of the k rows are calculated according to the fourth operational relationship, and whether the calculation result and the data of the first row and column of the k rows meet the first operational relationship is judged. Finally, a code for displaying the result of the collation is written, for example, a code segment "sysoutf (j) ═ sysoutf (j) &" is added before the first preset function compare1 function. The m is the minimum row mark of the report data, and the n is the maximum row mark of the report data, which can be obtained when the parameters are extracted.
In some embodiments, the number of the first lists is more than one, but it is only necessary to check the first lists according to a fixed operation relationship, in this case, the operation relationship determined between the first lists may be fixedly written in the implementation code of the first preset function, and the form parameter of the first preset function may default to a third operation relationship, which is an operation relationship between at least two first lists. For example, column a + column B ═ column C + column D. The first preset function is as in equations (1), (2) and (3) above.
In some embodiments, the number of the first indexes is more than one, and the operation relationship between the first indexes is uncertain, and may be a summation operation relationship, a multiplication operation relationship, or a logical and operation relationship, in which case the formal parameter of the first preset function must have a third operation relationship. For example, a column × B column + C column + D column (×) represents a product. The first preset function is as in equation (4) above. When assembling a loop code for circularly calling a first preset function, a loop variable is a line mark k; the circulation condition is from m to n, and the step length is 1; the loop body is a first preset function; taking the first column mark, the second column mark, the row mark k, the first operational relationship, the fourth operational relationship and the third operational relationship as actual parameters of the first preset function, as shown in the formula (8); when the first preset function is executed, the second row and column data of the k rows are calculated according to the fourth operational relationship, the first row and column data of the k rows are calculated according to the third operational relationship, and then whether the two calculation results meet the first operational relationship is judged. Finally, a code for displaying the result of the collation is written, for example, a code segment "sysoutf (j) ═ sysoutf (j) &" is added before the first preset function compare1 function. The m is the minimum row mark of the report data, and the n is the maximum row mark of the report data, which can be obtained when the parameters are extracted.
In some embodiments, the number of the second targets is one, but the second targets have monocular operators, and the second targets only need to be checked according to a fixed monocular operation relationship, in this case, the operation relationship to the second targets may be fixedly written in the implementation code of the function, and the form parameter of the function may default to a fourth operation relationship, which is an operation relationship between at least two second targets. The function is as in the above equations (1) (2). For example, the C column is cos E column.
In some embodiments, the number of the second list is one, but the second list has a monocular operator, and the monocular operational relationship is not definite, and may be a logical negation operation or a cosine cos operation, and in this case, the formal parameter of the function must have a fourth operational relationship. The function is as in the above equations (3) (4). For example, column E is cos C column and column F is sin D column.
In some embodiments, the number of the first list is one, but the first list has a monocular operator, and the first list only needs to be checked according to a fixed monocular operational relationship, in which case, the operational relationship to the first list may be fixedly written in the implementation code of the function, and the formal parameter of the function may default to the first operational relationship, which is an operational relationship between at least two first lists. The function is as in the above equations (1), (2) and (3). For example, cos C column ═ D column + E column.
In some embodiments, the number of the first list is one, but the first list has a monocular operator, and the monocular operational relationship is not definite, and may be a logical negation operation or a cosine cos operation, in which case the formal parameter of the function must have the first operational relationship. The function is as in equation (4) above. For example, cos C column + D column + E column, sin J column a B.
In one embodiment, one of the above functions (1) to (4) may be selected according to a specific situation.
Alternatively, in an embodiment, the first preset function, named 1, in the above (1) to (4) is a homonym function (i.e. the functions have the same name and are all named 1, and only the form parameters are different), and may be all packaged functions, and these homonym functions are written in advance and called function reloading. When the compare1 function is called, a required one of the (1) to (4) functions is automatically matched according to the incoming actual parameters.
When the comparison direction is vertical comparison, the second preset function may be any one of the following six functions (the following is only used for illustrating the name and form parameters of the function, and is not taken as a function header when defining the function):
compare2 (third column, third row, start row, end row, second operation relation); - (5)
Compare2 (third column, third row, start row, end row, second operation relationship, sixth operation relationship); - (6)
Compare2 (third column, first start row, first end row, second start row, second end row, second operation relation); - (7)
Compare2 (third column, first start row, first end row, second start row, second end row, second operation relationship, sixth operation relationship); - (8)
Compare2 (third column, first start row, first end row, second start row, second end row, second operation relationship, fifth operation relationship); - (9)
Compare2 (third column, first start row, first end row, second start row, second end row, second operation relationship, sixth operation relationship, fifth operation relationship); - (10)
The first initial row mark and the first end row mark are also called first row marks, the second initial row mark and the second end row mark are also called second row marks, the first row mark and the second row mark are row marks respectively positioned at two sides of a relation operator, wherein the relation operator can be represented by symbols or characters.
In some embodiments, it is only necessary to check the relationship between one data in a column and the sum (or other determined data relationship, such as product) of a segment of data (i.e. a plurality of data in a row mark in a column), where the operational relationship between the data of this data segment is determined, where the determined operational relationship may be fixedly written in the implementation code of the function, and the form parameter of the second preset function may default to a sixth operational relationship between the data of the start row mark row and the data of the end row mark row of the third column mark column. For example, B2> B3+ B4+ … … + B7. The second preset function is as in equation (5) above. When writing in a code for calling a second preset function, taking a third row mark, a third line mark, a starting line mark i in the operation rule, an ending line mark j in the operation rule and a second operation relation as actual parameters of the second preset function; when the second preset function is executed, the data from the i row to the j row of the third labeled column are calculated according to the determined operational relationship (for example, the sum of the data is calculated), and whether the calculation result and the data of the third labeled column and the third labeled row meet the second operational relationship is judged. Finally, a code for displaying the collation result is written, for example, a code segment "sysoutf (j) &" is added before the compare2 function.
In some embodiments, it is necessary to check the relationship between one data in a column and a segment of data (i.e. a plurality of data marked in succession in a row in a column), and the operational relationship between the segment of data is not determined, and may be a product relationship or a summation relationship, and then the formal parameter of the second preset function must have a sixth operational relationship. The function is as in equation (6) above. When a code for calling the second preset function is written, taking a third row mark, a third line mark, a starting line mark i, a terminating line mark j, a second operation relation and a sixth operation relation as actual parameters of the second preset function; when the second preset function is executed, the data from the i row to the j row of the third column and the third row are calculated according to the sixth operational relationship, and whether the calculation result and the data of the third column and the third row meet the second operational relationship is judged. Finally, a code for displaying the collation result is written, for example, a code segment "sysoutf (j) &" is added before the compare2 function.
In some embodiments, it is necessary to check a relationship between a sum of one piece of data (i.e., a plurality of data in which row marks in a row are consecutive) and a sum of another piece of data (i.e., a plurality of data in which row marks in a row are consecutive), where an operational relationship between data of two pieces of data is determined, where the determined operational relationship may be fixedly written in an implementation code of a second preset function, where a form parameter of the second preset function may default a sixth operational relationship, which is an operational relationship between data of a start row mark row to an end row mark row of a third row mark row, and a fifth operational relationship, which is an operational relationship between data of another start row mark row to another end row mark row of the third row mark row. For example, B1+ B2> B3+ B4+ … … + B7. The second preset function is as in equation (7) above. When writing in a code for calling a second preset function, taking a third row mark column, a first initial row mark m, a first termination row mark n, a second initial row mark i, a second termination row mark j and a second operation relation as actual parameters of the second preset function; when the second preset function is executed, the sum of the data from m rows to n rows of the third row mark column is calculated, the sum of the data from i rows to j rows of the third row mark column is calculated, and whether the two calculation results meet the second operation relationship is judged. Finally, a code for displaying the collation result is written, for example, a code segment "sysoutf (j) &" is added before the compare2 function.
In some embodiments, the relationship between one piece of data (i.e., a plurality of data marked by a row in a column) and another piece of data (i.e., a plurality of data marked by a row in a column) is checked, but the operational relationship between one piece of data is not determined, and the formal parameter of the function must have a sixth operational relationship or a fifth operational relationship, such as the above equation (8) or (9). Or the operational relationship between the two pieces of data is not determined, and at this time, the form parameter of the function has both the sixth operational relationship and the fifth operational relationship, as shown in the above formula (10). For the latter, when writing in a code for calling the second preset function, taking a third row label column, a first initial row label m, a first termination row label n, a second initial row label i, a second termination row label j, a second operational relationship, a sixth operational relationship and a fifth operational relationship as actual parameters of the second preset function; when the second preset function is executed, the data from the m row to the n row of the third row and column are calculated according to the fifth operational relationship, the data from the i row to the j row of the third row and column are calculated according to the sixth operational relationship, and whether the two calculation results meet the second operational relationship is judged. Finally, a code for displaying the collation result is written, for example, a code segment "sysoutf (j) &" is added before the compare2 function.
In one embodiment, one of the above functions (5) to (10) may be selected according to a specific situation.
Alternatively, in an embodiment, the second preset function, named 2, in the above (5) to (10) is a homonym function (i.e. the functions have the same name and are all named 2, and only the form parameters are different), and may be all packaged functions, and these homonym functions are written in advance and called function reloading. When the compare2 function is called, a required one of the compare2 functions is automatically matched (5) to (10) according to the actual parameters that are transmitted.
The generation method of the report form checking tool provided by the embodiment of the specification acquires the operation rule of report form data, extracts parameters from the rule in budget, writes codes for calling a preset function into a VBA editing window of a table, takes the extracted parameters as actual parameters of the preset function, judges whether a group of data positioned by a row mark and a column mark in the actual parameters accords with the operation rule when the preset function is executed, and writes codes for displaying a checking result to further obtain a checking tool code, wherein the checking tool can assist in checking the report forms, so that the data between the report forms do not need to be checked manually one by one, the checking efficiency is higher, and the accuracy is higher; and the report form checking tool can also realize the efficient checking of all data and the logic correctness of the management data among different report forms. According to the scheme, the checking tool codes are automatically generated according to the operation rules of the report, and the checking tool codes for a specific operation rule are not independently written aiming at the specific operation rule, so that the generated report checking tool codes are wide in application range.
The embodiment of the present specification provides a generation apparatus of a report checking tool, which can be used to implement the method described in the embodiment corresponding to fig. 4. As shown in fig. 5, the apparatus includes an acquisition module 10, an extraction module 20, a first writing module 30, and a second writing module 40.
The obtaining module 10 is configured to obtain an operation rule of report data, where the operation rule is used to constrain a relationship between data in a row or a column of a report.
The extracting module 20 is configured to extract parameters from the operation rule, where the parameters at least include row labels and/or column labels.
The first write-in module 30 is configured to call a preset write operation function, write a code for calling a preset function into a VBA editing window of a table, and use a parameter as an actual parameter of the preset function; when the preset function is executed, whether a group of data positioned by the row mark and the column mark in the actual parameter accords with the operation rule or not is judged.
The second writing module 40 is used for writing a code for displaying the checking result so as to obtain a report checking tool code; when the report checking tool is executed, the data in the report is automatically checked whether the data meet the operation rule.
The embodiment of the present specification provides an electronic device, which includes a memory and a processor, where the processor and the memory are communicatively connected to each other, the memory stores computer instructions, and the processor executes the computer instructions, so as to implement the steps of the method according to the corresponding embodiment in fig. 4.
Embodiments of the present invention provide a computer storage medium storing computer program instructions, which when executed implement the steps of the method of fig. 4 corresponding to the embodiments.
In the 90 s of the 20 th century, improvements in a technology could clearly distinguish between improvements in hardware (e.g., improvements in circuit structures such as diodes, transistors, switches, etc.) and improvements in software (improvements in process flow). However, as technology advances, many of today's process flow improvements have been seen as direct improvements in hardware circuit architecture. Designers almost always obtain the corresponding hardware circuit structure by programming an improved method flow into the hardware circuit. Thus, it cannot be said that an improvement in the process flow cannot be realized by hardware physical modules. For example, a Programmable Logic Device (PLD), such as a Field Programmable Gate Array (FPGA), is an integrated circuit whose Logic functions are determined by programming the Device by a user. A digital system is "integrated" on a PLD by the designer's own programming without requiring the chip manufacturer to design and fabricate a dedicated integrated circuit chip 2. Furthermore, nowadays, instead of manually making an Integrated Circuit chip, such Programming is often implemented by "logic compiler" software, which is similar to a software compiler used in program development and writing, but the original code before compiling is also written by a specific Programming Language, which is called Hardware Description Language (HDL), and HDL is not only one but many, such as abel (advanced Boolean Expression Language), ahdl (alternate Language Description Language), traffic, pl (core unified Programming Language), HDCal, JHDL (Java Hardware Description Language), langue, Lola, HDL, laspam, hardbyscript Description Language (vhr Description Language), and the like, which are currently used by Hardware compiler-software (Hardware Description Language-software). It will also be apparent to those skilled in the art that hardware circuitry that implements the logical method flows can be readily obtained by merely slightly programming the method flows into an integrated circuit using the hardware description languages described above.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments can be referred to each other, and each embodiment focuses on the differences from the other embodiments.
The systems, devices, modules or units described in the above embodiments may be implemented by a computer chip or an entity, or by a product with certain functions.
For convenience of description, the above devices are described as being divided into various units by function, and are described separately. Of course, the functionality of the units may be implemented in one or more software and/or hardware when implementing the present application.
From the above description of the embodiments, it is clear to those skilled in the art that the present application can be implemented by software plus necessary general hardware platform. Based on such understanding, the technical solutions of the present application may be essentially or partially implemented in the form of software products, which may be stored in a storage medium, such as ROM/RAM, magnetic disk, optical disk, etc., and include instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the methods of some parts of the embodiments of the present application.
The application is operational with numerous general purpose or special purpose computing system environments or configurations. For example: personal computers, server computers, hand-held or portable devices, tablet-type devices, multiprocessor systems, microprocessor-based systems, set top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, distributed computing environments that include any of the above systems or devices, and the like.
The application may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The application may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
Although the present application has been described in terms of embodiments, those of ordinary skill in the art will recognize that there are numerous variations and permutations of the present application without departing from the spirit of the application, and it is intended that the appended claims encompass such variations and permutations without departing from the spirit of the application.
Claims (10)
1. A method for generating a report form checking tool is characterized by comprising the following steps:
acquiring an operation rule of report data, wherein the operation rule is used for restricting the relationship between data in rows or columns of a report;
extracting parameters from the operation rule, wherein the parameters at least comprise row marks and/or column marks;
calling a preset write operation function, writing a code for calling a preset function into a VBA editing window of a table, and taking the parameter as an actual parameter of the preset function; when the preset function is executed, judging whether a group of data positioned by a row mark and a column mark in the actual parameters accords with the operation rule;
writing in a code for displaying a checking result so as to obtain a report checking tool code; and when the report checking tool is executed, automatically checking whether the data in the report conforms to the operation rule.
2. The generation method of report reconciliation tool of claim 1 further comprising:
judging the comparison direction of the operation rule, wherein the comparison direction comprises the following steps: comparing the data in different lines in the same row in the transverse direction, and comparing the data in different lines in the same line in the longitudinal direction;
and selecting a preset function according to the comparison direction.
3. The method for generating a report collating tool according to claim 1, wherein said step of extracting parameters from said operation rule includes:
extracting at least one first listing and at least one second listing, wherein the first listing and the second listing are respectively positioned at two sides of a relational operator;
alternatively, the first and second electrodes may be,
and extracting at least one first line mark and at least one second line mark, wherein the first line mark and the second line mark are respectively positioned at two sides of the relational operator.
4. The method for generating report reconciliation tool of claim 3 wherein in case of extracting at least one first and at least one second listing, prior to the step of obtaining report reconciliation tool code, further comprising:
acquiring a minimum row mark m and a maximum row mark n of a data range to be checked;
assembling a loop code for circularly calling the preset function, wherein a loop variable is a line mark k; the circulation condition is from m to n, and the step length is 1; the loop body is a code for calling the preset function, and a line mark k is also used as a parameter of the preset function; and when the preset function is executed, judging whether the data of the first column mark and the data of the second column mark of k rows meet the operation rule or not.
5. The generation method of report collating tool according to claim 3, wherein in the case of extracting at least one first listing and at least one second listing, the parameters further include a first operational relationship, the first operational relationship being an operational relationship between the first listing column and the second listing column data; correspondingly, when the preset function is executed, whether the first list mark column data and the second list mark column data meet the first operational relationship is judged;
alternatively, the first and second electrodes may be,
under the condition of extracting at least one first column mark and at least one second column mark, the parameters further comprise a second operational relationship, and the second operational relationship is an operational relationship between the first row mark and the second row mark; correspondingly, when the preset function is executed, whether the first row of marking data and the second row of marking data meet a second operational relationship is judged.
6. The method for generating report verification tool according to claim 4 or 5, wherein the parameters further include a third operation relationship and/or a fourth operation relationship when at least one first and at least one second column are extracted, the third operation relationship is an operation relationship between at least two first column data, and the fourth operation relationship is an operation relationship between at least two second column data;
correspondingly, when the preset function is executed, at least two first row mark column data are calculated according to the third operational relationship, and the calculation result is compared with the second row mark column data; and/or when the preset function is executed, at least two second column mark column data are calculated according to the fourth operational relationship, and the calculation result is compared with the first column mark column data;
alternatively, the first and second electrodes may be,
under the condition of extracting at least one first column mark and at least one second column mark, the parameters further comprise a fifth operational relationship and/or a sixth operational relationship, wherein the fifth operational relationship is an operational relationship between at least two first row standard data, and the sixth operational relationship is an operational relationship between at least two second row standard data;
correspondingly, when the preset function is executed, at least two first line index data are calculated according to the fifth operational relationship, and the calculation result is compared with the second line index data; and/or when the preset function is executed, at least two second line marking data are calculated according to the sixth operational relationship, and the calculation result is compared with the first line marking data.
7. The method as claimed in claim 1, wherein the parameters of the preset function further include a table name and/or a page name, and when the preset function is executed, the preset function opens the report corresponding to the table name and/or the page name and obtains the data located by the row mark and the column mark.
8. An apparatus for generating report reconciliation tools, the apparatus comprising:
the acquisition module is used for acquiring the operation rule of the report data, and the operation rule is used for restricting the relationship among the data in the row or the column of the report;
the extraction module is used for extracting parameters from the operation rule, and the parameters at least comprise row marks and/or column marks;
the first writing-in module is used for calling a preset writing operation function, writing a code for calling a preset function into a VBA editing window of a table, and taking the parameter as an actual parameter of the preset function; when the preset function is executed, judging whether a group of data positioned by a row mark and a column mark in the actual parameters accords with the operation rule;
the second writing module is used for writing in codes for displaying the checking result so as to obtain report checking tool codes; and when the report checking tool is executed, automatically checking whether the data in the report conforms to the operation rule.
9. An electronic device, comprising:
a memory and a processor, the processor and the memory being communicatively connected to each other, the memory having stored therein computer instructions, the processor implementing the steps of the method of any one of claims 1 to 7 by executing the computer instructions.
10. A computer storage medium having computer program instructions stored thereon that, when executed, implement the steps of the method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110562899.6A CN113191128B (en) | 2021-05-24 | 2021-05-24 | Report checking tool generation method and device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110562899.6A CN113191128B (en) | 2021-05-24 | 2021-05-24 | Report checking tool generation method and device and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113191128A true CN113191128A (en) | 2021-07-30 |
| CN113191128B CN113191128B (en) | 2024-03-19 |
Family
ID=76984814
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110562899.6A Active CN113191128B (en) | 2021-05-24 | 2021-05-24 | Report checking tool generation method and device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113191128B (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101794280A (en) * | 2010-03-11 | 2010-08-04 | 北京中科辅龙计算机技术股份有限公司 | Form automatic generation method and system based on form template set |
| CN102929853A (en) * | 2011-12-28 | 2013-02-13 | 上海西门子工业自动化有限公司 | DCS (Data Communication System) project data generating system and method based on Excel sheet association |
| CN103049558A (en) * | 2012-12-31 | 2013-04-17 | 郑州中实赛尔科技有限公司 | Method and system for generating report forms in Factory Talk View SE (site edition) configuration environment |
| US20150235262A1 (en) * | 2014-02-14 | 2015-08-20 | PharmaCommunications Holdings Inc. | Method, system and computer program product for enhancing business growth, marketing and analysis |
| CN106815182A (en) * | 2015-11-27 | 2017-06-09 | 国家电网公司 | One kind is based on being directed to power network financial statement statistical system under excel |
| CN108197114A (en) * | 2018-01-19 | 2018-06-22 | 腾讯科技（深圳）有限公司 | Detection method, device, storage medium and the electronic device of list data |
| CN111985201A (en) * | 2020-08-19 | 2020-11-24 | 支付宝(杭州)信息技术有限公司 | Data processing rule generation method and device and electronic equipment |
| CN112433730A (en) * | 2020-11-23 | 2021-03-02 | 北京字节跳动网络技术有限公司 | Code detection rule generation method and device and electronic equipment |
-
2021
- 2021-05-24 CN CN202110562899.6A patent/CN113191128B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101794280A (en) * | 2010-03-11 | 2010-08-04 | 北京中科辅龙计算机技术股份有限公司 | Form automatic generation method and system based on form template set |
| CN102929853A (en) * | 2011-12-28 | 2013-02-13 | 上海西门子工业自动化有限公司 | DCS (Data Communication System) project data generating system and method based on Excel sheet association |
| CN103049558A (en) * | 2012-12-31 | 2013-04-17 | 郑州中实赛尔科技有限公司 | Method and system for generating report forms in Factory Talk View SE (site edition) configuration environment |
| US20150235262A1 (en) * | 2014-02-14 | 2015-08-20 | PharmaCommunications Holdings Inc. | Method, system and computer program product for enhancing business growth, marketing and analysis |
| CN106815182A (en) * | 2015-11-27 | 2017-06-09 | 国家电网公司 | One kind is based on being directed to power network financial statement statistical system under excel |
| CN108197114A (en) * | 2018-01-19 | 2018-06-22 | 腾讯科技（深圳）有限公司 | Detection method, device, storage medium and the electronic device of list data |
| CN111985201A (en) * | 2020-08-19 | 2020-11-24 | 支付宝(杭州)信息技术有限公司 | Data processing rule generation method and device and electronic equipment |
| CN112433730A (en) * | 2020-11-23 | 2021-03-02 | 北京字节跳动网络技术有限公司 | Code detection rule generation method and device and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113191128B (en) | 2024-03-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9613115B2 (en) | Generating programs based on input-output examples using converter modules | |
| US8037450B2 (en) | System and methods for tracing code generation in template engines | |
| CN109710237A (en) | A kind of online modification method of calibration and equipment based on customized two-dimentional report | |
| CN111176996A (en) | Test case generation method and device, computer equipment and storage medium | |
| CN108694214A (en) | Generation method, generating means, readable medium and the electronic equipment of data sheet | |
| Han et al. | Deriving minimal conflict sets by CS-trees with mark set in diagnosis from first principles | |
| Dengel et al. | smartfix: A requirements-driven system for document analysis and understanding | |
| CN111680634A (en) | Document file processing method and device, computer equipment and storage medium | |
| US9037961B1 (en) | System and method for storing a series of calculations as a function for implementation in a spreadsheet application | |
| WO2020000952A1 (en) | Pcb internetwork data integrating method and device | |
| CN110543422A (en) | software package code defect data processing method, system and medium for FPR | |
| CN114090671A (en) | Data import method and device, electronic equipment and storage medium | |
| CN114091383A (en) | Test sequence generation method, device and system and related equipment | |
| Klein et al. | smartFIX: An adaptive system for document analysis and understanding | |
| CN113312258A (en) | Interface testing method, device, equipment and storage medium | |
| CN112966482A (en) | Report generation method, device and equipment | |
| CN105302547A (en) | Fault injection method for Verilog HDL design | |
| Bowen | Formal specification in Z as a design and documentation tool | |
| CN113191128A (en) | Report form checking tool generation method and device and electronic equipment | |
| CN116360794A (en) | Database language analysis method, device, computer equipment and storage medium | |
| Mengyuan et al. | Automatic generation method of airborne display and control system requirement domain model based on NLP | |
| CN113805861B (en) | Code generation method based on machine learning, code editing system and storage medium | |
| CN107015955B (en) | Document editing method and device | |
| CN115618777A (en) | File generation method, device, equipment and storage medium | |
| CN109324963A (en) | The method and terminal device of automatic test profitable result |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |