Rss & SiteMap

Foxtable(狐表) http://www.foxtable.com

新一代数据库软件,完美融合Access、Foxpro、Excel、vb.net之优势,人人都能掌握的快速软件开发工具!
共3 条记录, 每页显示 10 条, 页签: [1]
[浏览完整版]

标题:怪,又出错

1楼
小狐 发表于:2010/10/15 21:46:00

DataColChanged:

 

Dim dr As DataRow = e.DataRow
Select Case e.DataCol.Name
    Case "客户名称"
        If dr.IsNull("客户名称") Then
            Return
        Else
            dr("客户拼音") = getpy(dr("客户名称"),True)
        End If
    Case "联系人"
        If dr.IsNull("联系人") Then
            Return
        Else
            dr("客户拼音") =getpy(dr("客户名称"),True) & getpy(dr("联系人"),True)
        End If
    Case "所属_省市"
        dr("所属_市") = Nothing
        dr("所属_县市") = Nothing
    Case "所属_市"
        dr("所属_县市") = Nothing
    Case "所属_县市"
        Dim kfdm As String
        Dim xlh As Integer
        Dim kfdmdata As DataRow = DataTables("营销部").Find(" 市场片区_省市 = '" & e.DataRow("所属_省市") & "' and 市场片区_县市 = '" & e.DataRow("所属_县市") &"'")
        kfdm = kfdmdata("市场代码")
        kfdm = kfdm.trim()
        Dim last As new SQLCommand
        Dim last2 As new SQLCommand
        With last
            .ConnectionName =  "销售系统"
            .CommandText = "select [顺序号] from {编号} where [前缀] = '"& kfdm &"' and [表名] = '客户档案'"
        End With
        last2.ConnectionName =   "销售系统"
        Do
            xlh = last.ExecuteScalar()
            With last2
                .CommandText = "update {编号} set [顺序号] = " & ( xlh +1) & " where [前缀] = '" & kfdm & "'and [表名] = '客户档案' "
            End With
            If last2.ExecuteNonQuery() > 0 Then
                Exit Do
            End If
        Loop
        dr("客户简码") = kfdm & "-" & Format(xlh,"0000")
        dr("地址") = dr("所属_省市") & dr("所属_市") & dr("所属_县市")
End Select


图片点击可在新窗口打开查看此主题相关图片如下:11.jpg
图片点击可在新窗口打开查看
2楼
czy 发表于:2010/10/15 22:43:00

加上下面的代码试试

 

If kfdmdata IsNot Nothing Then
    ……
End If

3楼
小狐 发表于:2010/10/16 14:45:00
已解决,为什么会出现这种现象
共3 条记录, 每页显示 10 条, 页签: [1]

Copyright © 2000 - 2018 foxtable.com Tel: 4000-810-820 粤ICP备11091905号

Powered By Dvbbs Version 8.3.0
Processed in .01953 s, 2 queries.