📄 frmrpttimepos.frm
字号:
VERSION 5.00
Object = "{809F5ECB-E545-4F7D-A8A8-CBFF5617AADC}#1.0#0"; "xCombox.ocx"
Object = "{E11E7285-4386-40E5-A4D4-F55704D4D491}#1.0#0"; "sSuperGrid.ocx"
Object = "{060B05EA-F4F5-4255-9BFC-9295B6A89D11}#3.0#0"; "Sinour050715.ocx"
Object = "{811B8E4F-88E3-4162-88A6-CC4C86342FB1}#1.0#0"; "sDTPicker.ocx"
Object = "{2DCFDEBF-F3C7-4735-B263-99E2ADF554F0}#1.0#0"; "ACRptEngineX.ocx"
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "comdlg32.ocx"
Begin VB.Form frmRptTimePos
Caption = "Form1"
ClientHeight = 7125
ClientLeft = 60
ClientTop = 465
ClientWidth = 10380
LinkTopic = "Form1"
MDIChild = -1 'True
ScaleHeight = 7125
ScaleWidth = 10380
WindowState = 2 'Maximized
Begin ACRptEngineX.ACRptEngine ACRptEngine1
Height = 735
Left = 4815
TabIndex = 11
Top = 3195
Visible = 0 'False
Width = 780
Object.Visible = -1 'True
DoubleBuffered = 0 'False
Enabled = -1 'True
End
Begin VB.Frame Frame
Height = 795
Left = 90
TabIndex = 1
Top = 135
Width = 10740
Begin Sinour_Controls.sButton cmdExpor
Height = 420
Left = 7155
TabIndex = 9
Top = 270
Width = 1155
_ExtentX = 2037
_ExtentY = 741
BTYPE = 7
TX = "导出 "
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = -1 'True
BCOL = 14215660
BCOLO = 14215660
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "frmRptTimePos.frx":0000
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 0
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin Sinour_Controls.sButton cmdPrint
Height = 420
Left = 8370
TabIndex = 10
Top = 270
Width = 1155
_ExtentX = 2037
_ExtentY = 741
BTYPE = 7
TX = "打印(&P) "
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = 0 'False
BCOL = 13160660
BCOLO = 13160660
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "frmRptTimePos.frx":001C
PICN = "frmRptTimePos.frx":0038
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 1
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin Sinour_Controls.sButton cmdQuery
Height = 420
Left = 5895
TabIndex = 8
Top = 270
Width = 1155
_ExtentX = 2037
_ExtentY = 741
BTYPE = 7
TX = "查询 "
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = -1 'True
BCOL = 14215660
BCOLO = 14215660
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "frmRptTimePos.frx":00DA
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 0
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin SDTPICKERLib.SDTPicker dtpBeginDate
Height = 300
Left = 3915
TabIndex = 2
Top = 300
Width = 1935
_Version = 65536
_ExtentX = 3413
_ExtentY = 300
_StockProps = 68
End
Begin SDTPICKERLib.SDTPicker dtpEndDate
Height = 300
Left = 6870
TabIndex = 3
Top = 300
Width = 1770
_Version = 65536
_ExtentX = 3122
_ExtentY = 300
_StockProps = 68
End
Begin XCOMBOXLib.XCombox cmbEmployee
Height = 300
Left = 990
TabIndex = 6
Top = 270
Width = 1935
_Version = 65536
_ExtentX = 3413
_ExtentY = 300
_StockProps = 68
End
Begin VB.Label lblEmployee
AutoSize = -1 'True
Caption = "员工名称："
Height = 195
Left = 90
TabIndex = 7
Top = 315
Width = 900
End
Begin VB.Label lblBeginDate
AutoSize = -1 'True
Caption = "开始时间:"
Height = 180
Left = 3090
TabIndex = 5
Top = 360
Width = 810
End
Begin VB.Label lblEndDate
AutoSize = -1 'True
Caption = "结束时间:"
Height = 180
Left = 5985
TabIndex = 4
Top = 360
Width = 810
End
End
Begin MSComDlg.CommonDialog ComDlg
Left = 8865
Top = 2520
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin SSUPERGRIDLib.SSuperGrid Grid
Height = 4920
Left = 180
TabIndex = 0
Top = 1125
Width = 8190
_Version = 65536
_ExtentX = 14446
_ExtentY = 8678
_StockProps = 132
End
End
Attribute VB_Name = "frmRptTimePos"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim rstGrid As New ADODB.Recordset
Dim rstExec As New ADODB.Recordset
Dim bln() As Boolean
Private Sub cmbEmployee_BtnsClick(ByVal nIndex As Integer)
Select Case nIndex
Case 0
rstEmployee.Requery
bufEmployee.DataSource = rstEmployee
cmbEmployee.DataSource = bufEmployee
Case 1
cmbEmployee.SearchID 0
End Select
End Sub
Private Sub cmdExpor_Click()
On Error GoTo IsErr:
Dim tmpRst As New ADODB.Recordset
Grid.Col("序号").bOutput = True
Grid.FillOutRstEx tmpRst, byHeadKey
ComDlg.CancelError = True
ComDlg.Filter = "ExcelFile(*.xls)|*.xls"
ComDlg.Flags = cdlOFNHideReadOnly
ComDlg.InitDir = App.Path
ComDlg.DialogTitle = "导出"
ComDlg.ShowSave
If Trim(ComDlg.FileName) = "" Then Exit Sub
ExporToExcel tmpRst, "报表", ComDlg.FileName
If tmpRst.State = 1 Then tmpRst.Close
Set tmpRst = Nothing
Exit Sub
IsErr:
If InStr(Err.Description, "选定") <> 0 Then
Exit Sub
End If
ErrMsg
End Sub
Private Sub cmdPrint_Click()
Set iFrom = Me
Me.PopupMenu MNU.mnuPrint, , cmdPrint.Left - 15, cmdPrint.Top + cmdPrint.Height
End Sub
Private Sub Form_Load()
Me.Icon = MDI.Icon
Me.Caption = "排班报表"
dtpBeginDate.Value = Date - 30
dtpEndDate.Value = Date
'======员工
cmbEmployee.ShowHeadScale = "0,20,20,20"
cmbEmployee.ShowHeadValue = "EmployeeID,编号,名称,卡号"
cmbEmployee.ShowIndex = 2
cmbEmployee.Type = tStatic
cmbEmployee.SetBtns "刷新,清空"
cmbEmployee.ButtonHeight = 20
' cmbEmployee.DropWidth = cmbEmployee.Width \ 15
cmbEmployee.DataSource = bufEmployee
End Sub
Private Sub cmdQuery_Click()
Dim dBeginDate As Date
Dim dEndDate As Date
Dim EmployeeName As String
dBeginDate = dtpBeginDate.Value
dEndDate = dtpEndDate.Value
EmployeeName = Trim(cmbEmployee.Text)
Call ShowRpt(dBeginDate, dEndDate, EmployeeName)
End Sub
Public Sub ShowRpt(ByVal dBeginDate As Date, ByVal dEndDate As Date, Optional ByVal sEmployeeName As String)
dtpBeginDate.Value = dBeginDate
dtpEndDate.Value = dEndDate
cmbEmployee.Text = sEmployeeName
Dim MaxTimeCount As Long
Dim bTime As String
Dim sClassID As String
Dim sDate As String
FillInfo dBeginDate, dEndDate
' MaxTimeCount = GetMaxTimeCount(dBeginDate, dEndDate)
Dim i As Integer
i = GetTimePosCount
MaxTimeCount = i
ReDim bln(i)
Call SetGrid(MaxTimeCount)
Set Grid.DataSource = Nothing
rstGrid.CancelBatch
Dim lEmpRow As Long
Dim lEmpCount As Long
If blnEmployeeInfo = False Then Exit Sub
lEmpCount = UBound(EmployeeInfo)
Do While dBeginDate <= dEndDate
For lEmpRow = 1 To lEmpCount
If (sEmployeeName = "") Or _
(sEmployeeName <> "" And EmployeeInfo(lEmpRow).EmployeeName = sEmployeeName) Then
rstGrid.AddNew
'===========刷卡日期=========
sDate = Format(dBeginDate, "yyyy-mm-dd")
bTime = Format(dBeginDate, "yyyy-mm-dd")
rstGrid.Fields("刷卡日期") = bTime
'===========星期============
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -