📄 form3.frm
字号:
VERSION 5.00
Object = "{6BF52A50-394A-11D3-B153-00C04F79FAA6}#1.0#0"; "wmp.dll"
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "ComDlg32.OCX"
Begin VB.Form Form3
Caption = "Form3"
ClientHeight = 3375
ClientLeft = 60
ClientTop = 450
ClientWidth = 5130
LinkTopic = "Form3"
Picture = "Form3.frx":0000
ScaleHeight = 3375
ScaleWidth = 5130
StartUpPosition = 3 '窗口缺省
Begin VB.Timer Timer1
Left = 3000
Top = 1680
End
Begin VB.CommandButton Command1
Caption = "呼叫"
BeginProperty Font
Name = "宋体"
Size = 15
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 3960
TabIndex = 5
Top = 1560
Width = 975
End
Begin MSComDlg.CommonDialog CommonDialog1
Left = 240
Top = 2760
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin VB.TextBox Text4
Height = 390
Left = 1680
TabIndex = 3
Top = 1800
Width = 975
End
Begin VB.TextBox Text3
Height = 390
Left = 1680
TabIndex = 2
Top = 960
Width = 975
End
Begin VB.TextBox Text2
Height = 375
Left = 1680
TabIndex = 1
Top = 360
Width = 975
End
Begin VB.TextBox Text1
Height = 375
Left = 4080
TabIndex = 0
Top = 360
Width = 855
End
Begin VB.Label Label4
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "个人业务已办"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 120
TabIndex = 9
Top = 1800
Width = 1335
End
Begin VB.Label Label3
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "公司业务已办"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 0
TabIndex = 8
Top = 1080
Width = 1455
End
Begin VB.Label Label2
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "已办理人数"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 2760
TabIndex = 7
Top = 360
Width = 1095
End
Begin VB.Label Label1
Alignment = 2 'Center
BackStyle = 0 'Transparent
Caption = "业务办理人数"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 120
TabIndex = 6
Top = 480
Width = 1335
End
Begin WMPLibCtl.WindowsMediaPlayer MediaPlayer1
Height = 615
Left = 1200
TabIndex = 4
Top = 2760
Width = 3735
URL = ""
rate = 1
balance = 0
currentPosition = 0
defaultFrame = ""
playCount = 1
autoStart = -1 'True
currentMarker = 0
invokeURLs = -1 'True
baseURL = ""
volume = 50
mute = 0 'False
uiMode = "full"
stretchToFit = 0 'False
windowlessVideo = 0 'False
enabled = -1 'True
enableContextMenu= -1 'True
fullScreen = 0 'False
SAMIStyle = ""
SAMILang = ""
SAMIFilename = ""
captioningID = ""
enableErrorDialogs= 0 'False
_cx = 6588
_cy = 1085
End
End
Attribute VB_Name = "Form3"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
Dim sql As String
Dim rs_login As New ADODB.Recordset
Dim conn As New ADODB.Connection
conn.Open "provider=Microsoft.Jet.OLEDB.4.0; data source=中国银行.MDB"
Dim num1, x, y, z, a, b, c, f, k, d As Integer
sql = "select * from information where 已办人数"
rs_login.Open sql, conn, adOpenKeyset, adLockOptimistic
Text2.Text = rs_login.Fields(2)
num1 = rs_login.Fields(1)
x = num1 + 1
a = rs_login.Fields(9)
b = rs_login.Fields(10)
f = rs_login.Fields(8)
k = rs_login.Fields(7)
c = a - b
d = k - f
If c > 0 Then
y = b + 1
z = f
Text1.Text = x
rs_login.Fields(1) = x
rs_login.Fields(10) = y
rs_login.AddNew
rs_login.Fields(3) = z + y
rs_login.Fields(4) = Time
rs_login.Fields(5) = Date
rs_login.Fields(6) = "王丹"
rs_login.Update
Select Case y
Case 1
CommonDialog1.FileName = "f:\卡农\01.mp3"
MediaPlayer1.URL = CommonDialog1.FileName
MediaPlayer1.Controls.play
Case 2
CommonDialog1.FileName = "f:\卡农\02.mp3"
MediaPlayer1.URL = CommonDialog1.FileName
MediaPlayer1.Controls.play
Case 3
CommonDialog1.FileName = "f:\卡农\03.mp3"
MediaPlayer1.URL = CommonDialog1.FileName
MediaPlayer1.Controls.play
Case others
End Select
ElseIf d > 0 Then
z = f + 1
y = b
Text1.Text = x
rs_login.Fields(1) = x
rs_login.Fields(8) = z
rs_login.AddNew
rs_login.Fields(3) = z + y
rs_login.Fields(4) = Time
rs_login.Fields(5) = Date
rs_login.Fields(6) = "王丹"
rs_login.Update
Select Case z
Case 1
CommonDialog1.FileName = "f:\卡农\01.mp3"
MediaPlayer1.URL = CommonDialog1.FileName
MediaPlayer1.Controls.play
Case 2
CommonDialog1.FileName = "f:\卡农\02.mp3"
MediaPlayer1.URL = CommonDialog1.FileName
MediaPlayer1.Controls.play
Case 3
CommonDialog1.FileName = "f:\卡农\03.mp3"
MediaPlayer1.URL = CommonDialog1.FileName
MediaPlayer1.Controls.play
Case others
End Select
Else
End
End If
Text3.Text = y
Text4.Text = z
End Sub
Private Sub Form_Load()
Timer1.Interval = 1000
End Sub
Private Sub Timer1_Timer()
Dim sql As String
Dim rs_login As New ADODB.Recordset
Dim conn As New ADODB.Connection
conn.Open "provider=Microsoft.Jet.OLEDB.4.0; data source=中国银行.MDB"
sql = "select * from information where 已办人数"
rs_login.Open sql, conn, adOpenKeyset, adLockOptimistic
Text1.Text = rs_login.Fields(1)
Text2.Text = rs_login.Fields(2)
Text3.Text = rs_login.Fields(10)
Text4.Text = rs_login.Fields(8)
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -