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

📄 mdiform1.frm

📁 用VB做的一个数据库管理系统
💻 FRM
📖 第 1 页 / 共 2 页
字号:
VERSION 5.00
Object = "{6B7E6392-850A-101B-AFC0-4210102A8DA7}#1.3#0"; "COMCTL32.OCX"
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.MDIForm MDIForm1 
   BackColor       =   &H00808000&
   Caption         =   "仓库管理系统"
   ClientHeight    =   6330
   ClientLeft      =   60
   ClientTop       =   630
   ClientWidth     =   11880
   Icon            =   "MDIForm1.frx":0000
   LinkTopic       =   "MDIForm1"
   LockControls    =   -1  'True
   StartUpPosition =   2  '屏幕中心
   WindowState     =   2  'Maximized
   Begin VB.PictureBox picTools 
      Align           =   1  'Align Top
      AutoRedraw      =   -1  'True
      BorderStyle     =   0  'None
      Height          =   720
      Left            =   0
      ScaleHeight     =   720
      ScaleWidth      =   11880
      TabIndex        =   1
      Top             =   0
      Width           =   11880
      Begin MSComctlLib.ImageList ImageList1 
         Left            =   7005
         Top             =   345
         _ExtentX        =   1005
         _ExtentY        =   1005
         BackColor       =   -2147483643
         ImageWidth      =   32
         ImageHeight     =   32
         MaskColor       =   12632256
         _Version        =   393216
         BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
            NumListImages   =   12
            BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
               Picture         =   "MDIForm1.frx":030A
               Key             =   ""
            EndProperty
            BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
               Picture         =   "MDIForm1.frx":0BE6
               Key             =   ""
            EndProperty
            BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
               Picture         =   "MDIForm1.frx":0F02
               Key             =   ""
            EndProperty
            BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
               Picture         =   "MDIForm1.frx":121E
               Key             =   ""
            EndProperty
            BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
               Picture         =   "MDIForm1.frx":153A
               Key             =   ""
            EndProperty
            BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628} 
               Picture         =   "MDIForm1.frx":198E
               Key             =   ""
            EndProperty
            BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628} 
               Picture         =   "MDIForm1.frx":1DE2
               Key             =   ""
            EndProperty
            BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628} 
               Picture         =   "MDIForm1.frx":2236
               Key             =   ""
            EndProperty
            BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628} 
               Picture         =   "MDIForm1.frx":2552
               Key             =   ""
            EndProperty
            BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628} 
               Picture         =   "MDIForm1.frx":286E
               Key             =   ""
            EndProperty
            BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628} 
               Picture         =   "MDIForm1.frx":2B8A
               Key             =   ""
            EndProperty
            BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628} 
               Picture         =   "MDIForm1.frx":2EA6
               Key             =   ""
            EndProperty
         EndProperty
      End
      Begin MSComctlLib.Toolbar Toolbar1 
         Height          =   570
         Left            =   105
         TabIndex        =   2
         Top             =   105
         Width           =   8415
         _ExtentX        =   14843
         _ExtentY        =   1005
         ButtonWidth     =   1032
         ButtonHeight    =   1005
         Style           =   1
         ImageList       =   "ImageList1"
         DisabledImageList=   "ImageList1"
         HotImageList    =   "ImageList1"
         _Version        =   393216
         BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
            NumButtons      =   16
            BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Key             =   "StoreType"
               Object.ToolTipText     =   "仓库类型配置"
               ImageIndex      =   1
            EndProperty
            BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Key             =   "ProductType"
               Object.ToolTipText     =   "产品类型配置"
               ImageIndex      =   2
            EndProperty
            BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Key             =   "ProductKind"
               Object.ToolTipText     =   "产品种类配置"
               ImageIndex      =   3
            EndProperty
            BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Key             =   "AlertRef"
               Object.ToolTipText     =   "仓库报警参数设置"
               ImageIndex      =   4
            EndProperty
            BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Style           =   3
            EndProperty
            BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Key             =   "Import"
               Object.ToolTipText     =   "产品入库"
               ImageIndex      =   5
            EndProperty
            BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Key             =   "Export"
               Object.ToolTipText     =   "产品出库"
               ImageIndex      =   6
            EndProperty
            BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Key             =   "Adjust"
               Object.ToolTipText     =   "仓库调拨"
               ImageIndex      =   7
            EndProperty
            BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Key             =   "FindStore"
               Object.ToolTipText     =   "库存查询"
               ImageIndex      =   8
            EndProperty
            BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Style           =   3
            EndProperty
            BeginProperty Button11 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Key             =   "Alert"
               Object.ToolTipText     =   "查看报警的产品"
               ImageIndex      =   9
            EndProperty
            BeginProperty Button12 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Style           =   3
            EndProperty
            BeginProperty Button13 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Key             =   "Day"
               Object.ToolTipText     =   "每日一贴"
               ImageIndex      =   10
            EndProperty
            BeginProperty Button14 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Key             =   "SystemSet"
               Object.ToolTipText     =   "公司信息配置"
               ImageIndex      =   11
            EndProperty
            BeginProperty Button15 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Style           =   3
            EndProperty
            BeginProperty Button16 {66833FEA-8583-11D1-B16A-00C0F0283628} 
               Key             =   "Close"
               Object.ToolTipText     =   "退出系统"
               ImageIndex      =   12
            EndProperty
         EndProperty
      End
      Begin VB.Line Line2 
         BorderColor     =   &H00FFFFFF&
         X1              =   0
         X2              =   2235
         Y1              =   105
         Y2              =   105
      End
      Begin VB.Line Line1 
         X1              =   0
         X2              =   2265
         Y1              =   90
         Y2              =   90
      End
   End
   Begin ComctlLib.StatusBar StatusBar 
      Align           =   2  'Align Bottom
      Height          =   330
      Left            =   0
      TabIndex        =   0
      Top             =   6000
      Width           =   11880
      _ExtentX        =   20955
      _ExtentY        =   582
      SimpleText      =   ""
      _Version        =   327682
      BeginProperty Panels {0713E89E-850A-101B-AFC0-4210102A8DA7} 
         NumPanels       =   6
         BeginProperty Panel1 {0713E89F-850A-101B-AFC0-4210102A8DA7} 
            Alignment       =   2
            Bevel           =   2
            Object.Width           =   1942
            MinWidth        =   1942
            Text            =   "操作员:"
            TextSave        =   "操作员:"
            Key             =   ""
            Object.Tag             =   ""
         EndProperty
         BeginProperty Panel2 {0713E89F-850A-101B-AFC0-4210102A8DA7} 
            Object.Width           =   3528
            MinWidth        =   3528
            TextSave        =   ""
            Key             =   ""
            Object.Tag             =   ""
            Object.ToolTipText     =   "工具栏的提示信息"
         EndProperty
         BeginProperty Panel3 {0713E89F-850A-101B-AFC0-4210102A8DA7} 
            Alignment       =   1
            Object.Width           =   2469
            MinWidth        =   2469
            TextSave        =   ""
            Key             =   ""
            Object.Tag             =   ""
            Object.ToolTipText     =   "当前的日期"
         EndProperty
         BeginProperty Panel4 {0713E89F-850A-101B-AFC0-4210102A8DA7} 
            Style           =   5
            Alignment       =   1
            Object.Width           =   1411
            MinWidth        =   1411
            TextSave        =   "16:11"
            Key             =   ""
            Object.Tag             =   ""
            Object.ToolTipText     =   "当前的时间"
         EndProperty
         BeginProperty Panel5 {0713E89F-850A-101B-AFC0-4210102A8DA7} 
            Alignment       =   1
            Enabled         =   0   'False
            Object.Width           =   4939
            MinWidth        =   4939
            Text            =   "设计:俞思龙   调试:刘利"
            TextSave        =   "设计:俞思龙   调试:刘利"
            Key             =   ""
            Object.Tag             =   ""
            Object.ToolTipText     =   "传呼:1924727991 邮件:mickeysoft@yeah.net"
         EndProperty
         BeginProperty Panel6 {0713E89F-850A-101B-AFC0-4210102A8DA7} 
            Alignment       =   1
            AutoSize        =   1
            Enabled         =   0   'False
            Object.Width           =   6041
            MinWidth        =   5644
            Text            =   "制作单位:东化企业"
            TextSave        =   "制作单位:东化企业"
            Key             =   ""
            Object.Tag             =   ""
            Object.ToolTipText     =   "电话:0577-6263990  6269098  传真:6269096"
         EndProperty
      EndProperty
      MousePointer    =   99
      MouseIcon       =   "MDIForm1.frx":32FA
   End
   Begin VB.Menu MnuStoreC 
      Caption         =   "配置系统(&C)"
      Begin VB.Menu MnuStoreType 
         Caption         =   "配置仓库类型(&S) ...."
      End
      Begin VB.Menu MnuProductType 
         Caption         =   "配置产品类型(&P) ..."
      End
      Begin VB.Menu step12 
         Caption         =   "-"
      End
      Begin VB.Menu MnuProductConfig 
         Caption         =   "配置产品种类(&K) ..."
      End
      Begin VB.Menu step10 
         Caption         =   "-"
      End
      Begin VB.Menu MnuStoreRerence 
         Caption         =   "配置报警参数(&A) ..."
      End
   End
   Begin VB.Menu MnuStoreM 
      Caption         =   "仓库管理(&S)"
      Begin VB.Menu MnuProductE 
         Caption         =   "产品入库(&E) ..."
      End
      Begin VB.Menu MnuProductO 
         Caption         =   "产品出库(&O) ..."
      End
      Begin VB.Menu step20 
         Caption         =   "-"
      End
      Begin VB.Menu MnuStoreR 
         Caption         =   "仓库调拨(&R) ...."
      End
      Begin VB.Menu step21 
         Caption         =   "-"
      End
      Begin VB.Menu MnuStoreF 
         Caption         =   "库存查询(&F) ...."
      End
      Begin VB.Menu step28 
         Caption         =   "-"
      End
      Begin VB.Menu MnuKcAlert 
         Caption         =   "库存报警(&A)..."
      End
   End
   Begin VB.Menu Mnuhel 
      Caption         =   "系统管理(&H)"
      Begin VB.Menu MnuTip 
         Caption         =   "每日一贴(&T) ..."
      End
      Begin VB.Menu step2 
         Caption         =   "-"
      End
      Begin VB.Menu MnuCon 
         Caption         =   "系统的配置 ..."
         Shortcut        =   ^S
      End
      Begin VB.Menu mnuTools 
         Caption         =   "工具栏"
         Checked         =   -1  'True
         Shortcut        =   ^T
      End
      Begin VB.Menu MnuOperation 
         Caption         =   "操作员配置"
         Visible         =   0   'False
      End
      Begin VB.Menu step1 
         Caption         =   "-"
      End
      Begin VB.Menu MnuSof 
         Caption         =   "关于软件(&A) ..."
      End
      Begin VB.Menu MnuWxy 
         Caption         =   "WEB 上的 东化公司"
      End
      Begin VB.Menu step3 
         Caption         =   "-"
      End
      Begin VB.Menu MnuExi 
         Caption         =   "退出系统"
      End
   End
End
Attribute VB_Name = "MDIForm1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'**********************************
'**  Function Declarations: From Wenxingyuan

#If Win32 Then
Private Declare Function ShellExecute& Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long)
#Else
Private Declare Function ShellExecute% Lib "shell.dll" (ByVal hwnd As Integer, ByVal lpszOp As String, ByVal lpszFile As String, ByVal spszParams As String, ByVal lpszDir As String, ByVal fsShowCmd As Integer)
#End If 'WIN32

Private Sub MDIForm_Load()

CKCancel = False
Dim InNum As Integer
'配置图片
  'Menu.Show
Dim Ltp As Integer
Ltp = GetSetting(App.EXEName, "Options", "Show Tips at Startup", 1)
If Ltp = 1 Then
   frmTip.Show
End If

'配置工具栏
 mnuTools.Checked = GetSetting(App.EXEName, "Option", "Tools", 0)
 If mnuTools.Checked Then
    picTools.Visible = True
    Else
    picTools.Visible = False
 End If
'配置窗口大小
  MDIForm1.WindowState = GetSetting(App.EXEName, "Option", "Windows", 0)
StatusBar.Panels.Item(2).Text = UserText
StatusBar.Panels.Item(3).Text = "日期:" & Date
'配置
Dim DB As Database, Ef As Recordset, X As Integer
Dim TempArray(5) As String
On Error GoTo NoData
'阅读配置数据
Set DB = OpenDatabase(App.Path & "\Sys\Data.mdb", 0, 0, Constr)
Set Ef = DB.OpenRecordset("Config", dbOpenDynaset)
    For X = 0 To 5
      If Not IsNull(Ef.Fields(X).Value) Then
          TempArray(X) = Ef.Fields(X).Value
      End If
    Next
  DB.Close
MDIForm1.Caption = TempArray(0) + "-仓库管理系统"
MDIForm1.StatusBar.Panels.Item(6).Text = "制作单位:" + TempArray(0)
MDIForm1.StatusBar.Panels.Item(6).ToolTipText = "欢迎使用本软件"
On Error GoTo PhotoValible
MDIForm1.Picture = LoadPicture(TempArray(5))
 Dim AlertNo As Single
 On Error GoTo NoValible
 Dim TempFile As String, TempStr As String
 Dim AlertT As Boolean
 TempFile = Browser + "ALERT.YSL"
 InNum = FreeFile
 Open TempFile For Input As #InNum
  Line Input #InNum, TempStr
  Line Input #InNum, TempFile
  Close #InNum
  AlertNo = Val(TempStr)
 On Error GoTo 0
Set DB = OpenDatabase(App.Path & "\Sys\Store.mdb", 0, 0, Constr)
    TempStr = "Delete * From AlKcK"
    DB.Execute TempStr
    AlertT = False
Set Ef = DB.OpenRecordset("Select 仓库类型,产品类型,产品名称,数量 From KCK", dbOpenDynaset)
    Do Until Ef.EOF
      If Not IsNull(Ef.Fields(0).Value) Then
         TempArray(0) = Ef.Fields(0).Value
      End If
      If Not IsNull(Ef.Fields(1).Value) Then
         TempArray(1) = Ef.Fields(1).Value
      End If
      If Not IsNull(Ef.Fields(2).Value) Then

⌨️ 快捷键说明

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