ar_qry_araging5.dfm

一个MRPII系统源代码版本

inherited Frm_Ar_Qry_ArAging5: TFrm_Ar_Qry_ArAging5
  Left = 239
  Top = 150
  Caption = '应收帐龄分析'
  PixelsPerInch = 96
  TextHeight = 12
  inherited Pnl_Title: TPanel
    Caption = '按营销业务员'
  end
  inherited Pnl_Head: TPanel
    Height = 63
    inherited Lbl_OrderTitle: TLabel
      Top = 46
    end
    inherited Lbl_ConditionTitle: TLabel
      Top = 2
    end
    inherited Lbl_Condition: TLabel
      Top = 2
    end
    inherited Lbl_Order: TLabel
      Top = 46
      Width = 84
      Caption = '营销业务员代码'
    end
  end
  inherited Pnl_Body: TPanel
    Top = 120
    Height = 283
    inherited DBGridEh: TDBGridEh
      Height = 283
    end
  end
  inherited AdoQry_Tmp: TAdoQuery
    Left = 317
  end
  inherited ActionList: TActionList
    Left = 184
    Top = 200
  end
  inherited AdoQry_Main: TAdoQuery
    ConnectionString = 
      'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
      'User ID=mdrcmrm;Initial Catalog=mdysjmrm;Data Source=192.168.0.1' +
      '51;Use procedure for Prepare=1;Auto Translate=True;Packet Size=4' +
      '096;Workstation ID=XYB'
    SQL.Strings = (
      'select flag=0,'
      '       sa_SaleInvoice.SaleDeptCode,'
      '       Dept.DeptName,'
      
        '       sa_SaleInvoice.SaleDeptCode+'#39' '#39'+Dept.DeptName as Deptflag' +
        ','
      '      convert(varchAr, sa_SaleInvoice.Createdate) as createdate,'
      '       sa_SaleInvoice.Invoiceno,'
      '       sa_SaleInvoice.TotaltaxAmount,'
      '       tmp.TotalAmount,'
      
        '       sa_SaleInvoice.TotaltaxAmount-sa_SaleInvoice.CancelAmount' +
        ' as Balance,'
      '       sa_SaleInvoice.currencyCode,'
      '       currency.currencyName,'
      
        '       sa_SaleInvoice.currencyCode+'#39' '#39'+currency.currencyName as ' +
        'currencyflag'
      'from  sa_SaleInvoice'
      'left join Dept on sa_SaleInvoice.SaleDeptCode=Dept.DeptCode'
      
        'left join currency on sa_SaleInvoice.currencyCode=currency.curre' +
        'ncyCode'
      
        'left join (select Billno,sum(isnull(TotalAmount,0)) as Totalamou' +
        'nt from Ar_Gatheringline group by Billno) tmp'
      'on sa_SaleInvoice.Invoiceno=tmp.Billno')
    Left = 224
    Top = 217
  end
  inherited DataSource: TDataSource
    Left = 336
    Top = 201
  end
end