pm_enter_autopo1.dfm

一个MRPII系统源代码版本

inherited Frm_Pm_Enter_AutoPo1: TFrm_Pm_Enter_AutoPo1
  Left = -1
  Top = 64
  Caption = '采购订单准备'
  ClientHeight = 418
  ClientWidth = 800
  Position = poMainformCenter
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 800
    inherited ToolBar: TToolBar
      inherited ToolButton7: TToolButton
        Visible = False
      end
    end
  end
  inherited Pnl_Title: TPanel
    Width = 800
    Caption = '采购订单准备'
  end
  inherited Pnl_Head: TPanel
    Width = 800
    Height = 80
    object Label1: TLabel
      Left = 5
      Top = 9
      Width = 60
      Height = 12
      Caption = '采购订单号'
    end
    object Label2: TLabel
      Left = 187
      Top = 8
      Width = 48
      Height = 12
      Caption = '下单日期'
    end
    object Label3: TLabel
      Left = 404
      Top = 8
      Width = 60
      Height = 12
      Caption = '采购合同号'
    end
    object Label4: TLabel
      Left = 5
      Top = 56
      Width = 60
      Height = 12
      Caption = '供应商代码'
    end
    object Label5: TLabel
      Left = 598
      Top = 7
      Width = 48
      Height = 12
      Caption = '订单类型'
    end
    object Label6: TLabel
      Left = 5
      Top = 33
      Width = 60
      Height = 12
      Caption = '采购员代码'
    end
    object Label7: TLabel
      Left = 410
      Top = 31
      Width = 48
      Height = 12
      Caption = '货币代码'
    end
    object Label9: TLabel
      Left = 594
      Top = 33
      Width = 84
      Height = 12
      Caption = '税率（百分比）'
    end
    object Label10: TLabel
      Left = 747
      Top = 33
      Width = 6
      Height = 12
      Caption = '%'
    end
    object Label11: TLabel
      Left = 571
      Top = 57
      Width = 30
      Height = 12
      Caption = '备 注'
    end
    object Label12: TLabel
      Left = 184
      Top = 32
      Width = 60
      Height = 12
      Caption = '采购员姓名'
    end
    object Label14: TLabel
      Left = 184
      Top = 56
      Width = 60
      Height = 12
      Caption = '供应商名称'
    end
    object Edt_PoNo: TEdit
      Left = 71
      Top = 3
      Width = 106
      Height = 20
      Enabled = False
      MaxLength = 16
      ReadOnly = True
      TabOrder = 0
    end
    object MEdt_PoDate: TMaskEdit
      Left = 250
      Top = 3
      Width = 143
      Height = 20
      EditMask = '!9999.99.99;1;'
      MaxLength = 10
      TabOrder = 1
      Text = '    .  .  '
      OnExit = DateCheck
    end
    object Edt_PcNo: TEdit
      Left = 471
      Top = 3
      Width = 116
      Height = 20
      MaxLength = 16
      TabOrder = 2
      OnExit = PcCodeCheck
      OnKeyDown = Edt_PcNoKeyDown
    end
    object Edt_VendorCode: TEdit
      Left = 70
      Top = 53
      Width = 106
      Height = 20
      Enabled = False
      ReadOnly = True
      TabOrder = 8
      OnExit = VendorCodeCheck
      OnKeyDown = VendorHint
    end
    object Cmbx_PoType: TComboBox
      Left = 655
      Top = 3
      Width = 96
      Height = 20
      Style = csDropDownList
      ItemHeight = 12
      TabOrder = 3
    end
    object Edt_EmployeeCode: TEdit
      Left = 71
      Top = 29
      Width = 106
      Height = 20
      MaxLength = 30
      TabOrder = 4
      OnExit = Edt_EmployeeCodeExit
      OnKeyDown = Vw_BuyerHint
    end
    object Edt_CurrencyCode: TEdit
      Left = 471
      Top = 29
      Width = 118
      Height = 20
      Enabled = False
      MaxLength = 2
      ReadOnly = True
      TabOrder = 6
      OnExit = CurrencyCodeCheck
      OnKeyDown = CurrencyHint
    end
    object Edt_Potax: TEdit
      Left = 677
      Top = 29
      Width = 61
      Height = 20
      Enabled = False
      ReadOnly = True
      TabOrder = 7
      OnExit = FloatCheck
    end
    object Edt_PoRemArk: TEdit
      Left = 608
      Top = 53
      Width = 160
      Height = 20
      MaxLength = 150
      TabOrder = 10
    end
    object Edt_BuyerName: TEdit
      Left = 249
      Top = 29
      Width = 145
      Height = 20
      ReadOnly = True
      TabOrder = 5
    end
    object Edt_VendorName: TEdit
      Left = 249
      Top = 53
      Width = 313
      Height = 20
      ReadOnly = True
      TabOrder = 9
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 392
    Width = 800
    object Label8: TLabel
      Left = 16
      Top = 8
      Width = 60
      Height = 12
      Caption = '订单行号：'
    end
    object Lbl_LineNo: TLabel
      Left = 80
      Top = 8
      Width = 6
      Height = 12
    end
    object Label13: TLabel
      Left = 232
      Top = 8
      Width = 60
      Height = 12
      Caption = '物料标识：'
    end
    object Lbl_ItemFlag: TLabel
      Left = 288
      Top = 8
      Width = 6
      Height = 12
    end
    object Label15: TLabel
      Left = 592
      Top = 8
      Width = 72
      Height = 12
      Caption = '约定交货量：'
    end
    object Lbl_PoQty: TLabel
      Left = 664
      Top = 8
      Width = 6
      Height = 12
    end
  end
  inherited Pnl_Body: TPanel
    Top = 137
    Width = 800
    Height = 255
    inherited DBGridEh: TDBGridEh
      Width = 800
      Height = 255
      Columns = <
        Item
          FieldName = 'PONO'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'POLINENo'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'POLineDATE'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'POQTY'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PONoFinishQty'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'POREFERENCEDPRICE'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'POLINESTATUS'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PoNoTaxPrice'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PONoTaxAmount'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PoTaxPrice'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PoTaxAmount'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'POStArtWorkDate'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'UomName'
          PickList.Strings = ()
          KeyList.Strings = ()
        end>
    end
    object DBGridEh1: TDBGridEh
      Left = 0
      Top = 0
      Width = 800
      Height = 255
      Align = alClient
      DataSource = DataSource
      ReadOnly = True
      TabOrder = 1
      TitleFont.ChArset = GB2312_CHArSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -12
      TitleFont.Name = '宋体'
      TitleFont.Style = []
      OnDblClick = Act_ModifyExecute
      FrozenCols = 5
      Columns = <
        Item
          FieldName = 'POLINENo'
          Title.Alignment = taCenter
          Title.Caption = '订单行号'
          Width = 55
        end
        Item
          FieldName = 'ItemCode'
          Title.Alignment = taCenter
          Title.Caption = '物料代码'
          Width = 125
        end
        Item
          FieldName = 'ItemName'
          Title.Alignment = taCenter
          Title.Caption = '物料描述'
          Width = 125
        end
        Item
          Alignment = taCenter
          FieldName = 'UomName'
          Title.Alignment = taCenter
          Title.Caption = '计量单位'
          Width = 55
        end
        Item
          FieldName = 'POLINESTATUS'
          PickList.Strings = (
            '1 系统建议'
            '5 准备'
            '6 下达'
            '7 关闭'
            '8 已结算')
          Title.Alignment = taCenter
          Title.Caption = '行状态'
          Width = 45
          KeyList.Strings = (
            '1'
            '5'
            '6'
            '7'
            '8')
        end
        Item
          FieldName = 'POQTY'
          Title.Alignment = taCenter
          Title.Caption = '约定交货量'
          Width = 70
        end
        Item
          FieldName = 'PONoFinishQty'
          Title.Alignment = taCenter
          Title.Caption = '未结量'
          Width = 70
        end
        Item
          FieldName = 'PoTaxPrice'
          Title.Alignment = taCenter
          Title.Caption = '含税价'
          Width = 65
          Visible = False
        end
        Item
          FieldName = 'PoTaxAmount'
          Title.Alignment = taCenter
          Title.Caption = '含税金额'
          Width = 70
          Visible = False
        end
        Item
          FieldName = 'PoNoTaxPrice'
          Title.Alignment = taCenter
          Title.Caption = '未税价'
          Width = 65
          Visible = False
        end
        Item
          FieldName = 'PONoTaxAmount'
          Title.Alignment = taCenter
          Title.Caption = '未税金额'
          Width = 70
          Visible = False
        end
        Item
          Alignment = tArightJustify
          FieldName = 'POStArtWorkDate'
          Title.Alignment = taCenter
          Title.Caption = '约定开工日'
          Width = 70
        end
        Item
          Alignment = tArightJustify
          FieldName = 'POLineDATE'
          Title.Alignment = taCenter
          Title.Caption = '约定交货日'
          Width = 70
        end
        Item
          FieldName = 'POREFERENCEDPRICE'
          PickList.Strings = (
            ' '
            '是')
          Title.Alignment = taCenter
          Title.Caption = '是否参考价'
          KeyList.Strings = (
            '0'
            '1')
        end>
    end
  end
  inherited ActionList: TActionList
    Top = 192
    inherited Act_InsertLine: TAction
      Enabled = False
      Visible = False
    end
    inherited Act_Excel: TAction
      OnExecute = Act_ExcelExecute
    end
  end
  inherited AdoQry_Body: TAdoQuery
    ConnectionString = ''
    SQL.Strings = (
      
        'select Top 0 Poline.*,Item.ItemName,Uom.UomName from Poline join' +
        ' Item '
      
        'on Poline.ItemCode=Item.ItemCode join Uom on Item.UomCode=Uom.uo' +
        'mCode')
    object AdoQry_BodyPONO: TStringField
      FieldName = 'PONO'
      Size = 16
    end
    object AdoQry_BodyPOLINENo: TIntegerField
      FieldName = 'POLINENo'
      Origin = 'PoLine'
    end
    object AdoQry_BodyItemCode: TStringField
      FieldName = 'ItemCode'
      Origin = 'PoLine'
      Size = 16
    end
    object AdoQry_BodyPOLineDATE: TDateTimeField
      FieldName = 'POLineDATE'
      Origin = 'PoLine'
      DisplayFormat = 'yyyy.mm.dd'
    end
    object AdoQry_BodyPOQTY: TFloatField
      FieldName = 'POQTY'
      Origin = 'PoLine'
      DisplayFormat = '#,##0.##'
    end
    object AdoQry_BodyPONoFinishQty: TFloatField
      FieldName = 'PONoFinishQty'
      Origin = 'PoLine'
      DisplayFormat = '#,##0.##'
    end
    object AdoQry_BodyPOREFERENCEDPRICE: TIntegerField
      FieldName = 'POREFERENCEDPRICE'
      Origin = 'PoLine'
    end
    object AdoQry_BodyPOLINESTATUS: TIntegerField
      FieldName = 'POLINESTATUS'
      Origin = 'PoLine'
    end
    object AdoQry_BodyPoNoTaxPrice: TFloatField
      FieldName = 'PoNoTaxPrice'
      Origin = 'PoLine'
      DisplayFormat = '#,##0.00'
    end
    object AdoQry_BodyPONoTaxAmount: TBCDField
      FieldName = 'PONoTaxAmount'
      Origin = 'PoLine'
      DisplayFormat = '#,##0.00'
      Precision = 18
      Size = 2
    end
    object AdoQry_BodyPoTaxPrice: TFloatField
      FieldName = 'PoTaxPrice'
      Origin = 'PoLine'
      DisplayFormat = '#,##0.00'
    end
    object AdoQry_BodyPoTaxAmount: TBCDField
      FieldName = 'PoTaxAmount'
      Origin = 'PoLine'
      DisplayFormat = '#,##0.00'
      Precision = 18
      Size = 2
    end
    object AdoQry_BodyPOStArtWorkDate: TDateTimeField
      FieldName = 'POStArtWorkDate'
      Origin = 'PoLine'
      DisplayFormat = 'yyyy.mm.dd'
    end
    object AdoQry_BodyItemName: TStringField
      FieldName = 'ItemName'
      Origin = 'Item'
      Size = 60
    end
    object AdoQry_BodyUomName: TStringField
      FieldName = 'UomName'
      Origin = 'Uom'
      Size = 10
    end
    object AdoQry_BodySsQty: TFloatField
      FieldName = 'SsQty'
      Origin = 'PoLine'
    end
    object AdoQry_BodyLimItOut: TIntegerField
      FieldName = 'LimItOut'
    end
  end
  inherited DataSource: TDataSource
    OnDataChange = DataSourceDataChange
    Left = 512
    Top = 217
  end
  object AdoQry_Head1: TAdoQuery
    Parameters = <>
    Left = 250
    Top = 246
  end
  object AdoQry_Temp: TAdoQuery
    Parameters = <>
    Left = 136
    Top = 239
  end
end