📄 rptprintqueue.dsr
字号:
VERSION 5.00
Begin {78E93846-85FD-11D0-8487-00A0C90DC8A9} rptPrintQueue
Caption = "客户排队编号"
ClientHeight = 5835
ClientLeft = 60
ClientTop = 345
ClientWidth = 6885
Icon = "rptPrintQueue.dsx":0000
_ExtentX = 12144
_ExtentY = 10292
_Version = 393216
_DesignerVersion= 100685828
ReportWidth = 6237
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
GridX = 1
GridY = 1
LeftMargin = 1440
RightMargin = 567
TopMargin = 567
BottomMargin = 567
_Settings = 23
NumSections = 3
SectionCode0 = 1
BeginProperty Section0 {1C13A8E0-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "secHead"
Object.Height = 3297
NumControls = 6
ItemType0 = 3
BeginProperty Item0 {1C13A8E1-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "lblHead"
Object.Top = 567
Object.Width = 5669
Object.Height = 570
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 18
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Object.Caption = "XXXX银行XXXX分理处"
Alignment = 2
EndProperty
ItemType1 = 3
BeginProperty Item1 {1C13A8E1-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "lblBiz"
Object.Top = 1134
Object.Width = 5669
Object.Height = 300
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "隶书"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Object.Caption = "个人储蓄业务"
Alignment = 2
EndProperty
ItemType2 = 3
BeginProperty Item2 {1C13A8E1-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "lblCode"
Object.Top = 1701
Object.Width = 5669
Object.Height = 300
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Object.Caption = "2002"
Alignment = 2
EndProperty
ItemType3 = 3
BeginProperty Item3 {1C13A8E1-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "lblFoot"
Object.Top = 2880
Object.Width = 5670
Object.Height = 195
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Object.Caption = "请客户至排队区等候，注意屏幕提示。"
Alignment = 2
EndProperty
ItemType4 = 3
BeginProperty Item4 {1C13A8E1-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "lblNumer"
Object.Top = 2565
Object.Width = 5670
Object.Height = 195
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Object.Caption = "当前等候人数： 56"
Alignment = 2
EndProperty
ItemType5 = 3
BeginProperty Item5 {1C13A8E1-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "lblTime"
Object.Top = 2265
Object.Width = 5670
Object.Height = 195
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Object.Caption = "当前等候人数： 56"
Alignment = 2
EndProperty
EndProperty
SectionCode1 = 4
BeginProperty Section1 {1C13A8E0-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "secDetails"
Object.Visible = 0 'False
NumControls = 0
EndProperty
SectionCode2 = 8
BeginProperty Section2 {1C13A8E0-A0B6-11D0-848E-00A0C90DC8A9}
_Version = 393216
Name = "Section5"
Object.Visible = 0 'False
NumControls = 0
EndProperty
End
Attribute VB_Name = "rptPrintQueue"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim m_tagErrInfo As TYPE_ERRORINFO
Dim m_rs As New ADODB.Recordset
Public Function ShowReport(ByVal strPeriod As String, ByVal strEmpl As String) As Boolean
On Error GoTo ERROR_EXIT
InitResource strPeriod
With Sections("secHead")
.Controls("lblCode").Caption = strPeriod
.Controls("lblHead").Caption = my_print_set.print_head
.Controls("lblFoot").Caption = my_print_set.print_foot
.Controls("lblTime").Caption = Date & " " & Time
End With
Set Me.DataSource = m_rs
ShowReport = True
Exit Function
ERROR_EXIT:
m_tagErrInfo.strErrDate = Format(Now, "yyyy-mm-dd hh:mm:ss")
m_tagErrInfo.strErrFile = "rptPrintQueue"
m_tagErrInfo.strErrFunc = "ShowReport"
m_tagErrInfo.nErrNum = Err.Number
m_tagErrInfo.strErrDesc = Error(Err.Number) & "初始化数据库失败。"
If Err.Number <> 0 Then Err.Clear
modErrorInfo.WriteErrLog m_tagErrInfo
ShowReport = False
End Function
Private Sub DataReport_Error(ByVal JobType As MSDataReportLib.AsyncTypeConstants, ByVal Cookie As Long, ByVal ErrObj As MSDataReportLib.RptError, ShowError As Boolean)
On Error Resume Next
ShowError = False
Select Case ErrObj.ErrorNumber
Case 8542
MsgBox ErrObj.Description & vbCrLf & "打印内容超出纸张范围，请重新设定打印纸张！", vbOKOnly, "操作提示"
Case 8555, 8557
MsgBox ErrObj.Description & vbCrLf & "打印机初始化错误，请检查是否已正确安装打印机！", vbOKOnly, "操作提示"
End Select
End Sub
Private Sub DataReport_Terminate()
If m_rs.State = adStateOpen Then m_rs.Close
Set m_rs = Nothing
End Sub
Private Sub InitResource(ByVal sCode As String)
On Error Resume Next
m_rs.Fields.Append "Code", adVarChar, 50, adFldMayBeNull
m_rs.Open , , adOpenStatic, adLockBatchOptimistic
m_rs.AddNew
m_rs!Code = sCode
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -