如何实现点击Grid控件的列标头,然后数据按此列进行升序或降序排序?

如:表有如下字段:

姓名 数学 语文 英语

如何实现点哪一列,数据表就按哪列升序或降序排列
---------------------------------------------------------------

方法一:

*在表单中加入一新方法,取名为MSORT
*(新建的方法或属性将出现在属性窗口的最底部)。
*然后在此方法中写入以下代码:

LPARAMETERS xfield,xsort,xcol,xgrid,xtable &&..字段名,升降序,第几列,表格名,表名
IF PARAMETERS()<5
RETURN .F.
ENDIF
SET INDEX TO
LOCAL TEM1
IF xsort='△'
SELECT * FROM &xtable ORDER BY &xfield DESC INTO CURSOR TEM1
ELSE
SELECT * FROM &xtable ORDER BY &xfield ASC INTO CURSOR TEM1
ENDIF
IF _TALLY>0
SELECT (xtable)
ZAP
APPEND FROM DBF('TEM1')
ELSE
RETURN
ENDIF
vst='ThisForm.'+xgrid
IF !EMPTY(vst)
FOR i=1 TO &vst..COLUMNCOUNT &&
..先去掉▽(△)再加△(▽)
st0=vst+'.COLUMN'+ALLT(STR(i))+'.HEADER1.CAPTION'
IF AT(RIGHT(ALLT(&st0),2),"▽△")!=0
&st0.=LEFT(ALLT(&st0),LEN(ALLT(&st0))-2)
ENDIF
IF i=xcol &&**..第几例
IF AT(xsort,"▽△")=0.OR.xsort="▽"
&st0.=&st0+"△"
ELSE
&st0.=&st0+"▽"
ENDIF
ENDIF
ENDFOR
ENDIF
SELECT (xtable)
THISFORM.REFRESH
SELECT (xtable)
GO TOP
THISFORM.REFRESH

*然后把Grid控件的ColumnCount修改为你的列数,在GRID的每列的HEADER1的CLICK(单击)或者其它(如双击)中写入﹕

THISFORM.MSORT(THIS.PARENT.CONTROLSOURCE,RIGHT(ALLT(THIS.CAPTION),2),VAL(SUBSTR(THIS.PARENT.NAME,7,2)),this.Parent.Parent.Name,this.Parent.Parent.RecordSource) &&**..字段名,升降序,第几列,表名,表名

---------------------------------------------------------------

方法二:

*例如:前三列分别是f1,f2,f3
*把Grid控件的ColumnCount修改为3或你的列数
*表单的LOAD事件:

PUBLIC nF1,nF2,nF3
nF1=0
nF2=0
nF3=0
USE tmp
INDE ON f1 TAG f1
INDE ON f2 TAG f2
INDE ON f3 TAG f3
SET ORDE TO

*GRID第一列标头的CLICK事件:
IF nF1=0
SET ORDE TO f1 ASCENDING &&升序
nF1=1
ELSE
SET ORDE TO f1 DESCENDING &&降序
nF1=0
ENDIF
THISFORM.grid1.REFRESH

*GRID第二列标头的CLICK事件:
IF nF2=0
SET ORDE TO f2 ASCENDING &&升序
nF2=1
ELSE
SET ORDE TO f2 DESCENDING &&降序
nF2=0
ENDIF
THISFORM.grid1.REFRESH

*GRID第三列标头的CLICK事件:
IF nF3=0
SET ORDE TO f3 ASCENDING &&升序
nF3=1
ELSE
SET ORDE TO f3 DESCENDING &&降序
nF3=0
ENDIF
THISFORM.grid1.REFRESH

*你还可以设置一个按钮用于取消排序:
SET ORDE TO
THISFORM.grid1.REFRESH

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus