protected void bntQry_Click(object sender, System.EventArgs e)
{
........
........
//数据显示绑定
resultGrid.DataSource = ds.Tables[0];
resultGrid.DataBind();
}
finally{ condition = null; if(ds != null) ds.Dispose();}
private void resultGrid_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
try
{
double moneys = 0, rMoneys = 0, hospitalredeem = 0, fundredeem = 0, secondredeem = 0, mzredeem = 0, cashmoneys = 0, kouchumoney = 0, jsmoney = 0;
if(e.Item.ItemType == ListItemType.AlternatingItem||e.Item.ItemType == ListItemType.Item)
{ //计算总额
DataTable dt = null;
if (resultGrid.DataSource.GetType().Name.ToUpper() == "DATATABLE")
dt = (DataTable)(resultGrid.DataSource);
else if (resultGrid.DataSource.GetType().Name.ToUpper() == "DATAVIEW")
dt = ((DataView)(resultGrid.DataSource)).Table;
for (int i = 0; i < dt.Rows.Count; i++)
{
moneys += double.Parse(dt.Rows[i]["a"].ToString());
rMoneys += double.Parse(dt.Rows[i]["aa"].ToString());
hospitalredeem += double.Parse(dt.Rows[i]["aaa"].ToString());
fundredeem += double.Parse(dt.Rows[i]["x"].ToString());
secondredeem += double.Parse(dt.Rows[i]["xx"].ToString());
mzredeem += double.Parse(dt.Rows[i]["xxx"].ToString());
cashmoneys += double.Parse(dt.Rows[i]["r"].ToString());
kouchumoney += double.Parse(dt.Rows[i]["rr"].ToString());
jsmoney += double.Parse(dt.Rows[i]["rrr"].ToString());
}
}
else if (e.Item.ItemType == ListItemType.Footer)
{
e.Item.Cells[2].Text = "合计";
e.Item.Cells[3].Text = moneys.ToString("#,##0.00");
e.Item.Cells[4].Text = rMoneys.ToString("#,##0.00");
e.Item.Cells[5].Text = hospitalredeem.ToString("#,##0.00");
e.Item.Cells[6].Text = fundredeem.ToString("#,##0.00");
e.Item.Cells[7].Text = secondredeem.ToString("#,##0.00");
e.Item.Cells[8].Text = mzredeem.ToString("#,##0.00");
e.Item.Cells[9].Text = cashmoneys.ToString("#,##0.00");
e.Item.Cells[10].Text = kouchumoney.ToString("#,##0.00");
e.Item.Cells[11].Text = jsmoney.ToString("#,##0.00");
}
}
{
........
........
//数据显示绑定
resultGrid.DataSource = ds.Tables[0];
resultGrid.DataBind();
}
finally{ condition = null; if(ds != null) ds.Dispose();}
private void resultGrid_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
try
{
double moneys = 0, rMoneys = 0, hospitalredeem = 0, fundredeem = 0, secondredeem = 0, mzredeem = 0, cashmoneys = 0, kouchumoney = 0, jsmoney = 0;
if(e.Item.ItemType == ListItemType.AlternatingItem||e.Item.ItemType == ListItemType.Item)
{ //计算总额
DataTable dt = null;
if (resultGrid.DataSource.GetType().Name.ToUpper() == "DATATABLE")
dt = (DataTable)(resultGrid.DataSource);
else if (resultGrid.DataSource.GetType().Name.ToUpper() == "DATAVIEW")
dt = ((DataView)(resultGrid.DataSource)).Table;
for (int i = 0; i < dt.Rows.Count; i++)
{
moneys += double.Parse(dt.Rows[i]["a"].ToString());
rMoneys += double.Parse(dt.Rows[i]["aa"].ToString());
hospitalredeem += double.Parse(dt.Rows[i]["aaa"].ToString());
fundredeem += double.Parse(dt.Rows[i]["x"].ToString());
secondredeem += double.Parse(dt.Rows[i]["xx"].ToString());
mzredeem += double.Parse(dt.Rows[i]["xxx"].ToString());
cashmoneys += double.Parse(dt.Rows[i]["r"].ToString());
kouchumoney += double.Parse(dt.Rows[i]["rr"].ToString());
jsmoney += double.Parse(dt.Rows[i]["rrr"].ToString());
}
}
else if (e.Item.ItemType == ListItemType.Footer)
{
e.Item.Cells[2].Text = "合计";
e.Item.Cells[3].Text = moneys.ToString("#,##0.00");
e.Item.Cells[4].Text = rMoneys.ToString("#,##0.00");
e.Item.Cells[5].Text = hospitalredeem.ToString("#,##0.00");
e.Item.Cells[6].Text = fundredeem.ToString("#,##0.00");
e.Item.Cells[7].Text = secondredeem.ToString("#,##0.00");
e.Item.Cells[8].Text = mzredeem.ToString("#,##0.00");
e.Item.Cells[9].Text = cashmoneys.ToString("#,##0.00");
e.Item.Cells[10].Text = kouchumoney.ToString("#,##0.00");
e.Item.Cells[11].Text = jsmoney.ToString("#,##0.00");
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货