frmmain.frm

售楼管理系统,含系统源程序和数据库.功能齐全,界面美观,操作方便.

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "Comdlg32.ocx"
Begin VB.Form frmMain 
   Caption         =   "售楼管理系统"
   ClientHeight    =   7590
   ClientLeft      =   60
   ClientTop       =   750
   ClientWidth     =   9930
   Icon            =   "frmMain.frx":0000
   LinkTopic       =   "Form1"
   ScaleHeight     =   7590
   ScaleWidth      =   9930
   StartUpPosition =   2  '屏幕中心
   WindowState     =   2  'Maximized
   Begin MSComDlg.CommonDialog CommonDialog1 
      Left            =   10800
      Top             =   3720
      _ExtentX        =   847
      _ExtentY        =   847
      _Version        =   393216
   End
   Begin MSComctlLib.Toolbar Toolbar1 
      Align           =   1  'Align Top
      Height          =   900
      Left            =   0
      TabIndex        =   0
      Top             =   0
      Width           =   9930
      _ExtentX        =   17515
      _ExtentY        =   1588
      ButtonWidth     =   1720
      ButtonHeight    =   1429
      Appearance      =   1
      ImageList       =   "ImageList1"
      _Version        =   393216
      BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
         NumButtons      =   6
         BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "bt_loupan"
            ImageIndex      =   1
         EndProperty
         BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "bt_kehu"
            ImageIndex      =   2
         EndProperty
         BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "bt_shoufei"
            ImageIndex      =   3
         EndProperty
         BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "bt_shoulou"
            ImageIndex      =   4
         EndProperty
         BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "bt_shoukuan"
            ImageIndex      =   5
         EndProperty
         BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Key             =   "bt_tuichu"
            ImageIndex      =   8
         EndProperty
      EndProperty
   End
   Begin MSComctlLib.ImageList ImageList1 
      Left            =   2280
      Top             =   1800
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   58
      ImageHeight     =   48
      MaskColor       =   12632256
      _Version        =   393216
      BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
         NumListImages   =   8
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmMain.frx":014A
            Key             =   "bt_loupan"
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmMain.frx":229C
            Key             =   "bt_kehu"
         EndProperty
         BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmMain.frx":426E
            Key             =   "bt_shoufei"
         EndProperty
         BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmMain.frx":60DC
            Key             =   "bt_shoulouhetong"
         EndProperty
         BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmMain.frx":7F5E
            Key             =   "bt_shoukuan"
         EndProperty
         BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmMain.frx":A008
            Key             =   "bt_ribaobiao"
         EndProperty
         BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmMain.frx":BFEE
            Key             =   "bt_zhiguantu"
         EndProperty
         BeginProperty ListImage8 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "frmMain.frx":DF00
            Key             =   "bt_tuichu"
         EndProperty
      EndProperty
   End
   Begin VB.Menu housemanage 
      Caption         =   "房产管理(&R)"
      Begin VB.Menu housestylelogin 
         Caption         =   "户型登记"
      End
      Begin VB.Menu builinglogin 
         Caption         =   "楼盘登记"
      End
      Begin VB.Menu fenge 
         Caption         =   "-"
      End
      Begin VB.Menu housestylefind 
         Caption         =   "户型查询"
      End
      Begin VB.Menu buildingfind 
         Caption         =   "楼盘查询"
         Shortcut        =   ^L
      End
   End
   Begin VB.Menu customermanage 
      Caption         =   "客户管理(&S)"
      Begin VB.Menu customerlogin 
         Caption         =   "客户资料登记"
         Shortcut        =   ^O
      End
      Begin VB.Menu fenge2 
         Caption         =   "-"
      End
      Begin VB.Menu customerdatafind 
         Caption         =   "客户资料查询"
      End
   End
   Begin VB.Menu chargemanage 
      Caption         =   "收费管理(&E)"
      Begin VB.Menu chargelogin 
         Caption         =   "收费登记"
         Shortcut        =   {F4}
      End
      Begin VB.Menu fenge3 
         Caption         =   "-"
      End
      Begin VB.Menu chargefind 
         Caption         =   "收费查询"
      End
   End
   Begin VB.Menu buildingsalemanage 
      Caption         =   "售楼管理(&Q)"
      Begin VB.Menu salemanlogin 
         Caption         =   "销售人员登记"
      End
      Begin VB.Menu fenge4 
         Caption         =   "-"
      End
      Begin VB.Menu buildingsalebargain 
         Caption         =   "售楼合同管理"
      End
      Begin VB.Menu gatheringmanage 
         Caption         =   "收款管理"
      End
      Begin VB.Menu fenge5 
         Caption         =   "-"
      End
      Begin VB.Menu salemanfind 
         Caption         =   "销售人员查询"
      End
      Begin VB.Menu buildingsale 
         Caption         =   "售楼合同查询"
      End
      Begin VB.Menu gatheringfind 
         Caption         =   "收款情况查询"
      End
   End
   Begin VB.Menu systemmaintenance 
      Caption         =   "系统维护(&P)"
      Begin VB.Menu databasebak 
         Caption         =   "数据库备份"
      End
      Begin VB.Menu databaserecovery 
         Caption         =   "数据库恢复"
      End
   End
   Begin VB.Menu exitsys 
      Caption         =   "退出系统(&X)"
   End
