sfc_mnlistrequest.dfm

一个MRPII系统源代码版本

inherited Frm_Sfc_MnListRequest: TFrm_Sfc_MnListRequest
  Left = 63
  Top = 117
  Caption = '车间生产清单领料请领制单'
  ClientHeight = 386
  ClientWidth = 754
  Position = poDefault
  Windowstate = wsMaximized
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 754
  end
  inherited Pnl_Title: TPanel
    Width = 754
    Caption = '车间生产清单领料请领制单'
    inherited Image2: TImage
      Width = 754
    end
  end
  inherited Pnl_Head: TPanel
    Width = 754
    inherited Image1: TImage
      Width = 754
    end
    inherited Lbl_Condition: TLabel
      Width = 108
      Caption = '部门代码，定单状态'
    end
    inherited Lbl_Order: TLabel
      Width = 96
      Caption = '订单号，订单行号'
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 347
    Width = 754
    Height = 39
    inherited Image4: TImage
      Width = 754
      Height = 39
    end
    object Label1: TLabel
      Left = 24
      Top = 16
      Width = 60
      Height = 12
      Caption = '物料描述：'
    end
    object DBText1: TDBText
      Left = 88
      Top = 15
      Width = 42
      Height = 12
      AutoSize = True
      DataField = 'ItemName'
      DataSource = DataSource
    end
  end
  inherited Pnl_Body: TPanel
    Width = 754
    Height = 250
    inherited Image3: TImage
      Width = 754
      Height = 250
    end
    inherited DBGridEh: TDBGridEh
      Width = 754
      Height = 250
      OnCellClick = DBGridEhCellClick
      OnTitleBtnClick = DBGridEhTitleBtnClick
      Columns = <
        Item
          Alignment = taLeftJustify
          ButtonStyle = cbsNone
          Color = clWhite
          FieldName = 'mArk'
          PickList.Strings = ()
          ReadOnly = False
          Title.Alignment = taCenter
          Title.Caption = '标记'
          Title.Color = clSilver
          Title.Font.ChArset = GB2312_CHArSET
          Title.Font.Color = clRed
          Title.Font.Height = -12
          Title.Font.Name = '宋体'
          Title.Font.Style = []
          Title.TitleButton = True
          Width = 37
          KeyList.Strings = (
            '1'
            '0')
          Checkboxes = True
        end
        Item
          FieldName = 'mono'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '订单号'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MoLineno'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '订单行号'
          Width = 55
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MoLinestatus'
          PickList.Strings = (
            '准备'
            '下达')
          Title.Alignment = taCenter
          Title.Caption = '行状态'
          Width = 49
          KeyList.Strings = (
            '5'
            '6')
        end
        Item
          FieldName = 'moSpecial'
          PickList.Strings = (
            '否'
            '是')
          Title.Alignment = taCenter
          Title.Caption = '独立订单'
          Width = 53
          KeyList.Strings = (
            '0'
            '1')
        end
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料代码'
          Width = 125
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '物料描述'
          Width = 250
          KeyList.Strings = ()
        end
        Item
          FieldName = 'moqty'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '约定交货量'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'mostArtworkdate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '约定开工日'
          Width = 80
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MoLinedate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '约定交货日'
          Width = 80
          KeyList.Strings = ()
        end>
    end
  end
  inherited ActionList: TActionList
    inherited Act_New: TAction
      Enabled = False
      Visible = False
    end
    inherited Act_Modify: TAction
      Enabled = False
      Visible = False
    end
    inherited Act_Delete: TAction
      Enabled = False
      Visible = False
    end
    inherited Act_CancelCheck: TAction
      OnExecute = Act_CancelCheckExecute
    end
    inherited Act_Check: TAction
      OnExecute = Act_CheckExecute
    end
  end
  inherited AdoQry_Head: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=mdrcmrm_B;Data Source=192.168.0.' +
      '151'
    CurSorType = ctStatic
    BeforeInsert = AdoQry_HeadBeforeInsert
    SQL.Strings = (
      'select l.mono,'
      '       l.MoLineno,'
      '       l.ItemCode,'
      '       i.ItemName,'
      '       l.moqty,'
      '       l.mostArtworkdate,'
      '       l.MoLinedate,'
      '       l.MoLinestatus,'
      '              l.mArk,'
      '       m.moSpecial '
      '       from MoLine l left join Item i on l.ItemCode=i.ItemCode '
      '                     left join mo m on l.mono=m.mono ')
    object AdoQry_Headmono: TStringField
      FieldName = 'mono'
      Size = 16
    end
    object AdoQry_HeadMoLineno: TIntegerField
      FieldName = 'MoLineno'
    end
    object AdoQry_HeadItemCode: TStringField
      FieldName = 'ItemCode'
      Size = 16
    end
    object AdoQry_HeadItemName: TStringField
      FieldName = 'ItemName'
      Size = 60
    end
    object AdoQry_Headmoqty: TFloatField
      FieldName = 'moqty'
    end
    object AdoQry_HeadmostArtworkdate: TDateTimeField
      FieldName = 'mostArtworkdate'
    end
    object AdoQry_HeadMoLinedate: TDateTimeField
      FieldName = 'MoLinedate'
    end
    object AdoQry_HeadMoLinestatus: TIntegerField
      FieldName = 'MoLinestatus'
    end
    object AdoQry_HeadmoSpecial: TIntegerField
      FieldName = 'moSpecial'
    end
    object AdoQry_HeadmArk: TIntegerField
      FieldName = 'mArk'
    end
  end
end