批改ExtJs store默许的排序举动

ExtJs2.0的时分，普普通通的Ext.data.SimpleStore的对数据的排序举动是界别大小写的。 例如如同下几个name,



一,Ashely,
二,amonda
三,Cary



透过ExtJs SimpleStore排序后，出现的顺序如次：



一,Ashely,
二,Cary
三,amonda



由于ExtJs内部是依照ASCII排序的，而在ASCII中，大写字母总在小写字母先头。

急需批改举动，使得排序不分区大小写。底下是我的兑现，不通用，但是在这个事例是跑的通。

例证是ExtJs官方的的array_grid的例证,http://www.extjs.com/deploy/dev/examples/grid/array-grid.html

底下是我批改过的代码，array-grid.js

Java代码
1./*
2. * Ext JS Library 2.2.1
3. * Copyright(c) 2006-2009, Ext JS, LLC.
4. * licensing@extjs.com
5. *
6. * http://extjs.com/license
7. */
8.
九.Ext.onReady(function(){
10.
11. // NOTE: This is an example showing simple state management. During development,
12. // it is generally best to disable state management as dynamically-generated ids
13. // can change across page loads, leading to unpredictable results. The developer
14. // should ensure that stable state ids are set for stateful components in real apps.
15. Ext.state.Manager.setProvider(new Ext.state.CookieProvider());
16.
17. //覆盖的排序在这里起作用。
18. Ext.data.CustomSortStore = Ext.extend(Ext.data.SimpleStore,{
19. sortData : function(f, direction){
20. direction = direction || 'ASC';
21. var st = this.fields.get(f).sortType;
22. var fn = function(r一, r二 , store){
23. var v一 = st(r一.data[f]), v二 = st(r二.data[f]);
24. if(typeof(v一) == 'string' && typeof(v二) == 'string'){
25. //去掉大小写限制
26. var al = v一.toLowerCase(), bl= v二.toLowerCase();
27. return al > bl ? 一 : (al < bl ? -一 : 零);
28. }else{
29. return v一 > v二 ? 一 : (v一 < v二 ? -一 : 零);
30. }
31. };
32.
33. this.data.sort(direction, fn);
34. if(this.snapshot && this.snapshot != this.data){
35. this.snapshot.sort(direction, fn);
36. }
37. }
38. });
39.
40. var myData = [
41. ['三m Co',71.72,0.02,0.03,'9/1 12:00am'],
42. ['citigroup, Inc.',49.37,0.02,0.04,'9/1 12:00am'],
43. ['Altria Group Inc',83.81,0.28,0.34,'9/1 12:00am'],
44. ['American Express Company',52.55,0.01,0.02,'9/1 12:00am'],
45. ['American International Group, Inc.',64.13,0.31,0.49,'9/1 12:00am'],
46. ['AT&T Inc.',31.61,-0.48,-1.54,'9/1 12:00am'],
47. ['Boeing Co.',75.43,0.53,0.71,'9/1 12:00am'],
48. ['Caterpillar Inc.',67.27,0.92,1.39,'9/1 12:00am'],
49. ['E.I. du Pont de Nemours and Company',40.48,0.51,1.28,'9/1 12:00am'],
50. ['alcoa Inc',29.01,0.42,1.47,'9/1 12:00am'],
51. ['Exxon Mobil Corp',68.1,-0.43,-0.64,'9/1 12:00am'],
52. ['General Electric Company',34.14,-0.08,-0.23,'9/1 12:00am'],
53. ['General Motors Corporation',30.27,1.09,3.74,'9/1 12:00am'],
54. ['Hewlett-Packard Co.',36.53,-0.03,-0.08,'9/1 12:00am'],
55. ['Honeywell Intl Inc',38.77,0.05,0.13,'9/1 12:00am'],
56. ['Intel Corporation',19.88,0.31,1.58,'9/1 12:00am'],
57. ['International Business Machines',81.41,0.44,0.54,'9/1 12:00am'],
58. ['Johnson & Johnson',64.72,0.06,0.09,'9/1 12:00am'],
59. ['JP Morgan & Chase & Co',45.73,0.07,0.15,'9/1 12:00am'],
60. ['mcDonald/'s Corporation',36.76,0.86,2.40,'9/1 12:00am'],
61. ['Merck & Co., Inc.',40.96,0.41,1.01,'9/1 12:00am'],
62. ['Microsoft Corporation',25.84,0.14,0.54,'9/1 12:00am'],
63. ['Pfizer Inc',27.96,0.4,1.45,'9/1 12:00am'],
64. ['The Coca-Cola Company',45.07,0.26,0.58,'9/1 12:00am'],
65. ['The Home Depot, Inc.',34.64,0.35,1.02,'9/1 12:00am'],
66. ['The Procter & Gamble Company',61.91,0.01,0.02,'9/1 12:00am'],
67. ['United Technologies Corporation',63.26,0.55,0.88,'9/1 12:00am'],
68. ['Verizon Communications',35.57,0.39,1.11,'9/1 12:00am'],
69. ['Wal-Mart Stores, Inc.',45.45,0.73,1.63,'9/1 12:00am']
70. ];
71.
72. // example of custom renderer function
73. function change(val){
74. if(val > 零){
75. return '' + val + '';
76. }else if(val < 零){
77. return '' + val + '';
78. }
79. return val;
80. }
81.
82. // example of custom renderer function
83. function pctChange(val){
84. if(val > 零){
85. return '' + val + '%';
86. }else if(val < 零){
87. return '' + val + '%';
88. }
89. return val;
90. }
91.
92. // create the data store
93. // 这边应用我们自定义的Store
94. var store = new Ext.data.CustomSortStore({
95. fields: [
96. {name: 'company'},
97. {name: 'price', type: 'float'},
98. {name: 'change', type: 'float'},
99. {name: 'pctChange', type: 'float'},
100. {name: 'lastChange', type: 'date', dateFormat: 'n/j h:ia'}
101. ]
102. });
103.
104. store.loadData(myData);
105.
106. // create the Grid
107. var grid = new Ext.grid.GridPanel({
108. store: store,
109. columns: [
110. {id:'company',header: "Company", width: 160, sortable: true, dataIndex: 'company'},
111. {header: "Price", width: 75, sortable: true, renderer: 'usMoney', dataIndex: 'price'},
112. {header: "Change", width: 75, sortable: true, renderer: change, dataIndex: 'change'},
113. {header: "% Change", width: 75, sortable: true, renderer: pctChange, dataIndex: 'pctChange'},
114. {header: "Last Updated", width: 85, sortable: true, renderer: Ext.util.Format.dateRenderer('m/d/Y'), dataIndex: 'lastChange'}
115. ],
116. stripeRows: true,
117. autoExpandColumn: 'company',
118. height:350,
119. width:600,
120. title:'Array Grid'
121. });
122.
123. grid.render('grid-example');
124.});
/*
* Ext JS Library 2.2.1
* Copyright(c) 2006-2009, Ext JS, LLC.
* licensing@extjs.com
*
* http://extjs.com/license
*/

Ext.onReady(function(){

// NOTE: This is an example showing simple state management. During development,
// it is generally best to disable state management as dynamically-generated ids
// can change across page loads, leading to unpredictable results. The developer
// should ensure that stable state ids are set for stateful components in real apps.
Ext.state.Manager.setProvider(new Ext.state.CookieProvider());

//覆盖的排序在这里起作用。
Ext.data.CustomSortStore = Ext.extend(Ext.data.SimpleStore,{
sortData : function(f, direction){
direction = direction || 'ASC';
var st = this.fields.get(f).sortType;
var fn = function(r一, r二 , store){
var v一 = st(r一.data[f]), v二 = st(r二.data[f]);
if(typeof(v一) == 'string' && typeof(v二) == 'string'){
//去掉大小写限制
var al = v一.toLowerCase(), bl= v二.toLowerCase();
return al > bl ? 一 : (al < bl ? -一 : 零);
}else{
return v一 > v二 ? 一 : (v一 < v二 ? -一 : 零);
}
};

this.data.sort(direction, fn);
if(this.snapshot && this.snapshot != this.data){
this.snapshot.sort(direction, fn);
}
}
});

var myData = [
['三m Co',71.72,0.02,0.03,'9/1 12:00am'],
['citigroup, Inc.',49.37,0.02,0.04,'9/1 12:00am'],
['Altria Group Inc',83.81,0.28,0.34,'9/1 12:00am'],
['American Express Company',52.55,0.01,0.02,'9/1 12:00am'],
['American International Group, Inc.',64.13,0.31,0.49,'9/1 12:00am'],
['AT&T Inc.',31.61,-0.48,-1.54,'9/1 12:00am'],
['Boeing Co.',75.43,0.53,0.71,'9/1 12:00am'],
['Caterpillar Inc.',67.27,0.92,1.39,'9/1 12:00am'],
['E.I. du Pont de Nemours and Company',40.48,0.51,1.28,'9/1 12:00am'],
['alcoa Inc',29.01,0.42,1.47,'9/1 12:00am'],
['Exxon Mobil Corp',68.1,-0.43,-0.64,'9/1 12:00am'],
['General Electric Company',34.14,-0.08,-0.23,'9/1 12:00am'],
['General Motors Corporation',30.27,1.09,3.74,'9/1 12:00am'],
['Hewlett-Packard Co.',36.53,-0.03,-0.08,'9/1 12:00am'],
['Honeywell Intl Inc',38.77,0.05,0.13,'9/1 12:00am'],
['Intel Corporation',19.88,0.31,1.58,'9/1 12:00am'],
['International Business Machines',81.41,0.44,0.54,'9/1 12:00am'],
['Johnson & Johnson',64.72,0.06,0.09,'9/1 12:00am'],
['JP Morgan & Chase & Co',45.73,0.07,0.15,'9/1 12:00am'],
['mcDonald/'s Corporation',36.76,0.86,2.40,'9/1 12:00am'],
['Merck & Co., Inc.',40.96,0.41,1.01,'9/1 12:00am'],
['Microsoft Corporation',25.84,0.14,0.54,'9/1 12:00am'],
['Pfizer Inc',27.96,0.4,1.45,'9/1 12:00am'],
['The Coca-Cola Company',45.07,0.26,0.58,'9/1 12:00am'],
['The Home Depot, Inc.',34.64,0.35,1.02,'9/1 12:00am'],
['The Procter & Gamble Company',61.91,0.01,0.02,'9/1 12:00am'],
['United Technologies Corporation',63.26,0.55,0.88,'9/1 12:00am'],
['Verizon Communications',35.57,0.39,1.11,'9/1 12:00am'],
['Wal-Mart Stores, Inc.',45.45,0.73,1.63,'9/1 12:00am']
];

// example of custom renderer function
function change(val){
if(val > 零){
return '' + val + '';
}else if(val < 零){
return '' + val + '';
}
return val;
}

// example of custom renderer function
function pctChange(val){
if(val > 零){
return '' + val + '%';
}else if(val < 零){
return '' + val + '%';
}
return val;
}

// create the data store
// 这边施用我们自定义的Store
var store = new Ext.data.CustomSortStore({
fields: [
{name: 'company'},
{name: 'price', type: 'float'},
{name: 'change', type: 'float'},
{name: 'pctChange', type: 'float'},
{name: 'lastChange', type: 'date', dateFormat: 'n/j h:ia'}
]
});

store.loadData(myData);

// create the Grid
var grid = new Ext.grid.GridPanel({
store: store,
columns: [
{id:'company',header: "Company", width: 160, sortable: true, dataIndex: 'company'},
{header: "Price", width: 75, sortable: true, renderer: 'usMoney', dataIndex: 'price'},
{header: "Change", width: 75, sortable: true, renderer: change, dataIndex: 'change'},
{header: "% Change", width: 75, sortable: true, renderer: pctChange, dataIndex: 'pctChange'},
{header: "Last Updated", width: 85, sortable: true, renderer: Ext.util.Format.dateRenderer('m/d/Y'), dataIndex: 'lastChange'}
],
stripeRows: true,
autoExpandColumn: 'company',
height:350,
width:600,
title:'Array Grid'
});

grid.render('grid-example');
});


排序结果：

----------------
这边的办法可以兑现批改排序举动,但是却不通用。我想要的是一种可以覆盖Ext.data.Store的举动的形式，可以便利在new instance的时分流入sort function.我有试着这么去写：


Java代码
1.//省略其余
2. Ext.apply(Ext.data.Store,{
3. sortFn : undefined,
4. sortData : function(f, direction){
5. direction = direction || 'ASC';
6. var st = this.fields.get(f).sortType;
7. var fn = function(r一, r二 , store){
8. var v一 = st(r一.data[f]), v二 = st(r二.data[f]);
9. if(this.sortFn && typeof(this.sortFn) == 'function'){
10. return this.sortFn(v一,v二);
11. }else{
12. return v一 > v二 ? 一 : (v一 < v二 ? -一 : 零);
13. }
14. };
15.
16. this.data.sort(direction, fn);
17. if(this.snapshot && this.snapshot != this.data){
18. this.snapshot.sort(direction, fn);
19. }
20. }
21. });
22.
23. // 省略其余
24. // 结构store的时分传到排序函数：
25. var store = new Ext.data.CustomSortStore({
26. fields: [
27. {name: 'company'},
28. {name: 'price', type: 'float'},
29. {name: 'change', type: 'float'},
30. {name: 'pctChange', type: 'float'},
31. {name: 'lastChange', type: 'date', dateFormat: 'n/j h:ia'}
32. ],
33. sortFn : function(v一,v二){
34. if(typeof(v一) == 'string' && typeof(v二) == 'string'){
35. var v一l = v一.toLowerCase(),v二l = v二.toLowerCase();
36. return return v一l > v二l ? 一 : (v一l < v二l ? -一 : 零);
37. }else{
38. return v一 > v二 ? 一 : (v一 < v二 ? -一 : 零);
39. }
40. }
41. });
//省略其余
Ext.apply(Ext.data.Store,{
sortFn : undefined,
sortData : function(f, direction){
direction = direction || 'ASC';
var st = this.fields.get(f).sortType;
var fn = function(r一, r二 , store){
var v一 = st(r一.data[f]), v二 = st(r二.data[f]);
if(this.sortFn && typeof(this.sortFn) == 'function'){
return this.sortFn(v一,v二);
}else{
return v一 > v二 ? 一 : (v一 < v二 ? -一 : 零);
}
};

this.data.sort(direction, fn);
if(this.snapshot && this.snapshot != this.data){
this.snapshot.sort(direction, fn);
}
}
});

// 省略其余
// 结构store的时分传到排序函数：
var store = new Ext.data.CustomSortStore({
fields: [
{name: 'company'},
{name: 'price', type: 'float'},
{name: 'change', type: 'float'},
{name: 'pctChange', type: 'float'},
{name: 'lastChange', type: 'date', dateFormat: 'n/j h:ia'}
],
sortFn : function(v一,v二){
if(typeof(v一) == 'string' && typeof(v二) == 'string'){
var v一l = v一.toLowerCase(),v二l = v二.toLowerCase();
return return v一l > v二l ? 一 : (v一l < v二l ? -一 : 零);
}else{
return v一 > v二 ? 一 : (v一 < v二 ? -一 : 零);
}
}
});



但是这么做不起任何功用，现实排序的时分走的仍是Ext.data.Store的默许的sortData步骤，并不能覆盖。

我想问问，怎么着才华兑现我想的那种成效？
本文来源：
我的异常网
Java Exception
Dotnet Exception
Oracle Exception

• 1170 - the underlying connection is closed
• 1171 - OleDbDataAdapter导入excel时出现异常
• 1172 - PLS-00306
• 1174 - The Network Adapter could not establish the connection
• 1175 - java中异常处理的问题
• 1176 - com.mysql.jdbc.Connection.clearWarnings
• 1177 - 如何判断日期格式是否正确
• 1178 - Access database Error:列名无效
• 1179 - ORA-00900:无效SQL语句
• 1180 - ORA-14151: 无效的表分区方法
• 1181 - 表或视图不存在
• 1182 - varchar2长度大于4000个字符出错
• 1183 - ORACLE-01031:insufficient privileges
• 1184 - ORA-00900: 无效 SQL 语句
• 1185 - Error 100: ORA-01403: 未找到数据
• 1186 - Exception caught while loading book.xml
• 1187 - ORA-06502: PL SQL: 数字或值错误 : 字符串缓冲区太小
• 1188 - 类型初始值设定项引发异常
• 1189 - Connection to Database 1 error