📄 frmbaobiao.frm
字号:
VERSION 5.00
Begin VB.Form frmBaoBiao
AutoRedraw = -1 'True
BorderStyle = 1 'Fixed Single
Caption = "打印查询"
ClientHeight = 6900
ClientLeft = 45
ClientTop = 330
ClientWidth = 10770
ControlBox = 0 'False
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
LinkTopic = "Form1"
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
ScaleHeight = 6900
ScaleWidth = 10770
Begin VB.Frame FraKaoQin
Caption = "考勤查询内容"
BeginProperty Font
Name = "隶书"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 1215
Left = 4680
TabIndex = 10
Top = 480
Width = 5655
Begin VB.CheckBox chkKaoQinDate
Height = 240
Left = 2520
TabIndex = 16
Top = 600
Width = 240
End
Begin VB.ComboBox cobKaoQinType
Height = 360
Left = 1080
TabIndex = 19
Text = "Combo2"
Top = 720
Width = 1335
End
Begin VB.CheckBox chkKaoQinType
Caption = "类 别"
Height = 240
Left = 120
TabIndex = 18
Top = 840
Width = 975
End
Begin VB.PictureBox DTKaoQinStart
Height = 375
Left = 3480
ScaleHeight = 315
ScaleWidth = 1995
TabIndex = 12
ToolTipText = "查询开始时间"
Top = 240
Width = 2055
End
Begin VB.CheckBox chkKaoQinName
Caption = "姓 名"
Height = 240
Left = 120
TabIndex = 15
Top = 360
Width = 975
End
Begin VB.PictureBox DTKaoQinEnd
Height = 375
Left = 3480
ScaleHeight = 315
ScaleWidth = 1995
TabIndex = 13
ToolTipText = "查询结束时间"
Top = 720
Width = 2055
End
Begin VB.ComboBox cobKaoQinName
Height = 360
Left = 1080
TabIndex = 11
Text = "Combo1"
Top = 240
Width = 1335
End
Begin VB.Label Label7
AutoSize = -1 'True
Caption = "间"
Height = 240
Left = 2760
TabIndex = 22
Top = 720
Width = 240
End
Begin VB.Label Label6
AutoSize = -1 'True
Caption = "时"
Height = 240
Left = 2760
TabIndex = 21
Top = 360
Width = 240
End
Begin VB.Label Label5
AutoSize = -1 'True
Caption = "从"
Height = 240
Left = 3120
TabIndex = 20
Top = 360
Width = 240
End
Begin VB.Label Label4
AutoSize = -1 'True
Caption = "到"
Height = 240
Left = 3120
TabIndex = 17
Top = 840
Width = 240
End
Begin VB.Label Label3
Height = 15
Left = 240
TabIndex = 14
Top = 360
Width = 735
End
End
Begin VB.CommandButton cmdExit
Caption = "退 出"
Height = 375
Left = 6120
TabIndex = 8
Top = 1920
Width = 1455
End
Begin VB.CommandButton cmdPrint
Caption = "打 印"
Height = 375
Left = 3480
TabIndex = 7
Top = 1920
Width = 1455
End
Begin VB.CommandButton CmdFind
Caption = "查 询"
Height = 375
Left = 960
TabIndex = 6
Top = 1920
Width = 1455
End
Begin VB.PictureBox adoFind
BackColor = &H80000005&
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 330
Left = 3000
ScaleHeight = 270
ScaleWidth = 2355
TabIndex = 23
Top = 4920
Visible = 0 'False
Width = 2415
End
Begin VB.PictureBox Date
BackColor = &H00C0FFFF&
ForeColor = &H00FF0000&
Height = 4335
Left = 120
ScaleHeight = 4275
ScaleWidth = 10515
TabIndex = 5
Top = 2520
Width = 10575
End
Begin VB.Frame fraXuanXiang
Caption = "查询选项"
BeginProperty Font
Name = "隶书"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 1215
Left = 120
TabIndex = 0
Top = 480
Width = 4455
Begin VB.OptionButton OptBaoBiao
Caption = "月 度 报 表"
Height = 375
Left = 2400
TabIndex = 4
Top = 720
Width = 1815
End
Begin VB.OptionButton OptQingJia
Caption = "请假信息查询"
Height = 255
Left = 2400
TabIndex = 3
Top = 360
Width = 1815
End
Begin VB.OptionButton OptKaoQin
Caption = "考勤信息查询"
Height = 255
Left = 240
TabIndex = 2
Top = 780
Width = 1815
End
Begin VB.OptionButton OptWork
Caption = "员工信息查询"
Height = 375
Left = 240
TabIndex = 1
Top = 300
Width = 2055
End
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "考 勤 信 息 查 询 打 印"
BeginProperty Font
Name = "隶书"
Size = 21.75
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 435
Left = 2760
TabIndex = 9
Top = 0
Width = 5415
End
End
Attribute VB_Name = "frmBaoBiao"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim sCardID As String
Private Sub chkKaoQinDate_Click()
If chkKaoQinDate.Value = 1 Then
DTKaoQinStart.Enabled = True
DTKaoQinEnd.Enabled = True
Else
DTKaoQinStart.Enabled = False
DTKaoQinEnd.Enabled = False
End If
End Sub
Private Sub chkKaoQinName_Click()
If chkKaoQinName.Value = 1 Then
cobKaoQinName.Enabled = True
cobKaoQinName.BackColor = &HFFC0C0
Else
cobKaoQinName.Enabled = False
cobKaoQinName.BackColor = &H80000004
End If
End Sub
Private Sub chkKaoQinType_Click()
If chkKaoQinType.Value = 1 Then
cobKaoQinType.Enabled = True
cobKaoQinType.BackColor = &HFFC0C0
Else
cobKaoQinType.Enabled = False
cobKaoQinType.BackColor = &H80000004
End If
End Sub
Private Sub chkQingJiaName_Click()
If chkQingJiaName.Value = 1 Then
cobQingJiaName.Enabled = True
cobQingJiaName.BackColor = &HFFC0C0
Else
cobQingJiaName.Enabled = False
cobQingJiaName.BackColor = &H80000004
End If
End Sub
Private Sub chkQingJiaStart_Click()
If chkQingJiaStart.Value = 1 Then
dtQingJiaStart.Enabled = True
dtQingJiaEnd.Enabled = True
Else
dtQingJiaStart.Enabled = False
dtQingJiaEnd.Enabled = False
End If
End Sub
Private Sub chkQingJiaType_Click()
If chkQingJiaType.Value = 1 Then
cobQingJiaType.Enabled = True
cobQingJiaType.BackColor = &HFFC0C0
Else
cobQingJiaType.Enabled = False
cobQingJiaType.BackColor = &H80000004
End If
End Sub
Private Sub cmdExit_Click()
Unload Me
End Sub
Private Sub CmdFind_Click()
Dim SQL, sName, sType, sdate As String
If OptWork.Value = True Then
frmWorker.Show
Exit Sub
End If
If OptQingJia.Value = True Then
frmQingJia.Show
Exit Sub
End If
If OptKaoQin.Value = True Then
If chkKaoQinName.Value = 1 Then
Set adoRs = adoCon.Execute("select CardID from Worker Where Name='" & Trim(cobKaoQinName) & "'")
sCardID = " KaoQin.CardID Like '" & Trim(adoRs!cardid) & "'"
Else
sCardID = "KaoQin.CardID like '%'"
End If
Dim NumType As String
If chkKaoQinType.Value = 1 Then
sType = "KaoQin.Type='" & Trim(cobKaoQinType.Text) & "'"
Else
sType = "KaoQin.Type like '%'"
End If
If chkKaoQinDate.Value = 1 Then
sdate = "KaoQin.Date between '" & Format(DTKaoQinStart, "yyyy-mm-dd") & "' and '" & Format(DTKaoQinEnd, "yyyy-mm-dd") & "'"
Else
sdate = "KaoQin.Date like '%'"
End If
SQL = "select Worker.Name as 姓名 ,KaoQin.CardID as 卡号,"
SQL = SQL + " KaoQin.Date as 日期,KaoQin.Hour as 时,KaoQin.Minute as 分,"
SQL = SQL + "KaoQin.Type as 类别"
SQL = SQL + " from KaoQin join Worker on Worker.CardID=KaoQin.CardID "
SQL = SQL + " where "
SQL = SQL + sCardID + " and " + sType + " and "
SQL = SQL + sdate + " order by Date,Type "
With adoFind
.ConnectionString = RtnStr
.RecordSource = SQL
.Refresh
End With
End If
End Sub
Private Sub KaoQinNew()
Set adoRs = adoCon.Execute("select Name from Worker")
With cobKaoQinName
.Clear
.AddItem ""
If Not adoRs.EOF Then
Do While Not adoRs.EOF
.AddItem adoRs!Name
adoRs.MoveNext
Loop
End If
.ListIndex = 0
End With
DTKaoQinStart.Value = Now
DTKaoQinEnd.Value = Now
With cobKaoQinType
.Clear
.AddItem "正常"
.AddItem "迟到"
.AddItem "早退"
.AddItem "加班"
.AddItem "旷勤半天"
.AddItem "请假"
End With
End Sub
Private Sub Command1_Click()
For I = 1 To 10000
sCardID = Int(40! * Rnd())
sdate = "2002-" + CStr(Int(11! * Rnd()) + 1) + "-" + CStr(Int(27! * Rnd()) + 1)
sHour = Int(11! * Rnd() + 1)
sMinute = Int(60! * Rnd())
sSecond = Int(60! * Rnd())
adoCon.Execute ("insert into Kaoqin values('" & sCardID & "','" & sdate & "','" & sHour & "','" & sMinute & "','" & sSecond & "','请假')")
Next
End Sub
Private Sub Form_Load()
Call setConnect
Me.Move (Screen.Width - Me.Width) / 2, (Screen.Height - Me.Height) / 2 - 700
Call KaoQinNew
DTKaoQinStart.Enabled = False
DTKaoQinEnd.Enabled = False
cobKaoQinName.Enabled = False
cobKaoQinType.Enabled = False
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -