frmhyinfo.frm

这是一个毕业设计论文

VERSION 5.00
Begin VB.Form frmHYInfo 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "化验信息"
   ClientHeight    =   4410
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   4320
   Icon            =   "FrmHYInfo.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   4410
   ScaleWidth      =   4320
   Begin VB.PictureBox picDraw 
      AutoSize        =   -1  'True
      BorderStyle     =   0  'None
      Height          =   1125
      Left            =   45
      Picture         =   "FrmHYInfo.frx":030A
      ScaleHeight     =   1125
      ScaleWidth      =   1260
      TabIndex        =   10
      Top             =   2655
      Width           =   1260
   End
   Begin VB.CommandButton Command3 
      Caption         =   "退出"
      Height          =   375
      Left            =   2535
      TabIndex        =   9
      Top             =   3885
      Width           =   855
   End
   Begin VB.CommandButton Command2 
      Caption         =   "保存"
      Height          =   375
      Left            =   975
      TabIndex        =   8
      Top             =   3885
      Width           =   855
   End
   Begin VB.Frame Frame2 
      Caption         =   "输入化验信息"
      ForeColor       =   &H000040C0&
      Height          =   1815
      Left            =   315
      TabIndex        =   5
      Top             =   1710
      Width           =   3615
      Begin VB.TextBox Text1 
         Height          =   975
         Left            =   1395
         TabIndex        =   7
         Top             =   405
         Width           =   1935
      End
      Begin VB.Label Label4 
         Caption         =   "化验信息"
         ForeColor       =   &H00800000&
         Height          =   255
         Left            =   675
         TabIndex        =   6
         Top             =   405
         Width           =   735
      End
   End
   Begin VB.Frame Frame1 
      Caption         =   "显示信息"
      Height          =   1335
      Left            =   315
      TabIndex        =   0
      Top             =   180
      Width           =   3615
      Begin VB.ListBox List2 
         Height          =   240
         Left            =   1440
         TabIndex        =   4
         Top             =   720
         Width           =   1845
      End
      Begin VB.ListBox List1 
         Height          =   240
         Left            =   1440
         TabIndex        =   2
         Top             =   360
         Width           =   1845
      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 = "frmHYInfo"
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 Tanos='" & Text1.Text & "',Tflaga='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
'
'Private Sub List2_Click()
'Dim i, j As Integer
'Dim txtsql As String
'Dim msgtxt As String
'Dim mrc As ADODB.Recordset
'i = 0
'j = 0
'While Not List1.Selected(i)
'i = i + 1
'Wend
'While Not List2.Selected(j)
'j = j + 1
'Wend
'txtsql = "select * from TREAT where Tdate='" + List1.List(i) + "' and Tdno='" + List2.List(j) + "' and Tpno='" + Pno + "'"
'Set mrc2 = New Recordset
'mrc2.Open txtsql, Conn, adOpenKeyset, adLockOptimistic
'
'End Sub