mrp_enter_mo.dfm

一个MRPII系统源代码版本

inherited Frm_Mrp_Enter_Mo: TFrm_Mrp_Enter_Mo
  Left = 127
  Top = 143
  Caption = '生产订单准备'
  ClientHeight = 458
  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 = 64
    inherited Image1: TImage
      Width = 750
      Height = 64
    end
    object Label1: TLabel
      Left = 5
      Top = 13
      Width = 66
      Height = 12
      Caption = '生产订单号:'
    end
    object Label2: TLabel
      Left = 183
      Top = 15
      Width = 78
      Height = 12
      Caption = '受单部门代码:'
    end
    object Label3: TLabel
      Left = 5
      Top = 38
      Width = 54
      Height = 12
      Caption = '下单日期:'
    end
    object Label4: TLabel
      Left = 561
      Top = 40
      Width = 36
      Height = 12
      Caption = '备 注:'
    end
    object Lbl_DeptName: TLabel
      Left = 285
      Top = 15
      Width = 6
      Height = 12
      Visible = False
    end
    object Label5: TLabel
      Left = 183
      Top = 41
      Width = 78
      Height = 12
      Caption = '销售类型代码:'
    end
    object Label6: TLabel
      Left = 366
      Top = 41
      Width = 78
      Height = 12
      Caption = '销售类型描述:'
    end
    object Lbl_SaleType: TLabel
      Left = 245
      Top = 50
      Width = 6
      Height = 12
      Visible = False
    end
    object Label8: TLabel
      Left = 364
      Top = 15
      Width = 78
      Height = 12
      Caption = '受单部门名称:'
    end
    object Label11: TLabel
      Left = 623
      Top = 15
      Width = 54
      Height = 12
      Caption = '标准任务:'
    end
    object Edt_MoNo: TEdit
      Left = 70
      Top = 10
      Width = 107
      Height = 20
      Enabled = False
      ReadOnly = True
      TabOrder = 0
    end
    object Medt_Modate: TMaskEdit
      Left = 68
      Top = 36
      Width = 109
      Height = 20
      EditMask = '!9999.99.99;1;'
      MaxLength = 10
      TabOrder = 4
      Text = '    .  .  '
      OnExit = DateCheck
    end
    object Edt_MoRemArk: TEdit
      Left = 602
      Top = 37
      Width = 125
      Height = 20
      MaxLength = 150
      TabOrder = 7
    end
    object Edt_DeptCode: TExtEdit
      Left = 262
      Top = 10
      Width = 96
      Height = 20
      TabOrder = 1
      OnExit = Edt_DeptCodeExit
      OnKeyDown = DeptHint
      DispLabel = Lbl_DeptName
    end
    object Edt_SysParamValuec: TEdit
      Left = 447
      Top = 37
      Width = 111
      Height = 20
      Enabled = False
      ReadOnly = True
      TabOrder = 6
    end
    object Edt_SysParamCode: TExtEdit
      Left = 262
      Top = 36
      Width = 96
      Height = 20
      TabOrder = 5
      OnExit = Edt_SysParamCodeExit
      OnKeyDown = Edt_SysParamCodeKeyDown
      DispLabel = Lbl_SaleType
    end
    object Edt_DeptName: TEdit
      Left = 447
      Top = 10
      Width = 170
      Height = 20
      Enabled = False
      ReadOnly = True
      TabOrder = 2
    end
    object Cmbx_StandardFlag: TComboBox
      Left = 680
      Top = 10
      Width = 47
      Height = 22
      Style = csOwnerDrawFixed
      ItemHeight = 16
      TabOrder = 3
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 431
    Width = 750
    Height = 27
    inherited Image4: TImage
      Width = 750
      Height = 27
    end
    object Label7: TLabel
      Left = 3
      Top = 4
      Width = 60
      Height = 12
      Caption = '物料标识：'
    end
    object Lbl_ItemFlag: TLabel
      Left = 71
      Top = 2
      Width = 6
      Height = 12
    end
    object Label9: TLabel
      Left = 2
      Top = 16
      Width = 72
      Height = 12
      Caption = '约定交货量：'
    end
    object DBText1: TDBText
      Left = 74
      Top = 16
      Width = 42
      Height = 12
      AutoSize = True
      DataField = 'MOQTY'
      DataSource = DataSource
    end
    object Label10: TLabel
      Left = 570
      Top = 16
      Width = 72
      Height = 12
      Caption = '约定开工日：'
    end
    object DBText2: TDBText
      Left = 642
      Top = 16
      Width = 42
      Height = 12
      AutoSize = True
      DataField = 'MOStArtWorkDate'
      DataSource = DataSource
    end
  end
  inherited Pnl_Body: TPanel
    Top = 121
    Width = 750
    Height = 310
    inherited Image3: TImage
      Width = 750
      Height = 310
    end
    inherited DBGridEh: TDBGridEh
      Width = 750
      Height = 310
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      FrozenCols = 4
      Columns = <
        Item
          FieldName = 'MoLineNO'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '订单行号'
          Width = 55
          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 = 55
          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 = (
            ''
            '是')
          KeyList.Strings = (
            '0'
            '1')
        end
        Item
          FieldName = 'BackFlush'
          PickList.Strings = (
            ''
            '是')
          Width = 77
          KeyList.Strings = (
            '0'
            '1')
        end>
    end
  end
  inherited ActionList: TActionList
    Left = 253
    Top = 192
  end
  inherited AdoQry_Body: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=mdrcmrm;Data Source=192.168.0.8'
    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')
    object AdoQry_BodyMONO: TStringField
      FieldName = 'MONO'
      Size = 16
    end
    object AdoQry_BodyMoLineNO: TIntegerField
      FieldName = 'MoLineNO'
    end
    object AdoQry_BodyItemCode: TStringField
      FieldName = 'ItemCode'
      Size = 16
    end
    object AdoQry_BodyMOQTY: TFloatField
      FieldName = 'MOQTY'
      DisplayFormat = '#,##0.##'
    end
    object AdoQry_BodyMoLineDATE: TDateTimeField
      FieldName = 'MoLineDATE'
    end
    object AdoQry_BodyMoNoFinishQTY: TFloatField
      FieldName = 'MoNoFinishQTY'
      DisplayFormat = '#,##0.##'
    end
    object AdoQry_BodyMoLineSTATUS: TIntegerField
      FieldName = 'MoLineSTATUS'
    end
    object AdoQry_BodyItemName: TStringField
      FieldName = 'ItemName'
      Size = 60
    end
    object AdoQry_BodyMOStArtWorkDate: TDateTimeField
      FieldName = 'MOStArtWorkDate'
      Origin = 'MoLine'
      DisplayFormat = 'yyyy.mm.dd'
    end
    object AdoQry_BodyUomName: TStringField
      FieldName = 'UomName'
      Origin = 'Uom'
      Size = 10
    end
    object AdoQry_BodyByProduct: TIntegerField
      DisplayLabel = '是否副产品'
      FieldName = 'ByProduct'
    end
    object AdoQry_BodyParentMoLineNo: TIntegerField
      FieldName = 'ParentMoLineNo'
    end
    object AdoQry_BodyMoRealInQty: TFloatField
      FieldName = 'MoRealInQty'
    end
    object AdoQry_BodyMoInQty: TFloatField
      FieldName = 'MoInQty'
    end
    object AdoQry_BodyMoLineCheck: TIntegerField
      FieldName = 'MoLineCheck'
    end
    object AdoQry_BodySSQty: TFloatField
      FieldName = 'SSQty'
    end
    object AdoQry_BodyCloseRemArk: TStringField
      FieldName = 'CloseRemArk'
      Size = 60
    end
    object AdoQry_BodyBilllineremArk: TStringField
      FieldName = 'BilllineremArk'
      Size = 250
    end
    object AdoQry_BodyBackFlush: TIntegerField
      DisplayLabel = '是否拉式领料'
      FieldName = 'BackFlush'
    end
  end
  inherited DataSource: TDataSource
    OnDataChange = DataSourceDataChange
    Top = 225
  end
end