pm_qry_pc.dfm

一个MRPII系统源代码版本

inherited Frm_Pm_Qry_Pc: TFrm_Pm_Qry_Pc
  Left = 59
  Top = 123
  Caption = '采购价格列表查询'
  PixelsPerInch = 96
  TextHeight = 12
  inherited Pnl_Title: TPanel
    Caption = '采购价格列表查询'
  end
  inherited Pnl_Head: TPanel
    inherited Lbl_Condition: TLabel
      Width = 24
      Caption = '全部'
    end
    inherited Lbl_Order: TLabel
      Width = 114
      Caption = '供应商代码/物料代码'
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 384
    Height = 45
    inherited Image4: TImage
      Height = 45
    end
    object dbtxtVendorflag: TDBText
      Left = 96
      Top = 8
      Width = 90
      Height = 12
      AutoSize = True
      DataField = 'Vendorflag'
      DataSource = DataSource
      TransParent = True
    end
    object dbtxtItemflag: TDBText
      Left = 96
      Top = 24
      Width = 78
      Height = 12
      AutoSize = True
      DataField = 'Itemflag'
      DataSource = DataSource
      TransParent = True
    end
    object Label1: TLabel
      Left = 26
      Top = 24
      Width = 60
      Height = 12
      Caption = '物料标识：'
      TransParent = True
    end
    object Label2: TLabel
      Left = 14
      Top = 8
      Width = 72
      Height = 12
      Caption = '供应商标识：'
      TransParent = True
    end
  end
  inherited Pnl_Body: TPanel
    Height = 287
    inherited Image3: TImage
      Height = 287
    end
    inherited DBGridEh: TDBGridEh
      Height = 287
      FrozenCols = 4
      Columns = <
        Item
          FieldName = 'Vendorflag'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 200
          KeyList.Strings = ()
        end
        Item
          FieldName = 'VendorCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 69
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'VendorName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 154
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PcNo'
          PickList.Strings = ()
          Title.Caption = '价格单号'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'pcdate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 70
          KeyList.Strings = ()
        end
        Item
          Alignment = taLeftJustify
          FieldName = 'PcLineId'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 52
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Itemflag'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 200
          KeyList.Strings = ()
        end
        Item
          FieldName = 'UomName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '单位'
          Width = 38
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 72
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 236
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ReferencePricePass'
          PickList.Strings = (
            '未批准'
            '已批准')
          Width = 79
          KeyList.Strings = (
            '0'
            '1')
        end
        Item
          Alignment = taLeftJustify
          FieldName = 'PcTaxPrice'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '暂估含税价'
          Width = 65
          KeyList.Strings = ()
        end
        Item
          Alignment = taLeftJustify
          FieldName = 'PcNoTaxPrice'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '暂估未税价'
          Width = 65
          KeyList.Strings = ()
        end
        Item
          FieldName = 'FormalPricePass'
          PickList.Strings = (
            '未批准'
            '已批准')
          Width = 89
          KeyList.Strings = (
            '0'
            '1')
        end
        Item
          FieldName = 'PCTaxPrice_Formal'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PCNoTaxPrice_Formal'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PcStArtDate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 70
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PcendDate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 70
          KeyList.Strings = ()
        end
        Item
          Alignment = taLeftJustify
          FieldName = 'PcStArtQty'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 72
          KeyList.Strings = ()
        end
        Item
          Alignment = taLeftJustify
          FieldName = 'PcendQty'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 54
          KeyList.Strings = ()
        end
        Item
          Alignment = taLeftJustify
          FieldName = 'PcPriceType'
          PickList.Strings = (
            '采购'
            '委外')
          Title.Alignment = taCenter
          Width = 53
          KeyList.Strings = (
            '0'
            '1')
        end
        Item
          Alignment = taLeftJustify
          FieldName = 'PCTaxRate_Percent'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 32
          KeyList.Strings = ()
        end
        Item
          FieldName = 'currencyName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 56
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 237
    Top = 243
  end
  inherited ActionList: TActionList
    Left = 192
    Top = 160
  end
  inherited AdoQry_Main: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=Mrpii_Standard;Data Source=ExtDAT' +
      'ASERVER'
    CurSorType = ctStatic
    SQL.Strings = (
      'Select PcLine.*,'
      '       pc.pcdate,'
      '       Pc.VendorCode,'
      '       Item.ItemName,'
      '       Uom.UomName,'
      '       Vendor.VendorName,'
      '       Vendorflag=pc.VendorCode+'#39' '#39'+Vendor.VendorName,'
      '      Itemflag=pcline.ItemCode+'#39' '#39'+Item.ItemName,'
      '       Pc.PCTaxRate_Percent,'
      '       currency.currencyName,'
      '       Pc.PCStatus'
      'From PcLine '
      '   Join Item On PcLine.ItemCode=Item.ItemCode'
      '   Join Pc On PcLine.PcNo=Pc.PcNo '
      '   Left Join Vendor On Pc.VendorCode=Vendor.VendorCode'
      '   Left Outer Join Uom On Item.UomCode=Uom.UomCode'
      
        '   left outer join currency on pc.currencyCode=currency.currency' +
        'Code'
      
        'Order by Pc.VendorCode,PcLine.PcNo,PcLine.PcLineId,PcLine.ItemCo' +
        'de')
    Left = 368
    Top = 217
    object AdoQry_MainPcNo: TStringField
      DisplayLabel = '合同号'
      FieldName = 'PcNo'
      Origin = '#tmppcline'
      Size = 16
    end
    object AdoQry_MainPcLineId: TAutoIncField
      DisplayLabel = '合同行号'
      FieldName = 'PcLineId'
      Origin = '#tmppcline'
      ReadOnly = True
    end
    object AdoQry_MainItemCode: TStringField
      DisplayLabel = '物料代码'
      FieldName = 'ItemCode'
      Origin = '#tmppcline'
      Size = 16
    end
    object AdoQry_MainPcTaxPrice: TFloatField
      DisplayLabel = '含税价'
      FieldName = 'PcTaxPrice'
      Origin = '#tmppcline'
    end
    object AdoQry_MainPcNoTaxPrice: TFloatField
      DisplayLabel = '未税价'
      FieldName = 'PcNoTaxPrice'
      Origin = '#tmppcline'
    end
    object AdoQry_MainPcStArtDate: TDateTimeField
      DisplayLabel = '起始日期'
      FieldName = 'PcStArtDate'
      Origin = '#tmppcline'
    end
    object AdoQry_MainPcendDate: TDateTimeField
      DisplayLabel = '终止日期'
      FieldName = 'PcendDate'
      Origin = '#tmppcline'
    end
    object AdoQry_MainPcStArtQty: TFloatField
      DisplayLabel = '起始数量'
      FieldName = 'PcStArtQty'
      Origin = '#tmppcline'
    end
    object AdoQry_MainPcendQty: TFloatField
      DisplayLabel = '终止数量'
      FieldName = 'PcendQty'
      Origin = '#tmppcline'
    end
    object AdoQry_MainPcPriceType: TIntegerField
      DisplayLabel = '价格类型'
      FieldName = 'PcPriceType'
      Origin = '#tmppcline'
    end
    object AdoQry_MainPCReferencedPrice: TIntegerField
      DisplayLabel = '是否参考价'
      FieldName = 'PCReferencedPrice'
      Origin = '#tmppcline'
    end
    object AdoQry_MaInvendorCode: TStringField
      DisplayLabel = '供应商代码'
      FieldName = 'VendorCode'
      Origin = '#tmppcline'
      Size = 12
    end
    object AdoQry_MainItemName: TStringField
      DisplayLabel = '物料描述'
      FieldName = 'ItemName'
      Origin = '#tmppcline'
      Size = 60
    end
    object AdoQry_MainUomName: TStringField
      FieldName = 'UomName'
      Origin = '#tmppcline'
      Size = 10
    end
    object AdoQry_MaInvendorName: TStringField
      DisplayLabel = '供应商名称'
      FieldName = 'VendorName'
      Origin = '#tmppcline'
      Size = 60
    end
    object AdoQry_MainPCTaxRate_Percent: TIntegerField
      DisplayLabel = '税率'
      FieldName = 'PCTaxRate_Percent'
      Origin = '#tmppcline'
    end
    object AdoQry_MainPCStatus: TIntegerField
      DisplayLabel = '是否批准'
      FieldName = 'PCStatus'
      Origin = '#tmppcline'
    end
    object AdoQry_MaincurrencyName: TStringField
      DisplayLabel = '货币名称'
      FieldName = 'currencyName'
      Origin = '#tmppcline'
      Size = 30
    end
    object AdoQry_Mainpcdate: TDateTimeField
      DisplayLabel = '下单日期'
      FieldName = 'pcdate'
    end
    object AdoQry_MaInvendorflag: TStringField
      DisplayLabel = '供应商标识'
      FieldName = 'Vendorflag'
      ReadOnly = True
      Size = 73
    end
    object AdoQry_MainItemflag: TStringField
      DisplayLabel = '物料标识'
      FieldName = 'Itemflag'
      ReadOnly = True
      Size = 77
    end
    object AdoQry_Mainpclinestatus: TIntegerField
      DisplayLabel = '是否批准'
      FieldName = 'pclinestatus'
      Origin = '#tmppcline'
    end
    object AdoQry_Maintmpflag: TIntegerField
      FieldName = 'tmpflag'
    end
    object AdoQry_MainPCTaxPrice_Formal: TFloatField
      DisplayLabel = '正式含税价'
      FieldName = 'PCTaxPrice_Formal'
      Origin = 'PcLine'
    end
    object AdoQry_MainPCNoTaxPrice_Formal: TFloatField
      DisplayLabel = '正式未税价'
      FieldName = 'PCNoTaxPrice_Formal'
      Origin = 'PcLine'
    end
    object AdoQry_MainReferencePricePass: TIntegerField
      DisplayLabel = '暂估价批准否'
      FieldName = 'ReferencePricePass'
      Origin = 'PcLine'
    end
    object AdoQry_MainformalPricePass: TIntegerField
      DisplayLabel = '正式价批准否'
      FieldName = 'FormalPricePass'
      Origin = 'PcLine'
    end
  end
  inherited DataSource: TDataSource
    Top = 137
  end
end