unit1.dfm

《Delphi7编程100例》代码,书配资料

object Form1: TForm1
  Left = 238
  Top = 143
  Width = 498
  Height = 329
  Caption = 'Form1'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  PixelsPerInch = 96
  TextHeight = 13
  object Label1: TLabel
    Left = 269
    Top = 242
    Width = 47
    Height = 13
    Caption = 'OderTotal'
  end
  object Label2: TLabel
    Left = 117
    Top = 274
    Width = 110
    Height = 13
    Caption = 'OrderTotal Per ShipVIA'
  end
  object DBNavigator1: TDBNavigator
    Left = 5
    Top = 7
    Width = 300
    Height = 25
    DataSource = CustOrdersDataSource
    TabOrder = 0
  end
  object DBNavigator2: TDBNavigator
    Left = 13
    Top = 82
    Width = 310
    Height = 25
    DataSource = OrderDSDataSource
    TabOrder = 1
  end
  object DBEdit1: TDBEdit
    Left = 5
    Top = 47
    Width = 121
    Height = 21
    DataField = 'Company'
    DataSource = CustOrdersDataSource
    TabOrder = 2
  end
  object DBGrid1: TDBGrid
    Left = 5
    Top = 114
    Width = 481
    Height = 120
    DataSource = OrderDSDataSource
    TabOrder = 3
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
  end
  object DBEdit2: TDBEdit
    Left = 365
    Top = 234
    Width = 121
    Height = 21
    DataField = 'TotalPerCustomer'
    DataSource = OrderDSDataSource
    TabOrder = 4
  end
  object DBEdit3: TDBEdit
    Left = 365
    Top = 266
    Width = 121
    Height = 21
    DataField = 'TotalPerShipMethod'
    DataSource = OrderDSDataSource
    TabOrder = 5
  end
  object DBTextShipMethod: TDBEdit
    Left = 237
    Top = 266
    Width = 121
    Height = 21
    DataSource = OrderDSDataSource
    TabOrder = 6
  end
  object Button1: TButton
    Left = 365
    Top = 7
    Width = 75
    Height = 25
    Caption = 'Open'
    TabOrder = 7
    OnClick = Button1Click
  end
  object Button2: TButton
    Left = 357
    Top = 82
    Width = 97
    Height = 25
    Caption = 'GroupByShipVIA'
    TabOrder = 8
    OnClick = Button2Click
  end
  object CustDataSource: TDataSource
    DataSet = CustQuery
    Left = 85
    Top = 159
  end
  object CustOrders: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DataSetProvider1'
    Left = 205
    Top = 159
    object CustOrdersCustNo: TFloatField
      FieldName = 'CustNo'
    end
    object CustOrdersCompany: TStringField
      FieldName = 'Company'
      Size = 30
    end
    object CustOrdersAddr1: TStringField
      FieldName = 'Addr1'
      Size = 30
    end
    object CustOrdersAddr2: TStringField
      FieldName = 'Addr2'
      Size = 30
    end
    object CustOrdersCity: TStringField
      FieldName = 'City'
      Size = 15
    end
    object CustOrdersState: TStringField
      FieldName = 'State'
    end
    object CustOrdersZip: TStringField
      FieldName = 'Zip'
      Size = 10
    end
    object CustOrdersCountry: TStringField
      FieldName = 'Country'
    end
    object CustOrdersPhone: TStringField
      FieldName = 'Phone'
      Size = 15
    end
    object CustOrdersFAX: TStringField
      FieldName = 'FAX'
      Size = 15
    end
    object CustOrdersTaxRate: TFloatField
      FieldName = 'TaxRate'
    end
    object CustOrdersContact: TStringField
      FieldName = 'Contact'
    end
    object CustOrdersOrderQuery: TDataSetField
      FieldName = 'OrderQuery'
    end
    object CustOrdersLastInvoiceDate: TDateTimeField
      FieldName = 'LastInvoiceDate'
    end
  end
  object OrderDS: TClientDataSet
    Aggregates = <>
    AggregatesActive = True
    DataSetField = CustOrdersOrderQuery
    FieldDefs = <
      item
        Name = 'OrderNo'
        DataType = ftFloat
      end
      item
        Name = 'CustNo'
        DataType = ftFloat
      end
      item
        Name = 'SaleDate'
        DataType = ftDateTime
      end
      item
        Name = 'ShipDate'
        DataType = ftDateTime
      end
      item
        Name = 'EmpNo'
        DataType = ftInteger
      end
      item
        Name = 'ShipToContact'
        DataType = ftString
        Size = 20
      end
      item
        Name = 'ShipToAddr1'
        DataType = ftString
        Size = 30
      end
      item
        Name = 'ShipToAddr2'
        DataType = ftString
        Size = 30
      end
      item
        Name = 'ShipToCity'
        DataType = ftString
        Size = 15
      end
      item
        Name = 'ShipToState'
        DataType = ftString
        Size = 20
      end
      item
        Name = 'ShipToZip'
        DataType = ftString
        Size = 10
      end
      item
        Name = 'ShipToCountry'
        DataType = ftString
        Size = 20
      end
      item
        Name = 'ShipToPhone'
        DataType = ftString
        Size = 15
      end
      item
        Name = 'ShipVIA'
        DataType = ftString
        Size = 7
      end
      item
        Name = 'PO'
        DataType = ftString
        Size = 15
      end
      item
        Name = 'Terms'
        DataType = ftString
        Size = 6
      end
      item
        Name = 'PaymentMethod'
        DataType = ftString
        Size = 7
      end
      item
        Name = 'ItemsTotal'
        DataType = ftCurrency
      end
      item
        Name = 'TaxRate'
        DataType = ftFloat
      end
      item
        Name = 'Freight'
        DataType = ftCurrency
      end
      item
        Name = 'AmountPaid'
        DataType = ftCurrency
      end>
    IndexDefs = <
      item
        Name = 'ShipVIA'
      end>
    Params = <>
    StoreDefs = True
    Left = 237
    Top = 159
    object OrderDSTotalPerCustomer: TAggregateField
      FieldName = 'TotalPerCustomer'
      Active = True
      Expression = 'sum( ItemsTotal )'
    end
    object OrderDSTotalPerShipMethod: TAggregateField
      FieldName = 'TotalPerShipMethod'
      Active = True
      Expression = 'sum( ItemsTotal )'
      GroupingLevel = 1
      IndexName = 'ShipVIA'
    end
  end
  object CustOrdersDataSource: TDataSource
    DataSet = CustOrders
    Left = 269
    Top = 159
  end
  object OrderDSDataSource: TDataSource
    DataSet = OrderDS
    Left = 301
    Top = 159
  end
  object DataSetProvider1: TDataSetProvider
    DataSet = CustQuery
    Left = 173
    Top = 159
  end
  object CustQuery: TQuery
    Active = True
    DatabaseName = 'DBDEMOS'
    SQL.Strings = (
      'select * from customer'
      'where CustNo < 1500 ')
    Left = 117
    Top = 159
  end
  object OrderQuery: TQuery
    DatabaseName = 'DBDEMOS'
    DataSource = CustDataSource
    SQL.Strings = (
      'select * from orders'
      'where CustNo = :CustNo')
    Left = 149
    Top = 159
    ParamData = <
      item
        DataType = ftInteger
        Name = 'CustNo'
        ParamType = ptUnknown
        Size = 8
      end>
  end
end