frmchange.frm

VB城市排水系统

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.Form frmchange 
   Caption         =   "Form1"
   ClientHeight    =   2985
   ClientLeft      =   5250
   ClientTop       =   4560
   ClientWidth     =   4680
   LinkTopic       =   "Form1"
   ScaleHeight     =   2985
   ScaleWidth      =   4680
   Begin VB.CommandButton Command3 
      Caption         =   "设置密码"
      Enabled         =   0   'False
      Height          =   330
      Left            =   3555
      TabIndex        =   3
      Top             =   2430
      Width           =   960
   End
   Begin VB.CommandButton Command2 
      Caption         =   "删除"
      Height          =   330
      Left            =   2520
      TabIndex        =   2
      Top             =   2430
      Width           =   960
   End
   Begin VB.CommandButton Command1 
      Caption         =   "添加"
      Height          =   330
      Left            =   1485
      TabIndex        =   1
      Top             =   2430
      Width           =   960
   End
   Begin MSComctlLib.ListView ListView1 
      Height          =   1995
      Left            =   135
      TabIndex        =   0
      Top             =   180
      Width           =   4380
      _ExtentX        =   7726
      _ExtentY        =   3519
      View            =   3
      LabelWrap       =   -1  'True
      HideSelection   =   0   'False
      HotTracking     =   -1  'True
      _Version        =   393217
      ForeColor       =   -2147483640
      BackColor       =   -2147483643
      BorderStyle     =   1
      Appearance      =   1
      NumItems        =   0
   End
End
Attribute VB_Name = "frmchange"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub Command1_Click()
pwdinput.Show
End Sub

Private Sub Command2_Click()
'删除数据库中列表选取项
Set adopwdrs = New Recordset
adopwdrs.Open "select * from 系统登录 ", dbpwd, adOpenStatic, adLockOptimistic
adopwdrs.MoveFirst
Do Until adopwdrs.EOF
    If adopwdrs!用户 = ListView1.SelectedItem.Text Then
    Exit Do
    End If
    adopwdrs.MoveNext
Loop
adopwdrs.Delete
If adopwdrs.EOF Then adopwdrs.MoveLast
'删除列表中选取项
ListView1.ListItems.Remove (ListView1.SelectedItem.Index)
End Sub

Private Sub Command3_Click()
frmpwd.Show '修改密码
End Sub

Private Sub Form_Load()
'初始化listview1控件
Dim columheaderx As ColumnHeader
Set columheaderx = ListView1.ColumnHeaders.Add(, , "用户", ListView1.Width / 3)
Set columheaderx = ListView1.ColumnHeaders.Add(, , "权限", ListView1.Width / 3)
Set columheaderx = ListView1.ColumnHeaders.Add(, , "其它", ListView1.Width / 3)
'显示数据库中的用户记录
Set dbpwd = New Connection
dbpwd.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=" & App.Path & "\db1.mdb;"
Set adopwdrs = New Recordset
adopwdrs.Open "select * from 系统登录 ", dbpwd, adOpenStatic, adLockOptimistic
Dim listitemx As ListItem
Dim listsubitemx As ListSubItem
Dim intindex As Integer
Do Until adopwdrs.EOF
intindex = intindex + 1
Set listitemx = ListView1.ListItems.Add(, , adopwdrs!用户)
Set listsubitemx = ListView1.ListItems(intindex).ListSubItems.Add(, , adopwdrs!权限)
adopwdrs.MoveNext
Loop
ListView1.SelectedItem.Checked = 1
'判断用户权限
If accessflag = "guest" Then
Command1.Enabled = False
Command2.Enabled = False
End If
End Sub

Private Sub ListView1_ItemClick(ByVal Item As MSComctlLib.ListItem)
'由用户权限，判断是否可以修改密码
If ListView1.SelectedItem.Text = sBuffer Then
Command3.Enabled = True
Else
Command3.Enabled = False
End If
End Sub