mrp_enter_automo.dfm

一个MRPII系统源代码版本

inherited Frm_Mrp_Enter_AutoMo: TFrm_Mrp_Enter_AutoMo
  Left = 48
  Top = 82
  Caption = '生产订单准备'
  ClientHeight = 463
  ClientWidth = 722
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 722
    inherited ToolBar: TToolBar
      inherited TlBtn_InsertLine: TToolButton
        Hint = '主生产计划'
        Caption = '主生产计划'
      end
    end
  end
  inherited Pnl_Title: TPanel
    Width = 722
    Caption = '生产订单准备'
    inherited Image2: TImage
      Width = 722
    end
  end
  inherited Pnl_Head: TPanel
    Width = 722
    Height = 69
    inherited Image1: TImage
      Width = 722
      Height = 69
    end
    object Label1: TLabel
      Left = 5
      Top = 16
      Width = 66
      Height = 12
      Caption = '生产订单号:'
      TransParent = True
    end
    object Label2: TLabel
      Left = 178
      Top = 16
      Width = 78
      Height = 12
      Caption = '受单部门代码:'
      TransParent = True
    end
    object Label3: TLabel
      Left = 7
      Top = 48
      Width = 54
      Height = 12
      Caption = '下单日期:'
      TransParent = True
    end
    object Label4: TLabel
      Left = 545
      Top = 46
      Width = 30
      Height = 12
      Caption = '备注:'
      TransParent = True
    end
    object Label5: TLabel
      Left = 175
      Top = 48
      Width = 78
      Height = 12
      Caption = '销售类型代码:'
      TransParent = True
    end
    object Label6: TLabel
      Left = 362
      Top = 46
      Width = 78
      Height = 12
      Caption = '销售类型描述:'
      TransParent = True
    end
    object Lbl_SaleType: TLabel
      Left = 231
      Top = 54
      Width = 6
      Height = 12
      Visible = False
    end
    object Lbl_DeptName: TLabel
      Left = 475
      Top = 13
      Width = 6
      Height = 12
      Visible = False
    end
    object Label8: TLabel
      Left = 359
      Top = 14
      Width = 78
      Height = 12
      Caption = '受单部门名称:'
      TransParent = True
    end
    object Label11: TLabel
      Left = 615
      Top = 12
      Width = 54
      Height = 12
      Caption = '标准任务:'
      TransParent = True
    end
    object Edt_MoNo: TEdit
      Left = 74
      Top = 10
      Width = 95
      Height = 20
      MaxLength = 16
      ReadOnly = True
      TabOrder = 0
    end
    object Medt_Modate: TMaskEdit
      Left = 73
      Top = 42
      Width = 96
      Height = 20
      EditMask = '!9999.99.99;1;'
      MaxLength = 10
      TabOrder = 4
      Text = '    .  .  '
      OnExit = DateCheck
    end
    object Edt_MoRemArk: TEdit
      Left = 584
      Top = 40
      Width = 127
      Height = 20
      MaxLength = 150
      TabOrder = 7
    end
    object Edt_SysParamValuec: TEdit
      Left = 443
      Top = 40
      Width = 99
      Height = 20
      ReadOnly = True
      TabOrder = 6
    end
    object Edt_SysParamCode: TExtEdit
      Left = 257
      Top = 42
      Width = 97
      Height = 20
      TabOrder = 5
      OnExit = Edt_SysParamCodeExit
      OnKeyDown = Edt_SysParamCodeKeyDown
      DispLabel = Lbl_SaleType
    end
    object Edt_DeptCode: TExtEdit
      Left = 258
      Top = 10
      Width = 97
      Height = 20
      TabOrder = 1
      OnExit = Edt_DeptCodeExit
      OnKeyDown = DeptHint
      DispLabel = Lbl_DeptName
    end
    object Edt_DeptName: TEdit
      Left = 442
      Top = 8
      Width = 171
      Height = 20
      TabOrder = 2
    end
    object Cmbx_StandardFlag: TComboBox
      Left = 672
      Top = 7
      Width = 47
      Height = 22
      Style = csOwnerDrawFixed
      ItemHeight = 16
      TabOrder = 3
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 437
    Width = 722
    inherited Image4: TImage
      Width = 722
    end
    object Label7: TLabel
      Left = 16
      Top = 8
      Width = 60
      Height = 12
      Caption = '物料标识：'
    end
    object Lbl_ItemFlag: TLabel
      Left = 80
      Top = 8
      Width = 6
      Height = 12
    end
    object Label9: TLabel
      Left = 435
      Top = 8
      Width = 72
      Height = 12
      Caption = '约定交货量：'
    end
    object DBText1: TDBText
      Left = 507
      Top = 8
      Width = 42
      Height = 12
      AutoSize = True
      DataField = 'MOQTY'
      DataSource = DataSource
    end
    object Label10: TLabel
      Left = 592
      Top = 8
      Width = 72
      Height = 12
      Caption = '约定交货日：'
    end
    object DBText2: TDBText
      Left = 664
      Top = 8
      Width = 42
      Height = 12
      AutoSize = True
      DataField = 'MoLineDATE'
      DataSource = DataSource
    end
  end
  inherited Pnl_Body: TPanel
    Top = 126
    Width = 722
    Height = 311
    inherited Image3: TImage
      Width = 722
      Height = 311
    end
    inherited DBGridEh: TDBGridEh
      Width = 722
      Height = 311
      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 = 722
      Height = 311
      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 = 55
        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 = 55
        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 = (
            ''
            '是')
          KeyList.Strings = (
            '0'
            '1')
        end
        Item
          FieldName = 'BackFlush'
          PickList.Strings = (
            ''
            '是')
          Width = 81
          KeyList.Strings = (
            '0'
            '1')
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 413
    Top = 227
  end
  inherited ActionList: TActionList
    inherited Act_InsertLine: TAction
      Enabled = False
      Visible = False
    end
    inherited Act_Look: TAction
      Caption = '反查主生产计划'
      Hint = '反查主生产计划'
    end
    inherited Act_Excel: TAction
      OnExecute = Act_ExcelExecute
    end
  end
  inherited AdoQry_Body: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=mdrcmrm_B;Data Source=192.168.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
  end
  inherited DataSource: TDataSource
    OnDataChange = DataSourceDataChange
    Left = 376
    Top = 177
  end
  object AdoQry_Head1: TAdoQuery
    CacheSize = 500
    Parameters = <>
    Left = 466
    Top = 270
  end
  object AdoQry_Temp: TAdoQuery
    Parameters = <>
    Left = 328
    Top = 230
  end
end