⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄

📁 VB开发的ERP系统
💻
📖 第 1 页 / 共 3 页
字号:
      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   =   4
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":6B34
            Key             =   "y1"
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":6F88
            Key             =   ""
         EndProperty
         BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":72A8
            Key             =   "i"
         EndProperty
         BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "系统_主操作桌面.frx":82FA
            Key             =   "y"
         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 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                      '窗体是否首次读入
Dim sjgnbmStr As String                      '上级编码

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 '16%' 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 <> "T16" Then
        Node.Image = "stb"
    End If
 
End Sub

Private Sub tvTreeView_Expand(ByVal Node As MSComctlLib.Node)                 '功能树展开
    
    If Node.Index <> 1 And Node.Key <> "T16" 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 "Tr_register"                       '用户重新注册
            XT_login.Show 1
        Case "c_quit"
            Unload XT_Main
        
            '模式程序
     
            '1.录入类型
        Case "Tr_Type"                          '车辆类型(编码式)
            Tr_Type.HelpContextID = 1602001
            Tr_Type.Show 1
        Case "Tr_Situation"                     '车辆状况(编码式)
            Tr_Situation.HelpContextID = 1602002
            Tr_Situation.Show 1
        Case "Tr_UseNature"                     '车辆使用性质(编码式)
            Tr_UseNature.HelpContextID = 1602003
            Tr_UseNature.Show 1
        Case "Tr_OwnerShip"                     '车辆所有权(编码式)
            Tr_OwnerShip.HelpContextID = 1602004
            Tr_OwnerShip.Show 1
        Case "Tr_NowGrade"                      '车辆等级(编码式)
            Tr_NowGrade.HelpContextID = 1602005
            Tr_NowGrade.Show 1
        Case "Tr_Park"                          '车辆停车线(编码式)
            Tr_Park.HelpContextID = 1602006
            Tr_Park.Show 1
        Case "Tr_VehicleFile"                   '车辆档案(编码式)
            Tr_VehicleFile.HelpContextID = 1602007
            Call XtWaitMess("Tr_VehicleFile")
        Case "Tr_TrainUnit"                     '接收单位
            Tr_TrainUnit.HelpContextID = 1602008
            Tr_TrainUnit.Show 1
        Case "Tr_Source"                        '货源单位
            Tr_Supply.HelpContextID = 1602009
            Tr_Supply.Show 1
        Case "Tr_DispatchOut"                   '调卸单(编码式)
            Tr_DispatchOut.HelpContextID = 1603008001
            Tr_DispatchOut.Show 1
        Case "Tr_DispatchWash"                  '调洗单(编码式)
            Tr_DispatchWash.HelpContextID = 1603008003
            Tr_DispatchWash.Show 1
        Case "Tr_Stop"                          '暂放单(编码式)
            Tr_Stop.HelpContextID = 1603008004
            Tr_Stop.Show 1
        Case "Tr_Check"                         '查车单(编码式)
            Tr_Check.HelpContextID = 1603008002
            Tr_Check.Show 1
        Case "Tr_Weigh"                         '检斤单(编码式)
            Tr_Weigh.HelpContextID = 1603008005
            Tr_Weigh.Show 1
        Case "Tr_Move"                          '调车单(编码式)
            Tr_Move.HelpContextID = 1603010
            Tr_Move.Show 1
        Case "Tr_Arrive"                         '车辆到达单(编码式)
            Tr_Arrive.HelpContextID = 1603007
            Tr_Arrive.Show 1
        Case "Tr_NowAccountList"                '现车状况编码式)
            Tr_NowAccountList.HelpContextID = 1603009
            Tr_NowAccountList.Show
            Tr_NowAccountCxtj.Show 1
        Case "Tr_ParkList"                      '车辆在线状况(编码式)

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -