📄 formtjbzwh.frm
字号:
Begin VB.OptionButton optMale
BackColor = &H00D3DABC&
Caption = "男"
Height = 255
Left = 2190
TabIndex = 22
Top = 210
Width = 885
End
Begin VB.OptionButton optNNTY
BackColor = &H00D3DABC&
Caption = "所有"
Height = 255
Left = 660
TabIndex = 21
Top = 210
Value = -1 'True
Width = 885
End
End
Begin VB.Frame fraBZMX
BackColor = &H00D3DABC&
Caption = "标准明细"
Height = 2415
Left = 120
TabIndex = 5
Top = 885
Width = 5175
Begin VB.TextBox txtCKXX
Height = 300
Left = 1110
TabIndex = 43
Top = 735
Visible = 0 'False
Width = 765
End
Begin VB.TextBox txtCKSX
Height = 300
Left = 2850
TabIndex = 42
Top = 735
Visible = 0 'False
Width = 765
End
Begin VB.TextBox txtLowInfo
Height = 300
Left = 1110
TabIndex = 41
Top = 1155
Visible = 0 'False
Width = 3855
End
Begin VB.TextBox txtHighInfo
Height = 300
Left = 1110
TabIndex = 40
Top = 1590
Visible = 0 'False
Width = 3885
End
Begin VB.TextBox txtMinVal
Height = 300
Left = 1110
TabIndex = 39
Top = 2025
Visible = 0 'False
Width = 1515
End
Begin VB.TextBox txtMaxVal
Height = 300
Left = 3480
TabIndex = 38
Top = 2025
Visible = 0 'False
Width = 1515
End
Begin VB.TextBox txtNormalVal
Height = 300
Left = 1140
TabIndex = 6
Top = 307
Width = 3855
End
Begin VB.Label Label21
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "参考下限："
Height = 195
Left = 150
TabIndex = 49
Top = 780
Visible = 0 'False
Width = 900
End
Begin VB.Label Label22
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "参考上限："
Height = 195
Left = 1950
TabIndex = 48
Top = 780
Visible = 0 'False
Width = 900
End
Begin VB.Label Label23
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "偏低提示："
Height = 195
Left = 150
TabIndex = 47
Top = 1215
Visible = 0 'False
Width = 900
End
Begin VB.Label Label24
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "偏高提示："
Height = 195
Left = 150
TabIndex = 46
Top = 1635
Visible = 0 'False
Width = 900
End
Begin VB.Label Label25
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "最小值："
Height = 195
Left = 150
TabIndex = 45
Top = 2070
Visible = 0 'False
Width = 720
End
Begin VB.Label Label26
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "最大值："
Height = 195
Left = 2730
TabIndex = 44
Top = 2070
Visible = 0 'False
Width = 720
End
Begin VB.Label Label8
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "正常结果："
Height = 195
Left = 180
TabIndex = 7
Top = 360
Width = 900
End
End
Begin VB.Frame Frame3
BackColor = &H00D3DABC&
Caption = "操作"
Height = 735
Left = 120
TabIndex = 1
Top = 3360
Width = 5175
Begin XPControls.XPCommandButton cmdSaveInfo
Height = 345
Left = 660
TabIndex = 2
Top = 270
Width = 945
_ExtentX = 1667
_ExtentY = 609
Caption = "保 存(&S)"
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 XPControls.XPCommandButton cmdExit
Cancel = -1 'True
Height = 345
Left = 3570
TabIndex = 3
Top = 270
Width = 945
_ExtentX = 1667
_ExtentY = 609
Caption = "退出(&X)"
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 XPControls.XPCommandButton cmdExport
Height = 345
Left = 2190
TabIndex = 4
Top = 270
Width = 945
_ExtentX = 1667
_ExtentY = 609
Caption = "导 出(&E)"
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
End
End
Begin MSComctlLib.TreeView tvwXMu
Height = 6645
Left = 180
TabIndex = 18
Top = 420
Width = 3555
_ExtentX = 6271
_ExtentY = 11721
_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 Label1
BackColor = &H80000018&
BackStyle = 0 'Transparent
Caption = "所有项目："
Height = 285
Left = 180
TabIndex = 19
Top = 120
Width = 1095
End
End
Attribute VB_Name = "FormTJBZWH"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim mintBZID As Integer '修改时的标准ID
Dim mintIndex As Integer '修改时的索引号
Private Sub cmbBZMC_Click()
On Error GoTo ErrMsg
Dim Status
Dim strSQL As String
Dim rsBZ As ADODB.Recordset
Me.MousePointer = vbHourglass
cmdSave.Enabled = False
If cmbBZMC.ListCount < 0 Then
cmdAdd.Enabled = True
cmdChange.Enabled = False
cmdDel.Enabled = False
GoTo ExitLab
Else
If cmbBZMC.ListCount = 1 Then
'只有一条标准时禁用删除
cmdDel.Enabled = False
Else
'超过一条时可以删除
cmdDel.Enabled = True
End If
cmdAdd.Enabled = False '存在标准时禁用添加
cmdChange.Enabled = True
End If
If cmbBZMC.ListIndex < 0 Then
txtBZSM.Text = ""
fraInfo.Enabled = False
GoTo ExitLab
End If
'获取当前选中标准的说明
strSQL = "select BZSM from SET_TJBZIndex" _
& " where BZID=" & Val(cmbBZMC.ItemData(cmbBZMC.ListIndex))
Set rsBZ = New ADODB.Recordset
rsBZ.Open strSQL, GCon, adOpenKeyset, adLockOptimistic
If rsBZ.RecordCount > 0 Then
txtBZSM.Text = rsBZ("BZSM")
rsBZ.Close
End If
tvwXMuClick
GoTo ExitLab
ErrMsg:
Status = SetError(Err.Number, Err.Description, Err.Source)
ErrMsg Status
ExitLab:
Me.MousePointer = vbDefault
End Sub
Private Sub cmbBZMC_KeyPress(KeyAscii As Integer)
EnterToTab KeyAscii
If (cmdAdd.Enabled = True) And (cmdChange.Enabled = True) Then
KeyAscii = 0
End If
End Sub
Private Sub cmdAdd_Click()
'***********************************************************
'版本控制
'***********************************************************
Select Case genuVersion
Case WLB
'
Case ZYB
Case BZB
If cmbBZMC.ListCount >= 2 Then
MsgBox "您使用的是标准版，只能设置两套体检标准！", vbInformation, "提示"
Exit Sub
End If
Case PJB
If cmbBZMC.ListCount >= 1 Then
MsgBox "您使用的是普及版，只能设置一套体检标准！", vbInformation, "提示"
Exit Sub
End If
End Select
'***********************************************************
'***********************************************************
cmbBZMC.Text = ""
txtBZSM.Text = ""
mintBZID = -1
cmdChange.Enabled = False
cmdAdd.Enabled = False
cmdSave.Enabled = True
tvwXMuClick
End Sub
Private Sub CmdChange_Click()
mintIndex = cmbBZMC.ListIndex
mintBZID = cmbBZMC.ItemData(mintIndex)
cmdAdd.Enabled = False
cmdChange.Enabled = False
cmdSave.Enabled = True
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -