inv_amountadjust_h.dfm

一个MRPII系统源代码版本

inherited Frm_Inv_AmountAdjust_H: TFrm_Inv_AmountAdjust_H
  Left = 12
  Top = 86
  Caption = ''
  Windowstate = wsMaximized
  PixelsPerInch = 96
  TextHeight = 12
  inherited Pnl_Head: TPanel
    inherited Lbl_Order: TLabel
      Width = 96
      Caption = '仓库代码，单据号'
    end
  end
  inherited Pnl_Body: TPanel
    inherited DBGridEh: TDBGridEh
      Columns = <
        Item
          FieldName = 'WHCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '仓库代码'
          Width = 55
          KeyList.Strings = ()
        end
        Item
          FieldName = 'WHName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '仓库名称'
          Width = 192
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvBillNo'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '单据号'
          Width = 80
          KeyList.Strings = ()
        end
        Item
          FieldName = 'InvBillDate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '单据日期'
          Width = 76
          KeyList.Strings = ()
        end
        Item
          FieldName = 'BillType2Code'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '入库类型代码'
          Width = 86
          KeyList.Strings = ()
        end
        Item
          FieldName = 'BillType2Name'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '入库类型名称'
          KeyList.Strings = ()
        end>
    end
  end
  inherited ActionList: TActionList
    inherited Act_Modify: TAction
      Enabled = False
      Visible = False
    end
    inherited Act_Delete: TAction
      Enabled = False
      Visible = False
    end
  end
  inherited AdoQry_Head: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=mdrcmrm;Data Source=NT2'
    CurSorType = ctStatic
    SQL.Strings = (
      'Select'
      '     InvInBill.WHCode'
      '    ,Warehouse.WHName'
      '    ,InvInBill.InvBillNo'
      '    ,InvInBill.InvBillDate'
      '    ,InvInBill.InvBillRemArk'
      '    ,InvInBill.BillType2Code'
      '    ,BillType2.BillType2Name'
      '     From InvInBill'
      '     Join Warehouse On InvInBill.whCode=Warehouse.WHCode'
      
        '     Join BillType2 On InvInBill.BillType2Code=BillType2.BillTyp' +
        'e2Code')
    object AdoQry_HeadWHCode: TStringField
      FieldName = 'WHCode'
      Origin = 'InvInBill'
      Size = 4
    end
    object AdoQry_HeadWHName: TStringField
      FieldName = 'WHName'
      Origin = 'Warehouse'
      Size = 40
    end
    object AdoQry_HeadInvBillNo: TStringField
      FieldName = 'InvBillNo'
      Origin = 'InvInBill'
      Size = 10
    end
    object AdoQry_HeadInvBillDate: TDateTimeField
      FieldName = 'InvBillDate'
      Origin = 'InvInBill'
    end
    object AdoQry_HeadInvBillRemArk: TStringField
      FieldName = 'InvBillRemArk'
      Origin = 'InvInBill'
      Size = 250
    end
    object AdoQry_HeadBillType2Code: TStringField
      FieldName = 'BillType2Code'
      Origin = 'InvInBill'
      Size = 4
    end
    object AdoQry_HeadBillType2Name: TStringField
      FieldName = 'BillType2Name'
      Origin = 'BillType2'
    end
  end
end