企业管理

开发平台：
Visual Basic

：源码内容
							VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "COMDLG32.OCX"
Begin VB.Form Xt_Control 
   Caption         =   "桌面"
   ClientHeight    =   5850
   ClientLeft      =   675
   ClientTop       =   1665
   ClientWidth     =   9240
   Icon            =   "系统_主操作桌面.frx":0000
   LinkTopic       =   "Form1"
   MDIChild        =   -1  'True
   ScaleHeight     =   5850
   ScaleWidth      =   9240
   WindowState     =   2  'Maximized
   Begin VB.PictureBox picSplitter 
      BackColor       =   &H00808080&
      BorderStyle     =   0  'None
      FillColor       =   &H00808080&
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   8.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   4800
      Left            =   4740
      ScaleHeight     =   2090.126
      ScaleMode       =   0  'User
      ScaleWidth      =   780
      TabIndex        =   0
      Top             =   780
      Visible         =   0   'False
      Width           =   72
   End
   Begin MSComctlLib.ImageList ImageList1 
      Left            =   5220
      Top             =   2340
      _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         =   "系统_主操作桌面.frx":08CA
            Key             =   "stb"
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":191C
            Key             =   "xttb"
         EndProperty
         BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":296E
            Key             =   "szk"
         EndProperty
         BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":2D08
            Key             =   "kpgl"
         EndProperty
         BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":3D5A
            Key             =   "gnqx"
         EndProperty
      EndProperty
   End
   Begin MSComctlLib.ListView lvListView 
      Height          =   3375
      Left            =   2160
      TabIndex        =   5
      Top             =   705
      Width           =   2295
      _ExtentX        =   4048
      _ExtentY        =   5953
      Arrange         =   2
      LabelEdit       =   1
      LabelWrap       =   -1  'True
      HideSelection   =   -1  'True
      OLEDragMode     =   1
      OLEDropMode     =   1
      PictureAlignment=   1
      _Version        =   393217
      Icons           =   "ImageList2"
      SmallIcons      =   "ImageList1"
      ColHdrIcons     =   "ImageList1"
      ForeColor       =   -2147483640
      BackColor       =   -2147483643
      BorderStyle     =   1
      Appearance      =   1
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      OLEDragMode     =   1
      OLEDropMode     =   1
      NumItems        =   0
   End
   Begin VB.PictureBox picTitles 
      Align           =   1  'Align Top
      Appearance      =   0  'Flat
      BorderStyle     =   0  'None
      BeginProperty Font 
         Name            =   "MS Sans Serif"
         Size            =   8.25
         Charset         =   0
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H80000008&
      Height          =   300
      Left            =   0
      ScaleHeight     =   300
      ScaleWidth      =   9240
      TabIndex        =   1
      TabStop         =   0   'False
      Top             =   420
      Width           =   9240
      Begin VB.Label lblTitle 
         BorderStyle     =   1  'Fixed Single
         Caption         =   "百利/ERP5.0"
         Height          =   270
         Index           =   0
         Left            =   0
         TabIndex        =   3
         Tag             =   " 树形视图:"
         Top             =   12
         Width           =   2016
      End
      Begin VB.Label lblTitle 
         BorderStyle     =   1  'Fixed Single
         Caption         =   " 列表视图:"
         Height          =   270
         Index           =   1
         Left            =   2078
         TabIndex        =   2
         Tag             =   " 列表视图:"
         Top             =   12
         Width           =   3216
      End
   End
   Begin MSComDlg.CommonDialog dlgCommonDialog 
      Left            =   3360
      Top             =   2160
      _ExtentX        =   847
      _ExtentY        =   847
      _Version        =   393216
   End
   Begin MSComctlLib.TreeView tvTreeView 
      Height          =   4800
      Left            =   0
      TabIndex        =   4
      Top             =   705
      Width           =   2010
      _ExtentX        =   3545
      _ExtentY        =   8467
      _Version        =   393217
      Indentation     =   564
      LabelEdit       =   1
      Style           =   7
      ImageList       =   "ImageList1"
      Appearance      =   1
      BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
   End
   Begin MSComctlLib.Toolbar tbToolBar 
      Align           =   1  'Align Top
      Height          =   420
      Left            =   0
      TabIndex        =   6
      Top             =   0
      Width           =   9240
      _ExtentX        =   16298
      _ExtentY        =   741
      ButtonWidth     =   609
      ButtonHeight    =   582
      AllowCustomize  =   0   'False
      Appearance      =   1
      ImageList       =   "imlToolbarIcons"
      _Version        =   393216
      BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
         NumButtons      =   10
         BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "返回"
            Object.ToolTipText     =   "返回"
            ImageKey        =   "xq"
         EndProperty
         BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "向前"
            Object.ToolTipText     =   "向前"
            ImageKey        =   "xh"
         EndProperty
         BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "大图标"
            Object.ToolTipText     =   "大图标"
            ImageKey        =   "dtb"
            Style           =   2
            Value           =   1
         EndProperty
         BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "小图标"
            Object.ToolTipText     =   "小图标"
            ImageKey        =   "xtb"
            Style           =   2
         EndProperty
         BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "列表"
            Object.ToolTipText     =   "列表"
            ImageKey        =   "lb"
            Style           =   2
         EndProperty
         BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "详细资料"
            Object.ToolTipText     =   "详细资料"
            ImageKey        =   "xxzl"
            Style           =   2
         EndProperty
      EndProperty
   End
   Begin MSComctlLib.ImageList imlToolbarIcons 
      Left            =   4710
      Top             =   840
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   16
      ImageHeight     =   16
      MaskColor       =   12632256
      _Version        =   393216
      BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
         NumListImages   =   6
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":40F4
            Key             =   "xq"
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":448E
            Key             =   "xh"
         EndProperty
         BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":4828
            Key             =   "dtb"
         EndProperty
         BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":4BC2
            Key             =   "xtb"
         EndProperty
         BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":4F5C
            Key             =   "lb"
         EndProperty
         BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":52F6
            Key             =   "xxzl"
         EndProperty
      EndProperty
   End
   Begin MSComctlLib.ImageList ImageList2 
      Left            =   6210
      Top             =   2370
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   32
      ImageHeight     =   32
      MaskColor       =   12632256
      _Version        =   393216
      BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
         NumListImages   =   3
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":5690
            Key             =   ""
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":59B0
            Key             =   "y"
         EndProperty
         BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":668A
            Key             =   "i"
         EndProperty
      EndProperty
   End
   Begin VB.Image imgSplitter 
      Height          =   4785
      Left            =   4230
      MousePointer    =   9  'Size W E
      Top             =   750
      Width           =   150
   End
