f_cbhs.dfm

使用Delphi开发的成本管理系统

object Form3: TForm3
  Left = 166
  Top = 184
  BorderStyle = bsDialog
  Caption = #25104#26412#26680#31639'  '
  ClientHeight = 437
  ClientWidth = 794
  Color = clSkyBlue
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  Position = poMainFormCenter
  OnClose = FormClose
  OnCreate = FormCreate
  PixelsPerInch = 94
  TextHeight = 13
  object Shape1: TShape
    Left = 40
    Top = 216
    Width = 201
    Height = 65
    Brush.Color = clMoneyGreen
    Pen.Color = clBlue
    Shape = stEllipse
  end
  object Label1: TLabel
    Left = 72
    Top = 240
    Width = 150
    Height = 25
    Cursor = crHandPoint
    Caption = #36164#28304#20998#25674#20449#24687
    Color = clMoneyGreen
    DragCursor = crHandPoint
    Font.Charset = GB2312_CHARSET
    Font.Color = clRed
    Font.Height = -24
    Font.Name = #21326#25991#34892#26999
    Font.Style = [fsBold]
    ParentColor = False
    ParentFont = False
    OnClick = Label1Click
  end
  object Shape2: TShape
    Left = 192
    Top = 96
    Width = 185
    Height = 73
    Brush.Color = clMoneyGreen
    Pen.Color = clBlue
    Shape = stEllipse
  end
  object Label2: TLabel
    Left = 224
    Top = 120
    Width = 128
    Height = 25
    Cursor = crHandPoint
    Caption = #20316#19994#27719#24635'    '
    Color = clMoneyGreen
    DragCursor = crHandPoint
    Font.Charset = GB2312_CHARSET
    Font.Color = clBlue
    Font.Height = -24
    Font.Name = #21326#25991#34892#26999
    Font.Style = [fsBold]
    ParentColor = False
    ParentFont = False
    OnClick = Label2Click
  end
  object Shape3: TShape
    Left = 208
    Top = 296
    Width = 201
    Height = 73
    Brush.Color = clMoneyGreen
    Pen.Color = clBlue
    Shape = stEllipse
  end
  object Label3: TLabel
    Left = 240
    Top = 320
    Width = 150
    Height = 25
    Cursor = crHandPoint
    Caption = #35745#31639#25104#26412#21160#22240
    Color = clMoneyGreen
    DragCursor = crHandPoint
    Font.Charset = GB2312_CHARSET
    Font.Color = clPurple
    Font.Height = -24
    Font.Name = #21326#25991#34892#26999
    Font.Style = [fsBold]
    ParentColor = False
    ParentFont = False
    OnClick = Label3Click
  end
  object Shape4: TShape
    Left = 360
    Top = 200
    Width = 201
    Height = 73
    Brush.Color = clMoneyGreen
    Pen.Color = clBlue
    Shape = stEllipse
  end
  object Label4: TLabel
    Left = 392
    Top = 224
    Width = 150
    Height = 25
    Cursor = crHandPoint
    Caption = #21046#36896#36153#29992#20998#37197
    Color = clMoneyGreen
    DragCursor = crHandPoint
    Font.Charset = GB2312_CHARSET
    Font.Color = clFuchsia
    Font.Height = -24
    Font.Name = #21326#25991#34892#26999
    Font.Style = [fsBold]
    ParentColor = False
    ParentFont = False
    OnClick = Label4Click
  end
  object Shape5: TShape
    Left = 528
    Top = 112
    Width = 185
    Height = 73
    Brush.Color = clMoneyGreen
    Pen.Color = clBlue
    Shape = stEllipse
  end
  object Label5: TLabel
    Left = 568
    Top = 136
    Width = 114
    Height = 25
    Cursor = crHandPoint
    Caption = #35745#31639#21033#28070'  '
    Color = clMoneyGreen
    DragCursor = crHandPoint
    Font.Charset = GB2312_CHARSET
    Font.Color = clYellow
    Font.Height = -24
    Font.Name = #21326#25991#34892#26999
    Font.Style = [fsBold]
    ParentColor = False
    ParentFont = False
    OnClick = Label5Click
  end
  object Shape6: TShape
    Left = 568
    Top = 280
    Width = 153
    Height = 65
    Brush.Color = clMoneyGreen
    Pen.Color = clBlue
    Shape = stEllipse
  end
  object Label6: TLabel
    Left = 616
    Top = 304
    Width = 50
    Height = 25
    Cursor = crHandPoint
    Caption = #20851#38381
    Color = clMoneyGreen
    Font.Charset = GB2312_CHARSET
    Font.Color = clOlive
    Font.Height = -24
    Font.Name = #21326#25991#34892#26999
    Font.Style = [fsBold]
    ParentColor = False
    ParentFont = False
    OnClick = Label6Click
  end
  object DBEdit1: TDBEdit
    Left = 16
    Top = 344
    Width = 97
    Height = 21
    DataField = 'sum'
    DataSource = DataSource1
    TabOrder = 0
    Visible = False
  end
  object DBEdit2: TDBEdit
    Left = 168
    Top = 104
    Width = 73
    Height = 21
    DataField = 'sum'
    DataSource = DataSource2
    TabOrder = 1
    Visible = False
  end
  object DBEdit3: TDBEdit
    Left = 136
    Top = 192
    Width = 73
    Height = 21
    DataField = 'sum'
    DataSource = DataSource3
    TabOrder = 2
    Visible = False
  end
  object DBEdit4: TDBEdit
    Left = 136
    Top = 216
    Width = 89
    Height = 21
    DataField = 'sum'
    DataSource = DataSource4
    TabOrder = 3
    Visible = False
  end
  object DBEdit5: TDBEdit
    Left = 136
    Top = 352
    Width = 89
    Height = 21
    DataField = 'sum'
    DataSource = DataSource5
    TabOrder = 4
    Visible = False
  end
  object DBEdit6: TDBEdit
    Left = 24
    Top = 192
    Width = 97
    Height = 21
    DataField = 'sum'
    DataSource = DataSource6
    TabOrder = 5
    Visible = False
  end
  object DBEdit7: TDBEdit
    Left = 40
    Top = 88
    Width = 89
    Height = 21
    DataField = 'sum'
    DataSource = DataSource7
    TabOrder = 6
    Visible = False
  end
  object DBEdit8: TDBEdit
    Left = 32
    Top = 128
    Width = 97
    Height = 21
    DataField = 'sum'
    DataSource = DataSource8
    TabOrder = 7
    Visible = False
  end
  object DBEdit9: TDBEdit
    Left = 136
    Top = 256
    Width = 78
    Height = 21
    DataField = 'sum'
    DataSource = DataSource9
    TabOrder = 8
    Visible = False
  end
  object DBEdit10: TDBEdit
    Left = 24
    Top = 288
    Width = 81
    Height = 21
    DataField = 'sum'
    DataSource = DataSource10
    TabOrder = 9
    Visible = False
  end
  object DBEdit11: TDBEdit
    Left = 24
    Top = 248
    Width = 89
    Height = 21
    DataField = 'sum'
    DataSource = DataSource11
    TabOrder = 10
    Visible = False
  end
  object DBEdit12: TDBEdit
    Left = 128
    Top = 288
    Width = 81
    Height = 21
    DataField = 'sum'
    DataSource = DataSource12
    TabOrder = 11
    Visible = False
  end
  object StaticText1: TStaticText
    Left = 312
    Top = 16
    Width = 175
    Height = 29
    Caption = #25104#26412#26680#31639#20449#24687'   '
    Font.Charset = GB2312_CHARSET
    Font.Color = clYellow
    Font.Height = -24
    Font.Name = #21326#25991#34892#26999
    Font.Style = [fsBold, fsUnderline]
    ParentFont = False
    TabOrder = 12
  end
  object ado_active: TADOQuery
    Active = True
    Connection = data1.database1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select * from active')
    Left = 16
    Top = 8
    object ado_activeactive_id: TStringField
      DisplayLabel = #27963#21160#21495
      FieldName = 'active_id'
      FixedChar = True
      Size = 5
    end
    object ado_activeactive_name: TStringField
      DisplayLabel = #27963#21160#21517
      FieldName = 'active_name'
      FixedChar = True
      Size = 15
    end
    object ado_activeactive_cost: TFloatField
      DisplayLabel = #27963#21160#25104#26412
      FieldName = 'active_cost'
    end
  end
  object ADOQuery1: TADOQuery
    Active = True
    Connection = data1.database1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select sum(distribute_cost) as sum'
      'from resourse_distribute,active'
      'where resourse_distribute.active_id=active.active_id '
      'and resourse_distribute.active_id='#39'501'#39)
    Left = 32
    Top = 336
    object ADOQuery1sum: TFloatField
      FieldName = 'sum'
      ReadOnly = True
    end
  end
  object ADOQuery2: TADOQuery
    Active = True
    Connection = data1.database1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select sum(distribute_cost) as sum'
      'from resourse_distribute,active'
      
        'where resourse_distribute.active_id=active.active_id and resours' +
        'e_distribute.active_id='#39'502'#39)
    Left = 200
    Top = 104
    object ADOQuery2sum: TFloatField
      FieldName = 'sum'
      ReadOnly = True
    end
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 80
    Top = 336
  end
  object DataSource2: TDataSource
    DataSet = ADOQuery2
    Left = 160
    Top = 104
  end
  object ADOQuery3: TADOQuery
    Active = True
    Connection = data1.database1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select sum(distribute_cost) as sum'
      'from resourse_distribute,active'
      'where resourse_distribute.active_id=active.active_id '
      'and resourse_distribute.active_id='#39'503'#39)
    Left = 160
    Top = 168
    object ADOQuery3sum: TFloatField
      FieldName = 'sum'
      ReadOnly = True
    end
  end
  object DataSource3: TDataSource
    DataSet = ADOQuery3
    Left = 168
    Top = 168
  end
  object DataSource4: TDataSource
    DataSet = ADOQuery4
    Left = 176
    Top = 208
  end
  object ADOQuery4: TADOQuery
    Active = True
    Connection = data1.database1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select sum(distribute_cost) as sum'
      'from resourse_distribute,active'
      'where resourse_distribute.active_id=active.active_id '
      'and resourse_distribute.active_id='#39'504'#39)
    Left = 168
    Top = 208
    object ADOQuery4sum: TFloatField
      FieldName = 'sum'
      ReadOnly = True
    end
  end
  object Data_active: TDataSource
    DataSet = ado_active
    Left = 40
    Top = 32
  end
  object DataSource5: TDataSource
    DataSet = ADOQuery5
    Left = 192
    Top = 344
  end
  object ADOQuery5: TADOQuery
    Active = True
    Connection = data1.database1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select sum(distribute_cost) as sum'
      'from resourse_distribute,active'
      'where resourse_distribute.active_id=active.active_id '
      'and resourse_distribute.active_id='#39'505'#39)
    Left = 192
    Top = 344
    object ADOQuery5sum: TFloatField
      FieldName = 'sum'
      ReadOnly = True
    end
  end
  object ADOQuery6: TADOQuery
    Active = True
    Connection = data1.database1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select sum(distribute_cost) as sum'
      'from resourse_distribute,active'
      'where resourse_distribute.active_id=active.active_id '
      'and resourse_distribute.active_id='#39'506'#39)
    Left = 56
    Top = 184
  end
  object DataSource6: TDataSource
    DataSet = ADOQuery6
    Left = 88
    Top = 184
  end
  object ADOQuery7: TADOQuery
    Active = True
    Connection = data1.database1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select sum(distribute_cost) as sum'
      'from resourse_distribute,active'
      'where resourse_distribute.active_id=active.active_id '
      'and resourse_distribute.active_id='#39'507'#39)
    Left = 104
    Top = 88
    object ADOQuery7sum: TFloatField
      FieldName = 'sum'
      ReadOnly = True
    end
  end
  object DataSource7: TDataSource
    DataSet = ADOQuery7
    Left = 88
    Top = 88
  end
  object ADOQuery8: TADOQuery
    Active = True
    Connection = data1.database1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select sum(distribute_cost) as sum'
      'from resourse_distribute,active'
      'where resourse_distribute.active_id=active.active_id '
      'and resourse_distribute.active_id='#39'508'#39)
    Left = 80
    Top = 136
    object ADOQuery8sum: TFloatField
      FieldName = 'sum'
      ReadOnly = True
    end
  end
  object DataSource8: TDataSource
    DataSet = ADOQuery8
    Left = 56
    Top = 136
  end
  object ADOQuery9: TADOQuery
    Active = True
    Connection = data1.database1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select sum(distribute_cost) as sum'
      'from resourse_distribute,active'
      'where resourse_distribute.active_id=active.active_id '
      'and resourse_distribute.active_id='#39'509'#39)
    Left = 176
    Top = 248
    object ADOQuery9sum: TFloatField
      FieldName = 'sum'
      ReadOnly = True
    end
  end
  object DataSource9: TDataSource
    DataSet = ADOQuery9
    Left = 160
    Top = 248
  end
  object ADOQuery10: TADOQuery
    Active = True
    Connection = data1.database1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select sum(distribute_cost) as sum'
      'from resourse_distribute,active'
      'where resourse_distribute.active_id=active.active_id '
      'and resourse_distribute.active_id='#39'510'#39)
    Left = 72
    Top = 288
    object ADOQuery10sum: TFloatField
      FieldName = 'sum'
      ReadOnly = True
    end
  end
  object DataSource10: TDataSource
    DataSet = ADOQuery10
    Left = 40
    Top = 280
  end
  object ADOQuery11: TADOQuery
    Active = True
    Connection = data1.database1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select sum(distribute_cost) as sum'
      'from resourse_distribute,active'
      'where resourse_distribute.active_id=active.active_id '
      'and resourse_distribute.active_id='#39'511'#39)
    Left = 88
    Top = 248
    object ADOQuery11sum: TFloatField
      FieldName = 'sum'
      ReadOnly = True
    end
  end
  object DataSource11: TDataSource
    DataSet = ADOQuery11
    Left = 72
    Top = 248
  end
  object DataSource12: TDataSource
    DataSet = ADOQuery12
    Left = 136
    Top = 280
  end
  object ADOQuery12: TADOQuery
    Active = True
    Connection = data1.database1
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select sum(distribute_cost) as sum'
      'from resourse_distribute,active'
      'where resourse_distribute.active_id=active.active_id '
      'and resourse_distribute.active_id='#39'512'#39)
    Left = 152
    Top = 280
    object ADOQuery12sum: TFloatField
      FieldName = 'sum'
      ReadOnly = True
    end
  end
  object ADOStoredProc1: TADOStoredProc
    Active = True
    Connection = data1.database1
    CursorType = ctStatic
    ProcedureName = 'pro_active;1'
    Parameters = <
      item
        DataType = ftString
        Size = 3
        Value = '501'
      end>
    Left = 176
    Top = 24
    object ADOStoredProc1sum: TFloatField
      FieldName = 'sum'
      ReadOnly = True
    end
  end
end