form3.frm

从别处拿来感觉还可以 内容比较多且完备值得大家看一看

        .TextMatrix(0, 8) = "出生年月"
        .TextMatrix(0, 9) = "家庭住址"
        .TextMatrix(0, 10) = "邮政编码"
        .TextMatrix(0, 11) = "联系电话"
        .TextMatrix(0, 12) = "入学时间"
        .TextMatrix(0, 13) = "备注"
        .ColWidth(0) = 200
        .ColWidth(1) = 500
        .ColWidth(2) = 700
        .ColWidth(3) = 500
        .ColWidth(4) = 1000
        .ColWidth(5) = 800
        .ColWidth(6) = 700
        .ColWidth(7) = 800
        .ColWidth(8) = 800
        .ColWidth(9) = 3000
        .ColWidth(10) = 800
        .ColWidth(11) = 1000
        .ColWidth(12) = 800
        .ColWidth(13) = 6000
        .FixedRows = 1
        For i = 1 To 13
            .ColAlignment(i) = 0
        Next i
        .FillStyle = flexFillSingle
        .Col = 0
        .Row = 0
        .RowSel = 1
        .ColSel = .Cols - 1
        .CellAlignment = 4
        .Row = 1
    End With
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
          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 = "年级"
    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(, , 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, , mrc1.Fields(1), 2, 2)
            End If
            mrc1.MoveNext
        Loop
        a = a & "1"
        mrc.MoveNext
    Loop
    mrc1.Close
    mrc.Close
    Set mrc = Nothing
    Set mrc1 = Nothing
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
    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)
    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