📄 frmstudent.frm
字号:
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 180
Left = 180
TabIndex = 14
Top = 2820
Width = 780
End
Begin VB.Label Lbl_Duty
Caption = "Duty"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800080&
Height = 180
Left = 4200
TabIndex = 13
Top = 1560
Width = 1260
End
Begin VB.Label Lbl_StuNo
Caption = "no"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800080&
Height = 180
Left = 1440
TabIndex = 12
Top = 300
Width = 1260
End
Begin VB.Line Line8
X1 = 2760
X2 = 2760
Y1 = 3120
Y2 = 3540
End
Begin VB.Line Line10
X1 = 4080
X2 = 4080
Y1 = 3120
Y2 = 3540
End
Begin VB.Label Lbl_Address
Caption = "Address"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800080&
Height = 180
Left = 1440
TabIndex = 11
Top = 2820
Width = 5700
End
Begin VB.Label Label16
AutoSize = -1 'True
BackColor = &H00FFC0C0&
BackStyle = 0 'Transparent
Caption = "备注"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 180
Left = 180
TabIndex = 10
Top = 3660
Width = 390
End
Begin VB.Label Lbl_Memo
Caption = "Memo"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00800080&
Height = 780
Left = 1440
TabIndex = 9
Top = 3600
Width = 5640
WordWrap = -1 'True
End
End
Begin VB.CommandButton cmdAdd
Caption = "添加学生"
Height = 400
Left = 720
TabIndex = 7
Top = 5040
Width = 1300
End
Begin VB.CommandButton cmdDel
Caption = "删除学生"
Height = 400
Left = 5160
TabIndex = 6
Top = 5040
Width = 1300
End
Begin VB.CommandButton cmdEdit
Caption = "修改资料"
Height = 400
Left = 3000
TabIndex = 5
Top = 5040
Width = 1300
End
Begin VB.CommandButton cmdFamAdd
BackColor = &H80000004&
Caption = "添加"
Height = 400
Left = -73800
TabIndex = 4
Top = 5040
Width = 1300
End
Begin VB.CommandButton cmdFamEdit
BackColor = &H80000004&
Caption = "修改"
Height = 400
Left = -71880
TabIndex = 3
Top = 5040
Width = 1300
End
Begin VB.CommandButton cmdFamDel
BackColor = &H80000004&
Caption = "删除"
Height = 400
Left = -69960
TabIndex = 2
Top = 5040
Width = 1300
End
Begin MSDataGridLib.DataGrid DataGrid1
Bindings = "FrmStudent.frx":6514
Height = 4455
Left = -74880
TabIndex = 41
Top = 420
Width = 7215
_ExtentX = 12726
_ExtentY = 7858
_Version = 393216
AllowUpdate = 0 'False
HeadLines = 1
RowHeight = 15
FormatLocked = -1 'True
BeginProperty HeadFont {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ColumnCount = 6
BeginProperty Column00
DataField = "Name"
Caption = "姓名"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column01
DataField = "Sex"
Caption = "性别"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column02
DataField = "Relationship"
Caption = "与本人关系"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column03
DataField = "WorkingOrg"
Caption = "工作单位"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column04
DataField = "Phone"
Caption = "联系电话"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
BeginProperty Column05
DataField = "Memo"
Caption = "备注"
BeginProperty DataFormat {6D835690-900B-11D0-9484-00A0C91110ED}
Type = 0
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 0
EndProperty
EndProperty
SplitCount = 1
BeginProperty Split0
BeginProperty Column00
ColumnWidth = 1154.835
EndProperty
BeginProperty Column01
ColumnWidth = 555.024
EndProperty
BeginProperty Column02
ColumnWidth = 1049.953
EndProperty
BeginProperty Column03
ColumnWidth = 2069.858
EndProperty
BeginProperty Column04
ColumnWidth = 1140.095
EndProperty
BeginProperty Column05
ColumnWidth = 900.284
EndProperty
EndProperty
End
End
Begin MSComctlLib.TreeView TreeView1
Height = 1755
Left = 120
TabIndex = 42
Top = 120
Width = 2415
_ExtentX = 4260
_ExtentY = 3096
_Version = 393217
HideSelection = 0 'False
LabelEdit = 1
Style = 7
ImageList = "ImageList1"
Appearance = 1
End
Begin MSComctlLib.ListView ListView1
Height = 3135
Left = 120
TabIndex = 46
Top = 2040
Width = 2415
_ExtentX = 4260
_ExtentY = 5530
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = 0 'False
FullRowSelect = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 1
NumItems = 0
End
End
Attribute VB_Name = "FrmStudent"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Public rsFamily As New ADODB.Recordset '声明学生家庭成员记录集
Private Sub ClearStuDetail()
Lbl_StuNo.Caption = ""
Lbl_StuName.Caption = ""
Lbl_Sex.Caption = ""
Lbl_Birth.Caption = ""
Lbl_Political_Party.Caption = ""
Lbl_Family_Place.Caption = ""
Lbl_Nationality.Caption = ""
Lbl_Id_Card.Caption = ""
Lbl_DormRoom.Caption = ""
Lbl_DormPhone.Caption = ""
Lbl_Mobile.Caption = ""
Lbl_Address.Caption = ""
Lbl_PostCard.Caption = ""
Lbl_Family_Phone.Caption = ""
Lbl_Duty.Caption = ""
Lbl_Memo.Caption = ""
Image1.Picture = LoadPicture("") '清除Image1控件中的图像
End Sub
Public Sub ShowStuDetail(StuID As String)
Dim strSql As String
Dim Rs As New ADODB.Recordset
Dim TempFile As String '临时文件（临时转存照片）
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -