CN102508839A - Data processing device and data processing method - Google Patents
Data processing device and data processing method Download PDFInfo
- Publication number
- CN102508839A CN102508839A CN201110285301XA CN201110285301A CN102508839A CN 102508839 A CN102508839 A CN 102508839A CN 201110285301X A CN201110285301X A CN 201110285301XA CN 201110285301 A CN201110285301 A CN 201110285301A CN 102508839 A CN102508839 A CN 102508839A
- Authority
- CN
- China
- Prior art keywords
- attribute
- sign
- project
- cell
- module
- 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
Images
Abstract
The invention provides a data processing device and a data processing method. The device comprises a data base, an acquisition module, a storage module, a related module, a monitoring module and a processing module, wherein the data base is used for correspondingly storing markers, first attributes and second attributes of projects; the acquisition module is used for acquiring markers of to-be-processed projects and to-be-processed second attributes corresponding to target fields and storing the markers of the to-be-processed projects and the to-be-processed second attributes into the storage model, or used for acquiring markers of current projects corresponding to current cells and second attributes corresponding to the markers of the current projects from the storage module when acquisition signals are received; the storage module is used for correspondingly storing the markers, the target fields and the second attributes of the to-be-processed projects; the related module is used for enabling the monitoring module to be related to cells in columns corresponding to the target fields; the monitoring module is used for monitoring the cells and sending out the acquisition signals to the acquisition module when the cells receive data; and the processing module is used for processing the data according to the second attributes corresponding to the markers of the current projects. By the aid of the technical scheme, different decimal digits can be kept in the same column in a list.
Description
Technical field
The present invention relates to data processing technique, in particular to a kind of data processing equipment and a kind of data processing method.
Background technology
In application software, often can use such as numeric type projects such as quantity, currency, disparity items also is not quite similar to the requirement of decimal digits generally speaking, and some project is only required two, and the possibility that has must be accurate to four decimals.It generally is by user oneself definition that these projects specifically need keep several decimals, can be provided with flexibly; And when in tabulation, showing project, what generally same row showed is same project, and the user can carry out the decimal digits setting to row.But, use common method to meet the demands if show at the same row of tabulation and the value of disparity items to keep different decimal digits.
Therefore, need a kind of new data processing technique, can be implemented in the different decimal digits of reservation in the same row of tabulation.
Summary of the invention
The present invention just is being based on the problems referred to above, has proposed a kind of new data processing technique, can be implemented in the same row of tabulation to keep different decimal digits.
In view of this, the present invention proposes a kind of data processing equipment, comprising: database, the sign of one or more projects, one or more first attribute and one or more second attribute are stored accordingly; Acquisition module; After pending list initialization; From said tabulation, obtain source field and one or more aiming field; Wherein, Said source field corresponding row in said tabulation comprise the sign of one or more pending projects, and a said aiming field is corresponding to said first attribute, and a cell in the row of said aiming field correspondence in said tabulation is corresponding to said second attribute; From said database, obtain sign and corresponding pending second attribute of said aiming field with said pending project then, and be stored in the sign of said pending project, said aiming field and said second attribute in the memory module accordingly; Or receiving when obtaining signal, obtain the currentitem purpose sign corresponding, and from said memory module, obtain and second attribute that said currentitem purpose sign is corresponding with current cell; Said memory module is stored the sign of said pending project, said aiming field and said second attribute accordingly; Relating module is with the cell of monitoring in the corresponding row of module relation to said aiming field; Said monitoring module is monitored said cell, when said cell receives data, sends the said signal that obtains to said acquisition module; Processing module, that obtains according to said acquisition module identifies corresponding said second attribute with said currentitem purpose, and said data are handled.In this technical scheme; The sign that comprises project in the row of source field place, and first attribute is the sign of the row at aiming field place, in the row at aiming field place; Corresponding to the sign of the project in each source field row, the figure place of decimal in second attribute such as this cell of a correspondence is arranged all.Through monitoring, can when the input data, the data of input be handled according to second attribute that obtains to said units lattice in the tabulation.Simultaneously; Sign, first attribute, second attribute through the project in will tabulating in advance extract from database and are stored in the memory module that is equivalent to buffer memory; Thereby, realize the processing of data cell being monitored and when wherein data are handled, being improved treatment effeciency.
In technique scheme, preferably, said memory module is arranged in said data processing equipment or is positioned at the outside of said data processing equipment.In this technical scheme, memory module can be parts such as the hard disk, buffer memory in this device, also can be equipment such as external portable hard drive, flash disk, thereby when building this device, make full use of parts or equipment existing or that price is comparatively cheap.
In technique scheme, preferably, said first attribute comprises: the sub-project sign with numeric type attribute; And said second attribute comprises: the decimal digits of the numerical value of said sub-project sign.In this technical scheme, first attribute is the sub-project sign that the amount of money, number, quantity etc. have the numeric type attribute, and second attribute is the decimal digits of the numerical value of above-mentioned first attribute.
In technique scheme, preferably, when having a plurality of said tabulation, said relating module earlier with said monitoring module relation to the one or more said tabulation that needs to monitor, be associated to said cell again.In this technical scheme, possibly there are a plurality of tabulations simultaneously, some tabulation maybe not need be monitored, thereby does not need association, but association is carried out in the tabulation of directly needs being monitored, and then the related cell of the needs in the associated tabulation is carried out association.
In technique scheme, preferably, when said acquisition module did not find corresponding with said currentitem purpose sign said second attribute in said memory module, said acquisition module was searched from said database; And when said acquisition module does not find corresponding with said currentitem purpose sign said second attribute yet in said database, said data are handled according to the default value of presetting.In this technical scheme, be stored in advance in the data in the memory module, maybe be not and the second corresponding attribute of sign of current project, then in database, further inquire about by acquisition module; And possibly also not have corresponding second attribute in the database, thereby should under above-mentioned situation, data be handled in advance preset one or more default values or default rule according to default value or default rule.
According to another aspect of the invention, also proposed a kind of data processing method, it is characterized in that, having comprised: step 202 is stored in the sign of one or more projects, one or more first attribute and one or more second attribute in the database accordingly; Step 204; After pending list initialization; Audiomonitor obtains source field and one or more aiming field from said tabulation, wherein, said source field corresponding row in said tabulation comprise the sign of one or more pending projects; A said aiming field is corresponding to said first attribute, and a cell in the row of said aiming field correspondence in said tabulation is corresponding to said second attribute; And from said database, obtain sign and corresponding pending second attribute of said aiming field with said pending project, and be stored in the sign of said pending project, said aiming field and said second attribute in the memory storage accordingly; Step 206 is associated to the cell in the corresponding row of said aiming field with said audiomonitor, and said cell is monitored; When said cell receives data; Said audiomonitor is triggered; And obtain the currentitem purpose corresponding sign with said cell; And from said memory storage, obtain and the second corresponding attribute of said currentitem purpose sign, and the said data in the said cell are handled according to said second attribute.In this technical scheme; The sign that comprises project in the row of source field place, and first attribute is the sign of the row at aiming field place, in the row at aiming field place; Corresponding to the sign of the project in each source field row, the figure place of decimal in second attribute such as this cell of a correspondence is arranged all.Through monitoring, can when the input data, the data of input be handled according to second attribute that obtains to said units lattice in the tabulation.Simultaneously; Sign, first attribute, second attribute through the project in will tabulating in advance extract from database and are stored in the memory storage that is equivalent to buffer memory; Thereby, realize the processing of data cell being monitored and when wherein data are handled, being improved treatment effeciency.
In technique scheme, preferably, the sign of a said project is corresponding to one or more said first attributes; The sign of a said project is corresponding to one or more said second attributes; And it is corresponding one by one with one or more said second attribute corresponding to the sign of a said project corresponding to one or more said first attribute of the sign of a said project.In this technical scheme, for the sign of a project, such as " company "; Maybe be corresponding to one or more first attributes, such as " employee's number ", " average salary " etc., also maybe be corresponding to one or more second attributes; Such as " 2 decimals ", " 4 decimals " etc.; Then corresponding one by one between first attribute and second attribute, like " employee's number " correspondence " 2 decimals ", and " average salary " correspondence " 4 decimals " etc.
In technique scheme, preferably, said first attribute comprises: the sub-project sign with numeric type attribute; And said second attribute comprises: the decimal digits of the numerical value of said sub-project sign.In this technical scheme; Sign for a project; Such as " company ", the first corresponding attribute is such as the sub-project sign of numeric type attributes such as " employee's number ", " average salary "; And the second corresponding attribute is as " 2 decimals ", " 4 decimals " etc., the decimal digits of the first attribute item value.
In technique scheme, preferably, said step 206 also comprises: when having a plurality of said tabulation, said audiomonitor is associated to earlier in the one or more said tabulation that needs to monitor, and is associated to said cell again.In this technical scheme, possibly there are a plurality of tabulations simultaneously, some tabulation maybe not need be monitored, thereby does not need association, but association is carried out in the tabulation of directly needs being monitored, and then the related cell of the needs in the associated tabulation is carried out association.
In technique scheme, preferably, said step 206 also comprises: when in the said memory storage during not corresponding with said currentitem purpose sign said second attribute, said audiomonitor is searched from said database; And, said data are handled according to the default value of presetting when in the said database during also not corresponding said second attribute with said currentitem purpose sign.In this technical scheme, be stored in advance in the data in the memory module, maybe be not and the second corresponding attribute of sign of current project, then in database, further inquire about by acquisition module; And possibly also not have corresponding second attribute in the database, thereby should under above-mentioned situation, data be handled in advance preset one or more default values or default rule according to default value or default rule.
Through above technical scheme, can be implemented in the different decimal digits of reservation in the same row of tabulation.
Description of drawings
Fig. 1 shows the block diagram of data processing equipment according to an embodiment of the invention;
Fig. 2 shows the process flow diagram of data processing method according to an embodiment of the invention;
Fig. 3 shows and carries out the related particular flow sheet of audiomonitor according to an embodiment of the invention; And
Fig. 4 shows the particular flow sheet of data processing method according to an embodiment of the invention.
Embodiment
In order more to be expressly understood above-mentioned purpose of the present invention, feature and advantage, the present invention is further described in detail below in conjunction with accompanying drawing and embodiment.
Set forth a lot of details in the following description so that make much of the present invention, still, the present invention can also adopt other to be different from other modes described here and implement, and therefore, the present invention is not limited to the restriction of following disclosed specific embodiment.
Fig. 1 shows the block diagram of data processing equipment according to an embodiment of the invention.
As shown in Figure 1, data processing equipment 100 according to an embodiment of the invention, comprising: database 102, the sign of one or more projects, one or more first attribute and one or more second attribute are stored accordingly; Acquisition module 104; After pending list initialization; From tabulation, obtain source field and one or more aiming field, wherein, source field corresponding row in tabulation comprise the sign of one or more pending projects; An aiming field is corresponding to one first attribute; And aiming field cell in the corresponding row in tabulation obtains sign and corresponding pending second attribute of aiming field with pending project then corresponding to one second attribute from database 102, and sign, aiming field and second attribute of pending project is stored in the memory module 106 accordingly; Or receiving when obtaining signal, obtain the currentitem purpose sign corresponding, and from memory module 106, obtain and second attribute that currentitem purpose sign is corresponding with current cell; Memory module 106 is stored sign, aiming field and second attribute of pending project accordingly; Relating module 108 is associated to the cell in the corresponding row of aiming field with monitoring module 110; Monitor module 110, cell is monitored, when cell receives data, send to acquisition module 104 and to obtain signal; Processing module 112, according to acquisition module 104 that obtain with the second corresponding attribute of currentitem purpose sign, data are handled.In this technical scheme; The sign that comprises project in the row of source field place, and first attribute is the sign of the row at aiming field place, in the row at aiming field place; Corresponding to the sign of the project in each source field row, the figure place of decimal in second attribute such as this cell of a correspondence is arranged all.Through monitoring, can when the input data, the data of input be handled according to second attribute that obtains to said units lattice in the tabulation.Simultaneously; Sign, first attribute, second attribute through the project in will tabulating in advance extract from database 102 and are stored in the memory module 106 that is equivalent to buffer memory; Thereby, realize the processing of data cell being monitored and when wherein data are handled, being improved treatment effeciency.
In technique scheme, memory module 106 is arranged in data processing equipment 100 or is positioned at the outside of data processing equipment 100.In this technical scheme; Memory module 106 can be parts such as the hard disk, buffer memory in this device 100; Also can be equipment such as external portable hard drive, flash disk, thereby install 100 o'clock building this, make full use of parts or equipment existing or that price is comparatively cheap.
In technique scheme, first attribute comprises: the sub-project sign with numeric type attribute; And second attribute comprise: the decimal digits of the numerical value of said sub-project sign.In this technical scheme, first attribute is sub-project signs such as the amount of money, number, quantity, and second attribute is the decimal digits of the numerical value of above-mentioned first attribute.
In technique scheme, when having a plurality of tabulation, relating module 108 will be monitored module 110 earlier and be associated in the one or more tabulations that need to monitor, and be associated to cell again.In this technical scheme, possibly there are a plurality of tabulations simultaneously, some tabulation maybe not need be monitored, thereby does not need association, but association is carried out in the tabulation of directly needs being monitored, and then the related cell of the needs in the associated tabulation is carried out association.
In technique scheme, when acquisition module 104 did not find second attribute corresponding with currentitem purpose sign in memory module 106, acquisition module 104 was searched from database 102; And when acquisition module 104 does not find second attribute corresponding with currentitem purpose sign yet in database 102, data are handled according to preset default value.In this technical scheme, be stored in advance in the data in the memory module 106, maybe be not and the second corresponding attribute of sign of current project, then in database 102, further inquire about by acquisition module 104; And possibly also not have corresponding second attribute in the database 102, thereby should under above-mentioned situation, data be handled in advance preset one or more default values or default rule according to default value or default rule.
Fig. 2 shows the process flow diagram of data processing method according to an embodiment of the invention.
As shown in Figure 2, data processing method according to an embodiment of the invention, comprising: step 202 is stored in the sign of one or more projects, one or more first attribute and one or more second attribute in the database accordingly; Step 204; After pending list initialization; Audiomonitor obtains source field and one or more aiming field from tabulation, wherein, source field corresponding row in tabulation comprise the sign of one or more pending projects; An aiming field is corresponding to one first attribute, and a cell in the row of aiming field correspondence in tabulation is corresponding to one second attribute; And from database, obtain sign and corresponding pending second attribute of aiming field with pending project, and be stored in sign, aiming field and second attribute of pending project in the memory storage accordingly; Step 206 is associated to the cell in the corresponding row of aiming field with audiomonitor, and cell is monitored; When cell receives data; Audiomonitor is triggered; And obtain the currentitem purpose sign corresponding with cell, and from memory storage, obtain and the second corresponding attribute of currentitem purpose sign, and according to second attribute data in the cell are handled.In this technical scheme; The sign that comprises project in the row of source field place, and first attribute is the sign of the row at aiming field place, in the row at aiming field place; Corresponding to the sign of the project in each source field row, the figure place of decimal in second attribute such as this cell of a correspondence is arranged all.Through monitoring, can when the input data, the data of input be handled according to second attribute that obtains to said units lattice in the tabulation.Simultaneously; Sign, first attribute, second attribute through the project in will tabulating in advance extract from database and are stored in the memory storage that is equivalent to buffer memory; Thereby, realize the processing of data cell being monitored and when wherein data are handled, being improved treatment effeciency.
In technique scheme, the sign of a project is corresponding to one or more first attributes; The sign of a project is corresponding to one or more second attributes; And it is corresponding one by one with one or more second attributes corresponding to the sign of a project corresponding to one or more first attributes of the sign of a project.In this technical scheme, for the sign of a project, such as " company "; Maybe be corresponding to one or more first attributes, such as " employee's number ", " average salary " etc., also maybe be corresponding to one or more second attributes; Such as " 2 decimals ", " 4 decimals " etc.; Then corresponding one by one between first attribute and second attribute, like " employee's number " correspondence " 2 decimals ", and " average salary " correspondence " 4 decimals " etc.
In technique scheme, first attribute comprises: the sub-project sign with numeric type attribute; And second attribute comprise: the decimal digits of the numerical value of said sub-project sign.In this technical scheme; Sign for a project; Such as " company ", the first corresponding attribute is such as the sub-project sign of numeric type attributes such as " employee's number ", " average salary "; And the second corresponding attribute is as " 2 decimals ", " 4 decimals " etc., the decimal digits of the first attribute item value.
In technique scheme, step 206 also comprises: when having a plurality of tabulation, audiomonitor is associated to earlier in the one or more tabulations that need to monitor, and is associated to cell again.In this technical scheme, possibly there are a plurality of tabulations simultaneously, some tabulation maybe not need be monitored, thereby does not need association, but association is carried out in the tabulation of directly needs being monitored, and then the related cell of the needs in the associated tabulation is carried out association.
In technique scheme, step 206 also comprises: when not identifying the second not corresponding attribute with the currentitem purpose in the memory storage, audiomonitor is searched from database; And when also not identifying the second not corresponding attribute in the database, data are handled according to preset default value with the currentitem purpose.In this technical scheme, be stored in advance in the data in the memory module, maybe be not and the second corresponding attribute of sign of current project, then in database, further inquire about by acquisition module; And possibly also not have corresponding second attribute in the database, thereby should under above-mentioned situation, data be handled in advance preset one or more default values or default rule according to default value or default rule.
Fig. 3 shows and carries out the related particular flow sheet of audiomonitor according to an embodiment of the invention.
As shown in Figure 3, concrete steps are following:
Step 302 is carried out initialization to the tabulation that needs are handled;
Step 304; Initialization decimal digits monitor; Here initialization procedure comprise: audiomonitor obtains source field and one or more aiming field from tabulation, wherein, source field corresponding row in tabulation comprise the sign of one or more pending projects; An aiming field is corresponding to one first attribute, and a cell in the row of aiming field correspondence in tabulation is corresponding to one second attribute; And from database, obtain sign and corresponding pending second attribute of aiming field with pending project, and sign, aiming field and second attribute of pending project is stored in the memory storage accordingly.Here be stored in sign, aiming field and second attribute of the pending project in the memory storage; Be equivalent to a buffer memory that is independent of database; Its capacity is far smaller than database, thereby has guaranteed to search in the subsequent step corresponding second attribute, and first attribute here is meant the sub-project sign with numeric type attribute; Like " employee's number ", " amount of money " etc., and second attribute is meant the decimal digits of the number in the corresponding unit lattice in first attribute.
Step 306 is associated to the tabulation that need monitor with audiomonitor, possibly have a plurality of tabulations simultaneously, and some tabulation maybe not need be monitored, thereby does not need association, but association is carried out in the tabulation of directly needs being monitored.
Step 308 is associated to audiomonitor on the cell of the related column in the tabulation, comprises a lot of row in the tabulation here; But not every row all need be monitored; Audiomonitor comprises the cell of numeric type item value through judging those, and whether its corresponding row are the aiming field of appointment, if; Then monitor, otherwise the cell in these row is not monitored.
After the association of having carried out audiomonitor as shown in Figure 3, for further the processing procedure of data having been made corresponding explanation in Fig. 4.Fig. 4 shows the particular flow sheet of data processing method according to an embodiment of the invention.
As shown in Figure 4, concrete steps are:
Step 402 is for assignment is carried out in tabulation;
Step 404, whether the object unit lattice of determining step 402 assignment are associated with the decimal digits audiomonitor, if do not have, then get into step 410, if having, then get into step 406;
Step 406 is utilized the corresponding source word segment value of audiomonitor in the tabulation, obtains the corresponding decimal digits of aiming field, and cell decimal digits attribute is set;
Step 408 according to cell decimal digits attribute, is processed raw data;
Step 410 shows final data.
For the above several steps of Fig. 3 and Fig. 4, as shown in table 1:
| The wages project | The negotiation sign | The standard amount of money | The amount of money |
| First project | Be | 6000.0000 | 6898.00 |
| Second project | Not | 2500.00 | 2524.0000 |
Table 1
In table 1, " wages project " is source field, and " the standard amount of money " and " amount of money " are corresponding aiming field; Then at first should carry out association like the audiomonitor among Fig. 3; Promptly, from database, obtain corresponding " the standard amount of money " and the decimal digits attribute of " amount of money ", and be stored in the memory storage for " first project " in " wages project " and " second project "; And " negotiation sign " be not owing to have the numeric type attribute; Thereby when initialization, just do not belong to source field, and do not belong to aiming field yet, can't carry out aforesaid operations; Simultaneously, audiomonitor is associated with in the cell in the corresponding row of " the standard amount of money " and " amount of money ", it is monitored; When filling in this form,,, therefore do not have audiomonitor to monitor so, can directly fill in because " negotiation sign " is not the sub-project sign of numeric type attribute as when filling in the cell of " negotiation sign " row; And for the cell of " the standard amount of money " one row, such as " the standard amount of money " corresponding to " first project ", when the user fills at this cell; Promptly trigger audiomonitor; Audiomonitor obtains source field " first project " and aiming field " the standard amount of money ", and correspondence is searched for this source field and aiming field in memory storage, is " 4 " such as the decimal digits that obtains; Be " 4 " attribute then as numerical value in this cell with decimal digits; Be added into this cell, and when the user fills in following numerical value like " 6000 ", " 6000 " be treated to " 6000.0000 "; And when " amount of money " cell of filling in corresponding to " second project ", obtain corresponding decimal digits and be " 2 " when then filling in " 2500 " the user, " 2500 " to be treated to " 2500.00 "; And when " amount of money " cell of filling in corresponding to " first project ", obtain corresponding decimal digits and be " 2 " when then filling in " 6898 " the user, " 6898 " to be treated to " 6898.00 "; The processing mode of other tabulation, row, cell roughly the same repeats no more here.In a word,, thereby realized in the same row in tabulation, realized that logarithm value keeps different decimal digits according to technique scheme.
More than be described with reference to the accompanying drawings technical scheme of the present invention; Consider when carrying out data processing, need show the value of disparity items sometimes, keep different decimal digits at the same row of tabulation; And use common method to meet the demands; Therefore, the invention provides a kind of data processing equipment and a kind of data processing method, can be implemented in the different decimal digits of reservation in the same row of tabulation.
The above is merely the preferred embodiments of the present invention, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.All within spirit of the present invention and principle, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a data processing equipment is characterized in that, comprising:
Database is stored the sign of one or more projects, one or more first attribute and one or more second attribute accordingly;
Acquisition module; After pending list initialization; From said tabulation, obtain source field and one or more aiming field; Wherein, Said source field corresponding row in said tabulation comprise the sign of one or more pending projects, and a said aiming field is corresponding to said first attribute, and a cell in the row of said aiming field correspondence in said tabulation is corresponding to said second attribute; From said database, obtain sign and corresponding pending second attribute of said aiming field with said pending project then, and be stored in the sign of said pending project, said aiming field and said second attribute in the memory module accordingly; Or receiving when obtaining signal, obtain the currentitem purpose sign corresponding, and from said memory module, obtain and second attribute that said currentitem purpose sign is corresponding with current cell;
Said memory module is stored the sign of said pending project, said aiming field and said second attribute accordingly;
Relating module is with the cell of monitoring in the corresponding row of module relation to said aiming field;
Said monitoring module is monitored said cell, when said cell receives data, sends the said signal that obtains to said acquisition module;
Processing module, that obtains according to said acquisition module identifies corresponding said second attribute with said currentitem purpose, and said data are handled.
2. data processing equipment according to claim 1 is characterized in that, comprising: said memory module is arranged in said data processing equipment or is positioned at the outside of said data processing equipment.
3. data processing equipment according to claim 1 is characterized in that, said first attribute comprises: the sub-project sign with numeric type attribute; And
Said second attribute comprises: the decimal digits of the numerical value of said sub-project sign.
4. data processing equipment according to claim 1 is characterized in that, when having a plurality of said tabulation, said relating module earlier with said monitoring module relation to the one or more said tabulation that needs to monitor, be associated to said cell again.
5. according to each described data processing equipment in the claim 1 to 4; It is characterized in that; When said acquisition module did not find corresponding with said currentitem purpose sign said second attribute in said memory module, said acquisition module was searched from said database; And
When said acquisition module does not find corresponding with said currentitem purpose sign said second attribute yet in said database, said data are handled according to the default value of presetting.
6. a data processing method is characterized in that, comprising:
Step 202 is stored in the sign of one or more projects, one or more first attribute and one or more second attribute in the database accordingly;
Step 204; After pending list initialization; Audiomonitor obtains source field and one or more aiming field from said tabulation, wherein, said source field corresponding row in said tabulation comprise the sign of one or more pending projects; A said aiming field is corresponding to said first attribute, and a cell in the row of said aiming field correspondence in said tabulation is corresponding to said second attribute; And
From said database, obtain sign and corresponding pending second attribute of said aiming field with said pending project, and be stored in the sign of said pending project, said aiming field and said second attribute in the memory storage accordingly;
Step 206 is associated to the cell in the corresponding row of said aiming field with said audiomonitor, and said cell is monitored;
When said cell received data, said audiomonitor was triggered, and obtained the currentitem purpose sign corresponding with said cell, and from said memory storage, obtained and the second corresponding attribute of said currentitem purpose sign, and
According to said second attribute said data in the said cell are handled.
7. data processing method according to claim 6 is characterized in that, comprising: the sign of a said project is corresponding to one or more said first attributes;
The sign of a said project is corresponding to one or more said second attributes; And
Corresponding one by one corresponding to one or more said first attribute of the sign of a said project with one or more said second attribute corresponding to the sign of a said project.
8. data processing method according to claim 6 is characterized in that, said first attribute comprises: the sub-project sign with numeric type attribute; And
Said second attribute comprises: the decimal digits of the numerical value of said sub-project sign.
9. data processing method according to claim 6 is characterized in that, said step 206 also comprises: when having a plurality of said tabulation, said audiomonitor is associated to earlier in the one or more said tabulation that needs to monitor, and is associated to said cell again.
10. according to each described data processing method in the claim 6 to 9; It is characterized in that; Said step 206 also comprises: when in the said memory storage during not corresponding with said currentitem purpose sign said second attribute, said audiomonitor is searched from said database; And
When in the said database during also not corresponding said second attribute, said data are handled according to the default value of presetting with said currentitem purpose sign.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110285301 CN102508839B (en) | 2011-09-22 | 2011-09-22 | Data processing device and data processing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110285301 CN102508839B (en) | 2011-09-22 | 2011-09-22 | Data processing device and data processing method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102508839A true CN102508839A (en) | 2012-06-20 |
| CN102508839B CN102508839B (en) | 2013-09-11 |
Family
ID=46220929
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201110285301 Active CN102508839B (en) | 2011-09-22 | 2011-09-22 | Data processing device and data processing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102508839B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105718485A (en) * | 2014-12-04 | 2016-06-29 | 中国移动通信集团公司 | Method and device for inputting data into database |
| CN106921614A (en) * | 2015-12-24 | 2017-07-04 | 北京国双科技有限公司 | Business data processing method and device |
| CN109272215A (en) * | 2018-08-31 | 2019-01-25 | 平安科技（深圳）有限公司 | Project development quality control method, device, computer equipment and storage medium |
| CN111694925A (en) * | 2019-03-13 | 2020-09-22 | 上海晶赞融宣科技有限公司 | Behavior data processing method and device, storage medium and terminal |
| CN113420538A (en) * | 2021-08-23 | 2021-09-21 | 深圳市明源云科技有限公司 | Numerical value format intelligent display method, equipment terminal and computer readable storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6631497B1 (en) * | 1999-07-19 | 2003-10-07 | International Business Machines Corporation | Binding data from data source to cells in a spreadsheet |
| CN1755679A (en) * | 2004-09-30 | 2006-04-05 | 微软公司 | Method and implementation for referencing of dynamic data within spreadsheet formulas |
-
2011
- 2011-09-22 CN CN 201110285301 patent/CN102508839B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6631497B1 (en) * | 1999-07-19 | 2003-10-07 | International Business Machines Corporation | Binding data from data source to cells in a spreadsheet |
| CN1755679A (en) * | 2004-09-30 | 2006-04-05 | 微软公司 | Method and implementation for referencing of dynamic data within spreadsheet formulas |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105718485A (en) * | 2014-12-04 | 2016-06-29 | 中国移动通信集团公司 | Method and device for inputting data into database |
| CN105718485B (en) * | 2014-12-04 | 2019-08-27 | 中国移动通信集团公司 | A kind of method and device by data inputting database |
| CN106921614A (en) * | 2015-12-24 | 2017-07-04 | 北京国双科技有限公司 | Business data processing method and device |
| CN106921614B (en) * | 2015-12-24 | 2020-05-22 | 北京国双科技有限公司 | Service data processing method and device |
| CN109272215A (en) * | 2018-08-31 | 2019-01-25 | 平安科技（深圳）有限公司 | Project development quality control method, device, computer equipment and storage medium |
| CN109272215B (en) * | 2018-08-31 | 2024-03-05 | 平安科技（深圳）有限公司 | Project development quality monitoring method and device, computer equipment and storage medium |
| CN111694925A (en) * | 2019-03-13 | 2020-09-22 | 上海晶赞融宣科技有限公司 | Behavior data processing method and device, storage medium and terminal |
| CN111694925B (en) * | 2019-03-13 | 2023-06-09 | 上海晶赞融宣科技有限公司 | Behavior data processing method and device, storage medium and terminal |
| CN113420538A (en) * | 2021-08-23 | 2021-09-21 | 深圳市明源云科技有限公司 | Numerical value format intelligent display method, equipment terminal and computer readable storage medium |
| CN113420538B (en) * | 2021-08-23 | 2021-12-14 | 深圳市明源云科技有限公司 | Numerical value format intelligent display method, equipment terminal and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102508839B (en) | 2013-09-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102402548B (en) | Method and system for controlling data query of application system | |
| CN102508839B (en) | Data processing device and data processing method | |
| CN102129425B (en) | The access method of big object set table and device in data warehouse | |
| CN106326243B (en) | Data processing method and device | |
| WO2019024496A1 (en) | Enterprise recommendation method and application server | |
| CN110209348B (en) | Data storage method and device, electronic equipment and storage medium | |
| US10963888B2 (en) | Payment complaint method, device, server and readable storage medium | |
| US8854239B2 (en) | Data processing apparatus and method | |
| CN102682108A (en) | Row and line mixed database storage method | |
| TW201830180A (en) | Storage location assignment device and method for storage location assignment | |
| CN104199977A (en) | Method for creating information search based on data in database | |
| CN102932416B (en) | A kind of intermediate data storage method of information flow task, processing method and device | |
| CN102315930A (en) | Be used for reducing the method and system of volume of transmitted data in data sync | |
| CN110502506B (en) | Data processing method, device, equipment and storage medium | |
| US10949433B2 (en) | Systems and methods for expedited large file processing | |
| CN108681866B (en) | Waybill processing method, system, device and storage medium | |
| CN111127111A (en) | Store member management method, device and equipment | |
| CN111159183A (en) | Report generation method, electronic device and computer readable storage medium | |
| CN103678415A (en) | Method and device for processing project log data | |
| CN103870511A (en) | Shared memory-based information inquiring equipment and method | |
| CN104915435A (en) | Data query method and device | |
| US20150169515A1 (en) | Data driven synthesizer | |
| CN105574027A (en) | On-line transaction processing/on-line analytical processing (OLTP/OLAP) hybrid application based multi-dimensional performance data storage method, device and system | |
| CN103325277A (en) | Parking guidance system and working process | |
| EP3486861A1 (en) | Inter-company information sharing system and inter-company information sharing method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee |
Owner name: YONYOU NETWORK TECHNOLOGY CO., LTD. Free format text: FORMER NAME: UFIDA SOFTWARE CO., LTD. |
|
| CP03 | Change of name, title or address |
Address after: 100094 Haidian District North Road, Beijing, No. 68 Patentee after: Yonyou Network Technology Co., Ltd. Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Patentee before: UFIDA Software Co., Ltd. |