想从一个字符串中查找最后一个冒号之前的自字符串,c#中没有从右截取字符串这样的函数,正不知道该怎么好的时候,发现有一个函数叫做lastindexof(),嗯,简直太好用啦~ 灭卡卡~~
关于datatable存xml结点,我的想法还是不成熟,之前因为考虑不周出现了本来应该配对的offercode和qty值没能匹配上
昨天试着把一组值存在同一行上,可是判断哪些值是一组可以存在同一行这一点出现了障碍...
现在虽然配对offercode跟qty已经实现了,可是还是有很多问题的... orz
救命啊,谁帮我想一个好点的方法 (┬_┬)
打开一个新网页:
<a href="#" οnclick="window.open('资源地址','','WIDTH=430,height=380 TOP=0 left=350')"><IMG border=0 SRC="图形文件地址"></a>
本页面合计:
代码
private
double
sum
=
0
;
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 " ) + " (元) " ;
} }
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了.
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 " ) + " (元) " ;
} }
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();
}
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();
}
{
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