Foxtable(狐表)用户栏目专家坐堂 → 为何这两组代码同时放在一起不执行


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

主题:为何这两组代码同时放在一起不执行

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


加好友 发短信
等级:三尾狐 帖子:763 积分:6313 威望:0 精华:0 注册:2011/12/1 14:47:00
  发帖心情 Post By:2012/10/26 10:39:00 [显示全部帖子]

楼主传错附件了:

推测了你的逻辑可能是这样的:

 

Dim dr As DataRow =e.DataRow
Select e.DataCol.Name
    Case "日期","序号"
        If dr.IsNull("日期") OrElse dr.isnull("序号") Then
            dr("编号") = Nothing
        Else
            Dim drs As List(of DataRow) =e.DataTable.Select("日期 =#" & dr("日期") & "# and 序号 ='" & dr("序号") & "'" ,"_Identify")
            Dim i As Integer
            For Each tr As DataRow In drs
                Dim d As Date = tr("日期")
                Dim xh As Integer =tr("序号")
                Dim bh As String =  Format(d,"yyyyMMdd")  & format(xh,"000") '生成编号的前缀
                i =i+1
                tr("编号") = bh & format(i,"000")
            Next
        End If
    Case "机号"
        If dr.IsNull("机号") = False Then
            Dim drs As List (of DataRow) = e.DataTable.Select("[机号] Is null And [ID] < " & e.DataRow("ID") & "")
            For Each dr1 As DataRow In drs
                dr1("机号") = e.NewValue
            Next
        End If
End Select

[此贴子已经被作者于2012-10-26 10:56:42编辑过]

 回到顶部