gridview1:
date shipID departmentID worktypeID actualHour_today actualWeight_today
2008-4-5 0:00:00 200804 01 0101 23 34
2008-4-10 0:00:00 200804 01 0101 11 23
2008-4-15 0:00:00 200804 01 0101 33 45
gridview2:
year month shipID departmentID worktypeID actualHour_current actualWeight_current
2008 4 200804 01 0101 67 102计算结果存在table.stat中:
date shipID departmentID worktypeID actualHour_current actualWeight_current
2008-4-1 0:00:00 200804 01 0101 67 102
gridview1 是由collection的table根据date\shipID\departmentID\worktypeID查询得到的
date shipID departmentID worktypeID actualHour_today actualWeight_today
2008-4-5 0:00:00 200804 01 0101 23 34
2008-4-10 0:00:00 200804 01 0101 11 23
2008-4-15 0:00:00 200804 01 0101 33 45
gridview2:
year month shipID departmentID worktypeID actualHour_current actualWeight_current
2008 4 200804 01 0101 67 102计算结果存在table.stat中:
date shipID departmentID worktypeID actualHour_current actualWeight_current
2008-4-1 0:00:00 200804 01 0101 67 102
gridview1 是由collection的table根据date\shipID\departmentID\worktypeID查询得到的
解决方案 »
- winform 项目重新生成项目提示“生成此程序集的运行时比当前加载的运行时新,无法加载此程序集 ”
- 为何添加新纪录是长文本字段不能够写入ACCESS数据库
- 谁帮我把这个DES加密代码改为C#的,高分相赠!!!
- 大家现在搞C#的薪水多少啊?
- 请问大侠们TextBox.Text怎么转换为datetime类型
- 请教:C#的联合怎么声明,如何使用?
- 求一个正则表达式,取出.....<table height="59" cellSpacing="0">.....</table>.....中的内容。
- 给定了字符串指针及字符串长度,如何取得这个字符串的值?
- 问C#中Socket的Send和BeginSend的区别????
- 如何判断一个windows窗体是否已存在?
- 什么是 值按位组合
- Windows服务
double dd = 0;
double dh = 0;
DataTable tranDT=new DataTable ();
tranDT = BindDataWithSNToDataTable(DealOID.Value, out dd, out dh);
foreach (DataRow dr in dt2.Rows)
{
DataRow r = tranDT.NewRow();
r["TSN"]=dr["TSN"];
r["TOID"] = dr["TOID"];
r["POID"] = dr["POID"];
r["TSubTotal"] = dr["TSubTotal"];
r["TCheckScore"] = dr["TCheckScore"];
r["TLTotal"] = dr["TLTotal"];
r["PSN"] = dr["PSN"];
r["PCompanyName"] = dr["PCompanyName"];
r["PSubTotal"] = dr["PSubTotal"];
r["PDCheckScore"] = dr["PDCheckScore"];
r["PPCheckScore"] = dr["PPCheckScore"];
r["PLCheckScore"] = dr["PLCheckScore"];
r["PLTotal"] = dr["PLTotal"];
r["TPSN"] = dr["TPSN"];
r["PPSN"] = dr["PPSN"];
r["PCSN"] = dr["PCSN"];
tranDT.Rows.Add(r);
}
transD = 0;
deliverD = 0;
//dt2.Rows.CopyTo(tranDT.Rows, 0);
foreach (DataRow r in tranDT.Rows )
{
if (r["TLTotal"].ToString () != null && r["TLTotal"].ToString () != "")
{
transD = transD + Convert.ToDouble(r["TLTotal"]);
}
if (r["PLTotal"].ToString () != null && r["PLTotal"].ToString () != "")
{
deliverD = deliverD + Convert.ToDouble(r["PLTotal"]);
}
}
TransportSignBillSummary.DataSource = tranDT;
TransportSignBillSummary.DataBind();