Foxtable(狐表)用户栏目专家坐堂 → datacolchange的问题,单行更改沒问题,整列刷新出错-已解決


  共有4926人关注过本帖树形打印复制链接

主题:datacolchange的问题,单行更改沒问题,整列刷新出错-已解決

帅哥哟,离线,有人找我吗?
don
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:八尾狐 帖子:1812 积分:12993 威望:0 精华:14 注册:2008/10/11 18:07:00
  发帖心情 Post By:2013/5/19 7:00:00 [显示全部帖子]

If e.DataCol.Name = "款类" Then
    Dim nms() As String = { "开胚","跟形","跟重","网底","手工序","通花","瓜子耳","跟电雕" }  
    Dim dt As  DataRowe.DataRow
    Dim LVS As String = dt("级別")  
    If e.NewValue Is Nothing Then
        dt("A") = Nothing
    Else
        dt("A") = Nothing 
        For Each nm As String In nms
            Dim col As String = dt(nm)          
            dt("A") = dt("A") + DataTables("工价1").Compute( "sum(" & nm & LVS &  ")*" & col ,"[款类] = '" & e.NewValue & "'")  
        Next
        dt("A") = dt("A") + dt("加收_工值")
    End If
End If

 回到顶部