Foxtable(狐表)用户栏目专家坐堂 → 填充数据时有相同的不填充


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

主题:填充数据时有相同的不填充

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


加好友 发短信
等级:小狐 帖子:348 积分:2673 威望:0 精华:0 注册:2018/11/11 15:52:00
  发帖心情 Post By:2023/1/18 15:48:00 [只看该作者]


图片点击可在新窗口打开查看此主题相关图片如下:仓库仓库.png
图片点击可在新窗口打开查看


Dim Cols1() As String = {"仓库名称", "品名", "材质", "规格", "产地", "长度", "库存数量", "库存重量", "车船号", "货位号", "计量方式", "机构", "部门", "日期"}
Dim Cols2() As String = {"仓库名称","品名","材质","规格","产地","长度","库存数量","库存重量","车船号","货位号","入库计量方式","机构","部门","进货日期"}
For Each dr1 As DataRow In DataTables("初始库存明细").Select("仓库名称 is not null")
    Dim dr2 As DataRow = DataTables("现货库存明细").find("品名='" & dr1("品名") & "' and 材质='" & dr1("材质") & "'and 规格='" & dr1("规格") & "' and 产地='" & dr1("产地") & "' and 库存数量=" & dr1("库存数量") & " and 库存重量=" & dr1("库存重量") & " and 车船号='" & dr1("车船号") & "' and 货位号='" & dr1("货位号") & "' and 入库计量方式='" & dr1("计量方式") & "' and 机构='" & dr1("机构") & "' and 部门='" & dr1("部门") & "' and 进货日期=#" & dr1("日期") & "#")
    If dr2 Is Nothing Then
        dr2 = DataTables("现货库存明细").AddNew()
        For i As Integer = 0 To Cols1.Length - 1
            dr2(Cols2(i)) = dr1(Cols1(i))
        Next
    End If
Next

仓库名称不是空的行就复制对吧?现货库存明细没有数据时点按钮一次复制正确,再点按钮初始库存明细没有新数据不用复制。现在没有新增数据的情况下,点下按钮就会复制最后一条数据,要修改代码哪里?


 回到顶部
总数 13 1 2 下一页