seerz.dfm

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

object rzForm: TrzForm
  Left = 13
  Top = 78
  Width = 762
  Height = 505
  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 = 754
    Height = 421
    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 = 'code'
        Title.Alignment = taCenter
        Title.Caption = '工号'
        Width = 48
        Visible = True
      end
      item
        Expanded = False
        FieldName = '姓名'
        Title.Alignment = taCenter
        Width = 80
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'time'
        Title.Alignment = taCenter
        Title.Caption = '时间'
        Width = 144
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'des'
        Title.Alignment = taCenter
        Title.Caption = '操作'
        Width = 154
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'machine'
        Title.Alignment = taCenter
        Title.Caption = '工作站'
        Width = 83
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'memo1'
        Title.Alignment = taCenter
        Title.Caption = '备注'
        Width = 227
        Visible = True
      end>
  end
  object Panel1: TPanel
    Left = 0
    Top = 0
    Width = 754
    Height = 57
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 1
    object Label1: TLabel
      Left = 222
      Top = 20
      Width = 12
      Height = 12
      Caption = '至'
    end
    object Label2: TLabel
      Left = 432
      Top = 20
      Width = 36
      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
    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
    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
    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
    end
    object BitBtn1: TBitBtn
      Left = 609
      Top = 13
      Width = 66
      Height = 25
      Caption = '删除'
      Enabled = False
      TabOrder = 4
      OnClick = BitBtn1Click
    end
    object BitBtn2: TBitBtn
      Left = 675
      Top = 13
      Width = 66
      Height = 25
      Caption = '退出'
      TabOrder = 5
      OnClick = BitBtn2Click
    end
    object code: TEdit
      Left = 466
      Top = 16
      Width = 69
      Height = 20
      TabOrder = 6
    end
    object BitBtn3: TBitBtn
      Left = 543
      Top = 13
      Width = 66
      Height = 25
      Caption = '查询'
      TabOrder = 7
      OnClick = ksdateChange
    end
  end
  object DataSource1: TDataSource
    DataSet = Query1
    Left = 128
    Top = 136
  end
  object Query1: TQuery
    DatabaseName = 'sanadm'
    SQL.Strings = (
      
        'select *,(select name from stuff where code=logo.code) as 姓名 f' +
        'rom logo where [time]>:pbeg and [time]<:pend and code like :code' +
        ' order by [time] desc'
      ' '
      ' '
      ' '
      ' '
      ' ')
    Left = 200
    Top = 144
    ParamData = <
      item
        DataType = ftUnknown
        Name = 'pbeg'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'pend'
        ParamType = ptUnknown
      end
      item
        DataType = ftUnknown
        Name = 'code'
        ParamType = ptUnknown
      end>
  end
end