frmstock1.frm

一个贸易公司的管理信息系统 我的毕业设计

VERSION 5.00
Begin VB.Form frmStock1 
   Caption         =   "进货信息"
   ClientHeight    =   5148
   ClientLeft      =   48
   ClientTop       =   348
   ClientWidth     =   6912
   LinkTopic       =   "Form1"
   ScaleHeight     =   5148
   ScaleWidth      =   6912
   StartUpPosition =   1  'CenterOwner
   Begin VB.TextBox proText 
      Height          =   270
      Left            =   2160
      TabIndex        =   27
      TabStop         =   0   'False
      Top             =   5160
      Visible         =   0   'False
      Width           =   735
   End
   Begin VB.TextBox supText 
      Height          =   270
      Left            =   1320
      TabIndex        =   22
      TabStop         =   0   'False
      Top             =   5160
      Visible         =   0   'False
      Width           =   735
   End
   Begin VB.Frame Frame2 
      Caption         =   "商品信息"
      Height          =   1812
      Left            =   3360
      TabIndex        =   18
      Top             =   120
      Width           =   3372
      Begin VB.ComboBox cboItem 
         Height          =   288
         Index           =   5
         Left            =   1320
         Style           =   2  'Dropdown List
         TabIndex        =   5
         Top             =   1320
         Width           =   1812
      End
      Begin VB.ComboBox cboItem 
         Height          =   288
         Index           =   4
         Left            =   1320
         Style           =   2  'Dropdown List
         TabIndex        =   4
         Top             =   840
         Width           =   1812
      End
      Begin VB.ComboBox cboItem 
         Height          =   288
         Index           =   3
         Left            =   1320
         Style           =   2  'Dropdown List
         TabIndex        =   3
         Top             =   360
         Width           =   1812
      End
      Begin VB.Label Label2 
         Caption         =   "计量单位："
         Height          =   252
         Index           =   5
         Left            =   240
         TabIndex        =   21
         Top             =   1320
         Width           =   972
      End
      Begin VB.Label Label2 
         Caption         =   "商品规格："
         Height          =   252
         Index           =   4
         Left            =   240
         TabIndex        =   20
         Top             =   840
         Width           =   972
      End
      Begin VB.Label Label2 
         Caption         =   "商品名称："
         Height          =   252
         Index           =   3
         Left            =   240
         TabIndex        =   19
         Top             =   360
         Width           =   972
      End
   End
   Begin VB.TextBox txtNo 
      Height          =   270
      Left            =   480
      TabIndex        =   17
      TabStop         =   0   'False
      Top             =   5160
      Visible         =   0   'False
      Width           =   735
   End
   Begin VB.Frame Frame3 
      Caption         =   "进货信息"
      Height          =   2412
      Left            =   120
      TabIndex        =   16
      Top             =   2040
      Width           =   6612
      Begin VB.TextBox txtItem 
         Height          =   1080
         Index           =   3
         Left            =   120
         MultiLine       =   -1  'True
         ScrollBars      =   2  'Vertical
         TabIndex        =   9
         Top             =   1200
         Width           =   6252
      End
      Begin VB.TextBox txtItem 
         Height          =   270
         Index           =   2
         Left            =   1080
         MaxLength       =   20
         TabIndex        =   8
         Top             =   600
         Width           =   2172
      End
      Begin VB.TextBox txtItem 
         Height          =   270
         Index           =   1
         Left            =   4440
         MaxLength       =   20
         TabIndex        =   7
         Top             =   240
         Width           =   1932
      End
      Begin VB.TextBox txtItem 
         Height          =   270
         Index           =   0
         Left            =   1080
         MaxLength       =   20
         TabIndex        =   6
         Top             =   240
         Width           =   2172
      End
      Begin VB.Label Label2 
         Caption         =   "备注信息："
         Height          =   252
         Index           =   8
         Left            =   120
         TabIndex        =   26
         Top             =   960
         Width           =   852
      End
      Begin VB.Label Label2 
         Caption         =   "数        量："
         Height          =   252
         Index           =   7
         Left            =   120
         TabIndex        =   25
         Top             =   240
         Width           =   852
      End
      Begin VB.Label Label2 
         Caption         =   "单        价："
         Height          =   252
         Index           =   6
         Left            =   3480
         TabIndex        =   24
         Top             =   240
         Width           =   852
      End
      Begin VB.Label Label2 
         Caption         =   "进货日期："
         Height          =   252
         Index           =   2
         Left            =   120
         TabIndex        =   23
         Top             =   600
         Width           =   852
      End
   End
   Begin VB.Frame Frame1 
      Caption         =   "供货商信息"
      Height          =   1812
      Index           =   0
      Left            =   120
      TabIndex        =   12
      Top             =   120
      Width           =   3132
      Begin VB.ComboBox cboItem 
         Height          =   288
         Index           =   2
         Left            =   1080
         Style           =   2  'Dropdown List
         TabIndex        =   2
         Top             =   1320
         Width           =   1812
      End
      Begin VB.ComboBox cboItem 
         Height          =   288
         Index           =   1
         Left            =   1080
         Style           =   2  'Dropdown List
         TabIndex        =   1
         Top             =   840
         Width           =   1812
      End
      Begin VB.ComboBox cboItem 
         Height          =   288
         Index           =   0
         Left            =   1080
         Style           =   2  'Dropdown List
         TabIndex        =   0
         Top             =   360
         Width           =   1812
      End
      Begin VB.Label Label2 
         Caption         =   "联系电话："
         Height          =   252
         Index           =   1
         Left            =   120
         TabIndex        =   15
         Top             =   1320
         Width           =   972
      End
      Begin VB.Label Label2 
         Caption         =   "公司名称："
         Height          =   252
         Index           =   0
         Left            =   120
         TabIndex        =   14
         Top             =   360
         Width           =   972
      End
      Begin VB.Label Label2 
         Caption         =   "联系人姓名："
         Height          =   252
         Index           =   16
         Left            =   120
         TabIndex        =   13
         Top             =   840
         Width           =   972
      End
   End
   Begin VB.CommandButton cmdExit 
      Caption         =   "返回 (&X)"
      Height          =   375
      Left            =   4320
      TabIndex        =   11
      Top             =   4680
      Width           =   1215
   End
   Begin VB.CommandButton cmdSave 
      Caption         =   "保存 (&S)"
      Height          =   375
      Left            =   2880
      TabIndex        =   10
      Top             =   4680
      Width           =   1215
   End
End
Attribute VB_Name = "frmStock1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
'是否改动过记录，ture为改过
Dim mblChange As Boolean
Public txtSQL As String
Dim goodsNum As Integer


Private Sub cboItem_Change(Index As Integer)
    '有变化设置gblchange
    mblChange = True
End Sub


Private Sub cboItem_Click(Index As Integer)
    Dim mrc As ADODB.Recordset
    Dim mrcd As ADODB.Recordset
    Dim MsgText As String
    Dim intCount As Integer