frmuser.frm

业务管理系统。方便业务员跟踪记录客户信息。

VERSION 5.00
Object = "{6B7E6392-850A-101B-AFC0-4210102A8DA7}#1.3#0"; "COMCTL32.OCX"
Begin VB.Form FrmUser 
   Caption         =   "用户"
   ClientHeight    =   4950
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   7950
   LinkTopic       =   "Form1"
   MDIChild        =   -1  'True
   ScaleHeight     =   4950
   ScaleWidth      =   7950
   Begin ComctlLib.ListView ListVw 
      Height          =   2895
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   4560
      _ExtentX        =   8043
      _ExtentY        =   5106
      View            =   3
      LabelWrap       =   -1  'True
      HideSelection   =   -1  'True
      _Version        =   327682
      SmallIcons      =   "ImgList"
      ForeColor       =   -2147483640
      BackColor       =   -2147483643
      BorderStyle     =   1
      Appearance      =   1
      NumItems        =   0
   End
   Begin ComctlLib.ImageList ImgList 
      Left            =   1215
      Top             =   3645
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   16
      ImageHeight     =   16
      MaskColor       =   12632256
      _Version        =   327682
      BeginProperty Images {0713E8C2-850A-101B-AFC0-4210102A8DA7} 
         NumListImages   =   1
         BeginProperty ListImage1 {0713E8C3-850A-101B-AFC0-4210102A8DA7} 
            Picture         =   "FrmUser.frx":0000
            Key             =   ""
         EndProperty
      EndProperty
   End
End
Attribute VB_Name = "FrmUser"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Form_Load()
    
    EButton "000"
    
    GetFrm Me, "User", 1000, 500, 8000, 5000
    
    With ListVW.ColumnHeaders
        .Add , "User", "用户名", GetSetting("Operation", "User", "User", "1500")
        .Add , "Pwd", "密码", GetSetting("Operation", "User", "Pwd", "1000")
        .Add , "Name", "真实性名", GetSetting("Operation", "User", "Name", "1500")
    End With
    
    Dim Rst As New ADODB.Recordset
    Set Rst = Conn.Execute("SELECT User,Pwd,[Name] FROM [User]")
    
    Do While Not Rst.EOF
        With ListVW
            .ListItems.Add , "User" & Rst("User").Value, Rst("User").Value, , 1
            .ListItems("User" & Rst("User").Value).SubItems(1) = Rst("Pwd").Value
            .ListItems("User" & Rst("User").Value).SubItems(2) = Rst("Name").Value
        End With
        Rst.MoveNext
    Loop
    
End Sub

Private Sub Form_Resize()

    With ListVW
        .Width = Me.ScaleWidth
        .Height = Me.ScaleHeight
    End With
    
End Sub

Private Sub Form_Unload(Cancel As Integer)
    
    SaveFrm Me, "User"
    
    With ListVW
        SaveSetting "Operation", "User", "User", .ColumnHeaders("User").Width
        SaveSetting "Operation", "User", "Pwd", .ColumnHeaders("Pwd").Width
        SaveSetting "Operation", "User", "Name", .ColumnHeaders("Name").Width
    End With
    
    EButton "111"
    
End Sub