[索引页]
[源码下载]
扩展GridView控件(11) - 合并指定列的相邻且内容相同的单元格
作者:webabcd
介绍
扩展GridView控件:
合并指定列的相邻且内容相同的单元格
使用方法(设置属性):
MergeCells - 需要合并单元格的列的索引(用逗号“,”分隔)
关键代码
实现“合并指定列的相邻且内容相同的单元格”功能的代码
using System;
using System.Collections.Generic;
using System.Text;
using System.Web.UI.WebControls;
using System.Web.UI;
namespace YYControls.Helper
{
/// <summary>
/// SmartGridView的Helper
/// </summary>
public class SmartGridView
{
/// <summary>
/// 合并指定列的相邻且内容相同的单元格
/// </summary>
/// <param name="gv">GridView</param>
/// <param name="columnIndices">需要合并单元格的列的索引(用逗号“,”分隔)</param>
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 < aryInt.Length; i++)
{
aryInt[i] = 0;
}
// aryBln初值均为true
for (int i = 0; i < aryBln.Length; i++)
{
aryBln[i] = true;
}
for (int i = 1; i < gv.Rows.Count; i++)
{
// 本行和上一行均为DataControlRowType.DataRow
if (gv.Rows[i].RowType == DataControlRowType.DataRow && gv.Rows[i - 1].RowType == DataControlRowType.DataRow)
{
// 遍历指定的列索引
for (int j = 0; j < columnIndices.Length; j++)
{
// 列索引超出范围则不处理
if (columnIndices[j] < 0 || columnIndices[j] > 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;
}
}
}
}
}
}
}
using System.Collections.Generic;
using System.Text;
using System.Web.UI.WebControls;
using System.Web.UI;
namespace YYControls.Helper
{
/// <summary>
/// SmartGridView的Helper
/// </summary>
public class SmartGridView
{
/// <summary>
/// 合并指定列的相邻且内容相同的单元格
/// </summary>
/// <param name="gv">GridView</param>
/// <param name="columnIndices">需要合并单元格的列的索引(用逗号“,”分隔)</param>
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 < aryInt.Length; i++)
{
aryInt[i] = 0;
}
// aryBln初值均为true
for (int i = 0; i < aryBln.Length; i++)
{
aryBln[i] = true;
}
for (int i = 1; i < gv.Rows.Count; i++)
{
// 本行和上一行均为DataControlRowType.DataRow
if (gv.Rows[i].RowType == DataControlRowType.DataRow && gv.Rows[i - 1].RowType == DataControlRowType.DataRow)
{
// 遍历指定的列索引
for (int j = 0; j < columnIndices.Length; j++)
{
// 列索引超出范围则不处理
if (columnIndices[j] < 0 || columnIndices[j] > 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新增一个属性
为GridView新增一个属性
using System;
using System.Collections.Generic;
using System.Text;
using System.ComponentModel;
namespace YYControls
{
/// <summary>
/// SmartGridView类的属性部分
/// </summary>
public partial class SmartGridView
{
private string _mergeCells;
/// <summary>
/// 需要合并单元格的列的索引(用逗号“,”分隔)
/// </summary>
[
Browsable(true),
Description("需要合并单元格的列的索引(用逗号“,”分隔)"),
Category("扩展")
]
public virtual string MergeCells
{
get { return _mergeCells; }
set { _mergeCells = value; }
}
}
}
using System.Collections.Generic;
using System.Text;
using System.ComponentModel;
namespace YYControls
{
/// <summary>
/// SmartGridView类的属性部分
/// </summary>
public partial class SmartGridView
{
private string _mergeCells;
/// <summary>
/// 需要合并单元格的列的索引(用逗号“,”分隔)
/// </summary>
[
Browsable(true),
Description("需要合并单元格的列的索引(用逗号“,”分隔)"),
Category("扩展")
]
public virtual string MergeCells
{
get { return _mergeCells; }
set { _mergeCells = value; }
}
}
}
继承YYControls.SmartGridViewFunction.ExtendFunction抽象类,重写其Execute()方法
using System;
using System.Collections.Generic;
using System.Text;
using System.Web.UI.WebControls;
namespace YYControls.SmartGridViewFunction
{
/// <summary>
/// 扩展功能:合并指定列的相邻且内容相同的单元格
/// </summary>
public class MergeCellsFunction : ExtendFunction
{
/// <summary>
/// 构造函数
/// </summary>
public MergeCellsFunction()
: base()
{
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="sgv">SmartGridView对象</param>
public MergeCellsFunction(SmartGridView sgv)
: base(sgv)
{
}
/// <summary>
/// 扩展功能的实现
/// </summary>
protected override void Execute()
{
this._sgv.DataBound += new EventHandler(_sgv_DataBound);
}
/// <summary>
/// SmartGridView的DataBound事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void _sgv_DataBound(object sender, EventArgs e)
{
string[] ary = this._sgv.MergeCells.Split(',');
int[] columnIndices = new int[ary.Length];
// 将字符串数组转为整型数组
for (int i = 0; i < 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);
}
}
}
using System.Collections.Generic;
using System.Text;
using System.Web.UI.WebControls;
namespace YYControls.SmartGridViewFunction
{
/// <summary>
/// 扩展功能:合并指定列的相邻且内容相同的单元格
/// </summary>
public class MergeCellsFunction : ExtendFunction
{
/// <summary>
/// 构造函数
/// </summary>
public MergeCellsFunction()
: base()
{
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="sgv">SmartGridView对象</param>
public MergeCellsFunction(SmartGridView sgv)
: base(sgv)
{
}
/// <summary>
/// 扩展功能的实现
/// </summary>
protected override void Execute()
{
this._sgv.DataBound += new EventHandler(_sgv_DataBound);
}
/// <summary>
/// SmartGridView的DataBound事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void _sgv_DataBound(object sender, EventArgs e)
{
string[] ary = this._sgv.MergeCells.Split(',');
int[] columnIndices = new int[ary.Length];
// 将字符串数组转为整型数组
for (int i = 0; i < 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,如需转载请自行联系原作者