VB开发的ERP系统

            Oper_Bqgzllr.Show 1
                        
            Security_Log "Gdzc_Activities", Xtczybm, 2, False  '用户退出时写上机日志
        
        Case "Gdzc_Depr"                        '本期计提折旧
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Gdzc_Depr_Edit", Xtczybm, 1) Then
                Exit Sub
            End If
            
            Set Rs_Temp = New ADODB.Recordset
            Rs_Temp.Open "select * from gdzc_card", Cw_DataEnvi.DataConnect, adOpenDynamic, adLockOptimistic
            If Rs_Temp.EOF Then
                Tsxx = "资产卡片数目为零!"
                Call Xtxxts(Tsxx, 0, 1)
                Exit Sub
            End If
            Rs_Temp.Close
            Set Rs_Temp = Nothing
            
            Set Rs_Temp = New ADODB.Recordset
            Rs_Temp.Open "select * from gdzc_card where DeprFlag='1'", Cw_DataEnvi.DataConnect, adOpenDynamic, adLockOptimistic
            If Not Rs_Temp.EOF Then
                Tsxx = "本月已经计提折旧,请先恢复计提折旧,或执行月末结帐!"
                Call Xtxxts(Tsxx, 0, 4)
                Exit Sub
            Else
                Oper_Depr.Show 1
            End If
            Rs_Temp.Close
            Set Rs_Temp = Nothing
            
            Security_Log "Gdzc_Depr", Xtczybm, 2, False  '用户退出时写上机日志
        
        Case "Gdzc_ReSet"                       '恢复计提折旧
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Gdzc_ReSet_Edit", Xtczybm, 1) Then
                Exit Sub
            End If
            
            Set Rs_Temp = New ADODB.Recordset
            Rs_Temp.Open "select * from gdzc_card where DeprFlag='0' and [Check-outFlag]='0'", Cw_DataEnvi.DataConnect, adOpenDynamic, adLockOptimistic
            If Not Rs_Temp.EOF Then
                Tsxx = "本月未计提折旧,不用恢复计提折旧!"
                Call Xtxxts(Tsxx, 0, 4)
                Exit Sub
            Else
                Oper_DeprBack.Show 1
            End If
            Security_Log "Gdzc_ReSet", Xtczybm, 2, False  '用户退出时写上机日志
        
        Case "Gdzc_Check-Out"                   '月末结帐
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Gdzc_Check-Out_edit", Xtczybm, 1) Then
                Exit Sub
            End If
            
            Set Rs_Temp = New ADODB.Recordset
            Rs_Temp.Open "select * from gdzc_card", Cw_DataEnvi.DataConnect, adOpenDynamic, adLockOptimistic
            If Rs_Temp.EOF Then
                Tsxx = "资产卡片数目为零!"
                Call Xtxxts(Tsxx, 0, 1)
                Exit Sub
            End If
            Rs_Temp.Close
            Set Rs_Temp = Nothing
            
            Set rstemp = New ADODB.Recordset
            rstemp.Open "select top 1 * from gy_kjrlb where gdzcjzbz='0' ", Cw_DataEnvi.DataConnect, adOpenDynamic, adLockOptimistic
            If rstemp.EOF Then
                Tsxx = "没有新一年的会计日历表!"
                Call Xtxxts(Tsxx, 0, 4)
                Exit Sub
            End If
            rstemp.Close
            Set rstemp = Nothing
            
            Set Rs_Temp = New ADODB.Recordset
            Rs_Temp.Open "select * from gdzc_card where DeprFlag='0' and [Check-outFlag]='0'", Cw_DataEnvi.DataConnect, adOpenDynamic, adLockOptimistic
            If Not Rs_Temp.EOF Then
                Tsxx = "本月未计提折旧,请先执行计提折旧!"
                Call Xtxxts(Tsxx, 0, 4)
                Exit Sub
            Else
                Oper_CheckOut.Show 1
            End If
            Security_Log "Gdzc_Check-Out", Xtczybm, 2, False  '用户退出时写上机日志
        
        Case "Gdzc_FAList"                      '资产清单列表
            Book_CardList.Show
            Book_CardList_Search.Show 1
        Case "Gdzc_VariaList"                   '资产变动报表
            Book_VariList.Show
            Book_Vari_Search.Show 1
        Case "Gdzc_OverList"                    '超龄资产报表
            Book_OverList.Show
        Case "Gdzc_Zz"                          '固定资产总帐
            Book_CheckList.Show
            Book_Check_Search.Show 1
        Case "Gdzc_Part"                        '资产明细报表
            Book_Parti.Show
            Book_Parti_Search.Show 1
        Case "Gdzc_Total"                       '资产统计报表
            Book_Total.Show
            Book_Total_Search.Show 1
        Case "Gdzc_DeprComput"                  '折旧计算报表
            Book_Depr.Show
            Book_Depr_Search.Show 1
        Case "Gdzc_Stru"                        '价值结构分析
            Book_Value.Show
            Book_Value_Search.Show 1
        Case "Gdzc_Kjrl"                        '会计日历
            XT_kjrlFrm.Show 1
        Case "Gdzc_Computer"                    '计算器
            Shell App.Path & "\calc.exe", vbNormalFocus
        Case "Gdzc_SysHelp"                     '系统帮助
            Call F1bz
        Case "Gdzc_Internet"                    '网上华夏新达
            XT_frmBrowser.Show 1
        Case "Gdzc_About"                       '关于我们
            XT_frmAbout.Show
        
    End Select
    
    '用户退出时写上机日志
    Security_Log gnsy, Xtczybm, 2, False
   
    Exit Sub
Cwcl:
    Tsxx = "此项系统功能有待完善!"
    Call Xtxxts(Tsxx, 0, 4)
    Exit Sub

End Sub

Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)        '用户关闭窗体
  
    If Unload_TF = False Then
        Cancel = 1
        Me.WindowState = 1
    End If

End Sub

Private Sub Form_Load()
    
    '设置窗体图标
    Me.Icon = XT_Main.Icon
    
    '设置窗体位置大小,并调入系统功能树
    Me.Left = 0
    Me.Top = 0
    Me.Width = XT_Main.Width - 60
    Me.Height = XT_Main.Height - 760 - 690
    Call Cshgns
    
    '启动调入数据等待提示
    Load Xt_Wait
    
End Sub

Private Sub Form_Unload(Cancel As Integer)
    
    On Error Resume Next
    
    Dim i As Integer
    For i = Forms.count - 1 To 1 Step -1
        Unload Forms(i)
    Next
    If Me.WindowState <> vbMinimized Then
        SaveSetting App.Title, "Settings", "MainLeft", Me.Left
        SaveSetting App.Title, "Settings", "MainTop", Me.Top
        SaveSetting App.Title, "Settings", "MainWidth", Me.Width
        SaveSetting App.Title, "Settings", "MainHeight", Me.Height
    End If
    SaveSetting App.Title, "Settings", "ViewMode", lvListView.View

End Sub

Private Sub Form_Resize()
    
    On Error Resume Next
    If Me.Width < 3000 Then Me.Width = 3000
    SizeControls imgSplitter.Left

End Sub

Private Sub imgSplitter_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)
    
    With imgSplitter
        picSplitter.Move .Left, .Top, .Width \ 2, .Height - 20
    End With
    picSplitter.Visible = True
    mbMoving = True

End Sub

Private Sub imgSplitter_MouseMove(Button As Integer, Shift As Integer, x As Single, y As Single)
    
    Dim sglPos As Single
    If mbMoving Then
        sglPos = x + imgSplitter.Left
        If sglPos < sglSplitLimit Then
            picSplitter.Left = sglSplitLimit
        ElseIf sglPos > Me.Width - sglSplitLimit Then
            picSplitter.Left = Me.Width - sglSplitLimit
        Else
            picSplitter.Left = sglPos
        End If
    End If

End Sub

Private Sub imgSplitter_MouseUp(Button As Integer, Shift As Integer, x As Single, y As Single)
    
    SizeControls picSplitter.Left
    picSplitter.Visible = False
    mbMoving = False
    lvListView.Refresh

End Sub

Private Sub TreeView1_DragDrop(Source As Control, x As Single, y As Single)
    
    If Source = imgSplitter Then
        SizeControls x
    End If

End Sub

Sub SizeControls(x As Single)
    
    On Error Resume Next

    '设置 Width 属性
    If x < 3500 Then x = 3500
    If x > (Me.Width - 1500) Then x = Me.Width - 1500
    tvTreeView.Width = x
    imgSplitter.Left = x
    lvListView.Left = x + 40
    lvListView.Width = Me.Width - (tvTreeView.Width + 140)
    lblTitle(0).Width = tvTreeView.Width
    lblTitle(1).Left = lvListView.Left + 20
    lblTitle(1).Width = lvListView.Width - 40

    '设置 Top 属性

    tvTreeView.Top = tbToolBar.Height + picTitles.Height

    lvListView.Top = tvTreeView.Top

    '设置 height 属性
    tvTreeView.Height = Me.ScaleHeight - (picTitles.Top + picTitles.Height)
    
    lvListView.Height = tvTreeView.Height
    imgSplitter.Top = tvTreeView.Top
    imgSplitter.Height = tvTreeView.Height

End Sub

Private Sub tbToolBar_ButtonClick(ByVal Button As MSComctlLib.Button)
    
    On Error Resume Next
    
    Select Case Button.Key
        Case "返回"
            tvTreeView.SetFocus
              SendKeys "{up}", True
        Case "向前"
             tvTreeView.SetFocus
              SendKeys "{DOWN}", True
        Case "大图标"
            lvListView.View = lvwIcon
        Case "小图标"
            lvListView.View = lvwSmallIcon
        Case "列表"
            lvListView.View = lvwList
        Case "详细资料"
            lvListView.View = lvwReport
    End Select

End Sub

Private Sub lvListView_KeyPress(KeyAscii As Integer)
    
    If KeyAscii = vbKeyReturn Then
        Call lvListView_DblClick
    End If
    
End Sub