inv_importsumqry.dfm

一个MRPII系统源代码版本

inherited Frm_Inv_ImportSumQry: TFrm_Inv_ImportSumQry
  Left = -34
  Top = 93
  Caption = '进口采购入库汇总表'
  PixelsPerInch = 96
  TextHeight = 12
  inherited Pnl_Title: TPanel
    Caption = '进口采购入库汇总表'
  end
  inherited Pnl_Head: TPanel
    inherited Lbl_Order: TLabel
      Width = 48
      Caption = '物料标识'
    end
  end
  inherited Pnl_Hint: TPanel
    object Label1: TLabel
      Left = 6
      Top = 8
      Width = 96
      Height = 12
      Caption = '当前行物料描述：'
    end
    object DBText1: TDBText
      Left = 102
      Top = 8
      Width = 42
      Height = 12
      AutoSize = True
      DataField = 'ItemName'
      DataSource = DataSource
    end
  end
  inherited Pnl_Body: TPanel
    inherited DBGridEh: TDBGridEh
      Columns = <
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料代码'
          Width = 75
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料描述'
          Width = 131
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemCodeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料标识'
          Width = 230
          KeyList.Strings = ()
        end
        Item
          FieldName = 'UomName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '计量单位'
          Width = 53
          KeyList.Strings = ()
        end
        Item
          FieldName = 'AInvBillQty'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '数量'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CurrencyCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '货币代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CurrencyName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '货币名称'
          Width = 67
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'CurrencyCodeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '货币标识'
          Width = 122
          KeyList.Strings = ()
        end
        Item
          FieldName = 'AInvBillNoTaxPriceC'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '未税价'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'AInvBillNoTaxAmountC'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '未税金额'
          Width = 68
          KeyList.Strings = ()
        end
        Item
          FieldName = 'AInvBillNoTaxPrice'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '人民币未税价'
          Width = 80
          KeyList.Strings = ()
        end
        Item
          FieldName = 'AInvBillNoTaxAmount'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '人民币未税金额'
          Width = 88
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 293
    Top = 195
  end
  inherited ActionList: TActionList
    Left = 208
    Top = 216
  end
  inherited AdoQry_Main: TAdoQuery
    CurSorType = ctStatic
    SQL.Strings = (
      'Select InvInBillLine.ItemCode'
      '    ,Item.ItemName'
      '    ,InvInBillLine.ItemCode+'#39' '#39'+Item.ItemName As ItemCodeName'
      '    ,Uom.UomName'
      '    ,InvInBill.CurrencyCode'
      '    ,Currency.CurrencyName'
      
        '    ,InvInBill.CurrencyCode+'#39' '#39'+Currency.CurrencyName As Currenc' +
        'yCodeName'
      '    ,Sum(InvInBillLine.InvBillQty) As AInvBillQty'
      '    ,(Case Sum(InvInBillLine.InvBillQty) When 0 Then 0'
      
        '     Else Sum(InvInBillLine.InvBillNoTaxAmountC)/Sum(InvInBillLi' +
        'ne.InvBillQty) end)'
      '     As AInvBillNoTaxPriceC'
      
        '    ,Sum(InvInBillLine.InvBillNoTaxAmountC) As AInvBillNoTaxAmou' +
        'ntC'
      '    ,(Case Sum(InvInBillLine.InvBillQty) When 0 Then 0'
      
        '     Else Sum(InvInBillLine.InvBillNoTaxAmount)/Sum(InvInBillLin' +
        'e.InvBillQty) end)'
      '     As AInvBillNoTaxPrice'
      
        '    ,Sum(InvInBillLine.InvBillNoTaxAmount) As AInvBillNoTaxAmoun' +
        't'
      
        '     From InvInBillLine Join InvInBill On InvInBillLine.InvBillI' +
        'd=InvInBill.InvBillId'
      
        '     Join Currency On InvInBill.CurrencyCode=Currency.CurrencyCo' +
        'de'
      '     Join Item On InvInBillLine.ItemCode=Item.ItemCode'
      '     Join Uom On Item.UomCode=Uom.UomCode'
      
        '    Group By InvInBillLine.ItemCode,Item.ItemName,Uom.UomName,In' +
        'vInBill.CurrencyCode,Currency.CurrencyName'
      ' ')
    Left = 304
    Top = 225
  end
  inherited DataSource: TDataSource
    Left = 376
    Top = 153
  end
end