想从一个字符串中查找最后一个冒号之前的自字符串,c#中没有从右截取字符串这样的函数,正不知道该怎么好的时候,发现有一个函数叫做lastindexof(),嗯,简直太好用啦~ 灭卡卡~~
关于datatable存xml结点,我的想法还是不成熟,之前因为考虑不周出现了本来应该配对的offercode和qty值没能匹配上
昨天试着把一组值存在同一行上,可是判断哪些值是一组可以存在同一行这一点出现了障碍...
现在虽然配对offercode跟qty已经实现了,可是还是有很多问题的... orz
救命啊,谁帮我想一个好点的方法 (┬_┬)
打开一个新网页:
<a href="#" onclick="window.open('资源地址','','WIDTH=430,height=380 TOP=0 left=350')"><IMG border=0 SRC="图形文件地址"></a>
本页面合计:
代码
private double sum = 0;
{
if (e.Row.RowIndex >= 0)
{
sum += Convert.ToDouble(e.Row.Cells[6].Text.Replace("¥", ""));
}
else if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[0].Text = "合计:";
e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Right;
e.Row.Cells[1].Text = sum.ToString("C");
e.Row.Cells[1].HorizontalAlign = HorizontalAlign.Right;
e.Row.Cells[0].ColumnSpan = 5;
e.Row.Cells[1].Text = sum.ToString("C")+"(元)";
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowIndex >= 0)
{
sum += Convert.ToDouble(e.Row.Cells[6].Text.Replace("¥", ""));
}
else if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[0].Text = "合计:";
e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Right;
e.Row.Cells[1].Text = sum.ToString("C");
e.Row.Cells[1].HorizontalAlign = HorizontalAlign.Right;
e.Row.Cells[0].ColumnSpan = 5;
e.Row.Cells[1].Text = sum.ToString("C")+"(元)";
} }
如果从数据库直接取出sum
代码
面是本页的一改ok了.
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[0].Text = "合计:";
e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Right;
e.Row.Cells[1].Text = sum.ToString("C");
e.Row.Cells[1].HorizontalAlign = HorizontalAlign.Right;
e.Row.Cells[0].ColumnSpan = 5;
e.Row.Cells[1].Text = sum.ToString("C")+"(元)";
private double sum = 数据库中取出赋值;
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[0].Text = "合计:";
e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Right;
e.Row.Cells[1].Text = sum.ToString("C");
e.Row.Cells[1].HorizontalAlign = HorizontalAlign.Right;
e.Row.Cells[0].ColumnSpan = 5;
e.Row.Cells[1].Text = sum.ToString("C")+"(元)";
} }
可是我不想单个页面核计,我需要所有页面的总合计每个页面都列出这个总计的值。
因为不想另写sql,于是改写了一下
偶滴代码
protected void grdView_RealtimeSaves_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (Saves_searchFlag) //用来控制只核计累加一遍,而不要没翻一页就翻倍累加一遍 - =
{
DataRowView drv = (DataRowView)e.Row.DataItem;
if (hidtotal_SavesSale.Value == "")
{
hidtotal_SavesSale.Value = (Convert.ToDouble(drv[3].ToString())).ToString();
}
else
{
hidtotal_SavesSale.Value = (Convert.ToDouble(hidtotal_SavesSale.Value) + Convert.ToDouble(drv[3].ToString())).ToString();
}
{
hidtotal_SavesShip.Value = (Convert.ToDouble(drv[4].ToString())).ToString();
}
else
{
hidtotal_SavesShip.Value = (Convert.ToDouble(hidtotal_SavesShip.Value) + Convert.ToDouble(drv[4].ToString())).ToString();
}
}
}
{
Saves_searchFlag = false; //加载过一次咯~ false掉~
e.Row.Cells[0].Text = "Total:";
e.Row.Cells[3].Text = "$" + hidtotal_SavesSale.Value;
e.Row.Cells[4].Text = "$" + hidtotal_SavesShip.Value;
e.Row.Cells[3].HorizontalAlign = HorizontalAlign.Right;
e.Row.Cells[4].HorizontalAlign = HorizontalAlign.Right;
}
} protected void btnSearch_Click(object sender, EventArgs e)
{
hidtotal_SavesSale.Value = "";
hidtotal_SavesShip.Value = "";
Saves_searchFlag = true;
grdView_RealtimeSaves_BindGrd();
}
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
if (Saves_searchFlag) //用来控制只核计累加一遍,而不要没翻一页就翻倍累加一遍 - =
{
DataRowView drv = (DataRowView)e.Row.DataItem;
if (hidtotal_SavesSale.Value == "")
{
hidtotal_SavesSale.Value = (Convert.ToDouble(drv[3].ToString())).ToString();
}
else
{
hidtotal_SavesSale.Value = (Convert.ToDouble(hidtotal_SavesSale.Value) + Convert.ToDouble(drv[3].ToString())).ToString();
}
if (hidtotal_SavesShip.Value == "")
{
hidtotal_SavesShip.Value = (Convert.ToDouble(drv[4].ToString())).ToString();
}
else
{
hidtotal_SavesShip.Value = (Convert.ToDouble(hidtotal_SavesShip.Value) + Convert.ToDouble(drv[4].ToString())).ToString();
}
}
}
if (e.Row.RowType == DataControlRowType.Footer)
{
Saves_searchFlag = false; //加载过一次咯~ false掉~
e.Row.Cells[0].Text = "Total:";
e.Row.Cells[3].Text = "$" + hidtotal_SavesSale.Value;
e.Row.Cells[4].Text = "$" + hidtotal_SavesShip.Value;
e.Row.Cells[3].HorizontalAlign = HorizontalAlign.Right;
e.Row.Cells[4].HorizontalAlign = HorizontalAlign.Right;
}
} protected void btnSearch_Click(object sender, EventArgs e)
{
hidtotal_SavesSale.Value = "";
hidtotal_SavesShip.Value = "";
Saves_searchFlag = true;
grdView_RealtimeSaves_BindGrd();
}
http://curare.blog.163.com/blog/static/881144220083240321126/
用js在footer加上某欄的Total合計
http://www.dotblogs.com.tw/hatelove/archive/2008/12/25/6532.aspx