mrp_qry_uprightmrp_d_newmossparent.dfm

一个MRPII系统源代码版本

inherited Frm_Mrp_Qry_UpRightMrp_D_NewMossParent: TFrm_Mrp_Qry_UpRightMrp_D_NewMossParent
  Left = 65
  Top = 81
  Caption = '父项需求对应表'
  ClientWidth = 716
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 716
    inherited ToolBar: TToolBar
      inherited TlBtn_Filter: TToolButton
        Visible = False
      end
      inherited TlBtn_Locate: TToolButton
        Visible = False
      end
      inherited TlBtn_Order: TToolButton
        Visible = False
      end
    end
  end
  inherited Pnl_Title: TPanel
    Width = 716
    Alignment = taLeftJustify
    Caption = '父项物料信息'
  end
  inherited Pnl_Head: TPanel
    Top = 153
    Width = 716
    Height = 0
    inherited Lbl_Condition: TLabel
      Width = 24
      Caption = '全部'
    end
    inherited Lbl_Order: TLabel
      Width = 78
      Caption = '月份/物料代码'
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 212
    Width = 716
    Height = 217
    object Label1: TLabel
      Left = 8
      Top = 57
      Width = 84
      Height = 12
      Caption = '子项物料代码：'
    end
    object Label2: TLabel
      Left = 184
      Top = 57
      Width = 84
      Height = 12
      Caption = '子项物料描述：'
    end
    object Label3: TLabel
      Left = 98
      Top = 57
      Width = 6
      Height = 12
    end
    object Label4: TLabel
      Left = 274
      Top = 57
      Width = 6
      Height = 12
    end
    object Label5: TLabel
      Left = 56
      Top = 78
      Width = 36
      Height = 12
      Caption = '单位：'
    end
    object Label6: TLabel
      Left = 98
      Top = 79
      Width = 6
      Height = 12
    end
    object Label7: TLabel
      Left = 208
      Top = 78
      Width = 60
      Height = 12
      Caption = '物料类型：'
    end
    object Label8: TLabel
      Left = 274
      Top = 78
      Width = 6
      Height = 12
    end
    object Label9: TLabel
      Left = 368
      Top = 78
      Width = 48
      Height = 12
      Caption = '制购码：'
    end
    object Label10: TLabel
      Left = 422
      Top = 78
      Width = 6
      Height = 12
    end
    object Label11: TLabel
      Left = 32
      Top = 123
      Width = 60
      Height = 12
      Caption = '批量策略：'
    end
    object Label12: TLabel
      Left = 98
      Top = 123
      Width = 6
      Height = 12
    end
    object Label13: TLabel
      Left = 232
      Top = 122
      Width = 36
      Height = 12
      Caption = '批量：'
    end
    object Label14: TLabel
      Left = 274
      Top = 122
      Width = 6
      Height = 12
    end
    object Label15: TLabel
      Left = 356
      Top = 122
      Width = 60
      Height = 12
      Caption = '最大库存：'
    end
    object Label16: TLabel
      Left = 422
      Top = 122
      Width = 6
      Height = 12
    end
    object Label17: TLabel
      Left = 32
      Top = 144
      Width = 60
      Height = 12
      Caption = '安全库存：'
    end
    object Label18: TLabel
      Left = 98
      Top = 144
      Width = 6
      Height = 12
    end
    object Label19: TLabel
      Left = 2
      Top = 180
      Width = 132
      Height = 12
      Caption = '父项订单对子项需求量：'
    end
    object Label20: TLabel
      Left = 138
      Top = 180
      Width = 6
      Height = 12
    end
    object Label21: TLabel
      Left = 196
      Top = 180
      Width = 72
      Height = 12
      Caption = '子项已领量：'
    end
    object Label22: TLabel
      Left = 276
      Top = 180
      Width = 6
      Height = 12
    end
    object Label27: TLabel
      Left = 20
      Top = 100
      Width = 72
      Height = 12
      Caption = '准备提前期：'
    end
    object Label28: TLabel
      Left = 98
      Top = 100
      Width = 6
      Height = 12
    end
    object Label29: TLabel
      Left = 196
      Top = 100
      Width = 72
      Height = 12
      Caption = '运行提前期：'
    end
    object Label30: TLabel
      Left = 274
      Top = 100
      Width = 6
      Height = 12
    end
    object Bevel1: TBevel
      Left = 0
      Top = 13
      Width = 800
      Height = 2
      ParentShowHint = False
      ShApe = bsTopLine
      ShowHint = False
      Style = bsRaised
    end
    object Label31: TLabel
      Left = 344
      Top = 100
      Width = 72
      Height = 12
      Caption = '质检提前期：'
    end
    object Label32: TLabel
      Left = 422
      Top = 100
      Width = 6
      Height = 12
    end
    object Label33: TLabel
      Left = 8
      Top = 33
      Width = 91
      Height = 12
      Caption = '子项物料信息：'
      Font.ChArset = GB2312_CHArSET
      Font.Color = clWindowText
      Font.Height = -12
      Font.Name = '宋体'
      Font.Style = [fsBold]
      ParentFont = False
    end
  end
  inherited Pnl_Body: TPanel
    Top = 57
    Width = 716
    Height = 96
    Align = alTop
    inherited DBGridEh: TDBGridEh
      Width = 716
      Height = 96
      FrozenCols = 3
      Columns = <
        Item
          FieldName = 'Itemflag'
          PickList.Strings = ()
          Width = 174
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemCode'
          PickList.Strings = ()
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemName'
          PickList.Strings = ()
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'UomName'
          PickList.Strings = ()
          Width = 31
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ItemType'
          PickList.Strings = (
            '0 普通物料'
            '1 资源'
            '2 工具'
            '3 参考'
            '4 虚项'
            '5 劳务'
            '6 副产品'
            '7 成本')
          KeyList.Strings = (
            '0'
            '1'
            '2'
            '3'
            '4'
            '5'
            '6'
            '7')
        end
        Item
          FieldName = 'PmCode'
          PickList.Strings = (
            '0 制造'
            '1 采购'
            '2 委外'
            '3 既自制又委外')
          KeyList.Strings = (
            '0'
            '1'
            '2'
            '3')
        end
        Item
          FieldName = 'PrepareLT'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'RunLT'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'QcLT'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'BatchStrat'
          PickList.Strings = (
            '0 直接批量法'
            '1 固定批量法')
          KeyList.Strings = (
            '0'
            '1')
        end
        Item
          FieldName = 'PmBatch'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MaxQty'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MinQty'
          PickList.Strings = ()
          KeyList.Strings = ()
        end>
    end
  end
  object Panel1: TPanel [5]
    Left = 0
    Top = 153
    Width = 716
    Height = 59
    Align = alClient
    TabOrder = 5
    object Panel2: TPanel
      Left = 1
      Top = 1
      Width = 714
      Height = 31
      Align = alTop
      Alignment = taLeftJustify
      BevelOuter = bvNone
      Caption = '父项需求追溯'
      Font.ChArset = GB2312_CHArSET
      Font.Color = clWindowText
      Font.Height = -14
      Font.Name = '宋体'
      Font.Style = []
      ParentFont = False
      TabOrder = 0
    end
    object DBGridEh1: TDBGridEh
      Left = 1
      Top = 32
      Width = 714
      Height = 26
      Align = alClient
      DataSource = DataSource1
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      PopuPmenu = PopuPmenu
      ReadOnly = True
      TabOrder = 1
      TitleFont.ChArset = GB2312_CHArSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -12
      TitleFont.Name = '宋体'
      TitleFont.Style = []
      OnDrawDataCell = DBGridEhDrawDataCell
      FrozenCols = 4
      OnGetCellParams = DBGridEhGetCellParams
      Columns = <
        Item
          FieldName = 'Itemflag'
          Width = 184
        end
        Item
          FieldName = 'UomName'
          Width = 31
        end
        Item
          FieldName = 'Orderno'
          Width = 71
        end
        Item
          FieldName = 'Orderlineno'
          Width = 52
        end
        Item
          FieldName = 'Orderlinestatus'
          PickList.Strings = (
            '5 准备'
            '6 下达'
            '7 关闭'
            '8 永久关闭')
          Width = 47
          KeyList.Strings = (
            '5'
            '6'
            '7'
            '8')
        end
        Item
          FieldName = 'Orderqty'
        end
        Item
          FieldName = 'MoNoFinishqty'
          Width = 53
        end
        Item
          FieldName = 'duedate'
          Width = 74
        end
        Item
          FieldName = 'releasedate'
          Title.Caption = '约定交货日'
          Width = 73
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 181
    Top = 115
  end
  inherited ActionList: TActionList
    Left = 168
    Top = 168
  end
  inherited AdoQry_Main: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=mdrcmrm_B_old;Data Source=192.16' +
      '8.0.151;Use procedure for Prepare=1;Auto Translate=True;Packet S' +
      'ize=4096;Workstation ID=XYB'
    CurSorType = ctStatic
    SQL.Strings = (
      'select Item.*,Uom.UomName,Itemflag=ItemCode+'#39' '#39'+ItemName'
      ' from Item,Uom'
      'where Item.UomCode=Uom.UomCode'
      '  ')
    Left = 456
    Top = 137
    object AdoQry_MainItemCode: TStringField
      DisplayLabel = '物料代码'
      FieldName = 'ItemCode'
      Size = 16
    end
    object AdoQry_MainItemName: TStringField
      DisplayLabel = '物料描述'
      FieldName = 'ItemName'
      Size = 80
    end
    object AdoQry_MainItemType: TIntegerField
      DisplayLabel = '物料类型'
      FieldName = 'ItemType'
    end
    object AdoQry_MainPmCode: TIntegerField
      DisplayLabel = '制购码'
      FieldName = 'PmCode'
    end
    object AdoQry_MainBatchStrat: TIntegerField
      DisplayLabel = '批量策略'
      FieldName = 'BatchStrat'
    end
    object AdoQry_MainMaxQty: TFloatField
      DisplayLabel = '最大库存'
      FieldName = 'MaxQty'
    end
    object AdoQry_MainMinQty: TFloatField
      DisplayLabel = '安全库存'
      FieldName = 'MinQty'
    end
    object AdoQry_MainPurchLDTime: TFloatField
      DisplayLabel = '采购提前期'
      FieldName = 'PurchLDTime'
    end
    object AdoQry_MainItemflag: TStringField
      DisplayLabel = '物料标识'
      FieldName = 'Itemflag'
      ReadOnly = True
      Size = 97
    end
    object AdoQry_MainMNLDTime: TFloatField
      DisplayLabel = '制造提前期'
      FieldName = 'MNLDTime'
    end
    object AdoQry_MainUomName: TStringField
      DisplayLabel = '单位'
      FieldName = 'UomName'
      Size = 10
    end
    object AdoQry_MainPmBatch: TIntegerField
      DisplayLabel = '批量'
      FieldName = 'PmBatch'
    end
    object AdoQry_MainPrepareLT: TIntegerField
      DisplayLabel = '准备提前期'
      FieldName = 'PrepareLT'
    end
    object AdoQry_MainRunLT: TIntegerField
      DisplayLabel = '运行提前期'
      FieldName = 'RunLT'
    end
    object AdoQry_MainQcLT: TIntegerField
      DisplayLabel = '质检提前期'
      FieldName = 'QcLT'
    end
  end
  inherited ExtPrintReport: TExtPrintReport
    Left = 56
    Top = 129
  end
  inherited PopuPmenu: TPopuPmenu
    Left = 304
    Top = 137
  end
  object AdoQuery1: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=mdrcmrm_B;Data Source=192.168.0.' +
      '151;Use procedure for Prepare=1;Auto Translate=True;Packet Size=' +
      '4096;Workstation ID=XYB'
    CurSorType = ctStatic
    LockType = ltBatchOptimistic
    AfterOpen = AdoQueryAfterOpen
    EnableBCD = False
    Parameters = <>
    SQL.Strings = (
      'select MoLine.mono as Orderno,'
      '       MoLine.MoLineno as Orderlineno,'
      '       MoLine.MoLinestatus as Orderlinestatus,'
      '       MoLine.moqty as Orderqty,'
      '       MoLine.mostArtworkdate as duedate,'
      '       MoLine.MoLinedate as releasedate,'
      '       MoLine.MoNoFinishqty,'
      '       Bom.Bomqty,'
      '       ScrAprate=convert(varchAr,BomScrAp_Percent)+'#39'%'#39','
      '       Itemflag=MoLine.ItemCode+'#39' '#39'+Item.ItemName,'
      '       Item.Qclt,Item.Preparelt,'
      '       Uom.UomName'
      'from MoLine,Uom,Item,Bom'
      'where MoLine.ItemCode=Item.ItemCode'
      '  and Item.UomCode*=Uom.UomCode'
      '  and MoLine.ItemCode=Bom.ite_ItemCode'
      '')
    Left = 536
    Top = 209
    object AdoQuery1Orderno: TStringField
      DisplayLabel = '订单号'
      FieldName = 'Orderno'
      Size = 16
    end
    object AdoQuery1Orderlineno: TIntegerField
      DisplayLabel = '订单行号'
      FieldName = 'Orderlineno'
    end
    object AdoQuery1Orderlinestatus: TIntegerField
      DisplayLabel = '行状态'
      FieldName = 'Orderlinestatus'
    end
    object AdoQuery1Orderqty: TFloatField
      DisplayLabel = '约定交货量'
      FieldName = 'Orderqty'
    end
    object AdoQuery1duedate: TDateTimeField
      DisplayLabel = '约定开工日'
      FieldName = 'duedate'
    end
    object AdoQuery1releasedate: TDateTimeField
      DisplayLabel = '约定交货量'
      FieldName = 'releasedate'
    end
    object AdoQuery1Itemflag: TStringField
      DisplayLabel = '物料标识'
      FieldName = 'Itemflag'
      ReadOnly = True
      Size = 97
    end
    object AdoQuery1UomName: TStringField
      DisplayLabel = '单位'
      FieldName = 'UomName'
      Size = 10
    end
    object AdoQuery1MoNoFinishqty: TFloatField
      DisplayLabel = '未结量'
      FieldName = 'MoNoFinishqty'
    end
  end
  object DataSource1: TDataSource
    DataSet = AdoQuery1
    Left = 456
    Top = 206
  end
end