📄 pfm_rptyfkcl.dfm
字号:
Font.Style = []
Mask = '#0.00'
ParentFont = False
Transparent = False
WordWrap = True
FontSize = 10
end
object QRDBText9: TQRDBText
Left = 116
Top = 0
Width = 29
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
306.916666666667
0
76.7291666666667)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Color = clWhite
DataSet = ADOQuery2
DataField = 'fkje'
Font.Charset = ANSI_CHARSET
Font.Color = clNavy
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
Mask = '#0.00元'
ParentFont = False
Transparent = False
WordWrap = True
FontSize = 10
end
object QRDBText11: TQRDBText
Left = 500
Top = 0
Width = 29
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
1322.91666666667
0
76.7291666666667)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Color = clWhite
DataSet = ADOQuery2
DataField = 'shrm'
Font.Charset = ANSI_CHARSET
Font.Color = clNavy
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
Mask = '#0.00'
ParentFont = False
Transparent = False
WordWrap = True
FontSize = 10
end
end
object GroupFooterBand1: TQRBand
Left = 38
Top = 145
Width = 718
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
AlignToBottom = False
Color = clWhite
ForceNewColumn = False
ForceNewPage = False
Size.Values = (
42.3333333333333
1899.70833333333)
BandType = rbGroupFooter
object QRLabel9: TQRLabel
Left = 24
Top = 0
Width = 53
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
63.5
0
140.229166666667)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = '付款次数'
Color = clWhite
Font.Charset = ANSI_CHARSET
Font.Color = clNavy
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
ParentFont = False
Transparent = False
WordWrap = True
FontSize = 10
end
object QRExpr1: TQRExpr
Left = 92
Top = 0
Width = 36
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
243.416666666667
0
95.25)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Font.Charset = ANSI_CHARSET
Font.Color = clNavy
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
Color = clWhite
Master = QRSubDetail1
ParentFont = False
ResetAfterPrint = True
Transparent = False
WordWrap = True
Expression = 'COUNT'
FontSize = 10
end
object QRLabel11: TQRLabel
Left = 300
Top = 0
Width = 66
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
793.75
0
174.625)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = '合计已付款'
Color = clWhite
Font.Charset = ANSI_CHARSET
Font.Color = clNavy
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
ParentFont = False
Transparent = False
WordWrap = True
FontSize = 10
end
object QRExpr2: TQRExpr
Left = 372
Top = 0
Width = 64
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
984.25
0
169.333333333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Font.Charset = ANSI_CHARSET
Font.Color = clNavy
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
Color = clWhite
Master = QRSubDetail1
ParentFont = False
ResetAfterPrint = True
Transparent = False
WordWrap = True
Expression = 'SUM(fkje)'
Mask = '#0.00元'
FontSize = 10
end
object QRLabel13: TQRLabel
Left = 476
Top = 0
Width = 53
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
1259.41666666667
0
140.229166666667)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = '尚欠款数'
Color = clWhite
Font.Charset = ANSI_CHARSET
Font.Color = clNavy
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
ParentFont = False
Transparent = False
WordWrap = True
FontSize = 10
end
object QRExpr3: TQRExpr
Left = 536
Top = 0
Width = 211
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
1418.16666666667
0
558.270833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Font.Charset = ANSI_CHARSET
Font.Color = clNavy
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
Color = clWhite
Master = QRSubDetail1
ParentFont = False
ResetAfterPrint = True
Transparent = False
WordWrap = True
Expression = 'adoquery1.yfkje-adoquery1.fkje'
Mask = '#0.00元'
FontSize = 10
end
end
object GroupHeaderBand1: TQRBand
Left = 38
Top = 113
Width = 718
Height = 16
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
AlignToBottom = False
Color = clWhite
ForceNewColumn = False
ForceNewPage = False
Size.Values = (
42.3333333333333
1899.70833333333)
BandType = rbGroupHeader
object QRLabel6: TQRLabel
Left = 24
Top = 0
Width = 53
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
63.5
0
140.229166666667)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = '付款日期'
Color = clWhite
Font.Charset = ANSI_CHARSET
Font.Color = clNavy
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
ParentFont = False
Transparent = False
WordWrap = True
FontSize = 10
end
object QRLabel7: TQRLabel
Left = 280
Top = 0
Width = 53
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
740.833333333333
0
140.229166666667)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = '单据号码'
Color = clWhite
Font.Charset = ANSI_CHARSET
Font.Color = clNavy
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
ParentFont = False
Transparent = False
WordWrap = True
FontSize = 10
end
object QRLabel8: TQRLabel
Left = 196
Top = 0
Width = 53
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
518.583333333333
0
140.229166666667)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = '付款方式'
Color = clWhite
Font.Charset = ANSI_CHARSET
Font.Color = clNavy
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
ParentFont = False
Transparent = False
WordWrap = True
FontSize = 10
end
object QRLabel10: TQRLabel
Left = 404
Top = 0
Width = 40
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
1068.91666666667
0
105.833333333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = '经办人'
Color = clWhite
Font.Charset = ANSI_CHARSET
Font.Color = clNavy
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
ParentFont = False
Transparent = False
WordWrap = True
FontSize = 10
end
object QRLabel12: TQRLabel
Left = 116
Top = 0
Width = 53
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
306.916666666667
0
140.229166666667)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = '付款金额'
Color = clWhite
Font.Charset = ANSI_CHARSET
Font.Color = clNavy
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
ParentFont = False
Transparent = False
WordWrap = True
FontSize = 10
end
object QRLabel14: TQRLabel
Left = 500
Top = 0
Width = 40
Height = 17
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
44.9791666666667
1322.91666666667
0
105.833333333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = '审核人'
Color = clWhite
Font.Charset = ANSI_CHARSET
Font.Color = clNavy
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
ParentFont = False
Transparent = False
WordWrap = True
FontSize = 10
end
end
object ChildBand1: TQRChildBand
Left = 38
Top = 161
Width = 718
Height = 12
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
AlignToBottom = False
Color = clWhite
ForceNewColumn = False
ForceNewPage = False
Size.Values = (
31.75
1899.70833333333)
ParentBand = GroupFooterBand1
end
end
object ADOQuery1: TADOQuery
Connection = AdoDm.ADOConnection1
CursorType = ctStatic
Parameters = <>
SQL.Strings = (
'select tb_yfkmx.fkcause,tb_jhd.gysmc,tb_yfkmx.lsh,isnull(tb_yfkm' +
'x.yfkje,0) as yfkje ,isnull((select sum(fkje) from tb_yfkcl wher' +
'e tb_yfkmx.lsh=tb_yfkcl.lsh group by tb_yfkcl.lsh), 0) as fkje '
'from tb_yfkmx,tb_jhd'
'where tb_yfkmx.lsh=tb_jhd.lsh'
'order by tb_yfkmx.lsh desc'
'')
Left = 16
Top = 8
end
object ADOQuery2: TADOQuery
Connection = AdoDm.ADOConnection1
CursorType = ctStatic
DataSource = DataSource1
Parameters = <
item
Name = 'lsh'
Attributes = [paSigned]
DataType = ftInteger
Precision = 10
Value = Null
end>
Prepared = True
SQL.Strings = (
'select * from tb_yfkcl where lsh=:lsh')
Left = 24
Top = 64
end
object DataSource1: TDataSource
DataSet = ADOQuery1
Left = 48
Top = 8
end
end
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -