NetTiers学习笔记09---RADGrid + EntityDataSource设置默认排序, 及表格自动排序,分页的方法

前段时间虽然解决了排序和分页的问题,但始终没有解决默认排序的问题,
起初一直把焦点放在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>

关键部分
   <SortExpressions>
        <rad:GridSortExpression FieldName="F_No" SortOrder="Descending" />
   </SortExpressions>
设定RADGrid的默认排序

   <data:CustomParameter Name="OrderBy" ConvertEmptyStringToNull="true" />
可有可无,但不能在CustomParameter 的DefaultValue或Value 设值,要不然会无法自动排序

posted on 2007-07-25 14:35 Ψιζσεα. 阅读(1241) 评论(8) 编辑收藏网摘所属分类: 技术、.NetTiers

#1楼  2007-07-26 18:11 David [未注册用户]

: ) 回复引用

#2楼  2007-07-29 16:18 icezs [未注册用户]

版主，这样做要怎么做。
DataRepository.employees.getall之类的，有没有基类，在那设置一个表名常量，继承类中初始化常为一个表名，然后在所有的数据操作里判断权限。
回复引用

#3楼  2007-07-29 16:34 icezs [未注册用户]

这样子改那个模板文件？回复引用

#4楼 [楼主] 2007-07-29 17:55 iCaca

权限的话可以重写方法
在service层中封装吧

修改xxxService.cs文件他继承自xxxServiceBase.generated.cs
xxxServiceBase.generated.cs 这是自动生成的. 不需要修改

权限很复杂, 单单一张表可能还不够
还要配合上角色, 部门之类的
回复引用查看