📄 frmsee.frm
字号:
Left = 1755
TabIndex = 52
Top = 1635
Width = 540
End
Begin VB.Label Label36
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "西药费"
ForeColor = &H00000000&
Height = 180
Left = 1755
TabIndex = 51
Top = 165
Width = 540
End
Begin VB.Label Label35
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "取暖费"
ForeColor = &H00000000&
Height = 180
Left = 4875
TabIndex = 50
Top = 1275
Width = 540
End
Begin VB.Label Label34
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "保护费"
ForeColor = &H00000000&
Height = 180
Left = 3315
TabIndex = 49
Top = 1275
Width = 540
End
Begin VB.Label Label33
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "生活费"
ForeColor = &H00000000&
Height = 180
Left = 1755
TabIndex = 48
Top = 1275
Width = 540
End
Begin VB.Label Label32
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "输氧费"
ForeColor = &H00000000&
Height = 180
Left = 3315
TabIndex = 47
Top = 915
Width = 540
End
Begin VB.Label Label31
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "输血费"
ForeColor = &H00000000&
Height = 180
Left = 4875
TabIndex = 46
Top = 915
Width = 540
End
Begin VB.Label Label30
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "胃镜费"
ForeColor = &H00000000&
Height = 180
Left = 180
TabIndex = 45
Top = 1635
Width = 540
End
Begin VB.Label Label29
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "脑电费"
ForeColor = &H00000000&
Height = 180
Left = 180
TabIndex = 44
Top = 1995
Width = 540
End
Begin VB.Label Label28
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "心电费"
ForeColor = &H00000000&
Height = 180
Left = 180
TabIndex = 43
Top = 900
Width = 540
End
Begin VB.Label Label27
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "化验费"
ForeColor = &H00000000&
Height = 180
Left = 4875
TabIndex = 42
Top = 540
Width = 540
End
Begin VB.Label Label26
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "护理费"
ForeColor = &H00000000&
Height = 180
Left = 3315
TabIndex = 41
Top = 540
Width = 540
End
Begin VB.Label Label25
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "五 防"
ForeColor = &H00000000&
Height = 180
Left = 1755
TabIndex = 40
Top = 540
Width = 540
End
Begin VB.Label Label24
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "放射费"
ForeColor = &H00000000&
Height = 180
Left = 180
TabIndex = 39
Top = 540
Width = 540
End
Begin VB.Label Label23
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "诊疗费"
ForeColor = &H00000000&
Height = 180
Left = 4875
TabIndex = 38
Top = 165
Width = 540
End
Begin VB.Label Label22
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "治疗费"
ForeColor = &H00000000&
Height = 180
Left = 3315
TabIndex = 37
Top = 165
Width = 540
End
Begin VB.Label Label21
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "Ｂ超费"
ForeColor = &H00000000&
Height = 180
Left = 180
TabIndex = 36
Top = 1275
Width = 540
End
Begin VB.Label Label20
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
Caption = "床位费"
ForeColor = &H00000000&
Height = 180
Left = 180
TabIndex = 35
Top = 165
Width = 540
End
Begin VB.Label Label47
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "ＣＴ费"
Height = 180
Left = 180
TabIndex = 34
Top = 2325
Width = 540
End
Begin VB.Label Label48
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "检查费"
Height = 180
Left = 1755
TabIndex = 33
Top = 2325
Width = 540
End
Begin VB.Label Label49
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "其它费"
Height = 180
Left = 3315
TabIndex = 32
Top = 2325
Width = 540
End
End
Begin VB.CommandButton Command2
Caption = "详细费用&(D)"
Height = 350
Left = 3870
TabIndex = 2
Top = 2445
Width = 1200
End
Begin VB.CommandButton Command1
Caption = "关闭&(C)"
Height = 350
Left = 5280
TabIndex = 3
Top = 2445
Width = 1200
End
Begin MSAdodcLib.Adodc Adodc1
Height = 330
Left = 2520
Top = 2520
Visible = 0 'False
Width = 1335
_ExtentX = 2355
_ExtentY = 582
ConnectMode = 0
CursorLocation = 3
IsolationLevel = -1
ConnectionTimeout= 15
CommandTimeout = 30
CursorType = 3
LockType = 3
CommandType = 8
CursorOptions = 0
CacheSize = 50
MaxRecords = 0
BOFAction = 0
EOFAction = 0
ConnectStringType= 1
Appearance = 1
BackColor = -2147483643
ForeColor = -2147483640
Orientation = 0
Enabled = -1
Connect = ""
OLEDBString = ""
OLEDBFile = ""
DataSourceName = ""
OtherAttributes = ""
UserName = ""
Password = ""
RecordSource = ""
Caption = "Adodc1"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
_Version = 393216
End
Begin VB.Label Label17
AutoSize = -1 'True
BackColor = &H00404040&
BackStyle = 0 'Transparent
ForeColor = &H00000000&
Height = 180
Left = 200
TabIndex = 1
Top = 2520
Width = 90
End
End
Attribute VB_Name = "frmsee"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public zafei As String
Public strname As String
Private Sub Command1_Click()
Unload Me
End Sub
Private Sub Command2_Click()
Command2.Enabled = False
frmzafei.Show
End Sub
Private Sub Form_Activate()
frmmain.StatusBar1.Panels(2) = "活动窗口：" & frmsee.Caption
End Sub
Private Sub Form_Load()
Dim fyhj As Double
On Error GoTo err0
frmsee.Top = (frmmain.Height - frmsee.Height) / 2 - 500
frmsee.Left = (frmmain.Width - frmsee.Width) / 2
Adodc1.ConnectionString = frmlogin.conn
Command2.Enabled = False
frmsee.Height = 3270
Exit Sub
err0:
MsgBox "数据库连接失败！"
End Sub
Private Sub Text1_Change()
On Error GoTo err2
With Adodc1
.RecordSource = "select * from zyf where 住院证号='" & Text1.text & "'"
.Refresh
If .Recordset.AbsolutePosition <> adPosUnknown Then
frmsee.Height = 6225
Command2.Enabled = True
Text2.text = .Recordset.Fields("患者姓名")
strname = Text2.text
Text15.text = .Recordset.Fields("性别")
Text3.text = .Recordset.Fields("年龄")
Text4.text = .Recordset.Fields("病种")
Text14.text = .Recordset.Fields("预交费")
Text6.text = .Recordset.Fields("地址")
Text7.text = .Recordset.Fields("科室类别")
Text8.text = .Recordset.Fields("病房号")
Text9.text = .Recordset.Fields("床位号")
Text10.text = .Recordset.Fields("主治大夫")
Text11.text = Year(.Recordset.Fields("住院日期"))
Text12.text = Month(.Recordset.Fields("住院日期"))
Text13.text = Day(.Recordset.Fields("住院日期"))
fyhj = .Recordset.Fields("预交费") - .Recordset.Fields("费用合计")
zafei = .Recordset.Fields("备注")
If fyhj >= 0 Then
Label16.Caption = "剩余费用"
Text5.text = .Recordset.Fields("退费")
Else
Label16.Caption = "拖欠费用"
Text5.text = .Recordset.Fields("欠费")
End If
If .Recordset.Fields("出院标记") = True Then
Label17.Caption = "■此患者已于" & Year(.Recordset.Fields("出院日期")) & "年" & Month(.Recordset.Fields("出院日期")) & "月" & Day(.Recordset.Fields("出院日期")) & "日出院。"
Else
Label17.Caption = "■该患者目前尚未出院。"
End If
For i = 0 To 26
Text17(i).text = .Recordset.Fields(i + 12)
Next
Text16.text = .Recordset.Fields("费用合计")
Else
frmsee.Height = 3270
Text2.text = ""
strname = ""
zafei = ""
Text3.text = ""
Text4.text = ""
Text5.text = ""
Text6.text = ""
Text7.text = ""
Text8.text = ""
Text9.text = ""
Text10.text = ""
Text11.text = ""
Text12.text = ""
Text13.text = ""
Text14.text = ""
Label17.Caption = "■没有住院证号是“" & Text1.text & "”的患者。"
End If
End With
Exit Sub
err2:
MsgBox "数据类型不匹配或数据库连接失败！"
End Sub
Private Sub Form_Unload(Cancel As Integer)
frmmain.StatusBar1.Panels(2) = "目前没有窗口被激活"
End Sub
Private Sub Text1_GotFocus()
Text1.SelStart = 0
Text1.SelLength = Len(Text1.text)
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -