form3.frm

这是一个用VB做的学生管理系统

    .FillStyle = flexFillSingle
    .Col = 0
    .Row = 0
    .RowSel = 1
    .ColSel = .Cols - 1
    .CellAlignment = 4
    .Row = 1
    End With
End Sub







Private Sub Command1_Click()
MsgBox sss
 TreeView1.Nodes(sss).EnsureVisible
End Sub

Private Sub Form_Activate()
If find = True Then
Form4.ZOrder
End If
If find = True Then
  Exit Sub
ElseIf modi = True Then
showdata
 ' TreeView1_DblClick
  modi = False
Else
  tree
End If
End Sub

Public Sub showdata()

Dim j As Integer
Dim i As Integer

Dim mrc As ADODB.Recordset
Set mrc = New ADODB.Recordset
 Set mrc = ExecuteSQL(txtsql)
 If mrc.EOF = False Then
   mrc.MoveFirst
   With MSF1
    .Rows = 50
    .Row = 1
    Do While Not mrc.EOF
     .Rows = .Rows + 1
     For i = 1 To mrc.Fields.Count
      .TextMatrix(.Row, i) = mrc.Fields(i - 1)
     Next i
      .Row = .Row + 1
     mrc.MoveNext
    Loop
 End With
 Else
   If find = True Then
   Form3.Hide
   Form4.Show
   zzz = MsgBox("对不起，没有此学生的档案记录！", vbOKOnly, "查询")
   Form4.ZOrder (0)
   Form4.Text1(0).SetFocus
   
   End If
 End If
  Set mrc = Nothing
End Sub

Private Sub Form_Unload(Cancel As Integer)
If find = True Then
  find = False
  Form4.Text1(0).SetFocus
End If
End Sub


Public Sub tree()
TreeView1.Nodes.Clear
Dim nodex As Node
Dim mrc As ADODB.Recordset
Dim mrc1 As ADODB.Recordset
Dim str As String
Dim a As String
a = "年级"
 Set nodex = TreeView1.Nodes.Add(, , "厅", "山东轻工业学院", 3, 3)
'TreeView1.LineStyle = tvwRootLines
str = "select distinct 年级 from class order by 年级"
Set mrc = ExecuteSQL(str)
str = "select distinct 年级,班级 from class order by 年级,班级"
Set mrc1 = ExecuteSQL(str)
mrc.MoveFirst
Do Until mrc.EOF
  mrc1.MoveFirst
  Set nodex = TreeView1.Nodes.Add("厅", tvwChild, a, mrc.Fields(0), 1, 1)
  Do While Not mrc1.EOF
   If mrc1.Fields(0) = mrc.Fields(0) Then
     Set nodex = TreeView1.Nodes.Add(a, tvwChild, "a" & mrc1.Fields(1), mrc1.Fields(1), 2, 2)
     Set nodex = TreeView1.Nodes.Add("a" & mrc1.Fields(1), tvwChild, , "无", 2, 2)
   End If
   mrc1.MoveNext
  Loop
 
  a = a & "1"
  mrc.MoveNext
Loop
 mrc1.Close
 mrc.Close
 Set mrc = Nothing
  Set mrc1 = Nothing
  TreeView1.Nodes(10).EnsureVisible
End Sub

Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Tag
        Case "find"
        Form4.Show
        Case "modi"
                If Trim(Me.MSF1.TextMatrix(MSF1.Row, 1)) = "" Then
                  sssss = MsgBox("你还没有选择记录！", vbOKOnly + vbExclamation, "警告")
                Exit Sub
               Else
               qxstr = Executeqx(2)
              If qxstr = "readonly" Then
              ss = MsgBox("对不起，你是只读用户不能修改记录，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
              Exit Sub
              End If
               modi = True
               Form1.Show

               Form1.ZOrder 0
               End If
        Case "del"
               Dim mrc As ADODB.Recordset
             Dim intcount As Integer
              If Trim(Me.MSF1.TextMatrix(MSF1.Row, 1)) = "" Then
              sssss = MsgBox("你还没有选择记录！", vbOKOnly + vbExclamation, "警告")
              Else
              If qxstr = "readonly" Then
              ss = MsgBox("对不起，你是只读用户不能删除记录，请与管理员联系！", vbInformation + vbOKOnly, " 警告")
              Exit Sub
              End If
              If MsgBox("确定要删除学号为 " & Trim(Me.MSF1.TextMatrix(MSF1.Row, 1)) & " 的记录吗？" & Chr(10) & Chr(13) & "该操作会导致该学生交费记录和成绩记录的丢失！确定吗？", vbOKCancel + vbExclamation, "警告") = vbOK Then
             intcount = Me.MSF1.Row
            txtsql = "delete * from xj where 学号='" & Trim(Me.MSF1.TextMatrix(MSF1.Row, 1)) & "'"
           Set mrc = ExecuteSQL(txtsql)
           txtsql = "delete * from jf where 学号='" & Trim(Me.MSF1.TextMatrix(MSF1.Row, 1)) & "'"
           Set mrc = ExecuteSQL(txtsql)
           txtsql = "delete * from cj where 学号='" & Trim(Me.MSF1.TextMatrix(MSF1.Row, 1)) & "'"
           Set mrc = ExecuteSQL(txtsql)
             TreeView1_DblClick
             End If
             End If
       ' Case "print"
       ' Form6.Show
       ' Form6.ZOrder 0
End Select

End Sub

Private Sub Toolbar1_ButtonMenuClick(ByVal ButtonMenu As MSComctlLib.ButtonMenu)
  Select Case ButtonMenu.Key
  Case "dang"
  If Trim(printstr) = "" Then
    sssss = MsgBox("没有当前记录！", vbOKOnly + vbExclamation, "警告")
    Exit Sub
  End If
    If DataEnv1.rsCommand1.State = adStateOpen Then
     DataEnv1.rsCommand1.Close
    End If
     DataEnv1.rsCommand1.Open printstr
     If DataEnv1.rsCommand1.EOF = True Then
            sssss = MsgBox("没有当前记录！", vbOKOnly + vbExclamation, "警告")
      Exit Sub
    End If
    DataReportclass.Show 1
   Case "all"
     If DataEnv1.rsCommand1.State = adStateOpen Then
     DataEnv1.rsCommand1.Close
    End If
     DataEnv1.rsCommand1.Open ("select xj.学号,xj.姓名,xj.性别,xj.班级,xj.出生年月,xj.家庭住址,xj.邮政编码,xj.联系电话,xj.入学时间,xj.备注,class.专业 from xj inner join class on xj.班级=class.班级")
     If DataEnv1.rsCommand1.EOF = True Then
            sssss = MsgBox("没有当前记录！", vbOKOnly + vbExclamation, "警告")
      Exit Sub
    End If
    DataReportclass.Show 1
  End Select
End Sub



Private Sub TreeView1_DblClick()
On Error GoTo ss
If TreeView1.SelectedItem.Index = 0 Then
MSF1.Clear
Exit Sub
End If
txtsql = TreeView1.Nodes.Item(TreeView1.SelectedItem.Index).Key

   txtsql = "select xj.学号,xj.姓名,xj.性别,class.年级,xj.班级,class.专业,class.年制,xj.出生年月,xj.家庭住址,xj.邮政编码,xj.联系电话,xj.入学时间,xj.备注 from xj inner join class on xj.班级=class.班级  where xj.班级='" & txtsql & "' or 年级='" & txtsql & "' order by class.年级 ,class.班级 ,xj.学号 "
   printstr = txtsql
Me.Caption = "浏览学生档案"
Me.showtitle
Me.showdata
Exit Sub
ss:
MSF1.Clear
End Sub

Private Sub TreeView1_Expand(ByVal Node As MSComctlLib.Node)

sss = Node.Index

'MsgBox Node.Parent.Text '上一级的text
'MsgBox Node.Key
Dim nodex As Node
Dim mrc As ADODB.Recordset
Dim mrc1 As ADODB.Recordset
Dim str As String
Dim a, ss As String
'ss = InStr(1, Node.FullPath, "/")
If InStr(1, Node.Key, "a") <= 0 Then
Exit Sub
End If
 If TreeView1.Nodes(sss).Tag = "true" Then
 Else
   TreeView1.Nodes.Remove (Node.Child.FirstSibling.Index)
   Dim ww As ADODB.Recordset
   Set ww = New ADODB.Recordset
   txtsql = "select 姓名 from xj where 班级='" & Trim(Replace(Node.Key, "a", "")) & "'"
 Set ww = ExecuteSQL(txtsql)
     Do Until ww.EOF
    Set nodex = TreeView1.Nodes.Add(Node.Key, tvwChild, , ww.Fields(0), 4, 4)
    ww.MoveNext
    Loop
    TreeView1.Nodes(sss).Tag = "true"
    TreeView1.Nodes(sss).Text = TreeView1.Nodes(sss).Text
     TreeView1.Nodes(sss).EnsureVisible
  End If
  
'MsgBox TreeView1.Nodes(sss).Child.FirstSibling.Index & "  " & sss
End Sub