cxlshk.dfm

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

object cxlshkForm: TcxlshkForm
  Left = 110
  Top = 107
  Width = 605
  Height = 503
  Caption = '会客历史查询'
  Color = clBtnFace
  Font.Charset = GB2312_CHARSET
  Font.Color = clWindowText
  Font.Height = -12
  Font.Name = '宋体'
  Font.Style = []
  OldCreateOrder = False
  Position = poScreenCenter
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 12
  object DBGrid1: TDBGrid
    Left = 0
    Top = 57
    Width = 597
    Height = 419
    Align = alClient
    Color = clInfoBk
    DataSource = DataSource1
    Font.Charset = GB2312_CHARSET
    Font.Color = clWindowText
    Font.Height = -12
    Font.Name = '宋体'
    Font.Style = []
    ParentFont = False
    TabOrder = 0
    TitleFont.Charset = GB2312_CHARSET
    TitleFont.Color = clBlue
    TitleFont.Height = -12
    TitleFont.Name = '宋体'
    TitleFont.Style = []
    Columns = <
      item
        Expanded = False
        FieldName = 'roomno'
        Title.Alignment = taCenter
        Title.Caption = '会客房间'
        Width = 60
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'begtime'
        Title.Alignment = taCenter
        Title.Caption = '开始时间'
        Width = 127
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'num'
        Title.Alignment = taCenter
        Title.Caption = '会客人数'
        Width = 54
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'endtime'
        Title.Alignment = taCenter
        Title.Caption = '离开时间'
        Width = 142
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'czy'
        Title.Alignment = taCenter
        Title.Caption = '操作员'
        Width = 88
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'jsj'
        Title.Alignment = taCenter
        Title.Caption = '工作站'
        Width = 85
        Visible = True
      end>
  end
  object Panel1: TPanel
    Left = 0
    Top = 0
    Width = 597
    Height = 57
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 1
    object Label1: TLabel
      Left = 222
      Top = 20
      Width = 12
      Height = 12
      Caption = '至'
    end
    object ksdate: TDateTimePicker
      Left = 24
      Top = 16
      Width = 113
      Height = 20
      CalAlignment = dtaLeft
      Date = 37342.6643866898
      Time = 37342.6643866898
      DateFormat = dfLong
      DateMode = dmComboBox
      Kind = dtkDate
      ParseInput = False
      TabOrder = 0
      OnChange = ksdateChange
    end
    object kstime: TDateTimePicker
      Left = 137
      Top = 16
      Width = 75
      Height = 20
      CalAlignment = dtaLeft
      Date = 37342.6645888889
      Time = 37342.6645888889
      DateFormat = dfShort
      DateMode = dmComboBox
      Kind = dtkTime
      ParseInput = False
      TabOrder = 1
      OnChange = ksdateChange
    end
    object jsdate: TDateTimePicker
      Left = 242
      Top = 16
      Width = 112
      Height = 20
      CalAlignment = dtaLeft
      Date = 37342.6643866898
      Time = 37342.6643866898
      DateFormat = dfLong
      DateMode = dmComboBox
      Kind = dtkDate
      ParseInput = False
      TabOrder = 2
      OnChange = ksdateChange
    end
    object jstime: TDateTimePicker
      Left = 354
      Top = 16
      Width = 75
      Height = 20
      CalAlignment = dtaLeft
      Date = 37342.6645888889
      Time = 37342.6645888889
      DateFormat = dfShort
      DateMode = dmComboBox
      Kind = dtkTime
      ParseInput = False
      TabOrder = 3
      OnChange = ksdateChange
    end
    object BitBtn1: TBitBtn
      Left = 436
      Top = 13
      Width = 75
      Height = 25
      Caption = '删除'
      TabOrder = 4
      OnClick = BitBtn1Click
    end
    object BitBtn2: TBitBtn
      Left = 510
      Top = 13
      Width = 75
      Height = 25
      Caption = '退出'
      TabOrder = 5
      OnClick = BitBtn2Click
    end
  end
  object DataSource1: TDataSource
    DataSet = Query1
    Left = 128
    Top = 136
  end
  object Query1: TQuery
    DatabaseName = 'sanadm'
    SQL.Strings = (
      
        'select * from lsguest where endtime>:pbeg and endtime<:pend orde' +
        'r by endtime desc'
      ''
      ' '
      ' '
      ' '
      ' '
      ' '
      ' ')
    Left = 200
    Top = 144
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'pbeg'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'pend'
        ParamType = ptUnknown
      end>
  end
end