📄 mainmdiform.frm
字号:
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.MDIForm mainmdiform
BackColor = &H8000000C&
Caption = "狼人供销信息查询系统"
ClientHeight = 4170
ClientLeft = 60
ClientTop = 630
ClientWidth = 8745
Icon = "mainmdiform.frx":0000
LinkTopic = "MDIForm1"
StartUpPosition = 2 '屏幕中心
Begin MSComctlLib.ImageList ImageList1
Left = 8040
Top = 120
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 16
ImageHeight = 16
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 16
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":08CA
Key = ""
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":15A4
Key = ""
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":21AE
Key = ""
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":2C50
Key = ""
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":37E2
Key = ""
EndProperty
BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":4494
Key = ""
EndProperty
BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":4FAE
Key = ""
EndProperty
BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":5C1C
Key = ""
EndProperty
BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":68CE
Key = ""
EndProperty
BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":6A9A
Key = ""
EndProperty
BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":76EC
Key = ""
EndProperty
BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":9EF6
Key = ""
EndProperty
BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":A6C8
Key = ""
EndProperty
BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":B20A
Key = ""
EndProperty
BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":BC7C
Key = ""
EndProperty
BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "mainmdiform.frx":C886
Key = ""
EndProperty
EndProperty
End
Begin MSComDlg.CommonDialog CommonDialog1
Left = 7560
Top = 240
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin MSComctlLib.StatusBar StatusBar1
Align = 2 'Align Bottom
Height = 255
Left = 0
TabIndex = 1
Top = 3915
Width = 8745
_ExtentX = 15425
_ExtentY = 450
Style = 1
SimpleText = "狼人信息查询系统"
_Version = 393216
BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628}
NumPanels = 1
BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628}
EndProperty
EndProperty
End
Begin MSComctlLib.Toolbar Toolbar1
Align = 1 'Align Top
Height = 420
Left = 0
TabIndex = 0
Top = 0
Width = 8745
_ExtentX = 15425
_ExtentY = 741
ButtonWidth = 609
ButtonHeight = 582
AllowCustomize = 0 'False
Appearance = 1
ImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 22
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "打开厂家表"
ImageIndex = 2
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "打开产品表"
ImageIndex = 3
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "打开销售表"
ImageIndex = 4
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "打开商场表"
ImageIndex = 5
EndProperty
BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "字段查找"
ImageIndex = 6
EndProperty
BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "条件查询"
ImageIndex = 7
EndProperty
BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "交叉查询"
ImageIndex = 8
EndProperty
BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "添加"
ImageIndex = 9
EndProperty
BeginProperty Button11 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "删除"
ImageIndex = 10
EndProperty
BeginProperty Button12 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button13 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "厂家年总产值图表"
ImageIndex = 11
EndProperty
BeginProperty Button14 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "商场年销售总额图表"
ImageIndex = 12
EndProperty
BeginProperty Button15 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button16 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "厂家报表"
ImageIndex = 13
EndProperty
BeginProperty Button17 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "产品报表"
ImageIndex = 14
EndProperty
BeginProperty Button18 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "销售报表"
ImageIndex = 15
EndProperty
BeginProperty Button19 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "商场报表"
ImageIndex = 16
EndProperty
BeginProperty Button20 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button21 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button22 {66833FEA-8583-11D1-B16A-00C0F0283628}
Object.ToolTipText = "关于(按F1提供更多帮助)"
ImageIndex = 1
EndProperty
EndProperty
End
Begin VB.Menu file
Caption = "文件"
Begin VB.Menu file1
Caption = "打开厂家表"
End
Begin VB.Menu file2
Caption = "打开产品表"
End
Begin VB.Menu file3
Caption = "打开销售表"
End
Begin VB.Menu file4
Caption = "打开商场表"
End
Begin VB.Menu line1
Caption = "-"
End
Begin VB.Menu print1
Caption = "打印图表"
End
Begin VB.Menu line2
Caption = "-"
End
Begin VB.Menu exit1
Caption = "退出"
End
End
Begin VB.Menu edit
Caption = "编辑"
Begin VB.Menu addnew
Caption = "添加记录"
End
Begin VB.Menu delnew
Caption = "删除记录"
End
Begin VB.Menu line3
Caption = "-"
End
Begin VB.Menu wordcheck
Caption = "字段查找"
End
Begin VB.Menu ifcheck
Caption = "条件查询"
End
Begin VB.Menu changefind
Caption = "交叉查询"
End
End
Begin VB.Menu visul
Caption = "显示"
Begin VB.Menu tool
Caption = "工具条"
End
Begin VB.Menu line4
Caption = "-"
End
Begin VB.Menu tabel1
Caption = "厂家年总厂值图表"
End
Begin VB.Menu table2
Caption = "商场年销售总额图表"
End
End
Begin VB.Menu repor
Caption = "报表"
Begin VB.Menu repor1
Caption = "厂家报表"
End
Begin VB.Menu repor2
Caption = "产品报表"
End
Begin VB.Menu repor3
Caption = "销售报表"
End
Begin VB.Menu repor4
Caption = "商场报表"
End
End
Begin VB.Menu more
Caption = "其它"
Begin VB.Menu aboat1
Caption = "管理员"
End
Begin VB.Menu line5
Caption = "-"
End
Begin VB.Menu aboat2
Caption = "产品开发 (F1)"
HelpContextID = 1
End
Begin VB.Menu line6
Caption = "-"
End
Begin VB.Menu aboat
Caption = "关于"
End
End
End
Attribute VB_Name = "mainmdiform"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private rs As New ADODB.Recordset
Private strconn As String
Private strsql As String
Private intcode As Integer
Private del1 As Integer
Private Declare Function OSHelp% Lib "user32" Alias "WinHelpA" (ByVal hwnd&, ByVal HelpFile$, ByVal wCommand%, dwData As Any)
Private Sub aboat_Click()
aboatform.Show
End Sub
Private Sub aboat1_Click()
If xulang2 <> 1 Then
Exit Sub
End If
If che1 = 1 Then
Exit Sub
End If
passwordform.Show
End Sub
Private Sub aboat2_Click()
Dim nRet As Integer
If Len(App.Path & "\xu.hlp") = 0 Then
MsgBox "无法显示帮助目录，该工程没有相关联的帮助。", vbInformation, Me.Caption
Else
On Error Resume Next
nRet = OSHelp(Me.hwnd, App.Path & "\xu.hlp", 261, 0)
If Err Then
MsgBox Err.Description
End If
End If
End Sub
Private Sub addnew_Click()
If pass1 = 1 Then
Exit Sub
End If
If che1 = 1 Then
Exit Sub
End If
If xiaochuocha1 = 1 Then
Exit Sub
End If
If chunjiacha1 = 1 Then
Exit Sub
End If
If chanpincha1 = 1 Then
Exit Sub
End If
If unioform1 = 1 Then
Exit Sub
End If
If unioform2 = 1 Then
Exit Sub
End If
If chatform11 = 1 Then
Exit Sub
End If
If chatform21 = 1 Then
Exit Sub
End If
If mainform.SSTab1.Tab = 0 Then
chunjiaform.Show
End If
If mainform.SSTab1.Tab = 1 Then
chanpinform.Show
End If
If mainform.SSTab1.Tab = 2 Then
xiaochuoform.Show
End If
If mainform.SSTab1.Tab = 3 Then
xianchianform.Show
End If
End Sub
Private Sub changefind_Click()
mainmdiform.file1.Checked = False
mainmdiform.file2.Checked = False
mainmdiform.file3.Checked = False
mainmdiform.file4.Checked = False
If mainform1 = 1 Then
Unload mainform
mainform1 = 0
End If
If pass1 = 1 Then
Exit Sub
End If
If xiaochuocha1 = 1 Then
Exit Sub
End If
If chunjiacha1 = 1 Then
Exit Sub
End If
If chanpincha1 = 1 Then
Exit Sub
End If
If chatform11 = 1 Then
Exit Sub
End If
If chatform21 = 1 Then
Exit Sub
End If
If sst = 1 Or sst = 2 Then
unioncha1.Show
End If
If sst = 3 Or sst = 4 Then
unioncha2.Show
End If
End Sub
Private Sub delnew_Click()
If pass1 = 1 Then
Exit Sub
End If
If che1 = 1 Then
Exit Sub
End If
If unioform1 = 1 Then
Exit Sub
End If
If unioform2 = 1 Then
Exit Sub
End If
If chanpincha1 = 1 Then
Exit Sub
End If
If chunjiacha1 = 1 Then
Exit Sub
End If
If xiaochuocha1 = 1 Then
Exit Sub
End If
If chatform11 = 1 Then
Exit Sub
End If
If chatform21 = 1 Then
Exit Sub
End If
On Error Resume Next
mainmdiform.StatusBar1.SimpleText = "删除记录... ..."
If mainform.SSTab1.Tab = 0 Then
If MsgBox("确定要删除记录吗？", vbYesNo, "删除记录") = vbYes Then
mainform.Adodc1.Recordset.Delete
End If
End If
If mainform.SSTab1.Tab = 1 Then
If MsgBox("确定要删除记录吗？", vbYesNo, "删除记录") = vbYes Then
mainform.Adodc2.Recordset.Delete
End If
End If
If mainform.SSTab1.Tab = 2 Then
If MsgBox("确定要删除记录吗？", vbYesNo, "删除记录") = vbYes Then
mainform.Adodc3.Recordset.Delete
End If
End If
If mainform.SSTab1.Tab = 3 Then
If MsgBox("确定要删除记录吗？", vbYesNo, "删除记录") = vbYes Then
mainform.Adodc4.Recordset.Delete
End If
End If
End Sub
Private Sub exit1_Click()
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -