stk_otherprice.dfm

一个MRPII系统源代码版本

inherited Frm_Stk_OtherPrice: TFrm_Stk_OtherPrice
  Left = 9
  Top = 116
  Caption = '其它入库物料参考价格表'
  ClientHeight = 422
  ClientWidth = 781
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 781
  end
  inherited Pnl_Title: TPanel
    Width = 781
    Caption = '其它入库物料参考价格表'
    inherited Image2: TImage
      Width = 781
    end
  end
  inherited Pnl_Head: TPanel
    Width = 781
    inherited Image1: TImage
      Width = 781
    end
    inherited Lbl_Condition: TLabel
      Width = 24
      Caption = '全部'
    end
    inherited Lbl_Order: TLabel
      Width = 120
      Caption = '供应商代码，物料代码'
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 416
    Width = 781
    Height = 6
    inherited Image4: TImage
      Width = 781
      Height = 6
    end
  end
  inherited Pnl_Body: TPanel
    Width = 781
    Height = 319
    inherited Image3: TImage
      Width = 781
      Height = 319
    end
    inherited DBGridEh: TDBGridEh
      Width = 781
      Height = 319
      Columns = <
        Item
          FieldName = 'VendorCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '供应商代码'
          Width = 67
          KeyList.Strings = ()
        end
        Item
          FieldName = 'VendorName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '供应商描述'
          Width = 182
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料代码'
          Width = 125
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料描述'
          Width = 250
          KeyList.Strings = ()
        end
        Item
          FieldName = 'TaxRate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '税率%'
          Width = 44
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Price'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '含税价'
          Width = 67
          KeyList.Strings = ()
        end
        Item
          FieldName = 'NoTaxPrice'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '未税价'
          Width = 68
          KeyList.Strings = ()
        end>
    end
  end
  inherited ActionList: TActionList
    Left = 208
    Top = 160
  end
  inherited AdoQry_Main: TAdoQuery
    CurSorType = ctStatic
    SQL.Strings = (
      'Select OtherPrice.VendorCode'
      '    ,OtherPrice.ItemCode'
      '    ,Vendor.VendorName'
      '    ,Item.ItemName'
      '    ,OtherPrice.Price'
      '    ,OtherPrice.NoTaxPrice'
      '    ,OtherPrice.TaxRate'
      '     From OtherPrice'
      '     Join Vendor on OtherPrice.VendorCode=Vendor.VendorCode'
      '     Join Item on OtherPrice.ItemCode=Item.ItemCode'
      ' ')
    Left = 40
    Top = 153
    object AdoQry_MaInvendorCode: TStringField
      FieldName = 'VendorCode'
      Origin = 'OtherPrice'
      Size = 12
    end
    object AdoQry_MainItemCode: TStringField
      FieldName = 'ItemCode'
      Origin = 'OtherPrice'
      Size = 16
    end
    object AdoQry_MaInvendorName: TStringField
      FieldName = 'VendorName'
      Origin = 'Vendor'
      Size = 60
    end
    object AdoQry_MainItemName: TStringField
      FieldName = 'ItemName'
      Origin = 'Item'
      Size = 60
    end
    object AdoQry_MainPrice: TFloatField
      FieldName = 'Price'
      Origin = 'OtherPrice'
    end
    object AdoQry_MainNoTaxPrice: TFloatField
      FieldName = 'NoTaxPrice'
      Origin = 'OtherPrice'
    end
    object AdoQry_MainTaxRate: TFloatField
      FieldName = 'TaxRate'
      Origin = 'OtherPrice'
    end
  end
  inherited DataSource: TDataSource
    Left = 344
    Top = 177
  end
end