dailystorefindfrm.~dfm

相关的销售服务管理行业的一个软件

inherited DailyStoreFindForm: TDailyStoreFindForm
  Left = 1
  Top = 1
  Width = 798
  Height = 470
  Caption = '分销店查询'
  OnDestroy = FormDestroy
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 12
  inherited Panel1: TPanel
    Width = 790
    inherited Image1: TImage
      Width = 790
    end
  end
  inherited Panel2: TPanel
    Width = 790
    inherited Label2: TLabel
      Left = 17
      Top = 23
    end
    inherited Label3: TLabel
      Left = 185
      Top = 23
    end
    object Label4: TLabel [2]
      Left = 365
      Top = 23
      Width = 60
      Height = 12
      Caption = '分销店名称'
    end
    inherited DTPBegin: TDateTimePicker
      Left = 69
      Top = 19
    end
    inherited DTPEnd: TDateTimePicker
      Left = 237
      Top = 19
    end
    object cbStoreName: TComboBox
      Left = 437
      Top = 19
      Width = 145
      Height = 20
      ItemHeight = 12
      TabOrder = 6
      Text = 'cbStoreName'
    end
  end
  inherited Panel3: TPanel
    Width = 790
    Height = 346
    inherited LCount: TLabel
      Width = 778
    end
    inherited DBGridEh1: TDBGridEh
      Width = 778
      Height = 322
      FooterRowCount = 1
      FooterColor = clInfoBk
    end
  end
  inherited ActionList1: TActionList
    Left = 512
    inherited APrint: TAction
      OnExecute = APrintExecute
    end
    inherited AReview: TAction
      OnExecute = AReviewExecute
    end
  end
  inherited ADOQuery1: TADOQuery
    CursorType = ctStatic
    SQL.Strings = (
      ''
      
        'SELECT  xs_DailyMaster.DailyCode AS 日报编号,                  '#39 +
        ');'
      'xs_store.storeName AS 分销店名称,                '
      'xs_DailyMaster.DateTime AS 上报时间,                '
      'Sum(xs_DailyDetail.Total)  AS 总数量,               '
      'Sum(xs_DailyDetail.Amount) AS 总金额,               '
      'xs_DailyMaster.InputPerson AS 录入人,             '
      'xs_DailyMaster.memo AS 备注                       '
      
        'FROM xs_DailyMaster Left outer join                            '#39 +
        ');'
      'xs_store on xs_dailyMaster.storecode = xs_store.storecode '
      'join xs_dailyDetail                                       '
      'on xs_dailyMaster.DailyCode = xs_dailyDetail.DailyCode   '
      ''
      'GROUP BY xs_DailyMaster.DailyCode,xs_store.storeName,       '
      'xs_DailyMaster.DateTime,xs_DailyMaster.InputPerson,   '
      'xs_DailyMaster.memo                                  ')
    Top = 137
    object ADOQuery1DSDesigner: TWideStringField
      FieldName = '日报编号'
      Size = 50
    end
    object ADOQuery1DSDesigner2: TWideStringField
      FieldName = '分销店名称'
      Size = 50
    end
    object ADOQuery1DSDesigner3: TDateTimeField
      FieldName = '上报时间'
    end
    object ADOQuery1DSDesigner4: TFloatField
      FieldName = '总数量'
      DisplayFormat = '#0 双'
    end
    object ADOQuery1DSDesigner5: TFloatField
      FieldName = '总金额'
      DisplayFormat = '￥ #0.00'
    end
  end
  inherited DataSource1: TDataSource
    Top = 137
  end
  object ADOQuery2: TADOQuery
    Connection = DM.ADOConnection
    Parameters = <>
    Left = 472
    Top = 41
  end
end