gl_qry_cashreport.dfm

一个MRPII系统源代码版本

inherited Frm_Gl_Qry_CashReport: TFrm_Gl_Qry_CashReport
  Left = 193
  Top = 121
  Caption = '现金流量表'
  PixelsPerInch = 96
  TextHeight = 12
  inherited Pnl_Title: TPanel
    Caption = '现金流量表'
  end
  inherited Pnl_Head: TPanel
    Height = 35
    inherited Image1: TImage
      Height = 35
    end
    inherited Lbl_OrderTitle: TLabel
      Top = 18
    end
    inherited Lbl_ConditionTitle: TLabel
      Top = 2
    end
    inherited Lbl_Condition: TLabel
      Top = 2
      Width = 24
      Caption = '全部'
    end
    inherited Lbl_Order: TLabel
      Top = 18
      Width = 48
      Caption = '项目编号'
    end
  end
  inherited Pnl_Body: TPanel
    Top = 92
    Height = 311
    inherited Image3: TImage
      Height = 311
    end
    inherited DBGridEh: TDBGridEh
      Height = 311
      Columns = <
        Item
          FieldName = 'projectName'
          PickList.Strings = ()
          Width = 219
          KeyList.Strings = ()
        end
        Item
          FieldName = 'plineno'
          PickList.Strings = ()
          Width = 36
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Totalsum'
          PickList.Strings = ()
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 317
  end
  inherited ActionList: TActionList
    Left = 120
    Top = 240
  end
  inherited AdoQry_Main: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=Mrpii_Standard;Data Source=192.1' +
      '68.0.151;Use procedure for Prepare=1;Auto Translate=True;Packet ' +
      'Size=4096;Workstation ID=XYB'
    SQL.Strings = (
      'select projectCode,'
      '       projectName,'
      '       plineno,'
      '       t2.FirstBalance as Totalsum'
      ' from Gl_Gain'
      'left join Gl_AccountSubjectBalance t2 on Gl_Gain.plineno=t2.kmid')
    Left = 216
    Top = 241
    object AdoQry_MainprojectName: TStringField
      DisplayLabel = '项目'
      FieldName = 'projectName'
      Origin = '#cashQry'
      Size = 60
    end
    object AdoQry_Mainplineno: TIntegerField
      DisplayLabel = '行次'
      FieldName = 'plineno'
      Origin = '#cashQry'
    end
    object AdoQry_MainprojectCode: TStringField
      DisplayLabel = '项目编号'
      FieldName = 'projectCode'
      Origin = '#cashQry'
      Size = 16
    end
    object AdoQry_MainTotalsum: TFloatField
      DisplayLabel = '金额'
      FieldName = 'Totalsum'
      Origin = '#cashQry'
    end
  end
  inherited DataSource: TDataSource
    Left = 336
    Top = 201
  end
end