📄 frmsuggestion.frm
字号:
VERSION 5.00
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "comdlg32.ocx"
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "mscomctl.ocx"
Object = "{0B81E4A9-BE4E-4AEF-9272-33AB5B51C6FC}#1.0#0"; "XPControls.ocx"
Begin VB.Form frmSuggestion
BackColor = &H80000018&
BorderStyle = 3 'Fixed Dialog
Caption = "体检建议维护"
ClientHeight = 7335
ClientLeft = 2760
ClientTop = 3750
ClientWidth = 9930
Icon = "frmSuggestion.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 7335
ScaleWidth = 9930
ShowInTaskbar = 0 'False
StartUpPosition = 2 'CenterScreen
Begin VB.Frame Frame2
BackColor = &H80000018&
Caption = "操作"
Height = 1185
Left = 3450
TabIndex = 14
Top = 6030
Width = 6375
Begin XPControls.XPCommandButton cmdAdd
Height = 375
Left = 960
TabIndex = 15
Top = 240
Width = 1005
_ExtentX = 1773
_ExtentY = 661
Caption = "添加(&A)"
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 cmdModify
Height = 375
Left = 2700
TabIndex = 16
Top = 240
Width = 1005
_ExtentX = 1773
_ExtentY = 661
Caption = "修改(&M)"
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 cmdSave
Height = 375
Left = 4470
TabIndex = 17
Top = 240
Width = 1005
_ExtentX = 1773
_ExtentY = 661
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 cmdDelete
Height = 375
Left = 960
TabIndex = 18
Top = 690
Width = 1005
_ExtentX = 1773
_ExtentY = 661
Caption = "删除(&D)"
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 = 375
Left = 4470
TabIndex = 19
Top = 690
Width = 1005
_ExtentX = 1773
_ExtentY = 661
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 cmdExort
Height = 375
Left = 2700
TabIndex = 20
Top = 690
Width = 1005
_ExtentX = 1773
_ExtentY = 661
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
Begin VB.Frame Frame1
BackColor = &H80000018&
Caption = "详细信息"
Height = 3255
Left = 3450
TabIndex = 4
Top = 2715
Width = 6375
Begin VB.Frame Frame3
BackColor = &H80000018&
Height = 525
Left = 180
TabIndex = 8
Top = 1020
Width = 6015
Begin VB.CheckBox chkSFCJB
BackColor = &H80000018&
Caption = "是否常见病"
Height = 315
Left = 3510
TabIndex = 10
Top = 150
Width = 1965
End
Begin VB.CheckBox chkSFJB
BackColor = &H80000018&
Caption = "是否疾病"
Height = 315
Left = 930
TabIndex = 9
Top = 150
Width = 1965
End
End
Begin VB.TextBox txtJYNR
Height = 1305
Left = 210
MultiLine = -1 'True
ScrollBars = 2 'Vertical
TabIndex = 7
Top = 1860
Width = 5955
End
Begin VB.TextBox txtJYMC
Height = 315
Left = 1110
TabIndex = 6
Top = 660
Width = 5055
End
Begin VB.TextBox txtZDJL
Height = 315
Left = 1110
TabIndex = 5
Top = 270
Width = 5055
End
Begin VB.Label Label3
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "建议内容"
Height = 195
Index = 1
Left = 210
TabIndex = 13
Top = 1560
Width = 720
End
Begin VB.Label Label3
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "建议名称"
Height = 195
Index = 0
Left = 210
TabIndex = 12
Top = 720
Width = 720
End
Begin VB.Label Label2
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "诊断结论"
Height = 195
Left = 210
TabIndex = 11
Top = 330
Width = 720
End
End
Begin VB.Frame Frame4
BackColor = &H80000018&
Caption = "体检科室"
Height = 7095
Left = 120
TabIndex = 2
Top = 120
Width = 3255
Begin MSComctlLib.TreeView tvwXMu
Height = 6795
Left = 60
TabIndex = 3
Top = 240
Width = 3105
_ExtentX = 5477
_ExtentY = 11986
_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
End
Begin VB.Frame Frame5
BackColor = &H80000018&
Caption = "本科室建议"
Height = 2505
Left = 3450
TabIndex = 0
Top = 120
Width = 6375
Begin MSComctlLib.ListView lvwXMu
Height = 2205
Left = 60
TabIndex = 1
Top = 210
Width = 6255
_ExtentX = 11033
_ExtentY = 3889
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = 0 'False
FullRowSelect = -1 'True
GridLines = -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 = 5
BeginProperty ColumnHeader(1) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Text = "诊断结论"
Object.Width = 1834
EndProperty
BeginProperty ColumnHeader(2) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 1
Text = "建议名称"
Object.Width = 1834
EndProperty
BeginProperty ColumnHeader(3) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 2
Text = "建议内容"
Object.Width = 6068
EndProperty
BeginProperty ColumnHeader(4) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 3
Text = "是否疾病"
Object.Width = 0
EndProperty
BeginProperty ColumnHeader(5) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 4
Text = "是否常见病"
Object.Width = 0
EndProperty
End
End
Begin MSComDlg.CommonDialog CommonDialog1
Left = 4770
Top = 3420
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
End
Attribute VB_Name = "frmSuggestion"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim mblnChange As Boolean
Dim menuOperation As OperationType
Dim m_strMenu As String
Public Sub ShowForm(ByVal strMenu As String)
m_strMenu = strMenu
Me.Show vbModal
End Sub
Private Sub cmdAdd_Click()
'权限验证
If g_blnIsNew Then
If Not g_clsAuthority.CheckOperationAuthority(m_strMenu, INSERT_W) Then GoTo ExitLab
End If
'验证完毕
ClearInput
cmdAdd.Enabled = False
cmdModify.Enabled = False
cmdSave.Enabled = True
EnableInput True
txtZDJL.SetFocus
menuOperation = Add
ExitLab:
End Sub
Private Sub cmdDelete_Click()
On Error GoTo ErrMsg
Dim Status
Dim strSQL As String
Dim itmXMu As ListItem
Dim cmd As ADODB.Command
Dim intIndex As Integer
Me.MousePointer = vbHourglass
'权限验证
If g_blnIsNew Then
If Not g_clsAuthority.CheckOperationAuthority(m_strMenu, DELETE_W) Then GoTo ExitLab
End If
'验证完毕
If lvwXMu.SelectedItem Is Nothing Then GoTo ExitLab
If MsgBox("确实要删除体检建议项“" & lvwXMu.SelectedItem.Text & "”吗？", _
vbQuestion + vbYesNo + vbDefaultButton2, "提示") = vbNo Then GoTo ExitLab
strSQL = "delete from DM_ZJJY" _
& " where JYDMID='" & Mid(lvwXMu.SelectedItem.Key, 2) & "'"
Set cmd = New ADODB.Command
Set cmd.ActiveConnection = GCon
cmd.CommandText = strSQL
cmd.Execute
intIndex = lvwXMu.SelectedItem.Index
lvwXMu.ListItems.Remove intIndex
If lvwXMu.ListItems.Count > 0 Then
If intIndex > 1 Then
Set lvwXMu.SelectedItem = lvwXMu.ListItems(intIndex - 1)
Else
Set lvwXMu.SelectedItem = lvwXMu.ListItems(intIndex)
End If
Else
txtZDJL.Text = ""
txtJYMC.Text = ""
txtJYNR.Text = ""
End If
lvwXMu_Click
GoTo ExitLab
ErrMsg:
Status = SetError(Err.Number, Err.Description, Err.Source)
ErrMsg Status
ExitLab:
Me.MousePointer = vbDefault
End Sub
Private Sub cmdExit_Click()
Unload Me
End Sub
Private Sub cmdExort_Click()
Call ExportSuggestion(Me.CommonDialog1, "ZDJL")
End Sub
Private Sub cmdModify_Click()
'权限验证
If g_blnIsNew Then
If Not g_clsAuthority.CheckOperationAuthority(m_strMenu, UPDATE_W) Then GoTo ExitLab
End If
'验证完毕
'是否有选择
If lvwXMu.SelectedItem Is Nothing Then Exit Sub
txtZDJL.Text = lvwXMu.SelectedItem.Text
txtJYMC.Text = lvwXMu.SelectedItem.SubItems(1)
txtJYNR.Text = lvwXMu.SelectedItem.SubItems(2)
If lvwXMu.SelectedItem.SubItems(3) = 0 Then
chkSFJB.Value = vbUnchecked
ElseIf lvwXMu.SelectedItem.SubItems(3) = 1 Then
chkSFJB.Value = vbChecked
End If
If lvwXMu.SelectedItem.SubItems(4) = 0 Then
chkSFCJB.Value = vbUnchecked
ElseIf lvwXMu.SelectedItem.SubItems(4) = 1 Then
chkSFCJB.Value = vbChecked
End If
cmdAdd.Enabled = False
cmdModify.Enabled = False
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -