📄 query3unit.~dfm
字号:
01000000000000000761A1A2D3AAD2B5054D4E53323200000000FFFFFFFFFFFF
FFFF01000000000000000762A1A2CDA3D2B5054D4E53323300000000FFFFFFFF
FFFFFFFF01000000000000000763A1A2D4DABDA8054D4E53323400000000FFFF
FFFFFFFFFFFF01000000000000000764A1A2B3B7CFFA054D4E53323500000000
FFFFFFFFFFFFFFFF01000000000000000765A1A2C6E4CBFB054D4E5332360000
0000FFFFFFFFFFFFFFFF010000000000000011A3A834A3A9B0B4C6F3D2B5B9E6
C4A3B7D6054D4E53323700000000FFFFFFFFFFFFFFFF01000000000000000961
A1A2CCD8B4F3D0CD054D4E53323800000000FFFFFFFFFFFFFFFF010000000000
00000762A1A2B4F3D0CD054D4E53323900000000FFFFFFFFFFFFFFFF01000000
000000000763A1A2D6D0D0CD054D4E53333000000000FFFFFFFFFFFFFFFF0100
0000000000000764A1A2D0A1D0CD054D4E53333100000000FFFFFFFFFFFFFFFF
01000000000000000765A1A2C6E4CBFB054D4E53333200000000FFFFFFFFFFFF
FFFF01000000000000001932A1A2C6F3D2B5D7A2B2E1D7CAB1BEBDF0A3A8CDF2
D4AAA3A9054D4E53333300000000FFFFFFFFFFFFFFFF01000000000000001161
A1A2B9ABB9B2C6FBB3B5A1A2B5E7B3B5054D4E53333400000000FFFFFFFFFFFF
FFFF01000000000000000762A1A2B5D8CCFA054D4E53333500000000FFFFFFFF
FFFFFFFF01000000000000000763A1A2C7E1B9EC054D4E53333600000000FFFF
FFFFFFFFFFFF01000000000000000764A1A2C2D6B6C9054D4E533337FFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF}
RowSelect = True
ParentFont = False
TabOrder = 0
ViewStyle = vsReport
end
end
object TabSheet4: TTabSheet
Caption = #22235#39029
ImageIndex = 3
object ListView1: TListView
Left = 0
Top = 0
Width = 792
Height = 484
Align = alClient
Columns = <
item
Caption = #25351#26631#21517#31216
Width = 160
end
item
Caption = #20195#30721
end
item
Caption = #20445#31246#21306
end
item
Caption = #19996#31435#21306
end
item
Caption = #35199#38738#21306
end
item
Caption = #27941#21335#21306
end
item
Caption = #21271#36784#21306
end
item
Caption = #27494#28165#21306
end
item
Caption = #23453#22395#21306
end
item
Caption = #23425#27827#21439
end
item
Caption = #38745#28023#21439
end
item
Caption = #34015#21439
end>
Font.Charset = ANSI_CHARSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = #23435#20307
Font.Style = []
GridLines = True
Items.Data = {
9E0200001100000000000000FFFFFFFFFFFFFFFF010000000000000011A3A833
A3A9B0B4D3AAD2B5D7B4CCACB7D6054D4E53323100000000FFFFFFFFFFFFFFFF
01000000000000000761A1A2D3AAD2B5054D4E53323200000000FFFFFFFFFFFF
FFFF01000000000000000762A1A2CDA3D2B5054D4E53323300000000FFFFFFFF
FFFFFFFF01000000000000000763A1A2D4DABDA8054D4E53323400000000FFFF
FFFFFFFFFFFF01000000000000000764A1A2B3B7CFFA054D4E53323500000000
FFFFFFFFFFFFFFFF01000000000000000765A1A2C6E4CBFB054D4E5332360000
0000FFFFFFFFFFFFFFFF010000000000000011A3A834A3A9B0B4C6F3D2B5B9E6
C4A3B7D6054D4E53323700000000FFFFFFFFFFFFFFFF01000000000000000961
A1A2CCD8B4F3D0CD054D4E53323800000000FFFFFFFFFFFFFFFF010000000000
00000762A1A2B4F3D0CD054D4E53323900000000FFFFFFFFFFFFFFFF01000000
000000000763A1A2D6D0D0CD054D4E53333000000000FFFFFFFFFFFFFFFF0100
0000000000000764A1A2D0A1D0CD054D4E53333100000000FFFFFFFFFFFFFFFF
01000000000000000765A1A2C6E4CBFB054D4E53333200000000FFFFFFFFFFFF
FFFF01000000000000001932A1A2C6F3D2B5D7A2B2E1D7CAB1BEBDF0A3A8CDF2
D4AAA3A9054D4E53333300000000FFFFFFFFFFFFFFFF01000000000000001161
A1A2B9ABB9B2C6FBB3B5A1A2B5E7B3B5054D4E53333400000000FFFFFFFFFFFF
FFFF01000000000000000762A1A2B5D8CCFA054D4E53333500000000FFFFFFFF
FFFFFFFF01000000000000000763A1A2C7E1B9EC054D4E53333600000000FFFF
FFFFFFFFFFFF01000000000000000764A1A2C2D6B6C9054D4E533337FFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF}
RowSelect = True
ParentFont = False
TabOrder = 0
ViewStyle = vsReport
end
end
end
object Panel1: TPanel
Left = 0
Top = 0
Width = 800
Height = 41
Align = alTop
TabOrder = 1
object Label1: TLabel
Left = 24
Top = 12
Width = 60
Height = 13
Caption = #32479#35745#24180#20221#65306
end
object BitBtn1: TBitBtn
Left = 256
Top = 8
Width = 75
Height = 25
Caption = #27983#35272
TabOrder = 0
OnClick = BitBtn1Click
Glyph.Data = {
76010000424D7601000000000000760000002800000020000000100000000100
04000000000000010000120B0000120B00001000000000000000000000000000
800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333000000
000033333377777777773333330FFFFFFFF03FF3FF7FF33F3FF700300000FF0F
00F077F777773F737737E00BFBFB0FFFFFF07773333F7F3333F7E0BFBF000FFF
F0F077F3337773F3F737E0FBFBFBF0F00FF077F3333FF7F77F37E0BFBF00000B
0FF077F3337777737337E0FBFBFBFBF0FFF077F33FFFFFF73337E0BF0000000F
FFF077FF777777733FF7000BFB00B0FF00F07773FF77373377373330000B0FFF
FFF03337777373333FF7333330B0FFFF00003333373733FF777733330B0FF00F
0FF03333737F37737F373330B00FFFFF0F033337F77F33337F733309030FFFFF
00333377737FFFFF773333303300000003333337337777777333}
NumGlyphs = 2
end
object ComboBox1: TComboBox
Left = 96
Top = 8
Width = 145
Height = 21
ItemHeight = 13
TabOrder = 1
Items.Strings = (
'2000'
'2001'
'2002'
'2003'
'2004'
'2005'
'2006'
'2007'
'2008'
'2009'
'2010')
end
object BitBtn2: TBitBtn
Left = 344
Top = 8
Width = 75
Height = 25
Caption = #25171#21360
TabOrder = 2
OnClick = BitBtn2Click
Glyph.Data = {
76010000424D7601000000000000760000002800000020000000100000000100
04000000000000010000130B0000130B00001000000000000000000000000000
800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00300000000000
00033FFFFFFFFFFFFFFF0888888888888880777777777777777F088888888888
8880777777777777777F0000000000000000FFFFFFFFFFFFFFFF0F8F8F8F8F8F
8F80777777777777777F08F8F8F8F8F8F9F0777777777777777F0F8F8F8F8F8F
8F807777777777777F7F0000000000000000777777777777777F3330FFFFFFFF
03333337F3FFFF3F7F333330F0000F0F03333337F77773737F333330FFFFFFFF
03333337F3FF3FFF7F333330F00F000003333337F773777773333330FFFF0FF0
33333337F3FF7F3733333330F08F0F0333333337F7737F7333333330FFFF0033
33333337FFFF7733333333300000033333333337777773333333}
NumGlyphs = 2
end
object BitBtn3: TBitBtn
Left = 448
Top = 8
Width = 75
Height = 25
Caption = #36864#20986
ModalResult = 1
TabOrder = 3
Glyph.Data = {
76010000424D7601000000000000760000002800000020000000100000000100
04000000000000010000120B0000120B00001000000000000000000000000000
800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
33333333333333333333333333333333333333333333333333FF333333333333
3000333333FFFFF3F77733333000003000B033333777773777F733330BFBFB00
E00033337FFF3377F7773333000FBFB0E000333377733337F7773330FBFBFBF0
E00033F7FFFF3337F7773000000FBFB0E000377777733337F7770BFBFBFBFBF0
E00073FFFFFFFF37F777300000000FB0E000377777777337F7773333330BFB00
000033333373FF77777733333330003333333333333777333333333333333333
3333333333333333333333333333333333333333333333333333333333333333
3333333333333333333333333333333333333333333333333333}
NumGlyphs = 2
end
end
object ADOQuery1: TADOQuery
Connection = BusTradeDataModule.ADOConnection1
CursorType = ctStatic
Parameters = <>
SQL.Strings = (
'SELECT b.'#20225#19994#20195#30721', b.'#32479#35745#24180#20221', '#33829#19994#29366#20917', '#20225#19994#35268#27169', ['#20225#19994'('#21333#20301')'#30331#35760#27880#20876#31867#22411'], '#20027#35201#19994#21153#27963#21160', '#20225#19994#27880#20876#36164 +
#26412#37329', '#21333#20301#22352#33853#21306#22495', ['#20844#20849#27773#36710#12289#30005#36710'], '#22320#38081', '#36731#36712', '#36718#28193
'FROM '#20844#29992#20107#19994#21333#20301#22522#26412#24773#20917#34920' AS a, '#20027#35201#19994#21153#27963#21160#34920' AS b'
'WHERE a.'#32479#35745#24180#20221' = b.'#32479#35745#24180#20221' AND a.'#21333#20301#20195#30721' = b.'#20225#19994#20195#30721)
Left = 144
Top = 312
end
object ADOQuery2: TADOQuery
Connection = BusTradeDataModule.ADOConnection1
CursorType = ctStatic
Parameters = <>
SQL.Strings = (
'SELECT '#21333#20301#20195#30721', '#32479#35745#24180#20221', '#33829#19994#29366#20917', '#20225#19994#35268#27169', ['#20225#19994'('#21333#20301')'#30331#35760#27880#20876#31867#22411'], '#21333#20301#22352#33853#21306#22495
'FROM '#20844#29992#20107#19994#21333#20301#22522#26412#24773#20917#34920
'')
Left = 192
Top = 312
object ADOQuery2DSDesigner: TWideStringField
FieldName = #21333#20301#20195#30721
Size = 12
end
object ADOQuery2DSDesigner2: TSmallintField
FieldName = #32479#35745#24180#20221
end
object ADOQuery2DSDesigner3: TWideStringField
FieldName = #33829#19994#29366#20917
Size = 10
end
object ADOQuery2DSDesigner4: TWideStringField
FieldName = #20225#19994#35268#27169
Size = 10
end
object ADOQuery2DSDesigner5: TWideStringField
FieldName = #20225#19994'('#21333#20301')'#30331#35760#27880#20876#31867#22411
end
object ADOQuery2DSDesigner6: TWideStringField
FieldName = #21333#20301#22352#33853#21306#22495
Size = 10
end
end
object ADOQuery3: TADOQuery
Connection = BusTradeDataModule.ADOConnection1
Parameters = <>
Left = 248
Top = 312
end
end
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -