ar_qry_gatheringar3.dfm

一个MRPII系统源代码版本

inherited Frm_Ar_Qry_GatheringAr3: TFrm_Ar_Qry_GatheringAr3
  Left = 144
  Top = 106
  Caption = '收款票据--应收帐款对比分析'
  PixelsPerInch = 96
  TextHeight = 12
  inherited Pnl_Title: TPanel
    Caption = '按销售部门'
  end
  inherited Pnl_Head: TPanel
    Height = 63
    inherited Image1: TImage
      Height = 63
    end
    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 = 180
      Caption = '销售部门代码/发票日期/发票单号'
    end
  end
  inherited Pnl_Body: TPanel
    Top = 120
    Height = 283
    inherited Image3: TImage
      Height = 283
    end
    inherited DBGridEh: TDBGridEh
      Height = 283
      FrozenCols = 2
      Columns = <
        Item
          FieldName = 'SaleDeptCode'
          PickList.Strings = ()
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'DeptName'
          PickList.Strings = ()
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Deptflag'
          PickList.Strings = ()
          Width = 150
          KeyList.Strings = ()
        end
        Item
          FieldName = 'createdate'
          PickList.Strings = ()
          Width = 70
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Invoiceno'
          PickList.Strings = ()
          Width = 78
          KeyList.Strings = ()
        end
        Item
          FieldName = 'currencyCode'
          PickList.Strings = ()
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'currencyName'
          PickList.Strings = ()
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'currencyflag'
          PickList.Strings = ()
          Width = 65
          KeyList.Strings = ()
        end
        Item
          FieldName = 'TotaltaxAmount'
          PickList.Strings = ()
          Title.Caption = '发票金额'
          KeyList.Strings = ()
        end
        Item
          FieldName = 'TotalAmount'
          PickList.Strings = ()
          Width = 82
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Balance'
          PickList.Strings = ()
          Title.Caption = '未核销金额'
          Width = 83
          KeyList.Strings = ()
        end
        Item
          FieldName = 'TotalTaxAmountC'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'TotalAmountC'
          PickList.Strings = ()
          KeyList.Strings = ()
        end
        Item
          FieldName = 'BalanceC'
          PickList.Strings = ()
          KeyList.Strings = ()
        end>
    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=Mrpii_Standard;Data Source=192.1' +
      '68.0.100;Use procedure for Prepare=1;Auto Translate=True;Packet ' +
      'Size=4096;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,'
      '       0.0 as TotalTaxAmountC,'
      '       0.0 as TotalAmountC,'
      '       0.0 as BalanceC,'
      '       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 = 248
    Top = 241
    object AdoQry_MainSaleDeptCode: TStringField
      DisplayLabel = '销售部门代码'
      FieldName = 'SaleDeptCode'
      Origin = '#ArQry_gather3'
      Size = 8
    end
    object AdoQry_MainDeptName: TStringField
      DisplayLabel = '销售部门名称'
      FieldName = 'DeptName'
      Origin = '#ArQry_gather3'
      Size = 40
    end
    object AdoQry_MainDeptflag: TStringField
      DisplayLabel = '销售部门标识'
      FieldName = 'Deptflag'
      Origin = '#ArQry_gather3'
      ReadOnly = True
      Size = 49
    end
    object AdoQry_MainInvoiceno: TStringField
      DisplayLabel = '发票单号'
      FieldName = 'Invoiceno'
      Origin = '#ArQry_gather3'
      Size = 16
    end
    object AdoQry_MainTotaltaxAmount: TFloatField
      DisplayLabel = '应收帐款'
      FieldName = 'TotaltaxAmount'
      Origin = '#ArQry_gather3'
    end
    object AdoQry_MainBalance: TFloatField
      DisplayLabel = '应收帐款余额'
      FieldName = 'Balance'
      Origin = '#ArQry_gather3'
      ReadOnly = True
    end
    object AdoQry_MaincurrencyCode: TStringField
      DisplayLabel = '货币代码'
      FieldName = 'currencyCode'
      Origin = '#ArQry_gather3'
      Size = 2
    end
    object AdoQry_MaincurrencyName: TStringField
      DisplayLabel = '货币名称'
      FieldName = 'currencyName'
      Origin = '#ArQry_gather3'
      Size = 30
    end
    object AdoQry_Maincurrencyflag: TStringField
      DisplayLabel = '货币标识'
      FieldName = 'currencyflag'
      Origin = '#ArQry_gather3'
      ReadOnly = True
      Size = 33
    end
    object AdoQry_Maincreatedate: TStringField
      DisplayLabel = '发票日期'
      FieldName = 'createdate'
      Origin = '#ArQry_gather3'
      ReadOnly = True
      Size = 30
    end
    object AdoQry_Mainflag: TIntegerField
      FieldName = 'flag'
      ReadOnly = True
    end
    object AdoQry_MainTotalAmount: TFloatField
      DisplayLabel = '收款票据金额'
      FieldName = 'TotalAmount'
      Origin = '#ArQry_gather3'
    end
    object AdoQry_MainTotalTaxAmountC: TFloatField
      DisplayLabel = '本位币发票金额'
      FieldName = 'TotalTaxAmountC'
      Origin = '#ArQry_gather3'
      ReadOnly = True
    end
    object AdoQry_MainTotalAmountC: TFloatField
      DisplayLabel = '本位币收款票据金额'
      FieldName = 'TotalAmountC'
      Origin = '#ArQry_gather3'
      ReadOnly = True
    end
    object AdoQry_MainBalanceC: TFloatField
      DisplayLabel = '本位币未核销金额'
      FieldName = 'BalanceC'
      Origin = '#ArQry_gather3'
      ReadOnly = True
    end
  end
  inherited DataSource: TDataSource
    Left = 336
    Top = 201
  end
end