mainform.frm

用vb+access库房管理开放源码 1、日常业务 药品入库 药品出库 入库退单管理 出库退单管理 2、库存管理 库存查询 库存盘点 价格管理 3、查询统计 入库查询 入库退

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.MDIForm MainForm 
   BackColor       =   &H8000000C&
   Caption         =   "双鱼林商品库库存管理系统"
   ClientHeight    =   7275
   ClientLeft      =   165
   ClientTop       =   735
   ClientWidth     =   10365
   LinkTopic       =   "MDIForm1"
   Picture         =   "MainForm.frx":0000
   StartUpPosition =   3  '窗口缺省
   WindowState     =   2  'Maximized
   Begin MSComctlLib.StatusBar StatusBar1 
      Align           =   2  'Align Bottom
      Height          =   435
      Left            =   0
      TabIndex        =   0
      Top             =   6840
      Width           =   10365
      _ExtentX        =   18283
      _ExtentY        =   767
      SimpleText      =   "."
      _Version        =   393216
      BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628} 
         NumPanels       =   5
         BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
            Object.Width           =   6174
            MinWidth        =   6174
         EndProperty
         BeginProperty Panel2 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
            Object.Width           =   4410
            MinWidth        =   4410
         EndProperty
         BeginProperty Panel3 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
            Style           =   6
            TextSave        =   "2008-11-6"
         EndProperty
         BeginProperty Panel4 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
            Style           =   2
            Enabled         =   0   'False
            TextSave        =   "NUM"
         EndProperty
         BeginProperty Panel5 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
            Style           =   1
            Enabled         =   0   'False
            TextSave        =   "CAPS"
         EndProperty
      EndProperty
   End
   Begin MSComctlLib.ImageList ImageList1 
      Left            =   2640
      Top             =   2280
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   32
      ImageHeight     =   32
      MaskColor       =   12632256
      _Version        =   393216
      BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
         NumListImages   =   6
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "MainForm.frx":2C02F
            Key             =   ""
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "MainForm.frx":2C481
            Key             =   ""
         EndProperty
         BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "MainForm.frx":2C8D3
            Key             =   ""
         EndProperty
         BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "MainForm.frx":2CD25
            Key             =   ""
         EndProperty
         BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "MainForm.frx":2D177
            Key             =   ""
         EndProperty
         BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "MainForm.frx":2D5C9
            Key             =   ""
         EndProperty
      EndProperty
   End
   Begin MSComctlLib.Toolbar Toolbar1 
      Align           =   1  'Align Top
      Height          =   600
      Left            =   0
      TabIndex        =   1
      Top             =   0
      Width           =   10365
      _ExtentX        =   18283
      _ExtentY        =   1058
      ButtonWidth     =   1032
      ButtonHeight    =   1005
      Appearance      =   1
      Style           =   1
      ImageList       =   "ImageList1"
      HotImageList    =   "ImageList1"
      _Version        =   393216
      BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
         NumButtons      =   9
         BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "q"
            Style           =   3
         EndProperty
         BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "query"
            Object.ToolTipText     =   "操作人员维护"
            ImageIndex      =   3
         EndProperty
         BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "input"
            Object.ToolTipText     =   "商品输入"
            ImageIndex      =   4
         EndProperty
         BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "ee"
            Style           =   3
         EndProperty
         BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "drdc"
            Object.ToolTipText     =   "数据导出"
            ImageIndex      =   5
         EndProperty
         BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "good"
            Object.ToolTipText     =   "查询商品报表"
            ImageIndex      =   2
         EndProperty
         BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "HH"
            Style           =   3
         EndProperty
         BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "exit"
            Object.ToolTipText     =   "退出"
            ImageIndex      =   6
         EndProperty
         BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "cc"
            Style           =   3
         EndProperty
      EndProperty
   End
   Begin VB.Menu File 
      Caption         =   "操作人员管理(&F)"
      Begin VB.Menu qq 
         Caption         =   "-"
      End
      Begin VB.Menu new 
         Caption         =   "新建帐套(&N)"
         Visible         =   0   'False
      End
      Begin VB.Menu caywh 
         Caption         =   "操作员维护(&C)"
      End
      Begin VB.Menu xgkl 
         Caption         =   "修改口令(&K)"
      End
      Begin VB.Menu open 
         Caption         =   "-"
      End
      Begin VB.Menu close 
         Caption         =   "关闭帐套(&C)"
         Visible         =   0   'False
      End
      Begin VB.Menu l 
         Caption         =   "-"
      End
      Begin VB.Menu changeczy 
         Caption         =   "更换操作员(&G)"
      End
      Begin VB.Menu kk 
         Caption         =   "-"
      End
      Begin VB.Menu exit 
         Caption         =   "退     出(&E)"
      End
   End
   Begin VB.Menu goodManage 
      Caption         =   "商品管理"
      Begin VB.Menu a 
         Caption         =   "-"
      End
      Begin VB.Menu addGoodClass 
         Caption         =   "添加商品类别"
      End
      Begin VB.Menu goodClassManage 
         Caption         =   "商品类别管理"
      End
      Begin VB.Menu b 
         Caption         =   "-"
      End
      Begin VB.Menu addGood 
         Caption         =   "添加商品信息"
      End
      Begin VB.Menu goodInfoManage 
         Caption         =   "商品信息管理"
      End
      Begin VB.Menu c 
         Caption         =   "-"
      End
   End
   Begin VB.Menu stockManage 
      Caption         =   "库存管理"
      Begin VB.Menu d 
         Caption         =   "-"
      End
      Begin VB.Menu goodIn 
         Caption         =   "商品入库"
      End
      Begin VB.Menu goodOut 
         Caption         =   "商品出库"
      End
      Begin VB.Menu e 
         Caption         =   "-"
      End
      Begin VB.Menu goodInQuery 
         Caption         =   "商品入库记录查询"
      End
      Begin VB.Menu goodOutQuery 
         Caption         =   "商品出库记录查询"
      End
      Begin VB.Menu f 
         Caption         =   "-"
      End
   End
   Begin VB.Menu reportPrint 
      Caption         =   "报表打印"
      Begin VB.Menu g 
         Caption         =   "-"
      End
      Begin VB.Menu goodInfoReport 
         Caption         =   "商品信息报表"
      End
      Begin VB.Menu goodInReport 
         Caption         =   "商品入库记录报表"
      End
      Begin VB.Menu goodOutReport 
         Caption         =   "商品出库记录报表"
      End
      Begin VB.Menu h 
         Caption         =   "-"
      End
   End
   Begin VB.Menu sjbf 
      Caption         =   "数据备份"
      Begin VB.Menu i 
         Caption         =   "-"
      End
      Begin VB.Menu sjdc 
         Caption         =   "数据表导出"
      End
      Begin VB.Menu k 
         Caption         =   "-"
      End
   End
   Begin VB.Menu help 
      Caption         =   "帮助(&H)"
      Begin VB.Menu m 
         Caption         =   "-"
      End
      Begin VB.Menu bzzt 
         Caption         =   "系统说明(&Z)"
      End
      Begin VB.Menu bbxx 
         Caption         =   "版本信息(&X)"
      End
      Begin VB.Menu n 
         Caption         =   "-"
      End
   End
End
Attribute VB_Name = "MainForm"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim t As Boolean '判断某个操作的权限

Private Sub addGood_Click()
  t = check_qx(czry_flag, 2)
  If t = True Then
    MainForm.StatusBar1.Panels(1).Text = "状态：添加新商品信息"
    FrmAddGood.Show
  End If
End Sub

Private Sub addGoodClass_Click()
  t = check_qx(czry_flag, 1)
  If t = True Then
    MainForm.StatusBar1.Panels(1).Text = "状态：添加商品类别"
    FrmAddGoodClass.Show
  End If
End Sub

Private Sub bbxx_Click()
  MainForm.StatusBar1.Panels(1).Text = "状态： 版本信息"
  frmAbout.Show vbModal
End Sub

Private Sub bzzt_Click()
  MainForm.StatusBar1.Panels(1).Text = "状态： 帮助主题"
  frmBrowser.Show
End Sub

Private Sub caywh_Click()
'调用函数进行判断是否拥有权限使用各种功能
t = check_qx(czry_flag, 9)
If t = True Then
  MainForm.StatusBar1.Panels(1).Text = "状态： 操作员维护"
  frmsq.Show
End If
End Sub

Private Sub changeczy_Click()
  MainForm.StatusBar1.Panels(1).Text = "状态： 更换操作员"
  LoginForm.Show vbModal
End Sub

Private Sub exit_Click()
  End
End Sub

Private Sub goodClassManage_Click()
  t = check_qx(czry_flag, 3)
  If t = True Then
    MainForm.StatusBar1.Panels(1).Text = "状态： 商品类别维护"
    FrmGoodClassManage.Show
  End If
End Sub

Private Sub goodIn_Click()
  t = check_qx(czry_flag, 5)
  If t = True Then
    MainForm.StatusBar1.Panels(1).Text = "状态：商品入库"
    FrmGetIn.Show
  End If
End Sub

Private Sub goodInfoManage_Click()
  t = check_qx(czry_flag, 4)
  If t = True Then
    MainForm.StatusBar1.Panels(1).Text = "状态：商品信息维护"
    FrmGoodInfoManage.Show
  End If
End Sub

Private Sub goodInfoReport_Click()
  t = check_qx(czry_flag, 10)
  If t = True Then
    MainForm.StatusBar1.Panels(1).Text = "状态： 商品信息报表打印"
    GoodInfoDataReport.Show
  End If
End Sub

Private Sub goodInQuery_Click()
  t = check_qx(czry_flag, 6)
  If t = True Then
    MainForm.StatusBar1.Panels(1).Text = "状态：商品入库记录查询"
    FrmGetInQuery.Show
  End If
End Sub

Private Sub goodInReport_Click()
  t = check_qx(czry_flag, 10)
  If t = True Then
    MainForm.StatusBar1.Panels(1).Text = "状态：入库信息报表打印"
    FrmGetInPrint.Show
  End If
End Sub

Private Sub goodOut_Click()
  t = check_qx(czry_flag, 7)
  If t = True Then
    MainForm.StatusBar1.Panels(1).Text = "状态：商品出库"
    FrmGetOut.Show
  End If
End Sub

Private Sub goodOutQuery_Click()
  t = check_qx(czry_flag, 7)
  If t = True Then
    MainForm.StatusBar1.Panels(1).Text = "状态:商品出库信息查询"
    FrmGetOutQuery.Show
  End If
End Sub

Private Sub goodOutReport_Click()
  t = check_qx(czry_flag, 10)
  If t = True Then
    MainForm.StatusBar1.Panels(1).Text = "状态：入库信息报表打印"
    FrmGetOutPrint.Show
  End If
End Sub

Private Sub MDIForm_Load()
  frmBrowser.Show
End Sub

Private Sub sjdc_Click()
  t = check_qx(czry_flag, 11)
  If t = True Then
    MainForm.StatusBar1.Panels(1).Text = "状态： 导出数据"
    frmDataOutput.Show
  End If
End Sub

Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
  Select Case Button.Key
       Case "new"
            t = check_qx(czry_flag, 9)
            If t = True Then
              MainForm.StatusBar1.Panels(1).Text = "状态： 新建帐套"
              frmadduser.Show
            End If
       Case "query"
            t = check_qx(czry_flag, 9)
            If t = True Then
               MainForm.StatusBar1.Panels(1).Text = "状态： 操作员维护"
               frmsq.Show
            End If
       Case "input"
            t = check_qx(czry_flag, 2)
            If t = True Then
               MainForm.StatusBar1.Panels(1).Text = "状态： 商品信息输入"
               FrmAddGood.Show
            End If
       Case "drdc"
            t = check_qx(czry_flag, 11)
            If t = True Then
               MainForm.StatusBar1.Panels(1).Text = "状态： 每月数据导出"
               frmDataOutput.Show
            End If
       Case "good"
            t = check_qx(czry_flag, 10)
            If t = True Then
               MainForm.StatusBar1.Panels(1).Text = "状态： 查询商品报表"
               GoodInfoDataReport.Show
            End If
       Case "exit"
            End
  End Select
End Sub
'Download by http://www.codefans.net
Private Sub xgkl_Click()
  MainForm.StatusBar1.Panels(1).Text = "状态： 修改口令"
  changepswd.Show
End Sub