frmst_del.frm

进销存管理系统是基于用户的数据库管理系统

VERSION 5.00
Begin VB.Form frmSt_Del 
   Caption         =   "进货信息删除"
   ClientHeight    =   2910
   ClientLeft      =   120
   ClientTop       =   420
   ClientWidth     =   4290
   LinkTopic       =   "Form1"
   ScaleHeight     =   2910
   ScaleWidth      =   4290
   StartUpPosition =   3  '窗口缺省
   Begin VB.Frame fraInfo 
      Caption         =   "商品信息"
      Height          =   1575
      Left            =   360
      TabIndex        =   2
      Top             =   360
      Width           =   3612
      Begin VB.TextBox txtName 
         Height          =   390
         Left            =   1440
         TabIndex        =   4
         Top             =   240
         Width           =   1815
      End
      Begin VB.TextBox txtPro 
         Height          =   390
         Left            =   1440
         TabIndex        =   3
         Top             =   840
         Width           =   1815
      End
      Begin VB.Label lblFields 
         AutoSize        =   -1  'True
         Caption         =   "商品名称："
         Height          =   180
         Index           =   0
         Left            =   240
         TabIndex        =   6
         Top             =   360
         Width           =   900
      End
      Begin VB.Label lblFields 
         AutoSize        =   -1  'True
         Caption         =   "供应商名称："
         Height          =   180
         Index           =   1
         Left            =   240
         TabIndex        =   5
         Top             =   840
         Width           =   1080
      End
   End
   Begin VB.CommandButton cmdSave 
      Caption         =   "保存(&S)"
      Height          =   375
      Left            =   840
      TabIndex        =   1
      Top             =   2280
      Width           =   975
   End
   Begin VB.CommandButton cmdExit 
      Caption         =   "返回(&R)"
      Height          =   375
      Left            =   2400
      TabIndex        =   0
      Top             =   2280
      Width           =   975
   End
End
Attribute VB_Name = "frmSt_Del"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdSave_Click()
Dim P_Name As String
Dim S_Pra As String

P_Name = txtName.Text
S_Pra = txtPro.Text

gConn.Execute "delete from stock where 商品名称='" & P_Name & " 'and 供应商= '" & S_Pra & " ' "
MsgBox "操作已成功!", vbOKOnly

    '刷新整个FlexGrid
    Unload Me
    Load frmStockList
    frmStockList.SQL = "select * from stock"
    frmStockList.Show

End Sub