ap_qry_apbalancelist.dfm

一个MRPII系统源代码版本

inherited Frm_Ap_Qry_ApBalanceList: TFrm_Ap_Qry_ApBalanceList
  Left = 18
  Top = 113
  Caption = '应付帐款期初余额表查询'
  ClientWidth = 759
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 759
  end
  inherited Pnl_Title: TPanel
    Width = 759
    inherited Image2: TImage
      Width = 759
    end
  end
  inherited Pnl_Head: TPanel
    Width = 759
    inherited Image1: TImage
      Width = 759
    end
  end
  inherited Pnl_Hint: TPanel
    Width = 759
    inherited Image4: TImage
      Width = 759
    end
  end
  inherited Pnl_Body: TPanel
    Width = 759
    inherited Image3: TImage
      Width = 759
    end
    inherited DBGridEh: TDBGridEh
      Width = 759
      Columns = <
        Item
          FieldName = 'VendorCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '供应商代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'VendorCodeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '供应商标识'
          Width = 318
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ApBalanceMonth'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '月份'
          Width = 62
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CurrencyCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '货币代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CurrencyCodeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '货币标识'
          Width = 100
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvoiceBalance'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '有票应付期初余额'
          Width = 121
          KeyList.Strings = ()
        end
        Item
          FieldName = 'NoInviceBalance'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '未开票应付期初余额'
          Width = 126
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 77
    Top = 35
  end
  inherited ActionList: TActionList
    Left = 320
    Top = 0
  end
  inherited AdoQry_Main: TAdoQuery
    CacheSize = 100
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=Mrpii;Data Source=192.168.0.151'
    SQL.Strings = (
      'select ApBalance.ApBalanceMonth'
      '      ,ApBalance.VendorCode '
      
        '      ,ApBalance.VendorCode +'#39' '#39'+Vendor.VendorName as VendorCode' +
        'Name'
      '      ,Vendor.CurrencyCode'
      
        '      ,Vendor.CurrencyCode+'#39' '#39'+Currency.CurrencyName  as Currenc' +
        'yCodeName'
      '      ,ApBalance.InvoiceBalance'
      '      ,ApBalance.NoInviceBalance '
      
        'from Vendor left join Currency on Vendor.CurrencyCode=Currency.C' +
        'urrencyCode'
      'left join ApBalance on ApBalance.VendorCode=Vendor.VendorCode '
      ' where ApBalanceMonth is not null ')
    Left = 8
    Top = 33
    object AdoQry_MaInvendorCode: TStringField
      FieldName = 'VendorCode'
      Origin = 'Vendor'
      Size = 12
    end
    object AdoQry_MaInvendorCodeName: TStringField
      FieldName = 'VendorCodeName'
      ReadOnly = True
      Size = 73
    end
    object AdoQry_MainApBalanceMonth: TStringField
      FieldName = 'ApBalanceMonth'
      Origin = 'ApBalance'
      Size = 7
    end
    object AdoQry_MainCurrencyCode: TStringField
      FieldName = 'CurrencyCode'
      Origin = 'Currency'
      Size = 3
    end
    object AdoQry_MainCurrencyCodeName: TStringField
      FieldName = 'CurrencyCodeName'
      ReadOnly = True
      Size = 34
    end
    object AdoQry_MainInvoiceBalance: TFloatField
      FieldName = 'InvoiceBalance'
      Origin = 'ApBalance'
    end
    object AdoQry_MainNoInviceBalance: TFloatField
      FieldName = 'NoInviceBalance'
      Origin = 'ApBalance'
    end
  end
  inherited DataSource: TDataSource
    Left = 40
    Top = 33
  end
  inherited ExtPrintReport: TExtPrintReport
    Left = 400
    Top = 1
  end
  inherited PopuPmenu: TPopuPmenu
    Left = 360
    Top = 1
  end
end