📄 setroo.frm
字号:
VERSION 5.00
Begin VB.Form setroo
BorderStyle = 3 'Fixed Dialog
Caption = "客房设置"
ClientHeight = 5220
ClientLeft = 45
ClientTop = 330
ClientWidth = 8160
LinkTopic = "Form1"
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
ScaleHeight = 5220
ScaleWidth = 8160
ShowInTaskbar = 0 'False
Begin VB.ComboBox Comb1
Height = 300
Left = 1200
TabIndex = 19
Top = 600
Width = 1335
End
Begin VB.Frame Frame1
Caption = "客房新标准"
Height = 3015
Left = 120
TabIndex = 9
Top = 1080
Visible = 0 'False
Width = 7815
Begin VB.TextBox Text3
Height = 375
Index = 0
Left = 1320
Locked = -1 'True
TabIndex = 24
Top = 960
Width = 1575
End
Begin VB.TextBox Text3
Height = 2055
Index = 3
Left = 5880
Locked = -1 'True
MultiLine = -1 'True
ScrollBars = 2 'Vertical
TabIndex = 23
Top = 600
Width = 1695
End
Begin VB.TextBox Text3
Height = 375
Index = 2
Left = 1320
Locked = -1 'True
TabIndex = 22
Top = 2160
Width = 1575
End
Begin VB.TextBox Text3
Height = 375
Index = 1
Left = 1320
Locked = -1 'True
TabIndex = 21
Top = 1560
Width = 1575
End
Begin VB.ComboBox Comb2
Height = 300
Left = 1320
TabIndex = 20
Top = 360
Width = 1575
End
Begin VB.CheckBox Check1
Caption = "有无空调"
Height = 495
Index = 0
Left = 3840
TabIndex = 14
Top = 120
Width = 1215
End
Begin VB.CheckBox Check1
Caption = "有无电话"
Height = 495
Index = 1
Left = 3840
TabIndex = 13
Top = 840
Width = 1215
End
Begin VB.CheckBox Check1
Caption = "有无电视"
Height = 255
Index = 2
Left = 3840
TabIndex = 12
Top = 1560
Width = 1215
End
Begin VB.CheckBox Check1
Caption = "有无卫生间"
Height = 495
Index = 3
Left = 3840
TabIndex = 11
Top = 2160
Width = 1215
End
Begin VB.Label Label1
Caption = "床位数"
Height = 375
Index = 2
Left = 600
TabIndex = 18
Top = 960
Width = 615
End
Begin VB.Label Label1
Caption = "单价"
Height = 255
Index = 4
Left = 720
TabIndex = 17
Top = 2160
Width = 495
End
Begin VB.Label Label1
Caption = "面积"
Height = 255
Index = 5
Left = 720
TabIndex = 16
Top = 1560
Width = 495
End
Begin VB.Label Label1
Caption = "备注"
Height = 375
Index = 1
Left = 6000
TabIndex = 15
Top = 240
Width = 615
End
Begin VB.Label Label1
Caption = "客房新标准"
Height = 255
Index = 0
Left = 240
TabIndex = 10
Top = 360
Width = 1095
End
End
Begin VB.TextBox Text2
Height = 375
Left = 3720
Locked = -1 'True
TabIndex = 8
Top = 600
Width = 1455
End
Begin VB.TextBox Text1
Height = 375
Index = 0
Left = 6480
Locked = -1 'True
TabIndex = 7
Top = 600
Width = 1455
End
Begin VB.CommandButton Command4
Caption = "返回"
Height = 495
Left = 6120
TabIndex = 5
Top = 4320
Width = 1215
End
Begin VB.CommandButton Command3
Caption = "删除"
Height = 495
Left = 4200
TabIndex = 4
Top = 4320
Width = 1215
End
Begin VB.CommandButton Command2
Caption = "添加"
Height = 495
Left = 720
TabIndex = 3
Top = 4320
Width = 1215
End
Begin VB.CommandButton Command1
Caption = "更新"
Height = 495
Left = 2280
TabIndex = 2
Top = 4320
Width = 1215
End
Begin VB.Label Label2
Caption = " 添加新客房或者更新客房，请单击添加或者更新！"
BeginProperty Font
Name = "隶书"
Size = 21.75
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 1935
Left = 1800
TabIndex = 25
Top = 1680
Width = 4575
End
Begin VB.Label Label4
Caption = "客房状态"
Height = 255
Left = 5520
TabIndex = 6
Top = 720
Width = 735
End
Begin VB.Label Label3
Caption = "客房编号"
Height = 255
Index = 0
Left = 240
TabIndex = 1
Top = 600
Width = 735
End
Begin VB.Label Label3
Caption = "客房标准"
Height = 375
Index = 4
Left = 2880
TabIndex = 0
Top = 720
Width = 855
End
End
Attribute VB_Name = "setroo"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim mydb As Database
Dim mydb1 As Database
Dim myrs As Recordset
Dim myrs1 As Recordset
Private Sub Comb1_Change()
Comb1_Click
End Sub
Private Sub Comb1_Click()
Set mydb1 = Workspaces(0).OpenDatabase(App.Path & "\data\data.mdb")
Set myrs1 = mydb1.OpenRecordset("客房表", dbOpenDynaset)
myrs1.FindFirst "客房编号 = " + Chr(34) + Comb1.Text + Chr(34) + ""
Text2.Text = myrs1.Fields(1)
Text1(0).Text = myrs1.Fields(2)
myrs1.Close
mydb1.Close
End Sub
Private Sub Comb2_Change()
Comb2_Click
End Sub
Private Sub Comb2_Click()
Set mydb1 = Workspaces(0).OpenDatabase(App.Path & "\data\data.mdb")
Set myrs1 = mydb1.OpenRecordset("客房标准", dbOpenDynaset)
myrs1.FindFirst "客房标准 = " + Chr(34) + Comb2.Text + Chr(34) + ""
For i = 0 To 2
Text3(i).Text = myrs1.Fields(i + 1)
Next
For i = 0 To 3
If myrs1.Fields(i + 4) = "无" Then
Check1(i) = 0
Else
Check1(i) = 1
End If
Next
Text3(3).Text = myrs1.Fields(8)
myrs1.Close
mydb1.Close
End Sub
Private Sub Command1_Click()
If Frame1.Visible = False Then
Frame1.Visible = True
Else
Set mydb = Workspaces(0).OpenDatabase(App.Path & "\data\data.mdb")
Set myrs1 = mydb.OpenRecordset("客房标准", dbOpenDynaset)
myrs1.FindFirst "客房标准 = " + Chr(34) + Comb2.Text + Chr(34) + ""
If Not myrs1.NoMatch Then
Set myrs = mydb.OpenRecordset("客房表", dbOpenDynaset)
myrs.FindFirst "客房编号 = " + Chr(34) + Comb1.Text + Chr(34) + ""
If Not myrs.NoMatch Then
myrs.Edit
myrs.Fields("客房标准") = Comb2.Text
myrs.Update
myrs.Close
Text2.Text = Comb2.Text
MsgBox ("客房信息更新成功！")
Frame1.Visible = False
Else
MsgBox ("无此客房编号！"), 48, "警告"
End If
Else
MsgBox ("无此客房标准！"), 48, "警告"
End If
mydb.Close
End If
End Sub
Private Sub Command2_Click()
If Frame1.Visible = False Then
Frame1.Visible = True
Text2.Text = ""
Else
Set mydb = Workspaces(0).OpenDatabase(App.Path & "\data\data.mdb")
Set myrs1 = mydb.OpenRecordset("客房标准", dbOpenDynaset)
myrs1.FindFirst "客房标准 = " + Chr(34) + Comb2.Text + Chr(34) + ""
If Not myrs1.NoMatch Then
Set myrs = mydb.OpenRecordset("客房表", dbOpenDynaset)
myrs.FindFirst "客房编号 = " + Chr(34) + Comb1.Text + Chr(34) + ""
If myrs.NoMatch Then
myrs.AddNew
myrs.Fields(0) = Comb1.Text
myrs.Fields(1) = Comb2.Text
myrs.Fields(2) = "无"
myrs.Update
myrs.Close
Text2.Text = Comb2.Text
Comb1.AddItem Comb1.Text
MsgBox ("客房信息添加成功！")
Frame1.Visible = False
Else
MsgBox ("此客房编号已经存在！"), 48, "警告"
Comb1.SetFocus
End If
Else
MsgBox ("无此客房标准！"), 48, "警告"
End If
mydb.Close
End If
End Sub
Private Sub Command3_Click()
Dim MESSAGE As String
Set mydb = Workspaces(0).OpenDatabase(App.Path & "\data\data.mdb")
Set myrs = mydb.OpenRecordset("客房表", dbOpenDynaset)
myrs.FindFirst "客房编号 = " + Chr(34) + Comb1.Text + Chr(34) + ""
If Not myrs.NoMatch Then
MESSAGE = MsgBox("确定删除吗？", 1, "删除")
If MESSAGE = vbOK Then
myrs.Delete
myrs.MoveNext
Comb1.RemoveItem Comb1.ListIndex
MsgBox ("客房编号删除成功！")
End If
Else
MsgBox ("无此客房编号！"), 48, "警告"
End If
myrs.Close
mydb.Close
End Sub
Private Sub Command4_Click()
Unload Me
End Sub
Private Sub Form_Load()
Comb1.Clear
left = 100
Top = 100
Comb2.Clear
Set mydb = Workspaces(0).OpenDatabase(App.Path & "\data\data.mdb") '设置数据库
sql = "select 客房编号 from 客房表"
Set myrs = mydb.OpenRecordset(sql)
If myrs.EOF = False Then myrs.MoveLast
If myrs.BOF = False Then myrs.MoveFirst
For i = 0 To myrs.RecordCount - 1
If myrs.Fields(0) <> "" Then Comb1.AddItem (myrs.Fields(0)) '添加到列表框
myrs.MoveNext
Next i
If Comb1.ListCount > 0 Then Comb1.ListIndex = 0
Set mydb1 = Workspaces(0).OpenDatabase(App.Path & "\data\data.mdb") '设置数据库
sql = "select 客房标准 from 客房标准"
Set myrs1 = mydb1.OpenRecordset(sql)
If myrs1.EOF = False Then myrs1.MoveLast
If myrs1.BOF = False Then myrs1.MoveFirst
For i = 0 To myrs1.RecordCount - 1
If myrs1.Fields(0) <> "" Then Comb2.AddItem (myrs1.Fields(0)) '添加到列表框
myrs1.MoveNext
Next i
If Comb2.ListCount > 0 Then Comb2.ListIndex = 0
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -