📄 frmadd2.frm
字号:
VERSION 5.00
Begin VB.Form frmadd2
BorderStyle = 0 'None
Caption = "Form1"
ClientHeight = 6840
ClientLeft = 0
ClientTop = 0
ClientWidth = 6675
LinkTopic = "Form1"
LockControls = -1 'True
MDIChild = -1 'True
Picture = "frmadd2.frx":0000
ScaleHeight = 13082.33
ScaleMode = 0 'User
ScaleWidth = 6675
ShowInTaskbar = 0 'False
Begin VB.OptionButton op_xq3
BackColor = &H00E8EBF2&
Caption = "Option3"
Height = 255
Left = 5400
TabIndex = 10
Top = 1988
Width = 255
End
Begin VB.OptionButton op_xq2
BackColor = &H00F0F1F5&
Caption = "Option2"
Height = 255
Left = 3600
TabIndex = 9
Top = 1988
Width = 255
End
Begin VB.OptionButton op_xq1
BackColor = &H00F6F6F8&
Caption = "Option1"
Height = 255
Left = 1800
TabIndex = 8
Top = 1988
Width = 255
End
Begin VB.TextBox mak5
Appearance = 0 'Flat
BackColor = &H00F4F4F8&
BorderStyle = 0 'None
Height = 240
Left = 2690
TabIndex = 7
Top = 5333
Width = 1575
End
Begin VB.TextBox mak4
Appearance = 0 'Flat
BackColor = &H00F4F4F8&
BorderStyle = 0 'None
Height = 240
Left = 2690
TabIndex = 6
Top = 4967
Width = 1575
End
Begin VB.TextBox mak2
Appearance = 0 'Flat
BackColor = &H00F4F4F8&
BorderStyle = 0 'None
Height = 240
Left = 2690
TabIndex = 4
Top = 4200
Width = 1575
End
Begin VB.TextBox mak3
Appearance = 0 'Flat
BackColor = &H00F4F4F8&
BorderStyle = 0 'None
Height = 240
Left = 2690
TabIndex = 5
Top = 4575
Width = 1575
End
Begin VB.TextBox mak1
Appearance = 0 'Flat
BackColor = &H00F4F4F8&
BorderStyle = 0 'None
Height = 240
Left = 2690
TabIndex = 3
Top = 3817
Width = 1575
End
Begin VB.TextBox mak_name
Appearance = 0 'Flat
BackColor = &H00F4F4F8&
BorderStyle = 0 'None
Height = 240
Left = 2690
TabIndex = 2
Top = 3383
Width = 1815
End
Begin VB.Timer mousemovetimer
Enabled = 0 'False
Interval = 10
Left = 0
Top = 6360
End
Begin VB.TextBox mak_id
Appearance = 0 'Flat
BackColor = &H00F4F4F8&
BorderStyle = 0 'None
Height = 240
Left = 2690
TabIndex = 1
Top = 3000
Width = 1095
End
Begin VB.TextBox Text1
Height = 270
Left = 6840
TabIndex = 0
Text = "Text1"
Top = 1320
Width = 180
End
Begin VB.Image temppic3
Height = 375
Left = 1800
Picture = "frmadd2.frx":1F3AE
Stretch = -1 'True
Top = 7080
Visible = 0 'False
Width = 375
End
Begin VB.Image temppic2
Height = 375
Left = 1200
Picture = "frmadd2.frx":3E80D
Stretch = -1 'True
Top = 7080
Visible = 0 'False
Width = 375
End
Begin VB.Image temppic1
Height = 375
Left = 600
Picture = "frmadd2.frx":5DB3D
Stretch = -1 'True
Top = 7080
Visible = 0 'False
Width = 375
End
Begin VB.Image mousermovepic
Height = 345
Left = 0
Picture = "frmadd2.frx":7CEEB
Top = 0
Width = 6270
End
Begin VB.Image pic_clear
Height = 285
Left = 3840
Picture = "frmadd2.frx":8231D
Top = 6240
Width = 1065
End
Begin VB.Image pic_exit
Height = 285
Left = 5040
Picture = "frmadd2.frx":83369
Top = 6240
Width = 1065
End
Begin VB.Image pic_ok
Height = 285
Left = 2640
Picture = "frmadd2.frx":843B5
Top = 6240
Width = 1065
End
Begin VB.Image pic_close
Height = 180
Left = 6360
Picture = "frmadd2.frx":85401
Top = 120
Width = 180
End
Begin VB.Image tbutton1
Height = 210
Left = 480
Picture = "frmadd2.frx":85453
Top = 1080
Width = 960
End
End
Attribute VB_Name = "frmadd2"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim oldx As Integer '为解决全图形窗口没有标题栏而无法拖动的问题而定义的鼠标新旧两个XY变量
Dim oldy As Integer
Dim newx As Integer
Dim newy As Integer
'>>>>>>>>>>>>>>>>>>>>>>>>以下程序段解决全图形窗口的移动问题<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
'移植须知：将该功能移植到一个全图片窗口以解决不能移动的问题时，需注意：1 赋值计时器和伪装标题栏到新的全图片窗体中；2 赋值定义的新旧XY值（4个）和本程序段到新的全图片窗体中；3 修改计时器的过程“mousemovetimer_Timer”中的四个窗体名字。4 修改伪装标题栏的图片
'当指定图片（伪装标题栏）被鼠标点击时启动计时器，并记录下当时的初始鼠标坐标
Private Sub mousermovepic_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
mousemovetimer.Enabled = True
oldx = X
oldy = Y
End Sub
'当指定图片（伪装标题栏）上鼠标移动时，赋给新的鼠标XY值，注意系统每隔很短的时间会赋值一次。
Private Sub mousermovepic_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
newx = X
newy = Y
End Sub
'当指定图片（伪装标题栏）被鼠标释放时关闭计时器。
Private Sub mousermovepic_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
mousemovetimer.Enabled = False
End Sub
'计时器将定时得到四个值，分别是固定的初始XY值，和不断变化的新的XY值。利用新旧XY的差，可以以此来移动窗体。适当调小计时器间隔时间将有助于移动窗体的流畅性。
Private Sub mousemovetimer_Timer()
frmadd2.Left = frmadd2.Left - (oldx - newx)
If frmadd2.Top - (oldy - newy) < 1050 Then
frmadd2.Top = 1050
Else
frmadd2.Top = frmadd2.Top - (oldy - newy)
End If
End Sub
'>>>>>>>>>>>>>>>>>>>>>>>>以上程序段解决全图形窗口的移动问题<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
'初始化窗口
Private Sub Form_Load()
frmmain.addwindowsishas = True '加载时布尔值为真，这样在再次点击添加数据按钮或菜单时，不会出现第二个添加窗口“frmadd1”了
Me.Width = 6690
Me.Height = 6840
op_xq1.Value = True
End Sub
Private Sub op_xq1_Click()
Me.Picture = temppic1.Picture
End Sub
Private Sub op_xq2_Click()
Me.Picture = temppic2.Picture
End Sub
Private Sub op_xq3_Click()
Me.Picture = temppic3.Picture
End Sub
'清空所有填写项目
Private Sub pic_clear_Click()
mak_id.Text = ""
mak_name.Text = ""
mak1.Text = ""
mak2.Text = ""
mak3.Text = ""
mak4.Text = ""
mak5.Text = ""
End Sub
'关闭按钮实现
Private Sub pic_close_Click()
frmmain.addwindowsishas = False '还原布尔值
Unload Me
End Sub
'退出按钮实现
Private Sub pic_exit_Click()
frmmain.addwindowsishas = False '还原布尔值
Unload Me
End Sub
'确定按钮实现
Private Sub pic_ok_Click()
'检查数据完整性（一种情况：没有填完所有数据）
If mak_id.Text = "" Or mak_name.Text = "" Or mak1.Text = "" Or mak2.Text = "" Or mak3.Text = "" Or mak4.Text = "" Or mak5.Text = "" Then
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.pic1.Picture: publicmbox.Show vbModal
End If
Exit Sub
End If
'检查数据正确性（检查学生ID和各科成绩是否为数字）
If strisnum(mak_id.Text) = False Then
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.pic2.Picture: publicmbox.Show vbModal
End If
mak_id = "": Exit Sub
End If
If strisnum(mak1.Text) = False Then
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.picmakin0_100.Picture: publicmbox.Show vbModal
End If
mak1.Text = "": Exit Sub
End If
If strisnum(mak2.Text) = False Then
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.picmakin0_100.Picture: publicmbox.Show vbModal
End If
mak2.Text = "": Exit Sub
End If
If strisnum(mak3.Text) = False Then
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.picmakin0_100.Picture: publicmbox.Show vbModal
End If
mak3.Text = "": Exit Sub
End If
If strisnum(mak4.Text) = False Then
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.picmakin0_100.Picture: publicmbox.Show vbModal
End If
mak4.Text = "": Exit Sub
End If
If strisnum(mak5.Text) = False Then
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.picmakin0_100.Picture: publicmbox.Show vbModal
End If
mak5.Text = "": Exit Sub
End If
'检查数据的合法性（两种情况：学生ID或者学生年龄输入的数字超过范围,如ID为“-10”）
If Trim(mak_id.Text) < 0 Or Trim(mak_id.Text) > 30001 Then
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.pic4.Picture: publicmbox.Show vbModal
End If
mak_id.Text = "": Exit Sub
End If
If Trim(mak1.Text) < 0 Or Trim(mak1.Text) > 101 Then
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.picmakin0_100.Picture: publicmbox.Show vbModal
End If
mak1.Text = "": Exit Sub
End If
If Trim(mak2.Text) < 0 Or Trim(mak2.Text) > 101 Then
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.picmakin0_100.Picture: publicmbox.Show vbModal
End If
mak2.Text = "": Exit Sub
End If
If Trim(mak3.Text) < 0 Or Trim(mak3.Text) > 101 Then
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.picmakin0_100.Picture: publicmbox.Show vbModal
End If
mak3.Text = "": Exit Sub
End If
If Trim(mak4.Text) < 0 Or Trim(mak4.Text) > 101 Then
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.picmakin0_100.Picture: publicmbox.Show vbModal
End If
mak4.Text = "": Exit Sub
End If
If Trim(mak5.Text) < 0 Or Trim(mak5.Text) > 101 Then
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.picmakin0_100.Picture: publicmbox.Show vbModal
End If
mak5.Text = "": Exit Sub
End If
'所有数据检查完毕
'根据选定的学期确定字符串“xq”的值
Dim xq As String
If op_xq1.Value = True Then
xq = "stumak1"
Else
If op_xq2.Value = True Then
xq = "stumak2"
Else: xq = "stumak3"
End If
End If
'执行拼装T－SQL语句（嵌入确定的xq值）
Dim tsql As String
tsql = "insert " & xq & " values (" & Trim(mak_id.Text) & ",'" & Trim(mak_name.Text) & "'," & Trim(mak1.Text) & "," & Trim(mak2.Text) & "," & Trim(mak3.Text) & "," & Trim(mak4.Text) & "," & Trim(mak5.Text) & ")"
'调用addstuinfo函数添加成绩信息
If runtsql(tsql) Then
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.pic12.Picture: publicmbox.Show vbModal
End If
Call pic_clear_Click
Else
If frmmain.check_have.Value = 0 Then
Set publicmbox.Picture = publicmbox.pic7.Picture: publicmbox.Show vbModal
End If
End If
End Sub
'>>>>>>>>>>>>>>>>>切换功能程序段<<<<<<<<<<<<<<<<<<
Private Sub tbutton1_Click()
frmadd1.Top = Me.Top
frmadd1.Left = Me.Left
Unload Me
End Sub
'>>>>>>>>>>>>>>>>>切换功能程序段<<<<<<<<<<<<<<<<<<
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -