📄
字号:
BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "明细"
Key = "Detail"
Object.ToolTipText = "显示每个人员的信息"
ImageKey = "Detail"
Style = 1
Value = 1
EndProperty
BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "合计"
Key = "Total"
Object.ToolTipText = "显示合计信息"
ImageKey = "Total"
Style = 1
Value = 1
EndProperty
BeginProperty Button11 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button12 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "帮助"
Key = "bz"
Object.ToolTipText = "显示帮助信息"
ImageKey = "bz"
EndProperty
BeginProperty Button13 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "退出"
Key = "fh"
Object.ToolTipText = "退出本报表"
ImageKey = "tc"
EndProperty
EndProperty
BorderStyle = 1
Begin MSComctlLib.ImageList ImageList1
Left = 5280
Top = 0
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 16
ImageHeight = 16
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 35
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":35106
Key = "sz"
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":354A0
Key = "dy"
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3583A
Key = "yl"
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":35BD4
Key = "xg"
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":35F6E
Key = "zh"
EndProperty
BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":36308
Key = "sh"
EndProperty
BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":366A2
Key = "bc"
EndProperty
BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":36A3C
Key = "fq"
EndProperty
BeginProperty ListImage9 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":36DD6
Key = "bz"
EndProperty
BeginProperty ListImage10 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":37170
Key = "tc"
EndProperty
BeginProperty ListImage11 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3750A
Key = "bcgs"
EndProperty
BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":378A4
Key = "mrlk"
EndProperty
BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":37C3E
Key = "xsxm"
EndProperty
BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":37FD8
Key = "first"
EndProperty
BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":38372
Key = "prev"
EndProperty
BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3870C
Key = "next"
EndProperty
BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":38AA6
Key = "last"
EndProperty
BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":38E40
Key = "xx"
EndProperty
BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":391DA
Key = "define"
EndProperty
BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":39574
Key = "exec"
EndProperty
BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3990E
Key = "xz"
EndProperty
BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":39CA8
Key = "sc"
EndProperty
BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3A042
Key = "sx"
EndProperty
BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3A3DC
Key = "cx"
EndProperty
BeginProperty ListImage25 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3A776
Key = "zd"
EndProperty
BeginProperty ListImage26 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3AB10
Key = "dz"
EndProperty
BeginProperty ListImage27 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3AEAA
Key = "ph"
EndProperty
BeginProperty ListImage28 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3B244
Key = "fz"
EndProperty
BeginProperty ListImage29 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3B5DE
Key = "Locate"
EndProperty
BeginProperty ListImage30 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3B978
Key = "hf"
EndProperty
BeginProperty ListImage31 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3BD12
Key = "pz"
EndProperty
BeginProperty ListImage32 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3C0AC
Key = "check"
EndProperty
BeginProperty ListImage33 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3C446
Key = "Sum"
EndProperty
BeginProperty ListImage34 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3C7E0
Key = "Total"
EndProperty
BeginProperty ListImage35 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "报表_自定义考勤报表.frx":3CB7A
Key = "Detail"
EndProperty
EndProperty
End
End
End
Attribute VB_Name = "Rep_DIYAttend_Frm"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'**************************************************************************
'* 模 块 名 称 :自定义报表
'* 功 能 描 述 :
'* 程序员姓名 :苗鹏
'* 最后修改人 :苗鹏
'* 最后修改时间:2002/01/01
'* 备 注:
'**************************************************************************
Dim ReportTitle As String '报表主标题
Public sSqlWhere As String
Public sSqlFrom As String
Public sPTableName As String
Public sRCode As String
Dim sPmSort As String
Public sGroupField As String
Public iDeptBeginLevel As Integer
Public iDeptEndLevel As Integer
Dim sFieldValue() As New CFieldValue
Dim iSumEndCol As Integer
Dim iBeginCol As Integer
Dim sData() As String
'以下为固定使用变量
Dim Dyymctbl As New DY_Dyymsz '打印页面窗体变量
Dim GridCode As String '显示网格网格代码
Dim GridInf() As Variant '整个网格设置信息
Dim Tsxx As String '系统提示信息
Dim Qslz As Long '网格隐藏(非操作显示)列数
Dim Sjhgd As Double '网格数据行高度
Dim Sfxshjwg As Boolean '是否显示合计网格
Dim GridBoolean() As Boolean '网格列信息(布尔型)
Dim GridStr() As String '网格列信息(字符型)
Dim GridInt() As Integer '网格列信息(整型)
Dim Szzls As Integer '数组总列数(网格列数-1)
Private Sub CxbbGrid_AfterMoveColumn(ByVal Col As Long, Position As Long)
On Error Resume Next
Dim i As Integer
With Me.CxbbGrid
ReDim sFieldValue(.Cols - 1)
For i = 0 To .Cols - 1
sFieldValue(i).FieldName = Trim(.TextMatrix(1, i))
Next i
End With
End Sub
Private Sub Form_Resize() '根据窗体大小来调整网格,标题栏大小(Fixed)
On Error Resume Next
With CxbbGrid
.Width = Me.Width - 160
.Height = Me.Height - .Top - 400
End With
With Pic_Title
.Width = Me.Width - 160
End With
GsToolbar.Left = Me.Width - GsToolbar.Width - 140
With Me.PB_Proc
.Left = (Me.Width - .Width) / 2
.Top = Me.Height / 2
End With
End Sub
Private Sub Form_Load() '窗体装入
On Error GoTo ErrCtrl
'调入打印页面设置窗体
Dim rs As New ADODB.Recordset
Dim s As String
s = "SELECT * from PM_ReportSort WHERE RCode='" & Me.sRCode & "'"
Set rs = Cw_DataEnvi.DataConnect.Execute(s)
With rs
If Not .EOF() Then
ReportTitle = Trim(!RTitle & "")
XtReportCode = Trim(!RPrintParama & "")
End If
End With
Load Dyymctbl
Me.Caption = ReportTitle
Me.Lab_Title = ReportTitle
sPmSort = "001"
'调整标题栏及网格、格式工具条位置(Fixed)
Pic_Title.Left = 40
Pic_Title.Top = SzToolbar.Top + SzToolbar.Height - 10
CxbbGrid.Left = Pic_Title.Left
CxbbGrid.Top = Pic_Title.Top + Pic_Title.Height + 20
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -