经治医师查询.frm

这是一个医院管理系统中的院长查询模块

VERSION 5.00
Object = "{00028C01-0000-0000-0000-000000000046}#1.0#0"; "DBGRID32.OCX"
Begin VB.Form frmPatientDoctorQuery 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "住院管理-经治医师查询 "
   ClientHeight    =   4335
   ClientLeft      =   900
   ClientTop       =   1950
   ClientWidth     =   8100
   ControlBox      =   0   'False
   LinkTopic       =   "Form34"
   LockControls    =   -1  'True
   MaxButton       =   0   'False
   MinButton       =   0   'False
   Moveable        =   0   'False
   ScaleHeight     =   4335
   ScaleWidth      =   8100
   Begin VB.TextBox Text1 
      BackColor       =   &H00FFC0C0&
      BeginProperty Font 
         Name            =   "System"
         Size            =   12
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000040C0&
      Height          =   360
      Left            =   2190
      Locked          =   -1  'True
      TabIndex        =   3
      Text            =   "Text1"
      Top             =   3825
      Width           =   1470
   End
   Begin VB.PictureBox Picture1 
      Height          =   120
      Left            =   180
      ScaleHeight     =   60
      ScaleWidth      =   7620
      TabIndex        =   2
      Top             =   3585
      Width           =   7680
   End
   Begin VB.CommandButton Command1 
      Cancel          =   -1  'True
      Caption         =   "退  出 &Q"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   390
      Left            =   4680
      TabIndex        =   1
      Top             =   3810
      Width           =   2175
   End
   Begin VB.Data Data1 
      Caption         =   "Data1"
      Connect         =   "Access"
      DatabaseName    =   ""
      DefaultCursorType=   1  'ODBCCursor
      DefaultType     =   1  'UseODBC
      Exclusive       =   0   'False
      Height          =   285
      Left            =   6255
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   1  'Dynaset
      RecordSource    =   ""
      Top             =   3945
      Visible         =   0   'False
      Width           =   1935
   End
   Begin MSDBGrid.DBGrid DBGrid1 
      Bindings        =   "经治医师查询.frx":0000
      Height          =   3330
      Left            =   60
      OleObjectBlob   =   "经治医师查询.frx":0010
      TabIndex        =   0
      Top             =   105
      Width           =   7980
   End
   Begin VB.Label Label1 
      Caption         =   "现主治医师"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00008000&
      Height          =   375
      Index           =   8
      Left            =   540
      TabIndex        =   4
      Top             =   3840
      Width           =   1935
   End
End
Attribute VB_Name = "frmPatientDoctorQuery"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
 Unload Me
End Sub

Private Sub Form_Load()
 Dim rs As Recordset
 Dim Y As String
 Y = ""
 Data1.Connect = MyConnect
 Data1.DatabaseName = MyDatabase
 Data1.RecordSource = "zy_selectdoctor '" + yscxID + "'"
 Data1.Refresh
 Set rs = DB.OpenRecordset("SELECT * FROM ZY_IN_OUT WHERE ZY_ID='" + yscxID + "'")
 If Not rs.EOF Then
  If Not IsNull(rs!YS_ID) Then
     Y = rs!YS_ID
  End If
 End If
 rs.Close
 If Y <> "" Then
   Set rs = DB.OpenRecordset("SELECT * FROM YS_TABLE WHERE YS_ID='" + Y + "'")
   If Not rs.EOF Then
    If Not IsNull(rs!YS_NAME) Then
     Text1.Text = Y & "-" & rs!YS_NAME
    End If
   End If
 End If
End Sub