End
Attribute VB_Name = "Xt_Control"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'***********************************************
'*    模 块 名 称 :系统主操作桌面
'*    功 能 描 述 :
'*    程序员姓名  :张建忠
'*    最后修改人  :张建忠
'*    最后修改时间:2001/06/21
'*    备        注:封版
'***********************************************
Const NAME_COLUMN = 0
Const TYPE_COLUMN = 1
Const SIZE_COLUMN = 2
Const DATE_COLUMN = 3
Private Declare Function OSWinHelp% Lib "user32" Alias "WinHelpA" (ByVal hwnd&, ByVal HelpFile$, ByVal wCommand%, dwData As Any)
  
Dim mbMoving As Boolean
Const sglSplitLimit = 1000
Dim nodX As Node
Dim mitem As ListItem
Dim sjgnbmStr As String                      '上级编码
Dim Ztxxrec As New ADODB.Recordset           '帐套信息动态集
Dim Xtgnbrec As New ADODB.Recordset          '系统功能表
Dim Xtqxxzrec As New ADODB.Recordset         '系统权限限制动态集
Dim Tsxx As String                           '系统提示信息
Dim gnsyte As String                         '系统功能项索引
Dim Xtrlrec As New ADODB.Recordset           '系统日历动态集
Dim Ctsfscdr As Boolean                      '窗体是否首次读入
Private Sub lvListView_DblClick()            '点击ListView执行相应功能
    If lvListView.ListItems.count > 0 Then
        Set Xtgnbrec = Cw_DataEnvi.DataConnect.Execute("SELECT * FROM xt_xtgnb where gnbm='" + Mid(Trim(lvListView.SelectedItem.Key), 2, Len(Trim(lvListView.SelectedItem.Key)) - 1) + "'")
        If Not Xtgnbrec.EOF Then
            If Xtgnbrec.Fields("mjbz") = True Then
                gnsyte = Trim(Xtgnbrec.Fields("gnsy"))
                Call Zxxymk(gnsyte)
            Else
                '---------------
                Dim Ssql As String
                sjgnbmStr = ""
                lvListView.ColumnHeaders.Clear
                lvListView.ListItems.Clear
                Ssql = "SELECT * FROM xt_xtgnb where sjgnbm='" + Xtgnbrec.Fields("gnbm") + "' and MenuList=1 order by gnbm"
                Set Xtgnbrec = Cw_DataEnvi.DataConnect.Execute(Ssql)
                lvListView.ColumnHeaders.Add 1, "rcsw", tvTreeView.SelectedItem.Text, 3000, , "stb"
                Do While Not Xtgnbrec.EOF
                    Set mitem = lvListView.ListItems.Add()
                    mitem.Text = Trim(Xtgnbrec!gnmc)
                    If Xtgnbrec.Fields("mjbz") Then
                        mitem.SmallIcon = "gnqx"
                        mitem.Icon = "y"
                    Else
                        mitem.Icon = "i"
                        mitem.SmallIcon = "stb"
                    End If
                    mitem.Key = "T" & Trim(Xtgnbrec!gnbm)
                    Xtgnbrec.MoveNext
                Loop
                '---------------
            End If
        End If
    End If
End Sub
Private Sub lvListView_KeyPress(KeyAscii As Integer)
    If KeyAscii = vbKeyReturn Then
        Call lvListView_DblClick
    End If
End Sub
Private Sub tvTreeView_NodeClick(ByVal Node As MSComctlLib.Node)
    Dim Ssql As String
    If Node.Tag <> "" Then
        If Node.Tag = False Then
            Ssql = "SELECT * FROM xt_xtgnb where sjgnbm='" + Mid(Trim(tvTreeView.SelectedItem.Key), 2, Len(Trim(tvTreeView.SelectedItem.Key)) - 1) + "' and MenuList=1 order by gnbm"
            If sjgnbmStr = Mid(Trim(tvTreeView.SelectedItem.Key), 2, Len(Trim(tvTreeView.SelectedItem.Key)) - 1) Then
                Exit Sub
            Else
                sjgnbmStr = Mid(Trim(tvTreeView.SelectedItem.Key), 2, Len(Trim(tvTreeView.SelectedItem.Key)) - 1)
            End If
        Else
            Ssql = "SELECT * FROM xt_xtgnb a," _
                    & "(SELECT sjgnbm FROM xt_xtgnb where gnbm='" + Mid(Trim(tvTreeView.SelectedItem.Key), 2, Len(Trim(tvTreeView.SelectedItem.Key)) - 1) + "')b" & " where a.sjgnbm=b.sjgnbm and MenuList=1 order by gnbm"
        End If
        
        Set Xtgnbrec = Cw_DataEnvi.DataConnect.Execute(Ssql)
        If Node.Tag = True Then
            If sjgnbmStr = Trim(Xtgnbrec!sjgnbm) Then
                Exit Sub
            Else
                sjgnbmStr = Trim(Xtgnbrec!sjgnbm)
            End If
        End If
        lvListView.ColumnHeaders.Clear
        lvListView.ListItems.Clear
        lvListView.ColumnHeaders.Add 1, "rcsw", "明细", 3000, , "stb"
        Do While Not Xtgnbrec.EOF
            Set mitem = lvListView.ListItems.Add()
            mitem.Text = Trim(Xtgnbrec!gnmc)
            If Xtgnbrec.Fields("mjbz") Then
                mitem.SmallIcon = "gnqx"
                mitem.Icon = "y"
            Else
                mitem.Icon = "i"
                mitem.SmallIcon = "stb"
            End If
            mitem.Key = "T" & Trim(Xtgnbrec!gnbm)
            Xtgnbrec.MoveNext
        Loop
    End If
End Sub
Public Sub Cshgns()                                                    '初始化系统功能树
  
    Set Xtgnbrec = Cw_DataEnvi.DataConnect.Execute("SELECT * FROM xt_xtgnb where gnbm like '11%' and MenuList=1 order by gnbm")
    tvTreeView.Nodes.Add , 4, "T", "百利/ERP5.0", "xttb"
    With Xtgnbrec
        Do While Not .EOF
            If .Fields("mjbz") Then
                Set nodX = tvTreeView.Nodes.Add("T" + Trim(.Fields("sjgnbm")), 4, "T" + Trim(.Fields("gnbm")), Trim(.Fields("gnmc")), "gnqx")
            Else
                If Trim(.Fields("sjgnbm")) = "" Then
                    Set nodX = tvTreeView.Nodes.Add("T" + Trim(.Fields("sjgnbm")), 4, "T" + Trim(.Fields("gnbm")), Trim(.Fields("gnmc")), "kpgl")
                Else
                    Set nodX = tvTreeView.Nodes.Add("T" + Trim(.Fields("sjgnbm")), 4, "T" + Trim(.Fields("gnbm")), Trim(.Fields("gnmc")), "stb")
                End If
            End If
            nodX.Tag = Xtgnbrec!mjbz
            If Len(Trim(.Fields("sjgnbm"))) <= 2 Then
                nodX.EnsureVisible
            End If
            .MoveNext
        Loop
    End With
End Sub
'系统功能树操作
Private Sub tvTreeView_BeforeLabelEdit(Cancel As Integer)                     '屏蔽编辑
  Cancel = 1
End Sub
Private Sub tvTreeView_Collapse(ByVal Node As MSComctlLib.Node)               '功能树收缩
    
    If Node.Index <> 1 And Node.Key <> "T11" Then
        Node.Image = "stb"
    End If
 
End Sub
Private Sub tvTreeView_Expand(ByVal Node As MSComctlLib.Node)                 '功能树展开
    
    If Node.Index <> 1 And Node.Key <> "T11" Then
        Node.Image = "szk"
    End If
End Sub
Private Sub tvTreeView_KeyPress(KeyAscii As Integer)                          '用户按回车键执行相应功能
    
    If KeyAscii = vbKeyReturn Then
        Call tvTreeView_DblClick
    End If
End Sub
Private Sub tvTreeView_DblClick()                                             '选择功能
    
    If tvTreeView.SelectedItem.Children = 0 Then
        Set Xtgnbrec = Cw_DataEnvi.DataConnect.Execute("SELECT * FROM xt_xtgnb where gnbm='" + Mid(Trim(tvTreeView.SelectedItem.Key), 2, Len(Trim(tvTreeView.SelectedItem.Key)) - 1) + "'")
        If Not Xtgnbrec.EOF Then
            gnsyte = Trim(Xtgnbrec.Fields("gnsy"))
            Call Zxxymk(gnsyte)
        End If
    End If
End Sub
Public Sub Zxxymk(gnsy As String)                                            '根据用户选择执行相应程序
  
    Dim RecTemp As New ADODB.Recordset     '临时使用动态集
    Dim Sqlstr As String                   '临时查询字符串
  
    If Len(Trim(gnsy)) = 0 Then
        Exit Sub
    End If
    
    
    On Error GoTo Cwcl:
    Select Case gnsy
        
        Case "Cg_wlsort"                        '采购物料分类设置
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_wlsort", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_CgwlflSet.Show 1
        Case "Cg_PurTypeSet"                    '采购类型设置
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_PurTypeSet", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_PurTypeSet.Show 1
        Case "Cg_ordertype"                     '订单类型设置
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_ordertype", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_OrderTypeSet.Show 1
        Case "Cg_Invoicetype"                   '发票类型设置
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_Invoicetype", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_InvoiceTypeSet.Show 1
        Case "Cg_Supplier"                      '供应商
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_Supplier", Xtczybm, 1) Then
                Exit Sub
            End If
            
            Gy_Supplier.Show
            Gy_SupplierQuery.Show 1
        Case "Cg_Material"                      '物料档案
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_Material", Xtczybm, 1) Then
                Exit Sub
            End If
            Gy_Material.Show
            Gy_MaterialQuery.Show 1
            
        Case "Cg_SupplierSort"                  '供应商分类设置
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_SupplierSort", Xtczybm, 1) Then
                Exit Sub
            End If
            
            With Gy_BaseSortSet
                XtReportCode = "Gy_SupplierSort"
                .ReportTitle = "供应商分类设置"
                
                .TextGroupCode = "Gy_SupplierSort"
                .GridCode = "Gy_SupplierSort"
                .CodSchemeIndex = "Gy_SupplierSort"
                
                .str_TableName = "Gy_SupplierSort"
                .str_SortCode = "SupplierSortCode"
                .str_SortName = "SupplierSortName"
                .str_Label = "供应商分类"
                .Caption = "供应商分类设置"
                .HelpContextID = "1101009"
                .Show 1
            End With
            
        Case "Cg_areasort"                       '供应商地区分类设置
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_areasort", Xtczybm, 1) Then
                Exit Sub
            End If
            
            With Gy_BaseSortSet
                XtReportCode = "Cg_AreaSet"
                .ReportTitle = "供应商地区分类设置"
                
                .TextGroupCode = "Cg_AreaSet"
                .GridCode = "gy_AreaSet"
                .CodSchemeIndex = "Cg_AreaSet"
                .str_TableName = "Cg_AreaSet"
                .str_SortCode = "AreaCode"
                .str_SortName = "AreaName"
                .str_Label = "供应商地区分类"
                .Caption = "供应商地区分类设置"
                .HelpContextID = "1101001"
                .Show 1
            End With
        Case "Cg_Tradesort"                      '供应商行业分类设置
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_Tradesort", Xtczybm, 1) Then
                Exit Sub
            End If
            
            With Gy_BaseSortSet
                XtReportCode = "Cg_TradeSet"
                .ReportTitle = "供应商行业分类设置"
                
                .TextGroupCode = "Cg_TradeSet"
                .GridCode = "gy_TradeSet"
                .CodSchemeIndex = "Cg_TradeSet"
                .str_TableName = "Cg_TradeSet"
                .str_SortCode = "TradeCode"
                .str_SortName = "TradeName"
                .str_Label = "供应商行业分类"
                .Caption = "供应商行业分类设置"
                .HelpContextID = "1101002"
                .Show 1
            End With
            
        Case "Cg_account"                       '期初结账
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_account", Xtczybm, 1) Then
                Exit Sub
            End If
            Call Cg_Startaccount(1)
        Case "Cg_cancelaccount"                 '回复期初结账
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_cancelaccount", Xtczybm, 3) Then
                Exit Sub
            End If
            Call Cg_Startaccount(0)
        Case "Cg_planinput"                     '采购计划录入
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_planinput_edit", Xtczybm, 1) Then
                Exit Sub
            End If
            Xtcdcs = "1"
            Cg_planinput.Show 1
            Security_Log gnsy, Xtczybm, 2, False  '用户退出时写上机日志
        Case "Cg_planch"                        '采购计划拆合
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_planch", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_PlanUnitSplit.Show
            Cg_PlanUnitSplitQuery.Show 1
        Case "Cg_planlist"                      '采购计划列表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_planlist", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_planlist.Show
            Cg_PlanListQuery.Show 1
        Case "Cg_scxqcx"                        '采购计划（MRP生成）查询
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_scxqcx", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_ScxqList.Show
            Cg_ScxqListQuery.Show 1
        Case "Cg_zjys"                          '采购资金预算
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_zjys", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_FundCmptList.Show
            Cg_FundCmptListQuery.Show 1
        Case "Cg_hzgl"                          '采购计划执行情况—汇总（关联）
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_hzgl", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_PurPlanExecThingSum.Show
            Int_PlanQueryType = 1
            Cg_PlanExecThingQuery.Show 1
        Case "Cg_mxgl"                          '采购计划执行情况—明细（关联）
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_mxgl", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_PurPlanExecThing.Show
            Int_PlanQueryType = 2
            Cg_PlanExecThingQuery.Show 1
        Case "Cg_hzcx"                          '采购计划执行情况汇总
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_hzcx", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_PurPlanExecTotal.Show
            Cg_PlanExecTotalQuery.Show 1
        Case "Cg_qkfk"                          '采购情况反馈单
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_qkfk", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_PlanFeedback.Show 1
        Case "Cg_xjlr"                          '采购询价单录入
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_xjlr_edit", Xtczybm, 1) Then
                Exit Sub
            End If
            Xtcdcs = 1
            Cg_AskPriceInput.Show 1
            Security_Log gnsy, Xtczybm, 2, False  '用户退出时写上机日志
        Case "Cg_xjlb"                          '询价单列表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_xjlb", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_AskPriceList.Show
            Cg_AskPriceListQuery.Show 1
        Case "Cg_bjfx"                          '采购比价分析
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_bjfx", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_CmpPriceList.Show
            Cg_CmpPriceListQuery.Show 1
        Case "Cg_orderinput"                    '订单录入
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_orderinput_edit", Xtczybm, 1) Then
                Exit Sub
            End If
            Xtcdcs = "1"
            Cg_orderinput.Show 1
            Security_Log gnsy, Xtczybm, 2, False  '用户退出时写上机日志
        Case "Cg_orderlist"                     '订单列表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_orderlist", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_orderlist.Show
            Cg_OrderListQuery.Show 1
        Case "Cg_orderhzcx"                     '采购订单执行情况汇总
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_orderhzcx", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_OrderExecTotal.Show
            Cg_OrderExecTotalQuery.Show 1
        Case "Cg_ordermxcx"                     '采购订单执行情况明细
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_ordermxcx", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_OrderExecThing.Show
            Cg_OrderExecThingQuery.Show 1
        Case "Cg_sllr"                          '收料通知单
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_sllr_edit", Xtczybm, 1) Then
                Exit Sub
            End If
            Xtcdcs = "1"
            Cg_GoodsInput.Show 1
            Security_Log gnsy, Xtczybm, 2, False  '用户退出时写上机日志
        Case "Cg_xllb"                           '收料通知单列表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_xllb", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_GoodsInputList.Show
            Cg_GoodsInputQuery.Show 1
        Case "Cg_thlr"                          '退货通知单
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_thlr_edit", Xtczybm, 1) Then
                Exit Sub
            End If
            Xtcdcs = "1"
            Cg_GoodsOutput.Show 1
            Security_Log gnsy, Xtczybm, 2, False  '用户退出时写上机日志
        Case "Cg_thlb"                           '退货通知单列表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_thlb", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_GoodsOutputList.Show
            Cg_GoodsOutputQuery.Show 1
        Case "Cg_spinvoice"                      '期初普通发票录入
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_spinvoice_edit", Xtczybm, 1) Then
                Exit Sub
            End If
            If CG_StartAccountCheck = True Then
                
                Xtcdcs = "1"
                Cg_InvoiceBill.InvoiceType = 1
                Cg_InvoiceBill.Show 1
                Security_Log gnsy, Xtczybm, 2, False  '用户退出时写上机日志
            End If
        Case "Cg_szinvoice"                      '期初专用发票录入
            If CG_StartAccountCheck = True Then
                '判断用户是否有此功能执行权限,如有则写上机日志(进入)
                If Not Security_Log("Cg_szinvoice_edit", Xtczybm, 1) Then
                    Exit Sub
                End If
                Xtcdcs = "1"
                Cg_InvoiceBill.InvoiceType = 2
                Cg_InvoiceBill.Show 1
                Security_Log gnsy, Xtczybm, 2, False  '用户退出时写上机日志
            End If
        Case "Cg_pfpinput"                      '蓝字普通发票录入
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_pfpinput_edit", Xtczybm, 1) Then
                Exit Sub
            End If
            Xtcdcs = "1"
            Cg_InvoiceBill.InvoiceType = 3
            Cg_InvoiceBill.Show 1
            Security_Log gnsy, Xtczybm, 2, False  '用户退出时写上机日志
        Case "Cg_hfpinput"                      '红字普通发票录入
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_hfpinput_edit", Xtczybm, 1) Then
                Exit Sub
            End If
            Xtcdcs = "1"
            Cg_InvoiceBill.InvoiceType = 5
            Cg_InvoiceBill.Show 1
            Security_Log gnsy, Xtczybm, 2, False  '用户退出时写上机日志
        Case "Cg_zfpinput"                      '蓝字专用发票录入
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_zfpinput_edit", Xtczybm, 1) Then
                Exit Sub
            End If
            Xtcdcs = "1"
            Cg_InvoiceBill.InvoiceType = 4
            Cg_InvoiceBill.Show 1
            Security_Log gnsy, Xtczybm, 2, False  '用户退出时写上机日志
        Case "Cg_hzfpinput"                      '红字专用发票录入
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_hzfpinput_edit", Xtczybm, 1) Then
                Exit Sub
            End If
            Xtcdcs = "1"
            Cg_InvoiceBill.InvoiceType = 6
            Cg_InvoiceBill.Show 1
            Security_Log gnsy, Xtczybm, 2, False  '用户退出时写上机日志
        Case "Cg_spinvoicelist"                 ' 期初普通发票列表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_spinvoicelist", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_InvoiceQuery.InvoiceType = 1
            Cg_InvoiceQCPT_List.Show
            Cg_InvoiceQuery.Show 1
        Case "Cg_szinvoicelist"                 '期初增值税发票列表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_szinvoicelist", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_InvoiceQuery.InvoiceType = 2
           
            Cg_InvoiceQCZy_List.Show
            Cg_InvoiceQuery.Show 1
        Case "Cg_pfplist"                       '普通发票列表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_pfplist", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_InvoiceQuery.InvoiceType = 3
           
            Cg_InvoicePt_list.Show
            Cg_InvoiceQuery.Show 1
        Case "Cg_zfplist"                       '增值税发票列表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_zfplist", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_InvoiceQuery.InvoiceType = 4
          
            Cg_InvoiceZy_List.Show
            Cg_InvoiceQuery.Show 1
        Case "Cg_slmxb"                         '采购收料明细表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_slmxb", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_PaymentList.Show
            Cg_PaymentQuery.Show 1
        Case "Cg_fpmxb"                         '采购发票明细表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_fpmxb", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_InvoiceDevList.Show
            Cg_InvoiceDevQuery.Show 1
        Case "Cg_zthwyeb"                       '在途余额表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_zthwyeb", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_OnRoadList.Show
            Cg_OnRoadListQuery.Show 1
        Case "Cg_sltjb"                         '采购收料统计表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_sltjb", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_ReceiptTotalList.Show
            Cg_ReciptTotalQuery.Show 1
        Case "Cg_fptjb"                         '采购发票统计表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_fptjb", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_InvoiceTotalList.Show
            Cg_InvoiceTotalQuery.Show 1
        Case "Cg_zttjb"                         '在途统计表
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_zttjb", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_OnRoadTotalList.Show
            Cg_OnRoadTotalQuery.Show 1
        Case "Cg_zhtjfx"                        '综合统计分析
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_zhtjfx", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_IntegrationList.Show
            Cg_IntegrationQuery.Show 1
        Case "Cg_ddwlfx"                        '订单物料分析
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_ddwlfx", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_OrderAnalyseList.Show
            Cg_OrderAnalyseQuery.Show 1
        Case "Cg_gysjgdbfx"                     '供应商价格对比分析
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_gysjgdbfx", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_SuppAnalyseList.Show
            Cg_SuppAnalyseQuery.Show 1
        Case "Cg_zjbzfx"                        '采购资金比重分析
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_zjbzfx", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_FundAnalyseList.Show
            Cg_FundAnalyseQuery.Show 1
        Case "Cg_wljgdbfx"                      '物料价格对比分析
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_wljgdbfx", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_PriceAnalyseList.Show
            Cg_PriceAnalyseQuery.Show 1
        Case "Cg_fyfx"                          '采购费用分析
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_fyfx", Xtczybm, 1) Then
                Exit Sub
            End If
            Cg_ChargeAnalyseList.Show
            Cg_ChargeAnalyseQuery.Show 1
       
        
        Case "Cg_ymjz"                          '月末结帐
            '判断用户是否有此功能执行权限,如有则写上机日志(进入)
            If Not Security_Log("Cg_ymjz", Xtczybm, 1) Then
                Exit Sub
            End If
            If Bln_IsStartChalk() Then
                Cg_account.Show 1
            Else
                Tsxx = "期初尚未结帐，不能进行月末结帐!"
                Call Xtxxts(Tsxx, 0, 4)
            End If
        Case "Cg_jsq"                           '计算器
            Shell App.Path & "calc.exe"
        Case "Cg_kjrl"                          '会计日历
            XT_kjrlFrm.Show
        Case "Cg_syshelp"                       '系统帮助
            Call F1bz
        Case "Cg_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 Cg_Startaccount(Cancel As Integer)  '采购期初结账
Dim int_Answer As Integer
On Error GoTo Err_Execute
 If Cancel = 1 Then
    If Cg_startCheck = False Then Exit Sub
    If CG_StartAccountCheck = False Then Exit Sub
    If Xtxxts("是否期初结账?", 1, 2) = vbYes Then
        Me.MousePointer = 11
        Cw_DataEnvi.DataConnect.Execute ("Cg_Sp_StartAccount " & "1," & Xtczy)
        Me.MousePointer = 0
        Call Xtxxts("期初结账完成!", 0, 4)
    End If
 Else
    
    If Cg_startCheck(True) = False Then Exit Sub
    If CG_StartAccountCheck(True) = False Then Exit Sub
    If Xtxxts("是否取消期初结账?", 1, 2) = vbYes Then
        Me.MousePointer = 11
        Cw_DataEnvi.DataConnect.Execute ("Cg_Sp_StartAccount ")
        Me.MousePointer = 0
        Call Xtxxts("取消期初结账完成!", 0, 4)
    End If
 End If
 Exit Sub
Err_Execute:
        Tsxx = Err.Description
        Me.MousePointer = 0
        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

						