ClientDataSet的动态排序

最新推荐文章于 2023-03-08 11:48:02 发布

weixin_34153893

最新推荐文章于 2023-03-08 11:48:02 发布

阅读量211

点赞数

原文链接：https://my.oschina.net/u/582827/blog/798988

版权

2019独角兽企业重金招聘Python工程师标准>>>

ClientDataSet 的动态排序可以通过以下代码实现
1.单一字段的升序和降序
with cds do
begin
  IndexDefs.Update;
  if IndexDefs.IndexOf('index1') >= 0 then
  DeleteIndex('index1');
  AddIndex('index1', SortFieldName, [], '');
  IndexName := 'index1';
  First;
end;

with cds do
begin
  IndexDefs.Update;
  if IndexDefs.IndexOf('index1') >= 0 then
  DeleteIndex('index1');
  AddIndex('index1', SortFieldName, [], SortFieldName);
  IndexName := 'index1';
  First;
end;

2.复合字段的升序和降序
with cds do
begin
  IndexDefs.Update;
  if IndexDefs.IndexOf('index2') >= 0 then
    DeleteIndex('index2');
  AddIndex('index2', 'SortField1, SortField2', [], '');
  IndexName := 'index1';
  First;
end;

with cds do
begin
  IndexDefs.Update;
  if IndexDefs.IndexOf('index2') >= 0 then
    DeleteIndex('index2');
  AddIndex('index2', 'SortField1, SortField2', [], 'SortField1, SortField2');
  IndexName := 'index2';
  First;
end;

3.复合字段的复合排序
传入参数  SortField1, SortField2, [], SortField2 即可

http://blog.youkuaiyun.com/whw6_faye/article/details/1754084

转载于:https://my.oschina.net/u/582827/blog/798988