CN102508825B - List data dynamic sequencing method and device - Google Patents
List data dynamic sequencing method and device Download PDFInfo
- Publication number
- CN102508825B CN102508825B CN201110341824.1A CN201110341824A CN102508825B CN 102508825 B CN102508825 B CN 102508825B CN 201110341824 A CN201110341824 A CN 201110341824A CN 102508825 B CN102508825 B CN 102508825B
- Authority
- CN
- China
- Prior art keywords
- data
- data rows
- sort
- list
- benchmark
- 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.)
- Active
Links
- 238000012163 sequencing technique Methods 0.000 title claims abstract description 25
- 230000001174 ascending effect Effects 0.000 claims abstract description 74
- 238000012546 transfer Methods 0.000 claims abstract description 53
- 238000000034 method Methods 0.000 claims abstract description 27
- 238000012545 processing Methods 0.000 abstract description 9
- 238000012423 maintenance Methods 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 6
- 238000012552 review Methods 0.000 description 5
- 230000008520 organization Effects 0.000 description 4
- 238000004458 analytical method Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000007418 data mining Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000009412 basement excavation Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- MKEKAXKNTUEPCM-UHFFFAOYSA-N collismycin C Natural products OCC1=C(SC)C(OC)=CC(C=2N=CC=CC=2)=N1 MKEKAXKNTUEPCM-UHFFFAOYSA-N 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000003745 diagnosis Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 239000004615 ingredient Substances 0.000 description 1
Images
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to the field of data processing and provides a list data dynamic sequencing method and a list data dynamic sequencing device. The method comprises the following steps of: adding a first data line and a second data line for a list, setting the first data line into the ascending sort, and setting the second data line into the descending sort; selecting the reference sequencing field in the list, and setting transfer parameters for the reference sequence field; and clicking the reference sequencing field, transferring the transfer parameters to the first data line and the second data line in the list and displaying the sequencing results of the list data according to the first data line or the second data line in accordance with the transfer parameters. The method provided by the invention has the advantages that the dynamic sequencing of the list data according to the first data line or the second data line can be realized, and the technical problem that the dynamic ascending and descending sort sequencing of the list cannot be realized in the prior art is solved. The method provided by the invention is easy to realize, the maintenance is convenient, and the data processing efficiency is improved.
Description
Technical field
The application relates to data processing field, particularly relates to a kind of list data dynamic sequencing method and apparatus.
Background technology
Business intelligence (BI, Business Intelligence), is called again business intelligence, is conventionally understood to existing data in enterprise to be converted into knowledge, helps enterprise to make the instrument of wise business business decision.Here the data talked comprise from the order of enterprise operation system, stock, transaction account, client and supplier data and from enterprise's the industry and rival's data, and from the various data in residing other external environment conditions of enterprise.And business intelligence can be auxiliary business business decision can be both operation layer, can be also the decision-making of tactics layer and strategy layer.For data are converted into knowledge, need to utilize the technology such as data warehouse, on-line analytical processing (OLAP) instrument and data mining.Business intelligence can utilize inquiry and analysis instrument, Data Mining Tools, OLAP instrument etc. to data analysis and processing, finally knowledge is presented to supvr, for gerentocratic decision process provides support.
Along with constantly popularizing of Business intelligence, now a lot of companies all start to build the business intelligence system that is applicable to own business diagnosis.Current common business intelligence system comprises the several parts of data warehouse, data pick-up, report form showing and multidimensional analysis.The processing of data is very important ingredients of business intelligence, and report form showing is the important component part of data processing.In prior art, the product that this field of report form showing is relatively commonly used has Cognos, the Business Objects of SAP company etc. of IBM Corporation.These report tools can be stored easily, data query, provide convenience for user carries out data processing.But some report tools are the dynamic ascending, descending sequence of support list not, can not allow table data carry out the sequence of ascending order or descending according to the value of this column data by clicking gauge outfit.And being carried out to dynamic order, data have great importance for data query, analysis and excavation, because these report tools are not supported dynamic order, for data processing has been brought inconvenience, reduced data-handling efficiency, a kind of therefore need list data dynamic sequencing badly method solves this technical matters.
Summary of the invention
For solving the problems of the technologies described above, the embodiment of the present application provides a kind of list data dynamic sequencing method and apparatus, can realize the dynamic order of table data, realizes simply, has improved data-handling efficiency.
Technical scheme is as follows:
The embodiment of the present application discloses a kind of list data dynamic sequencing method, and described method comprises:
Add the first data rows and the second data rows for list, described the first data are set and classify ascending order arrangement as, described the second data are set and classify descending sort as;
Select the benchmark sort field in described list, for described benchmark sort field arranges Transfer Parameters;
Click described benchmark sort field, described Transfer Parameters is passed to the first data rows and the second data rows in described list, show that according to described Transfer Parameters the data of described list are according to the result of described the first data rows or the sequence of the second data rows.
Preferably, described Transfer Parameters comprises sort type parameter and benchmark sequence field parameter.
Preferably, the content of described the first data rows is:
In the time that the value of described sort type parameter is ascending order, determine current base platoon sequence according to described benchmark sequence field parameter, the content of described the first data rows is the content of current base platoon sequence; In the time that the value of described sort type parameter is descending, the content of described the first data rows is empty;
The content of described the second data rows is:
In the time that the value of described sort type parameter is descending, determine current base platoon sequence according to described benchmark sequence field parameter, the content of described the second data rows is the content of current base platoon sequence; In the time that the value of described sort type parameter is ascending order, the content of described the second data rows is empty.
Preferably, described data of showing described list according to described Transfer Parameters according to the result of described the first data rows or the sequence of the second data rows are:
In the time that the value of described sort type parameter is ascending order, show that the data of described list are according to the result of described the first data rows sequence;
In the time that the value of described sort type parameter is descending, show that the data of described list are according to the result of described the second data rows sequence.
Preferably, described method further comprises:
For described benchmark sort field arranges ascending chain head and descending chain head, in the time that the value of described sort type parameter is ascending order, described ascending chain head is set and hides, described descending chain head shows; In the time that the value of described sort type parameter is descending, described descending chain head is set and hides, described ascending chain head shows.
Preferably, described method further comprises:
The display type of described the first data rows and described the second data rows is set to hide.
Preferably, described method further comprises:
For all fields in described list arrange Transfer Parameters.
The embodiment of the present application also discloses a kind of list data dynamic sequencing device, and described device comprises:
Data rows adding device, is used to list to add the first data rows and the second data rows, described the first data is set and classifies ascending order arrangement as, described the second data is set and classifies descending sort as;
Selected cell, for selecting the benchmark sort field of described list, for described benchmark sort field arranges Transfer Parameters;
Sequence display unit, be used for clicking described benchmark sort field, described Transfer Parameters is passed to the first data rows and the second data rows in described list, show that according to described Transfer Parameters the data of described list are according to the result of described the first data rows or the sequence of the second data rows.
Preferably, described data rows adding device comprises the first definition unit and the second definition unit, wherein,
Described the first definition unit is for defining the content of the first data rows: in the time that the value of described sort type parameter is ascending order, determine current base platoon sequence according to described benchmark sequence field parameter, the content of described the first data rows is the content of current base platoon sequence; In the time that the value of described sort type parameter is descending, the content of described the first data rows is empty;
Described the second definition unit is for defining the content of the second data rows: in the time that the value of described sort type parameter is descending, determine current base platoon sequence according to described benchmark sequence field parameter, the content of described the second data rows is the content of current base platoon sequence; In the time that the value of described sort type parameter is ascending order, the content of described the second data rows is empty.
Preferably, described device also comprises:
The first setting unit, for the ascending chain head of described benchmark sort field and the display type of descending chain head are set, in the time that the value of described sort type parameter is ascending order, arranges described ascending chain head and hides, and described descending chain head shows; In the time that the value of described sort type parameter is descending, described descending chain head is set and hides, described ascending chain head shows.
Preferably, described device also comprises:
The second setting unit, is set to hide for the display type of described the first data rows and described the second data rows.
A kind of list data dynamic sequencing method that the embodiment of the present application provides, its beneficial effect that can reach is: the method that the embodiment of the present application provides is by adding the first data rows and the second data rows for list, the first data are set and classify ascending order arrangement as, the second data are set and classify descending sort as; Selection reference sort field, for benchmark sort field arranges Transfer Parameters; Click described benchmark sort field, described Transfer Parameters is passed to the first data rows and the second data rows in described list, like this, determine that according to Transfer Parameters current is to arrange and the title of definite base platoon sequence according to ascending order or descending, like this, in the time clicking benchmark sort field, can realize the data of list and can carry out dynamic order according to the first data rows or the second data rows, solve the technical matters that prior art cannot be carried out to list dynamic lifting sequence.The method that the application provides realizes easily, easy to maintenance, has improved data-handling efficiency.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present application or technical scheme of the prior art, to the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described below, apparently, the accompanying drawing the following describes is only some embodiment that record in the application, for those of ordinary skills, do not paying under the prerequisite of creative work, can also obtain according to these accompanying drawings other accompanying drawing.
List data dynamic sequencing method the first embodiment process flow diagram that Fig. 1 provides for the application;
List data dynamic sequencing method the second embodiment process flow diagram that Fig. 2 provides for the application;
The list data dynamic sequencing device schematic diagram that Fig. 3 provides for the application.
Embodiment
The embodiment of the present application provides a kind of list data dynamic sequencing method and apparatus, can realize the dynamic order of table data, realizes simply, has improved data-handling efficiency.
In order to make those skilled in the art person understand better the technical scheme in the application, below in conjunction with the accompanying drawing in the embodiment of the present application, technical scheme in the embodiment of the present application is clearly and completely described, obviously, described embodiment is only the application's part embodiment, rather than whole embodiment.Based on the embodiment in the application, those of ordinary skills are not making the every other embodiment obtaining under creative work prerequisite, all should belong to the scope of the application's protection.
First a kind of list data dynamic sequencing method of the application is described.
Referring to Fig. 1, list data dynamic sequencing method the first embodiment process flow diagram providing for the application.
S101, adds the first data rows and the second data rows for list, described the first data is set and classifies ascending order arrangement as, described the second data is set and classifies descending sort as.
S102, selects the benchmark sort field in described list, for described benchmark sort field arranges Transfer Parameters.
S103, clicks described benchmark sort field, and described Transfer Parameters is passed to the first data rows and the second data rows in described list, shows that the data of described list are according to the result of described the first data rows or the sequence of the second data rows according to described Transfer Parameters.
Referring to Fig. 2, list dynamic order method the second embodiment process flow diagram providing for the application.
S201, the content of definition data item.
In the second embodiment providing in the application, describe as an example of list A example.Suppose that the list that need to sort is as shown in table 1:
Table 1 list A
| Time | Organization name | Wage |
| 2004 | Unit 1 | 6230.8 |
| 2006 | Unit 1 | 84067.52 |
| 2005 | Unit 1 | 86197.73 |
| 2006 | Unit 2 | 65211.67 |
| 2005 | Unit 2 | 90810.96 |
| 2004 | Unit 2 | 20145.83 |
Suppose that we will sort to classifying year, organization name, three fields of wage as, first define the content of data item.In the embodiment providing in the application, described data item comprises the first data rows and the second data rows, and described data item can also comprise sort type data item, benchmark sequence field name data item.Wherein, sort type data item is the standard that ascending order operation or descending operation are carried out in judgement.Concrete, two sort type data item can be set, called after UP and DOWN respectively, its content be respectively character string ' UP ' and ' DOWN '.Benchmark sequence field name data item is used for recording the title of base platoon's sequence, such as COL-A, COL-B, COL-C represent respectively year, organization name and wage three row fields.
Concrete, described the first data rows content-defined as follows:
When according to ascending sort, when the value of sort type parameter is ascending order, determine current base platoon sequence according to benchmark sequence field parameter, the content of described the first data rows is the content of current base platoon sequence; When according to descending sort, when the value of sort type parameter is descending, the content of described the first data rows is empty.
Concrete, the content of described the second data rows is:
When according to descending sort, when the value of sort type parameter is descending, determine current base platoon sequence according to described benchmark sequence field parameter, the content of described the second data rows is the content of current base platoon sequence; When according to ascending sort,, in the time that the value of sort type parameter is ascending order, the content of described the second data rows is empty.
Concrete, the content of the first data rows can define as shown in table 2:
The content of table 2 the first data rows
Implication defined above is: if according to ascending sort, determine current base platoon sequence by sortcolumn parameter, the content of the first data item is consistent with the content of current base platoon sequence; If according to descending sort, the content of this first data rows is empty.
Concrete, the content of the second data rows can define as shown in table 3:
The content of table 3 the second data rows
Implication defined above is: if according to descending sort, determine current base platoon sequence by sortcolumn parameter, the content of the second data rows is consistent with the content of current base platoon sequence.If according to descending sort, the content of the second data rows is empty.
S202, adds the first data rows and the second data rows for list, described the first data is set and classifies ascending order arrangement as, described the second data is set and classifies descending sort as.
Concrete, the first data rows and the second data rows are added in list.When specific implementation, click the data item tab of insertable object, choose the first data rows, added to the last of list; Choose the with data rows row, the first data are set and classify ascending order as and arrange.Same, the second data rows is added in list, it is set for descending sort.
In the time that needs are arranged according to ascending order, what play a decisive role is the data of the first data rows like this, because the content of the second data rows is empty, specifically as shown in table 4:
Table 4 list A ascending order is arranged
While in like manner needing descending sort, what play a decisive role is the data of the second data rows, because the content of the first data rows is empty.Specifically as shown in table 5:
Table 5 list A descending sort
S203, selects the benchmark sort field in described list, for described benchmark sort field arranges Transfer Parameters.
In the embodiment of the present application, benchmark sort field is that list is according to that column data of which row sequence.For example, we want list to sort according to the time, and the time field in selective listing is as benchmark sort field, for it arranges Transfer Parameters.
When specific implementation, we can use the tracing function in report tool.First review for the benchmark sort field in list arranges ascending order, choose the benchmark sort field time, for it arranges Transfer Parameters.To review called after UP, target form is form self.Click parameter arranges, and for transmitting, transmission value is set.Described Transfer Parameters comprises sort type parameter (sorttype) and benchmark sequence field parameter (sortcolumn).Method row are set to transmit data item occurrence, and the value that then benchmark sequence field parameter sortcolumn is set is that the value of data item COL-A (representing the time) is A, and the value of sort type parameter s orttype is that the value of data item UP is UP.After setting completes, the benchmark sort field time will become hyperlink pattern.Like this, benchmark sort field and the first data rows or the second data rows have just been set up incidence relation.
Below, for arranging descending, reviews the benchmark sort field in list.Choose the time, the reproduction button on click tools hurdle, and then click paste button, to review and copy portion, revise the duplicated attribute of reviewing, will review RNTO DOWN, and the transmission value of sort type parameter s orttype is set to the value " DOWN " of data item DOWN.
S204, clicks described benchmark sort field, and described Transfer Parameters is passed to the first data rows and the second data rows in described list, shows that the data of described list are according to the result of described the first data rows or the sequence of the second data rows according to described Transfer Parameters.
Concrete, show that according to described Transfer Parameters the data of described list are specially according to the result of described the first data rows or the sequence of the second data rows:
In the time that the value of described sort type parameter is ascending order, show that the data of described list are according to the result of described the first data rows sequence;
In the time that the value of described sort type parameter is descending, show that the data of described list are according to the result of described the second data rows sequence.
Specific to the embodiment of the present application, by the setting in step S203, click ascending order while reviewing (while clicking the benchmark sort field time) transmitted sortcolumn=A and these two filterconditions of sorttype=UP for form, the content that can judge the first data rows in conjunction with the definition of the first data rows and the second data rows is the content in base platoon's sequence time, and the content of the second data rows is empty.
When click descending is reviewed, for form has transmitted sortcolumn=A and these two filterconditions of sorttype=DOWN, can judge the content of the first data rows in conjunction with the definition of the first data rows and the second data rows for empty, the content of the second data rows is the content in base platoon's sequence time.
Operation form, can see that it is all hyperlink form that year column gauge outfit has 2 times, clicks the previous time, is that ascending order is arranged, descending sort while clicking a rear sequence.Concrete, data in list are that full line moves in the time of sequence, therefore in the time clicking first time, ascending order UP owing to being provided with the value of sort type parameter for it, the value of benchmark sequence field parameter is A (being the time), so just Transfer Parameters has been passed to the first data rows and the second data rows in list; Due to being set in step S202, the first data classify ascending order arrangement as, at this moment, the first data rows plays a decisive role in sequence, in the time that the first data rows is arranged according to ascending order, data full line in list moves, and has therefore realized all data in list and carry out according to the first data rows the result of dynamic order.According to the definition of the first data rows and the second data rows, the content of the first data rows is the content of base platoon's sequence, has therefore in fact realized list according to the effect of benchmark sort field dynamic order.
S205, for all fields in list arrange Transfer Parameters.
The organization name and the wage that are respectively in the same way in list arrange Transfer Parameters.
Further, the method that the embodiment of the present application provides can also comprise:
S206, for described benchmark sort field arranges ascending chain head and descending chain head, in the time that the value of described sort type parameter is ascending order, arranges described ascending chain head and hides, and described descending chain head shows; In the time that the value of described sort type parameter is descending, described descending chain head is set and hides, described ascending chain head shows.
Only see exercisable row in order to ensure user, can ascending chain head and descending chain head be set for base platoon's order field, below take the time as example.Choose the corresponding time of ascending order in list, arrange.Choose the time that in list, descending is corresponding to arrange.By above-mentioned setting, in the time that Transfer Parameters sorttype parameter value is UP, representing current is ascending order operation, and in year column, ascending order gauge outfit is invisible, represents that the descending gauge outfit of descending is visible; In the time that Transfer Parameters sorttype parameter value is DOWN, representing current is descending operation, and in year column, ascending order gauge outfit is visible, represents that the descending gauge outfit of descending is invisible.
Preferably, in the time that list acquiescence does not sort, what list gauge outfit showed is ascending order gauge outfit.
Further, the method that the application provides can also comprise:
S207, the display type of described the first data rows and described the second data rows is set to hide.
Succinct for overall interface, can the first data rows and the gauge outfit of the second data rows and the display type of content be set to hide, like this, while again moving form, can't see the first data rows and the second data rows.
In the embodiment providing in the application, by add the first data rows and the second data rows for list, for benchmark sort field arranges Transfer Parameters, in the time clicking benchmark sort field, Transfer Parameters is passed to the first data rows and second data rows of form; In the time that the value of the sort type parameter of transmitting is ascending order UP, the first data rows plays a decisive role, and displaying result is that the data in list are carried out ascending sort according to the first data rows; In the time that the value of the sort type parameter of transmitting is descending DOWN, the second data rows plays a decisive role, and displaying result is that the data in list are carried out descending sort according to the second data rows.Like this, realize the data in list and carried out dynamic order, realized simply, improved data-handling efficiency.
The embodiment of the present application also discloses a kind of list data dynamic sequencing device.
Referring to Fig. 3, it is the embodiment of the present application list data dynamic sequencing device schematic diagram.
Described device comprises:
Data rows adding device 301, is used to list to add the first data rows and the second data rows, described the first data is set and classifies ascending order arrangement as, described the second data is set and classifies descending sort as;
Selected cell 302, for selecting the benchmark sort field of described list, for described benchmark sort field arranges Transfer Parameters;
Sequence display unit 303, be used for clicking described benchmark sort field, described Transfer Parameters is passed to the first data rows and the second data rows in described list, show that according to described Transfer Parameters the data of described list are according to the result of described the first data rows or the sequence of the second data rows.
Preferably, described data rows adding device comprises the first definition unit and the second definition unit, wherein,
Described the first definition unit is for defining the content of the first data rows: in the time that the value of described sort type parameter is ascending order, determine current base platoon sequence according to described benchmark sequence field parameter, the content of described the first data rows is the content of current base platoon sequence; In the time that the value of described sort type parameter is descending, the content of described the first data rows is empty.
Described the second definition unit is for defining the content of the second data rows: in the time that the value of described sort type parameter is descending, determine current base platoon sequence according to described benchmark sequence field parameter, the content of described the second data rows is the content of current base platoon sequence; In the time that the value of described sort type parameter is ascending order, the content of described the second data rows is empty.
Concrete, described selected cell 302 specifically comprises:
The first selected cell, for selection reference sort field, for described benchmark sort field arranges ascending chain head, for ascending chain head arranges Transfer Parameters, described Transfer Parameters comprises sort type parameter and benchmark sequence field parameter, the value of sort type parameter is set to ascending order, and the sort value of field parameter of benchmark is set to the value of benchmark sort field.
The second selected cell, for selection reference sort field, for described benchmark sort field arranges descending chain head, for descending chain head arranges Transfer Parameters, described Transfer Parameters comprises sort type parameter and benchmark sequence field parameter, the value of sort type parameter is set to descending, and the sort value of field parameter of benchmark is set to the value of benchmark sort field.
Further, described device also comprises:
The first setting unit, for the ascending chain head of described benchmark sort field and the display type of descending chain head are set, in the time that the value of described sort type parameter is ascending order, arranges described ascending chain head and hides, and described descending chain head shows; In the time that the value of described sort type parameter is descending, described descending chain head is set and hides, described ascending chain head shows.
Further, described device also comprises:
The second setting unit, is set to hide for the display type of described the first data rows and described the second data rows.
The application can describe in the general context of the computer executable instructions of being carried out by computing machine, for example program module.Usually, program module comprises and carries out particular task or realize routine, program, object, assembly, data structure of particular abstract data type etc.Also can in distributed computing environment, put into practice the application, in these distributed computing environment, be executed the task by the teleprocessing equipment being connected by communication network.In distributed computing environment, program module can be arranged in the local and remote computer-readable storage medium including memory device.
The above is only the application's embodiment; it should be pointed out that for those skilled in the art, do not departing under the prerequisite of the application's principle; can also make some improvements and modifications, these improvements and modifications also should be considered as the application's protection domain.
Claims (8)
1. a list data dynamic sequencing method, is characterized in that, described method comprises:
Add the first data rows and the second data rows for list, described the first data are set and classify ascending order arrangement as, described the second data are set and classify descending sort as;
Select the benchmark sort field in described list, for described benchmark sort field arranges Transfer Parameters, think that described benchmark sort field and described the first data rows set up incidence relation or set up incidence relation for described benchmark sort field and described the second data rows; Described Transfer Parameters comprises sort type parameter and benchmark sequence field parameter;
Click described benchmark sort field, described Transfer Parameters is passed to the first data rows and the second data rows in described list, when the value of the sort type parameter comprising when described Transfer Parameters is ascending order, determine current base platoon sequence according to described benchmark sequence field parameter, the content of described the first data rows is the content of current base platoon sequence, and the content of described the second data rows is empty; When the value of the sort type parameter comprising when described Transfer Parameters is descending, determine current base platoon sequence according to described benchmark sequence field parameter, the content of described the second data rows is the content of current base platoon sequence, and the content of described the first data rows be sky;
Data full line in list is moved, show that according to described Transfer Parameters all data of described list carry out the result of dynamic order according to described the first data rows or the second data rows.
2. method according to claim 1, is characterized in that, described data of showing described list according to described Transfer Parameters according to the result of described the first data rows or the sequence of the second data rows are:
In the time that the value of described sort type parameter is ascending order, show that the data of described list are according to the result of described the first data rows sequence;
In the time that the value of described sort type parameter is descending, show that the data of described list are according to the result of described the second data rows sequence.
3. method according to claim 1, is characterized in that, described method further comprises:
For described benchmark sort field arranges ascending chain head and descending chain head, in the time that the value of described sort type parameter is ascending order, described ascending chain head is set and hides, described descending chain head shows; In the time that the value of described sort type parameter is descending, described descending chain head is set and hides, described ascending chain head shows.
4. method according to claim 1, is characterized in that, described method further comprises:
The display type of described the first data rows and described the second data rows is set to hide.
5. method according to claim 1, is characterized in that, described method further comprises:
For all fields in described list arrange Transfer Parameters.
6. a list data dynamic sequencing device, is characterized in that, described device comprises:
Data rows adding device, is used to list to add the first data rows and the second data rows, described the first data is set and classifies ascending order arrangement as, described the second data is set and classifies descending sort as;
Selected cell, for selecting the benchmark sort field of described list, for described benchmark sort field arranges Transfer Parameters, think that described benchmark sort field and described the first data rows set up incidence relation or set up incidence relation for described benchmark sort field and described the second data rows; Described Transfer Parameters comprises sort type parameter and benchmark sequence field parameter;
Sequence display unit, be used for clicking described benchmark sort field, described Transfer Parameters is passed to the first data rows and the second data rows in described list, when the value of the sort type parameter comprising when described Transfer Parameters is ascending order, determine current base platoon sequence according to described benchmark sequence field parameter, the content of described the first data rows is the content of current base platoon sequence, and the content of described the second data rows is empty; When the value of the sort type parameter comprising when described Transfer Parameters is descending, determine current base platoon sequence according to described benchmark sequence field parameter, the content of described the second data rows is the content of current base platoon sequence, and the content of described the first data rows be sky; Data full line in list is moved, show that according to described Transfer Parameters all data of described list are according to the result of described the first data rows or the sequence of the second data rows.
7. device according to claim 6, is characterized in that, described device also comprises:
The first setting unit, for the ascending chain head of described benchmark sort field and the display type of descending chain head are set, in the time that the value of described sort type parameter is ascending order, arranges described ascending chain head and hides, and described descending chain head shows; In the time that the value of described sort type parameter is descending, described descending chain head is set and hides, described ascending chain head shows.
8. device according to claim 6, is characterized in that, described device also comprises:
The second setting unit, is set to hide for the display type of described the first data rows and described the second data rows.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110341824.1A CN102508825B (en) | 2011-11-02 | 2011-11-02 | List data dynamic sequencing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110341824.1A CN102508825B (en) | 2011-11-02 | 2011-11-02 | List data dynamic sequencing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102508825A CN102508825A (en) | 2012-06-20 |
| CN102508825B true CN102508825B (en) | 2014-05-28 |
Family
ID=46220916
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110341824.1A Active CN102508825B (en) | 2011-11-02 | 2011-11-02 | List data dynamic sequencing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102508825B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104504132A (en) * | 2014-12-31 | 2015-04-08 | 天津南大通用数据技术股份有限公司 | Custom sorting achieving method in data analysis query |
| CN113010583A (en) * | 2021-03-02 | 2021-06-22 | 金蝶蝶金云计算有限公司 | Sorting method and device based on report, computer equipment and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102045339A (en) * | 2010-10-14 | 2011-05-04 | 深圳市五巨科技有限公司 | Method, device and system for personalized sorting of fields |
| CN102043823A (en) * | 2010-09-27 | 2011-05-04 | 深圳市五巨科技有限公司 | Method and device for flexibly selecting and gathering fields in dynamic pages |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4563558B2 (en) * | 2000-07-31 | 2010-10-13 | 株式会社ターボデータラボラトリー | Data compiling method and storage medium storing compiling method |
| US8850327B2 (en) * | 2003-04-30 | 2014-09-30 | Lenovo (Singapore) Pte Ltd. | Method and apparatus for dynamic sorting and displaying of listing data composition and automating the activation event |
-
2011
- 2011-11-02 CN CN201110341824.1A patent/CN102508825B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102043823A (en) * | 2010-09-27 | 2011-05-04 | 深圳市五巨科技有限公司 | Method and device for flexibly selecting and gathering fields in dynamic pages |
| CN102045339A (en) * | 2010-10-14 | 2011-05-04 | 深圳市五巨科技有限公司 | Method, device and system for personalized sorting of fields |
Non-Patent Citations (2)
| Title |
|---|
| Excel2000在医学统计中的若干应用;杨碰狮;《海峡预防医学杂志》;20030228;第9卷(第1期);第72-73页 * |
| 杨碰狮.Excel2000在医学统计中的若干应用.《海峡预防医学杂志》.2003,第9卷(第1期),第72-73页. |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102508825A (en) | 2012-06-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103984624A (en) | Automatic testing method and system for webpage | |
| CN102446311A (en) | Business intelligence technology for process driving | |
| CN102253936A (en) | Method for recording access of user to merchandise information, search method and server | |
| US20030018634A1 (en) | Value-chained queries in analytic applications | |
| US7685196B2 (en) | Methods and systems for task-based search model | |
| US9785910B2 (en) | Virtual product hierarchies | |
| CN103699549B (en) | The renewal of a kind of graphic code storehouse, querying method and relevant apparatus | |
| CN102915301B (en) | A kind of mark row table generating method and electronic equipment | |
| CN105046414A (en) | Business tracing method and business tracing device applied to ERP systems | |
| CN102508825B (en) | List data dynamic sequencing method and device | |
| CN104657127A (en) | System and method for automatically embedding operation collection element | |
| CN102402553B (en) | Method and device for analyzing operation quality of promoted account | |
| Slowinski et al. | Dealing with shortages of critical materials | |
| CN103425732A (en) | Electronic invoice data processing method | |
| CN103123647A (en) | Method and device for substance search | |
| CN101241430A (en) | Management software user interface design method | |
| US20140258210A1 (en) | Business intelligence reports with navigable reference indicators | |
| Jain et al. | Establishing State of the Art Unified Technical Data Center to Harness the Power of Legacy Data for Future Opportunities-An E&P Success Story in Sharjah, UAE | |
| AU2012392164B2 (en) | Method and system of knowledge transfer between users of a software application | |
| Asif et al. | Business intelligence solution for food industry | |
| CN106021624A (en) | ETL (extract-transform-load) model generation method and device | |
| CN102479242A (en) | System and method for displaying query result by relational graph | |
| CN110399337A (en) | File automating method of servicing and system based on data-driven | |
| Doherty et al. | The role of enhanced information accessibility in realizing the benefits from data warehousing investments | |
| CN115221849B (en) | Report filling method, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| ASS | Succession or assignment of patent right |
Owner name: BEIJING ZHONGDIAN PUHUA INFORMATION TECHNOLOGY CO. Effective date: 20120803 Owner name: STATE ELECTRIC NET CROP. Free format text: FORMER OWNER: BEIJING ZHONGDIAN PUHUA INFORMATION TECHNOLOGY CO., LTD. Effective date: 20120803 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| COR | Change of bibliographic data |
Free format text: CORRECT: ADDRESS; FROM: 100192 HAIDIAN, BEIJING TO: 100031 XICHENG, BEIJING |
|
| TA01 | Transfer of patent application right |
Effective date of registration: 20120803 Address after: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Applicant after: State Grid Corporation of China Co-applicant after: BEIJING CHINA POWER INFORMATION TECHNOLOGY Co.,Ltd. Address before: 100192 Beijing city Haidian District Qinghe small Camp Road No. 15 Applicant before: BEIJING CHINA POWER INFORMATION TECHNOLOGY Co.,Ltd. |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CP03 | Change of name, title or address | ||
| CP03 | Change of name, title or address |
Address after: 100033 West Chang'an Avenue, Beijing, No. 86, No. Co-patentee after: BEIJING CHINA POWER INFORMATION TECHNOLOGY Co.,Ltd. Patentee after: STATE GRID CORPORATION OF CHINA Address before: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Co-patentee before: BEIJING CHINA POWER INFORMATION TECHNOLOGY Co.,Ltd. Patentee before: State Grid Corporation of China |
|
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20190724 Address after: 100085 Building 32-3-4108-4109, Pioneer Road, Haidian District, Beijing Co-patentee after: STATE GRID CORPORATION OF CHINA Patentee after: BEIJING GUODIANTONG NETWORK TECHNOLOGY Co.,Ltd. Address before: 100033 West Chang'an Avenue, Beijing, No. 86, No. Co-patentee before: BEIJING CHINA POWER INFORMATION TECHNOLOGY Co.,Ltd. Patentee before: State Grid Corporation of China |