frmjz.frm

这是我大学毕业时作的毕业设计

VERSION 5.00
Begin VB.Form frmJZ 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "就诊系统"
   ClientHeight    =   4335
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   6285
   Icon            =   "frmJZ.frx":0000
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   4335
   ScaleWidth      =   6285
   Begin VB.PictureBox Picture1 
      AutoSize        =   -1  'True
      BorderStyle     =   0  'None
      Height          =   480
      Left            =   0
      Picture         =   "frmJZ.frx":0442
      ScaleHeight     =   480
      ScaleWidth      =   480
      TabIndex        =   10
      Top             =   0
      Width           =   480
   End
   Begin VB.CommandButton Command3 
      Caption         =   "退出"
      Height          =   375
      Left            =   2595
      TabIndex        =   9
      Top             =   3795
      Width           =   855
   End
   Begin VB.CommandButton Command2 
      Caption         =   "保存"
      Height          =   375
      Left            =   1275
      TabIndex        =   8
      Top             =   3795
      Width           =   855
   End
   Begin VB.Frame Frame2 
      Caption         =   "输入诊断信息"
      Height          =   1815
      Left            =   480
      TabIndex        =   5
      Top             =   1680
      Width           =   5500
      Begin VB.TextBox Text1 
         Height          =   1095
         Left            =   1485
         TabIndex        =   7
         Top             =   405
         Width           =   3800
      End
      Begin VB.Label Label3 
         Caption         =   "诊断信息"
         ForeColor       =   &H00800080&
         Height          =   255
         Left            =   525
         TabIndex        =   6
         Top             =   405
         Width           =   735
      End
   End
   Begin VB.Frame Frame1 
      Caption         =   "显示信息"
      Height          =   1335
      Left            =   480
      TabIndex        =   0
      Top             =   240
      Width           =   3570
      Begin VB.ListBox List2 
         Height          =   240
         Left            =   1440
         TabIndex        =   4
         Top             =   720
         Width           =   1935
      End
      Begin VB.ListBox List1 
         Height          =   240
         Left            =   1440
         TabIndex        =   2
         Top             =   360
         Width           =   1935
      End
      Begin VB.Label Label2 
         Caption         =   "诊断医生编号"
         Height          =   255
         Left            =   120
         TabIndex        =   3
         Top             =   720
         Width           =   1095
      End
      Begin VB.Label Label1 
         Caption         =   "诊断日期"
         Height          =   255
         Left            =   480
         TabIndex        =   1
         Top             =   360
         Width           =   735
      End
   End
End
Attribute VB_Name = "frmJZ"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim Pno As String
Dim mrc2 As ADODB.Recordset

Private Sub Command2_Click()

Conn.Execute "update treat set Tinfo='" & Text1.Text & "', Tflagt='1' where Tpno='" & Pno & "' and Tdate='" & List1.Text & "' and Tdno='" & List2.Text & "'"

MsgBox "诊断信息添加成功", , "提示"
Unload Me
End Sub

Private Sub Command3_Click()
Unload Me
End Sub

Private Sub Form_Load()
Dim i As Integer
Dim mrc As Recordset
Pno = InputBox("请输入病例号", "提示")
If Len(Pno) = 0 Then
MsgBox "请先输入病例号,然后进行交费管理!", , "提示"
Unload Me
Exit Sub
End If
i = 0
Set mrc = New Recordset
mrc.Open "select * from treat where Tpno='" & Pno & "'", Conn, adOpenKeyset, adLockOptimistic
If mrc.EOF Then
MsgBox "不存在该病例号,或该病例号病人未进行挂号费交纳,请先交纳挂号费!", , "提示"
Unload Me
Exit Sub
Else

While Not mrc.EOF
List1.List(i) = mrc("Tdate")
i = i + 1
mrc.MoveNext
Wend
End If
List1.ListIndex = 0
If mrc.State = 1 Then
  mrc.Close
  Set mrc = Nothing
End If
End Sub

Private Sub List1_Click()
Dim i As Integer
Dim txtsql As String
Dim msgtxt As String
Dim mrc As ADODB.Recordset
i = 0
While Not List1.Selected(i)
i = i + 1
Wend
txtsql = "select * from TREAT where Tdate='" + List1.List(i) + "' and Tpno='" + Pno + "'"
Set mrc = New Recordset
mrc.Open txtsql, Conn, adOpenKeyset, adLockOptimistic
i = 0
While Not mrc.EOF
List2.List(i) = mrc("Tdno")
mrc.MoveNext
i = i + 1
Wend
List2.ListIndex = 0
If mrc.State = 1 Then
mrc.Close
End If
End Sub