sfc_enter_mounitmnrequesth.dfm

一个MRPII系统源代码版本

inherited Frm_Sfc_Enter_MoUnitMnRequestH: TFrm_Sfc_Enter_MoUnitMnRequestH
  Left = 5
  Top = 38
  Caption = 'MO合并领料制单'
  ClientHeight = 553
  ClientWidth = 800
  Position = poDefault
  Windowstate = wsMaximized
  OnDestroy = FormDestroy
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 800
  end
  inherited Pnl_Title: TPanel
    Width = 800
    Caption = 'MO合并领料制单'
    inherited Image2: TImage
      Width = 800
    end
  end
  inherited Pnl_Head: TPanel
    Width = 800
    inherited Image1: TImage
      Width = 800
    end
    inherited Lbl_Condition: TLabel
      Width = 24
      Caption = '全部'
    end
    inherited Lbl_Order: TLabel
      Width = 174
      Caption = '受单部门/物料代码/订单号/行号'
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 514
    Width = 800
    Height = 39
    inherited Image4: TImage
      Width = 800
      Height = 39
    end
    object Label1: TLabel
      Left = 24
      Top = 16
      Width = 60
      Height = 12
      Caption = '物料描述：'
    end
    object DBText1: TDBText
      Left = 88
      Top = 14
      Width = 42
      Height = 12
      AutoSize = True
      DataField = 'ItemName'
      DataSource = DataSource
    end
  end
  inherited Pnl_Body: TPanel
    Width = 800
    Height = 417
    inherited Image3: TImage
      Width = 800
      Height = 417
    end
    inherited DBGridEh: TDBGridEh
      Width = 800
      Height = 417
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      ReadOnly = False
      OnKeyDown = DBGridEhKeyDown
      OnTitleClick = DBGridEhTitleClick
      FrozenCols = 3
      Columns = <
        Item
          FieldName = 'CheckFlag'
          Font.ChArset = GB2312_CHArSET
          Font.Color = clBtnFace
          Font.Height = -12
          Font.Name = '宋体'
          Font.Style = []
          PickList.Strings = (
            '1'
            '0')
          Title.Caption = '标记'
          Title.Font.ChArset = GB2312_CHArSET
          Title.Font.Color = clBlack
          Title.Font.Height = -12
          Title.Font.Name = '宋体'
          Title.Font.Style = []
          Width = 30
          KeyList.Strings = (
            '1'
            '0')
          Checkboxes = True
        end
        Item
          FieldName = 'MoNo'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '订单号'
          Width = 84
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MoLineNo'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '行号'
          Width = 31
          KeyList.Strings = ()
        end
        Item
          Alignment = taCenter
          FieldName = 'MoLineStatus'
          PickList.Strings = (
            '5 准备'
            '6 下达')
          Title.Alignment = taCenter
          Title.Caption = '行状态'
          Width = 45
          KeyList.Strings = (
            '5'
            '6')
          Checkboxes = False
        end
        Item
          FieldName = 'DeptCode'
          PickList.Strings = ()
          Title.Caption = '受单部门代码'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DeptName'
          PickList.Strings = ()
          Title.Caption = '受单部门名称'
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DeptFlag'
          PickList.Strings = ()
          Title.Caption = '受单部门标识'
          Width = 112
          KeyList.Strings = ()
        end
        Item
          Alignment = taCenter
          FieldName = 'MoSpecial'
          PickList.Strings = (
            '普通订单'
            '独立订单')
          Title.Alignment = taCenter
          Title.Caption = '订单类型'
          Width = 56
          KeyList.Strings = (
            '0'
            '1')
        end
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料代码'
          Width = 80
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料描述'
          Width = 170
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MoQty'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '约定交货量'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MoNoFinishQty'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '未结量'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MoStArtWorkDate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '约定开工日'
          Width = 66
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MoLineDate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '约定交货日'
          Width = 73
          KeyList.Strings = ()
        end>
    end
  end
  inherited ActionList: TActionList
    inherited Act_Modify: TAction
      Enabled = False
      Visible = False
    end
    inherited Act_Delete: TAction
      Enabled = False
      Visible = False
    end
    inherited Act_Look: TAction
      Enabled = False
      Visible = False
    end
  end
  inherited AdoQry_Head: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=mdrcmrm;Data Source=ExtDATASERVER'
    CurSorType = ctStatic
    BeforeInsert = AdoQry_HeadBeforeInsert
    BeforeEdit = AdoQry_HeadBeforeEdit
    AfterPost = AdoQry_HeadAfterPost
    SQL.Strings = (
      'select CheckFlag=0,'
      '                     MoLine.MoNo,'
      '                     MoLine.MoLineNo,'
      '                     MoLine.MoLineStatus,'
      '                     Mo.DeptCode, '
      '                     Dept.DeptName,'
      '                     Mo.DeptCode+'#39' '#39'+Dept.DeptName as DeptFlag,'
      '                     Mo.MoSpecial, '
      '                     MoLine.ItemCode,'
      '                     Item.ItemName,'
      '                     MoLine.MoQty,'
      '                     MoLine.MoNoFinishQty,'
      '                     MoLine.MoStArtWorkDate,'
      '                     MoLine.MoLineDate '
      '             --      Into #TmPMoLine '
      '                   from MoLine '
      '                   Join Mo On MoLine.MoNo=Mo.MoNo '
      
        '                   left join Item  on MoLine.ItemCode=Item.ItemC' +
        'ode '
      '                   left join Dept On Mo.DeptCode=Dept.DeptCode '
      
        '                   Where BackFlush<>1 and MoQty>0 and MoLineStat' +
        'us=6 ')
    Left = 432
    Top = 233
    object AdoQry_HeadCheckFlag: TIntegerField
      FieldName = 'CheckFlag'
      Origin = '#TmPMoLine'
    end
    object AdoQry_HeadMoNo: TStringField
      FieldName = 'MoNo'
      Origin = '#TmPMoLine'
      ReadOnly = True
      Size = 16
    end
    object AdoQry_HeadMoLineNo: TIntegerField
      FieldName = 'MoLineNo'
      Origin = '#TmPMoLine'
      ReadOnly = True
    end
    object AdoQry_HeadMoLineStatus: TIntegerField
      FieldName = 'MoLineStatus'
      Origin = '#TmPMoLine'
      ReadOnly = True
    end
    object AdoQry_HeadDeptCode: TStringField
      FieldName = 'DeptCode'
      Origin = '#TmPMoLine'
      ReadOnly = True
      Size = 8
    end
    object AdoQry_HeadDeptName: TStringField
      FieldName = 'DeptName'
      Origin = '#TmPMoLine'
      ReadOnly = True
      Size = 40
    end
    object AdoQry_HeadMoSpecial: TIntegerField
      FieldName = 'MoSpecial'
      Origin = '#TmPMoLine'
      ReadOnly = True
    end
    object AdoQry_HeadItemCode: TStringField
      FieldName = 'ItemCode'
      Origin = '#TmPMoLine'
      ReadOnly = True
      Size = 16
    end
    object AdoQry_HeadItemName: TStringField
      FieldName = 'ItemName'
      Origin = '#TmPMoLine'
      ReadOnly = True
      Size = 80
    end
    object AdoQry_HeadMoQty: TFloatField
      FieldName = 'MoQty'
      Origin = '#TmPMoLine'
      ReadOnly = True
    end
    object AdoQry_HeadMoNoFinishQty: TFloatField
      FieldName = 'MoNoFinishQty'
      Origin = '#TmPMoLine'
      ReadOnly = True
    end
    object AdoQry_HeadMoStArtWorkDate: TDateTimeField
      FieldName = 'MoStArtWorkDate'
      Origin = '#TmPMoLine'
      ReadOnly = True
    end
    object AdoQry_HeadMoLineDate: TDateTimeField
      FieldName = 'MoLineDate'
      Origin = '#TmPMoLine'
      ReadOnly = True
    end
    object AdoQry_HeadDeptFlag: TStringField
      FieldName = 'DeptFlag'
      Origin = '#TmPMoLine'
      ReadOnly = True
      Size = 49
    end
  end
end