GridView的数据行的行合并，GridView实现合计数据项

最新推荐文章于 2016-03-28 17:25:28 发布

原创最新推荐文章于 2016-03-28 17:25:28 发布 · 5.5k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#asp #server #textbox #string #医疗 #html

ASP.NET 专区专栏收录该内容

18 篇文章

订阅专栏

本文介绍了一个员工保险管理系统的设计与实现过程，包括使用ASP.NET进行前端界面布局、数据验证及表格展示，通过GridView实现了数据行合并及列合计等功能。

以下是页面的HTML代码：

<%@ Page Language="C#" AutoEventWireup="true" StylesheetTheme="Default" Theme="Default"

CodeFile="InsuranceList.aspx.cs" Inherits="Employee_InsuranceList" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>员工保险信息</title>

</head>

<body>

<legend>员工保险管理</legend>

<ul>

<li><a href="AddInsurance.aspx" title="添加员工保险"><span>添加员工保险</span></a></li>

</ul>

</div>

</fieldset>

<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtBDate"

ErrorMessage="开始年份不能为空" Display="Dynamic">*</asp:RequiredFieldValidator>

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="txtBDate"

Display="Dynamic" ErrorMessage="开始年份格式不正确" ValidationExpression="^[0-9]*[1-9][0-9]*$">*</asp:RegularExpressionValidator>结束年份：

<asp:TextBox ID="txtEndDate" runat="server"></asp:TextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="txtEndDate"

ErrorMessage="结束年份不能为空" Display="Dynamic">*</asp:RequiredFieldValidator>

<asp:RegularExpressionValidator ID="RegularExpressionValidator2" runat="server" ControlToValidate="txtEndDate"

Display="Dynamic" ErrorMessage="结束年份格式不正确" ValidationExpression="^[0-9]*[1-9][0-9]*$">*</asp:RegularExpressionValidator>

<asp:CompareValidator ID="CompareValidator1" runat="server" ControlToCompare="txtEndDate"

ControlToValidate="txtBDate" ErrorMessage="开始年份不能大于结束年份" Operator="LessThanEqual"

Type="Integer" Display="Dynamic">*</asp:CompareValidator>

<asp:Button ID="btnSel" runat="server" Text="开始查询" OnClick="btnSel_Click" />

<asp:GridView ID="gvInsurance" runat="server" SkinID="Default_GridView" AutoGenerateColumns="False"

OnDataBound="gvInsurance_DataBound" OnRowDataBound="gvInsurance_RowDataBound" CaptionAlign="Left" OnRowDeleting="gvInsurance_RowDeleting" OnRowEditing="gvInsurance_RowEditing" ShowFooter="True">

<asp:BoundField DataField="ComName" HeaderText="公司名称" />

<asp:BoundField DataField="DepartName" HeaderText="部门名称" />

<asp:BoundField DataField="EmpName" HeaderText="员工姓名" />

<asp:BoundField DataField="InsYear" HeaderText="保险年度" />

<asp:BoundField DataField="Endowment" DataFormatString="{0:C}" HeaderText="养老保险"

HtmlEncode="False">

</asp:BoundField>

<asp:BoundField DataField="Medicare" DataFormatString="{0:C}" HeaderText="医疗保险" HtmlEncode="False">

</asp:BoundField>

<asp:BoundField DataField="Unemployed" DataFormatString="{0:C}" HeaderText="失业保险"

HtmlEncode="False">

</asp:BoundField>

<asp:BoundField DataField="Fund" DataFormatString="{0:C}" HeaderText="公积金" HtmlEncode="False">

</asp:BoundField>

<asp:BoundField DataField="EmpCode" HeaderText="员工编号" />

<asp:CommandField ShowEditButton="True" />

<asp:CommandField ShowDeleteButton="True" />

</Columns>

</asp:GridView>

</fieldset>

<asp:ValidationSummary ID="ValidationSummary1" runat="server" ShowMessageBox="True"

ShowSummary="False" />

</form>

</body>

</html>

实现数据行合并是在GridView的DataBind事件进行书写：
代码如下：

protected void gvInsurance_DataBound(object sender, EventArgs e)

{

GroupRows(this.gvInsurance, 0);

GroupRows(this.gvInsurance, 1);

}

public static void GroupRows(GridView GridView1, int cellNum)

{

int i = 0, rowSpanNum = 1;

while (i < GridView1.Rows.Count - 1)

{

GridViewRow gvr = GridView1.Rows[i];

for (++i; i < GridView1.Rows.Count; i++)

{

GridViewRow gvrNext = GridView1.Rows[i];

if (gvr.Cells[cellNum].Text == gvrNext.Cells[cellNum].Text)

{

gvrNext.Cells[cellNum].Visible = false;

rowSpanNum++;

}

else

{

gvr.Cells[cellNum].RowSpan = rowSpanNum;

rowSpanNum = 1;

break;

}

if (i == GridView1.Rows.Count - 1)

{

gvr.Cells[cellNum].RowSpan = rowSpanNum;

}

书写实现数据列合计是在RowDataBind事件里面进行书写，代码如下：

protected void gvInsurance_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

e.Row.Attributes.Add("onmouseover", "e=this.style.backgroundColor; this.style.backgroundColor='linen'");

e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=e");

}

//sum info

if (e.Row.RowType == DataControlRowType.Footer)

{

//unite cell

e.Row.Cells[0].ColumnSpan = 11;

//visual 10 cell

for (int i = 1; i < 11; i++)

{

e.Row.Cells[i].Visible = false;

}

//get every unite cell value

TableCell cellEndowment = e.Row.Cells[4];

TableCell cellMedicare = e.Row.Cells[5];

TableCell cellUnemployed=e.Row.Cells[6];

TableCell cellFund=e.Row.Cells[7];

TableCell cellSum = e.Row.Cells[8];

//define variable

double endowment,medicare,unemployee,fund;

//set value

endowment= GetSum(4);

medicare=GetSum(5);

unemployee=GetSum(6);

fund=GetSum(7);

//response string

e.Row.Cells[0].Text="养老保险合计：" + String.Format("{0:C}",endowment)+

" 医疗保险合计：" + String.Format("{0:C}", medicare)+

" 失业保险合计：" + string.Format("{0:C}",unemployee)+

" 公积金合计：" + string.Format("{0:C}",fund)+

" 总计："+string.Format("{0:C}",this.GetSum(endowment,medicare,unemployee,fund));

}

注：设置GridView的DataSource时，根据你欲合并数据行的列进行排序。
附１：　

/// <summary>

/// get sum

/// </summary>

/// <param name="i">column id</param>

/// <returns>sum value</returns>

private double GetSum(int i)

{

//define variable

double sum = 0;

foreach (GridViewRow row in this.gvInsurance.Rows)

{

sum += Convert.ToDouble(string.Format("{0:2F}",row.Cells[i].Text.Remove(0,1)));

}

return sum;

}

/// <summary>

/// get all sum

/// </summary>

/// <param name="endowment">养老保险</param>

/// <param name="medicare">医疗保险</param>

/// <param name="unemployee">失业保险</param>

/// <param name="fund">公积金</param>

/// <returns>sum</returns>

private double GetSum(double endowment,double medicare,double unemployee,double fund)

{

return endowment+medicare+unemployee+fund;

}