📄 mc_cnfdy.~dfm
字号:
129.645833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Color = clWhite
DataSet = Query2
DataField = '户主姓名'
Transparent = False
WordWrap = True
FontSize = 9
end
object QRDBText3: TQRDBText
Left = 144
Top = 8
Width = 49
Height = 13
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
34.3958333333333
381
21.1666666666667
129.645833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Color = clWhite
DataSet = Query2
DataField = '建筑面积'
Transparent = False
WordWrap = True
FontSize = 9
end
object QRDBText4: TQRDBText
Left = 204
Top = 8
Width = 73
Height = 13
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
34.3958333333333
539.75
21.1666666666667
193.145833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Color = clWhite
DataSet = Query2
DataField = '计费起始日期'
Transparent = False
WordWrap = True
FontSize = 9
end
object QRDBText5: TQRDBText
Left = 287
Top = 8
Width = 73
Height = 13
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
34.3958333333333
759.354166666667
21.1666666666667
193.145833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Color = clWhite
DataSet = Query2
DataField = '计费终止日期'
Transparent = False
WordWrap = True
FontSize = 9
end
object QRDBText6: TQRDBText
Left = 365
Top = 8
Width = 49
Height = 13
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
34.3958333333333
965.729166666667
21.1666666666667
129.645833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Color = clWhite
DataSet = Query2
DataField = '应收金额'
Transparent = False
WordWrap = True
FontSize = 9
end
object QRDBText7: TQRDBText
Left = 424
Top = 8
Width = 49
Height = 13
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
34.3958333333333
1121.83333333333
21.1666666666667
129.645833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Color = clWhite
DataSet = Query2
DataField = '实收金额'
Transparent = False
WordWrap = True
FontSize = 9
end
object QRDBText8: TQRDBText
Left = 480
Top = 8
Width = 25
Height = 13
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
34.3958333333333
1270
21.1666666666667
66.1458333333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Color = clWhite
DataSet = Query2
DataField = '余额'
Transparent = False
WordWrap = True
FontSize = 9
end
object QRDBText9: TQRDBText
Left = 528
Top = 8
Width = 25
Height = 13
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
34.3958333333333
1397
21.1666666666667
66.1458333333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Color = clWhite
DataSet = Query2
DataField = '原因'
Transparent = False
WordWrap = True
FontSize = 9
end
end
object SummaryBand1: TQRBand
Left = 38
Top = 143
Width = 718
Height = 40
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 = (
105.833333333333
1899.70833333333)
BandType = rbSummary
object QRShape20: TQRShape
Left = 8
Top = 4
Width = 705
Height = 2
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
5.29166666666667
21.1666666666667
10.5833333333333
1865.3125)
Brush.Color = clBlack
Shape = qrsRectangle
end
object QRLabel11: TQRLabel
Left = 8
Top = 16
Width = 61
Height = 13
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
34.3958333333333
21.1666666666667
42.3333333333333
161.395833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = '打印日期:'
Color = clWhite
Font.Charset = GB2312_CHARSET
Font.Color = clBlue
Font.Height = -12
Font.Name = '宋体'
Font.Style = []
ParentFont = False
Transparent = False
WordWrap = True
FontSize = 9
end
object QRExpr1: TQRExpr
Left = 80
Top = 16
Width = 25
Height = 13
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
34.3958333333333
211.666666666667
42.3333333333333
66.1458333333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Font.Charset = GB2312_CHARSET
Font.Color = clBlue
Font.Height = -12
Font.Name = '宋体'
Font.Style = []
Color = clWhite
ParentFont = False
ResetAfterPrint = False
Transparent = False
WordWrap = True
Expression = 'DATE'
FontSize = 9
end
object QRLabel12: TQRLabel
Left = 504
Top = 16
Width = 61
Height = 13
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
34.3958333333333
1333.5
42.3333333333333
161.395833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Caption = '共计金额:'
Color = clWhite
Transparent = False
WordWrap = True
FontSize = 9
end
object QRExpr2: TQRExpr
Left = 568
Top = 16
Width = 121
Height = 13
Frame.Color = clBlack
Frame.DrawTop = False
Frame.DrawBottom = False
Frame.DrawLeft = False
Frame.DrawRight = False
Size.Values = (
34.3958333333333
1502.83333333333
42.3333333333333
320.145833333333)
Alignment = taLeftJustify
AlignToBand = False
AutoSize = True
AutoStretch = False
Color = clWhite
ResetAfterPrint = False
Transparent = False
WordWrap = True
Expression = 'SUM(Query2.实收金额)'
FontSize = 9
end
end
end
object DataSource1: TDataSource
DataSet = Query1
Left = 20
Top = 21
end
object DataSource2: TDataSource
DataSet = Table2
Left = 20
Top = 109
end
object Table2: TTable
Active = True
DatabaseName = 'WYGL'
IndexFieldNames = '所属区域'
MasterFields = '小区名'
MasterSource = DataSource1
TableName = 'dbo.大楼信息表'
Left = 52
Top = 109
object Table2BDEDesigner2: TStringField
FieldName = '大楼名称'
FixedChar = True
end
object Table2BDEDesigner5: TIntegerField
FieldName = '房屋数量'
end
object Table2BDEDesigner6: TStringField
FieldName = '负责人'
FixedChar = True
Size = 10
end
object Table2BDEDesigner7: TStringField
FieldName = '所属区域'
FixedChar = True
end
object Table2BDEDesigner: TStringField
FieldName = '大楼编号'
Required = True
FixedChar = True
Size = 10
end
end
object Query1: TQuery
Active = True
DatabaseName = 'WYGL'
SQL.Strings = (
'select 小区编号,小区名 From 小区信息表')
Left = 52
Top = 21
object Query1BDEDesigner: TStringField
FieldName = '小区编号'
Origin = 'WYGL.小区信息表.小区编号'
FixedChar = True
Size = 10
end
object Query1BDEDesigner2: TStringField
FieldName = '小区名'
Origin = 'WYGL.小区信息表.小区名'
FixedChar = True
Size = 10
end
end
object Table1: TTable
Active = True
DatabaseName = 'WYGL'
IndexFieldNames = '大楼名'
MasterFields = '大楼名称'
MasterSource = DataSource2
TableName = 'dbo.房屋信息表'
Left = 96
Top = 424
object Table1BDEDesigner: TStringField
FieldName = '房间编号'
Required = True
FixedChar = True
end
object Table1BDEDesigner2: TStringField
FieldName = '区名'
FixedChar = True
end
object Table1BDEDesigner3: TStringField
FieldName = '大楼名'
FixedChar = True
end
object Table1BDEDesigner4: TStringField
FieldName = '单元'
FixedChar = True
Size = 10
end
object Table1BDEDesigner5: TStringField
FieldName = '楼层'
FixedChar = True
Size = 10
end
object Table1BDEDesigner6: TStringField
FieldName = '房间号码'
FixedChar = True
Size = 10
end
object Table1BDEDesigner7: TStringField
FieldName = '房主姓名'
FixedChar = True
Size = 10
end
end
object DataSource3: TDataSource
DataSet = Table1
Left = 64
Top = 424
end
object Query2: TQuery
DatabaseName = 'WYGL'
SQL.Strings = (
'Select * From 采暖费')
Left = 504
Top = 261
object Query2BDEDesigner: TStringField
FieldName = '采暖费编号'
Origin = 'WYGL.采暖费.采暖费编号'
FixedChar = True
end
object Query2BDEDesigner2: TStringField
FieldName = '户主姓名'
Origin = 'WYGL.采暖费.户主姓名'
FixedChar = True
Size = 10
end
object Query2BDEDesigner3: TFloatField
FieldName = '采暖费标准'
Origin = 'WYGL.采暖费.采暖费标准'
end
object Query2BDEDesigner4: TDateTimeField
FieldName = '计费起始日期'
Origin = 'WYGL.采暖费.计费起始日期'
end
object Query2BDEDesigner5: TDateTimeField
FieldName = '计费终止日期'
Origin = 'WYGL.采暖费.计费终止日期'
end
object Query2BDEDesigner6: TFloatField
FieldName = '建筑面积'
Origin = 'WYGL.采暖费.建筑面积'
end
object Query2BDEDesigner7: TFloatField
FieldName = '应收金额'
Origin = 'WYGL.采暖费.应收金额'
end
object Query2BDEDesigner8: TFloatField
FieldName = '实收金额'
Origin = 'WYGL.采暖费.实收金额'
end
object Query2BDEDesigner9: TFloatField
FieldName = '余额'
Origin = 'WYGL.采暖费.余额'
end
object Query2BDEDesigner10: TFloatField
FieldName = '减免金额'
Origin = 'WYGL.采暖费.减免金额'
end
object Query2BDEDesigner11: TStringField
FieldName = '原因'
Origin = 'WYGL.采暖费.原因'
FixedChar = True
Size = 50
end
object Query2BDEDesigner12: TStringField
FieldName = '是否收缴'
Origin = 'WYGL.采暖费.是否收缴'
FixedChar = True
Size = 10
end
end
object DataSource4: TDataSource
DataSet = Query2
Left = 464
Top = 261
end
end
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -