📄 frmadd2.frm.bak
字号:
VERSION 5.00
Begin VB.Form frmadd1
BorderStyle = 0 'None
Caption = "增加信息"
ClientHeight = 5910
ClientLeft = 0
ClientTop = -105
ClientWidth = 6690
LinkTopic = "Form2"
MaxButton = 0 'False
MDIChild = -1 'True
MinButton = 0 'False
Picture = "frmadd.frx":0000
ScaleHeight = 5910
ScaleWidth = 6690
ShowInTaskbar = 0 'False
Begin VB.TextBox Text1
Height = 270
Left = 6840
TabIndex = 0
Text = "Text1"
Top = 1320
Width = 180
End
Begin VB.TextBox stu_age
Appearance = 0 'Flat
BackColor = &H00F2F3F7&
Height = 300
Left = 1920
TabIndex = 5
Top = 3360
Width = 2655
End
Begin VB.ComboBox stu_term
Appearance = 0 'Flat
BackColor = &H00F2F3F7&
Height = 300
ItemData = "frmadd.frx":1AC8F
Left = 1920
List = "frmadd.frx":1AC9C
Style = 2 'Dropdown List
TabIndex = 4
Top = 2950
Width = 2655
End
Begin VB.TextBox stu_id
Appearance = 0 'Flat
BackColor = &H00F2F3F7&
Height = 300
Left = 1920
TabIndex = 1
Top = 1770
Width = 2655
End
Begin VB.TextBox stu_name
Appearance = 0 'Flat
BackColor = &H00F2F3F7&
Height = 300
Left = 1920
TabIndex = 2
Top = 2160
Width = 2655
End
Begin VB.TextBox stu_photo
Appearance = 0 'Flat
BackColor = &H00F2F3F7&
BorderStyle = 0 'None
Height = 230
Left = 1950
TabIndex = 6
Top = 3775
Width = 2415
End
Begin VB.TextBox stu_add
Appearance = 0 'Flat
BackColor = &H00F2F3F7&
BorderStyle = 0 'None
Height = 240
Left = 1950
TabIndex = 7
Top = 4170
Width = 2415
End
Begin VB.ComboBox stu_sex
Appearance = 0 'Flat
BackColor = &H00F2F3F7&
Height = 300
ItemData = "frmadd.frx":1ACBE
Left = 1920
List = "frmadd.frx":1ACC8
Style = 2 'Dropdown List
TabIndex = 3
Top = 2575
Width = 2655
End
Begin VB.Timer mousemovetimer
Enabled = 0 'False
Interval = 10
Left = 240
Top = 5160
End
Begin VB.Image tbutton2
Height = 210
Left = 1560
Picture = "frmadd.frx":1ACD4
Top = 1080
Width = 960
End
Begin VB.Image tbutton3
Height = 210
Left = 2520
Picture = "frmadd.frx":1AD2B
Top = 1080
Width = 960
End
Begin VB.Image pic_close
Height = 180
Left = 6360
Picture = "frmadd.frx":1AD82
Top = 120
Width = 180
End
Begin VB.Image pic_ok
Height = 285
Left = 3600
Picture = "frmadd.frx":1ADD4
Top = 4860
Width = 1065
End
Begin VB.Image pic_exit
Height = 285
Left = 4920
Picture = "frmadd.frx":1BE20
Top = 4860
Width = 1065
End
Begin VB.Image pic_clear
Height = 285
Left = 2280
Picture = "frmadd.frx":1CE6C
Top = 4860
Width = 1065
End
Begin VB.Image mousermovepic
Height = 345
Left = 0
Picture = "frmadd.frx":1DEB8
Top = 0
Width = 6270
End
End
Attribute VB_Name = "frmadd1"
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()
frmadd1.Left = frmadd1.Left - (oldx - newx)
frmadd1.Top = frmadd1.Top - (oldy - newy)
End Sub
'>>>>>>>>>>>>>>>>>>>>>>>>以上程序段解决全图形窗口的移动问题<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
'初始化窗口
Private Sub Form_Load()
Me.Top = 0
Me.Left = 0
stu_sex.ListIndex = 0 '默认性别为男性
stu_term.ListIndex = 0 '默认学期为第一学期
End Sub
'清空所有填写项目
Private Sub pic_clear_Click()
stu_id.Text = ""
stu_name.Text = ""
stu_age.Text = ""
stu_photo.Text = ""
stu_add.Text = ""
End Sub
'关闭按钮实现
Private Sub pic_close_Click()
Unload Me
End Sub
'退出按钮实现
Private Sub pic_exit_Click()
Unload Me
End Sub
'确定按钮实现
Private Sub pic_ok_Click()
'检查数据完整性（一种情况：没有填完所有数据）
If stu_id.Text = "" Or stu_name.Text = "" Or stu_sex.Text = "" Or stu_age.Text = "" Or stu_photo.Text = "" Or stu_add.Text = "" Then
MsgBox "数据不完整，该窗口需要修改。": Exit Sub
End If
'检查数据正确性（两种情况：学生ID或者学生年龄输入了非数字字符，如ID为“ABC123”）
If Not IsNumeric(Trim(stu_id.Text)) Then
MsgBox "学生ID不能为非数字字符": stu_id.Text = "": Exit Sub
End If
If Not IsNumeric(Trim(stu_age.Text)) Then
MsgBox "学生年龄不能为非数字字符": stu_age.Text = "": Exit Sub
End If
'检查数据的合法性（两种情况：学生ID或者学生年龄输入的数字超过范围,如ID为“-10”）
If Trim(stu_id.Text) < 0 Or Trim(stu_id.Text) > 30001 Then
MsgBox "学生ID的范围为1～30000": stu_id.Text = "": Exit Sub
End If
If Trim(stu_age.Text) < 18 Or Trim(stu_age.Text) > 100 Then
MsgBox "学生年龄的范围为18～99": stu_age.Text = "": Exit Sub
End If
'所有数据检查完毕
'执行拼装T－SQL语句
Dim tsql As String
tsql = "insert StuInfo values (" & Trim(stu_id.Text) & ",'" & Trim(stu_name.Text) & "','" & Trim(stu_sex.Text) & "','" & Trim(stu_term.Text) & "'," & Trim(stu_age.Text) & ",'" & Trim(stu_photo.Text) & "','" & Trim(stu_add.Text) & "')"
'调用addstuinfo函数添加学生信息
If runtsql(tsql) Then
MsgBox "学生信息添加成功。"
Else
MsgBox "学生信息添加失败！"
End If
End Sub
'>>>>>>>>>>>>>>>>>切换功能程序段<<<<<<<<<<<<<<<<<<
Private Sub tbutton2_Click()
frmadd2.Top = Me.Top
frmadd2.Left = Me.Left
Unload Me
End Sub
Private Sub tbutton3_Click()
frmadd3.Top = Me.Top
frmadd3.Left = Me.Left
Unload Me
End Sub
'>>>>>>>>>>>>>>>>>切换功能程序段<<<<<<<<<<<<<<<<<<
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -