CN109324963A - The method and terminal device of automatic test profitable result - Google Patents

The method and terminal device of automatic test profitable result Download PDF

Info

Publication number
CN109324963A
CN109324963A CN201810961150.7A CN201810961150A CN109324963A CN 109324963 A CN109324963 A CN 109324963A CN 201810961150 A CN201810961150 A CN 201810961150A CN 109324963 A CN109324963 A CN 109324963A
Authority
CN
China
Prior art keywords
result
data
test
profitable
data line
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
Application number
CN201810961150.7A
Other languages
Chinese (zh)
Other versions
CN109324963B (en
Inventor
梁厚恩
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Ping An Life Insurance Company of China Ltd
Original Assignee
Ping An Life Insurance Company of China Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Ping An Life Insurance Company of China Ltd filed Critical Ping An Life Insurance Company of China Ltd
Priority to CN201810961150.7A priority Critical patent/CN109324963B/en
Publication of CN109324963A publication Critical patent/CN109324963A/en
Application granted granted Critical
Publication of CN109324963B publication Critical patent/CN109324963B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/36Preventing errors by testing or debugging software
    • G06F11/3668Software testing
    • G06F11/3672Test management
    • G06F11/3692Test management for test results analysis
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/08Insurance
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • General Physics & Mathematics (AREA)
  • Development Economics (AREA)
  • Technology Law (AREA)
  • Strategic Management (AREA)
  • General Business, Economics & Management (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • Computer Hardware Design (AREA)
  • Quality & Reliability (AREA)
  • General Engineering & Computer Science (AREA)
  • Debugging And Monitoring (AREA)

Abstract

The present invention is suitable for technical field of data processing, provides method, terminal device and the computer readable storage medium of automatic test profitable result, comprising: obtain preset multiple Data Identifications;The creation data file that user uploads is obtained, and determines multiple input datas corresponding with the multiple Data Identification in the creation data file;The multiple input data is calculated, using the obtained profitable result as production result;Test data file and preset calculation paradigm are obtained, the multiple input data is inputted into the test data file, and calculate the multiple input data by the calculation paradigm, using the obtained profitable result as test result;The production result is compared with the test result, if comparing failure, exports warning note.This invention simplifies test operations, improve testing efficiency.

Description

The method and terminal device of automatic test profitable result
Technical field
The invention belongs to technical field of data processing, more particularly to the method for automatic test profitable result, terminal device with And computer readable storage medium.
Background technique
With the development of Software engineering thought and computer technology, software test has been increasingly becoming software development flow and reality Important link in the operation flow of border.In the fields such as insurance or bank, need for a certain business progress income calculation, and to The profitable result that present customers are calculated needs to test the correctness of profitable result, prevents income knot before this Fruit error causes to influence business process.
In the prior art, the process for testing profitable result is that user is in front end system according to the call format of income calculation It is manually entered relevant business datum, and generates input parameter by the processing of front end system, then back-end system is successively read The input parameter of front end system is handled to obtain corresponding profitable result, and end user extracts income knot from back-end system Fruit, and it is compared manually with standard cases.It can be seen that in the prior art, the testing efficiency of profitable result by Front end system processing input parameter and back-end system read the influence of input parametric speed, and the coupling of front end system and back-end system Conjunction property is high, when front end system handle and is generated when the process of input parameter is blocked or when user's entry time is longer, is tested Low efficiency.
Summary of the invention
It can in view of this, the embodiment of the invention provides method, terminal device and the computers of automatic test profitable result Storage medium is read, it is low to the testing efficiency of profitable result in the prior art to solve the problems, such as.
The first aspect of the embodiment of the present invention provides a kind of method of automatic test profitable result, comprising:
Preset multiple Data Identifications are obtained, each Data Identification corresponding one for calculating the number of profitable result According to;
Obtain user upload creation data file, and determine in the creation data file with the multiple data mark Know corresponding multiple input datas, the creation data file is file relevant to the profitable result in production environment;
The multiple input data is calculated, using the profitable result being calculated as production result;
Test data file is obtained, calculation paradigm is preset with for the test data file, by the multiple input number According to the input test data file, and the multiple input data is calculated by the calculation paradigm, will be calculated For the profitable result arrived as test result, the test data file is relevant to the profitable result in test environment File;
The production result is compared with the test result, if comparing failure, exports warning note.
The second aspect of the embodiment of the present invention provides a kind of terminal device, and the terminal device includes memory, processing Device and storage in the memory and the computer program that can run on the processor, described in the processor execution Following steps are realized when computer program:
Preset multiple Data Identifications are obtained, each Data Identification corresponding one for calculating the number of profitable result According to;
Obtain user upload creation data file, and determine in the creation data file with the multiple data mark Know corresponding multiple input datas, the creation data file is file relevant to the profitable result in production environment;
The multiple input data is calculated, using the profitable result being calculated as production result;
Test data file is obtained, calculation paradigm is preset with for the test data file, by the multiple input number According to the input test data file, and the multiple input data is calculated by the calculation paradigm, will be calculated For the profitable result arrived as test result, the test data file is relevant to the profitable result in test environment File;
The production result is compared with the test result, if comparing failure, exports warning note.
The third aspect of the embodiment of the present invention provides a kind of computer readable storage medium, the computer-readable storage Media storage has computer program, and the computer program realizes following steps when being executed by processor:
Preset multiple Data Identifications are obtained, each Data Identification corresponding one for calculating the number of profitable result According to;
Obtain user upload creation data file, and determine in the creation data file with the multiple data mark Know corresponding multiple input datas, the creation data file is file relevant to the profitable result in production environment;
The multiple input data is calculated, using the profitable result being calculated as production result;
Test data file is obtained, calculation paradigm is preset with for the test data file, by the multiple input number According to the input test data file, and the multiple input data is calculated by the calculation paradigm, will be calculated For the profitable result arrived as test result, the test data file is relevant to the profitable result in test environment File;
The production result is compared with the test result, if comparing failure, exports warning note.
Existing beneficial effect is the embodiment of the present invention compared with prior art:
By obtaining preset multiple Data Identifications in the embodiment of the present invention, and obtain in the production environment that user uploads Creation data file determines multiple input datas corresponding with multiple Data Identifications in the creation data file, then multiple Input data is calculated, using obtained profitable result as production as a result, test data file is then obtained, by multiple inputs Data input test data file calculates multiple input datas according to calculation paradigm in test data file, will obtain Profitable result as test result, finally production result is compared with test result, fails if comparing, exports alarm Prompt.The embodiment of the present invention realizes the automatic test of profitable result, and user only needs to upload creation data file, is promoted Testing efficiency.
Detailed description of the invention
It to describe the technical solutions in the embodiments of the present invention more clearly, below will be to embodiment or description of the prior art Needed in attached drawing be briefly described, it should be apparent that, the accompanying drawings in the following description is only of the invention some Embodiment for those of ordinary skill in the art without any creative labor, can also be according to these Attached drawing obtains other attached drawings.
Fig. 1 is the implementation flow chart of the method for the automatic test profitable result that the embodiment of the present invention one provides;
Fig. 2 is the implementation flow chart of the method for automatic test profitable result provided by Embodiment 2 of the present invention;
Fig. 3 is the implementation flow chart of the method for the automatic test profitable result that the embodiment of the present invention three provides;
Fig. 4 is the implementation flow chart of the method for the automatic test profitable result that the embodiment of the present invention four provides;
Fig. 5 is the implementation flow chart of the method for the automatic test profitable result that the embodiment of the present invention five provides;
Fig. 6 is the structural block diagram for the terminal device that the embodiment of the present invention six provides;
Fig. 7 is the schematic diagram for the terminal device that the embodiment of the present invention seven provides.
Specific embodiment
In being described below, for illustration and not for limitation, the tool of such as particular system structure, technology etc is proposed Body details, to understand thoroughly the embodiment of the present invention.However, it will be clear to one skilled in the art that there is no these specific The present invention also may be implemented in the other embodiments of details.In other situations, it omits to well-known system, device, electricity The detailed description of road and method, in case unnecessary details interferes description of the invention.
In order to illustrate technical solutions according to the invention, the following is a description of specific embodiments.
Fig. 1 shows the implementation process of the method for automatic test profitable result provided in an embodiment of the present invention, and details are as follows:
In S101, preset multiple Data Identifications are obtained, each Data Identification corresponding one is received for calculating The data of beneficial result.
Profitable result refer to client after handling some business obtainable interests as a result, illustrated with insurance business, throw For guarantor (client) after paying insurance premium to insurance company, profitable result is regulation of the insurance company according to the insurance business, Insurer meets the insurance money paid after specified conditions to insurer.For the publisher of distribution work, pushed away by business When pin is to client, need simultaneously to present customers profitable result, to promote the successful probability of business handling.Showing profitable result Before, it needs to test profitable result, to guarantee the correctness of profitable result.In embodiments of the present invention, in order to receipts Beneficial result is tested, and obtains multiple Data Identifications first, above-mentioned each Data Identification corresponding one for calculating income knot The data of fruit.Equally illustrated with insurance business, usually, for calculate insurance business profitable result multiple data at least Including warrantee's age, insurance kind type, the basic insurance amount of money and insurance premium, then multiple Data Identifications are then above-mentioned multiple data Mark.Wherein, since in business scope, the title of multiple data for calculating profitable result is usually not in weight It is multiple, therefore the name for being used to calculate multiple data of profitable result directly can be referred to as multiple Data Identifications.
Optionally, multiple Data Identifications are obtained by preset Data Identification collection corresponding with profitable result.In the present invention In embodiment, the Data Identification collection comprising multiple Data Identifications can be preset, and after receiving acquisition instruction, from the data Multiple Data Identifications are obtained in identification sets.It is noted that profitable result relevant to business may include multiple types, and There may be differences for the corresponding Data Identification of each type of profitable result, therefore can be preset and a variety of profitable results one are a pair of The multiple Data Identification collection answered, and after receiving acquisition instruction (information that the acquisition instruction carries certain profitable result), Data Identification collection corresponding with this kind of profitable result is determined, to obtain multiple Data Identifications.
In S102, obtain user upload creation data file, and determine in the creation data file with it is described The corresponding multiple input datas of multiple Data Identifications, the creation data file are related to the profitable result in production environment File.
During developing on service line, test environment and production environment are undergone, wherein production environment refers to formally It is provided out the environment of business service, it is the environment for test data that test environment is identical as production environment configuration, is usually made For the standard of test.Therefore in order to guarantee the accuracy of profitable result calculating, will be respectively obtained by production environment and test environment Profitable result be compared.It is tested compared to traditional relevant data of business that are manually entered, in front end page shakiness Periodically, it is easy to because typing interruption causes test that can not carry out, in embodiments of the present invention, obtain the creation data that user uploads File, and multiple input datas in creation data file are determined according to multiple Data Identifications that step S101 is obtained.Whole During a, user need to only upload creation data file, reduce the unstable factor in Input Process.Wherein, it produces Data file is located in production environment, for calculating the file of profitable result.It is uploaded just to promote creation data file Benefit can be preset in the front end page of user client and upload option.It is noted that in the embodiment of the present invention, user Refer to the personnel tested.Illustrate this step with example, if the format of creation data file is EXCEL table, due to EXCEL table There are multiple data lines and multiple data to arrange, each data line represents a data record, each data column represent the number According to the corresponding attribute of data in record (title), when calculating profitable result, it is only necessary in data record some or certain it is several The corresponding data of attribute are as input, therefore multiple target columns correspondingly with multiple Data Identifications determining first.It wherein, can benefit With the VLOOKUP function of EXCEL table, and inputs multiple Data Identifications and search target columns.
Optionally, the name for obtaining multiple data column in EXCEL table is referred to as multiple name character strings, and by multiple data marks Knowledge is converted to multiple identification strings, and multiple name character strings are compared one by one with multiple identification strings, are obtained multiple Similar value is used as target column above or equal to the corresponding column of similar value of preset threshold.In practical application scene, due to ring Border difference, the title of data column may not be stringent corresponding with Data Identification in creation data file, such as insurance kind type pair The Data Identification answered is " insurance ", and in creation data file insurance kind type corresponding data column it is entitled " insurance-types ", but the two is substantially same attribute.Therefore in embodiments of the present invention, it obtains more in EXCEL table The name of a data column is referred to as multiple name character strings, and each name character string corresponds to the column of a data in EXCEL table, and will Multiple Data Identifications are converted to multiple identification strings, then carry out multiple name character strings and multiple identification strings one by one It compares.Comparing can be realized by edit distance approach or Hamming distance method, obtain multiple similar values after the completion of comparing, will be multiple Similar value is compared with preset threshold carries out numerical value, then above or equal in the corresponding EXCEL table of the similar value of preset threshold Data column be used as target column, improve target column determine applicability.Wherein, it is determining more than or equal to preset threshold After similar value, the corresponding name character string of similar value and identification strings can also be exported to user, and getting user's After confirmation instruction, then the data in the corresponding EXCEL table of similar value are arranged and are used as target column, prevents determining target column from occurring wrong Accidentally, the accuracy that target column determines is improved.
After multiple target columns of EXCEL table determine, according to the sequence of multiple Data Identifications from the data of every row of EXCEL table Multiple data corresponding with multiple target columns are extracted in record, as multiple input datas.For ease of description, hereinafter only to more The case where a input data is multiple data corresponding with multiple target columns in the data record of a certain data line of EXCEL table carries out It illustrates.
Optionally, if in the data record of EXCEL table, there is missing in the data under some target column, then stops obtaining and be somebody's turn to do All data of data record.As the data under target column to calculate data necessary to profitable result, therefore when under target column Some data when being empty, stop all data of the data line of EXCEL table where obtaining the data, i.e. data where the data All data of record, output prompt relevant to the data to user, and continue to carry out from next data line of EXCEL table The acquisition of input data, it is therefore prevented that subsequent profitable result calculates error.
Further, since the data under target column are in addition to necessary data, it may further include other data, than if necessary Data be number, other data be it is relevant introduce text, subsequent calculating process does not need to introduce the participation of text.Therefore It can obtain in embodiments of the present invention preset multiple value ranges (value range such as number 1 to 9, alphabetical A to Z etc.), it is multiple Value range and multiple Data Identifications correspond, for the value range for calculating multiple data necessary to profitable result.It is obtaining When taking the data under target column, target column will be only located in the data under target column and corresponds to the data of value range as input number According to realizing the screening of input data.
In S103, the multiple input data is calculated, using the profitable result being calculated as production As a result.
After obtaining multiple input datas, multiple input datas are counted by the storing process of the database of rear end It calculates, storing process refers to structured query language (the Structured Query for calculating profitable result in embodiments of the present invention Language, SQL) sentence, it is worth mentioning at this point that, which is located in production environment.Multiple input datas will be carried out The profitable result being calculated is as production result.In other words, the embodiment of the present invention be using storing process as an interface, from And the accuracy of the interface is tested.
In S104, test data file is obtained, is preset with calculation paradigm for the test data file, it will be described more A input data inputs the test data file, and is calculated by the calculation paradigm the multiple input data, Using the profitable result being calculated as test result, the test data file be in test environment with the income knot The relevant file of fruit.
After obtaining production result by storing process, the test data file in test environment, test data file are obtained For providing the standard compared, it is preset with calculation paradigm for test data file, which indicates correctly calculating side Method, it is worth mentioning at this point that, computer capacity can be stored in advance in test data file, may also be stored in specified storage address. Test data file can include equally different data kinds in the data record wherein including data record for EXCEL table Class, but the particular content under different data type is all empty.By multiple input data input test data files, being actually will be more The particular content of a input data is filled into data record, and income is calculated to multiple input datas by calculation paradigm As a result, using the profitable result as test result.
Optionally, if being preset with multiple calculation paradigms for test data file, chosen from multiple calculation paradigms with The corresponding calculation paradigm of multiple input datas, and test result is calculated.In practical application scene, a test data text Part may be as the comparison standard of multinomial business, namely the data record (data record including the different calculation paradigms of multiple correspondences Can be embodied in the form of data line, the corresponding data record of each data line), therefore can be set in advance according to multiple data records Rule of judgment is set, to judge the data record that multiple input datas belong to, and calls the corresponding calculating model of the data record Formula calculates multiple input datas.
For example, there are three row data records in test data file:
The first row data record is: the numerical value of data class A is ConditionA1, it is located at the first value interval;Data kind The numerical value of class B is ConditionB1, it is located at the second value interval, calculation paradigm ConditionA1+ConditionB1
Second row data record example is: the numerical value of data class A is ConditionA2, it is located at third value interval;Data The numerical value of type B is ConditionB2, it is located at the 4th value interval;Calculation paradigm is 1/2 (ConditionA2+ ConditionB2)。
The third line data record is: the numerical value of data class A is ConditionA3, it is located at the 5th value interval;Data kind The numerical value of class B is ConditionB3, it is located at the 6th value interval, calculation paradigm is 2/3 (ConditionA3+ConditionB3)。
It, can be by the numerical value institute of value interval and data class B where the numerical value of data class A according to three row data records Value interval constitute Rule of judgment, when receive multiple input datas (multiple input datas include data class A numerical value With the numerical value of data class B) when, judge the numerical value of the value interval and data class B where the numerical value of data class A again Value interval, to judge that the corresponding calculation paradigm of which data record is called to be calculated.Such as multiple input datas In, the numerical value of data class A belongs to third value interval, and the numerical value of data class B belongs to the 4th value interval, then by data kind The numerical value of class A and the numerical value of data class B are packed into the second above-mentioned row data record, and call 1/2 (ConditionA2+ ConditionB2) calculation paradigm handled, obtain test result.
In S105, the production result is compared with the test result, if comparing failure, exports alarm and mention Show.
After obtaining production result and test result, production result and test result are compared, one of which compares other side Formula is will to produce result and test result to be uniformly stored in another EXCEL table, and utilize the comparison function of EXCEL table such as MATCH () function is compared;Another alignments are will to produce result and test result to be converted into character string or text respectively Originally it is compared.Certainly, other alignments are also applicable in the embodiment of the present invention.Will production result and test result into Row obtains comparison value after comparing, if similar value meets preset condition, output compares successful result;If similar value is unsatisfactory for presetting Condition then compares failure, and exports the result for comparing failure, wherein and preset condition can be set according to practical application scene, Such as can be 100% numerical value.
By embodiment illustrated in fig. 1 it is found that in embodiments of the present invention, by obtaining preset multiple Data Identifications, and The creation data file in the production environment that user uploads is obtained, is determined corresponding with multiple Data Identifications in creation data file Multiple input datas, multiple input datas are calculated, using obtained profitable result as production as a result, then obtain survey Test data file in test ring border calculates multiple input datas by the corresponding calculation paradigm of test data file, Using obtained profitable result as test result, production result is compared with test result, if comparing failure, exports report Alert prompt, the embodiment of the present invention avoid user's long-time typing input data, improve the efficiency of profitable result test.
Shown in Fig. 2, be on the basis of the embodiment of the present invention one, and profitable result include it is multiple demonstration items basis On, multiple input datas will be calculated, after the profitable result being calculated is refined as the process of production result A kind of obtained implementation method.The embodiment of the invention provides the implementation flow charts of the method for automatic test profitable result, such as scheme Shown, which may comprise steps of:
In S201, the selection result about the multiple demonstration item of user's output is obtained.
If profitable result includes multiple demonstration items, such as some insurance business, profitable result may include expiry Multiple demonstration items such as insurance money, pure endowment gold and insurance money of dieing, but when demonstrating profitable result to client, it may only need The profitable result of item is demonstrated in demonstration part, for example only needs to demonstrate the expiry insurance money in profitable result.Accordingly, it is received in test When beneficial result, the profitable result for part demonstration item is also only needed to be tested.In embodiments of the present invention, it is defeated to obtain user The selection result about multiple demonstration items out, selection result instruction need demonstration item to be tested, wherein can be to the client of user Selection options of the end output comprising multiple demonstration items, and obtain selection operation alternatively result of the user about selection option.
In S202, the multiple input data is calculated, and by the obtained profitable result with the choosing The associated part of result is selected as the production result.
After getting selection result, multiple input datas are calculated by storing process, are obtained comprising multiple demonstrations The profitable result of item retains in above-mentioned profitable result with the associated part of selection result, i.e., only retains comprising needing to be tested drill The profitable result of aspect, and using the profitable result after reservation as production result.
In S203, the multiple input data is calculated, and will be calculated by the calculation paradigm institute It states in profitable result with the associated part of the selection result as the test result.
Similarly, after calculating by calculation paradigm multiple input datas, the receipts comprising multiple demonstration items are obtained Benefit is as a result, retain with the associated part of selection result in above-mentioned profitable result, i.e., only retaining includes to need demonstration item to be tested Profitable result, and using the profitable result after reservation as test result.
By embodiment illustrated in fig. 2 it is found that in embodiments of the present invention, by obtain user's output about multiple demonstrations Selection result, and multiple input datas are calculated, and by obtained profitable result with the associated portion of selection result It is allocated as to produce as a result, similarly, being calculated by calculation paradigm multiple input datas, and will be in obtained profitable result With the associated part of selection result as test result, surveyed just for the relevant profitable result of demonstration item to user demand Examination reduces the computing resource that test needs.
Shown in Fig. 3, be on the basis of the embodiment of the present invention one, and production result and test result include matching mark On the basis of knowledge, to a kind of implementation method obtained after the process that is compared with test result of result refines will be produced. The embodiment of the invention provides the implementation flow charts of the method for automatic test profitable result, as shown, the automatic test income As a result method may comprise steps of:
In S301, the second data line in the first data line and the test result in the production result is determined, The numerical value of the matching identification is identical with the numerical value of the matching identification under second data line under first data line.
If it includes matching identification that the format of profitable result, which is comprising multiple data lines, and in each data line, With some dimensional properties identified for identifying the income of the data line, such as time, then in order to complete format and income knot Comparison between the identical production result of fruit and test result is in embodiments of the present invention determined in production result first The second data line in first data line and test result, wherein the numerical value of matching identification and the second data line under the first data line The numerical value of lower matching identification is identical, for example the numerical value of matching identification is all the 1st year under the first data line and under the second data line.
In S302, first data line is compared with second data line.
After determining the first data line and the second data line, the first data line and the second data line are compared, obtained To data line comparison value.Optionally, comparison result collection is created, and data line comparison value is stored in comparison result collection.Actually answering With in scene, the first data line and the second data line may all exist multiple, therefore comparison result collection be pre-created, and by multiple One data line and multiple second data lines are compared, and obtained multiple data line comparison values are stored in comparison result collection.It compares After the completion, mean value is taken to the multiple data line comparison values compared in result set, and using the result for taking mean value to obtain as comparison value. It certainly, can also be directly using data line comparison value as comparison value.
By embodiment illustrated in fig. 3 it is found that in embodiments of the present invention, if production result and test result include matching Mark, it is determined that produce the second data line in the first data line and test result in result, match mark under the first data line The numerical value of matching identification is identical under the numerical value of knowledge and the second data line, then compares the first data line and the second data line It is right, by determining there are the first data line of corresponding relationship and the second data line, improve the order of comparing.
It is to determine the first data line and test in production result on the basis of the embodiment of the present invention three shown in Fig. 4 As a result it before the second data line in, when in production result comprising newly-increased data line, is adjusted according to newly-increased data line and calculates model A kind of implementation method that the process of formula obtains after being refined.The embodiment of the invention provides the methods of automatic test profitable result Implementation flow chart, as shown, the method for the automatic test profitable result may comprise steps of:
In S401, if comprising increasing data line, the matching identification under the newly-increased data line newly in the production result Numerical value and the numerical value of the matching identification under all data lines in the test result be different from, then obtain the newly-increased number According to the numerical value of matching identification described under row.
By the matching mark of all data lines in the numerical value of the matching identification of all data lines in production result and test result The numerical value of knowledge is matched, if production result in some matching identification numerical value in test result in all data lines not Successful match is then being surveyed the corresponding data line of the numerical value of the matching identification as newly-increased data line namely the newly-increased data line There is no corresponding data line in test result.For example, the numerical value for producing the matching identification of all data lines in result is followed successively by 1st year, the 2nd year ..., the 10th year, the numerical value of the matching identification of all data lines is followed successively by the 1st year, the 2nd in test result Year ..., the 9th year, then increase newly data line be produce result in matching identification numerical value be the 10th year data line.
In S402, the calculation paradigm is adjusted according to the numerical value of the matching identification under the newly-increased data line, so that Comprising adjusting data line, institute under the adjustment data line in the test result that the calculation paradigm by adjusting after obtains The numerical value for stating matching identification is identical as the numerical value of the matching identification under the newly-increased data line.
If there is newly-increased data line, then in order to guarantee that all data lines for producing result can be tested, according to new The corresponding calculation paradigm of numerical value adjustment test data file for increasing matching identification under data line, is under increase and newly-increased data line The corresponding calculation paradigm of the numerical value of matching identification.Multiple input datas are calculated based on calculation paradigm adjusted, To test result in comprising adjustment data line, adjust data line under matching identification numerical value and newly-increased data line under matching identification Numerical value it is identical, which is the standard that newly-increased data line compares.It is subsequent to be counted newly-increased data line as first It is compared according to row, and using adjustment data line as the second data line.
By embodiment illustrated in fig. 4 it is found that in embodiments of the present invention, being counted if producing in the data line of result comprising newly-increased According to row, the numerical value of the numerical value of matching identification and matching identification under data lines all in test result not phases under the newly-increased data line Together, then the numerical value of matching identification under the newly-increased data line is obtained, and is adjusted according to the numerical value for increasing matching identification under data line newly Calculation paradigm, so as to include adjustment data line, the adjustment number in the test result that the calculation paradigm by adjusting after is calculated Numerical value according to the lower matching identification of row is identical as the numerical value of matching identification under newly-increased data line, makes it possible to own production result Data line is tested, and the comprehensive of test is improved.
Shown in Fig. 5, be compared to result will be produced with test result on the basis of the embodiment of the present invention one, if Compare failure, then export warning note process refined after a kind of obtained implementation method.The embodiment of the invention provides The implementation flow chart of the method for automatic test profitable result, as shown, the method for the automatic test profitable result may include Following steps:
In S501, the production result and the test result are subjected to text matches, obtain matching value.
In embodiments of the present invention, the production text information of production result and the test text letter of test result are obtained respectively Breath, and text information and test text information progress text matches will be produced, the mode of text matches includes but is not limited to following Two kinds: first way is will to produce text information and test text information is compared by turn according to text digit, and will be literary This identical digit obtains matching value divided by the total bit of production text information, is suitable for the higher applied field of accuracy requirement Scape;The second way is to carry out word extraction to production text information and test text information, respectively obtains production sequence and survey Sequence is tried, and production sequence and cycle tests are compared according to preset sequence alignment formula, obtains matching value, wherein Word extraction can be carried out according to preset word list.Illustrate the second way with example, production text information is that " expiry obtains Claims Resolution ", test text information are " expiry settle a claim ", whether preset word list be " expiry, or not obtain, settle a claim ", then press The production sequence extracted according to word list to production text information is Listproduction=(1,0,1,1), according to pressing It is List to the cycle tests that test text information extracts according to word listtesting=(1,1,1,1), wherein producing " 1 " in sequence represents the word in word list to be occurred 1 time in production text information, similarly produces " 0 " in sequence The word represented in word list occurs 0 time in production text information, in practical application scene, produces sequence and test It may also occur that more numerical value in sequence.Sequence alignment formula for ease of description, it is assumed that Listproduction= (production1, production2... ..., productionn), cycle tests Listtesting=(testing1, testing2... ..., testingn), then sequence alignment formula can be with are as follows:
Wherein, NumbermatchFor matching value.Ω is constant term, can be arranged according to practical application scene, is matched for making Value is in expected numberical range.
In S502, if matching value is less than preset threshold, the warning note is exported, and export the calculating model Formula.
If being greater than or equal to preset threshold by the calculated matching value of sequence alignment formula, text information and survey are produced The matching degree of examination text information exceeds or meets expection, then does not execute the prompt that operation or output test pass through;If matching value Less than preset threshold, then the matching degree for producing text information and test text information is low, does not meet expection, then exports alarm and mention Show, prompts user to check production result and test result, also, the also exportable meter as test result calculations basis It calculates normal form and calculates the storing process on basis as production result, user is facilitated to search the difference of calculation paradigm and storing process.
By embodiment illustrated in fig. 5 it is found that in embodiments of the present invention, production result and test result are carried out text Match, obtain matching value, if obtained matching value is less than preset threshold, exports warning note, and export and test is calculated As a result calculation paradigm improves the accuracy of matching value calculating, and output calculates model when matching value is less than preset threshold Formula finds out existing difference between calculation paradigm and storing process convenient for user.
It should be understood that the size of the serial number of each step is not meant that the order of the execution order in above-described embodiment, each process Execution sequence should be determined by its function and internal logic, the implementation process without coping with the embodiment of the present invention constitutes any limit It is fixed.
Fig. 6 shows the structural block diagram of terminal device provided in an embodiment of the present invention, each unit which includes For executing each step in the corresponding embodiment of Fig. 1.It is retouched referring specifically to Fig. 1 is related in embodiment corresponding to Fig. 1 It states.For ease of description, only the parts related to this embodiment are shown.
Referring to Fig. 6, the terminal device includes:
First acquisition unit 61, for obtaining preset multiple Data Identifications, each Data Identification is one corresponding For calculating the data of profitable result;
Second acquisition unit 62 for obtaining the creation data file of user's upload, and determines the creation data text Multiple input datas corresponding with the multiple Data Identification in part, the creation data file be production environment in the receipts The relevant file of beneficial result;
Call unit 63 makees the profitable result being calculated for calculating the multiple input data To produce result;
Computing unit 64 is preset with calculation paradigm for the test data file for obtaining test data file, will The multiple input data inputs the test data file, and is carried out by the calculation paradigm to the multiple input data Calculate, using the profitable result being calculated be used as test result, the test data file be test environment in it is described The relevant file of profitable result;
Output unit 65, if comparing failure, is exported for the production result to be compared with the test result Warning note.
Optionally, profitable result includes multiple demonstration items, and call unit 63 includes:
As a result acquiring unit, for obtaining the selection result about the multiple demonstration item of user's output;
First computing unit calculates the multiple input data, and will be in the profitable result that be calculated With the associated part of the selection result as the production result;
The computing unit 64, comprising:
Second computing unit for being calculated by the calculation paradigm the multiple input data, and will calculate With the associated part of the selection result as the test result in the obtained profitable result.
Optionally, it produces result and test result includes matching identification, output unit 65 includes:
Determination unit, for determining the second data in the first data line and the test result in the production result Row, under first data line under the numerical value of the matching identification and second data line matching identification numerical value phase Together;
Comparing unit, for first data line to be compared with second data line.
Optionally it is determined that unit further include:
Numerical value acquiring unit, if for including to increase data line newly in the production result, it is described under the newly-increased data line The numerical value of matching identification and the numerical value of the matching identification under all data lines in the test result are different from, then obtain institute State the numerical value of the matching identification under newly-increased data line;
Adjustment unit, for adjusting the calculation paradigm according to the numerical value of the matching identification under the newly-increased data line, So as to include adjustment data line, the adjustment number in the test result that the calculation paradigm by adjusting after is calculated It is identical as the numerical value of the matching identification under the newly-increased data line according to the numerical value of matching identification described under row.
Optionally, output unit 65 includes:
Matching unit obtains matching value for the production result and the test result to be carried out text matches;
Subelement is exported, if being less than preset threshold for matching value, exports the warning note, and export the meter Calculate normal form.
Therefore, terminal device provided in an embodiment of the present invention realizes the automatic test of profitable result, simplifies test behaviour Make, improves testing efficiency.
Fig. 7 is the schematic diagram of terminal device provided in an embodiment of the present invention.As shown in fig. 7, the terminal device 7 of the embodiment Include: processor 70, memory 71 and is stored in the calculating that can be run in the memory 71 and on the processor 70 Machine program 72.The processor 70 realizes above-mentioned each automatic test profitable result method when executing the computer program 72 Step in embodiment, such as step S101 to S105 shown in FIG. 1.Alternatively, the processor 70 executes the computer journey The function of each unit in above-mentioned each terminal device embodiment, such as the function of unit 61 to 65 shown in Fig. 6 are realized when sequence 72.
Illustratively, the computer program 72 can be divided into one or more units, one or more of Unit is stored in the memory 71, and is executed by the processor 70, to complete the present invention.One or more of lists Member can be the series of computation machine program instruction section that can complete specific function, and the instruction segment is for describing the computer journey Implementation procedure of the sequence 72 in the terminal device 7.For example, the computer program 72 can be divided into the first acquisition list Member, second acquisition unit, call unit, computing unit and output unit, each unit concrete function are as follows:
First acquisition unit, for obtaining preset multiple Data Identifications, each Data Identification corresponds to a use In the data for calculating profitable result;
Second acquisition unit for obtaining the creation data file of user's upload, and determines the creation data file In multiple input datas corresponding with the multiple Data Identification, the creation data file be production environment in the income As a result relevant file;
Call unit, for calculating the multiple input data, using the profitable result being calculated as Produce result;
Computing unit is preset with calculation paradigm for the test data file for obtaining test data file, by institute It states multiple input datas and inputs the test data file, and the multiple input data is counted by the calculation paradigm Calculate, using the profitable result being calculated be used as test result, the test data file be test environment in the receipts The relevant file of beneficial result;
Output unit, if comparing failure, exports report for the production result to be compared with the test result Alert prompt.
The terminal device 7 can be the calculating such as desktop PC, notebook, palm PC and cloud server and set It is standby.The terminal device may include, but be not limited only to, processor 70, memory 71.It will be understood by those skilled in the art that Fig. 7 The only example of terminal device 7 does not constitute the restriction to terminal device 7, may include than illustrating more or fewer portions Part perhaps combines certain components or different components, such as the terminal device can also include input-output equipment, net Network access device, bus etc..
Alleged processor 70 can be central processing unit (Central Processing Unit, CPU), can also be Other general processors, digital signal processor (Digital Signal Processor, DSP), specific integrated circuit (Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field- Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic, Discrete hardware components etc..General processor can be microprocessor or the processor is also possible to any conventional processor Deng.
The memory 71 can be the internal storage unit of the terminal device 7, such as the hard disk or interior of terminal device 7 It deposits.The memory 71 is also possible to the External memory equipment of the terminal device 7, such as be equipped on the terminal device 7 Plug-in type hard disk, intelligent memory card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card dodge Deposit card (Flash Card) etc..Further, the memory 71 can also both include the storage inside list of the terminal device 7 Member also includes External memory equipment.The memory 71 is for storing needed for the computer program and the terminal device Other programs and data.The memory 71 can be also used for temporarily storing the data that has exported or will export.
It is apparent to those skilled in the art that for convenience of description and succinctly, only with above-mentioned each function Can unit division progress for example, in practical application, can according to need and by above-mentioned function distribution by different functions Unit is completed, i.e., the internal structure of the terminal device is divided into different functional units, to complete whole described above Or partial function.Each functional unit in embodiment can integrate in one processing unit, be also possible to each unit list It is solely physically present, can also be integrated in one unit with two or more units, above-mentioned integrated unit can both use Formal implementation of hardware can also be realized in the form of software functional units.In addition, the specific name of each functional unit also only It is the protection scope that is not intended to limit this application for the ease of mutually distinguishing.The specific work process of unit in above system, It can refer to corresponding processes in the foregoing method embodiment, details are not described herein.
In the above-described embodiments, it all emphasizes particularly on different fields to the description of each embodiment, is not described in detail or remembers in some embodiment The part of load may refer to the associated description of other embodiments.
Those of ordinary skill in the art may be aware that list described in conjunction with the examples disclosed in the embodiments of the present disclosure Member and algorithm steps can be realized with the combination of electronic hardware or computer software and electronic hardware.These functions are actually It is implemented in hardware or software, the specific application and design constraint depending on technical solution.Professional technician Each specific application can be used different methods to achieve the described function, but this realization is it is not considered that exceed The scope of the present invention.
In embodiment provided by the present invention, it should be understood that disclosed terminal device and method can pass through it Its mode is realized.For example, terminal device embodiment described above is only schematical, for example, the unit is drawn Point, only a kind of logical function partition, there may be another division manner in actual implementation, such as multiple units or components can To combine or be desirably integrated into another system, or some features can be ignored or not executed.Another point, it is shown or beg for The mutual coupling or direct-coupling or communication connection of opinion can be through some interfaces, the INDIRECT COUPLING of device or unit Or communication connection, it can be electrical property, mechanical or other forms.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple In network unit.It can select some or all of unit therein according to the actual needs to realize the mesh of this embodiment scheme 's.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit It is that each unit physically exists alone, can also be integrated in one unit with two or more units.Above-mentioned integrated list Member both can take the form of hardware realization, can also realize in the form of software functional units.
If the integrated unit is realized in the form of SFU software functional unit and sells or use as independent product When, it can store in a computer readable storage medium.Based on this understanding, the present invention realizes above-described embodiment side All or part of the process in method can also instruct relevant hardware to complete, the computer by computer program Program can be stored in a computer readable storage medium, and the computer program is when being executed by processor, it can be achieved that above-mentioned each The step of a embodiment of the method.Wherein, the computer program includes computer program code, and the computer program code can Think source code form, object identification code form, executable file or certain intermediate forms etc..The computer-readable medium can be with It include: any entity or device, recording medium, USB flash disk, mobile hard disk, magnetic disk, light that can carry the computer program code Disk, computer storage, read-only memory (Read-Only Memory, ROM), random access memory (Random Access Memory, RAM), electric carrier signal, telecommunication signal and software distribution medium etc..It should be noted that described computer-readable The content that medium includes can carry out increase and decrease appropriate according to the requirement made laws in jurisdiction with patent practice, such as at certain A little jurisdictions do not include electric carrier signal and telecommunication signal according to legislation and patent practice, computer-readable medium.
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations;Although referring to aforementioned reality Applying example, invention is explained in detail, those skilled in the art should understand that: it still can be to aforementioned each Technical solution documented by embodiment is modified or equivalent replacement of some of the technical features;And these are modified Or replacement, the spirit and scope for technical solution of various embodiments of the present invention that it does not separate the essence of the corresponding technical solution should all It is included within protection scope of the present invention.

Claims (10)

1. a kind of method of automatic test profitable result characterized by comprising
Preset multiple Data Identifications are obtained, each Data Identification corresponding one for calculating the data of profitable result;
Obtain user upload creation data file, and determine in the creation data file with the multiple Data Identification pair The multiple input datas answered, the creation data file are file relevant to the profitable result in production environment;
The multiple input data is calculated, using the profitable result being calculated as production result;
Test data file is obtained, is preset with calculation paradigm for the test data file, the multiple input data is defeated Enter the test data file, and the multiple input data is calculated by the calculation paradigm, by what is be calculated For the profitable result as test result, the test data file is text relevant to the profitable result in test environment Part;
The production result is compared with the test result, if comparing failure, exports warning note.
2. the method as described in claim 1, which is characterized in that the profitable result includes multiple demonstration items, described to described Multiple input datas are calculated, using the obtained profitable result as production result, comprising:
Obtain the selection result about the multiple demonstration item of user's output;
The multiple input data is calculated, and will be associated in the profitable result being calculated with the selection result Part as the production result;
It is described that the multiple input data is calculated by the calculation paradigm, the profitable result being calculated is made For test result, comprising:
The multiple input data is calculated by the calculation paradigm, and by the profitable result being calculated with The associated part of selection result is as the test result.
3. the method as described in claim 1, which is characterized in that the production result and the test result include matching mark Know, it is described that the production result is compared with the test result, comprising:
Determine the second data line in the first data line and the test result in the production result, first data line Under the matching identification numerical value it is identical with the numerical value of the matching identification under second data line;
First data line is compared with second data line.
4. method as claimed in claim 3, which is characterized in that the first data line and institute in the determination production result Before stating the second data line in test result, further includes:
If comprising increasing data line newly in the production result, the numerical value of the matching identification and the survey under the newly-increased data line The numerical value of the matching identification is different under all data lines in test result, then obtains the matching under the newly-increased data line The numerical value of mark;
The calculation paradigm is adjusted according to the numerical value of the matching identification under the newly-increased data line, so that the institute by adjusting after It states in the test result that calculation paradigm is calculated comprising adjusting data line, the matching identification under the adjustment data line Numerical value it is identical as the numerical value of the matching identification under the newly-increased data line.
5. the method as described in claim 1, which is characterized in that described to compare the production result with the test result It is right, if comparing failure, export warning note, comprising:
The production result and the test result are subjected to text matches, obtain matching value;
If matching value is less than preset threshold, the warning note is exported, and export the calculation paradigm.
6. a kind of terminal device, which is characterized in that the terminal device includes memory, processor and is stored in the storage In device and the computer program that can run on the processor, the processor are realized as follows when executing the computer program Step:
Preset multiple Data Identifications are obtained, each Data Identification corresponding one for calculating the data of profitable result;
Obtain user upload creation data file, and determine in the creation data file with the multiple Data Identification pair The multiple input datas answered, the creation data file are file relevant to the profitable result in production environment;
The multiple input data is calculated, using the profitable result being calculated as production result;
Test data file is obtained, is preset with calculation paradigm for the test data file, the multiple input data is defeated Enter the test data file, and the multiple input data is calculated by the calculation paradigm, by what is be calculated For the profitable result as test result, the test data file is text relevant to the profitable result in test environment Part;
The production result is compared with the test result, if comparing failure, exports warning note.
7. terminal device as claimed in claim 6, which is characterized in that the profitable result includes multiple demonstration items, described right The multiple input data is calculated, using the obtained profitable result as production result, comprising:
Obtain the selection result about the multiple demonstration item of user's output;
The multiple input data is calculated, and will be associated in the profitable result being calculated with the selection result Part as the production result;
It is described that the multiple input data is calculated by the calculation paradigm, the profitable result being calculated is made For test result, comprising:
The multiple input data is calculated by the calculation paradigm, and by the profitable result being calculated with The associated part of selection result is as the test result.
8. terminal device as claimed in claim 6, which is characterized in that the production result and the test result include It is described that the production result is compared with the test result with mark, comprising:
Determine the second data line in the first data line and the test result in the production result, first data line Under the matching identification numerical value it is identical with the numerical value of the matching identification under second data line;
First data line is compared with second data line.
9. terminal device as claimed in claim 8, which is characterized in that the first data line in the determination production result Before the second data line in the test result, further includes:
If comprising increasing data line newly in the production result, the numerical value of the matching identification and the survey under the newly-increased data line The numerical value of the matching identification is different under all data lines in test result, then obtains the matching under the newly-increased data line The numerical value of mark;
The calculation paradigm is adjusted according to the numerical value of the matching identification under the newly-increased data line, so that the institute by adjusting after It states in the test result that calculation paradigm is calculated comprising adjusting data line, the matching identification under the adjustment data line Numerical value it is identical as the numerical value of the matching identification under the newly-increased data line.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, and feature exists In when the computer program is executed by processor the step of any one of such as claim 1 to 5 of realization the method.
CN201810961150.7A 2018-08-22 2018-08-22 Method for automatically testing profit result and terminal equipment Active CN109324963B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810961150.7A CN109324963B (en) 2018-08-22 2018-08-22 Method for automatically testing profit result and terminal equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810961150.7A CN109324963B (en) 2018-08-22 2018-08-22 Method for automatically testing profit result and terminal equipment

Publications (2)

Publication Number Publication Date
CN109324963A true CN109324963A (en) 2019-02-12
CN109324963B CN109324963B (en) 2024-03-15

Family

ID=65263240

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810961150.7A Active CN109324963B (en) 2018-08-22 2018-08-22 Method for automatically testing profit result and terminal equipment

Country Status (1)

Country Link
CN (1) CN109324963B (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109902025A (en) * 2019-03-25 2019-06-18 腾讯科技(深圳)有限公司 Test environment Chinese part processing method, device, storage medium and computer equipment
CN111552698A (en) * 2020-04-21 2020-08-18 重庆富民银行股份有限公司 SQL version control system and method for solving environmental difference

Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1307705A (en) * 1998-06-29 2001-08-08 蒂姆莱恩公司 Data retrieval method and apparatus with multiple source capability
CN102708336A (en) * 2012-05-02 2012-10-03 四川建设网有限责任公司 Method and system for electronic document processing based on separation of key data from customized template
WO2014064777A1 (en) * 2012-10-24 2014-05-01 株式会社 日立製作所 Document evaluation assistance system and document evaluation assistance method
CN104299105A (en) * 2014-11-02 2015-01-21 中国科学院软件研究所 Credit data management system supporting complex enterprise environment and credit data management method
CN104978333A (en) * 2014-04-08 2015-10-14 无锡兰霖网络科技有限公司 Automatic matching method based on Excel statistical form and web technology
CN106022599A (en) * 2016-05-18 2016-10-12 德稻全球创新网络(北京)有限公司 Industrial design talent level evaluation method and system
JP2017021406A (en) * 2015-07-07 2017-01-26 日立オートモティブシステムズ株式会社 Evaluation result analysis system and evaluation result analysis method
CN106528419A (en) * 2016-11-07 2017-03-22 合网络技术(北京)有限公司 Service system testing method and device
CN107122344A (en) * 2017-05-24 2017-09-01 中国农业银行股份有限公司 A kind of report-generating method and system

Patent Citations (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1307705A (en) * 1998-06-29 2001-08-08 蒂姆莱恩公司 Data retrieval method and apparatus with multiple source capability
CN102708336A (en) * 2012-05-02 2012-10-03 四川建设网有限责任公司 Method and system for electronic document processing based on separation of key data from customized template
WO2014064777A1 (en) * 2012-10-24 2014-05-01 株式会社 日立製作所 Document evaluation assistance system and document evaluation assistance method
CN104978333A (en) * 2014-04-08 2015-10-14 无锡兰霖网络科技有限公司 Automatic matching method based on Excel statistical form and web technology
CN104299105A (en) * 2014-11-02 2015-01-21 中国科学院软件研究所 Credit data management system supporting complex enterprise environment and credit data management method
JP2017021406A (en) * 2015-07-07 2017-01-26 日立オートモティブシステムズ株式会社 Evaluation result analysis system and evaluation result analysis method
CN106022599A (en) * 2016-05-18 2016-10-12 德稻全球创新网络(北京)有限公司 Industrial design talent level evaluation method and system
CN106528419A (en) * 2016-11-07 2017-03-22 合网络技术(北京)有限公司 Service system testing method and device
CN107122344A (en) * 2017-05-24 2017-09-01 中国农业银行股份有限公司 A kind of report-generating method and system

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109902025A (en) * 2019-03-25 2019-06-18 腾讯科技(深圳)有限公司 Test environment Chinese part processing method, device, storage medium and computer equipment
CN111552698A (en) * 2020-04-21 2020-08-18 重庆富民银行股份有限公司 SQL version control system and method for solving environmental difference

Also Published As

Publication number Publication date
CN109324963B (en) 2024-03-15

Similar Documents

Publication Publication Date Title
CN109241068B (en) Method and device for comparing foreground and background data and terminal equipment
CN109359113B (en) Tax payment report checking method and device, storage medium and server
CN112507098B (en) Question processing method, question processing device, electronic equipment, storage medium and program product
CN109324960A (en) Automatic test approach and terminal device based on big data analysis
CN108460068A (en) Method, apparatus, storage medium and the terminal that report imports and exports
CN108345658B (en) Decomposition processing method of algorithm calculation track, server and storage medium
CN113297458A (en) Paging query method, device and equipment
CN115203435A (en) Entity relation generation method and data query method based on knowledge graph
CN109324963A (en) The method and terminal device of automatic test profitable result
CN113434542B (en) Data relationship identification method and device, electronic equipment and storage medium
CN110276609B (en) Business data processing method and device, electronic equipment and computer readable medium
CN112818937B (en) Excel file identification method and device, electronic equipment and readable storage medium
CN110503537A (en) A kind of financial accounting data intelligence matching process and system
CN111292068B (en) Contract information auditing method and device, electronic equipment and storage medium
CN109542890B (en) Data modification method, device, computer equipment and storage medium
CN112559817A (en) Report content checking method, system, computer equipment and storage medium
CN109740130B (en) Method and device for generating file
CN117236304A (en) Method for realizing Excel general import based on template configuration
CN111460293A (en) Information pushing method and device and computer readable storage medium
WO2016060553A1 (en) A method for converting file format and system thereof
CN111723129B (en) Report generation method, report generation device and electronic equipment
CN114490415A (en) Service testing method, computer device, storage medium, and computer program product
CN114138743A (en) ETL task automatic configuration method and device based on machine learning
CN115730604A (en) Index aggregation method, device, equipment and storage medium based on index library
CN109522211A (en) Interface parameters transmission method, device, electronic equipment and storage medium

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