frm_addcustomernametodatabase.frm

一个公司的客户财产管理系统vb源码

VERSION 5.00
Begin VB.Form frm_AddCustomerNameToDatabase 
   Caption         =   "向Customer_Riches表中添加客户名称字段时，旧数据的客户名称的自动添加"
   ClientHeight    =   3705
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   8325
   LinkTopic       =   "Form1"
   ScaleHeight     =   3705
   ScaleWidth      =   8325
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton cmd_Exit 
      Caption         =   "退出（&Exit）"
      Height          =   495
      Left            =   4477
      TabIndex        =   2
      Top             =   2925
      Width           =   1935
   End
   Begin VB.CommandButton cmd_Ok 
      Caption         =   "开始（&Start）"
      Height          =   495
      Left            =   1912
      TabIndex        =   1
      Top             =   2925
      Width           =   1935
   End
   Begin VB.PictureBox Picture1 
      Appearance      =   0  'Flat
      AutoSize        =   -1  'True
      BackColor       =   &H80000004&
      BorderStyle     =   0  'None
      ForeColor       =   &H80000008&
      Height          =   480
      Left            =   1170
      Picture         =   "frm_AddCustomerNameToDatabase.frx":0000
      ScaleHeight     =   480
      ScaleWidth      =   480
      TabIndex        =   0
      Top             =   285
      Width           =   480
   End
   Begin VB.Line Line1 
      BorderColor     =   &H000000FF&
      X1              =   705
      X2              =   7605
      Y1              =   2685
      Y2              =   2685
   End
   Begin VB.Label Label2 
      Caption         =   $"frm_AddCustomerNameToDatabase.frx":08CA
      ForeColor       =   &H00FF0000&
      Height          =   615
      Left            =   1335
      TabIndex        =   5
      Top             =   1845
      Width           =   5655
   End
   Begin VB.Label Label1 
      Caption         =   "1、在现有的母盘规格单中过滤“订单种类”为“外卖”的订单，并在Customer_Riches中查找此节目"
      ForeColor       =   &H00FF0000&
      Height          =   615
      Left            =   1335
      TabIndex        =   4
      Top             =   1125
      Width           =   5655
   End
   Begin VB.Label Label3 
      Caption         =   "此操作只在初期第一次运行时使用,以后请不要再使用此项功能。在数据的导入过程会因数据量的不同有所变化，请耐心等待......."
      ForeColor       =   &H000000FF&
      Height          =   375
      Left            =   1740
      TabIndex        =   3
      Top             =   345
      Width           =   5415
   End
End
Attribute VB_Name = "frm_AddCustomerNameToDatabase"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmd_Exit_Click()
   Unload Me
End Sub

Private Sub cmd_OK_Click()
On Error GoTo err

    Dim i As Integer
    '1、打开客户财产表
    Dim cnCustomer_Riches As ADODB.Connection
    Dim rsCustomer_Riches As ADODB.Recordset
    Set cnCustomer_Riches = New ADODB.Connection
    Set rsCustomer_Riches = New ADODB.Recordset
    cnCustomer_Riches.Open Cs
    rsCustomer_Riches.Open "select 内编码, 客户名称 from Customer_Riches order by 内编码", cnCustomer_Riches, adOpenKeyset, adLockOptimistic, adCmdText
    For i = 1 To rsCustomer_Riches.RecordCount
        '2、打开地区客户表
        Set Cn_Area = New ADODB.Connection
        Cn_Area.Open Cs
        Set Rs_Area = New ADODB.Recordset
        Rs_Area.Open "select * from Area_Customer where 客户编码 ='" & Left(Trim(rsCustomer_Riches!内编码), 5) & "'", Cn_Area, adOpenKeyset, adLockOptimistic, adCmdText
        If Rs_Area.RecordCount <> 0 Then
          If IsNull(Rs_Area!客户名称) = False Then rsCustomer_Riches!客户名称 = Rs_Area!客户名称
          rsCustomer_Riches.Update
        End If
        Rs_Area.Close
        Cn_Area.Close
        rsCustomer_Riches.MoveNext
    Next
    rsCustomer_Riches.Update
    rsCustomer_Riches.Close
    cnCustomer_Riches.Close