tas500_02.dfm.svn-base

这是一个功能齐全的,代码完整的ERP企业信息管理系统,现在上传和大家分享

      LookupResultField = 'O151_004'
      KeyFields = 'T500_015'
      Size = 50
      Lookup = True
    end
    object qryTas500O150_007: TWideStringField
      DisplayLabel = #30005#23376#37038#20214
      FieldKind = fkCalculated
      FieldName = 'O150_007'
      Size = 50
      Calculated = True
    end
    object qryTas500I150_002: TWideStringField
      DisplayLabel = #20135#21697#32534#21495
      FieldKind = fkLookup
      FieldName = 'I150_002'
      LookupDataSet = qryInv150
      LookupKeyFields = 'I150_001'
      LookupResultField = 'I150_002'
      KeyFields = 'T500_016'
      Size = 30
      Lookup = True
    end
    object qryTas500I150_003: TWideStringField
      DisplayLabel = #20135#21697#21517#31216
      FieldKind = fkLookup
      FieldName = 'I150_003'
      LookupDataSet = qryInv150
      LookupKeyFields = 'I150_001'
      LookupResultField = 'I150_003'
      KeyFields = 'T500_016'
      Size = 60
      Lookup = True
    end
    object qryTas500I150_004: TWideStringField
      DisplayLabel = #35268#26684#22411#21495
      FieldKind = fkLookup
      FieldName = 'I150_004'
      LookupDataSet = qryInv150
      LookupKeyFields = 'I150_001'
      LookupResultField = 'I150_004'
      KeyFields = 'T500_016'
      Size = 60
      Lookup = True
    end
    object qryTas500I120_003: TWideStringField
      DisplayLabel = #20135#21697#31867#21035
      FieldKind = fkLookup
      FieldName = 'I120_003'
      LookupDataSet = qryInv150
      LookupKeyFields = 'I150_001'
      LookupResultField = 'I120_003'
      KeyFields = 'T500_016'
      Size = 50
      Lookup = True
    end
    object qryTas500M150_002: TWideStringField
      DisplayLabel = #21046#36896#21830#21495
      FieldKind = fkLookup
      FieldName = 'M150_002'
      LookupDataSet = qryInv150
      LookupKeyFields = 'I150_001'
      LookupResultField = 'O150_002'
      KeyFields = 'T500_016'
      Lookup = True
    end
    object qryTas500M150_003: TWideStringField
      DisplayLabel = #21046#36896#21830#21517
      FieldKind = fkLookup
      FieldName = 'M150_003'
      LookupDataSet = qryInv150
      LookupKeyFields = 'I150_001'
      LookupResultField = 'O150_003'
      KeyFields = 'T500_016'
      Size = 60
      Lookup = True
    end
    object qryTas500T500_017: TWideStringField
      DisplayLabel = #26426#36523#32534#21495
      FieldName = 'T500_017'
      Size = 30
    end
    object qryTas500T500_019: TDateTimeField
      DisplayLabel = #21046#21333#26085#26399
      FieldName = 'T500_019'
    end
    object qryTas500T500_020: TWideStringField
      DisplayLabel = #21046#21333#20154#21592
      FieldName = 'T500_020'
    end
    object qryTas500T500_021: TDateTimeField
      DisplayLabel = #20462#25913#26085#26399
      FieldName = 'T500_021'
    end
    object qryTas500T500_022: TWideStringField
      DisplayLabel = #20462#25913#20154#21592
      FieldName = 'T500_022'
    end
    object qryTas500H150_002: TWideStringField
      DisplayLabel = #36131#20219#20154#21495
      FieldKind = fkLookup
      FieldName = 'H150_002'
      LookupDataSet = qryHrm150
      LookupKeyFields = 'H150_001'
      LookupResultField = 'H150_002'
      KeyFields = 'T500_023'
      Lookup = True
    end
    object qryTas500H150_003: TWideStringField
      DisplayLabel = #36131#20219#20154#21592
      FieldKind = fkLookup
      FieldName = 'H150_003'
      LookupDataSet = qryHrm150
      LookupKeyFields = 'H150_001'
      LookupResultField = 'H150_003'
      KeyFields = 'T500_023'
      Lookup = True
    end
    object qryTas500T500_024: TDateTimeField
      DisplayLabel = #39044#35745#24320#22987
      FieldName = 'T500_024'
    end
    object qryTas500T500_025: TDateTimeField
      DisplayLabel = #39044#35745#23436#25104
      FieldName = 'T500_025'
    end
    object qryTas500T500_026: TDateTimeField
      DisplayLabel = #23454#38469#24320#22987
      FieldName = 'T500_026'
    end
    object qryTas500T500_027: TDateTimeField
      DisplayLabel = #23454#38469#23436#25104
      FieldName = 'T500_027'
    end
    object qryTas500T500_003: TIntegerField
      FieldName = 'T500_003'
      Visible = False
    end
    object qryTas500T500_009: TIntegerField
      FieldName = 'T500_009'
      Visible = False
    end
    object qryTas500T500_015: TIntegerField
      FieldName = 'T500_015'
      Visible = False
    end
    object qryTas500T500_016: TIntegerField
      FieldName = 'T500_016'
      Visible = False
    end
    object qryTas500T500_018: TMemoField
      DisplayLabel = #39033#30446#35828#26126
      FieldName = 'T500_018'
      Visible = False
      BlobType = ftMemo
    end
    object qryTas500T500_023: TIntegerField
      FieldName = 'T500_023'
      Visible = False
    end
    object qryTas500T500_004: TIntegerField
      FieldName = 'T500_004'
      Visible = False
    end
    object qryTas500T130_006: TBooleanField
      FieldName = 'T130_006'
      Visible = False
    end
  end
  object qryHrm150: TADOQuery
    Connection = SYSDM.ADOC
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select H150_001,H150_002,H150_003 from HRM150 order by H150_002')
    Left = 352
    Top = 80
    object qryHrm150H150_001: TAutoIncField
      FieldName = 'H150_001'
      ReadOnly = True
      Visible = False
    end
    object qryHrm150H150_002: TWideStringField
      DisplayLabel = #21592#24037#32534#21495
      FieldName = 'H150_002'
    end
    object qryHrm150H150_003: TWideStringField
      DisplayLabel = #21592#24037#22995#21517
      FieldName = 'H150_003'
    end
  end
  object ActionList1: TActionList
    Images = SYSDM.imgBtn
    Left = 576
    Top = 8
    object ActFirst: TAction
      Caption = #26368#21069
      Hint = #31227#21040#31532#19968#26465#35760#24405
      ImageIndex = 0
      ShortCut = 32838
      OnExecute = ActFirstExecute
    end
    object ActPrior: TAction
      Caption = #19978#31227
      Hint = #31227#21040#19978#19968#26465#35760#24405
      ImageIndex = 1
      ShortCut = 32834
      OnExecute = ActPriorExecute
    end
    object ActNext: TAction
      Caption = #19979#31227
      Hint = #31227#21040#19979#19968#26465#35760#24405
      ImageIndex = 2
      ShortCut = 32846
      OnExecute = ActNextExecute
    end
    object ActLast: TAction
      Caption = #26368#21518
      Hint = #31227#21040#26368#21518#19968#26465#35760#24405
      ImageIndex = 3
      ShortCut = 32844
      OnExecute = ActLastExecute
    end
    object ActInsert: TAction
      Caption = #26032#22686
      Hint = #26032#22686#19968#26465#35760#24405
      ImageIndex = 4
      ShortCut = 32833
      OnExecute = ActInsertExecute
    end
    object ActUpdate: TAction
      Caption = #20462#25913
      Hint = #20462#25913#24403#21069#35760#24405
      ImageIndex = 5
      ShortCut = 32837
      OnExecute = ActUpdateExecute
    end
    object ActDelete: TAction
      Caption = #21024#38500
      Hint = #21024#38500#24403#21069#35760#24405
      ImageIndex = 6
      ShortCut = 32836
      OnExecute = ActDeleteExecute
    end
    object ActSave: TAction
      Caption = #20445#23384
      Enabled = False
      Hint = #20445#23384#32534#36753#30340#35760#24405
      ImageIndex = 7
      ShortCut = 32851
      OnExecute = ActSaveExecute
    end
    object ActCancel: TAction
      Caption = #21462#28040
      Enabled = False
      Hint = #21462#28040#32534#36753#30340#35760#24405
      ImageIndex = 8
      ShortCut = 32835
      OnExecute = ActCancelExecute
    end
    object ActRefresh: TAction
      Caption = #21047#26032
      Hint = #21462#24471#26368#26032#30340#25968#25454
      ImageIndex = 9
      ShortCut = 32850
      OnExecute = ActRefreshExecute
    end
    object ActLocate: TAction
      Caption = #26597#25214
      Hint = #24555#36895#23450#20301#35760#24405
      ImageIndex = 10
      ShortCut = 32847
      OnExecute = ActLocateExecute
    end
    object ActSearch: TAction
      Caption = #26597#35810
      Hint = #25353#26465#20214#26597#35810#25968#25454
      ImageIndex = 11
      ShortCut = 32849
      OnExecute = ActSearchExecute
    end
    object ActPrint: TAction
      Caption = #25171#21360
      Hint = #23558#25968#25454#25171#21360#20986#26469
      ImageIndex = 12
      ShortCut = 32848
      OnExecute = ActPrintExecute
    end
    object ActExit: TAction
      Caption = #36864#20986
      Hint = #20851#38381#24403#21069#31383#21475
      ImageIndex = 15
      ShortCut = 32856
      OnExecute = ActExitExecute
    end
  end
  object dsTas500: TDataSource
    DataSet = qryTas500
    Left = 8
    Top = 88
  end
  object qryOrd151: TADOQuery
    Connection = SYSDM.ADOC
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from ORD151 where O151_011<>0')
    Left = 88
    Top = 48
  end
  object dsTas130: TDataSource
    DataSet = qryTas130
    Left = 136
    Top = 40
  end
  object qryTas130: TADOQuery
    Connection = SYSDM.ADOC
    Parameters = <>
    SQL.Strings = (
      'select * from TAS130')
    Left = 168
    Top = 40
  end
  object qryInv150: TADOQuery
    Connection = SYSDM.ADOC
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'select A.I150_001,A.I150_002,A.I150_003,A.I150_004,B.I120_003,C.' +
        'O150_002,C.O150_003'
      
        'from (INV150 A left join INV120 B on A.I150_005=B.I120_001) left' +
        ' join ORD150 C on A.I150_010=C.O150_001')
    Left = 64
    Top = 96
  end
  object qrySer500: TADOQuery
    CacheSize = 1000
    Connection = SYSDM.ADOC
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select S500_001,S500_002,S100_002,S500_017,S500_018,S500_019'
      'from SER500, SER100'
      'where S500_004=S100_001 and S500_003=1'
      'order by S500_001')
    Left = 320
    Top = 112
    object qrySer500S500_001: TWideStringField
      DisplayLabel = #26469#30005#32534#21495
      FieldName = 'S500_001'
      Size = 30
    end
    object qrySer500S500_002: TWideStringField
      DisplayLabel = #26469#30005#21517#31216
      FieldName = 'S500_002'
      Size = 50
    end
    object qrySer500S100_002: TWideStringField
      DisplayLabel = #26381#21153#31867#21035
      FieldName = 'S100_002'
      Size = 50
    end
    object qrySer500S500_017: TIntegerField
      DisplayLabel = #23458#25142#32534#21495
      FieldName = 'S500_017'
      Visible = False
    end
    object qrySer500S500_018: TIntegerField
      DisplayLabel = #20135#21697#32534#21495
      FieldName = 'S500_018'
      Visible = False
    end
    object qrySer500S500_019: TWideStringField
      DisplayLabel = #26426#36523#32534#21495
      FieldName = 'S500_019'
      Visible = False
      Size = 30
    end
  end
end