📄 fangke.frm
字号:
VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form fangke
Caption = "旅客信息查询"
ClientHeight = 5055
ClientLeft = 60
ClientTop = 345
ClientWidth = 8205
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 5055
ScaleWidth = 8205
Begin VB.PictureBox Picture1
Height = 5055
Left = 0
ScaleHeight = 4995
ScaleWidth = 8115
TabIndex = 0
Top = 0
Width = 8175
Begin VB.CommandButton Command2
Height = 375
Left = 3600
Picture = "fangke.frx":0000
Style = 1 'Graphical
TabIndex = 6
Top = 4440
Width = 375
End
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid3
Height = 1335
Left = 5400
TabIndex = 3
Top = 2760
Width = 2295
_ExtentX = 4048
_ExtentY = 2355
_Version = 393216
BackColorBkg = 16777215
End
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid2
Height = 1335
Left = 360
TabIndex = 2
Top = 2760
Width = 4935
_ExtentX = 8705
_ExtentY = 2355
_Version = 393216
Cols = 7
BackColor = 16777215
BackColorBkg = 16777215
End
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1
Height = 2055
Left = 360
TabIndex = 1
Top = 360
Width = 7335
_ExtentX = 12938
_ExtentY = 3625
_Version = 393216
Cols = 5
BackColorBkg = 16777215
End
Begin VB.Label Label2
Caption = "( 所住房间 )"
ForeColor = &H000000FF&
Height = 200
Left = 5520
TabIndex = 5
Top = 4200
Width = 1095
End
Begin VB.Label Label1
Caption = "( 同行旅客 )"
ForeColor = &H000000FF&
Height = 200
Left = 480
TabIndex = 4
Top = 4200
Width = 975
End
End
End
Attribute VB_Name = "fangke"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim m_no As String '帐单号
Private Sub Command2_Click()
Unload Me
main.Show
End Sub
Private Sub Form_Load()
Call LoadInstall
Call LoadsFangKe
End Sub
'窗体初始化
Private Sub LoadInstall()
'窗口居中
Me.Left = (Screen.Width - Me.Width) / 2
Me.Top = (Screen.Height - Me.Height) / 2 - 550
'初始化表格窗体
MSFlexGrid1.ColWidth(0) = 500
MSFlexGrid1.ColWidth(1) = 1500
MSFlexGrid1.ColWidth(2) = 1000
MSFlexGrid1.ColWidth(3) = 2000
MSFlexGrid1.ColWidth(4) = 1000
MSFlexGrid2.ColWidth(0) = 300
MSFlexGrid2.ColWidth(1) = 700
MSFlexGrid2.ColWidth(2) = 500
MSFlexGrid2.ColWidth(3) = 800
MSFlexGrid2.ColWidth(4) = 2000
MSFlexGrid2.ColWidth(5) = 2000
MSFlexGrid2.ColWidth(6) = 2000
MSFlexGrid3.ColWidth(0) = 700
MSFlexGrid3.ColWidth(1) = 1000
'---------------------------------------------------------
'初始化表格名称
MSFlexGrid1.TextMatrix(0, 1) = "帐单编号"
MSFlexGrid1.TextMatrix(0, 2) = "旅客名称"
MSFlexGrid1.TextMatrix(0, 3) = "入住时间"
MSFlexGrid1.TextMatrix(0, 4) = "入住人数"
MSFlexGrid2.TextMatrix(0, 1) = "姓名"
MSFlexGrid2.TextMatrix(0, 2) = "性别"
MSFlexGrid2.TextMatrix(0, 3) = "证件名称"
MSFlexGrid2.TextMatrix(0, 4) = "证件编码"
MSFlexGrid2.TextMatrix(0, 5) = "工作单位"
MSFlexGrid2.TextMatrix(0, 6) = "籍贯住址"
MSFlexGrid3.TextMatrix(0, 1) = "房间号"
End Sub
Private Sub LoadsFangKe() '加载入住房客相关信息
Dim str As String
str = "select * from guest where numb not like '1'"
Dim myrs As ADODB.Recordset
Set myrs = New ADODB.Recordset
myrs.CursorLocation = adUseClient
myrs.LockType = adLockOptimistic
myrs.CursorType = adOpenDynamic
myrs.Open str, myCon
Dim m As Integer
Dim m_sum As Integer
m_sum = myrs.RecordCount
MSFlexGrid1.Rows = MSFlexGrid1.Rows + m_sum - 1
For m = 1 To m_sum
With MSFlexGrid1
.TextMatrix(m, 1) = myrs("numb")
.TextMatrix(m, 2) = myrs("nam")
.TextMatrix(m, 3) = myrs("tim")
.TextMatrix(m, 4) = myrs("sums")
End With
myrs.MoveNext
Next
End Sub
Private Sub MSFlexGrid1_Click()
Call LoadInfo1
Call LoadInfo2
End Sub
Private Sub LoadInfo1() '加载某具体房客相关信息
With MSFlexGrid1
If .Rows = 1 Or .MouseRow = 0 Then
MsgBox "请选择旅客!", vbExclamation
Else
m_no = .TextMatrix(.MouseRow, 1)
Dim str As String
str = "select * from guest where numb='" & m_no & "'"
Dim myrs As ADODB.Recordset
Set myrs = New ADODB.Recordset
myrs.CursorLocation = adUseClient
myrs.LockType = adLockOptimistic
myrs.CursorType = adOpenDynamic
myrs.Open str, myCon
MSFlexGrid2.TextMatrix(1, 1) = myrs("nam")
If myrs("sexs") = 0 Then
MSFlexGrid2.TextMatrix(1, 2) = "男"
Else
MSFlexGrid2.TextMatrix(1, 2) = "女"
End If
MSFlexGrid2.TextMatrix(1, 3) = myrs("zhengjian")
MSFlexGrid2.TextMatrix(1, 4) = myrs("hao")
MSFlexGrid2.TextMatrix(1, 5) = myrs("danwei")
MSFlexGrid2.TextMatrix(1, 6) = myrs("addr")
End If
End With
End Sub
Private Sub LoadInfo2() '加载某具体房客所住房间
With MSFlexGrid3
Dim sum As Integer
sum = MSFlexGrid3.Rows - 1
Dim n As Integer
For n = sum To 2 Step -1
MSFlexGrid3.RemoveItem (n)
Next
If MSFlexGrid1.MouseRow = 0 Then
MsgBox "请选择旅客!", vbExclamation
Else
' m_no = MSFlexGrid1.TextMatrix(.MouseRow, 1)
Dim str As String
str = "select * from guestinfo where numb='" & m_no & "'"
Dim myrs As ADODB.Recordset
Set myrs = New ADODB.Recordset
myrs.CursorLocation = adUseClient
myrs.LockType = adLockOptimistic
myrs.CursorType = adOpenDynamic
myrs.Open str, myCon
Dim m_sum As Integer
m_sum = myrs.RecordCount
If m_sum > 1 Then
.Rows = .Rows + m_sum - 1
End If
Dim m As Integer
For m = 1 To m_sum
.TextMatrix(m, 1) = myrs("houseno")
myrs.MoveNext
Next
End If
End With
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -