sfc_monthsumqrybcp.dfm

一个MRPII系统源代码版本

inherited Frm_Sfc_MonthSumQrybcp: TFrm_Sfc_MonthSumQrybcp
  Left = -33
  Top = 23
  Caption = '车间月末收发存汇总表'
  ClientHeight = 522
  ClientWidth = 754
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 754
  end
  inherited Pnl_Title: TPanel
    Width = 754
    Caption = '总装车间外壳月末收发存报表'
  end
  inherited Pnl_Head: TPanel
    Width = 754
    inherited Lbl_Condition: TLabel
      Width = 46
    end
    inherited Lbl_Order: TLabel
      Width = 78
      Caption = '部门/物料代码'
    end
    object Button1: TButton
      Left = 656
      Top = 8
      Width = 115
      Height = 25
      Caption = '未分配的印刷钢板'
      TabOrder = 0
      OnClick = Button1Click
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 490
    Width = 754
    Height = 32
    object DBText1: TDBText
      Left = 12
      Top = 10
      Width = 42
      Height = 12
      AutoSize = True
      DataField = 'ItemCodeName'
      DataSource = DataSource
    end
    object Label2: TLabel
      Left = 383
      Top = 12
      Width = 12
      Height = 12
      Caption = '上'
    end
    object Label3: TLabel
      Left = 486
      Top = 12
      Width = 12
      Height = 12
      Caption = '入'
    end
    object Label4: TLabel
      Left = 590
      Top = 12
      Width = 12
      Height = 12
      Caption = '出'
    end
    object Label5: TLabel
      Left = 690
      Top = 12
      Width = 12
      Height = 12
      Caption = '本'
    end
    object Label6: TLabel
      Left = 326
      Top = 12
      Width = 54
      Height = 12
      Caption = '金额汇总:'
    end
    object Edit1: TEdit
      Left = 399
      Top = 9
      Width = 84
      Height = 20
      ReadOnly = True
      TabOrder = 0
    end
    object Edit2: TEdit
      Left = 502
      Top = 9
      Width = 84
      Height = 20
      ReadOnly = True
      TabOrder = 1
    end
    object Edit3: TEdit
      Left = 603
      Top = 8
      Width = 84
      Height = 20
      ReadOnly = True
      TabOrder = 2
    end
    object Edit4: TEdit
      Left = 704
      Top = 8
      Width = 84
      Height = 20
      ReadOnly = True
      TabOrder = 3
    end
  end
  inherited Pnl_Body: TPanel
    Width = 754
    Height = 393
    inherited DBGridEh: TDBGridEh
      Width = 754
      Height = 393
      UseMultiTitle = True
      Columns = <
        Item
          FieldName = 'DeptCodeName'
          PickList.Strings = ()
          Title.Caption = '部门标识'
          Width = 94
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          Title.Caption = '物料代码'
          Width = 125
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          Title.Caption = '物料描述'
          Width = 204
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemCodeName'
          PickList.Strings = ()
          Title.Caption = '物料标识'
          Width = 250
          KeyList.Strings = ()
        end
        Item
          FieldName = 'UomName'
          PickList.Strings = ()
          Title.Caption = '单位'
          Width = 22
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvLMQty'
          PickList.Strings = ()
          Title.Caption = '上月结存|数量'
          Width = 56
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Price1'
          PickList.Strings = ()
          Title.Caption = '上月结存|单价'
          Width = 58
          KeyList.Strings = ()
        end
        Item
          FieldName = 'aInvLMQty'
          PickList.Strings = ()
          Title.Caption = '上月结存|金额'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvInQty'
          PickList.Strings = ()
          Title.Caption = '本月收入|数量'
          Width = 56
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Price2'
          PickList.Strings = ()
          Title.Caption = '本月收入|单价'
          Width = 56
          KeyList.Strings = ()
        end
        Item
          FieldName = 'aInvInQty'
          PickList.Strings = ()
          Title.Caption = '本月收入|金额'
          Width = 60
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvOutQty'
          PickList.Strings = ()
          Title.Caption = '本月发出|数量'
          Width = 60
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Price3'
          PickList.Strings = ()
          Title.Caption = '本月发出|单价'
          Width = 57
          KeyList.Strings = ()
        end
        Item
          FieldName = 'aInvOutQty'
          PickList.Strings = ()
          Title.Caption = '本月发出|金额'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvBlncQty'
          PickList.Strings = ()
          Title.Caption = '本月结存|数量'
          Width = 53
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Price4'
          PickList.Strings = ()
          Title.Caption = '本月结存|单价'
          Width = 55
          KeyList.Strings = ()
        end
        Item
          FieldName = 'aInvBlncQty'
          PickList.Strings = ()
          Title.Caption = '本月结存|金额'
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 437
    Top = 187
  end
  inherited ActionList: TActionList
    Left = 224
    Top = 208
  end
  inherited AdoQry_Main: TAdoQuery
    CurSorType = ctStatic
    SQL.Strings = (
      'Select InvMonthSum.ItemCode'
      '    ,Item.ItemName'
      '    ,InvMonthSum.ItemCode+'#39' '#39'+Item.ItemName As ItemCodeName'
      '    ,Uom.UomName'
      '    ,InvMonthSum.InvLMQty'
      '    ,InvMonthSum.InvLMPrice'
      '    ,InvMonthSum.InvLMAmount'
      '    ,InvMonthSum.InvInQty'
      '    ,InvMonthSum.InvInPrice'
      '    ,InvMonthSum.InvInAmount'
      '    ,InvMonthSum.InvOutQty'
      '    ,InvMonthSum.InvOutPrice'
      '    ,InvMonthSum.InvOutAmount'
      '    ,InvMonthSum.InvBlncQty'
      '    ,InvMonthSum.InvBlncPrice'
      '    ,InvMonthSum.InvBlncAmount'
      
        '     From InvMonthSum Join Item On InvMonthSum.ItemCode=Item.Ite' +
        'mCode'
      '     Join Uom On Item.UomCode=Uom.UomCode'
      ' ')
    Left = 320
    Top = 225
  end
  inherited DataSource: TDataSource
    Left = 368
    Top = 209
  end
  inherited ExtPrintReport: TExtPrintReport
    ReportFont.Height = -12
    PAperType = ptWide
  end
end