datagrid 汇总？

[lingling82]

杜秀美 440.000 435.000 0.071400 ￥0.00 ￥1.50 ￥0.00 ￥31.42
448.000 448.000 0.071400 ￥0.00 ￥1.50 ￥0.00 ￥31.99
304.000 264.000 0.071400 ￥0.00 ￥1.50 ￥4.50 ￥26.21
208.000 208.000 0.073800 ￥0.00 ￥0.00 ￥9.00 ￥24.35
冯华强 576.000 0 0.034100 ￥0.00 ￥0.00 ￥0.00 ￥19.64
528.000 526.000 0.055800 ￥0.00 ￥1.50 ￥0.00 ￥29.46
522.000 522.000 0.055800 ￥0.00 ￥1.50 ￥0.00 ￥29.13
594.000 594.000 0.055800 ￥0.00 ￥1.50 ￥0.00 ￥33.15
540.000 540.000 0.055800 ￥0.00 ￥0.00 ￥0.00 ￥30.13
冯友良 522.000 522.000 0.055800 ￥0.00 ￥1.50 ￥0.00 ￥29.13
在datagrid 中能否实现针对每个人实现纵向相加，并添加汇总值？（把杜秀美的最后列相加、、、、、）望各位高手赐教，谢谢！

[vzxq]

能啊，主要是你的 SQL 语句怎么写了。

[lingling82]

这是我的SQL语句，我想对每个E37_worker.Wor_name对R8_4_workroom.Workroom_cq，R8_4_workroom.Workroom_ycf，wage求和，怎么实现呢？同时这三项也要求出现
select distinct E37_worker.Wor_name,R8_4_workroom.Wor_type,DM_class.class_name,E4_workroom.Workroom_date,E4_workroom.Workroom_class,R8_4_workroom.Workroom_cq,E1_Material.M_name,R8_4_workroom.Workroom_peo_num,R8_4_workroom.Workroom_good_num,R8_4_workroom.Workroom_pro_price,R8_4_workroom.Workroom_is_add,R8_4_workroom.Workroom_ycf,R8_4_workroom.Workroom_time_s*1.5+R8_4_workroom.Workroom_time_f*2+R8_4_workroom.Workroom_stop_time*3 as wage_stop,R8_4_workroom.Workroom_pro_price*R8_4_workroom.Workroom_peo_num+R8_4_workroom.Workroom_is_add+R8_4_workroom.Workroom_time_s*1.5+R8_4_workroom.Workroom_time_f*2+R8_4_workroom.Workroom_stop_time*3 as wage
from R8_4_workroom,E4_workroom,E37_worker,DM_class,E1_Material
where E4_workroom.Workroom_id=R8_4_workroom.Workroom_id and R8_4_workroom.Wor_id=E37_worker.Wor_id and R8_4_workroom.M_id=E1_Material.M_id and E4_workroom.class_id =DM_class.class_id and E4_workroom.class_id in (select class_id from DM_class where class_name like '注塑%')

[musicllm]

呵呵。你的sql像天书。

[gwfyjthink]

你可以在存储过程中写。你可以用你的查询出来的数据然后再产生一个表，再梆定。
我看见有人写过这种存储过程。很夸张的！呵呵只是建议啊

[shangwg]

类似Excel的分类汇总?

[lingling82]

还是没有解决啊！

[hbzxf]

可以尝试使用DataColumn来解决，看看msdn

[伪装绅士]

同意hbzxf(阿好)