pm_pobalance_h.dfm

一个MRPII系统源代码版本

inherited Frm_Pm_PoBalance_H: TFrm_Pm_PoBalance_H
  Left = 13
  Top = 44
  Caption = ''
  PixelsPerInch = 96
  TextHeight = 12
  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]
      Columns = <
        Item
          FieldName = 'PoTmpFlag'
          PickList.Strings = (
            '是'
            '否')
          Title.Alignment = taCenter
          Title.Caption = '结算标志'
          KeyList.Strings = (
            '1'
            '0')
        end
        Item
          FieldName = 'PoNo'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '采购订单号'
          Width = 80
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PoType'
          PickList.Strings = (
            '0-普通采购'
            '1-委外加工'
            '2-进口采购')
          Title.Alignment = taCenter
          Title.Caption = '订单类型'
          Width = 80
          KeyList.Strings = (
            '0'
            '1'
            '2')
        end
        Item
          FieldName = 'VendorCode'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '供应商代码'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'VendorName'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '供应商名称'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'PoDate'
          PickList.Strings = ()
          Title.Alignment = taCenter
          Title.Caption = '下达日期'
          KeyList.Strings = ()
        end>
    end
  end
  inherited AdoQry_Head: 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'
    SQL.Strings = (
      
        '   select Po.PoTmpFlag,Po.PoNo,Po.PoType,Po.VendorCode,V.VendorN' +
        'ame,Po.PoDate from po'
      '      left Join Vendor V on '
      '        Po.VendorCode=V.VendorCode,'#9
      '      (select pono,Count(*) CloselineCount'
      '         from poline'
      '         where polinestatus=7'
      '         group by pono) cpl,'
      '      (select pono,Count(*) lineCount'
      '         from poline'
      '         where pono in '
      '           (select pono'
      '              from poline'
      '              where polinestatus=7'
      '              group by pono)'
      '         group by poNo) pl   '
      'Where  pl.pono=cpl.pono and pl.lineCount=cpl.CloselineCount and'
      '            po.pono=cpl.pono   ')
    object AdoQry_HeadPoTmpFlag: TIntegerField
      FieldName = 'PoTmpFlag'
      Origin = 'PO'
    end
    object AdoQry_HeadPoNo: TStringField
      FieldName = 'PoNo'
      Origin = 'PO'
      Size = 16
    end
    object AdoQry_HeadVendorCode: TStringField
      FieldName = 'VendorCode'
      Origin = 'PO'
      Size = 12
    end
    object AdoQry_HeadVendorName: TStringField
      FieldName = 'VendorName'
      Origin = 'V'
      Size = 60
    end
    object AdoQry_HeadPoDate: TDateTimeField
      FieldName = 'PoDate'
      Origin = 'PO'
    end
    object AdoQry_HeadPoType: TIntegerField
      FieldName = 'PoType'
    end
  end
end