inv_vendorsumqry.dfm

一个MRPII系统源代码版本

inherited Frm_Inv_VendorSumQry: TFrm_Inv_VendorSumQry
  Left = 31
  Top = 37
  Caption = '供应商到货金额汇总表'
  PixelsPerInch = 96
  TextHeight = 12
  inherited Pnl_Title: TPanel
    Caption = '供应商到货金额汇总表'
  end
  inherited Pnl_Head: TPanel
    inherited Lbl_Order: TLabel
      Width = 60
      Caption = '供应商标识'
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 401
    Height = 28
    object Lbl_NoTax: TLabel
      Left = 416
      Top = 8
      Width = 6
      Height = 12
      Anchors = [akTop, akRight]
    end
    object Label2: TLabel
      Left = 520
      Top = 8
      Width = 60
      Height = 12
      Anchors = [akTop, akRight]
      Caption = '含税总额：'
    end
    object Lbl_Tax: TLabel
      Left = 584
      Top = 8
      Width = 6
      Height = 12
      Anchors = [akTop, akRight]
    end
    object Label1: TLabel
      Left = 352
      Top = 8
      Width = 60
      Height = 12
      Anchors = [akTop, akRight]
      Caption = '未税总额：'
    end
  end
  inherited Pnl_Body: TPanel
    Height = 304
    inherited DBGridEh: TDBGridEh
      Height = 304
      Columns = <
        Item
          FieldName = 'VendorCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '供应商代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'VendorName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '供应商名称'
          Width = 229
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'VendorCodeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '供应商标识'
          Width = 345
          KeyList.Strings = ()
        end
        Item
          FieldName = 'AInvBillNoTaxAmount'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '未税金额'
          Width = 134
          KeyList.Strings = ()
        end
        Item
          FieldName = 'AInvBillAmount'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '含税金额'
          Width = 172
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 149
    Top = 211
  end
  inherited ActionList: TActionList
    Left = 200
    Top = 200
  end
  inherited AdoQry_Main: TAdoQuery
    CurSorType = ctStatic
    SQL.Strings = (
      'Select InvInBill.VendorCode'
      '    ,Vendor.VendorName'
      
        '    ,InvInBill.VendorCode+'#39' '#39'+Vendor.VendorName As VendorCodeNam' +
        'e'
      
        '    ,Sum(InvInBillLine.InvBillNoTaxAmount) As AInvBillNoTaxAmoun' +
        't'
      '    ,Sum(InvInBillLine.InvBillAmount) As AInvBillAmount'
      
        '     From InvInBillLine Join InvInBill On InvInBillLine.InvBillI' +
        'd=InvInBill.InvBillId'
      
        '     Join Currency On InvInBill.CurrencyCode=Currency.CurrencyCo' +
        'de'
      '     Join Vendor On InvInBill.VendorCode=Vendor.VendorCode'
      '  Group By InvInBill.VendorCode,Vendor.VendorName'
      ' '
      ' '
      ' ')
    Left = 304
    Top = 209
  end
  inherited DataSource: TDataSource
    Left = 376
    Top = 209
  end
  inherited PopuPmenu: TPopuPmenu
    Top = 201
  end
end