Foxtable(狐表)用户栏目专家坐堂 → 帮忙简化下代码吧


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

主题:帮忙简化下代码吧

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


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

Select Case e.DataCol.name
    Case "零件名称","规格","材质"
        Dim flt As String
        Dim dr As DataRow = e.DataRow
        Dim v1 as String() = {"品名","规格","材质"}
        Dim v2 as String() = {"零件名称","规格","材质"}

        For n1 As Integer = 0 to v2.length-1
            if  dr.Isnull(s1) =False Then
                 flt+ =  " and " & v1(n1) & " = '" & dr(v2(n1)) & "'"
            End if
        next

        If fllt = Nothing Then
            dr("仓库_库位代码") = Nothing
        Else         
            Dim pr As DataRow = DataTables("库存总表").Find(flt.substring(5)) 
            If pr isnot nothing Then  dr("仓库_库位代码") = pr("储位")       
        End If
End Select

 回到顶部