?? rptprintqueue.dsr
字號(hào):
VERSION 5.00
Begin {78E93846-85FD-11D0-8487-00A0C90DC8A9} rptPrintQueue
Caption = "客戶排隊(duì)編號(hào)"
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 = "個(gè)人儲(chǔ)蓄業(yè)務(wù)"
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 = "請(qǐng)客戶至排隊(duì)區(qū)等候，注意屏幕提示。"
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 = "當(dāng)前等候人數(shù)： 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 = "當(dāng)前等候人數(shù)： 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) & "初始化數(shù)據(jù)庫(kù)失敗。"
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 & "打印內(nèi)容超出紙張范圍，請(qǐng)重新設(shè)定打印紙張！", vbOKOnly, "操作提示"
Case 8555, 8557
MsgBox ErrObj.Description & vbCrLf & "打印機(jī)初始化錯(cuò)誤，請(qǐng)檢查是否已正確安裝打印機(jī)！", 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
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -