扩展GridView控件(11) - 合并指定列的相邻且内容相同的单元格

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


扩展GridView控件(11) - 合并指定列的相邻且内容相同的单元格


作者: webabcd


介绍
扩展GridView控件:
合并指定列的相邻且内容相同的单元格

使用方法(设置属性): 
MergeCells -  需要合并单元格的列的索引(用逗号“,”分隔)


关键代码
实现“合并指定列的相邻且内容相同的单元格”功能的代码
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.Helper 
InBlock.gif
InBlock.gif         /// <summary> 
InBlock.gif         /// SmartGridView的Helper 
InBlock.gif         /// </summary> 
InBlock.gif         public  class SmartGridView 
InBlock.gif        { 
InBlock.gif                 /// <summary> 
InBlock.gif                 /// 合并指定列的相邻且内容相同的单元格 
InBlock.gif                 /// </summary> 
InBlock.gif                 /// <param name="gv">GridView</param> 
InBlock.gif                 /// <param name="columnIndices">需要合并单元格的列的索引(用逗号“,”分隔)</param> 
InBlock.gif                 public  static  void MergeCells(GridView gv,  int[] columnIndices) 
InBlock.gif                { 
InBlock.gif                         // 指定的列中需要设置RowSpan的单元格的行索引 
InBlock.gif                         int[] aryInt =  new  int[columnIndices.Length]; 
InBlock.gif                         // 是否重新指定aryInt的相关元素的值 
InBlock.gif                         // aryInt中的元素与aryBln中的元素一一对应 
InBlock.gif                         bool[] aryBln =  new  bool[columnIndices.Length]; 
InBlock.gif                         // aryInt初值均为0 
InBlock.gif                         for ( int i = 0; i < aryInt.Length; i++) 
InBlock.gif                        { 
InBlock.gif                                aryInt[i] = 0; 
InBlock.gif                        } 
InBlock.gif                         // aryBln初值均为true 
InBlock.gif                         for ( int i = 0; i < aryBln.Length; i++) 
InBlock.gif                        { 
InBlock.gif                                aryBln[i] =  true
InBlock.gif                        } 
InBlock.gif 
InBlock.gif                         for ( int i = 1; i < gv.Rows.Count; i++) 
InBlock.gif                        { 
InBlock.gif                                 // 本行和上一行均为DataControlRowType.DataRow 
InBlock.gif                                 if (gv.Rows[i].RowType == DataControlRowType.DataRow && gv.Rows[i - 1].RowType == DataControlRowType.DataRow) 
InBlock.gif                                { 
InBlock.gif                                         // 遍历指定的列索引 
InBlock.gif                                         for ( int j = 0; j < columnIndices.Length; j++) 
InBlock.gif                                        { 
InBlock.gif                                                 // 列索引超出范围则不处理 
InBlock.gif                                                 if (columnIndices[j] < 0 || columnIndices[j] > gv.Columns.Count - 1)  continue
InBlock.gif 
InBlock.gif                                                 // 相邻单元格的内容相同 
InBlock.gif                                                 if (gv.Rows[i].Cells[columnIndices[j]].Text == gv.Rows[i - 1].Cells[columnIndices[j]].Text) 
InBlock.gif                                                { 
InBlock.gif                                                         if (aryBln[j]) 
InBlock.gif                                                                aryInt[j] = i - 1; 
InBlock.gif 
InBlock.gif                                                         if (gv.Rows[aryInt[j]].Cells[columnIndices[j]].RowSpan == 0) 
InBlock.gif                                                                gv.Rows[aryInt[j]].Cells[columnIndices[j]].RowSpan = 1; 
InBlock.gif 
InBlock.gif                                                        gv.Rows[aryInt[j]].Cells[columnIndices[j]].RowSpan++; 
InBlock.gif                                                        gv.Rows[i].Cells[columnIndices[j]].Visible =  false
InBlock.gif 
InBlock.gif                                                        aryBln[j] =  false
InBlock.gif                                                } 
InBlock.gif                                                 else 
InBlock.gif                                                { 
InBlock.gif                                                        aryBln[j] =  true
InBlock.gif                                                } 
InBlock.gif                                        } 
InBlock.gif                                } 
InBlock.gif                        } 
InBlock.gif                } 
InBlock.gif        } 
InBlock.gif}
 
上面的MergeCells(GridView gv, int[] columnIndices)方法用于实现“合并指定列的相邻且内容相同的单元格”,第一个参数是GridView,第二个参数是需要合并单元格的列的索引(用逗号“,”分隔)。

为GridView新增一个属性
InBlock.gif using System; 
InBlock.gif using System.Collections.Generic; 
InBlock.gif using System.Text; 
InBlock.gif 
InBlock.gif using System.ComponentModel; 
InBlock.gif 
InBlock.gif namespace YYControls 
InBlock.gif
InBlock.gif         /// <summary> 
InBlock.gif         /// SmartGridView类的属性部分 
InBlock.gif         /// </summary> 
InBlock.gif         public partial  class SmartGridView 
InBlock.gif        { 
InBlock.gif                 private  string _mergeCells; 
InBlock.gif                 /// <summary> 
InBlock.gif                 /// 需要合并单元格的列的索引(用逗号“,”分隔) 
InBlock.gif                 /// </summary> 
InBlock.gif                [ 
InBlock.gif                Browsable( true), 
InBlock.gif                Description( "需要合并单元格的列的索引(用逗号“,”分隔)"),    
InBlock.gif                Category( "扩展"
InBlock.gif                ] 
InBlock.gif                 public  virtual  string MergeCells 
InBlock.gif                { 
InBlock.gif                        get {  return _mergeCells; } 
InBlock.gif                        set { _mergeCells = value; } 
InBlock.gif                } 
InBlock.gif        } 
InBlock.gif}
 
继承YYControls.SmartGridViewFunction.ExtendFunction抽象类,重写其Execute()方法
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 
InBlock.gif namespace YYControls.SmartGridViewFunction 
InBlock.gif
InBlock.gif         /// <summary> 
InBlock.gif         /// 扩展功能:合并指定列的相邻且内容相同的单元格 
InBlock.gif         /// </summary> 
InBlock.gif         public  class MergeCellsFunction : ExtendFunction 
InBlock.gif        { 
InBlock.gif                 /// <summary> 
InBlock.gif                 /// 构造函数 
InBlock.gif                 /// </summary> 
InBlock.gif                 public MergeCellsFunction() 
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 MergeCellsFunction(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                         this._sgv.DataBound +=  new EventHandler(_sgv_DataBound); 
InBlock.gif                } 
InBlock.gif 
InBlock.gif                 /// <summary> 
InBlock.gif                 /// SmartGridView的DataBound事件 
InBlock.gif                 /// </summary> 
InBlock.gif                 /// <param name="sender"></param> 
InBlock.gif                 /// <param name="e"></param> 
InBlock.gif                 void _sgv_DataBound( object sender, EventArgs e) 
InBlock.gif                { 
InBlock.gif                         string[] ary =  this._sgv.MergeCells.Split(','); 
InBlock.gif                         int[] columnIndices =  new  int[ary.Length]; 
InBlock.gif 
InBlock.gif                         // 将字符串数组转为整型数组 
InBlock.gif                         for ( int i = 0; i < columnIndices.Length; i++) 
InBlock.gif                        { 
InBlock.gif                                 int j; 
InBlock.gif                                 if (!Int32.TryParse(ary[i],  out j)) 
InBlock.gif                                { 
InBlock.gif                                         // 转整型失败则赋值为-1,“合并指定列的相邻且内容相同的单元格”则不会处理 
InBlock.gif                                        j = -1; 
InBlock.gif                                } 
InBlock.gif 
InBlock.gif                                columnIndices[i] = j; 
InBlock.gif                        } 
InBlock.gif 
InBlock.gif                        YYControls.Helper.SmartGridView.MergeCells( this._sgv, columnIndices); 
InBlock.gif                } 
InBlock.gif        } 
InBlock.gif}
 


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

相关文章
|
5月前
layUI数据表格可编辑表格单元格值修改之后获取修改前的值
layUI数据表格可编辑表格单元格值修改之后获取修改前的值
142 0
|
11天前
用dragstart、drag、dragend、dragover、drop、dragleave实现针对表格列的顺序进行拖拽排序(附带实现选择某几列数据显示或隐藏)
用dragstart、drag、dragend、dragover、drop、dragleave实现针对表格列的顺序进行拖拽排序(附带实现选择某几列数据显示或隐藏)
PyQt5 技术篇-QTableWidget表格组件指定行的隐藏与显示控制实例演示,设置表格指定列的列宽方法
PyQt5 技术篇-QTableWidget表格组件指定行的隐藏与显示控制实例演示,设置表格指定列的列宽方法
590 0
PyQt5 技术篇-QTableWidget表格组件指定行的隐藏与显示控制实例演示,设置表格指定列的列宽方法
|
5月前
在TableViewer中如何给表格的单元格增加其他组件的编辑功能
在TableViewer中如何给表格的单元格增加其他组件的编辑功能
24 0
VB编程:利用数组设置MSFlexGrid表头和列宽-34
VB编程:利用数组设置MSFlexGrid表头和列宽-34
178 0
PyQt5 技术篇-QTableWidget表格组件的行选择与列选择实例演示,表格组件的双击事件捕获,获取表格选中单元格的值
PyQt5 技术篇-QTableWidget表格组件的行选择与列选择实例演示,表格组件的双击事件捕获,获取表格选中单元格的值
1055 0
PyQt5 技术篇-QTableWidget表格组件的行选择与列选择实例演示,表格组件的双击事件捕获,获取表格选中单元格的值
PyQt5 技术篇-设置QTableWidget表格组件默认值实例演示,如何获取QTableWidget表格组件里的值,获取表格的行数和列数
PyQt5 技术篇-设置QTableWidget表格组件默认值实例演示,如何获取QTableWidget表格组件里的值,获取表格的行数和列数
550 0
PyQt5 技术篇-设置QTableWidget表格组件默认值实例演示,如何获取QTableWidget表格组件里的值,获取表格的行数和列数
VB编程:利用数组设置MSFlexGrid表头和列宽
VB编程:利用数组设置MSFlexGrid表头和列宽
266 0