frmshanchuguanliyuan.frm

VB编程：简单酒店管理系统（SQL版）VB编程：简单酒店管理系统（SQL版）

VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form frmshanchuguanliyuan 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "删除管理员"
   ClientHeight    =   5610
   ClientLeft      =   4350
   ClientTop       =   3270
   ClientWidth     =   3660
   Icon            =   "frmshanchuguanliyuan.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   5610
   ScaleWidth      =   3660
   Begin MSFlexGridLib.MSFlexGrid msfxinxi 
      Height          =   5415
      Left            =   120
      TabIndex        =   4
      Top             =   120
      Width           =   2055
      _ExtentX        =   3625
      _ExtentY        =   9551
      _Version        =   393216
   End
   Begin VB.CommandButton Command2 
      Caption         =   "退出"
      Height          =   375
      Left            =   2400
      TabIndex        =   3
      Top             =   5040
      Width           =   1095
   End
   Begin VB.CommandButton Command1 
      Caption         =   "删除"
      Height          =   375
      Left            =   2400
      TabIndex        =   2
      Top             =   4440
      Width           =   1095
   End
   Begin VB.TextBox txtguanliyuanid 
      Height          =   375
      Left            =   2280
      TabIndex        =   1
      Top             =   3840
      Width           =   1215
   End
   Begin VB.Label Label1 
      Caption         =   "管理员ID"
      Height          =   375
      Left            =   2280
      TabIndex        =   0
      Top             =   3240
      Width           =   1095
   End
End
Attribute VB_Name = "frmshanchuguanliyuan"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
    On Error Resume Next
        If MsgBox("数据删除后将不能恢复，确认要删除当前数据吗？", vbQuestion + vbYesNo, "删除数据") = vbNo Then Exit Sub
        'rct.MoveFirst
        'rct.Filter = "guanliyuan = '" & txtguanliyuanid.Text & "'"
    Dim sqlstr As String
    sqlstr = "select * from guanliyuan where guanliyuan='" & txtguanliyuanid & "'"
    If querydata(sqlstr) = False Then Exit Sub
        rct.MoveFirst
        rct.Delete
        If rct.EOF Then
            rct.MoveFirst
        Else
            rct.MoveNext
        End If
        Call shuaxin
        txtguanliyuanid.Text = ""
End Sub

Private Sub Command2_Click()
    Unload Me
End Sub

Private Sub Form_Load()
Call shuaxin

End Sub

Private Sub shuaxin()
        Dim chaxun As String
    
    If chaxun = Empty Then
    
        chaxun = "select * from guanliyuan"
    End If
    If querydata(chaxun) = True Then
        
    End If
     msfxinxi.Rows = 1
     msfxinxi.Cols = 2
     msfxinxi.Row = 0
     msfxinxi.Col = 0
     msfxinxi.Text = "管理员ID"
     msfxinxi.ColWidth(0) = 800
     msfxinxi.CellAlignment = flexAlignCenterCenter
     msfxinxi.Col = 1
     msfxinxi.Text = "密码"
     msfxinxi.ColWidth(1) = 800
     msfxinxi.CellAlignment = flexAlignCenterCenter
    
     On Error Resume Next
        rct.MoveFirst
        If Err.Number > 0 Then Exit Sub
    Do While Not rct.EOF
         msfxinxi.AddItem (Empty)
         msfxinxi.Row = msfxinxi.Rows - 1
        
         msfxinxi.Col = 0
         msfxinxi.Text = rct.Fields("guanliyuan").Value
        
         msfxinxi.Col = 1
         msfxinxi.Text = rct.Fields("mima").Value
        
        rct.MoveNext
    
    Loop
End Sub