mdifrmmain.frm

本程序用VB+SQL 2000实现,可以实现小区的住户资料,仪表资料,住户投宿,住户报修等数据的查询,修改,删除,统计和以报表形式打印输出.

VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.MDIForm MDIfrmMain 
   BackColor       =   &H8000000C&
   Caption         =   "小区管理系统"
   ClientHeight    =   7080
   ClientLeft      =   165
   ClientTop       =   735
   ClientWidth     =   9750
   LinkTopic       =   "MDIForm1"
   Picture         =   "MDIfrmMain.frx":0000
   StartUpPosition =   3  '窗口缺省
   WindowState     =   2  'Maximized
   Begin MSComctlLib.ImageList ImageList1 
      Left            =   1560
      Top             =   2280
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   32
      ImageHeight     =   32
      MaskColor       =   12632256
      _Version        =   393216
      BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
         NumListImages   =   6
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "MDIfrmMain.frx":CB53
            Key             =   ""
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "MDIfrmMain.frx":D42D
            Key             =   ""
         EndProperty
         BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "MDIfrmMain.frx":D9C7
            Key             =   ""
         EndProperty
         BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "MDIfrmMain.frx":DF61
            Key             =   ""
         EndProperty
         BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "MDIfrmMain.frx":E83B
            Key             =   ""
         EndProperty
         BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "MDIfrmMain.frx":F115
            Key             =   ""
         EndProperty
      EndProperty
   End
   Begin MSComctlLib.Toolbar Toolbar1 
      Align           =   1  'Align Top
      Height          =   870
      Left            =   0
      TabIndex        =   1
      Top             =   0
      Width           =   9750
      _ExtentX        =   17198
      _ExtentY        =   1535
      ButtonWidth     =   2090
      ButtonHeight    =   1376
      Appearance      =   1
      ImageList       =   "ImageList1"
      HotImageList    =   "ImageList1"
      _Version        =   393216
      BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628} 
         NumButtons      =   11
         BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "房产资料"
            Key             =   "fchzl"
            ImageIndex      =   1
            BeginProperty ButtonMenus {66833FEC-8583-11D1-B16A-00C0F0283628} 
               NumButtonMenus  =   1
               BeginProperty ButtonMenu1 {66833FEE-8583-11D1-B16A-00C0F0283628} 
               EndProperty
            EndProperty
         EndProperty
         BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "仪表数据管理"
            Key             =   "ybshj"
            ImageIndex      =   2
         EndProperty
         BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "收费管理"
            Key             =   "feegl"
            ImageIndex      =   3
         EndProperty
         BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "仪表数据统计"
            Key             =   "ybtj"
            ImageIndex      =   4
         EndProperty
         BeginProperty Button8 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button9 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "收费统计"
            Key             =   "feetj"
            ImageIndex      =   5
         EndProperty
         BeginProperty Button10 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Style           =   3
         EndProperty
         BeginProperty Button11 {66833FEA-8583-11D1-B16A-00C0F0283628} 
            Caption         =   "退出"
            Key             =   "exit"
            ImageIndex      =   6
         EndProperty
      EndProperty
   End
   Begin MSComctlLib.StatusBar StatusBar1 
      Align           =   2  'Align Bottom
      Height          =   375
      Left            =   0
      TabIndex        =   0
      Top             =   6705
      Width           =   9750
      _ExtentX        =   17198
      _ExtentY        =   661
      _Version        =   393216
      BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628} 
         NumPanels       =   3
         BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
            Alignment       =   1
            AutoSize        =   1
            Object.Width           =   11562
            Text            =   "小区物业管理系统"
            TextSave        =   "小区物业管理系统"
         EndProperty
         BeginProperty Panel2 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
            Alignment       =   1
            Text            =   "信计03-1班"
            TextSave        =   "信计03-1班"
         EndProperty
         BeginProperty Panel3 {8E3867AB-8586-11D1-B16A-00C0F0283628} 
            Style           =   5
            TextSave        =   "上午 11:21"
         EndProperty
      EndProperty
   End
   Begin VB.Menu mnLoginSys 
      Caption         =   "登录系统"
      Begin VB.Menu mnLogin 
         Caption         =   "用户登录"
      End
      Begin VB.Menu mnChPwd 
         Caption         =   "修改密码"
      End
      Begin VB.Menu mnAddUser 
         Caption         =   "添加用户"
      End
      Begin VB.Menu mnExit 
         Caption         =   "退出系统"
      End
   End
   Begin VB.Menu mnBasicData 
      Caption         =   "基本资料"
      Begin VB.Menu mnClient 
         Caption         =   "住户资料"
      End
      Begin VB.Menu mnHouse 
         Caption         =   "房产资料"
      End
   End
   Begin VB.Menu mnWuYe 
      Caption         =   "物业管理"
      Begin VB.Menu mnYiBiao 
         Caption         =   "仪表数据管理"
      End
      Begin VB.Menu mnPark 
         Caption         =   "停车场管理"
      End
      Begin VB.Menu mnFee 
         Caption         =   "收费管理"
      End
      Begin VB.Menu mnTouSu 
         Caption         =   "住户投诉管理"
      End
      Begin VB.Menu mnBaoXiu 
         Caption         =   "住户报修管理"
      End
   End
   Begin VB.Menu mnDataTg 
      Caption         =   "数据报表统计"
      Begin VB.Menu mnYiBiaoTg 
         Caption         =   "仪表数据统计"
      End
      Begin VB.Menu mnFeeTg 
         Caption         =   "收费统计"
      End
      Begin VB.Menu mnTouSuTg 
         Caption         =   "住户投诉统计"
      End
      Begin VB.Menu mnBaoXiuTg 
         Caption         =   "住户报修统计"
      End
   End
   Begin VB.Menu mnHelp 
      Caption         =   "帮助(&H)"
      Begin VB.Menu mnAbout 
         Caption         =   "关于"
      End
   End
