test13.frm

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

VERSION 5.00
Begin VB.Form test13 
   Caption         =   "Form1"
   ClientHeight    =   3435
   ClientLeft      =   60
   ClientTop       =   420
   ClientWidth     =   5865
   LinkTopic       =   "Form1"
   ScaleHeight     =   3435
   ScaleWidth      =   5865
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command1 
      Caption         =   "删除商品记录"
      Height          =   615
      Left            =   1560
      TabIndex        =   9
      Top             =   2520
      Width           =   1455
   End
   Begin VB.TextBox Text1 
      Enabled         =   0   'False
      Height          =   375
      Index           =   0
      Left            =   1320
      Locked          =   -1  'True
      TabIndex        =   8
      Top             =   120
      Width           =   1215
   End
   Begin VB.TextBox Text1 
      Enabled         =   0   'False
      Height          =   375
      Index           =   1
      Left            =   1320
      TabIndex        =   7
      Top             =   720
      Width           =   1215
   End
   Begin VB.TextBox Text1 
      Enabled         =   0   'False
      Height          =   375
      Index           =   2
      Left            =   1320
      TabIndex        =   6
      Top             =   1320
      Width           =   1215
   End
   Begin VB.TextBox Text1 
      Enabled         =   0   'False
      Height          =   375
      Index           =   3
      Left            =   1320
      TabIndex        =   5
      Top             =   1920
      Width           =   1215
   End
   Begin VB.TextBox Text1 
      Enabled         =   0   'False
      Height          =   375
      Index           =   4
      Left            =   4320
      TabIndex        =   4
      Top             =   120
      Width           =   1215
   End
   Begin VB.TextBox Text1 
      Enabled         =   0   'False
      Height          =   375
      Index           =   5
      Left            =   4320
      TabIndex        =   3
      Top             =   720
      Width           =   1215
   End
   Begin VB.TextBox Text1 
      Enabled         =   0   'False
      Height          =   375
      Index           =   6
      Left            =   4320
      TabIndex        =   2
      Top             =   1320
      Width           =   1215
   End
   Begin VB.TextBox Text1 
      Enabled         =   0   'False
      Height          =   375
      Index           =   7
      Left            =   4320
      TabIndex        =   1
      Top             =   1920
      Width           =   1215
   End
   Begin VB.CommandButton Command2 
      Caption         =   "返   回"
      Height          =   615
      Left            =   3480
      TabIndex        =   0
      Top             =   2520
      Width           =   1335
   End
   Begin VB.Label Label1 
      Caption         =   "商品编号"
      Height          =   375
      Index           =   0
      Left            =   360
      TabIndex        =   17
      Top             =   120
      Width           =   855
   End
   Begin VB.Label Label1 
      Caption         =   "商品名称"
      Height          =   375
      Index           =   1
      Left            =   360
      TabIndex        =   16
      Top             =   720
      Width           =   855
   End
   Begin VB.Label Label1 
      Caption         =   "商品简称"
      Height          =   375
      Index           =   2
      Left            =   360
      TabIndex        =   15
      Top             =   1320
      Width           =   855
   End
   Begin VB.Label Label1 
      Caption         =   "规   格"
      Height          =   375
      Index           =   3
      Left            =   360
      TabIndex        =   14
      Top             =   1920
      Width           =   855
   End
   Begin VB.Label Label1 
      Caption         =   "产   地"
      Height          =   375
      Index           =   4
      Left            =   3240
      TabIndex        =   13
      Top             =   120
      Width           =   855
   End
   Begin VB.Label Label1 
      Caption         =   "单   位"
      Height          =   375
      Index           =   5
      Left            =   3240
      TabIndex        =   12
      Top             =   720
      Width           =   855
   End
   Begin VB.Label Label1 
      Caption         =   "单   价"
      Height          =   375
      Index           =   6
      Left            =   3240
      TabIndex        =   11
      Top             =   1320
      Width           =   855
   End
   Begin VB.Label Label1 
      Caption         =   "库存数量"
      Height          =   375
      Index           =   7
      Left            =   3240
      TabIndex        =   10
      Top             =   1920
      Width           =   855
   End
End
Attribute VB_Name = "test13"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
test1.Adodc1.RecordSource = "delete 商品信息表 where 商品编号=" + Text1(0).Text + ""
With test1.Adodc1.Recordset
If test1.Adodc1.Recordset.RecordCount > 0 Then
MsgBox "确认要删除该条信息吗?", 17, "销售管理系统"
.Delete
.Update
End If
End With
test13.Visible = False
End Sub

Private Sub Command2_Click()
test13.Visible = False

End Sub

Private Sub Form_Load()
Text1(0).Text = sale.Text1(0).Text
Text1(1).Text = sale.Text1(1).Text
Text1(2).Text = sale.Text1(2).Text
Text1(3).Text = sale.Text1(3).Text
Text1(4).Text = sale.Text1(4).Text
Text1(5).Text = sale.Text1(5).Text
Text1(6).Text = sale.Text1(6).Text
Text1(7).Text = sale.Text1(7).Text
End Sub