pm_vendoritemassign.dfm

一个MRPII系统源代码版本

inherited Frm_Pm_VendorItemAssign: TFrm_Pm_VendorItemAssign
  Left = 37
  Top = 148
  Caption = '供应商物料分配表'
  ClientHeight = 471
  ClientWidth = 745
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 745
  end
  inherited Pnl_Title: TPanel
    Width = 745
    Caption = '供应商物料分配表'
    inherited Image2: TImage
      Width = 745
    end
  end
  inherited Pnl_Head: TPanel
    Width = 745
    inherited Image1: TImage
      Width = 745
    end
    inherited Lbl_Order: TLabel
      Width = 6
      Caption = ''
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 445
    Width = 745
    inherited Image4: TImage
      Width = 745
    end
  end
  inherited Pnl_Body: TPanel
    Width = 745
    Height = 348
    inherited Image3: TImage
      Width = 745
      Height = 348
    end
    inherited DBGridEh: TDBGridEh
      Width = 745
      Height = 348
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      Columns = <
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料代码'
          Width = 80
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料描述'
          Width = 300
          KeyList.Strings = ()
        end
        Item
          FieldName = 'VendorCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '供应商代码'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'VendorName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '供应商名称'
          Width = 200
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Assignrate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '分配比例(%)'
          Width = 80
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Main: TAdoQuery
    CurSorType = ctStatic
    SQL.Strings = (
      'Select a.ItemCode,'
      '       i.ItemName,'
      '       a.VendorCode,'
      '       v.VendorName,'
      '       a.Assignrate'
      'from VendorItemAssign a '
      '   left join Vendor v on a.VendorCode=v.VendorCode '
      '   left join Item i on a.ItemCode=i.ItemCode ')
    object AdoQry_MainItemCode: TStringField
      FieldName = 'ItemCode'
      Origin = 'VendorItemAssign'
      Size = 16
    end
    object AdoQry_MainItemName: TStringField
      FieldName = 'ItemName'
      Size = 60
    end
    object AdoQry_MaInvendorCode: TStringField
      FieldName = 'VendorCode'
      Origin = 'VendorItemAssign'
      Size = 12
    end
    object AdoQry_MaInvendorName: TStringField
      FieldName = 'VendorName'
      Size = 60
    end
    object AdoQry_MainAssignrate: TFloatField
      FieldName = 'Assignrate'
      Origin = 'VendorItemAssign'
    end
  end
end