inv_mnlistaudit_h.dfm

一个MRPII系统源代码版本

inherited Frm_Inv_MnListAudit_H: TFrm_Inv_MnListAudit_H
  Left = -11
  Top = 134
  Caption = '车间清单领料仓库核定'
  ClientHeight = 553
  ClientWidth = 800
  Position = poDefault
  Windowstate = wsMaximized
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 800
  end
  inherited Pnl_Title: TPanel
    Width = 800
    Caption = '车间清单领料仓库核定'
    inherited Image2: TImage
      Width = 800
    end
  end
  inherited Pnl_Head: TPanel
    Width = 800
    inherited Image1: TImage
      Width = 800
    end
    inherited Lbl_Condition: TLabel
      Width = 108
      Caption = '部门代码，定单状态'
    end
    inherited Lbl_Order: TLabel
      Width = 96
      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 = 15
      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]
      Columns = <
        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_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=192.168.0.15' +
      '1'
    CurSorType = ctStatic
    BeforeInsert = AdoQry_HeadBeforeInsert
    SQL.Strings = (
      'select l.mono,'
      '       l.MoLineno,'
      '       l.ItemCode,'
      '       i.ItemName,'
      '       l.moqty,'
      '       l.mostArtworkdate,'
      '       l.MoLinedate,'
      '       l.MoLinestatus,'
      '       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
  end
end