📄 frmtable.frm
字号:
Width = 415
End
Begin VB.CommandButton cmdArrow
Caption = ">>"
Enabled = 0 'False
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 336
Index = 1
Left = 4320
TabIndex = 17
Top = 1635
UseMaskColor = -1 'True
Width = 415
End
Begin VB.CommandButton cmdArrow
Caption = "<"
Enabled = 0 'False
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 336
Index = 2
Left = 4320
TabIndex = 18
Top = 2040
UseMaskColor = -1 'True
Width = 415
End
Begin VB.CommandButton cmdArrow
Caption = "<<"
Enabled = 0 'False
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 336
Index = 3
Left = 4320
TabIndex = 19
Top = 2460
UseMaskColor = -1 'True
Width = 415
End
Begin VB.CommandButton cmdUpDown
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 336
Index = 1
Left = 6900
Style = 1 'Graphical
TabIndex = 21
Top = 2100
UseMaskColor = -1 'True
Width = 240
End
Begin VB.CommandButton cmdUpDown
BeginProperty Font
Name = "MS Sans Serif"
Size = 9.75
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 336
Index = 0
Left = 6900
Style = 1 'Graphical
TabIndex = 20
Top = 1620
UseMaskColor = -1 'True
Width = 240
End
Begin VB.TextBox txtName
Height = 300
Left = -72720
TabIndex = 7
Text = "未命名"
Top = 1140
Width = 4480
End
Begin VB.Frame Frame5
Caption = "说明"
Height = 1365
Left = -72720
TabIndex = 8
Top = 2430
Width = 4480
Begin MSForms.Label Label3
Height = 360
Left = 450
TabIndex = 9
Top = 360
Width = 3135
VariousPropertyBits= 276824091
Caption = "请按向导步骤选择查询项目和方式!"
Size = "5530;635"
FontName = "宋体"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
End
End
Begin VB.Label LblList
Caption = "列名(&L)"
Height = 255
Left = 4080
TabIndex = 22
Top = 3360
Width = 675
End
Begin ComctlLib.ImageList ImageList1
Left = 5220
Top = -120
_ExtentX = 1005
_ExtentY = 1005
BackColor = -2147483643
ImageWidth = 13
ImageHeight = 13
MaskColor = 12632256
_Version = 327682
BeginProperty Images {0713E8C2-850A-101B-AFC0-4210102A8DA7}
NumListImages = 3
BeginProperty ListImage1 {0713E8C3-850A-101B-AFC0-4210102A8DA7}
Picture = "frmTable.frx":01E3
Key = "open"
EndProperty
BeginProperty ListImage2 {0713E8C3-850A-101B-AFC0-4210102A8DA7}
Picture = "frmTable.frx":02DD
Key = "closed"
EndProperty
BeginProperty ListImage3 {0713E8C3-850A-101B-AFC0-4210102A8DA7}
Picture = "frmTable.frx":03D7
Key = "book"
EndProperty
EndProperty
End
Begin VB.Label LblReport
Caption = "报表项目"
Height = 225
Index = 0
Left = 4860
TabIndex = 13
Top = 600
Width = 1575
End
Begin VB.Label LblData
Caption = "数据项目"
Height = 225
Left = 2340
TabIndex = 11
Top = 600
Width = 1035
End
Begin VB.Label LblName
Alignment = 2 'Center
Appearance = 0 'Flat
AutoSize = -1 'True
Caption = "报表名称(&R)"
ForeColor = &H00000000&
Height = 180
Left = -72720
TabIndex = 6
Top = 780
Width = 1005
End
End
Begin VB.Line linSep
BorderColor = &H00FFFFFF&
Index = 1
X1 = 0
X2 = 8032.128
Y1 = 4509.494
Y2 = 4509.494
End
Begin VB.Line linSep
BorderColor = &H00808080&
Index = 0
X1 = 0
X2 = 8032.128
Y1 = 4509.494
Y2 = 4509.494
End
End
Attribute VB_Name = "frmTable"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
' 列表向导窗体
' 作者：邓强
' 日期：1998.06.26
'
' 引导用户选择列表项目
' SetTable 初始化向导(设置钩子), 返回是否选中"完成"按钮(TableSet类模块调用)
'
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Option Explicit
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
' 查询条件变量
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Private WithEvents mclsHook As Hook
Attribute mclsHook.VB_VarHelpID = -1
Private mclsFilter As FormCond '查询条件类
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
' 向导变量
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Private mclsTable As TableSet '列表类
Private mblnMeOK As Boolean '是否选中"完成"按钮
Private mblnIsInited(2) As Boolean 'Tab是否已初始化
Private Sub cmdArrow_Click(Index As Integer) '查询项目
Dim intCount As Integer
Dim intLoc As Integer
Dim strSel As String
Select Case Index
Case 0
SendField LstDataField, LstReport, False
CmdEnabled LstDataField, cmdArrow(0), cmdArrow(1)
CmdEnabled LstReport, cmdArrow(2), cmdArrow(3)
Case 1
SendField LstDataField, LstReport, True
CmdEnabled LstDataField, cmdArrow(0), cmdArrow(1)
CmdEnabled LstReport, cmdArrow(2), cmdArrow(3)
Case 2
SendField LstReport, LstDataField, False
CmdEnabled LstDataField, cmdArrow(0), cmdArrow(1)
CmdEnabled LstReport, cmdArrow(2), cmdArrow(3)
If LstReport.ListCount = 0 Then
txtList.Text = ""
txtList.Enabled = False
LblList.Enabled = False
End If
Case 3
SendField LstReport, LstDataField, True
CmdEnabled LstDataField, cmdArrow(0), cmdArrow(1)
CmdEnabled LstReport, cmdArrow(2), cmdArrow(3)
txtList.Text = ""
txtList.Enabled = False
LblList.Enabled = False
End Select
If LstDataField.SelCount = 1 Then
strSel = GetNoXString(LstDataField.list(LstDataField.ListIndex), 8, "\")
If strSel = "4" Or strSel = "6" Then
cmdBrowse.Enabled = False
Else
cmdBrowse.Enabled = True
End If
Else
cmdBrowse.Enabled = False
End If
LstClick LstReport, cmdUpDown(0), cmdUpDown(1)
IsComplete
End Sub
Private Sub CmdBrowse_Click()
LstBrowse LstDataField
End Sub
Private Sub CmdCancel_Click()
mblnMeOK = False
Unload Me
End Sub
Private Sub cmdComplete_Click()
Dim blnIsSave As Boolean
mblnMeOK = True
If Not mblnIsInited(2) Then InitTableWizard 2
GetTableWizard
Unload Me
End Sub
Private Sub cmdHeadTail_Click()
Dim frmHeadTail As New frmCustomerField
frmHeadTail.SetHeadTail mclsTable
Set frmHeadTail = Nothing
End Sub
Private Sub cmdNext_Click()
sstTable.Tab = sstTable.Tab + 1
End Sub
Private Sub cmdPrevious_Click()
sstTable.Tab = sstTable.Tab - 1
End Sub
Private Sub cmdUpDown_Click(Index As Integer)
StandardReport.FieldUpdown LstReport, Index
picWizard.SetFocus
End Sub
Private Sub Form_Load()
SetHelpID Me.hwnd, 70017
Set Me.Icon = Utility.GetFormResPicture(139, vbResIcon)
End Sub
Private Sub Form_Unload(Cancel As Integer)
Set mclsTable = Nothing
Set mclsFilter = Nothing
Set mclsHook = Nothing
Set Me.Icon = Nothing
UnloadResPic
End Sub
Private Sub LstDataField_Click()
Dim strSel As String
If LstDataField.SelCount = 1 Then
strSel = GetNoXString(LstDataField.list(LstDataField.ListIndex), 8, "\")
If strSel = "4" Or strSel = "6" Then
cmdBrowse.Enabled = False
Else
cmdBrowse.Enabled = True
End If
Else
cmdBrowse.Enabled = False
End If
CmdEnabled LstDataField, cmdArrow(0), cmdArrow(1)
If LstDataField.ListIndex <> -1 Then LstDataField.ToolTipText = GetNoXString(LstDataField.list(LstDataField.ListIndex), 1, Space(100))
End Sub
Private Sub LstDataField_DblClick()
If LstDataField.SelCount <> 1 Then Exit Sub
cmdArrow_Click 0
End Sub
Private Sub LstDataField_KeyPress(KeyAscii As Integer)
If KeyAscii <> vbKeySpace Then Exit Sub
If LstDataField.SelCount <> 1 Then Exit Sub
cmdArrow_Click 0
End Sub
Private Sub LstReport_Click()
Dim intLoc As Integer
Dim strSel As String
If LstReport.ListIndex <> -1 Then LstReport.ToolTipText = GetNoXString(LstReport.list(LstReport.ListIndex), 1, Space(100))
If LstReport.SelCount <> 1 Then
txtList.Text = ""
txtList.Enabled = False
LblList.Enabled = False
Else
strSel = LstReport.list(LstReport.ListIndex)
txtList.Text = StringOut(strSel, Space(100))
If GetNoXString(strSel, 8, "\") = 5 Then
txtList.Enabled = False
LblList.Enabled = False
Else
txtList.Enabled = True
LblList.Enabled = True
End If
End If
CmdEnabled LstReport, cmdArrow(2), cmdArrow(3)
LstClick LstReport, cmdUpDown(0), cmdUpDown(1)
End Sub
Private Sub LstReport_DblClick()
cmdArrow_Click 2
End Sub
Private Sub LstReport_KeyPress(KeyAscii As Integer)
If KeyAscii <> vbKeySpace Then Exit Sub
cmdArrow_Click 2
End Sub
Private Sub sstTable_Click(PreviousTab As Integer)
Dim intCount As Integer
intCount = sstTable.Tab
InitTableWizard intCount
Select Case intCount
Case 0, 1
picWizard.ZOrder 0
CmdReset.Visible = False
Case 2
picWizard.ZOrder 1
CmdReset.Visible = True
End Select
CmdISEnabled sstTable.Tab
End Sub
Private Sub txtList_Change()
Dim strSel As String
Dim strTail As String
Dim blnIsSame As Boolean
If LstReport.ListIndex = -1 Or Trim(txtList.Text) = "" Then Exit Sub
If mblnIsInited(1) Then
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -