finddailyfrm.dfm

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

object FindDailyForm: TFindDailyForm
  Left = 41
  Top = 108
  Width = 770
  Height = 375
  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 Panel1: TPanel
    Left = 0
    Top = 0
    Width = 762
    Height = 49
    Align = alTop
    TabOrder = 0
    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 = 408
      Top = 19
      Width = 60
      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 BitBtn1: TBitBtn
      Left = 648
      Top = 4
      Width = 40
      Height = 40
      Caption = '查询'
      TabOrder = 2
      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 = 3
      OnClick = BitBtn2Click
      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 = 4
      Glyph.Data = {
        76010000424D7601000000000000760000002800000020000000100000000100
        04000000000000010000130B0000130B00001000000000000000000000000000
        800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00300000000000
        00033FFFFFFFFFFFFFFF0888888888888880777777777777777F088888888888
        8880777777777777777F0000000000000000FFFFFFFFFFFFFFFF0F8F8F8F8F8F
        8F80777777777777777F08F8F8F8F8F8F9F0777777777777777F0F8F8F8F8F8F
        8F807777777777777F7F0000000000000000777777777777777F3330FFFFFFFF
        03333337F3FFFF3F7F333330F0000F0F03333337F77773737F333330FFFFFFFF
        03333337F3FF3FFF7F333330F00F000003333337F773777773333330FFFF0FF0
        33333337F3FF7F3733333330F08F0F0333333337F7737F7333333330FFFF0033
        33333337FFFF7733333333300000033333333337777773333333}
      Layout = blGlyphTop
      NumGlyphs = 2
    end
    object DBEdit1: TDBEdit
      Left = 480
      Top = 16
      Width = 105
      Height = 20
      DataField = 'storeCode'
      DataSource = DataSource2
      TabOrder = 5
    end
    object DBLookupComboBox1: TDBLookupComboBox
      Left = 480
      Top = 16
      Width = 113
      Height = 20
      DataField = 'storename'
      DataSource = DataSource2
      TabOrder = 6
    end
  end
  object Panel3: TPanel
    Left = 0
    Top = 49
    Width = 762
    Height = 299
    Align = alClient
    BorderWidth = 5
    Caption = 'Panel3'
    TabOrder = 1
    object DBGridEh1: TDBGridEh
      Left = 6
      Top = 6
      Width = 750
      Height = 287
      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 = 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 ADOQuery1: TADOQuery
    Connection = DM.ADOConnection
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'SELECT  xs_DailyMaster.DailyCode AS 日报编号, '
      '              xs_store.StoreName AS 分销店名称, '
      '         xs_DailyMaster.DateTime AS 上报时间, '
      '            xs_DailyMaster.Tatol AS 总数量, '
      '           xs_DailyMaster.Amount AS 总金额, '
      '      InputPerson AS 录入人'
      'FROM xs_DailyMaster Left outer join '
      '     xs_store on xs_dailyMaster.storecode = xs_store.storecode')
    Left = 424
    Top = 131
    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
    object ADOQuery1DSDesigner6: TWideStringField
      FieldName = '录入人'
      Size = 50
    end
  end
  object DataSource1: TDataSource
    DataSet = ADOQuery1
    Left = 392
    Top = 131
  end
  object ADOQuery2: TADOQuery
    Connection = DM.ADOConnection
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select storeCode'
      'from xs_store')
    Left = 616
    Top = 83
    object ADOQuery2storeCode: TWideStringField
      FieldName = 'storeCode'
      Size = 50
    end
    object ADOQuery2storename: TStringField
      FieldKind = fkLookup
      FieldName = 'storename'
      LookupDataSet = ADOQuery3
      LookupKeyFields = 'storeCode'
      LookupResultField = 'storename'
      KeyFields = 'storeCode'
      Size = 50
      Lookup = True
    end
  end
  object DataSource2: TDataSource
    DataSet = ADOQuery2
    Left = 576
    Top = 88
  end
  object ADOQuery3: TADOQuery
    Connection = DM.ADOConnection
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select storeCode,storename'
      'from xs_store')
    Left = 656
    Top = 83
  end
end