📄 frmstudent.frm
字号:
Left = 2520
TabIndex = 7
Top = 210
Width = 1455
End
Begin VB.TextBox TXTBianhao
Appearance = 0 'Flat
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 315
Left = 735
TabIndex = 5
Top = 225
Width = 1200
End
Begin VB.Label Label5
Caption = "车间："
Height = 210
Left = 2850
TabIndex = 19
Top = 690
Width = 540
End
Begin VB.Label Label6
Caption = "部门："
Height = 240
Left = 210
TabIndex = 18
Top = 690
Width = 540
End
Begin VB.Label Label2
Caption = "姓名："
Height = 240
Left = 1995
TabIndex = 6
Top = 270
Width = 600
End
Begin VB.Label Label1
Caption = "编号："
Height = 240
Left = 225
TabIndex = 4
Top = 285
Width = 600
End
End
End
Begin MSComctlLib.TreeView TrVzilei
Height = 6900
Left = 90
TabIndex = 8
Top = 315
Width = 2820
_ExtentX = 4974
_ExtentY = 12171
_Version = 393217
Indentation = 460
LabelEdit = 1
LineStyle = 1
Style = 7
ImageList = "ImgLst"
BorderStyle = 1
Appearance = 0
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
End
Begin MSComctlLib.ImageList ImgLst
Left = 3315
Top = 7785
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 20
ImageHeight = 20
MaskColor = 12632256
_Version = 393216
BeginProperty Images {2C247F25-8591-11D1-B16A-00C0F0283628}
NumListImages = 7
BeginProperty ListImage1 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmStudent.frx":0187
Key = "save"
EndProperty
BeginProperty ListImage2 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmStudent.frx":021B
Key = "undo"
EndProperty
BeginProperty ListImage3 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmStudent.frx":028B
Key = "new"
EndProperty
BeginProperty ListImage4 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmStudent.frx":030B
Key = "edit"
EndProperty
BeginProperty ListImage5 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmStudent.frx":03A7
Key = "student"
EndProperty
BeginProperty ListImage6 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmStudent.frx":07FB
Key = "grade"
EndProperty
BeginProperty ListImage7 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "FrmStudent.frx":0C4F
Key = "class"
EndProperty
EndProperty
End
End
Attribute VB_Name = "FrmStudent"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'Option Explicit
''标志是添加还是编辑
'Dim NewOrEdit As String
'
''设置是否可以编辑
'Sub SetEnabled(ByVal TF As Boolean)
' FramIn.Enabled = TF
' CmdDel.Enabled = Not TF
'End Sub
''清空
'Sub ClsXS()
' TXTName = ""
' TXTName.SetFocus
' 'TXTXuehao = ""
' 'TxTNum = ""
'
'End Sub
''判断输入是否合格
'Function CheckIn() As Boolean
' If TXTName = "" Then
' MsgBox "请输入考生的姓名！"
' TXTName.SetFocus
' Exit Function
' End If
' If Val(TXTBianhao) <= 0 Then
' MsgBox "请输入考生的编号！"
' TXTBianhao.SetFocus
' Exit Function
' End If
' If Val(TXTJu.Text) <= 0 Then
' MsgBox "请输入考生所在的部门！"
' TXTJu.SetFocus
' Exit Function
' End If
' CheckIn = True
'End Function
'
'Private Sub CmdEdit_Click()
' If CmdNew.ToolTipText = "添加考生信息" Then
' SetEnabled True
' CmdNew.Picture = ImgLst.ListImages(1).Picture
' CmdEdit.Picture = ImgLst.ListImages(2).Picture
' CmdNew.ToolTipText = "保存考生信息"
' CmdEdit.ToolTipText = "取消保存"
' NewOrEdit = "Edit"
' Else
' SetEnabled False
' CmdNew.Picture = ImgLst.ListImages(3).Picture
' CmdEdit.Picture = ImgLst.ListImages(4).Picture
' CmdNew.ToolTipText = "添加考生信息"
' CmdEdit.ToolTipText = "编辑考生信息"
' End If
'
'End Sub
'
'Private Sub CmdNew_Click()
' If CmdNew.ToolTipText = "添加考生信息" Then
' SetEnabled True
' CmdNew.Picture = ImgLst.ListImages(1).Picture
' CmdEdit.Picture = ImgLst.ListImages(2).Picture
' CmdNew.ToolTipText = "保存考生信息"
' CmdEdit.ToolTipText = "取消保存"
' NewOrEdit = "New"
' If CheQK.Value = 1 Then
' '清空
' ClsXS
' End If
' Else
'
' '判断输入是否合格
' If CheckIn = False Then
' Exit Sub
' End If
' Dim sql As String
' Dim Sex As String
' '判断是添加还是编辑
' Sex = "男"
' If OptNv.Value = True Then Sex = "女"
' If NewOrEdit = "New" Then
' '添加
' sql = "insert into student(name,sex,grade,class,sid,pass) values('" + TXTName.Text + "','" + Sex + "','" + TXTYear.Text + "'," + str(Val(CmbNum.Text)) + "," + TXTXuehao.Text + ",'')"
' MsgBox sql
' adoCn.Execute sql
'
' Else
' '更新
' End If
' SetEnabled False
' CmdNew.Picture = ImgLst.ListImages(3).Picture
' CmdEdit.Picture = ImgLst.ListImages(4).Picture
' CmdNew.ToolTipText = "添加考生信息"
' CmdEdit.ToolTipText = "编辑考生信息"
' End If
'
'End Sub
'
'
'
'Private Sub Form_Load()
'
'' Dim adoRS As Recordset
'' Dim i As Integer
'' Dim MyNod As Node
'' Dim NewNod As Node
''' 显示年份信息
''' 打开记录集
'' Set adoRS = New Recordset
'' adoRS.Open "select * from kaosheng", adoCn, adOpenStatic, adLockOptimistic
''' 建立根接点
'' Set MyNod = TrVzilei.Nodes.Add(, , "node_n", "所有考生", "student")
'' Do While Not adoRS.EOF
''' 建立年份节点
'' Set NewNod = TrVzilei.Nodes.Add("node_n", tvwChild, "node_nj" + adoRS.Fields(0).Value, adoRS.Fields(1).Value, "grade")
'' For i = 1 To adoRS.Fields(2).Value
''' 建立车间节点
'' Set NewNod = TrVzilei.Nodes.Add("node_nj" + adoRS.Fields(0).Value, tvwChild, "node_njc" + adoRS.Fields(1).Value + "|" + Trim(str(i)), Trim(str(i)) + "车间", "class")
'' Next i
'' adoRS.MoveNext
'' Loop
''
'' adoRS.Close
'
'End Sub
'
'
'
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -