frmse_del.frm

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

VERSION 5.00
Begin VB.Form frmSe_Del 
   Caption         =   "销售信息删除"
   ClientHeight    =   2925
   ClientLeft      =   120
   ClientTop       =   420
   ClientWidth     =   4290
   LinkTopic       =   "Form1"
   ScaleHeight     =   2925
   ScaleWidth      =   4290
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton cmdExit 
      Caption         =   "返回(&R)"
      Height          =   375
      Left            =   2400
      TabIndex        =   6
      Top             =   2280
      Width           =   975
   End
   Begin VB.CommandButton cmdSave 
      Caption         =   "保存(&S)"
      Height          =   375
      Left            =   840
      TabIndex        =   5
      Top             =   2280
      Width           =   975
   End
   Begin VB.Frame fraInfo 
      Caption         =   "商品信息"
      Height          =   1575
      Left            =   360
      TabIndex        =   0
      Top             =   360
      Width           =   3612
      Begin VB.TextBox txtCus 
         Height          =   390
         Left            =   1440
         TabIndex        =   2
         Top             =   840
         Width           =   1815
      End
      Begin VB.TextBox txtName 
         Height          =   390
         Left            =   1440
         TabIndex        =   1
         Top             =   240
         Width           =   1815
      End
      Begin VB.Label lblFields 
         AutoSize        =   -1  'True
         Caption         =   "顾客名称："
         Height          =   180
         Index           =   1
         Left            =   240
         TabIndex        =   4
         Top             =   840
         Width           =   900
      End
      Begin VB.Label lblFields 
         AutoSize        =   -1  'True
         Caption         =   "商品名称："
         Height          =   180
         Index           =   0
         Left            =   240
         TabIndex        =   3
         Top             =   360
         Width           =   900
      End
   End
End
Attribute VB_Name = "frmSe_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
C_Name = txtCus.Text

gConn.Execute "delete from sell where 商品名称='" & P_Name & " 'and 顾客名称= '" & C_Name & " ' "
MsgBox "操作已成功!", vbOKOnly

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

End Sub