📄 frmpatientbaseinfoquery
字号:
VERSION 5.00
Object = "{C932BA88-4374-101B-A56C-00AA003668DC}#1.1#0"; "msmask32.ocx"
Object = "{AA0D501B-0C16-11D4-8531-00E098160F52}#4.0#0"; "ComnButtons.ocx"
Begin VB.Form frmPatientBaseInfoQuery
Caption = "查询"
ClientHeight = 1875
ClientLeft = 3390
ClientTop = 2895
ClientWidth = 5805
Icon = "frmPatientBaseInfoQuery.frx":0000
KeyPreview = -1 'True
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
Moveable = 0 'False
ScaleHeight = 1875
ScaleWidth = 5805
Begin ComnButtons.ButtonGroup ButtonGroup1
Height = 405
Left = 2760
TabIndex = 12
Top = 1440
Width = 2985
_ExtentX = 5265
_ExtentY = 714
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
BackColor = -2147483638
ButtonCount = 3
ButtonCaption = "&A.确定 &C.取消 &E.关闭"
KeyEnabled = "1#1#1#"
End
Begin VB.ComboBox cboSex
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 330
ItemData = "frmPatientBaseInfoQuery.frx":0442
Left = 3960
List = "frmPatientBaseInfoQuery.frx":044C
TabIndex = 5
Text = "cboSex"
Top = 930
Width = 1770
End
Begin VB.ComboBox cboPtID
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 330
ItemData = "frmPatientBaseInfoQuery.frx":045E
Left = 1080
List = "frmPatientBaseInfoQuery.frx":0460
TabIndex = 4
Text = "cboPtID"
Top = 930
Width = 1770
End
Begin VB.TextBox txtName
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Left = 3960
TabIndex = 1
Text = "txtName"
Top = 75
Width = 1770
End
Begin VB.TextBox txtID
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
IMEMode = 2 'OFF
Left = 1080
TabIndex = 0
Text = "txtID"
Top = 75
Width = 1770
End
Begin MSMask.MaskEdBox mskDate
Height = 330
Index = 0
Left = 1080
TabIndex = 2
Top = 510
Width = 1770
_ExtentX = 3122
_ExtentY = 582
_Version = 393216
AutoTab = -1 'True
MaxLength = 10
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Mask = "####-##-##"
PromptChar = " "
End
Begin MSMask.MaskEdBox mskDate
Height = 330
Index = 1
Left = 3960
TabIndex = 3
Top = 510
Width = 1770
_ExtentX = 3122
_ExtentY = 582
_Version = 393216
AutoTab = -1 'True
MaxLength = 10
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Mask = "####-##-##"
PromptChar = " "
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "性 别"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 3060
TabIndex = 11
Top = 1005
Width = 840
End
Begin VB.Label Label7
AutoSize = -1 'True
Caption = "病人类型"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 90
TabIndex = 10
Top = 1005
Width = 840
End
Begin VB.Label Label8
AutoSize = -1 'True
Caption = "病人姓名"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 3060
TabIndex = 9
Top = 150
Width = 840
End
Begin VB.Label Label3
AutoSize = -1 'True
Caption = "病人 ID"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 90
TabIndex = 8
Top = 150
Width = 840
End
Begin VB.Line Line1
BorderColor = &H80000010&
Index = 1
X1 = 0
X2 = 6300
Y1 = 1410
Y2 = 1410
End
Begin VB.Label Label6
AutoSize = -1 'True
Caption = "--"
Height = 180
Left = 3300
TabIndex = 7
Top = 570
Width = 180
End
Begin VB.Label Label4
AutoSize = -1 'True
Caption = "出生日期"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 210
Left = 90
TabIndex = 6
Top = 585
Width = 840
End
End
Attribute VB_Name = "frmPatientBaseInfoQuery"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Public Event Ack(ByVal Cdt As String)
Public Event Cancel()
Private mStr As String
Private WithEvents ComnHlp1 As frmInputHelp
Attribute ComnHlp1.VB_VarHelpID = -1
Private Sub InitForm()
hisFormClear Me
End Sub
Private Function MakeCdt() As String
Dim PtID As String, Sex As String
Set gDBFldsObj = New clsDBFields
If cboPtID.ListIndex = -1 Then
PtID = ""
Else
PtID = Left(cboPtID.Text, InStr(cboPtID.Text, " ") - 1)
End If
If cboSex.ListIndex = -1 Then
Sex = ""
Else
Sex = Left(cboSex.Text, InStr(cboSex.Text, " ") - 1)
End If
gDBFldsObj.Add "PatientID", txtID, "", lmEquel
gDBFldsObj.Add "BirthDate", mskDate(0).Text, gstrMASK_INIT, lmGreatAndEquel
gDBFldsObj.Add "BirthDate", mskDate(1).Text & " 23:59:59", gstrMASK_INIT & " 23:59:59", lmLessAndEquel
gDBFldsObj.Add "PtID", PtID, ""
gDBFldsObj.Add "Sex", Sex, ""
MakeCdt = gDBFldsObj.MakeSelectSQL("")
End Function
Private Sub ComnHlp1_ResSelect(ByVal SelData As Variant, ByVal STag As String)
Me.SetFocus
If TypeName(SelData) <> "Nothing" Then
txtName = SelData(1)
txtID = SelData(0)
Else
txtName = ""
txtID = ""
End If
End Sub
Private Sub Form_KeyPress(KeyAscii As Integer)
If KeyAscii = vbKeyReturn Then
hisToActiveCtl(Me).SetFocus
KeyAscii = 0
End If
End Sub
Private Sub Form_Load()
Dim i As Integer
Call hisFormToCenter(Me, frmMain)
cboPtID.Clear
'For i = 1 To gPatientTypesObj.Count
' cboPtID.AddItem gPatientTypesObj.Item(i).ID & " " & gPatientTypesObj.Item(i).Des
'Next i
Set ComnHlp1 = New frmInputHelp
Set ComnHlp1.CN = gDbObj.CN
InitForm
End Sub
Private Sub Form_Unload(Cancel As Integer)
Set frmPatientBaseInfoQuery = Nothing
End Sub
Private Sub mskDate_LostFocus(Index As Integer)
If mskDate(Index) <> gstrMASK_INIT And Not IsDate(mskDate(Index)) Then
MsgBox gstrDATE_ERROR_MSG, vbCritical
mskDate(Index).SetFocus
End If
End Sub
Private Sub txtName_GotFocus()
mStr = txtName
txtName.SelLength = Len(mStr)
End Sub
Private Sub txtName_LostFocus()
If txtName = "" Or mStr = txtName Then Exit Sub
ComnHlp1.SQL = "SELECT PatientID,Name FROM Open_m_patientbaseinfo WHERE brief LIKE '##%'"
ComnHlp1.InitPut = txtName.Text
ComnHlp1.FormatHead = "病 人 编 码|病 人 姓 名"
ComnHlp1.WidthRate = 1
ComnHlp1.ParmTag = "Name"
ComnHlp1.ShowHelp vbModal
End Sub
Private Sub ButtonGroup1_Click(ByVal WhichB As Integer)
Select Case WhichB
Case 0
RaiseEvent Ack(MakeCdt())
Unload Me
Case 1
InitForm
txtID.SetFocus
Case 2
Unload Me
RaiseEvent Cancel
End Select
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -