frmauth.frm

一个用VB写的财务软件源码

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.Form frmAuth 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "权限维护"
   ClientHeight    =   6255
   ClientLeft      =   45
   ClientTop       =   615
   ClientWidth     =   10455
   Icon            =   "frmAuth.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   6255
   ScaleWidth      =   10455
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  '屏幕中心
   WhatsThisButton =   -1  'True
   WhatsThisHelp   =   -1  'True
   Begin MSComctlLib.ImageList ilsTvw 
      Left            =   5220
      Top             =   1980
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   16
      ImageHeight     =   16
      MaskColor       =   12632256
      _Version        =   393216
      BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
         NumListImages   =   15
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":0442
            Key             =   "System"
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":0896
            Key             =   "Account"
         EndProperty
         BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":0CEA
            Key             =   "FixedAssets"
         EndProperty
         BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":113E
            Key             =   "Pay"
         EndProperty
         BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":1592
            Key             =   "FinanceReport"
         EndProperty
         BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":18AE
            Key             =   "FinanceAnalysis"
         EndProperty
         BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":1D02
            Key             =   "CashFlow"
         EndProperty
         BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":201E
            Key             =   "MergeReport"
         EndProperty
         BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":28FA
            Key             =   "IncomeAndExpense"
         EndProperty
         BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":2D4E
            Key             =   "LeaderQuery"
         EndProperty
         BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":3068
            Key             =   "Collapse"
         EndProperty
         BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":34BC
            Key             =   "Expand"
         EndProperty
         BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":3910
            Key             =   "UnSelected"
         EndProperty
         BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":3D64
            Key             =   "Selected"
         EndProperty
         BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":41B8
            Key             =   "Labor"
         EndProperty
      EndProperty
   End
   Begin MSComctlLib.ListView lvwAuth 
      Height          =   5655
      Left            =   4080
      TabIndex        =   1
      Top             =   600
      Width           =   6375
      _ExtentX        =   11245
      _ExtentY        =   9975
      LabelEdit       =   1
      LabelWrap       =   -1  'True
      HideSelection   =   0   'False
      FullRowSelect   =   -1  'True
      _Version        =   393217
      ForeColor       =   -2147483640
      BackColor       =   -2147483643
      BorderStyle     =   1
      Appearance      =   1
      NumItems        =   0
   End
   Begin MSComctlLib.TreeView tvwAuth 
      Height          =   5655
      Left            =   15
      TabIndex        =   0
      Top             =   585
      Width           =   4035
      _ExtentX        =   7117
      _ExtentY        =   9975
      _Version        =   393217
      HideSelection   =   0   'False
      LabelEdit       =   1
      Style           =   7
      ImageList       =   "ilsTvw"
      Appearance      =   1
   End
   Begin MSComctlLib.ImageList ImageList1 
      Left            =   1800
      Top             =   1830
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   16
      ImageHeight     =   16
      MaskColor       =   12632256
      _Version        =   393216
      BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
         NumListImages   =   5
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":460C
            Key             =   "Append"
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":4A60
            Key             =   "Delete"
         EndProperty
         BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":4B74
            Key             =   "Modify"
         EndProperty
         BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":4FC6
            Key             =   "Quit"
         EndProperty
         BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmAuth.frx":542E
            Key             =   "Help"
         EndProperty
      EndProperty
   End
   Begin MSComctlLib.Toolbar tBr 
      Align           =   1  'Align Top
      Height          =   570
      Left            =   0
      TabIndex        =   2
      Top             =   0
      Width           =   10455
      _ExtentX        =   18441
      _ExtentY        =   1005
      ButtonWidth     =   820
      ButtonHeight    =   953
      Appearance      =   1
      Style           =   1
      ImageList       =   "ImageList1"
      _Version        =   393216
      BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
         NumButtons      =   6
         BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "添加"
            Key             =   "Append"
            ImageIndex      =   1
         EndProperty
         BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "修改"
            Key             =   "Modify"
            ImageIndex      =   3
         EndProperty
         BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "删除"
            Key             =   "Delete"
            ImageIndex      =   2
         EndProperty
         BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "帮助"
            Key             =   "Help"
            ImageIndex      =   5
         EndProperty
         BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "退出"
            Key             =   "Exit"
            ImageIndex      =   4
         EndProperty
      EndProperty
   End
   Begin VB.Menu mnuTvw 
      Caption         =   "编辑(&E)"
      Begin VB.Menu mnuTvwAppend 
         Caption         =   "添加(&A)"
         Shortcut        =   ^A
      End
      Begin VB.Menu mnuTvwEdit 
         Caption         =   "修改(&E)"
         Shortcut        =   ^E
      End
      Begin VB.Menu mnuTvwDelete 
         Caption         =   "删除(&D)"
         Shortcut        =   ^D
      End
   End
