VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form frmjf2 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "交費瀏覽"
   ClientHeight    =   6330
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   11910
   Icon            =   "Form2.frx":0000
   LinkTopic       =   "Form2"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   6330
   ScaleWidth      =   11910
   Begin VB.Frame Frame2 
      Caption         =   "班級"
      Height          =   5895
      Left            =   0
      TabIndex        =   3
      Top             =   360
      Width           =   2655
      Begin MSComctlLib.TreeView TreeView1 
         Height          =   5535
         Left            =   120
         TabIndex        =   4
         Top             =   240
         Width           =   2415
         _ExtentX        =   4260
         _ExtentY        =   9763
         _Version        =   393217
         HideSelection   =   0   'False
         LineStyle       =   1
         Style           =   7
         FullRowSelect   =   -1  'True
         HotTracking     =   -1  'True
         ImageList       =   "ImageList2"
         BorderStyle     =   1
         Appearance      =   1
      End
   End
   Begin VB.Frame Frame1 
      Caption         =   "交費瀏覽"
      Height          =   5895
      Left            =   2685
      TabIndex        =   0
      Top             =   360
      Width           =   9015
      Begin MSFlexGridLib.MSFlexGrid MSF1 
         Height          =   5535
         Left            =   120
         TabIndex        =   1
         Top             =   240
         Width           =   8805
         _ExtentX        =   15531
         _ExtentY        =   9763
         _Version        =   393216
         BackColor       =   -2147483624
         BackColorFixed  =   12632256
         ForeColorFixed  =   0
         BackColorSel    =   16777215
         ForeColorSel    =   255
         BackColorBkg    =   -2147483624
         AllowBigSelection=   -1  'True
         SelectionMode   =   1
         AllowUserResizing=   3
         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 MSComctlLib.ImageList ImageList2 
      Left            =   960
      Top             =   0
      _ExtentX        =   1005
      _ExtentY        =   1005
      BackColor       =   -2147483643
      ImageWidth      =   16
      ImageHeight     =   16
      MaskColor       =   12632256
      _Version        =   393216
      BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628} 
         NumListImages   =   2
         BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "Form2.frx":0442
            Key             =   "class"
            Object.Tag             =   "class"
         EndProperty
         BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628} 
            Picture         =   "Form2.frx":0772
            Key             =   "cla2"
         EndProperty
      EndProperty
   End
   Begin VB.Label Label1 
      Caption         =   "雙擊數據即可得到該學生對應的詳細交費情況列表"
      BeginProperty Font 
         Name            =   "宋體"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000FF&
      Height          =   255
      Left            =   2760
      TabIndex        =   2
      Top             =   120
      Width           =   4935
   End
End
Attribute VB_Name = "frmjf2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public maxx As String
Public classtxt As String
Dim num As String

Public Sub jfshowtitle()
MSF1.Clear
  Dim i As Integer
  With MSF1
    .Cols = 10
    .TextMatrix(0, 1) = "學號"
    .TextMatrix(0, 2) = "姓名"
    .TextMatrix(0, 3) = "班級"
    .TextMatrix(0, 4) = "學期"
    .TextMatrix(0, 5) = "本次交費(元)"
    .TextMatrix(0, 6) = "本次欠費(元)"
    .TextMatrix(0, 7) = "累計欠費(元)"
    .TextMatrix(0, 8) = "日期"
    .TextMatrix(0, 9) = "操作員"
  
    .ColWidth(0) = 200
    .ColWidth(1) = 800
    .ColWidth(2) = 1000
    .ColWidth(3) = 1000
    .ColWidth(4) = 2300
    .ColWidth(5) = 1200
    .ColWidth(6) = 1200
    .ColWidth(7) = 1200
    .ColWidth(8) = 900
    .ColWidth(9) = 900
    .FixedRows = 1
    For i = 1 To 4
      .ColAlignment(i) = 0
    Next i
    For i = 5 To 9
      .ColAlignment(i) = 6 '靠右
    Next i
    .FillStyle = flexFillSingle
    .Col = 0
    .Row = 0
    .RowSel = 1
    .ColSel = .Cols - 1
    .CellAlignment = 4
    .Row = 1
    End With
End Sub



Public Sub xuefeidata()


jfshowtitle
max
Dim mrc As ADODB.Recordset

Dim mrc2 As ADODB.Recordset
txtsql = "select jf.學號,xj.姓名,xj.班級,jf.學期,jf.交費,jf.欠費,jf.日期,jf.操作員 from jf inner join xj on jf.學號=xj.學號 where jf.學期='" & maxx & "年度第二學期 ' and xj.班級='" & Trim(classtxt) & "' order by jf.學號,jf.日期"
Set mrc = ExecuteSQL(txtsql)
If mrc.EOF = True Then
txtsql = "select jf.學號,xj.姓名,xj.班級,jf.學期,jf.交費,jf.欠費,jf.日期,jf.操作員 from jf inner join xj on jf.學號=xj.學號 where jf.學期='" & maxx & "年度第一學期 ' and xj.班級='" & Trim(classtxt) & "' order by jf.學號,jf.日期"
Set mrc = ExecuteSQL(txtsql)
If mrc.EOF = True Then
 MSF1.Clear
 Exit Sub
Else
 maxx = maxx & "年度第一學期"
End If
Else
maxx = maxx & "年度第二學期"
End If
'txtsql = "select 學號,sum(欠費) from jf where 學期<>'" & maxx & "' and 學號 in (select 學號 from jf where 學期='" & maxx & "') and 學號 in (select 學號 from xj where 班級='" & Trim(classtxt) & "') group by 學號 "
'Set mrc1 = ExecuteSQL(txtsql)
txtsql = "select 學號,sum(欠費) from jf where   學號 in (select 學號 from xj where 班級='" & Trim(classtxt) & "') group by 學號 "
Set mrc2 = ExecuteSQL(txtsql)
Dim j As Integer
Dim i As Integer
If mrc.EOF = True Then
 MSF1.Clear
 Exit Sub
End If
mrc.MoveFirst

With MSF1
 .Rows = 20
    .Row = 1
 
 Do Until mrc.EOF
   .Rows = .Rows + 1
   .TextMatrix(.Row, 1) = mrc.Fields(0)
   .TextMatrix(.Row, 2) = mrc.Fields(1)
    .TextMatrix(.Row, 3) = mrc.Fields(2)
    .TextMatrix(.Row, 4) = mrc.Fields(3)
   .TextMatrix(.Row, 5) = "￥" & Format(mrc.Fields(4), "0.00")
   
   If Val(mrc.Fields(5)) >= 0 Then
   '.MergeCells = flexMergeFree
  ' .MergeRow(0) = True
 ' .MergeCol(7) = True
    .TextMatrix(.Row, 6) = "￥" & Format(mrc.Fields(5), "0.00")
   Else
      .TextMatrix(.Row, 6) = "-￥" & Format(-Val(mrc.Fields(5)), "0.00")
   End If
    .TextMatrix(.Row, 7) = "￥" & Format(mrc2.Fields(1), "0.00")
       .TextMatrix(.Row, 8) = mrc.Fields(6)
        .TextMatrix(.Row, 9) = mrc.Fields(7)
    
    
      
       
     
   .Row = .Row + 1
        mrc.MoveNext
        num = mrc2.Fields(0)
       mrc2.MoveNext
       If mrc.EOF = False Then
    If Trim(num) = Trim(mrc.Fields(0)) Then
      mrc2.MovePrevious
    End If
    End If
 Loop
 End With
End Sub

Private Sub Command1_Click()

End Sub

Private Sub Form_Activate()
'jfshowtitle
jftree
End Sub

Private Sub max()
Dim mrc As ADODB.Recordset
txtsql = "select max(學期) from jf  where 學號 in (select 學號 from class where 班級='" & Trim(classtxt) & "')"
Set mrc = ExecuteSQL(txtsql)
If mrc.EOF = True Then
  Exit Sub
  Else
  If IsNull(mrc.Fields(0)) Then
  Exit Sub
  End If
End If
maxx = Left(mrc.Fields(0), 11)
g = 1
End Sub

Private Sub Form_Load()
MSF1.Clear
jfshowtitle
End Sub

Private Sub MSF1_DblClick()
   If Trim(Me.MSF1.TextMatrix(MSF1.Row, 1)) = "" Then
                  sssss = MsgBox("無當前選擇記錄！", vbOKOnly + vbExclamation, "警告")
                Exit Sub
               End If
Frmjf3.Show 1
End Sub

Public Sub jftree()
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 = "年級"
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(, , 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 TreeView1_DblClick()
On Error GoTo ss
If TreeView1.SelectedItem.Index = 0 Then
MSF1.Clear
Exit Sub
End If
classtxt = TreeView1.Nodes.Item(TreeView1.SelectedItem.Index)
xuefeidata
Exit Sub
ss:
MSF1.Clear
End Sub