📄 boss.frm
字号:
Begin VB.CommandButton Command1
Caption = "查 询"
Height = 375
Left = 8160
TabIndex = 5
Top = 600
Width = 1095
End
Begin VB.ComboBox Combo4
BackColor = &H00E0E0E0&
ForeColor = &H00000000&
Height = 300
Left = 5760
TabIndex = 4
Text = "Combo1"
Top = 840
Width = 1935
End
Begin VB.ComboBox Combo3
BackColor = &H00E0E0E0&
ForeColor = &H00000000&
Height = 300
Left = 5760
TabIndex = 3
Text = "Combo1"
Top = 360
Width = 1935
End
Begin VB.ComboBox Combo2
BackColor = &H00E0E0E0&
ForeColor = &H00000000&
Height = 300
Left = 2040
TabIndex = 2
Text = "Combo1"
Top = 840
Width = 1695
End
Begin VB.ComboBox Combo1
BackColor = &H00E0E0E0&
ForeColor = &H00000000&
Height = 300
Left = 2040
TabIndex = 1
Text = "Combo1"
Top = 360
Width = 1695
End
Begin VB.Label Label4
AutoSize = -1 'True
Caption = "请选择BOSS的等级"
Height = 180
Left = 4200
TabIndex = 9
Top = 900
Width = 1440
End
Begin VB.Label Label3
AutoSize = -1 'True
Caption = "请选择BOSS的名称"
Height = 180
Left = 4200
TabIndex = 8
Top = 420
Width = 1440
End
Begin VB.Label Label2
AutoSize = -1 'True
Caption = "请选择BOSS的类型"
Height = 180
Left = 240
TabIndex = 7
Top = 900
Width = 1440
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "请选择BOSS出现地点"
Height = 180
Left = 240
TabIndex = 6
Top = 420
Width = 1620
End
End
Begin VB.Data Data1
Caption = "Data1"
Connect = "Access"
DatabaseName = "C:\征途boss查询\SkillBookLost.mdb"
DefaultCursorType= 0 '缺省游标
DefaultType = 2 '使用 ODBC
Exclusive = 0 'False
Height = 375
Left = 5760
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = "boss"
Top = 8280
Visible = 0 'False
Width = 3375
End
Begin VB.Label Label7
AutoSize = -1 'True
Caption = "秘笈"
Height = 180
Left = 6720
TabIndex = 43
Top = 4920
Width = 360
End
Begin VB.Label Label12
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00C00000&
Height = 255
Left = 7320
TabIndex = 38
Top = 5400
Width = 1695
End
Begin VB.Label Label15
AutoSize = -1 'True
Caption = "重要信息显示"
ForeColor = &H00FF0000&
Height = 180
Left = 600
TabIndex = 31
Top = 8377
Width = 1080
End
Begin VB.Label Label14
AutoSize = -1 'True
Caption = "Label14"
ForeColor = &H00FF0000&
Height = 180
Left = 1920
TabIndex = 30
Top = 8377
Width = 1080
End
Begin VB.Label Label10
AutoSize = -1 'True
Caption = "BOSS数据显示"
ForeColor = &H00FF0000&
Height = 180
Left = 600
TabIndex = 18
Top = 7920
Width = 1080
End
Begin VB.Label Label8
AutoSize = -1 'True
Caption = "BOSS刷新时间即时提示"
ForeColor = &H000000FF&
Height = 180
Left = 600
TabIndex = 15
Top = 8760
Width = 1800
End
Begin VB.Label Label9
BackColor = &H00000000&
BeginProperty Font
Name = "隶书"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H000080FF&
Height = 375
Left = 240
TabIndex = 14
Top = 9000
Visible = 0 'False
Width = 10575
End
End
Attribute VB_Name = "FormBossQuery"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim db As Database
Dim skillno As Variant
Dim rst, rst1 As Recordset
Const BossAppearMap = "BOSS所在的地图"
Const BossType = "BOSS的类型"
Const BossName = "BOSS的名称"
Const BossLevel = "BOSS的等级"
Const CaptionBossNo = "还没有BOSS出现在人间"
Private Sub cmdBrowse_Click()
FormBossQuery.Hide
FormBossRemainTime.Show
'如果已经查看过 , 则清除有新消息提示
Me.Caption = "征途辅助(蓝\黄\金\绿色BOSS\紫色BOSS及技能书掉落查询)"
End Sub
Private Sub Combo1_Click()
If Combo3.Text <> BossName Or Combo4.Text <> BossLevel Then
Combo3.Text = BossName '还原
Combo4.Text = BossLevel
End If
End Sub
Private Sub Combo1_KeyDown(KeyCode As Integer, Shift As Integer)
'如果输入的文本匹配列表框中的任何一个数据,则立即找到这个数据,并显示在列表框中第一项目中
If KeyCode = 13 Then
For i = 0 To Combo1.ListCount - 1
If InStr(Left(Combo1.List(i), 1) + Right(Combo1.List(i), 2), Combo1.Text) Then
Combo1.Text = Combo1.List(i)
End If
Next i
End If
End Sub
Private Sub Combo2_Click()
If Combo3.Text <> BossName Then Combo3.Text = BossName
If Combo4.Text <> BossLevel Then Combo4.Text = BossLevel
End Sub
Private Sub Combo3_Click()
If Combo1.Text <> BossAppearMap Or Combo2.Text <> BossType Or Combo4.Text <> BossLevel Then
Combo1.Text = BossAppearMap
Combo2.Text = BossType '还原
Combo4.Text = BossLevel
End If
End Sub
Private Sub Combo4_Click()
If Combo3.Text <> BossName Then
Combo3.Text = BossName '还原
End If
End Sub
Private Sub Combo5_Click()
ItemClear
SQL5 = "Select Series.Name from occupation inner join Series on Occupation.OccupationID =Series.[OccupationID] where [Occupation].[Name] =" + Chr(34) + Combo5.Text + Chr(34) + ""
Set rst5 = db.OpenRecordset(SQL5)
rst5.MoveFirst
Do While Not rst5.EOF
Combo6.AddItem rst5!Name
rst5.MoveNext
Loop
End Sub
Private Sub Combo6_Click()
ItemClearA
sql6 = "SELECT Skill.Name FROM Series INNER JOIN Skill ON [Series].[SeriesID] =[Skill].[SeriesID] where [Series].[Name] =" + Chr(34) + Combo6.Text + Chr(34) + ""
Set rst6 = db.OpenRecordset(sql6)
rst6.MoveFirst
Do While Not rst6.EOF
Combo7.AddItem rst6!Name
rst6.MoveNext
Loop
End Sub
Private Sub Combo7_Click()
'显示技能说明
Set rst = db.OpenRecordset("select Skill.Descript from Skill where Skill.Name=" + Chr(34) + Combo7.Text + Chr(34) + "")
rst.MoveFirst
Do Until rst.EOF
Label6.Caption = rst!Descript
Exit Do
Loop
'查询掉落此技能的所有怪物列表
If Check1.Value = 1 And Check2.Value = 0 Then
find8
title
sort1
MSFlexGrid1.TextMatrix(0, 6) = " 技能书名"
End If
If Check2.Value = 1 And Check1.Value = 0 Then
title
sort2 '按怪怪类型排序显示
find8
End If
showbosscolor
If Check1.Value = 0 And Check2.Value = 0 Then
'MsgBox "请选择一个排序条件，以便程序为你查询", vbOKOnly + vbInformation, "征途辅助"
title
find8
showbosscolor
End If
Label12.Caption = "共找到" & MSFlexGrid1.Rows - 1 & "条记录"
End Sub
Private Sub Command1_Click()
'如果用户什么都条件都没选择，提醒用户选择一个必要条件
If Combo1.Text = BossAppearMap And Combo2.Text = BossType And Combo3.Text = BossName And Combo4.Text = BossLevel Then
MsgBox "请选择一个必要条件以便程序为你查询", vbOKOnly + vbInformation
ShowAll
End If
'根据出现地点和怪物类型组合查询
If Combo3.Text = BossName And Combo4.Text = BossLevel And Combo1.Text <> BossAppearMap And Combo2.Text <> BossType Then find1
'根据怪物名称模糊查询
If Combo3.Text <> BossName And Combo1.Text = BossAppearMap And Combo2.Text = BossType And Combo4.Text = BossLevel Then _
find2
'根据怪物等级模糊查询
If Combo4.Text <> BossLevel And Combo1.Text = BossAppearMap And Combo2.Text = BossType And Combo3.Text = BossName Then _
find3
'根据怪特类型模糊查询
If Combo2.Text <> BossType And Combo1.Text = BossAppearMap And Combo3.Text = BossName And Combo4.Text = BossLevel Then _
find4
'根据出现地点和怪物等级组合查询
If Combo1.Text <> BossAppearMap And Combo4.Text <> BossLevel And Combo2.Text = BossType And Combo3.Text = BossName Then _
find5
'根据怪物类型和怪物等级组合查询
If Combo2.Text <> BossType And Combo4.Text <> BossLevel And Combo1.Text = BossAppearMap And Combo3.Text = BossName Then _
find6
'根据怪物出现地点模糊查询
If Combo1.Text <> BossAppearMap And Combo2.Text = BossType And Combo3.Text = BossName And Combo4.Text = BossLevel Then _
find7
title
sort
showbosscolor
Label12.Caption = "共找到" & Data1.Recordset.RecordCount & "条记录"
End Sub
Private Sub Command2_Click()
ShowAll
showbosscolor
Label12.Caption = "共有" & Data1.Recordset.RecordCount & "条记录"
If Check1.Value = 1 And Check2.Value = 0 Then
sort1 '按怪物等级
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -