frm_zyinfocu.frm

主要是实现物业管理功能！可以帮助了解该区的相关物业情况

         ButtonBackColor =   16744576
         BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
      End
      Begin 工程1.GurhanCoolButton GurhanCoolButton5 
         Height          =   495
         Left            =   7092
         TabIndex        =   5
         Top             =   45
         Width           =   1335
         _ExtentX        =   2355
         _ExtentY        =   873
         ButtonIcon      =   "Frm_zyinfocu.frx":0FA2
         CaptionTitle    =   "条件查询    "
         ButtonBackColor =   16744576
         BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
      End
      Begin 工程1.GurhanCoolButton GurhanCoolButton6 
         Height          =   495
         Left            =   6054
         TabIndex        =   6
         Top             =   45
         Width           =   855
         _ExtentX        =   1508
         _ExtentY        =   873
         ButtonIcon      =   "Frm_zyinfocu.frx":14C4
         CaptionTitle    =   "打 印   "
         ButtonBackColor =   16744576
         BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
      End
      Begin 工程1.GurhanCoolButton GurhanCoolButton7 
         Height          =   495
         Left            =   8610
         TabIndex        =   7
         Top             =   45
         Width           =   975
         _ExtentX        =   1720
         _ExtentY        =   873
         ButtonIcon      =   "Frm_zyinfocu.frx":199E
         CaptionTitle    =   "退 出  "
         ButtonBackColor =   16744576
         BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851} 
            Name            =   "宋体"
            Size            =   9
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
      End
   End
   Begin VB.TextBox Text1 
      Height          =   1695
      Left            =   2625
      TabIndex        =   10
      Text            =   "Text1"
      Top             =   2730
      Width           =   3060
   End
End
Attribute VB_Name = "Frm_zyinfocu"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private ObjOldWidth As Long  '保存窗体的原始宽度
Private ObjOldHeight As Long '保存窗体的原始高度
Private ObjOldFont As Single '保存窗体的原始字体比
Private Sub Command1_Click()
Adodc1.RecordSource = "select * from tab_职工  "
Adodc1.Refresh
End Sub

Private Sub Command1_GotFocus()
Adodc1.RecordSource = "select * from tab_职工  "
Adodc1.Refresh
End Sub

Private Sub DataList1_Click()
Text1.Text = DataList1.Text
Adodc1.RecordSource = "select * from tab_职工 where 姓名 like '" & Text1.Text & "' "
Adodc1.Refresh
End Sub


Private Sub Form_Load()
 If Frm_load.group = "3" Then
    GurhanCoolButton1.Visible = False
    GurhanCoolButton2.Visible = False
    GurhanCoolButton4.Visible = False
     
  End If
 Call ResizeInit(Me)
End Sub

Private Sub GurhanCoolButton1_CLICKED()
frm_zyinfo.Show
frm_zyinfo.Adodc1.Recordset.AddNew
Call text_clear

End Sub

Private Sub GurhanCoolButton2_CLICKED()
Dim res As Integer
res = MsgBox("确实要删除此员工的信息吗?", vbExclamation + vbYesNo + vbDefaultButton2)
If res = vbYes Then
 
Adodc1.Recordset.Delete
Adodc1.Refresh
End If
Adodc1.RecordSource = "select * from tab_职工  "
Adodc1.Refresh
End Sub

Private Sub GurhanCoolButton4_CLICKED()
frm_zyinfo.Adodc1.RecordSource = "select * from tab_职工 where 姓名 like '" & Text1.Text & "' "
frm_zyinfo.Adodc1.Refresh
frm_zyinfo.Show
End Sub

Private Sub GurhanCoolButton5_CLICKED()
Frm_tjxu.Show

End Sub

Private Sub GurhanCoolButton7_CLICKED()
Unload Me


End Sub

'在调用ResizeForm前先调用本函数
Public Sub ResizeInit(FormName As Form)
  Dim Obj As Control
  
  ObjOldWidth = FormName.ScaleWidth
  ObjOldHeight = FormName.ScaleHeight
  ObjOldFont = FormName.Font.Size / ObjOldHeight
  On Error Resume Next
  For Each Obj In FormName
    Obj.Tag = Obj.Left & " " & Obj.Top & " " & Obj.Width & " " & Obj.Height & " "
  Next Obj
  
  On Error GoTo 0
End Sub

'按比例改变表单内各元件的大小，
'在调用ReSizeForm前先调用ReSizeInit函数
Public Sub ResizeForm(FormName As Form)

  Dim Pos(4) As Double
  Dim i As Long, TempPos As Long, StartPos As Long
  Dim Obj As Control
  Dim ScaleX As Double, ScaleY As Double
  
  ScaleX = FormName.ScaleWidth / ObjOldWidth
  '保存窗体宽度缩放比例
  ScaleY = FormName.ScaleHeight / ObjOldHeight
  '保存窗体高度缩放比例
  On Error Resume Next
  
  For Each Obj In FormName
    StartPos = 1
    For i = 0 To 4
      '读取控件的原始位置与大小
      TempPos = InStr(StartPos, Obj.Tag, " ", vbTextCompare)
      If TempPos > 0 Then
        Pos(i) = Mid(Obj.Tag, StartPos, TempPos - StartPos)
        StartPos = TempPos + 1
      Else
        Pos(i) = 0
      End If
      
      '根据控件的原始位置及窗体改变大
      '小的比例对控件重新定位与改变大小
      Obj.Move Pos(0) * ScaleX, Pos(1) * ScaleY, Pos(2) * ScaleX, Pos(3) * ScaleY
      Obj.Font.Size = ObjOldFont * FormName.ScaleHeight
    Next i
  
  Next Obj
  
  On Error GoTo 0
End Sub

Private Sub Form_Resize()
  '确保窗体改变时控件随之改变
  Call ResizeForm(Me)
End Sub