inv_amountoutadjust_h.dfm

一个MRPII系统源代码版本

inherited Frm_Inv_AmountOutAdjust_H: TFrm_Inv_AmountOutAdjust_H
  Left = 4
  Top = 61
  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
        Item
          FieldName = 'DeptCode'
          PickList.Strings = ()
          Title.Caption = '部门代码'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DeptName'
          PickList.Strings = ()
          Title.Caption = '部门名称'
          Width = 76
          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=ZHENGJIArONG'
    CurSorType = ctStatic
    SQL.Strings = (
      'Select'
      '     InvOutBill.WHCode'
      '    ,Warehouse.WHName'
      '    ,InvOutBill.InvBillNo'
      '    ,InvOutBill.InvBillDate'
      '    ,InvOutBill.InvBillRemArk'
      '    ,InvOutBill.BillType2Code'
      ',InvOutBill.DeptCode'
      ',Dept.DeptName as DeptName'
      '    ,BillType2.BillType2Name'
      '     From InvOutBill'
      '          left join Dept on InvOutBill.DeptCode=Dept.DeptCode'
      '     Join Warehouse On InvOutBill.whCode=Warehouse.WHCode'
      
        '     Join BillType2 On InvOutBill.BillType2Code=BillType2.BillTy' +
        'pe2Code')
    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
    object AdoQry_HeadDeptCode: TStringField
      FieldName = 'DeptCode'
      Size = 8
    end
    object AdoQry_HeadDeptName: TStringField
      FieldName = 'DeptName'
      ReadOnly = True
      Size = 49
    end
  end
end