mrp_enter_newmo.dfm

一个MRPII系统源代码版本

inherited Frm_Mrp_Enter_NewMo: TFrm_Mrp_Enter_NewMo
  Left = 26
  Top = 91
  Caption = '生产订单准备'
  ClientWidth = 750
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 750
  end
  inherited Pnl_Title: TPanel
    Width = 750
    Caption = '生产订单准备'
    inherited Image2: TImage
      Width = 750
    end
  end
  inherited Pnl_Head: TPanel
    Width = 750
    Height = 75
    inherited Image1: TImage
      Width = 750
      Height = 75
    end
    object Label1: TLabel
      Left = 14
      Top = 8
      Width = 66
      Height = 12
      Caption = '生产订单号:'
      TransParent = True
    end
    object Label2: TLabel
      Left = 26
      Top = 32
      Width = 54
      Height = 12
      Caption = '受单部门:'
      TransParent = True
    end
    object Label3: TLabel
      Left = 191
      Top = 9
      Width = 54
      Height = 12
      Caption = '下单日期:'
      TransParent = True
    end
    object Label4: TLabel
      Left = 44
      Top = 53
      Width = 36
      Height = 12
      Caption = '备 注:'
      TransParent = True
    end
    object Lbl_DeptName: TLabel
      Left = 285
      Top = 15
      Width = 6
      Height = 12
      Visible = False
    end
    object Label5: TLabel
      Left = 350
      Top = 32
      Width = 54
      Height = 12
      Caption = '销售类型:'
      TransParent = True
      Visible = False
    end
    object Lbl_SaleType: TLabel
      Left = 285
      Top = 50
      Width = 6
      Height = 12
      Visible = False
    end
    object Label11: TLabel
      Left = 350
      Top = 10
      Width = 54
      Height = 12
      Caption = '标准任务:'
      TransParent = True
    end
    object Label6: TLabel
      Left = 362
      Top = 32
      Width = 42
      Height = 12
      Caption = '参考号:'
      TransParent = True
    end
    object Edt_MoNo: TEdit
      Left = 82
      Top = 4
      Width = 72
      Height = 20
      Enabled = False
      TabOrder = 0
    end
    object Medt_Modate: TMaskEdit
      Left = 254
      Top = 4
      Width = 69
      Height = 20
      EditMask = '!9999.99.99;1;'
      MaxLength = 10
      TabOrder = 1
      Text = '    .  .  '
      OnExit = DateCheck
    end
    object Edt_MoRemArk: TEdit
      Left = 82
      Top = 50
      Width = 520
      Height = 20
      MaxLength = 150
      TabOrder = 8
    end
    object Edt_SysParamValuec: TEdit
      Left = 458
      Top = 27
      Width = 144
      Height = 20
      Enabled = False
      ReadOnly = True
      TabOrder = 7
      Visible = False
    end
    object Edt_DeptName: TEdit
      Left = 134
      Top = 27
      Width = 189
      Height = 20
      Enabled = False
      ReadOnly = True
      TabOrder = 4
    end
    object edt_SysParamCode: TLinkEdit
      Left = 406
      Top = 27
      Width = 50
      Height = 20
      LinkStyle = lsEllipsis
      TabOrder = 6
      Visible = False
      OnButtonClick = edt_SysParamCodeButtonClick
      OnExit = Edt_SysParamCodeExit
      OnKeyDown = Edt_SysParamCodeKeyDown
    end
    object Cmbx_StandardFlag: TComboBox
      Left = 406
      Top = 2
      Width = 50
      Height = 20
      Style = csDropDownList
      ItemHeight = 12
      ParentShowHint = False
      ShowHint = False
      TabOrder = 2
    end
    object edt_DeptCode: TLinkEdit
      Left = 82
      Top = 27
      Width = 50
      Height = 20
      LinkStyle = lsEllipsis
      TabOrder = 3
      OnButtonClick = DeptHint1
      OnExit = Edt_DeptCodeExit
      OnKeyDown = DeptHint
    end
    object edt_rno: TEdit
      Left = 406
      Top = 27
      Width = 88
      Height = 20
      TabOrder = 5
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 441
    Width = 750
    Height = 27
    inherited Image4: TImage
      Width = 750
      Height = 27
    end
    object Label7: TLabel
      Left = 3
      Top = 4
      Width = 60
      Height = 12
      Caption = '物料标识：'
      TransParent = True
    end
    object Lbl_ItemFlag: TLabel
      Left = 71
      Top = 2
      Width = 6
      Height = 12
      TransParent = True
    end
    object Label9: TLabel
      Left = 2
      Top = 16
      Width = 72
      Height = 12
      Caption = '约定交货量：'
      TransParent = True
    end
    object DBText1: TDBText
      Left = 74
      Top = 16
      Width = 42
      Height = 12
      AutoSize = True
      DataField = 'MOQTY'
      DataSource = DataSource
      TransParent = True
    end
    object Label10: TLabel
      Left = 570
      Top = 16
      Width = 72
      Height = 12
      Caption = '约定开工日：'
      TransParent = True
    end
    object DBText2: TDBText
      Left = 642
      Top = 16
      Width = 42
      Height = 12
      AutoSize = True
      DataField = 'MOStArtWorkDate'
      DataSource = DataSource
      TransParent = True
    end
  end
  inherited Pnl_Body: TPanel
    Top = 132
    Width = 750
    Height = 309
    inherited Image3: TImage
      Width = 750
      Height = 309
    end
    inherited DBGridEh: TDBGridEh
      Width = 750
      Height = 309
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      FrozenCols = 4
      Columns = <
        Item
          FieldName = 'MoLineNO'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '订单行号'
          Width = 29
          KeyList.Strings = ()
        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
          Alignment = taCenter
          FieldName = 'UomName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '计量单位'
          Width = 28
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MOQTY'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '约定交货量'
          Width = 70
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MoNoFinishQTY'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '未结量'
          Width = 70
          KeyList.Strings = ()
        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'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '约定开工日'
          Width = 70
          KeyList.Strings = ()
        end
        Item
          Alignment = tArightJustify
          FieldName = 'MoLineDATE'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '约定交货日'
          Width = 70
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ByProduct'
          PickList.Strings = (
            ''
            '是')
          Width = 43
          KeyList.Strings = (
            '0'
            '1')
        end
        Item
          FieldName = 'BackFlush'
          PickList.Strings = (
            ''
            '是')
          Width = 50
          KeyList.Strings = (
            '0'
            '1')
        end
        Item
          FieldName = 'RemArk'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Width = 123
          KeyList.Strings = ()
        end>
    end
  end
  inherited ActionList: TActionList
    Left = 253
    Top = 192
    inherited Act_Filter: TAction
      Enabled = True
      Visible = True
    end
    inherited Act_Order: TAction
      Enabled = True
      Visible = True
    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=ZHENG' +
      'JIArONG'
    SQL.Strings = (
      'select MoLine.*,Item.ItemName,Uom.UomName from MoLine join Item '
      
        'on MoLine.ItemCode=Item.ItemCode left outer join Uom on Item.Uom' +
        'Code=Uom.UomCode')
    Left = 296
    Top = 265
    object AdoQry_BodyMONO: TStringField
      FieldName = 'MONO'
      Origin = '#tmptable'
      Size = 16
    end
    object AdoQry_BodyMoLineNO: TIntegerField
      FieldName = 'MoLineNO'
      Origin = '#tmptable'
    end
    object AdoQry_BodyItemCode: TStringField
      FieldName = 'ItemCode'
      Origin = '#tmptable'
      Size = 16
    end
    object AdoQry_BodyMOQTY: TFloatField
      FieldName = 'MOQTY'
      Origin = '#tmptable'
      DisplayFormat = '#,##0.##'
    end
    object AdoQry_BodyMoLineDATE: TDateTimeField
      FieldName = 'MoLineDATE'
      Origin = '#tmptable'
    end
    object AdoQry_BodyMoNoFinishQTY: TFloatField
      FieldName = 'MoNoFinishQTY'
      Origin = '#tmptable'
      DisplayFormat = '#,##0.##'
    end
    object AdoQry_BodyMoLineSTATUS: TIntegerField
      FieldName = 'MoLineSTATUS'
      Origin = '#tmptable'
    end
    object AdoQry_BodyItemName: TStringField
      FieldName = 'ItemName'
      Origin = '#tmptable'
      Size = 60
    end
    object AdoQry_BodyMOStArtWorkDate: TDateTimeField
      FieldName = 'MOStArtWorkDate'
      Origin = '#tmptable'
      DisplayFormat = 'yyyy.mm.dd'
    end
    object AdoQry_BodyUomName: TStringField
      FieldName = 'UomName'
      Origin = '#tmptable'
      Size = 10
    end
    object AdoQry_BodyByProduct: TIntegerField
      DisplayLabel = '是否副产品'
      FieldName = 'ByProduct'
      Origin = '#tmptable'
    end
    object AdoQry_BodyParentMoLineNo: TIntegerField
      FieldName = 'ParentMoLineNo'
      Origin = '#tmptable'
    end
    object AdoQry_BodyMoRealInQty: TFloatField
      FieldName = 'MoRealInQty'
      Origin = '#tmptable'
    end
    object AdoQry_BodyMoInQty: TFloatField
      FieldName = 'MoInQty'
      Origin = '#tmptable'
    end
    object AdoQry_BodyMoLineCheck: TIntegerField
      FieldName = 'MoLineCheck'
      Origin = '#tmptable'
    end
    object AdoQry_BodySSQty: TFloatField
      FieldName = 'SSQty'
      Origin = '#tmptable'
    end
    object AdoQry_BodyCloseRemArk: TStringField
      FieldName = 'CloseRemArk'
      Origin = '#tmptable'
      Size = 60
    end
    object AdoQry_BodyBilllineremArk: TStringField
      FieldName = 'BilllineremArk'
      Origin = '#tmptable'
      Size = 250
    end
    object AdoQry_BodyBackFlush: TIntegerField
      DisplayLabel = '是否拉式领料'
      FieldName = 'BackFlush'
      Origin = '#tmptable'
    end
    object AdoQry_BodyRemArk: TStringField
      DisplayLabel = '备注'
      FieldName = 'RemArk'
      Origin = '#tmptable'
      Size = 30
    end
  end
  inherited DataSource: TDataSource
    OnDataChange = DataSourceDataChange
    Top = 225
  end
end