ar_qry_ar3.dfm

一个MRPII系统源代码版本

inherited Frm_Ar_Qry_Ar3: TFrm_Ar_Qry_Ar3
  Left = 204
  Top = 134
  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 = 192
      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 = 'SaleEmployeeCode'
          PickList.Strings = ()
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'EmployeeName'
          PickList.Strings = ()
          Visible = False
          KeyList.Strings = ()
        end
        Item
          FieldName = 'Employeeflag'
          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 = 'Balance'
          PickList.Strings = ()
          Title.Caption = '未核销金额'
          Width = 83
          KeyList.Strings = ()
        end
        Item
          FieldName = 'TotalTaxAmountC'
          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.SaleEmployeeCode,'
      '       Employee.EmployeeName,'
      
        '       sa_SaleInvoice.SaleEmployeeCode+'#39' '#39'+Employee.EmployeeName' +
        ' as Employeeflag,'
      '      convert(varchAr, sa_SaleInvoice.Createdate) as createdate,'
      '       sa_SaleInvoice.Invoiceno,'
      '       sa_SaleInvoice.TotaltaxAmount,'
      
        '       sa_SaleInvoice.TotaltaxAmount-sa_SaleInvoice.CancelAmount' +
        ' as Balance,'
      '       sa_SaleInvoice.TotalTaxAmountC,'
      
        '       Sa_SaleInvoice.TotalTaxAmountC-Sa_SaleInvoice.CancelAmoun' +
        'tC as BalanceC,'
      '       sa_SaleInvoice.currencyCode,'
      '       currency.currencyName,'
      
        '       sa_SaleInvoice.currencyCode+'#39' '#39'+currency.currencyName as ' +
        'currencyflag'
      'from  sa_SaleInvoice'
      
        'left join Employee on sa_SaleInvoice.SaleEmployeeCode=Employee.e' +
        'mployeeCode'
      
        'left join currency on sa_SaleInvoice.currencyCode=currency.curre' +
        'ncyCode')
    Left = 224
    Top = 217
    object AdoQry_MainInvoiceno: TStringField
      DisplayLabel = '发票单号'
      FieldName = 'Invoiceno'
      Origin = '#Ar3Qry'
      Size = 16
    end
    object AdoQry_MainTotaltaxAmount: TFloatField
      DisplayLabel = '应收帐款'
      FieldName = 'TotaltaxAmount'
      Origin = '#Ar3Qry'
    end
    object AdoQry_MainBalance: TFloatField
      DisplayLabel = '应收帐款余额'
      FieldName = 'Balance'
      Origin = '#Ar3Qry'
      ReadOnly = True
    end
    object AdoQry_MaincurrencyCode: TStringField
      DisplayLabel = '货币代码'
      FieldName = 'currencyCode'
      Origin = '#Ar3Qry'
      Size = 2
    end
    object AdoQry_MaincurrencyName: TStringField
      DisplayLabel = '货币名称'
      FieldName = 'currencyName'
      Origin = '#Ar3Qry'
      Size = 30
    end
    object AdoQry_Maincurrencyflag: TStringField
      DisplayLabel = '货币标识'
      FieldName = 'currencyflag'
      Origin = '#Ar3Qry'
      ReadOnly = True
      Size = 33
    end
    object AdoQry_Maincreatedate: TStringField
      DisplayLabel = '发票日期'
      FieldName = 'createdate'
      Origin = '#Ar3Qry'
      ReadOnly = True
      Size = 30
    end
    object AdoQry_MainSaleEmployeeCode: TStringField
      DisplayLabel = '营销业务员代码'
      FieldName = 'SaleEmployeeCode'
      Origin = '#Ar3Qry'
      Size = 30
    end
    object AdoQry_MainEmployeeName: TStringField
      DisplayLabel = '营销业务员名称'
      FieldName = 'EmployeeName'
      Origin = '#Ar3Qry'
      Size = 60
    end
    object AdoQry_MainEmployeeflag: TStringField
      DisplayLabel = '营销业务员标识'
      FieldName = 'Employeeflag'
      Origin = '#Ar3Qry'
      ReadOnly = True
      Size = 91
    end
    object AdoQry_Mainflag: TIntegerField
      FieldName = 'flag'
      ReadOnly = True
    end
    object AdoQry_MainTotalTaxAmountC: TFloatField
      DisplayLabel = '本位币发票金额'
      FieldName = 'TotalTaxAmountC'
      Origin = '#Ar3Qry'
    end
    object AdoQry_MainBalanceC: TFloatField
      DisplayLabel = '本位币未核销金额'
      FieldName = 'BalanceC'
      Origin = '#Ar3Qry'
      ReadOnly = True
    end
  end
  inherited DataSource: TDataSource
    Left = 336
    Top = 201
  end
end