frmqy.frm

这是一个毕业设计论文

VERSION 5.00
Begin VB.Form frmQY 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "取药系统"
   ClientHeight    =   4845
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   5295
   Icon            =   "frmQY.frx":0000
   LinkTopic       =   "Form1"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MDIChild        =   -1  'True
   MinButton       =   0   'False
   ScaleHeight     =   4845
   ScaleWidth      =   5295
   Begin VB.PictureBox Picture1 
      AutoSize        =   -1  'True
      BorderStyle     =   0  'None
      Height          =   480
      Left            =   0
      Picture         =   "frmQY.frx":030A
      ScaleHeight     =   480
      ScaleWidth      =   480
      TabIndex        =   10
      Top             =   0
      Width           =   480
   End
   Begin VB.CommandButton Command3 
      Caption         =   "退出"
      Height          =   375
      Left            =   3150
      TabIndex        =   9
      Top             =   4185
      Width           =   855
   End
   Begin VB.CommandButton Command2 
      Caption         =   "保存"
      Height          =   375
      Left            =   1740
      TabIndex        =   8
      Top             =   4185
      Width           =   855
   End
   Begin VB.Frame Frame2 
      Caption         =   "输入取药信息"
      Height          =   2295
      Left            =   480
      TabIndex        =   5
      Top             =   1680
      Width           =   4155
      Begin VB.TextBox Text1 
         Height          =   1095
         Left            =   1395
         TabIndex        =   7
         Top             =   480
         Width           =   2340
      End
      Begin VB.Label Label5 
         Caption         =   "药方"
         ForeColor       =   &H00800000&
         Height          =   255
         Left            =   990
         TabIndex        =   6
         Top             =   585
         Width           =   495
      End
   End
   Begin VB.Frame Frame1 
      Caption         =   "显示信息"
      Height          =   1335
      Left            =   480
      TabIndex        =   0
      Top             =   240
      Width           =   4155
      Begin VB.ListBox List2 
         Height          =   240
         Left            =   1440
         TabIndex        =   4
         Top             =   720
         Width           =   2295
      End
      Begin VB.ListBox List1 
         Height          =   240
         Left            =   1440
         TabIndex        =   2
         Top             =   360
         Width           =   2295
      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 = "frmQY"
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 Tmnos='" & Text1.Text & "', Tflagm='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