frmmdi.frm

一个简单但功能强大的进货系统,同样适合用于毕业论文的设计

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.MDIForm frmMDI 
   Appearance      =   0  'Flat
   AutoShowChildren=   0   'False
   BackColor       =   &H80000001&
   Caption         =   "ACCP仓库管理系统"
   ClientHeight    =   4185
   ClientLeft      =   165
   ClientTop       =   450
   ClientWidth     =   6780
   Icon            =   "frmMDI.frx":0000
   LinkTopic       =   "ACCP仓库管理系统"
   Moveable        =   0   'False
   NegotiateToolbars=   0   'False
   ScrollBars      =   0   'False
   StartUpPosition =   1  '所有者中心
   WindowState     =   2  'Maximized
   Begin MSComctlLib.ImageList ImageList1 
      Left            =   120
      Top             =   3120
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      MaskColor       =   12632256
      _Version        =   393216
   End
   Begin MSComctlLib.StatusBar Stb 
      Align           =   2  'Align Bottom
      Height          =   375
      Left            =   0
      TabIndex        =   0
      Top             =   3810
      Width           =   6780
      _ExtentX        =   11959
      _ExtentY        =   661
      _Version        =   393216
      BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628} 
      EndProperty
   End
   Begin VB.Menu Menu_System 
      Caption         =   "系统(&S)"
      Begin VB.Menu Menu_R 
         Caption         =   "系统启动(&R)"
      End
      Begin VB.Menu Menu_Delete 
         Caption         =   "删除资料(&D)"
      End
      Begin VB.Menu b1 
         Caption         =   "-"
      End
      Begin VB.Menu Menu_AddUser 
         Caption         =   "添加用户(&A)"
      End
      Begin VB.Menu b2 
         Caption         =   "-"
      End
      Begin VB.Menu Menu_New 
         Caption         =   "重新登陆"
      End
      Begin VB.Menu Menu_Exit 
         Caption         =   "退出(&X)"
      End
   End
   Begin VB.Menu Menu_BasicInfo 
      Caption         =   "基本信息管理"
      Begin VB.Menu Menu_Sys 
         Caption         =   "初始信息录入"
      End
      Begin VB.Menu b3 
         Caption         =   "-"
      End
      Begin VB.Menu Menu_StorageInfo 
         Caption         =   "仓库管理(&A)"
      End
      Begin VB.Menu Menu_Merch 
         Caption         =   "商品管理(&M)"
      End
      Begin VB.Menu Menu_Serve 
         Caption         =   "供应商管理(&S)"
      End
      Begin VB.Menu Menu_Client 
         Caption         =   "客户管理(&C)"
      End
      Begin VB.Menu b4 
         Caption         =   "-"
      End
      Begin VB.Menu Menu_Make 
         Caption         =   "盘点结算"
      End
   End
   Begin VB.Menu Menu_Enterinfo 
      Caption         =   "入库管理(&E)"
      Enabled         =   0   'False
      Begin VB.Menu Menu_Act_Ps 
         Caption         =   "订购入库管理"
         Begin VB.Menu Menu_PSEDIT 
            Caption         =   "订购入库编辑"
         End
         Begin VB.Menu Menu_PsCk 
            Caption         =   "订购入库审核"
         End
      End
      Begin VB.Menu Menu_Act_Other 
         Caption         =   "其它入库管理"
         Begin VB.Menu Menu_OtherEdit 
            Caption         =   "其它入库编辑"
         End
         Begin VB.Menu Menu_OtherCk 
            Caption         =   "其它入库审核"
         End
      End
   End
   Begin VB.Menu Menu_Sellinfo 
      Caption         =   "销售管理(&L)"
      Enabled         =   0   'False
      Begin VB.Menu Menu_SellEdit 
         Caption         =   "销售出库编辑"
      End
      Begin VB.Menu Menu_SellCk 
         Caption         =   "销售出库审核"
      End
   End
   Begin VB.Menu Menu_SQL 
      Caption         =   "统计查询"
      Enabled         =   0   'False
      Begin VB.Menu Menu_SQLA 
         Caption         =   "查询已审核"
         Begin VB.Menu Menu_PsSQL 
            Caption         =   "订购入库"
         End
         Begin VB.Menu Menu_OtherSQl 
            Caption         =   "其它入库"
         End
         Begin VB.Menu Menu_SellSQL 
            Caption         =   "出库单据"
         End
      End
   End
   Begin VB.Menu Menu_Help 
      Caption         =   "帮助(&H)"
      Begin VB.Menu Menu_HelpDoc 
         Caption         =   "帮助文档(&D)"
      End
      Begin VB.Menu Menu_helpbreak 
         Caption         =   "-"
      End
      Begin VB.Menu Menu_About 
         Caption         =   "关于系统(&A)"
      End
   End
End
Attribute VB_Name = "frmMDI"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rsSys As ADODB.Recordset
Dim cmdSys As ADODB.Command
Dim rsprosql As ADODB.Recordset
Dim blnexit As Boolean


Private Sub MDIForm_Load()

            If post = "管理员" Then
                Me.Menu_AddUser.Enabled = True
            Else
                Me.Menu_AddUser.Enabled = False
                Me.Menu_Delete.Enabled = False
            End If
    
Me.Icon = LoadPicture(App.Path & "\icon\main.ico")

    Dim strsql As String
    strsql = "select * from 系统启动表"
    
'    Dim mypanel As Panel
'    Set mypanel = StatusBar1.Panels.Add()
'    mypanel.Alignment = sbrRight
'    Set mypanel = StatusBar1.Panels.Add(, , , sbrIns)
'    Set mypanel = StatusBar1.Panels.Add(, , , sbrCaps)
'    Set mypanel = StatusBar1.Panels.Add(, , , sbrNum)
'    Set mypanel = StatusBar1.Panels.Add(, , , sbrTime)
    
    For i = 1 To 7
        Stb.Panels.Add
    Next
    For i = 3 To 7
        Stb.Panels.Item(i).Alignment = sbrRight
        Stb.Panels.Item(i).AutoSize = sbrSpring
    Next
    With Stb
        .Panels.Item(3).Style = sbrIns
        .Panels.Item(4).Style = sbrCaps
        .Panels.Item(5).Style = sbrNum
        .Panels.Item(6).Style = sbrTime
        .Panels.Item(7).Style = sbrDate
    End With
    
    Set rsSys = New Recordset
    Set rsSys = ExecuteSQL(strsql)
    'rsSys.MoveFirst
    If Not rsSys.EOF Then
    If rsSys!offline = "true" Then
        Me.Menu_R.Enabled = False
        Me.Menu_Sys.Enabled = False
        Me.Menu_Enterinfo.Enabled = True
        Me.Menu_Sellinfo.Enabled = True
        Me.Menu_SQL.Enabled = True

    Else
        Me.Menu_R.Enabled = True
        Me.Menu_Delete.Enabled = False

    End If
    End If
    
    Set cmdSys = New Command
    cmdSys.ActiveConnection = DEaccp.Conaccp
    cmdSys.CommandType = adCmdText
 
    Set rsprosql = New Recordset

    blnexit = True

    
End Sub



Private Sub MDIForm_QueryUnload(Cancel As Integer, UnloadMode As Integer)
    Dim intexit As Integer
    If blnexit = True Then
    intexit = MsgBox("真的退出该系统吗(Y/N)?    ", vbYesNo + 32, "请确认")
    If intexit = vbYes Then
        Cancel = 0
    Else
        Cancel = -1
    End If
    Else
        Exit Sub
    End If
End Sub

Private Sub Menu_About_Click()
    
    frmAbout.Show (vbModal)
    
End Sub

Private Sub Menu_AddShelf_Click()
    frmShelf.Show vbModal
End Sub

Private Sub Menu_AddStorage_Click()
    frmStorage.Show vbModal
End Sub

Private Sub Menu_AddUser_Click()
    frmAddUser.Show vbModal
    
End Sub

Private Sub Menu_Client_Click()