mrp_enter_newautomo.dfm

一个MRPII系统源代码版本

inherited Frm_Mrp_Enter_NewAutoMo: TFrm_Mrp_Enter_NewAutoMo
  Left = 31
  Top = 66
  Caption = '生产订单准备'
  ClientHeight = 485
  ClientWidth = 785
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 785
  end
  inherited Pnl_Title: TPanel
    Width = 785
    Caption = '生产订单准备'
    inherited Image2: TImage
      Width = 785
    end
  end
  inherited Pnl_Head: TPanel
    Width = 785
    Height = 82
    inherited Image1: TImage
      Width = 785
      Height = 82
    end
    object Label1: TLabel
      Left = 18
      Top = 16
      Width = 66
      Height = 12
      Caption = '生产订单号:'
      TransParent = True
    end
    object Label2: TLabel
      Left = 29
      Top = 38
      Width = 54
      Height = 12
      Caption = '受单部门:'
      TransParent = True
    end
    object Label3: TLabel
      Left = 201
      Top = 16
      Width = 54
      Height = 12
      Caption = '下单日期:'
      TransParent = True
    end
    object Label4: TLabel
      Left = 52
      Top = 62
      Width = 30
      Height = 12
      Caption = '备注:'
      TransParent = True
    end
    object Label5: TLabel
      Left = 646
      Top = 40
      Width = 54
      Height = 12
      Caption = '销售类型:'
      TransParent = True
      Visible = False
    end
    object Lbl_SaleType: TLabel
      Left = 271
      Top = 54
      Width = 6
      Height = 12
      TransParent = True
      Visible = False
    end
    object Lbl_DeptName: TLabel
      Left = 475
      Top = 13
      Width = 6
      Height = 12
      TransParent = True
      Visible = False
    end
    object Label11: TLabel
      Left = 356
      Top = 12
      Width = 54
      Height = 12
      Caption = '标准任务:'
      TransParent = True
    end
    object Label6: TLabel
      Left = 369
      Top = 39
      Width = 42
      Height = 12
      Caption = '参考号:'
      TransParent = True
    end
    object Edt_MoNo: TEdit
      Left = 87
      Top = 10
      Width = 72
      Height = 20
      MaxLength = 16
      TabOrder = 0
    end
    object Medt_Modate: TMaskEdit
      Left = 257
      Top = 10
      Width = 72
      Height = 20
      EditMask = '!9999.99.99;1;'
      MaxLength = 10
      TabOrder = 1
      Text = '    .  .  '
      OnExit = DateCheck
    end
    object Edt_MoRemArk: TEdit
      Left = 87
      Top = 56
      Width = 524
      Height = 20
      MaxLength = 150
      TabOrder = 6
    end
    object Edt_SysParamValuec: TEdit
      Left = 635
      Top = 58
      Width = 147
      Height = 20
      ReadOnly = True
      TabOrder = 8
      Visible = False
    end
    object Edt_DeptName: TEdit
      Left = 140
      Top = 33
      Width = 189
      Height = 20
      TabOrder = 4
    end
    object Cmbx_StandardFlag: TComboBox
      Left = 413
      Top = 7
      Width = 63
      Height = 22
      Style = csOwnerDrawFixed
      ItemHeight = 16
      TabOrder = 2
    end
    object edt_DeptCode: TLinkEdit
      Left = 87
      Top = 33
      Width = 50
      Height = 20
      LinkStyle = lsEllipsis
      TabOrder = 3
      OnButtonClick = DeptHint1
      OnExit = Edt_DeptCodeExit
      OnKeyDown = DeptHint
    end
    object edt_SysParamCode: TLinkEdit
      Left = 712
      Top = 34
      Width = 50
      Height = 20
      LinkStyle = lsEllipsis
      TabOrder = 7
      Visible = False
      OnButtonClick = edt_SysParamCodeButtonClick
      OnExit = Edt_SysParamCodeExit
      OnKeyDown = Edt_SysParamCodeKeyDown
    end
    object edt_rno: TEdit
      Left = 413
      Top = 32
      Width = 87
      Height = 20
      TabOrder = 5
    end
  end
  inherited Pnl_Hint: TPanel
    Width = 785
    Height = 43
    inherited Image4: TImage
      Width = 785
      Height = 43
    end
    object Label7: TLabel
      Left = 16
      Top = 8
      Width = 60
      Height = 12
      Caption = '物料标识：'
      TransParent = True
    end
    object Lbl_ItemFlag: TLabel
      Left = 80
      Top = 8
      Width = 6
      Height = 12
      TransParent = True
    end
    object Label9: TLabel
      Left = 435
      Top = 8
      Width = 72
      Height = 12
      Caption = '约定交货量：'
      TransParent = True
    end
    object DBText1: TDBText
      Left = 507
      Top = 8
      Width = 42
      Height = 12
      AutoSize = True
      DataField = 'MOQTY'
      DataSource = DataSource
      TransParent = True
    end
    object Label10: TLabel
      Left = 592
      Top = 8
      Width = 72
      Height = 12
      Caption = '约定交货日：'
      TransParent = True
    end
    object DBText2: TDBText
      Left = 664
      Top = 8
      Width = 42
      Height = 12
      AutoSize = True
      DataField = 'MoLineDATE'
      DataSource = DataSource
      TransParent = True
    end
  end
  inherited Pnl_Body: TPanel
    Top = 139
    Width = 785
    Height = 303
    inherited Image3: TImage
      Width = 785
      Height = 303
    end
    inherited DBGridEh: TDBGridEh
      Width = 785
      Height = 303
      Columns = <
        Item
          FieldName = 'MONO'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MoLineNO'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MOQTY'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MoLineDATE'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MoNoFinishQTY'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MoLineSTATUS'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MOStArtWorkDate'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MOMNQty'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'UomCode'
          PickList.Strings = ()
          KeyList.Strings = ()
        end>
    end
    object DBGridEh1: TDBGridEh
      Left = 0
      Top = 0
      Width = 785
      Height = 303
      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 = 4
      UseMultiTitle = True
      Columns = <
        Item
          Alignment = taCenter
          FieldName = 'MoLineNO'
          Title.Alignment = taCenter
          Title.Caption = '订单行号'
          Width = 30
        end
        Item
          FieldName = 'ItemCode'
          Title.Alignment = taCenter
          Title.Caption = '物料代码'
          Width = 125
        end
        Item
          FieldName = 'ItemName'
          Title.Alignment = taCenter
          Title.Caption = '物料描述'
          Width = 250
        end
        Item
          Alignment = taCenter
          FieldName = 'UomName'
          Title.Alignment = taCenter
          Title.Caption = '计量单位'
          Width = 30
        end
        Item
          FieldName = 'MOQTY'
          Title.Alignment = taCenter
          Title.Caption = '约定交货量'
          Width = 70
        end
        Item
          FieldName = 'MoNoFinishQTY'
          Title.Alignment = taCenter
          Title.Caption = '未结量'
          Width = 70
        end
        Item
          FieldName = 'MoLineSTATUS'
          PickList.Strings = (
            '1 系统建议'
            '5 准备'
            '6 下达'
            '7 关闭'
            '8 永久性关闭')
          Title.Alignment = taCenter
          Title.Caption = '行状态'
          Width = 45
          KeyList.Strings = (
            '1'
            '5'
            '6'
            '7'
            '8')
        end
        Item
          Alignment = tArightJustify
          FieldName = 'MOStArtWorkDate'
          Title.Alignment = taCenter
          Title.Caption = '约定开工日'
          Width = 70
        end
        Item
          Alignment = tArightJustify
          FieldName = 'MoLineDATE'
          Title.Alignment = taCenter
          Title.Caption = '约定交货日'
          Width = 70
        end
        Item
          FieldName = 'ByProduct'
          PickList.Strings = (
            ''
            '是')
          Width = 52
          KeyList.Strings = (
            '0'
            '1')
        end
        Item
          FieldName = 'BackFlush'
          PickList.Strings = (
            ''
            '是')
          Width = 65
          KeyList.Strings = (
            '0'
            '1')
        end
        Item
          FieldName = 'RemArk'
          Width = 147
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 413
    Top = 227
  end
  inherited ActionList: TActionList
    inherited Act_Look: TAction
      Caption = '反查主生产计划'
      Hint = '反查主生产计划'
    end
  end
  inherited AdoQry_Body: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=Mrpii_Standard;Data Source=192.1' +
      '68.0.151'
    SQL.Strings = (
      
        'select Top 0 MoLine.*,Item.ItemName,Uom.UomName from MoLine join' +
        ' Item '
      
        'on MoLine.ItemCode=Item.ItemCode join Uom on Item.UomCode=Uom.uo' +
        'mCode')
    Left = 224
    Top = 265
    object AdoQry_BodyMONO: TStringField
      FieldName = 'MONO'
      Origin = 'MoLine'
      Size = 16
    end
    object AdoQry_BodyMoLineNO: TIntegerField
      FieldName = 'MoLineNO'
      Origin = 'MoLine'
    end
    object AdoQry_BodyItemCode: TStringField
      FieldName = 'ItemCode'
      Origin = 'MoLine'
      Size = 16
    end
    object AdoQry_BodyMOQTY: TFloatField
      DisplayWidth = 14
      FieldName = 'MOQTY'
      Origin = 'MoLine'
    end
    object AdoQry_BodyMoLineDATE: TDateTimeField
      FieldName = 'MoLineDATE'
      Origin = 'MoLine'
      DisplayFormat = 'yyyy.mm.dd'
    end
    object AdoQry_BodyMoNoFinishQTY: TFloatField
      DisplayWidth = 14
      FieldName = 'MoNoFinishQTY'
      Origin = 'MoLine'
    end
    object AdoQry_BodyMoLineSTATUS: TIntegerField
      FieldName = 'MoLineSTATUS'
      Origin = 'MoLine'
    end
    object AdoQry_BodyMOStArtWorkDate: TDateTimeField
      FieldName = 'MOStArtWorkDate'
      Origin = 'MoLine'
      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'
    end
    object AdoQry_BodyLimItOut: TIntegerField
      FieldName = 'LimItOut'
    end
    object AdoQry_BodyByProduct: TIntegerField
      DisplayLabel = '是否副产品'
      FieldName = 'ByProduct'
    end
    object AdoQry_BodyParentMoLineNo: TIntegerField
      FieldName = 'ParentMoLineNo'
    end
    object AdoQry_BodyBackFlush: TIntegerField
      DisplayLabel = '是否拉式领料'
      FieldName = 'BackFlush'
    end
    object AdoQry_BodyMoInQty: TFloatField
      FieldName = 'MoInQty'
    end
    object AdoQry_BodyRemArk: TStringField
      DisplayLabel = '备注'
      FieldName = 'RemArk'
      Size = 30
    end
  end
  inherited DataSource: TDataSource
    OnDataChange = DataSourceDataChange
    Left = 376
    Top = 177
  end
  object AdoQry_Head1: TAdoQuery
    CacheSize = 500
    Parameters = <>
    Left = 50
    Top = 270
  end
  object AdoQry_Temp: TAdoQuery
    Parameters = <>
    Left = 328
    Top = 230
  end
end