Foxtable(狐表)用户栏目专家坐堂 → [求助]不知哪不对


  共有1758人关注过本帖平板打印复制链接

主题:[求助]不知哪不对

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


加好友 发短信
等级:四尾狐 帖子:972 积分:7048 威望:0 精华:0 注册:2013/3/31 10:33:00
[求助]不知哪不对  发帖心情 Post By:2017/6/26 16:08:00 [只看该作者]

Dim cmd As New SQLCommand
Dim dt As DataTable
cmd.C
cmd.CommandText = "SELECT [_Identify],请购编号,名称规格,单位,编号,报销 FRO M {物资入库} Where [报销] = False "
dt = cmd.ExecuteReader(True)

If MsgBox("确认提交保存?",65,"提示") = 1 Then
    Dim a As Table = Tables("费用管理_Table3")
    Dim b As Table = Tables("入账报销")
    Dim dr1 As DataRow
    For r As Integer = 0 To a.Rows.Count - 1
        b.AddNew
        b.Current("经办") = _username
        b.Current("物料编码") = a.Rows(r)("物料编码")
        b.Current("名称规格") = a.Rows(r)("名称规格")
        ......
        b.Current("备注") = a.Rows(r)("备注")
        b.Current("入库ID") = a.Rows(r)("入库ID")
       
        If a.Rows(r)("入库ID") IsNot Nothing Then
            dr1 = dt.Find("[编号] = '" & a.Rows(r)("入库ID") & "' ")
            dr1("报销") = True
        End If
    Next
    dt.Save()
    For r As Integer = a.rows.Count - 1 To 0 Step -1
        a.Current.Delete
    Next
    DataTables("入账报销").Save()
End If


 回到顶部