khrz.dfm

房屋出租信息管理系统,房屋出租信息的录入、查询、删除以及用户管理等功能

object KhrzForm: TKhrzForm
  Left = 240
  Top = 128
  BorderStyle = bsDialog
  Caption = #23458#25143#20837#20303#31649#29702
  ClientHeight = 243
  ClientWidth = 404
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  Position = poMainFormCenter
  OnClose = FormClose
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 13
  object Label1: TLabel
    Left = 79
    Top = 30
    Width = 80
    Height = 16
    Caption = #23458#25143#32534#21495#65306
    Font.Charset = GB2312_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = #23435#20307
    Font.Style = []
    ParentFont = False
  end
  object Label2: TLabel
    Left = 79
    Top = 70
    Width = 80
    Height = 16
    Caption = #25151#38388#32534#21495#65306
    Font.Charset = GB2312_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = #23435#20307
    Font.Style = []
    ParentFont = False
  end
  object Label3: TLabel
    Left = 79
    Top = 110
    Width = 80
    Height = 16
    Caption = #36215#22987#26085#26399#65306
    Font.Charset = GB2312_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = #23435#20307
    Font.Style = []
    ParentFont = False
  end
  object Label4: TLabel
    Left = 79
    Top = 153
    Width = 80
    Height = 16
    Caption = #32456#27490#26085#26399#65306
    Font.Charset = GB2312_CHARSET
    Font.Color = clWindowText
    Font.Height = -16
    Font.Name = #23435#20307
    Font.Style = []
    ParentFont = False
  end
  object Label5: TLabel
    Left = 287
    Top = 67
    Width = 3
    Height = 13
  end
  object Label6: TLabel
    Left = 287
    Top = 118
    Width = 3
    Height = 13
  end
  object Label7: TLabel
    Left = 287
    Top = 22
    Width = 3
    Height = 13
  end
  object Ed_Khbh: TEdit
    Left = 159
    Top = 26
    Width = 125
    Height = 21
    TabOrder = 0
    OnChange = Ed_KhbhChange
    OnKeyDown = Ed_KhbhKeyDown
    OnKeyPress = Ed_KhbhKeyPress
  end
  object bitbtn_Rz: TBitBtn
    Left = 71
    Top = 201
    Width = 75
    Height = 25
    Caption = #20837#20303
    TabOrder = 1
    OnClick = bitbtn_RzClick
    Glyph.Data = {
      76010000424D7601000000000000760000002800000020000000100000000100
      04000000000000010000120B0000120B00001000000000000000000000000000
      800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
      FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
      3333333333333333333333333333333333333FFF333333333333000333333333
      3333777FFF3FFFFF33330B000300000333337F777F777773F333000E00BFBFB0
      3333777F773333F7F333000E0BFBF0003333777F7F3337773F33000E0FBFBFBF
      0333777F7F3333FF7FFF000E0BFBF0000003777F7F3337777773000E0FBFBFBF
      BFB0777F7F33FFFFFFF7000E0BF000000003777F7FF777777773000000BFB033
      33337777773FF733333333333300033333333333337773333333333333333333
      3333333333333333333333333333333333333333333333333333333333333333
      3333333333333333333333333333333333333333333333333333}
    NumGlyphs = 2
  end
  object bitbtn_quit: TBitBtn
    Left = 239
    Top = 201
    Width = 75
    Height = 25
    Caption = #36864#20986
    TabOrder = 2
    OnClick = bitbtn_quitClick
    Glyph.Data = {
      76010000424D7601000000000000760000002800000020000000100000000100
      04000000000000010000120B0000120B00001000000000000000000000000000
      800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
      FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00330000000000
      03333377777777777F333301BBBBBBBB033333773F3333337F3333011BBBBBBB
      0333337F73F333337F33330111BBBBBB0333337F373F33337F333301110BBBBB
      0333337F337F33337F333301110BBBBB0333337F337F33337F333301110BBBBB
      0333337F337F33337F333301110BBBBB0333337F337F33337F333301110BBBBB
      0333337F337F33337F333301110BBBBB0333337F337FF3337F33330111B0BBBB
      0333337F337733337F333301110BBBBB0333337F337F33337F333301110BBBBB
      0333337F3F7F33337F333301E10BBBBB0333337F7F7F33337F333301EE0BBBBB
      0333337F777FFFFF7F3333000000000003333377777777777333}
    NumGlyphs = 2
  end
  object Ed_FJbh: TEdit
    Left = 159
    Top = 67
    Width = 125
    Height = 21
    TabOrder = 3
    OnChange = Ed_FJbhChange
    OnKeyDown = Ed_FJbhKeyDown
    OnKeyPress = Ed_FJbhKeyPress
  end
  object DT_begin: TDateTimePicker
    Left = 159
    Top = 107
    Width = 125
    Height = 25
    CalAlignment = dtaLeft
    Date = 38113
    Time = 38113
    DateFormat = dfShort
    DateMode = dmComboBox
    Kind = dtkDate
    ParseInput = False
    TabOrder = 4
  end
  object DT_end: TDateTimePicker
    Left = 159
    Top = 150
    Width = 125
    Height = 25
    CalAlignment = dtaLeft
    Date = 38113
    Time = 38113
    DateFormat = dfShort
    DateMode = dmComboBox
    Kind = dtkDate
    ParseInput = False
    TabOrder = 5
  end
  object DBGrid2: TDBGrid
    Left = 160
    Top = 88
    Width = 241
    Height = 16
    BorderStyle = bsNone
    Color = clAqua
    DataSource = DS_Fh
    FixedColor = clAqua
    Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit]
    ReadOnly = True
    TabOrder = 6
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    Visible = False
    OnDblClick = DBGrid2DblClick
    OnKeyDown = DBGrid2KeyDown
    Columns = <
      item
        Expanded = False
        FieldName = 'fangno'
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -12
        Font.Name = #23435#20307
        Font.Style = []
        Title.Alignment = taCenter
        Title.Caption = #25151#21495
        Width = 57
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'area'
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -12
        Font.Name = #23435#20307
        Font.Style = []
        Title.Alignment = taCenter
        Title.Caption = #38754#31215
        Width = 45
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'housetype'
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -12
        Font.Name = #23435#20307
        Font.Style = []
        Title.Alignment = taCenter
        Title.Caption = #25143#22411
        Width = 68
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'facetype'
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -12
        Font.Name = #23435#20307
        Font.Style = []
        Title.Alignment = taCenter
        Title.Caption = #26397#21521
        Width = 49
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'sb'
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -12
        Font.Name = #23435#20307
        Font.Style = []
        Title.Alignment = taCenter
        Title.Caption = #23478#20855#35774#22791
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'fangya'
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -12
        Font.Name = #23435#20307
        Font.Style = []
        Title.Alignment = taCenter
        Title.Caption = #25276#37329#12288
        Width = 42
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'fangprice'
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -12
        Font.Name = #23435#20307
        Font.Style = []
        Title.Alignment = taCenter
        Title.Caption = #26376#31199
        Width = 52
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'status'
        Font.Charset = GB2312_CHARSET
        Font.Color = clWindowText
        Font.Height = -12
        Font.Name = #23435#20307
        Font.Style = []
        Title.Alignment = taCenter
        Title.Caption = #29366#24577
        Visible = True
      end>
  end
  object DBGrid1: TDBGrid
    Left = 160
    Top = 48
    Width = 241
    Height = 17
    Color = clAqua
    DataSource = DS_Khbh
    FixedColor = clAqua
    Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit]
    TabOrder = 7
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    Visible = False
    OnDblClick = DBGrid1DblClick
    OnKeyDown = DBGrid1KeyDown
    Columns = <
      item
        Expanded = False
        FieldName = 'manid'
        Title.Alignment = taCenter
        Title.Caption = #23458#25143#32534#21495
        Title.Font.Charset = ANSI_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -12
        Title.Font.Name = #23435#20307
        Title.Font.Style = []
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'manname'
        Title.Alignment = taCenter
        Title.Caption = #23458#25143#22995#21517
        Title.Font.Charset = ANSI_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -12
        Title.Font.Name = #23435#20307
        Title.Font.Style = []
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'zjm'
        Title.Alignment = taCenter
        Title.Caption = #21161#35760#30721
        Title.Font.Charset = ANSI_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -12
        Title.Font.Name = #23435#20307
        Title.Font.Style = []
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'sex'
        Title.Alignment = taCenter
        Title.Caption = #24615#21035
        Title.Font.Charset = ANSI_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -12
        Title.Font.Name = #23435#20307
        Title.Font.Style = []
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'idcard'
        Title.Alignment = taCenter
        Title.Caption = #36523#20221#35777#21495
        Title.Font.Charset = ANSI_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -12
        Title.Font.Name = #23435#20307
        Title.Font.Style = []
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'iddress'
        Title.Alignment = taCenter
        Title.Caption = #36523#20998#35777#22320#22336
        Title.Font.Charset = ANSI_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -12
        Title.Font.Name = #23435#20307
        Title.Font.Style = []
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'handset'
        Title.Alignment = taCenter
        Title.Caption = #32852#31995#30005#35805
        Title.Font.Charset = ANSI_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -12
        Title.Font.Name = #23435#20307
        Title.Font.Style = []
        Visible = True
      end
      item
        Expanded = False
        FieldName = 'company'
        Title.Alignment = taCenter
        Title.Caption = #29616#22312#21333#20301
        Title.Font.Charset = ANSI_CHARSET
        Title.Font.Color = clWindowText
        Title.Font.Height = -12
        Title.Font.Name = #23435#20307
        Title.Font.Style = []
        Visible = True
      end>
  end
  object DS_Fh: TDataSource
    DataSet = ADQ_Fh
    Left = 120
    Top = 80
  end
  object ADQ_Fh: TADOQuery
    Connection = DB_module.ADOCon
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'select fangno,area,housetype,facetype,sb,fangya,fangprice,'
      'case status when '#39'1'#39' then '#39#24050#20986#31199#39' else '#39#26410#20986#31199#39' end as status'
      'from fangjian')
    Left = 88
    Top = 80
  end
  object DS_Khbh: TDataSource
    DataSet = ADQ_Khbh
    Left = 112
    Top = 32
  end
  object ADQ_Khbh: TADOQuery
    Connection = DB_module.ADOCon
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'select manid,manname,zjm,case sex when '#39'1'#39' then '#39#30007#39' else '#39#22899#39' end' +
        ' as sex,'
      'idcard,iddress,handset,company  from dbo.Zf_Man  ')
    Left = 88
    Top = 32
  end
  object ADQ_Insert: TADOQuery
    Connection = DB_module.ADOCon
    Parameters = <
      item
        Name = 'manid'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 10
        Value = Null
      end
      item
        Name = 'fangno'
        Attributes = [paNullable]
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 10
        Value = Null
      end
      item
        Name = 'begindate'
        Attributes = [paNullable]
        DataType = ftDateTime
        NumericScale = 3
        Precision = 23
        Size = 16
        Value = Null
      end
      item
        Name = 'enddate'
        DataType = ftDateTime
        NumericScale = 3
        Precision = 23
        Size = 16
        Value = Null
      end
      item
        Name = 'status'
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 1
        Value = Null
      end>
    SQL.Strings = (
      'insert into Zf_Rz'
      '       (manid,fangno,begindate,enddate,status)'
      'values (:manid,:fangno,:begindate,:enddate,:status)')
    Left = 48
    Top = 160
  end
end