pingheng.~dfm

全面剖析财务管理的内容

object fmPingheng: TfmPingheng
  Left = 192
  Top = 107
  Width = 695
  Height = 480
  Caption = #35797#31639#24179#34913#34920
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object Panel1: TPanel
    Left = 0
    Top = 392
    Width = 687
    Height = 61
    Align = alBottom
    BevelOuter = bvNone
    TabOrder = 0
    object StringGrid1: TStringGrid
      Left = 0
      Top = 0
      Width = 687
      Height = 61
      Align = alClient
      ColCount = 8
      DefaultRowHeight = 18
      RowCount = 2
      TabOrder = 0
    end
  end
  object DBGrid1: TDBGrid
    Left = 0
    Top = 0
    Width = 687
    Height = 392
    Align = alClient
    DataSource = DataSource1
    TabOrder = 1
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    Columns = <
      item
        Expanded = False
        FieldName = #31185#30446#20195#30721
        Width = 57
        Visible = True
      end
      item
        Expanded = False
        FieldName = #31185#30446#21517#31216
        Width = 109
        Visible = True
      end
      item
        Expanded = False
        FieldName = #26399#21021#20511#26041
        Width = 65
        Visible = True
      end
      item
        Expanded = False
        FieldName = #26399#21021#36151#26041
        Width = 65
        Visible = True
      end
      item
        Expanded = False
        FieldName = #26412#26399#21457#29983#20511#26041
        Visible = True
      end
      item
        Expanded = False
        FieldName = #26412#26399#21457#29983#36151#26041
        Visible = True
      end
      item
        Expanded = False
        FieldName = #26399#26411#20511#26041
        Width = 68
        Visible = True
      end
      item
        Expanded = False
        FieldName = #26399#26411#36151#26041
        Width = 67
        Visible = True
      end>
  end
  object DataSource1: TDataSource
    DataSet = Query1
    Left = 608
    Top = 112
  end
  object Query1: TQuery
    Active = True
    DatabaseName = 'db'
    SQL.Strings = (
      'select '#31185#30446#20195#30721', '#31185#30446#21517#31216', '
      #9'(case when '#20313#39069#26041#21521'='#39#20511#26041#39' then '#26399#21021#20313#39069' else 0 end - '#32047#35745#20511#26041') as '#26399#21021#20511#26041','
      #9'(case when '#20313#39069#26041#21521'='#39#36151#26041#39' then '#26399#21021#20313#39069' else 0 end - '#32047#35745#36151#26041') as '#26399#21021#36151#26041','
      #9#32047#35745#20511#26041' as '#26412#26399#21457#29983#20511#26041','#32047#35745#36151#26041' as '#26412#26399#21457#29983#36151#26041','
      #9'case when '#20313#39069#26041#21521'='#39#20511#26041#39' then '#26399#21021#20313#39069' else 0 end as '#26399#26411#20511#26041','
      #9'case when '#20313#39069#26041#21521'='#39#36151#26041#39' then '#26399#21021#20313#39069' else 0 end as '#26399#26411#36151#26041
      #9'from '#24080#31807#21021#22987#21270#34920
      #9'where '#32047#35745#20511#26041'<>0 or '#32047#35745#36151#26041'<>0 or '#26399#21021#20313#39069'<>0')
    Left = 608
    Top = 80
  end
  object Query2: TQuery
    DatabaseName = 'db'
    Left = 608
    Top = 144
  end
end