editvipt.frm

VB影碟出租系统

VERSION 5.00
Object = "{BDF6FCF6-E2A0-4DA6-8DF8-FA27594705C8}#26.1#0"; "XPControls.ocx"
Object = "{2D8BCEE7-021A-4575-99B6-5E26BF8B6DEE}#1.0#0"; "Form32.ocx"
Begin VB.Form EditVipt 
   BackColor       =   &H00FFFFFF&
   BorderStyle     =   0  'None
   Caption         =   "修改会员级别"
   ClientHeight    =   2640
   ClientLeft      =   0
   ClientTop       =   105
   ClientWidth     =   6135
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2640
   ScaleWidth      =   6135
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  '屏幕中心
   Begin Form32.SkyGzForm SkyGzForm1 
      Height          =   2655
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   6135
      _ExtentX        =   10821
      _ExtentY        =   4683
      Icon            =   "EditVipt.frx":0000
      Begin XPControls.XPButton Command2 
         Height          =   375
         Left            =   3600
         TabIndex        =   8
         Top             =   1800
         Width           =   1095
         _ExtentX        =   1931
         _ExtentY        =   661
         Caption         =   "取消  "
         BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
      End
      Begin XPControls.XPButton Command1 
         Height          =   375
         Left            =   1200
         TabIndex        =   7
         Top             =   1800
         Width           =   1095
         _ExtentX        =   1931
         _ExtentY        =   661
         Caption         =   "修改  "
         BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
      End
      Begin VB.TextBox Text1 
         Appearance      =   0  'Flat
         Height          =   270
         Index           =   0
         Left            =   840
         TabIndex        =   3
         ToolTipText     =   "会员租借级别"
         Top             =   600
         Width           =   1935
      End
      Begin VB.TextBox Text1 
         Appearance      =   0  'Flat
         Height          =   270
         Index           =   1
         Left            =   3840
         TabIndex        =   2
         ToolTipText     =   "会员租借的费用"
         Top             =   600
         Width           =   1935
      End
      Begin VB.TextBox Text1 
         Appearance      =   0  'Flat
         Height          =   270
         Index           =   2
         Left            =   840
         TabIndex        =   1
         ToolTipText     =   "会员可租借的张数"
         Top             =   1200
         Width           =   1935
      End
      Begin VB.Label Label1 
         Appearance      =   0  'Flat
         BackColor       =   &H80000005&
         BackStyle       =   0  'Transparent
         Caption         =   "级别："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H80000008&
         Height          =   255
         Index           =   0
         Left            =   240
         TabIndex        =   6
         Top             =   600
         Width           =   735
      End
      Begin VB.Label Label1 
         Appearance      =   0  'Flat
         BackColor       =   &H80000005&
         BackStyle       =   0  'Transparent
         Caption         =   "费用："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H80000008&
         Height          =   255
         Index           =   1
         Left            =   3240
         TabIndex        =   5
         Top             =   600
         Width           =   735
      End
      Begin VB.Label Label1 
         Appearance      =   0  'Flat
         BackColor       =   &H80000005&
         BackStyle       =   0  'Transparent
         Caption         =   "张数："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H80000008&
         Height          =   255
         Index           =   2
         Left            =   240
         TabIndex        =   4
         Top             =   1200
         Width           =   735
      End
   End
End
Attribute VB_Name = "EditVipt"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'Download by http://www.codefans.net
Option Explicit
Dim Tmpv As String
Private Sub Command1_Click()
Dim SQL As String
Dim i As Integer
For i = 0 To 2
    If Text1(i).Text = "" Then
         MsgBox "对不起！" & Label1(i).Caption & "不能为空！", vbInformation + vbOKOnly, "警告"
         Text1(i).SetFocus
         Exit Sub
    End If
Next

SQL = "update  viptype set 会员级别=""" & Text1(0).Text & """,会员交费=" & Text1(1).Text & ",可借碟片=" & Text1(2).Text & " where 自动ID= " & Tmpv & ""

OpenDBFile

gCon.Execute SQL

CloseDBFile
VipType.Adodc1.Refresh
MsgBox "会员租借级别修改成功，按取消按钮返回！", vbInformation + vbOKOnly, "提示"
Unload Me
End Sub

Private Sub Command2_Click()
Unload Me
End Sub

Private Sub Form_Load()
Dim i As Integer
For i = 1 To 3
    VipType.DataGrid1.Col = i
    Text1(i - 1).Text = VipType.DataGrid1.Text
Next
VipType.DataGrid1.Col = 0
Tmpv = VipType.DataGrid1.Text

SkyGzForm1.Caption = Me.Caption
SkyGzForm1.hWnd = Me.hWnd
End Sub

Private Sub Form_Resize()
SkyGzForm1.Left = 0
SkyGzForm1.Top = 0
Me.Width = SkyGzForm1.Width - 5
Me.Height = SkyGzForm1.Height
Call SkyGzForm1.SetRgn(Me, 5)
End Sub

Private Sub SkyGzForm1_UnloadClick()
Unload Me
End Sub