End
Attribute VB_Name = "frmMain"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit


Private Sub buildingfind_Click()
    Frmbuildingfind.Show
End Sub

Private Sub buildingsale_Click()
    frmhetongfind.Show 1
End Sub

Private Sub buildingsalebargain_Click()
    frmhetonglogin.Show 1
End Sub

Private Sub builinglogin_Click()
    frmbuildinglogin.Show 1
End Sub

Private Sub chargefind_Click()
    frmshoufeifind.Show
End Sub

Private Sub chargelogin_Click()
    frmshoufeilogin.Show 1
End Sub

Private Sub customerdatafind_Click()
    Frmkehufind.Show 1
End Sub

Private Sub customerlogin_Click()
    Frmkehulogin.Show 1
End Sub

Private Sub databasebak_Click()
    Dim fsofile
    If conn.State <> 0 Then conn.Close
    Set conn = Nothing
    Set fsofile = CreateObject("scripting.filesystemobject")
    CommonDialog1.Filter = "mdb文件(*.mdb)|*.mdb"
    CommonDialog1.CancelError = True
    On Error GoTo myerr
    CommonDialog1.ShowSave
    fsofile.copyfile App.Path & "\House.mdb", CommonDialog1.FileTitle
    Dim connectionstring As String
    connectionstring = "provider=Microsoft.Jet.oledb.4.0;" & _
                       "data source=" & App.Path & "\House.mdb"
    conn.Open connectionstring
    Exit Sub
myerr:
    
End Sub

Private Sub databaserecovery_Click()
    Dim fsofile
    If conn.State <> 0 Then conn.Close
    Set conn = Nothing
    Set fsofile = CreateObject("scripting.filesystemobject")
    CommonDialog1.Filter = "mdb文件(*.mdb)|*.mdb"
    CommonDialog1.CancelError = True
    On Error GoTo myerr
    CommonDialog1.ShowOpen
    fsofile.copyfile CommonDialog1.FileTitle, App.Path & "\House.mdb"
    Dim connectionstring As String
    connectionstring = "provider=Microsoft.Jet.oledb.4.0;" & _
                       "data source=" & App.Path & "\House.mdb"
    conn.Open connectionstring
    Exit Sub
myerr:
End Sub

Private Sub exitsys_Click()
    Unload Me
End Sub

Private Sub Form_Load()
    If username = "guest" Then
       buildingsalebargain.Enabled = False    '销售合同管理不可用
       databaserecovery.Enabled = False      '数据库恢复不可用
    End If
End Sub

Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
    If MsgBox("确实要退出本系统吗？", vbYesNo + vbQuestion, "提示") = vbNo Then
        Cancel = True             '如果用户不退出，则取消卸载
    Else                          '如果确定退出，在卸载之前关闭数据库
        If conn.State <> 0 Then conn.Close    '关闭数据库连接
        Set conn = Nothing
    End If
End Sub

Private Sub gatheringfind_Click()
    frmshoukuanfind.Show
End Sub

Private Sub gatheringmanage_Click()
    frmshoukuanlogin.Show 1
End Sub
Private Sub housestylefind_Click()
    Frmbuildingstylefind.Show 1
End Sub

Private Sub housestylelogin_Click()
    frmhuxinglogin.Show
End Sub

Private Sub salemanfind_Click()
    frmsalemanfind.Show 1
End Sub

Private Sub salemanlogin_Click()
    frmsalemanlogin.Show 1
End Sub

Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
    Select Case Button.Key        '按关键字选择
        Case "bt_loupan"            '如果单击按钮关键字为bt_loupan则显示楼盘查询窗体
             Frmbuildingfind.Show 1
        Case "bt_kehu"
             Frmkehufind.Show 1
        Case "bt_shoufei"
             frmshoufeifind.Show 1
        Case "bt_shoulou"
             frmhetonglogin.Show 1
        Case "bt_shoukuan"
             frmshoukuanlogin.Show 1
        Case "bt_tuichu"
             Unload Me
    End Select
End Sub

Private Sub xiaoshouyuantongji_Click()

End Sub