扩展GridView控件(2) - 复合排序和排序状态提示

简介:
GridView既强大又好用。为了让它更强大、更好用,我们来写一个继承自GridView的控件。
[索引页]
[源码下载]


扩展GridView控件(2) - 复合排序和排序状态提示


作者: webabcd
InBlock.gif /*正式版的实现 开始*/
 
介绍
扩展GridView控件:
对多个字段进行复合排序;升序、降序的排序状态提示

使用方法(设置SmartSorting复合属性):
AllowSortTip - 是否启用排序提示
AllowMultiSorting - 是否启用复合排序
SortAscImageUrl - 升序提示图片的URL(不设置则使用默认图片)
SortDescImageUrl - 降序提示图片的URL(不设置则使用默认图片)
SortAscText - 升序提示文本
SortDescText - 降序提示文本


关键代码
InBlock.gif using System; 
InBlock.gif using System.Collections.Generic; 
InBlock.gif using System.Text; 
InBlock.gif 
InBlock.gif using System.Web.UI.WebControls; 
InBlock.gif using System.Web.UI; 
InBlock.gif 
InBlock.gif namespace YYControls.SmartGridViewFunction 
InBlock.gif
InBlock.gif         /// <summary> 
InBlock.gif         /// 扩展功能:复合排序和排序状态提示 
InBlock.gif         /// </summary> 
InBlock.gif         public  class SmartSortingFunction : ExtendFunction 
InBlock.gif        { 
InBlock.gif                 /// <summary> 
InBlock.gif                 /// 构造函数 
InBlock.gif                 /// </summary> 
InBlock.gif                 public SmartSortingFunction() 
InBlock.gif                        :  base() 
InBlock.gif                { 
InBlock.gif 
InBlock.gif                } 
InBlock.gif 
InBlock.gif                 /// <summary> 
InBlock.gif                 /// 构造函数 
InBlock.gif                 /// </summary> 
InBlock.gif                 /// <param name="sgv">SmartGridView对象</param> 
InBlock.gif                 public SmartSortingFunction(SmartGridView sgv) 
InBlock.gif                        :  base(sgv) 
InBlock.gif                { 
InBlock.gif 
InBlock.gif                } 
InBlock.gif 
InBlock.gif                 /// <summary> 
InBlock.gif                 /// 扩展功能的实现 
InBlock.gif                 /// </summary> 
InBlock.gif                 protected  override  void Execute() 
InBlock.gif                { 
InBlock.gif                         // 开启SmartGridView的排序功能 
InBlock.gif                         // this._sgv.AllowSorting = true; 
InBlock.gif 
InBlock.gif                         this._sgv.Sorting +=  new System.Web.UI.WebControls.GridViewSortEventHandler(_sgv_Sorting); 
InBlock.gif                         this._sgv.RowDataBoundCell +=  new SmartGridView.RowDataBoundCellHandler(_sgv_RowDataBoundCell); 
InBlock.gif                } 
InBlock.gif 
InBlock.gif                 /// <summary> 
InBlock.gif                 /// SmartGridView的RowDataBoundCell事件 
InBlock.gif                 /// </summary> 
InBlock.gif                 /// <param name="sender"></param> 
InBlock.gif                 /// <param name="gvtc"></param> 
InBlock.gif                 void _sgv_RowDataBoundCell( object sender, GridViewTableCell gvtc) 
InBlock.gif                { 
InBlock.gif                         if (!String.IsNullOrEmpty( this._sgv.SortExpression)    
InBlock.gif                                &&  this._sgv.SmartSorting.AllowSortTip 
InBlock.gif                                && gvtc.RowType == DataControlRowType.Header) 
InBlock.gif                        { 
InBlock.gif                                 // 显示排序状态提示 
InBlock.gif                                DisplaySortTip( this._sgv.SortExpression, gvtc.TableCell); 
InBlock.gif                        } 
InBlock.gif                } 
InBlock.gif 
InBlock.gif                 /// <summary> 
InBlock.gif                 /// Sorting事件 
InBlock.gif                 /// </summary> 
InBlock.gif                 /// <param name="sender"></param> 
InBlock.gif                 /// <param name="e"></param> 
InBlock.gif                 void _sgv_Sorting( object sender, System.Web.UI.WebControls.GridViewSortEventArgs e) 
InBlock.gif                { 
InBlock.gif                         // 如果允许复合排序的话,则设置复合排序表达式 
InBlock.gif                         if ( this._sgv.SmartSorting.AllowMultiSorting) 
InBlock.gif                        { 
InBlock.gif                                e.SortExpression = GetSortExpression(e); 
InBlock.gif                        } 
InBlock.gif                } 
InBlock.gif 
InBlock.gif                 /// <summary> 
InBlock.gif                 /// 获得复合排序表达式 
InBlock.gif                 /// </summary> 
InBlock.gif                 /// <param name="e"></param> 
InBlock.gif                 /// <returns></returns> 
InBlock.gif                 protected  string GetSortExpression(GridViewSortEventArgs e) 
InBlock.gif                { 
InBlock.gif                         string[] sortColumns =  null
InBlock.gif                         string sortAttribute =  this._sgv.SortExpression; 
InBlock.gif 
InBlock.gif                         if (!String.IsNullOrEmpty(sortAttribute)) 
InBlock.gif                        { 
InBlock.gif                                sortColumns = sortAttribute.Split(','); 
InBlock.gif                        } 
InBlock.gif 
InBlock.gif                         // 如果原排序表达式有当前排序字段 
InBlock.gif                         if (sortAttribute.IndexOf(e.SortExpression) != -1) 
InBlock.gif                        { 
InBlock.gif                                 // 更新排序表达式 
InBlock.gif                                sortAttribute = ModifySortExpression(sortColumns, e.SortExpression); 
InBlock.gif                        } 
InBlock.gif                         else 
InBlock.gif                        { 
InBlock.gif                                 // 为原排序表达式添加新的排序规则(升序) 
InBlock.gif                                sortAttribute += String.Concat( ",", e.SortExpression,  " ASC"); 
InBlock.gif                        } 
InBlock.gif 
InBlock.gif                         return sortAttribute.Trim(','); 
InBlock.gif                } 
InBlock.gif 
InBlock.gif                 /// <summary> 
InBlock.gif                 /// 更新排序表达式 
InBlock.gif                 /// </summary> 
InBlock.gif                 /// <param name="sortColumns">各个字段的排序表达式数组</param> 
InBlock.gif                 /// <param name="sortExpression">当前需要排序的字段(该字段在sortColumns数组中)</param> 
InBlock.gif                 /// <returns></returns> 
InBlock.gif                 protected  string ModifySortExpression( string[] sortColumns,  string sortExpression) 
InBlock.gif                { 
InBlock.gif                         // 当前需要排序的字段的升序表达式 
InBlock.gif                         string ascSortExpression = String.Concat(sortExpression,  " ASC"); 
InBlock.gif                         // 当前需要排序的字段的降序表达式 
InBlock.gif                         string descSortExpression = String.Concat(sortExpression,  " DESC"); 
InBlock.gif 
InBlock.gif                         for ( int i = 0; i < sortColumns.Length; i++) 
InBlock.gif                        { 
InBlock.gif                                 // 各个字段的排序表达式数组中,有当前需要排序的字段的升序表达式 
InBlock.gif                                 if (ascSortExpression.Equals(sortColumns[i])) 
InBlock.gif                                { 
InBlock.gif                                         // 当前排序字段由升序变为降序 
InBlock.gif                                        sortColumns[i] = descSortExpression; 
InBlock.gif                                         break
InBlock.gif                                } 
InBlock.gif                                 // 各个字段的排序表达式数组中,有当前需要排序的字段的降序表达式 
InBlock.gif                                 else  if (descSortExpression.Equals(sortColumns[i])) 
InBlock.gif                                { 
InBlock.gif                                         // 从各个字段的排序表达式数组中,删除当前需要排序的字段 
InBlock.gif                                        Array.Clear(sortColumns, i, 1); 
InBlock.gif                                         break
InBlock.gif                                } 
InBlock.gif                        } 
InBlock.gif 
InBlock.gif                         return String.Join( ",", sortColumns).Replace( ",,"",").Trim(','); 
InBlock.gif                } 
InBlock.gif 
InBlock.gif                 /// <summary> 
InBlock.gif                 /// 显示排序状态提示 
InBlock.gif                 /// </summary> 
InBlock.gif                 /// <param name="sortExpression">排序表达式</param> 
InBlock.gif                 /// <param name="tc">Header的TableCell</param> 
InBlock.gif                 protected  void DisplaySortTip( string sortExpression, TableCell tc) 
InBlock.gif                { 
InBlock.gif                         string[] sortColumns = sortExpression.Split(','); 
InBlock.gif 
InBlock.gif                         if (tc.Controls.Count > 0 && tc.Controls[0]  is LinkButton) 
InBlock.gif                        { 
InBlock.gif                                 string columnName = ((LinkButton)tc.Controls[0]).CommandArgument; 
InBlock.gif 
InBlock.gif                                 int sortOrderIndex = Array.FindIndex(sortColumns,  delegate( string s) {  return s.IndexOf(columnName) != -1; }); 
InBlock.gif 
InBlock.gif                                 // 如果排序表达式中有当前列 
InBlock.gif                                 if (sortOrderIndex != -1) 
InBlock.gif                                { 
InBlock.gif                                         // 当前列应该是升序还是降序(区分两种情况:复合排序和非复合排序) 
InBlock.gif                                        SortDirection sortDirection = SortDirection.Ascending; 
InBlock.gif                                         if ( this._sgv.SmartSorting.AllowMultiSorting && sortColumns[sortOrderIndex].IndexOf( "DESC") != -1) 
InBlock.gif                                        { 
InBlock.gif                                                sortDirection = SortDirection.Descending; 
InBlock.gif                                        } 
InBlock.gif                                         else  if (! this._sgv.SmartSorting.AllowMultiSorting &&  this._sgv.SortDirection == SortDirection.Descending) 
InBlock.gif                                        { 
InBlock.gif                                                sortDirection = SortDirection.Descending; 
InBlock.gif                                        } 
InBlock.gif 
InBlock.gif                                         // 排序状态提示(图片地址) 
InBlock.gif                                         string sortImageUrl =  null
InBlock.gif                                         // 排序状态提示(文本) 
InBlock.gif                                         string sortText =  null
InBlock.gif                                         if (sortDirection == SortDirection.Ascending) 
InBlock.gif                                        { 
InBlock.gif                                                sortText =  this._sgv.SmartSorting.SortAscText; 
InBlock.gif 
InBlock.gif                                                sortImageUrl =  this._sgv.SmartSorting.SortAscImageUrl; 
InBlock.gif 
InBlock.gif                                                 if (String.IsNullOrEmpty(sortImageUrl)) 
InBlock.gif                                                { 
InBlock.gif                                                        sortImageUrl =    
InBlock.gif                                                                 this._sgv.Page.ClientScript.GetWebResourceUrl 
InBlock.gif                                                                ( 
InBlock.gif                                                                         this.GetType(), 
InBlock.gif                                                                         "YYControls.SmartGridView.Resources.Asc.gif" 
InBlock.gif                                                                ); 
InBlock.gif                                                } 
InBlock.gif                                        } 
InBlock.gif                                         else 
InBlock.gif                                        { 
InBlock.gif                                                sortText =  this._sgv.SmartSorting.SortDescText; 
InBlock.gif 
InBlock.gif                                                sortImageUrl =  this._sgv.SmartSorting.SortDescImageUrl; 
InBlock.gif 
InBlock.gif                                                 if (String.IsNullOrEmpty(sortImageUrl)) 
InBlock.gif                                                { 
InBlock.gif                                                        sortImageUrl =    
InBlock.gif                                                                 this._sgv.Page.ClientScript.GetWebResourceUrl 
InBlock.gif                                                                ( 
InBlock.gif                                                                         this.GetType(), 
InBlock.gif                                                                         "YYControls.SmartGridView.Resources.Desc.gif" 
InBlock.gif                                                                ); 
InBlock.gif                                                } 
InBlock.gif                                        } 
InBlock.gif 
InBlock.gif                                         // 添加排序状态提示图片 
InBlock.gif                                        Image imgSortDirection =  new Image(); 
InBlock.gif                                        imgSortDirection.ImageUrl = sortImageUrl; 
InBlock.gif                                        tc.Controls.Add(imgSortDirection); 
InBlock.gif 
InBlock.gif                                         // 添加排序状态提示文本 
InBlock.gif                                        tc.Controls.Add( new LiteralControl(sortText)); 
InBlock.gif 
InBlock.gif                                         if ( this._sgv.SmartSorting.AllowMultiSorting) 
InBlock.gif                                        { 
InBlock.gif                                                 // 添加排序状态提示序号 
InBlock.gif                                                tc.Controls.Add( new LiteralControl((sortOrderIndex + 1).ToString())); 
InBlock.gif                                        } 
InBlock.gif 
InBlock.gif不用资源文件,又没有设置排序状态提示时的逻辑(已经注释掉了) #region 不用资源文件,又没有设置排序状态提示时的逻辑(已经注释掉了) 
InBlock.gif                                         //// 添加排序状态提示图标 
InBlock.gif                                         //Label lblSortDirection = new Label(); 
InBlock.gif                                         //// 被注释的代码使用的是webdings,但是FF不支持,所以放弃了 
InBlock.gif                                         //// lblSortDirection.Font.Name = "webdings"
InBlock.gif                                         //// lblSortDirection.EnableTheming = false
InBlock.gif                                         //if (sortDirection == SortDirection.Ascending) 
InBlock.gif                                         //{ 
InBlock.gif                                         //        // lblSortDirection.Text = "5"; 
InBlock.gif                                         //        lblSortDirection.Text = "▲"; 
InBlock.gif                                         //} 
InBlock.gif                                         //else 
InBlock.gif                                         //{ 
InBlock.gif                                         //        // lblSortDirection.Text = "6"; 
InBlock.gif                                         //        lblSortDirection.Text = "▼"; 
InBlock.gif                                         //} 
InBlock.gif                                         //tc.Controls.Add(lblSortDirection); 
InBlock.gif 
InBlock.gif                                         //if (this._sgv.SmartSorting.AllowMultiSorting) 
InBlock.gif                                         //{ 
InBlock.gif                                         //        // 添加排序状态提示序号 
InBlock.gif                                         //        tc.Controls.Add(new LiteralControl((sortOrderIndex + 1).ToString())); 
InBlock.gif                                         //} 
InBlock.gif                                        #endregion 
InBlock.gif 
InBlock.gif                                }  // if (sortOrderIndex != -1) 
InBlock.gif                        }  // if (tc.Controls.Count > 0 && tc.Controls[0] is LinkButton) 
InBlock.gif                } 
InBlock.gif        } 
InBlock.gif}
 
InBlock.gif /*正式版的实现 结束*/
 
 




     本文转自webabcd 51CTO博客,原文链接:http://blog.51cto.com/webabcd/345446,如需转载请自行联系原作者

相关文章
|
12天前
用dragstart、drag、dragend、dragover、drop、dragleave实现针对表格列的顺序进行拖拽排序(附带实现选择某几列数据显示或隐藏)
用dragstart、drag、dragend、dragover、drop、dragleave实现针对表格列的顺序进行拖拽排序(附带实现选择某几列数据显示或隐藏)