cxsrrb.dfm

集成酒店桑拿食管管理的完整程序

object cxsrrbForm: TcxsrrbForm
  Left = 83
  Top = 103
  Width = 687
  Height = 465
  BorderIcons = [biSystemMenu]
  Caption = '收入日报表查询'
  Color = clBtnFace
  Font.Charset = GB2312_CHARSET
  Font.Color = clWindowText
  Font.Height = -12
  Font.Name = '宋体'
  Font.Style = []
  OldCreateOrder = False
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 12
  object Panel2: TPanel
    Left = 0
    Top = 0
    Width = 679
    Height = 65
    Align = alTop
    BevelOuter = bvNone
    Font.Charset = GB2312_CHARSET
    Font.Color = clBlack
    Font.Height = -27
    Font.Name = '宋体'
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 0
    object Panel1: TPanel
      Left = 0
      Top = 0
      Width = 679
      Height = 41
      Align = alTop
      BevelOuter = bvNone
      Caption = '营业收入  报表'
      Font.Charset = GB2312_CHARSET
      Font.Color = clBlue
      Font.Height = -27
      Font.Name = '隶书'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 0
      object kk: TLabel
        Left = 32
        Top = 8
        Width = 15
        Height = 27
        Visible = False
      end
    end
    object BitBtn2: TBitBtn
      Left = 602
      Top = 44
      Width = 64
      Height = 21
      Caption = '打印'
      Font.Charset = GB2312_CHARSET
      Font.Color = clBlack
      Font.Height = -12
      Font.Name = '宋体'
      Font.Style = []
      ParentFont = False
      TabOrder = 1
      OnClick = BitBtn2Click
      Glyph.Data = {
        76010000424D7601000000000000760000002800000020000000100000000100
        04000000000000010000130B0000130B00001000000000000000000000000000
        800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
        FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00300000000000
        00033FFFFFFFFFFFFFFF0888888888888880777777777777777F088888888888
        8880777777777777777F0000000000000000FFFFFFFFFFFFFFFF0F8F8F8F8F8F
        8F80777777777777777F08F8F8F8F8F8F9F0777777777777777F0F8F8F8F8F8F
        8F807777777777777F7F0000000000000000777777777777777F3330FFFFFFFF
        03333337F3FFFF3F7F333330F0000F0F03333337F77773737F333330FFFFFFFF
        03333337F3FF3FFF7F333330F00F000003333337F773777773333330FFFF0FF0
        33333337F3FF7F3733333330F08F0F0333333337F7737F7333333330FFFF0033
        33333337FFFF7733333333300000033333333337777773333333}
      NumGlyphs = 2
    end
    object DateTimePicker1: TDateTimePicker
      Left = 280
      Top = 40
      Width = 113
      Height = 20
      CalAlignment = dtaLeft
      Date = 37673.0378609954
      Time = 37673.0378609954
      DateFormat = dfLong
      DateMode = dmComboBox
      Font.Charset = GB2312_CHARSET
      Font.Color = clBlack
      Font.Height = -12
      Font.Name = '宋体'
      Font.Style = []
      Kind = dtkDate
      ParseInput = False
      ParentFont = False
      TabOrder = 2
    end
  end
  object BitBtn1: TBitBtn
    Left = 602
    Top = 22
    Width = 64
    Height = 21
    Caption = '显示'
    Font.Charset = GB2312_CHARSET
    Font.Color = clBlack
    Font.Height = -12
    Font.Name = '宋体'
    Font.Style = []
    ParentFont = False
    TabOrder = 1
    OnClick = BitBtn1Click
    Glyph.Data = {
      76010000424D7601000000000000760000002800000020000000100000000100
      04000000000000010000120B0000120B00001000000000000000000000000000
      800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
      FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
      333333333333FF3333333333333C0C333333333333F777F3333333333CC0F0C3
      333333333777377F33333333C30F0F0C333333337F737377F333333C00FFF0F0
      C33333F7773337377F333CC0FFFFFF0F0C3337773F33337377F3C30F0FFFFFF0
      F0C37F7373F33337377F00FFF0FFFFFF0F0C7733373F333373770FFFFF0FFFFF
      F0F073F33373F333373730FFFFF0FFFFFF03373F33373F333F73330FFFFF0FFF
      00333373F33373FF77333330FFFFF000333333373F333777333333330FFF0333
      3333333373FF7333333333333000333333333333377733333333333333333333
      3333333333333333333333333333333333333333333333333333}
    NumGlyphs = 2
  end
  object PageControl1: TPageControl
    Left = 0
    Top = 65
    Width = 679
    Height = 373
    ActivePage = TabSheet1
    Align = alClient
    TabOrder = 2
    object TabSheet1: TTabSheet
      Caption = '营业收入日报表'
      object DBGrid1: TDBGrid
        Left = 0
        Top = 0
        Width = 671
        Height = 346
        Align = alClient
        DataSource = DataSource1
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -12
        Font.Name = '宋体'
        Font.Style = []
        ImeName = '中文 (简体) - 智能 ABC'
        Options = [dgEditing, dgTitles, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgConfirmDelete, dgCancelOnExit]
        ParentFont = False
        ParentShowHint = False
        ReadOnly = True
        ShowHint = True
        TabOrder = 0
        TitleFont.Charset = GB2312_CHARSET
        TitleFont.Color = clWindowText
        TitleFont.Height = -12
        TitleFont.Name = '宋体'
        TitleFont.Style = []
        Columns = <
          item
            Expanded = False
            FieldName = 'Code'
            Title.Alignment = taCenter
            Title.Caption = '项目'
            Width = 106
            Visible = True
          end
          item
            Expanded = False
            FieldName = 'num'
            Title.Alignment = taCenter
            Title.Caption = '数量'
            Width = 38
            Visible = True
          end
          item
            Expanded = False
            FieldName = 'xj'
            Title.Alignment = taCenter
            Title.Caption = '现金'
            Width = 62
            Visible = True
          end
          item
            Expanded = False
            FieldName = 'hy'
            Title.Alignment = taCenter
            Title.Caption = '消费卡'
            Width = 50
            Visible = True
          end
          item
            Expanded = False
            FieldName = 'zp'
            Title.Alignment = taCenter
            Title.Caption = '支票'
            Width = 54
            Visible = True
          end
          item
            Expanded = False
            FieldName = 'card'
            Title.Alignment = taCenter
            Title.Caption = '信用卡'
            Width = 53
            Visible = True
          end
          item
            Expanded = False
            FieldName = 'gz'
            Title.Alignment = taCenter
            Title.Caption = '记帐'
            Width = 51
            Visible = True
          end
          item
            Expanded = False
            FieldName = 'md'
            Title.Alignment = taCenter
            Title.Caption = '内招'
            Width = 58
            Visible = True
          end
          item
            Expanded = False
            FieldName = 'other'
            Title.Alignment = taCenter
            Title.Caption = '代金券'
            Width = 53
            Visible = True
          end
          item
            Expanded = False
            FieldName = 'xiaoj'
            Title.Alignment = taCenter
            Title.Caption = '合计'
            Width = 59
            Visible = True
          end
          item
            Expanded = False
            FieldName = 'rbdate'
            Title.Alignment = taCenter
            Title.Caption = '日期'
            Visible = True
          end>
      end
    end
    object TabSheet2: TTabSheet
      Caption = '营业收入分类饼图'
      ImageIndex = 1
      object DBChart1: TDBChart
        Left = 0
        Top = 0
        Width = 569
        Height = 345
        AllowPanning = pmNone
        AllowZoom = False
        BackWall.Brush.Color = clWhite
        BackWall.Brush.Style = bsClear
        BackWall.Pen.Visible = False
        Title.Font.Charset = GB2312_CHARSET
        Title.Font.Color = clBlue
        Title.Font.Height = -11
        Title.Font.Name = '宋体'
        Title.Font.Style = []
        Title.Text.Strings = (
          'TDBChart')
        AxisVisible = False
        ClipPoints = False
        Frame.Visible = False
        Legend.Font.Charset = GB2312_CHARSET
        Legend.Font.Color = clBlack
        Legend.Font.Height = -11
        Legend.Font.Name = '宋体'
        Legend.Font.Style = []
        View3DOptions.Elevation = 315
        View3DOptions.Orthogonal = False
        View3DOptions.Perspective = 0
        View3DOptions.Rotation = 360
        View3DWalls = False
        TabOrder = 0
        object Series1: TPieSeries
          Marks.ArrowLength = 8
          Marks.Visible = True
          SeriesColor = clRed
          ValueFormat = '#,##0.##'
          XLabelsSource = 'Code'
          OtherSlice.Text = 'Other'
          PieValues.DateTime = False
          PieValues.Name = 'Pie'
          PieValues.Multiplier = 1
          PieValues.Order = loNone
          PieValues.ValueSource = 'xiaoj'
        end
      end
    end
    object TabSheet3: TTabSheet
      Caption = '营业收入分类直方图'
      ImageIndex = 2
      object DBChart2: TDBChart
        Left = 0
        Top = 0
        Width = 671
        Height = 346
        BackWall.Brush.Color = clWhite
        BackWall.Brush.Style = bsClear
        Title.Font.Charset = GB2312_CHARSET
        Title.Font.Color = clBlue
        Title.Font.Height = -11
        Title.Font.Name = '宋体'
        Title.Font.Style = []
        Title.Text.Strings = (
          'TDBChart')
        LeftAxis.LabelsFont.Charset = GB2312_CHARSET
        LeftAxis.LabelsFont.Color = clBlack
        LeftAxis.LabelsFont.Height = -11
        LeftAxis.LabelsFont.Name = '宋体'
        LeftAxis.LabelsFont.Style = []
        LeftAxis.Title.Font.Charset = GB2312_CHARSET
        LeftAxis.Title.Font.Color = clBlack
        LeftAxis.Title.Font.Height = -11
        LeftAxis.Title.Font.Name = '宋体'
        LeftAxis.Title.Font.Style = []
        Legend.Font.Charset = GB2312_CHARSET
        Legend.Font.Color = clBlack
        Legend.Font.Height = -11
        Legend.Font.Name = '宋体'
        Legend.Font.Style = []
        View3D = False
        Align = alClient
        TabOrder = 0
        object Series2: TBarSeries
          Marks.ArrowLength = 20
          Marks.Visible = True
          SeriesColor = clRed
          XLabelsSource = 'Code'
          XValues.DateTime = False
          XValues.Name = 'X'
          XValues.Multiplier = 1
          XValues.Order = loAscending
          YValues.DateTime = False
          YValues.Name = 'Bar'
          YValues.Multiplier = 1
          YValues.Order = loNone
          YValues.ValueSource = 'xiaoj'
        end
      end
    end
  end
  object DataSource1: TDataSource
    DataSet = Query1
    Left = 320
    Top = 126
  end
  object Query1: TQuery
    DatabaseName = 'sanadm'
    SQL.Strings = (
      'select * from srrb  where rbdate=:prq order by xh')
    Left = 440
    Top = 160
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'prq'
        ParamType = ptUnknown
      end>
  end
  object Query2: TQuery
    DatabaseName = 'sanadm'
    SQL.Strings = (
      
        'select * from srrb where rbdate=:prq and code<>'#39' 合   计  '#39' orde' +
        'r by xh'
      ' ')
    Left = 384
    Top = 160
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'prq'
        ParamType = ptUnknown
      end>
  end
end