天天看点

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

GridView既强大又好用。为了让它更强大、更好用,我们来写一个继承自GridView的控件。

<a href="http://webabcd.blog.51cto.com/1787395/345429" target="_blank">[索引页]</a>

<a href="http://down.51cto.com/data/101204" target="_blank">[源码下载]</a>

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

介绍

扩展GridView控件:

合并指定列的相邻且内容相同的单元格

使用方法(设置属性): 

MergeCells -  需要合并单元格的列的索引(用逗号“,”分隔)

关键代码

实现“合并指定列的相邻且内容相同的单元格”功能的代码

using System; 

using System.Collections.Generic; 

using System.Text; 

using System.Web.UI.WebControls; 

using System.Web.UI; 

namespace YYControls.Helper 

        /// &lt;summary&gt; 

        /// SmartGridView的Helper 

        /// &lt;/summary&gt; 

        public class SmartGridView 

        { 

                /// &lt;summary&gt; 

                /// 合并指定列的相邻且内容相同的单元格 

                /// &lt;/summary&gt; 

                /// &lt;param name="gv"&gt;GridView&lt;/param&gt; 

                /// &lt;param name="columnIndices"&gt;需要合并单元格的列的索引(用逗号“,”分隔)&lt;/param&gt; 

                public static void MergeCells(GridView gv, int[] columnIndices) 

                { 

                        // 指定的列中需要设置RowSpan的单元格的行索引 

                        int[] aryInt = new int[columnIndices.Length]; 

                        // 是否重新指定aryInt的相关元素的值 

                        // aryInt中的元素与aryBln中的元素一一对应 

                        bool[] aryBln = new bool[columnIndices.Length]; 

                        // aryInt初值均为0 

                        for (int i = 0; i &lt; aryInt.Length; i++) 

                        { 

                                aryInt[i] = 0; 

                        } 

                        // aryBln初值均为true 

                        for (int i = 0; i &lt; aryBln.Length; i++) 

                                aryBln[i] = true; 

                        for (int i = 1; i &lt; gv.Rows.Count; i++) 

                                // 本行和上一行均为DataControlRowType.DataRow 

                                if (gv.Rows[i].RowType == DataControlRowType.DataRow &amp;&amp; gv.Rows[i - 1].RowType == DataControlRowType.DataRow) 

                                { 

                                        // 遍历指定的列索引 

                                        for (int j = 0; j &lt; columnIndices.Length; j++) 

                                        { 

                                                // 列索引超出范围则不处理 

                                                if (columnIndices[j] &lt; 0 || columnIndices[j] &gt; gv.Columns.Count - 1) continue; 

                                                // 相邻单元格的内容相同 

                                                if (gv.Rows[i].Cells[columnIndices[j]].Text == gv.Rows[i - 1].Cells[columnIndices[j]].Text) 

                                                { 

                                                        if (aryBln[j]) 

                                                                aryInt[j] = i - 1; 

                                                        if (gv.Rows[aryInt[j]].Cells[columnIndices[j]].RowSpan == 0) 

                                                                gv.Rows[aryInt[j]].Cells[columnIndices[j]].RowSpan = 1; 

                                                        gv.Rows[aryInt[j]].Cells[columnIndices[j]].RowSpan++; 

                                                        gv.Rows[i].Cells[columnIndices[j]].Visible = false; 

                                                        aryBln[j] = false; 

                                                } 

                                                else 

                                                        aryBln[j] = true; 

                                        } 

                                } 

                } 

        } 

}

上面的MergeCells(GridView gv, int[] columnIndices)方法用于实现“合并指定列的相邻且内容相同的单元格”,第一个参数是GridView,第二个参数是需要合并单元格的列的索引(用逗号“,”分隔)。

为GridView新增一个属性

using System.ComponentModel; 

namespace YYControls 

        /// SmartGridView类的属性部分 

        public partial class SmartGridView 

                private string _mergeCells; 

                /// 需要合并单元格的列的索引(用逗号“,”分隔) 

                [ 

                Browsable(true), 

                Description("需要合并单元格的列的索引(用逗号“,”分隔)"),    

                Category("扩展") 

                ] 

                public virtual string MergeCells 

                        get { return _mergeCells; } 

                        set { _mergeCells = value; } 

继承YYControls.SmartGridViewFunction.ExtendFunction抽象类,重写其Execute()方法

namespace YYControls.SmartGridViewFunction 

        /// 扩展功能:合并指定列的相邻且内容相同的单元格 

        public class MergeCellsFunction : ExtendFunction 

                /// 构造函数 

                public MergeCellsFunction() 

                        : base() 

                /// &lt;param name="sgv"&gt;SmartGridView对象&lt;/param&gt; 

                public MergeCellsFunction(SmartGridView sgv) 

                        : base(sgv) 

                /// 扩展功能的实现 

                protected override void Execute() 

                        this._sgv.DataBound += new EventHandler(_sgv_DataBound); 

                /// SmartGridView的DataBound事件 

                /// &lt;param name="sender"&gt;&lt;/param&gt; 

                /// &lt;param name="e"&gt;&lt;/param&gt; 

                void _sgv_DataBound(object sender, EventArgs e) 

                        string[] ary = this._sgv.MergeCells.Split(','); 

                        int[] columnIndices = new int[ary.Length]; 

                        // 将字符串数组转为整型数组 

                        for (int i = 0; i &lt; columnIndices.Length; i++) 

                                int j; 

                                if (!Int32.TryParse(ary[i], out j)) 

                                        // 转整型失败则赋值为-1,“合并指定列的相邻且内容相同的单元格”则不会处理 

                                        j = -1; 

                                columnIndices[i] = j; 

                        YYControls.Helper.SmartGridView.MergeCells(this._sgv, columnIndices); 

OK

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

继续阅读