ap_qry_noinvoiceinvinbilllist.dfm

一个MRPII系统源代码版本

inherited Frm_Ap_Qry_NoInvoiceInvInBillList: TFrm_Ap_Qry_NoInvoiceInvInBillList
  Left = 6
  Top = 117
  Caption = '未开发票入库单列表'
  ClientHeight = 510
  ClientWidth = 753
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 753
  end
  inherited Pnl_Title: TPanel
    Width = 753
    inherited Image2: TImage
      Width = 753
    end
  end
  inherited Pnl_Head: TPanel
    Width = 753
    inherited Image1: TImage
      Width = 753
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 312
    Width = 753
    Height = 198
    inherited Image4: TImage
      Top = 34
      Width = 753
      Height = 164
    end
    object Splitter1: TSplitter
      Left = 0
      Top = 0
      Width = 753
      Height = 1
      Cursor = crVSplit
      Align = alTop
      ResizeStyle = rsLine
    end
    object Panel1: TPanel
      Left = 0
      Top = 1
      Width = 753
      Height = 33
      Align = alTop
      BevelOuter = bvNone
      TabOrder = 0
      object Lb_tax: TLabel
        Left = 312
        Top = 8
        Width = 36
        Height = 12
        Caption = 'Lb_tax'
      end
      object Label3: TLabel
        Left = 216
        Top = 8
        Width = 84
        Height = 12
        Caption = '含税金额合计：'
      end
      object Lb_Notax: TLabel
        Left = 104
        Top = 8
        Width = 48
        Height = 12
        Caption = 'Lb_Notax'
      end
      object Label1: TLabel
        Left = 8
        Top = 8
        Width = 84
        Height = 12
        Caption = '未税金额合计：'
      end
    end
    object DBGridEh1: TDBGridEh
      Left = 0
      Top = 34
      Width = 753
      Height = 164
      Align = alClient
      DataSource = DataSource1
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      PopuPmenu = PopuPmenu
      ReadOnly = True
      TabOrder = 1
      TitleFont.ChArset = GB2312_CHArSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -12
      TitleFont.Name = '宋体'
      TitleFont.Style = []
      OnDrawDataCell = DBGridEhDrawDataCell
      UseMultiTitle = True
      OnGetCellParams = DBGridEhGetCellParams
      Columns = <
        Item
          FieldName = 'InvBilllineno'
          Title.Alignment = taCenter
          Title.Caption = '单据行号'
          Width = 116
        end
        Item
          FieldName = 'ItemB'
          Title.Alignment = taCenter
          Title.Caption = '物料标识'
          Width = 241
        end
        Item
          FieldName = 'InvBillQTY'
          Title.Alignment = taCenter
          Title.Caption = '入库量'
          Width = 103
        end
        Item
          Alignment = tArightJustify
          FieldName = 'InvBillPrice'
          Title.Alignment = taCenter
          Title.Caption = '含税价'
        end
        Item
          Alignment = tArightJustify
          FieldName = 'InvBillAmount'
          Title.Alignment = taCenter
          Title.Caption = '含税金额'
        end
        Item
          FieldName = 'InvBillPriceC'
          Title.Alignment = taCenter
          Title.Caption = '含税价  (本位币)'
          Width = 55
        end
        Item
          Alignment = tArightJustify
          FieldName = 'InvBillAmountC'
          Title.Alignment = taCenter
          Title.Caption = '含税金额  (本位币)'
          Width = 66
        end>
    end
  end
  inherited Pnl_Body: TPanel
    Width = 753
    Height = 215
    inherited Image3: TImage
      Width = 753
      Height = 215
    end
    inherited DBGridEh: TDBGridEh
      Width = 753
      Height = 215
      Columns = <
        Item
          FieldName = 'VendorCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '供应商代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'VendorB'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '供应商标识'
          Width = 278
          KeyList.Strings = ()
        end
        Item
          FieldName = 'WHCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '仓库代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'WarehouseB'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '仓库标识'
          Width = 98
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvBillDate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '入库日期'
          Width = 77
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvBillNo'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '单据号'
          Width = 69
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CurrencyCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '货币代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'currencyB'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '货币标识'
          Width = 83
          KeyList.Strings = ()
        end
        Item
          Alignment = tArightJustify
          FieldName = 'InvBillnotaxAmount'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '未税金额'
          Width = 117
          KeyList.Strings = ()
        end
        Item
          Alignment = tArightJustify
          FieldName = 'InvBillAmount'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '含税金额'
          Width = 70
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvBillnotaxAmountC'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '未税金额  (本位币)'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvBillAmountC'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '含税金额  (本位币)'
          Width = 62
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 621
    Top = 3
  end
  inherited ActionList: TActionList
    Left = 456
    Top = 0
  end
  inherited AdoQry_Main: TAdoQuery
    CacheSize = 100
    ConnectionString = ''
    SQL.Strings = (
      'select InvInBill.InvBillId,'
      '               InvInBill.VendorCode,'
      
        '               InvInBill.VendorCode+'#39' '#39'+Vendor.VendorName as ven' +
        'dorB,'
      '               InvInBill.WHCode,'
      
        '               InvInBill.WHCode+'#39' '#39'+Warehouse.WHName as wArehous' +
        'eB,'
      '               InvInBill.InvBillNo,'
      '               InvInBill.InvBillDate,'
      '               InvInBill.CurrencyCode,'
      
        '               InvInBill.CurrencyCode+'#39' '#39'+ currency.currencyName' +
        ' as currencyB,'
      
        '               sum(InvInBillline.InvBillnotaxAmountC) as InvBill' +
        'notaxAmountC,'
      
        '               sum(InvInBillline.InvBillAmountC) as InvBillAmoun' +
        'tC '
      '         from InvInBill'
      '         join Vendor on InvInBill.VendorCode=Vendor.VendorCode'
      '         join Warehouse on InvInBill.WHCode=Warehouse.WHCode'
      
        '         join currency on InvInBill.CurrencyCode=currency.curren' +
        'cyCode'
      
        '         join InvInBillline on  InvInBill.InvBillId=InvInBilllin' +
        'e.InvBillid '
      
        '         group by InvInBill.InvBillId,InvInBill.VendorCode,vendo' +
        'r.VendorName,'
      '        Warehouse.WHName,currency.currencyName,'
      
        '        InvInBill.WHCode,InvInBill.InvBillNo,InvInBill.InvBillDa' +
        'te,InvInBill.CurrencyCode')
    Left = 488
    Top = 1
  end
  inherited DataSource: TDataSource
    OnDataChange = DataSourceDataChange
    Left = 520
    Top = 1
  end
  inherited ExtPrintReport: TExtPrintReport
    Left = 584
    Top = 1
  end
  inherited PopuPmenu: TPopuPmenu
    Left = 552
    Top = 1
  end
  object DataSource1: TDataSource
    DataSet = AdoQuery_Detail
    Left = 472
    Top = 406
  end
  object AdoQuery_Detail: TAdoQuery
    Parameters = <>
    Left = 344
    Top = 398
  end
end