mrp_qry_uprightmrp_d_po.dfm

一个MRPII系统源代码版本

inherited Frm_Mrp_Qry_UpRightMrp_D_Po: TFrm_Mrp_Qry_UpRightMrp_D_Po
  Left = 57
  Top = 90
  Caption = '采购订单对应表'
  ClientWidth = 720
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 720
    inherited ToolBar: TToolBar
      inherited TlBtn_Filter: TToolButton
        Visible = False
      end
      inherited TlBtn_Locate: TToolButton
        Visible = False
      end
      inherited TlBtn_Order: TToolButton
        Visible = False
      end
      inherited TlBtn_SetColumn: TToolButton
        Visible = False
      end
    end
  end
  inherited Pnl_Title: TPanel
    Width = 720
    Caption = '采购订单对应表'
  end
  inherited Pnl_Head: TPanel
    Width = 720
    Height = 64
    inherited Lbl_OrderTitle: TLabel
      Left = 9
      Top = 60
      Visible = False
    end
    inherited Lbl_ConditionTitle: TLabel
      Left = 1
      Top = 53
      Visible = False
    end
    inherited Lbl_Order: TLabel
      Left = 61
      Top = 52
      Visible = False
    end
    object Label1: TLabel
      Left = 5
      Top = 4
      Width = 60
      Height = 12
      Caption = '采购订单号'
    end
    object Label2: TLabel
      Left = 155
      Top = 4
      Width = 48
      Height = 12
      Caption = '下单日期'
    end
    object Label3: TLabel
      Left = 280
      Top = 6
      Width = 60
      Height = 12
      Caption = '采购合同号'
    end
    object Label4: TLabel
      Left = 450
      Top = 6
      Width = 60
      Height = 12
      Caption = '供应商代码'
    end
    object Label5: TLabel
      Left = 625
      Top = 6
      Width = 48
      Height = 12
      Caption = '订单类型'
    end
    object Label11: TLabel
      Left = 455
      Top = 35
      Width = 24
      Height = 12
      Caption = '备注'
    end
    object Label10: TLabel
      Left = 432
      Top = 35
      Width = 6
      Height = 12
      Caption = '%'
    end
    object Label9: TLabel
      Left = 282
      Top = 35
      Width = 84
      Height = 12
      Caption = '税率（百分比）'
    end
    object Label7: TLabel
      Left = 155
      Top = 35
      Width = 48
      Height = 12
      Caption = '货币代码'
    end
    object Label6: TLabel
      Left = 5
      Top = 34
      Width = 60
      Height = 12
      Caption = '采购员代码'
    end
    object Edt_PoNo: TEdit
      Left = 70
      Top = 1
      Width = 81
      Height = 20
      Enabled = False
      MaxLength = 16
      TabOrder = 0
    end
    object MEdt_PoDate: TMaskEdit
      Left = 205
      Top = 1
      Width = 71
      Height = 20
      Enabled = False
      EditMask = '!9999.99.99;1;'
      MaxLength = 10
      TabOrder = 1
      Text = '    .  .  '
    end
    object Edt_PcNo: TEdit
      Left = 345
      Top = 1
      Width = 96
      Height = 20
      Enabled = False
      MaxLength = 16
      TabOrder = 2
    end
    object Edt_VendorCode: TEdit
      Left = 510
      Top = 1
      Width = 106
      Height = 20
      Enabled = False
      ReadOnly = True
      TabOrder = 3
    end
    object Cmbx_PoType: TComboBox
      Left = 678
      Top = 1
      Width = 96
      Height = 20
      Style = csDropDownList
      Enabled = False
      ItemHeight = 12
      TabOrder = 4
      Items.Strings = (
        '0 普通采购'
        '1 委外加工')
    end
    object Edt_PoRemArk: TEdit
      Left = 488
      Top = 27
      Width = 286
      Height = 20
      Enabled = False
      MaxLength = 150
      ReadOnly = True
      TabOrder = 5
    end
    object Edt_Potax: TEdit
      Left = 367
      Top = 27
      Width = 61
      Height = 20
      Enabled = False
      ReadOnly = True
      TabOrder = 6
    end
    object Edt_CurrencyCode: TEdit
      Left = 205
      Top = 27
      Width = 71
      Height = 20
      Enabled = False
      MaxLength = 2
      ReadOnly = True
      TabOrder = 7
    end
    object Edt_EmployeeCode: TEdit
      Left = 70
      Top = 27
      Width = 81
      Height = 20
      Enabled = False
      MaxLength = 30
      TabOrder = 8
    end
  end
  inherited Pnl_Hint: TPanel
    Width = 720
  end
  inherited Pnl_Body: TPanel
    Top = 121
    Width = 720
    Height = 282
    inherited DBGridEh: TDBGridEh
      Width = 720
      Height = 282
      FrozenCols = 4
      Columns = <
        Item
          FieldName = 'POLINENo'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          Width = 213
          KeyList.Strings = ()
        end
        Item
          FieldName = 'UomName'
          PickList.Strings = ()
          Title.Caption = '单位'
          Width = 32
          KeyList.Strings = ()
        end
        Item
          FieldName = 'POLINESTATUS'
          PickList.Strings = (
            '5 准备'
            '6 下达'
            '7 关闭')
          Width = 55
          KeyList.Strings = (
            '5'
            '6'
            '7')
        end
        Item
          FieldName = 'POQTY'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PONoFinishQty'
          PickList.Strings = ()
          Width = 45
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PoTaxPrice'
          PickList.Strings = ()
          Width = 46
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PoTaxAmount'
          PickList.Strings = ()
          Width = 66
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PoNoTaxPrice'
          PickList.Strings = ()
          Width = 46
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PONoTaxAmount'
          PickList.Strings = ()
          Width = 60
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'POStArtWorkDate'
          PickList.Strings = ()
          Width = 69
          KeyList.Strings = ()
        end
        Item
          FieldName = 'POLineDATE'
          PickList.Strings = ()
          Width = 68
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 213
    Top = 171
  end
  inherited ActionList: TActionList
    Left = 184
    Top = 200
  end
  inherited AdoQry_Main: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=mdrcmrm;Data Source=NT2;Use Proc' +
      'edure for Prepare=1;Auto Translate=True;Packet Size=4096;Worksta' +
      'tion ID=XYB'
    CurSorType = ctStatic
    AfterScroll = AdoQry_MainAfterScroll
    SQL.Strings = (
      'Select po.VendorCode,po.poType,po.podate,po.potaxrate_Percent,'
      '       po.currencyCode,po.EmployeeCode,po.pcno,po.poremArk,'
      '      PoLine.*,Item.ItemName,Uom.UomName '
      '      From PoLine'
      '      join po on po.pono=poline.pono'
      '      Left Outer Join Item On PoLine.ItemCode=Item.ItemCode'
      '      Left Outer Join Uom On Item.UomCode=Uom.UomCode')
    Left = 304
    Top = 169
    object AdoQry_MaInvendorCode: TStringField
      FieldName = 'VendorCode'
      Size = 12
    end
    object AdoQry_MainpoType: TIntegerField
      FieldName = 'poType'
    end
    object AdoQry_Mainpodate: TDateTimeField
      FieldName = 'podate'
    end
    object AdoQry_Mainpotaxrate_Percent: TIntegerField
      FieldName = 'potaxrate_Percent'
    end
    object AdoQry_MaincurrencyCode: TStringField
      FieldName = 'currencyCode'
      Size = 2
    end
    object AdoQry_MainEmployeeCode: TStringField
      FieldName = 'EmployeeCode'
      Size = 30
    end
    object AdoQry_MainporemArk: TStringField
      FieldName = 'poremArk'
      Size = 150
    end
    object AdoQry_MainPONO: TStringField
      FieldName = 'PONO'
      Size = 16
    end
    object AdoQry_MainPOLINENo: TIntegerField
      DisplayLabel = '订单行号'
      FieldName = 'POLINENo'
    end
    object AdoQry_MainItemCode: TStringField
      DisplayLabel = '物料代码'
      FieldName = 'ItemCode'
      Size = 16
    end
    object AdoQry_MainPOLineDATE: TDateTimeField
      DisplayLabel = '约定交货日'
      FieldName = 'POLineDATE'
    end
    object AdoQry_MainPOQTY: TFloatField
      DisplayLabel = '约定交货量'
      FieldName = 'POQTY'
    end
    object AdoQry_MainPONoFinishQty: TFloatField
      DisplayLabel = '未结量'
      FieldName = 'PONoFinishQty'
    end
    object AdoQry_MainPOREFERENCEDPRICE: TIntegerField
      FieldName = 'POREFERENCEDPRICE'
    end
    object AdoQry_MainPOLINESTATUS: TIntegerField
      DisplayLabel = '行状态'
      FieldName = 'POLINESTATUS'
    end
    object AdoQry_MainPoNoTaxPrice: TFloatField
      DisplayLabel = '未税价'
      FieldName = 'PoNoTaxPrice'
    end
    object AdoQry_MainPONoTaxAmount: TBCDField
      DisplayLabel = '未税金额'
      FieldName = 'PONoTaxAmount'
      Precision = 18
      Size = 2
    end
    object AdoQry_MainPoTaxPrice: TFloatField
      DisplayLabel = '含税价'
      FieldName = 'PoTaxPrice'
    end
    object AdoQry_MainPoTaxAmount: TBCDField
      DisplayLabel = '含税金额'
      FieldName = 'PoTaxAmount'
      Precision = 18
      Size = 2
    end
    object AdoQry_MainPOStArtWorkDate: TDateTimeField
      DisplayLabel = '约定开工日'
      FieldName = 'POStArtWorkDate'
    end
    object AdoQry_MainPoRealInQty: TFloatField
      FieldName = 'PoRealInQty'
    end
    object AdoQry_MainPoInQty: TFloatField
      FieldName = 'PoInQty'
    end
    object AdoQry_MainItemName: TStringField
      DisplayLabel = '物料描述'
      FieldName = 'ItemName'
      Size = 60
    end
    object AdoQry_MainUomName: TStringField
      DisplayLabel = '计量单位'
      FieldName = 'UomName'
      Size = 10
    end
    object AdoQry_Mainpcno: TStringField
      FieldName = 'pcno'
      Size = 16
    end
  end
  inherited DataSource: TDataSource
    Top = 169
  end
  inherited PopuPmenu: TPopuPmenu
    Left = 248
    Top = 225
  end
end