?? frmcheckcompany.frm
字號:
VERSION 5.00
Begin VB.Form frmCheckCompany
BorderStyle = 1 'Fixed Single
Caption = "查詢企業(yè)"
ClientHeight = 4620
ClientLeft = 45
ClientTop = 330
ClientWidth = 6705
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 4620
ScaleWidth = 6705
StartUpPosition = 2 '屏幕中心
Begin VB.CommandButton cmdCancel
Caption = "取 消"
Height = 495
Left = 3840
TabIndex = 5
Top = 3240
Width = 1575
End
Begin VB.CommandButton cmdOK
Caption = "查 找"
Height = 495
Left = 1320
TabIndex = 4
Top = 3240
Width = 1575
End
Begin VB.TextBox textDomain
Height = 375
Left = 2880
TabIndex = 3
Top = 2160
Width = 2535
End
Begin VB.TextBox textComName
Height = 375
Left = 2880
TabIndex = 2
Top = 1080
Width = 2535
End
Begin VB.CheckBox checkDomain
Caption = "經營領域"
Height = 495
Left = 1440
TabIndex = 1
Top = 2040
Width = 1335
End
Begin VB.CheckBox checkComName
Caption = "企業(yè)名稱"
Height = 615
Left = 1440
TabIndex = 0
Top = 960
Width = 1215
End
End
Attribute VB_Name = "frmCheckCompany"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Sub cmdCancel_Click()
Unload Me
Exit Sub
End Sub
Private Sub cmdOK_Click()
Dim sql As String
If Me.checkComName.Value = vbChecked And Me.checkDomain.Value = vbChecked Then
sql = "select * from Company where ComName='" & Me.textComName & "' and "
sql = sql & "DealDomain='" & Me.textDomain & "'"
ElseIf Me.checkComName.Value = vbChecked Then
sql = "select * from Company where ComName='" & Me.textComName & "'"
ElseIf Me.checkDomain.Value = vbChecked Then
sql = "select * from Company where DealDomain like '%" & Me.textDomain & "%'"
Else
sql = "select * from Company order by ID"
End If
Call frmComResult.showComTopic '顯示查詢結果
Call frmComResult.showComData(sql)
frmComResult.Show
frmComResult.ZOrder 0
Unload Me
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -