findtypefrm.dfm

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

object FindTypeForm: TFindTypeForm
  Left = 36
  Top = 52
  Width = 748
  Height = 457
  Caption = '销售统计'
  Color = clBtnFace
  Font.Charset = GB2312_CHARSET
  Font.Color = clWindowText
  Font.Height = -12
  Font.Name = '宋体'
  Font.Style = []
  FormStyle = fsMDIChild
  OldCreateOrder = False
  Position = poDefault
  Visible = True
  WindowState = wsMaximized
  OnActivate = FormActivate
  OnClose = FormClose
  OnCreate = FormCreate
  OnDestroy = FormDestroy
  PixelsPerInch = 96
  TextHeight = 12
  object Panel3: TPanel
    Left = 0
    Top = 47
    Width = 740
    Height = 383
    Align = alClient
    BorderWidth = 5
    Caption = 'Panel3'
    TabOrder = 0
    object DBGridEh1: TDBGridEh
      Left = 6
      Top = 6
      Width = 728
      Height = 371
      Align = alClient
      DataSource = DataSource1
      Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
      TabOrder = 0
      TitleFont.Charset = GB2312_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -12
      TitleFont.Name = '宋体'
      TitleFont.Style = []
      FooterRowCount = 1
      FooterFont.Charset = GB2312_CHARSET
      FooterFont.Color = clWindowText
      FooterFont.Height = -12
      FooterFont.Name = '宋体'
      FooterFont.Style = []
      FooterColor = clBackground
      SumList.Active = True
      OptionsEh = [dghFixed3D, dghHighlightFocus, dghClearSelection, dghAutoSortMarking, dghMultiSortMarking]
      OnTitleBtnClick = DBGridEh1TitleBtnClick
      OnSortMarkingChanged = DBGridEh1SortMarkingChanged
      Columns = <
        item
          Alignment = taCenter
          FieldName = '日报编号'
          Title.Alignment = taCenter
          Title.TitleButton = True
          Width = 123
          Footer.Font.Charset = DEFAULT_CHARSET
          Footer.Font.Color = clWindow
          Footer.Font.Height = -11
          Footer.Font.Name = 'MS Sans Serif'
          Footer.Font.Style = []
          Footer.ValueType = fvtStaticText
          Footer.Value = '合计：'
          Footers = <>
        end
        item
          Alignment = taCenter
          FieldName = '分销店名称'
          Title.Alignment = taCenter
          Title.TitleButton = True
          Width = 149
          Footers = <>
        end
        item
          Alignment = taCenter
          FieldName = '分销店类型'
          Title.Alignment = taCenter
          Title.TitleButton = True
          Width = 100
          Footers = <>
        end
        item
          Alignment = taCenter
          FieldName = '上报时间'
          Title.Alignment = taCenter
          Title.TitleButton = True
          Width = 144
          Footers = <>
        end
        item
          Alignment = taCenter
          FieldName = '总数量'
          Title.Alignment = taCenter
          Title.TitleButton = True
          Width = 95
          Footer.Font.Charset = DEFAULT_CHARSET
          Footer.Font.Color = clWindow
          Footer.Font.Height = -11
          Footer.Font.Name = 'MS Sans Serif'
          Footer.Font.Style = []
          Footer.ValueType = fvtSum
          Footer.FieldName = '总数量'
          Footers = <>
        end
        item
          Alignment = taCenter
          FieldName = '总金额'
          Title.Alignment = taCenter
          Title.TitleButton = True
          Width = 69
          Footer.Font.Charset = DEFAULT_CHARSET
          Footer.Font.Color = clWindow
          Footer.Font.Height = -11
          Footer.Font.Name = 'MS Sans Serif'
          Footer.Font.Style = []
          Footer.ValueType = fvtSum
          Footer.FieldName = '总金额'
          Footers = <>
        end
        item
          Alignment = taCenter
          FieldName = '录入人'
          Title.Alignment = taCenter
          Width = 117
          Footers = <>
        end>
    end
  end
  object Panel1: TPanel
    Left = 0
    Top = 0
    Width = 740
    Height = 47
    Align = alTop
    TabOrder = 1
    object Label1: TLabel
      Left = 24
      Top = 19
      Width = 48
      Height = 12
      Caption = '开始时间'
    end
    object Label2: TLabel
      Left = 216
      Top = 19
      Width = 48
      Height = 12
      Caption = '结束时间'
    end
    object Label3: TLabel
      Left = 416
      Top = 19
      Width = 48
      Height = 12
      Caption = '分店类型'
    end
    object DTPBegin: TDateTimePicker
      Left = 78
      Top = 16
      Width = 96
      Height = 20
      CalAlignment = dtaLeft
      Date = 37100.4432231366
      Time = 37100.4432231366
      DateFormat = dfShort
      DateMode = dmComboBox
      Kind = dtkDate
      ParseInput = False
      TabOrder = 0
      OnCloseUp = DTPBeginCloseUp
      OnChange = DTPBeginChange
    end
    object DTPEnd: TDateTimePicker
      Left = 270
      Top = 16
      Width = 96
      Height = 20
      CalAlignment = dtaLeft
      Date = 37253.4432859491
      Time = 37253.4432859491
      DateFormat = dfShort
      DateMode = dmComboBox
      Kind = dtkDate
      ParseInput = False
      TabOrder = 1
      OnCloseUp = DTPEndCloseUp
      OnChange = DTPEndChange
    end
    object ComboBox1: TComboBox
      Left = 472
      Top = 16
      Width = 112
      Height = 20
      Style = csDropDownList
      ItemHeight = 12
      TabOrder = 2
      Items.Strings = (
        '自销'
        '代理')
    end
    object BitBtn1: TBitBtn
      Left = 648
      Top = 4
      Width = 40
      Height = 40
      Caption = '查询'
      TabOrder = 3
      OnClick = BitBtn1Click
      Glyph.Data = {
        76010000424D7601000000000000760000002800000020000000100000000100
        04000000000000010000120B0000120B00001000000000000000000000000000
        800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
        333333333333333333333333333333333333333333FFFFF3333333333CCCCC33
        33333FFFF77777FFFFFFCCCCCC808CCCCCC377777737F777777F008888070888
        8003773FFF7773FFF77F0F0770F7F0770F037F777737F777737F70FFFFF7FFFF
        F07373F3FFF7F3FFF37F70F000F7F000F07337F77737F777373330FFFFF7FFFF
        F03337FF3FF7F3FF37F3370F00F7F00F0733373F7737F77337F3370FFFF7FFFF
        0733337F33373F337333330FFF030FFF03333373FF7373FF7333333000333000
        3333333777333777333333333333333333333333333333333333333333333333
        3333333333333333333333333333333333333333333333333333}
      Layout = blGlyphTop
      NumGlyphs = 2
    end
    object BitBtn2: TBitBtn
      Left = 728
      Top = 4
      Width = 40
      Height = 40
      Caption = '退出'
      TabOrder = 4
      Glyph.Data = {
        36030000424D3603000000000000360000002800000010000000100000000100
        18000000000000030000120B0000120B00000000000000000000BFBFBFBFBFBF
        BFBFBFBFBFBF000000000000BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF
        BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF0000007F7F00000000BFBFBFBF
        BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF
        0000007F7F007F7F00000000BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF
        BFBFBFBFBFBFBFBFBFBF0000000000007F7F007F7F007F7F0000000000000000
        0000000000000000000000000000000000BFBFBFBFBFBFBFBFBFBFBFBF000000
        7F7F007F7F007F7F00000000FFFFFFFFFFFF000000BFBFBFBFBFBFBFBFBFBFBF
        BFBFBFBFBFBFBFBFBFBFBFBFBF0000007F7F007F7F00000000000000FFFFFFFF
        FFFF000000BFBFBFBFBFBFBFBFBFBFBFBF7F0000BFBFBFBFBFBFBFBFBF000000
        7F7F007F7F007F7F00000000FFFFFFFFFFFF000000BFBFBFBFBFBFBFBFBF7F00
        007F0000BFBFBFBFBFBFBFBFBF0000007F7F007F7F007F7F00000000FFFFFFFF
        FFFF000000BFBFBFBFBFBF7F00007F00007F00007F00007F0000BFBFBF000000
        7F7F007F7F007F7F00000000FFFFFFFFFFFF000000BFBFBF7F00007F00007F00
        007F00007F00007F0000BFBFBF0000007F7F007F7F007F7F00000000FFFFFFFF
        FFFF000000BFBFBFBFBFBF7F00007F00007F00007F00007F0000BFBFBF000000
        7F7F007F7F00000000FFFFFFFFFFFFFFFFFF000000BFBFBFBFBFBFBFBFBF7F00
        007F0000BFBFBFBFBFBFBFBFBF0000007F7F00000000FFFFFFFFFFFFFFFFFFFF
        FFFF000000BFBFBFBFBFBFBFBFBFBFBFBF7F0000BFBFBFBFBFBFBFBFBF000000
        000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF000000BFBFBFBFBFBFBFBFBFBFBF
        BFBFBFBFBFBFBFBFBFBFBFBFBF00000000000000000000000000000000000000
        0000000000BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF
        BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF
        BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF
        BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBF}
      Layout = blGlyphTop
    end
    object BitBtn3: TBitBtn
      Left = 688
      Top = 4
      Width = 40
      Height = 40
      Caption = '打印'
      TabOrder = 5
      Glyph.Data = {
        76010000424D7601000000000000760000002800000020000000100000000100
        04000000000000010000130B0000130B00001000000000000000000000000000
        800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00300000000000
        00033FFFFFFFFFFFFFFF0888888888888880777777777777777F088888888888
        8880777777777777777F0000000000000000FFFFFFFFFFFFFFFF0F8F8F8F8F8F
        8F80777777777777777F08F8F8F8F8F8F9F0777777777777777F0F8F8F8F8F8F
        8F807777777777777F7F0000000000000000777777777777777F3330FFFFFFFF
        03333337F3FFFF3F7F333330F0000F0F03333337F77773737F333330FFFFFFFF
        03333337F3FF3FFF7F333330F00F000003333337F773777773333330FFFF0FF0
        33333337F3FF7F3733333330F08F0F0333333337F7737F7333333330FFFF0033
        33333337FFFF7733333333300000033333333337777773333333}
      Layout = blGlyphTop
      NumGlyphs = 2
    end
  end
  object ADOQuery1: TADOQuery
    Connection = DM.ADOConnection
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'SELECT xs_DailyMaster.DailyCode AS 日报编号,       '
      'xs_store.StoreName AS 分销店名称,                  '
      'xs_store.type      AS 分销店类型,                  '
      'xs_DailyMaster.DateTime AS 上报时间,               '
      'sum(xs_Dailydetail.Total) AS 总数量,                    '
      'sum(xs_Dailydetail.Amount) AS 总金额,                   '
      
        'xs_DailyMaster.InputPerson AS 录入人                            ' +
        '  '
      'FROM xs_DailyMaster Left outer join                '
      '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_store.ty' +
        'pe,xs_DailyMaster.DateTime'
      '         ,xs_DailyMaster.InputPerson  '
      '')
    Left = 424
    Top = 131
    object ADOQuery1DSDesigner: TWideStringField
      FieldName = '日报编号'
      Size = 50
    end
    object ADOQuery1DSDesigner2: TWideStringField
      FieldName = '分销店名称'
      Size = 50
    end
    object ADOQuery1DSDesigner3: TWideStringField
      FieldName = '分销店类型'
      Size = 50
    end
    object ADOQuery1DSDesigner4: TDateTimeField
      FieldName = '上报时间'
    end
    object ADOQuery1DSDesigner5: TFloatField
      FieldName = '总数量'
      ReadOnly = True
      DisplayFormat = '#0 双'
    end
    object ADOQuery1DSDesigner6: TFloatField
      FieldName = '总金额'
      ReadOnly = True
      DisplayFormat = '￥ #0.00'
    end
    object ADOQuery1DSDesigner7: TWideStringField
      FieldName = '录入人'
      Size = 50
    end
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 392
    Top = 131
  end
end