📄 frmfetchquery.frm
字号:
VERSION 5.00
Object = "{C932BA88-4374-101B-A56C-00AA003668DC}#1.1#0"; "MSMASK32.OCX"
Begin VB.Form frmFetchQuery
BorderStyle = 1 'Fixed Single
Caption = "取药查询"
ClientHeight = 3645
ClientLeft = 2865
ClientTop = 1860
ClientWidth = 5850
Icon = "frmFetchQuery.frx":0000
KeyPreview = -1 'True
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 3645
ScaleWidth = 5850
Begin VB.CheckBox chkBack
Caption = "退药"
Height = 270
Left = 105
TabIndex = 15
Top = 2760
Width = 1755
End
Begin VB.CheckBox chkFetch
Caption = "取药"
Height = 270
Left = 105
TabIndex = 14
Top = 2370
Width = 1755
End
Begin VB.TextBox txtHandler
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Left = 3870
TabIndex = 3
Text = "txtHandler"
Top = 870
Width = 1770
End
Begin VB.CommandButton cmdAck
Caption = "&A.确 定"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 405
Left = 3585
TabIndex = 12
Top = 3210
Width = 1065
End
Begin VB.CommandButton cmdClose
Caption = "&E.关 闭"
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 405
Left = 4755
TabIndex = 11
Top = 3210
Width = 1065
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 = 3885
TabIndex = 1
Text = "txtName"
Top = 60
Width = 1770
End
Begin VB.TextBox txtDepart
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 345
Left = 1005
TabIndex = 2
Text = "txtDepart"
Top = 885
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
Left = 1005
TabIndex = 0
Text = "txtID"
Top = 45
Width = 1770
End
Begin MSMask.MaskEdBox mskDate
Height = 330
Index = 0
Left = 990
TabIndex = 4
Top = 1890
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 = 3855
TabIndex = 5
Top = 1890
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 Label5
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 = 2910
TabIndex = 13
Top = 945
Width = 630
End
Begin VB.Line Line1
BorderColor = &H80000010&
Index = 1
X1 = 0
X2 = 6300
Y1 = 3135
Y2 = 3135
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 = 2895
TabIndex = 10
Top = 150
Width = 840
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 = 45
TabIndex = 9
Top = 930
Width = 840
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 = 0
TabIndex = 8
Top = 1950
Width = 840
End
Begin VB.Label Label6
AutoSize = -1 'True
Caption = "--"
Height = 180
Left = 3195
TabIndex = 7
Top = 1950
Width = 180
End
Begin VB.Label Label7
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 = 45
TabIndex = 6
Top = 135
Width = 630
End
End
Attribute VB_Name = "frmFetchQuery"
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 Del()
Private OldName As String
Private OldDepart As String
Private WithEvents ComnHlp1 As frmInputHelp
Attribute ComnHlp1.VB_VarHelpID = -1
Private Sub cmdAck_Click()
RaiseEvent Ack(MakeCdt())
Unload Me
End Sub
Private Function MakeCdt() As String
Dim HdCode As String
Dim TmpStr As String
Set gDBFldsObj = New clsDBFields
gDBFldsObj.Add "FetchHdCode", txtHandler, "", lmEquel
gDBFldsObj.Add "PatientID", txtID, "", lmEquel
gDBFldsObj.Add "Name", txtName, "", lmEquel
gDBFldsObj.Add "DepCode", txtDepart.Tag, "", lmlike
gDBFldsObj.Add "FetchDate", mskDate(0).Text, gstrMASK_INIT, lmGreatAndEquel
gDBFldsObj.Add "FetchDate", mskDate(1).Text & " 23:59:59", gstrMASK_INIT & " 23:59:59", lmLessAndEquel
If chkFetch.Value = 0 Then
gDBFldsObj.Add "Fair", 0, -1, lmLess
End If
If chkBack.Value = 0 Then
gDBFldsObj.Add "Fair", 0, -1, lmGreat
End If
TmpStr = gDBFldsObj.MakeSelectSQL("")
MakeCdt = TmpStr
End Function
Private Sub cmdClose_Click()
Unload Me
End Sub
Private Sub ComnHlp1_ResSelect(ByVal SelData As Variant, ByVal STag As String)
Me.SetFocus
Select Case STag
Case "Depart"
If TypeName(SelData) <> "Nothing" Then
txtDepart.Tag = SelData(0)
txtDepart = SelData(1)
Else
txtDepart.Tag = ""
txtDepart = ""
End If
Case "Name"
If TypeName(SelData) <> "Nothing" Then
txtName = SelData(1)
Else
txtName = ""
End If
End Select
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 TmpRs As Recordset
Call hisFormToCenter(Me, frmMain)
hisFormClear Me
txtHandler.Text = gtydSysConfig.HdCode
mskDate(0).Text = gfnGetTime("yyyy-mm-dd")
mskDate(1).Text = gfnGetTime("yyyy-mm-dd")
chkFetch.Value = 1
chkBack.Value = 0
Set ComnHlp1 = New frmInputHelp
Set ComnHlp1.CN = gDbObj.CN
'
End Sub
Private Sub Form_Unload(Cancel As Integer)
Set frmFetchQuery = 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 txtDepart_LostFocus()
If txtDepart = "" Then
txtDepart = ""
Exit Sub
End If
If txtDepart <> OldDepart Or txtDepart = "" Then
ComnHlp1.SQL = "SELECT m_Depart.DepCode,m_Depart.DepName FROM m_Depart" _
& " WHERE m_Depart.Brief LIKE '##%' AND m_Depart.flag & 4 = 0"
ComnHlp1.InitPut = txtDepart.Text
ComnHlp1.FormatHead = "科 别 编 码|科 别 名 称 "
ComnHlp1.WidthRate = 1
ComnHlp1.ParmTag = "Depart"
ComnHlp1.ShowHelp vbModal
End If
End Sub
Private Sub txtName_GotFocus()
OldName = txtName
End Sub
Private Sub txtName_LostFocus()
If txtName = "" Then
Exit Sub
End If
If txtName <> OldName Then
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 If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -