datapas.~dfm
来自「本软件是一套功能完整成熟的固定资产管理系统,具有固定资产管理系统的相应全部功能」· ~DFM 代码 · 共 1,872 行 · 第 1/5 页
~DFM
1,872 行
NumericScale = 255
Precision = 255
Size = 510
Value = Null
end
item
Name = 'edate'
Attributes = [paNullable]
DataType = ftFixedChar
NumericScale = 255
Precision = 255
Size = 510
Value = Null
end>
SQL.Strings = (
'select b.'#36164#20135#20511#20986#32534#30721',a.'#22266#23450#36164#20135#32534#30721',b.'#20511#29992#20154#22995#21517',a.'#36164#20135#31867#21035#32534#30721',a.'#36164#20135#21517#31216#32534#30721',a.'#36164#20135#29992#36884#32534#30721',a.'#36164#20135 +
#22411#21495#32534#30721','
'a.'#20379#24212#21830#32534#30721',b.'#20511#29992#26085#26399',b.'#25311#36824#26085#26399',a.'#32844#21592#32534#30721',a.'#23384#25918#22320#28857',a.'#24207#21015#21495',a.'#37197#32622' '
'from '#22266#23450#36164#20135#20449#24687#34920' a,'#22266#23450#36164#20135#20511#29992#34920' b '
'where a.'#26159#21542#20511#20986'=true and a.'#22266#23450#36164#20135#32534#30721'=b.'#22266#23450#36164#20135#32534#30721
'and b.'#26159#21542#24402#36824'=false and b.'#20511#29992#26085#26399'>=:sdate and b.'#20511#29992#26085#26399'<=:edate'
'')
Left = 8
Top = 160
object SmallintField8: TSmallintField
FieldName = #22266#23450#36164#20135#32534#30721
end
object ycjzccxDSDesigner4: TSmallintField
FieldName = #36164#20135#20511#20986#32534#30721
end
object SmallintField9: TSmallintField
DisplayLabel = #36164#20135#31867#21035
FieldName = #36164#20135#31867#21035#32534#30721
end
object SmallintField10: TSmallintField
DisplayLabel = #36164#20135#21517#31216
FieldName = #36164#20135#21517#31216#32534#30721
end
object SmallintField11: TSmallintField
DisplayLabel = #36164#20135#29992#36884
FieldName = #36164#20135#29992#36884#32534#30721
end
object SmallintField12: TSmallintField
DisplayLabel = #36164#20135#22411#21495
FieldName = #36164#20135#22411#21495#32534#30721
end
object SmallintField13: TSmallintField
DisplayLabel = #20379#24212#21830
FieldName = #20379#24212#21830#32534#30721
end
object SmallintField14: TSmallintField
DisplayLabel = #20351#29992#32773
FieldName = #32844#21592#32534#30721
end
object WideStringField4: TWideStringField
FieldName = #23384#25918#22320#28857
Size = 50
end
object WideStringField5: TWideStringField
FieldName = #24207#21015#21495
Size = 50
end
object WideStringField6: TWideStringField
FieldName = #37197#32622
Size = 50
end
object StringField7: TStringField
DisplayLabel = #36164#20135#31867#21035
FieldKind = fkLookup
FieldName = 'zclb'
LookupDataSet = gdzclbb
LookupKeyFields = #36164#20135#31867#21035#32534#30721
LookupResultField = #22266#23450#36164#20135#31867#21035
KeyFields = #36164#20135#31867#21035#32534#30721
Lookup = True
end
object StringField8: TStringField
DisplayLabel = #36164#20135#21517#31216
FieldKind = fkLookup
FieldName = 'zcmc'
LookupDataSet = gdzcmcb
LookupKeyFields = #36164#20135#21517#31216#32534#30721
LookupResultField = #22266#23450#36164#20135#21517#31216
KeyFields = #36164#20135#21517#31216#32534#30721
Lookup = True
end
object StringField9: TStringField
DisplayLabel = #36164#20135#29992#36884
FieldKind = fkLookup
FieldName = 'zcyt'
LookupDataSet = gdzcytb
LookupKeyFields = #36164#20135#29992#36884#32534#30721
LookupResultField = #22266#23450#36164#20135#29992#36884
KeyFields = #36164#20135#29992#36884#32534#30721
Lookup = True
end
object StringField10: TStringField
DisplayLabel = #36164#20135#22411#21495
FieldKind = fkLookup
FieldName = 'zcxh'
LookupDataSet = gdzcxhb
LookupKeyFields = #36164#20135#22411#21495#32534#30721
LookupResultField = #22266#23450#36164#20135#22411#21495
KeyFields = #36164#20135#22411#21495#32534#30721
Lookup = True
end
object StringField11: TStringField
DisplayLabel = #20379#24212#21830
FieldKind = fkLookup
FieldName = 'gys'
LookupDataSet = gysbmb
LookupKeyFields = #20379#24212#21830#32534#30721
LookupResultField = #20379#24212#21830#21517#31216
KeyFields = #20379#24212#21830#32534#30721
Lookup = True
end
object StringField12: TStringField
DisplayLabel = #20351#29992#32773
FieldKind = fkLookup
FieldName = 'zyxm'
LookupDataSet = zybmb
LookupKeyFields = #32844#21592#32534#30721
LookupResultField = #32844#21592#22995#21517
KeyFields = #32844#21592#32534#30721
Lookup = True
end
object ycjzccxDSDesigner: TWideStringField
FieldName = #20511#29992#20154#22995#21517
Size = 10
end
object ycjzccxDSDesigner2: TDateTimeField
FieldName = #20511#29992#26085#26399
end
object ycjzccxDSDesigner3: TDateTimeField
FieldName = #25311#36824#26085#26399
end
end
object gdzcjyb: TADOTable
Connection = hjzcdatabase
TableName = #22266#23450#36164#20135#20511#29992#34920
Left = 48
Top = 160
object gdzcjybDSDesigner: TSmallintField
FieldName = #36164#20135#20511#20986#32534#30721
end
object gdzcjybDSDesigner2: TSmallintField
FieldName = #22266#23450#36164#20135#32534#30721
end
object gdzcjybDSDesigner3: TIntegerField
FieldName = #32463#25163#20154#32534#30721
end
object gdzcjybjsr: TStringField
DisplayLabel = #32463#25163#20154
FieldKind = fkLookup
FieldName = 'jsr'
LookupDataSet = zybmb
LookupKeyFields = #32844#21592#32534#30721
LookupResultField = #32844#21592#22995#21517
KeyFields = #32463#25163#20154#32534#30721
Lookup = True
end
object gdzcjybDSDesigner4: TWideStringField
FieldName = #20511#29992#20154#22995#21517
Size = 10
end
object gdzcjybDSDesigner5: TDateTimeField
FieldName = #20511#29992#26085#26399
end
object gdzcjybDSDesigner6: TDateTimeField
FieldName = #25311#36824#26085#26399
end
object gdzcjybDSDesigner7: TWideStringField
FieldName = #20511#29992#22320#28857
Size = 50
end
object gdzcjybDSDesigner8: TBooleanField
FieldName = #26159#21542#24402#36824
end
object gdzcjybDSDesigner9: TWideStringField
FieldName = #22791#27880
Size = 120
end
end
object zcwxcx: TADOQuery
Connection = hjzcdatabase
Parameters = <
item
Name = 'sdate'
Attributes = [paNullable]
DataType = ftFixedChar
NumericScale = 255
Precision = 255
Size = 510
Value = Null
end
item
Name = 'edate'
Attributes = [paNullable]
DataType = ftFixedChar
NumericScale = 255
Precision = 255
Size = 510
Value = Null
end>
SQL.Strings = (
'select '#22266#23450#36164#20135#32534#30721','#36164#20135#31867#21035#32534#30721','#36164#20135#21517#31216#32534#30721','#36164#20135#29992#36884#32534#30721','#36164#20135#22411#21495#32534#30721','
#20379#24212#21830#32534#30721','#36141#20080#26085#26399','#32844#21592#32534#30721','#23384#25918#22320#28857','#26159#21542#20511#20986','#24207#21015#21495','#37197#32622','#32500#20462#26631#24535' '
'from '#22266#23450#36164#20135#20449#24687#34920' where '#36141#20080#26085#26399'>=:sdate'
'and '#36141#20080#26085#26399'<=:edate')
Left = 88
Top = 160
object SmallintField15: TSmallintField
FieldName = #22266#23450#36164#20135#32534#30721
end
object SmallintField16: TSmallintField
DisplayLabel = #36164#20135#31867#21035
FieldName = #36164#20135#31867#21035#32534#30721
end
object SmallintField17: TSmallintField
DisplayLabel = #36164#20135#21517#31216
FieldName = #36164#20135#21517#31216#32534#30721
end
object SmallintField18: TSmallintField
DisplayLabel = #36164#20135#29992#36884
FieldName = #36164#20135#29992#36884#32534#30721
end
object SmallintField19: TSmallintField
DisplayLabel = #36164#20135#22411#21495
FieldName = #36164#20135#22411#21495#32534#30721
end
object SmallintField20: TSmallintField
DisplayLabel = #20379#24212#21830
FieldName = #20379#24212#21830#32534#30721
end
object DateTimeField2: TDateTimeField
FieldName = #36141#20080#26085#26399
end
object SmallintField21: TSmallintField
DisplayLabel = #20351#29992#32773
FieldName = #32844#21592#32534#30721
end
object WideStringField7: TWideStringField
FieldName = #23384#25918#22320#28857
Size = 50
end
object BooleanField1: TBooleanField
FieldName = #26159#21542#20511#20986
end
object WideStringField8: TWideStringField
FieldName = #24207#21015#21495
Size = 50
end
object WideStringField9: TWideStringField
FieldName = #37197#32622
Size = 50
end
object StringField13: TStringField
DisplayLabel = #36164#20135#31867#21035
FieldKind = fkLookup
FieldName = 'zclb'
LookupDataSet = gdzclbb
LookupKeyFields = #36164#20135#31867#21035#32534#30721
LookupResultField = #22266#23450#36164#20135#31867#21035
KeyFields = #36164#20135#31867#21035#32534#30721
Lookup = True
end
object StringField14: TStringField
DisplayLabel = #36164#20135#21517#31216
FieldKind = fkLookup
FieldName = 'zcmc'
LookupDataSet = gdzcmcb
LookupKeyFields = #36164#20135#21517#31216#32534#30721
LookupResultField = #22266#23450#36164#20135#21517#31216
KeyFields = #36164#20135#21517#31216#32534#30721
Lookup = True
end
object StringField15: TStringField
DisplayLabel = #36164#20135#29992#36884
FieldKind = fkLookup
FieldName = 'zcyt'
LookupDataSet = gdzcytb
LookupKeyFields = #36164#20135#29992#36884#32534#30721
LookupResultField = #22266#23450#36164#20135#29992#36884
KeyFields = #36164#20135#29992#36884#32534#30721
Lookup = True
end
object StringField16: TStringField
DisplayLabel = #36164#20135#22411#21495
FieldKind = fkLookup
FieldName = 'zcxh'
LookupDataSet = gdzcxhb
LookupKeyFields = #36164#20135#22411#21495#32534#30721
LookupResultField = #22266#23450#36164#20135#22411#21495
KeyFields = #36164#20135#22411#21495#32534#30721
Lookup = True
end
object StringField17: TStringField
DisplayLabel = #20379#24212#21830
FieldKind = fkLookup
FieldName = 'gys'
LookupDataSet = gysbmb
LookupKeyFields = #20379#24212#21830#32534#30721
LookupResultField = #20379#24212#21830#21517#31216
KeyFields = #20379#24212#21830#32534#30721
Lookup = True
end
object StringField18: TStringField
DisplayLabel = #20351#29992#32773
FieldKind = fkLookup
FieldName = 'zyxm'
LookupDataSet = zybmb
LookupKeyFields = #32844#21592#32534#30721
LookupResultField = #32844#21592#22995#21517
KeyFields = #32844#21592#32534#30721
Lookup = True
end
object zcwxcxDSDesigner: TBooleanField
FieldName = #32500#20462#26631#24535
OnGetText = zcwxcxDSDesignerGetText
end
end
object gdzccx: TADOQuery
Connection = hjzcdatabase
OnCalcFields = gdzccxCalcFields
Parameters = <
item
Name = 'sdate'
Attributes = [paNullable]
DataType = ftFixedChar
NumericScale = 255
Precision = 255
Size = 510
Value = Null
end
item
Name = 'edate'
Attributes = [paNullable]
DataType = ftFixedChar
NumericScale = 255
Precision = 255
Size = 510
Value = Null
end>
SQL.Strings = (
'select '#22266#23450#36164#20135#32534#30721','#36164#20135#31867#21035#32534#30721','#36164#20135#21517#31216#32534#30721','#36164#20135#29992#36884#32534#30721','#36164#20135#22411#21495#32534#30721','
#36141#20080#20215#26684','#20351#29992#24180#38480','#20379#24212#21830#32534#30721','#36141#20080#26085#26399','#32844#21592#32534#30721','#23384#25918#22320#28857','#26159#21542#20511#20986','#24207#21015#21495','#37197#32622' '
'from '#22266#23450#36164#20135#20449#24687#34920' where '#25253#24223'=false and '#36141#20080#26085#26399'>=:sdate'
'and '#36141#20080#26085#26399'<=:edate')
Left = 128
Top = 160
object SmallintField22: TSmallintField
FieldName = #22266#23450#36164#20135#32534#30721
end
object SmallintField23: TSmallintField
DisplayLabel = #36164#20135#31867#21035
FieldName = #36164#20135#31867#21035#32534#30721
end
object SmallintField24: TSmallintField
DisplayLabel = #36164#20135#21517#31216
FieldName = #36164#20135#21517#31216#32534#30721
end
object SmallintField25: TSmallintField
DisplayLabel = #36164#20135#29992#36884
FieldName = #36164#20135#29992#36884#32534#30721
end
object SmallintField26: TSmallintField
DisplayLabel = #36164#20135#22411#21495
FieldName = #36164#20135#22411#21495#32534#30721
end
object SmallintField27: TSmallintField
DisplayLabel = #20379#24212#21830
FieldName = #20379#24212#21830#32534#30721
end
object DateTimeField3: TDateTimeField
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?