📄 管理员.frm
字号:
Left = -67560
TabIndex = 37
Top = 5880
Width = 855
End
Begin VB.Frame Frame3
Caption = "医生技术专长信息"
Height = 2175
Index = 0
Left = -74880
TabIndex = 28
Top = 3480
Width = 10335
Begin VB.TextBox Text7
Enabled = 0 'False
Height = 375
Index = 0
Left = 840
TabIndex = 32
Top = 360
Width = 1815
End
Begin VB.TextBox Text8
Enabled = 0 'False
Height = 375
Index = 1
Left = 3720
TabIndex = 31
Top = 360
Width = 1815
End
Begin VB.TextBox Text9
Enabled = 0 'False
Height = 375
Index = 0
Left = 6480
TabIndex = 30
Top = 360
Width = 1815
End
Begin VB.TextBox Text10
Enabled = 0 'False
Height = 975
Left = 840
MultiLine = -1 'True
ScrollBars = 2 'Vertical
TabIndex = 29
Top = 1080
Width = 3615
End
Begin VB.Label Label13
Caption = "科别"
Height = 255
Index = 1
Left = 240
TabIndex = 36
Top = 480
Width = 495
End
Begin VB.Label Label14
Caption = "职务"
Height = 255
Index = 1
Left = 3000
TabIndex = 35
Top = 480
Width = 495
End
Begin VB.Label Label15
Caption = "职称"
Height = 375
Index = 0
Left = 5880
TabIndex = 34
Top = 480
Width = 495
End
Begin VB.Label Label16
Caption = "专长"
Height = 255
Index = 0
Left = 240
TabIndex = 33
Top = 1200
Width = 495
End
End
Begin VB.Frame Frame2
Caption = "医技人员基本信息"
Height = 2775
Index = 0
Left = -74880
TabIndex = 1
Top = 600
Width = 10335
Begin VB.ComboBox Combo1
BeginProperty DataFormat
Type = 4
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 8
EndProperty
Enabled = 0 'False
Height = 300
ItemData = "管理员.frx":13BE
Left = 4680
List = "管理员.frx":13D7
TabIndex = 14
Top = 1080
Width = 1455
End
Begin VB.TextBox Text4
Enabled = 0 'False
Height = 270
Index = 0
Left = 7560
TabIndex = 13
Top = 1080
Width = 1335
End
Begin VB.Frame Frame1
Height = 615
Index = 0
Left = 7560
TabIndex = 10
Top = 360
Width = 2055
Begin VB.OptionButton Option2
Caption = "女"
Enabled = 0 'False
Height = 375
Left = 1080
TabIndex = 12
Top = 120
Width = 735
End
Begin VB.OptionButton Option1
Caption = "男"
Enabled = 0 'False
Height = 375
Left = 120
TabIndex = 11
Top = 120
Value = -1 'True
Width = 855
End
End
Begin VB.TextBox Text1
Height = 285
Index = 1
Left = 1200
TabIndex = 9
Top = 480
Width = 1695
End
Begin VB.TextBox Text2
Enabled = 0 'False
Height = 315
Index = 1
Left = 4635
TabIndex = 8
Top = 480
Width = 1575
End
Begin VB.TextBox Text3
Enabled = 0 'False
Height = 315
Index = 0
Left = 1200
TabIndex = 7
Top = 960
Width = 1095
End
Begin VB.ComboBox Combo4
BeginProperty DataFormat
Type = 4
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 8
EndProperty
Enabled = 0 'False
Height = 300
Index = 0
ItemData = "管理员.frx":1405
Left = 3960
List = "管理员.frx":1466
TabIndex = 6
Top = 1560
Width = 735
End
Begin VB.ComboBox Combo3
BeginProperty DataFormat
Type = 4
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 8
EndProperty
Enabled = 0 'False
Height = 300
Index = 0
ItemData = "管理员.frx":14DD
Left = 2640
List = "管理员.frx":1505
TabIndex = 5
Top = 1560
Width = 735
End
Begin VB.ComboBox Combo2
BeginProperty DataFormat
Type = 4
Format = ""
HaveTrueFalseNull= 0
FirstDayOfWeek = 0
FirstWeekOfYear = 0
LCID = 2052
SubFormatType = 8
EndProperty
Enabled = 0 'False
Height = 300
Index = 0
ItemData = "管理员.frx":1530
Left = 1200
List = "管理员.frx":16F9
TabIndex = 4
Top = 1560
Width = 975
End
Begin VB.TextBox Text6
Enabled = 0 'False
Height = 375
Index = 0
Left = 6240
TabIndex = 3
Top = 2160
Width = 3135
End
Begin VB.TextBox Text5
Enabled = 0 'False
Height = 375
Index = 0
Left = 1200
TabIndex = 2
Top = 2160
Width = 3135
End
Begin VB.Label Label5
Caption = "学历"
Height = 375
Index = 0
Left = 3600
TabIndex = 27
Top = 1080
Width = 855
End
Begin VB.Label Label6
Caption = "专业"
Height = 375
Index = 0
Left = 6840
TabIndex = 26
Top = 1080
Width = 735
End
Begin VB.Label Label7
Caption = "出生日期"
Height = 375
Index = 1
Left = 240
TabIndex = 25
Top = 1560
Width = 855
End
Begin VB.Label Label1
Caption = "id"
Height = 375
Index = 1
Left = 240
TabIndex = 24
Top = 480
Width = 735
End
Begin VB.Label Label2
Caption = "姓名"
Height = 330
Index = 1
Left = 3645
TabIndex = 23
Top = 585
Width = 975
End
Begin VB.Label Label3
Caption = "性别"
Height = 375
Index = 0
Left = 6945
TabIndex = 22
Top = 585
Width = 615
End
Begin VB.Label Label17
Caption = "岁"
Height = 375
Left = 2400
TabIndex = 21
Top = 960
Width = 495
End
Begin VB.Label Label4
Caption = "年龄"
Height = 375
Index = 0
Left = 240
TabIndex = 20
Top = 1065
Width = 735
End
Begin VB.Label Label10
Caption = "日"
Height = 255
Index = 0
Left = 4800
TabIndex = 19
Top = 1680
Width = 375
End
Begin VB.Label Label9
Caption = "月"
Height = 375
Index = 0
Left = 3600
TabIndex = 18
Top = 1680
Width = 615
End
Begin VB.Label Label8
Caption = "年"
Height = 375
Index = 0
Left = 2280
TabIndex = 17
Top = 1680
Width = 495
End
Begin VB.Label Label12
Caption = "联系方式"
Height = 495
Index = 0
Left = 5040
TabIndex = 16
Top = 2160
Width = 855
End
Begin VB.Label Label11
Caption = "家庭地址"
Height = 495
Index = 0
Left = 120
TabIndex = 15
Top = 2160
Width = 1095
End
End
End
End
Attribute VB_Name = "Form8"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Drive1_Change()
End Sub
Private Sub OLE1_Updated(Code As Integer)
End Sub
Private Sub Command1_Click(Index As Integer)
Dim Rs1 As New ADODB.Recordset
Dim tianjia As String
Set Rs1 = New Recordset
tianjia = " select * from 医生信息 "
Rs1.Open tianjia, Str, adOpenKeyset, adLockOptimistic, adCmdText
On Error GoTo li2
Rs1.AddNew
With Rs1
.Fields("id") = Text1(1).Text
.Fields("姓名") = Text2(1).Text
.Fields("年龄") = Text3(0).Text
.Fields("专业") = Text4(0).Text
.Fields("家庭地址") = Text5(0).Text
.Fields("联系方式") = Text6(0).Text
.Fields("科别") = Text7(0).Text
.Fields("职务") = Text8(1).Text
.Fields("职称") = Text9(0).Text
.Fields("专长") = Text10.Text
.Fields("学历") = Combo1.Text
.Fields("出生日期") = DateSerial(Combo2(0).Text, Combo3(0).Text, Combo4(0).Text)
If Option1.Value = True Then
.Fields("性别") = "男"
Else
.Fields("性别") = "女"
End If
End With
Rs1.Update
Dim Rs2 As New ADODB.Recordset
Dim tianjia2 As String
Set Rs2 = New Recordset
tianjia2 = " select * from 用户 "
Rs2.Open tianjia2, Str, adOpenKeyset, adLockOptimistic, adCmdText
On Error GoTo li2
Rs2.AddNew
With Rs2
.Fields("用户名") = Text1(1).Text
.Fields("姓名") = Text2(1).Text
.Fields("密码") = "1111"
.Fields("用户类型") = "医生用户"
End With
Rs2.Update
If MsgBox("成功添加还要继续么", vbOKCancel + vbQuestion, "退出") = vbOK Then
Unload Me
Form8.Show
Else
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -