?? frmshowyuding.frm
字號:
Left = 3840
TabIndex = 13
Top = 1680
Width = 1215
End
Begin VB.Label Label1
Caption = "業 務 員"
Height = 255
Index = 7
Left = 360
TabIndex = 12
Top = 2280
Width = 735
End
Begin VB.Label Label1
Caption = "預定日期"
Height = 255
Index = 8
Left = 4200
TabIndex = 11
Top = 2280
Width = 735
End
Begin VB.Label Label4
Caption = "月"
Height = 255
Index = 0
Left = 2760
TabIndex = 10
Top = 1680
Width = 375
End
End
End
Attribute VB_Name = "frmShowYuDing"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim rs_yd As New ADODB.Recordset
Dim rs_count As New ADODB.Recordset
Dim sqlyd As String
Dim sqlcount As String
Private Sub cmdClose_Click()
Unload Me
End Sub
Private Sub cmdEnd_Click()
'當單擊終止預定按鈕時，需要彈出一個提示框，警告用戶
Dim answer As String
answer = MsgBox("確定要終止預定嗎？", vbYesNo, "")
'確實終止
If answer = vbYes Then
'需要檢查該房屋狀態，如果為預定，則修改為未租
Dim sqlh As String
Dim rs_house As New ADODB.Recordset
If rs_house.State = adStateOpen Then
rs_house.Close
End If
sqlh = "select * from House where 房屋編號 = '" & Text1(2).Text & "'"
rs_house.Open sqlh, conn, adOpenStatic, adLockOptimistic
rs_house(8) = "未租"
rs_house.Update
'在預定表中刪除當前記錄
rs_yd.Delete
rs_yd.Update '更新刪除
'提示終止預定成功
MsgBox "終止預定成功！", vbOKOnly + vbExclamation, "注意"
Else
Exit Sub
End If
'刪除之后，顯示總信息條數需要減 1
Text2.Text = Val(Text2.Text) - 1
'刪除當前記錄后，需要顯示下一條記錄，如果刪除的是最后一條記錄，則顯示上一條記錄
'先移動rs_yd記錄到后一條
rs_yd.MoveNext
If rs_yd.EOF Then
rs_yd.MovePrevious
'如果沒有到記錄首則顯示該記錄
If Not rs_yd.BOF Then
For i = 0 To 8
Text1(i).Text = rs_yd.Fields(i)
Next i
'如果到記錄首，則表格已經為空，置所有text框顯示為空,設置前后翻滾按鈕為不可用
ElseIf rs_yd.BOF Then
MsgBox "當前表格已為空！", vbOKOnly + vbInformation, "注意"
For i = 0 To 8
Text1(i).Text = ""
Next i
cmdFirst.Enabled = False
cmdPrev.Enabled = False
cmdNext.Enabled = False
cmdLast.Enabled = False
cmdEnd.Enabled = False
End If
'如果刪除的不是首尾記錄，則顯示當前記錄即可
Else
For i = 0 To 8
Text1(i).Text = rs_yd.Fields(i)
Next i
End If
End Sub
Private Sub cmdFirst_Click()
'先移動rs_yd記錄到第一條
rs_yd.MoveFirst
'同時需要設置相應按鈕為不可用和不可用
cmdPrev.Enabled = False
cmdFirst.Enabled = False
cmdNext.Enabled = True
cmdLast.Enabled = True
'如果已經是第一條記錄，則提示用戶
If rs_yd.BOF = True Then
MsgBox "對不起，已經是第一條記錄了！", vbOKOnly + vbInformation, "注意"
Exit Sub
'如果不是，則個數據表的記錄位置移到第一條記錄，并且顯示之
Else
For i = 0 To 8
Text1(i).Text = rs_yd.Fields(i)
Next i
End If
End Sub
Private Sub cmdLast_Click()
'移動rs_yd記錄到最后一條
rs_yd.MoveLast
cmdFirst.Enabled = True
cmdPrev.Enabled = True
cmdNext.Enabled = False
cmdLast.Enabled = False
'如果已經是最后一條記錄，則提示用戶
If rs_yd.EOF = True Then
MsgBox "對不起，已經是最后一條記錄了！", vbOKOnly + vbInformation, "注意"
Exit Sub
'如果不是最后一條，則個數據表的記錄位置移到后一條記錄，并且顯示之
Else
For i = 0 To 8
Text1(i).Text = rs_yd.Fields(i)
Next i
End If
End Sub
Private Sub cmdNext_Click()
'先移動rs_yd記錄到后一條
rs_yd.MoveNext
'設置前一條和第一條按鈕可用
cmdPrev.Enabled = True
cmdFirst.Enabled = True
'如果已經是最后一條記錄，則提示用戶
If rs_yd.EOF = True Then
MsgBox "對不起，已經是最后一條記錄了！", vbOKOnly + vbInformation, "注意"
'并且設置“后一條”和最后一條按鈕不可用
cmdNext.Enabled = False
cmdLast.Enabled = False
Exit Sub
'如果不是，則個數據表的記錄位置移到后一條記錄，并且顯示之
Else
For i = 0 To 8
Text1(i).Text = rs_yd.Fields(i)
Next i
End If
End Sub
Private Sub cmdPrev_Click()
'先移動rs_yd記錄到前一條
rs_yd.MovePrevious
'設置后一條和最后一條按鈕可用
cmdNext.Enabled = True
cmdLast.Enabled = True
'如果已經是第一條記錄，則提示用戶
If rs_yd.BOF = True Then
MsgBox "對不起，已經是第一條記錄了！", vbOKOnly + vbInformation, "注意"
'并且設置“前一條”和第一條按鈕不可用
cmdPrev.Enabled = False
cmdFirst.Enabled = False
Exit Sub
'如果不是，則個數據表的記錄位置移到前一條記錄，并且顯示之
Else
For i = 0 To 8
Text1(i).Text = rs_yd.Fields(i)
Next i
End If
End Sub
Private Sub Form_Load()
Dim X0 As Long
Dim Y0 As Long
'讓窗體居中
X0 = Screen.Width
Y0 = Screen.Height
X0 = (X0 - Me.Width) / 2
Y0 = (Y0 - Me.Height) / 2
Me.Move X0, Y0
'設定所有text不可寫
For i = 0 To 8
Text1(i).Enabled = False
Next i
Text2.Enabled = False
'檢查輸入的查詢預定單條件是否存在符合條件的記錄
If rs_yd.State = adStateOpen Then
rs_yd.Close
End If
sqlyd = "select * from YuDing " & sqlqyd
rs_yd.Open sqlyd, conn, adOpenStatic, adLockOptimistic
'如果沒有找到記錄
If rs_yd.EOF = True Then
Text2.Text = 0
For i = 0 To 8
Text1(i).Text = ""
Next i
'設置除關閉外所有按鈕不可用
cmdFirst.Enabled = False
cmdPrev.Enabled = False
cmdNext.Enabled = False
cmdLast.Enabled = False
cmdEnd.Enabled = False
MsgBox "沒有找到符合條件的預定單記錄！", vbOKOnly + vbInformation, "注意"
Exit Sub
Else
If rs_count.State = adStateOpen Then
rs_count.Close
End If
sqlcount = "select count(*) from YuDing " & sqlqyd
rs_count.Open sqlcount, conn, adOpenStatic, adLockOptimistic
Text2.Text = rs_count.Fields(0)
For i = 0 To 8
Text1(i).Text = rs_yd.Fields(i)
Next i
cmdFirst.Enabled = True
cmdPrev.Enabled = True
cmdNext.Enabled = True
cmdLast.Enabled = True
cmdEnd.Enabled = True
End If
End Sub
Private Sub Form_Unload(Cancel As Integer)
If rs_yd.State = adStateOpen Then
rs_yd.Close
End If
If rs_count.State = adStateOpen Then
rs_count.Close
End If
Unload Me
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -