test31.frm

这个商品销售管理系统实现了几乎所有的功能,并通过验收

VERSION 5.00
Begin VB.Form test31 
   Caption         =   "Form1"
   ClientHeight    =   3435
   ClientLeft      =   60
   ClientTop       =   420
   ClientWidth     =   8550
   LinkTopic       =   "Form1"
   ScaleHeight     =   3435
   ScaleWidth      =   8550
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command1 
      Caption         =   "保存"
      Height          =   495
      Left            =   2040
      TabIndex        =   21
      Top             =   2640
      Width           =   1575
   End
   Begin VB.CommandButton Command14 
      Caption         =   "退    出"
      Height          =   495
      Left            =   4320
      TabIndex        =   20
      Top             =   2640
      Width           =   1575
   End
   Begin VB.TextBox Text16 
      Height          =   375
      Index           =   0
      Left            =   1080
      TabIndex        =   9
      Top             =   240
      Width           =   1575
   End
   Begin VB.TextBox Text17 
      Height          =   375
      Left            =   1080
      TabIndex        =   8
      Top             =   840
      Width           =   1455
   End
   Begin VB.TextBox Text18 
      Height          =   375
      Left            =   1080
      TabIndex        =   7
      Top             =   1440
      Width           =   1455
   End
   Begin VB.TextBox Text19 
      Height          =   375
      Left            =   1080
      TabIndex        =   6
      Top             =   2040
      Width           =   1455
   End
   Begin VB.TextBox Text20 
      Height          =   375
      Left            =   4440
      TabIndex        =   5
      Top             =   120
      Width           =   1215
   End
   Begin VB.TextBox Text21 
      Height          =   375
      Left            =   4440
      TabIndex        =   4
      Top             =   840
      Width           =   1455
   End
   Begin VB.TextBox Text22 
      Height          =   375
      Left            =   4440
      TabIndex        =   3
      Top             =   1440
      Width           =   1815
   End
   Begin VB.TextBox Text23 
      Height          =   375
      Left            =   4440
      TabIndex        =   2
      Top             =   2040
      Width           =   1575
   End
   Begin VB.TextBox Text24 
      Height          =   375
      Left            =   7080
      TabIndex        =   1
      Top             =   240
      Width           =   1215
   End
   Begin VB.TextBox Text25 
      Height          =   375
      Left            =   7080
      TabIndex        =   0
      Top             =   840
      Width           =   1335
   End
   Begin VB.Label Label27 
      Caption         =   "客户编号"
      Height          =   375
      Index           =   0
      Left            =   240
      TabIndex        =   19
      Top             =   240
      Width           =   735
   End
   Begin VB.Label Label28 
      Caption         =   "客户全称"
      Height          =   255
      Left            =   240
      TabIndex        =   18
      Top             =   840
      Width           =   735
   End
   Begin VB.Label Label29 
      Caption         =   "简称"
      Height          =   375
      Left            =   360
      TabIndex        =   17
      Top             =   1320
      Width           =   615
   End
   Begin VB.Label Label30 
      Caption         =   "地址"
      Height          =   375
      Left            =   360
      TabIndex        =   16
      Top             =   2040
      Width           =   495
   End
   Begin VB.Label Label31 
      Caption         =   "电话"
      Height          =   375
      Left            =   3480
      TabIndex        =   15
      Top             =   240
      Width           =   735
   End
   Begin VB.Label Label32 
      Caption         =   "联系人"
      Height          =   375
      Left            =   3240
      TabIndex        =   14
      Top             =   840
      Width           =   975
   End
   Begin VB.Label Label33 
      Caption         =   "联系人电话"
      Height          =   375
      Left            =   3120
      TabIndex        =   13
      Top             =   1440
      Width           =   1095
   End
   Begin VB.Label Label34 
      Caption         =   "应收金额"
      Height          =   375
      Left            =   3360
      TabIndex        =   12
      Top             =   2040
      Width           =   735
   End
   Begin VB.Label Label35 
      Caption         =   "实际欠款"
      Height          =   255
      Left            =   6240
      TabIndex        =   11
      Top             =   240
      Width           =   735
   End
   Begin VB.Label Label36 
      Caption         =   "网址邮箱"
      Height          =   375
      Left            =   6120
      TabIndex        =   10
      Top             =   840
      Width           =   735
   End
End
Attribute VB_Name = "test31"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
test1.Adodc3.RecordSource = "Update 客户信息表 set 客户编号=" + Text16(0).Text + "客户全称=" + Text17.Text + "简称=" + Text18.Text + "地址=" + Text19.Text + "电话=" + Text20.Text + "联系人=" + Text21.Text + "联系人电话=" + Text22.Text + "应收金额=" + Text23.Text + "实际欠款" + Text24.Text + "网址邮箱=" + Text25.Text + ""
With test1.Adodc3.Recordset
If .RecordCount > 0 Then
.Fields("客户编号") = Text16(0).Text
.Fields("客户全称") = Text17.Text
.Fields("简称") = Text18.Text
.Fields("地址") = Text19.Text
.Fields("电话") = Text20.Text
.Fields("联系人") = Text21.Text
.Fields("联系人电话") = Text22.Text
.Fields("应收金额") = Text23.Text
.Fields("实际欠款") = Text24.Text
.Fields("网址邮箱") = Text25.Text

.Update
End If
End With
MsgBox "数据保存成功!!", 32, "销售管理系统"
test31.Visible = False
End Sub

Private Sub Command14_Click()
test31.Visible = False
End Sub