⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 pass.frm

📁 这是一个医院管理系统中的院长查询模块
💻 FRM
字号:
VERSION 5.00
Begin VB.Form mmm 
   BackColor       =   &H80000004&
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "东星医用网络、请您输入登录口令"
   ClientHeight    =   1935
   ClientLeft      =   4050
   ClientTop       =   3435
   ClientWidth     =   4140
   BeginProperty Font 
      Name            =   "宋体"
      Size            =   9
      Charset         =   134
      Weight          =   700
      Underline       =   0   'False
      Italic          =   0   'False
      Strikethrough   =   0   'False
   EndProperty
   Icon            =   "PASS.frx":0000
   LinkTopic       =   "Form3"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   Moveable        =   0   'False
   ScaleHeight     =   1935
   ScaleWidth      =   4140
   ShowInTaskbar   =   0   'False
   Begin VB.Timer Timer1 
      Enabled         =   0   'False
      Left            =   180
      Top             =   120
   End
   Begin VB.Data Data1 
      Caption         =   "Data1"
      Connect         =   "odbc;uid=sa;pwd=lpcy;database=yd_mz;"
      DatabaseName    =   "ydhis"
      DefaultCursorType=   0  'DefaultCursor
      DefaultType     =   2  'UseODBC
      Exclusive       =   0   'False
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   345
      Left            =   4440
      Options         =   0
      ReadOnly        =   0   'False
      RecordsetType   =   2  'Snapshot
      RecordSource    =   "dbo.cZY_table"
      Top             =   3570
      Visible         =   0   'False
      Width           =   1215
   End
   Begin VB.TextBox Text3 
      BackColor       =   &H00FFFFFF&
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00000000&
      Height          =   360
      Left            =   1965
      Locked          =   -1  'True
      MaxLength       =   15
      TabIndex        =   6
      Top             =   585
      Width           =   1860
   End
   Begin VB.CommandButton Command2 
      BackColor       =   &H80000004&
      Cancel          =   -1  'True
      Caption         =   "取消"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   330
      Left            =   2370
      MaskColor       =   &H00FFFFFF&
      Style           =   1  'Graphical
      TabIndex        =   5
      Top             =   1485
      Width           =   1350
   End
   Begin VB.CommandButton Command1 
      BackColor       =   &H80000004&
      Caption         =   "确定"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   330
      Left            =   615
      MaskColor       =   &H00FFFFFF&
      Style           =   1  'Graphical
      TabIndex        =   4
      Top             =   1485
      Width           =   1350
   End
   Begin VB.TextBox Text2 
      BackColor       =   &H00FFFFFF&
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000FF&
      Height          =   360
      IMEMode         =   3  'DISABLE
      Left            =   1965
      MaxLength       =   15
      PasswordChar    =   "*"
      TabIndex        =   2
      ToolTipText     =   "请输入密码"
      Top             =   990
      Width           =   1860
   End
   Begin VB.TextBox Text1 
      BackColor       =   &H00FFFFFF&
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   12
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00000000&
      Height          =   360
      IMEMode         =   3  'DISABLE
      Left            =   1965
      MaxLength       =   3
      TabIndex        =   1
      ToolTipText     =   "请输入操作员代码"
      Top             =   180
      Width           =   1860
   End
   Begin VB.Label Label3 
      BackStyle       =   0  'Transparent
      Caption         =   "操作员姓名:"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00000000&
      Height          =   240
      Left            =   405
      TabIndex        =   7
      Top             =   630
      Width           =   1770
   End
   Begin VB.Label Label2 
      BackStyle       =   0  'Transparent
      Caption         =   "操作员密码:"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000FF&
      Height          =   285
      Left            =   405
      TabIndex        =   3
      Top             =   1065
      Width           =   1860
   End
   Begin VB.Label Label1 
      BackStyle       =   0  'Transparent
      Caption         =   "操作员代码:"
      BeginProperty Font 
         Name            =   "隶书"
         Size            =   14.25
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H000000FF&
      Height          =   240
      Left            =   405
      TabIndex        =   0
      Top             =   210
      Width           =   1770
   End
End
Attribute VB_Name = "mmm"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False

Private Sub Command1_Click()
If Text3 = "" Then
MsgBox "操作员代码输入错误,请注意大小写,然后重新录入!"
TEXT1 = ""
Text2 = ""
TEXT1.SetFocus
Exit Sub
End If
If Data1.Recordset!CZY_MM = DxMmm(Text2) Then
CZYID = Trim(TEXT1)
Form3.sbar.Panels(2) = CZYID + "-" + CStr(Data1.Recordset!CZY_NAME)
Select Case menu
Case 50
Form3.Show
menu = 1000
Unload Me
Unload Form11
End Select
TEXT1 = ""
Text2 = ""
Else
MsgBox "口令输入错误,请注意大小写,然后重新录入!"
Text2 = ""
TEXT1 = ""
TEXT1.SetFocus
End If
End Sub

Private Sub Command2_Click()
Timer1.Enabled = False
TEXT1 = ""
Text2 = ""
If menu = 111 Then
Unload Me
Exit Sub
End If
Select Case menu
Case 50
Unload Me
Case Else
Form3.Enabled = True
TEXT1.SetFocus
Unload Me
Form3.Show
Form3.SetFocus
End Select
End Sub

Private Sub Form_Activate()
If menu = 111 Then
mmm.Timer1.Interval = 10000
mmm.Timer1.Enabled = True
End If
End Sub

Private Sub Form_Load()
TEXT1 = ""
Text2 = ""
Data1.Connect = DxPassWord
Data1.DatabaseName = "207his"
Data1.RecordSource = "SELECT * FROM CZY_TABLE WHERE CZY_ID='" + TEXT1 + "' AND KS LIKE '*A*'"
End Sub

Private Sub Form_Unload(Cancel As Integer)
If menu = 50 Then
db.Close
Call showwindows
Unload Form11
End
End If
End Sub

Private Sub Text1_GotFocus()
TEXT1 = ""
Text2 = ""
Text3 = ""
End Sub

Private Sub Text1_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 Then
Data1.RecordSource = "SELECT * FROM CZY_TABLE WHERE CZY_ID='" + TEXT1 + "' AND KS LIKE '*A*'"
Data1.Refresh
If Not Data1.Recordset.EOF Then
Text3 = Data1.Recordset!CZY_NAME
Text2.SetFocus
End If
End If
End Sub

Private Sub Text2_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 Then
KeyCode = 0
Call Command1_Click
End If
End Sub

Private Sub Timer1_Timer()
Timer1.Enabled = False
Unload mmm
End Sub

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -