📄 courtable.frm
字号:
Begin VB.TextBox Text33
Height = 495
Left = 5640
TabIndex = 32
Top = 2640
Width = 1095
End
Begin VB.TextBox Text32
Height = 495
Left = 4560
TabIndex = 31
Top = 5040
Width = 1095
End
Begin VB.TextBox Text31
Height = 495
Left = 4560
TabIndex = 30
Top = 4560
Width = 1095
End
Begin VB.TextBox Text30
Height = 495
Left = 4560
TabIndex = 29
Top = 4080
Width = 1095
End
Begin VB.TextBox Text29
Height = 495
Left = 4560
TabIndex = 28
Top = 3600
Width = 1095
End
Begin VB.TextBox Text28
Height = 495
Left = 4560
TabIndex = 27
Top = 3120
Width = 1095
End
Begin VB.TextBox Text27
Height = 495
Left = 4560
TabIndex = 26
Top = 2640
Width = 1095
End
Begin VB.TextBox Text26
Height = 495
Left = 3600
TabIndex = 25
Top = 5040
Width = 975
End
Begin VB.TextBox Text25
Height = 495
Left = 3600
TabIndex = 24
Top = 4560
Width = 975
End
Begin VB.TextBox Text24
Height = 495
Left = 3600
TabIndex = 23
Top = 4080
Width = 975
End
Begin VB.TextBox Text23
Height = 495
Left = 3600
TabIndex = 22
Top = 3600
Width = 975
End
Begin VB.TextBox Text22
Height = 495
Left = 3600
TabIndex = 21
Top = 3120
Width = 975
End
Begin VB.TextBox Text21
Height = 495
Left = 3600
TabIndex = 20
Top = 2640
Width = 975
End
Begin VB.TextBox Text20
Height = 495
Left = 2640
TabIndex = 19
Top = 5040
Width = 975
End
Begin VB.TextBox Text19
Height = 495
Left = 2640
TabIndex = 18
Top = 4560
Width = 975
End
Begin VB.TextBox Text18
Height = 495
Left = 2640
TabIndex = 17
Top = 4560
Width = 975
End
Begin VB.TextBox Text17
Height = 495
Left = 2640
TabIndex = 16
Top = 4560
Width = 975
End
Begin VB.TextBox Text16
Height = 495
Left = 2640
TabIndex = 15
Top = 4080
Width = 975
End
Begin VB.TextBox Text15
Height = 495
Left = 2640
TabIndex = 14
Top = 3600
Width = 975
End
Begin VB.TextBox Text14
Height = 495
Left = 2640
TabIndex = 13
Top = 3120
Width = 975
End
Begin VB.TextBox Text13
Height = 495
Left = 2640
TabIndex = 12
Top = 2640
Width = 975
End
Begin VB.TextBox Text12
Height = 495
Left = 1680
TabIndex = 11
Top = 5040
Width = 975
End
Begin VB.TextBox Text11
Height = 495
Left = 1680
TabIndex = 10
Top = 4560
Width = 975
End
Begin VB.TextBox Text10
Height = 495
Left = 1680
TabIndex = 9
Top = 4080
Width = 975
End
Begin VB.TextBox Text9
Height = 495
Left = 1680
TabIndex = 8
Top = 3600
Width = 975
End
Begin VB.TextBox Text8
Height = 495
Left = 1680
TabIndex = 7
Top = 3120
Width = 975
End
Begin VB.TextBox Text7
Height = 495
Left = 1680
TabIndex = 6
Top = 2640
Width = 975
End
Begin VB.TextBox Text6
Height = 495
Left = 480
TabIndex = 5
Text = "星期六"
Top = 5040
Width = 1215
End
Begin VB.TextBox Text5
Height = 495
Left = 480
TabIndex = 4
Text = "星期五"
Top = 4560
Width = 1215
End
Begin VB.TextBox Text4
Height = 495
Left = 480
TabIndex = 3
Text = "星期四"
Top = 4080
Width = 1215
End
Begin VB.TextBox Text3
Height = 495
Left = 480
TabIndex = 2
Text = "星期三"
Top = 3600
Width = 1215
End
Begin VB.TextBox Text2
Height = 495
Left = 480
TabIndex = 1
Text = "星期二"
Top = 3120
Width = 1215
End
Begin VB.TextBox Text1
Height = 495
Left = 480
TabIndex = 0
Text = "星期一"
Top = 2640
Width = 1215
End
Begin VB.Label Label3
Caption = "课程表"
BeginProperty Font
Name = "宋体"
Size = 21.75
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 495
Left = 7800
TabIndex = 80
Top = 720
Width = 1455
End
Begin VB.Label Label2
Caption = "班"
BeginProperty Font
Name = "宋体"
Size = 21.75
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF0000&
Height = 375
Left = 4560
TabIndex = 78
Top = 720
Width = 495
End
Begin VB.Label Label1
Caption = "Label1"
Height = 495
Left = 5640
TabIndex = 76
Top = 3120
Width = 975
End
End
Attribute VB_Name = "addtable"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command2_Click()
If Command2.Caption = "确定(&O)" Then
If Not Testtxt(Text63.Text) Then
MsgBox "请输入班级！", 48, "提示"
Text63.SetFocus
Exit Sub
End If
If Not Testtxt(Text64.Text) Then
MsgBox "请输入时间！", 48, "提示"
Text64.SetFocus
Exit Sub
End If
'+++++++++++++++++++++++++++++++++++++++++++++++++
txtSQL = "select * from coutable "
Set dream = ExecuteSQL(txtSQL, Msgtext)
dream.MoveFirst
While (dream.EOF = False)
If (dream.Fields(1)) = Trim(Text41.Text) Then
MsgBox "该班课程表已经添加，需要修改请点击菜单上的修改命令！", 48, "提示"
Exit Sub
Text85.Text = ""
Text85.SetFocus
Else
dream.MoveNext
End If
Wend
dream.AddNew
dream.Fields(0) = Trim(Text4.Text)
dream.Fields(1) = Trim(Text8.Text)
dream.Fields(2) = Trim(Text9.Text)
dream.Fields(3) = Trim(Text10.Text)
dream.Fields(4) = Trim(Text11.Text)
dream.Fields(5) = Trim(Text12.Text)
dream.Fields(6) = Trim(Text13.Text)
dream.Fields(7) = Trim(Text14.Text)
dream.Fields(8) = Trim(Text15.Text)
dream.Fields(9) = Trim(Text16.Text)
dream.Fields(10) = Trim(Text17.Text)
dream.Fields(11) = Trim(Text18.Text)
dream.Fields(12) = Trim(Text19.Text)
dream.Fields(13) = Trim(Text20.Text)
dream.Fields(14) = Trim(Text21.Text)
dream.Fields(15) = Trim(Text22.Text)
dream.Fields(16) = Trim(Text23.Text)
dream.Fields(17) = Trim(Text24.Text)
dream.Fields(18) = Trim(Text25.Text)
dream.Fields(19) = Trim(Text26.Text)
dream.Fields(20) = Trim(Text27.Text)
dream.Fields(21) = Trim(Text28.Text)
dream.Fields(22) = Trim(Text29.Text)
dream.Fields(23) = Trim(Text30.Text)
dream.Fields(24) = Trim(Text31.Text)
dream.Fields(25) = Trim(Text32.Text)
dream.Fields(26) = Trim(Text33.Text)
dream.Fields(27) = Trim(Text34.Text)
dream.Fields(28) = Trim(Text35.Text)
dream.Fields(29) = Trim(Text36.Text)
dream.Fields(30) = Trim(Text64.Text)
dream.UpdateBatch
'=================================================
MsgBox "课程表添加成功！", 48, "提示"
Command2.Enabled = True
Command3.Enabled = True
Else
' Text1.Text = ""
' Text2.Text = ""
' Text3.Text = ""
' Text4.Text = ""
' Text5.Text = ""
' Text6.Text = ""
' Text7.Text = ""
'Text8.Text = ""
' Text9.Text = ""
'Text10.Text = ""
'Text11.Text = ""
'Text12.Text = ""
' Text13.Text = ""
End If
End Sub
Private Sub Command4_Click()
Unload Me
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -