📄 frmhcsz.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Begin VB.Form FrmHCSZ
BackColor = &H80000018&
BorderStyle = 1 'Fixed Single
Caption = "体检耗材设置"
ClientHeight = 7365
ClientLeft = 45
ClientTop = 330
ClientWidth = 9720
Icon = "FrmHCSZ.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 7365
ScaleWidth = 9720
StartUpPosition = 2 '屏幕中心
Begin VB.Frame Frame4
BackColor = &H80000018&
Caption = "可选耗材"
Height = 5235
Index = 1
Left = 7140
TabIndex = 18
Top = 360
Width = 2415
Begin MSComctlLib.ListView lvwAllTJHC
DragIcon = "FrmHCSZ.frx":1982
Height = 4890
Left = 90
TabIndex = 19
Top = 210
Width = 2205
_ExtentX = 3889
_ExtentY = 8625
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = 0 'False
FullRowSelect = -1 'True
GridLines = -1 'True
HotTracking = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = 12648384
BorderStyle = 1
Appearance = 1
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
NumItems = 1
BeginProperty ColumnHeader(1) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Text = "耗材名称"
Object.Width = 3528
EndProperty
End
End
Begin VB.Frame Frame4
BackColor = &H80000018&
Caption = "已选耗材"
Height = 5235
Index = 0
Left = 4560
TabIndex = 16
Top = 360
Width = 2415
Begin MSComctlLib.ListView lvwTJHC
DragIcon = "FrmHCSZ.frx":1AD4
Height = 4920
Left = 90
TabIndex = 17
Top = 210
Width = 2205
_ExtentX = 3889
_ExtentY = 8678
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = 0 'False
FullRowSelect = -1 'True
GridLines = -1 'True
HotTracking = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = 12648384
BorderStyle = 1
Appearance = 1
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
NumItems = 1
BeginProperty ColumnHeader(1) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Text = "耗材名称"
Object.Width = 3528
EndProperty
End
End
Begin VB.Frame Frame1
BackColor = &H80000018&
Caption = "耗材信息"
Height = 1515
Left = 4590
TabIndex = 0
Top = 5730
Width = 5010
Begin VB.TextBox txtHCYL
BackColor = &H00C0FFC0&
Height = 300
Left = 795
Locked = -1 'True
TabIndex = 13
Top = 540
Width = 990
End
Begin VB.Frame Frame3
BackColor = &H80000018&
Caption = "使用性别"
Enabled = 0 'False
Height = 510
Left = 120
TabIndex = 9
Top = 930
Width = 2400
Begin VB.OptionButton OptTY
BackColor = &H80000018&
Caption = "通用"
Height = 225
Left = 120
TabIndex = 12
Top = 225
Width = 780
End
Begin VB.OptionButton OptFemale
BackColor = &H80000018&
Caption = "女"
Height = 285
Left = 1725
TabIndex = 11
Top = 195
Width = 630
End
Begin VB.OptionButton OptMale
BackColor = &H80000018&
Caption = "男"
Height = 285
Left = 990
TabIndex = 10
Top = 195
Width = 585
End
End
Begin VB.TextBox TxtHCJG
BackColor = &H00C0FFC0&
Enabled = 0 'False
Height = 300
Left = 3285
Locked = -1 'True
TabIndex = 7
Top = 1035
Visible = 0 'False
Width = 1590
End
Begin VB.TextBox txtHCSM
BackColor = &H00C0FFC0&
Height = 300
Left = 2520
Locked = -1 'True
TabIndex = 5
Top = 555
Width = 2355
End
Begin VB.TextBox txtHCID
BackColor = &H00C0FFC0&
Height = 300
Left = 810
Locked = -1 'True
TabIndex = 3
Top = 195
Width = 990
End
Begin VB.TextBox txtHCMC
BackColor = &H00C0FFC0&
Height = 300
Left = 2520
Locked = -1 'True
TabIndex = 1
Top = 210
Width = 2355
End
Begin VB.Label Label5
BackStyle = 0 'Transparent
Caption = "用量"
Height = 285
Left = 195
TabIndex = 14
Top = 615
Width = 495
End
Begin VB.Label Label4
BackStyle = 0 'Transparent
Caption = "价格"
Height = 285
Left = 2685
TabIndex = 8
Top = 1110
Visible = 0 'False
Width = 495
End
Begin VB.Label Label3
BackStyle = 0 'Transparent
Caption = "说明"
Height = 285
Left = 1935
TabIndex = 6
Top = 645
Width = 495
End
Begin VB.Label Label2
BackStyle = 0 'Transparent
Caption = "ID号"
Height = 285
Left = 210
TabIndex = 4
Top = 255
Width = 495
End
Begin VB.Label Label1
BackStyle = 0 'Transparent
Caption = "名称"
Height = 285
Left = 1935
TabIndex = 2
Top = 255
Width = 495
End
End
Begin MSComctlLib.TreeView tvwXMu
Height = 7140
Left = 120
TabIndex = 15
Top = 120
Width = 4305
_ExtentX = 7594
_ExtentY = 12594
_Version = 393217
HideSelection = 0 'False
LabelEdit = 1
Style = 7
Appearance = 1
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin VB.Label Label6
BackStyle = 0 'Transparent
Caption = "用鼠标可在下面两个列表内拖动耗材。"
Height = 225
Left = 4560
TabIndex = 20
Top = 90
Width = 4545
End
End
Attribute VB_Name = "FrmHCSZ"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub cmdExit_Click()
Unload Me
End Sub
Private Sub Form_Load()
On Error GoTo ErrMsg
Dim Status
Dim strSQL As String
Dim nodTemp As Node
Dim rsKShi As ADODB.Recordset
Dim rsDX As ADODB.Recordset
Dim rsXX As ADODB.Recordset
Screen.MousePointer = vbArrowHourglass
Me.Top = 1300
Me.Left = 500
'添加一个根节点
'关键字长度：1＝1
Set nodTemp = tvwXMu.Nodes.Add(, , "W", "项目设置")
nodTemp.Expanded = True
'显示所有科室
strSQL = "select KSID,KSMC from SET_KSSZ"
'按顺序号排序
strSQL = strSQL & " order by SXH"
Set rsKShi = New ADODB.Recordset
rsKShi.Open strSQL, GCon, adOpenStatic, adLockOptimistic
If rsKShi.RecordCount > 0 Then
rsKShi.MoveFirst
Do
'添加科室
'关键字长度：1＋2＝3
Set nodTemp = tvwXMu.Nodes.Add("W", tvwChild, "W" & rsKShi("KSID"), rsKShi("KSMC"))
' nodTemp.Expanded = True
strSQL = "select DXID,DXMC,DXSFYZX from SET_DX" _
& " where left(DXID,2)='" & rsKShi("KSID") & "'"
'按顺序号排序
strSQL = strSQL & " order by SXH"
Set rsDX = New ADODB.Recordset
rsDX.Open strSQL, GCon, adOpenStatic, adLockOptimistic
If rsDX.RecordCount > 0 Then
rsDX.MoveFirst
Do
'添加大项
'关键字长度：1＋4＝5
Set nodTemp = tvwXMu.Nodes.Add("W" & rsKShi("KSID"), tvwChild, "W" & rsDX("DXID"), rsDX("DXMC"))
' nodTemp.Expanded = True
If rsDX("DXSFYZX") = 1 Then '有子项
strSQL = "select XXID,XXMC from SET_XX" _
& " where XXID in (" _
& "select XXID from SET_ZH_Data" _
& " where DXID='" & rsDX("DXID") & "'" _
& ")"
'按顺序号排序
strSQL = strSQL & " order by SXH"
Set rsXX = New ADODB.Recordset
rsXX.Open strSQL, GCon, adOpenKeyset, adLockOptimistic
If rsXX.RecordCount > 0 Then
rsXX.MoveFirst
Do
'关键字长度：1＋4＋7＝12
tvwXMu.Nodes.Add "W" & rsDX("DXID"), tvwChild, "W" & rsDX("DXID") & rsXX("XXID"), rsXX("XXMC")
' nodTemp.Expanded = True
rsXX.MoveNext
Loop Until rsXX.EOF
rsXX.Close
End If
End If
rsDX.MoveNext
Loop Until rsDX.EOF
rsDX.Close
End If
rsKShi.MoveNext
Loop Until rsKShi.EOF
rsKShi.Close
End If
GoTo ExitLab
ErrMsg:
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -