起初一直把焦点放在EntityDataSource的排序默认值上,但始终搞不定,
今天又花了不少时间Google和研究,终于通过设置RADGrid的默认排序,
把此问题解决了
1
<
rad:RadGrid
ID
="grid"
runat
="server"
AllowPaging
="True"
AllowSorting
="true"
GridLines
="None"
2 EnableAJAX ="true" DataSourceID ="source" AutoGenerateColumns ="False" GroupingEnabled ="False" >
3 < ClientSettings >
4 < Selecting AllowRowSelect ="True" />
5 </ ClientSettings >
6 < MasterTableView DataKeyNames ="FId" DataSourceID ="source" AllowNaturalSort ="False" >
7 < ExpandCollapseColumn Visible ="False" >
8 < HeaderStyle Width ="19px" />
9 </ ExpandCollapseColumn >
10 < RowIndicatorColumn Visible ="False" >
11 < HeaderStyle Width ="20px" />
12 </ RowIndicatorColumn >
13 < Columns >
14 < rad:GridBoundColumn DataField ="FNo" HeaderText ="发票号" SortExpression ="F_No" UniqueName ="FNo" >
15 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
16 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
17 </ rad:GridBoundColumn >
18 < rad:GridBoundColumn DataField ="FBlno" SortExpression ="F_Blno" HeaderText ="提(运)单号"
19 UniqueName ="FBlno" >
20 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
21 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
22 </ rad:GridBoundColumn >
23 < rad:GridBoundColumn DataField ="AttPayerName" HeaderText ="付款单位" AllowSorting ="False"
24 UniqueName ="AttPayerName" >
25 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
26 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
27 </ rad:GridBoundColumn >
28 < rad:GridBoundColumn DataField ="FVessel" HeaderText ="船名/航次/航班/车次" SortExpression ="F_Vessel"
29 UniqueName ="FVessel" >
30 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
31 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
32 </ rad:GridBoundColumn >
33 < rad:GridBoundColumn DataField ="FDateIssued" DataFormatString ="{0:yyyy-MM-dd}" HeaderText ="开票日期"
34 SortExpression ="F_DateIssued" UniqueName ="FDateIssued" >
35 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
36 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
37 </ rad:GridBoundColumn >
38 < rad:GridBoundColumn DataField ="FDateSailed" DataFormatString ="{0:yyyy-MM-dd}" HeaderText ="开航日期"
39 SortExpression ="F_DateSailed" UniqueName ="FDateSailed" >
40 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
41 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
42 </ rad:GridBoundColumn >
43 < rad:GridBoundColumn HeaderText ="制单" DataField ="AttIssuedName" AllowSorting ="False"
44 UniqueName ="AttIssuedName" >
45 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
46 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
47 </ rad:GridBoundColumn >
48 < rad:GridBoundColumn DataField ="AttFCheckedName" HeaderText ="复核" AllowSorting ="False"
49 UniqueName ="AttFCheckedName" >
50 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
51 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
52 </ rad:GridBoundColumn >
53 </ Columns >
54 < SortExpressions >
55 < rad:GridSortExpression FieldName ="F_No" SortOrder ="Descending" />
56 </ SortExpressions >
57 </ MasterTableView >
58 </ rad:RadGrid >
59 < data:FmInvoicesDataSource ID ="source" runat ="server" EnablePaging ="false" EnableSorting ="False"
60 EnableTransaction ="False" SelectMethod ="GetPaged" EnableDeepLoad ="true" >
61 < DeepLoadProperties Method ="IncludeChildren" Recursive ="false" >
62 < Types >
63 < data:FmInvoicesProperty Name ="HrmUsers" />
64 < data:FmInvoicesProperty Name ="CrmCustomers" />
65 < data:FmInvoicesProperty Name ="TypeFmInvoiceStatusTypes" />
66 </ Types >
67 </ DeepLoadProperties >
68 < Parameters >
69 < asp:Parameter Name ="WhereClause" />
70 < data:CustomParameter Name ="OrderBy" ConvertEmptyStringToNull ="true" />
71 < asp:ControlParameter Name ="PageIndex" ControlID ="grid" PropertyName ="CurrentPageIndex"
72 Type ="Int32" />
73 < asp:ControlParameter Name ="PageSize" ControlID ="grid" PropertyName ="PageSize" Type ="Int32" />
74 < asp:Parameter Name ="RecordCount" Direction ="Output" Type ="Int32" />
75 </ Parameters >
76 </ data:FmInvoicesDataSource >
2 EnableAJAX ="true" DataSourceID ="source" AutoGenerateColumns ="False" GroupingEnabled ="False" >
3 < ClientSettings >
4 < Selecting AllowRowSelect ="True" />
5 </ ClientSettings >
6 < MasterTableView DataKeyNames ="FId" DataSourceID ="source" AllowNaturalSort ="False" >
7 < ExpandCollapseColumn Visible ="False" >
8 < HeaderStyle Width ="19px" />
9 </ ExpandCollapseColumn >
10 < RowIndicatorColumn Visible ="False" >
11 < HeaderStyle Width ="20px" />
12 </ RowIndicatorColumn >
13 < Columns >
14 < rad:GridBoundColumn DataField ="FNo" HeaderText ="发票号" SortExpression ="F_No" UniqueName ="FNo" >
15 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
16 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
17 </ rad:GridBoundColumn >
18 < rad:GridBoundColumn DataField ="FBlno" SortExpression ="F_Blno" HeaderText ="提(运)单号"
19 UniqueName ="FBlno" >
20 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
21 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
22 </ rad:GridBoundColumn >
23 < rad:GridBoundColumn DataField ="AttPayerName" HeaderText ="付款单位" AllowSorting ="False"
24 UniqueName ="AttPayerName" >
25 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
26 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
27 </ rad:GridBoundColumn >
28 < rad:GridBoundColumn DataField ="FVessel" HeaderText ="船名/航次/航班/车次" SortExpression ="F_Vessel"
29 UniqueName ="FVessel" >
30 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
31 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
32 </ rad:GridBoundColumn >
33 < rad:GridBoundColumn DataField ="FDateIssued" DataFormatString ="{0:yyyy-MM-dd}" HeaderText ="开票日期"
34 SortExpression ="F_DateIssued" UniqueName ="FDateIssued" >
35 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
36 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
37 </ rad:GridBoundColumn >
38 < rad:GridBoundColumn DataField ="FDateSailed" DataFormatString ="{0:yyyy-MM-dd}" HeaderText ="开航日期"
39 SortExpression ="F_DateSailed" UniqueName ="FDateSailed" >
40 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
41 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
42 </ rad:GridBoundColumn >
43 < rad:GridBoundColumn HeaderText ="制单" DataField ="AttIssuedName" AllowSorting ="False"
44 UniqueName ="AttIssuedName" >
45 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
46 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
47 </ rad:GridBoundColumn >
48 < rad:GridBoundColumn DataField ="AttFCheckedName" HeaderText ="复核" AllowSorting ="False"
49 UniqueName ="AttFCheckedName" >
50 < ItemStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
51 < HeaderStyle HorizontalAlign ="Center" VerticalAlign ="Middle" />
52 </ rad:GridBoundColumn >
53 </ Columns >
54 < SortExpressions >
55 < rad:GridSortExpression FieldName ="F_No" SortOrder ="Descending" />
56 </ SortExpressions >
57 </ MasterTableView >
58 </ rad:RadGrid >
59 < data:FmInvoicesDataSource ID ="source" runat ="server" EnablePaging ="false" EnableSorting ="False"
60 EnableTransaction ="False" SelectMethod ="GetPaged" EnableDeepLoad ="true" >
61 < DeepLoadProperties Method ="IncludeChildren" Recursive ="false" >
62 < Types >
63 < data:FmInvoicesProperty Name ="HrmUsers" />
64 < data:FmInvoicesProperty Name ="CrmCustomers" />
65 < data:FmInvoicesProperty Name ="TypeFmInvoiceStatusTypes" />
66 </ Types >
67 </ DeepLoadProperties >
68 < Parameters >
69 < asp:Parameter Name ="WhereClause" />
70 < data:CustomParameter Name ="OrderBy" ConvertEmptyStringToNull ="true" />
71 < asp:ControlParameter Name ="PageIndex" ControlID ="grid" PropertyName ="CurrentPageIndex"
72 Type ="Int32" />
73 < asp:ControlParameter Name ="PageSize" ControlID ="grid" PropertyName ="PageSize" Type ="Int32" />
74 < asp:Parameter Name ="RecordCount" Direction ="Output" Type ="Int32" />
75 </ Parameters >
76 </ data:FmInvoicesDataSource >
关键部分
<SortExpressions>
<rad:GridSortExpression FieldName="F_No" SortOrder="Descending" />
</SortExpressions>
设定RADGrid的默认排序
<data:CustomParameter Name="OrderBy" ConvertEmptyStringToNull="true" />
可有可无,但不能在CustomParameter 的DefaultValue或Value 设值,要不然会无法自动排序