bas_qry_multibom1.dfm

一个MRPII系统源代码版本

inherited Frm_Bas_Qry_MultiBom1: TFrm_Bas_Qry_MultiBom1
  Left = -5
  Top = 104
  Caption = '设计Bom多层展开'
  ClientHeight = 428
  ClientWidth = 801
  FormStyle = fsMDIChild
  Visible = True
  Windowstate = wsMaximized
  OnClose = FormClose
  OnDestroy = FormDestroy
  PixelsPerInch = 96
  TextHeight = 12
  inherited ControlBar: TControlBar
    Width = 801
    inherited ToolBar: TToolBar
      Width = 178
      object ToolButton2: TToolButton
        Left = 23
        Top = 0
        Width = 8
        Caption = 'ToolButton2'
        ImageIndex = 11
        Style = tbsSeparator
      end
      object Tlbtn_Hint: TToolButton
        Left = 31
        Top = 0
        Action = Act_Hint
        ParentShowHint = False
        ShowHint = True
      end
      object ToolButton7: TToolButton
        Left = 54
        Top = 0
        Width = 8
        Caption = 'ToolButton7'
        ImageIndex = 12
        Style = tbsSeparator
      end
      object TlBtn_Excel: TToolButton
        Left = 62
        Top = 0
        Action = Act_Excel
      end
      object ToolButton1: TToolButton
        Left = 85
        Top = 0
        Width = 8
        Caption = 'ToolButton1'
        ImageIndex = 43
        Style = tbsSeparator
      end
      object TlBtn_Preview: TToolButton
        Left = 93
        Top = 0
        Action = Act_Preview
      end
      object ToolButton3: TToolButton
        Left = 116
        Top = 0
        Width = 8
        Caption = 'ToolButton3'
        ImageIndex = 19
        Style = tbsSeparator
      end
      object TlBtn_Print: TToolButton
        Left = 124
        Top = 0
        Action = Act_Print
      end
      object ToolButton6: TToolButton
        Left = 147
        Top = 0
        Width = 8
        Caption = 'ToolButton6'
        ImageIndex = 12
        Style = tbsSeparator
      end
      object ToolButton4: TToolButton
        Left = 155
        Top = 0
        Action = Act_Quit
      end
    end
  end
  inherited Pnl_Title: TPanel
    Width = 801
    BevelOuter = bvRaised
    Caption = '设计Bom多层展开'
    inherited Image2: TImage
      Left = 1
      Top = 1
      Width = 799
      Height = 25
    end
  end
  inherited Pnl_Head: TPanel
    Width = 801
    BevelOuter = bvSpace
    inherited Image1: TImage
      Left = 1
      Top = 1
      Width = 799
      Height = 30
    end
    object Label1: TLabel
      Left = 16
      Top = 9
      Width = 60
      Height = 12
      Caption = '物料代码：'
    end
    object Label3: TLabel
      Left = 247
      Top = 9
      Width = 60
      Height = 12
      Caption = '物料描述：'
    end
    object Lbl_ItemName: TLabel
      Left = 306
      Top = 9
      Width = 6
      Height = 12
    end
    object Edt_ItemCode: TEdit
      Left = 73
      Top = 4
      Width = 125
      Height = 20
      TabOrder = 0
      OnExit = Edt_ItemCodeExit
    end
  end
  inherited Pnl_Hint: TPanel
    Top = 402
    Width = 801
    BevelOuter = bvRaised
    inherited Image4: TImage
      Left = 1
      Top = 1
      Width = 799
      Height = 24
    end
  end
  inherited Pnl_Body: TPanel
    Width = 801
    Height = 313
    inherited Image3: TImage
      Width = 801
      Height = 313
    end
    object DBGridEh1: TDBGridEh
      Left = 0
      Top = 0
      Width = 801
      Height = 313
      Align = alClient
      DataSource = DataSource1
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      ReadOnly = True
      TabOrder = 0
      TitleFont.ChArset = GB2312_CHArSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -12
      TitleFont.Name = '宋体'
      TitleFont.Style = []
      OnDrawDataCell = DBGridEhDrawDataCell
      OnGetCellParams = DBGridEh1GetCellParams
      Columns = <
        Item
          FieldName = 'ItemCodeName'
          Title.Alignment = taCenter
          Title.Caption = '子项物料标识'
          Width = 293
        end
        Item
          Alignment = taCenter
          FieldName = 'UomCodeName'
          Title.Alignment = taCenter
          Title.Caption = '单位'
          Width = 40
        end
        Item
          FieldName = 'designno'
          Title.Alignment = taCenter
          Title.Caption = '图号'
          Width = 121
        end
        Item
          Alignment = taCenter
          FieldName = 'BomItemType'
          PickList.Strings = (
            '普通物料'
            '工作中心'
            '工具'
            '结构虚项'
            '副产品'
            '成本中心'
            '替代虚项')
          Title.Alignment = taCenter
          Title.Caption = '子项属性'
          Width = 57
          KeyList.Strings = (
            '0'
            '1'
            '2'
            '3'
            '4'
            '5'
            '6')
        end
        Item
          Alignment = tArightJustify
          FieldName = 'BomQty'
          Title.Alignment = taCenter
          Title.Caption = '定额'
          Width = 48
        end
        Item
          Alignment = tArightJustify
          FieldName = 'BomScrAp_Percent'
          Title.Alignment = taCenter
          Title.Caption = '损耗率(%)'
          Width = 59
        end
        Item
          Alignment = taCenter
          FieldName = 'BomStatus'
          PickList.Strings = (
            '生效'
            '未生效'
            '暂定'
            '暂停使用'
            ' ')
          Title.Alignment = taCenter
          Title.Caption = '子项状态'
          Width = 56
          KeyList.Strings = (
            '0'
            '1'
            '2'
            '3')
        end
        Item
          FieldName = 'Material'
          Title.Alignment = taCenter
          Title.Caption = '材质'
        end
        Item
          FieldName = 'DeptCodeName'
          Title.Alignment = taCenter
          Title.Caption = '用料部门标识'
          Width = 92
        end
        Item
          FieldName = 'EmployeeCode'
          Title.Alignment = taCenter
          Title.Caption = '采购员'
          Width = 47
        end
        Item
          FieldName = 'Pla_EmployeeCode'
          Title.Alignment = taCenter
          Title.Caption = '计划员'
          Width = 44
        end
        Item
          Alignment = taCenter
          FieldName = 'ItemUsable'
          PickList.Strings = (
            '是'
            '否')
          Title.Alignment = taCenter
          Title.Caption = '物料生效'
          Width = 56
          KeyList.Strings = (
            '1'
            '0'
            ''
            '')
        end>
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Prepared = True
    Left = 368
    Top = 0
  end
  inherited ActionList: TActionList
    Left = 416
    Top = 0
    inherited Act_Print: TAction
      OnExecute = Act_PrintExecute
    end
    inherited Act_Preview: TAction
      OnExecute = Act_PreviewExecute
    end
    inherited Act_Excel: TAction
      OnExecute = Act_ExcelExecute
    end
    object Action4: TAction
      Caption = 'Action4'
      ShortCut = 120
      OnExecute = Action4Execute
    end
    object Action5: TAction
      Caption = 'Action5'
      ShortCut = 16500
    end
  end
  object AdoQry_Main: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=Mrpii_Puyuan_010207;Data Source=' +
      '192.168.0.151'
    CurSorType = ctStatic
    LockType = ltBatchOptimistic
    AfterOpen = AdoQry_MainAfterOpen
    EnableBCD = False
    Parameters = <>
    Prepared = True
    SQL.Strings = (
      'select designno from Item')
    Left = 330
    Top = 1
  end
  object DataSource1: TDataSource
    DataSet = AdoQry_Main
    Left = 250
    Top = 2
  end
  object ExtPrintReport1: TExtPrintReport
    TopBOrdermm = 20
    BottomBOrdermm = 20
    LeftBOrdermm = 10
    RightBOrdermm = 10
    DataSet = AdoQry_Main
    TitleFont.ChArset = DEFAULT_CHArSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -19
    TitleFont.Name = '宋体'
    TitleFont.Style = [fsBold]
    SubtitleFont.ChArset = DEFAULT_CHArSET
    SubtitleFont.Color = clWindowText
    SubtitleFont.Height = -13
    SubtitleFont.Name = '宋体'
    SubtitleFont.Style = [fsBold]
    ReportFont.ChArset = DEFAULT_CHArSET
    ReportFont.Color = clWindowText
    ReportFont.Height = -13
    ReportFont.Name = '宋体'
    ReportFont.Style = []
    FootFont.ChArset = DEFAULT_CHArSET
    FootFont.Color = clWindowText
    FootFont.Height = -13
    FootFont.Name = '宋体'
    FootFont.Style = [fsBold]
    NeedLine = False
    SumPerPage = True
    SumTotal = True
    PAperSet = [ptA3, ptA4, ptB4, ptB5, ptNArrow, ptWide]
    PAperOrientation = poPortrait
    ShowPrintRange = True
    PAperType = ptA4
    HeaderGroups = <>
    Headers = <>
    Left = 472
  end
end