www.pudn.com > 西南医院.rar > FrmAdd1.frm
VERSION 5.00
Begin VB.Form FrmAdd1
Caption = "基本资料登记"
ClientHeight = 4890
ClientLeft = 60
ClientTop = 345
ClientWidth = 7785
LinkTopic = "Form1"
MaxButton = 0 'False
MDIChild = -1 'True
ScaleHeight = 4890
ScaleWidth = 7785
Begin VB.Data Data1
Caption = "Data1"
Connect = "Access 2000;"
DatabaseName = ""
DefaultCursorType= 0 'DefaultCursor
DefaultType = 2 'UseODBC
Exclusive = 0 'False
Height = 300
Left = 3000
Options = 0
ReadOnly = 0 'False
RecordsetType = 1 'Dynaset
RecordSource = ""
Top = 1080
Visible = 0 'False
Width = 1740
End
Begin VB.ComboBox Combo1
DataField = "性别"
DataSource = "Data1"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 960
TabIndex = 23
Top = 1542
Width = 1215
End
Begin VB.TextBox Text9
DataField = "家庭住址"
DataSource = "Data1"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 5640
TabIndex = 22
Top = 2880
Width = 2055
End
Begin VB.TextBox Text8
DataField = "手机"
DataSource = "Data1"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 5640
TabIndex = 21
Top = 2190
Width = 2055
End
Begin VB.TextBox Text7
DataField = "电话"
DataSource = "Data1"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 5640
TabIndex = 20
Top = 1500
Width = 2055
End
Begin VB.TextBox Text6
DataField = "职业"
DataSource = "Data1"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 5640
TabIndex = 19
Top = 810
Width = 2055
End
Begin VB.TextBox Text5
DataField = "住院号"
DataSource = "Data1"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 5640
TabIndex = 18
Top = 120
Width = 1455
End
Begin VB.TextBox Text4
DataField = "起病时间"
DataSource = "Data1"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 960
TabIndex = 17
Top = 2880
Width = 2055
End
Begin VB.TextBox Text3
DataField = "出生日期"
DataSource = "Data1"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 960
TabIndex = 16
Top = 2168
Width = 2055
End
Begin VB.TextBox Text2
DataField = "姓名"
DataSource = "Data1"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 960
TabIndex = 15
Top = 831
Width = 1455
End
Begin VB.TextBox Text1
DataField = "ID号"
DataSource = "Data1"
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 400
Left = 960
TabIndex = 14
Top = 120
Width = 1455
End
Begin VB.CommandButton Command9
Caption = "关闭"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 6240
TabIndex = 13
Top = 4320
Width = 1215
End
Begin VB.CommandButton Command8
Caption = "删 除"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 4800
TabIndex = 12
Top = 4320
Width = 1095
End
Begin VB.CommandButton Command7
Caption = "保存"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 3240
TabIndex = 11
Top = 4320
Width = 1095
End
Begin VB.CommandButton Command6
Caption = "修改"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 1680
TabIndex = 10
Top = 4320
Width = 1095
End
Begin VB.CommandButton Command5
Caption = " 添加"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 120
TabIndex = 9
Top = 4320
Width = 1095
End
Begin VB.CommandButton Command4
Caption = ">>"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 4800
TabIndex = 8
Top = 3600
Width = 1095
End
Begin VB.CommandButton Command3
Caption = ">"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 3240
TabIndex = 7
Top = 3600
Width = 1095
End
Begin VB.CommandButton Command2
Caption = "<"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 1680
TabIndex = 6
Top = 3600
Width = 1095
End
Begin VB.CommandButton Command1
Caption = "<<"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 495
Left = 120
TabIndex = 5
Top = 3600
Width = 1095
End
Begin VB.Line Line2
BorderColor = &H80000005&
X1 = 0
X2 = 8640
Y1 = 3440
Y2 = 3440
End
Begin VB.Line Line1
X1 = 0
X2 = 8640
Y1 = 3420
Y2 = 3420
End
Begin VB.Label Label12
Caption = "【如:1988-08-16】"
Height = 495
Left = 3120
TabIndex = 30
Top = 2880
Width = 1575
End
Begin VB.Label Label11
Caption = "【如:1988-08-16】"
Height = 495
Left = 3120
TabIndex = 29
Top = 2175
Width = 1575
End
Begin VB.Label Label10
Caption = "家庭住址"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 4680
TabIndex = 28
Top = 2880
Width = 975
End
Begin VB.Label Label9
Caption = "手 机"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 4680
TabIndex = 27
Top = 2190
Width = 855
End
Begin VB.Label Label8
Caption = "电 话"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 4680
TabIndex = 26
Top = 1500
Width = 855
End
Begin VB.Label Label7
Caption = "职 业"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 4680
TabIndex = 25
Top = 810
Width = 975
End
Begin VB.Label Label2
Caption = "住院号"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 4680
TabIndex = 24
Top = 120
Width = 975
End
Begin VB.Label Label6
Caption = "起病日期"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 0
TabIndex = 4
Top = 2880
Width = 975
End
Begin VB.Label Label5
Caption = "出生日期"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 0
TabIndex = 3
Top = 2190
Width = 975
End
Begin VB.Label Label4
Caption = "性 别"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 120
TabIndex = 2
Top = 1500
Width = 855
End
Begin VB.Label Label3
Caption = "姓 名"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 120
TabIndex = 1
Top = 810
Width = 855
End
Begin VB.Label Label1
Caption = "ID 号"
BeginProperty Font
Name = "MS Sans Serif"
Size = 12
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 120
TabIndex = 0
Top = 120
Width = 855
End
End
Attribute VB_Name = "FrmAdd1"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
If Data1.Recordset.RecordCount < 1 Then
MsgBox "数据库中没有数据", vbOKOnly + vbInformation, "系统消息"
Exit Sub
End If
Data1.Recordset.MoveFirst
End Sub
Private Sub Command2_Click()
If Data1.Recordset.RecordCount < 1 Then
MsgBox "数据库中没有数据", vbOKOnly + vbInformation, "系统消息"
Exit Sub
End If
Data1.Recordset.MovePrevious
If Data1.Recordset.BOF Then
Data1.Recordset.MoveFirst
End If
End Sub
Private Sub Command3_Click()
If Data1.Recordset.RecordCount < 1 Then
MsgBox "数据库中没有数据", vbOKOnly + vbInformation, "系统消息"
Exit Sub
End If
Data1.Recordset.MoveNext
If Data1.Recordset.EOF Then
Data1.Recordset.MoveLast
End If
End Sub
Private Sub Command4_Click()
If Data1.Recordset.RecordCount < 1 Then
MsgBox "数据库中没有数据", vbOKOnly + vbInformation, "系统消息"
Exit Sub
End If
Data1.Recordset.MoveLast
End Sub
Private Sub Command5_Click()
Command1.Enabled = False
Command2.Enabled = False
Command3.Enabled = False
Command4.Enabled = False
Command5.Enabled = False
Command6.Enabled = False
Command7.Enabled = True
Command8.Enabled = False
Text1.SetFocus
lockfalsh ' 解除琐定
Data1.Recordset.addnew
End Sub
Private Sub Command6_Click()
Command1.Enabled = False
Command2.Enabled = False
Command3.Enabled = False
Command4.Enabled = False
Command5.Enabled = False
Command6.Enabled = False
Command7.Enabled = True
Command8.Enabled = False
lockfalsh ' 解除琐定
If Data1.Recordset.RecordCount < 1 Then
MsgBox "当前没有记录，无法修改", vbQuestion + vbInformation, "系统消息"
Exit Sub
End If
Data1.Recordset.Edit
End Sub
Private Sub Command7_Click()
If Text1.Text = "" Then
MsgBox "ID号不能为空", vbOKOnly + vbQuestion, "系统信息"
Text1.SetFocus
Exit Sub
End If
If Text2.Text = "" Then
MsgBox "请填写姓名", vbOKOnly + vbQuestion, "系统信息"
Text2.SetFocus
Exit Sub
End If
If Combo1.Text = "" Then
MsgBox "请选择性别", vbOKOnly + vbQuestion, "系统信息"
Combo1.SetFocus
Exit Sub
End If
If Text3.Text = "" Then
MsgBox "请填写出生日期", vbOKOnly + vbQuestion, "系统信息"
Text3.SetFocus
Exit Sub
End If
If Text4.Text = "" Then
MsgBox "请填写起病日期", vbOKOnly + vbQuestion, "系统信息"
Text4.SetFocus
Exit Sub
End If
Data1.Recordset.Update
Data1.Refresh
MsgBox "保存成功", vbOKOnly + vbInformation, "系统消息"
Command1.Enabled = True
Command2.Enabled = True
Command3.Enabled = True
Command4.Enabled = True
Command5.Enabled = True
Command6.Enabled = True
Command7.Enabled = False
Command8.Enabled = True
locked '锁定
End Sub
Private Sub Command8_Click()
On Error GoTo err
If Data1.Recordset.RecordCount < 1 Then
MsgBox "数据库中没有数据", vbOKOnly + vbCritical, "系统消息"
Exit Sub
End If
Data1.Recordset.Delete
Data1.Recordset.MoveNext
If Data1.Recordset.EOF Then
Data1.Recordset.MoveLast
End If
err:
If err.Number = 3021 Then
MsgBox "无当前记录", vbOKOnly + vbCritical, "系统信息"
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
Text6.Text = ""
Text7.Text = ""
Text8.Text = ""
Text9.Text = ""
Combo1.Text = ""
Exit Sub
End If
End Sub
Private Sub Command9_Click()
Unload Me
FrmMdi.mnuadd1.Checked = False
End Sub
Private Sub Form_Load()
Data1.DatabaseName = App.Path & "\message.mdb"
Data1.RecordSource = "basic"
Data1.Refresh
locked '锁定
Command7.Enabled = False
Me.Height = 5295
Me.Width = 7905
Combo1.AddItem "男"
Combo1.AddItem "女"
End Sub
Sub locked() '锁定
Text1.locked = True
Text2.locked = True
Text3.locked = True
Text4.locked = True
Text5.locked = True
Text6.locked = True
Text7.locked = True
Text8.locked = True
Text9.locked = True
Combo1.locked = True
End Sub
Sub lockfalsh() ' 解除琐定
Text1.locked = False
Text2.locked = False
Text3.locked = False
Text4.locked = False
Text5.locked = False
Text6.locked = False
Text7.locked = False
Text8.locked = False
Text9.locked = False
Combo1.locked = False
End Sub
Private Sub Form_Unload(Cancel As Integer)
FrmMdi.mnuadd1.Checked = False
End Sub
Private Sub Timer1_Timer()
Me.Height = 5295
Me.Width = 7905
End Sub