sfc_monthsumqrybcp_d1.dfm

一个MRPII系统源代码版本

inherited Frm_Sfc_MonthSumQrybcp_D1: TFrm_Sfc_MonthSumQrybcp_D1
  Left = -7
  Top = 74
  Caption = '未分配的印刷钢板记录'
  ClientHeight = 486
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    inherited ToolBar: TToolBar
      inherited ToolButton1: TToolButton
        Visible = False
      end
      inherited ToolButton5: TToolButton
        Visible = False
      end
      inherited ToolButton7: TToolButton
        Visible = False
      end
      inherited TlBtn_InsertLine: TToolButton
        Visible = False
      end
      inherited TlBtn_Modify: TToolButton
        Visible = False
      end
      inherited TlBtn_DeleteLine: TToolButton
        Visible = False
      end
      inherited ToolButton6: TToolButton
        Visible = False
      end
      inherited ToolButton2: TToolButton
        Visible = False
      end
      inherited ToolButton3: TToolButton
        Visible = False
      end
      inherited TlBtn_Excel: TToolButton
        Visible = True
      end
    end
  end
  inherited Pnl_Title: TPanel
    Caption = '没有对应外壳的印刷钢板'
  end
  inherited Pnl_Head: TPanel
    object Label3: TLabel
      Left = 8
      Top = 29
      Width = 60
      Height = 12
      Caption = '筛选条件：'
    end
    object lbl_filter: TLabel
      Left = 71
      Top = 28
      Width = 98
      Height = 12
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 449
    Height = 37
    object Label1: TLabel
      Left = 304
      Top = 12
      Width = 60
      Height = 12
      Caption = '数量汇总：'
    end
    object Label2: TLabel
      Left = 504
      Top = 12
      Width = 60
      Height = 12
      Caption = '金额汇总：'
    end
    object Edit1: TEdit
      Left = 364
      Top = 8
      Width = 121
      Height = 20
      ReadOnly = True
      TabOrder = 0
    end
    object Edit2: TEdit
      Left = 563
      Top = 8
      Width = 121
      Height = 20
      ReadOnly = True
      TabOrder = 1
    end
  end
  inherited Pnl_Body: TPanel
    Height = 339
    inherited DBGridEh: TDBGridEh
      Height = 339
      Columns = <
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料代码'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料描述'
          Width = 272
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Invoutqty'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '耗用数量'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvoutAmount'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '耗用金额'
          Width = 82
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Body: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=mdrcmrm;Data Source=192.168.0.15' +
      '1;Use procedure for Prepare=1;Auto Translate=True;Packet Size=40' +
      '96;Workstation ID=XYB'
    SQL.Strings = (
      
        'select Temp01.ItemCode,Item.ItemName,Invoutqty,InvoutAmount from' +
        ' Temp01'
      'left join Item on Temp01.ItemCode=Item.ItemCode'
      ' where Temp01.ItemCode not in (select ItemCode from Temp02)')
    object AdoQry_BodyItemCode: TStringField
      FieldName = 'ItemCode'
      Size = 16
    end
    object AdoQry_BodyItemName: TStringField
      FieldName = 'ItemName'
      Size = 80
    end
    object AdoQry_BodyInvoutqty: TFloatField
      FieldName = 'Invoutqty'
    end
    object AdoQry_BodyInvoutAmount: TFloatField
      FieldName = 'InvoutAmount'
    end
  end
end