gl_qry_balancesheet.dfm

一个MRPII系统源代码版本

inherited Frm_Gl_Qry_BalanceSheet: TFrm_Gl_Qry_BalanceSheet
  Left = 63
  Top = 105
  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
      FrozenCols = 2
      TitlEHeight = 20
      Columns = <
        Item
          FieldName = 'projectCode'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'assetproject'
          PickList.Strings = ()
          Width = 150
          KeyList.Strings = ()
        end
        Item
          FieldName = 'plineno'
          PickList.Strings = ()
          Width = 40
          KeyList.Strings = ()
        end
        Item
          FieldName = 'FirstBalance'
          PickList.Strings = ()
          Width = 65
          KeyList.Strings = ()
        end
        Item
          FieldName = 'lastBalance'
          PickList.Strings = ()
          Width = 65
          KeyList.Strings = ()
        end
        Item
          FieldName = 'owesprossessoryproject'
          PickList.Strings = ()
          Width = 145
          KeyList.Strings = ()
        end
        Item
          FieldName = 'plineno1'
          PickList.Strings = ()
          Width = 36
          KeyList.Strings = ()
        end
        Item
          FieldName = 'FirstBalance1'
          PickList.Strings = ()
          Width = 65
          KeyList.Strings = ()
        end
        Item
          FieldName = 'lastBalance1'
          PickList.Strings = ()
          Width = 65
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 317
  end
  inherited ActionList: TActionList
    Left = 184
    Top = 200
  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 t1.projectCode,'
      '       t1.assetproject,'
      '       t1.plineno,'
      '       t2.FirstBalance as FirstBalance,'
      '       t3.FirstBalance as lastBalance,'
      '       t1.owesprossessoryproject,'
      '       t1.plineno1,'
      '       t4.FirstBalance as FirstBalance1,'
      '       t5.FirstBalance as lastBalance1'
      'from  Gl_BalanceSheet t1'
      ' join Gl_AccountSubjectBalance t2 on t1.plineno=t2.kmid'
      ' join Gl_AccountSubjectBalance t3 on t1.plineno=t3.kmid'
      ' join Gl_AccountSubjectBalance t4 on t1.plineno=t4.kmid'
      ' join Gl_AccountSubjectBalance t5 on t1.plineno=t5.kmid')
    Left = 224
    Top = 217
    object AdoQry_MainprojectCode: TStringField
      DisplayLabel = '项目编号'
      FieldName = 'projectCode'
      Origin = '#tMpSheet'
      Size = 16
    end
    object AdoQry_Mainassetproject: TStringField
      DisplayLabel = '资产'
      FieldName = 'assetproject'
      Origin = '#tMpSheet'
      Size = 60
    end
    object AdoQry_Mainplineno: TIntegerField
      DisplayLabel = '行次'
      FieldName = 'plineno'
      Origin = '#tMpSheet'
    end
    object AdoQry_MainFirstBalance: TFloatField
      DisplayLabel = '期初数'
      FieldName = 'FirstBalance'
      Origin = '#tMpSheet'
    end
    object AdoQry_MainlastBalance: TFloatField
      DisplayLabel = '期末数'
      FieldName = 'lastBalance'
      Origin = '#tMpSheet'
    end
    object AdoQry_Mainowesprossessoryproject: TStringField
      DisplayLabel = '负债及所有者权益'
      FieldName = 'owesprossessoryproject'
      Origin = '#tMpSheet'
      Size = 60
    end
    object AdoQry_Mainplineno1: TIntegerField
      DisplayLabel = '行次 '
      FieldName = 'plineno1'
      Origin = '#tMpSheet'
    end
    object AdoQry_MainFirstBalance1: TFloatField
      DisplayLabel = '期初数 '
      FieldName = 'FirstBalance1'
      Origin = '#tMpSheet'
    end
    object AdoQry_MainlastBalance1: TFloatField
      DisplayLabel = '期末数 '
      FieldName = 'lastBalance1'
      Origin = '#tMpSheet'
    end
  end
  inherited DataSource: TDataSource
    Left = 336
    Top = 201
  end
end