End
Attribute VB_Name = "MDIfrmMain"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdExit_Click()
   Unload Me
End Sub

Private Sub cmdFee_Click()
   frmCharge.Show
End Sub

Private Sub cmdHouse_Click()
   frmHouse.Show
End Sub

Private Sub cmdTgFee_Click()
   frmTgFee.Show
End Sub

Private Sub cmdTgYB_Click()
   frmTgYiBiao.Show
End Sub

Private Sub cmdYiBiao_Click()
   frmYiBiao.Show
End Sub

Private Sub MDIForm_Load()
   ' 在主窗体中打开对数据库的连接
   Dim strCnn As String   '定义一个连接串变量
   strCnn = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=XiaoQu"
   conn.Open strCnn
   mnAddUser.Enabled = False   '设置添加新用户菜单不可用
   mnBasicData.Enabled = False
   mnWuYe.Enabled = False
   mnDataTg.Enabled = False
   
    Toolbar1.Enabled = False
  

   
 
   
End Sub

Private Sub MDIForm_Unload(Cancel As Integer)
   conn.Close
End Sub

Private Sub mnAbout_Click()
frmAbout.Show

End Sub

Private Sub mnAddUser_Click()
   frmAddUser.Show
End Sub

Private Sub mnBaoXiu_Click()
   frmBaoXiu.Show
End Sub

Private Sub mnBaoXiuTg_Click()
   frmTgBaoXiu.Show
End Sub

Private Sub mnChPwd_Click()
   frmChPwd.Show
End Sub

Private Sub mnClient_Click()
   frmClient.Show
End Sub

Private Sub mnEmp_Click()
   frmEmp.Show
End Sub

Private Sub mnEquipment_Click()
   frmEquipment.Show
End Sub

Private Sub mnEquipTg_Click()
   frmTgEquip.Show
End Sub

Private Sub mnExit_Click()
   Unload Me
End Sub

Private Sub mnFee_Click()
   frmCharge.Show
End Sub

Private Sub mnFeeTg_Click()
   frmTgFee.Show
End Sub

Private Sub mnHouse_Click()
   frmHouse.Show
End Sub

Private Sub mnLogin_Click()
   frmLogin.Show
End Sub

Private Sub mnPark_Click()
   frmPark.Show
End Sub

Private Sub mnRepair_Click()
   frmRepair.Show
End Sub

Private Sub mnRepairTg_Click()
   frmTgRepair.Show
End Sub

Private Sub mnTousu_Click()
   frmTouSu.Show
End Sub

Private Sub mnTouSuTg_Click()
   frmTgTouSu.Show
End Sub

Private Sub mnYibiao_Click()
   frmYiBiao.Show
End Sub

Private Sub mnYiBiaoTg_Click()
   frmTgYiBiao.Show
End Sub

Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Key
Case "fchzl"
      frmHouse.Show
Case "ybshj"
      frmYiBiao.Show
Case "feegl"
      frmCharge.Show
Case "ybtj"
      frmTgYiBiao.Show
Case "feetj"
      frmTgFee.Show
Case "exit"
      Unload Me
End Select

End Sub