📄 frmindex.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Begin VB.Form frmindex
BorderStyle = 3 'Fixed Dialog
Caption = "排序"
ClientHeight = 3750
ClientLeft = 45
ClientTop = 330
ClientWidth = 4020
Icon = "frmindex.frx":0000
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 3750
ScaleWidth = 4020
ShowInTaskbar = 0 'False
StartUpPosition = 3 '窗口缺省
WhatsThisButton = -1 'True
WhatsThisHelp = -1 'True
Begin MSComctlLib.ImageCombo Combo3
Height = 315
Left = 360
TabIndex = 16
Top = 2520
Width = 1815
_ExtentX = 3201
_ExtentY = 556
_Version = 393216
ForeColor = -2147483640
BackColor = 12640511
End
Begin MSComctlLib.ImageCombo Combo2
Height = 315
Left = 360
TabIndex = 15
Top = 1560
Width = 1815
_ExtentX = 3201
_ExtentY = 556
_Version = 393216
ForeColor = -2147483640
BackColor = 12640511
End
Begin MSComctlLib.ImageCombo Combo1
Height = 315
Left = 360
TabIndex = 14
Top = 600
Width = 1815
_ExtentX = 3201
_ExtentY = 556
_Version = 393216
ForeColor = -2147483640
BackColor = 12640511
End
Begin VB.Frame Frame3
Height = 615
Left = 2640
TabIndex = 11
Top = 2400
Width = 1335
Begin VB.OptionButton asc3
Caption = "递增"
Height = 180
Left = 360
TabIndex = 13
Top = 120
Value = -1 'True
Width = 735
End
Begin VB.OptionButton desc3
Caption = "递减"
Height = 180
Left = 360
TabIndex = 12
Top = 405
Width = 735
End
End
Begin VB.Frame Frame2
Height = 735
Left = 2640
TabIndex = 8
Top = 1440
Width = 1335
Begin VB.OptionButton asc2
Caption = "递增"
ForeColor = &H00404040&
Height = 255
Left = 360
MaskColor = &H008080FF&
TabIndex = 10
Top = 240
Value = -1 'True
Width = 735
End
Begin VB.OptionButton desc2
Caption = "递减"
ForeColor = &H00404040&
Height = 180
Left = 360
MaskColor = &H008080FF&
TabIndex = 9
Top = 480
Width = 735
End
End
Begin VB.CommandButton comcancel
Caption = "取消"
Height = 375
Left = 2160
TabIndex = 4
Top = 3240
Width = 1095
End
Begin VB.CommandButton comok
Caption = "确定"
Height = 375
Left = 600
TabIndex = 3
Top = 3240
Width = 1095
End
Begin VB.Frame Frame1
Height = 735
Left = 2640
TabIndex = 5
Top = 480
Width = 1335
Begin VB.OptionButton asc1
Caption = "递增"
Height = 180
Left = 360
TabIndex = 7
Top = 195
Value = -1 'True
Width = 735
End
Begin VB.OptionButton desc1
Caption = "递减"
Height = 180
Left = 360
TabIndex = 6
Top = 480
Width = 855
End
End
Begin VB.Line Line1
BorderColor = &H80000001&
BorderWidth = 2
X1 = 1200
X2 = 3960
Y1 = 360
Y2 = 360
End
Begin VB.Label Label1
Caption = "主关键字"
Height = 255
Left = 360
TabIndex = 0
Top = 240
Width = 855
End
Begin VB.Line Line4
BorderColor = &H80000001&
BorderWidth = 2
X1 = 240
X2 = 4200
Y1 = 3120
Y2 = 3120
End
Begin VB.Line Line3
BorderColor = &H80000001&
BorderWidth = 2
X1 = 1320
X2 = 3975
Y1 = 2280
Y2 = 2295
End
Begin VB.Label Label3
Caption = "第三关键字"
Height = 255
Left = 360
TabIndex = 2
Top = 2160
Width = 975
End
Begin VB.Line Line2
BorderColor = &H80000001&
BorderWidth = 2
X1 = 1200
X2 = 3975
Y1 = 1320
Y2 = 1335
End
Begin VB.Label Label2
Caption = "次关键字"
Height = 255
Left = 360
TabIndex = 1
Top = 1260
Width = 855
End
End
Attribute VB_Name = "frmindex"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private strsum1, strsum2, strsum3, str1, str2, str3 As String
Private Sub comcancel_Click()
Unload Me
End Sub
Private Sub comok_Click()
If Trim(Combo1.Text) = "" Then
str1 = ""
MsgBox "主关键字不能为空！"
Exit Sub
Else
str1 = Trim(Mid(Combo1.SelectedItem.Key, 2, 100))
End If
If Trim(Combo2.Text) = "" Then
str2 = ""
Else
str2 = Trim(Mid(Combo2.SelectedItem.Key, 2, 100))
End If
If Trim(Combo3.Text) = "" Then
str3 = ""
Else
str3 = Trim(Mid(Combo3.SelectedItem.Key, 2, 100))
End If
If (str1 = "" And str2 = "") Or (str1 = "" And str3 = "") Or (str2 = "" And str3 = "") Or (str1 = "" And str2 = "" And str3 = "") Then
Else
If str1 = str2 Or str1 = str3 Or str2 = str3 Then
MsgBox "关键字不能相同！"
Exit Sub
End If
End If
strsum = IIf(str1 = "", "", str1)
strsum = strsum & IIf(str1 = "", "", IIf(Me.asc1.Value = True, " Asc ", " Desc "))
strsum = strsum & IIf(str2 = "", "", "," & str2)
strsum = strsum & IIf(str2 = "", "", IIf(Me.asc2.Value = True, " Asc ", " Desc "))
strsum = strsum & IIf(str3 = "", "", "," & str3)
strsum = strsum & IIf(str3 = "", "", IIf(Me.asc3.Value = True, " Asc ", " Desc "))
If strsum = "" Then
strsum = ""
Else
strsum = " order by " & strsum
End If
Unload Me
End Sub
Private Sub Form_Load()
Me.Top = 1875
Me.Left = 4000
Me.Combo1.ComboItems.Add , "_" & "id", "材料代号"
Me.Combo1.ComboItems.Add , "_" & "helpcode", "助记码"
Me.Combo1.ComboItems.Add , "_" & "name", "材料名称"
Me.Combo1.ComboItems.Add , "_" & "color", "颜色"
Me.Combo1.ComboItems.Add , "_" & "unit", "单位"
Me.Combo1.ComboItems.Add , "_" & "stuffclass", "货品类别"
Me.Combo1.ComboItems.Add , "_" & "libclass", "库存类别"
Me.Combo1.ComboItems.Add , "_" & "supply", "厂商"
Me.Combo2.ComboItems.Add , "_" & "id", "材料代号"
Me.Combo2.ComboItems.Add , "_" & "helpcode", "助记码"
Me.Combo2.ComboItems.Add , "_" & "name", "材料名称"
Me.Combo2.ComboItems.Add , "_" & "color", "颜色"
Me.Combo2.ComboItems.Add , "_" & "unit", "单位"
Me.Combo2.ComboItems.Add , "_" & "stuffclass", "货品类别"
Me.Combo2.ComboItems.Add , "_" & "libclass", "库存类别"
Me.Combo2.ComboItems.Add , "_" & "supply", "厂商"
Me.Combo3.ComboItems.Add , "_" & "id", "材料代号"
Me.Combo3.ComboItems.Add , "_" & "helpcode", "助记码"
Me.Combo3.ComboItems.Add , "_" & "name", "材料名称"
Me.Combo3.ComboItems.Add , "_" & "color", "颜色"
Me.Combo3.ComboItems.Add , "_" & "unit", "单位"
Me.Combo3.ComboItems.Add , "_" & "stuffclass", "货品类别"
Me.Combo3.ComboItems.Add , "_" & "libclass", "库存类别"
Me.Combo3.ComboItems.Add , "_" & "supply", "厂商"
Me.asc1.Value = True
Me.asc2.Value = True
Me.asc3.Value = True
Me.desc1.Value = False
Me.desc2.Value = False
Me.desc3.Value = False
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -