?? formclass2.frm
字號:
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 Formclass2
BorderStyle = 1 'Fixed Single
Caption = "瀏覽班級"
ClientHeight = 5730
ClientLeft = 45
ClientTop = 330
ClientWidth = 11910
Icon = "Formclass2.frx":0000
LinkTopic = "Form2"
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
ScaleHeight = 5730
ScaleWidth = 11910
Begin VB.Frame Frame2
Height = 5655
Left = 3120
TabIndex = 4
Top = 0
Width = 8655
Begin MSFlexGridLib.MSFlexGrid MSF1
Height = 5295
Left = 120
TabIndex = 5
Top = 240
Width = 8445
_ExtentX = 14896
_ExtentY = 9340
_Version = 393216
Cols = 1
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
Begin MSComctlLib.ImageList ImageList2
Left = -120
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 = "Formclass2.frx":0442
Key = "class"
Object.Tag = "class"
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Formclass2.frx":0772
Key = "cla2"
EndProperty
EndProperty
End
End
Begin VB.Frame Frame1
Caption = "瀏覽數據"
Height = 4695
Left = 0
TabIndex = 2
Top = 960
Width = 3015
Begin MSComctlLib.TreeView TreeView1
Height = 4335
Left = 120
TabIndex = 3
Top = 240
Width = 2775
_ExtentX = 4895
_ExtentY = 7646
_Version = 393217
HideSelection = 0 'False
LineStyle = 1
Style = 7
HotTracking = -1 'True
ImageList = "ImageList2"
Appearance = 1
End
End
Begin VB.Frame Frame3
Height = 940
Left = 0
TabIndex = 0
Top = 0
Width = 3040
Begin MSComctlLib.Toolbar Toolbar1
Height = 765
Left = 120
TabIndex = 1
Top = 120
Width = 2895
_ExtentX = 5106
_ExtentY = 1349
ButtonWidth = 1032
ButtonHeight = 1349
Style = 1
ImageList = "ImageList1"
_Version = 393216
BeginProperty Buttons {66833FE8-8583-11D1-B16A-00C0F0283628}
NumButtons = 7
BeginProperty Button1 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "查找"
Key = "find"
Object.Tag = "find"
ImageKey = "find"
EndProperty
BeginProperty Button2 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button3 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "修改"
Key = "modi"
Object.Tag = "modi"
ImageKey = "modi"
EndProperty
BeginProperty Button4 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button5 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "刪除"
Key = "del"
Object.Tag = "del"
ImageKey = "del"
EndProperty
BeginProperty Button6 {66833FEA-8583-11D1-B16A-00C0F0283628}
Style = 3
EndProperty
BeginProperty Button7 {66833FEA-8583-11D1-B16A-00C0F0283628}
Caption = "打印"
Key = "print"
Object.Tag = "print"
ImageKey = "print"
Style = 5
BeginProperty ButtonMenus {66833FEC-8583-11D1-B16A-00C0F0283628}
NumButtonMenus = 2
BeginProperty ButtonMenu1 {66833FEE-8583-11D1-B16A-00C0F0283628}
Key = "dang"
Text = "打印當前記錄"
EndProperty
BeginProperty ButtonMenu2 {66833FEE-8583-11D1-B16A-00C0F0283628}
Key = "all"
Text = "打印全部記錄"
EndProperty
EndProperty
EndProperty
EndProperty
End
End
Begin MSComctlLib.ImageList ImageList1
Left = 2880
Top = 2400
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 32
ImageHeight = 32
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 5
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Formclass2.frx":0BC6
Key = "del"
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Formclass2.frx":101E
Key = "print"
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Formclass2.frx":169A
Key = "find"
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Formclass2.frx":1AEE
Key = "modi"
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "Formclass2.frx":1F42
Key = "class"
Object.Tag = "class"
EndProperty
EndProperty
End
End
Attribute VB_Name = "Formclass2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public printstr As String
Public Sub classshowtitle()
Dim i As Integer
MSF1.Clear
With MSF1
.Cols = 8
.TextMatrix(0, 1) = "年級"
.TextMatrix(0, 2) = "班級"
.TextMatrix(0, 3) = "教室"
.TextMatrix(0, 4) = "年制"
.TextMatrix(0, 5) = "專業"
.TextMatrix(0, 6) = "班主任"
.TextMatrix(0, 7) = "備注"
.ColWidth(0) = 100
.ColWidth(1) = 1300
.ColWidth(2) = 1200
.ColWidth(3) = 800
.ColWidth(4) = 800
.ColWidth(5) = 800
.ColWidth(6) = 800
.ColWidth(7) = 5000
.FixedRows = 1
For i = 1 To 7
.ColAlignment(i) = 0
Next i
.FillStyle = flexFillSingle
.Col = 0
.Row = 0
.RowSel = 1
.ColSel = .Cols - 1
.CellAlignment = 4
.Row = 1
End With
End Sub
Public Sub classshowdata()
Dim j As Integer
Dim i As Integer
Dim mrc1 As ADODB.Recordset
Set mrc1 = ExecuteSQL(Trim(txtsql))
If mrc1.EOF = False Then
mrc1.MoveFirst
With MSF1
.Rows = 1
Do While Not mrc1.EOF
.Rows = .Rows + 1
For i = 1 To mrc1.Fields.Count
.TextMatrix(.Rows - 1, i) = mrc1.Fields(i - 1)
Next i
mrc1.MoveNext
Loop
mrc1.Close
End With
Else
If classfind = True Then
Formclass2.Hide
Formclass3.Show
zzz = MsgBox("對不起，沒有此班級的檔案記錄！", vbOKOnly, "查詢")
Formclass3.ZOrder (0)
Formclass3.Text1(0).SetFocus
End If
End If
End Sub
Private Sub Form_Activate()
If classfind = True Then
Formclass3.ZOrder 0
End If
If classfind = True Then
Exit Sub
ElseIf classmodi = True Then
classshowdata
' TreeView1_DblClick
classmodi = False
Else
classtree
End If
'If classfind = True Then
' Exit Sub
'Else
' MDIForm1.clabrowse
'End If
End Sub
Private Sub Toolbar1_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Tag
Case "find"
Formclass3.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
classmodi = True
Formclass1.Show
Formclass1.classload
Formclass1.ZOrder 0
End If
Case "del"
qxstr = Executeqx(2)
If qxstr = "readonly" Then
ss = MsgBox("對不起，你是只讀用戶不能刪除記錄，請與管理員聯系！", vbInformation + vbOKOnly, " 警告")
Exit Sub
End If
Dim mrc As ADODB.Recordset
Dim msgtext As String
Dim intcount As Integer
If Trim(Me.MSF1.TextMatrix(MSF1.Row, 1)) = "" Then
sssss = MsgBox("你還沒有選擇記錄！", vbOKOnly + vbExclamation, "警告")
Exit Sub
End If
If MsgBox("確定要刪除班級為 " & Trim(Me.MSF1.TextMatrix(MSF1.Row, 2)) & " 的記錄嗎？" & Chr(13) & Chr(10) & "繼續會導致該班級在成績和學費記錄的數據丟失，繼續嗎？", vbOKCancel + vbExclamation, "警告") = vbOK Then
txtsql = "delete * from xj where 班級='" & Trim(Me.MSF1.TextMatrix(MSF1.Row, 2)) & "'"
Set mrc = ExecuteSQL(txtsql)
txtsql = "select * from jf where 學號 in (select from xj where 班級='" & Trim(Me.MSF1.TextMatrix(MSF1.Row, 2)) & "')"
Set mrc = ExecuteSQL(txtsql) '刪除在交費表中的所有該班級的記錄
txtsql = "select * from cj where 學號 in (select from xj where 班級='" & Trim(Me.MSF1.TextMatrix(MSF1.Row, 2)) & "')"
Set mrc = ExecuteSQL(txtsql) '刪除在成績表中的所有該班級的記錄
txtsql = "delete * from class where 班級='" & Trim(Me.MSF1.TextMatrix(MSF1.Row, 2)) & "'"
Set mrc = ExecuteSQL(txtsql) '刪除該班級的記錄
End If
'txtsql = "select* from class "
classshowtitle
classshowdata
End Select
End Sub
Public Sub classtree()
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 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.rsCommand2.State = adStateOpen Then
DataEnv1.rsCommand2.Close
End If
DataEnv1.rsCommand2.Open printstr
If DataEnv1.rsCommand2.EOF = True Then
sssss = MsgBox("沒有當前記錄！", vbOKOnly + vbExclamation, "警告")
Exit Sub
End If
DataReportclass2.Show 1
Case "all"
If DataEnv1.rsCommand2.State = adStateOpen Then
DataEnv1.rsCommand2.Close
End If
DataEnv1.rsCommand2.Open ("select * from class")
If DataEnv1.rsCommand2.EOF = True Then
sssss = MsgBox("沒有當前記錄！", vbOKOnly + vbExclamation, "警告")
Exit Sub
End If
DataReportclass2.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 * from class where 年級='" & Trim(txtsql) & "' or 班級='" & Trim(txtsql) & "' order by 年級 ,班級 "
printstr = txtsql
Me.Caption = "瀏覽班級"
Me.classshowtitle
Me.classshowdata
Exit Sub
ss:
MSF1.Clear
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -