📄 frmtjrsfrm.frm
字号:
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00004080&
Height = 345
Index = 0
Left = 120
Style = 2 'Dropdown List
TabIndex = 33
Top = 480
Width = 2055
End
Begin VB.ComboBox cobCount
BeginProperty Font
Name = "宋体"
Size = 11.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00004080&
Height = 345
Index = 1
Left = 2715
Style = 2 'Dropdown List
TabIndex = 32
Top = 480
Width = 2055
End
Begin VB.ComboBox cobCount
BeginProperty Font
Name = "宋体"
Size = 11.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00004080&
Height = 345
Index = 2
Left = 5325
Style = 2 'Dropdown List
TabIndex = 31
Top = 480
Width = 2055
End
Begin VB.ComboBox cobCount
BeginProperty Font
Name = "宋体"
Size = 11.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00004080&
Height = 345
Index = 3
Left = 7920
Style = 2 'Dropdown List
TabIndex = 30
Top = 480
Width = 2055
End
Begin VB.Label Label12
Caption = "项目1"
Height = 255
Left = 120
TabIndex = 37
Top = 240
Width = 1455
End
Begin VB.Label Label11
Caption = "项目2"
Height = 255
Left = 2760
TabIndex = 36
Top = 240
Width = 1455
End
Begin VB.Label Label10
Caption = "项目3"
Height = 255
Left = 5280
TabIndex = 35
Top = 240
Width = 1455
End
Begin VB.Label Label9
Caption = "项目4"
Height = 255
Left = 7920
TabIndex = 34
Top = 240
Width = 1455
End
End
Begin VB.Frame frameGroup
Caption = "分组"
Height = 1335
Left = 120
TabIndex = 20
Top = 200
Width = 10215
Begin VB.CheckBox chkGroupCount
Caption = " 添加合计"
Height = 375
Index = 0
Left = 120
TabIndex = 60
Top = 915
Value = 1 'Checked
Width = 1335
End
Begin VB.CheckBox chkGroupCount
Caption = "添加合计"
Height = 375
Index = 1
Left = 2715
TabIndex = 59
Top = 915
Value = 1 'Checked
Width = 1335
End
Begin VB.CheckBox chkGroupCount
Caption = "添加合计"
Height = 375
Index = 2
Left = 5325
TabIndex = 58
Top = 915
Value = 1 'Checked
Width = 1335
End
Begin VB.CheckBox chkGroupCount
Caption = "添加合计"
Enabled = 0 'False
Height = 375
Index = 3
Left = 7920
TabIndex = 57
Top = 915
Width = 1335
End
Begin VB.ComboBox cobGroup
BeginProperty Font
Name = "宋体"
Size = 11.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00008000&
Height = 345
Index = 3
Left = 7920
Style = 2 'Dropdown List
TabIndex = 24
Top = 480
Width = 2055
End
Begin VB.ComboBox cobGroup
BeginProperty Font
Name = "宋体"
Size = 11.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00008000&
Height = 345
Index = 2
Left = 5325
Style = 2 'Dropdown List
TabIndex = 23
Top = 480
Width = 2055
End
Begin VB.ComboBox cobGroup
BeginProperty Font
Name = "宋体"
Size = 11.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00008000&
Height = 345
Index = 1
Left = 2715
Style = 2 'Dropdown List
TabIndex = 22
Top = 480
Width = 2055
End
Begin VB.ComboBox cobGroup
BeginProperty Font
Name = "宋体"
Size = 11.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00008000&
Height = 345
Index = 0
Left = 120
Style = 2 'Dropdown List
TabIndex = 21
Top = 480
Width = 2055
End
Begin VB.Label Label8
Caption = "第四分组项目"
Height = 255
Left = 7920
TabIndex = 28
Top = 240
Width = 1455
End
Begin VB.Label Label7
Caption = "第三分组项目"
Height = 255
Left = 5280
TabIndex = 27
Top = 240
Width = 1455
End
Begin VB.Label Label6
Caption = "第二分组项目"
Height = 255
Left = 2760
TabIndex = 26
Top = 240
Width = 1455
End
Begin VB.Label Label5
Caption = "第一分组项目"
Height = 255
Left = 120
TabIndex = 25
Top = 240
Width = 1455
End
End
Begin VB.CommandButton cmdExpTj
Caption = "导出统计结果->Excel"
Height = 375
Left = 6960
TabIndex = 10
Top = 7480
Width = 3375
End
End
Begin VB.Frame frameQuery
Height = 7935
Index = 3
Left = 120
TabIndex = 8
Top = 840
Width = 10455
Begin VB.CommandButton cmdExport
Caption = "导出查询结果->Excel"
Height = 375
Left = 7320
TabIndex = 12
Top = 7440
Width = 3015
End
Begin MSComctlLib.ListView lstXs
Height = 6855
Left = 120
TabIndex = 11
Top = 480
Width = 10215
_ExtentX = 18018
_ExtentY = 12091
View = 3
Arrange = 1
LabelEdit = 1
Sorted = -1 'True
MultiSelect = -1 'True
LabelWrap = -1 'True
HideSelection = 0 'False
AllowReorder = -1 'True
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 1
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 11.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
NumItems = 1
BeginProperty ColumnHeader(1) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Object.Width = 2540
EndProperty
End
Begin VB.Label labQueryR
Caption = "记录数：0"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H00FF8080&
Height = 375
Left = 240
TabIndex = 44
Top = 7440
Width = 5895
End
End
Begin MSComctlLib.TabStrip tabPage
Height = 375
Left = 120
TabIndex = 0
Top = 240
Width = 10455
_ExtentX = 18441
_ExtentY = 661
MultiRow = -1 'True
Style = 2
Separators = -1 'True
_Version = 393216
BeginProperty Tabs {1EFB6598-857C-11D1-B16A-00C0F0283628}
NumTabs = 4
BeginProperty Tab1 {1EFB659A-857C-11D1-B16A-00C0F0283628}
Caption = " 选 择 项 目 "
ImageVarType = 2
EndProperty
BeginProperty Tab2 {1EFB659A-857C-11D1-B16A-00C0F0283628}
Caption = " 定 制 条 件 "
ImageVarType = 2
EndProperty
BeginProperty Tab3 {1EFB659A-857C-11D1-B16A-00C0F0283628}
Caption = " 查 询 结 果 "
ImageVarType = 2
EndProperty
BeginProperty Tab4 {1EFB659A-857C-11D1-B16A-00C0F0283628}
Caption = " 统 计 结 果 "
ImageVarType = 2
EndProperty
EndProperty
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 11.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
End
Attribute VB_Name = "frmTjRs"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdAddExample_Click()
Screen.MousePointer = 11
Dim rsTmp As New ADODB.Recordset
cobTxt.Clear
sSql = "select distinct " & Trim(Left(cobField.Text, Len(cobField.Text) - 50)) & " from "
sSql = sSql & tmpTableName
sSql = sSql & " where " & Trim(Left(cobField.Text, Len(cobField.Text) - 50)) & " is not null"
sSql = sSql & " order by " & Trim(Left(cobField.Text, Len(cobField.Text) - 50))
rsTmp.Open sSql, adoCn
cobTxt.Clear
Do Until rsTmp.EOF()
cobTxt.AddItem Trim(rsTmp(0))
rsTmp.MoveNext
Loop
rsTmp.Close
Screen.MousePointer = vbDefault
End Sub
Private Sub cmdAddOrder_Click()
If Not txtTxtOrder.Text = "" Then txtTxtOrder.Text = txtTxtOrder.Text & " ,"
txtTxtOrder.Text = txtTxtOrder.Text & Trim(Left(cobField.Text, Len(cobField.Text) - 50))
If chkOrder.Value Then txtTxtOrder.Text = txtTxtOrder.Text & " Desc "
End Sub
Private Sub cmdAnd_Click()
Dim tmpTxt As String
Dim tmpTxtOf As String
tmpTxt = cobTxt.Text
If tmpTxt = "" Then
MsgBox ("请选择或输入要查找的内容")
Exit Sub
End If
If cobOperator.Text = "like" Then tmpTxt = "%" & tmpTxt & "%"
If Not txtTxt.Text = "" Then
txtTxt.Text = txtTxt.Text & " And "
End If
txtTxt.Text = txtTxt.Text & Trim(Left(cobField.Text, Len(cobField.Text) - 50))
txtTxt.Text = txtTxt.Text & " " & Trim(cobOperator.Text) & " "
Select Case Right(cobField.Text, 1)
Case "C"
tmpTxtOf = "'"
Case "N"
tmpTxtOf = ""
Case Else
tmpTxtOf = ""
End Select
txtTxt.Text = txtTxt.Text & tmpTxtOf & tmpTxt & tmpTxtOf
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -