Foxtable(狐表)用户栏目专家坐堂 → 请问一下,当我“贷款每日进度表”中“最新进度”这一列的值为“放款”时,在“已放款”这个表会自动增加此行,现在的问题是:


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

主题:请问一下,当我“贷款每日进度表”中“最新进度”这一列的值为“放款”时,在“已放款”这个表会自动增加此行,现在的问题是:

帅哥,在线噢!
有点蓝
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:超级版主 帖子:110558 积分:562680 威望:0 精华:9 注册:2015/6/24 9:21:00
  发帖心情 Post By:2018/1/22 17:57:00 [显示全部帖子]

If e.DataCol.Name = "最新进度" AndAlso e.DataRow("最新进度") = "放款" Then
    
    Dim nma() As String = {"进件日期","分类","部门或渠道","客户经理","客户名字","客户手机号","产品名称","期数","进件额度","批款日期","批款额度","放款日期","放款额度","最新进度","备注"} 'A表数据来源列
    
    Dim nmb() As String = {"进件日期","分类","部门或渠道","客户经理","客户名字","客户手机号","产品名称","期数","进件额度","批款日期","批款额度","放款日期","放款额度","最新进度","备注"}'B表数据接收列
    
    Dim dr1 As DataRow = DataTables("已放款").find("客户名字='" & e.DataRow("客户名字") & "'") '自己改为合适的查询条件
    If dr1 Is Nothing Then
        Dim dr As DataRow = DataTables("已放款").AddNew
    End If
    For i As Integer = 0 To nma.Length - 1
        dr(nmb(i)) = e.DataRow(nma(i))
    Next
End If

 回到顶部