datagrid 汇总?

lingling82 2004-05-07 05:29:46
杜秀美 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 中能否实现针对每个人实现纵向相加,并添加汇总值?(把杜秀美的最后列相加、、、、、)望各位高手赐教,谢谢!
...全文
50 8 点赞 打赏 收藏 举报
写回复
8 条回复
切换为时间正序
当前发帖距今超过3年,不再开放新的回复
发表回复
伪装绅士 2004-05-09
同意hbzxf(阿好)
  • 打赏
  • 举报
回复
hbzxf 2004-05-09
可以尝试使用DataColumn来解决,看看msdn
  • 打赏
  • 举报
回复
lingling82 2004-05-09
还是没有解决啊!
  • 打赏
  • 举报
回复
shangwg 2004-05-07
类似Excel的分类汇总?
  • 打赏
  • 举报
回复
gwfyjthink 2004-05-07
你可以在存储过程中写。你可以用你的查询出来的数据然后再产生一个表,再梆定。
我看见有人写过这种存储过程。很夸张的!呵呵只是建议啊
  • 打赏
  • 举报
回复
musicllm 2004-05-07
呵呵。你的sql像天书。
  • 打赏
  • 举报
回复
lingling82 2004-05-07
这是我的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 '注塑%')
  • 打赏
  • 举报
回复
vzxq 2004-05-07
能啊,主要是你的 SQL 语句怎么写了。
  • 打赏
  • 举报
回复
相关推荐
发帖
.NET社区
加入

5.9w+

社区成员

.NET技术交流专区
申请成为版主
帖子事件
创建了帖子
2004-05-07 05:29
社区公告
暂无公告