inv_opmaterialsumqry.dfm

一个MRPII系统源代码版本

inherited Frm_Inv_OpMaterialSumQry: TFrm_Inv_OpMaterialSumQry
  Left = 24
  Top = 116
  Caption = '委外加工产品材料费汇总表'
  ClientHeight = 553
  ClientWidth = 800
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 800
  end
  inherited Pnl_Title: TPanel
    Width = 800
    Caption = '委外加工产品材料费汇总表'
    inherited Image2: TImage
      Width = 800
    end
  end
  inherited Pnl_Head: TPanel
    Width = 800
    inherited Image1: TImage
      Width = 800
    end
    inherited Lbl_Order: TLabel
      Width = 48
      Caption = '物料标识'
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 522
    Width = 800
    Height = 31
    inherited Image4: TImage
      Width = 800
      Height = 31
    end
    object Label1: TLabel
      Left = 504
      Top = 8
      Width = 66
      Height = 12
      Caption = '材料费合计:'
    end
    object Lbl_TaxAmountTatol: TLabel
      Left = 601
      Top = 8
      Width = 6
      Height = 12
    end
    object Edit1: TEdit
      Left = 574
      Top = 5
      Width = 137
      Height = 20
      ReadOnly = True
      TabOrder = 0
    end
  end
  inherited Pnl_Body: TPanel
    Width = 800
    Height = 425
    inherited Image3: TImage
      Width = 800
      Height = 425
    end
    inherited DBGridEh: TDBGridEh
      Width = 800
      Height = 425
      Columns = <
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料名称'
          Width = 229
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemCodeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料标识'
          Width = 319
          KeyList.Strings = ()
        end
        Item
          FieldName = 'UomName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '单位'
          Width = 38
          KeyList.Strings = ()
        end
        Item
          FieldName = 'AInvBillNoTaxAmount'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '材料费'
          Width = 172
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Main: TAdoQuery
    CurSorType = ctStatic
    SQL.Strings = (
      'Select InvInBillLine.ItemCode'
      '    ,Item.ItemName'
      '    ,InvInBillLine.ItemCode+'#39' '#39'+Item.ItemName As ItemCodeName'
      '    ,Uom.UomName'
      
        '    ,Sum(InvInBillLine.InvBillNoTaxAmount) As AInvBillNoTaxAmoun' +
        't'
      
        '     From InvInBillLine Join InvInBill On InvInBillLine.InvBillI' +
        'd=InvInBill.InvBillId'
      '     Join Item On InvInBillLine.ItemCode=Item.ItemCode'
      '     Join Uom On Item.UomCode=Uom.UomCode'
      '  Group By InvInBillLine.ItemCode,Item.ItemName,Uom.UomName'
      ' '
      ' ')
    Top = 257
  end
  inherited ExtPrintReport: TExtPrintReport
    PAperType = ptNArrow
  end
end