End
Attribute VB_Name = "frmAuth"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Option Base 1

Const m_CFieldName = "AuthID"
Const m_NFieldName = "AuthName"

Dim m_adoRst As ADODB.Recordset

Dim m_bMouseStart As Boolean
Private Sub Form_Initialize()
    m_bMouseStart = False
End Sub


Private Sub Form_Load()
    Dim Nodx As Node
    Dim i As Long
    
    Set m_adoRst = New ADODB.Recordset
    m_adoRst.CursorLocation = adUseClient
    m_adoRst.Open "select * from tSYS_Auth order by AuthID", _
                gloSys.cnnSys, adOpenStatic, adLockReadOnly
    
    glo.frmProg.ShowProgress 0
    glo.frmProg.SetMsg "正在导入权限目录..."
    glo.frmProg.Show
    
    With tvwAuth
        With .Nodes
            Set Nodx = .Add(, , "R", "权限维护", "System")
            Nodx.Bold = True
            Nodx.Expanded = True
            Nodx.Tag = Nodx.Key
            
            Set Nodx = .Add("R", tvwChild, "ZW", "ZW=集成账务", "Account")
            Nodx.Tag = "Account" ' Nodx.Key
            Nodx.Sorted = True
            Nodx.Expanded = True
            Nodx.ForeColor = vbBlue
            Nodx.BackColor = vbInfoBackground
            
            Set Nodx = .Add("R", tvwChild, "BB", "BB=财务报表", "FinanceReport")
            Nodx.Tag = "FinanceReport" ' Nodx.Key
            Nodx.Sorted = True
            Nodx.Expanded = True
            Nodx.ForeColor = vbBlue
            Nodx.BackColor = vbInfoBackground
            
            Set Nodx = .Add("R", tvwChild, "GD", "GD=固定资产", "FixedAssets")
            Nodx.Tag = "FixedAssets" ' Nodx.Key
            Nodx.Sorted = True
            Nodx.Expanded = True
            Nodx.ForeColor = vbBlue
            Nodx.BackColor = vbInfoBackground
            
            Set Nodx = .Add("R", tvwChild, "SF", "SF=应收应付", "IncomeAndExpense")
            Nodx.Tag = "IncomeAndExpense" ' Nodx.Key
            Nodx.Sorted = True
            Nodx.Expanded = True
            Nodx.ForeColor = vbBlue
            Nodx.BackColor = vbInfoBackground
            
            Set Nodx = .Add("R", tvwChild, "FX", "FX=财务分析", "FinanceAnalysis")
            Nodx.Tag = "FinanceAnalysis" ' Nodx.Key
            Nodx.Sorted = True
            Nodx.Expanded = True
            Nodx.ForeColor = vbBlue
            Nodx.BackColor = vbInfoBackground
            
            Set Nodx = .Add("R", tvwChild, "CF", "CF=现金流量表", "CashFlow")
            Nodx.Tag = "CashFlow" ' Nodx.Key
            Nodx.Sorted = True
            Nodx.Expanded = True
            Nodx.ForeColor = vbBlue
            Nodx.BackColor = vbInfoBackground
            
            Set Nodx = .Add("R", tvwChild, "MR", "MR=合并报表", "MergeReport")
            Nodx.Tag = "MergeReport" ' Nodx.Key
            Nodx.Sorted = True
            Nodx.Expanded = True
            Nodx.ForeColor = vbBlue
            Nodx.BackColor = vbInfoBackground
            
            Set Nodx = .Add("R", tvwChild, "GZ", "GZ=工资核算", "Pay")
            Nodx.Tag = "Pay" ' Nodx.Key
            Nodx.Sorted = True
            Nodx.Expanded = True
            Nodx.ForeColor = vbBlue
            Nodx.BackColor = vbInfoBackground
            
'===========Begin  2002-07-22 jack 辅助管理
            Set Nodx = .Add("R", tvwChild, "FZ", "FZ=辅助管理", "IncomeAndExpense")
            Nodx.Tag = "AssistantManager" 'Nodx.Key
            Nodx.Sorted = True
            Nodx.Expanded = True
            Nodx.ForeColor = vbBlue
            Nodx.BackColor = vbInfoBackground
            

            Set Nodx = .Add("R", tvwChild, "CX", "CX=领导查询", "LeaderQuery")
            Nodx.Tag = "LeaderQuery" 'Nodx.Key
            Nodx.Sorted = True
            Nodx.Expanded = True
            Nodx.ForeColor = vbBlue