frmmain.frm

一个优秀的售楼系统,可供毕业生毕业设计参考

VERSION 5.00
Begin VB.Form frmmain 
   BackColor       =   &H00FF8080&
   Caption         =   "售楼管理系统"
   ClientHeight    =   7920
   ClientLeft      =   165
   ClientTop       =   255
   ClientWidth     =   10320
   LinkTopic       =   "Form1"
   Picture         =   "frmmain.frx":0000
   ScaleHeight     =   7920
   ScaleWidth      =   10320
   StartUpPosition =   2  '屏幕中心
   WindowState     =   2  'Maximized
   Begin VB.PictureBox CommonDialog1 
      Height          =   480
      Left            =   6240
      ScaleHeight     =   420
      ScaleWidth      =   1140
      TabIndex        =   1
      Top             =   1200
      Width           =   1200
   End
   Begin VB.PictureBox Toolbar1 
      Align           =   1  'Align Top
      Height          =   900
      Left            =   0
      ScaleHeight     =   840
      ScaleWidth      =   10260
      TabIndex        =   0
      Top             =   0
      Width           =   10320
   End
   Begin VB.PictureBox ImageList1 
      BackColor       =   &H80000005&
      Height          =   480
      Left            =   2280
      ScaleHeight     =   420
      ScaleWidth      =   1140
      TabIndex        =   2
      Top             =   1800
      Width           =   1200
   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 sysmanage 
      Caption         =   "系统管理"
      Begin VB.Menu adduser 
         Caption         =   "添加用户"
      End
      Begin VB.Menu changepwd 
         Caption         =   "更改密码"
      End
      Begin VB.Menu exitsys 
         Caption         =   "退出系统"
      End
   End
End
Attribute VB_Name = "frmmain"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub adduser_Click()
frmadduser.Show
End Sub

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 changepwd_Click()
frmchangepwd.Show
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
conn.Close
Set conn = Nothing
Set fsofile = CreateObject("scripting.filesystemobject")
CommonDialog1.Filter = "mdb文件(*.mdb)|*.mdb"
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
End Sub

Private Sub databaserecovery_Click()
Dim fsofile
conn.Close
Set conn = Nothing
Set fsofile = CreateObject("scripting.filesystemobject")
CommonDialog1.Filter = "mdb文件(*.mdb)|*.mdb"
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
End Sub

Private Sub exitsys_Click()
conn.Close
Set conn = Nothing
End
End Sub

Private Sub Form_Load()
If username = "guest" Then
   buildingsalebargain.Enabled = False
   databaserecovery.Enabled = False
   adduser.Enabled = False
End If

End Sub

Private Sub gatheringfind_Click()
frmshoukuanfind.Show
End Sub

Private Sub gatheringmanage_Click()
frmshoukuanlogin.Show 1
End Sub

Private Sub hetongtongji_Click()
Form16.Show
End Sub

Private Sub housestylefind_Click()
Form4.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"
     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"
     End
End Select
End Sub

Private Sub xiaoshouyuantongji_Click()

End Sub