inv_mninaudit_h.dfm

一个MRPII系统源代码版本

inherited Frm_Inv_MnInAudit_H: TFrm_Inv_MnInAudit_H
  Left = -195
  Top = 130
  Caption = '车间生产入库仓库核定'
  PixelsPerInch = 96
  TextHeight = 12
  inherited Pnl_Title: TPanel
    Caption = '车间生产入库仓库核定'
  end
  inherited Pnl_Head: TPanel
    inherited Lbl_Order: TLabel
      Width = 108
      Caption = '仓库、部门、单据号'
    end
  end
  inherited Pnl_Body: TPanel
    inherited DBGridEh: TDBGridEh
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      FrozenCols = 4
      Columns = <
        Item
          FieldName = 'InvBillId'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Visible = False
          KeyList.Strings = ()
        end
        Item
          Alignment = taCenter
          FieldName = 'InvBillTmpFlag'
          PickList.Strings = (
            '已核')
          Title.Alignment = taCenter
          Title.Caption = '核定标志'
          Width = 54
          KeyList.Strings = (
            '1')
        end
        Item
          FieldName = 'WHCodeName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '仓库'
          Width = 99
          KeyList.Strings = ()
        end
        Item
          FieldName = 'WhPosition'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '货位'
          Width = 118
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DeptFlag'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '部门标识'
          Width = 131
          KeyList.Strings = ()
        end
        Item
          FieldName = 'ShiftType'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '班别'
          Width = 53
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvBillNo'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '单据号'
          Width = 85
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvBillDate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '日期'
          Width = 78
          KeyList.Strings = ()
        end
        Item
          FieldName = 'MONo'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '生产订单号'
          Width = 86
          KeyList.Strings = ()
        end
        Item
          Alignment = taCenter
          FieldName = 'OverPlan'
          PickList.Strings = (
            '否'
            '是')
          Title.Alignment = taCenter
          Title.Caption = '超订单'
          Width = 47
          KeyList.Strings = (
            '0'
            '1')
        end>
    end
  end
  inherited AdoQry_Head: TAdoQuery
    SQL.Strings = (
      'select I.InvBillId,I.InvBillTmpFlag,I.ShiftType,'
      
        '       I.WHCode+'#39' '#39'+Warehouse.WhName as WHCodeName,I.whCode,I.de' +
        'ptCode,'
      '       I.DeptCode+'#39' '#39'+D.DeptName DeptFlag,'
      
        '       I.WhPositionCode+'#39' '#39'+WhPosition.WhPositionName As WHPosit' +
        'ion,'
      '       I.InvBillNo,I.InvBillDate,I.MONo,I.OverPlan'
      '  from  InvInBill I'
      '  Join Warehouse'
      '    on I.WHCode=Warehouse.WHCode'
      '  Join WhPosition'
      '    on WhPosition.WhPositionCode=I.WhPositionCode'
      '  Left Join Dept D'
      '    on I.DeptCode=D.DeptCode'
      ''
      '')
    object AdoQry_HeadInvBillId: TBCDField
      FieldName = 'InvBillId'
      ReadOnly = True
      Precision = 18
      Size = 0
    end
    object AdoQry_HeadInvBillTmpFlag: TIntegerField
      FieldName = 'InvBillTmpFlag'
      Origin = 'I'
    end
    object AdoQry_HeadWHCodeName: TStringField
      FieldName = 'WHCodeName'
      ReadOnly = True
      Size = 45
    end
    object AdoQry_HeadInvBillNo: TStringField
      FieldName = 'InvBillNo'
      Origin = 'I'
      Size = 10
    end
    object AdoQry_HeadInvBillDate: TDateTimeField
      FieldName = 'InvBillDate'
      Origin = 'I'
    end
    object AdoQry_HeadMONo: TStringField
      FieldName = 'MONo'
      Origin = 'I'
      Size = 16
    end
    object AdoQry_HeadOverPlan: TIntegerField
      FieldName = 'OverPlan'
    end
    object AdoQry_HeadWhPosition: TStringField
      FieldName = 'WhPosition'
      ReadOnly = True
      Size = 45
    end
    object AdoQry_HeadwhCode: TStringField
      FieldName = 'whCode'
      Size = 4
    end
    object AdoQry_HeadDeptCode: TStringField
      FieldName = 'DeptCode'
      Size = 8
    end
    object AdoQry_HeadDeptFlag: TStringField
      FieldName = 'DeptFlag'
      ReadOnly = True
      Size = 49
    end
    object AdoQry_HeadShiftType: TStringField
      FieldName = 'ShiftType'
    end
  end
end